Oracle Fusion · Data dictionary
AP_PAYMENT_HIST_DISTS
PayablesUsed in 1 subject areas11 reporting columns
Payables (AP).
Primary key: PAYMENT_HIST_DIST_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AMOUNT | ● | Amount. | |
| AMOUNT_VARIANCE | ● | Amount variance. | |
| BANK_CURR_AMOUNT | ● | Bank currency amount. | |
| CLEARED_BASE_AMOUNT | ● | Cleared base amount. | |
| INVOICE_BASE_AMT_VARIANCE | ● | Invoice base amount variance. | |
| INVOICE_DIST_AMOUNT | ● | Invoice distribution amount. | |
| INVOICE_DIST_BASE_AMOUNT | ● | Invoice distribution base amount. | |
| MATURED_BASE_AMOUNT | ● | Matured base amount. | |
| PAID_BASE_AMOUNT | ● | Paid base amount. | |
| PAYMENT_HIST_DIST_ID | PK | ○ | Identifier for the payment hist distribution. |
| PAY_DIST_LOOKUP_CODE | ● | Lookup code for the pay distribution. | |
| ROUNDING_AMT | ● | Rounding 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_HIST_DISTS?
We ship parameterized SQL, BICC config, and dbt models you own.