Table Abbreviation Description Module Activity code
PJMTIMEMPTMP PTET Time summary Common Data PJM

Key Description Duplicates Activity code
PTET0 IDENT1+CLB+PTESEQ No  
PTET1 IDENT1+CPY+CUR+FCY+PCCCOD Yes  
PTET2 IDENT1+CPY+CUR+FCY+PCCCOD+OPPNUM Yes  
PTET3 IDENT1+CPY+CUR+FCY+PCCCOD+PTEDAT Yes  
PTET4 IDENT1+CPY+CUR+FCY+PCCCOD+OPPNUM+SEP+PTEDAT Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACC General accounts   GAC     [GAC]GAC0=COA;ACC Other LED
ACCDAT Accounting date   D          
AUUID Single identifier   AUUID          
CCE Analytical dimension   CCE     [CCE]CCE0=DIE(indice);CCE(indice) Other ANA
CHGTYP Rate type   M 15 202      
CLB Employee   AUS     [AUS]CODUSR=[PTET]CLB Other  
CLBAMT Amount   MD2          
COA Chart of accounts   COA     [COA]COA0=[PTET]COA Other LED
CPY Company   CPY     [CPY]CPY0=[PTET]CPY Other  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[PTET]CREUSR Other  
CUR Currency   CUR     [TCU]TCU0=[PTET]CUR Other  
CURLED Ledger currency   CUR     [TCU]TCU0=[PTET]CURLED Other LED
DIE Dimension type code   DIE     [DIE]DIE0=[PTET]DIE Other ANA
FCY Financial site   FCY     [FCY]FCY0=[PTET]FCY Other  
GTE Entry type   GTE     [GTE]GTE0=GTE;[V]GSUPCLE Other  
GTE_LEG Legislation   ADI     [ADI]CODE=909;GTE_LEG Other  
IDENT1 Identifier 1   ID1          
JOU Journal   JOU     [JOU]JOU0=JOU(indice);[V]GSUPCLE Other  
JOUNUM Entry number   VCR          
JOU_LEG Legislation   ADI     [ADI]CODE=909;JOU_LEG Other  
LABRAT Labor rate   MD2          
LEDTYP Ledger type   M   2644     LED
OPENUM Operation   OPE          
OPESPLNUM Operation split   C 4        
OPPNUM Project   OPP     [OPP]OPP0=[PTET]OPPNUM Other  
PBUCOD Budget code   PBU          
PCCCOD Cost type   PJCC     [PJCC]PCC0=[PTET]PCCCOD Delete  
PIMPBUCOD Budget   PIM     [PIM]PIM0=[PTET]PIMPBUCOD Other  
PIMTASCOD Task   PIM     [PIM]PIM0=[PTET]PIMTASCOD Other  
PTEDAT Date   D          
PTEQTY Time spent   QTY          
PTESEQ Sequence   L 8        
PTESTA Status   M   2074      
PTETYP Time category   PJTC     [PJTC]PJTC0=[PTET]PTETYP Other  
PTETYPRAT Rate multiplier   RAT          
PTEUOM Time unit   UOM     [TUN]TUN0=[PTET]PTEUOM Other  
RATDIV Dividing rate   RCU         LED
RATMLT Multiplying rate   RCU         LED
SEP Separator   A 30        
TASCOD Task code   TAC          
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[PTET]UPDUSR Other