MOP_Routing_Line (WR010130)

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

Product: Manufacturing (346)
Series:

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

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1MANUFACTUREORDER_I SearchManufacture OrderStringSTR30_UC30
2RTSEQNUM_I SearchrtseqnumStringSTR1010
3DONECB_I Searchdone_cbBooleanCB_Done0
4RTSEQTYPE_I SearchrtseqtypeIntegerDDL_rtseqtype0
5CLOSEDBY_I SearchClosed ByStringSTR3030
6DATECLOSED_I SearchDate ClosedDateDATE6
7TIMECLOSED_I SearchTime ClosedTimeTM6
8RTSEQDES_I SearchrtseqdesStringSTR100100
9ACTUALFINISHDATE_I SearchActualFinishDateDateDATE6
10ACTUALFINISHTIME_I SearchActualFinishTimeTimeTM6
11ACTUALSTARTDATE_I SearchActualStartDateDateDATE6
12ACTUALSTARTTIME_I SearchActualStartTimeTimeTM6
13SCHEDULEFINISHDATE_I SearchScheduleFinishDateDateDATE6
14SCHEDULEFINISHTIME_I SearchScheduleFinishTimeTimeTM6
15SCHEDULESTARTDATE_I SearchScheduleStartDateDateDATE6
16SCHEDULESTARTTIME_I SearchScheduleStartTimeTimeTM6
17WCID_I SearchWC IDStringSTR10_Location_Code10
18OPCODE_I SearchOpcodeStringSTR66
19RTGWCID_I SearchrtgwcidStringstr1212
20RTMCID_I SearchrtgmcidStringstr1212
21MACHINEID_I SearchMachine ID ICStringSTR10_Location_Code10
22SETUPTIME_I SearchSetupTimeCurrencyhr10
23MACHINETIME_I SearchMachineTimeCurrencyhr10
24RUNTIME_I SearchRunTimeCurrencyhr10
25LABORTIME_I SearchLaborTimeCurrencyhr10
26QUEUETIME_I SearchQueueTimeCurrencyhr10
27CYCLETIME_I SearchCycleTimeCurrencyhr10
28MOVETIME_I SearchMoveTimeCurrencyhr10
29MRPAMOUNT_I SearchMRP_AmountCurrencyDLR_14_MRP14
30LABORCODE_I SearchLabor CodeStringSTR1010
31LABORCODE2_I SearchLabor Code2StringSTR1010
32RTNEXNUM_I SearchrtnexnumStringSTR1010
33RTPARNUM_I SearchrtparnumStringSTR1010
34PERCENTCOMPLETE_I SearchPercent CompleteLong IntegerINTXXX.X%4
35QUANTITY_I SearchQuantityCurrencyDLR12_RBN_UT212
36DWGNUM_I SearchDWG #StringSTR30_Item_Number30
37TOOLID_I SearchtoolidStringSTR1515
38WAITHOURS_I SearchWait HoursIntegerINT22
39MULTIPLEEMPLOYEEOP_I SearchMultiple Employee OperationBooleanCB0
40NUMOFEMP SearchNumber of EmployeesIntegerINT5_U05
41NUMBEROFCREWS_I SearchNumber of CrewsIntegerIINT44
42LASTSEQUENCETODAY_I SearchLastSequenceTodayBooleanCB0
43TAPENUMBER_I SearchTape NumberStringSTR15_LBAU15
44USERDEF1 SearchUser Defined 1StringSTR2020
45USERDEF2 SearchUser Defined 2StringSTR2020
46USERID SearchUser IDStringSTR15_User_ID15
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 DateDateDT8
48CREATETIME_I SearchCreate TimeTimeTM6
49CHANGEDATE_I SearchChange DateDateDT8
50CHANGETIME_I SearchChange TimeTimeTM6
51CRPALLOCATED_I SearchCRP_allocatedBooleanCB0
52NOTEINDX SearchNote IndexCurrencyDLR1414
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 IndexCurrencyDLR1414
54PIECES_I SearchPiecesCurrencyDLR_14_MRP14
55REJECTS_I SearchRejectsCurrencyDLR_14_MRP14
56AUTOBACKFLUSHLABOR_I SearchAuto Backflush LaborBooleanCB_Auto_Backflush_Labor0
57AUTOBACKMACHINE_I SearchAuto Backflush MachineBooleanCB_Auto_Backflush_Machine0
58NUMBEROFMACHINES_I SearchNumber of MachinesIntegerINT5_U05
59QAQCNEEDED_I SearchQA/QC NeededBooleanCB_QA_Sequence0
60POOFFSETDAYS SearchPOOffsetDaysIntegerINT3_U03
61WIPOPPERMOSTARTQTY SearchWIP OP per MO Start QTYIntegerINT3_U03
62PHANTOM_I SearchPhantomBooleanCB0

Leave a Reply

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