描述：发票的付款记录
Primary Key: AP_INVOICE_PAYMENTS_PK
- 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窗口。
