描述:付款批量发票的选择标准
Primary Key: AP_INVOICE_SELECTION_CRITER_PK
- CHECKRUN_ID
Foreign Keys from this table:
Foreign Key Column | Foreign Table |
---|---|
AP_INV_SELECTION_CRITERIA_ALL.CHECK_STOCK_ID | AP_CHECK_STOCKS_ALL |
AP_INV_SELECTION_CRITERIA_ALL.CURRENCY_CODE | FND_CURRENCIES |
AP_INV_SELECTION_CRITERIA_ALL.EXCHANGE_RATE_TYPE | GL_DAILY_CONVERSION_TYPES |
AP_INV_SELECTION_CRITERIA_ALL.BANK_ACCOUNT_ID | AP_BANK_ACCOUNTS_ALL |
AP_INV_SELECTION_CRITERIA_ALL.BATCH_SET_ID | AP_PBATCH_SETS_ALL |
AP_INV_SELECTION_CRITERIA_ALL.BATCH_SET_LINE_ID | AP_PBATCH_SET_LINES_ALL |
Foreign Keys to this table:
Foreign Key Column | Foreign Table |
---|---|
AP_AWT_TEMP_DISTRIBUTIONS_ALL.CHECKRUN_NAME | AP_INV_SELECTION_CRITERIA_ALL |
AP_CHECKRUN_CONC_PROCESSES_ALL.CHECKRUN_NAME | AP_INV_SELECTION_CRITERIA_ALL |
AP_CHECKRUN_CONFIRMATIONS_ALL.CHECKRUN_NAME | AP_INV_SELECTION_CRITERIA_ALL |
AP_CHECKS_ALL.CHECKRUN_ID | AP_INV_SELECTION_CRITERIA_ALL |
AP_CHECKS_ALL.CHECKRUN_NAME | AP_INV_SELECTION_CRITERIA_ALL |
AP_CURRENCY_GROUP.CHECKRUN_ID | AP_INV_SELECTION_CRITERIA_ALL |
AP_LE_GROUP.CHECKRUN_ID | AP_INV_SELECTION_CRITERIA_ALL |
AP_OU_GROUP.CHECKRUN_ID | AP_INV_SELECTION_CRITERIA_ALL |
AP_PAY_GROUP.CHECKRUN_ID | AP_INV_SELECTION_CRITERIA_ALL |
AP_SELECTED_INVOICES_ALL.CHECKRUN_NAME | AP_INV_SELECTION_CRITERIA_ALL |
AP_SELECTED_INVOICE_CHECKS_ALL.CHECKRUN_NAME | AP_INV_SELECTION_CRITERIA_ALL |
AP_UNSELECTED_INVOICES_ALL.CHECKRUN_ID | AP_INV_SELECTION_CRITERIA_ALL |
FV_AAN_MATCHES_TEMP.CHECKRUN_NAME | AP_INV_SELECTION_CRITERIA_ALL |
FV_AP_CASH_POS_TEMP.CHECKRUN_ID | AP_INV_SELECTION_CRITERIA_ALL |
Comments:
AP_INVOICE_SELECTION_CRITERIA_ALL存储支付批处理用于选择支付发票的标准。您的Oracle Payables应用程序在每次初始化支付批处理时创建一行。您的Oracle Payables应用程序使用此信息来指导AutoSelect选择支付发票。该表对应于“创建付款请求”页面。