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.
Problems that run through this table