SVC_RTV_Receiving_WORK (SVC05625)

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

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

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

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