Data Exch_ Field Mapping Buf_

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

Table Type: Company

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

Table Number: 1265

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Data Exchange Def Code]
   ,[Data Exchange Line Def Code]
   ,[Field ID]
   ,[Table ID]
   ,[Column No_]
   ,[Type]
   ,[Default Value]
   ,[Source]
   ,[Caption]
   ,[Depth]
   ,[Transformation Rule]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Data Exch_ Field Mapping Buf_$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Data Exch_ Field Mapping Buf_ table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Data Exchange Def Code Primary Key Searchnvarchar(40)
3Data Exchange Line Def Code Primary Key Searchnvarchar(40)
4Field ID Primary Key Searchint
5Table ID Primary Key Searchint
6Column No_ Searchint
7Type Searchint
8Default Value Searchnvarchar(500)
9Source Searchnvarchar(500)
10Caption Searchnvarchar(500)
11Depth Searchint
12Transformation Rule Searchnvarchar(40)
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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