indexes, Oracle Fusion, Oracle Fusion Finance, Table Structure

AP_INVOICE_DISTRIBUTIONS_ALL: Table Details

AP_INVOICE_DISTRIBUTIONS_ALL is the child table of AP_INVOICE_LINES_ALL and more or less can be used to find the GL Code Combinations used by the invoice line. To connect AP_INVOICE_LINES_ALL table with AP_INVOICE_DISTRIBUTIONS_ALL, use the column INVOICE_ID in conjunction with INVOICE_LINE_NUMBER. Of course INVOICE_ID is the primary key of Invoice Table. So we can say that this table AP_INVOICE_DISTRIBUTIONS_ALL plays a critical role in P2P Cycle in Oracle.

AP_INVOICE_DISTRIBUTIONS_ALL can also be used to find the connectivity between AP invoice & PO or AP invoices & Project. But keep an eye on column quantity_invoiced. As every AP invoice Line can be made of multiple PO Distributions or tasks, this table can give specific amount from PO Distribution or task.

(By the way, I was helped by this book a great deal, just in case you want to refer. No no.. I am neither the author nor the publisher of this book. )

Table Structure

COLUMN_NAMEDATA_TYPENULLABLE
 ACCOUNTING_DATEDATE
 ASSETS_ADDITION_FLAGVARCHAR2(4)
 ASSETS_TRACKING_FLAGVARCHAR2(4)
 DISTRIBUTION_LINE_NUMBERNUMBER
 DIST_CODE_COMBINATION_IDNUMBER
 INVOICE_IDNUMBER
 LAST_UPDATED_BYVARCHAR2(256)
 LAST_UPDATE_DATETIMESTAMP(6)
 LINE_TYPE_LOOKUP_CODEVARCHAR2(100)
 PERIOD_NAMEVARCHAR2(60)
 SET_OF_BOOKS_IDNUMBER
 AMOUNTNUMBER
 BASE_AMOUNTNUMBER
 BATCH_IDNUMBER
 CREATED_BYVARCHAR2(256)
 CREATION_DATETIMESTAMP(6)
 DESCRIPTIONVARCHAR2(960)
 FINAL_MATCH_FLAGVARCHAR2(4)
 INCOME_TAX_REGIONVARCHAR2(40)
 LAST_UPDATE_LOGINVARCHAR2(128)
 MATCH_STATUS_FLAGVARCHAR2(4)
 POSTED_FLAGVARCHAR2(4)
 PO_DISTRIBUTION_IDNUMBER
 PROGRAM_APPLICATION_IDNUMBER
 PROGRAM_IDNUMBER
 PROGRAM_UPDATE_DATEDATE
 QUANTITY_INVOICEDNUMBER
 REQUEST_IDNUMBER
 REVERSAL_FLAGVARCHAR2(4)
 TYPE_1099VARCHAR2(40)
 UNIT_PRICENUMBER
 ENCUMBERED_FLAGVARCHAR2(4)
 STAT_AMOUNTNUMBER
 ATTRIBUTE1 – ATTRIBUTE15VARCHAR2(600)
 ATTRIBUTE_CATEGORYVARCHAR2(600)
 EXPENDITURE_ITEM_DATEDATE
 EXPENDITURE_ORGANIZATION_IDNUMBER
 EXPENDITURE_TYPEVARCHAR2(120)
 PARENT_INVOICE_IDNUMBER
 PA_ADDITION_FLAGVARCHAR2(4)
 PA_QUANTITYNUMBER
 PREPAY_AMOUNT_REMAININGNUMBER
 PROJECT_IDNUMBER
 TASK_IDNUMBER
 AWT_FLAGVARCHAR2(4)
 AWT_GROUP_IDNUMBER
 AWT_TAX_RATE_IDNUMBER
 AWT_GROSS_AMOUNTNUMBER
 AWT_INVOICE_IDNUMBER
 AWT_ORIGIN_GROUP_IDNUMBER
 REFERENCE_1VARCHAR2(120)
 REFERENCE_2VARCHAR2(120)
 ORG_IDNUMBER
 AWT_INVOICE_PAYMENT_IDNUMBER
 GLOBAL_ATTRIBUTE_CATEGORYVARCHAR2(600)
 GLOBAL_ATTRIBUTE1 –  GLOBAL_ATTRIBUTE20VARCHAR2(600)
 RECEIPT_VERIFIED_FLAGVARCHAR2(4)
 RECEIPT_REQUIRED_FLAGVARCHAR2(4)
 RECEIPT_MISSING_FLAGVARCHAR2(4)
 JUSTIFICATIONVARCHAR2(960)
 EXPENSE_GROUPVARCHAR2(320)
 START_EXPENSE_DATEDATE
 END_EXPENSE_DATEDATE
 RECEIPT_CURRENCY_CODEVARCHAR2(60)
 RECEIPT_CONVERSION_RATENUMBER
 RECEIPT_CURRENCY_AMOUNTNUMBER
 DAILY_AMOUNTNUMBER
 WEB_PARAMETER_IDNUMBER
 ADJUSTMENT_REASONVARCHAR2(960)
 AWARD_IDNUMBER
 CREDIT_CARD_TRX_IDNUMBER
 DIST_MATCH_TYPEVARCHAR2(100)
 RCV_TRANSACTION_IDNUMBER
 INVOICE_DISTRIBUTION_IDNUMBER
 PARENT_REVERSAL_IDNUMBER
 TAX_RECOVERABLE_FLAGVARCHAR2(4)
 MERCHANT_DOCUMENT_NUMBERVARCHAR2(320)
 MERCHANT_NAMEVARCHAR2(320)
 MERCHANT_REFERENCEVARCHAR2(960)
 MERCHANT_TAX_REG_NUMBERVARCHAR2(320)
 MERCHANT_TAXPAYER_IDVARCHAR2(320)
 COUNTRY_OF_SUPPLYVARCHAR2(20)
 MATCHED_UOM_LOOKUP_CODEVARCHAR2(100)
 GMS_BURDENABLE_RAW_COSTNUMBER
 ACCOUNTING_EVENT_IDNUMBER
 PREPAY_DISTRIBUTION_IDNUMBER
 UPGRADE_POSTED_AMTNUMBER
 UPGRADE_BASE_POSTED_AMTNUMBER
 INVENTORY_TRANSFER_STATUSVARCHAR2(4)
 COMPANY_PREPAID_INVOICE_IDNUMBER
 CC_REVERSAL_FLAGVARCHAR2(4)
 INVOICE_INCLUDES_PREPAY_FLAGVARCHAR2(4)
 PA_CMT_XFACE_FLAGVARCHAR2(4)
 CANCELLATION_FLAGVARCHAR2(4)
 INVOICE_LINE_NUMBERNUMBER
 CORRECTED_INVOICE_DIST_IDNUMBER
 ROUNDING_AMTNUMBER
 CHARGE_APPLICABLE_TO_DIST_IDNUMBER
 CORRECTED_QUANTITYNUMBER
 RELATED_IDNUMBER
 ASSET_BOOK_TYPE_CODEVARCHAR2(120)
 ASSET_CATEGORY_IDNUMBER
 DISTRIBUTION_CLASSVARCHAR2(120)
 FINAL_PAYMENT_ROUNDINGNUMBER
 FINAL_APPLICATION_ROUNDINGNUMBER
 AMOUNT_AT_PREPAY_XRATENUMBER
 CASH_BASIS_FINAL_APP_ROUNDINGNUMBER
 AMOUNT_AT_PREPAY_PAY_XRATENUMBER
 INTENDED_USEVARCHAR2(120)
 INTENDED_USE_CLASSIF_IDNUMBER
 DETAIL_TAX_DIST_IDNUMBER
 REC_NREC_RATENUMBER
 RECOVERY_RATE_IDNUMBER
 RECOVERY_RATE_NAMEVARCHAR2(600)
 RECOVERY_TYPE_CODEVARCHAR2(120)
 RECOVERY_RATE_CODEVARCHAR2(120)
 WITHHOLDING_TAX_CODE_IDNUMBER
 TAX_ALREADY_DISTRIBUTED_FLAGVARCHAR2(4)
 SUMMARY_TAX_LINE_IDNUMBER
 TAXABLE_AMOUNTNUMBER
 TAXABLE_BASE_AMOUNTNUMBER
 EXTRA_PO_ERVNUMBER
 PREPAY_TAX_DIFF_AMOUNTNUMBER
 TAX_CODE_IDNUMBER
 TOTAL_DIST_AMOUNTNUMBER
 TOTAL_DIST_BASE_AMOUNTNUMBER
 OLD_DISTRIBUTION_IDNUMBER
 OLD_DIST_LINE_NUMBERNUMBER
 AMOUNT_VARIANCENUMBER
 BASE_AMOUNT_VARIANCENUMBER
 HISTORICAL_FLAGVARCHAR2(4)
 RCV_CHARGE_ADDITION_FLAGVARCHAR2(4)
 AWT_RELATED_IDNUMBER
 RELATED_RETAINAGE_DIST_IDNUMBER
 RETAINED_AMOUNT_REMAININGNUMBER
 BC_EVENT_IDNUMBER
 RETAINED_INVOICE_DIST_IDNUMBER
 FINAL_RELEASE_ROUNDINGNUMBER
 FULLY_PAID_ACCTD_FLAGVARCHAR2(4)
 ROOT_DISTRIBUTION_IDNUMBER
 XINV_PARENT_REVERSAL_IDNUMBER
 RECURRING_PAYMENT_IDNUMBER
 RELEASE_INV_DIST_DERIVED_FROMNUMBER
 QUANTITY_VARIANCENUMBER
 BASE_QUANTITY_VARIANCENUMBER
 EXCHANGE_RATE_TYPEVARCHAR2(120)
 EXCHANGE_RATENUMBER
 EXCHANGE_DATEDATE
 PJC_CONTEXT_CATEGORYVARCHAR2(160)
 PJC_PROJECT_IDNUMBER
 PJC_TASK_IDNUMBER
 PJC_EXPENDITURE_TYPE_IDNUMBER
 PJC_EXPENDITURE_ITEM_DATEDATE
 PJC_ORGANIZATION_IDNUMBER
 PJC_BILLABLE_FLAGVARCHAR2(4)
 PJC_CAPITALIZABLE_FLAGVARCHAR2(4)
 PJC_WORK_TYPE_IDNUMBER
 PJC_CONTRACT_IDNUMBER
 PJC_CONTRACT_LINE_IDNUMBER
 PJC_FUNDING_ALLOCATION_IDNUMBER
 PJC_RESERVED_ATTRIBUTE1VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE2VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE3VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE4VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE5VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE6VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE7VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE8VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE9VARCHAR2(600)
 PJC_RESERVED_ATTRIBUTE10VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE1VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE2VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE3VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE4VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE5VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE6VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE7VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE8VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE9VARCHAR2(600)
 PJC_USER_DEF_ATTRIBUTE10VARCHAR2(600)
 ATTRIBUTE_NUMBER1 –  ATTRIBUTE_NUMBER5NUMBER
 GLOBAL_ATTRIBUTE_NUMBER1 –  GLOBAL_ATTRIBUTE_NUMBER5NUMBER
 GLOBAL_ATTRIBUTE_DATE1 – GLOBAL_ATTRIBUTE_DATE5DATE
 OBJECT_VERSION_NUMBERNUMBER
 JOB_DEFINITION_NAMEVARCHAR2(400)
 JOB_DEFINITION_PACKAGEVARCHAR2(3600)
 BUDGET_DATEDATE
 FUNDS_STATUSVARCHAR2(120)
 CONSUMPTION_ADVICE_HEADER_IDNUMBER
 CONSUMPTION_ADVICE_LINE_IDNUMBER
 DATA_SET_IDNUMBER
 DETAIL_TAX_LINE_IDNUMBER
 PRODUCT_TABLEVARCHAR2(120)
 REFERENCE_KEY1VARCHAR2(600)
 REFERENCE_KEY2VARCHAR2(600)
 REFERENCE_KEY3VARCHAR2(600)
 REFERENCE_KEY4VARCHAR2(600)
 REFERENCE_KEY5VARCHAR2(600)
 DEF_ACCTG_ACCRUAL_CCIDNUMBER
 DEF_ACCTG_START_DATEDATE
 DEF_ACCTG_END_DATEDATE
Table Structure: AP_INVOICE_DISTRIBUTIONS_ALL

Indexes

INDEX_NAMEINDEX_TYPEUNIQUENESSCOLUMN NAME
 AP_INVOICE_DISTRIBUTIONS_N12NORMALNONUNIQUEPARENT_INVOICE_ID
 AP_INVOICE_DISTRIBUTIONS_N13NORMALNONUNIQUEPJC_PROJECT_ID
 AP_INVOICE_DISTRIBUTIONS_N13NORMALNONUNIQUEPJC_TASK_ID
 AP_INVOICE_DISTRIBUTIONS_N14NORMALNONUNIQUEPA_ADDITION_FLAG
 AP_INVOICE_DISTRIBUTIONS_N14NORMALNONUNIQUEPJC_PROJECT_ID
 AP_INVOICE_DISTRIBUTIONS_N14NORMALNONUNIQUEREQUEST_ID
 AP_INVOICE_DISTRIBUTIONS_N15NORMALNONUNIQUEAWT_INVOICE_PAYMENT_ID
 AP_INVOICE_DISTRIBUTIONS_N16NORMALNONUNIQUEAWT_INVOICE_ID
 AP_INVOICE_DISTRIBUTIONS_N17NORMALNONUNIQUERCV_TRANSACTION_ID
 AP_INVOICE_DISTRIBUTIONS_N18NORMALNONUNIQUEACCOUNTING_EVENT_ID
 AP_INVOICE_DISTRIBUTIONS_N19NORMALNONUNIQUEINVENTORY_TRANSFER_STATUS
 AP_INVOICE_DISTRIBUTIONS_N19NORMALNONUNIQUEORG_ID
 AP_INVOICE_DISTRIBUTIONS_N2NORMALNONUNIQUEPOSTED_FLAG
 AP_INVOICE_DISTRIBUTIONS_N2NORMALNONUNIQUEORG_ID
 AP_INVOICE_DISTRIBUTIONS_N20NORMALNONUNIQUEPREPAY_DISTRIBUTION_ID
 AP_INVOICE_DISTRIBUTIONS_N23NORMALNONUNIQUERELATED_ID
 AP_INVOICE_DISTRIBUTIONS_N23NORMALNONUNIQUEINVOICE_ID
 AP_INVOICE_DISTRIBUTIONS_N23NORMALNONUNIQUEAMOUNT
 AP_INVOICE_DISTRIBUTIONS_N24NORMALNONUNIQUECORRECTED_INVOICE_DIST_ID
 AP_INVOICE_DISTRIBUTIONS_N25NORMALNONUNIQUEPARENT_REVERSAL_ID
 AP_INVOICE_DISTRIBUTIONS_N28NORMALNONUNIQUECHARGE_APPLICABLE_TO_DIST_ID
 AP_INVOICE_DISTRIBUTIONS_N29NORMALNONUNIQUEDETAIL_TAX_DIST_ID
 AP_INVOICE_DISTRIBUTIONS_N3NORMALNONUNIQUEDIST_CODE_COMBINATION_ID
 AP_INVOICE_DISTRIBUTIONS_N30NORMALNONUNIQUEBC_EVENT_ID
 AP_INVOICE_DISTRIBUTIONS_N31NORMALNONUNIQUEASSETS_ADDITION_FLAG
 AP_INVOICE_DISTRIBUTIONS_N31NORMALNONUNIQUEPOSTED_FLAG
 AP_INVOICE_DISTRIBUTIONS_N31NORMALNONUNIQUESET_OF_BOOKS_ID
 AP_INVOICE_DISTRIBUTIONS_N31NORMALNONUNIQUEASSETS_TRACKING_FLAG
 AP_INVOICE_DISTRIBUTIONS_N31NORMALNONUNIQUELINE_TYPE_LOOKUP_CODE
 AP_INVOICE_DISTRIBUTIONS_N31NORMALNONUNIQUEACCOUNTING_DATE
 AP_INVOICE_DISTRIBUTIONS_N32NORMALNONUNIQUEINVOICE_ID
 AP_INVOICE_DISTRIBUTIONS_N32NORMALNONUNIQUEINVOICE_LINE_NUMBER
 AP_INVOICE_DISTRIBUTIONS_N32NORMALNONUNIQUEORG_ID
 AP_INVOICE_DISTRIBUTIONS_N33NORMALNONUNIQUEINVOICE_ID
 AP_INVOICE_DISTRIBUTIONS_N33NORMALNONUNIQUECANCELLATION_FLAG
 AP_INVOICE_DISTRIBUTIONS_N33NORMALNONUNIQUEMATCH_STATUS_FLAG
 AP_INVOICE_DISTRIBUTIONS_N4NORMALNONUNIQUEACCOUNTING_DATE
 AP_INVOICE_DISTRIBUTIONS_N6NORMALNONUNIQUEASSETS_ADDITION_FLAG
 AP_INVOICE_DISTRIBUTIONS_N6NORMALNONUNIQUEASSETS_TRACKING_FLAG
 AP_INVOICE_DISTRIBUTIONS_N6NORMALNONUNIQUEPOSTED_FLAG
 AP_INVOICE_DISTRIBUTIONS_N6NORMALNONUNIQUEORG_ID
 AP_INVOICE_DISTRIBUTIONS_N7NORMALNONUNIQUEPO_DISTRIBUTION_ID
 AP_INVOICE_DISTRIBUTIONS_U1NORMALUNIQUEINVOICE_ID
 AP_INVOICE_DISTRIBUTIONS_U1NORMALUNIQUEINVOICE_LINE_NUMBER
 AP_INVOICE_DISTRIBUTIONS_U1NORMALUNIQUEDISTRIBUTION_LINE_NUMBER
 AP_INVOICE_DISTRIBUTIONS_U2NORMALUNIQUEINVOICE_DISTRIBUTION_ID
Indexes

Related Posts

AP Invoices Table Structure
AP_invoice_Lines_all Table structure

Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.

Reference:
support.oracle.com

Check out the Amazon Deals of the day based on your interests..

How useful was this post?

Click on a star to rate it!

Average rating 3 / 5. Vote count: 2

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?