QA_HIST_NSR_Incoming (QA010433)

SELECT
       ['QA_HIST_NSR_Incoming'].ITEMNMBR AS 'QA_HIST_NSR_Incoming-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       QA010433 AS ['QA_HIST_NSR_Incoming']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['QA_HIST_NSR_Incoming'].ITEMNMBR = ['Item Master'].ITEMNMBR

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

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

SELECT
       ['QA_HIST_NSR_Incoming'].LOCNCODE AS 'QA_HIST_NSR_Incoming-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       QA010433 AS ['QA_HIST_NSR_Incoming']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['QA_HIST_NSR_Incoming'].LOCNCODE = ['Site Setup'].LOCNCODE