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: 99000758

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
   [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_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Machine Center].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Machine Center].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Work Shift$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Shift]
      ON
         [Machine Center].[Work Shift Filter] = [Work Shift].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
      ON
         [Machine Center].[Item Filter] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Stop$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stop]
      ON
         [Machine Center].[Stop Code Filter] = [Stop].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Scrap$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Scrap]
      ON
         [Machine Center].[Scrap Code Filter] = [Scrap].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Machine Center].[Location Code] = [Location].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Machine Center].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Machine Center].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Machine Center table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
3Name SearchNameNormalText100Namenvarchar(200)
4Search Name SearchSearch NameNormalCode100Search Namenvarchar(200)
5Name 2 SearchName 2NormalText50Name 2nvarchar(100)
6Address SearchAddressNormalText100Addressnvarchar(200)
7Address 2 SearchAddress 2NormalText50Address 2nvarchar(100)
8City SearchCityNormalText30Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Machine Center].[City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Machine Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Machine Center]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Machine Center].[City] = [Post Code].[City]
9Post Code SearchZIP CodeNormalCode20Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Machine Center].[Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Machine Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Machine Center]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Machine Center].[Post Code] = [Post Code].[Code]
14Work Center No. SearchWork Center No.NormalCode20Work Center No_nvarchar(40)
Key to join to the Work Center table.

Show/hide example query

SELECT
       [Machine Center].[Work Center No_]
       ,[Work Center].[No_]
FROM
       [CRONUS UK Ltd_$Machine Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Machine Center]
LEFT JOIN
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
              ON
                     [Machine Center].[Work Center No_] = [Work Center].[No_]
19Direct Unit Cost SearchDirect Unit CostNormalDecimal12Direct Unit Costdecimal(38,38)
20Indirect Cost % SearchIndirect Cost %NormalDecimal12Indirect Cost _decimal(38,38)
21Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
22Queue Time SearchQueue TimeNormalDecimal12Queue Timedecimal(38,38)
23Queue Time Unit of Meas. Code SearchQueue Time Unit of Meas. CodeNormalCode10Queue Time Unit of Meas_ Codenvarchar(20)
Key to join to the Capacity Unit of Measure table.

Show/hide example query

SELECT
       [Machine Center].[Queue Time Unit of Meas_ Code]
       ,[Capacity Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Machine Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Machine Center]
LEFT JOIN
       [CRONUS UK Ltd_$Capacity Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Unit of Measure]
              ON
                     [Machine Center].[Queue Time Unit of Meas_ Code] = [Capacity Unit of Measure].[Code]
26Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
27Comment SearchCommentFlowFieldBoolean4
31Capacity SearchCapacityNormalDecimal12Capacitydecimal(38,38)
32Efficiency SearchEfficiencyNormalDecimal12Efficiencydecimal(38,38)
33Maximum Efficiency SearchMaximum EfficiencyNormalDecimal12Maximum Efficiencydecimal(38,38)
34Minimum Efficiency SearchMinimum EfficiencyNormalDecimal12Minimum Efficiencydecimal(38,38)
38Blocked SearchBlockedNormalBoolean4Blockedtinyint
39Date Filter SearchDate FilterFlowFilterDate4
40Work Shift Filter SearchWork Shift FilterFlowFilterCode10
41Capacity (Total) SearchCapacity (Total)FlowFieldDecimal12
42Capacity (Effective) SearchCapacity (Effective)FlowFieldDecimal12
44Prod. Order Need (Qty.) SearchProd. Order Need (Qty.)FlowFieldDecimal12
45Prod. Order Need Amount SearchProd. Order Need AmountFlowFieldDecimal12
47Prod. Order Status Filter SearchProd. Order Status FilterFlowFilterOption4
50Setup Time SearchSetup TimeNormalDecimal12Setup Timedecimal(38,38)
52Wait Time SearchWait TimeNormalDecimal12Wait Timedecimal(38,38)
53Move Time SearchMove TimeNormalDecimal12Move Timedecimal(38,38)
54Fixed Scrap Quantity SearchFixed Scrap QuantityNormalDecimal12Fixed Scrap Quantitydecimal(38,38)
55Scrap % SearchScrap %NormalDecimal12Scrap _decimal(38,38)
56Setup Time Unit of Meas. Code SearchSetup Time Unit of Meas. CodeNormalCode10Setup Time Unit of Meas_ Codenvarchar(20)
Key to join to the Capacity Unit of Measure table.

Show/hide example query

SELECT
       [Machine Center].[Setup Time Unit of Meas_ Code]
       ,[Capacity Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Machine Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Machine Center]
LEFT JOIN
       [CRONUS UK Ltd_$Capacity Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Unit of Measure]
              ON
                     [Machine Center].[Setup Time Unit of Meas_ Code] = [Capacity Unit of Measure].[Code]
57Wait Time Unit of Meas. Code SearchWait Time Unit of Meas. CodeNormalCode10Wait Time Unit of Meas_ Codenvarchar(20)
Key to join to the Capacity Unit of Measure table.

Show/hide example query

SELECT
       [Machine Center].[Wait Time Unit of Meas_ Code]
       ,[Capacity Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Machine Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Machine Center]
LEFT JOIN
       [CRONUS UK Ltd_$Capacity Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Unit of Measure]
              ON
                     [Machine Center].[Wait Time Unit of Meas_ Code] = [Capacity Unit of Measure].[Code]
58Send-Ahead Quantity SearchSend-Ahead QuantityNormalDecimal12Send-Ahead Quantitydecimal(38,38)
59Move Time Unit of Meas. Code SearchMove Time Unit of Meas. CodeNormalCode10Move Time Unit of Meas_ Codenvarchar(20)
Key to join to the Capacity Unit of Measure table.

Show/hide example query

SELECT
       [Machine Center].[Move Time Unit of Meas_ Code]
       ,[Capacity Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Machine Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Machine Center]
LEFT JOIN
       [CRONUS UK Ltd_$Capacity Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Unit of Measure]
              ON
                     [Machine Center].[Move Time Unit of Meas_ Code] = [Capacity Unit of Measure].[Code]
60Flushing Method SearchFlushing MethodNormalOption4Flushing Methodint
Available options are:
  • “Manual”
  • “Forward”
  • “Backward”
62Minimum Process Time SearchMinimum Process TimeNormalDecimal12Minimum Process Timedecimal(38,38)
63Maximum Process Time SearchMaximum Process TimeNormalDecimal12Maximum Process Timedecimal(38,38)
64Concurrent Capacities SearchConcurrent CapacitiesNormalDecimal12Concurrent Capacitiesdecimal(38,38)
65Item Filter SearchItem FilterFlowFilterCode20
66Stop Code Filter SearchStop Code FilterFlowFilterCode10
67Scrap Code Filter SearchScrap Code FilterFlowFilterCode10
80No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Machine Center].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Machine Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Machine Center]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Machine Center].[No_ Series] = [No. Series].[Code]
81Overhead Rate SearchOverhead RateNormalDecimal12Overhead Ratedecimal(38,38)
82Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Machine Center].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Machine Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Machine Center]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Machine Center].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
83County SearchStateNormalText30Countynvarchar(60)
84Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(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]
7300Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
7301Open Shop Floor Bin Code SearchOpen Shop Floor Bin CodeNormalCode20Open Shop Floor Bin Codenvarchar(40)
7302To-Production Bin Code SearchTo-Production Bin CodeNormalCode20To-Production Bin Codenvarchar(40)
7303From-Production Bin Code SearchFrom-Production Bin CodeNormalCode20From-Production Bin Codenvarchar(40)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Machine Center].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Machine Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Machine Center]
LEFT JOIN
       [User] AS [User]
              ON
                     [Machine Center].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Machine Center].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Machine Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Machine Center]
LEFT JOIN
       [User] AS [User]
              ON
                     [Machine Center].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Machine Center table

Leave a Reply

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