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 | |||||
| EXPNUM | Export number | L | 8 | |||||
| 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 | ||||
| TASCOD | Task code | TAC | PJM | |||||
| TASSTATE | Status | M | 9 | 2250 | PJM | |||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |