Record Link

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

Table Type: System

Table Name: Record Link
Database Table Name: Record Link

Table Number: 0

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [Record Link]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Link ID]
   ,[Record ID]
   ,[URL1]
   ,[URL2]
   ,[URL3]
   ,[URL4]
   ,[Description]
   ,[Type]
   ,[Note]
   ,[Created]
   ,[User ID]
   ,[Company]
   ,[Notify]
   ,[To User ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Record Link]

Show/hide columns in Record Link table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Link ID Primary Key Searchint
3Record ID Searchvarbinary(448)
4URL1 Searchnvarchar(4096)
5URL2 Searchnvarchar(500)
6URL3 Searchnvarchar(500)
7URL4 Searchnvarchar(500)
8Description Searchnvarchar(500)
9Type Searchint
10Note Searchimage
11Created Searchdatetime
12User ID Searchnvarchar(264)
13Company Searchnvarchar(60)
14Notify Searchtinyint
15To User ID Searchnvarchar(264)
16$systemId Searchuniqueidentifier
17$systemCreatedAt Searchdatetime
18$systemCreatedBy Searchuniqueidentifier
19$systemModifiedAt Searchdatetime
20$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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