Table PIMPL
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
PIMPL | PIM | Project link | Common Data |
Key | Description | Duplicates | Activity code |
---|---|---|---|
PIM0 | PIMNUM | No | |
PIM1 | OPPNUM+TASCOD | Yes | PJM |
PIM2 | OPPNUM+PBUCOD | Yes | PJM |
PIM4 | OPPNUM | Yes |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
AUUID | Single identifier | AUUID | ||||||
CPY | Company | CPY | [CPY]CPY0=[PIM]CPY | Block | ||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | A | 5 | |||||
FCY | Site | FCY | [FCY]FCY0=[PIM]FCY | Block | ||||
FINRSPFCY | Financial site | FCY | [FCY]FCY0=[PIM]FINRSPFCY | Block | ||||
OPPNUM | Project | OPP | [OPP]OPP0=[PIM]OPPNUM | Other | ||||
OPPSTATE | Status | M | 9 | 2249 | PJM | |||
PBUCOD | Budget code | PBU | PJM | |||||
PBUSTATE | Status | M | 8 | 2251 | PJM | |||
PIMDESAX1 | Short description | AX3 | ||||||
PIMDESAXX | Description | AXX | ||||||
PIMNUM | Project link | VPJ | ||||||
PIMSTA | Active | M | 4 | 1 | ||||
PIMTYP | Type | M | 20 | 2254 | ||||
PROBIL | Billing mode | M | 15 | 7769 | PJM | |||
TASCOD | Task code | TAC | PJM | |||||
TASSTATE | Status | M | 9 | 2250 | PJM | |||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Change user | A | 5 |