FND Design Data [Home] [Help]

Table: AP_RECURRING_PAYMENTS_ALL

Product: AP - Payables
Description: Recurring invoice parameters
Implementation/DBA Data: TableAP.AP_RECURRING_PAYMENTS_ALL
Primary Key: AP_RECURRING_PAYMENTS_PK
  1. ColumnRECURRING_PAYMENT_ID
Primary Key: AP_RECURRING_PAYMENTS_UK1
  1. ColumnVENDOR_ID
  2. ColumnRECURRING_PAY_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
AP_RECURRING_PAYMENTS_ALL FK Joins to TableAP_DISTRIBUTION_SETS_ALL AP_RECURRING_PAYMENTS_ALL.DISTRIBUTION_SET_ID
AP_RECURRING_PAYMENTS_ALL FK Joins to TablePO_VENDOR_SITES_ALL AP_RECURRING_PAYMENTS_ALL.VENDOR_SITE_ID
AP_RECURRING_PAYMENTS_ALL FK Joins to TableGL_SETS_OF_BOOKS_11I AP_RECURRING_PAYMENTS_ALL.SET_OF_BOOKS_ID
AP_RECURRING_PAYMENTS_ALL FK Joins to TableGL_CODE_COMBINATIONS AP_RECURRING_PAYMENTS_ALL.ACCTS_PAY_CODE_COMBINATION_ID
AP_RECURRING_PAYMENTS_ALL FK Joins to TableFND_CURRENCIES AP_RECURRING_PAYMENTS_ALL.INVOICE_CURRENCY_CODE
AP_RECURRING_PAYMENTS_ALL FK Joins to TableFND_CURRENCIES AP_RECURRING_PAYMENTS_ALL.PAYMENT_CURRENCY_CODE
AP_RECURRING_PAYMENTS_ALL FK Joins to TableGL_DAILY_CONVERSION_TYPES AP_RECURRING_PAYMENTS_ALL.EXCHANGE_RATE_TYPE
AP_RECURRING_PAYMENTS_ALL FK Joins to TableAP_AWT_GROUPS AP_RECURRING_PAYMENTS_ALL.AWT_GROUP_ID
AP_RECURRING_PAYMENTS_ALL FK Joins to TablePO_LINE_LOCATIONS_ALL AP_RECURRING_PAYMENTS_ALL.LINE_LOCATION_ID
AP_RECURRING_PAYMENTS_ALL FK Joins to TableAP_BATCHES_ALL AP_RECURRING_PAYMENTS_ALL.BATCH_ID
AP_RECURRING_PAYMENTS_ALL FK Joins to TableAP_HOLD_CODES AP_RECURRING_PAYMENTS_ALL.HOLD_LOOKUP_CODE
AP_RECURRING_PAYMENTS_ALL FK Joins to TablePO_VENDORS AP_RECURRING_PAYMENTS_ALL.VENDOR_ID
TableAP_INVOICES_ALL FK Joins to AP_RECURRING_PAYMENTS_ALL AP_INVOICES_ALL.RECURRING_PAYMENT_ID