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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed 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.
Problems that run through this table