EBS:AP_INVOICE_PAYMENTS_ALL

描述：发票的付款记录

Primary Key: AP_INVOICE_PAYMENTS_PK

1. INVOICE_PAYMENT_ID

Foreign Keys from this table:

Foreign Key Column	Foreign Table
AP_INVOICE_PAYMENTS_ALL.INVOICE_ID	AP_INVOICES_ALL
AP_INVOICE_PAYMENTS_ALL.INVOICING_VENDOR_SITE_ID	%
AP_INVOICE_PAYMENTS_ALL.CHECK_ID	AP_CHECKS_ALL
AP_INVOICE_PAYMENTS_ALL.SET_OF_BOOKS_ID	%
AP_INVOICE_PAYMENTS_ALL.EXCHANGE_RATE_TYPE	GL_DAILY_CONVERSION_TYPES
AP_INVOICE_PAYMENTS_ALL.ACCOUNTING_EVENT_ID	AP_ACCOUNTING_EVENTS_ALL
AP_INVOICE_PAYMENTS_ALL.INVOICE_ID AP_INVOICE_PAYMENTS_ALL.PAYMENT_NUM	AP_PAYMENT_SCHEDULES_ALL
AP_INVOICE_PAYMENTS_ALL.INVOICING_PARTY_ID	HZ_PARTIES
AP_INVOICE_PAYMENTS_ALL.INVOICING_PARTY_SITE_ID	HZ_PARTY_SITES

Foreign Keys to this table:

Foreign Key Column	Foreign Table
AP_AWT_TEMP_DISTRIBUTIONS_ALL.INVOICE_PAYMENT_ID	AP_INVOICE_PAYMENTS_ALL
	AP_INVOICE_PAYMENTS_ALL
AP_INVOICE_DISTRIBUTIONS_ALL.AWT_INVOICE_PAYMENT_ID	AP_INVOICE_PAYMENTS_ALL
AP_PAYMENT_DISTRIBUTIONS_ALL.INVOICE_PAYMENT_ID	AP_INVOICE_PAYMENTS_ALL
FV_BD_CONTROLS.INVOICE_PAYMENT_ID	AP_INVOICE_PAYMENTS_ALL
FV_TREASURY_CONFIRMATIONS_ALL.INVOICE_PAYMENT_ID	AP_INVOICE_PAYMENTS_ALL
JAI_AP_TDS_F16_DTLS_ALL.INVOICE_PAYMENT_ID	AP_INVOICE_PAYMENTS_ALL
JAI_AP_TDS_INV_PAYMENTS.INVOICE_PAYMENT_ID	AP_INVOICE_PAYMENTS_ALL
PA_COST_DISTRIBUTION_LINES_ALL.SYSTEM_REFERENCE4	AP_INVOICE_PAYMENTS_ALL

Comments：

AP_INVOICE_PAYMENTS_ALL包含您向供应商支付的发票付款记录。每一笔发票的付款都有一行数据。在这个表格中，每笔付款都有一笔付款和一张发票。您的Oracle Payables应用程序更新该表时，您确认自动支付批次，输入手动支付，或处理一个快速支付。当您取消支付时，您的Oracle Payables应用程序插入一个额外的支付线，它是原始支付线的负数。

POSTED_FLAG的值可以是'Y'(对于有账户的付款)或'N'(对于未账户的付款)。在权责发生制会计下，应计al_posted_flag的值可能为'Y'，或为'N'，为未计帐付款;CASH_POSTED_FLAG的值在收付实现制会计下可能是'Y'，或者是'N'。

对于手动支付和快速支付，该表对应于Payment工作台中的Select Invoices窗口。