Table PJMTIMEMP
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PJMTIMEMP | PTE | Time summary | Common Data | PJM |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PTE0 | CLB+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 |
|---|---|---|---|---|---|---|---|---|
| ACC | General accounts | GAC | [GAC]GAC0=COA;ACC | Block | LED | |||
| ACCDAT | Accounting date | D | ||||||
| APPRUSR | Approved by | AUS | [AUS]CODUSR=[PTE]APPRUSR | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| BILFRO | Billable from | D | ||||||
| BILLABLE | Billable | M | 4 | 1 | ||||
| BILQTY | Billed quantity | QTY | ||||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| 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 | ||||
| COA | Chart code | COA | [COA]COA0=[PTE]COA | Block | LED | |||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Created by | AUS | [AUS]CODUSR=[PTE]CREUSR | Other | ||||
| CTRLUSR | Controlled by | AUS | [AUS]CODUSR=[PTE]CTRLUSR | Block | ||||
| CUR | Currency | CUR | [TCU]TCU0=[PTE]CUR | Block | ||||
| CURLED | Ledger currency | CUR | [TCU]TCU0=[PTE]CURLED | Block | LED | |||
| DIE | Dimension type code | DIE | [DIE]DIE0=[PTE]DIE | Block | ANA | |||
| FCY | Financial site | FCY | [FCY]FCY0=[PTE]FCY | Block | ||||
| GTE | Entry type | GTE | [GTE]GTE0=GTE(indice);[V]GSUPCLE | Block | ||||
| JOU | Journal type | JOU | [JOU]JOU0=JOU(indice);[V]GSUPCLE | Block | ||||
| JOUNUM | Entry number | VCR | ||||||
| LEDTYP | Ledger type | M | 2644 | LED | ||||
| 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 | |||||
| POSTUSR | Posted by | AUS | [AUS]CODUSR=[PTE]POSTUSR | Block | ||||
| PRGBILLIN | Project status no. | L | 8 | SALM | ||||
| PRGBILNUM | Billing plan number | PBIL | [PBILH]PBILH0=[PTE]PRGBILNUM | Other | SALM | |||
| PTEDAT | Date | D | ||||||
| PTEDESAXX | Description | AXX | ||||||
| PTEORI | Origin | M | 2078 | |||||
| PTEQTY | Time spent | QTY | ||||||
| PTESEQ | Time entry line number | L | 8 | |||||
| PTESTA | Status | M | 2074 | |||||
| PTETYP | Time category | PJTC | [PJTC]PJTC0=[PTE]PTETYP | Block | ||||
| PTETYPRAT | Rate multiplier | RAT | ||||||
| PTEUOM | Time unit | UOM | [TUN]TUN0=[PTE]PTEUOM | Block | ||||
| PTEVAL | Validated | M | 4 | 1 | ||||
| RATDIV | Dividing rate | RCU | LED | |||||
| RATMLT | Multiplying rate | RCU | LED | |||||
| REJUSR | Rejected by | AUS | [AUS]CODUSR=[PTE]REJUSR | Block | ||||
| RPTCOD | Report code | TIMRPT | [PTER]PTER0=[PTE]RPTCOD | Block | ||||
| TASCOD | Task number | TAC | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Updated by | AUS | [AUS]CODUSR=[PTE]UPDUSR | Other | ||||
| VALUSR | Validated by | AUS | [AUS]CODUSR=[PTE]VALUSR | Block |