Data Exch_ Mapping

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

Table Type: Company

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

Table Number: 1224

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Data Exch_ 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]
   ,[Name]
   ,[Mapping Codeunit]
   ,[Data Exch_ No_ Field ID]
   ,[Data Exch_ Line Field ID]
   ,[Pre-Mapping Codeunit]
   ,[Post-Mapping Codeunit]
   ,[Use as Intermediate Table]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Data Exch_ 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
5Name Searchnvarchar(500)
6Mapping Codeunit Searchint
7Data Exch_ No_ Field ID Searchint
8Data Exch_ Line Field ID Searchint
9Pre-Mapping Codeunit Searchint
10Post-Mapping Codeunit Searchint
11Use as Intermediate Table Searchtinyint
12$systemId Searchuniqueidentifier
13$systemCreatedAt Searchdatetime
14$systemCreatedBy Searchuniqueidentifier
15$systemModifiedAt Searchdatetime
16$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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