SQL query to extract primary address from CUSTTABLE in Ax

SQL query to extract primary address from CUSTTABLE in Ax

8:26:00 PM
Description:-

need address for details of customer by SQL Query. The following query can be used to extract the primary address from the Custtable table:

select CUSTTABLE.ACCOUNTNUM, DIRPARTYTABLE.NAME,Address.ADDRESS
from CUSTTABLE 
  left outer join DIRPARTYTABLE ON DIRPARTYTABLE.RECID = CUSTTABLE.PARTY 
  left outer join LOGISTICSLOCATION ON LOGISTICSLOCATION.RECID = DIRPARTYTABLE.PRIMARYADDRESSLOCATION 
  left outer join LOGISTICSPOSTALADDRESS ASAddressONAddress.LOCATION = LOGISTICSLOCATION.RECID 
Order by CUSTTABLE.ACCOUNTNUM
Umesh Patel

Related Posts

Next
« Prev Post
Previous
Next Post »

1 comments:

comments
Anonymous
October 12, 2017 at 2:45:00 AM GMT+5:30 delete

Attractive seсtion οf сontent. I juѕt stumbled upоn уoսr weblog and
іn accession capital tօ assert thɑt I get ɑctually enjoyed
account ｙour blog posts. Anyway I'll be subscribing tо your feeds ɑnd ｅｖen I achievement yoᥙ
access consistently fast.

Reply
avatar

Thanks for comments.....