Calendar Entry

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

Table Type: Company

Table Name: Calendar Entry
Database Table Name: CRONUS UK Ltd_$Calendar Entry$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 Calendar Entry can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Capacity Type]
   ,[No_]
   ,[Date]
   ,[Starting Time]
   ,[Ending Time]
   ,[Work Shift Code]
   ,[Work Center No_]
   ,[Work Center Group Code]
   ,[Capacity (Total)]
   ,[Capacity (Effective)]
   ,[Efficiency]
   ,[Capacity]
   ,[Absence Efficiency]
   ,[Absence Capacity]
   ,[Starting Date-Time]
   ,[Ending Date-Time]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Calendar Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Calendar Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Capacity Type Primary Key Searchint
3No_ Primary Key Searchnvarchar(40)
4Date Primary Key Searchdatetime
5Starting Time Primary Key Searchdatetime
6Ending Time Primary Key Searchdatetime
7Work Shift Code Primary Key Searchnvarchar(20)
8Work Center No_ Searchnvarchar(40)
9Work Center Group Code Searchnvarchar(20)
10Capacity (Total) Searchdecimal(38,38)
11Capacity (Effective) Searchdecimal(38,38)
12Efficiency Searchdecimal(38,38)
13Capacity Searchdecimal(38,38)
14Absence Efficiency Searchdecimal(38,38)
15Absence Capacity Searchdecimal(38,38)
16Starting Date-Time Searchdatetime
17Ending Date-Time Searchdatetime
18$systemId Searchuniqueidentifier
19$systemCreatedAt Searchdatetime
20$systemCreatedBy Searchuniqueidentifier
21$systemModifiedAt Searchdatetime
22$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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