Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ICJC3030
Product: Manufacturing (346)
Series:
Display Name: ICJC IV TRX HISTORY VIEW
Physical Name: ICJC3030
Technical Name: ICJC_IV_TRX_HIST_LINE_VIEWSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 TRXSORCE 
TRX Source String STR13 13 2 DOCTYPE Document Type Integer DDL_Document_Type 0 3 DOCNUMBR Document Number String STR20_Document_Number 20 4 DOCDATE Document Date Date DT 8 5 HSTMODUL History Module String STR3 3 6 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
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'].CUSTNMBR7 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
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'].ITEMNMBR8 LNSEQNBR Line SEQ Number Currency Sequence_Number 19 9 UOFM U Of M String U_Of_M 8 10 TRXQTY TRX QTY Currency DLR17_QTY_RBS0_STR 17 11 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 12 EXTDCOST Extended Cost Currency DLR17_RBS0_UTR$ 17 13 TRXLOCTN TRX Location String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
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'].LOCNCODE14 TRNSTLOC Transfer To Location String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
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'].LOCNCODE15 TRFQTYTY Transfer From QTY Type Integer DDL_QTY_Type 0 16 TRTQTYTY Transfer To QTY Type Integer DDL_QTY_Type 0 17 IVIVINDX IV IV Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
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'].ACTINDX18 IVIVOFIX IV IV Offset Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
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'].ACTINDX19 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 20 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0