Dictionary >  Module Common Data >  Table Time summary  

Display all Hide all

Table Abbreviation Description Module Activity code
PJMTIMEMP PTE Time summary Common Data PJM

Key Description Duplicates Activity code
PTE0 CLB+OPPNUM+PTEDAT+PTESEQ No  
PTE1 PIMTASCOD Yes  
PTE2 PIMPBUCOD Yes  
PTE3 CLB-PTEDAT+OPPNUM+PTESEQ No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AUUID Single identifier   AUUID          
CHGTYP Rate type   M 15 202      
CLB Employee   AUS     [AUS]CODUSR=[PTE]CLB Block  
CLBCST Employee labor rate   MD2          
CLBPCC Employee cost type   PJCC     [PJCC]PCC0=[PTE]CLBPCC Block  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[PTE]CREUSR Other  
CUR Currency   CUR     [TCU]TCU0=[PTE]CUR Block  
FCY Site   FCY     [FCY]FCY0=[PTE]FCY Block  
OPENUM Operation   OPE          
OPESPLNUM Operation split   C 4        
OPPNUM Project chrono   PIM     [PIM]PIM0=[PTE]OPPNUM Block  
PBUCOD Budget code   PBU          
PIMPBUCOD Budget   PIM     [PIM]PIM0=[PTE]PIMPBUCOD Block  
PIMTASCOD Task   PIM     [PIM]PIM0=[PTE]PIMTASCOD Block  
PJMCST Project labor rate   MD2          
PJMPCC Project cost type   PJCC     [PJCC]PCC0=[PTE]PJMPCC Block  
POANUM Sequence   L 8        
PTEDAT Date   D          
PTEDESAXX Description   AXX          
PTEINV Invoicing flag   M 4 1      
PTEORI Origin   M   2078      
PTEQTY Time spent   QTY          
PTESEQ Sequence   L 8        
PTESTA Status   M   2074      
PTETYP Time category   ADI     [ADI]CODE=640;PTETYP Block  
PTEUOM Time unit   UOM     [TUN]TUN0=[PTE]PTEUOM Block  
PTEVAL Validated   M 4 1      
TASCOD Task number   TAC          
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[PTE]UPDUSR Other