VRBT_RULE_ITEM

(SQL Table)
 Index Back

Supplier Rebate Rule-GrowthIte

Supplier Rebate Agreement Rule -For Growth Bonus, Define Item/Category growth Basis Qty/Amt details for which the VRBT_RULE_DTL.PCT_MIN and PCT_MAX apply.

  • Parent record: VRBT_RULE

    • # 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 VRBT_RULE_ID Number(5,0) INTEGER NOT NULL Vendor Rebate Agreement Rule ID
    4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

    Default Value: 1

    5 VRBT_LINE_TYPE Character(4) VARCHAR2(4) NOT NULL Rebate Line Type: Category or Item
    CAT=Category
    ITEM=Item

    Default Value: ITEM

    6 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    7 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
    8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: ITM_ITMSETID_VW
    Set Control Field: ITM_SETID

    9 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    10 ITEM_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Basis Amount for the Rule Item/Category. Mainly used for Growth Bonus Rule (Growth Bonus Basis Amt for the Rule Item)
    11 ITEM_BASIS_QTY Number(16,4) DECIMAL(15,4) NOT NULL Basis Qty for the Rule Item/Category. Mainly used for Growth Bonus Rule (Growth Bonus Basis Qty for the Rule Item)
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: VRBT_HDR.CURRENCY_CD

    13 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Default Value: VRBT_RULE.UNIT_OF_MEASURE

    Prompt Table: VNDR_ITM_UOM_VW

    14 RBTABLE_AMT_TOT Signed Number(28,3) DECIMAL(26,3) NOT NULL RBTABLE_AMT_TOT: Total Rebatable Amount For the Rule
    15 RBTABLE_QTY_TOT Signed Number(17,4) DECIMAL(15,4) NOT NULL RBTABLE_qty_TOT: Total Rebatable Quantity For the Rule