Routing Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables RRouting Line

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

Table Number: 0

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

SELECT

   *

FROM

   [CRONUS UK Ltd_$Routing Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Routing No_]
   ,[Version Code]
   ,[Operation No_]
   ,[Next Operation No_]
   ,[Previous Operation No_]
   ,[Type]
   ,[No_]
   ,[Work Center No_]
   ,[Work Center Group Code]
   ,[Description]
   ,[Setup Time]
   ,[Run Time]
   ,[Wait Time]
   ,[Move Time]
   ,[Fixed Scrap Quantity]
   ,[Lot Size]
   ,[Scrap Factor _]
   ,[Setup Time Unit of Meas_ Code]
   ,[Run Time Unit of Meas_ Code]
   ,[Wait Time Unit of Meas_ Code]
   ,[Move Time Unit of Meas_ Code]
   ,[Minimum Process Time]
   ,[Maximum Process Time]
   ,[Concurrent Capacities]
   ,[Send-Ahead Quantity]
   ,[Routing Link Code]
   ,[Standard Task Code]
   ,[Unit Cost per]
   ,[Recalculate]
   ,[Sequence No_ (Forward)]
   ,[Sequence No_ (Backward)]
   ,[Fixed Scrap Qty_ (Accum_)]
   ,[Scrap Factor _ (Accumulated)]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Routing Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Routing Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Line]
LEFT JOIN
   [CRONUS UK Ltd_$Routing Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Link]
      ON
         [Routing Line].[Routing Link Code] = [Routing Link].[Code]

Show/hide columns in Routing Line table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Routing No_	nvarchar(40)
3	Version Code	nvarchar(40)
4	Operation No_	nvarchar(20)
5	Next Operation No_	nvarchar(60)
6	Previous Operation No_	nvarchar(60)
7	Type	int
8	No_	nvarchar(40)
9	Work Center No_	nvarchar(40)
10	Work Center Group Code	nvarchar(20)
11	Description	nvarchar(200)
12	Setup Time	decimal(38,38)
13	Run Time	decimal(38,38)
14	Wait Time	decimal(38,38)
15	Move Time	decimal(38,38)
16	Fixed Scrap Quantity	decimal(38,38)
17	Lot Size	decimal(38,38)
18	Scrap Factor _	decimal(38,38)
19	Setup Time Unit of Meas_ Code	nvarchar(20)
20	Run Time Unit of Meas_ Code	nvarchar(20)
21	Wait Time Unit of Meas_ Code	nvarchar(20)
22	Move Time Unit of Meas_ Code	nvarchar(20)
23	Minimum Process Time	decimal(38,38)
24	Maximum Process Time	decimal(38,38)
25	Concurrent Capacities	decimal(38,38)
26	Send-Ahead Quantity	decimal(38,38)
27	Routing Link Code	nvarchar(20)
	Key to join to the Routing Link table. Show/hide example query SELECT [Routing Line].[Routing Link Code] ,[Routing Link].[Code] FROM [CRONUS UK Ltd_$Routing Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Line] LEFT JOIN [CRONUS UK Ltd_$Routing Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Link] ON [Routing Line].[Routing Link Code] = [Routing Link].[Code]
28	Standard Task Code	nvarchar(20)
29	Unit Cost per	decimal(38,38)
30	Recalculate	tinyint
31	Sequence No_ (Forward)	int
32	Sequence No_ (Backward)	int
33	Fixed Scrap Qty_ (Accum_)	decimal(38,38)
34	Scrap Factor _ (Accumulated)	decimal(38,38)
35	$systemId	uniqueidentifier
36	$systemCreatedAt	datetime
37	$systemCreatedBy	uniqueidentifier
38	$systemModifiedAt	datetime
39	$systemModifiedBy	uniqueidentifier