FND Design Data [Home] [Help]

Table: FV_AAN_MATCHES_TEMP

Product: FV - Federal Financials
Description: Temporary table that stores information about the match entries identified by the match process for AR/AP netting
Implementation/DBA Data: Not implemented in this database
Primary Key: PK_SETUP_HDR
  1. ColumnCHECKRUN_NAME
  2. ColumnCUSTOMER_TRX_ID
  3. ColumnAR_PAYMENT_SCHEDULE_ID
  4. ColumnAP_INVOICE_ID
  5. ColumnAP_PAYMENT_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
FV_AAN_MATCHES_TEMP FK Joins to TableAP_INV_SELECTION_CRITERIA_ALL FV_AAN_MATCHES_TEMP.CHECKRUN_NAME
FV_AAN_MATCHES_TEMP FK Joins to TableAP_INVOICES_ALL FV_AAN_MATCHES_TEMP.AP_INVOICE_ID