BUSINESS_UNITPO_IDCURRENCY_CDSETIDVRBT_IDVRBT_PO_AMT_VW(SQL View) |
Index Back |
|---|---|
Supplier Rebate PO Amount ViewSupplier Rebate PO Amount View |
| SELECT H.BUSINESS_UNIT , H.PO_ID , H.CURRENCY_CD , L.CNTRCT_SETID , L.VRBT_ID , SUM(S.MERCHANDISE_AMT) FROM PS_VRBT_EVT_PO V , PS_PO_HDR H , PS_PO_LINE L , PS_PO_LINE_SHIP S WHERE V.BUSINESS_UNIT = H.BUSINESS_UNIT AND V.PO_ID = H.PO_ID AND H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.PO_ID = L.PO_ID AND L.BUSINESS_UNIT = S.BUSINESS_UNIT AND L.PO_ID = S.PO_ID AND L.LINE_NBR = S.LINE_NBR AND V.LINE_NBR = L.LINE_NBR AND V.SETID = L.CNTRCT_SETID AND V.VRBT_ID = L.VRBT_ID AND V.EVENT_STATUS_VRBT = 'A' AND H.PO_STATUS <> 'X' AND H.PO_STATUS <> 'PX' GROUP BY H.BUSINESS_UNIT, H.PO_ID, H.CURRENCY_CD, L.CNTRCT_SETID, L.VRBT_ID |
| # | 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 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 4 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | VRBT_ID |
Character(25) | VARCHAR2(25) NOT NULL | Vendor Rebate ID |
| 6 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |