SVC_RTV_Shipping_WORK (SVC05615)

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

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

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

SELECT
       ['SVC_RTV_Shipping_WORK'].SHIPMTHD AS 'SVC_RTV_Shipping_WORK-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       SVC05615 AS ['SVC_RTV_Shipping_WORK']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['SVC_RTV_Shipping_WORK'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD