PA Purchase Order Line History (PA30601)

SELECT
       ['PA Purchase Order Line History'].ITEMNMBR AS 'PA Purchase Order Line History-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       PA30601 AS ['PA Purchase Order Line History']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['PA Purchase Order Line History'].ITEMNMBR = ['Item Master'].ITEMNMBR

SELECT
       ['PA Purchase Order Line History'].CURNCYID AS 'PA Purchase Order Line History-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PA30601 AS ['PA Purchase Order Line History']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PA Purchase Order Line History'].CURNCYID = ['Currency Setup'].CURNCYID

SELECT
       ['PA Purchase Order Line History'].ITMTSHID AS 'PA Purchase Order Line History-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PA30601 AS ['PA Purchase Order Line History']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PA Purchase Order Line History'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID