BM00111 - Bill of Materials Component | Prospr - Dynamics GP Table Reference

BM00111 - Bill of Materials Component

Query Builder

Select * from BM00111

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ITEMNMBR	Item Number	String	32	View
Bill_Status	Bill Status	Integer	2	View
Status_Ord	Status Ord	Long Integer	4	View
ORD	Ord	Long Integer	4	View
CMPTITNM	Component Item Number	String	32	View
Component_Status	Component Status	Integer	2	View
BM_Comp_State	BM Comp State	Integer	2	View
Cost_Type	Cost Type	Integer	2	View
Design_Qty	Design Qty	Currency	10	View
Scrap_Percentage	Scrap Percentage	Integer	2	View
Effective_Date	Effective Date	Date	4	View
Obsolete_Date	Obsolete Date	Date	4	View
UOFM	U Of M	String	10	View
NOTEINDX	Note Index	Currency	10	View