AP_INV_SELECTION_CRITERIA_ALL
AP_INVOICE_SELECTION_CRITERIA_ALL stores the criteria that a payment batch uses to select invoices for payment. Your Oracle Payables application creates one row each time you initiate a payment batch. Your Oracle Payables application uses this information to guide AutoSelect in selecting invoices for payment. This table corresponds to the Create Payment Request page.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AP_INVOICE_SELECTION_CRITER_PK |
CHECKRUN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CHECKRUN_NAME | VARCHAR2 | 255 | Yes | Name of payment process request submitted. | |
| INV_AWT_EXISTS_FLAG | VARCHAR2 | 1 | Indicates that payment process request contains invoices with withholding tax group associated with them. | ||
| CHECK_DATE | DATE | Yes | Payment date of payments generated for given check run. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| PERIOD_NAME | VARCHAR2 | 15 | Period name of the invoice selection criteria. | ||
| PAY_THRU_DATE | DATE | Date until when invoices can be selected for check run. | |||
| HI_PAYMENT_PRIORITY | NUMBER | 2 | Highest payment priority of invoices to select | ||
| LOW_PAYMENT_PRIORITY | NUMBER | 2 | Lowest payment priority of invoices to select | ||
| PAY_ONLY_WHEN_DUE_FLAG | VARCHAR2 | 1 | Flag that indicates if invoices will be selected by their due date only (Y or N) | ||
| STATUS | VARCHAR2 | 25 | Status of completion of a batch | ||
| EXCHANGE_RATE | NUMBER | Exchange rate for a foreign currency payment | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Exchange rate type for a foreign currency payment | ||
| EXCHANGE_DATE | DATE | Date exchange rate is obtained from daily rates table | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| FIRST_VOUCHER_NUMBER | NUMBER | 18 | First available voucher number in document sequence for payment batch document category | ||
| ZERO_INVOICES_ALLOWED | VARCHAR2 | 1 | Flag indicating whether scheduled payments with zero amount remaining will be selected during a payment batch | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| CHECKRUN_ID | NUMBER | 18 | Yes | Payment process request identifier | |
| TRANSFER_PRIORITY | VARCHAR2 | 25 | Transfer priority of the invoice selection criteria. | ||
| INVOICE_BATCH_ID | NUMBER | 18 | Invoice group selected as selection criteria. | ||
| VENDOR_ID | NUMBER | 18 | Unique supplier identifier that identifies a supplier that is selected in the selection criteria. | ||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Who column: indicates the application identifier of the row. | ||
| PROGRAM_ID | NUMBER | 18 | Who column: indicates the identifier of the row. | ||
| PROGRAM_UPDATE_DATE | DATE | Who column: indicates the date and time of the creation of the row. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CE_BANK_ACCT_USE_ID | NUMBER | 18 | Internal bank account used unique identifier. | ||
| TEMPLATE_ID | NUMBER | 18 | Payment Process Template Identifier | ||
| PAY_FROM_DATE | DATE | Date from when invoices should be selected for check run. | |||
| VENDOR_TYPE_LOOKUP_CODE | VARCHAR2 | 30 | Supplier Type. Based on PO Lookup Type VENDOR TYPES | ||
| PAYMENT_PROFILE_ID | NUMBER | 18 | Payment process profile identifier | ||
| INV_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Invoice Exchange Rate Type. Values, from the lookup INVOICE_EXCHANGE_RATE_TYPE | ||
| PAYABLES_REVIEW_SETTINGS | VARCHAR2 | 1 | Stop Process for Review After Invoice Selection | ||
| CALC_AWT_INT_FLAG | VARCHAR2 | 1 | Flag to indicate Calculate Payment Withholding and Interest During Scheduled Payment Selection | ||
| PAYMENTS_REVIEW_SETTINGS | VARCHAR2 | 1 | Stop Process for Review After Creation of Proposed Payments.Defaulted from IBY Payer Setup. | ||
| DOCUMENT_REJECTION_LEVEL_CODE | VARCHAR2 | 30 | Specifies what is rejected if a document payable fails validation. Values, from the IBY_DOCUMENT_REJECTION_LEVELS lookup, include REQUEST, PAYEE, and DOCUMENT. | ||
| PAYMENT_REJECTION_LEVEL_CODE | VARCHAR2 | 30 | Pay Group Options, All and Specify | ||
| CREATE_INSTRS_FLAG | VARCHAR2 | 1 | Payment Instruction Creation Program. This setting requires the user to select a payment process profile. This setting will also ensure that payments from this payment process request are not combined with payments from other payment process requests when the system creates payment instructions. | ||
| PAY_GROUP_OPTION | VARCHAR2 | 10 | Pay Group Options, All and Specify | ||
| CURRENCY_GROUP_OPTION | VARCHAR2 | 10 | Currency Options, All and Specify | ||
| LE_GROUP_OPTION | VARCHAR2 | 10 | Legal Entity Options, All and Specify | ||
| OU_GROUP_OPTION | VARCHAR2 | 10 | Operating Unit Options, All and Specify | ||
| PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Payment method selected as selection criteria. | ||
| BANK_CHARGE_BEARER | VARCHAR2 | 30 | Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER. | ||
| SETTLEMENT_PRIORITY | VARCHAR2 | 30 | The priority with which the financial institution or payment system should settle payments for this payee. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY. | ||
| NEXT_VOUCHER_NUMBER | NUMBER | 18 | Next available voucher number in document sequence for payment batch document category | ||
| PARTY_ID | NUMBER | 18 | Unique identifier of the party selected as selection criteria. | ||
| PAYMENT_DOCUMENT_ID | NUMBER | 18 | Identifier of payment document selected as processing criteria for payment run. | ||
| ZERO_AMOUNTS_ALLOWED | VARCHAR2 | 1 | Indicates whether zero amount payment can be created. | ||
| BANK_ACCOUNT_ID | NUMBER | 18 | Unique identifier associated with bank account. | ||
| TEMPLATE_FLAG | VARCHAR2 | 1 | Flag to track check runs submitted through template scheduling process. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| X_CURR_RATE_TYPE | VARCHAR2 | 30 | The conversion rate type used to convert the invoice currency to payment currency. | ||
| FIRST_APPROVER_ID | NUMBER | 18 | First approver identifier for payment process requests that the payments approval workflow uses to generate the list of approvers. | ||
| NOTIFICATION_MESSAGE_ID | NUMBER | 18 | Notification message identifier. | ||
| BIP_JOB_ID | NUMBER | 18 | Job identifier of the selected installment report that was last run. | ||
| ACCELERATED_INVOICES_CODE | VARCHAR2 | 30 | Code identifier for the accelerated invoices. Possible values are INCLUDE, EXCLUDE and EXCLUSIVE. | ||
| SOURCE_GROUP_OPTION | VARCHAR2 | 10 | Options on how to select invoices with either all or specific values. | ||
| THRESHOLD_OPTION_CODE | VARCHAR2 | 30 | Threshold amount option provided on the payment process request. | ||
| THRESHOLD_AMOUNT | NUMBER | Threshold amount provided on the payment process request. This can be either user given amount or actual bank balance depending upon the threshold amount option selected by user. | |||
| TRANSACTION_CALENDAR_ID | NUMBER | 18 | General Ledger transaction calendar identifier | ||
| PAYMENT_MODE_CODE | VARCHAR2 | 30 | Invoice payment mode identifier. | ||
| PAYMENT_INSTRUMENT_ID | NUMBER | 18 | Funding instrument used for making payments. | ||
| PMT_TO_BANK_RATE_TYPE | VARCHAR2 | 30 | Type of exchange rate used to convert payment to disbursement bank account currency. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AP_INV_SELECTION_CRITERIA_ALL | ap_payment_templates | TEMPLATE_ID |
| AP_INV_SELECTION_CRITERIA_ALL | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
| AP_INV_SELECTION_CRITERIA_ALL | hz_parties | PARTY_ID |
| AP_INV_SELECTION_CRITERIA_ALL | ce_bank_acct_uses_all | CE_BANK_ACCT_USE_ID |
| AP_INV_SELECTION_CRITERIA_ALL | ce_payment_documents | PAYMENT_DOCUMENT_ID |
| AP_INV_SELECTION_CRITERIA_ALL | iby_acct_pmt_profiles_b | PAYMENT_PROFILE_ID |
| ap_currency_group | ap_inv_selection_criteria_all | CHECKRUN_ID |
| ap_checks_all | ap_inv_selection_criteria_all | CHECKRUN_ID |
| ap_pay_group | ap_inv_selection_criteria_all | CHECKRUN_ID |
| ap_ppr_multi_select_criteria | ap_inv_selection_criteria_all | CHECKRUN_ID |
| ap_user_exchange_rates | ap_inv_selection_criteria_all | CHECKRUN_ID |
| ap_selected_invoices_all | ap_inv_selection_criteria_all | CHECKRUN_ID |
| ap_unselected_invoices_all | ap_inv_selection_criteria_all | CHECKRUN_ID |
| ap_ou_group | ap_inv_selection_criteria_all | CHECKRUN_ID |
| ap_payment_schedules_all | ap_inv_selection_criteria_all | CHECKRUN_ID |
| ap_le_group | ap_inv_selection_criteria_all | CHECKRUN_ID |
| ap_awt_temp_distributions_all | ap_inv_selection_criteria_all | CHECKRUN_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_INV_SELECTION_CRITERIA_N1 | Non Unique | Default | STATUS, PERIOD_NAME |
| AP_INV_SELECTION_CRITERIA_N5 | Non Unique | Default | CHECK_DATE |
| AP_INV_SELECTION_CRITERIA_N6 | Non Unique | Default | CREATION_DATE |
| AP_INV_SELECTION_CRITERIA_N7 | Non Unique | Default | UPPER("CHECKRUN_NAME"), ORG_ID |
| AP_INV_SELECTION_CRITERIA_U1 | Unique | Default | CHECKRUN_NAME, ORG_ID |
| AP_INV_SELECTION_CRITERIA_U2 | Unique | Default | CHECKRUN_ID |