Customized Calendar Change

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

Table Type: Company

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

Table Number: 7602

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Source Type]
   ,[Source Code]
   ,[Additional Source Code]
   ,[Base Calendar Code]
   ,[Date]
   ,[Day]
   ,[Description]
   ,[Nonworking]
   ,[Entry No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Customized Calendar Change$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Customized Calendar Change$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customized Calendar Change]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Customized Calendar Change].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar]
      ON
         [Customized Calendar Change].[Base Calendar Code] = [Base Calendar].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Customized Calendar Change].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Customized Calendar Change].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Customized Calendar Change table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Source Type Primary Key SearchSource TypeNormalOption4Source Typeint
Available options are:
  • “Company”
  • “Customer”
  • “Vendor”
  • “Location”
  • “Shipping Agent”
  • “Service”
2Source Code Primary Key SearchSource CodeNormalCode20Source Codenvarchar(40)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Customized Calendar Change].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Customized Calendar Change$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customized Calendar Change]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Customized Calendar Change].[Source Code] = [Source Code].[Code]
3Additional Source Code Primary Key SearchAdditional Source CodeNormalCode20Additional Source Codenvarchar(40)
4Base Calendar Code Primary Key SearchBase Calendar CodeNormalCode10Base Calendar Codenvarchar(20)
Key to join to the Base Calendar table.

Show/hide example query

SELECT
       [Customized Calendar Change].[Base Calendar Code]
       ,[Base Calendar].[Code]
FROM
       [CRONUS UK Ltd_$Customized Calendar Change$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customized Calendar Change]
LEFT JOIN
       [CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar]
              ON
                     [Customized Calendar Change].[Base Calendar Code] = [Base Calendar].[Code]
5Recurring System Primary Key SearchRecurring SystemNormalOption4
6Date Primary Key SearchDateNormalDate4Datedatetime
7Day Primary Key SearchDayNormalOption4Dayint
Available options are:
  • ” “
  • “Monday”
  • “Tuesday”
  • “Wednesday”
  • “Thursday”
  • “Friday”
  • “Saturday”
  • “Sunday”
8Description SearchDescriptionNormalText30Descriptionnvarchar(60)
9Nonworking SearchNonworkingNormalBoolean4Nonworkingtinyint
10Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
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
       [Customized Calendar Change].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Customized Calendar Change$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customized Calendar Change]
LEFT JOIN
       [User] AS [User]
              ON
                     [Customized Calendar Change].[$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
       [Customized Calendar Change].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Customized Calendar Change$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customized Calendar Change]
LEFT JOIN
       [User] AS [User]
              ON
                     [Customized Calendar Change].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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