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:
- STATEMENT_LINE_ID — surrogate identifier for the archived line.
- STATEMENT_HEADER_ID — foreign key to CE_ARCH_HEADERS_ALL; identifies the parent statement header.
- LINE_NUMBER — the line sequence within the statement header, forming the unique business key with the header.
- TRX_DATE — the transaction or value date of the statement line.
- TRX_TYPE and TRX_CODE_ID — transaction classification, with TRX_CODE_ID referencing CE_TRANSACTION_CODES.
- AMOUNT and ORIGINAL_AMOUNT — the statement line amount and its original-currency equivalent.
- CHARGES_AMOUNT — bank charges applied to the line.
- STATUS — the reconciliation status of the line.
- CURRENCY_CODE — foreign key to FND_CURRENCIES.
- EXCHANGE_RATE_TYPE, EXCHANGE_RATE and EXCHANGE_RATE_DATE — conversion information; the rate type references GL_DAILY_CONVERSION_TYPES.
- BANK_TRX_NUMBER, TRX_TEXT, CUSTOMER_TEXT and INVOICE_TEXT — the reference and free-text fields carried from the original statement.
- RECONCILE_TO_STATEMENT_FLAG — indicates whether the line is reconciled against the bank statement.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE and LAST_UPDATE_LOGIN — standard who-column audit attributes.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard descriptive flexfield columns.
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.
-
Archived CE_STATEMENT_LINES records
-
Archived CE_STATEMENT_LINES records
-
TABLE: CE.CE_ARCH_LINES 12.1.1
-
SYNONYM: APPS.CE_ARCH_LINES 12.1.1
-
SYNONYM: APPS.CE_ARCH_LINES 12.2.2
-
TABLE: CE.CE_ARCH_LINES 12.2.2
-
VIEW: CE.CE_ARCH_LINES# 12.2.2
-
PACKAGE BODY: APPS.CE_PURGE 12.2.2
-
PACKAGE: APPS.CE_PURGE 12.2.2
-
VIEW: CE.CE_ARCH_LINES# 12.2.2
-
Table: CE_ARCH_HEADERS_ALL 12.1.1
Archived CE_STATEMENT_HEADERS_ALL records
Not implemented in this database·Explore CE module →
-
Table: CE_ARCH_HEADERS_ALL 12.2.2
Archived CE_STATEMENT_HEADERS_ALL records
Not implemented in this database·Explore CE module →
-
Archived CE_RECONCILIATION_ERRORS records
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
Archived CE_RECONCILIATION_ERRORS records
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
Archived CE_STATEMENT_RECONCILS_ALL records
-
12.2.2 DBA Data 12.2.2
-
Archived CE_STATEMENT_RECONCILS_ALL records
-
APPS.CE_PURGE SQL Statements 12.2.2
-
PACKAGE BODY: APPS.CE_PURGE 12.2.2
-
eTRM - CE Tables and Views 12.2.2
This table stores the error or warning messages from ZBA deal creation process
-
eTRM - CE Tables and Views 12.1.1
This table stores the error or warning messages from ZBA deal creation process