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.
-
Table: AR_CASH_RECEIPTS_ALL
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CASH_RECEIPTS_ALL, object_name:AR_CASH_RECEIPTS_ALL, status:VALID, product: AR - Receivables , description: Detailed receipt information , implementation_dba_data: AR.AR_CASH_RECEIPTS_ALL ,
-
Table: AR_CASH_RECEIPTS_ALL
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.AR_CASH_RECEIPTS_ALL, object_name:AR_CASH_RECEIPTS_ALL, status:VALID, product: AR - Receivables , description: Detailed receipt information , implementation_dba_data: AR.AR_CASH_RECEIPTS_ALL ,
-
APPS.OKL_SSC_WF dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.OKL_BPD_CAP_ADV_MON_PVT dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.JG_ZZ_AERL_DT_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.GMF_AR_GET_PAYMENT_DETAILS dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.PSA_MF_MISC_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.JAI_AR_CR_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.JAI_AR_CR_TRIGGER_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.OKL_CASH_APPL_RULES_PUB dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.OKL_PAYMENT_PVT dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.OKL_INT_EXT_CSH_APP_PVT dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.AR_PREPAYMENTS_PUB dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.OKL_PAYMENT_PVT dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.FUN_XML_REPORT_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.ARP_CORRECT_CC_ERRORS dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.OE_CREDIT_CHECK_UTIL dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.OKL_BPD_MAN_RCT_HANDLE_PVT dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.CE_AUTO_BANK_CLEAR1 dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.JAI_AR_TCS_REP_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.OKL_VARIABLE_INTEREST_PVT dependencies on AR_CASH_RECEIPTS_ALL
12.2.2
-
APPS.AR_CAO_ASSIGN_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.2.2
-
APPS.JAI_AR_CR_TRIGGER_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.2.2
-
APPS.JA_JAINARDR_XMLP_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.2.2
-
APPS.FV_SLA_AR_PROCESSING_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.2.2
-
APPS.AR_TRX_SUMMARY_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.2.2
-
APPS.JAI_ARRA_TRG_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.2.2
-
APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on AR_CASH_RECEIPTS_ALL
12.2.2
-
APPS.AR_CASH_RECEIPT_PRINT_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.2.2
-
APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.2.2
-
APPS.OKL_UPDT_CASH_DTLS dependencies on AR_CASH_RECEIPTS_ALL
12.2.2
-
APPS.OE_CREDIT_CHECK_UTIL dependencies on AR_CASH_RECEIPTS_ALL
12.2.2
-
APPS.JG_ZZ_VAT_ALLOC_PRC_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.2.2
-
APPS.OKL_CASH_RECEIPT dependencies on AR_CASH_RECEIPTS_ALL
12.2.2
-
APPS.JA_JAINDTBR_XMLP_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.2.2
-
APPS.OE_CREDIT_EXPOSURE_PVT dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.OKL_UPDT_CASH_DTLS dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.OKL_VARIABLE_INTEREST_PVT dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.OKL_BPD_ADV_MON_RPT_PVT dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.OKL_BPD_ADVANCED_CASH_APP_PUB dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.OKL_BPD_CAP_PURPOSE_PVT dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.OKL_BPD_ADVANCED_CASH_APP_PVT dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.JG_ZZ_SUMMARY_AR_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.FUN_NET_CANCEL_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.OKL_PAYMENT_PUB dependencies on AR_CASH_RECEIPTS_ALL
12.1.1
-
APPS.AR_UPG_PSA_DIST_PKG dependencies on AR_CASH_RECEIPTS_ALL
12.1.1