CA_DISC_SUR_VW3

(SQL View)
 Index Back

Discounts - percent and amount


SELECT DS.SETID , DS.BI_CURRENCY_CD , DS.DISC_SUR_ID , DS.DISC_SUR_INDICATOR , DS.EFFDT , DS.DESCRSHORT , DS.AMOUNT , DS.PERCENTAGE , DS.CALCULATION_CD FROM PS_BI_DISC_SUR DS WHERE %EffdtCheck(BI_DISC_SUR DS2, DS, %CurrentDateIn) AND DS.EFF_STATUS ='A' AND DS.DISC_SUR_INDICATOR IN ('S','D') AND DS.RETAINAGE_FLG <> 'Y'

  • Related Language Record: CA_DISCSRV3_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 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    3 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier
    4 DISC_SUR_INDICATOR Character(1) VARCHAR2(1) NOT NULL Discount/Surcharge
    D=Discount
    I=Installment Surcharge
    S=Surcharge
    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    8 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
    9 CALCULATION_CD Character(3) VARCHAR2(3) NOT NULL Calculation_cd
    AMT=Amount
    PCT=Percentage