BM00111 - Bill of Materials Component

Dynamics GP table BM00111 (Bill of Materials Component) contains 14 columns including ITEMNMBR, Bill_Status, Status_Ord....

SQL Query Builder

SELECT * FROM BM00111

Select all

Column	Description	Type	Length	Shared With
ITEMNMBR	Item Number	String	32	41 tables
Bill_Status	Bill Status	Integer	2	1 tables
Status_Ord	Status Ord	Long Integer	4	1 tables
ORD	Ord	Long Integer	4	12 tables
CMPTITNM	Component Item Number	String	32	1 tables
Component_Status	Component Status	Integer	2	-
BM_Comp_State	BM Comp State	Integer	2	-
Cost_Type	Cost Type	Integer	2	2 tables
Design_Qty	Design Qty	Currency	10	-
Scrap_Percentage	Scrap Percentage	Integer	2	2 tables
Effective_Date	Effective Date	Date	4	4 tables
Obsolete_Date	Obsolete Date	Date	4	1 tables
UOFM	U Of M	String	10	17 tables
NOTEINDX	Note Index	Currency	10	114 tables