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 |