FND Design Data [Home] [Help]

Table: AP_INVOICE_DISTRIBUTIONS_ALL

Product: AP - Payables
Description: Invoice distribution line information
Implementation/DBA Data: TableAP.AP_INVOICE_DISTRIBUTIONS_ALL
Primary Key: AP_INVOICE_DISTRIBUTIONS_PK
  1. ColumnINVOICE_ID
  2. ColumnDISTRIBUTION_LINE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableAP_INVOICES_ALL AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableFND_CURRENCIES AP_INVOICE_DISTRIBUTIONS_ALL.RECEIPT_CURRENCY_CODE
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableAP_ACCOUNTING_EVENTS_ALL AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_EVENT_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableAP_INCOME_TAX_REGIONS AP_INVOICE_DISTRIBUTIONS_ALL.INCOME_TAX_REGION
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_INVOICE_DISTRIBUTIONS_ALL.RATE_VAR_CODE_COMBINATION_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_INVOICE_DISTRIBUTIONS_ALL.PRICE_VAR_CODE_COMBINATION_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableAP_INVOICES_ALL AP_INVOICE_DISTRIBUTIONS_ALL.PARENT_INVOICE_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableAP_AWT_GROUPS AP_INVOICE_DISTRIBUTIONS_ALL.AWT_GROUP_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableAP_TAX_CODES_ALL AP_INVOICE_DISTRIBUTIONS_ALL.TAX_CODE_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableAP_AWT_TAX_RATES_ALL AP_INVOICE_DISTRIBUTIONS_ALL.AWT_TAX_RATE_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TablePA_TASKS AP_INVOICE_DISTRIBUTIONS_ALL.TASK_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TablePA_EXPENDITURE_TYPES AP_INVOICE_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TablePA_EXP_ORGS_IT AP_INVOICE_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableRCV_TRANSACTIONS AP_INVOICE_DISTRIBUTIONS_ALL.RCV_TRANSACTION_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableAP_INVOICES_ALL AP_INVOICE_DISTRIBUTIONS_ALL.AWT_INVOICE_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableAP_AWT_GROUPS AP_INVOICE_DISTRIBUTIONS_ALL.AWT_ORIGIN_GROUP_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableAP_CREDIT_CARD_TRXNS_ALL AP_INVOICE_DISTRIBUTIONS_ALL.CREDIT_CARD_TRX_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableAP_INVOICES_ALL AP_INVOICE_DISTRIBUTIONS_ALL.COMPANY_PREPAID_INVOICE_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableAP_INVOICE_PAYMENTS_ALL AP_INVOICE_DISTRIBUTIONS_ALL.AWT_INVOICE_PAYMENT_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableAP_INVOICES_ALL AP_INVOICE_DISTRIBUTIONS_ALL.PRICE_CORRECT_INV_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableAP_BATCHES_ALL AP_INVOICE_DISTRIBUTIONS_ALL.BATCH_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TablePA_PROJECTS_ALL AP_INVOICE_DISTRIBUTIONS_ALL.PROJECT_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableGL_SETS_OF_BOOKS_11I AP_INVOICE_DISTRIBUTIONS_ALL.SET_OF_BOOKS_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TablePO_DISTRIBUTIONS_ALL AP_INVOICE_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableGL_DAILY_CONVERSION_TYPES AP_INVOICE_DISTRIBUTIONS_ALL.EXCHANGE_RATE_TYPE
AP_INVOICE_DISTRIBUTIONS_ALL FK Joins to TableAP_INVOICE_LINES_ALL AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER
AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID
TableAP_INVOICE_LINES_ALL FK Joins to AP_INVOICE_DISTRIBUTIONS_ALL AP_INVOICE_LINES_ALL.AIL_INVOICE_ID2
AP_INVOICE_LINES_ALL.AIL_DISTRIBUTION_LINE_NUMBER
TableAP_INVOICE_LINES_ALL FK Joins to AP_INVOICE_DISTRIBUTIONS_ALL AP_INVOICE_LINES_ALL.AIL_INVOICE_ID3
AP_INVOICE_LINES_ALL.AIL_DISTRIBUTION_LINE_NUMBER2
TableAP_INVOICE_LINES_ALL FK Joins to AP_INVOICE_DISTRIBUTIONS_ALL AP_INVOICE_LINES_ALL.AIL_INVOICE_ID4
AP_INVOICE_LINES_ALL.AIL_DISTRIBUTION_LINE_NUMBER3
TableAP_TRIAL_BALANCE FK Joins to AP_INVOICE_DISTRIBUTIONS_ALL AP_TRIAL_BALANCE.INVOICE_ID
AP_TRIAL_BALANCE.DISTRIBUTION_LINE_NUMBER
TableFA_ASSET_INVOICES FK Joins to AP_INVOICE_DISTRIBUTIONS_ALL FA_ASSET_INVOICES.INVOICE_ID
FA_ASSET_INVOICES.AP_DISTRIBUTION_LINE_NUMBER
TableFA_MASS_ADDITIONS FK Joins to AP_INVOICE_DISTRIBUTIONS_ALL FA_MASS_ADDITIONS.INVOICE_ID
FA_MASS_ADDITIONS.AP_DISTRIBUTION_LINE_NUMBER
TableFA_MC_ASSET_INVOICES FK Joins to AP_INVOICE_DISTRIBUTIONS_ALL FA_MC_ASSET_INVOICES.INVOICE_ID
FA_MC_ASSET_INVOICES.AP_DISTRIBUTION_LINE_NUMBER
TableJAI_FA_MASS_ADDITIONS FK Joins to AP_INVOICE_DISTRIBUTIONS_ALL JAI_FA_MASS_ADDITIONS.INVOICE_ID
JAI_FA_MASS_ADDITIONS.DISTRIBUTION_LINE_NUMBER
TableJAI_PO_REP_PRRG_T FK Joins to AP_INVOICE_DISTRIBUTIONS_ALL JAI_PO_REP_PRRG_T.INVOICE_ID
JAI_PO_REP_PRRG_T.DISTRIBUTION_LINE_NUMBER
TablePA_COST_DISTRIBUTION_LINES_ALL FK Joins to AP_INVOICE_DISTRIBUTIONS_ALL PA_COST_DISTRIBUTION_LINES_ALL.SYSTEM_REFERENCE2
PA_COST_DISTRIBUTION_LINES_ALL.SYSTEM_REFERENCE3
TablePA_BC_COMMITMENTS_ALL FK Joins to AP_INVOICE_DISTRIBUTIONS_ALL PA_BC_COMMITMENTS_ALL.AIL_INVOICE_ID
PA_BC_COMMITMENTS_ALL.AIL_DISTRIBUTION_LINE_NUMBER