Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ELZ_AIR
Product: Distribution Elementz (6392)
Series: Inventory
Display Name: ELZ_Aged_IV
Physical Name: ELZ_AIR
Technical Name: ELZ_Aged_IVSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DOCNUMBR 
Document Number String STR20_Document_Number 20 2 DOCTYPE Document Type Integer DDL_Document_Type 0 3 DOCDATE Document Date Date DT 8 4 LNSEQNBR Line SEQ Number Currency Sequence_Number 19 5 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['ELZ_Aged_IV'].ITEMNMBR AS 'ELZ_Aged_IV-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ELZ_AIR AS ['ELZ_Aged_IV']
INNER JOIN
IV00101 AS ['Item Master']
ON
['ELZ_Aged_IV'].ITEMNMBR = ['Item Master'].ITEMNMBR6 ITEMDESC Item Description String STR100 100 7 ITMCLSDC Item Class Description String STR30 30 8 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 9 ELZ_LstQtyIssue ELZ_Last_Qty_Issue Currency DLR17_QTY_RBS0_STR 17 10 ELZ_QtyBalLstIssue ELZ_Qty_Bal_Last_Issue Currency DLR17_QTY_RBS0_STR 17 11 ELZ_Qty_1 ELZ_Qty[1] Currency DLR17_QTY_RBS0_STR 17 12 ELZ_Qty_2 ELZ_Qty[2] Currency DLR17_QTY_RBS0_STR 17 13 ELZ_Qty_3 ELZ_Qty[3] Currency DLR17_QTY_RBS0_STR 17 14 ELZ_Qty_4 ELZ_Qty[4] Currency DLR17_QTY_RBS0_STR 17 15 ELZ_Qty_5 ELZ_Qty[5] Currency DLR17_QTY_RBS0_STR 17 16 ELZ_Qty_6 ELZ_Qty[6] Currency DLR17_QTY_RBS0_STR 17 17 ELZ_Qty_7 ELZ_Qty[7] Currency DLR17_QTY_RBS0_STR 17 18 ELZ_Qty_8 ELZ_Qty[8] Currency DLR17_QTY_RBS0_STR 17 19 ELZ_Qty_9 ELZ_Qty[9] Currency DLR17_QTY_RBS0_STR 17 20 ELZ_Qty_10 ELZ_Qty[10] Currency DLR17_QTY_RBS0_STR 17 21 ELZ_Cost_1 ELZ_Cost[1] Currency DLR17_RBS0_UTR$ 17 22 ELZ_Cost_2 ELZ_Cost[2] Currency DLR17_RBS0_UTR$ 17 23 ELZ_Cost_3 ELZ_Cost[3] Currency DLR17_RBS0_UTR$ 17 24 ELZ_Cost_4 ELZ_Cost[4] Currency DLR17_RBS0_UTR$ 17 25 ELZ_Cost_5 ELZ_Cost[5] Currency DLR17_RBS0_UTR$ 17 26 ELZ_Cost_6 ELZ_Cost[6] Currency DLR17_RBS0_UTR$ 17 27 ELZ_Cost_7 ELZ_Cost[7] Currency DLR17_RBS0_UTR$ 17 28 ELZ_Cost_8 ELZ_Cost[8] Currency DLR17_RBS0_UTR$ 17 29 ELZ_Cost_9 ELZ_Cost[9] Currency DLR17_RBS0_UTR$ 17 30 ELZ_Cost_10 ELZ_Cost[10] Currency DLR17_RBS0_UTR$ 17 31 ELZ_Prcntage_1 ELZ_Percentage[1] Currency DLR5_%2 8 32 ELZ_Prcntage_2 ELZ_Percentage[2] Currency DLR5_%2 8 33 ELZ_Prcntage_3 ELZ_Percentage[3] Currency DLR5_%2 8 34 ELZ_Prcntage_4 ELZ_Percentage[4] Currency DLR5_%2 8 35 ELZ_Prcntage_5 ELZ_Percentage[5] Currency DLR5_%2 8 36 ELZ_Prcntage_6 ELZ_Percentage[6] Currency DLR5_%2 8 37 ELZ_Prcntage_7 ELZ_Percentage[7] Currency DLR5_%2 8 38 ELZ_Prcntage_8 ELZ_Percentage[8] Currency DLR5_%2 8 39 ELZ_Prcntage_9 ELZ_Percentage[9] Currency DLR5_%2 8 40 ELZ_Prcntage_10 ELZ_Percentage[10] Currency DLR5_%2 8