Exchange Service Setup

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

Table Type: Company

Table Name: Exchange Service Setup
Database Table Name: CRONUS UK Ltd_$Exchange Service Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5324

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 Exchange Service Setup can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Exchange Service Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Primary Key]
   ,[Azure AD App_ ID]
   ,[Azure AD App_ Cert_ Thumbprint]
   ,[Azure AD Auth_ Endpoint]
   ,[Exchange Service Endpoint]
   ,[Exchange Resource Uri]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Exchange Service Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Exchange Service Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Azure AD App_ ID Searchuniqueidentifier
4Azure AD App_ Cert_ Thumbprint Searchnvarchar(80)
5Azure AD Auth_ Endpoint Searchnvarchar(500)
6Exchange Service Endpoint Searchnvarchar(500)
7Exchange Resource Uri Searchnvarchar(500)
8$systemId Searchuniqueidentifier
9$systemCreatedAt Searchdatetime
10$systemCreatedBy Searchuniqueidentifier
11$systemModifiedAt Searchdatetime
12$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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