AR Receipts to SLA Link R12

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.