SETIDVRBT_IDVRBT_RULE_IDF=Flat Amount
G=Growth Bonus
M=Marketing Contribution
R=Retrospective
S=Stepped/Standard
VRBT_TMPRD_SCR(SQL Table) |
Index Back |
|---|---|
Supplier Rebate Time Anly ScrSupplier Rebate Time Analysis scroll |
| # | 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 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | VR_AMT00 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 00 |
| 7 | VR_AMT01 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 01 |
| 8 | VR_AMT02 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 02 |
| 9 | VR_AMT03 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 03 |
| 10 | VR_AMT04 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 04 |
| 11 | VR_AMT05 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 05 |
| 12 | VR_AMT06 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 06 |
| 13 | VR_AMT07 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 07 |
| 14 | VR_AMT08 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 08 |
| 15 | VR_AMT09 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 09 |
| 16 | VR_AMT10 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 10 |
| 17 | VR_AMT11 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 11 |
| 18 | VR_AMT12 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 12 |
| 19 | VR_AMT13 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 13 |
| 20 | VR_AMT14 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 14 |
| 21 | VR_AMT15 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 15 |
| 22 | VR_AMT16 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 16 |
| 23 | VR_AMT17 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 17 |
| 24 | VR_AMT18 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 18 |
| 25 | VR_AMT19 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 19 |
| 26 | VR_AMT20 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 20 |
| 27 | VR_AMT21 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 21 |
| 28 | VR_AMT22 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 22 |
| 29 | VR_AMT23 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 23 |
| 30 | VR_AMT24 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 24 |
| 31 | VR_AMT99 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VRBT 99 |