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.
Problems that run through this table