Work Center Group

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

Table Type: Company

Table Name: Work Center Group
Database Table Name: CRONUS UK Ltd_$Work Center Group$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 99000756

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 Group can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Work Center Group$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Code]
   ,[Name]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Work Center Group$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [Work Center Group]
LEFT JOIN
   [CRONUS UK Ltd_$Work Shift$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Shift]
      ON
         [Work Center Group].[Work Shift Filter] = [Work Shift].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Work Center Group].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Work Center Group].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Work Center Group table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode10Codenvarchar(20)
2Name SearchNameNormalText50Namenvarchar(100)
20Date Filter SearchDate FilterFlowFilterDate4
21Work Shift Filter SearchWork Shift FilterFlowFilterCode10
22Capacity (Total) SearchCapacity (Total)FlowFieldDecimal12
23Capacity (Effective) SearchCapacity (Effective)FlowFieldDecimal12
24Prod. Order Need (Qty.) SearchProd. Order Need (Qty.)FlowFieldDecimal12
47Prod. Order Status Filter SearchProd. Order Status FilterFlowFilterOption4
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 Group].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Work Center Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center Group]
LEFT JOIN
       [User] AS [User]
              ON
                     [Work Center Group].[$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 Group].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Work Center Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center Group]
LEFT JOIN
       [User] AS [User]
              ON
                     [Work Center Group].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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