Search Results ar_cash_receipts_all




Here's a detailed description of the AR_CASH_RECEIPTS_ALL table in Oracle E-Business Suite (EBS):

Table Name: AR_CASH_RECEIPTS_ALL

Purpose:
- Stores information about cash receipts and payments received from customers
- Tracks detailed financial transaction details for accounts receivable

Key Columns:
1. CASH_RECEIPT_ID (Primary Key)
- Unique identifier for each cash receipt transaction
- Sequentially generated value

2. RECEIPT_NUMBER
- Unique reference number for the cash receipt
- Can be system-generated or manually entered

3. RECEIPT_DATE
- Date when the cash receipt was recorded
- Used for accounting and reporting purposes

4. AMOUNT
- Total amount of the cash receipt
- Represents the monetary value received

5. CURRENCY_CODE
- Currency in which the receipt was made
- Typically follows ISO currency standards

6. CUSTOMER_ID
- Links to the customer who made the payment
- Foreign key to HZ_PARTIES or HZ_CUST_ACCOUNTS

7. PAYMENT_METHOD
- Indicates the method of payment (e.g., check, credit card, wire transfer)

8. STATUS
- Current status of the cash receipt (e.g., Approved, Unapplied, Applied)

9. ORG_ID
- Operating unit identifier
- Supports multi-organization architecture

10. GL_DATE
- General ledger date for accounting purposes

11. DEPOSIT_DATE
- Date when funds were deposited

Common Usage:
- Cash application process
- Customer payment tracking
- Accounts receivable reconciliation
- Financial reporting

Related Tables:
- AR_RECEIVABLES_TRX_ALL
- HZ_PARTIES
- GL_CODE_COMBINATIONS

Typical Interactions:
- Integrated with Cash Management
- Used in Receipt Application process
- Supports revenue recognition

Performance Considerations:
- Indexed on CASH_RECEIPT_ID
- Regularly partitioned for large transaction volumes

This description provides a comprehensive overview of the AR_CASH_RECEIPTS_ALL table in Oracle EBS, highlighting its structure, purpose, and key characteristics.