BMMU0001 - BOM_Mass_Changes_WORK | Prospr - Dynamics GP Table Reference

BMMU0001 - BOM_Mass_Changes_WORK

Query Builder

Select * from BMMU0001

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
PPN_I	PPN	String	32	View
CPN_I	CPN	String	32	View
BOMCAT_I	BOM Cat	Integer	2	View
BOMNAME_I	BOM Name	String	16	View
BOMSEQ_I	BOM Seq	Long Integer	4	View
POSITION_NUMBER	Position Number	Integer	2	View
REVISIONLEVEL_I	Revision Level	String	52	View
CB_I	CB	Boolean	2	View
OLDITMNM	Old Item Number	String	32	View
BOMTYPE_I	BOM Type	Integer	2	View
SUBCAT_I	Sub Cat	Integer	2	View
SUBNAME_I	Sub Name	String	16	View
QUANTITY_I	Quantity	Currency	10	View
OPTPERCENT_I	OPT Percent	Long Integer	4	View
SCRAPPERCENT_I	Scrap Percent	Long Integer	4	View
FLOORSTOCK_I	Floor Stock	Boolean	2	View
EFFECTIVEINDATE_I	Effective In Date	Date	4	View
EFFECTIVEOUTDATE_I	Effective Out Date	Date	4	View
ALTERNATE_I	Alternate	Boolean	2	View
ALTERNATEPARTFOR_I	Alternate Part For	String	32	View
ALT_FOR_BOM_SEQ_I	Alt For BOM Seq	Long Integer	4	View
LEADTIMEOFFSET_I	Lead Time Offset	Currency	10	View
LEADTIMEOFFSETINC_I	Lead Time Offset Inc	Integer	2	View
BOMUSERDEF1_I	BOM User Def1	String	32	View
BOMUSERDEF2_I	BOM User Def2	String	32	View
BOMSINGLELOT_I	BOM_Single_Lot	Boolean	2	View
BOMENGAPPROVAL_I	BOM_Eng_Approval	Boolean	2	View
WCID_I	WC ID	String	12	View
LOCNCODE	Location Code	String	12	View
BACKFLUSHITEM_I	Backflush Item	Boolean	2	View
CHANGEDATE_I	Change Date	Date	4	View
CHANGEBY_I	Change By	String	16	View
OPTIONED_ITEM_I	Optioned Item	Boolean	2	View
ACTUAL_CONSUMED_CHECK_I	Actual Consumed Check	Boolean	2	View
FIXED_QTY_I	Fixed Quantity	Currency	10	View
UOFM	U Of M	String	10	View
U_Of_M_2	U Of M 2	String	10	View
QTYBSUOM	QTY In Base U Of M	Currency	10	View
OFFSET_FROM_I	Offset From	Integer	2	View
MFGNOTEINDEX_I	MFG Note Index	Currency	10	View
MFGNOTEINDEX2_I	MFG Note Index2	Currency	10	View
REVISION_LEVEL_CHANGED_I	Revision Level Changed	Boolean	2	View
ROUTINGLINK_I	Routing Link	Boolean	2	View
ALTERNATEUSED_I	Alternate Used	Boolean	2	View
ALTERNATE_ACTION_I	Alternate Action	Integer	2	View
ROUTING_LINK_DISSOLVED_I	Routing Link Dissolved	Boolean	2	View
MFGNOTEINDEX3_I	MFG Note Index3	Currency	10	View

BMMU0001 - BOM_Mass_Changes_WORK

Query Builder

Customer Service

Information

My Account

Contact Us