SETIDVRBT_IDVRBT_ANLYSCR_VW(SQL View) |
Index Back |
|---|---|
Supplier Rebate Analysis SummaSupplier Rebate Analysis Summary WorkScroll |
| SELECT H.SETID , H.VRBT_ID , H.VENDOR_SETID , H.VENDOR_ID , H.VRBT_BEGIN_DT , H.VRBT_EXPIRE_DT , H.TOTAL_REBATE_AMT , H.TOTAL_REBATE_AMT-H.TOTAL_REBATE_RECVD , H.TOTAL_REBATE_RECVD , L.TOT_ALLOC_AMT , SUM(A.REBATE_AMOUNT) , C.TOT_CLAIM_COLLECT , C.TOT_VAT_COLLECT , C.TOT_CLAIM_ADJ_AMT , H.CURRENCY_CD FROM PS_VRBT_ANLYHDR_VW H , PS_VRA_ACCRSUM_SCR A , PS_VRA_CLAIMSUM_VW C , PS_VRBT_ALOCHDR_VW L WHERE H.SETID = A.SETID(+) AND H.VRBT_ID = A.VRBT_ID(+) AND H.SETID = C.SETID(+) AND H.VRBT_ID = C.VRBT_ID(+) AND H.SETID = L.SETID(+) AND H.VRBT_ID = L.VRBT_ID(+) GROUP BY H.SETID , H.VRBT_ID , H.VENDOR_SETID , H.VENDOR_ID , H.VRBT_BEGIN_DT , H.VRBT_EXPIRE_DT , H.TOTAL_REBATE_AMT , H.TOTAL_REBATE_RECVD , L.TOT_ALLOC_AMT , C.TOT_CLAIM_COLLECT , C.TOT_VAT_COLLECT , C.TOT_CLAIM_ADJ_AMT , H.CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | VRBT_ID |
Character(25) | VARCHAR2(25) NOT NULL | Vendor Rebate ID |
| 3 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 4 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | VRBT_BEGIN_DT | Date(10) | DATE | Vendor Rebate Agreement Begin Date |
| 6 | VRBT_EXPIRE_DT | Date(10) | DATE | Vendor Rebate Agreement Expire Date |
| 7 | TOTAL_REBATE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Accrued Rebate |
| 8 | TOTAL_REBATE_PEND | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Pending Rebate Amount |
| 9 | TOTAL_REBATE_RECVD | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Rebate Payment Received |
| 10 | TOTAL_REBATE_ALLOC | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Allocated Rebate Amount |
| 11 | TOT_REB_AMT_TRANS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Rebate Amt on Sel Trans |
| 12 | TOT_CLAIM_COLLECT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Claim Collected |
| 13 | TOT_VAT_COLLECT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Claim Collected |
| 14 | TOT_CLAIM_ADJ_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Claim Adjustment Amount |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |