Recon Batch Header (CB330001)

SELECT
       ['Recon Batch Header'].ACTINDX AS 'Recon Batch Header-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       CB330001 AS ['Recon Batch Header']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Recon Batch Header'].ACTINDX = ['Account Index Master'].ACTINDX

SELECT
       ['Recon Batch Header'].CURRNIDX AS 'Recon Batch Header-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       CB330001 AS ['Recon Batch Header']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Recon Batch Header'].CURRNIDX = ['Currency Setup'].CURRNIDX

SELECT
       ['Recon Batch Header'].CURNCYID AS 'Recon Batch Header-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       CB330001 AS ['Recon Batch Header']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Recon Batch Header'].CURNCYID = ['Currency Setup'].CURNCYID

SELECT
       ['Recon Batch Header'].CHEKBKID AS 'Recon Batch Header-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       CB330001 AS ['Recon Batch Header']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Recon Batch Header'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID