VRBT_RULE

(SQL Table)
 Index Back

Supplier Rebate Rule Defn

  • Parent record: VRBT_HDR

    • # 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

    Default Value: 1

    4 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
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 REBATE_UNIT Character(1) VARCHAR2(1) NOT NULL Rebate Tiers Basis
    A=Amount
    Q=Quantity
    7 PREV_PRD_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Previous Period Basis Amount for Market Contribution
    8 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: VRBT_HDR.CURRENCY_CD

    10 ADJ_METH Character(1) VARCHAR2(1) NOT NULL Rebate Calculated As
    A=Amount
    P=Percentage
    11 VRBT_SCALE Character(1) VARCHAR2(1) NOT NULL Vendor Rebate Threshold Scale for Rebate Rules Tiers
    F=From (Minimum)
    T=To (Maximum)

    Default Value: F

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