OAuth 2.0 Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables OOAuth 2.0 Setup

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

Table Type: Company

Table Name: OAuth 2.0 Setup
Database Table Name: CRONUS UK Ltd_$OAuth 2_0 Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1140

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 OAuth 2.0 Setup can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$OAuth 2_0 Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Description]
   ,[Service URL]
   ,[Redirect URL]
   ,[Client ID]
   ,[Client Secret]
   ,[Access Token]
   ,[Refresh Token]
   ,[Authorization URL Path]
   ,[Access Token URL Path]
   ,[Refresh Token URL Path]
   ,[Scope]
   ,[Authorization Response Type]
   ,[Status]
   ,[Token DataScope]
   ,[Activity Log ID]
   ,[Daily Limit]
   ,[Daily Count]
   ,[Latest Datetime]
   ,[Access Token Due DateTime]
   ,[Feature GUID]
   ,[User ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$OAuth 2_0 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_$OAuth 2_0 Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [OAuth 2.0 Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [OAuth 2.0 Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [OAuth 2.0 Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in OAuth 2.0 Setup table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	20	Code	nvarchar(40)
2	Description	Description	Normal	Text	250	Description	nvarchar(500)
3	Service URL	Service URL	Normal	Text	250	Service URL	nvarchar(500)
4	Redirect URL	Redirect URL	Normal	Text	250	Redirect URL	nvarchar(500)
5	Client ID	Client ID	Normal	GUID	16	Client ID	uniqueidentifier
6	Client Secret	Client Secret	Normal	GUID	16	Client Secret	uniqueidentifier
7	Access Token	Access Token	Normal	GUID	16	Access Token	uniqueidentifier
8	Refresh Token	Refresh Token	Normal	GUID	16	Refresh Token	uniqueidentifier
9	Authorization URL Path	Authorization URL Path	Normal	Text	250	Authorization URL Path	nvarchar(500)
10	Access Token URL Path	Access Token URL Path	Normal	Text	250	Access Token URL Path	nvarchar(500)
11	Refresh Token URL Path	Refresh Token URL Path	Normal	Text	250	Refresh Token URL Path	nvarchar(500)
12	Scope	Scope	Normal	Text	250	Scope	nvarchar(500)
13	Authorization Response Type	Authorization Response Type	Normal	Text	250	Authorization Response Type	nvarchar(500)
14	Status	Status	Normal	Option	4	Status	int
	Available options are: ” “ “Enabled” “Disabled” “Connected” “Error”
15	Token DataScope	Token DataScope	Normal	Option	4	Token DataScope	int
	Available options are: “Module” “User” “Company” “UserAndCompany”
16	Activity Log ID	Activity Log ID	Normal	Integer	4	Activity Log ID	int
17	Daily Limit	Daily Limit	Normal	Integer	4	Daily Limit	int
18	Daily Count	Daily Count	Normal	Integer	4	Daily Count	int
19	Latest Datetime	Latest Datetime	Normal	DateTime	8	Latest Datetime	datetime
20	Access Token Due DateTime	Access Token Due DateTime	Normal	DateTime	8	Access Token Due DateTime	datetime
21	Feature GUID	Feature GUID	Normal	GUID	16	Feature GUID	uniqueidentifier
22	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
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 [OAuth 2.0 Setup].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$OAuth 2_0 Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [OAuth 2.0 Setup] LEFT JOIN [User] AS [User] ON [OAuth 2.0 Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Dynamics 365 BC Table Reference Tables Company Tables OOAuth 2.0 Setup

Show/hide an example select of all columns

Show/hide an example select of all columns by name

Show/hide an example select of all columns including those from all joined tables

Show/hide columns in OAuth 2.0 Setup table

Show/hide example query

Leave a Reply Cancel reply