Token Cache – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables TToken Cache

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

Table Type: System

Table Name: Token Cache
Database Table Name: Token Cache

Table Number: 2000000197

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 Token Cache can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [Token Cache]

Show/hide an example select of all columns by name

SELECT

   [User Security ID]
   ,[User Unique ID]
   ,[Tenant ID]
   ,[Cache Write Time]
   ,[Cache Data]
   ,[User String Unique ID]
   ,[Tenant String Unique ID]
   ,[Home Account ID]
   ,[Login Hint]
   ,[Session Cache Key]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [Token Cache]

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

SELECT
   *
FROM
   [Token Cache] AS [Token Cache]
LEFT JOIN
   [User] AS [User]
      ON
         [Token Cache].[User Security ID] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Token Cache].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Token Cache].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Token Cache table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	User Security ID	User Security ID	Normal	GUID	16	User Security ID	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Token Cache].[User Security ID] ,[User].[User Security ID] FROM [Token Cache] AS [Token Cache] LEFT JOIN [User] AS [User] ON [Token Cache].[User Security ID] = [User].[User Security ID]
2	User Unique ID	User Unique ID	Normal	GUID	16	User Unique ID	uniqueidentifier
3	Tenant ID	Tenant ID	Normal	GUID	16	Tenant ID	uniqueidentifier
4	Cache Write Time	Cache Write Time	Normal	DateTime	8	Cache Write Time	datetime
5	Cache Data	Cache Data	Normal	BLOB	8	Cache Data	image
6	User String Unique ID	User String Unique ID	Normal	Text	80	User String Unique ID	nvarchar(160)
7	Tenant String Unique ID	Tenant String Unique ID	Normal	Text	80	Tenant String Unique ID	nvarchar(160)
8	Home Account ID	Home Account ID	Normal	Text	120	Home Account ID	nvarchar(240)
9	Login Hint	Login Hint	Normal	Text	120	Login Hint	nvarchar(240)
10	Session Cache Key	Session Cache Key	Normal	Text	120	Session Cache Key	nvarchar(240)
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 [Token Cache].[$systemCreatedBy] ,[User].[User Security ID] FROM [Token Cache] AS [Token Cache] LEFT JOIN [User] AS [User] ON [Token Cache].[$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 [Token Cache].[$systemModifiedBy] ,[User].[User Security ID] FROM [Token Cache] AS [Token Cache] LEFT JOIN [User] AS [User] ON [Token Cache].[$systemModifiedBy] = [User].[User Security ID]