routing_line (RT010130)

azurecurve Products Manufacturing (346)3rd Partyrouting_line (RT010130)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RT010130

Display Name: routing_line
Physical Name: RT010130
Technical Name: routing_line

Group Display Name: Manufacturing Routings
Group Technical Name: Manufacturing Routing

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ROUTINGNAME_I	RoutingName	String	STR30_Item_Number	30
2	RTSEQNUM_I	rtseqnum	String	STR10	10
3	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['routing_line'].ITEMNMBR AS 'routing_line-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM RT010130 AS ['routing_line'] INNER JOIN IV00101 AS ['Item Master'] ON ['routing_line'].ITEMNMBR = ['Item Master'].ITEMNMBR
4	RTSEQTYPE_I	rtseqtype	Integer	DDL_rtseqtype	0
5	RTSEQDES_I	rtseqdes	String	STR100	100
6	WCID_I	WC ID	String	STR10_Location_Code	10
7	OPCODE_I	Opcode	String	STR6	6
8	RTGWCID_I	rtgwcid	String	str12	12
9	RTMCID_I	rtgmcid	String	str12	12
10	MACHINEID_I	Machine ID IC	String	STR10_Location_Code	10
11	SETUPTIME_I	SetupTime	Currency	hr	10
12	MACHINETIME_I	MachineTime	Currency	hr	10
13	RUNTIME_I	RunTime	Currency	hr	10
14	LABORTIME_I	LaborTime	Currency	hr	10
15	QUEUETIME_I	QueueTime	Currency	hr	10
16	CYCLETIME_I	CycleTime	Currency	hr	10
17	MOVETIME_I	MoveTime	Currency	hr	10
18	PERCENTCOMPLETE_I	Percent Complete	Long Integer	INTXXX.X%	4
19	QUANTITY_I	Quantity	Currency	DLR12_RBN_UT2	12
20	LABORCODE_I	Labor Code	String	STR10	10
21	LABORCODE2_I	Labor Code2	String	STR10	10
22	RTPARNUM_I	rtparnum	String	STR10	10
23	RTNEXNUM_I	rtnexnum	String	STR10	10
24	DWGNUM_I	DWG #	String	STR30_Item_Number	30
25	TOOLID_I	toolid	String	STR15	15
26	WAITHOURS_I	Wait Hours	Integer	INT2	2
27	MULTIPLEEMPLOYEEOP_I	Multiple Employee Operation	Boolean	CB	0
28	NUMOFEMP	Number of Employees	Integer	INT5_U0	5
29	LASTSEQUENCETODAY_I	LastSequenceToday	Boolean	CB	0
30	TAPENUMBER_I	Tape Number	String	STR15_LBAU	15
31	USERDEF1	User Defined 1	String	STR20	20
32	USERDEF2	User Defined 2	String	STR20	20
33	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['routing_line'].NOTEINDX AS 'routing_line-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM RT010130 AS ['routing_line'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['routing_line'].NOTEINDX = ['Record Notes Master'].NOTEINDX
34	MFGNOTEINDEX_I	MFG Note Index	Currency	DLR14	14
35	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['routing_line'].USERID AS 'routing_line-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM RT010130 AS ['routing_line'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['routing_line'].USERID = ['Users Master'].USERID
36	CREATDDT	Created Date	Date	DT	8
37	CREATETIME_I	Create Time	Time	TM	6
38	CHANGEDATE_I	Change Date	Date	DT	8
39	CHANGETIME_I	Change Time	Time	TM	6
40	AUTOBACKFLUSHLABOR_I	Auto Backflush Labor	Boolean	CB_Auto_Backflush_Labor	0
41	AUTOBACKMACHINE_I	Auto Backflush Machine	Boolean	CB_Auto_Backflush_Machine	0
42	NUMBEROFMACHINES_I	Number of Machines	Integer	INT5_U0	5
43	NUMBEROFCREWS_I	Number of Crews	Integer	IINT4	4
44	QAQCNEEDED_I	QA/QC Needed	Boolean	CB_QA_Sequence	0
45	POOFFSETDAYS	POOffsetDays	Integer	INT3_U0	3
46	WIPOPPERMOSTARTQTY	WIP OP per MO Start QTY	Integer	INT3_U0	3

azurecurve Products Manufacturing (346)3rd Partyrouting_line (RT010130)

2 thoughts on “routing_line (RT010130)”

Lucas Van Vonderen says:

8th November 2022 at 1850

On the page for RT010130 the Note index relation to SY03900 is incorrect. This should reference Table MN010000.

1. iangrieve says:
  
  10th January 2023 at 1416
  
  Thanks, Lukas.
  
  I add the note links in an automated way. I’ll see about getting this updated for the Mfg tables to point at the correct table.

Click to show/hide

Click to show/hide

Click to show/hide

2 thoughts on “routing_line (RT010130)”

Leave a Reply Cancel reply