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
   [timestamp]
   ,[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 columns in O365 C2Graph Event Settings table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(20)
3Inv_ Sent Enabled Searchtinyint
4Inv_ Sent Event Searchint
5Inv_ Paid Enabled Searchtinyint
6Inv_ Paid Event Searchint
7Inv_ Draft Enabled Searchtinyint
8Inv_ Draft Duration (Day) Searchint
9Inv_ Draft Event Searchint
10Inv_ Overdue Enabled Searchtinyint
11Inv_ Overdue Event Searchint
12Inv_ Inactivity Enabled Searchtinyint
13Inv_ Inactivity Duration (Day) Searchint
14Inv_ Inactivity Event Searchint
15Est_ Sent Enabled Searchtinyint
16Est_ Accepted Enabled Searchtinyint
17Est_ Expiring Enabled Searchtinyint
18Est_ Expiring Week Start (WD) Searchint
19Est_ Expiring Event Searchint
20Inv_ Email Failed Enabled Searchtinyint
21Inv_ Email Failed Event Searchint
22Est_ Email Failed Enabled Searchtinyint
23Est_ Email Failed Event Searchint
24Kpi Update Enabled Searchtinyint
25$systemId Searchuniqueidentifier
26$systemCreatedAt Searchdatetime
27$systemCreatedBy Searchuniqueidentifier
28$systemModifiedAt Searchdatetime
29$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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