BM010115 - Bill Of Material Line File | Prospr

BM010115 - Bill Of Material Line File

Query Builder

Select * from BM010115

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
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
BOMTYPE_I	BOM Type	Integer	2	View
BOMSEQ_I	BOM Seq	Long Integer	4	View
POSITION_NUMBER	Position Number	Integer	2	View
SUBCAT_I	Sub Cat	Integer	2	View
SUBNAME_I	Sub Name	String	16	View
SUB_REV_LEVEL_SEQ_I	Sub Revision Level Sequence	Long Integer	4	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
USERID	User ID	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

BM010115 - Bill Of Material Line File

Query Builder

Customer Service

Information

My Account

Contact Us