Resource

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: 0

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
   [timestamp]
   ,[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_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Resource].[Vendor No_] = [Vendor].[No_]
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_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Resource].[Country_Region Code] = [Country_Region].[Code]

Show/hide columns in Resource table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Type Searchint
4Name Searchnvarchar(200)
5Search Name Searchnvarchar(200)
6Name 2 Searchnvarchar(100)
7Address Searchnvarchar(200)
8Address 2 Searchnvarchar(100)
9City Searchnvarchar(60)
10Social Security No_ Searchnvarchar(60)
11Job Title Searchnvarchar(60)
12Education Searchnvarchar(60)
13Contract Class Searchnvarchar(60)
14Employment Date Searchdatetime
15Resource Group No_ Searchnvarchar(40)
16Global Dimension 1 Code Searchnvarchar(40)
17Global Dimension 2 Code Searchnvarchar(40)
18Base Unit of Measure Searchnvarchar(20)
19Direct Unit Cost Searchdecimal(38,38)
20Indirect Cost _ Searchdecimal(38,38)
21Unit Cost Searchdecimal(38,38)
22Profit _ Searchdecimal(38,38)
23Price_Profit Calculation Searchint
24Unit Price Searchdecimal(38,38)
25Vendor No_ Searchnvarchar(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 Searchdatetime
27Blocked Searchtinyint
28Gen_ Prod_ Posting Group Searchnvarchar(40)
29Picture Searchimage
30Post Code Searchnvarchar(40)
31County Searchnvarchar(60)
32Automatic Ext_ Texts Searchtinyint
33No_ Series Searchnvarchar(40)
34Tax Group Code Searchnvarchar(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]
35VAT Prod_ Posting Group Searchnvarchar(40)
36Country_Region Code Searchnvarchar(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]
37IC Partner Purch_ G_L Acc_ No_ Searchnvarchar(40)
38Image Searchuniqueidentifier
39Privacy Blocked Searchtinyint
40Coupled to CRM Searchtinyint
41Use Time Sheet Searchtinyint
42Time Sheet Owner User ID Searchnvarchar(100)
43Time Sheet Approver User ID Searchnvarchar(100)
44Default Deferral Template Code Searchnvarchar(20)
45Service Zone Filter Searchnvarchar(20)
46$systemId Searchuniqueidentifier
47$systemCreatedAt Searchdatetime
48$systemCreatedBy Searchuniqueidentifier
49$systemModifiedAt Searchdatetime
50$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Resource table

Leave a Reply

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