MOP_Routing_Line_Copy1 (WR010130)

azurecurveProductsManufacturing (346)3rd PartyMOP_Routing_Line_Copy1 (WR010130)

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

Product: Manufacturing (346)
Series: 3rd Party

Display Name: MOP_Routing_Line
Physical Name: WR010130
Technical Name: MOP_Routing_Line_Copy2

Group Display Name: Manufacturing MOP
Group Technical Name: Manufacturing MOP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1MANUFACTUREORDER_I SearchManufacture OrderSTR30_UCString3230
2RTSEQNUM_I SearchrtseqnumSTR10String1210
3DONECB_I Searchdone_cbCB_DoneBoolean20
4RTSEQTYPE_I SearchrtseqtypeDDL_rtseqtypeInteger20
5CLOSEDBY_I SearchClosed BySTR30String3230
6DATECLOSED_I SearchDate ClosedDATEDate46
7TIMECLOSED_I SearchTime ClosedTMTime46
8RTSEQDES_I SearchrtseqdesSTR100String102100
9ACTUALFINISHDATE_I SearchActualFinishDateDATEDate46
10ACTUALFINISHTIME_I SearchActualFinishTimeTMTime46
11ACTUALSTARTDATE_I SearchActualStartDateDATEDate46
12ACTUALSTARTTIME_I SearchActualStartTimeTMTime46
13SCHEDULEFINISHDATE_I SearchScheduleFinishDateDATEDate46
14SCHEDULEFINISHTIME_I SearchScheduleFinishTimeTMTime46
15SCHEDULESTARTDATE_I SearchScheduleStartDateDATEDate46
16SCHEDULESTARTTIME_I SearchScheduleStartTimeTMTime46
17WCID_I SearchWC IDSTR10_Location_CodeString1210
18OPCODE_I SearchOpcodeSTR6String86
19RTGWCID_I Searchrtgwcidstr12String1412
20RTMCID_I Searchrtgmcidstr12String1412
21MACHINEID_I SearchMachine ID ICSTR10_Location_CodeString1210
22SETUPTIME_I SearchSetupTimehrCurrency1010
23MACHINETIME_I SearchMachineTimehrCurrency1010
24RUNTIME_I SearchRunTimehrCurrency1010
25LABORTIME_I SearchLaborTimehrCurrency1010
26QUEUETIME_I SearchQueueTimehrCurrency1010
27CYCLETIME_I SearchCycleTimehrCurrency1010
28MOVETIME_I SearchMoveTimehrCurrency1010
29MRPAMOUNT_I SearchMRP_AmountDLR_14_MRPCurrency1014
30LABORCODE_I SearchLabor CodeSTR10String1210
31LABORCODE2_I SearchLabor Code2STR10String1210
32RTNEXNUM_I SearchrtnexnumSTR10String1210
33RTPARNUM_I SearchrtparnumSTR10String1210
34PERCENTCOMPLETE_I SearchPercent CompleteINTXXX.X%Long Integer44
35QUANTITY_I SearchQuantityDLR12_RBN_UT2Currency1012
36DWGNUM_I SearchDWG #STR30_Item_NumberString3230
37TOOLID_I SearchtoolidSTR15String1615
38WAITHOURS_I SearchWait HoursINT2Integer22
39MULTIPLEEMPLOYEEOP_I SearchMultiple Employee OperationCBBoolean20
40NUMOFEMP SearchNumber of EmployeesINT5_U0Integer25
41NUMBEROFCREWS_I SearchNumber of CrewsIINT4Integer24
42LASTSEQUENCETODAY_I SearchLastSequenceTodayCBBoolean20
43TAPENUMBER_I SearchTape NumberSTR15_LBAUString1615
44USERDEF1 SearchUser Defined 1STR20String2220
45USERDEF2 SearchUser Defined 2STR20String2220
46USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['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
47CREATDDT SearchCreated DateDTDate48
48CREATETIME_I SearchCreate TimeTMTime46
49CHANGEDATE_I SearchChange DateDTDate48
50CHANGETIME_I SearchChange TimeTMTime46
51CRPALLOCATED_I SearchCRP_allocatedCBBoolean20
52NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['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
53MFGNOTEINDEX_I SearchMFG Note IndexDLR14Currency1014
54PIECES_I SearchPiecesDLR_14_MRPCurrency1014
55REJECTS_I SearchRejectsDLR_14_MRPCurrency1014
56AUTOBACKFLUSHLABOR_I SearchAuto Backflush LaborCB_Auto_Backflush_LaborBoolean20
57AUTOBACKMACHINE_I SearchAuto Backflush MachineCB_Auto_Backflush_MachineBoolean20
58NUMBEROFMACHINES_I SearchNumber of MachinesINT5_U0Integer25
59QAQCNEEDED_I SearchQA/QC NeededCB_QA_SequenceBoolean20
60POOFFSETDAYS SearchPOOffsetDaysINT3_U0Integer23
61WIPOPPERMOSTARTQTY SearchWIP OP per MO Start QTYINT3_U0Integer23
62PHANTOM_I SearchPhantomCBBoolean20
63DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsManufacturing (346)3rd PartyMOP_Routing_Line_Copy1 (WR010130)

Leave a Reply

Your email address will not be published. Required fields are marked *