ITM_SETIDINV_ITEM_IDVENDOR_SETIDVENDOR_IDITM_ID_VNDRWM_ITMVND_AC_VW(SQL View) |
Index Back |
|---|---|
Supplier Item ID (Active) View |
| SELECT A.SETID AS ITM_SETID , A.INV_ITEM_ID , A.VENDOR_SETID , A.VENDOR_ID , A.ITM_ID_VNDR , B.DESCR , A.VNDR_CATALOG_ID FROM PS_ITM_VENDOR A , PS_MASTER_ITEM_TBL B WHERE A.ITM_ID_VNDR <> ' ' AND A.ITM_STATUS = 'A' AND B.SETID = A.SETID AND B.INV_ITEM_ID = A.INV_ITEM_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ITM_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 4 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | ITM_ID_VNDR |
Character(50) | VARCHAR2(50) NOT NULL | Vendor Item ID |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | VNDR_CATALOG_ID | Character(20) | VARCHAR2(20) NOT NULL | Vendor's Catalog Number |