Resource

Dynamics 365 BC Table ReferenceTablesCompany TablesRResource

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

Table Type: Company

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

Table Number: 156

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [No_]
   ,[Type]
   ,[Name]
   ,[Search Name]
   ,[Name 2]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Social Security No_]
   ,[Job Title]
   ,[Education]
   ,[Contract Class]
   ,[Employment Date]
   ,[Resource Group No_]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Base Unit of Measure]
   ,[Direct Unit Cost]
   ,[Indirect Cost _]
   ,[Unit Cost]
   ,[Profit _]
   ,[Price_Profit Calculation]
   ,[Unit Price]
   ,[Vendor No_]
   ,[Last Date Modified]
   ,[Blocked]
   ,[Gen_ Prod_ Posting Group]
   ,[Picture]
   ,[Post Code]
   ,[County]
   ,[Automatic Ext_ Texts]
   ,[No_ Series]
   ,[Tax Group Code]
   ,[VAT Prod_ Posting Group]
   ,[Country_Region Code]
   ,[IC Partner Purch_ G_L Acc_ No_]
   ,[Image]
   ,[Privacy Blocked]
   ,[Coupled to CRM]
   ,[Use Time Sheet]
   ,[Time Sheet Owner User ID]
   ,[Time Sheet Approver User ID]
   ,[Default Deferral Template Code]
   ,[Service Zone Filter]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Resource].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Resource].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Resource].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Resource].[Base Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Resource].[Unit of Measure Filter] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Resource].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Resource].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Resource].[Time Sheet Owner User ID] = [User Setup].[User ID]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Resource].[Time Sheet Approver User ID] = [User Setup].[User ID]
LEFT JOIN
   [CRONUS UK Ltd_$Deferral Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Template]
      ON
         [Resource].[Default Deferral Template Code] = [Deferral Template].[Deferral Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
      ON
         [Resource].[Service Zone Filter] = [Service Zone].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Resource].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Resource].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Resource table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Type SearchTypeNormalOption4Typeint
Available options are:
  • “Person”
  • “Machine”
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
       [Resource].[City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Resource].[City] = [Post Code].[City]
9Social Security No. SearchSocial Security No.NormalText30Social Security No_nvarchar(60)
10Job Title SearchJob TitleNormalText30Job Titlenvarchar(60)
11Education SearchEducationNormalText30Educationnvarchar(60)
12Contract Class SearchContract ClassNormalText30Contract Classnvarchar(60)
13Employment Date SearchEmployment DateNormalDate4Employment Datedatetime
14Resource Group No. SearchResource Group No.NormalCode20Resource Group No_nvarchar(40)
Key to join to the Resource Group table.

Show/hide example query

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

Show/hide example query

SELECT
       [Resource].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Resource].[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
       [Resource].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Resource].[Global Dimension 2 Code] = [Dimension].[Code]
18Base Unit of Measure SearchBase Unit of MeasureNormalCode10Base Unit of Measurenvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Resource].[Base Unit of Measure]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Resource].[Base Unit of Measure] = [Unit of Measure].[Code]
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)
22Profit % SearchProfit %NormalDecimal12Profit _decimal(38,38)
23Price/Profit Calculation SearchPrice/Profit CalculationNormalOption4Price_Profit Calculationint
Available options are:
  • “Profit=Price-Cost”
  • “Price=Cost+Profit”
  • “No Relationship”
24Unit Price SearchUnit PriceNormalDecimal12Unit Pricedecimal(38,38)
25Vendor No. SearchVendor No.NormalCode20Vendor No_nvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Resource].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Resource].[Vendor No_] = [Vendor].[No_]
26Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
27Comment SearchCommentFlowFieldBoolean4
38Blocked SearchBlockedNormalBoolean4Blockedtinyint
39Date Filter SearchDate FilterFlowFilterDate4
40Unit of Measure Filter SearchUnit of Measure FilterFlowFilterCode10
41Capacity SearchCapacityFlowFieldDecimal12
42Qty. on Order (Job) SearchQty. on Order (Job)FlowFieldDecimal12
43Qty. Quoted (Job) SearchQty. Quoted (Job)FlowFieldDecimal12
44Usage (Qty.) SearchUsage (Qty.)FlowFieldDecimal12
45Usage (Cost) SearchUsage (Cost)FlowFieldDecimal12
46Usage (Price) SearchUsage (Price)FlowFieldDecimal12
47Sales (Qty.) SearchSales (Qty.)FlowFieldDecimal12
48Sales (Cost) SearchSales (Cost)FlowFieldDecimal12
49Sales (Price) SearchSales (Price)FlowFieldDecimal12
50Chargeable Filter SearchChargeable FilterFlowFilterBoolean4
51Gen. 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
       [Resource].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Resource].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
52Picture SearchPictureNormalBLOB8Pictureimage
53Post Code SearchZIP CodeNormalCode20Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Resource].[Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Resource].[Post Code] = [Post Code].[Code]
54County SearchStateNormalText30Countynvarchar(60)
55Automatic Ext. Texts SearchAutomatic Ext. TextNormalBoolean4Automatic Ext_ Textstinyint
56No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Resource].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Resource].[No_ Series] = [No. Series].[Code]
57Tax Group Code SearchTax Group CodeNormalCode20Tax Group Codenvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Resource].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Resource].[Tax Group Code] = [Tax Group].[Code]
58VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
       [Resource].[VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Resource].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
59Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Resource].[Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Resource].[Country_Region Code] = [Country/Region].[Code]
60IC Partner Purch. G/L Acc. No. SearchIC Partner Purch. G/L Acc. No.NormalCode20IC Partner Purch_ G_L Acc_ No_nvarchar(40)
Key to join to the IC G/L Account table.

Show/hide example query

SELECT
       [Resource].[IC Partner Purch_ G_L Acc_ No_]
       ,[IC G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [CRONUS UK Ltd_$IC G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC G/L Account]
              ON
                     [Resource].[IC Partner Purch_ G_L Acc_ No_] = [IC G/L Account].[No_]
61Unit Group Exists SearchUnit Group ExistsFlowFieldBoolean4
140Image SearchImageNormalMedia16Imageuniqueidentifier
150Privacy Blocked SearchPrivacy BlockedNormalBoolean4Privacy Blockedtinyint
720Coupled to CRM SearchCoupled to Dynamics 365 SalesNormalBoolean4Coupled to CRMtinyint
721Coupled to Dataverse SearchCoupled to Dynamics 365 SalesFlowFieldBoolean4
900Qty. on Assembly Order SearchQty. on Assembly OrderFlowFieldDecimal12
950Use Time Sheet SearchUse Time SheetNormalBoolean4Use Time Sheettinyint
951Time Sheet Owner User ID SearchTime Sheet Owner User IDNormalCode50Time Sheet Owner User IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
       [Resource].[Time Sheet Owner User ID]
       ,[User Setup].[User ID]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
              ON
                     [Resource].[Time Sheet Owner User ID] = [User Setup].[User ID]
952Time Sheet Approver User ID SearchTime Sheet Approver User IDNormalCode50Time Sheet Approver User IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
       [Resource].[Time Sheet Approver User ID]
       ,[User Setup].[User ID]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
              ON
                     [Resource].[Time Sheet Approver User ID] = [User Setup].[User ID]
1700Default Deferral Template Code SearchDefault Deferral Template CodeNormalCode10Default Deferral Template Codenvarchar(20)
Key to join to the Deferral Template table.

Show/hide example query

SELECT
       [Resource].[Default Deferral Template Code]
       ,[Deferral Template].[Deferral Code]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [CRONUS UK Ltd_$Deferral Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Template]
              ON
                     [Resource].[Default Deferral Template Code] = [Deferral Template].[Deferral Code]
5900Qty. on Service Order SearchQty. on Service OrderFlowFieldDecimal12
5901Service Zone Filter SearchService Zone FilterNormalCode10Service Zone Filternvarchar(20)
Key to join to the Service Zone table.

Show/hide example query

SELECT
       [Resource].[Service Zone Filter]
       ,[Service Zone].[Code]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
              ON
                     [Resource].[Service Zone Filter] = [Service Zone].[Code]
5902In Customer Zone SearchIn Customer ZoneFlowFieldBoolean4
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].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [User] AS [User]
              ON
                     [Resource].[$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].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
LEFT JOIN
       [User] AS [User]
              ON
                     [Resource].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Resource table

Post CodeTax Group
Dynamics 365 BC Table ReferenceTablesCompany TablesRResource

Leave a Reply

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