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
   [Type]
   ,[ID]
   ,[Name]
   ,[Duplicate Value]
   ,[Current Value]
   ,[Override]
   ,[Duplicate Count]
   ,[Current Count]
   ,[Table ID]
   ,[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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Merge Duplicates Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Merge Duplicates Line Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
      ON
         [Merge Duplicates Line Buffer].[Table ID] = [Data Exch. Mapping].[Table ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Merge Duplicates Line Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Merge Duplicates Line Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Merge Duplicates Line Buffer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Type Primary Key SearchTypeNormalOption4Typeint
Available options are:
  • “”
  • “Field”
  • “Table”
2ID Primary Key SearchIDNormalInteger4IDint
3Name SearchNameNormalText30Namenvarchar(60)
4Duplicate Value SearchDuplicate ValueNormalText2048Duplicate Valuenvarchar(4096)
5Current Value SearchCurrent ValueNormalText2048Current Valuenvarchar(4096)
6Override SearchOverrideNormalBoolean4Overridetinyint
7Duplicate Count SearchDuplicate CountNormalInteger4Duplicate Countint
8Current Count SearchCurrent CountNormalInteger4Current Countint
9Table ID Primary Key SearchTable IDNormalInteger4Table IDint
Key to join to the Data Exch. Mapping table.

Show/hide example query

SELECT
       [Merge Duplicates Line Buffer].[Table ID]
       ,[Data Exch. Mapping].[Table ID]
FROM
       [CRONUS UK Ltd_$Merge Duplicates Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Merge Duplicates Line Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
              ON
                     [Merge Duplicates Line Buffer].[Table ID] = [Data Exch. Mapping].[Table ID]
10Table Name SearchTable NameNormalText30Table Namenvarchar(60)
11In Primary Key SearchIn Primary KeyNormalOption4In Primary Keyint
Available options are:
  • “Yes”
  • “No”
12Conflicts SearchConflictsNormalInteger4Conflictsint
13Modified SearchModifiedNormalBoolean4Modifiedtinyint
14Data Type SearchData TypeNormalText30Data Typenvarchar(60)
15Can Be Renamed SearchCan Be RenamedNormalBoolean4Can Be Renamedtinyint
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
       [Merge Duplicates Line Buffer].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Merge Duplicates Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Merge Duplicates Line Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Merge Duplicates Line Buffer].[$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
       [Merge Duplicates Line Buffer].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Merge Duplicates Line Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Merge Duplicates Line Buffer]
LEFT JOIN
       [User] AS [User]
              ON
                     [Merge Duplicates Line Buffer].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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