Document Service Scenario – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables DDocument Service Scenario

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

Table Type: System

Table Name: Document Service Scenario
Database Table Name: Document Service Scenario

Table Number: 2000000115

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 Document Service Scenario can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [Document Service Scenario]

Show/hide an example select of all columns by name

SELECT

   [Service Integration]
   ,[Company]
   ,[Document Service]
   ,[Use for Application]
   ,[Use for Platform]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [Document Service Scenario]

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

SELECT
   *
FROM
   [Document Service Scenario] AS [Document Service Scenario]
LEFT JOIN
   [Company] AS [Company]
      ON
         [Document Service Scenario].[Company] = [Company].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Document Service Scenario].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Document Service Scenario].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Document Service Scenario table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Service Integration	Service Integration	Normal	Option	4	Service Integration	int
	Available options are: “OneDrive”
2	Company	Company	Normal	GUID	16	Company	uniqueidentifier
	Key to join to the Company table. Show/hide example query SELECT [Document Service Scenario].[Company] ,[Company].[Name] FROM [Document Service Scenario] AS [Document Service Scenario] LEFT JOIN [Company] AS [Company] ON [Document Service Scenario].[Company] = [Company].[Name]
3	Document Service	Document Service	Normal	Code	30	Document Service	nvarchar(60)
4	Use for Application	Use for Application	Normal	Boolean	4	Use for Application	tinyint
5	Use for Platform	Use for Platform	Normal	Boolean	4	Use for Platform	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 [Document Service Scenario].[$systemCreatedBy] ,[User].[User Security ID] FROM [Document Service Scenario] AS [Document Service Scenario] LEFT JOIN [User] AS [User] ON [Document Service Scenario].[$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 [Document Service Scenario].[$systemModifiedBy] ,[User].[User Security ID] FROM [Document Service Scenario] AS [Document Service Scenario] LEFT JOIN [User] AS [User] ON [Document Service Scenario].[$systemModifiedBy] = [User].[User Security ID]