Outlook Synch_ Option Correl_

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

Table Type: Company

Table Name: Outlook Synch_ Option Correl_
Database Table Name: CRONUS UK Ltd_$Outlook Synch_ Option Correl_$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5307

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 Outlook Synch_ Option Correl_ can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Outlook Synch_ Option Correl_$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Synch_ Entity Code]
   ,[Element No_]
   ,[Field Line No_]
   ,[Line No_]
   ,[Outlook Object]
   ,[Outlook Property]
   ,[Outlook Value]
   ,[Table No_]
   ,[Field No_]
   ,[Option No_]
   ,[Enumeration No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Outlook Synch_ Option Correl_$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Outlook Synch_ Option Correl_ table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Synch_ Entity Code Primary Key Searchnvarchar(20)
3Element No_ Primary Key Searchint
4Field Line No_ Primary Key Searchint
5Line No_ Primary Key Searchint
6Outlook Object Searchnvarchar(160)
7Outlook Property Searchnvarchar(160)
8Outlook Value Searchnvarchar(160)
9Table No_ Searchint
10Field No_ Searchint
11Option No_ Searchint
12Enumeration No_ Searchint
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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