BUSINESS_UNITINV_ITEM_IDVENDOR_IDAPS_SUPPITEM_VW(SQL View) |
Index Back |
|---|---|
APS Integ Supplier Item View |
| SELECT ITM.BUSINESS_UNIT , IV.INV_ITEM_ID , PA.SETID , IV.VENDOR_SETID , IV.VENDOR_ID , IV.VNDR_LOC , IV.USE_STD_LEAD_TIME , IV.LEAD_TIME , PA.STD_LEAD , PA.PRICE_LIST , ITM.PUR_ORDER_MULTIPLE FROM PS_ITM_VENDOR_LOC IV , PS_PURCH_ITEM_ATTR PA , PS_APS_ITEM_BU_VW ITM , PS_VENDOR V WHERE IV.SETID = PA.SETID AND IV.INV_ITEM_ID = PA.INV_ITEM_ID AND IV.SETID = ITM.ITM_SETID AND IV.INV_ITEM_ID = ITM.INV_ITEM_ID AND V.VENDOR_ID = IV.VENDOR_ID AND V.SETID = IV.VENDOR_SETID AND V.VENDOR_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 5 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 6 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 7 | USE_STD_LEAD_TIME | Character(1) | VARCHAR2(1) NOT NULL | Use Item Standard Lead Time |
| 8 | LEAD_TIME | Number(3,0) | SMALLINT NOT NULL | Lead Time Days |
| 9 | STD_LEAD | Number(3,0) | SMALLINT NOT NULL | Purchase Lead Time Days |
| 10 | PRICE_LIST | Number(16,5) | DECIMAL(15,5) NOT NULL | Standard Price |
| 11 | PUR_ORDER_MULTIPLE | Number(12,4) | DECIMAL(11,4) NOT NULL | jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4 |