MOPW500 - MOP Receipt TEMP WORK | Prospr - Dynamics GP Table Reference

MOPW500 - MOP Receipt TEMP WORK

Query Builder

Select * from MOPW500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
MOPRCTNM	MOP Receipt Number	String	22	View
ITEMNMBR	Item Number	String	32	View
PICKLISTSEQ	Picklist Seq	Long Integer	4	View
POSITION_NUMBER	Position Number	Integer	2	View
POSITION_NUMBER2	Position Number2	Integer	2	View
USERID	User ID	String	16	View
ITEMDESC	Item Description	String	102	View
ITMTRKOP	Item Tracking Option 1. None 2. Serial Numbers 3. Lot Numbers	Integer	2	View
QTYPLANNEDTOCONSUME	QTY Planned To Consume	Currency	10	View
QTYPLANNEDTOBACKFLUSH	QTY Planned To Backflush	Currency	10	View
QTYTOCONSUME	QTY To Consume	Currency	10	View
QTYTOBACKFLUSH	QTY To Backflush	Currency	10	View
BACKFLUSHSITEID	Backflush Site ID	String	12	View
BYPRODUCTSITEID	Byproduct Site ID	String	12	View
QTYTOUSE	QTY To Use	Currency	10	View
UOFM	U Of M	String	10	View
MOP_REQUIRED_QUANTITY_I	MOP Required Quantity	Currency	10	View
WIPQUANTITY	WIP Quantity	Currency	10	View
QTYAVAIL	QTY Available	Currency	10	View
QTYCONSUMEDTODATE	QTY Consumed To Date	Currency	10	View
QTYBACKFLUSHEDTODATE	QTY Backflushed To Date	Currency	10	View
QTYSLCTD	QTY Selected	Currency	10	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
NUMBERSCRAPPED_I	Number Scrapped	Currency	10	View
BOMSINGLELOT_I	BOM_Single_Lot	Boolean	2	View
BACKFLUSHCB	Backflush CB	Boolean	2	View
ATYALLOC	QTY Allocated	Currency	10	View
PLNDFIXDQTYTOCONS	Planned Fixed Quantity to Consume	Currency	10	View
PLNDFIXDQTYTOBF	Planned Fixed Quantity to Backflush	Currency	10	View
FIXDQTYTOCONS	Fixed Quantity to Consume	Currency	10	View
FIXDQTYTOBF	Fixed Quantity to Backflush	Currency	10	View
QTYSELCTDBF	QTY Selected Backflushed	Currency	10	View
FLOORSTOCK_I	Floor Stock	Boolean	2	View
NONINVENTORY	Non Inventory	Boolean	2	View
STR20DUMMY_I	STR20 Dummy	String	22	View
ITEMTYPE	Item Type 1. Sales Inventory (For SBM, this type is Stock Item.) 2. Discontinued 3. Kit 4. Misc Charges 5. Services 6. Flat Fee (For SBM, this type is Labor.)	Integer	2	View
NOTEINDX	Note Index	Currency	10	View
SUBASSEMBLYOF_I	Subassembly Of	String	32	View

MOPW500 - MOP Receipt TEMP WORK

Query Builder

Customer Service

Information

My Account

Contact Us