MP040901 - MRP_Routing_Line | Prospr - Dynamics GP Table Reference

MP040901 - MRP_Routing_Line

Query Builder

Select * from MP040901

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
MANUFACTUREORDER_I	Manufacture Order	String	32	View
RTSEQNUM_I	rtseqnum	String	12	View
DONECB_I	done_cb	Boolean	2	View
RTSEQTYPE_I	rtseqtype	Integer	2	View
CLOSEDBY_I	Closed By	String	32	View
DATECLOSED_I	Date Closed	Date	4	View
TIMECLOSED_I	Time Closed	Time	4	View
RTSEQDES_I	rtseqdes	String	102	View
ACTUALFINISHDATE_I	ActualFinishDate	Date	4	View
ACTUALFINISHTIME_I	ActualFinishTime	Time	4	View
ACTUALSTARTDATE_I	ActualStartDate	Date	4	View
ACTUALSTARTTIME_I	ActualStartTime	Time	4	View
SCHEDULEFINISHDATE_I	ScheduleFinishDate	Date	4	View
SCHEDULEFINISHTIME_I	ScheduleFinishTime	Time	4	View
SCHEDULESTARTDATE_I	ScheduleStartDate	Date	4	View
SCHEDULESTARTTIME_I	ScheduleStartTime	Time	4	View
WCID_I	WC ID	String	12	View
OPCODE_I	Opcode	String	8	View
RTGWCID_I	rtgwcid	String	14	View
RTMCID_I	rtgmcid	String	14	View
MACHINEID_I	Machine ID IC	String	12	View
SETUPTIME_I	SetupTime	Currency	10	View
MACHINETIME_I	MachineTime	Currency	10	View
RUNTIME_I	RunTime	Currency	10	View
LABORTIME_I	LaborTime	Currency	10	View
QUEUETIME_I	QueueTime	Currency	10	View
CYCLETIME_I	CycleTime	Currency	10	View
MOVETIME_I	MoveTime	Currency	10	View
MRPAMOUNT_I	MRP_Amount	Currency	10	View
LABORCODE_I	Labor Code	String	12	View
LABORCODE2_I	Labor Code2	String	12	View
RTNEXNUM_I	rtnexnum	String	12	View
RTPARNUM_I	rtparnum	String	12	View
PERCENTCOMPLETE_I	Percent Complete	Long Integer	4	View
QUANTITY_I	Quantity	Currency	10	View
DWGNUM_I	DWG #	String	32	View
TOOLID_I	toolid	String	16	View
WAITHOURS_I	Wait Hours	Integer	2	View
MULTIPLEEMPLOYEEOP_I	Multiple Employee Operation	Boolean	2	View
NUMOFEMP	Number of Employees	Integer	2	View
NUMBEROFCREWS_I	Number of Crews	Integer	2	View
LASTSEQUENCETODAY_I	LastSequenceToday	Boolean	2	View
TAPENUMBER_I	Tape Number	String	16	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
USERID	User ID	String	16	View
CREATDDT	Created Date	Date	4	View
CREATETIME_I	Create Time	Time	4	View
CHANGEDATE_I	Change Date	Date	4	View
CHANGETIME_I	Change Time	Time	4	View
CRPALLOCATED_I	CRP_allocated	Boolean	2	View
NOTEINDX	Note Index	Currency	10	View
MFGNOTEINDEX_I	MFG Note Index	Currency	10	View
PIECES_I	Pieces	Currency	10	View
REJECTS_I	Rejects	Currency	10	View
AUTOBACKFLUSHLABOR_I	Auto Backflush Labor	Boolean	2	View
AUTOBACKMACHINE_I	Auto Backflush Machine	Boolean	2	View
NUMBEROFMACHINES_I	Number of Machines	Integer	2	View
QAQCNEEDED_I	QA/QC Needed	Boolean	2	View
POOFFSETDAYS	POOffsetDays	Integer	2	View
WIPOPPERMOSTARTQTY	WIP OP per MO Start QTY	Integer	2	View

MP040901 - MRP_Routing_Line

Query Builder

Customer Service

Information

My Account

Contact Us