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