AR_CASH_RECEIPTS_ALL
The AR_CASH_RECEIPTS_ALL table stores one record for each receipt that you enter. Oracle Receivables concurrently creates records in the AR_CASH_RECEIPT_HISTORY_ALL, AR_PAYMENT_SCHEDULES_ALL, and AR_RECEIVABLE_APPLICATIONS_ALL tables for invoice-related receipts. For receipts that are not related to invoices, such as miscellaneous receipts, Receivables creates records in the AR_MISC_CASH_DISTRIBUTIONS_ALL table instead of the AR_RECEIVABLE_APPLICATIONS_ALL table. Receivables associates a status with each receipt. These statuses include: APP for applied, UNAPP for unapplied, UNID for unidentified, NSF for nonsufficient funds, REV for reversed receipt and STOP for stop payment. Receivables does not update the status of a receipt from UNAPP to APP until the entire amount of the receipt is either applied or placed on account. A receipt can have a status of APP even if the entire receipt amount is placed on account. Cash receipts proceed through the confirmation, remittance, and clearance steps. Each step creates rows in the AR_CASH_RECEIPT_HISTORY table. The CODE_COMBINATION_ID column in this table stores the general ledger accounts that are debited and credited as part of the cycle of steps. The RECEIVABLES_TRX_ID column links the AR_CASH_RECEIPTS_ALL table to AR_RECEIVABLES_TRX_ALL table and identifies receivables activity associated with miscellaneous receipts. The DISTRIBUTION_SET_ID column links AR_CASH_RECEIPTS_ALL table to AR_DISTRIBUTION_SETS_ALL table and identifies distribution set and distribution set line accounts that are credited for miscellaneous receipts. The CUSTOMER_BANK_ACCOUNT_ID column is a foreign key to the IBY_EXT_BANK_ACCOUNTS table for bank accounts that do not belong to you and have a type of EXTERNAL. The primary key for this table is CASH_RECEIPT_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AR_CASH_RECEIPTS_PK |
CASH_RECEIPT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| CASH_RECEIPT_ID | NUMBER | 18 | Yes | Cash receipt identifier. | ||
| COLLECTOR_ID | NUMBER | 18 | Collector identifier. | |||
| RECEIPT_BATCH_ID | NUMBER | 18 | Receipt batch identifier. | |||
| REMITTANCE_BATCH_ID | NUMBER | 18 | Remittance batch identifier. | |||
| RECON_FLAG | VARCHAR2 | 1 | Added the column as part of the Cash Management uptake on ARP_CASHBOOK. The value of the column will be defaulted to N in Receivables and modified by Cash Management during bank reconciliation. | |||
| LOGICAL_GROUP_REFERENCE | VARCHAR2 | 30 | A column that is added as part of the Cash Management uptake on ARP_CASHBOOK and used in payments. | |||
| 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. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| 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. | |||
| AMOUNT | NUMBER | Yes | Amount of the payment entry, denormalized from the history record to allow querying on amount | |||
| TAX_AMOUNT | NUMBER | Tax amount of the miscellaneous receipt. | ||||
| SET_OF_BOOKS_ID | NUMBER | 18 | Yes | General ledger set of books used. Only one is supported currently. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code of the payment batch associated with this payment entry | ||
| RECEIVABLES_TRX_ID | NUMBER | 18 | Identifier of the transaction associated with this payment entry | |||
| PAY_FROM_CUSTOMER | NUMBER | 18 | Identifier of the customer associated with this payment entry | |||
| STATUS | VARCHAR2 | 30 | Identifies whether the status of this payment entry is applied, unapplied, unidentified, insufficient funds, reverse payment or stop payment | |||
| TYPE | VARCHAR2 | 20 | Identifies the category of the payment entry - either CASH or MISC; when coding, please use = 'MISC' or != 'MISC' (instead of = 'CASH') because of internal customization | |||
| RECEIPT_NUMBER | VARCHAR2 | 30 | Cash receipt number | |||
| RECEIPT_DATE | DATE | Yes | This is the receipt date. | |||
| MISC_PAYMENT_SOURCE | VARCHAR2 | 30 | Identifies the source of the miscellaneous receipt | |||
| COMMENTS | VARCHAR2 | 2000 | Comments about this receipt record | |||
| DISTRIBUTION_SET_ID | NUMBER | 18 | Identifier of the distribution set associated with this payment entry | |||
| REVERSAL_DATE | DATE | Date payment entry reversed | ||||
| REVERSAL_CATEGORY | VARCHAR2 | 20 | Identifies the reason why the payment entry was reversed | |||
| REVERSAL_REASON_CODE | VARCHAR2 | 30 | Indicates reason for reversing receipt, defined by user | |||
| REVERSAL_COMMENTS | VARCHAR2 | 240 | Comments regarding reversal | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Defines multiple currency exchange rates for the same date | |||
| EXCHANGE_RATE | NUMBER | Exchange rate used to convert foreign amounts into functional currency | ||||
| EXCHANGE_DATE | DATE | Date for which rate selected | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Receipts (AR_CASH_RECEIPTS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipts (AR_CASH_RECEIPTS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipts (AR_CASH_RECEIPTS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipts (AR_CASH_RECEIPTS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipts (AR_CASH_RECEIPTS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipts (AR_CASH_RECEIPTS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipts (AR_CASH_RECEIPTS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipts (AR_CASH_RECEIPTS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipts (AR_CASH_RECEIPTS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipts (AR_CASH_RECEIPTS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipts (AR_CASH_RECEIPTS) | ||
| REMITTANCE_BANK_ACCOUNT_ID | NUMBER | 18 | Identifies the user's bank account for depositing the receipt | |||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipts (AR_CASH_RECEIPTS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipts (AR_CASH_RECEIPTS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipts (AR_CASH_RECEIPTS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipts (AR_CASH_RECEIPTS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipts (AR_CASH_RECEIPTS) | ||
| CONFIRMED_FLAG | VARCHAR2 | 1 | This is null or Y when the cash receipt is confirmed. It is N if the cash receipt is not confirmed. Always use null value (confirmed_flag,'Y') when checking this column. | |||
| CUSTOMER_BANK_ACCOUNT_ID | NUMBER | 18 | Identifies the customer's bank account from where the receipt was paid | |||
| CUSTOMER_SITE_USE_ID | NUMBER | 18 | Identifies the customer's location | |||
| DEPOSIT_DATE | DATE | This will be a user column, and will have no significance within the system | ||||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |||
| PROGRAM_ID | NUMBER | 18 | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||||
| RECEIPT_METHOD_ID | NUMBER | 18 | Yes | Identifies the payment method of the receipt | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| SELECTED_FOR_FACTORING_FLAG | VARCHAR2 | 1 | Indicates if the receipt amount is discounted | |||
| SELECTED_REMITTANCE_BATCH_ID | NUMBER | 18 | Identifies the batch created by the receipt remitting process | |||
| FACTOR_DISCOUNT_AMOUNT | NUMBER | The amount determined to factor the receipt | ||||
| USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Code defined by public sector accounting | Government Receipts (AR_CASH_RECEIPTS_GOV) | ||
| USSGL_TRANSACTION_CODE_CONTEXT | VARCHAR2 | 30 | Descriptive Flexfield structure defining column for public sector accounting | Government Receipts (AR_CASH_RECEIPTS_GOV) | ||
| DOC_SEQUENCE_VALUE | NUMBER | 18 | Value assigned to document receipt | |||
| DOC_SEQUENCE_ID | NUMBER | 18 | Identifies database sequence used to assign document number to receipt | |||
| VAT_TAX_ID | NUMBER | 18 | This column refers to the VAT tax that this miscellaneous receipt is subject | |||
| REFERENCE_TYPE | VARCHAR2 | 30 | Indicates if this Miscellaneous Receipts is a PAYMENT, RECEIPT, or REMITTANCE | |||
| REFERENCE_ID | NUMBER | 18 | Foreign key to the AR_BATCHES, AR_CASH_RECEIPTS, or AP_CHECKS tables | |||
| CUSTOMER_RECEIPT_REFERENCE | VARCHAR2 | 30 | This column is used to store a customer reference value that the customer supplies at confirmation time | |||
| OVERRIDE_REMIT_ACCOUNT_FLAG | VARCHAR2 | 1 | Yes or No flag that indicates if the remittance selection process can override the remittance bank account, when a value indicates null then the flag should be considered as yes. | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| ANTICIPATED_CLEARING_DATE | DATE | Date the receipt is expected to clear the bank | ||||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | 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. | |||
| 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. | ||||
| 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. | ||||
| ISSUER_NAME | VARCHAR2 | 50 | Issuer name of Notes Receivable (Asia Pacific requirement) | |||
| ISSUE_DATE | DATE | Date this Note Receivable was issued (Asia Pacific requirement) | ||||
| ISSUER_BANK_BRANCH_ID | NUMBER | 18 | Bank / Branch issuing the Note Receivable (Asia Pacific requirement) | |||
| CUSTOMER_BANK_BRANCH_ID | NUMBER | 18 | Unique identifier for customer bank branch ID | |||
| PAYMENT_SERVER_ORDER_NUM | VARCHAR2 | 80 | Identifies credit card payment authorized by Oracle Payment Server | |||
| APPROVAL_CODE | VARCHAR2 | 80 | Payment approval code from credit card issuer | |||
| ADDRESS_VERIFICATION_CODE | VARCHAR2 | 80 | Credit card address verification code from Oracle Payment Server | |||
| TAX_RATE | NUMBER | The new tax rate entered when you override the rate for an ad hoc tax code | ||||
| ACTUAL_VALUE_DATE | DATE | The date cash is withdrawn or deposited in a bank account | ||||
| POSTMARK_DATE | DATE | The postmark date of the Receipt. Updated for record type 6. Used for discount calculation | ||||
| APPLICATION_NOTES | VARCHAR2 | 2000 | Reference number that could not be matched to a transaction number during lockbox validation. | |||
| UNIQUE_REFERENCE | VARCHAR2 | 32 | Unique identifier for the automatic receipt. | |||
| PROMISE_SOURCE | VARCHAR2 | 30 | Source that generated this promise to pay | |||
| REC_VERSION_NUMBER | NUMBER | 18 | Indicates receipt version number for audit purposes | |||
| CC_ERROR_CODE | VARCHAR2 | 80 | Error code from credit card payment processor | |||
| CC_ERROR_TEXT | VARCHAR2 | 255 | User-enterable description for credit card error code | |||
| CC_ERROR_FLAG | VARCHAR2 | 1 | Y indicates a transaction had a credit card processing error | |||
| REMIT_BANK_ACCT_USE_ID | NUMBER | 18 | The unique identifier of the remittance bank account use id to which the automatic receipt will be deposited | |||
| OLD_CUSTOMER_BANK_BRANCH_ID | NUMBER | 18 | Identifier of the old default remittance bank branch of the payment batch | |||
| OLD_ISSUER_BANK_BRANCH_ID | NUMBER | 18 | Identifier of the old default remittance bank branch of the payment batch | |||
| LEGAL_ENTITY_ID | NUMBER | 18 | Identifies the legal entity to receive this receipt | |||
| PAYMENT_TRXN_EXTENSION_ID | NUMBER | 18 | Oracle Payments transaction identifier for processing a credit card or bank account payment. | |||
| AX_ACCOUNTED_FLAG | VARCHAR2 | 1 | Upgrade flag to indicate the distributions have been upgraded by AX | |||
| OLD_CUSTOMER_BANK_ACCOUNT_ID | NUMBER | 18 | Old customer bank account identifier. | |||
| 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. | ||
| RESOURCE_ID | NUMBER | 18 | This the PARTY_ID of the receivable specialist to whom the current receipt is assigned. | |||
| AUTOAPPLY_FLAG | VARCHAR2 | 1 | Indicator for Automatch to pick the receipt | |||
| AUTOMATCH_REQUEST_ID | NUMBER | 18 | Request Id of Automatch Run | |||
| CODE_COMBINATION_ID | NUMBER | 18 | Accounting identifier. | |||
| PREV_PAY_FROM_CUSTOMER | NUMBER | 18 | Identifier of the customer that was previously associated with this payment entry. | |||
| PREV_CUSTOMER_SITE_USE_ID | NUMBER | 18 | Identifier of the customer account site that was previously associated with this payment entry. | |||
| RECOMMENDATION_COUNT | NUMBER | 18 | Total number of application recommendations available for this receipt. | |||
| STRUCTURED_PAYMENT_REFERENCE | VARCHAR2 | 256 | An industry standard reference on receivables transactions composed of letters, check digits, and transaction information, used to identify the transaction, transaction lines, and its payments to the customer and bank. | |||
| FUNDS_STATUS_CODE | VARCHAR2 | 30 | Status of the funds update on the receipt. Valid values are mapped to the lookup ORA_XCC_FUNDS_STATUS. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_CASH_RECEIPTS_ALL | iby_ext_bank_accounts | CUSTOMER_BANK_ACCOUNT_ID |
| AR_CASH_RECEIPTS_ALL | hz_cust_site_uses_all | CUSTOMER_SITE_USE_ID |
| AR_CASH_RECEIPTS_ALL | ce_bank_acct_uses_all | REMIT_BANK_ACCT_USE_ID |
| AR_CASH_RECEIPTS_ALL | ar_batches_all | SELECTED_REMITTANCE_BATCH_ID |
| AR_CASH_RECEIPTS_ALL | ar_distribution_sets_all | DISTRIBUTION_SET_ID |
| AR_CASH_RECEIPTS_ALL | iby_fndcpt_tx_extensions | PAYMENT_TRXN_EXTENSION_ID |
| AR_CASH_RECEIPTS_ALL | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
| AR_CASH_RECEIPTS_ALL | ar_receipt_methods | RECEIPT_METHOD_ID |
| AR_CASH_RECEIPTS_ALL | xle_entity_profiles | LEGAL_ENTITY_ID |
| AR_CASH_RECEIPTS_ALL | ar_receivables_trx_all | RECEIVABLES_TRX_ID, ORG_ID |
| AR_CASH_RECEIPTS_ALL | hz_cust_accounts | PAY_FROM_CUSTOMER |
| ra_customer_trx_all | ar_cash_receipts_all | REVERSED_CASH_RECEIPT_ID |
| ar_adjustments_all | ar_cash_receipts_all | ASSOCIATED_CASH_RECEIPT_ID |
| ar_cash_remit_refs_all | ar_cash_receipts_all | CASH_RECEIPT_ID |
| hes_transaction_post_all | ar_cash_receipts_all | CASH_RECEIPT_ID |
| hes_transaction_post_all | ar_cash_receipts_all | RESULT_CASH_RECEIPT_ID |
| ar_trx_dist_line_balances_all | ar_cash_receipts_all | CASH_RECEIPT_ID |
| ar_autorec_exceptions | ar_cash_receipts_all | CASH_RECEIPT_ID |
| ar_activity_details | ar_cash_receipts_all | CASH_RECEIPT_ID |
| ar_trx_summary_hist | ar_cash_receipts_all | CASH_RECEIPT_ID |
| arb_payment_audit | ar_cash_receipts_all | CASH_RECEIPT_ID |
| ar_misc_cash_distributions_all | ar_cash_receipts_all | CASH_RECEIPT_ID |
| ar_payment_schedules_all | ar_cash_receipts_all | CASH_RECEIPT_ID_LAST |
| ar_payment_schedules_all | ar_cash_receipts_all | CASH_RECEIPT_ID |
| ar_payment_schedules_all | ar_cash_receipts_all | ASSOCIATED_CASH_RECEIPT_ID |
| ar_payment_schedules_all | ar_cash_receipts_all | REVERSED_CASH_RECEIPT_ID |
| ar_cash_receipt_history_all | ar_cash_receipts_all | CASH_RECEIPT_ID |
| ar_rate_adjustments_all | ar_cash_receipts_all | CASH_RECEIPT_ID |
| ar_receivable_applications_all | ar_cash_receipts_all | CASH_RECEIPT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AR_CASH_RECEIPTS_N1 | Non Unique | Default | SELECTED_REMITTANCE_BATCH_ID |
| AR_CASH_RECEIPTS_N10 | Non Unique | Default | PAYMENT_SERVER_ORDER_NUM |
| AR_CASH_RECEIPTS_N11 | Non Unique | Default | ACTUAL_VALUE_DATE |
| AR_CASH_RECEIPTS_N12 | Non Unique | Default | CC_ERROR_FLAG |
| AR_CASH_RECEIPTS_N13 | Non Unique | Default | PAY_FROM_CUSTOMER |
| AR_CASH_RECEIPTS_N14 | Non Unique | Default | RECEIPT_BATCH_ID |
| AR_CASH_RECEIPTS_N15 | Non Unique | Default | REMITTANCE_BATCH_ID |
| AR_CASH_RECEIPTS_N16 | Non Unique | Default | RECON_FLAG |
| AR_CASH_RECEIPTS_N17 | Non Unique | Default | AUTOMATCH_REQUEST_ID |
| AR_CASH_RECEIPTS_N18 | Non Unique | Default | UPPER("RECEIPT_NUMBER") |
| AR_CASH_RECEIPTS_N19 | Non Unique | Default | PAYMENT_TRXN_EXTENSION_ID |
| AR_CASH_RECEIPTS_N3 | Non Unique | Default | RECEIVABLES_TRX_ID |
| AR_CASH_RECEIPTS_N5 | Non Unique | Default | RECEIPT_NUMBER, ORG_ID |
| AR_CASH_RECEIPTS_N6 | Non Unique | Default | DEPOSIT_DATE |
| AR_CASH_RECEIPTS_N7 | Non Unique | Default | REVERSAL_DATE |
| AR_CASH_RECEIPTS_N8 | Non Unique | Default | RECEIPT_DATE |
| AR_CASH_RECEIPTS_N9 | Non Unique | Default | REQUEST_ID, CC_ERROR_FLAG |
| AR_CASH_RECEIPTS_U1 | Unique | Default | CASH_RECEIPT_ID |