O365 C2Graph Event Settings – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables OO365 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	10	Code	nvarchar(20)
2	Inv. Sent Enabled	Inv. Sent Enabled	Normal	Boolean	4	Inv_ Sent Enabled	tinyint
3	Inv. Sent Event	Inv. Sent Event	Normal	Integer	4	Inv_ Sent Event	int
4	Inv. Paid Enabled	Inv. Paid Enabled	Normal	Boolean	4	Inv_ Paid Enabled	tinyint
5	Inv. Paid Event	Inv. Paid Event	Normal	Integer	4	Inv_ Paid Event	int
6	Inv. Draft Enabled	Inv. Draft Enabled	Normal	Boolean	4	Inv_ Draft Enabled	tinyint
7	Inv. Draft Duration (Day)	Inv. Draft Duration (Day)	Normal	Integer	4	Inv_ Draft Duration (Day)	int
8	Inv. Draft Event	Inv. Draft Event	Normal	Integer	4	Inv_ Draft Event	int
9	Inv. Overdue Enabled	Inv. Overdue Enabled	Normal	Boolean	4	Inv_ Overdue Enabled	tinyint
10	Inv. Overdue Event	Inv. Overdue Event	Normal	Integer	4	Inv_ Overdue Event	int
11	Inv. Inactivity Enabled	Inv. Inactivity Enabled	Normal	Boolean	4	Inv_ Inactivity Enabled	tinyint
12	Inv. Inactivity Duration (Day)	Inv. Inactivity Duration (Day)	Normal	Integer	4	Inv_ Inactivity Duration (Day)	int
13	Inv. Inactivity Event	Inv. Inactivity Event	Normal	Integer	4	Inv_ Inactivity Event	int
14	Est. Sent Enabled	Est. Sent Enabled	Normal	Boolean	4	Est_ Sent Enabled	tinyint
15	Est. Accepted Enabled	Est. Accepted Enabled	Normal	Boolean	4	Est_ Accepted Enabled	tinyint
16	Est. Expiring Enabled	Est. Expiring Enabled	Normal	Boolean	4	Est_ Expiring Enabled	tinyint
17	Est. Expiring Week Start (WD)	Est. Expiring Week Start (WD)	Normal	Integer	4	Est_ Expiring Week Start (WD)	int
18	Est. Expiring Event	Est. Expiring Event	Normal	Integer	4	Est_ Expiring Event	int
19	Inv. Email Failed Enabled	Inv. Email Failed Enabled	Normal	Boolean	4	Inv_ Email Failed Enabled	tinyint
20	Inv. Email Failed Event	Inv. Email Failed Event	Normal	Integer	4	Inv_ Email Failed Event	int
21	Est. Email Failed Enabled	Est. Email Failed Enabled	Normal	Boolean	4	Est_ Email Failed Enabled	tinyint
22	Est. Email Failed Event	Est. Email Failed Event	Normal	Integer	4	Est_ Email Failed Event	int
23	Kpi Update Enabled	Kpi Update Enabled	Normal	Boolean	4	Kpi Update Enabled	tinyint
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [O365 C2Graph Event Settings].[$systemModifiedBy] ,[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].[$systemModifiedBy] = [User].[User Security ID]