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.