SETIDVRBT_IDVRBT_RULE_IDF=Flat Amount
G=Growth Bonus
M=Marketing Contribution
R=Retrospective
S=Stepped/Standard
VRBT_RULE_VW(SQL View) |
Index Back |
|---|---|
Supplier Rebate Rule VWSupplier Rebate Rule VW |
| SELECT R.SETID , R.VRBT_ID , R.VRBT_RULE_ID , R.VRBT_RULE_TYPE , R.DESCR FROM PS_VRBT_RULE R |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |