Work Center – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables WWork 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	No.	No.	Normal	Code	20	No_	nvarchar(40)
3	Name	Name	Normal	Text	100	Name	nvarchar(200)
4	Search Name	Search Name	Normal	Code	100	Search Name	nvarchar(200)
5	Name 2	Name 2	Normal	Text	50	Name 2	nvarchar(100)
6	Address	Address	Normal	Text	100	Address	nvarchar(200)
7	Address 2	Address 2	Normal	Text	50	Address 2	nvarchar(100)
8	City	City	Normal	Text	30	City	nvarchar(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]
9	Post Code	ZIP Code	Normal	Code	20	Post Code	nvarchar(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]
12	Alternate Work Center	Alternate Work Center	Normal	Code	20	Alternate Work Center	nvarchar(40)
14	Work Center Group Code	Work Center Group Code	Normal	Code	10	Work Center Group Code	nvarchar(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]
16	Global Dimension 1 Code	Global Dimension 1 Code	Normal	Code	20	Global Dimension 1 Code	nvarchar(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]
17	Global Dimension 2 Code	Global Dimension 2 Code	Normal	Code	20	Global Dimension 2 Code	nvarchar(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]
18	Subcontractor No.	Subcontractor No.	Normal	Code	20	Subcontractor 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_]
19	Direct Unit Cost	Direct Unit Cost	Normal	Decimal	12	Direct Unit Cost	decimal(38,38)
20	Indirect Cost %	Indirect Cost %	Normal	Decimal	12	Indirect Cost _	decimal(38,38)
21	Unit Cost	Unit Cost	Normal	Decimal	12	Unit Cost	decimal(38,38)
22	Queue Time	Queue Time	Normal	Decimal	12	Queue Time	decimal(38,38)
23	Queue Time Unit of Meas. Code	Queue Time Unit of Meas. Code	Normal	Code	10	Queue Time Unit of Meas_ Code	nvarchar(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]
26	Last Date Modified	Last Date Modified	Normal	Date	4	Last Date Modified	datetime
27	Comment	Comment	FlowField	Boolean	4
30	Unit of Measure Code	Unit of Measure Code	Normal	Code	10	Unit of Measure Code	nvarchar(20)
31	Capacity	Capacity	Normal	Decimal	12	Capacity	decimal(38,38)
32	Efficiency	Efficiency	Normal	Decimal	12	Efficiency	decimal(38,38)
33	Maximum Efficiency	Maximum Efficiency	Normal	Decimal	12	Maximum Efficiency	decimal(38,38)
34	Minimum Efficiency	Minimum Efficiency	Normal	Decimal	12	Minimum Efficiency	decimal(38,38)
35	Calendar Rounding Precision	Calendar Rounding Precision	Normal	Decimal	12	Calendar Rounding Precision	decimal(38,38)
36	Simulation Type	Simulation Type	Normal	Option	4	Simulation Type	int
	Available options are: “Moves” “Moves When Necessary” “Critical”
37	Shop Calendar Code	Shop Calendar Code	Normal	Code	10	Shop Calendar Code	nvarchar(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]
38	Blocked	Blocked	Normal	Boolean	4	Blocked	tinyint
39	Date Filter	Date Filter	FlowFilter	Date	4
40	Work Shift Filter	Work Shift Filter	FlowFilter	Code	10
	Key to join to the Work Shift table. Show/hide example query SELECT [Work Center].[] ,[Work Shift].[Code] FROM [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center] LEFT JOIN [CRONUS UK Ltd_$Work Shift$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Shift] ON [Work Center].[] = [Work Shift].[Code]
41	Capacity (Total)	Capacity (Total)	FlowField	Decimal	12
42	Capacity (Effective)	Capacity (Effective)	FlowField	Decimal	12
44	Prod. Order Need (Qty.)	Prod. Order Need (Qty.)	FlowField	Decimal	12
45	Prod. Order Need Amount	Prod. Order Need Amount	FlowField	Decimal	12
47	Prod. Order Status Filter	Prod. Order Status Filter	FlowFilter	Option	4
50	Unit Cost Calculation	Unit Cost Calculation	Normal	Option	4	Unit Cost Calculation	int
	Available options are: “Time” “Units”
51	Specific Unit Cost	Specific Unit Cost	Normal	Boolean	4	Specific Unit Cost	tinyint
52	Consolidated Calendar	Consolidated Calendar	Normal	Boolean	4	Consolidated Calendar	tinyint
53	Flushing Method	Flushing Method	Normal	Option	4	Flushing Method	int
	Available options are: “Manual” “Forward” “Backward”
80	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(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]
81	Overhead Rate	Overhead Rate	Normal	Decimal	12	Overhead Rate	decimal(38,38)
82	Gen. Prod. Posting Group	Gen. Prod. Posting Group	Normal	Code	20	Gen_ Prod_ Posting Group	nvarchar(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]
83	County	State	Normal	Text	30	County	nvarchar(60)
84	Country/Region Code	Country/Region Code	Normal	Code	10	Country_Region Code	nvarchar(20)
7300	Location Code	Location Code	Normal	Code	10	Location Code	nvarchar(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]
7301	Open Shop Floor Bin Code	Open Shop Floor Bin Code	Normal	Code	20	Open Shop Floor Bin Code	nvarchar(40)
7302	To-Production Bin Code	To-Production Bin Code	Normal	Code	20	To-Production Bin Code	nvarchar(40)
7303	From-Production Bin Code	From-Production Bin Code	Normal	Code	20	From-Production Bin Code	nvarchar(40)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Work Center table

Dynamics 365 BC Table Reference Tables Company Tables WWork Center

Leave a Reply Cancel reply