CA_DISCSURV_LNG

(SQL View)
Index Back

Percent-only discounts RLR


SELECT DS.SETID , DS.BI_CURRENCY_CD , DS.DISC_SUR_ID , DS.EFFDT , LANG.LANGUAGE_CD , DS.DESCRSHORT , DS.DESCR FROM PS_BI_DISC_SUR DS , PS_BI_DISC_SUR_LNG LANG WHERE %Join(COMMON_KEYS, BI_DISC_SUR DS, BI_DISC_SUR_LNG LANG) AND %EffdtCheck(BI_DISC_SUR DS2, DS, %CURRENTDATEIN) AND DS.EFF_STATUS='A' AND DS.DISC_SUR_INDICATOR = 'D' AND DS.CALCULATION_CD = 'PCT' AND DS.RETAINAGE_FLG <> 'Y'

  • Related Language Record for CA_DISC_SUR_VW1
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    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 Effective Date

    Default Value: %date

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description