IBY_EXT_BANK_ACCOUNTS

PaymentsUsed in 12 subject areas12 reporting columns

Payments (IBY).

Primary key: EXT_BANK_ACCOUNT_ID

Columns

Column	Key	In reports	Description (inferred)
BANK_ACCOUNT_NAME		●	Name of the bank account.
BANK_ACCOUNT_NUM		●	Bank account number.
BANK_ACCOUNT_TYPE		●	Type of bank account.
CHECK_DIGITS		●	Check digits.
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
CURRENCY_CODE		●	Code identifying the currency.
DESCRIPTION		●	Description.
EXT_BANK_ACCOUNT_ID	PK	○	Identifier for the ext bank account.
LAST_UPDATED_BY		●	User who last updated the row.
LAST_UPDATE_DATE		●	Date and time the row was last updated (the incremental-extract key).
MASKED_BANK_ACCOUNT_NUM		●	Masked bank account number.
MASKED_IBAN		●	Masked iban.

Change a column here and these are the reports that move with it — the blast radius for any change to IBY_EXT_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 IBY_EXT_BANK_ACCOUNTS?

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