Table Abbreviation Description Module Activity code
PLANDET PLADET Plan detail Common Data NCS

Key Description Duplicates Activity code
PLADET_0 PLANID+LINENO No  
PLADET_1 PLANID+SORTSEQ Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACTIONER Actioner   AUS     [AUS]CODUSR=[PLADET]ACTIONER Block  
ACTIONID Action code   PLANACT          
ACTTYP Action type   ADI     [ADI]CODE=805;ACTTYP Block  
AUUID Single identifier   AUUID          
COMMENT Comment   A 50        
COMPLETEDATE Complete by   D          
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[PLADET]CREUSR Other  
ENDDATE End date   D          
LINENO Line no.   C 4        
LINESTATUS Status   M 15 2040      
LINTEX Text   TXC          
MFGNUM Order no.   VCR          
PLANID Plan   PLANID     [PLAHDR]PLAHDR_0=[PLADET]PLANID Block  
SORTSEQ Sort sequence   C 4        
STARTDATE Start date   D          
TRANTYPE Transaction type   ADI     [ADI]CODE=807;TRANTYPE Block  
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[PLADET]UPDUSR Other