VRBT_ANLY_WB(SQL Table) |
Index Back |
---|---|
Supplier Rebate WorkBenchSupplier 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 |