PV_CO_SUP_PROD(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | Character(50) | VARCHAR2(50) NOT NULL | e | |
| 3 | Character(50) | VARCHAR2(50) NOT NULL | Supplier Part Number | |
| 4 | Character(50) | VARCHAR2(50) NOT NULL | CUP Part Extension | |
| 5 | Character(12) | VARCHAR2(12) NOT NULL | CUP Unit of Measure | |
| 6 | DESCR150_MIXED | Character(150) | VARCHAR2(150) NOT NULL | Description |
| 7 | PV_CP_SHORT_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Short Description |
| 8 | PV_CP_LIST_PRICE | Number(16,5) | DECIMAL(15,5) NOT NULL | CUP List Price |
| 9 | PV_CP_LEAD_TIME | Number(11,0) | DECIMAL(11) NOT NULL | CUP Lead Time |
| 10 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 11 | CATEGORY_CD | Character(18) | VARCHAR2(18) NOT NULL | Category Code |
| 12 | MFG_ITM_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer's Item ID |
| 13 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer ID |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 15 | PV_CP_EFFDT | Date(10) | DATE | Effective Date |
| 16 | PV_CP_QTY_MIN | Number(16,4) | DECIMAL(15,4) NOT NULL | Minimum Quantity |
| 17 | PV_CP_FILE_NAME | Character(100) | VARCHAR2(100) NOT NULL | CUP File Name |
| 18 | PV_CO_PS_ACTION | Character(32) | VARCHAR2(32) NOT NULL | Cohera PS Action |
| 19 | PV_CO_ACTION_TIME | DateTime(26) | TIMESTAMP | Cohera PS Action Time |
| 20 | FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 21 | FILE_EXTENSION | Character(4) | VARCHAR2(4) NOT NULL | File Extension |
| 22 | FILEPATH | Character(30) | VARCHAR2(30) NOT NULL | File Information |
| 23 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 24 | VNDR_CATALOG_ID | Character(20) | VARCHAR2(20) NOT NULL | Vendor's Catalog Number |
| 25 | PV_CP_SEQ_ID | Number(10,0) | DECIMAL(10) NOT NULL | CUP Sequence ID |