PV_CO_SUP_PROD(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_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 | 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 |