PROCESS_INSTANCEPREV=Previous Period
RCV=Receipt
RTV=Return To Vendor (Supplier)
VCHR=Voucher
A=Amount
Q=Quantity
A=Amount
P=Percentage
VRBT_ACCR_AET(SQL Table) |
Index Back |
|---|---|
Supplier Rebate Accrual StateState table for rebate accrual programs (PO_VRBTACCR and PO_CMVRACCR). |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | VRBT_ID | Character(25) | VARCHAR2(25) NOT NULL | Vendor Rebate ID |
| 7 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 8 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 9 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 10 | TRANS_DATE | Date(10) | DATE | Transaction Date |
| 11 | VRBT_TRANS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Transaction Type
PREV=Previous Period RCV=Receipt RTV=Return To Vendor (Supplier) VCHR=Voucher |
| 12 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 13 | DOC_ID | Character(50) | VARCHAR2(50) NOT NULL | ID |
| 14 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 15 | RECV_SHIP_SEQ | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 16 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 17 | VRBT_RULE_ID | Number(5,0) | INTEGER NOT NULL | Vendor Rebate Agreement Rule ID |
| 18 | VRBT_RULE_SEQ | Number(5,0) | INTEGER NOT NULL | Vendor Rebate Agreement Rule Details Sequence |
| 19 | REBATE_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Rebate Tiers Basis
A=Amount Q=Quantity |
| 20 | RBTABLE_QTY_TOT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | RBTABLE_qty_TOT: Total Rebatable Quantity For the Rule |
| 21 | RBTABLE_AMT_TOT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | RBTABLE_AMT_TOT: Total Rebatable Amount For the Rule |
| 22 | RBTABLE_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Rebateable Quantity |
| 23 | RBTABLE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Rebateable Amount |
| 24 | QTY_MIN | Number(16,4) | DECIMAL(15,4) NOT NULL | Minimum Quantity |
| 25 | QTY_MAX | Number(16,4) | DECIMAL(15,4) NOT NULL | Maximum Quantity |
| 26 | AMT_MIN | Number(27,3) | DECIMAL(26,3) NOT NULL | Mimimum Amount |
| 27 | AMT_MAX | Number(27,3) | DECIMAL(26,3) NOT NULL | Maximum Amount |
| 28 | PCT_MIN | Signed Number(11,4) | DECIMAL(9,4) NOT NULL | Growth Percentage Minimum |
| 29 | PCT_MAX | Signed Number(11,4) | DECIMAL(9,4) NOT NULL | Growth Percentage Minimum |
| 30 | ADJ_PCT | Signed Number(11,4) | DECIMAL(9,4) NOT NULL | Adjust Percentage |
| 31 | ADJ_AMT | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Adjustment Amount |
| 32 | PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate |
| 33 | RT_RATE_INDEX | Character(10) | VARCHAR2(10) NOT NULL | Market Rate Index |
| 34 | REBATE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Rebate Amount |
| 35 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 36 | GB_PCT | Signed Number(11,4) | DECIMAL(9,4) NOT NULL | GB_PCT: Used in Vendor Rebate Accrual program PO_CMVRACCR for Growth Bonus calculation. |
| 37 | ADJ_METH | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Method
A=Amount P=Percentage |