ACCOUNT_LANG_VW

(SQL View)
 Index Back

Accounts RLR


SELECT SETID , ACCOUNT , LANGUAGE_CD , EFFDT , DESCR , DESCRSHORT FROM PS_GL_ACCOUNT_LANG

  • Related Language Record for ACCOUNT_EXP_VW ACCOUNT_REV_VW BI_GLACC_MON_VW EE_GL_ACCT_VW GLACCT_OPN_VW GL_ACCT_BUGL_VW GL_ACCT_CNTL_VW GL_ACCT_CTLB_VW GL_ACCT_CUR_VW GL_ACCT_EFFVW GL_ACCT_MON_VW GL_ACCT_MON_VW3 GL_ACCT_SC_VW GL_ACCT_STA_VW IU_ACCT_CUR_VW KK_ACCT_NOST_VW MIN_GLACTBGL_VW PC_ACCT_BUGL_VW TR_GL_ACC_CL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description