Machine Center

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

Table Type: Company

Table Name: Machine Center
Database Table Name: CRONUS UK Ltd_$Machine Center$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 Machine Center can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Machine Center$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Name]
   ,[Search Name]
   ,[Name 2]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Post Code]
   ,[Work Center No_]
   ,[Direct Unit Cost]
   ,[Indirect Cost _]
   ,[Unit Cost]
   ,[Queue Time]
   ,[Queue Time Unit of Meas_ Code]
   ,[Last Date Modified]
   ,[Capacity]
   ,[Efficiency]
   ,[Maximum Efficiency]
   ,[Minimum Efficiency]
   ,[Blocked]
   ,[Setup Time]
   ,[Wait Time]
   ,[Move Time]
   ,[Fixed Scrap Quantity]
   ,[Scrap _]
   ,[Setup Time Unit of Meas_ Code]
   ,[Wait Time Unit of Meas_ Code]
   ,[Send-Ahead Quantity]
   ,[Move Time Unit of Meas_ Code]
   ,[Flushing Method]
   ,[Minimum Process Time]
   ,[Maximum Process Time]
   ,[Concurrent Capacities]
   ,[No_ Series]
   ,[Overhead Rate]
   ,[Gen_ Prod_ Posting Group]
   ,[County]
   ,[Country_Region Code]
   ,[Location Code]
   ,[Open Shop Floor Bin Code]
   ,[To-Production Bin Code]
   ,[From-Production Bin Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Machine Center$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Machine Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Machine Center]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Machine Center].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Machine Center].[Location Code] = [Location].[Code]

Show/hide columns in Machine Center table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Name Searchnvarchar(100)
4Search Name Searchnvarchar(100)
5Name 2 Searchnvarchar(100)
6Address Searchnvarchar(200)
7Address 2 Searchnvarchar(100)
8City Searchnvarchar(60)
9Post Code Searchnvarchar(40)
10Work Center No_ Searchnvarchar(40)
11Direct Unit Cost Searchdecimal(38,38)
12Indirect Cost _ Searchdecimal(38,38)
13Unit Cost Searchdecimal(38,38)
14Queue Time Searchdecimal(38,38)
15Queue Time Unit of Meas_ Code Searchnvarchar(20)
16Last Date Modified Searchdatetime
17Capacity Searchdecimal(38,38)
18Efficiency Searchdecimal(38,38)
19Maximum Efficiency Searchdecimal(38,38)
20Minimum Efficiency Searchdecimal(38,38)
21Blocked Searchtinyint
22Setup Time Searchdecimal(38,38)
23Wait Time Searchdecimal(38,38)
24Move Time Searchdecimal(38,38)
25Fixed Scrap Quantity Searchdecimal(38,38)
26Scrap _ Searchdecimal(38,38)
27Setup Time Unit of Meas_ Code Searchnvarchar(20)
28Wait Time Unit of Meas_ Code Searchnvarchar(20)
29Send-Ahead Quantity Searchdecimal(38,38)
30Move Time Unit of Meas_ Code Searchnvarchar(20)
31Flushing Method Searchint
32Minimum Process Time Searchdecimal(38,38)
33Maximum Process Time Searchdecimal(38,38)
34Concurrent Capacities Searchdecimal(38,38)
35No_ Series Searchnvarchar(40)
36Overhead Rate Searchdecimal(38,38)
37Gen_ Prod_ Posting Group Searchnvarchar(40)
38County Searchnvarchar(60)
39Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Machine Center].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Machine Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Machine Center]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Machine Center].[Country_Region Code] = [Country_Region].[Code]
40Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Machine Center].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Machine Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Machine Center]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Machine Center].[Location Code] = [Location].[Code]
41Open Shop Floor Bin Code Searchnvarchar(40)
42To-Production Bin Code Searchnvarchar(40)
43From-Production Bin Code Searchnvarchar(40)
44$systemId Searchuniqueidentifier
45$systemCreatedAt Searchdatetime
46$systemCreatedBy Searchuniqueidentifier
47$systemModifiedAt Searchdatetime
48$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Machine Center table

Leave a Reply

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