mops0100 - pref_mop_sys | Prospr - Dynamics GP Table Reference

mops0100 - pref_mop_sys

Query Builder

Select * from mops0100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
MANUFACTUREORDER_I	Manufacture Order	String	32	View
CMPANYID	Company ID	Integer	2	View
Delete_Configured_BOM	Delete Configured BOM	Boolean	2	View
Archive_Configured_BOM	Archive Configured BOM	Boolean	2	View
Remove_Canceled_MO	Remove Canceled MO	Boolean	2	View
Remove_Canceled_MO_Days	Remove Canceled MO Days	Integer	2	View
Remove_CF_MO	Remove CF MO	Boolean	2	View
Remove_CF_MO_Days	Remove CF MO Days	Integer	2	View
Remove_LotSerial_MO	Remove LotSerial MO	Boolean	2	View
Remove_LotSerial_MO_Days	Remove LotSerial MO Days	Integer	2	View
MOCloseOption	MO Close Option	Integer	2	View
OSRCLABEL	Outsourcing Label	String	22	View
PROCESSSECURITY	Process Security	String	32	View
PROCESSSECURITY2	Process Security 2	String	32	View
PICKNUMBER	Pick Number	String	18	View
MOPRCTNM	MOP Receipt Number	String	22	View
MOCLOSEOPTIONS_1	MO Close Options[1]	Boolean	2	View
MOCLOSEOPTIONS_2	MO Close Options[2]	Boolean	2	View
MOCLOSEOPTIONS_3	MO Close Options[3]	Boolean	2	View
MOCLOSEOPTIONS_4	MO Close Options[4]	Boolean	2	View
MOCLOSEOPTIONS_5	MO Close Options[5]	Boolean	2	View
MOCLOSEOPTIONS_6	MO Close Options[6]	Boolean	2	View
MOCLOSEOPTIONS_7	MO Close Options[7]	Boolean	2	View
MOCLOSEOPTIONS_8	MO Close Options[8]	Boolean	2	View
MOCLOSEOPTIONS_9	MO Close Options[9]	Boolean	2	View
MOCLOSEOPTIONS_10	MO Close Options[10]	Boolean	2	View
MOCLOSEOPTIONS_11	MO Close Options[11]	Boolean	2	View
MOCLOSEOPTIONS_12	MO Close Options[12]	Boolean	2	View
MOCLOSEOPTIONS_13	MO Close Options[13]	Boolean	2	View
MOCLOSEOPTIONS_14	MO Close Options[14]	Boolean	2	View
ALLOCATERELEASED	Allocate Released	Boolean	2	View
COMPLETEMOATCOMPCLOSE	Complete MO at Complete/Close	Boolean	2	View
CLOSEMOATCOMPCLOSE	Close MO at Complete/Close	Boolean	2	View
REVAL_IN_PROCESS_I	Revaluation In Process	Boolean	2	View
RECONCILE_IN_PROCESS_I	Picklist Reconcile In Process	Boolean	2	View
PRINT_PICKLIST_NOTES	Print Picklist Notes	Boolean	2	View
ALLOCATE_REV_ISS_I	Allocate upon Reverse Issue	Boolean	2	View
FLRSTCKACCNTINDEX	Floor Stock Account Index	Long Integer	4	View
CBXALLOWNEGATIVEWIP	cbxAllowNegativeWIP	Boolean	2	View
MANUALSELECT	Manual Select	Boolean	2	View
DEF_PICKLIST_SORTBY	Default Picklist Sortby	Integer	2	View
MFGUSEALLCOLLECTED	cbxUseAllCollected	Boolean	2	View
MFGUSEALLSETUP	cbxUseAllSetup	Boolean	2	View
MFGUSEALLWIP	cbxUseAllWIP	Boolean	2	View
LOTSLCTNMTHD	LotSelectionMethod	Integer	2	View
REQLNKNG	RequireLinking	Boolean	2	View
USE_DEFAULT_BIN	Use Default Bin	Boolean	2	View

mops0100 - pref_mop_sys

Query Builder

Customer Service

Information

My Account

Contact Us