Oracle Fusion · Data dictionary
AP_PAYMENT_HISTORY_ALL
PayablesUsed in 1 subject areas16 reporting columns
Payables (AP) — transaction table (rows scoped across all operating units).
Primary key: not yet catalogued for AP_PAYMENT_HISTORY_ALL — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNTING_DATE | ● | Accounting date. | |
| BANK_TO_BASE_XRATE | ● | Bank to base xrate. | |
| BANK_TO_BASE_XRATE_DATE | ● | Bank to base xrate date. | |
| BANK_TO_BASE_XRATE_TYPE | ● | Type of bank to base xrate. | |
| GAIN_LOSS_INDICATOR | ● | Gain loss indicator. | |
| MATCHED_FLAG | ● | Indicator (Y/N) for the matched. | |
| PMT_TO_BASE_XRATE | ● | Payment to base xrate. | |
| PMT_TO_BASE_XRATE_DATE | ● | Payment to base xrate date. | |
| PMT_TO_BASE_XRATE_TYPE | ● | Type of payment to base xrate. | |
| POSTED_FLAG | ● | Indicator (Y/N) for the posted. | |
| TRANSACTION_AMOUNT | ● | Transaction amount. | |
| TRANSACTION_DATE | ● | Transaction date. | |
| TRANSACTION_TYPE | ● | Type of transaction. | |
| TRX_BANK_AMOUNT | ● | Transaction bank amount. | |
| TRX_BASE_AMOUNT | ● | Transaction base amount. | |
| TRX_PMT_AMOUNT | ● | Transaction payment amount. |
Used by reports
No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.
- —
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 AP_PAYMENT_HISTORY_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.