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

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]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[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]
   ,[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]

Show/hide columns in Integration Table Mapping table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Name Primary Key Searchnvarchar(40)
3Table ID Searchint
4Integration Table ID Searchint
5Synch_ Codeunit ID Searchint
6Integration Table UID Fld_ No_ Searchint
7Int_ Tbl_ Modified On Fld_ No_ Searchint
8Int_ Table UID Field Type Searchint
9Table Config Template Code Searchnvarchar(20)
10Int_ Tbl_ Config Template Code Searchnvarchar(20)
11Direction Searchint
12Int_ Tbl_ Caption Prefix Searchnvarchar(60)
13Synch_ Int_ Tbl_ Mod_ On Fltr_ Searchdatetime
14Synch_ Modified On Filter Searchdatetime
15Table Filter Searchimage
16Integration Table Filter Searchimage
17Synch_ Only Coupled Records Searchtinyint
18Parent Name Searchnvarchar(40)
19Graph Delta Token Searchnvarchar(500)
20Int_ Tbl_ Delta Token Fld_ No_ Searchint
21Int_ Tbl_ ChangeKey Fld_ No_ Searchint
22Int_ Tbl_ State Fld_ No_ Searchint
23Delete After Synchronization Searchtinyint
24BC Rec Page Id Searchint
25CDS Rec Page Id Searchint
26Deletion-Conflict Resolution Searchint
27Update-Conflict Resolution Searchint
28Uncouple Codeunit ID Searchint
29Coupling Codeunit ID Searchint
30Synch_ After Bulk Coupling Searchtinyint
31Dependency Filter Searchnvarchar(500)
32Create New in Case of No Match Searchtinyint
33Full Sync is Running Searchtinyint
34Full Sync Session ID Searchint
35Last Full Sync Start DateTime Searchdatetime
36$systemId Searchuniqueidentifier
37$systemCreatedAt Searchdatetime
38$systemCreatedBy Searchuniqueidentifier
39$systemModifiedAt Searchdatetime
40$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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