SRBT_TBL

(SQL Table)
 Index Back

Sales Rebate Table

Sales Rebate Definition Table.

  • Related Language Record: SRBT_TBL_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT

    Prompt Table: SP_BU_OM_NONVW

    2 SRBT_ID Character(6) VARCHAR2(6) NOT NULL Sales Rebate ID

    Default Value: NEXT

    Prompt Table: SRBT_TBL

    3 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

    Prompt Table: CAL_DEFN_TBL

    4 COMPARE_TO_CRIT Character(1) VARCHAR2(1) NOT NULL Compare To Criteria
    F=Fixed Amount/Quantity
    P=Previous Period
    S=Same Period Last Year

    Default Value: P

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: SRBT_TBL.DESCR

    7 SRBT_STATUS Character(1) VARCHAR2(1) NOT NULL Sales Rebate Status
    A=Active
    C=Closed
    H=Hold
    X=Cancelled

    Default Value: A

    8 START_DATE Date(10) DATE Start Date for Gen Standing PO
    9 END_DATE Date(10) DATE End Date
    10 PRC_BREAK_DATE Character(1) VARCHAR2(1) NOT NULL Price Break Date Type
    A=Requested Arrival Date
    O=Order Date
    S=Schedule Ship Date

    Default Value: O

    11 REBATE_ID Character(6) VARCHAR2(6) NOT NULL Rebate ID

    Prompt Table: RBT_PNLTY_SRBTV

    12 PENALTY_ID Character(6) VARCHAR2(6) NOT NULL Penalty ID

    Prompt Table: RBT_PNLTY_SRBTV

    13 SRBT_AMOUNT Number(16,2) DECIMAL(15,2) NOT NULL Compare Amount
    14 SRBT_QTY Number(16,4) DECIMAL(15,4) NOT NULL Compare Quantity
    15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL