BI_DISC_SUR

(SQL Table)
 Index Back

Discounts/Surcharges

Discounts/Surcharges

  • Related Language Record: BI_DISC_SUR_LNG

    • # 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 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

    Default Value: OPR_DEF_TBL_BI.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    3 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 DISC_SUR_INDICATOR Character(1) VARCHAR2(1) NOT NULL Discount/Surcharge
    D=Discount
    I=Installment Surcharge
    S=Surcharge

    Default Value: D

    6 RETAINAGE_FLG Character(1) VARCHAR2(1) NOT NULL Used to track discounts that are retainage discounts.
    N=No
    Y=Yes

    Default Value: N

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

    Default Value: A

    8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 CALCULATION_CD Character(3) VARCHAR2(3) NOT NULL Calculation_cd
    AMT=Amount
    PCT=Percentage

    Default Value: AMT

    11 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    12 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
    13 DST_ID Character(10) VARCHAR2(10) NOT NULL Distribution Code

    Prompt Table: %EDITTABLE2

    14 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
    15 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    16 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID