OPRIDRUN_CNTL_IDSETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
REQUEST_NBRPrompt Table: VRBT_HDR
F=Flat Amount
G=Growth Bonus
M=Marketing Contribution
R=Retrospective
S=Stepped/Standard
VRBT_RPT_PARM2(SQL Table) |
Index Back |
|---|---|
Rebates Accrual Parm TableRebates Parm Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 4 | REQUEST_NBR |
Number(4,0) | SMALLINT NOT NULL | Request Number |
| 5 | VRBT_ID | Character(25) | VARCHAR2(25) NOT NULL |
Vendor Rebate ID
Prompt Table: VRBT_HDR |
| 6 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 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 |