Customer Activity
Hi all,I'm trying to work out how to find the last activity for a customer.
I've identified the following tables that may hold an acitivity from a customer:
RA_CUSTOMER_TRX_ALL
AR_PAYMENT_SCHEDULES_ALL
AR_CASH_RECEIPTS_ALL
AR_ADJUSTMENTS_ALL
Is anyone able to advise any other tables I should be looking at? Or if there is a simpilier way to find the last cusomter activity?
Cheers,
Russell H
I've identified the following tables that may hold an acitivity from a customer:
RA_CUSTOMER_TRX_ALL
AR_PAYMENT_SCHEDULES_ALL
AR_CASH_RECEIPTS_ALL
AR_ADJUSTMENTS_ALL
Is anyone able to advise any other tables I should be looking at? Or if there is a simpilier way to find the last cusomter activity?
Cheers,
Russell H
0