RPTG_JRNL_LANG

(SQL View)
Index Back

XGC Journal type view

Related language record for RPTG_JRNL_VW for EXG statutory reports for non doc seq BUs

SELECT A.RPTG_APPL_ID , A.BUSINESS_UNIT , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.RPTG_DETAIL_SEQ , A.LEDGER , A.JRNL_TYPE , B.LANGUAGE_CD , B.DESCR FROM PS_RPTG_DETAIL_TBL A LEFT OUTER JOIN PS_JRNL_TP_BU_LANG B ON A.JRNL_TYPE = B.JRNL_TYPE AND A.BUSINESS_UNIT = B.BUSINESS_UNIT

  • Related Language Record for RPTG_JRNL_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RPTG_APPL_ID Character(3) VARCHAR2(3) NOT NULL Reporting Application
    AP=Accounts Payable
    AR=Accounts Receivable
    BI=Billing
    EX=Expenses
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    4 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
    5 RPTG_DETAIL_SEQ Number(6,0) INTEGER NOT NULL Reporting Detail Line
    6 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    7 JRNL_TYPE Character(2) VARCHAR2(2) NOT NULL Journal Type
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description