[OAUGNet]-Re: Accounting in AR Transactions and Receipts ...!

["Avinash Zodpe" <azodpe@ablelabs.com>]

For transactions you need to look into ra_trx_line_gl_dist_all table and for cash receipts
you need to look into ar_Cash_receipt_history_all table.

But if you want to look at the applications, then you will have to look at AR_RECEIVABLE_APPLICATIONS_ALL
table.
See columns applied_customer_Trx_id, cash_receipt_id, application_type columns.
Please let me know if you need anymore help.



Thanks,
Avi

-----Original Message-----
From: OAUG Net listserver [mailto:OAUGNet@oaug.com]On Behalf Of Shehzad
Ahmed
Sent: Saturday, October 23, 2004 12:55 AM
To: OAUG Net listserver
Subject: [OAUGNet]-Accounting in AR Transactions and Receipts ...!


Hi everybody,

is any one there can help me to know the name of
tables where oracle receivables keep the record for
Transaction accounting and receipts accounting
information. Actualy I want to generate one report to
show the transactions and receipts gl account wise
which account debited and which account credited for
both transactions and receipts. we are on Oracle apps
release 11.5.9.

All types of help would be highly appreciated. please
its urgent.

Thanks and regards,
Shehzad. 
ICS.


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>


#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>