AR Miscellaneous Receipt to SLA Link R12

AR Miscellaneous Receipt to SLA Link R12

Accounting Data Model – Miscellaneous Receipts

•Where POSTABLE_FLAG <> ‘N’

•EVENT_ID should exist

•Distributions stored in AR_DISTRIBUTIONS_ALL (source_table=CRH & MCD)

•Debit & credit amounts should match

Important columns in the AR_MISC_CASH_DISTRIBUTIONS table include:

MISC_CASH_DISTRIBUTION_ID column

CASH_RECEIPT_ID column

CODE_COMBINATION_ID column

The AR_MISC_CASH_DISTRIBUTIONS table stores the accounting distribution for miscellaneous cash receipts. Each distribution is stored as a unique record, based on the primary key misc_cash_distribution_id. The distributions are linked to the receipt by the cash_receipt_id column. The code_combination_id column stores the general ledger account assigned to this receipt.