Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/BOMV1000
Product: Manufacturing (346)
Series:
Display Name: MFGBomList
Physical Name: BOMV1000
Technical Name: MFGBomListSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BOMCAT_I 
BOM Cat Integer DDL_BOM_Cat 0 2 BOMNAME_I BOM Name String STR15_LBU 15 3 BOMTYPE_I BOM Type Integer DDL_BOM_Type 0 4 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['MFGBomList'].ITEMNMBR AS 'MFGBomList-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
BOMV1000 AS ['MFGBomList']
INNER JOIN
IV00101 AS ['Item Master']
ON
['MFGBomList'].ITEMNMBR = ['Item Master'].ITEMNMBR5 Language_ID Language ID Integer INT5 4 6 REVISIONLEVEL_I Revision Level String STR50 50 7 ITEMDESC Item Description String STR100 100 8 EFFECTIVEDATE_I Effective Date0 Date DT 8 9 BOMCATSTR BOM Cat String String STR12 12 10 BOMTYPESTR BOM Type String String STR10 10