NC_Deposit_HDR (NCABR207)

SELECT
       ['NC_Deposit_HDR'].NOTEINDX AS 'NC_Deposit_HDR-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       NCABR207 AS ['NC_Deposit_HDR']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['NC_Deposit_HDR'].NOTEINDX = ['Record Notes Master'].NOTEINDX

SELECT
       ['NC_Deposit_HDR'].CURNCYID AS 'NC_Deposit_HDR-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       NCABR207 AS ['NC_Deposit_HDR']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['NC_Deposit_HDR'].CURNCYID = ['Currency Setup'].CURNCYID

SELECT
       ['NC_Deposit_HDR'].CURRNIDX AS 'NC_Deposit_HDR-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       NCABR207 AS ['NC_Deposit_HDR']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['NC_Deposit_HDR'].CURRNIDX = ['Currency Setup'].CURRNIDX