EBS:AP_INVOICE_DISTRIBUTIONS_ALL

描述：发票配送线信息

Primary Key: AP_INVOICE_DISTRIBUTIONS_PK

1. INVOICE_ID
2. DISTRIBUTION_LINE_NUMBER

Foreign Keys from this table:

Foreign Key Column	Foreign Table
AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID	AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.RECEIPT_CURRENCY_CODE	FND_CURRENCIES
AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_EVENT_ID	AP_ACCOUNTING_EVENTS_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.INCOME_TAX_REGION	AP_INCOME_TAX_REGIONS
AP_INVOICE_DISTRIBUTIONS_ALL.RATE_VAR_CODE_COMBINATION_ID	GL_CODE_COMBINATIONS
AP_INVOICE_DISTRIBUTIONS_ALL.PRICE_VAR_CODE_COMBINATION_ID	GL_CODE_COMBINATIONS
AP_INVOICE_DISTRIBUTIONS_ALL.PARENT_INVOICE_ID	AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.AWT_GROUP_ID	AP_AWT_GROUPS
AP_INVOICE_DISTRIBUTIONS_ALL.TAX_CODE_ID	AP_TAX_CODES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.AWT_TAX_RATE_ID	AP_AWT_TAX_RATES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.TASK_ID	PA_TASKS
AP_INVOICE_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE	PA_EXPENDITURE_TYPES
AP_INVOICE_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID	PA_EXP_ORGS_IT
AP_INVOICE_DISTRIBUTIONS_ALL.RCV_TRANSACTION_ID	RCV_TRANSACTIONS
AP_INVOICE_DISTRIBUTIONS_ALL.AWT_INVOICE_ID	AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.AWT_ORIGIN_GROUP_ID	AP_AWT_GROUPS
AP_INVOICE_DISTRIBUTIONS_ALL.CREDIT_CARD_TRX_ID	AP_CREDIT_CARD_TRXNS_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.COMPANY_PREPAID_INVOICE_ID	AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.AWT_INVOICE_PAYMENT_ID	AP_INVOICE_PAYMENTS_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.PRICE_CORRECT_INV_ID	AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.BATCH_ID	AP_BATCHES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_ID	GL_CODE_COMBINATIONS
AP_INVOICE_DISTRIBUTIONS_ALL.PROJECT_ID	PA_PROJECTS_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.SET_OF_BOOKS_ID	%
AP_INVOICE_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID	PO_DISTRIBUTIONS_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.EXCHANGE_RATE_TYPE	GL_DAILY_CONVERSION_TYPES

Foreign Keys to this table:

Foreign Key Column	Foreign Table
AP_TRIAL_BALANCE.INVOICE_ID AP_TRIAL_BALANCE.DISTRIBUTION_LINE_NUMBER	AP_INVOICE_DISTRIBUTIONS_ALL
FA_ASSET_INVOICES.INVOICE_ID FA_ASSET_INVOICES.AP_DISTRIBUTION_LINE_NUMBER	AP_INVOICE_DISTRIBUTIONS_ALL
FA_MASS_ADDITIONS.INVOICE_ID FA_MASS_ADDITIONS.AP_DISTRIBUTION_LINE_NUMBER	AP_INVOICE_DISTRIBUTIONS_ALL
FA_MC_ASSET_INVOICES.INVOICE_ID FA_MC_ASSET_INVOICES.AP_DISTRIBUTION_LINE_NUMBER	AP_INVOICE_DISTRIBUTIONS_ALL
JAI_FA_MASS_ADDITIONS.INVOICE_ID JAI_FA_MASS_ADDITIONS.DISTRIBUTION_LINE_NUMBER	AP_INVOICE_DISTRIBUTIONS_ALL
JAI_PO_REP_PRRG_T.INVOICE_ID JAI_PO_REP_PRRG_T.DISTRIBUTION_LINE_NUMBER	AP_INVOICE_DISTRIBUTIONS_ALL
PA_COST_DISTRIBUTION_LINES_ALL.SYSTEM_REFERENCE2 PA_COST_DISTRIBUTION_LINES_ALL.SYSTEM_REFERENCE3	AP_INVOICE_DISTRIBUTIONS_ALL
PA_BC_COMMITMENTS_ALL.AIL_INVOICE_ID PA_BC_COMMITMENTS_ALL.AIL_DISTRIBUTION_LINE_NUMBER	AP_INVOICE_DISTRIBUTIONS_ALL

Comments：

AP_INVOICE_DISTRIBUTIONS_ALL保存手动输入或系统生成的分发信息。每一张发票都有一行。分发必须与发票相关联。一个发票可以有多个分发版本。当您的Oracle Payables应用程序自动在该表中创建行包括以下示例:

1. 你在发票标头级别选择一个分发集。
2. 你将发票行与采购订单或收据相匹配。系统使用来自匹配的购买订单或收据的信息来创建分发。
3. 你把贷记或借记通知单与发票相匹配。
4. 从分配规则中生成费用分配(税、运费、杂项)。
5. 你可以申请提前支付或取消提前支付。
6. 应付款自动代扣税款。
7. 应付款创建一个利息发票。

当你为发票记账时，Payables Accounting Process为那些在选定的会计日期范围内包含会计日期的发行版创建会计事件、会计分录头和会计分录行。转移到总账流程可以将会计分录作为日记账分录转移到总账。发票分发版可以通过Oracle资产或Oracle项目进行接口。你的Oracle Payables应用程序设置ASSETS_ADDITION_FLAG为U的分布没有通过Oracle资产测试;然后Oracle资产在测试分配分配的分布作为资产后调整这个标志。为了避免相同的发票分发被连接到Oracle项目和Oracle资产，你必须将任何项目相关的发票分发连接到Oracle项目，然后才能将其连接到Oracle资产。

如果项目相关发票分配向资本项目在Oracle项目,Oracle项目设置ASSETS_ADDITION_FLAG设置为P且PA_ADDITION_FLAG时设置为Y, Z,或T。Oracle资产只有拿起发票分布ASSET_ADDITION_FLAG设置为U,如果项目相关PA_ADDITION_FLAG设置为Y, Z,或T。 PA_ADDITION_FLAG跟踪与项目相关的供应商发票分发和费用报告分发的状态。对于通过Oracle Payables输入的供应商发票分发，如果分发与项目相关，PA_ADDITION_FLAG设置为N，否则设置为E，当分发被Oracle项目接口供应商发票流程处理时，由Oracle项目更新。

在项目被成功处理后，Oracle Projects将PA_ADDITION_FLAG设置为Y或Z，或者如果行在转移到Oracle Projects时被拒绝，可以设置为拒绝代码。请参阅Payables查找列表中的所有错误。您必须纠正拒绝原因，并尝试重新转接线路。对于从Oracle Projects到Oracle Payables的供应商发票调整发行版(与另一个发行版相比，其净额必须为零)，PA_ADDITION_FLAG的值设置为T。