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. There is one row for each invoice distribution. A distribution must be associated with an invoice. An invoice can have multiple distributions. Examples of when your Oracle Payables application automatically creates rows in this table include the following:
You choose a distribution set at the invoice header level.
You match an invoice line to a purchase order or receipt. The system uses information from the matched purchase order or receipt to create the distributions.
You match a credit or debit memo to an invoice.
You generate charge distributions (tax, freight, misc.) from allocation rules.
You apply a prepayment or unapply a prepayment.
Payables automatically withholds tax.
Payables creates an interest invoice.
When you account for an invoice, the Payables 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. Your 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, you must interface any project-related invoice distribution to Oracle projects before you can interface it 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. See Payables Lookup Listing for all the errors. You must correct the rejection reason and try to retransfer the line. 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.
This table corresponds to the Distributions window.

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 INVOICE_ID AMOUNT
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 ASSETS_TRACKING_FLAG LINE_TYPE_LOOKUP_CODE ACCOUNTING_DATE
AP_INVOICE_DISTRIBUTIONS_N32	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_ID CANCELLATION_FLAG MATCH_STATUS_FLAG
AP_INVOICE_DISTRIBUTIONS_N33	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_ID INVOICE_LINE_NUMBER ORG_ID
AP_INVOICE_DISTRIBUTIONS_N34	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_ID SUMMARY_TAX_LINE_ID
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
DIST_CODE_COMBINATION_ID	NUMBER	(15)	Yes	Accounting Flexfield identifier for account associated with a distribution
INVOICE_ID	NUMBER	(15)	Yes	Invoice identifier
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
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
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of books identifier
ACCTS_PAY_CODE_COMBINATION_ID	NUMBER	(15)		No longer used
AMOUNT	NUMBER			Invoice distribution amount
BASE_AMOUNT	NUMBER			Amount of invoice in functional currency, only used for foreign currency invoices
BASE_INVOICE_PRICE_VARIANCE	NUMBER			No longer used
BATCH_ID	NUMBER	(15)		Invoice batch identifier
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
DESCRIPTION	VARCHAR2	(240)		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 FND_LOGINS.LOGIN_ID).
MATCH_STATUS_FLAG	VARCHAR2	(1)		Validation status
POSTED_FLAG	VARCHAR2	(1)		Flag that indicates if invoice distribution line has been accounted
PO_DISTRIBUTION_ID	NUMBER	(15)		Purchase order distribution identifier for purchase order or receipt matched invoice distributions
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
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)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
REVERSAL_FLAG	VARCHAR2	(1)		Flag that indicates if distribution is part of a reversal pair
TYPE_1099	VARCHAR2	(10)		1099 type
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
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)		Organization identifier
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 receipts verified
RECEIPT_REQUIRED_FLAG	VARCHAR2	(1)		Indicates whether receipts required
RECEIPT_MISSING_FLAG	VARCHAR2	(1)		Indicates whether receipts missing
JUSTIFICATION	VARCHAR2	(240)		Expense justification
EXPENSE_GROUP	VARCHAR2	(80)		Expense group
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
ADJUSTMENT_REASON	VARCHAR2	(240)		Reason for expense adjustment
AWARD_ID	NUMBER	(15)		If Oracle Grants Accounting is installed, the award ID is used with award_set_id to track Grants 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)		Credit card transaction identifier
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 invoice distributions
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Yes	Unique identifier for this table
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
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 t create accounting entries for Cash basis accounting
UPGRADE_BASE_POSTED_AMT	NUMBER			This column is only used during the upgrade t 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)		Flag indicating whether distribution has been cancelled
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
DETAIL_TAX_DIST_ID	NUMBER			Cross reference to E-Business Tax repository.
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)		Separating out withholding tax functionality AWT package used to populate tax_code_id on withholding tax distributions with withholding tax code.
TAX_ALREADY_DISTRIBUTED_FLAG	VARCHAR2	(1)		Internal processing flag for Payables, indicating whether tax has already been distributed.
SUMMARY_TAX_LINE_ID	NUMBER			Cross reference to E-Business Tax repository.
TAXABLE_AMOUNT	NUMBER			For Internal Use Only
TAXABLE_BASE_AMOUNT	NUMBER			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
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)		Distribution identifier from old table
OLD_DIST_LINE_NUMBER	NUMBER	(15)		Distribution line number from old table
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
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:

AP: AP_INVOICE_DISTRIBUTIONS_ALL#