Doc. Exch. Service Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables DDoc. 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

   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Doc_ Exch_ Service Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Doc. Exch. Service Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [Doc. Exch. Service Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Doc. Exch. Service Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Doc. Exch. Service Setup table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Primary Key	Primary Key	Normal	Code	10	Primary Key	nvarchar(20)
4	Sign-up URL	Sign-up URL	Normal	Text	250	Sign-up URL	nvarchar(500)
5	Service URL	Service URL	Normal	Text	250	Service URL	nvarchar(500)
6	Sign-in URL	Sign-in URL	Normal	Text	250	Sign-in URL	nvarchar(500)
7	Consumer Key	Consumer Key	Normal	GUID	16	Consumer Key	uniqueidentifier
8	Consumer Secret	Consumer Secret	Normal	GUID	16	Consumer Secret	uniqueidentifier
9	Token	Token	Normal	GUID	16	Token	uniqueidentifier
10	Token Secret	Token Secret	Normal	GUID	16	Token Secret	uniqueidentifier
11	Doc. Exch. Tenant ID	Doc. Exch. Tenant ID	Normal	GUID	16	Doc_ Exch_ Tenant ID	uniqueidentifier
12	User Agent	User Agent	Normal	Text	30	User Agent	nvarchar(60)
13	Client Id	Client Id	Normal	Text	250	Client Id	nvarchar(500)
14	Client Secret Key	Client Secret Key	Normal	GUID	16	Client Secret Key	uniqueidentifier
15	Redirect URL	Redirect URL	Normal	Text	250	Redirect URL	nvarchar(500)
16	Auth URL	Authentication URL	Normal	Text	250	Auth URL	nvarchar(500)
17	Token URL	Token URL	Normal	Text	250	Token URL	nvarchar(500)
18	Access Token Key	Access Token Key	Normal	GUID	16	Access Token Key	uniqueidentifier
19	Refresh Token Key	Refresh Token Key	Normal	GUID	16	Refresh Token Key	uniqueidentifier
20	Enabled	Enabled	Normal	Boolean	4	Enabled	tinyint
21	Log Web Requests	Log Web Requests	Normal	Boolean	4	Log Web Requests	tinyint
24	Token Subject	Token Subject	Normal	Text	250	Token Subject	nvarchar(500)
25	Token Issued At	Token Issued At	Normal	DateTime	8	Token Issued At	datetime
27	Id Token	Id Token	Normal	Text	1024	Id Token	nvarchar(2048)
28	Token Expired	Id Token	Normal	Boolean	4	Token Expired	tinyint
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Doc. Exch. Service Setup].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Doc_ Exch_ Service Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Doc. Exch. Service Setup] LEFT JOIN [User] AS [User] ON [Doc. Exch. Service Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Doc. Exch. Service Setup].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Doc_ Exch_ Service Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Doc. Exch. Service Setup] LEFT JOIN [User] AS [User] ON [Doc. Exch. Service Setup].[$systemModifiedBy] = [User].[User Security ID]