Base Calendar Change

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

Table Type: Company

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

Table Number: 7601

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Base Calendar Change$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Base Calendar Code]
   ,[Recurring System]
   ,[Date]
   ,[Day]
   ,[Description]
   ,[Nonworking]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Base Calendar Change$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Base Calendar Change table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Base Calendar Code Primary Key Searchnvarchar(20)
3Recurring System Primary Key Searchint
4Date Primary Key Searchdatetime
5Day Primary Key Searchint
6Description Searchnvarchar(60)
7Nonworking Searchtinyint
8$systemId Searchuniqueidentifier
9$systemCreatedAt Searchdatetime
10$systemCreatedBy Searchuniqueidentifier
11$systemModifiedAt Searchdatetime
12$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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