IVR10015 - Item Engineering File | Prospr - Dynamics GP Table Reference

IVR10015 - Item Engineering File

Select * from IVR10015

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ITEMNMBR	Item Number	String	32	View
ITEMSTATUS_I	Item Status	Integer	2	View
BOMTYPE_I	BOM Type	Integer	2	View
MAKEBUYCODE_I	Make/Buy_Code	Integer	2	View
ITEMDESIGNAUTHORIT_I	Item Design Authority	String	102	View
EFFECTIVEDATE_I	Effective Date0	Date	4	View
REVISIONLEVEL_I	Revision Level	String	52	View
CHANGEDATE_I	Change Date	Date	4	View
USERID	User ID	String	16	View
DWGNUM_I	DWG #	String	32	View
DWGSIZE_I	DWG Size	String	4	View
ABCCODE_I	ABC_Code	Integer	2	View
FLOORSTOCK_I	Floor Stock	Boolean	2	View
ITEMUSEUP_I	Item Use Up?	Boolean	2	View
CALCMRP_I	Calc MRP	Boolean	2	View
QAQCNEEDED_I	QA/QC Needed	Boolean	2	View
MINIMUMISSUE_I	Minimum Issue	Currency	10	View
IVCARRYINGCOST_I	IV Carrying Cost	Currency	10	View
IVSETUPCOST_I	IV Setup Cost	Currency	10	View
AVERAGEORDQTY_I	Average ORD QTY	Currency	10	View
SHRINKAGEPERCENT_I	Shrinkage%	Long Integer	4	View
DESTTESTINGREQD_I	Destructive Testing Required	Boolean	2	View
ALTERNATE_I	Alternate	Boolean	2	View
SHIPPINGUOFM_I	Shipping U Of M	Integer	2	View
LOCNCODE	Location Code	String	12	View
MFGNOTEINDEX_I	MFG Note Index	Currency	10	View
ITEMFULFILLMETHOD	Item Fulfillment Method	Integer	2	View
LLC	LLC	Long Integer	4	View
RUNNUMBER	MRP_Run_Number	Long Integer	4	View
FG_STD_QTY_I	FG Standard Quantity	Currency	10	View
QASTDATE	QA Start Date	Date	4	View
QAENDDATE	QA End Date	Date	4	View
DAYTOEXP	Days To Expire	Integer	2	View
INCL_EXP_TO_ENG	Include In Export To Engineering	Boolean	2	View
ISCHANGD	IsChanged	Boolean	2	View