SETIDVRBT_IDVRBT_RULE_IDF=Flat Amount
G=Growth Bonus
M=Marketing Contribution
R=Retrospective
S=Stepped/Standard
A=Amount
Q=Quantity
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
VRBT_TRSHLD_VW(SQL View) |
Index Back |
|---|---|
Supplier Rebate Analysis Summa |
| SELECT DISTINCT A.SETID , A.VRBT_ID , A.VRBT_RULE_ID , A.VRBT_RULE_TYPE , B.DESCR AS RULE_DESCR , C.DESCR , A.VENDOR_SETID , A.VENDOR_ID , ' ' , A.REBATE_UNIT , B.UNIT_OF_MEASURE , A.CURRENCY_CD , SUM(A.RBTABLE_AMT) AS REBATEABLE_AMT , SUM(A.RBTABLE_QTY) AS REBATEABLE_QTY , SUM(A.REBATE_AMOUNT) AS TOTAL_REBATE_AMT , SUM(A.MERCHANDISE_AMT) AS TOT_PURCH_AMT , SUM(A.ACCEPTED_QTY_VRBT) FROM PS_VRBT_ACCRSUM_VW A , PS_VRBT_RULE B , PS_VRBT_HDR C WHERE A.SETID = B.SETID AND A.VRBT_ID = B.VRBT_ID AND A.VRBT_RULE_ID = B.VRBT_RULE_ID AND A.SETID = C.SETID AND A.VRBT_ID = C.VRBT_ID GROUP BY A.SETID, A.VRBT_ID, A.VRBT_RULE_ID, A.VRBT_RULE_TYPE, B.DESCR, C.DESCR, A.VENDOR_SETID, A.VENDOR_ID, A.REBATE_UNIT, A.UNIT_MEASURE_VRBT, B.UNIT_OF_MEASURE, A.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 | VRBT_RULE_ID |
Number(5,0) | INTEGER NOT NULL | Vendor Rebate Agreement Rule ID |
| 4 | VRBT_RULE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Vendor Rebate Agreement Rule Type: There are 5 types of Rebate Rules 1) Stepped/Standard, 2) Market Contribution, 3) Growth Bonus., 4) Flat Rebate,5) Retrospective
F=Flat Amount G=Growth Bonus M=Marketing Contribution R=Retrospective S=Stepped/Standard |
| 5 | VRBT_RULE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Vendor Rebate Rule Descr |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 8 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 9 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 10 | REBATE_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Rebate Tiers Basis
A=Amount Q=Quantity |
| 11 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 13 | CURR_REBATE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Current Rebateable Amount |
| 14 | CURR_REBATE_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Maximum Quantity |
| 15 | TOTAL_REBATE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Accrued Rebate |
| 16 | TOT_PURCH_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Purchased Amount |
| 17 | ACCEPTED_QTY_VRBT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Accepted Quantity - Rebate UOM |