AP_CHECKS_ALL
AP_CHECKS_ALL stores information about payments issued to suppliers or refunds received from suppliers. You need one row for each payment you issue to a supplier or refund received from a supplier. Your Oracle Payables application uses this information to record payments you make to suppliers or refunds you receive from suppliers. Your Oracle Payables application stores the supplier name and bank account name for auditing purposes, in case either one is changed after you create the payment. Your Oracle Payables application stores address information for all payments. If you allow changes to the supplier payment address on manual payments or Quick payments, your Oracle Payables application maintains the new address information in this table. Your Oracle Payables application uses BANK_ACCOUNT_NUM, BANK_NUM, and BANK_ACCOUNT_TYPE for the supplier's bank information when you use the Electronic payment method. Your Oracle Payables application stores a dummy value for CHECK_STOCK_ID for refunds, thus, CHECK_STOCK_ID should not be treated as a foreign key to AP_CHECK_STOCKS_ALL in the case of refunds.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AP_CHECKS_PK |
CHECK_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| AMOUNT | NUMBER | Yes | Payment amount in payment currency. | |||
| BANK_ACCOUNT_NAME | VARCHAR2 | 360 | Yes | Name of bank account from which payment is made. | ||
| CHECK_DATE | DATE | Yes | Date on which payment is made and mentioned on payment document. | |||
| CHECK_ID | NUMBER | 18 | Yes | Unique Identifier maintained for every payment made. | ||
| CHECK_NUMBER | NUMBER | 18 | Yes | Check number printed on physical check. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency in which payment is made. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| PAYMENT_METHOD_LOOKUP_CODE | VARCHAR2 | 25 | Payment method used to make payment. For example, check or electronic. | |||
| PAYMENT_TYPE_FLAG | VARCHAR2 | 25 | Yes | Flag that indicates the payment type | ||
| ADDRESS_LINE1 | VARCHAR2 | 240 | First address line of party to whom payment is made. | |||
| ADDRESS_LINE2 | VARCHAR2 | 240 | Second address line of party to whom payment is made. | |||
| ADDRESS_LINE3 | VARCHAR2 | 240 | Third address line of party to whom payment is made. | |||
| CHECKRUN_NAME | VARCHAR2 | 255 | Name of payment batch or quick payment identifier. | |||
| CHECK_FORMAT_ID | NUMBER | 18 | Identifier of check format used to make payment. | |||
| CHECK_STOCK_ID | NUMBER | 18 | Identifier of payment document used to make payment. | |||
| CITY | VARCHAR2 | 60 | City name of party to whom payment is made. | |||
| COUNTRY | VARCHAR2 | 60 | Country name of party to whom payment is made. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| STATUS_LOOKUP_CODE | VARCHAR2 | 25 | Status of payment (for example, NEGOTIABLE, SET UP, SPOILED) | |||
| VENDOR_NAME | VARCHAR2 | 240 | Name of supplier to whom payment is made. | |||
| VENDOR_SITE_CODE | VARCHAR2 | 240 | Name of supplier site to whom payment is made. | |||
| ZIP | VARCHAR2 | 60 | ZIP code of party address to whom payment is made. | |||
| BANK_ACCOUNT_NUM | VARCHAR2 | 30 | Supplier's bank account number for electronic payment purposes | |||
| BANK_ACCOUNT_TYPE | VARCHAR2 | 25 | Supplier's bank account type code for electronic payment purposes | |||
| BANK_NUM | VARCHAR2 | 30 | Supplier's bank number for electronic payment purposes | |||
| CHECK_VOUCHER_NUM | NUMBER | 16 | Voucher number associated with payment made. | |||
| CLEARED_AMOUNT | NUMBER | Payment amount cleared against payment in cash management. | ||||
| CLEARED_DATE | DATE | Date when payment is cleared in cash management. | ||||
| DOC_CATEGORY_CODE | VARCHAR2 | 30 | Sequential Numbering (voucher number) document category for payment | |||
| DOC_SEQUENCE_ID | NUMBER | Sequential Numbering document sequence identifier | ||||
| DOC_SEQUENCE_VALUE | NUMBER | Voucher number (sequential numbering) for payment | ||||
| RELEASED_BY | NUMBER | 18 | User that released stop payment | |||
| STATE | VARCHAR2 | 150 | State name of party to whom payment is made. | |||
| STOPPED_BY | NUMBER | 18 | User that recorded stop payment | |||
| VOID_DATE | DATE | Date on which payment is voided. | ||||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Information (AP_CHECKS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Information (AP_CHECKS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Information (AP_CHECKS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Information (AP_CHECKS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Information (AP_CHECKS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Information (AP_CHECKS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Information (AP_CHECKS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Information (AP_CHECKS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Information (AP_CHECKS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Information (AP_CHECKS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Information (AP_CHECKS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Information (AP_CHECKS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Information (AP_CHECKS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Information (AP_CHECKS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Payment Information (AP_CHECKS) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Payment Information (AP_CHECKS) | ||
| FUTURE_PAY_DUE_DATE | DATE | Negotiable date for future dated payment | ||||
| TREASURY_PAY_DATE | DATE | Date payment processed through internal clearing organization | ||||
| TREASURY_PAY_NUMBER | NUMBER | 18 | Number assigned to payment processed through internal clearing organization | |||
| USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Transaction code for creating US Standard General Ledger journal entries | |||
| USSGL_TRX_CODE_CONTEXT | VARCHAR2 | 30 | USSGL Transaction Code Descriptive Flexfield context column | |||
| RECONCILIATION_BATCH_ID | NUMBER | 18 | Supports integration with Oracle Cash Management | |||
| CLEARED_BASE_AMOUNT | NUMBER | Payment cleared amount in functional currency | ||||
| CLEARED_EXCHANGE_RATE | NUMBER | Exchange rate at which the payment cleared, for foreign currency payments only | ||||
| CLEARED_EXCHANGE_DATE | DATE | Date clearing exchange rate is effective, usually accounting date of a transaction | ||||
| CLEARED_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Exchange rate type at payment clearing time, for foreign currency payments only | |||
| ADDRESS_LINE4 | VARCHAR2 | 240 | Fourth address line of payment. Used for flexible address formatting | |||
| COUNTY | VARCHAR2 | 150 | Used for flexible address formatting. Also used for matching AP and AR addresses | |||
| ADDRESS_STYLE | VARCHAR2 | 30 | Used as context value in FAF descriptive flexfields. Do not populate. Instead, join to FND_TERRITORIES where territory_code=country. | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| VENDOR_ID | NUMBER | 18 | Supplier identifier. Supports integration with Oracle Cash Management | |||
| VENDOR_SITE_ID | NUMBER | 18 | Supplier site identifier. Supports integration with Oracle Cash Management | |||
| BASE_AMOUNT | NUMBER | Payment amount in functional currency | ||||
| CHECKRUN_ID | NUMBER | 18 | Unique identifier of payment batch, not applicable to quick payment. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| CLEARED_ERROR_AMOUNT | NUMBER | Cleared error amount of the payment. | ||||
| CLEARED_CHARGES_AMOUNT | NUMBER | Cleared charges amount of the payment. | ||||
| CLEARED_ERROR_BASE_AMOUNT | NUMBER | Cleared payment error amount in functional currency | ||||
| CLEARED_CHARGES_BASE_AMOUNT | NUMBER | Cleared payment charges amount in functional currency | ||||
| POSITIVE_PAY_STATUS_CODE | VARCHAR2 | 25 | Set by and used by Positive Pay Report to select records | |||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| TRANSFER_PRIORITY | VARCHAR2 | 25 | Transfer priority of the payment. | |||
| EXTERNAL_BANK_ACCOUNT_ID | NUMBER | 18 | External bank account identifier | |||
| STAMP_DUTY_AMT | NUMBER | Stamp duty tax amount for globalization | ||||
| STAMP_DUTY_BASE_AMT | NUMBER | Stamp duty tax amount in functional currency for globalization | ||||
| MRC_CLEARED_BASE_AMOUNT | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and payment cleared amount pairs | |||
| MRC_CLEARED_EXCHANGE_RATE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate of cleared payment pairs | |||
| MRC_CLEARED_EXCHANGE_DATE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion date of cleared payment pairs | |||
| MRC_CLEARED_EXCHANGE_RATE_TYPE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate type at clearing time pairs | |||
| MRC_EXCHANGE_RATE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate pairs | |||
| MRC_EXCHANGE_DATE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion date pairs | |||
| MRC_EXCHANGE_RATE_TYPE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate type pairs | |||
| MRC_BASE_AMOUNT | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and payment amount pairs | |||
| MRC_CLEARED_ERROR_BASE_AMOUNT | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and cleared payment error base amount pairs | |||
| MRC_CLEARED_CHARGES_BASE_AMT | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and cleared payment charges base amount pairs | |||
| MRC_STAMP_DUTY_BASE_AMT | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and stamp duty tax pairs | |||
| ACTUAL_VALUE_DATE | DATE | Actual Value Date. For use by Cash Management | ||||
| ANTICIPATED_VALUE_DATE | DATE | Anticipated Value Date. For use by Cash Management | ||||
| MATURITY_EXCHANGE_DATE | DATE | Date maturity exchange rate is effective, usually the maturity date for the payment | ||||
| MATURITY_EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Exchange rate type at future dated payment maturity time, for foreign currency payments only | |||
| MATURITY_EXCHANGE_RATE | NUMBER | Exchange rate at future dated payment maturity time, for foreign currency payments only | ||||
| DESCRIPTION | VARCHAR2 | 240 | User description for a payment. | |||
| RELEASED_DATE | DATE | Date and time user released stop payment | ||||
| STOPPED_DATE | DATE | Date and time user recorded stop payment | ||||
| MRC_MATURITY_EXG_DATE | VARCHAR2 | 2000 | Multiple reporting currencies only: Concatenated string of reporting set of books id and currency conversion date at maturity time pairs | |||
| MRC_MATURITY_EXG_RATE | VARCHAR2 | 2000 | Multiple reporting currencies only: Concatenated string of reporting set of books id and currency conversion rate at maturity time pairs | |||
| MRC_MATURITY_EXG_RATE_TYPE | VARCHAR2 | 2000 | Multiple reporting currencies only: Concatenated string of reporting set of books id and currency conversion type at maturity time pairs | |||
| IBAN_NUMBER | VARCHAR2 | 40 | International bank account number. Used internationally to uniquely identify the account of a customer at a financial institution. During bank entry, the system validates the value to ensure that it is a valid IBAN. | |||
| CE_BANK_ACCT_USE_ID | NUMBER | 18 | Identifier of internal bank account used. | |||
| PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Payment method used to make payment. | |||
| PARTY_ID | NUMBER | 18 | Unique identifier of party to whom payment is made. | |||
| PARTY_SITE_ID | NUMBER | 18 | Identifier of party site to whom payment is made. | |||
| PAYMENT_PROFILE_ID | NUMBER | 18 | Payment process profile identifier | |||
| SETTLEMENT_PRIORITY | VARCHAR2 | 30 | The priority with which the financial institution or payment system should settle payment for this document. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY' | |||
| BANK_CHARGE_BEARER | VARCHAR2 | 30 | Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER. | |||
| LEGAL_ENTITY_ID | NUMBER | 18 | Identifier of legal entity stamped on the payment transaction. | |||
| PAYMENT_DOCUMENT_ID | NUMBER | 18 | Identifier of payment document used to make payment. | |||
| COMPLETED_PMTS_GROUP_ID | NUMBER | 18 | Completed payments group identifier | |||
| PAYMENT_ID | NUMBER | 18 | Oracle Payments payment identifier | |||
| PAYMENT_INSTRUCTION_ID | NUMBER | 18 | Identifier of payment file generated for given payment. | |||
| PROVINCE | VARCHAR2 | 150 | Province of party to whom payment is made. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Type of exchange rate used to convert foreign currency payments. | |||
| EXCHANGE_RATE | NUMBER | Exchange rate used to convert foreign currency payments. | ||||
| EXCHANGE_DATE | DATE | Date when the exchange rate was used to convert foreign currency payments. | ||||
| 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. | ||
| RECON_FLAG | VARCHAR2 | 1 | Recon flag is set to 'Y' on Clearing and set to 'N' on unclearing apis called by CE | |||
| LOGICAL_GROUP_REFERENCE | VARCHAR2 | 30 | LOGICAL_GROUP_REFERENCE added as per CE request. Values passed by Oracle Payments. | |||
| EMPLOYEE_ADDRESS_CODE | VARCHAR2 | 15 | Address Code for Employee. Can be either 'HOME' or 'OFFICE'. | |||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| X_CURR_RATE_TYPE | VARCHAR2 | 30 | The conversion rate type used to convert the invoice currency to payment currency. | |||
| REMIT_TO_SUPPLIER_NAME | VARCHAR2 | 240 | Third party supplier | |||
| REMIT_TO_SUPPLIER_ID | NUMBER | 18 | Third party supplier identifier | |||
| REMIT_TO_ADDRESS_NAME | VARCHAR2 | 240 | Remit-to address where the payment should be sent | |||
| REMIT_TO_ADDRESS_ID | NUMBER | 18 | Remit-to address identifier where the payment should be sent | |||
| RELATIONSHIP_ID | NUMBER | 18 | Third party relationship identifier | |||
| ESCHEATMENT_VENDOR_ID | NUMBER | 18 | Escheatment authority vendor identifier. | |||
| ESCHEATMENT_VENDOR_SITE_ID | NUMBER | 18 | Escheatment authority vendor site identifier. | |||
| ESCHEATMENT_INVOICE_ID | NUMBER | 18 | Escheatment invoice identifier created for the payment. | |||
| PAYMENT_MODE_CODE | VARCHAR2 | 30 | Invoice payment mode identifier. | |||
| PAYMENT_INSTRUMENT_ID | NUMBER | 18 | Funding instrument used for making payments. | |||
| PMT_INSTR_BU_ASSIGNMENT_ID | NUMBER | 18 | Payment instrument business unit assignment identifier. | |||
| BEP_TRXN_RESPONSE_ID | VARCHAR2 | 60 | Response identifier generated by payment system for a payment request. | |||
| BEP_STATUS | VARCHAR2 | 30 | Status returned by the payment system. | |||
| BEP_RESPONSE_CODE | VARCHAR2 | 30 | Response code from the payment system. | |||
| BEP_RESPONSE_DATE | TIMESTAMP | Date when the response code was sent by the payment system. | ||||
| PMT_TO_BANK_RATE_TYPE | VARCHAR2 | 30 | Type of exchange rate used to convert payment to disbursement bank account currency. | |||
| PMT_TO_BANK_RATE | NUMBER | Exchange rate used to convert payment to disbursement bank account currency. | ||||
| PMT_TO_BANK_AMOUNT | NUMBER | Payment amount in disbursement bank account currency. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AP_CHECKS_ALL | ce_bank_acct_uses_all | CE_BANK_ACCT_USE_ID |
| AP_CHECKS_ALL | gl_daily_conversion_types | CLEARED_EXCHANGE_RATE_TYPE |
| AP_CHECKS_ALL | gl_daily_conversion_types | MATURITY_EXCHANGE_RATE_TYPE |
| AP_CHECKS_ALL | ap_inv_selection_criteria_all | CHECKRUN_ID |
| AP_CHECKS_ALL | iby_pay_instructions_all | PAYMENT_INSTRUCTION_ID |
| AP_CHECKS_ALL | hz_parties | PARTY_ID |
| AP_CHECKS_ALL | hz_party_sites | PARTY_SITE_ID |
| AP_CHECKS_ALL | ce_payment_documents | PAYMENT_DOCUMENT_ID |
| AP_CHECKS_ALL | iby_acct_pmt_profiles_b | PAYMENT_PROFILE_ID |
| AP_CHECKS_ALL | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
| AP_CHECKS_ALL | iby_payments_all | PAYMENT_ID |
| AP_CHECKS_ALL | iby_ext_bank_accounts | EXTERNAL_BANK_ACCOUNT_ID |
| AP_CHECKS_ALL | iby_payment_methods_b | PAYMENT_METHOD_CODE |
| AP_CHECKS_ALL | xle_entity_profiles | LEGAL_ENTITY_ID |
| AP_CHECKS_ALL | iby_payments_all | COMPLETED_PMTS_GROUP_ID |
| AP_CHECKS_ALL | poz_suppliers | REMIT_TO_SUPPLIER_ID |
| AP_CHECKS_ALL | poz_suppliers | VENDOR_ID |
| AP_CHECKS_ALL | hz_party_sites | REMIT_TO_ADDRESS_ID |
| AP_CHECKS_ALL | poz_sup_thirdparty_payment_rel | RELATIONSHIP_ID |
| AP_CHECKS_ALL | ap_doc_sequence_audit | DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE |
| AP_CHECKS_ALL | poz_suppliers | ESCHEATMENT_VENDOR_ID |
| AP_CHECKS_ALL | poz_supplier_sites_all_m | ESCHEATMENT_VENDOR_SITE_ID |
| AP_CHECKS_ALL | ap_invoices_all | ESCHEATMENT_INVOICE_ID |
| ap_invoice_payments_all | ap_checks_all | CHECK_ID |
| ap_payment_history_all | ap_checks_all | CHECK_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_CHECKS_N1 | Non Unique | Default | CHECK_DATE |
| AP_CHECKS_N10 | Non Unique | Default | FUTURE_PAY_DUE_DATE |
| AP_CHECKS_N11 | Non Unique | Default | PARTY_ID |
| AP_CHECKS_N12 | Non Unique | Default | PAYMENT_ID |
| AP_CHECKS_N13 | Non Unique | Default | PAYMENT_INSTRUCTION_ID |
| AP_CHECKS_N14 | Non Unique | Default | CE_BANK_ACCT_USE_ID |
| AP_CHECKS_N15 | Non Unique | Default | STATUS_LOOKUP_CODE |
| AP_CHECKS_N16 | Non Unique | Default | BEP_TRXN_RESPONSE_ID |
| AP_CHECKS_N2 | Non Unique | Default | CHECK_NUMBER |
| AP_CHECKS_N3 | Non Unique | Default | CHECKRUN_NAME |
| AP_CHECKS_N4 | Non Unique | Default | PAYMENT_TYPE_FLAG |
| AP_CHECKS_N5 | Non Unique | Default | REQUEST_ID |
| AP_CHECKS_N6 | Non Unique | Default | VENDOR_ID |
| AP_CHECKS_N7 | Non Unique | Default | VENDOR_SITE_ID |
| AP_CHECKS_N8 | Non Unique | Default | CHECKRUN_ID |
| AP_CHECKS_N9 | Non Unique | Default | COMPLETED_PMTS_GROUP_ID |
| AP_CHECKS_U1 | Unique | Default | CHECK_ID |
| AP_CHECKS_U3 | Unique | Default | DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE |