Integration Field Mapping

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

Table Type: Company

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

Table Number: 5336

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Integration Table Mapping Name]
   ,[Field No_]
   ,[Integration Table Field No_]
   ,[Direction]
   ,[Constant Value]
   ,[Validate Field]
   ,[Validate Integration Table Fld]
   ,[Clear Value on Failed Sync]
   ,[Status]
   ,[Not Null]
   ,[Transformation Rule]
   ,[Transformation Direction]
   ,[Use For Match-Based Coupling]
   ,[Case-Sensitive Matching]
   ,[Match Priority]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Integration Field Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Integration Field Mapping table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchint
3Integration Table Mapping Name Searchnvarchar(40)
4Field No_ Searchint
5Integration Table Field No_ Searchint
6Direction Searchint
7Constant Value Searchnvarchar(200)
8Validate Field Searchtinyint
9Validate Integration Table Fld Searchtinyint
10Clear Value on Failed Sync Searchtinyint
11Status Searchint
12Not Null Searchtinyint
13Transformation Rule Searchnvarchar(40)
14Transformation Direction Searchint
15Use For Match-Based Coupling Searchtinyint
16Case-Sensitive Matching Searchtinyint
17Match Priority Searchint
18$systemId Searchuniqueidentifier
19$systemCreatedAt Searchdatetime
20$systemCreatedBy Searchuniqueidentifier
21$systemModifiedAt Searchdatetime
22$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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