Oracle Fusion · Data dictionary
AR_DISTRIBUTIONS_ALL
ReceivablesUsed in 6 subject areas12 reporting columns
Receivables (AR) — accounting distribution lines — the GL coding behind each transaction line.
Primary key: LINE_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCTD_AMOUNT_CR | ● | Acctd amount cr. | |
| ACCTD_AMOUNT_DR | ● | Acctd amount dr. | |
| AMOUNT_CR | ● | Amount cr. | |
| AMOUNT_DR | ● | Amount dr. | |
| CURRENCY_CONVERSION_DATE | ● | Currency conversion date. | |
| CURRENCY_CONVERSION_RATE | ● | Currency conversion rate. | |
| LINE_ID | PK | ○ | Identifier for the line. |
| SOURCE_TYPE | ● | Type of source. | |
| SOURCE_TYPE_SECONDARY | ● | Source type secondary. | |
| TAXABLE_ACCOUNTED_CR | ● | Taxable accounted cr. | |
| TAXABLE_ACCOUNTED_DR | ● | Taxable accounted dr. | |
| TAXABLE_ENTERED_CR | ● | Taxable entered cr. | |
| TAXABLE_ENTERED_DR | ● | Taxable entered dr. |
4 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 AR_DISTRIBUTIONS_ALL.
- Invoices Posted to Suspense Report
- Potential Reconciling Items Report
- Receivables Aging by General Ledger Account Report
- Recognize Revenue Execution Report
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.
- Receivables - Adjustments Real Time
- Receivables - Bills Receivable Real Time
- Receivables - Credit Memo Applications Real Time
- Receivables - Miscellaneous Receipts Real Time
- Receivables - Receipts Details Real Time
- Receivables - Standard Receipts Application Details Real Time
Need the extract + dbt staging for AR_DISTRIBUTIONS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.