PROCESS_INSTANCEPV_MS_SUP_MPIDPV_CP_SPNPV_CP_PART_EXTPV_CP_UOMPV_CP_LOAD_TMP(SQL Table) |
Index Back |
|---|---|
Temp table for PV_CP_LOAD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PV_MS_SUP_MPID |
Character(50) | VARCHAR2(50) NOT NULL | e |
| 3 | PV_CP_SPN |
Character(50) | VARCHAR2(50) NOT NULL | Supplier Part Number |
| 4 | PV_CP_PART_EXT |
Character(50) | VARCHAR2(50) NOT NULL | CUP Part Extension |
| 5 | PV_CP_UOM |
Character(12) | VARCHAR2(12) NOT NULL | CUP Unit of Measure |
| 6 | PV_CP_LIST_PRICE | Number(16,5) | DECIMAL(15,5) NOT NULL | CUP List Price |
| 7 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 8 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 9 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 10 | PV_CP_QTY_MIN | Number(16,4) | DECIMAL(15,4) NOT NULL | Minimum Quantity |
| 11 | PV_CP_EFFDT | Date(10) | DATE | Effective Date |
| 12 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |