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

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
   [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_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Work Center].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Work Center].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
      ON
         [Work Center].[Alternate Work Center] = [Work Center].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Work Center Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center Group]
      ON
         [Work Center].[Work Center Group Code] = [Work Center Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Work Center].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Work Center].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shop Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shop Calendar]
      ON
         [Work Center].[Shop Calendar Code] = [Shop Calendar].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Work Shift$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Shift]
      ON
         [Work Center].[Work Shift Filter] = [Work Shift].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Work Center].[Location Code] = [Location].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Work Center].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Work Center].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Work 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
       [Work Center].[City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Work Center].[City] = [Post Code].[City]
9Post Code SearchZIP CodeNormalCode20Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Work Center].[Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Work Center].[Post Code] = [Post Code].[Code]
12Alternate Work Center SearchAlternate Work CenterNormalCode20Alternate Work Centernvarchar(40)
14Work Center Group Code SearchWork Center Group CodeNormalCode10Work Center Group Codenvarchar(20)
Key to join to the Work Center Group table.

Show/hide example query

SELECT
       [Work Center].[Work Center Group Code]
       ,[Work Center Group].[Code]
FROM
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
LEFT JOIN
       [CRONUS UK Ltd_$Work Center Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center Group]
              ON
                     [Work Center].[Work Center Group Code] = [Work Center Group].[Code]
16Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Work Center].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Work Center].[Global Dimension 1 Code] = [Dimension].[Code]
17Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Work Center].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Work Center].[Global Dimension 2 Code] = [Dimension].[Code]
18Subcontractor No. SearchSubcontractor No.NormalCode20Subcontractor No_nvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Work Center].[Subcontractor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Work Center].[Subcontractor No_] = [Vendor].[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
       [Work Center].[Queue Time Unit of Meas_ Code]
       ,[Capacity Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
LEFT JOIN
       [CRONUS UK Ltd_$Capacity Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Capacity Unit of Measure]
              ON
                     [Work Center].[Queue Time Unit of Meas_ Code] = [Capacity Unit of Measure].[Code]
26Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
27Comment SearchCommentFlowFieldBoolean4
30Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
31Capacity SearchCapacityNormalDecimal12Capacitydecimal(38,38)
32Efficiency SearchEfficiencyNormalDecimal12Efficiencydecimal(38,38)
33Maximum Efficiency SearchMaximum EfficiencyNormalDecimal12Maximum Efficiencydecimal(38,38)
34Minimum Efficiency SearchMinimum EfficiencyNormalDecimal12Minimum Efficiencydecimal(38,38)
35Calendar Rounding Precision SearchCalendar Rounding PrecisionNormalDecimal12Calendar Rounding Precisiondecimal(38,38)
36Simulation Type SearchSimulation TypeNormalOption4Simulation Typeint
Available options are:
  • “Moves”
  • “Moves When Necessary”
  • “Critical”
37Shop Calendar Code SearchShop Calendar CodeNormalCode10Shop Calendar Codenvarchar(20)
Key to join to the Shop Calendar table.

Show/hide example query

SELECT
       [Work Center].[Shop Calendar Code]
       ,[Shop Calendar].[Code]
FROM
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
LEFT JOIN
       [CRONUS UK Ltd_$Shop Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shop Calendar]
              ON
                     [Work Center].[Shop Calendar Code] = [Shop Calendar].[Code]
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
50Unit Cost Calculation SearchUnit Cost CalculationNormalOption4Unit Cost Calculationint
Available options are:
  • “Time”
  • “Units”
51Specific Unit Cost SearchSpecific Unit CostNormalBoolean4Specific Unit Costtinyint
52Consolidated Calendar SearchConsolidated CalendarNormalBoolean4Consolidated Calendartinyint
53Flushing Method SearchFlushing MethodNormalOption4Flushing Methodint
Available options are:
  • “Manual”
  • “Forward”
  • “Backward”
80No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Work Center].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Work 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
       [Work Center].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Work 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
       [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]
7300Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
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
       [Work Center].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
LEFT JOIN
       [User] AS [User]
              ON
                     [Work 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
       [Work Center].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
LEFT JOIN
       [User] AS [User]
              ON
                     [Work Center].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Work Center table

Leave a Reply

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