VRBT_ANLY_WB

(SQL Table)
Index Back

Supplier Rebate WorkBench

Supplier Rebate WorkBench

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: OPR_DEF_TBL_FS

2 WORKBENCH_ID Character(10) VARCHAR2(10) NOT NULL WorkBench ID

Prompt Table: VRBT_ANLYWB_VW

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Default Value: VENDOR.SETID

Prompt Table: VENDOR_PO_VW

5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PO_VW

6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VNDR_LOC_VW1

7 VRBT_BEGIN_DT Date(10) DATE Vendor Rebate Agreement Begin Date
8 VRBT_EXPIRE_DT Date(10) DATE Vendor Rebate Agreement Expire Date
9 VRBT_ID Character(25) VARCHAR2(25) NOT NULL Vendor Rebate ID

Prompt Table: VRBT_APPR_SRCH

10 VRBT_RULE_ID Number(5,0) INTEGER NOT NULL Vendor Rebate Agreement Rule ID

Prompt Table: VRBT_RULE_VW

11 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
12 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID

Prompt Table: SP_SETID_NONVW

13 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: ITM_PURCH_VW

14 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
15 CLAIM_ID Character(15) VARCHAR2(15) NOT NULL Claim ID

Prompt Table: VRBT_CLAIM_SRCH

16 CLAIM_STATUS Character(1) VARCHAR2(1) NOT NULL Claim Status
1=Open
3=Approved
5=Deferred
6=Cancelled
7=Pending Payment
8=Partially Paid
9=Paid
17 DISPLAY_OPTION Character(1) VARCHAR2(1) NOT NULL Display Option
M=Monthly
Q=Quarterly
Y=Yearly

Default Value: M

18 REBATE_MGR Character(30) VARCHAR2(30) NOT NULL Rebate Manager

Prompt Table: PO_OPRDEFN_VW