FND Design Data [Home] [Help]

Table: AP_PAYMENT_SCHEDULES_ALL

Product: AP - Payables
Description: Scheduled payment information on invoices
Implementation/DBA Data: TableAP.AP_PAYMENT_SCHEDULES_ALL
Primary Key: AP_PAYMENT_SCHEDULES_PK
  1. ColumnINVOICE_ID
  2. ColumnPAYMENT_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
AP_PAYMENT_SCHEDULES_ALL FK Joins to TableAP_INVOICES_ALL AP_PAYMENT_SCHEDULES_ALL.INVOICE_ID
AP_PAYMENT_SCHEDULES_ALL FK Joins to TableAP_BATCHES_ALL AP_PAYMENT_SCHEDULES_ALL.BATCH_ID
AP_PAYMENT_SCHEDULES_ALL FK Joins to TableAP_BANK_ACCOUNTS_ALL AP_PAYMENT_SCHEDULES_ALL.EXTERNAL_BANK_ACCOUNT_ID
TableAP_INVOICE_PAYMENTS_ALL FK Joins to AP_PAYMENT_SCHEDULES_ALL AP_INVOICE_PAYMENTS_ALL.INVOICE_ID
AP_INVOICE_PAYMENTS_ALL.PAYMENT_NUM
TableJL_BR_AP_COLLECTION_DOCS_ALL FK Joins to AP_PAYMENT_SCHEDULES_ALL JL_BR_AP_COLLECTION_DOCS_ALL.INVOICE_ID
JL_BR_AP_COLLECTION_DOCS_ALL.PAYMENT_NUM