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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s