Oracle Fusion · Data dictionary
AP_INVOICE_DISTRIBUTIONS_ALL
PayablesUsed in 11 subject areas59 reporting columns
Payables (AP), invoice distributions. The accounting and project distributions per invoice line.
Primary key: INVOICE_DISTRIBUTION_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNTING_DATE | ● | Accounting date. | |
| ADJUSTMENT_REASON | ● | Adjustment reason. | |
| AMOUNT | ● | Amount. | |
| AMOUNT_AT_PREPAY_PAY_XRATE | ● | Amount at prepay pay xrate. | |
| AMOUNT_AT_PREPAY_XRATE | ● | Amount at prepay xrate. | |
| AMOUNT_VARIANCE | ● | Amount variance. | |
| ASSETS_ADDITION_FLAG | ● | Indicator (Y/N) for the assets addition. | |
| ASSETS_TRACKING_FLAG | ● | Indicator (Y/N) for the assets tracking. | |
| ASSET_BOOK_TYPE_CODE | ● | Code identifying the asset book type. | |
| AWT_FLAG | ● | Indicator (Y/N) for the awt. | |
| BASE_AMOUNT | ● | Base amount. | |
| BASE_AMOUNT_VARIANCE | ● | Base amount variance. | |
| BUDGET_DATE | ● | Budget date. | |
| CANCELLATION_FLAG | ● | Indicator (Y/N) for the cancellation. | |
| CORRECTED_QUANTITY | ● | Corrected quantity. | |
| DESCRIPTION | ● | Description. | |
| DISTRIBUTION_LINE_NUMBER | ● | Distribution line number. | |
| DIST_MATCH_TYPE | ● | Type of distribution match. | |
| EXCHANGE_DATE | ● | Exchange date. | |
| EXCHANGE_RATE | ● | Exchange rate. | |
| EXCHANGE_RATE_TYPE | ● | Type of exchange rate. | |
| FINAL_APPLICATION_ROUNDING | ● | Final application rounding. | |
| FINAL_MATCH_FLAG | ● | Indicator (Y/N) for the final match. | |
| FINAL_PAYMENT_ROUNDING | ● | Final payment rounding. | |
| FUNDS_STATUS | ● | Status of the funds. | |
| INCOME_TAX_REGION | ● | Income tax region. | |
| INTENDED_USE | ● | Intended use. | |
| INVENTORY_TRANSFER_STATUS | ● | Status of the inventory transfer. | |
| INVOICE_DISTRIBUTION_ID | PK | ● | Identifier for the invoice distribution. |
| INVOICE_INCLUDES_PREPAY_FLAG | ● | Indicator (Y/N) for the invoice includes prepay. | |
| INVOICE_LINE_NUMBER | ● | Invoice line number. | |
| LINE_TYPE_LOOKUP_CODE | ● | Lookup code for the line type. | |
| MATCHED_UOM_LOOKUP_CODE | ● | Lookup code for the matched unit of measure. | |
| MATCH_STATUS_FLAG | ● | Indicator (Y/N) for the match status. | |
| PA_ADDITION_FLAG | ● | Indicator (Y/N) for the pa addition. | |
| PA_CMT_XFACE_FLAG | ● | Indicator (Y/N) for the pa cmt xface. | |
| PA_QUANTITY | ● | Pa quantity. | |
| PERIOD_NAME | ● | Name of the period. | |
| PJC_EXPENDITURE_ITEM_DATE | ● | Pjc expenditure item date. | |
| POSTED_FLAG | ● | Indicator (Y/N) for the posted. | |
| PREPAY_AMOUNT_REMAINING | ● | Prepay amount remaining. | |
| PREPAY_TAX_DIFF_AMOUNT | ● | Prepay tax diff amount. | |
| QUANTITY_INVOICED | ● | Quantity invoiced. | |
| RCV_TRANSACTION_ID | ● | Identifier for the receiving transaction. | |
| RECOVERY_RATE_CODE | ● | Code identifying the recovery rate. | |
| RECOVERY_RATE_NAME | ● | Name of the recovery rate. | |
| RECOVERY_TYPE_CODE | ● | Code identifying the recovery type. | |
| REC_NREC_RATE | ● | Rec nrec rate. | |
| RELATED_ID | ● | Identifier for the related. | |
| REVERSAL_FLAG | ● | Indicator (Y/N) for the reversal. | |
| ROUNDING_AMT | ● | Rounding amount. | |
| TAXABLE_AMOUNT | ● | Taxable amount. | |
| TAXABLE_BASE_AMOUNT | ● | Taxable base amount. | |
| TAX_ALREADY_DISTRIBUTED_FLAG | ● | Indicator (Y/N) for the tax already distributed. | |
| TAX_RECOVERABLE_FLAG | ● | Indicator (Y/N) for the tax recoverable. | |
| TOTAL_DIST_AMOUNT | ● | Total distribution amount. | |
| TOTAL_DIST_BASE_AMOUNT | ● | Total distribution base amount. | |
| TYPE_1099 | ● | Type 1099. | |
| UNIT_PRICE | ● | Unit price. |
27 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 AP_INVOICE_DISTRIBUTIONS_ALL.
- Oracle Fusion AP Aging Report
- AP Invoice Detail Report
- India Creditors Ledger Report
- India eTDS Data Report
- Supplier Balance by Account Report
- Supplier Subledger Balance by Account Report
- Withholding Tax by Supplier Report
- Projects Transactions Dashboard Report
- Payables to Ledger Reconciliation Report
- Payables Invoice Register
- Payables Credit Memo Matching Report
- Payables Matched and Modified Receipts Report
- Payables Matching Detail Report
- Payables Matching Hold Detail Report
- Payables Posted Invoice Register
- Payables Trial Balance Report
- Prepayment Remittance Notice
- Payables Withholding Tax Report
- Payables Withholding Tax by Tax Authority Report
- Payables Withholding Tax Letter
- US 1099 Report
- US 1099 Payments Report
- US 1099 Invoice Exceptions Report
- US 1096 Report
- US 1099 Electronic Media Report
- Update and Report Income Tax Details
- Mass Additions 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.
- Budgetary Control - Transactions Real Time
- Costing - Cost Accounting Real Time
- Costing - Fiscal Document Capture Transactions Real Time
- Costing - Receipt Accounting Real Time
- Fixed Assets - Asset Source Lines Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
- Payables Payments - Disbursements Real Time
- Procurement - Procure To Pay Real Time
- Procurement - Spend Real Time
- Supplier Portal - Invoice Real Time
Need the extract + dbt staging for AP_INVOICE_DISTRIBUTIONS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table