BUSINESS_UNITPO_IDLINE_NBRSETIDVRBT_IDVRBT_EVT_PO_VW(SQL View) |
Index Back |
|---|---|
Supplier Rebate PO Xref ViewSupplier Rebate PO Event Cross-Ref View |
| SELECT X.BUSINESS_UNIT , X.PO_ID , X.LINE_NBR , X.SETID , X.VRBT_ID , P.ITM_SETID ,P.INV_ITEM_ID , P.CATEGORY_ID FROM PS_VRBT_EVT_PO X , PS_PO_LINE P WHERE X.BUSINESS_UNIT = P.BUSINESS_UNIT AND X.PO_ID = P.PO_ID AND X.LINE_NBR = P.LINE_NBR AND X.SETID = P.CNTRCT_SETID AND X.VRBT_ID = P.VRBT_ID AND X.EVENT_STATUS_VRBT = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | VRBT_ID |
Character(25) | VARCHAR2(25) NOT NULL | Vendor Rebate ID |
| 6 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 7 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 8 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |