Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ELZ_IB
Product: Distribution Elementz (6392)
Series: Inventory
Display Name: ELZ_IV_Balance
Physical Name: ELZ_IB
Technical Name: ELZ_IV_BalanceSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DOCDATE 
Document Date Date DT 8 2 DOCTYPE Document Type Integer DDL_Document_Type 0 3 LNSEQNBR Line SEQ Number Currency Sequence_Number 19 4 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['ELZ_IV_Balance'].ITEMNMBR AS 'ELZ_IV_Balance-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ELZ_IB AS ['ELZ_IV_Balance']
INNER JOIN
IV00101 AS ['Item Master']
ON
['ELZ_IV_Balance'].ITEMNMBR = ['Item Master'].ITEMNMBR5 ITEMDESC Item Description String STR100 100 6 BIN Bin String STR15_Bin 15 7 TRXQTY TRX QTY Currency DLR17_QTY_RBS0_STR 17 8 QTYONHND QTY On Hand Currency DLR17_QTY_RBS0_STR 17 9 QUANTITY QTY Currency DLR17_QTY_RBS0_STR 17 10 ELZ_Opening_Balance ELZ_Opening_Balance Currency DLR17_QTY_RBS0_STR 17 11 DOCNUMBR Document Number String STR20_Document_Number 20 12 ELZ_Document_Type ELZ_Document_Type String STR20 20 13 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ELZ_IV_Balance'].USERID AS 'ELZ_IV_Balance-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ELZ_IB AS ['ELZ_IV_Balance']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ELZ_IV_Balance'].USERID = ['Users Master'].USERID