eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AP.AP_INVOICE_DISTRIBUTIONS_ALL

Object Details

Object Name:	AP_INVOICE_DISTRIBUTIONS_ALL
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_INVOICE_DISTRIBUTIONS_ALL
Subobject Name:
Status:	VALID

AP_INVOICE_DISTRIBUTIONS_ALL holds the distribution information that is manually entered or system-generated. This table corresponds to the Invoice distributions window of Invoice workbench.
There is one row for each invoice distribution. A distribution must be associated with an invoice and invoice line. An invoice / invoice line can have multiple distributions. Examples of when your Oracle Payables application automatically creates rows in this table include the following:
� Distribution set is entered at the invoice header level or invoice lines level.
� Invoice line matched to a purchase order or receipt. The system uses the information from the matched purchase order or receipt to create the distributions
� Invoice matched to an credit or debit memo
� Allocation rules are defined for Tax, Freight & Misc lines
� Apply or Unapply prepayment on an invoice
� Payables automatically calculate withholding tax.
� Payables create an interest invoice.
When an invoice is accounted, the Accounting Process creates accounting events, accounting entry headers and accounting entry lines for those distributions that have accounting dates included in the selected accounting date range. The Transfer to General Ledger process can then transfer the accounting entries to General Ledger as journal entries.
Values for POSTED_FLAG are Y for accounted distributions or N for unaccounted distributions. Invoice distributions can be interfaced over/from Oracle Assets or Oracle Projects. Oracle Payables application sets the ASSETS_ADDITION_FLAG to U for distributions not tested by Oracle Assets; Oracle Assets then adjusts this flag after it tests a distribution for assignment as an asset.
To avoid the same invoice distribution being interfaced to Oracle Project and Oracle Assets, any project-related invoice distributions should be interfaced to Oracle projects first before interfacing to Oracle Assets. If a project-related invoice distribution is charged to a capital project in Oracle Projects, Oracle Projects sets the ASSETS_ADDITION_FLAG to P when the PA_ADDITION_FLAG is set to Y, Z, or T. Oracle Assets only picks up invoice distributions with the ASSET_ADDITION_FLAG set to U, and if project-related, with the PA_ADDITION_FLAG set to Y, Z, or T. PA_ADDITION_FLAG tracks the status of project-related supplier invoice distributions and expense report distributions.
For supplier invoice distributions entered via Oracle Payables, the PA_ADDITION_FLAG is set to N if the distribution is project-related, otherwise it is set to E, and it is updated by Oracle Projects when the distribution is processed by the Oracle Projects Interface Supplier Invoice process. Oracle Projects sets the PA_ADDITION_FLAG to Y or Z after the item is successfully processed, or may be set to a rejection code if the line is rejected during transfer to Oracle Projects.
All rejects can be found in Payables Lookup listing. Retransfer of the line can be done after correcting the rejection reason.
For supplier invoice adjustment distributions interfaced from Oracle Projects to Oracle Payables (which must net to zero with another distribution), the value for the PA_ADDITION_FLAG is set to T.
The accounting code combinations stored in this table is meta data for creating accounting entries in Subledger Accounting. Payables provides the code combinations stored in this table to Subledger Accounting as a source for accounting attributes for deriving the accounting code combinations. Subledger Accounting generates the final accounting entries that are posted to General Ledger. The accounting code combination used in the final accounting entries can be same as that stored in AP_INVOICE_DISTRIBUTIONS_ALL table or can

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_INVOICE_DISTRIBUTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVOICE_ID INVOICE_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
AP_INVOICE_DISTRIBUTIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVOICE_DISTRIBUTION_ID
AP_INVOICE_DISTRIBUTIONS_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID TASK_ID
AP_INVOICE_DISTRIBUTIONS_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PA_ADDITION_FLAG PROJECT_ID REQUEST_ID
AP_INVOICE_DISTRIBUTIONS_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWT_INVOICE_PAYMENT_ID
AP_INVOICE_DISTRIBUTIONS_N16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWT_INVOICE_ID
AP_INVOICE_DISTRIBUTIONS_N17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RCV_TRANSACTION_ID
AP_INVOICE_DISTRIBUTIONS_N18	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNTING_EVENT_ID
AP_INVOICE_DISTRIBUTIONS_N19	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_TRANSFER_STATUS
AP_INVOICE_DISTRIBUTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSTED_FLAG ORG_ID
AP_INVOICE_DISTRIBUTIONS_N20	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PREPAY_DISTRIBUTION_ID
AP_INVOICE_DISTRIBUTIONS_N21	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_ID
AP_INVOICE_DISTRIBUTIONS_N23	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RELATED_ID
AP_INVOICE_DISTRIBUTIONS_N24	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CORRECTED_INVOICE_DIST_ID
AP_INVOICE_DISTRIBUTIONS_N25	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_REVERSAL_ID
AP_INVOICE_DISTRIBUTIONS_N26	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OLD_DISTRIBUTION_ID
AP_INVOICE_DISTRIBUTIONS_N27	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_ID OLD_DIST_LINE_NUMBER
AP_INVOICE_DISTRIBUTIONS_N28	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHARGE_APPLICABLE_TO_DIST_ID
AP_INVOICE_DISTRIBUTIONS_N29	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DETAIL_TAX_DIST_ID
AP_INVOICE_DISTRIBUTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DIST_CODE_COMBINATION_ID
AP_INVOICE_DISTRIBUTIONS_N30	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BC_EVENT_ID
AP_INVOICE_DISTRIBUTIONS_N31	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSETS_ADDITION_FLAG POSTED_FLAG SET_OF_BOOKS_ID ACCOUNTING_DATE
AP_INVOICE_DISTRIBUTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNTING_DATE
AP_INVOICE_DISTRIBUTIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID
AP_INVOICE_DISTRIBUTIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSETS_ADDITION_FLAG ASSETS_TRACKING_FLAG POSTED_FLAG ORG_ID
AP_INVOICE_DISTRIBUTIONS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_DISTRIBUTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNTING_DATE	DATE		Yes	Accounting date
ACCRUAL_POSTED_FLAG	VARCHAR2	(1)		Accrual accounting status of the distribution. Values may be: Y if distribution has been accounted and system is set up for accrual basis accounting, or N if either the distribution has not been accounted or accrual basis accounting is not used.
ASSETS_ADDITION_FLAG	VARCHAR2	(1)	Yes	Flag that indicates if distribution has been transferred into Oracle Assets (U, Y, or N)
ASSETS_TRACKING_FLAG	VARCHAR2	(1)	Yes	Flag that indicates if distribution is tracked in Oracle Assets. Possible values are Y or N
CASH_POSTED_FLAG	VARCHAR2	(1)		Cash basis accounting status of the distribution. Values may be: Y if distribution has been accounted and the system is set up for cash basis accounting, N if either the distribution has not been accounted or system is not set up for cash basis accounting, or P if distribution has been partially accounted in the cash set of books
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)	Yes	Distribution number for an invoice line. This is unique sequence per invoice line.
DIST_CODE_COMBINATION_ID	NUMBER	(15)	Yes	Accounting Flexfield identifier for account associated with a distribution. Foreign key from the GL_CODE_COMBINATIONS table.
INVOICE_ID	NUMBER	(15)	Yes	Unique internal identifier for the invoice line of the associated Invoice. Foreign key to the AP_INVOICES_ALL table.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LINE_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes	Distribution type. Validated against AP_LOOKUP_CODES. Lookup type is INVOICE DISTRIBUTION TYPE
PERIOD_NAME	VARCHAR2	(15)	Yes	Accounting period name, foreign key from the GL_PERIODS table.
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Ledger unique identifer
ACCTS_PAY_CODE_COMBINATION_ID	NUMBER	(15)		No longer used
AMOUNT	NUMBER			Invoice distribution amount
BASE_AMOUNT	NUMBER			Distribution amount in functional currency. This column gets populated for the invoice entered in non-functional currency and this column corresponds to the 'Functional Amount' field of Invoice Distribution window.
BASE_INVOICE_PRICE_VARIANCE	NUMBER			No longer used
BATCH_ID	NUMBER	(15)		Invoice Batch Identifier. This column will be populated if Invoices are entered in batches. Foreign key to the AP_BATCHES_ALL table.
CREATED_BY	NUMBER	(15)		Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table.
CREATION_DATE	DATE			Standard who column - date when this row was created.
DESCRIPTION	VARCHAR2	(240)		Distribution line description
EXCHANGE_RATE_VARIANCE	NUMBER			No longer used
FINAL_MATCH_FLAG	VARCHAR2	(1)		Final match indicator for distribution matched to a purchase order
INCOME_TAX_REGION	VARCHAR2	(10)		Reporting region for distribution for 1099 supplier
INVOICE_PRICE_VARIANCE	NUMBER			No longer used
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table.
MATCH_STATUS_FLAG	VARCHAR2	(1)		Validation status for the distribution. This flag is used to derive Invoice Status. Possible values for this flag:� Null or N for invoice distributions that are not tested and validated, T for distributions that have been tested, A for distributions that have been tested and validated, S for distributions that have been selected for validation
POSTED_FLAG	VARCHAR2	(1)		Flag that indicates if invoice distribution line has been accounted. Valid values are 'Y' or 'N'.
PO_DISTRIBUTION_ID	NUMBER	(15)		Purchase order distribution identifier for purchase order or receipt matched invoice distributions. Foreign key to the PO_DISTRIBUTIONS_ALL table.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Enhanced Who column Concurrent Program who column - application id of the program that last updated this row. Foreign key to the APPLICATION_ID column of the FND_APPLICATION table.
PROGRAM_ID	NUMBER	(15)		Enhanced Who column Concurrent Program who column - program id of the program that last updated this row. Foreign key to the CONCURRENT_PROGRAM_ID column of the FND_CONCURRENT_PROGRAM table.
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row.
QUANTITY_INVOICED	NUMBER			Quantity billed for purchase order or receipt matched invoice distributions
RATE_VAR_CODE_COMBINATION_ID	NUMBER	(15)		No longer used
REQUEST_ID	NUMBER	(15)		Enhanced Who column Concurrent Program who column - concurrent request id of the program that last updated this row. Foreign key to the REQUEST_ID column of the FND_CONCURRENT_REQUESTS table.
REVERSAL_FLAG	VARCHAR2	(1)		Flag that indicates if distribution is part of a reversal pair
TYPE_1099	VARCHAR2	(10)		Income tax type, for 1099 reporting purposes. This column corresponds to 'Income Tax Type' field in Invoice Distributions window.
UNIT_PRICE	NUMBER			Unit price for purchase order, receipt matched invoice distributions, and price or quantity corrections
AMOUNT_ENCUMBERED	NUMBER			No longer used
BASE_AMOUNT_ENCUMBERED	NUMBER			No longer used
ENCUMBERED_FLAG	VARCHAR2	(1)		Flag indicating encumbrance status of distribution
EXCHANGE_DATE	DATE			No longer used
EXCHANGE_RATE	NUMBER			No longer used
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		No longer used
PRICE_ADJUSTMENT_FLAG	VARCHAR2	(1)		No longer used
PRICE_VAR_CODE_COMBINATION_ID	NUMBER	(15)		No longer used
QUANTITY_UNENCUMBERED	NUMBER			No longer used
STAT_AMOUNT	NUMBER			Amount associated with a distribution for measuring statistical quantities
AMOUNT_TO_POST	NUMBER			No longer used
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield structure definition column.
BASE_AMOUNT_TO_POST	NUMBER			No longer used
CASH_JE_BATCH_ID	NUMBER	(15)		No longer used
EXPENDITURE_ITEM_DATE	DATE			Date for project expenditure item used to build Accounting Flexfield for project-related distribution
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)		Identifier for project organization used to build Accounting Flexfield for project-related distribution
EXPENDITURE_TYPE	VARCHAR2	(30)		Project expenditure type used to build Accounting Flexfield for project-related distribution
JE_BATCH_ID	NUMBER	(15)		No longer used
PARENT_INVOICE_ID	NUMBER	(15)		Identifier for invoice matched to a credit or debit memo
PA_ADDITION_FLAG	VARCHAR2	(1)		Flag that indicates if project related invoice distributions have been transferred into Oracle Projects
PA_QUANTITY	NUMBER	(22)		Project item quantity used to build Accounting Flexfield for project-related distribution
POSTED_AMOUNT	NUMBER			No longer used
POSTED_BASE_AMOUNT	NUMBER			No longer used
PREPAY_AMOUNT_REMAINING	NUMBER			Amount of prepayment that can still be applied to an invoice
PROJECT_ACCOUNTING_CONTEXT	VARCHAR2	(30)		No longer used
PROJECT_ID	NUMBER	(15)		Identifier for project used to build Accounting Flexfield for project-related distribution
TASK_ID	NUMBER	(15)		Identifier for project task used to build Accounting Flexfield for project-related distribution
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		No longer used
USSGL_TRX_CODE_CONTEXT	VARCHAR2	(30)		No longer used
EARLIEST_SETTLEMENT_DATE	DATE			No longer used
REQ_DISTRIBUTION_ID	NUMBER	(15)		No longer used
QUANTITY_VARIANCE	NUMBER			No longer used
BASE_QUANTITY_VARIANCE	NUMBER			No longer used
PACKET_ID	NUMBER	(15)		Budgetary control packet identifier for distributions that fail funds checking
AWT_FLAG	VARCHAR2	(1)		Flag to determine if distribution is subject to withholding tax (Y, N, null)
AWT_GROUP_ID	NUMBER	(15)		Withholding Tax group identifier at Invoice Validation. This column corresponds to 'Invoice Withholding Tax Group'
AWT_TAX_RATE_ID	NUMBER	(15)		Withholding tax rate identifier
AWT_GROSS_AMOUNT	NUMBER			Amount subject to withholding tax
AWT_INVOICE_ID	NUMBER	(15)		Refers to the withholding tax invoice created from this distribution
AWT_ORIGIN_GROUP_ID	NUMBER	(15)		Foreign key to AP_AWT_GROUPS; refers to the parent withholding tax group; this column is only populated for automatically created withholding tax distributions
REFERENCE_1	VARCHAR2	(30)		Reference information from Oracle Projects expense reports or other external source invoice loading program
REFERENCE_2	VARCHAR2	(30)		Reference information from Oracle Projects expense reports or other external source invoice loading program
ORG_ID	NUMBER	(15)		Unique internal identifier of the Operating Unit to which the invoice belongs.
OTHER_INVOICE_ID	NUMBER	(15)		No longer used
AWT_INVOICE_PAYMENT_ID	NUMBER	(15)		Refers to the parent invoice payment. This column is populated only for automatically created withholding tax distributions at payment time
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
LINE_GROUP_NUMBER	NUMBER	(15)		No longer used
RECEIPT_VERIFIED_FLAG	VARCHAR2	(1)		Indicates whether payables department verified the receipt for the expense line. Used for expense reports.
RECEIPT_REQUIRED_FLAG	VARCHAR2	(1)		Indicates whether payables department requires that a receipt be sent to them for the expense line. Used for expense reports.
RECEIPT_MISSING_FLAG	VARCHAR2	(1)		Indicates whether the employee does not possess a receipt for an expense line. Used for expense reports.
JUSTIFICATION	VARCHAR2	(240)		Expense justification given while submitting expense report.
EXPENSE_GROUP	VARCHAR2	(80)		Expense group: User-defined label used to identify a group of expense lines contained on a single receipt, for example, a hotel bill.
START_EXPENSE_DATE	DATE			Date when incurred expense started. Used for Expense Reports
END_EXPENSE_DATE	DATE			Date when incurred expense ended. Used for Expense Reports
RECEIPT_CURRENCY_CODE	VARCHAR2	(15)		Currency code of receipt. Used for Expense Reports
RECEIPT_CONVERSION_RATE	NUMBER			Exchange rate for currency of receipt. Used for Expense Reports
RECEIPT_CURRENCY_AMOUNT	NUMBER			Amount in receipt currency. Used for Expense Reports
DAILY_AMOUNT	NUMBER			Daily expense amount. Used for Expense Reports
WEB_PARAMETER_ID	NUMBER			Self-Service Web Applications parameter identifier. Used by self service applications like iExpenses.
ADJUSTMENT_REASON	VARCHAR2	(240)		Reason for expense adjustment
AWARD_ID	NUMBER	(15)		If Oracle Grants Accounting is installed, the award ID is used with data in project columns to track grant information
MRC_ACCRUAL_POSTED_FLAG	VARCHAR2	(2000)
MRC_CASH_POSTED_FLAG	VARCHAR2	(2000)
MRC_DIST_CODE_COMBINATION_ID	VARCHAR2	(2000)		No longer used
MRC_AMOUNT	VARCHAR2	(2000)
MRC_BASE_AMOUNT	VARCHAR2	(2000)		No longer used
MRC_BASE_INV_PRICE_VARIANCE	VARCHAR2	(2000)		No longer used
MRC_EXCHANGE_RATE_VARIANCE	VARCHAR2	(2000)		No longer used
MRC_POSTED_FLAG	VARCHAR2	(2000)
MRC_PROGRAM_APPLICATION_ID	VARCHAR2	(2000)
MRC_PROGRAM_ID	VARCHAR2	(2000)
MRC_PROGRAM_UPDATE_DATE	VARCHAR2	(2000)
MRC_RATE_VAR_CCID	VARCHAR2	(2000)		No longer used
MRC_REQUEST_ID	VARCHAR2	(2000)
MRC_EXCHANGE_DATE	VARCHAR2	(2000)		No longer used
MRC_EXCHANGE_RATE	VARCHAR2	(2000)		No longer used
MRC_EXCHANGE_RATE_TYPE	VARCHAR2	(2000)		No longer used
MRC_AMOUNT_TO_POST	VARCHAR2	(2000)
MRC_BASE_AMOUNT_TO_POST	VARCHAR2	(2000)
MRC_CASH_JE_BATCH_ID	VARCHAR2	(2000)
MRC_JE_BATCH_ID	VARCHAR2	(2000)
MRC_POSTED_AMOUNT	VARCHAR2	(2000)
MRC_POSTED_BASE_AMOUNT	VARCHAR2	(2000)
MRC_RECEIPT_CONVERSION_RATE	VARCHAR2	(2000)		No longer used
CREDIT_CARD_TRX_ID	NUMBER	(15)		Identifies the credit card transaction from which the expense line is derived. This column is populated when credit card transactions for expense reports entered in Oracle Internet Expenses are exported.
DIST_MATCH_TYPE	VARCHAR2	(25)		Flag that indicates type of distribution match. Validated against AP_LOOKUP_CODES with lookup type as MATCH_STATUS
RCV_TRANSACTION_ID	NUMBER	(15)		Receipt identifier for receipt matched to invoice distributions. Foreign key to the RCV_TRANSACTIONS.
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Yes	Unique internal Identifier of the invoice distribution record. Generated using a database sequence.
PARENT_REVERSAL_ID	NUMBER	(15)		Invoice distribution identifier for distribution being reversed by the current distribution
TAX_RECOVERABLE_FLAG	VARCHAR2	(1)		Indicates whether this tax line is recoverable or not. Used for tax lines
PA_CC_AR_INVOICE_ID	NUMBER	(15)		No longer used
PA_CC_AR_INVOICE_LINE_NUM	NUMBER	(15)		No longer used
PA_CC_PROCESSED_CODE	VARCHAR2	(1)		No longer used
MERCHANT_DOCUMENT_NUMBER	VARCHAR2	(80)		Third party document number. Used for Expense Reports
MERCHANT_NAME	VARCHAR2	(80)		Third party name. Used for Expense Reports
MERCHANT_REFERENCE	VARCHAR2	(240)		Third party reference. Used for Expense Reports
MERCHANT_TAX_REG_NUMBER	VARCHAR2	(80)		Third party tax registration number. Used for Expense Reports
MERCHANT_TAXPAYER_ID	VARCHAR2	(80)		Third party tax identification number. Used for Expense Reports
COUNTRY_OF_SUPPLY	VARCHAR2	(5)		Country where services or goods were originated. Used for Expense Reports
MATCHED_UOM_LOOKUP_CODE	VARCHAR2	(25)		UOM used for the quantity invoiced during matching of this distributions
GMS_BURDENABLE_RAW_COST	NUMBER	(22)		Burdenable Raw Cost
ACCOUNTING_EVENT_ID	NUMBER	(15)		Accounting event identifier. Refers to the accounting event that accounted for the distribution. Foreign key to the XLA_EVENTS table.
PREPAY_DISTRIBUTION_ID	NUMBER	(15)		Invoice distribution identifier for the distribution on the prepayment that originated the prepayment application represented by the current distribution
UPGRADE_POSTED_AMT	NUMBER			This column is only used during the upgrade to create accounting entries for Cash basis accounting.
UPGRADE_BASE_POSTED_AMT	NUMBER			This column is only used during the upgrade to create accounting entries for Cash basis accounting.
INVENTORY_TRANSFER_STATUS	VARCHAR2	(1)		Inventory transfer status indicates whether the invoice distribution has been processed by the transfer invoice variance program. A value of 'N' indicates that the distribution has not been transferred. A value of NULL indicates that either the distribution was transferred or is not eligible for transfer to inventory valuation. The default value of this column at the time of distribution creation is 'N'
COMPANY_PREPAID_INVOICE_ID	NUMBER	(15)		Invoice ID when this line is an prepaid credit card transaction
CC_REVERSAL_FLAG	VARCHAR2	(1)		Invoice ID when this line is an prepaid credit card transaction
AWT_WITHHELD_AMT	NUMBER			No Longer Used
INVOICE_INCLUDES_PREPAY_FLAG	VARCHAR2	(1)		No longer used
PRICE_CORRECT_INV_ID	NUMBER	(15)		No longer used
PRICE_CORRECT_QTY	NUMBER			No longer used
PA_CMT_XFACE_FLAG	VARCHAR2	(1)		Flag that indicates if project related invoice distributions have been interfaced into Oracle Projects as committed cost.
CANCELLATION_FLAG	VARCHAR2	(1)		A value of Y indicates that the distribution line has been created during the Invoice Cancel.
INVOICE_LINE_NUMBER	NUMBER			Invoice line number for parent line
CORRECTED_INVOICE_DIST_ID	NUMBER	(15)		Invoice distribution identifier for invoice distribution corrected via current distribution. For price, quantity, or invoice line corrections
ROUNDING_AMT	NUMBER			Amount corresponding to rounding included in BASE_AMOUNT if any
CHARGE_APPLICABLE_TO_DIST_ID	NUMBER	(15)		Invoice distribution to which 100% of current charge is applied
CORRECTED_QUANTITY	NUMBER			Quantity corrected via price, quantity, or invoice line correction. Column populated for correcting distribution
RELATED_ID	NUMBER	(15)		Identifier linking related distributions. Used for linking related IPV, ERV, ITEM, or ACCRUAL. Populated from INVOICE_DISTRIBUTION_ID of ITEM or ACCRUAL distribution if any, IPV if no ITEM or ACCRUAL or ERV otherwise
ASSET_BOOK_TYPE_CODE	VARCHAR2	(15)		Asset Book. Defaults from invoice line for newly created distributions or distributions that have changed ASSETS_TRACKING_FLAG from N to Y
ASSET_CATEGORY_ID	NUMBER	(15)		Asset Category. Defaults from invoice line for newly created distributions or distributions that have changed ASSETS_TRACKING_FLAG from N to Y
DISTRIBUTION_CLASS	VARCHAR2	(30)		Flag that indicates whether this distribution is permanent or built in candidate mode for display to the user. Validated against AP_LOOKUP_CODES with lookup type as DISTRIBUTION CLASS
FINAL_PAYMENT_ROUNDING	NUMBER			Rounding amount to relieve the invoice liability completely for foreign currency invoices paid with more than one prepayment application or payment. This is calculated when the invoice becomes fully paid by a prepayment application. This amount is added to the largest PREPAY distribution on the invoice
FINAL_APPLICATION_ROUNDING	NUMBER			Rounding amount to relieve the prepaid expense completely. This is calculated during final application of a prepayment, and is added to the PREPAY distribution on the invoice that the prepayment is applied to that has the same account as the prepayment distribution with an outstanding balance to relieve
AMOUNT_AT_PREPAY_XRATE	NUMBER			Invoice distribution amount in functional currency at prepayment invoice exchange rate. Populated for PREPAY type distributions on foreign currency invoices
CASH_BASIS_FINAL_APP_ROUNDING	NUMBER			Rounding amount to relieve the prepaid expense completely when the accounting method used is cash basis. This is calculated during final application of a foreign currency prepayment, and is added to the PREPAY distribution on the invoice that the prepayment is applied to that has the same account as the prepayment distribution that has an outstanding balance to relieve
AMOUNT_AT_PREPAY_PAY_XRATE	NUMBER			Invoice distribution amount in functional currency at prepayment payment exchange rate. Populated for PREPAY type distributions on foreign currency invoices
INTENDED_USE	VARCHAR2	(30)		Tax Driver: Intended use of product Identifies the intended use of an Inventory item or non-Inventory based product fiscal classification, when the intended use is a factor either in tax determination or tax recovery.
DETAIL_TAX_DIST_ID	NUMBER			Unique internal identifier for detail tax line of E-Business Tax repository. This identifier is used to fetch the tax distribution information for an invoice line from Tax repository and displayed if 'Tax Distribution' button is pressed. Foreign key to the REC_NREC_TAX_DIST_ID column of the ZX_REC_NREC_DIST table.
REC_NREC_RATE	NUMBER			Recovery / Non-recovery rate
RECOVERY_RATE_ID	NUMBER			Recovery rate identifier.
RECOVERY_RATE_NAME	VARCHAR2	(150)		Recovery rate name
RECOVERY_TYPE_CODE	VARCHAR2	(30)		Recovery type code
RECOVERY_RATE_CODE	VARCHAR2	(30)
WITHHOLDING_TAX_CODE_ID	NUMBER	(15)		Withholding tax code unique ideintifier populated for the tax distributions generated by EBTax.
TAX_ALREADY_DISTRIBUTED_FLAG	VARCHAR2	(1)		Internal processing flag for Payables, indicating whether tax has already been distributed.
SUMMARY_TAX_LINE_ID	NUMBER			Unique internal identifier for summary tax line of E-Business Tax repository. This identifier is used to fetch the summary tax line information for an invoice line from Tax repository and displayed if 'Tax Details' button is pressed. Foreign key to the SUMMARY_TAX_LINE_ID column of the ZX_LINES_SUMMARY table.
TAXABLE_AMOUNT	NUMBER			The taxable amount for the distribution. This column used during upgrade and intended for internal use only.
TAXABLE_BASE_AMOUNT	NUMBER			The taxable amount in functional currency for the distribution. This column used during upgrade and intended for internal use only.
EXTRA_PO_ERV	NUMBER			ERV value for receipt matched distributions, based on the receipt and PO exchange rates. Used to simplify encumbrace code.
PREPAY_TAX_DIFF_AMOUNT	NUMBER			Amount resulting from a tax rate or recovery rate change between the Prepayment invoice date and the Standard invoice date.
TAX_CODE_ID	NUMBER	(15)		The tax code that was used on this distribution for the invoice date. This column used during upgrade and intended for internal use only.
VAT_CODE	VARCHAR2	(15)		No longer used
AMOUNT_INCLUDES_TAX_FLAG	VARCHAR2	(1)		No longer used
TAX_CALCULATED_FLAG	VARCHAR2	(1)		No longer used
TAX_RECOVERY_RATE	NUMBER			No longer used
TAX_RECOVERY_OVERRIDE_FLAG	VARCHAR2	(1)		No longer used
TAX_CODE_OVERRIDE_FLAG	VARCHAR2	(1)		No Longer Used
TOTAL_DIST_AMOUNT	NUMBER			Sum Total of Amounts related to this distribution including variance amounts from related Invoice distributions.
TOTAL_DIST_BASE_AMOUNT	NUMBER			Sum Total of Amounts related to this distribution including variance amounts from related Invoice distributions in Base Currency.
PREPAY_TAX_PARENT_ID	NUMBER	(15)		No longer used
CANCELLED_FLAG	VARCHAR2	(1)
OLD_DISTRIBUTION_ID	NUMBER	(15)		This column indicates 11i distribution id for the upgraded invoices.
OLD_DIST_LINE_NUMBER	NUMBER	(15)		This column indicates 11i distribution line number for the upgraded invoices.
AMOUNT_VARIANCE	NUMBER			Amount variance in entered currency for invoice distributions matched to service shipment or receipt
BASE_AMOUNT_VARIANCE	NUMBER			Amount variance in functional currency for invoice distributions matched to service shipment or receipt
HISTORICAL_FLAG	VARCHAR2	(1)		Flag to represents whether the document / invoice has been upgraded from a prior release or whether it has been newly created.
RCV_CHARGE_ADDITION_FLAG	VARCHAR2	(1)		Indicates if a distribution has been transferred to Oracle Procurement.
AWT_RELATED_ID	NUMBER	(15)		Identifier linking related distributions. Used for linking related Invoice Distribution for this Withholding Distribution. Populated from INVOICE_DISTRIBUTION_ID of the related distribution.
RELATED_RETAINAGE_DIST_ID	NUMBER	(15)		Related Retainage Invoice Distribution Identifier
RETAINED_AMOUNT_REMAINING	NUMBER			Retained amount available for release
BC_EVENT_ID	NUMBER			Identifier of Accounting Event raised for Encumbrance accounting
RETAINED_INVOICE_DIST_ID	NUMBER	(15)		Retained Invoice Distribution Identifier.
FINAL_RELEASE_ROUNDING	NUMBER			Rounding amount due to final release of an invoice with retainage
FULLY_PAID_ACCTD_FLAG	VARCHAR2	(1)		This column is used internally by Payables accounting engine and populated only for Federal customers. A value of Y represents fully paid and accounted invoice or NULL.
ROOT_DISTRIBUTION_ID	NUMBER	(15)		Identifier of the original distribution that has been price adjusted retroactively. This column is populated on PO Price Adjustment and Adjustment documents.
XINV_PARENT_REVERSAL_ID	NUMBER	(15)		Cross-invoice parent reversal identifier of the distribution that has been reversed. This column is populated on a distribution that negates a distribution on a different invoice.
RECURRING_PAYMENT_ID	NUMBER	(15)		Recurring invoice identifier
RELEASE_INV_DIST_DERIVED_FROM	NUMBER	(15)		Retainage release invoice distribution identifier used for subledger accounting business flows
PAY_AWT_GROUP_ID	NUMBER	(15)		Withholding Tax group identifier at Payment time. This column correspods to 'Payment Withholding Tax Group'.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACCOUNTING_DATE
,      ACCRUAL_POSTED_FLAG
,      ASSETS_ADDITION_FLAG
,      ASSETS_TRACKING_FLAG
,      CASH_POSTED_FLAG
,      DISTRIBUTION_LINE_NUMBER
,      DIST_CODE_COMBINATION_ID
,      INVOICE_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LINE_TYPE_LOOKUP_CODE
,      PERIOD_NAME
,      SET_OF_BOOKS_ID
,      ACCTS_PAY_CODE_COMBINATION_ID
,      AMOUNT
,      BASE_AMOUNT
,      BASE_INVOICE_PRICE_VARIANCE
,      BATCH_ID
,      CREATED_BY
,      CREATION_DATE
,      DESCRIPTION
,      EXCHANGE_RATE_VARIANCE
,      FINAL_MATCH_FLAG
,      INCOME_TAX_REGION
,      INVOICE_PRICE_VARIANCE
,      LAST_UPDATE_LOGIN
,      MATCH_STATUS_FLAG
,      POSTED_FLAG
,      PO_DISTRIBUTION_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      QUANTITY_INVOICED
,      RATE_VAR_CODE_COMBINATION_ID
,      REQUEST_ID
,      REVERSAL_FLAG
,      TYPE_1099
,      UNIT_PRICE
,      AMOUNT_ENCUMBERED
,      BASE_AMOUNT_ENCUMBERED
,      ENCUMBERED_FLAG
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      PRICE_ADJUSTMENT_FLAG
,      PRICE_VAR_CODE_COMBINATION_ID
,      QUANTITY_UNENCUMBERED
,      STAT_AMOUNT
,      AMOUNT_TO_POST
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      BASE_AMOUNT_TO_POST
,      CASH_JE_BATCH_ID
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      JE_BATCH_ID
,      PARENT_INVOICE_ID
,      PA_ADDITION_FLAG
,      PA_QUANTITY
,      POSTED_AMOUNT
,      POSTED_BASE_AMOUNT
,      PREPAY_AMOUNT_REMAINING
,      PROJECT_ACCOUNTING_CONTEXT
,      PROJECT_ID
,      TASK_ID
,      USSGL_TRANSACTION_CODE
,      USSGL_TRX_CODE_CONTEXT
,      EARLIEST_SETTLEMENT_DATE
,      REQ_DISTRIBUTION_ID
,      QUANTITY_VARIANCE
,      BASE_QUANTITY_VARIANCE
,      PACKET_ID
,      AWT_FLAG
,      AWT_GROUP_ID
,      AWT_TAX_RATE_ID
,      AWT_GROSS_AMOUNT
,      AWT_INVOICE_ID
,      AWT_ORIGIN_GROUP_ID
,      REFERENCE_1
,      REFERENCE_2
,      ORG_ID
,      OTHER_INVOICE_ID
,      AWT_INVOICE_PAYMENT_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      LINE_GROUP_NUMBER
,      RECEIPT_VERIFIED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      RECEIPT_MISSING_FLAG
,      JUSTIFICATION
,      EXPENSE_GROUP
,      START_EXPENSE_DATE
,      END_EXPENSE_DATE
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_CONVERSION_RATE
,      RECEIPT_CURRENCY_AMOUNT
,      DAILY_AMOUNT
,      WEB_PARAMETER_ID
,      ADJUSTMENT_REASON
,      AWARD_ID
,      MRC_ACCRUAL_POSTED_FLAG
,      MRC_CASH_POSTED_FLAG
,      MRC_DIST_CODE_COMBINATION_ID
,      MRC_AMOUNT
,      MRC_BASE_AMOUNT
,      MRC_BASE_INV_PRICE_VARIANCE
,      MRC_EXCHANGE_RATE_VARIANCE
,      MRC_POSTED_FLAG
,      MRC_PROGRAM_APPLICATION_ID
,      MRC_PROGRAM_ID
,      MRC_PROGRAM_UPDATE_DATE
,      MRC_RATE_VAR_CCID
,      MRC_REQUEST_ID
,      MRC_EXCHANGE_DATE
,      MRC_EXCHANGE_RATE
,      MRC_EXCHANGE_RATE_TYPE
,      MRC_AMOUNT_TO_POST
,      MRC_BASE_AMOUNT_TO_POST
,      MRC_CASH_JE_BATCH_ID
,      MRC_JE_BATCH_ID
,      MRC_POSTED_AMOUNT
,      MRC_POSTED_BASE_AMOUNT
,      MRC_RECEIPT_CONVERSION_RATE
,      CREDIT_CARD_TRX_ID
,      DIST_MATCH_TYPE
,      RCV_TRANSACTION_ID
,      INVOICE_DISTRIBUTION_ID
,      PARENT_REVERSAL_ID
,      TAX_RECOVERABLE_FLAG
,      PA_CC_AR_INVOICE_ID
,      PA_CC_AR_INVOICE_LINE_NUM
,      PA_CC_PROCESSED_CODE
,      MERCHANT_DOCUMENT_NUMBER
,      MERCHANT_NAME
,      MERCHANT_REFERENCE
,      MERCHANT_TAX_REG_NUMBER
,      MERCHANT_TAXPAYER_ID
,      COUNTRY_OF_SUPPLY
,      MATCHED_UOM_LOOKUP_CODE
,      GMS_BURDENABLE_RAW_COST
,      ACCOUNTING_EVENT_ID
,      PREPAY_DISTRIBUTION_ID
,      UPGRADE_POSTED_AMT
,      UPGRADE_BASE_POSTED_AMT
,      INVENTORY_TRANSFER_STATUS
,      COMPANY_PREPAID_INVOICE_ID
,      CC_REVERSAL_FLAG
,      AWT_WITHHELD_AMT
,      INVOICE_INCLUDES_PREPAY_FLAG
,      PRICE_CORRECT_INV_ID
,      PRICE_CORRECT_QTY
,      PA_CMT_XFACE_FLAG
,      CANCELLATION_FLAG
,      INVOICE_LINE_NUMBER
,      CORRECTED_INVOICE_DIST_ID
,      ROUNDING_AMT
,      CHARGE_APPLICABLE_TO_DIST_ID
,      CORRECTED_QUANTITY
,      RELATED_ID
,      ASSET_BOOK_TYPE_CODE
,      ASSET_CATEGORY_ID
,      DISTRIBUTION_CLASS
,      FINAL_PAYMENT_ROUNDING
,      FINAL_APPLICATION_ROUNDING
,      AMOUNT_AT_PREPAY_XRATE
,      CASH_BASIS_FINAL_APP_ROUNDING
,      AMOUNT_AT_PREPAY_PAY_XRATE
,      INTENDED_USE
,      DETAIL_TAX_DIST_ID
,      REC_NREC_RATE
,      RECOVERY_RATE_ID
,      RECOVERY_RATE_NAME
,      RECOVERY_TYPE_CODE
,      RECOVERY_RATE_CODE
,      WITHHOLDING_TAX_CODE_ID
,      TAX_ALREADY_DISTRIBUTED_FLAG
,      SUMMARY_TAX_LINE_ID
,      TAXABLE_AMOUNT
,      TAXABLE_BASE_AMOUNT
,      EXTRA_PO_ERV
,      PREPAY_TAX_DIFF_AMOUNT
,      TAX_CODE_ID
,      VAT_CODE
,      AMOUNT_INCLUDES_TAX_FLAG
,      TAX_CALCULATED_FLAG
,      TAX_RECOVERY_RATE
,      TAX_RECOVERY_OVERRIDE_FLAG
,      TAX_CODE_OVERRIDE_FLAG
,      TOTAL_DIST_AMOUNT
,      TOTAL_DIST_BASE_AMOUNT
,      PREPAY_TAX_PARENT_ID
,      CANCELLED_FLAG
,      OLD_DISTRIBUTION_ID
,      OLD_DIST_LINE_NUMBER
,      AMOUNT_VARIANCE
,      BASE_AMOUNT_VARIANCE
,      HISTORICAL_FLAG
,      RCV_CHARGE_ADDITION_FLAG
,      AWT_RELATED_ID
,      RELATED_RETAINAGE_DIST_ID
,      RETAINED_AMOUNT_REMAINING
,      BC_EVENT_ID
,      RETAINED_INVOICE_DIST_ID
,      FINAL_RELEASE_ROUNDING
,      FULLY_PAID_ACCTD_FLAG
,      ROOT_DISTRIBUTION_ID
,      XINV_PARENT_REVERSAL_ID
,      RECURRING_PAYMENT_ID
,      RELEASE_INV_DIST_DERIVED_FROM
,      PAY_AWT_GROUP_ID
FROM AP.AP_INVOICE_DISTRIBUTIONS_ALL;

Dependencies

[top of page]

AP.AP_INVOICE_DISTRIBUTIONS_ALL does not reference any database object

AP.AP_INVOICE_DISTRIBUTIONS_ALL is referenced by following:

APPS: AP_INVOICE_DISTRIBUTIONS; AP_INVOICE_DISTRIBUTIONS_ALL; AP_INV_DISTS_TARGET; IGI_AP_INVOICE_DIST_EXP_T1; IGI_AP_INVOICE_DIST_T1; IGI_AP_INVOICE_DIST_T2; IGI_AP_INVOICE_DIST_T3; JAI_AP_IDA_ARIUD_T1; JAI_AP_IDA_BRIUD_T1