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.

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_INVOICE_DISTRIBUTIONS_ALL?

We ship parameterized SQL, BICC config, and dbt models you own.

Talk to us