VRBT_BCKT_HDR

(SQL Table)
Index Back

Supplier Rebate Header VW

Supplier 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