Prod_ Order Routing Line

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5409

Table Type: Company

Table Name: Prod_ Order Routing Line
Database Table Name: CRONUS UK Ltd_$Prod_ Order Routing Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5409

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 Prod_ Order Routing Line can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Prod_ Order Routing Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Status]
   ,[Prod_ Order No_]
   ,[Routing Reference No_]
   ,[Routing No_]
   ,[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)]
   ,[Sequence No_ (Actual)]
   ,[Direct Unit Cost]
   ,[Indirect Cost _]
   ,[Overhead Rate]
   ,[Starting Time]
   ,[Starting Date]
   ,[Ending Time]
   ,[Ending Date]
   ,[Unit Cost Calculation]
   ,[Input Quantity]
   ,[Critical Path]
   ,[Routing Status]
   ,[Flushing Method]
   ,[Expected Operation Cost Amt_]
   ,[Expected Capacity Need]
   ,[Expected Capacity Ovhd_ Cost]
   ,[Starting Date-Time]
   ,[Ending Date-Time]
   ,[Schedule Manually]
   ,[Location Code]
   ,[Open Shop Floor Bin Code]
   ,[To-Production Bin Code]
   ,[From-Production Bin Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Prod_ Order 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_$Prod_ Order Routing Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod_ Order Routing Line]
LEFT JOIN
   [CRONUS UK Ltd_$Routing Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Link]
      ON
         [Prod_ Order Routing Line].[Routing Link Code] = [Routing Link].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Prod_ Order Routing Line].[Location Code] = [Location].[Code]

Show/hide columns in Prod_ Order Routing Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Status Primary Key Searchint
3Prod_ Order No_ Primary Key Searchnvarchar(40)
4Routing Reference No_ Primary Key Searchint
5Routing No_ Primary Key Searchnvarchar(40)
6Operation No_ Primary Key Searchnvarchar(20)
7Next Operation No_ Searchnvarchar(60)
8Previous Operation No_ Searchnvarchar(60)
9Type Searchint
10No_ Searchnvarchar(40)
11Work Center No_ Searchnvarchar(40)
12Work Center Group Code Searchnvarchar(20)
13Description Searchnvarchar(200)
14Setup Time Searchdecimal(38,38)
15Run Time Searchdecimal(38,38)
16Wait Time Searchdecimal(38,38)
17Move Time Searchdecimal(38,38)
18Fixed Scrap Quantity Searchdecimal(38,38)
19Lot Size Searchdecimal(38,38)
20Scrap Factor _ Searchdecimal(38,38)
21Setup Time Unit of Meas_ Code Searchnvarchar(20)
22Run Time Unit of Meas_ Code Searchnvarchar(20)
23Wait Time Unit of Meas_ Code Searchnvarchar(20)
24Move Time Unit of Meas_ Code Searchnvarchar(20)
25Minimum Process Time Searchdecimal(38,38)
26Maximum Process Time Searchdecimal(38,38)
27Concurrent Capacities Searchdecimal(38,38)
28Send-Ahead Quantity Searchdecimal(38,38)
29Routing Link Code Searchnvarchar(20)
Key to join to the Routing Link table.

Show/hide example query

SELECT
       [Prod_ Order Routing Line].[Routing Link Code]
       ,[Routing Link].[Code]
FROM
       [CRONUS UK Ltd_$Prod_ Order Routing Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod_ Order Routing Line]
LEFT JOIN
       [CRONUS UK Ltd_$Routing Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Link]
              ON
                     [Prod_ Order Routing Line].[Routing Link Code] = [Routing Link].[Code]
30Standard Task Code Searchnvarchar(20)
31Unit Cost per Searchdecimal(38,38)
32Recalculate Searchtinyint
33Sequence No_ (Forward) Searchint
34Sequence No_ (Backward) Searchint
35Fixed Scrap Qty_ (Accum_) Searchdecimal(38,38)
36Scrap Factor _ (Accumulated) Searchdecimal(38,38)
37Sequence No_ (Actual) Searchint
38Direct Unit Cost Searchdecimal(38,38)
39Indirect Cost _ Searchdecimal(38,38)
40Overhead Rate Searchdecimal(38,38)
41Starting Time Searchdatetime
42Starting Date Searchdatetime
43Ending Time Searchdatetime
44Ending Date Searchdatetime
45Unit Cost Calculation Searchint
46Input Quantity Searchdecimal(38,38)
47Critical Path Searchtinyint
48Routing Status Searchint
49Flushing Method Searchint
50Expected Operation Cost Amt_ Searchdecimal(38,38)
51Expected Capacity Need Searchdecimal(38,38)
52Expected Capacity Ovhd_ Cost Searchdecimal(38,38)
53Starting Date-Time Searchdatetime
54Ending Date-Time Searchdatetime
55Schedule Manually Searchtinyint
56Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Prod_ Order Routing Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Prod_ Order Routing Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod_ Order Routing Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Prod_ Order Routing Line].[Location Code] = [Location].[Code]
57Open Shop Floor Bin Code Searchnvarchar(40)
58To-Production Bin Code Searchnvarchar(40)
59From-Production Bin Code Searchnvarchar(40)
60$systemId Searchuniqueidentifier
61$systemCreatedAt Searchdatetime
62$systemCreatedBy Searchuniqueidentifier
63$systemModifiedAt Searchdatetime
64$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Prod_ Order Routing Line table

Leave a Reply

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