Recurrence Schedule

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

Table Type: Company

Table Name: Recurrence Schedule
Database Table Name: CRONUS UK Ltd_$Recurrence Schedule$63ca2fa4-4f03-4f2b-a480-172fef340d3f

Table Number: 4690

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 Recurrence Schedule can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Recurrence Schedule$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[ID]
   ,[Pattern]
   ,[Recurs Every]
   ,[Monthly Pattern]
   ,[Recurs on Day]
   ,[Ordinal Recurrence No_]
   ,[Start Time]
   ,[Recurs on Monday]
   ,[Recurs on Tuesday]
   ,[Recurs on Wednesday]
   ,[Recurs on Thursday]
   ,[Recurs on Friday]
   ,[Recurs on Saturday]
   ,[Recurs on Sunday]
   ,[Weekday]
   ,[Month]
   ,[Start Date]
   ,[End Date]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Recurrence Schedule$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide columns in Recurrence Schedule table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchuniqueidentifier
3Pattern Searchint
4Recurs Every Searchint
5Monthly Pattern Searchint
6Recurs on Day Searchint
7Ordinal Recurrence No_ Searchint
8Start Time Searchdatetime
9Recurs on Monday Searchtinyint
10Recurs on Tuesday Searchtinyint
11Recurs on Wednesday Searchtinyint
12Recurs on Thursday Searchtinyint
13Recurs on Friday Searchtinyint
14Recurs on Saturday Searchtinyint
15Recurs on Sunday Searchtinyint
16Weekday Searchint
17Month Searchint
18Start Date Searchdatetime
19End Date Searchdatetime
20$systemId Searchuniqueidentifier
21$systemCreatedAt Searchdatetime
22$systemCreatedBy Searchuniqueidentifier
23$systemModifiedAt Searchdatetime
24$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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