ICJC IV TRX HISTORY VIEW (ICJC3030)

SELECT
       ['ICJC IV TRX HISTORY VIEW'].CUSTNMBR AS 'ICJC IV TRX HISTORY VIEW-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       ICJC3030 AS ['ICJC IV TRX HISTORY VIEW']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['ICJC IV TRX HISTORY VIEW'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR

SELECT
       ['ICJC IV TRX HISTORY VIEW'].ITEMNMBR AS 'ICJC IV TRX HISTORY VIEW-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       ICJC3030 AS ['ICJC IV TRX HISTORY VIEW']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['ICJC IV TRX HISTORY VIEW'].ITEMNMBR = ['Item Master'].ITEMNMBR

SELECT
       ['ICJC IV TRX HISTORY VIEW'].TRXLOCTN AS 'ICJC IV TRX HISTORY VIEW-TRX Location'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       ICJC3030 AS ['ICJC IV TRX HISTORY VIEW']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['ICJC IV TRX HISTORY VIEW'].TRXLOCTN = ['Site Setup'].LOCNCODE

SELECT
       ['ICJC IV TRX HISTORY VIEW'].TRNSTLOC AS 'ICJC IV TRX HISTORY VIEW-Transfer To Location'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       ICJC3030 AS ['ICJC IV TRX HISTORY VIEW']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['ICJC IV TRX HISTORY VIEW'].TRNSTLOC = ['Site Setup'].LOCNCODE

SELECT
       ['ICJC IV TRX HISTORY VIEW'].IVIVINDX AS 'ICJC IV TRX HISTORY VIEW-IV IV Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ICJC3030 AS ['ICJC IV TRX HISTORY VIEW']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ICJC IV TRX HISTORY VIEW'].IVIVINDX = ['Account Index Master'].ACTINDX

SELECT
       ['ICJC IV TRX HISTORY VIEW'].IVIVOFIX AS 'ICJC IV TRX HISTORY VIEW-IV IV Offset Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ICJC3030 AS ['ICJC IV TRX HISTORY VIEW']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ICJC IV TRX HISTORY VIEW'].IVIVOFIX = ['Account Index Master'].ACTINDX