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.

[Home] [Help]

Table: AP_INVOICE_DISTRIBUTIONS_ALL

Product:	AP - Payables
Description:	Invoice distribution line information
Implementation/DBA Data:	AP.AP_INVOICE_DISTRIBUTIONS_ALL

Primary Key: AP_INVOICE_DISTRIBUTIONS_PK

INVOICE_ID
DISTRIBUTION_LINE_NUMBER

Foreign Keys

Table	Foreign Table	Foreign Key Column
AP_INVOICE_DISTRIBUTIONS_ALL	AP_INVOICES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID
AP_INVOICE_DISTRIBUTIONS_ALL	FND_CURRENCIES	AP_INVOICE_DISTRIBUTIONS_ALL.RECEIPT_CURRENCY_CODE
AP_INVOICE_DISTRIBUTIONS_ALL	AP_ACCOUNTING_EVENTS_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_EVENT_ID
AP_INVOICE_DISTRIBUTIONS_ALL	AP_INCOME_TAX_REGIONS	AP_INVOICE_DISTRIBUTIONS_ALL.INCOME_TAX_REGION
AP_INVOICE_DISTRIBUTIONS_ALL	GL_CODE_COMBINATIONS	AP_INVOICE_DISTRIBUTIONS_ALL.RATE_VAR_CODE_COMBINATION_ID
AP_INVOICE_DISTRIBUTIONS_ALL	GL_CODE_COMBINATIONS	AP_INVOICE_DISTRIBUTIONS_ALL.PRICE_VAR_CODE_COMBINATION_ID
AP_INVOICE_DISTRIBUTIONS_ALL	AP_INVOICES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.PARENT_INVOICE_ID
AP_INVOICE_DISTRIBUTIONS_ALL	AP_AWT_GROUPS	AP_INVOICE_DISTRIBUTIONS_ALL.AWT_GROUP_ID
AP_INVOICE_DISTRIBUTIONS_ALL	AP_TAX_CODES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.TAX_CODE_ID
AP_INVOICE_DISTRIBUTIONS_ALL	AP_AWT_TAX_RATES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.AWT_TAX_RATE_ID
AP_INVOICE_DISTRIBUTIONS_ALL	PA_TASKS	AP_INVOICE_DISTRIBUTIONS_ALL.TASK_ID
AP_INVOICE_DISTRIBUTIONS_ALL	PA_EXPENDITURE_TYPES	AP_INVOICE_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE
AP_INVOICE_DISTRIBUTIONS_ALL	PA_EXP_ORGS_IT	AP_INVOICE_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID
AP_INVOICE_DISTRIBUTIONS_ALL	RCV_TRANSACTIONS	AP_INVOICE_DISTRIBUTIONS_ALL.RCV_TRANSACTION_ID
AP_INVOICE_DISTRIBUTIONS_ALL	AP_INVOICES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.AWT_INVOICE_ID
AP_INVOICE_DISTRIBUTIONS_ALL	AP_AWT_GROUPS	AP_INVOICE_DISTRIBUTIONS_ALL.AWT_ORIGIN_GROUP_ID
AP_INVOICE_DISTRIBUTIONS_ALL	AP_CREDIT_CARD_TRXNS_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.CREDIT_CARD_TRX_ID
AP_INVOICE_DISTRIBUTIONS_ALL	AP_INVOICES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.COMPANY_PREPAID_INVOICE_ID
AP_INVOICE_DISTRIBUTIONS_ALL	AP_INVOICE_PAYMENTS_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.AWT_INVOICE_PAYMENT_ID
AP_INVOICE_DISTRIBUTIONS_ALL	AP_INVOICES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.PRICE_CORRECT_INV_ID
AP_INVOICE_DISTRIBUTIONS_ALL	AP_BATCHES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.BATCH_ID
AP_INVOICE_DISTRIBUTIONS_ALL	GL_CODE_COMBINATIONS	AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_ID
AP_INVOICE_DISTRIBUTIONS_ALL	PA_PROJECTS_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.PROJECT_ID
AP_INVOICE_DISTRIBUTIONS_ALL	GL_SETS_OF_BOOKS_11I	AP_INVOICE_DISTRIBUTIONS_ALL.SET_OF_BOOKS_ID
AP_INVOICE_DISTRIBUTIONS_ALL	PO_DISTRIBUTIONS_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID
AP_INVOICE_DISTRIBUTIONS_ALL	GL_DAILY_CONVERSION_TYPES	AP_INVOICE_DISTRIBUTIONS_ALL.EXCHANGE_RATE_TYPE
AP_INVOICE_DISTRIBUTIONS_ALL	AP_INVOICE_LINES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID
AP_INVOICE_LINES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL	AP_INVOICE_LINES_ALL.AIL_INVOICE_ID2 AP_INVOICE_LINES_ALL.AIL_DISTRIBUTION_LINE_NUMBER
AP_INVOICE_LINES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL	AP_INVOICE_LINES_ALL.AIL_INVOICE_ID3 AP_INVOICE_LINES_ALL.AIL_DISTRIBUTION_LINE_NUMBER2
AP_INVOICE_LINES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL	AP_INVOICE_LINES_ALL.AIL_INVOICE_ID4 AP_INVOICE_LINES_ALL.AIL_DISTRIBUTION_LINE_NUMBER3
AP_TRIAL_BALANCE	AP_INVOICE_DISTRIBUTIONS_ALL	AP_TRIAL_BALANCE.INVOICE_ID AP_TRIAL_BALANCE.DISTRIBUTION_LINE_NUMBER
FA_ASSET_INVOICES	AP_INVOICE_DISTRIBUTIONS_ALL	FA_ASSET_INVOICES.INVOICE_ID FA_ASSET_INVOICES.AP_DISTRIBUTION_LINE_NUMBER
FA_MASS_ADDITIONS	AP_INVOICE_DISTRIBUTIONS_ALL	FA_MASS_ADDITIONS.INVOICE_ID FA_MASS_ADDITIONS.AP_DISTRIBUTION_LINE_NUMBER
FA_MC_ASSET_INVOICES	AP_INVOICE_DISTRIBUTIONS_ALL	FA_MC_ASSET_INVOICES.INVOICE_ID FA_MC_ASSET_INVOICES.AP_DISTRIBUTION_LINE_NUMBER
JAI_FA_MASS_ADDITIONS	AP_INVOICE_DISTRIBUTIONS_ALL	JAI_FA_MASS_ADDITIONS.INVOICE_ID JAI_FA_MASS_ADDITIONS.DISTRIBUTION_LINE_NUMBER
JAI_PO_REP_PRRG_T	AP_INVOICE_DISTRIBUTIONS_ALL	JAI_PO_REP_PRRG_T.INVOICE_ID JAI_PO_REP_PRRG_T.DISTRIBUTION_LINE_NUMBER
PA_COST_DISTRIBUTION_LINES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL	PA_COST_DISTRIBUTION_LINES_ALL.SYSTEM_REFERENCE2 PA_COST_DISTRIBUTION_LINES_ALL.SYSTEM_REFERENCE3
PA_BC_COMMITMENTS_ALL	AP_INVOICE_DISTRIBUTIONS_ALL	PA_BC_COMMITMENTS_ALL.AIL_INVOICE_ID PA_BC_COMMITMENTS_ALL.AIL_DISTRIBUTION_LINE_NUMBER