Bill of Materials Component (BM00111)

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

Display Name: Bill of Materials Component
Physical Name: BM00111
Technical Name: bmBillComp

Group Display Name: Bill of Materials Cards
Group Technical Name: bmBillGroup

Seq 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 ['Bill of Materials Component'].ITEMNMBR AS 'Bill of Materials Component-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM BM00111 AS ['Bill of Materials Component'] INNER JOIN IV00101 AS ['Item Master'] ON ['Bill of Materials Component'].ITEMNMBR = ['Item Master'].ITEMNMBR
2	Bill_Status	Bill Status	Integer	DDL_Bill_Status	0
3	Status_Ord	Status Ord	Long Integer	long	8
4	ORD	Ord	Long Integer	LI_Sequence_Number	10
5	CMPTITNM	Component Item Number	String	STR30_Item_Number	30
6	Component_Status	Component Status	Integer	DDL_Bill_Status	0
7	BM_Comp_State	BM Comp State	Integer	INT	0
8	Cost_Type	Cost Type	Integer	DDL_Cost_Type	0
9	Design_Qty	Design Qty	Currency	DLR17_QTY_RBS0_UTR	17
10	Scrap_Percentage	Scrap Percentage	Integer	INT4_%2	4
11	Effective_Date	Effective Date	Date	DT	8
12	Obsolete_Date	Obsolete Date	Date	DT	8
13	UOFM	U Of M	String	U_Of_M	8
	The unit of measure. The value in this field must exist in Inventory.
14	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Bill of Materials Component'].NOTEINDX AS 'Bill of Materials Component-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM BM00111 AS ['Bill of Materials Component'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Bill of Materials Component'].NOTEINDX = ['Record Notes Master'].NOTEINDX