Temp Integration Field Mapping

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

Table Type: Company

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

Table Number: 5337

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Temp 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]
   ,[Source Field No_]
   ,[Destination Field No_]
   ,[Validate Destination Field]
   ,[Bidirectional]
   ,[Constant Value]
   ,[Not Null]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Temp Integration Field Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Temp Integration Field Mapping table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchint
3Integration Table Mapping Name Searchnvarchar(40)
4Source Field No_ Searchint
5Destination Field No_ Searchint
6Validate Destination Field Searchtinyint
7Bidirectional Searchtinyint
8Constant Value Searchnvarchar(200)
9Not Null Searchtinyint
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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