AX 2012 Query To Get Vendor Address Information

Here is a SQLServer query that can be run against the database to pull vendor address information.  In this case, it is pulling addresses with the "Remit To" address role belonging to a company designated as "gi".

SELECT
  vt.*,
  dpt.*,
  dpl.*,
  ll.*,
  lpa.*,
  dplr.*,
  llr.*
FROM VendTable vt
INNER JOIN DIRPARTYTABLE dpt
  ON vt.PARTY = dpt.RECID
INNER JOIN DIRPARTYLOCATION dpl
  ON dpl.PARTY = dpt.RECID
INNER JOIN LOGISTICSLOCATION ll
  ON ll.RECID = dpl.LOCATION
INNER JOIN LOGISTICSPOSTALADDRESS lpa
  ON ll.RECID = lpa.LOCATION
INNER JOIN DIRPARTYLOCATIONROLE dplr
  ON dplr.PARTYLOCATION = dpl.RECID
INNER JOIN LOGISTICSLOCATIONROLE llr
  ON llr.RECID = dplr.LOCATIONROLE
INNER JOIN PARTITIONS AS p
  ON vt.PARTITION = p.RECID
WHERE vt.DATAAREAID = 'gi'
AND GETUTCDATE() BETWEEN lpa.VALIDFROM AND lpa.VALIDTO
AND llr.Name = 'Remit To'
ORDER BY vt.ACCOUNTNUM

Enjoy!!!