Analytics Catalog/Data dictionary/IBY_EXTERNAL_PAYERS_ALL
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

IBY_EXTERNAL_PAYERS_ALL

PaymentsUsed in 1 subject areas8 reporting columns

Payments (IBY), transaction table (rows scoped across all operating units).

Primary key: EXT_PAYER_ID

Columns

ColumnKeyIn reportsDescription (inferred)
BANK_CHARGE_BEARER_CODECode identifying the bank charge bearer.
DEBIT_ADVICE_DELIVERY_METHODDebit advice delivery method.
DEBIT_ADVICE_EMAILDebit advice email.
DEBIT_ADVICE_FAXDebit advice fax.
DIRDEB_INSTRUCTION_CODECode identifying the dirdeb instruction.
EXT_PAYER_IDPKIdentifier for the ext payer.
LOCALINSTRLocalinstr.
PURPOSE_CODECode identifying the purpose.
SERVICE_LEVELService level.

2 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_EXTERNAL_PAYERS_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_PAYERS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
Payables does not tie · Three-way match does not tie · The export ceiling