GL_ACCTALL_LANG

(SQL View)
 Index Back

View of all Accounts RLR


SELECT A.SETID ,A.ACCOUNT ,L.LANGUAGE_CD ,L.DESCR FROM PS_GL_ACCOUNT_TBL A ,PS_GL_ACCOUNT_LANG L WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_GL_ACCOUNT_TBL B WHERE A.SETID = B.SETID AND A.ACCOUNT = B.ACCOUNT) AND L.SETID = A.SETID AND L.ACCOUNT = A.ACCOUNT AND L.EFFDT = A.EFFDT

  • Related Language Record for AP_ACCT_ALL_VW GL_ACCT_ALL_VW

  • Parent Record Of VAT_ACCTMON_LVW VAT_ACCT_MON_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description