BI_DISC_SUR_VW

(SQL View)
 Index Back

Discounts/Surcharges Eff. Vw


SELECT ds.setid , ds.bi_currency_cd , ds.disc_sur_id , ds.effdt , ds.disc_sur_indicator , ds.eff_status , ds.descrshort , ds.descr , ds.calculation_cd , ds.amount , ds.percentage , ds.dst_id FROM PS_BI_DISC_SUR ds WHERE ds.effdt = ( SELECT MAX(effdt) FROM PS_BI_DISC_SUR WHERE setid=ds.setid AND bi_currency_cd = ds.bi_currency_cd AND disc_sur_id =ds.disc_sur_id AND effdt <= %CurrentDateIn) AND ds.eff_status='A'

  • Related Language Record: BI_DISCSURV_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

    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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

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

    Default Value: AMT

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

    Prompt Table: %EDITTABLE2