CM_ACCTBUGL_LVW

(SQL View)
 Index Back

Accts Bu GL Related lang View

08/02 MXS B1606/RES106631/INC512811002 Unable to select control accounts Transaction accounting rules

SELECT A.SETID , A.ACCOUNT , A.EFFDT , B.LANGUAGE_CD , B.DESCR , B.DESCRSHORT , A.BUDGETARY_ONLY , A.ACCOUNTING_OWNER , A.OPEN_ITEM_DESCR FROM PS_GL_ACCOUNT_TBL A , PS_GL_ACCOUNT_LANG B WHERE A.SETID = B.SETID AND A.ACCOUNT = B.ACCOUNT AND A.EFFDT = B.EFFDT AND A.BUDGETARY_ONLY = 'N'

  • Related Language Record for CM_ACCT_BUGL_VW

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCOUNT_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 BUDGETARY_ONLY Character(1) VARCHAR2(1) NOT NULL Budgetary Only
    8 ACCOUNTING_OWNER Character(30) VARCHAR2(30) NOT NULL Accounting Owner
    9 OPEN_ITEM_DESCR Character(10) VARCHAR2(10) NOT NULL Describes the OpenItem key that must be specified in the reference field on journal entry panels when an open item account number is used. It appears on prompt lists, reports, and online inquiries related to an open item account in the general ledger.