Work Center

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

Table Type: Company

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Work 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]
   ,[Alternate Work Center]
   ,[Work Center Group Code]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Subcontractor No_]
   ,[Direct Unit Cost]
   ,[Indirect Cost _]
   ,[Unit Cost]
   ,[Queue Time]
   ,[Queue Time Unit of Meas_ Code]
   ,[Last Date Modified]
   ,[Unit of Measure Code]
   ,[Capacity]
   ,[Efficiency]
   ,[Maximum Efficiency]
   ,[Minimum Efficiency]
   ,[Calendar Rounding Precision]
   ,[Simulation Type]
   ,[Shop Calendar Code]
   ,[Blocked]
   ,[Unit Cost Calculation]
   ,[Specific Unit Cost]
   ,[Consolidated Calendar]
   ,[Flushing Method]
   ,[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_$Work 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_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Work Center].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Work Center].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Work Center].[Location Code] = [Location].[Code]

Show/hide columns in Work Center table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Name Searchnvarchar(200)
4Search Name Searchnvarchar(200)
5Name 2 Searchnvarchar(100)
6Address Searchnvarchar(200)
7Address 2 Searchnvarchar(100)
8City Searchnvarchar(60)
9Post Code Searchnvarchar(40)
10Alternate Work Center Searchnvarchar(40)
11Work Center Group Code Searchnvarchar(20)
12Global Dimension 1 Code Searchnvarchar(40)
13Global Dimension 2 Code Searchnvarchar(40)
14Subcontractor No_ Searchnvarchar(40)
15Direct Unit Cost Searchdecimal(38,38)
16Indirect Cost _ Searchdecimal(38,38)
17Unit Cost Searchdecimal(38,38)
18Queue Time Searchdecimal(38,38)
19Queue Time Unit of Meas_ Code Searchnvarchar(20)
20Last Date Modified Searchdatetime
21Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Work Center].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Work Center].[Unit of Measure Code] = [Unit of Measure].[Code]
22Capacity Searchdecimal(38,38)
23Efficiency Searchdecimal(38,38)
24Maximum Efficiency Searchdecimal(38,38)
25Minimum Efficiency Searchdecimal(38,38)
26Calendar Rounding Precision Searchdecimal(38,38)
27Simulation Type Searchint
28Shop Calendar Code Searchnvarchar(20)
29Blocked Searchtinyint
30Unit Cost Calculation Searchint
31Specific Unit Cost Searchtinyint
32Consolidated Calendar Searchtinyint
33Flushing Method Searchint
34No_ Series Searchnvarchar(40)
35Overhead Rate Searchdecimal(38,38)
36Gen_ Prod_ Posting Group Searchnvarchar(40)
37County Searchnvarchar(60)
38Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

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

Show/hide example query

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

Show/hide tables related from Work Center table

Leave a Reply

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