Document Service

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

Table Type: System

Table Name: Document Service
Database Table Name: Document Service

Table Number: 2000000114

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Document Service]

Show/hide an example select of all columns by name

SELECT
   [Service ID]
   ,[Description]
   ,[Location]
   ,[User Name]
   ,[Password]
   ,[Document Repository]
   ,[Folder]
   ,[Client Id]
   ,[Client Secret]
   ,[Redirect URL]
   ,[Authentication Type]
   ,[Client Secret Key]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Document Service]

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

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

Show/hide columns in Document Service table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Service ID Primary Key SearchService IDNormalCode30Service IDnvarchar(60)
3Description SearchDescriptionNormalText80Descriptionnvarchar(160)
5Location SearchLocationNormalText250Locationnvarchar(500)
7User Name SearchUser NameNormalText128User Namenvarchar(256)
9Password SearchPasswordNormalText128Passwordnvarchar(256)
11Document Repository SearchDocument RepositoryNormalText250Document Repositorynvarchar(500)
13Folder SearchFolderNormalText250Foldernvarchar(500)
15Client Id SearchClient IdNormalText250Client Idnvarchar(500)
17Client Secret SearchClient SecretNormalText250Client Secretnvarchar(500)
19Redirect URL SearchRedirect URLNormalText2048Redirect URLnvarchar(4096)
21Authentication Type SearchAuthentication TypeNormalOption4Authentication Typeint
Available options are:
  • “Legacy”
  • “OAuth2”
23Client Secret Key SearchClient Secret KeyNormalGUID16Client Secret Keyuniqueidentifier
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Document Service].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [Document Service] AS [Document Service]
LEFT JOIN
       [User] AS [User]
              ON
                     [Document Service].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Document Service].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [Document Service] AS [Document Service]
LEFT JOIN
       [User] AS [User]
              ON
                     [Document Service].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

Your email address will not be published. Required fields are marked *