Oracle Fusion · Data dictionary
AP_PREPAY_APP_DISTS
PayablesUsed in 1 subject areas21 reporting columns
Payables (AP).
Primary key: not yet catalogued for AP_PREPAY_APP_DISTS — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AMOUNT | ● | Amount. | |
| AMOUNT_VARIANCE | ● | Amount variance. | |
| BASE_AMOUNT | ● | Base amount. | |
| BASE_AMT_AT_PREPAY_CLR_XRATE | ● | Base amount at prepay clr xrate. | |
| BASE_AMT_AT_PREPAY_PAY_XRATE | ● | Base amount at prepay pay xrate. | |
| BASE_AMT_AT_PREPAY_XRATE | ● | Base amount at prepay xrate. | |
| INVOICE_BASE_AMT_VARIANCE | ● | Invoice base amount variance. | |
| PREPAY_CLR_EXCHANGE_DATE | ● | Prepay clr exchange date. | |
| PREPAY_CLR_EXCHANGE_RATE | ● | Prepay clr exchange rate. | |
| PREPAY_CLR_EXCHANGE_RATE_TYPE | ● | Type of prepay clr exchange rate. | |
| PREPAY_DIST_LOOKUP_CODE | ● | Lookup code for the prepay distribution. | |
| PREPAY_EXCHANGE_DATE | ● | Prepay exchange date. | |
| PREPAY_EXCHANGE_RATE | ● | Prepay exchange rate. | |
| PREPAY_EXCHANGE_RATE_TYPE | ● | Type of prepay exchange rate. | |
| PREPAY_PAY_EXCHANGE_DATE | ● | Prepay pay exchange date. | |
| PREPAY_PAY_EXCHANGE_RATE | ● | Prepay pay exchange rate. | |
| PREPAY_PAY_EXCHANGE_RATE_TYPE | ● | Type of prepay pay exchange rate. | |
| ROUNDING_AMT | ● | Rounding amount. | |
| ROUND_AMT_AT_PREPAY_CLR_XRATE | ● | Round amount at prepay clr xrate. | |
| ROUND_AMT_AT_PREPAY_PAY_XRATE | ● | Round amount at prepay pay xrate. | |
| ROUND_AMT_AT_PREPAY_XRATE | ● | Round amount at prepay xrate. |
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_PREPAY_APP_DISTS?
We ship parameterized SQL, BICC config, and dbt models you own.