Hi,
Can anyone help me to know the difference between RA_CUSTOMERS and AR_CUSTOMERS
Difference between RA_CUSTOMERS and AR_CUSTOMERS
-
- Posts: 13
- Joined: Mon Jun 25, 2007 4:38 am
- Location: India
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
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
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">[:)]
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">[:)]
Who is online
Users browsing this forum: No registered users and 5 guests