EBS:AP_INV_SELECTION_CRITERIA_ALL

原创于 2022-05-16 16:46:56 发布 · 345 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle

EBS 专栏收录该内容

88 篇文章

订阅专栏

AP_INVOICE_SELECTION_CRITERIA_ALL表格详细记录了Oracle Payables中用于批量支付发票选择的准则。每行数据对应一次支付批处理初始化，指导AutoSelect选择支付发票。此表与其他多个表通过外键关联，涉及检查库存、货币、汇率类型、银行账户等多个方面，对于创建和管理付款请求至关重要。

描述：付款批量发票的选择标准

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选择支付发票。该表对应于“创建付款请求”页面。