Page 1 of 1
Difference between RA_CUSTOMERS and AR_CUSTOMERS
Posted: Mon Jun 25, 2007 5:24 am
by ramaraomovva
Hi,
Can anyone help me to know the difference between RA_CUSTOMERS and AR_CUSTOMERS
Posted: Mon Jun 25, 2007 6:23 am
by vaneetha
Hi Ramaroa
AR_CUSTOMERS is not a table. It is a view based on HZ_CUSTOMERS and HZ_PARTIES.
So when you run the customer interface program, HZ_CUSTOMERS table will get updated and those updates will also appear in AR_CUSTOMERS since it is a view.
HZ tables is where all the party information is maintained. In the
old the customer information was stored in RA_CUSTOMERS but now
everything is in party tables. Within each party there is seggregation
on which party is of what type customer, employee, etc.
Hope it may clear u
Posted: Tue Jun 26, 2007 1:21 pm
by arun1203
Hi Vaneetha,
You have given a nice explanation.
Can you please tell me why they have moved the data from RA_CUSTOMERS table into party tables?
And the source where I can find the detailed information regarding this.
Your reply will be of great help.
<font color="blue"><b>Best Regards & Thanks,
Arun Reddy</b></font id="blue">[:)]