Two Step Transfer View (IV00700V)

SELECT
       ['Two Step Transfer View'].SHIPMTHD AS 'Two Step Transfer View-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       IV00700V AS ['Two Step Transfer View']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Two Step Transfer View'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD

SELECT
       ['Two Step Transfer View'].TRXLOCTN AS 'Two Step Transfer View-TRX Location'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       IV00700V AS ['Two Step Transfer View']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Two Step Transfer View'].TRXLOCTN = ['Site Setup'].LOCNCODE

SELECT
       ['Two Step Transfer View'].TRNSTLOC AS 'Two Step Transfer View-Transfer To Location'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       IV00700V AS ['Two Step Transfer View']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Two Step Transfer View'].TRNSTLOC = ['Site Setup'].LOCNCODE

SELECT
       ['Two Step Transfer View'].NOTEINDX AS 'Two Step Transfer View-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       IV00700V AS ['Two Step Transfer View']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Two Step Transfer View'].NOTEINDX = ['Record Notes Master'].NOTEINDX