Doc_ Exch_ Service Setup

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

Table Type: Company

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

Table Number: 1275

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Primary Key]
   ,[Sign-up URL]
   ,[Service URL]
   ,[Sign-in URL]
   ,[Consumer Key]
   ,[Consumer Secret]
   ,[Token]
   ,[Token Secret]
   ,[Doc_ Exch_ Tenant ID]
   ,[User Agent]
   ,[Client Id]
   ,[Client Secret Key]
   ,[Redirect URL]
   ,[Auth URL]
   ,[Token URL]
   ,[Access Token Key]
   ,[Refresh Token Key]
   ,[Enabled]
   ,[Log Web Requests]
   ,[Token Subject]
   ,[Token Issued At]
   ,[Id Token]
   ,[Token Expired]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Doc_ Exch_ Service Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Doc_ Exch_ Service Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Sign-up URL Searchnvarchar(500)
4Service URL Searchnvarchar(500)
5Sign-in URL Searchnvarchar(500)
6Consumer Key Searchuniqueidentifier
7Consumer Secret Searchuniqueidentifier
8Token Searchuniqueidentifier
9Token Secret Searchuniqueidentifier
10Doc_ Exch_ Tenant ID Searchuniqueidentifier
11User Agent Searchnvarchar(60)
12Client Id Searchnvarchar(500)
13Client Secret Key Searchuniqueidentifier
14Redirect URL Searchnvarchar(500)
15Auth URL Searchnvarchar(500)
16Token URL Searchnvarchar(500)
17Access Token Key Searchuniqueidentifier
18Refresh Token Key Searchuniqueidentifier
19Enabled Searchtinyint
20Log Web Requests Searchtinyint
21Token Subject Searchnvarchar(500)
22Token Issued At Searchdatetime
23Id Token Searchnvarchar(2048)
24Token Expired 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 *