Table PJMTIMEMPTMP
| 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 |