Search Results ja_cn_journal_lines

Overview

The JA_CN_JOURNAL_LINES table is a localization data object owned by the JA schema within the Asia/Pacific Localizations product family. Its documented purpose is to store General Ledger journal lines together with information about any related subsidiary accounts. The table is classified as VALID in the ETRM 12.2.2 physical schema and contains 71 documented columns. It is a standalone object from a foreign-key perspective: the only documented outbound relationship is from LEGAL_ENTITY_ID to FV_LEGAL_ENTITIES. Because the object carries descriptive journal-line attributes alongside ledger references, the heuristic Data Vault classification is satellite, suggesting it behaves as a descriptive detail store keyed to an upstream journal header or line hub rather than as a hub or link in its own right.

Key Information Stored

The table captures the journal header context, the accounting entry itself, and localization-specific subsidiary account detail. The most significant columns are:

JE_HEADER_ID — the GL journal header reference tying the line to its parent journal.
JE_LINE_NUM and LINE_NUMBER — line-level sequence identifiers within the journal.
SET_OF_BOOKS_ID and LEDGER_ID — the ledger context under which the line is recorded.
LEGAL_ENTITY_ID — the documented foreign key to FV_LEGAL_ENTITIES.
PERIOD_NAME, DEFAULT_EFFECTIVE_DATE, JE_CATEGORY, and JOURNAL_NUMBER — journal identity and accounting period attributes.
CURRENCY_CODE, CURRENCY_CONVERSION_RATE, and CURRENCY_CONVERSION_TYPE — currency and conversion detail.
ENTERED_DR, ENTERED_CR, ACCOUNTED_DR, ACCOUNTED_CR — the monetary amounts of the line.
CODE_COMBINATION_ID — the GL account combination, complemented by SEGMENT1 through SEGMENT30 and the COMPANY_SEGMENT and ACCOUNT_SEGMENT helper columns.
THIRD_PARTY_ID, PERSONNEL_ID, PROJECT_ID, and PROJECT_SOURCE — subsidiary account attributes such as supplier, employee, and project references.
STATUS, JOURNAL_CREATOR, JOURNAL_APPROVER, JOURNAL_POSTER — workflow and audit state.

No explicit surrogate primary key or unique index candidate is documented in the supplied metadata; JE_HEADER_ID combined with JE_LINE_NUM is the practical business-key candidate for identifying a journal line.

Common Use Cases and Queries

Typical scenarios include subsidiary-account reporting, journal-line reconciliation, and combined GL plus localization extracts. A representative query joining the documented legal entity relationship:

Query journal lines for a legal entity: SELECT j.JE_HEADER_ID, j.JE_LINE_NUM, j.PERIOD_NAME, j.ENTERED_DR, j.ENTERED_CR FROM JA.JA_CN_JOURNAL_LINES j JOIN FV_LEGAL_ENTITIES e ON j.LEGAL_ENTITY_ID = e.LEGAL_ENTITY_ID.
Summarize posted activity by ledger and account: SELECT LEDGER_ID, CODE_COMBINATION_ID, SUM(ACCOUNTED_DR - ACCOUNTED_CR) FROM JA.JA_CN_JOURNAL_LINES WHERE STATUS = 'P' GROUP BY LEDGER_ID, CODE_COMBINATION_ID.
Filter lines carrying subsidiary account detail: restrict on THIRD_PARTY_ID IS NOT NULL or PROJECT_ID IS NOT NULL.

Related Objects

The most significant related objects, based on the documented FK and the table's role, include:

FV_LEGAL_ENTITIES — referenced via JA_CN_JOURNAL_LINES.LEGAL_ENTITY_ID.
GL_JE_HEADERS and GL_JE_LINES — the parent GL journal objects associated through JE_HEADER_ID and JE_LINE_NUM.
GL_CODE_COMBINATIONS — resolved through CODE_COMBINATION_ID.
GL_LEDGERS and GL_SETS_OF_BOOKS — referenced through LEDGER_ID and SET_OF_BOOKS_ID.
Supplier and personnel masters referenced by THIRD_PARTY_ID and PERSONNEL_ID for subsidiary account detail.

Table: JA_CN_JOURNAL_LINES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_CN_JOURNAL_LINES, object_name:JA_CN_JOURNAL_LINES, status:VALID, product: JA - Asia/Pacific Localizations , description: The 'JA_CN_JOURNAL_LINES' table stores GL journal lines with information of related subsidiary accounts if any. , implementation_dba_data: JA.JA_CN_JOURNAL_LINES ,
Table: JA_CN_JOURNAL_LINES 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_CN_JOURNAL_LINES, object_name:JA_CN_JOURNAL_LINES, status:VALID, product: JA - Asia/Pacific Localizations , description: The 'JA_CN_JOURNAL_LINES' table stores GL journal lines with information of related subsidiary accounts if any. , implementation_dba_data: JA.JA_CN_JOURNAL_LINES ,
APPS.JA_CN_VOUCHER_NUM_MIG_PKG SQL Statements 12.2.2
SYNONYM: APPS.JA_CN_JOURNAL_LINES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:JA_CN_JOURNAL_LINES, status:VALID,
SYNONYM: APPS.JA_CN_JOURNAL_LINES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:JA_CN_JOURNAL_LINES, status:VALID,
APPS.JA_CN_UDRV_EXPORT SQL Statements 12.2.2
APPS.JA_CN_PS_SI_SM_EXPORT_PKG SQL Statements 12.2.2
APPS.JA_CN_ITEMIZATION_INTERFACE SQL Statements 12.1.1
APPS.JA_CN_ITEMIZATION_INTERFACE SQL Statements 12.2.2
VIEW: JA.JA_CN_JOURNAL_LINES# 12.2.2
owner:JA, object_type:VIEW, object_name:JA_CN_JOURNAL_LINES#, status:VALID,
APPS.JA_CN_HISDATA_MIG_PKG SQL Statements 12.2.2
Table: JA_CN_ITEM_INTERFACE 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_CN_ITEM_INTERFACE, object_name:JA_CN_ITEM_INTERFACE, status:VALID, product: JA - Asia/Pacific Localizations , description: The 'JA_CN_ITEM_INTERFACE' table is the interface table. It will store the journals user import. Data in this table will import to JA_CN_JOURNAL_LINES table by interface program. , implementation_dba_data: JA.JA_CN_ITEM_INTERFACE ,
Table: JA_CN_ITEM_INTERFACE 12.2.2
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_CN_ITEM_INTERFACE, object_name:JA_CN_ITEM_INTERFACE, status:VALID, product: JA - Asia/Pacific Localizations , description: The 'JA_CN_ITEM_INTERFACE' table is the interface table. It will store the journals that user imported by manual. Data in this table will be imported into JA_CN_JOURNAL_LINES table by interface program. , implementation_dba_data: JA.JA_CN_ITEM_INTERFACE ,
PACKAGE: APPS.JA_CN_ITEMIZATION_INTERFACE 12.2.2
PACKAGE: APPS.JA_CN_ITEMIZATION_INTERFACE 12.1.1
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
APPS.JA_CN_UDR_EXPORT SQL Statements 12.2.2
VIEW: JA.JA_CN_JOURNAL_LINES# 12.2.2
12.1.1 DBA Data 12.1.1
TABLE: JA.JA_CN_JOURNAL_LINES 12.1.1
owner:JA, object_type:TABLE, fnd_design_data:JA.JA_CN_JOURNAL_LINES, object_name:JA_CN_JOURNAL_LINES, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.JA_CN_JC_EXPORT_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_JC_EXPORT_PKG, status:VALID,
PACKAGE BODY: APPS.JA_CN_CUR_EXPORT_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_CUR_EXPORT_PKG, status:VALID,
PACKAGE BODY: APPS.JA_CN_ERT_EXPORT_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_ERT_EXPORT_PKG, status:VALID,
PACKAGE BODY: APPS.JA_CN_SM_EXPORT_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_SM_EXPORT_PKG, status:VALID,
PACKAGE BODY: APPS.JA_CN_JRCFI_EXPORT_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_JRCFI_EXPORT_PKG, status:VALID,
PACKAGE BODY: APPS.JA_CN_POST_UTILITY_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_POST_UTILITY_PKG, status:VALID,
PACKAGE BODY: APPS.JA_CN_POST_UTILITY_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_POST_UTILITY_PKG, status:VALID,
PACKAGE BODY: APPS.JA_CN_VOUCHER_NUM_MIG_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_VOUCHER_NUM_MIG_PKG, status:VALID,
PACKAGE BODY: APPS.JA_CN_APAB_EXPORT_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_APAB_EXPORT_PKG, status:VALID,
PACKAGE BODY: APPS.JA_CN_PS_SI_SM_EXPORT_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_PS_SI_SM_EXPORT_PKG, status:VALID,
APPS.JA_CN_CUR_EXPORT_PKG SQL Statements 12.2.2
PACKAGE BODY: APPS.JA_CN_JE_EXP_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_JE_EXP_PKG, status:VALID,
PACKAGE BODY: APPS.JA_CN_HISDATA_MIG_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_HISDATA_MIG_PKG, status:VALID,
APPS.JA_CN_JC_EXPORT_PKG SQL Statements 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.JA_CN_UDR_EXPORT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_UDR_EXPORT, status:VALID,
PACKAGE BODY: APPS.JA_CN_UDRV_EXPORT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_UDRV_EXPORT, status:VALID,
PACKAGE BODY: APPS.JA_CN_JE_EXPORT_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_JE_EXPORT_PKG, status:VALID,
PACKAGE BODY: APPS.JA_CN_ITEMIZATION_INTERFACE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_ITEMIZATION_INTERFACE, status:VALID,
APPS.JA_CN_ERT_EXPORT_PKG SQL Statements 12.2.2
PACKAGE BODY: APPS.JA_CN_AB_EXP_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_AB_EXP_PKG, status:VALID,
PACKAGE BODY: APPS.JA_CN_ITEMIZATION_INTERFACE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_ITEMIZATION_INTERFACE, status:VALID,
PACKAGE BODY: APPS.JA_CN_JE_EXP_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_JE_EXP_PKG, status:VALID,
PACKAGE BODY: APPS.JA_CN_ACC_JE_ITEMIZATION_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_ACC_JE_ITEMIZATION_PKG, status:VALID,
PACKAGE BODY: APPS.JA_CN_ACC_JE_ITEMIZATION_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_ACC_JE_ITEMIZATION_PKG, status:VALID,
PACKAGE BODY: APPS.JA_CN_AB_EXP_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:JA_CN_AB_EXP_PKG, status:VALID,
APPS.JA_CN_JE_EXPORT_PKG SQL Statements 12.2.2
APPS.JA_CN_SM_EXPORT_PKG SQL Statements 12.2.2