Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ELZ_BRTB
Product: Distribution Elementz (6392)
Series: Project
Display Name: ELZ_BOM_Ready_To_Build
Physical Name: ELZ_BRTB
Technical Name: ELZ_BOM_Ready_To_BuildSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ELZ_BOM_Ready_To_Build'].USERID AS 'ELZ_BOM_Ready_To_Build-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ELZ_BRTB AS ['ELZ_BOM_Ready_To_Build']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ELZ_BOM_Ready_To_Build'].USERID = ['Users Master'].USERID2 CMPTITNM Component Item Number String STR30_Item_Number 30 3 Component_Item_Descripti Component Item Description String STR100 100 4 CMPITQTY Component Item QTY Currency DLR17_QTY_RBS0_UTR 17 5 CMPITUOM Component Item U Of M String U_Of_M 8 6 QTYONHND QTY On Hand Currency DLR17_QTY_RBS0_STR 17 7 QTYAVAIL QTY Available Currency DLR17_QTY_RBS0_UTR 17 8 QTYONORD QTY On Order Currency DLR17_QTY_RBS0_UTR 17 9 PONUMBER PO Number String STR17_POP_Number 17 10 PRMDATE Promised Date Date DATE_L 0 11 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 12 ERRICON Error Icon Integer VS_Error_Icons 0