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
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 ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | No_  | nvarchar(40) | ||||
| 3 | Name | nvarchar(200) | ||||
| 4 | Search Name | nvarchar(200) | ||||
| 5 | Name 2 | nvarchar(100) | ||||
| 6 | Address | nvarchar(200) | ||||
| 7 | Address 2 | nvarchar(100) | ||||
| 8 | City | nvarchar(60) | ||||
| 9 | Post Code | nvarchar(40) | ||||
| 10 | Alternate Work Center | nvarchar(40) | ||||
| 11 | Work Center Group Code | nvarchar(20) | ||||
| 12 | Global Dimension 1 Code | nvarchar(40) | ||||
| 13 | Global Dimension 2 Code | nvarchar(40) | ||||
| 14 | Subcontractor No_ | nvarchar(40) | ||||
| 15 | Direct Unit Cost | decimal(38,38) | ||||
| 16 | Indirect Cost _ | decimal(38,38) | ||||
| 17 | Unit Cost | decimal(38,38) | ||||
| 18 | Queue Time | decimal(38,38) | ||||
| 19 | Queue Time Unit of Meas_ Code | nvarchar(20) | ||||
| 20 | Last Date Modified | datetime | ||||
| 21 | Unit of Measure Code | nvarchar(20) | ||||
Key to join to the Unit of Measure table.Show/hide example querySELECT
[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] | ||||||
| 22 | Capacity | decimal(38,38) | ||||
| 23 | Efficiency | decimal(38,38) | ||||
| 24 | Maximum Efficiency | decimal(38,38) | ||||
| 25 | Minimum Efficiency | decimal(38,38) | ||||
| 26 | Calendar Rounding Precision | decimal(38,38) | ||||
| 27 | Simulation Type | int | ||||
| 28 | Shop Calendar Code | nvarchar(20) | ||||
| 29 | Blocked | tinyint | ||||
| 30 | Unit Cost Calculation | int | ||||
| 31 | Specific Unit Cost | tinyint | ||||
| 32 | Consolidated Calendar | tinyint | ||||
| 33 | Flushing Method | int | ||||
| 34 | No_ Series | nvarchar(40) | ||||
| 35 | Overhead Rate | decimal(38,38) | ||||
| 36 | Gen_ Prod_ Posting Group | nvarchar(40) | ||||
| 37 | County | nvarchar(60) | ||||
| 38 | Country_Region Code | nvarchar(20) | ||||
Key to join to the Country_Region table.Show/hide example querySELECT
[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] | ||||||
| 39 | Location Code | nvarchar(20) | ||||
Key to join to the Location table.Show/hide example querySELECT
[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] | ||||||
| 40 | Open Shop Floor Bin Code | nvarchar(40) | ||||
| 41 | To-Production Bin Code | nvarchar(40) | ||||
| 42 | From-Production Bin Code | nvarchar(40) | ||||
| 43 | $systemId | uniqueidentifier | ||||
| 44 | $systemCreatedAt | datetime | ||||
| 45 | $systemCreatedBy | uniqueidentifier | ||||
| 46 | $systemModifiedAt | datetime | ||||
| 47 | $systemModifiedBy | uniqueidentifier | ||||