NC_Statement_Document_TEMP (NCABR035)

SELECT
       ['NC_Statement_Document_TEMP'].USERID AS 'NC_Statement_Document_TEMP-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       NCABR035 AS ['NC_Statement_Document_TEMP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['NC_Statement_Document_TEMP'].USERID = ['Users Master'].USERID

SELECT
       ['NC_Statement_Document_TEMP'].ACTINDX AS 'NC_Statement_Document_TEMP-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       NCABR035 AS ['NC_Statement_Document_TEMP']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['NC_Statement_Document_TEMP'].ACTINDX = ['Account Index Master'].ACTINDX

SELECT
       ['NC_Statement_Document_TEMP'].CUSTNMBR AS 'NC_Statement_Document_TEMP-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       NCABR035 AS ['NC_Statement_Document_TEMP']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['NC_Statement_Document_TEMP'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR

SELECT
       ['NC_Statement_Document_TEMP'].VENDORID AS 'NC_Statement_Document_TEMP-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       NCABR035 AS ['NC_Statement_Document_TEMP']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['NC_Statement_Document_TEMP'].VENDORID = ['PM Vendor Master File'].VENDORID

SELECT
       ['NC_Statement_Document_TEMP'].TAXDTLID AS 'NC_Statement_Document_TEMP-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       NCABR035 AS ['NC_Statement_Document_TEMP']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['NC_Statement_Document_TEMP'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID