Data Exch. Field Mapping Buf. – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables DData 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

   [Data Exchange Def Code]
   ,[Data Exchange Line Def Code]
   ,[Table ID]
   ,[Column No_]
   ,[Type]
   ,[Field ID]
   ,[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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Data Exch_ Field Mapping Buf_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Field Mapping Buf.]
LEFT JOIN
   [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping]
      ON
         [Data Exch. Field Mapping Buf.].[Table ID] = [Data Exch. Mapping].[Table ID]
LEFT JOIN
   [CRONUS UK Ltd_$Transformation Rule$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transformation Rule]
      ON
         [Data Exch. Field Mapping Buf.].[Transformation Rule] = [Transformation Rule].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Data Exch. Field Mapping Buf.].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Data Exch. Field Mapping Buf.].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Data Exch. Field Mapping Buf. table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Data Exchange Def Code	Data Exchange Def Code	Normal	Code	20	Data Exchange Def Code	nvarchar(40)
2	Data Exchange Line Def Code	Data Exchange Line Def Code	Normal	Code	20	Data Exchange Line Def Code	nvarchar(40)
3	Table ID	Table ID	Normal	Integer	4	Table ID	int
	Key to join to the Data Exch. Mapping table. Show/hide example query SELECT [Data Exch. Field Mapping Buf.].[Table ID] ,[Data Exch. Mapping].[Table ID] FROM [CRONUS UK Ltd_$Data Exch_ Field Mapping Buf_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Field Mapping Buf.] LEFT JOIN [CRONUS UK Ltd_$Data Exch_ Mapping$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Mapping] ON [Data Exch. Field Mapping Buf.].[Table ID] = [Data Exch. Mapping].[Table ID]
4	Column No.	Column No.	Normal	Integer	4	Column No_	int
5	Type	Type	Normal	Option	4	Type	int
	Available options are: “Field” “Table”
10	Field ID	Field ID	Normal	Integer	4	Field ID	int
11	Default Value	Default Value	Normal	Text	250	Default Value	nvarchar(500)
13	Source	Source	Normal	Text	250	Source	nvarchar(500)
20	Caption	Caption	Normal	Text	250	Caption	nvarchar(500)
22	Depth	Depth	Normal	Integer	4	Depth	int
23	Transformation Rule	Transformation Rule	Normal	Code	20	Transformation Rule	nvarchar(40)
	Key to join to the Transformation Rule table. Show/hide example query SELECT [Data Exch. Field Mapping Buf.].[Transformation Rule] ,[Transformation Rule].[Code] FROM [CRONUS UK Ltd_$Data Exch_ Field Mapping Buf_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Field Mapping Buf.] LEFT JOIN [CRONUS UK Ltd_$Transformation Rule$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transformation Rule] ON [Data Exch. Field Mapping Buf.].[Transformation Rule] = [Transformation Rule].[Code]
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Data Exch. Field Mapping Buf.].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Data Exch_ Field Mapping Buf_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Field Mapping Buf.] LEFT JOIN [User] AS [User] ON [Data Exch. Field Mapping Buf.].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier