Oracle Fusion · Data dictionary
CE_STATEMENT_LINES
Cash ManagementUsed in 3 subject areas23 reporting columns
Cash Management (CE), imported bank statement lines (the raw transactions from the bank).
Primary key: STATEMENT_LINE_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCNT_SERVICER_REF | ● | Accnt servicer reference. | |
| ADDENDA_TXT | ● | Addenda txt. | |
| AMOUNT | ● | Amount. | |
| BOOKING_DATE | ● | Booking date. | |
| CHECK_NUMBER | ● | Check number. | |
| CLEARING_SYSTEM_REF | ● | Clearing system reference. | |
| COMM_WAIVER_IND_FLAG | ● | Indicator (Y/N) for the comm waiver ind. | |
| CONTRACT_IDENTIFICATION | ● | Contract identification. | |
| CUSTOMER_REFERENCE | ● | Customer reference. | |
| END_TO_END_ID | ● | Identifier for the end to end. | |
| EXCHANGE_RATE | ● | Exchange rate. | |
| EXCHANGE_RATE_DATE | ● | Exchange rate date. | |
| FLOW_INDICATOR | ● | Flow indicator. | |
| INSTRUCTION_IDENTIFICATION | ● | Instruction identification. | |
| LINE_NUMBER | ● | Line number. | |
| ORIG_BANK_ACCOUNT_ID | ● | Identifier for the orig bank account. | |
| RECON_REFERENCE | ● | Recon reference. | |
| RECON_STATUS | ● | Status of the recon. | |
| REVERSAL_IND_FLAG | ● | Indicator (Y/N) for the reversal ind. | |
| SERVICER_STATUS | ● | Status of the servicer. | |
| STATEMENT_LINE_ID | PK | ○ | Identifier for the statement line. |
| TRX_AMOUNT | ● | Transaction amount. | |
| TRX_TYPE | ● | Type of transaction. | |
| VALUE_DATE | ● | Value date. |
4 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_LINES.
- Cash to General Ledger Reconciliation Report
- Treasury-Loaded Bank Account Information Report
- Transactions Available for Reconciliation Report
- Cash Management Bank Statement 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 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_LINES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table