RBT_PNLTY_STEP

(SQL Table)
Index Back

Rebate Definition - Steps

  • Parent record: RBT_PNLTY_DEFN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 RBT_PNLTY_DEFN Character(6) VARCHAR2(6) NOT NULL Rebate/Penalty Definition
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 BREAK_ID Number(10,0) DECIMAL(10) NOT NULL Price Break ID
    5 RBT_STEP_AMT Number(15,3) DECIMAL(14,3) NOT NULL Reward Amount
    6 RBT_STEP_AMT_HI Number(15,3) DECIMAL(14,3) NOT NULL Amount Basis High
    7 RBT_STEP_AMT_LO Number(15,3) DECIMAL(14,3) NOT NULL Amount Basis Low
    8 RBT_STEP_PCT Number(6,2) DECIMAL(5,2) NOT NULL Reward Percent
    9 RBT_STEP_PCT_HI Number(6,2) DECIMAL(5,2) NOT NULL Percent Basis High
    10 RBT_STEP_PCT_LO Number(6,2) DECIMAL(5,2) NOT NULL Percent Basis Low
    11 RBT_STEP_QTY_HI Signed Number(16,4) DECIMAL(14,4) NOT NULL Quantity Basis High
    12 RBT_STEP_QTY_LO Signed Number(16,4) DECIMAL(14,4) NOT NULL Quantity Basis Low