EXPV1001 - EXP_BillOfMaterials | Prospr - Dynamics GP Table Reference

EXPV1001 - EXP_BillOfMaterials

Query Builder

Select * from EXPV1001

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PPN_I	PPN	String	32	View
BOMCAT_I	BOM Cat	Integer	2	View
BOMTYPE_I	BOM Type	Integer	2	View
BOMNAME_I	BOM Name	String	16	View
BOM_REVISION_LEVEL	BOM Revision Level	String	52	View
CPN_I	CPN	String	32	View
SUBCAT_I	Sub Cat	Integer	2	View
SUBNAME_I	Sub Name	String	16	View
QUANTITY_I	Quantity	Currency	10	View
UOFM	U Of M	String	10	View
FIXED_QTY_I	Fixed Quantity	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
LOCNCODE	Location Code	String	12	View
WCID_I	WC ID	String	12	View
FLOORSTOCK_I	Floor Stock	Boolean	2	View
BACKFLUSHITEM_I	Backflush Item	Boolean	2	View
ALTERNATE_I	Alternate	Boolean	2	View
ALTERNATEPARTFOR_I	Alternate Part For	String	32	View
EFFECTIVEDATE_I	Effective Date0	Date	4	View
OPTPERCENT_I	OPT Percent	Long Integer	4	View
SCRAPPERCENT_I	Scrap Percent	Long Integer	4	View
EFFECTIVEINDATE_I	Effective In Date	Date	4	View
EFFECTIVEOUTDATE_I	Effective Out Date	Date	4	View
LEADTIMEOFFSET_I	Lead Time Offset	Currency	10	View
OFFSET_FROM_I	Offset From	Integer	2	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
BOMSINGLELOT_I	BOM_Single_Lot	Boolean	2	View
BOMENGAPPROVAL_I	BOM_Eng_Approval	Boolean	2	View
CHANGEDATE_I	Change Date	Date	4	View
CHANGEBY_I	Change By	String	16	View
ACTUAL_CONSUMED_CHECK_I	Actual Consumed Check	Boolean	2	View
MODIFDT	Modified Date	Date	4	View
USERID	User ID	String	16	View
BOMSEQ_I	BOM Seq	Long Integer	4	View