Table SNPPIMPL
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SNPPIMPL | SPIM | Project link | Common Data | PJM |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PIM0 | SNPVCR+PIMNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CPY | Company | CPY | [CPY]CPY0=[SPIM]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=[SPIM]FCY | Block | ||||
| FINRSPFCY | Financial site | FCY | [FCY]FCY0=[SPIM]FINRSPFCY | Block | ||||
| OPPNUM | Project | OPP | [OPP]OPP0=[SPIM]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 | |||
| SNPVCR | Snapshot code | VPJ | ||||||
| TASCOD | Task code | TAC | PJM | |||||
| TASSTATE | Status | M | 9 | 2250 | PJM | |||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |