The Journal Entries Report displays detailed header and line information for subledger and General Ledger journal entries
Note: To avoid duplication with subledger journal entries, General Ledger journal entries imported from Subledger Accounting are not included in the report.
Journal Entries Report Selection Parameters
| Parameter | Token | Required | Valid Values |
|---|---|---|---|
| Ledger /Ledger Set | P_LEDGER | Yes | From GL: All ledgers and ledger sets included in the access set identified by the profile option SLA: Data Access Set From Subledger, Use Ledger Security = Yes: All ledgers and ledger sets included in the access sets identified by the profile options GL: Data Access Set and SLA: Additional Data Access Set From Subledger, Use Ledger Security = No: All ledgers and ledger sets defined in GL |
| Legal Entity | P_LEGAL_ENTITY | No | All legal entities assigned to ledgers in the ledger set |
| Transaction Legal Entity | P_TRX_LEGAL_ENTITY | No | All legal entities in the business group |
| Period [From, To] | Yes | ||
| From | P_PERIOD_FROM | All periods from the accounting calendar associated with the selected Ledger or Ledger Set | |
| To | P_PERIOD_TO | All periods from the accounting calendar equal to or coming after the From period up to the end of the fiscal year | |
| GL Date [From, To] | No | ||
| From | P_GL_DATE_FROM | ||
| To | P_GL_DATE_TO | Any date later than or equal to the From date | |
| Creation Date [From, To] | No | ||
| From | P_CREATION_DATE_FROM | ||
| To | P_CREATION_DATE_TO | Any date later than or equal to the From date | |
| Transaction Date [From, To] | No | ||
| From | P_TRANSACTION_DATE_FROM | ||
| To | P_TRANSACTION_DATE_TO | Any date later than or equal to the From date | |
| Journal Entry Status | P_JE_STATUS | No | Valid values are Draft, Final, and Error. |
| Posted | P_POSTING_STATUS | No | Yes: Lines that are posted in GL (i.e. transferred to and posted in GL) No: Lines that are not posted in GL (not transferred to GL or transferred to GL and not posted) All: all lines, irrespective of their posting status. |
| Journal Source | P_JE_SOURCE | No | From GL: All GL journal sources From Subledger: taken from the application owning the responsibility |
| Process Category | P_PROCESS_CATEGORY | No; requires a source associated with a subledger application | All process categories defined for the application associated with the journal entry source |
| Accounting Event Class | P_EVENT_CLASS | No; requires a source associated with a subledger application | All event classes enabled for the application associated with the JE source |
| Accounting Sequence Name | P_ACCOUNTING_SEQUENCE_NAME | No | All sequences assigned to ledgers in the ledger or ledger set |
| Accounting Sequence Version | P_ACCOUNTING_SEQUENCE_VERSION | No; requires accounting sequence name | All sequence versions for the accounting sequence |
| Accounting Sequence Number [From, To] | No; requires accounting sequence name and version | ||
| From | P_ACCOUNTING_SEQUENCE_NUMBER_FROM | ||
| To | P_ACCOUNTING_SEQUENCE_NUMBER_TO | Any value greater than or equal to the From value | |
| Reporting Sequence Name | P_REPORTING_SEQUENCE_NAME | No | All available sequences assigned to ledgers in the ledger or ledger set |
| Reporting Sequence Version | P_REPORTING_SEQUENCE_VERSION | No; requires reporting sequence name | All sequence versions for the reporting sequence |
| Reporting Sequence Number [From, To] | No; requires reporting sequence name and version | ||
| From | P_REPORTING_SEQUENCE_NUMBER_FROM | ||
| To | P_REPORTING_SEQUENCE_NUMBER_TO | Any value greater than or equal to the From value | |
| Document Sequence Name | P_DOCUMENT_SEQUENCE_NAME | No | All available document sequences |
| Document Sequence Number [From, To] | No; requires document sequence name | ||
| From | P_DOCUMENT_SEQUENCE_NUMBER_FROM | ||
| To | P_DOCUMENT_SEQUENCE_NUMBER_TO | Any value greater than or equal to the From value | |
| Third Party Type | P_PARTY_TYPE | No | Customer or Supplier |
| Third Party Name | P_PARTY_NAME | No; requires third party type | All customers or suppliers based on the third party type |
| Third Party Number [From, To] | No; requires third party type | ||
| From | P_PARTY_NUMBER_FROM | All customer or supplier numbers based on the third party type | |
| To | P_PARTY_NUMBER_TO | Any customer or supplier number greater than or equal to the From value | |
| Journal Category | P_JE_CATEGORY | No | All available journal categories |
| Balance Type | P_BALANCE_TYPE | No | Valid values are Actual, Encumbrance, and Budget. |
| Budget | P_BUDGET_NAME | No | All enabled budgets |
| Encumbrance Type | P_ENCUMBRANCE_TYPE | No | All encumbrance types defined in GL |
| Include Zero Amount Lines | P_INCLUDE_ZERO_AMOUNT_LINES | No | Yes and No; controls whether lines with both entered and accounted amount equal to zero are included in the report |
| Entered Currency | P_ENTERED_CURRENCY | No | All enabled currencies |
| Side | P_SIDE | No | Debit or credit. A journal entry line is included in the extract only if the line has the side provided by the user. |
| Accounted Amount Range [From, To] | No | Allowed only if a ledger (rather than a ledger set) is provided | |
| From | P_ACCOUNTED_AMOUNT_FROM | ||
| To | P_ACCOUNTED_AMOUNT_TO | Any value greater than or equal to the From date | |
| Balancing Segment [From, To] | No | From GL: All balancing segment values (BSV) included in the access set identified by the profile option GL: Data Access Set From Subledger, Use Ledger Security = Yes: All BSVs assigned to the ledger or ledger set (parameter) and included in the access sets identified by the profile options GL: Data Access Set and SLA: Additional Data Access Set From Subledger, Use Ledger Security = No: All BSVs assigned to the ledger or ledger set | |
| From | P_BALANCING_SEGMENT_FROM | ||
| To | P_BALANCING_SEGMENT_TO | All BSVs greater than or equal to the From value that meet the above criteria | |
| Natural Account Segment [From, To] | No | ||
| From | P_ACCOUNT_SEGMENT_FROM | All enabled natural account values from the ledger or ledger set's chart of accounts | |
| To | P_ACCOUNT_SEGMENT_TO | Any enabled natural account value from the ledger or ledger set's chart of accounts greater than or equal to the From value | |
| Accounting Code Combination [From, To] | No | ||
| From | P_ACCOUNTING_FLEXFIELD _FROM | All enabled accounting code combinations from the ledger or ledger set's chart of accounts | |
| To | P_ACCOUNTING_FLEXFIELD_ TO | Any enabled accounting code combination from the ledger or Ledger Set's COA greater than or equal to the From value | |
| Valuation Method | P_VALUATION_METHOD | No | No validation |
| Security Id Integer 1 | P_SECURITY_ID_INT_1 | No | No validation |
| Security Id Integer 2 | P_SECURITY_ID_INT_2 | No | No validation |
| Security Id Integer 3 | P_SECURITY_ID_INT_3 | No | No validation |
| Security Id Char 1 | P_SECURITY_ID_CHAR_1 | No | No validation |
| Security Id Char 2 | P_SECURITY_ID_CHAR_2 | No | No validation |
| Security Id Char 3 | P_SECURITY_ID_CHAR_3 | No | No validation |
| Post-Accounting Program | P_POST_ACCOUNTING_PROGRAM | No; requires a source associated with a subledger application | All post-accounting programs defined for the subledger application associated with the journal entry source. The extract retrieves lines with accounting classes assigned to the post-accounting program. |
| User Transaction Identifier Column 1 | P_USER_TRX_ID_COLUMN_1 (to 5) | No; requires an event class | All columns from the transaction view associated with the event class |
| User Transaction Identifier Value 1 | P_USER_TRX_ID_VALUE_1 (to 5) | No; requires an event class | No validation |
| GL Batch Name | P_GL_BATCH_NAME | No; requires a journal entry source | All GL batches from the journal entry source |
| Include User Transaction Identifiers | P_INCLUDE_USER_TRX_IDENTIFIERS | No | Yes or No; controls whether the extract program retrieves user identifiers names and values |
| Include Tax Details | P_INCLUDE_TAX_DETAILS | No | Yes or No; controls whether the extract program retrieves tax details for the journal entry lines |
| Include Legal Entity Information | P_INCLUDE_LEGAL_ENTITY_INFO | No | Legal Entity: Company information is retrieved from the legal entity to which the balancing segment value of the line is assigned; Establishment: Company information is retrieved from the establishment to which the balancing segment value of the line is assigned; None: No company information is retrieved. |
Note: Not all data elements have a corresponding field on the seeded journal entry report templates.
Journal Entries Report Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| GL Date | GL_DATE | Journal entry GL date |
| Transaction Created by | CREATED_BY | User who created the subledger transaction |
| Creation Date | CREATION_DATE | Journal entry creation date |
| Last Update Date | LAST_UPDATE_DATE | Last date journal entry updated |
| GL Transfer Date | GL_TRANSFER_DATE | Date journal entry transferred to General Ledger |
| Reference Date | REFERENCE_DATE | Journal entry legal reporting date |
| Completed Date | COMPLETED_DATE | Journal entry completion date |
| External Reference | EXTERNAL_REFERENCE | Journal entry external reference |
| Period Year | PERIOD_YEAR | Journal entry fiscal year |
| Period Year Start Date | PERIOD_YEAR_START_DATE | First date of the fiscal year |
| Period Year End Date | PERIOD_YEAR_END_DATE | Last date of the fiscal year |
| Period Number | PERIOD_NUMBER | Position of the period in the fiscal year |
| Period Name | PERIOD_NAME | Journal entry accounting period name |
| Period Start Date | PERIOD_START_DATE | First date of accounting period |
| Period End Date | PERIOD_END_DATE | Last date of accounting period |
| Transaction Number | TRANSACTION_NUMBER | Subledger transaction number |
| Transaction Date | TRANSACTION_DATE | Subledger transaction date |
| Accounting Sequence Name | ACCOUNTING_SEQUENCE_NAME | Sequence name used to number the journal entry at creation or posting |
| Accounting Sequence Version | ACCOUNTING_SEQUENCE_VERSION | Sequence version used to number the journal entry at creation or posting |
| Accounting Sequence Number | ACCOUNTING_SEQUENCE_NUMBER | Sequence number assigned to the journal entry at creation or posting |
| Reporting Sequence Name | REPORTING_SEQUENCE_NAME | Sequence name used to number the journal entry at period closing |
| Reporting Sequence Version | REPORTING_SEQUENCE_VERSION | Sequence version used to number the journal entry at period closing |
| Reporting Sequence Number | REPORTING_SEQUENCE_NUMBER | Sequence number assigned to the journal entry at period closing |
| Document Sequence Category | DOCUMENT_CATEGORY | Document category assigned to the subledger transaction |
| Document Sequence Name | DOCUMENT_SEQUENCE_NAME | Sequence name used to number the subledger transaction |
| Document Sequence Number | DOCUMENT_SEQUENCE_NUMBER | Sequence number assigned to the subledger transaction |
| Application Id | APPLICATION_ID | Internal identifier of the application owning the journal entry |
| Application Name | APPLICATION_NAME | Application name owning the journal entry |
| Ledger ID | LEDGER_ID | Internal identifier of the ledger owning the journal entry |
| Ledger Short Name | LEDGER_SHORT_NAME | Short name of ledger owning the journal entry |
| Ledger Description | LEDGER_DESCRIPTION | Description of ledger owning the journal entry |
| Ledger Name | LEDGER_NAME | Name of ledger owning the journal entry |
| Ledger Currency | LEDGER_CURRENCY | Currency of ledger owning the journal entry |
| Header ID | HEADER_ID | Journal entry internal identifier |
| Header Description | HEADER_DESCRIPTION | Journal entry description |
| Journal Entry Status | JOURNAL_ENTRY_STATUS | Subledger journal entry status: Draft, Final, and Enter |
| Transfer to GL Status | TRANSFER_TO_GL_STATUS | Indicates whether journal entry transferred to General Ledger |
| Balance Type Code | BALANCE_TYPE_CODE | Balance type indicator: A, B, or E for Actual, Budget, and Encumbrance respectively |
| Balance Type Name | BALANCE_TYPE | Journal entry balance type: Actual, Balance, or Encumbrance |
| Budget Name | BUDGET_NAME | Budget name for budget entries |
| Encumbrance Type | ENCUMBRANCE_TYPE | Encumbrance type for encumbrance entries |
| Fund Status Value | FUND_STATUS | Fund reservation status for the journal entry |
| Journal Category Name | JE_CATEGORY_NAME | Journal entry category |
| Journal Source Name | JE_SOURCE_NAME | Journal entry source |
| Event ID | EVENT_ID | Internal identifier of accounting event that originated the journal entry |
| Event Date | EVENT_DATE | Date of the accounting event that originated the journal entry |
| Event Number | EVENT_NUMBER | Number of the accounting event that originated the journal entry |
| Event Class Code | EVENT_CLASS_CODE | Event class code of the accounting event that originated the journal entry |
| Event Class Name | EVENT_CLASS_NAME | Event class name of the accounting event that originated the journal entry |
| Event Type Code | EVENT_TYPE_CODE | Event type code of the accounting event that originated the journal entry |
| Event Type Name | EVENT_TYPE_NAME | Event type name of the accounting event that originated the journal entry |
| User Transaction Identifier Name | USER_TRX_IDENTIFIER_NAME_1 (to 10) | Additional transaction information for identifying the transaction |
| User Transaction Identifier Value | USER_TRX_IDENTIFIER_VALUE_1 (to 10) | Additional transaction information for identifying the transaction |
| Batch Name | GL_BATCH_NAME | Name of General Ledger batch that includes the journal entry |
| GL Batch Status | GL_BATCH_STATUS | Status of batch that includes the journal entry: Unposted or Posted |
| Posted Date | POSTED_DATE | Date journal entry posted to General Ledger |
| GL Journal Name | GL_JE_NAME | Journal entry name; name for subledger journal entries taken from corresponding General Ledger journal entry |
| GL Document Sequence Name | GL_DOC_SEQUENCE_NAME | General Ledger document sequence name |
| GL Document Sequence Value | GL_DOC_SEQUENCE_VALUE | Document sequence value in General Ledger |
| GL Line Number | GL_LINE_NUMBER | Sequence name used to number the journal in General Ledger at creation |
| Line Number | LINE_NUMBER | Sequence number assigned to the journal in General Ledger at creation |
| Accounting Class Code | ACCOUNTING_CLASS_CODE | Accounting class code assigned to the subledger journal entry line |
| Accounting Class | ACCOUNTING_CLASS_NAME | Accounting class assigned to the subledger journal entry line |
| Line Description | LINE_DESCRIPTION | Journal entry line description |
| Code Combination Id | CODE_COMBINATION_ID | Accounting code combination internal identifier for the journal entry line |
| Accounting Code Combination | ACCOUNTING_CODE_COMBINATION (concatenated values) | Concatenated values of the accounting code combination for the journal entry line |
| Code Combination Description | CODE_COMBINATION_DESCRIPTION (concatenated descriptions) | Concatenated descriptions of the accounting code combination for the journal entry line |
| Control Account Flag | CONTROL_ACCOUNT_FLAG | Indicates whether the account is a third party control identifier: Y for yes; N for No |
| Control Account | CONTROL_ACCOUNT | Translated value of the control account flag: Yes or No |
| Entered Currency | ENTERED_CURRENCY | Journal entry currency |
| Conversion Rate | CONVERSION_RATE | Transaction conversion rate |
| Conversion Rate Date | CONVERSION _RATE_DATE | Transaction conversion rate date |
| Conversion Rate Type Code | CONVERSION _RATE_TYPE_CODE | Transaction conversion type code of rate |
| Conversion Rate Type | CONVERSION_RATE_TYPE | Transaction conversion rate type |
| Entered Debit | ENTERED_DR | Entered debit for journal entry line |
| Entered Credit | ENTERED_CR | Entered credit for journal entry line |
| Unrounded Accounted Debit | UNROUNDED_ACCOUNTED_DR | Accounted debit before rounding |
| Unrounded Accounted Credit | UNROUNDED_ACCOUNTED_CR | Accounted credit before rounding |
| Accounted Debit | ACCOUNTED_DR | Journal entry line accounted debit |
| Accounted Credit | ACCOUNTED_CR | Journal entry line accounted credit |
| Statistical Amount | STATISTICAL_AMOUNT | Journal entry line statistical amount |
| Reconciliation Reference | RECONCILIATION_REFERENCE | Reference used for reconciliation purposes |
| Attribute Category | ATTRIBUTE_CATEGORY | Context column for the journal entry lines descriptive flexfield |
| Attribute 1 (to 10) | ATTRIBUTE1 (to 10) | Attribute columns for the journal entry lines descriptive flexfield |
| Third Party Type | PARTY_TYPE_CODE | Third party type indicator: C for Customer; S for Supplier |
| Third Party Type | PARTY_TYPE | Party type: Customer or Supplier |
| Third Party Number | PARTY_NUMBER | Third party number for journal entry line |
| Third Party Name | PARTY_NAME | Third party name for journal entry line |
| Third Party Taxpayer Id | PARTY_TYPE_TAXPAYER_ID | Third party taxpayer identifier for journal entry line |
| Third Party Tax Registration Number | PARTY_TAX_REGISTRATION_NUMBER | Third party tax registration number for journal entry line |
| Third Party Site Number | PARTY_SITE_NUMBER | Third party site number for journal entry line |
| Third Party Site Name | PARTY_SITE_NAME | Third party site name for journal entry line |
| Third Party Tax Registration Number | PARTY_TAX_REGISTRATION_NUMBER | Third party tax registration number for journal entry line |
| Third Party Site Number | PARTY_SITE_NUMBER | Third party site number for journal entry line |
| Third Party Site Name | PARTY_SITE_NAME | Third party site name for journal entry line |
| Third Party Site Tax Registration Number | PARTY__SITE_TAX_REGISTRATION_NUMBER | Third party site taxpayer identifier for journal entry line |
| Balancing Segment | BALANCING_SEGMENT | Journal entry line balancing segment |
| Balancing Segment Description | BALANCING_SEGMENT_DESCRIPTION | Journal entry line balancing segment description |
| Natural Account | NATURAL_ACCOUNT | Journal entry line natural account segment value |
| Natural Account Description | NATURAL_ACCOUNT_DESCRIPTION | Journal entry line natural account segment description |
| Cost Center | COST_CENTER | Journal entry line cost center segment value |
| Cost Center Description | COST_CENTER_DESCRIPTION | Journal entry line cost center segment description |
| Management Segment | MANAGEMENT_SEGMENT | Journal entry line management segment value |
| Management Segment Description | MANAGEMENT_SEGMENT_DESCRIPTION | Journal entry line management segment description |
| Inter-company Segment | INTERCOMPANY_SEGMENT | Journal entry line intercompany segment value |
| Inter-company Segment Description | INTERCOMPANY_SEGMENT_DESCRIPTION | Journal entry line intercompany segment description |
| Segment 1 (to 30) | SEGMENT1 (to 30) | Journal entry lines individual Accounting Flexfield segment values |