routing_line_Copy2 (RT010130)

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

Product: Manufacturing (346)
Series: 3rd Party

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

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ROUTINGNAME_I SearchRoutingNameSTR30_Item_NumberString30
2RTSEQNUM_I SearchrtseqnumSTR10String10
3ITEMNMBR SearchItem NumberSTR30_Item_NumberString30
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
4RTSEQTYPE_I SearchrtseqtypeDDL_rtseqtypeInteger0
5RTSEQDES_I SearchrtseqdesSTR100String100
6WCID_I SearchWC IDSTR10_Location_CodeString10
7OPCODE_I SearchOpcodeSTR6String6
8RTGWCID_I Searchrtgwcidstr12String12
9RTMCID_I Searchrtgmcidstr12String12
10MACHINEID_I SearchMachine ID ICSTR10_Location_CodeString10
11SETUPTIME_I SearchSetupTimehrCurrency10
12MACHINETIME_I SearchMachineTimehrCurrency10
13RUNTIME_I SearchRunTimehrCurrency10
14LABORTIME_I SearchLaborTimehrCurrency10
15QUEUETIME_I SearchQueueTimehrCurrency10
16CYCLETIME_I SearchCycleTimehrCurrency10
17MOVETIME_I SearchMoveTimehrCurrency10
18PERCENTCOMPLETE_I SearchPercent CompleteINTXXX.X%Long Integer4
19QUANTITY_I SearchQuantityDLR12_RBN_UT2Currency12
20LABORCODE_I SearchLabor CodeSTR10String10
21LABORCODE2_I SearchLabor Code2STR10String10
22RTPARNUM_I SearchrtparnumSTR10String10
23RTNEXNUM_I SearchrtnexnumSTR10String10
24DWGNUM_I SearchDWG #STR30_Item_NumberString30
25TOOLID_I SearchtoolidSTR15String15
26WAITHOURS_I SearchWait HoursINT2Integer2
27MULTIPLEEMPLOYEEOP_I SearchMultiple Employee OperationCBBoolean0
28NUMOFEMP SearchNumber of EmployeesINT5_U0Integer5
29LASTSEQUENCETODAY_I SearchLastSequenceTodayCBBoolean0
30TAPENUMBER_I SearchTape NumberSTR15_LBAUString15
31USERDEF1 SearchUser Defined 1STR20String20
32USERDEF2 SearchUser Defined 2STR20String20
33NOTEINDX SearchNote IndexDLR14Currency14
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
34MFGNOTEINDEX_I SearchMFG Note IndexDLR14Currency14
35USERID SearchUser IDSTR15_User_IDString15
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
36CREATDDT SearchCreated DateDTDate8
37CREATETIME_I SearchCreate TimeTMTime6
38CHANGEDATE_I SearchChange DateDTDate8
39CHANGETIME_I SearchChange TimeTMTime6
40AUTOBACKFLUSHLABOR_I SearchAuto Backflush LaborCB_Auto_Backflush_LaborBoolean0
41AUTOBACKMACHINE_I SearchAuto Backflush MachineCB_Auto_Backflush_MachineBoolean0
42NUMBEROFMACHINES_I SearchNumber of MachinesINT5_U0Integer5
43NUMBEROFCREWS_I SearchNumber of CrewsIINT4Integer4
44QAQCNEEDED_I SearchQA/QC NeededCB_QA_SequenceBoolean0
45POOFFSETDAYS SearchPOOffsetDaysINT3_U0Integer3
46WIPOPPERMOSTARTQTY SearchWIP OP per MO Start QTYINT3_U0Integer3
47DEX_ROW_ID Searchintint10

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.

Leave a Reply

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