Resources Setup

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

Table Type: Company

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

Table Number: 314

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Primary Key]
   ,[Resource Nos_]
   ,[Time Sheet Nos_]
   ,[Time Sheet First Weekday]
   ,[Time Sheet by Job Approval]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Resources Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Resources Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Resource Nos_ Searchnvarchar(40)
4Time Sheet Nos_ Searchnvarchar(40)
5Time Sheet First Weekday Searchint
6Time Sheet by Job Approval Searchint
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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