WO010032 - Manufacture Order Master | Prospr - Dynamics GP Table Reference

WO010032 - Manufacture Order Master

Query Builder

Select * from WO010032

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
MANUFACTUREORDER_I	Manufacture Order	String	32	View
DSCRIPTN	Description	String	32	View
MANUFACTUREORDERST_I	Manufacture Order Status	Integer	2	View
ITEMNMBR	Item Number	String	32	View
ARCHIVED_MO_I	Archived MO	Boolean	2	View
BOMCAT_I	BOM Cat	Integer	2	View
BOMNAME_I	BOM Name	String	16	View
ROUTINGNAME_I	RoutingName	String	32	View
ENDQTY_I	End QTY	Currency	10	View
STARTQTY_I	Start QTY	Currency	10	View
STRTDATE	Start Date	Date	4	View
STARTTIME_I	Start Time_IC	Time	4	View
ENDDATE	End Date	Date	4	View
DRAWFROMSITE_I	Draw From Site	String	12	View
CHANGEDATE_I	Change Date	Date	4	View
USERID	User ID	String	16	View
SCHEDULEMETHOD_I	Schedule Method	Integer	2	View
PROJEMPLOYEEHRSSUM_I	Projected Employee Hours Sum	Currency	10	View
PROJMACHINEHRSSUM_I	Projected Machine Hours Sum	Currency	10	View
MATPROJCOSTI_1	Mat Proj Cost[1]	Currency	10	View
MATPROJCOSTI_2	Mat Proj Cost[2]	Currency	10	View
MATFIXOHDPROJCOSTI_1	Mat Fix Ohd Proj Cost[1]	Currency	10	View
MATFIXOHDPROJCOSTI_2	Mat Fix Ohd Proj Cost[2]	Currency	10	View
MATVAROHDPROJCOST_1	Mat Var Ohd Proj Cost[1]	Currency	10	View
MATVAROHDPROJCOST_2	Mat Var Ohd Proj Cost[2]	Currency	10	View
LABPROJCOSTI_1	Lab Proj Cost[1]	Currency	10	View
LABPROJCOSTI_2	Lab Proj Cost[2]	Currency	10	View
LABFIXOHDPROJCOSTI_1	Lab Fix Ohd Proj Cost[1]	Currency	10	View
LABFIXOHDPROJCOSTI_2	Lab Fix Ohd Proj Cost[2]	Currency	10	View
LABVAROHDPROJCOSTI_1	Lab Var Ohd Proj Cost[1]	Currency	10	View
LABVAROHDPROJCOSTI_2	Lab Var Ohd Proj Cost[2]	Currency	10	View
MACHPROJCOSTI_1	Mach Proj Cost[1]	Currency	10	View
MACHPROJCOSTI_2	Mach Proj Cost[2]	Currency	10	View
MACHFIXOHDPROJCOSTI_1	Mach Fix Ohd Proj Cost[1]	Currency	10	View
MACHFIXOHDPROJCOSTI_2	Mach Fix Ohd Proj Cost[2]	Currency	10	View
MACHVAROHDPROJCOSTI_1	Mach Var Ohd Proj Cost[1]	Currency	10	View
MACHVAROHDPROJCOSTI_2	Mach Var Ohd Proj Cost[2]	Currency	10	View
POSTTOSITE_I	Post To Site	String	12	View
LOTNUMBR	Lot Number	String	22	View
SCHEDULINGPREFEREN_I	Scheduling Preference	String	22	View
PLANNAME_I	Plan Name	String	16	View
ACTUALDEMAND_I	Actual Demand	Currency	10	View
MANUFACTUREORDPRI_I	Manufacture Order Priority	Integer	2	View
Partial_Purge_Date	Partial Purge Date	Date	4	View
NOTEINDX	Note Index	Currency	10	View
OUTSOURCED_I	Outsourced	Integer	2	View
COMPCALCOPTION	Component Calculation Option	Integer	2	View
COMPLETECLOSEDATE	Complete/Close Date	Date	4	View
PSTGDATE	Posting Date	Date	4	View
PLNNDSPPLID	Planned Supply ID	Integer	2	View
PICKNUMBER	Pick Number	String	18	View
QUICK_MO_I	Quick MO	Boolean	2	View
ROUTING_REVISION_LEVEL	Routing Revision Level	String	52	View
BOM_REVISION_LEVEL	BOM Revision Level	String	52	View

WO010032 - Manufacture Order Master

Query Builder

Customer Service

Information

My Account

Contact Us