Service Hour

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

Table Type: Company

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

Table Number: 5910

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 Service Hour can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Service Contract Type]
   ,[Service Contract No_]
   ,[Day]
   ,[Starting Date]
   ,[Starting Time]
   ,[Ending Time]
   ,[Valid on Holidays]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Service Hour$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Service Hour table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Service Contract Type Primary Key Searchint
3Service Contract No_ Primary Key Searchnvarchar(40)
4Day Primary Key Searchint
5Starting Date Primary Key Searchdatetime
6Starting Time Searchdatetime
7Ending Time Searchdatetime
8Valid on Holidays Searchtinyint
9$systemId Searchuniqueidentifier
10$systemCreatedAt Searchdatetime
11$systemCreatedBy Searchuniqueidentifier
12$systemModifiedAt Searchdatetime
13$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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