Integration Table Mapping

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

Table Type: Company

Table Name: Integration Table Mapping
Database Table Name: CRONUS UK Ltd_$Integration Table Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972$ext

Table Number: 5335

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Integration Table Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

Show/hide an example select of all columns by name

SELECT
   [Name]
   ,[Table ID]
   ,[Integration Table ID]
   ,[Synch_ Codeunit ID]
   ,[Integration Table UID Fld_ No_]
   ,[Int_ Tbl_ Modified On Fld_ No_]
   ,[Int_ Table UID Field Type]
   ,[Table Config Template Code]
   ,[Int_ Tbl_ Config Template Code]
   ,[Direction]
   ,[Int_ Tbl_ Caption Prefix]
   ,[Synch_ Int_ Tbl_ Mod_ On Fltr_]
   ,[Synch_ Modified On Filter]
   ,[Table Filter]
   ,[Integration Table Filter]
   ,[Synch_ Only Coupled Records]
   ,[Parent Name]
   ,[Graph Delta Token]
   ,[Int_ Tbl_ Delta Token Fld_ No_]
   ,[Int_ Tbl_ ChangeKey Fld_ No_]
   ,[Int_ Tbl_ State Fld_ No_]
   ,[Delete After Synchronization]
   ,[BC Rec Page Id]
   ,[CDS Rec Page Id]
   ,[Deletion-Conflict Resolution]
   ,[Update-Conflict Resolution]
   ,[Uncouple Codeunit ID]
   ,[Coupling Codeunit ID]
   ,[Synch_ After Bulk Coupling]
   ,[Dependency Filter]
   ,[Create New in Case of No Match]
   ,[Type]
   ,[Disable Event Job Resch_]
   ,[Multi Company Synch_ Enabled]
   ,[Full Sync is Running]
   ,[Full Sync Session ID]
   ,[Last Full Sync Start DateTime]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Integration Table Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

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

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

Show/hide columns in Integration Table Mapping table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Name Primary Key SearchNameNormalCode20Namenvarchar(40)
2Table ID SearchTable IDNormalInteger4Table IDint
Key to join to the Data Exch. Mapping table.

Show/hide example query

SELECT
       [Integration Table Mapping].[Table ID]
       ,[Data Exch. Mapping].[Table ID]
FROM
       [CRONUS UK Ltd_$Integration Table Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Integration Table Mapping]
LEFT JOIN
       [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
              ON
                     [Integration Table Mapping].[Table ID] = [Data Exch. Mapping].[Table ID]
3Integration Table ID SearchIntegration Table IDNormalInteger4Integration Table IDint
4Synch. Codeunit ID SearchSynch. Codeunit IDNormalInteger4Synch_ Codeunit IDint
5Integration Table UID Fld. No. SearchIntegration Table UID Fld. No.NormalInteger4Integration Table UID Fld_ No_int
6Int. Tbl. Modified On Fld. No. SearchInt. Tbl. Modified On Fld. No.NormalInteger4Int_ Tbl_ Modified On Fld_ No_int
7Int. Table UID Field Type SearchInt. Table UID Field TypeNormalInteger4Int_ Table UID Field Typeint
8Table Config Template Code SearchTable Config Template CodeNormalCode10Table Config Template Codenvarchar(20)
9Int. Tbl. Config Template Code SearchInt. Tbl. Config Template CodeNormalCode10Int_ Tbl_ Config Template Codenvarchar(20)
10Direction SearchDirectionNormalOption4Directionint
Available options are:
  • “Bidirectional”
  • “ToIntegrationTable”
  • “FromIntegrationTable”
11Int. Tbl. Caption Prefix SearchInt. Tbl. Caption PrefixNormalText30Int_ Tbl_ Caption Prefixnvarchar(60)
12Synch. Int. Tbl. Mod. On Fltr. SearchSynch. Int. Tbl. Mod. On Fltr.NormalDateTime8Synch_ Int_ Tbl_ Mod_ On Fltr_datetime
13Synch. Modified On Filter SearchSynch. Modified On FilterNormalDateTime8Synch_ Modified On Filterdatetime
14Table Filter SearchTable FilterNormalBLOB8Table Filterimage
15Integration Table Filter SearchIntegration Table FilterNormalBLOB8Integration Table Filterimage
16Synch. Only Coupled Records SearchSynch. Only Coupled RecordsNormalBoolean4Synch_ Only Coupled Recordstinyint
17Parent Name SearchParent NameNormalCode20Parent Namenvarchar(40)
18Graph Delta Token SearchGraph Delta TokenNormalText250Graph Delta Tokennvarchar(500)
19Int. Tbl. Delta Token Fld. No. SearchInt. Tbl. Delta Token Fld. No.NormalInteger4Int_ Tbl_ Delta Token Fld_ No_int
20Int. Tbl. ChangeKey Fld. No. SearchInt. Tbl. ChangeKey Fld. No.NormalInteger4Int_ Tbl_ ChangeKey Fld_ No_int
21Int. Tbl. State Fld. No. SearchInt. Tbl. State Fld. No.NormalInteger4Int_ Tbl_ State Fld_ No_int
22Delete After Synchronization SearchDelete After SynchronizationNormalBoolean4Delete After Synchronizationtinyint
23BC Rec Page Id SearchThe Id of the BC Record PageNormalInteger4BC Rec Page Idint
24CDS Rec Page Id SearchThe Id of the Dataverse Record PageNormalInteger4CDS Rec Page Idint
25Deletion-Conflict Resolution SearchResolve Deletion ConflictsNormalOption4Deletion-Conflict Resolutionint
Available options are:
  • “None”
  • “Restore Records”
  • “Remove Coupling”
26Update-Conflict Resolution SearchResolve Update ConflictsNormalOption4Update-Conflict Resolutionint
Available options are:
  • “None”
  • “Send Update to Integration”
  • “Get Update from Integration”
27Uncouple Codeunit ID SearchUncouple Codeunit IDNormalInteger4Uncouple Codeunit IDint
28Coupling Codeunit ID SearchCoupling Codeunit IDNormalInteger4Coupling Codeunit IDint
29Synch. After Bulk Coupling SearchSynch. After Match-Based CouplingNormalBoolean4Synch_ After Bulk Couplingtinyint
30Dependency Filter SearchDependency FilterNormalText250Dependency Filternvarchar(500)
31Create New in Case of No Match SearchCreate New in Case of No MatchNormalBoolean4Create New in Case of No Matchtinyint
32Type SearchTypeNormalOption4Typeint
Available options are:
  • “Dataverse”
  • “Master Data Management”
33Disable Event Job Resch. SearchDisable Event-driven Synch. Job ReschedulingNormalBoolean4Disable Event Job Resch_tinyint
34Multi Company Synch. Enabled SearchMulti-Company Synchronization EnabledNormalBoolean4Multi Company Synch_ Enabledtinyint
100Full Sync is Running SearchFull Sync is RunningNormalBoolean4Full Sync is Runningtinyint
101Full Sync Session ID SearchFull Sync Session IDNormalInteger4Full Sync Session IDint
102Last Full Sync Start DateTime SearchLast Full Sync Start DateTimeNormalDateTime8Last Full Sync Start DateTimedatetime
7234Overwrite Local Change SearchOverwrite Local ChangeNormalBoolean4
7235Status SearchStatusNormalOption4
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
       [Integration Table Mapping].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Integration Table Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Integration Table Mapping]
LEFT JOIN
       [User] AS [User]
              ON
                     [Integration Table Mapping].[$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
       [Integration Table Mapping].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Integration Table Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Integration Table Mapping]
LEFT JOIN
       [User] AS [User]
              ON
                     [Integration Table Mapping].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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