Oracle Fusion · Data dictionary
CE_STATEMENT_HEADERS
Cash ManagementUsed in 4 subject areas7 reporting columns
Cash Management (CE) — imported bank statement headers.
Primary key: STATEMENT_HEADER_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ELECTRONIC_SEQ_NUM | ● | Electronic seq number. | |
| LEGAL_SEQ_NUM | ● | Legal seq number. | |
| RECON_STATUS_CODE | ● | Code identifying the recon status. | |
| STATEMENT_ENTRY_TYPE | ● | Type of statement entry. | |
| STATEMENT_HEADER_ID | PK | ○ | Identifier for the statement header. |
| STATEMENT_NUMBER | ● | Statement number. | |
| STMT_FROM_DATE | ● | Stmt from date. | |
| STMT_TO_DATE | ● | Stmt to date. |
3 reports read from this table
Change a column here and these are the reports that move with it — the blast radius for any change to CE_STATEMENT_HEADERS.
- Cash to General Ledger Reconciliation Report
- Treasury-Loaded Bank Account Information Report
- Transactions Available for Reconciliation Report
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
- Cash Management - Bank Statement Balances Real Time
- Cash Management - Bank Statement Line Charges Real Time
- Cash Management - Bank Statements Real Time
- Cash Management - External Cash Transactions Real Time
Need the extract + dbt staging for CE_STATEMENT_HEADERS?
We ship parameterized SQL, BICC config, and dbt models you own.