Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ELZ_AGR
Product: Distribution Elementz (6392)
Series: Inventory
Display Name: ELZ_Aged_Group
Physical Name: ELZ_AGR
Technical Name: ELZ_Aged_GroupSeq 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_Aged_Group'].ITEMNMBR AS 'ELZ_Aged_Group-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ELZ_AGR AS ['ELZ_Aged_Group']
INNER JOIN
IV00101 AS ['Item Master']
ON
['ELZ_Aged_Group'].ITEMNMBR = ['Item Master'].ITEMNMBR2 ITEMDESC Item Description String STR100 100 3 ITMCLSDC Item Class Description String STR30 30 4 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 5 ELZ_LstQtyIssue ELZ_Last_Qty_Issue Currency DLR17_QTY_RBS0_STR 17 6 ELZ_QtyBalLstIssue ELZ_Qty_Bal_Last_Issue Currency DLR17_QTY_RBS0_STR 17 7 ELZ_Qty_1 ELZ_Qty[1] Currency DLR17_QTY_RBS0_STR 17 8 ELZ_Qty_2 ELZ_Qty[2] Currency DLR17_QTY_RBS0_STR 17 9 ELZ_Qty_3 ELZ_Qty[3] Currency DLR17_QTY_RBS0_STR 17 10 ELZ_Qty_4 ELZ_Qty[4] Currency DLR17_QTY_RBS0_STR 17 11 ELZ_Qty_5 ELZ_Qty[5] Currency DLR17_QTY_RBS0_STR 17 12 ELZ_Qty_6 ELZ_Qty[6] Currency DLR17_QTY_RBS0_STR 17 13 ELZ_Qty_7 ELZ_Qty[7] Currency DLR17_QTY_RBS0_STR 17 14 ELZ_Qty_8 ELZ_Qty[8] Currency DLR17_QTY_RBS0_STR 17 15 ELZ_Qty_9 ELZ_Qty[9] Currency DLR17_QTY_RBS0_STR 17 16 ELZ_Qty_10 ELZ_Qty[10] Currency DLR17_QTY_RBS0_STR 17 17 ELZ_Cost_1 ELZ_Cost[1] Currency DLR17_RBS0_UTR$ 17 18 ELZ_Cost_2 ELZ_Cost[2] Currency DLR17_RBS0_UTR$ 17 19 ELZ_Cost_3 ELZ_Cost[3] Currency DLR17_RBS0_UTR$ 17 20 ELZ_Cost_4 ELZ_Cost[4] Currency DLR17_RBS0_UTR$ 17 21 ELZ_Cost_5 ELZ_Cost[5] Currency DLR17_RBS0_UTR$ 17 22 ELZ_Cost_6 ELZ_Cost[6] Currency DLR17_RBS0_UTR$ 17 23 ELZ_Cost_7 ELZ_Cost[7] Currency DLR17_RBS0_UTR$ 17 24 ELZ_Cost_8 ELZ_Cost[8] Currency DLR17_RBS0_UTR$ 17 25 ELZ_Cost_9 ELZ_Cost[9] Currency DLR17_RBS0_UTR$ 17 26 ELZ_Cost_10 ELZ_Cost[10] Currency DLR17_RBS0_UTR$ 17 27 ELZ_Prcntage_1 ELZ_Percentage[1] Currency DLR5_%2 8 28 ELZ_Prcntage_2 ELZ_Percentage[2] Currency DLR5_%2 8 29 ELZ_Prcntage_3 ELZ_Percentage[3] Currency DLR5_%2 8 30 ELZ_Prcntage_4 ELZ_Percentage[4] Currency DLR5_%2 8 31 ELZ_Prcntage_5 ELZ_Percentage[5] Currency DLR5_%2 8 32 ELZ_Prcntage_6 ELZ_Percentage[6] Currency DLR5_%2 8 33 ELZ_Prcntage_7 ELZ_Percentage[7] Currency DLR5_%2 8 34 ELZ_Prcntage_8 ELZ_Percentage[8] Currency DLR5_%2 8 35 ELZ_Prcntage_9 ELZ_Percentage[9] Currency DLR5_%2 8 36 ELZ_Prcntage_10 ELZ_Percentage[10] Currency DLR5_%2 8