Outlook Synch_ Field

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

Table Type: Company

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

Table Number: 5304

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_ Field can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Synch_ Entity Code]
   ,[Element No_]
   ,[Line No_]
   ,[Master Table No_]
   ,[Outlook Object]
   ,[Outlook Property]
   ,[User-Defined]
   ,[Search Field]
   ,[Condition]
   ,[Table No_]
   ,[Table Relation]
   ,[Field No_]
   ,[Read-Only Status]
   ,[Field Default Value]
   ,[Record GUID]
   ,[DefaultValueExpression]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Outlook Synch_ Field$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Outlook Synch_ Field table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Synch_ Entity Code Primary Key Searchnvarchar(20)
3Element No_ Primary Key Searchint
4Line No_ Primary Key Searchint
5Master Table No_ Searchint
6Outlook Object Searchnvarchar(160)
7Outlook Property Searchnvarchar(160)
8User-Defined Searchtinyint
9Search Field Searchtinyint
10Condition Searchnvarchar(500)
11Table No_ Searchint
12Table Relation Searchnvarchar(500)
13Field No_ Searchint
14Read-Only Status Searchint
15Field Default Value Searchnvarchar(500)
16Record GUID Searchuniqueidentifier
17DefaultValueExpression Searchnvarchar(500)
18$systemId Searchuniqueidentifier
19$systemCreatedAt Searchdatetime
20$systemCreatedBy Searchuniqueidentifier
21$systemModifiedAt Searchdatetime
22$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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