Oracle Fusion · Data dictionary
IBY_EXTERNAL_PAYEES_ALL
PaymentsUsed in 2 subject areas17 reporting columns
Payments (IBY) — transaction table (rows scoped across all operating units).
Primary key: EXT_PAYEE_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| BANK_CHARGE_BEARER | ● | Bank charge bearer. | |
| BANK_INSTRUCTION1_CODE | ● | Code identifying the bank instruction1. | |
| BANK_INSTRUCTION2_CODE | ● | Code identifying the bank instruction2. | |
| BANK_INSTRUCTION_DETAILS | ● | Bank instruction details. | |
| DELIVERY_CHANNEL_CODE | ● | Code identifying the delivery channel. | |
| EXCLUSIVE_PAYMENT_FLAG | ● | Indicator (Y/N) for the exclusive payment. | |
| EXT_PAYEE_ID | PK | ○ | Identifier for the ext payee. |
| PAYMENT_FORMAT_CODE | ● | Code identifying the payment format. | |
| PAYMENT_REASON_CODE | ● | Code identifying the payment reason. | |
| PAYMENT_REASON_COMMENTS | ● | Payment reason comments. | |
| PAYMENT_TEXT_MESSAGE1 | ● | Payment text message1. | |
| PAYMENT_TEXT_MESSAGE2 | ● | Payment text message2. | |
| PAYMENT_TEXT_MESSAGE3 | ● | Payment text message3. | |
| REMIT_ADVICE_DELIVERY_METHOD | ● | Remit advice delivery method. | |
| REMIT_ADVICE_EMAIL | ● | Remit advice email. | |
| REMIT_ADVICE_FAX | ● | Remit advice fax. | |
| SERVICE_LEVEL_CODE | ● | Code identifying the service level. | |
| SETTLEMENT_PRIORITY | ● | Settlement priority. |
1 report 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_EXTERNAL_PAYEES_ALL.
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.
Need the extract + dbt staging for IBY_EXTERNAL_PAYEES_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.