RT010130 - routing_line | Prospr - Dynamics GP Table Reference

RT010130 - routing_line

Query Builder

Select * from RT010130

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ROUTINGNAME_I	RoutingName	String	32	View
RTSEQNUM_I	rtseqnum	String	12	View
ITEMNMBR	Item Number	String	32	View
RTSEQTYPE_I	rtseqtype	Integer	2	View
RTSEQDES_I	rtseqdes	String	102	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
PERCENTCOMPLETE_I	Percent Complete	Long Integer	4	View
QUANTITY_I	Quantity	Currency	10	View
LABORCODE_I	Labor Code	String	12	View
LABORCODE2_I	Labor Code2	String	12	View
RTPARNUM_I	rtparnum	String	12	View
RTNEXNUM_I	rtnexnum	String	12	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
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
NOTEINDX	Note Index	Currency	10	View
MFGNOTEINDEX_I	MFG Note Index	Currency	10	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
AUTOBACKFLUSHLABOR_I	Auto Backflush Labor	Boolean	2	View
AUTOBACKMACHINE_I	Auto Backflush Machine	Boolean	2	View
NUMBEROFMACHINES_I	Number of Machines	Integer	2	View
NUMBEROFCREWS_I	Number of Crews	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

RT010130 - routing_line

Query Builder

Customer Service

Information

My Account

Contact Us