Merge Duplicates Line Buffer

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

Table Type: Company

Table Name: Merge Duplicates Line Buffer
Database Table Name: CRONUS UK Ltd_$Merge Duplicates Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 65

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 Merge Duplicates Line Buffer can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Merge Duplicates Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Type]
   ,[Table ID]
   ,[ID]
   ,[Name]
   ,[Duplicate Value]
   ,[Current Value]
   ,[Override]
   ,[Duplicate Count]
   ,[Current Count]
   ,[Table Name]
   ,[In Primary Key]
   ,[Conflicts]
   ,[Modified]
   ,[Data Type]
   ,[Can Be Renamed]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Merge Duplicates Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Merge Duplicates Line Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Type Primary Key Searchint
3Table ID Primary Key Searchint
4ID Primary Key Searchint
5Name Searchnvarchar(60)
6Duplicate Value Searchnvarchar(4096)
7Current Value Searchnvarchar(4096)
8Override Searchtinyint
9Duplicate Count Searchint
10Current Count Searchint
11Table Name Searchnvarchar(60)
12In Primary Key Searchint
13Conflicts Searchint
14Modified Searchtinyint
15Data Type Searchnvarchar(60)
16Can Be Renamed Searchtinyint
17$systemId Searchuniqueidentifier
18$systemCreatedAt Searchdatetime
19$systemCreatedBy Searchuniqueidentifier
20$systemModifiedAt Searchdatetime
21$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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