Table Abbreviation Description Module Activity code
SNPTSK SPJTA Project task Common Data PJM

Key Description Duplicates Activity code
PTA0 SNPVCR+OPPNUM+TASCOD No  
PTA2 SNPVCR+OPPNUM+TASSOR+TASCOD No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AUUID Single identifier   AUUID          
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
DUEDAT Due date   D          
KEYCONCAT Concatenation   A 40        
OPPNUM Project number   PIM     [PIM]PIM0=[SPJTA]OPPNUM Delete  
ORITAS Source task   PIM     [PIM]PIM0=[SPJTA]ORITAS RTZ  
PBUCOD Budget code   PBU          
PRCCPL Estimated (%) comple   RAT          
PRCCPLADI Progress range   ADI     [ADI]CODE=387;PRCCPLADI Block  
PRCCPLDAT Estimation date   D          
PRCCPLMET Estimation method   M 15 7737      
PROBIL Billing mode   M 15 7769      
PTETYP Time category   PJTC     [PJTC]PJTC0=[SPJTA]PTETYP Block  
RPBAUS Person responsible   AUS     [AUS]CODUSR=[SPJTA]RPBAUS Block  
SNPVCR Snapshot code   VPJ          
TASCOD Task code   TAC          
TASDATB Actual start date   D          
TASDATH Suspension date   D          
TASDATL Launch date   D          
TASDATP Planning date   D          
TASDATS Closing date   D          
TASDUR Duration   C 4        
TASENDDT End date   D          
TASFCY Site   FCY     [FCY]FCY0=[SPJTA]TASFCY Block  
TASNUM Sequence no.   VCR          
TASPAE Parent code   TAC          
TASSOR Sort key   L 8        
TASSTARTDT Start date   D          
TASSTATE Status   M 9 2250      
TASTLA To launch   M 4 1      
TASTYP Task type   M 16 2258      
TCACOD Category   CTA     [PTC]CTA0=[SPJTA]TCACOD Block  
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5