Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/99000764
Table Type: Company
Table Name: Routing Line
Database Table Name: CRONUS UK Ltd_$Routing Line$437dbf0e-84ff-417a-965d-ed2bb9650972
Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Routing Line can be queried.
Show/hide an example select of all columns
Show/hide an example select of all columns by name
Show/hide an example select of all columns including those from all joined tables
Show/hide columns in Routing Line table
Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | Routing No. | Routing No. | Normal | Code | 20 | Routing No_ | nvarchar(40) |
Key to join to the Routing Header table.Show/hide example query | |||||||
2 | Version Code | Version Code | Normal | Code | 20 | Version Code | nvarchar(40) |
4 | Operation No. | Operation No. | Normal | Code | 10 | Operation No_ | nvarchar(20) |
5 | Next Operation No. | Next Operation No. | Normal | Code | 30 | Next Operation No_ | nvarchar(60) |
6 | Previous Operation No. | Previous Operation No. | Normal | Code | 30 | Previous Operation No_ | nvarchar(60) |
7 | Type | Type | Normal | Option | 4 | Type | int |
Available options are:
| |||||||
8 | No. | No. | Normal | Code | 20 | No_ | nvarchar(40) |
9 | Work Center No. | Work Center No. | Normal | Code | 20 | Work Center No_ | nvarchar(40) |
Key to join to the Work Center table.Show/hide example query | |||||||
10 | Work Center Group Code | Work Center Group Code | Normal | Code | 10 | Work Center Group Code | nvarchar(20) |
Key to join to the Work Center Group table.Show/hide example query | |||||||
11 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
12 | Setup Time | Setup Time | Normal | Decimal | 12 | Setup Time | decimal(38,38) |
13 | Run Time | Run Time | Normal | Decimal | 12 | Run Time | decimal(38,38) |
14 | Wait Time | Wait Time | Normal | Decimal | 12 | Wait Time | decimal(38,38) |
15 | Move Time | Move Time | Normal | Decimal | 12 | Move Time | decimal(38,38) |
16 | Fixed Scrap Quantity | Fixed Scrap Quantity | Normal | Decimal | 12 | Fixed Scrap Quantity | decimal(38,38) |
17 | Lot Size | Lot Size | Normal | Decimal | 12 | Lot Size | decimal(38,38) |
18 | Scrap Factor % | Scrap Factor % | Normal | Decimal | 12 | Scrap Factor _ | decimal(38,38) |
19 | Setup Time Unit of Meas. Code | Setup Time Unit of Meas. Code | Normal | Code | 10 | Setup Time Unit of Meas_ Code | nvarchar(20) |
Key to join to the Capacity Unit of Measure table.Show/hide example query | |||||||
20 | Run Time Unit of Meas. Code | Run Time Unit of Meas. Code | Normal | Code | 10 | Run Time Unit of Meas_ Code | nvarchar(20) |
Key to join to the Capacity Unit of Measure table.Show/hide example query | |||||||
21 | Wait Time Unit of Meas. Code | Wait Time Unit of Meas. Code | Normal | Code | 10 | Wait Time Unit of Meas_ Code | nvarchar(20) |
Key to join to the Capacity Unit of Measure table.Show/hide example query | |||||||
22 | Move Time Unit of Meas. Code | Move Time Unit of Meas. Code | Normal | Code | 10 | Move Time Unit of Meas_ Code | nvarchar(20) |
Key to join to the Capacity Unit of Measure table.Show/hide example query | |||||||
27 | Minimum Process Time | Minimum Process Time | Normal | Decimal | 12 | Minimum Process Time | decimal(38,38) |
28 | Maximum Process Time | Maximum Process Time | Normal | Decimal | 12 | Maximum Process Time | decimal(38,38) |
30 | Concurrent Capacities | Concurrent Capacities | Normal | Decimal | 12 | Concurrent Capacities | decimal(38,38) |
31 | Send-Ahead Quantity | Send-Ahead Quantity | Normal | Decimal | 12 | Send-Ahead Quantity | decimal(38,38) |
34 | Routing Link Code | Routing Link Code | Normal | Code | 10 | Routing Link Code | nvarchar(20) |
Key to join to the Routing Link table.Show/hide example query | |||||||
35 | Standard Task Code | Standard Task Code | Normal | Code | 10 | Standard Task Code | nvarchar(20) |
Key to join to the Standard Task table.Show/hide example query | |||||||
40 | Unit Cost per | Unit Cost per | Normal | Decimal | 12 | Unit Cost per | decimal(38,38) |
41 | Recalculate | Recalculate | Normal | Boolean | 4 | Recalculate | tinyint |
45 | Comment | Comment | FlowField | Boolean | 4 | ||
50 | Sequence No. (Forward) | Sequence No. (Forward) | Normal | Integer | 4 | Sequence No_ (Forward) | int |
51 | Sequence No. (Backward) | Sequence No. (Backward) | Normal | Integer | 4 | Sequence No_ (Backward) | int |
52 | Fixed Scrap Qty. (Accum.) | Fixed Scrap Qty. (Accum.) | Normal | Decimal | 12 | Fixed Scrap Qty_ (Accum_) | decimal(38,38) |
53 | Scrap Factor % (Accumulated) | Scrap Factor % (Accumulated) | Normal | Decimal | 12 | Scrap Factor _ (Accumulated) | decimal(38,38) |
2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example query | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |