MOP3000 - MOP Variances | Prospr - Dynamics GP Table Reference

MOP3000 - MOP Variances

Query Builder

Select * from MOP3000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
MANUFACTUREORDER_I	Manufacture Order	String	32	View
MANUFACTUREORDERST_I	Manufacture Order Status	Integer	2	View
ENDQTY_I	End QTY	Currency	10	View
QTYRECVD	QTY Received	Currency	10	View
ITEMNMBR	Item Number	String	32	View
VCTNMTHD	Valuation Method 1. FIFO Perpetual 2. LIFO Perpetual 3. Average Perpetual 4. FIFO Periodic (This value is not available for SBM.) 5. LIFO Periodic (This value is not available for SBM.)	Integer	2	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
STDMATQTYRCD	Var_StdMatQtyRcd	Currency	10	View
STDMATFOQTYRCD	Var_StdMatFoQtyRcd	Currency	10	View
STDMATVOQTYRCD	Var_StdMatVoQtyRcd	Currency	10	View
STDLABQTYRCD	Var_StdLabQtyRcd	Currency	10	View
STDLABFOQTYRCD	Var_StdLabFoQtyRcd	Currency	10	View
STDLABVOQTYRCD	Var_StdLabVoQtyRcd	Currency	10	View
STDMACHQTYRCD	Var_StdMachQtyRcd	Currency	10	View
STDMACHFOQTYRCD	Var_StdMachFoQtyRcd	Currency	10	View
STDMACHVOQTYRCD	Var_StdMachVoQtyRcd	Currency	10	View
STDTOTALQTYRCD	Var_StdTotalQtyRcd	Currency	10	View
STDMATQTYEND	Var_StdMatQtyEnd	Currency	10	View
STDMATFOQTYEND	Var_StdMatFoQtyEnd	Currency	10	View
STDMATVOQTYEND	Var_StdMatVoQtyEnd	Currency	10	View
STDLABQTYEND	Var_StdLabQtyEnd	Currency	10	View
STDLABFOQTYEND	Var_StdLabFoQtyEnd	Currency	10	View
STDLABVOQTYEND	Var_StdLabVoQtyEnd	Currency	10	View
STDMACHQTYEND	Var_StdMachQtyEnd	Currency	10	View
STDMACHFOQTYEND	Var_StdMachFoQtyEnd	Currency	10	View
STDMACHVOQTYEND	Var_StdMachVoQtyEnd	Currency	10	View
STDTOTALQTYEND	Var_StdTotalQtyEnd	Currency	10	View
PRODMATQTYRCD	Var_ProdMatQtyRcd	Currency	10	View
PRODMATFOQTYRCD	Var_ProdMatFoQtyRcd	Currency	10	View
PRODMATVOQTYRCD	Var_ProdMatVoQtyRcd	Currency	10	View
PRODLABQTYRCD	Var_ProdLabQtyRcd	Currency	10	View
PRODLABFOQTYRCD	Var_ProdLabFoQtyRcd	Currency	10	View
PRODLABVOQTYRCD	Var_ProdLabVoQtyRcd	Currency	10	View
PRODMACHQTYRCD	Var_ProdMachQtyRcd	Currency	10	View
PRODMACHFOQTYRCD	Var_ProdMachFoQtyRcd	Currency	10	View
PRODMACHVOQTYRCD	Var_ProdMachVoQtyRcd	Currency	10	View
PRODTOTALQTYRCD	Var_ProdTotalQtyRcd	Currency	10	View
PRODMATQTYEND	Var_ProdMatQtyEnd	Currency	10	View
PRODMATFOQTYEND	Var_ProdMatFoQtyEnd	Currency	10	View
PRODMATVOQTYEND	Var_ProdMatVoQtyEnd	Currency	10	View
PRODLABQTYEND	Var_ProdLabQtyEnd	Currency	10	View
PRODLABFOQTYEND	Var_ProdLabFoQtyEnd	Currency	10	View
PRODLABVOQTYEND	Var_ProdLabVoQtyEnd	Currency	10	View
PRODMACHQTYEND	Var_ProdMachQtyEnd	Currency	10	View
PRODMACHFOQTYEND	Var_ProdMachFoQtyEnd	Currency	10	View
PRODMACHVOQTYEND	Var_ProdMachVoQtyEnd	Currency	10	View
PRODTOTALQTYEND	Var_ProdTotalQtyEnd	Currency	10	View
MATWIPIN	Var_MatQtyWipIn	Currency	10	View
MATFOWIPIN	Var_MatFoQtyWipIn	Currency	10	View
MATVOWIPIN	Var_MatVoQtyWipIn	Currency	10	View
LABWIPIN	Var_LabQtyWipIn	Currency	10	View
LABFOWIPIN	Var_LabFoQtyWipIn	Currency	10	View
LABVOWIPIN	Var_LabVoQtyWipIn	Currency	10	View
MACHWIPIN	Var_MachQtyWipIn	Currency	10	View
MACHFOWIPIN	Var_MachFoQtyWipIn	Currency	10	View
MACHVOWIPIN	Var_MachVoQtyWipIn	Currency	10	View
TOTALWIPIN	Var_TotalQtyWipIn	Currency	10	View
MATWIPCONSUMED	Var_MatQtyWipConsumed	Currency	10	View
MATFOWIPCONSUMED	Var_MatFoQtyWipConsumed	Currency	10	View
MATVOWIPCONSUMED	Var_MatVoQtyWipConsumed	Currency	10	View
LABWIPCONSUMED	Var_LabQtyWipConsumed	Currency	10	View
LABFOWIPCONSUMED	Var_LabFoQtyWipConsumed	Currency	10	View
LABVOWIPCONSUMED	Var_LabVoQtyWipConsumed	Currency	10	View
MACHWIPCONSUMED	Var_MachQtyWipConsumed	Currency	10	View
MACHFOWIPCONSUMED	Var_MachFoQtyWipConsumed	Currency	10	View
MACHVOWIPCONSUMED	Var_MachVoQtyWipConsumed	Currency	10	View
TOTALWIPCONSUMED	Var_TotalQtyWipConsumed	Currency	10	View
STDMATQTYRCDVAR	Var_StdMatQtyRcdVar	Currency	10	View
STDMATFOQTYRCDVAR	Var_StdMatFoQtyRcdVar	Currency	10	View
STDMATVOQTYRCDVAR	Var_StdMatVoQtyRcdVar	Currency	10	View
STDLABQTYRCDVAR	Var_StdLabQtyRcdVar	Currency	10	View
STDLABFOQTYRCDVAR	Var_StdLabFoQtyRcdVar	Currency	10	View
STDLABVOQTYRCDVAR	Var_StdLabVoQtyRcdVar	Currency	10	View
STDMACHQTYRCDVAR	Var_StdMachQtyRcdVar	Currency	10	View
STDMACHFOQTYRCDVAR	Var_StdMachFoQtyRcdVar	Currency	10	View
STDMACHVOQTYRCDVAR	Var_StdMachVoQtyRcdVar	Currency	10	View
STDTOTALQTYRCDVAR	Var_StdTotalQtyRcdVar	Currency	10	View
STDMATQTYENDVAR	Var_StdMatQtyEndVar	Currency	10	View
STDMATFOQTYENDVAR	Var_StdMatFoQtyEndVar	Currency	10	View
STDMATVOQTYENDVAR	Var_StdMatVoQtyEndVar	Currency	10	View
STDLABQTYENDVAR	Var_StdLabQtyEndVar	Currency	10	View
STDLABFOQTYENDVAR	Var_StdLabFoQtyEndVar	Currency	10	View
STDLABVOQTYENDVAR	Var_StdLabVoQtyEndVar	Currency	10	View
STDMACHQTYENDVAR	Var_StdMachQtyEndVar	Currency	10	View
STDMACHFOQTYENDVAR	Var_StdMachFoQtyEndVar	Currency	10	View
STDMACHVOQTYENDVAR	Var_StdMachVoQtyEndVar	Currency	10	View
STDTOTALQTYENDVAR	Var_StdTotalQtyEndVar	Currency	10	View
STDMATQTYRCDVARPCT	Var_StdMatQtyRcdVarPct	Currency	10	View
STDMATFOQTYRCDVARPCT	Var_StdMatFoQtyRcdVarPct	Currency	10	View
STDMATVOQTYRCDVARPCT	Var_StdMatVoQtyRcdVarPct	Currency	10	View
STDLABQTYRCDVARPCT	Var_StdLabQtyRcdVarPct	Currency	10	View
STDLABFOQTYRCDVARPCT	Var_StdLabFoQtyRcdVarPct	Currency	10	View
STDLABVOQTYRCDVARPCT	Var_StdLabVoQtyRcdVarPct	Currency	10	View
STDMACHQTYRCDVARPCT	Var_StdMachQtyRcdVarPct	Currency	10	View
STDMACHFOQTYRCDVARPCT	Var_StdMachFoQtyRcdVarPct	Currency	10	View
STDMACHVOQTYRCDVARPCT	Var_StdMachVoQtyRcdVarPct	Currency	10	View
STDTOTALQTYRCDVARPCT	Var_StdTotalQtyRcdVarPct	Currency	10	View
STDMATQTYENDVARPCT	Var_StdMatQtyEndVarPct	Currency	10	View
STDMATFOQTYENDVARPCT	Var_StdMatFoQtyEndVarPct	Currency	10	View
STDMATVOQTYENDVARPCT	Var_StdMatVoQtyEndVarPct	Currency	10	View
STDLABQTYENDVARPCT	Var_StdLabQtyEndVarPct	Currency	10	View
STDLABFOQTYENDVARPCT	Var_StdLabFoQtyEndVarPct	Currency	10	View
STDLABVOQTYENDVARPCT	Var_StdLabVoQtyEndVarPct	Currency	10	View
STDMACHQTYENDVARPCT	Var_StdMachQtyEndVarPct	Currency	10	View
STDMACHFOQTYENDVARPCT	Var_StdMachFoQtyEndVarPct	Currency	10	View
STDMACHVOQTYENDVARPCT	Var_StdMachVoQtyEndVarPct	Currency	10	View
STDTOTALQTYENDVARPCT	Var_StdTotalQtyEndVarPct	Currency	10	View
PRODMATQTYRCDVAR	Var_ProdMatQtyRcdVar	Currency	10	View
PRODMATFOQTYRCDVAR	Var_ProdMatFoQtyRcdVar	Currency	10	View
PRODMATVOQTYRCDVAR	Var_ProdMatVoQtyRcdVar	Currency	10	View
PRODLABQTYRCDVAR	Var_ProdLabQtyRcdVar	Currency	10	View
PRODLABFOQTYRCDVAR	Var_ProdLabFoQtyRcdVar	Currency	10	View
PRODLABVOQTYRCDVAR	Var_ProdLabVoQtyRcdVar	Currency	10	View
PRODMACHQTYRCDVAR	Var_ProdMachQtyRcdVar	Currency	10	View
PRODMACHFOQTYRCDVAR	Var_ProdMachFoQtyRcdVar	Currency	10	View
PRODMACHVOQTYRCDVAR	Var_ProdMachVoQtyRcdVar	Currency	10	View
PRODTOTALQTYRCDVAR	Var_ProdTotalQtyRcdVar	Currency	10	View
PRODMATQTYENDVAR	Var_ProdMatQtyEndVar	Currency	10	View
PRODMATFOQTYENDVAR	Var_ProdMatFoQtyEndVar	Currency	10	View
PRODMATVOQTYENDVAR	Var_ProdMatVoQtyEndVar	Currency	10	View
PRODLABQTYENDVAR	Var_ProdLabQtyEndVar	Currency	10	View
PRODLABFOQTYENDVAR	Var_ProdLabFoQtyEndVar	Currency	10	View
PRODLABVOQTYENDVAR	Var_ProdLabVoQtyEndVar	Currency	10	View
PRODMACHQTYENDVAR	Var_ProdMachQtyEndVar	Currency	10	View
PRODMACHFOQTYENDVAR	Var_ProdMachFoQtyEndVar	Currency	10	View
PRODMACHVOQTYENDVAR	Var_ProdMachVoQtyEndVar	Currency	10	View
PRODTOTALQTYENDVAR	Var_ProdTotalQtyEndVar	Currency	10	View
PRODMATQTYRCDVARPCT	Var_ProdMatQtyRcdVarPct	Currency	10	View
PRODMATFOQTYRCDVARPCT	Var_ProdMatFoQtyRcdVarPct	Currency	10	View
PRODMATVOQTYRCDVARPCT	Var_ProdMatVoQtyRcdVarPct	Currency	10	View
PRODLABQTYRCDVARPCT	Var_ProdLabQtyRcdVarPct	Currency	10	View
PRODLABFOQTYRCDVARPCT	Var_ProdLabFoQtyRcdVarPct	Currency	10	View
PRODLABVOQTYRCDVARPCT	Var_ProdLabVoQtyRcdVarPct	Currency	10	View
PRODMACHQTYRCDVARPCT	Var_ProdMachQtyRcdVarPct	Currency	10	View
PRODMACHFOQTYRCDVARPCT	Var_ProdMachFoQtyRcdVarPct	Currency	10	View
PRODMACHVOQTYRCDVARPCT	Var_ProdMachVoQtyRcdVarPct	Currency	10	View
PRODTOTALQTYRCDVARPCT	Var_ProdTotalQtyRcdVarPct	Currency	10	View
PRODMATQTYENDVARPCT	Var_ProdMatQtyEndVarPct	Currency	10	View
PRODMATFOQTYENDVARPCT	Var_ProdMatFoQtyEndVarPct	Currency	10	View
PRODMATVOQTYENDVARPCT	Var_ProdMatVoQtyEndVarPct	Currency	10	View
PRODLABQTYENDVARPCT	Var_ProdLabQtyEndVarPct	Currency	10	View
PRODLABFOQTYENDVARPCT	Var_ProdLabFoQtyEndVarPct	Currency	10	View
PRODLABVOQTYENDVARPCT	Var_ProdLabVoQtyEndVarPct	Currency	10	View
PRODMACHQTYENDVARPCT	Var_ProdMachQtyEndVarPct	Currency	10	View
PRODMACHFOQTYENDVARPCT	Var_ProdMachFoQtyEndVarPct	Currency	10	View
PRODMACHVOQTYENDVARPCT	Var_ProdMachVoQtyEndVarPct	Currency	10	View
PRODTOTALQTYENDVARPCT	Var_ProdTotalQtyEndVarPct	Currency	10	View
PRODTOTALQTYENDVARPCT2	Var_ProdTotalQtyEndVarPct2	Currency	10	View
MATVARPCT	Var_MatQtyVarPct	Currency	10	View
MATFOVARPCT	Var_MatFoQtyVarPct	Currency	10	View
MATVOVARPCT	Var_MatVoQtyVarPct	Currency	10	View
LABVARPCT	Var_LabQtyVarPct	Currency	10	View
LABFOVARPCT	Var_LabFoQtyVarPct	Currency	10	View
LABVOVARPCT	Var_LabVoQtyVarPct	Currency	10	View
MACHVARPCT	Var_MachQtyVarPct	Currency	10	View
MACHFOVARPCT	Var_MachFoQtyVarPct	Currency	10	View
MACHVOVARPCT	Var_MachVoQtyVarPct	Currency	10	View
TOTALVARPCT	Var_TotalQtyVarPct	Currency	10	View

MOP3000 - MOP Variances

Query Builder

Customer Service

Information

My Account

Contact Us