RPTG_JRNL_VW

(SQL View)
 Index Back

XGC Journal type

This view is used in EXG statutory reports for non doc seq BUs (Journal type blank)

SELECT A.RPTG_APPL_ID , A.BUSINESS_UNIT , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.RPTG_DETAIL_SEQ , A.LEDGER , A.JRNL_TYPE , A.RPTG_BALANCE_SEQ , A.ACCOUNT , A.ALTACCT , B.DESCR , A.BASE_CURRENCY , A.JRNL_CODE , A.DOC_TYPE , A.DOC_SEQ_NBR , A.FOREIGN_CURRENCY , A.RT_TYPE , A.RATE_DIV , A.RATE_MULT , A.FOREIGN_AMT_DR , A.FOREIGN_AMT_CR , A.MONETARY_AMT_DR , A.MONETARY_AMT_CR , A.ACCOUNTING_DT , A.DOC_SEQ_DATE FROM PS_RPTG_DETAIL_TBL A LEFT OUTER JOIN PS_JRNL_TP_BU_VW B ON A.JRNL_TYPE = B.JRNL_TYPE AND A.BUSINESS_UNIT = B.BUSINESS_UNIT

  • Related Language Record: RPTG_JRNL_LANG

    • # 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 RPTG_BALANCE_SEQ Signed Number(19,0) DECIMAL(18) NOT NULL Reporting Balance Line
    9 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
    10 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    12 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
    13 JRNL_CODE Character(8) VARCHAR2(8) NOT NULL Journal Code
    14 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
    15 DOC_SEQ_NBR Character(12) VARCHAR2(12) NOT NULL Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
    16 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
    17 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
    18 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
    19 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    20 FOREIGN_AMT_DR Signed Number(28,3) DECIMAL(26,3) NOT NULL Debit Amount
    21 FOREIGN_AMT_CR Signed Number(28,3) DECIMAL(26,3) NOT NULL Credit Amount
    22 MONETARY_AMT_DR Signed Number(28,3) DECIMAL(26,3) NOT NULL Base DR Amount
    23 MONETARY_AMT_CR Signed Number(28,3) DECIMAL(26,3) NOT NULL Base CR Amount
    24 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
    25 DOC_SEQ_DATE Date(10) DATE Specifies the date that a document sequence number is assigned to a document or the date the document was created.