Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ELZV1000
Product: Distribution Elementz (6392)
Series: Inventory
Display Name: ELZ_Valuation_View
Physical Name: ELZV1000
Technical Name: ELZ_Valuation_ViewSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ITEMNMBR 
Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['ELZ_Valuation_View'].ITEMNMBR AS 'ELZ_Valuation_View-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ELZV1000 AS ['ELZ_Valuation_View']
INNER JOIN
IV00101 AS ['Item Master']
ON
['ELZ_Valuation_View'].ITEMNMBR = ['Item Master'].ITEMNMBR2 TRXLOCTN TRX Location String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['ELZ_Valuation_View'].TRXLOCTN AS 'ELZ_Valuation_View-TRX Location'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
ELZV1000 AS ['ELZ_Valuation_View']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['ELZ_Valuation_View'].TRXLOCTN = ['Site Setup'].LOCNCODE3 RCTSEQNM Receipt SEQ Number Long Integer long 8 4 QTYRECVD QTY Received Currency DLR17_QTY_RBS0_UTR 17 5 DATERECD Date Received Date DATE 6 6 QTYSOLD QTY Sold Currency DLR17_QTY_RBS0_UTR 17 7 QTYONHND QTY On Hand Currency DLR17_QTY_RBS0_STR 17 8 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 9 EXTDCOST Extended Cost Currency DLR17_RBS0_UTR$ 17 10 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ELZ_Valuation_View'].USERID AS 'ELZ_Valuation_View-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ELZV1000 AS ['ELZ_Valuation_View']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ELZ_Valuation_View'].USERID = ['Users Master'].USERID