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