VRBT_BCKT_HDR(SQL Table) |
Index Back |
---|---|
Supplier Rebate Header VWSupplier Rebate Header View |
# | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | VRBT_RULE_ID | Number(5,0) | INTEGER NOT NULL | Vendor Rebate Agreement Rule ID |
7 | 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 |
8 | VRBT_RULE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Vendor Rebate Rule Descr |
9 | REBATE_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Rebate Tiers Basis
A=Amount Q=Quantity |
10 | VRBT_BEGIN_DT | Date(10) | DATE | Vendor Rebate Agreement Begin Date |
11 | VRBT_EXPIRE_DT | Date(10) | DATE | Vendor Rebate Agreement Expire Date |
12 | UNIT_MEASURE_VRBT | Character(3) | VARCHAR2(3) NOT NULL | Vendor Rebate UOM |
13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
14 | TOTAL_REBATE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Accrued Rebate |
15 | TOT_PURCH_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Purchased Amount |