VENDOR_ITM_VW2(SQL View) |
Index Back |
|---|---|
Items by Supplier<* **************************************************************************************************** Date Initials Reference # Description 8/11/2014 JOHAN 18805539 We ensured that sourcing workbench has no error when sourcing a requisition with item substitution. **************************************************************************************************** *> |
| SELECT A.VENDOR_SETID , A.VENDOR_ID , D.VNDR_LOC , A.SETID , A.INV_ITEM_ID , B.DESCR , A.ITM_VNDR_PRIORITY , A.ITM_ID_VNDR , A.ITM_STATUS , A.PCT_ALLOC , D.ACCEPT_ALL_UOM , D.ACCEPT_ALL_SHIPTO , D.QTY_TYPE , D.PRICE_DT_TYPE , D.PRICE_CAN_CHANGE , A.VNDR_CATALOG_ID , D.USE_STD_LEAD_TIME , D.LEAD_TIME , D.STOCKLESS_FLG , A.COMMENTS_LONG FROM PS_ITM_VENDOR A , PS_PURCH_ITEM_ATTR B , PS_MASTER_ITEM_TBL C , PS_ITM_VENDOR_LOC D WHERE A.SETID = B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND B.SETID = C.SETID AND B.INV_ITEM_ID = C.INV_ITEM_ID AND A.SETID = D.SETID AND A.INV_ITEM_ID = D.INV_ITEM_ID AND B.SETID = D.SETID AND B.INV_ITEM_ID = D.INV_ITEM_ID AND C.ITM_STATUS_CURRENT = '1' AND ((%CurrentDateIn >= B.PO_AVAIL_DT) AND (B.PO_UNAVAIL_DT > %CurrentDateIn)) AND A.VENDOR_SETID = D.VENDOR_SETID AND A.VENDOR_ID = D.VENDOR_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PRICE_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Price From Vendor SetID |
| 2 | PRICE_VENDOR |
Character(10) | VARCHAR2(10) NOT NULL | Price Vendor ID |
| 3 | PRICE_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Price from Location |
| 4 | ITM_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 5 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | ITM_VNDR_PRIORITY | Number(3,0) | SMALLINT NOT NULL | Item Vendor Priority |
| 8 | ITM_ID_VNDR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Item ID |
| 9 | ITM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Item Status
A=Active D=Discntued H=Hold I=Inactive X=To be Del Default Value: A |
| 10 | PCT_ALLOC | Number(3,0) | SMALLINT NOT NULL | Allocation Percentage |
| 11 | ACCEPT_ALL_UOM | Character(1) | VARCHAR2(1) NOT NULL |
Accept Any UOM
Y/N Table Edit Default Value: Y |
| 12 | ACCEPT_ALL_SHIPTO | Character(1) | VARCHAR2(1) NOT NULL |
Accept Any Ship To
Y/N Table Edit Default Value: Y |
| 13 | QTY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Quantity to Use for Prices
L=Line Quantity S=Schedule Quantity Default Value: L |
| 14 | PRICE_DT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Date to Use for Prices
D=Due Date P=PO Date Default Value: P |
| 15 | PRICE_CAN_CHANGE | Character(1) | VARCHAR2(1) NOT NULL |
Price Can Be Changed on Order
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 16 | VNDR_CATALOG_ID | Character(20) | VARCHAR2(20) NOT NULL | Vendor's Catalog Number |
| 17 | USE_STD_LEAD_TIME | Character(1) | VARCHAR2(1) NOT NULL | Use Item Standard Lead Time |
| 18 | LEAD_TIME | Number(3,0) | SMALLINT NOT NULL | Lead Time Days |
| 19 | STOCKLESS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Stockless Item
N=No Y=Yes |
| 20 | COMMENTS_LONG | Long Character | CLOB | Comment Text |