CA_DISC_SUR_VW2

(SQL View)
 Index Back

Percent-only retainages


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 %EffdtCheck(BI_DISC_SUR DS2, DS, %CURRENTDATEIN) AND DS.EFF_STATUS='A' AND DISC_SUR_INDICATOR = 'D' AND DS.RETAINAGE_FLG = 'Y' AND DS.CALCULATION_CD = 'PCT'

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