Resource Group

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

Table Type: Company

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

Table Number: 152

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [No_]
   ,[Name]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Resource Group$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [] AS [Resource Group]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Resource Group].[Unit of Measure Filter] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Resource Group].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Resource Group].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Resource Group].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Resource Group].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Resource Group table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Name SearchNameNormalText50Namenvarchar(100)
22Date Filter SearchDate FilterFlowFilterDate4
23Capacity SearchCapacityFlowFieldDecimal12
24Qty. on Order (Job) SearchQty. on Order (Job)FlowFieldDecimal12
25Qty. Quoted (Job) SearchQty. Quoted (Job)FlowFieldDecimal12
26Unit of Measure Filter SearchUnit of Measure FilterFlowFilterCode10
27Usage (Qty.) SearchUsage (Qty.)FlowFieldDecimal12
28Usage (Cost) SearchUsage (Cost)FlowFieldDecimal12
29Usage (Price) SearchUsage (Price)FlowFieldDecimal12
30Sales (Qty.) SearchSales (Qty.)FlowFieldDecimal12
31Sales (Cost) SearchSales (Cost)FlowFieldDecimal12
32Sales (Price) SearchSales (Price)FlowFieldDecimal12
33Chargeable Filter SearchChargeable FilterFlowFilterBoolean4
34Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

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

Show/hide example query

SELECT
       [Resource Group].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Resource Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource Group]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Resource Group].[Global Dimension 2 Code] = [Dimension].[Code]
36No. of Resources Assigned SearchNo. of Resources AssignedFlowFieldInteger4
5900Qty. on Service Order SearchQty. on Service OrderFlowFieldDecimal12
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
       [Resource Group].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Resource Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource Group]
LEFT JOIN
       [User] AS [User]
              ON
                     [Resource 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
       [Resource Group].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Resource Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource Group]
LEFT JOIN
       [User] AS [User]
              ON
                     [Resource Group].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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