TABLE - AR.AR_CASH_RECEIPTS_ALL

[Home] [Help] [Dependency Information] Select Etrm VersionVersion 12.1.1Version 12.2.2Search

TABLE: AR.AR_CASH_RECEIPTS_ALL

Object Details

Object Name:	AR_CASH_RECEIPTS_ALL
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_CASH_RECEIPTS_ALL
Subobject Name:
Status:	VALID

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: {{"bul:1"}}APP - Applied {{"bul:1"}}UNAPP - Unapplied {{"bul:1"}}UNID - Unidentified {{"bul:1"}}NSF - Non-sufficient funds {{"bul:1"}}REV - Reversed receipt {{"bul:1"}}STOP - Stop payment {{"bodytext"}}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 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 the AR_RECEIVABLES_TRX_ALL table and identifies the receivables activity that you select when you enter miscellaneous receipts. . The DISTRIBUTION_SET_ID column links the AR_CASH_RECEIPTS_ALL table to the AR_DISTRIBUTION_SETS_ALL table and identifies the distribution set and the distribution set line accounts that are credited when you enter miscellaneous receipts. . The CUSTOMER_BANK_ACCOUNT_ID column replaced the CUSTOMER_MICR_ID column as a pointer to the customer bank account. The CUSTOMER_BANK_ACCOUNT_ID column is a foreign key to the AP_BANK_ACCOUNTS_ALL table for bank accounts that do not belong to you and have a type of EXTERNAL. . The GL_DATE and REVERSAL_GL_DATE columns were also moved to the AR_CASH_RECEIPT_HISTORY_ALL table because each step has its own General Ledger date and accounting impact. . The primary key for this table is CASH_RECEIPT_ID, which identifies the receipt transaction that created the row for the receipt.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_CASH_RECEIPTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CASH_RECEIPT_ID
AR_CASH_RECEIPTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SELECTED_REMITTANCE_BATCH_ID
AR_CASH_RECEIPTS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_SERVER_ORDER_NUM
AR_CASH_RECEIPTS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTUAL_VALUE_DATE
AR_CASH_RECEIPTS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CC_ERROR_FLAG
AR_CASH_RECEIPTS_N13	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NVL("ACTUAL_VALUE_DATE","ANTICIPATED_CLEARING_DATE")
AR_CASH_RECEIPTS_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WORK_ITEM_STATUS_CODE CASH_APPLN_OWNER_ID WORK_ITEM_REVIEW_DATE
AR_CASH_RECEIPTS_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_TRXN_EXTENSION_ID
AR_CASH_RECEIPTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAY_FROM_CUSTOMER CUSTOMER_SITE_USE_ID
AR_CASH_RECEIPTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECEIVABLES_TRX_ID
AR_CASH_RECEIPTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECEIPT_NUMBER ORG_ID
AR_CASH_RECEIPTS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEPOSIT_DATE
AR_CASH_RECEIPTS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REVERSAL_DATE
AR_CASH_RECEIPTS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECEIPT_DATE
AR_CASH_RECEIPTS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID CC_ERROR_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
CASH_RECEIPT_ID	NUMBER	(15)	Yes	Identifier of the cash receipt
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE	Yes	Standard Who column - date when a user last updated this row.
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).
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE	Yes	Standard who column - date when this row was created.
AMOUNT	NUMBER	Yes	Amount of the payment entry, denormalized from the history record to allow querying on amount
SET_OF_BOOKS_ID	NUMBER	(15)	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	(15)	Identifier of the transaction associated with this payment entry
PAY_FROM_CUSTOMER	NUMBER	(15)	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	Date of the payment entry
MISC_PAYMENT_SOURCE	VARCHAR2	(30)	Identifies the source of the miscellaneous receipt
COMMENTS	VARCHAR2	(2000)	Comments about this receipt record
DISTRIBUTION_SET_ID	NUMBER	(15)	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 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
REMITTANCE_BANK_ACCOUNT_ID	NUMBER	(15)	Identifies the user's bank account for depositing the receipt
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
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	(15)	Identifies the customer's bank account from where the receipt was paid
CUSTOMER_SITE_USE_ID	NUMBER	(15)	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	(15)	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)	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	(15)	Yes	Identifies the payment method of the receipt
REQUEST_ID	NUMBER	(15)	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
SELECTED_FOR_FACTORING_FLAG	VARCHAR2	(1)	Indicates if the receipt amount is discounted
SELECTED_REMITTANCE_BATCH_ID	NUMBER	(15)	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
USSGL_TRANSACTION_CODE_CONTEXT	VARCHAR2	(30)	Descriptive Flexfield structure defining column for public sector accounting
DOC_SEQUENCE_VALUE	NUMBER	(15)	Value assigned to document receipt
DOC_SEQUENCE_ID	NUMBER	(15)	Identifies database sequence used to assign document number to receipt
VAT_TAX_ID	NUMBER	(15)	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	(15)	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)	This flag is Y when the remittance bank account is overridable by the remittance selection process and N when it is not. When it is null, it should be treated as Y.
ORG_ID	NUMBER	(15)	Organization identifier
ANTICIPATED_CLEARING_DATE	DATE	Date the receipt is expected to clear the bank
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Reserved for country-specific functionality
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	(15)	Bank / Branch issuing the Note Receivable (Asia Pacific requirement)
CUSTOMER_BANK_BRANCH_ID	NUMBER	(15)	Unique identifier for customer bank branch ID
MRC_EXCHANGE_RATE_TYPE	VARCHAR2	(2000)	Multiple Reporting Currencies only: Concatenated string of reporting set of books ID, currency conversion rate type pairs
MRC_EXCHANGE_RATE	VARCHAR2	(2000)	Multiple Reporting Currencies only: Concatenated string of reporting set of books ID, currency conversion rate pairs
MRC_EXCHANGE_DATE	VARCHAR2	(2000)	Multiple Reporting Currencies only: Concatenated string of reporting set of books ID, currency conversion date pairs
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 AutoLockbox validation.
UNIQUE_REFERENCE	VARCHAR2	(32)	Unique Identifier for Credit Card Receipts Please re-create the multi-org view AR_CASH_RECEIPTS to include the new column UNIQUE_REFERENCE.
PROMISE_SOURCE	VARCHAR2	(30)	Source that generated this promise to pay
REC_VERSION_NUMBER	NUMBER	(15)	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	(15)	The unique identifier of the remittance bank account use id to which the automatic receipt will be deposited
OLD_CUSTOMER_BANK_BRANCH_ID	NUMBER	(15)	Identifier of the old default remittance bank branch of the payment batch
OLD_ISSUER_BANK_BRANCH_ID	NUMBER	(15)	Identifier of the old default remittance bank branch of the payment batch
LEGAL_ENTITY_ID	NUMBER	(15)	Identifies the legal entity to receive this receipt
PAYMENT_TRXN_EXTENSION_ID	NUMBER	(15)	Payment extension identifier
AX_ACCOUNTED_FLAG	VARCHAR2	(1)	Upgrade flag to indicate the distributions have been upgraded by AX
OLD_CUSTOMER_BANK_ACCOUNT_ID	NUMBER	(15)	Identifier of the old default remittance bank account of the payment batch
CASH_APPLN_OWNER_ID	NUMBER	(15)	Identifier of the cash application owner to whom the receipt is assigned for application.
WORK_ITEM_ASSIGNMENT_DATE	DATE	Date on which the receipt is assigned to the cash application owner.
WORK_ITEM_REVIEW_DATE	DATE	Review date assigned by the cash application owner.
WORK_ITEM_STATUS_CODE	VARCHAR2	(30)	Status code of the receipt in cash application work queue.
WORK_ITEM_REVIEW_NOTE	VARCHAR2	(2000)	Review notes entered by cash application owner
PREV_PAY_FROM_CUSTOMER	NUMBER	(15)	Identifier of the customer which was associated with this payment entry previously
PREV_CUSTOMER_SITE_USE_ID	NUMBER	(15)	Identifies the customer's location which was associated with this payment entry previously
WORK_ITEM_EXCEPTION_REASON	VARCHAR2	(30)	Reserved for future use
AUTOMATCH_SET_ID	NUMBER	(15)	Reserved for future use
AUTOAPPLY_FLAG	VARCHAR2	(1)	Reserved for future use
SEQ_TYPE_LAST	VARCHAR2	(1)	Sequence Type Last

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT CASH_RECEIPT_ID , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , CREATED_BY , CREATION_DATE , AMOUNT , SET_OF_BOOKS_ID , CURRENCY_CODE , RECEIVABLES_TRX_ID , PAY_FROM_CUSTOMER , STATUS , TYPE , RECEIPT_NUMBER , RECEIPT_DATE , MISC_PAYMENT_SOURCE , COMMENTS , DISTRIBUTION_SET_ID , REVERSAL_DATE , REVERSAL_CATEGORY , REVERSAL_REASON_CODE , REVERSAL_COMMENTS , EXCHANGE_RATE_TYPE , EXCHANGE_RATE , EXCHANGE_DATE , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , REMITTANCE_BANK_ACCOUNT_ID , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , CONFIRMED_FLAG , CUSTOMER_BANK_ACCOUNT_ID , CUSTOMER_SITE_USE_ID , DEPOSIT_DATE , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , RECEIPT_METHOD_ID , REQUEST_ID , SELECTED_FOR_FACTORING_FLAG , SELECTED_REMITTANCE_BATCH_ID , FACTOR_DISCOUNT_AMOUNT , USSGL_TRANSACTION_CODE , USSGL_TRANSACTION_CODE_CONTEXT , DOC_SEQUENCE_VALUE , DOC_SEQUENCE_ID , VAT_TAX_ID , REFERENCE_TYPE , REFERENCE_ID , CUSTOMER_RECEIPT_REFERENCE , OVERRIDE_REMIT_ACCOUNT_FLAG , ORG_ID , ANTICIPATED_CLEARING_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOBAL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE_CATEGORY , ISSUER_NAME , ISSUE_DATE , ISSUER_BANK_BRANCH_ID , CUSTOMER_BANK_BRANCH_ID , MRC_EXCHANGE_RATE_TYPE , MRC_EXCHANGE_RATE , MRC_EXCHANGE_DATE , PAYMENT_SERVER_ORDER_NUM , APPROVAL_CODE , ADDRESS_VERIFICATION_CODE , TAX_RATE , ACTUAL_VALUE_DATE , POSTMARK_DATE , APPLICATION_NOTES , UNIQUE_REFERENCE , PROMISE_SOURCE , REC_VERSION_NUMBER , CC_ERROR_CODE , CC_ERROR_TEXT , CC_ERROR_FLAG , REMIT_BANK_ACCT_USE_ID , OLD_CUSTOMER_BANK_BRANCH_ID , OLD_ISSUER_BANK_BRANCH_ID , LEGAL_ENTITY_ID , PAYMENT_TRXN_EXTENSION_ID , AX_ACCOUNTED_FLAG , OLD_CUSTOMER_BANK_ACCOUNT_ID , CASH_APPLN_OWNER_ID , WORK_ITEM_ASSIGNMENT_DATE , WORK_ITEM_REVIEW_DATE , WORK_ITEM_STATUS_CODE , WORK_ITEM_REVIEW_NOTE , PREV_PAY_FROM_CUSTOMER , PREV_CUSTOMER_SITE_USE_ID , WORK_ITEM_EXCEPTION_REASON , AUTOMATCH_SET_ID , AUTOAPPLY_FLAG , SEQ_TYPE_LAST FROM AR.AR_CASH_RECEIPTS_ALL;

Dependencies

[top of page]

AR.AR_CASH_RECEIPTS_ALL does not reference any database object

AR.AR_CASH_RECEIPTS_ALL is referenced by following:

AR AR_CASH_RECEIPTS_ALL#