PV_TPO_ITEM(SQL Table) |
Index Back |
|---|---|
Transparent Punchout Itm Resp10/28/2010 VR 855123 Transparent Punchout |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PV_SUPP_PARTNUM | Character(50) | VARCHAR2(50) NOT NULL | Supplier Part Number |
| 2 | PV_SUPP_ID_CODE | Character(50) | VARCHAR2(50) NOT NULL | Supplier Identification Code |
| 3 | PV_SUPP_NAME | Character(50) | VARCHAR2(50) NOT NULL | Supplier Name |
| 4 | DESCR150_MIXED | Character(150) | VARCHAR2(150) NOT NULL | Description |
| 5 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | UNIT_PRICE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Unit Price |
| 8 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 9 | PV_MANUF_PART_NUM | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer Part Number |
| 10 | PV_MANUF_NAME | Character(60) | VARCHAR2(60) NOT NULL | Manufacturer Name |
| 11 | PV_IMG_ITM_URL1 | Character(254) | VARCHAR2(254) NOT NULL | Item Image URL |
| 12 | PV_IMG_ITM_URL2 | Character(254) | VARCHAR2(254) NOT NULL | Item Image URL |
| 13 | CATEGORY_CODE | Character(18) | VARCHAR2(18) NOT NULL | 01/29/01 rml CN#WV802-1.0 Created to use as search field in supplier's workbench |
| 14 | CATEGORY_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Category Description |
| 15 | CATEGORY_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Category Type
PSF=User Def UNS=UN/SPSC |
| 16 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
| 17 | PV_UNSPSC_CODE | Character(18) | VARCHAR2(18) NOT NULL | UNSPSC Code |
| 18 | PV_QTY_REQ | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity on Requisition |
| 19 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 20 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 21 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 22 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 23 | CATEGORY_SETID | Character(5) | VARCHAR2(5) NOT NULL | Category SetID |
| 24 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 25 | PV_PREF_VNDR | Character(1) | VARCHAR2(1) NOT NULL |
Preferred Supplier
N=Not Preferred Y=Preferred |
| 26 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer ID |
| 27 | PV_SUPP_ATTR | Long Character(1000) | VARCHAR2(1000) | Marketplace supplier attribute |