O365 C2Graph Event Settings

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

Table Type: Company

Table Name: O365 C2Graph Event Settings
Database Table Name: CRONUS UK Ltd_$O365 C2Graph Event Settings$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 2162

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 O365 C2Graph Event Settings can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$O365 C2Graph Event Settings$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Code]
   ,[Inv_ Sent Enabled]
   ,[Inv_ Sent Event]
   ,[Inv_ Paid Enabled]
   ,[Inv_ Paid Event]
   ,[Inv_ Draft Enabled]
   ,[Inv_ Draft Duration (Day)]
   ,[Inv_ Draft Event]
   ,[Inv_ Overdue Enabled]
   ,[Inv_ Overdue Event]
   ,[Inv_ Inactivity Enabled]
   ,[Inv_ Inactivity Duration (Day)]
   ,[Inv_ Inactivity Event]
   ,[Est_ Sent Enabled]
   ,[Est_ Accepted Enabled]
   ,[Est_ Expiring Enabled]
   ,[Est_ Expiring Week Start (WD)]
   ,[Est_ Expiring Event]
   ,[Inv_ Email Failed Enabled]
   ,[Inv_ Email Failed Event]
   ,[Est_ Email Failed Enabled]
   ,[Est_ Email Failed Event]
   ,[Kpi Update Enabled]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$O365 C2Graph Event Settings$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$O365 C2Graph Event Settings$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 C2Graph Event Settings]
LEFT JOIN
   [User] AS [User]
      ON
         [O365 C2Graph Event Settings].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [O365 C2Graph Event Settings].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in O365 C2Graph Event Settings table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code SearchCodeNormalCode10Codenvarchar(20)
2Inv. Sent Enabled Primary Key SearchInv. Sent EnabledNormalBoolean4Inv_ Sent Enabledtinyint
3Inv. Sent Event SearchInv. Sent EventNormalInteger4Inv_ Sent Eventint
4Inv. Paid Enabled SearchInv. Paid EnabledNormalBoolean4Inv_ Paid Enabledtinyint
5Inv. Paid Event SearchInv. Paid EventNormalInteger4Inv_ Paid Eventint
6Inv. Draft Enabled SearchInv. Draft EnabledNormalBoolean4Inv_ Draft Enabledtinyint
7Inv. Draft Duration (Day) SearchInv. Draft Duration (Day)NormalInteger4Inv_ Draft Duration (Day)int
8Inv. Draft Event SearchInv. Draft EventNormalInteger4Inv_ Draft Eventint
9Inv. Overdue Enabled SearchInv. Overdue EnabledNormalBoolean4Inv_ Overdue Enabledtinyint
10Inv. Overdue Event SearchInv. Overdue EventNormalInteger4Inv_ Overdue Eventint
11Inv. Inactivity Enabled SearchInv. Inactivity EnabledNormalBoolean4Inv_ Inactivity Enabledtinyint
12Inv. Inactivity Duration (Day) SearchInv. Inactivity Duration (Day)NormalInteger4Inv_ Inactivity Duration (Day)int
13Inv. Inactivity Event SearchInv. Inactivity EventNormalInteger4Inv_ Inactivity Eventint
14Est. Sent Enabled SearchEst. Sent EnabledNormalBoolean4Est_ Sent Enabledtinyint
15Est. Accepted Enabled SearchEst. Accepted EnabledNormalBoolean4Est_ Accepted Enabledtinyint
16Est. Expiring Enabled SearchEst. Expiring EnabledNormalBoolean4Est_ Expiring Enabledtinyint
17Est. Expiring Week Start (WD) SearchEst. Expiring Week Start (WD)NormalInteger4Est_ Expiring Week Start (WD)int
18Est. Expiring Event SearchEst. Expiring EventNormalInteger4Est_ Expiring Eventint
19Inv. Email Failed Enabled SearchInv. Email Failed EnabledNormalBoolean4Inv_ Email Failed Enabledtinyint
20Inv. Email Failed Event SearchInv. Email Failed EventNormalInteger4Inv_ Email Failed Eventint
21Est. Email Failed Enabled SearchEst. Email Failed EnabledNormalBoolean4Est_ Email Failed Enabledtinyint
22Est. Email Failed Event SearchEst. Email Failed EventNormalInteger4Est_ Email Failed Eventint
23Kpi Update Enabled SearchKpi Update EnabledNormalBoolean4Kpi Update Enabledtinyint
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
	       [O365 C2Graph Event Settings].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$O365 C2Graph Event Settings$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 C2Graph Event Settings]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [O365 C2Graph Event Settings].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Leave a Reply

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