ACCT_CD_VW_LNG

(SQL View)
 Index Back

Account Codes Related Language

ACCT_CD_TBL_LNG is the language record related to ACCT_CD_TBL. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT A.FDM_HASH , B.ACCT_CD , A.LANGUAGE_CD , A.DESCR , A.DESCRSHORT FROM PS_ACCT_CD_TBL_LNG A , PS_ACCT_CD_TBL B WHERE A.FDM_HASH = B.FDM_HASH

  • Related Language Record for ACCT_CD_NEW_VW ACCT_CD_OLD_VW ACCT_CD_PC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FDM_HASH Character(31) VARCHAR2(31) NOT NULL Hash function
    2 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

    Default Value: NEW

    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