Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/WR010130
Product: Manufacturing (346)
Series:
Display Name: MOP_Routing_Line Group Display Name: Manufacturing MOP
Physical Name: WR010130
Technical Name: MOP_Routing_Line
Group Technical Name: Manufacturing MOP
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | MANUFACTUREORDER_I  | Manufacture Order | String | STR30_UC | 30 | |
| 2 | RTSEQNUM_I | rtseqnum | String | STR10 | 10 | |
| 3 | DONECB_I | done_cb | Boolean | CB_Done | 0 | |
| 4 | RTSEQTYPE_I | rtseqtype | Integer | DDL_rtseqtype | 0 | |
| 5 | CLOSEDBY_I | Closed By | String | STR30 | 30 | |
| 6 | DATECLOSED_I | Date Closed | Date | DATE | 6 | |
| 7 | TIMECLOSED_I | Time Closed | Time | TM | 6 | |
| 8 | RTSEQDES_I | rtseqdes | String | STR100 | 100 | |
| 9 | ACTUALFINISHDATE_I | ActualFinishDate | Date | DATE | 6 | |
| 10 | ACTUALFINISHTIME_I | ActualFinishTime | Time | TM | 6 | |
| 11 | ACTUALSTARTDATE_I | ActualStartDate | Date | DATE | 6 | |
| 12 | ACTUALSTARTTIME_I | ActualStartTime | Time | TM | 6 | |
| 13 | SCHEDULEFINISHDATE_I | ScheduleFinishDate | Date | DATE | 6 | |
| 14 | SCHEDULEFINISHTIME_I | ScheduleFinishTime | Time | TM | 6 | |
| 15 | SCHEDULESTARTDATE_I | ScheduleStartDate | Date | DATE | 6 | |
| 16 | SCHEDULESTARTTIME_I | ScheduleStartTime | Time | TM | 6 | |
| 17 | WCID_I | WC ID | String | STR10_Location_Code | 10 | |
| 18 | OPCODE_I | Opcode | String | STR6 | 6 | |
| 19 | RTGWCID_I | rtgwcid | String | str12 | 12 | |
| 20 | RTMCID_I | rtgmcid | String | str12 | 12 | |
| 21 | MACHINEID_I | Machine ID IC | String | STR10_Location_Code | 10 | |
| 22 | SETUPTIME_I | SetupTime | Currency | hr | 10 | |
| 23 | MACHINETIME_I | MachineTime | Currency | hr | 10 | |
| 24 | RUNTIME_I | RunTime | Currency | hr | 10 | |
| 25 | LABORTIME_I | LaborTime | Currency | hr | 10 | |
| 26 | QUEUETIME_I | QueueTime | Currency | hr | 10 | |
| 27 | CYCLETIME_I | CycleTime | Currency | hr | 10 | |
| 28 | MOVETIME_I | MoveTime | Currency | hr | 10 | |
| 29 | MRPAMOUNT_I | MRP_Amount | Currency | DLR_14_MRP | 14 | |
| 30 | LABORCODE_I | Labor Code | String | STR10 | 10 | |
| 31 | LABORCODE2_I | Labor Code2 | String | STR10 | 10 | |
| 32 | RTNEXNUM_I | rtnexnum | String | STR10 | 10 | |
| 33 | RTPARNUM_I | rtparnum | String | STR10 | 10 | |
| 34 | PERCENTCOMPLETE_I | Percent Complete | Long Integer | INTXXX.X% | 4 | |
| 35 | QUANTITY_I | Quantity | Currency | DLR12_RBN_UT2 | 12 | |
| 36 | DWGNUM_I | DWG # | String | STR30_Item_Number | 30 | |
| 37 | TOOLID_I | toolid | String | STR15 | 15 | |
| 38 | WAITHOURS_I | Wait Hours | Integer | INT2 | 2 | |
| 39 | MULTIPLEEMPLOYEEOP_I | Multiple Employee Operation | Boolean | CB | 0 | |
| 40 | NUMOFEMP | Number of Employees | Integer | INT5_U0 | 5 | |
| 41 | NUMBEROFCREWS_I | Number of Crews | Integer | IINT4 | 4 | |
| 42 | LASTSEQUENCETODAY_I | LastSequenceToday | Boolean | CB | 0 | |
| 43 | TAPENUMBER_I | Tape Number | String | STR15_LBAU | 15 | |
| 44 | USERDEF1 | User Defined 1 | String | STR20 | 20 | |
| 45 | USERDEF2 | User Defined 2 | String | STR20 | 20 | |
| 46 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['MOP_Routing_Line'].USERID AS 'MOP_Routing_Line-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
WR010130 AS ['MOP_Routing_Line']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['MOP_Routing_Line'].USERID = ['Users Master'].USERID | ||||||
| 47 | CREATDDT | Created Date | Date | DT | 8 | |
| 48 | CREATETIME_I | Create Time | Time | TM | 6 | |
| 49 | CHANGEDATE_I | Change Date | Date | DT | 8 | |
| 50 | CHANGETIME_I | Change Time | Time | TM | 6 | |
| 51 | CRPALLOCATED_I | CRP_allocated | Boolean | CB | 0 | |
| 52 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['MOP_Routing_Line'].NOTEINDX AS 'MOP_Routing_Line-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
WR010130 AS ['MOP_Routing_Line']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['MOP_Routing_Line'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
| 53 | MFGNOTEINDEX_I | MFG Note Index | Currency | DLR14 | 14 | |
| 54 | PIECES_I | Pieces | Currency | DLR_14_MRP | 14 | |
| 55 | REJECTS_I | Rejects | Currency | DLR_14_MRP | 14 | |
| 56 | AUTOBACKFLUSHLABOR_I | Auto Backflush Labor | Boolean | CB_Auto_Backflush_Labor | 0 | |
| 57 | AUTOBACKMACHINE_I | Auto Backflush Machine | Boolean | CB_Auto_Backflush_Machine | 0 | |
| 58 | NUMBEROFMACHINES_I | Number of Machines | Integer | INT5_U0 | 5 | |
| 59 | QAQCNEEDED_I | QA/QC Needed | Boolean | CB_QA_Sequence | 0 | |
| 60 | POOFFSETDAYS | POOffsetDays | Integer | INT3_U0 | 3 | |
| 61 | WIPOPPERMOSTARTQTY | WIP OP per MO Start QTY | Integer | INT3_U0 | 3 | |
| 62 | PHANTOM_I | Phantom | Boolean | CB | 0 | |