RBT_PNLTY_DEFN

(SQL Table)
Index Back

Rebate Definitions

  • Parent Record Of RBT_PNLTY_STEP
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 RBT_PNLTY_DEFN Character(6) VARCHAR2(6) NOT NULL Rebate/Penalty Definition
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

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

    Prompt Table: CURRENCY_CD_TBL

    6 MAX_AMOUNT Number(16,4) DECIMAL(15,4) NOT NULL Maximum Amount
    7 RBT_AMT_NO_QTY_TYP Character(1) VARCHAR2(1) NOT NULL Amount Type
    F=Flat Amount
    8 RBT_AMT_QTY_TYPE Character(1) VARCHAR2(1) NOT NULL Amount Type
    F=Flat Amount
    L=(List - Net) Price
    N=Net Price
    U=Flat Amount per Unit
    9 RBT_BASIS_TYPE Character(1) VARCHAR2(1) NOT NULL Basis Type
    A=Amount
    N=None
    P=Percent
    Q=Quantity

    Default Value: N

    10 RBT_PCT_NO_QTY_TYP Character(1) VARCHAR2(1) NOT NULL Percent Type
    A=% of Amount
    11 RBT_PCT_QTY_TYPE Character(1) VARCHAR2(1) NOT NULL Percent Type
    A=% of Amount
    L=% of (List - Net) Price
    N=% of Net Price
    12 RBT_PNLTY_TYPE Character(1) VARCHAR2(1) NOT NULL Reward Type
    A=Amount
    P=Percent

    Default Value: A