Search Results ce_statement_lines




Overview
Explore in AI Chat

Overview

The CE_STATEMENT_LINES table is a core data repository within Oracle E-Business Suite Cash Management (CE) module. It serves as the detailed transaction-level record for bank statements that have been loaded into the system, either manually or via automated bank feeds. Each row in this table represents an individual line item from a bank statement, such as a deposit, check, wire transfer, or bank charge. Its primary role is to store the granular transactional data imported from financial institutions, which is then used as the source for the system's automated and manual bank reconciliation processes. The integrity of this data is critical for accurately matching statement lines with internal cash transactions (e.g., payments, receipts) in the CE_STATEMENT_RECONCILS_ALL table.

Key Information Stored

The table's structure is designed to capture the essential details of a bank statement transaction. Its primary key is the system-generated STATEMENT_LINE_ID. A unique key constraint also exists on the combination of STATEMENT_HEADER_ID and LINE_NUMBER, ensuring line uniqueness within a statement batch. Key transactional columns include TRX_CODE_ID (linking to CE_TRANSACTION_CODES for line type), CURRENCY_CODE, and the monetary amounts (e.g., statement amount, accounted amount). Critical reconciliation columns are GL_ACCOUNT_CCID, which holds the code combination ID for the cash account, and EXCHANGE_RATE_TYPE. The table also stores descriptive information such as the bank's transaction date, value date, and payer/payee details, which are vital for matching logic during reconciliation.

Common Use Cases and Queries

The primary use case is the bank reconciliation process. Analysts query this table to review unreconciled items, investigate discrepancies, and validate statement data before reconciliation. Common SQL patterns involve joining to the statement header (CE_STATEMENT_HEADERS_ALL) for bank and statement date context, and to the reconciliation table (CE_STATEMENT_RECONCILS_ALL) to see match status. A typical query to find unreconciled lines for a specific bank account would filter on the header and check for the absence of a reconciliation record. The table is also central to reconciliation error reporting via CE_RECONCILIATION_ERRORS and journal entry exception reporting via CE_JE_MESSAGES. Data from this table is frequently extracted for cash position and bank transaction detail reports.

Related Objects

CE_STATEMENT_LINES maintains integral relationships with several key Cash Management and General Ledger tables, as documented in the provided metadata.

  • CE_STATEMENT_HEADERS_ALL: Foreign key from STATEMENT_HEADER_ID. Every statement line must belong to a statement header, which defines the bank account and statement period.
  • CE_STATEMENT_RECONCILS_ALL: Foreign key from STATEMENT_LINE_ID. This is the core reconciliation join, where each statement line may have one or more reconciliation records linking it to internal system transactions.
  • CE_TRANSACTION_CODES: Foreign key from TRX_CODE_ID. Provides the meaning (e.g., "Check", "Deposit") for the statement line's transaction type.
  • GL_CODE_COMBINATIONS: Foreign key from GL_ACCOUNT_CCID. Identifies the General Ledger cash account against which the statement line is reconciled.
  • FND_CURRENCIES & GL_DAILY_CONVERSION_TYPES: Foreign keys for CURRENCY_CODE and EXCHANGE_RATE_TYPE, supporting multi-currency transactions.
  • CE_RECONCILIATION_ERRORS & CE_JE_MESSAGES: Child tables with a foreign key to STATEMENT_LINE_ID, logging reconciliation and journal creation issues for specific lines.