CE_BANK_ACCOUNTS

Cash ManagementUsed in 12 subject areas9 reporting columns

Cash Management (CE) — bank account master.

Primary key: BANK_ACCOUNT_ID

Columns

Column	Key	In reports	Description (inferred)
AP_USE_ALLOWED_FLAG		●	Indicator (Y/N) for the payables use allowed.
AR_USE_ALLOWED_FLAG		●	Indicator (Y/N) for the receivables use allowed.
BANK_ACCOUNT_ID	PK	○	Identifier for the bank account.
BANK_ACCOUNT_NAME		●	Name of the bank account.
BANK_ACCOUNT_NAME_ALT		●	Bank account name alt.
BANK_ACCOUNT_TYPE		●	Type of bank account.
CURRENCY_CODE		●	Code identifying the currency.
DESCRIPTION		●	Description.
MASKED_ACCOUNT_NUM		●	Masked account number.
PAY_USE_ALLOWED_FLAG		●	Indicator (Y/N) for the pay use allowed.

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

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_BANK_ACCOUNTS?

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