BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
OPR_DEF_TBL_FS
Set Control Field: BUSINESS_UNIT
SETIDINV_ITEM_IDPrompt Table: MST_ITM_VW
VENDOR_SETIDVENDOR_IDITM_PRMY_VND_VW(SQL View) |
Index Back |
|---|---|
View of an Item's Prmry Suppli |
| SELECT A.BUSINESS_UNIT , B.SETID , A.INV_ITEM_ID , D.SETID , D.VENDOR_ID , E.NAME1 , A.LAST_PRICE_PAID , A.AVERAGE_COST , F.BASE_CURRENCY FROM PS_BU_ITEMS_INV A , PS_MASTER_ITEM_TBL B , PS_SET_CNTRL_REC C , PS_ITM_VENDOR D , PS_VENDOR E , PS_BUS_UNIT_TBL_IN F WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.REC_GROUP_ID = 'FS_18' AND C.RECNAME = 'MASTER_ITEM_TBL' AND B.SETID = C.SETID AND B.INV_ITEM_ID = A.INV_ITEM_ID AND D.ITM_VNDR_PRIORITY = 1 AND D.SETID = B.SETID AND D.INV_ITEM_ID = B.INV_ITEM_ID AND D.VENDOR_SETID = E.SETID AND D.VENDOR_ID = E.VENDOR_ID AND F.BUSINESS_UNIT = A.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table:
OPR_DEF_TBL_FS
|
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MST_ITM_VW |
| 4 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 5 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 6 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 7 | LAST_PRICE_PAID | Number(15,4) | DECIMAL(14,4) NOT NULL | Last Price Paid |
| 8 | AVERAGE_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | Average Purchase Price |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |