[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_INV_SELECTION_CRITERIA_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_INV_SELECTION_CRITERIA_ALL
|
| Subobject Name: | |
| Status: | VALID |
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.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AP_INV_SELECTION_CRITERIA_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CHECKRUN_NAME
ORG_ID
|
| AP_INV_SELECTION_CRITERIA_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
CHECKRUN_ID
|
| AP_INV_SELECTION_CRITERIA_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
STATUS
PERIOD_NAME
|
| AP_INV_SELECTION_CRITERIA_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CHECK_STOCK_ID
|
| AP_INV_SELECTION_CRITERIA_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BANK_ACCOUNT_NAME
|
| AP_INV_SELECTION_CRITERIA_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BATCH_SET_ID
BATCH_RUN_NAME
|
| AP_INV_SELECTION_CRITERIA_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CHECK_DATE
|
| AP_INV_SELECTION_CRITERIA_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CREATION_DATE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CHECKRUN_NAME | VARCHAR2 | (255) | Yes | Payment batch name |
| CHECK_DATE | DATE | Yes | Payment Date | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
| BANK_ACCOUNT_NAME | VARCHAR2 | (80) | No longer used | |
| PERIOD_NAME | VARCHAR2 | (15) | Period name | |
| PAY_THRU_DATE | DATE | Pay through date | ||
| VENDOR_PAY_GROUP | VARCHAR2 | (25) | No longer Used | |
| HI_PAYMENT_PRIORITY | NUMBER | (2) | Highest payment priority of invoices to select | |
| LOW_PAYMENT_PRIORITY | NUMBER | (2) | Lowest payment priority of invoices to select | |
| MAX_PAYMENT_AMOUNT | NUMBER | No longer Used | ||
| MIN_CHECK_AMOUNT | NUMBER | No longer Used | ||
| MAX_OUTLAY | NUMBER | No longer Used | ||
| 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 | |
| CHECK_STOCK_ID | NUMBER | (15) | No longer Used | |
| CURRENCY_CODE | VARCHAR2 | (15) | No longer Used | |
| 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 | ||
| DOCUMENT_ORDER_LOOKUP_CODE | VARCHAR2 | (25) | No longer Used | |
| AUDIT_REQUIRED_FLAG | VARCHAR2 | (1) | No longer Used | |
| INTERVAL | NUMBER | (15) | No longer Used | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
| CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
| VOLUME_SERIAL_NUMBER | VARCHAR2 | (6) | No longer Used | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | No longer Used | |
| USSGL_TRX_CODE_CONTEXT | VARCHAR2 | (30) | No longer Used | |
| ZERO_AMOUNTS_ALLOWED | VARCHAR2 | (1) | No longer used | |
| START_PRINT_DOCUMENT | NUMBER | (15) | No longer Used | |
| END_PRINT_DOCUMENT | NUMBER | (15) | No longer Used | |
| FIRST_VOUCHER_NUMBER | NUMBER | (15) | First available voucher number in document sequence for payment batch document category | |
| FIRST_AVAILABLE_DOCUMENT | NUMBER | (15) | No longer Used | |
| PAYMENT_METHOD_LOOKUP_CODE | VARCHAR2 | (25) | No longer Used | |
| ZERO_INVOICES_ALLOWED | VARCHAR2 | (1) | Flag indicating whether scheduled payments with zero amount remaining will be selected during a payment batch | |
| ORG_ID | NUMBER | (15) | Organization identifier | |
| CHECKRUN_ID | NUMBER | (15) | Yes | Payment process request identifier |
| BATCH_IDENTIFIER | VARCHAR2 | (30) | No longer Used | |
| BANK_ACCOUNT_ID | NUMBER | (15) | No longer used | |
| TEMPLATE_FLAG | VARCHAR2 | (1) | No longer Used | |
| TRANSFER_PRIORITY | VARCHAR2 | (25) | Transfer priority | |
| BATCH_RUN_NAME | VARCHAR2 | (30) | No longer Used | |
| BATCH_SET_ID | NUMBER | (15) | No longer used | |
| BATCH_SET_LINE_ID | NUMBER | (15) | No longer used | |
| FUTURE_DATED_PAYMENT_FLAG | VARCHAR2 | (30) | No longer used | |
| ANTICIPATED_VALUE_DATE | DATE | No longer used | ||
| INVOICE_BATCH_ID | NUMBER | (15) | Invoice Batch Identifier | |
| VENDOR_ID | NUMBER | (15) | Supplier Identifier | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Who Column | |
| PROGRAM_ID | NUMBER | (15) | Concurrent Who Column | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent Who Column | ||
| REQUEST_ID | NUMBER | (15) | Concurrent Who Column | |
| TEMPLATE_ID | NUMBER | (15) | Payment Process Template Identifier | |
| PAY_FROM_DATE | DATE | Pay from Date | ||
| VENDOR_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | Supplier Type. Based on PO Lookup Type VENDOR TYPES | |
| PAYMENT_PROFILE_ID | NUMBER | (15) | 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 code. | |
| 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. | |
| RESUBMIT_FLAG | VARCHAR2 | (1) | NEVER USED | |
| NEXT_VOUCHER_NUMBER | NUMBER | (15) | Next available voucher number in document sequence for payment batch document category | |
| PARTY_ID | NUMBER | (15) | Party Identifier | |
| PAYMENT_DOCUMENT_ID | NUMBER | (15) | Payment Document Identifier | |
| CE_BANK_ACCT_USE_ID | NUMBER | (15) | CE Bank Account Use Identifier | |
| INV_AWT_EXISTS_FLAG | VARCHAR2 | (1) | Flag to track if the PPR contains invoices that has awt associated with it. This flag will determine the values of rejection code that must be passed to the IBY packages. |
Cut, paste (and edit) the following text to query this object:
SELECT CHECKRUN_NAME
, CHECK_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, BANK_ACCOUNT_NAME
, PERIOD_NAME
, PAY_THRU_DATE
, VENDOR_PAY_GROUP
, HI_PAYMENT_PRIORITY
, LOW_PAYMENT_PRIORITY
, MAX_PAYMENT_AMOUNT
, MIN_CHECK_AMOUNT
, MAX_OUTLAY
, PAY_ONLY_WHEN_DUE_FLAG
, STATUS
, CHECK_STOCK_ID
, CURRENCY_CODE
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, EXCHANGE_DATE
, DOCUMENT_ORDER_LOOKUP_CODE
, AUDIT_REQUIRED_FLAG
, INTERVAL
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, VOLUME_SERIAL_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, USSGL_TRANSACTION_CODE
, USSGL_TRX_CODE_CONTEXT
, ZERO_AMOUNTS_ALLOWED
, START_PRINT_DOCUMENT
, END_PRINT_DOCUMENT
, FIRST_VOUCHER_NUMBER
, FIRST_AVAILABLE_DOCUMENT
, PAYMENT_METHOD_LOOKUP_CODE
, ZERO_INVOICES_ALLOWED
, ORG_ID
, CHECKRUN_ID
, BATCH_IDENTIFIER
, BANK_ACCOUNT_ID
, TEMPLATE_FLAG
, TRANSFER_PRIORITY
, BATCH_RUN_NAME
, BATCH_SET_ID
, BATCH_SET_LINE_ID
, FUTURE_DATED_PAYMENT_FLAG
, ANTICIPATED_VALUE_DATE
, INVOICE_BATCH_ID
, VENDOR_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, TEMPLATE_ID
, PAY_FROM_DATE
, VENDOR_TYPE_LOOKUP_CODE
, PAYMENT_PROFILE_ID
, INV_EXCHANGE_RATE_TYPE
, PAYABLES_REVIEW_SETTINGS
, CALC_AWT_INT_FLAG
, PAYMENTS_REVIEW_SETTINGS
, DOCUMENT_REJECTION_LEVEL_CODE
, PAYMENT_REJECTION_LEVEL_CODE
, CREATE_INSTRS_FLAG
, PAY_GROUP_OPTION
, CURRENCY_GROUP_OPTION
, LE_GROUP_OPTION
, OU_GROUP_OPTION
, PAYMENT_METHOD_CODE
, BANK_CHARGE_BEARER
, SETTLEMENT_PRIORITY
, RESUBMIT_FLAG
, NEXT_VOUCHER_NUMBER
, PARTY_ID
, PAYMENT_DOCUMENT_ID
, CE_BANK_ACCT_USE_ID
, INV_AWT_EXISTS_FLAG
FROM AP.AP_INV_SELECTION_CRITERIA_ALL;
AP.AP_INV_SELECTION_CRITERIA_ALL does not reference any database object
AP.AP_INV_SELECTION_CRITERIA_ALL is referenced by following:
APPS
AP_INVOICE_SELECTION_CRITERIA
AP_INV_SELECTION_CRITERIA_ALL
|
|
|
|