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.

Change a column here and these are the reports that move with it — the blast radius for any change to CE_STATEMENT_LINES.

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.

Need the extract + dbt staging for CE_STATEMENT_LINES?

We ship parameterized SQL, BICC config, and dbt models you own.