PROCESS_INSTANCEPV_CP_ITM_KEYPV_CP_ATTACH_KEYPV_MS_SUP_MPIDPV_CP_ATTCH_TMP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PV_CP_ITM_KEY |
Number(10,0) | DECIMAL(10) NOT NULL | MarketSite to Peoplesoft Item |
| 3 | PV_CP_ATTACH_KEY |
Number(10,0) | DECIMAL(10) NOT NULL | MarketSite Item Attachment Key |
| 4 | PV_MS_SUP_MPID |
Character(50) | VARCHAR2(50) NOT NULL | e |
| 5 | PV_CP_PURPOSE | Character(50) | VARCHAR2(50) NOT NULL | Image Purpose |
| 6 | PV_CP_LOCATION | Character(254) | VARCHAR2(254) NOT NULL | Image Location |
| 7 | PV_CP_SPN | Character(50) | VARCHAR2(50) NOT NULL | Supplier Part Number |
| 8 | PV_CP_PART_EXT | Character(50) | VARCHAR2(50) NOT NULL | CUP Part Extension |
| 9 | PV_CP_UOM | Character(12) | VARCHAR2(12) NOT NULL | CUP Unit of Measure |
| 10 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 11 | FILE_EXTENSION | Character(4) | VARCHAR2(4) NOT NULL | File Extension |