Data Exch_ Field Mapping

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

Table Type: Company

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

Table Number: 0

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Data Exch_ Def Code]
   ,[Data Exch_ Line Def Code]
   ,[Table ID]
   ,[Column No_]
   ,[Field ID]
   ,[Optional]
   ,[Use Default Value]
   ,[Default Value]
   ,[Multiplier]
   ,[Target Table ID]
   ,[Target Field ID]
   ,[Transformation Rule]
   ,[Overwrite Value]
   ,[Priority]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Data Exch_ Field Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Data Exch_ Field Mapping table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Data Exch_ Def Code Primary Key Searchnvarchar(40)
3Data Exch_ Line Def Code Primary Key Searchnvarchar(40)
4Table ID Primary Key Searchint
5Column No_ Primary Key Searchint
6Field ID Primary Key Searchint
7Optional Searchtinyint
8Use Default Value Searchtinyint
9Default Value Searchnvarchar(500)
10Multiplier Searchdecimal(38,38)
11Target Table ID Searchint
12Target Field ID Searchint
13Transformation Rule Searchnvarchar(40)
14Overwrite Value Searchtinyint
15Priority Searchint
16$systemId Searchuniqueidentifier
17$systemCreatedAt Searchdatetime
18$systemCreatedBy Searchuniqueidentifier
19$systemModifiedAt Searchdatetime
20$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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