Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RTH10100
Product: Manufacturing (346)
Series:
Display Name: routing_sum Group Display Name: Manufacturing Routings
Physical Name: RTH10100
Technical Name: routing_sum
Group Technical Name: Manufacturing Routing
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['routing_sum'].ITEMNMBR AS 'routing_sum-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
RTH10100 AS ['routing_sum']
INNER JOIN
IV00101 AS ['Item Master']
ON
['routing_sum'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
2 | ROUTINGNAME_I | RoutingName | String | STR30_Item_Number | 30 | |
3 | QUEUETIME_I | QueueTime | Currency | hr | 10 | |
4 | MACHINETIME_I | MachineTime | Currency | hr | 10 | |
5 | RUNTIME_I | RunTime | Currency | hr | 10 | |
6 | LABORTIME_I | LaborTime | Currency | hr | 10 | |
7 | SETUPTIME_I | SetupTime | Currency | hr | 10 | |
8 | CYCLETIME_I | CycleTime | Currency | hr | 10 | |
9 | MOVETIME_I | MoveTime | Currency | hr | 10 |