Results for “ce_statement_lines_pk”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CE_STATEMENT_LINES is a core transactional table within the Oracle E-Business Suite Cash Management (CE) module. It stores individual bank statement lines as received or loaded from financial institutions, serving as the granular foundation for bank statement reconciliation, cash positioning, and automated clearing workflows. Each row represents a single debit or credit entry on a bank statement, linked to its parent statement header and subsequently to reconciliation, accounting, and error-tracking records.

From a dimensional modeling perspective, the table exhibits a satellite-leaning Data Vault classification. The surrogate primary key STATEMENT_LINE_ID uniquely identifies each line, while the business key is represented by the composite unique index CE_STATEMENT_LINES_U2 on STATEMENT_HEADER_ID and LINE_NUMBER. This positions the table as a detail-bearing satellite that depends on the CE_STATEMENT_HEADERS_ALL hub for contextual grouping and carries descriptive and transactional attributes across 70 documented columns.

Key Information Stored

The table captures both identification and transactional attributes essential to statement processing.

• STATEMENT_LINE_ID — Surrogate primary key (CE_STATEMENT_LINES_PK / CE_STATEMENT_LINES_U1) uniquely identifying each line.
• STATEMENT_HEADER_ID and LINE_NUMBER — Composite business key (CE_STATEMENT_LINES_U2) linking the line to its parent statement and establishing ordering.
• TRX_DATE and EFFECTIVE_DATE — Transaction and effective dates driving reconciliation timing and accounting.
• TRX_TYPE and TRX_CODE_ID — Transaction classification, with TRX_CODE_ID referencing CE_TRANSACTION_CODES.
• AMOUNT, ORIGINAL_AMOUNT, and CHARGES_AMOUNT — The line value, original bank-reported amount, and any bank charges.
• CURRENCY_CODE, EXCHANGE_RATE_TYPE, EXCHANGE_RATE, and EXCHANGE_RATE_DATE — Currency and conversion detail for foreign-currency statements.
• STATUS and RECONCILE_TO_STATEMENT_FLAG — Line processing and reconciliation state.
• BANK_TRX_NUMBER, TRX_TEXT, CUSTOMER_TEXT, INVOICE_TEXT, and REFERENCE_TXT — Reference and narrative fields used for matching.
• GL_ACCOUNT_CCID and ACCOUNTING_DATE — Accounting flexfield and date for journal generation.
• JE_STATUS_FLAG — Indicates journal entry creation status.
• CASHFLOW_ID — Links the line to cashflow forecasting.
• ATTRIBUTE_CATEGORY / ATTRIBUTE1–15 and GLOBAL_ATTRIBUTE_CATEGORY / GLOBAL_ATTRIBUTE1–20 — Descriptive flexfield and global descriptive flexfield extension columns.

Common Use Cases and Queries

Reconciliation analysts and reporting developers query this table to match statement lines against open transactions, review unreconciled items, and audit accounting status. A typical pattern joins lines to their header and reconciliation records:

• Listing unreconciled lines by bank account and statement date.
• Retrieving line-level detail for a single statement header via STATEMENT_HEADER_ID.
• Identifying lines with JE_STATUS_FLAG indicating pending accounting.
• Foreign-currency exposure reporting using CURRENCY_CODE and EXCHANGE_RATE.

Sample SQL:

• SELECT l.statement_line_id, l.line_number, l.trx_date, l.amount, l.status FROM ce_statement_lines l WHERE l.statement_header_id = :header_id ORDER BY l.line_number;
• SELECT l.statement_line_id, l.bank_trx_number, l.amount, l.status FROM ce_statement_lines l WHERE l.status = 'UNRECONCILED';

Related Objects

The table participates in a rich relational network anchored by its foreign keys and dependent child tables.

• CE_STATEMENT_HEADERS_ALL — Parent header via CE_STATEMENT_LINES.STATEMENT_HEADER_ID.
• CE_TRANSACTION_CODES — Transaction code lookup via TRX_CODE_ID.
• FND_CURRENCIES — Currency validation via CURRENCY_CODE.
• GL_DAILY_CONVERSION_TYPES — Rate type via EXCHANGE_RATE_TYPE.
• GL_CODE_COMBINATIONS — Accounting flexfield via GL_ACCOUNT_CCID.
• CE_STATEMENT_RECONCILS_ALL — Reconciliation details keyed by STATEMENT_LINE_ID.
• CE_RECONCILIATION_ERRORS — Error capture keyed by STATEMENT_LINE_ID.
• CE_JE_MESSAGES — Journal entry message tracking keyed by STATEMENT_LINE_ID.