SSRCURRENCYVWLN

(SQL View)
 Index Back

Rel Lang View for Currency

Rel Lang View for Currency Codes & Descriptions

SELECT A.CURRENCY_CD , A.EFFDT , A.LANGUAGE_CD , A.DESCR , A.DESCRSHORT FROM %Table(CURRCD_TBL_LANG) A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM %Table(CURRCD_TBL_LANG) A1 WHERE A1.CURRENCY_CD = A.CURRENCY_CD AND A1.LANGUAGE_CD = A.LANGUAGE_CD AND A1.EFFDT <= %CurrentDateIn)

  • Related Language Record for SSR_CURRENCY_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %Date

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