SVC_Contract_Price_Book_Group (SVC00654)

SELECT
       ['SVC_Contract_Price_Book_Group'].ITMCLSCD AS 'SVC_Contract_Price_Book_Group-Item Class Code'
       ,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
       SVC00654 AS ['SVC_Contract_Price_Book_Group']
INNER JOIN
       IV40400 AS ['Item Class Setup']
              ON
                     ['SVC_Contract_Price_Book_Group'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD

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

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