Table Abbreviation Description Module Activity code
SNPOPEAFF SPJOA Employee assignment Common Data PJM

Key Description Duplicates Activity code
PJOA0 SNPVCR+OPPNUM+TASCOD+OPENUM+OPESPLNUM+POANUM 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        
CUR Currency   CUR     [TCU]TCU0=[SPJOA]CUR Block  
KEYCONCAT Concatenation   A 40        
OPENUM Operation   OPE          
OPESPLNUM Operation split   C 4        
OPPNUM Project number   PIM     [PIM]PIM0=[SPJOA]OPPNUM Block  
POACLB Employee   AUS     [AUS]CODUSR=[SPJOA]POACLB Block  
POACSMQTY Consumed load   QTY          
POACST Hourly rate   MD2          
POACSTLAB Labor rate   MD2          
POADES Description   AXX          
POAEND End date   D          
POAENDHM End time   HM          
POANUM Sequence   ISEQ          
POARMNQTY Remaining load   QTY          
POASTDQTY Planned load   QTY          
POASTR Start date   D          
POASTRHM Start time   HM          
POUOM Unit   UOM     [TUN]TUN0=[SPJOA]POUOM Block  
PTETYP Time category   PJTC     [PJTC]PJTC0=[SPJOA]PTETYP Block  
SNPVCR Snapshot code   VPJ          
TASCOD Task code   TAC          
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5