MFGBomList (BOMV1000)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/BOMV1000

Display Name: MFGBomList
Physical Name: BOMV1000
Technical Name: MFGBomList

Seq 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'].ITEMNMBR
5	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