WO010116 - MOP Historical Variance | Prospr - Dynamics GP Table Reference

WO010116 - MOP Historical Variance

Query Builder

Select * from WO010116

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
MANUFACTUREORDER_I	Manufacture Order	String	32	View
DSCRIPTN	Description	String	32	View
ITEMNMBR	Item Number	String	32	View
BOMCAT_I	BOM Cat	Integer	2	View
BOMNAME_I	BOM Name	String	16	View
ITEMDESC	Item Description	String	102	View
ROUTINGNAME_I	RoutingName	String	32	View
REVISIONLEVEL_I	Revision Level	String	52	View
STARTQTY_I	Start QTY	Currency	10	View
ENDQTY_I	End QTY	Currency	10	View
PROJEMPLOYEEHRSSUM_I	Projected Employee Hours Sum	Currency	10	View
PROJMACHINEHRSSUM_I	Projected Machine Hours Sum	Currency	10	View
ACTUALEMPHOURSSUM_I	Actual Employee Hours Sum	Currency	10	View
ACTUALMACHRSSUM_I	Actual Machine Hours Sum	Currency	10	View
MATCOSTI_1	Mat Cost[1]	Currency	10	View
MATCOSTI_2	Mat Cost[2]	Currency	10	View
MATCOSTI_3	Mat Cost[3]	Currency	10	View
MATCOSTI_4	Mat Cost[4]	Currency	10	View
MATCOSTI_5	Mat Cost[5]	Currency	10	View
MATCOSTI_6	Mat Cost[6]	Currency	10	View
MATCOSTI_7	Mat Cost[7]	Currency	10	View
MATCOSTI_8	Mat Cost[8]	Currency	10	View
MATFIXOHDCOSTI_1	Mat Fix Ohd Cost[1]	Currency	10	View
MATFIXOHDCOSTI_2	Mat Fix Ohd Cost[2]	Currency	10	View
MATFIXOHDCOSTI_3	Mat Fix Ohd Cost[3]	Currency	10	View
MATFIXOHDCOSTI_4	Mat Fix Ohd Cost[4]	Currency	10	View
MATFIXOHDCOSTI_5	Mat Fix Ohd Cost[5]	Currency	10	View
MATFIXOHDCOSTI_6	Mat Fix Ohd Cost[6]	Currency	10	View
MATFIXOHDCOSTI_7	Mat Fix Ohd Cost[7]	Currency	10	View
MATFIXOHDCOSTI_8	Mat Fix Ohd Cost[8]	Currency	10	View
MATVAROHDCOSTI_1	Mat Var Ohd Cost[1]	Currency	10	View
MATVAROHDCOSTI_2	Mat Var Ohd Cost[2]	Currency	10	View
MATVAROHDCOSTI_3	Mat Var Ohd Cost[3]	Currency	10	View
MATVAROHDCOSTI_4	Mat Var Ohd Cost[4]	Currency	10	View
MATVAROHDCOSTI_5	Mat Var Ohd Cost[5]	Currency	10	View
MATVAROHDCOSTI_6	Mat Var Ohd Cost[6]	Currency	10	View
MATVAROHDCOSTI_7	Mat Var Ohd Cost[7]	Currency	10	View
MATVAROHDCOSTI_8	Mat Var Ohd Cost[8]	Currency	10	View
LABCOSTI_1	Lab Cost[1]	Currency	10	View
LABCOSTI_2	Lab Cost[2]	Currency	10	View
LABCOSTI_3	Lab Cost[3]	Currency	10	View
LABCOSTI_4	Lab Cost[4]	Currency	10	View
LABCOSTI_5	Lab Cost[5]	Currency	10	View
LABCOSTI_6	Lab Cost[6]	Currency	10	View
LABCOSTI_7	Lab Cost[7]	Currency	10	View
LABCOSTI_8	Lab Cost[8]	Currency	10	View
LABFIXOHDCOSTI_1	Lab Fix Ohd Cost[1]	Currency	10	View
LABFIXOHDCOSTI_2	Lab Fix Ohd Cost[2]	Currency	10	View
LABFIXOHDCOSTI_3	Lab Fix Ohd Cost[3]	Currency	10	View
LABFIXOHDCOSTI_4	Lab Fix Ohd Cost[4]	Currency	10	View
LABFIXOHDCOSTI_5	Lab Fix Ohd Cost[5]	Currency	10	View
LABFIXOHDCOSTI_6	Lab Fix Ohd Cost[6]	Currency	10	View
LABFIXOHDCOSTI_7	Lab Fix Ohd Cost[7]	Currency	10	View
LABFIXOHDCOSTI_8	Lab Fix Ohd Cost[8]	Currency	10	View
LABVAROHDCOSTI_1	Lab Var Ohd Cost[1]	Currency	10	View
LABVAROHDCOSTI_2	Lab Var Ohd Cost[2]	Currency	10	View
LABVAROHDCOSTI_3	Lab Var Ohd Cost[3]	Currency	10	View
LABVAROHDCOSTI_4	Lab Var Ohd Cost[4]	Currency	10	View
LABVAROHDCOSTI_5	Lab Var Ohd Cost[5]	Currency	10	View
LABVAROHDCOSTI_6	Lab Var Ohd Cost[6]	Currency	10	View
LABVAROHDCOSTI_7	Lab Var Ohd Cost[7]	Currency	10	View
LABVAROHDCOSTI_8	Lab Var Ohd Cost[8]	Currency	10	View
MACHCOSTI_1	Mach Cost[1]	Currency	10	View
MACHCOSTI_2	Mach Cost[2]	Currency	10	View
MACHCOSTI_3	Mach Cost[3]	Currency	10	View
MACHCOSTI_4	Mach Cost[4]	Currency	10	View
MACHCOSTI_5	Mach Cost[5]	Currency	10	View
MACHCOSTI_6	Mach Cost[6]	Currency	10	View
MACHCOSTI_7	Mach Cost[7]	Currency	10	View
MACHCOSTI_8	Mach Cost[8]	Currency	10	View
MACHFIXOHDCOSTI_1	Mach Fix Ohd Cost[1]	Currency	10	View
MACHFIXOHDCOSTI_2	Mach Fix Ohd Cost[2]	Currency	10	View
MACHFIXOHDCOSTI_3	Mach Fix Ohd Cost[3]	Currency	10	View
MACHFIXOHDCOSTI_4	Mach Fix Ohd Cost[4]	Currency	10	View
MACHFIXOHDCOSTI_5	Mach Fix Ohd Cost[5]	Currency	10	View
MACHFIXOHDCOSTI_6	Mach Fix Ohd Cost[6]	Currency	10	View
MACHFIXOHDCOSTI_7	Mach Fix Ohd Cost[7]	Currency	10	View
MACHFIXOHDCOSTI_8	Mach Fix Ohd Cost[8]	Currency	10	View
MACHVAROHDCOSTI_1	Mach Var Ohd Cost[1]	Currency	10	View
MACHVAROHDCOSTI_2	Mach Var Ohd Cost[2]	Currency	10	View
MACHVAROHDCOSTI_3	Mach Var Ohd Cost[3]	Currency	10	View
MACHVAROHDCOSTI_4	Mach Var Ohd Cost[4]	Currency	10	View
MACHVAROHDCOSTI_5	Mach Var Ohd Cost[5]	Currency	10	View
MACHVAROHDCOSTI_6	Mach Var Ohd Cost[6]	Currency	10	View
MACHVAROHDCOSTI_7	Mach Var Ohd Cost[7]	Currency	10	View
MACHVAROHDCOSTI_8	Mach Var Ohd Cost[8]	Currency	10	View
QAQCNEEDEDSTR3_I	QA/QC Needed STR3	String	4	View
QTYTOPOST_I	QTY To Post	Currency	10	View
LOTNUMBR	Lot Number	String	22	View
PLANNAME_I	Plan Name	String	16	View
ACTUALDEMAND_I	Actual Demand	Currency	10	View
NOTEINDX	Note Index	Currency	10	View
MRPAMOUNT_I	MRP_Amount	Currency	10	View
DATE1	Date	Date	4	View
TIME1	Time	Time	4	View
BASEUOFM	Base U Of M	String	10	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View

WO010116 - MOP Historical Variance

Query Builder

Customer Service

Information

My Account

Contact Us