Oracle Fusion · Data dictionary
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. |
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 IBY_EXT_BANK_ACCOUNTS.
- Supplier Detail Report
- SEPA Debit Authorization and Bank Detail Check Report
- SEPA Letter for Italy Customer
Where this surfaces in OTBI
The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Costing - New COGS and Gross Margin Details Real Time
- Payables Invoices - Installments Real Time
- Payables Payments - Disbursements Real Time
- Payables Payments - Payment History Real Time
- Receivables - Adjustments Real Time
- Receivables - Bills Receivable Real Time
- Receivables - Customer Real Time
- Receivables - Miscellaneous Receipts Real Time
- Receivables - Standard Receipts Application Details Real Time
- Receivables - Transactions Real Time
- Subledger Accounting - Journals Real Time
- Supplier - Supplier Real Time
Need the extract + dbt staging for IBY_EXT_BANK_ACCOUNTS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table