Routing 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Routing No_ Primary Key Searchnvarchar(40)
3Version Code Primary Key Searchnvarchar(40)
4Operation No_ Primary Key Searchnvarchar(20)
5Next Operation No_ Searchnvarchar(60)
6Previous Operation No_ Searchnvarchar(60)
7Type Searchint
8No_ Searchnvarchar(40)
9Work Center No_ Searchnvarchar(40)
10Work Center Group Code Searchnvarchar(20)
11Description Searchnvarchar(200)
12Setup Time Searchdecimal(38,38)
13Run Time Searchdecimal(38,38)
14Wait Time Searchdecimal(38,38)
15Move Time Searchdecimal(38,38)
16Fixed Scrap Quantity Searchdecimal(38,38)
17Lot Size Searchdecimal(38,38)
18Scrap Factor _ Searchdecimal(38,38)
19Setup Time Unit of Meas_ Code Searchnvarchar(20)
20Run Time Unit of Meas_ Code Searchnvarchar(20)
21Wait Time Unit of Meas_ Code Searchnvarchar(20)
22Move Time Unit of Meas_ Code Searchnvarchar(20)
23Minimum Process Time Searchdecimal(38,38)
24Maximum Process Time Searchdecimal(38,38)
25Concurrent Capacities Searchdecimal(38,38)
26Send-Ahead Quantity Searchdecimal(38,38)
27Routing Link Code Searchnvarchar(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]
28Standard Task Code Searchnvarchar(20)
29Unit Cost per Searchdecimal(38,38)
30Recalculate Searchtinyint
31Sequence No_ (Forward) Searchint
32Sequence No_ (Backward) Searchint
33Fixed Scrap Qty_ (Accum_) Searchdecimal(38,38)
34Scrap Factor _ (Accumulated) Searchdecimal(38,38)
35$systemId Searchuniqueidentifier
36$systemCreatedAt Searchdatetime
37$systemCreatedBy Searchuniqueidentifier
38$systemModifiedAt Searchdatetime
39$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Routing Line table

Leave a Reply

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