Sales Payment Document Remittance Distributions (RVLPD014)

SELECT
       ['Sales Payment Document Remittance Distributions'].DSTINDX AS 'Sales Payment Document Remittance Distributions-Distribution Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       RVLPD014 AS ['Sales Payment Document Remittance Distributions']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Sales Payment Document Remittance Distributions'].DSTINDX = ['Account Index Master'].ACTINDX

SELECT
       ['Sales Payment Document Remittance Distributions'].CURNCYID AS 'Sales Payment Document Remittance Distributions-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       RVLPD014 AS ['Sales Payment Document Remittance Distributions']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Sales Payment Document Remittance Distributions'].CURNCYID = ['Currency Setup'].CURNCYID

SELECT
       ['Sales Payment Document Remittance Distributions'].CURRNIDX AS 'Sales Payment Document Remittance Distributions-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       RVLPD014 AS ['Sales Payment Document Remittance Distributions']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Sales Payment Document Remittance Distributions'].CURRNIDX = ['Currency Setup'].CURRNIDX