Results for “ce_arch_lines”

50+ results




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

Overview

CE_ARCH_LINES is a Cash Management archive table in the CE schema that stores archived copies of CE_STATEMENT_LINES records. Bank statement lines are periodically purged from the active tables into this archive to control growth of the operational statement tables, while preserving the transactional detail required for reconciliation audit and historical reporting. The table is owned by CE and holds 42 documented columns in the 12.2.2 schema definition; the same structure is delivered in 12.1.1.

In Data Vault modeling terms, CE_ARCH_LINES is classified heuristically as satellite-leaning. This classification reflects that the table is a descriptive, transaction-level detail object that hangs off a header rather than a business hub. It carries a single surrogate key and a large set of descriptive attributes (amounts, dates, text fields, currency and rate information) that describe a statement line event. It is not a candidate hub because the identity it exposes, STATEMENT_LINE_ID, is generated internally rather than being a durable business concept, and it is not a pure link because the row content is descriptive rather than a relationship between two or more hubs.

Key Information Stored

The surrogate primary key is CE_ARCHIVE_LINES_PK1, defined on STATEMENT_LINE_ID. A second unique constraint, CE_ARCHIVE_LINES_UK1, is defined on STATEMENT_HEADER_ID and LINE_NUMBER, which is the natural business key candidate for a statement line within its header.

The most significant columns are:

Common Use Cases and Queries

The primary use case is historical reconstruction of reconciled bank statement detail after the operational statement lines have been archived. Typical queries join CE_ARCH_LINES to CE_ARCH_HEADERS_ALL to obtain the bank account, statement number and period context, and apply filters on TRX_DATE to satisfy audit or regulatory retrieval windows.

A representative pattern retrieves archived lines for a given statement header:

  • SELECT l.line_number, l.trx_date, l.trx_type, l.amount, l.currency_code, l.status, l.bank_trx_number FROM ce.ce_arch_lines l WHERE l.statement_header_id = :p_header_id ORDER BY l.line_number;

A second pattern reconstructs the reconciliation trail by joining archived lines to CE_ARCH_RECONCILIATIONS_ALL and CE_ARCH_RECON_ERRORS on STATEMENT_LINE_ID, which is useful when investigating why a historic line failed reconciliation or was reversed. A third pattern aggregates archived line amounts by currency and period for trend analysis of bank activity, using ORIGINAL_AMOUNT and CHARGES_AMOUNT alongside EXCHANGE_RATE.

Related Objects

The following objects have the most significant relationships with CE_ARCH_LINES:

  • CE_ARCH_HEADERS_ALL — parent header; joined on CE_ARCH_LINES.STATEMENT_HEADER_ID = CE_ARCH_HEADERS_ALL.STATEMENT_HEADER_ID.
  • CE_ARCH_RECONCILIATIONS_ALL — references this table via STATEMENT_LINE_ID and holds the archiving reconciliation detail.
  • CE_ARCH_RECON_ERRORS — references this table via STATEMENT_LINE_ID and stores reconciliation exception records.
  • CE_TRANSACTION_CODES — referenced through TRX_CODE_ID to resolve transaction code descriptions.
  • FND_CURRENCIES — referenced through CURRENCY_CODE for currency name and precision.
  • GL_DAILY_CONVERSION_TYPES — referenced through EXCHANGE_RATE_TYPE for rate type descriptions.
  • CE_STATEMENT_LINES — the operational source table whose rows are migrated into this archive structure.