AR Receipts to SLA Link R12
Accounting Data Model – Receipts
•Where POSTABLE_FLAG <> ‘N’
•EVENT_ID should exist
•Distributions stored in AR_DISTRIBUTIONS_ALL (source_table=CRH and RA)
•Debit & credit amounts should match
Important columns in the AR_CASH_RECEIPTS table include:
CASH_RECEIPT_ID column
AMOUNT column
STATUS column
RECEIPT_NUMBER column
TYPE column
The AR_CASH_RECEIPTS table stores a unique record for each receipt, based on the primary key cash_receipt_id. The status column describes the state of the receipt in relation to customer invoices and balances. Valid status values are:
UNID: The receipt customer is unidentified, and no customer balance was updated.
UNAPP: The receipt customer was identified, but the receipt has neither been fully applied to a specific invoice nor placed on account.
APP: The entire amount of the receipt was either placed on account or applied to specific customer invoices.
REV: The receipt was reversed.
NSF: The receipt was reversed due to insufficient funds.
STOP: The receipt was reversed by a stop payment.
The type column identifies the receipt as either CASH or MISC to indicate whether the receipt is a customer payment or a miscellaneous receipt (not related to a receivables activity). The amount column stores the net amount of the receipt, while the receipt_number column stores the receipt number.
Important columns in the AR_CASH_RECEIPT_HISTORY table include:
CASH_RECEIPT_HISTORY_ID column
AMOUNT column
STATUS column
The AR_CASH_RECEIPT_HISTORY table stores the current status and history of a receipt. Each status change is stored as a unique transaction, based on the primary key cash_receipt_history_id. The status column describes which step of the receipt life cycle the receipt has reached. Valid status values are:
APPROVED: This status is only valid for automatic receipts, and indicates that the receipt was approved for automatic creation. These record types are never postable.
CONFIRMED: This status is only valid for automatic receipts, and indicates that the receipt was confirmed by the customer.
REMITTED: This status is valid for both manual and automatic receipts, and indicates that the receipt was remitted.
CLEARED: This status is valid for both manual and automatic receipts, and indicates that the receipt was cleared.
REVERSED: This status is valid for both manual and automatic receipts, and indicates that the receipt was reversed.
As the receipt moves through its life cycle, Receivables inserts a new record into the AR_CASH_RECEIPTS_HISTORY table with the current_record_flag column set to Y. Receivables also updates the previous record related to this receipt, by setting the current_record_flag to NULL and by setting the reversal_gl_date. The amount column stores the amount of the receipt. The cash_receipts_id column links the AR_CASH_RECEIPTS_HISTORY table to the AR_CASH_RECEIPTS table.
