Data Exch. Def – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables DData Exch. Def

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

Table Type: Company

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

Table Number: 1222

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Data Exch_ Def$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Name]
   ,[Type]
   ,[Reading_Writing XMLport]
   ,[Header Lines]
   ,[Header Tag]
   ,[Footer Tag]
   ,[Column Separator]
   ,[File Encoding]
   ,[File Type]
   ,[Ext_ Data Handling Codeunit]
   ,[Reading_Writing Codeunit]
   ,[Validation Codeunit]
   ,[Data Handling Codeunit]
   ,[User Feedback Codeunit]
   ,[Custom Column Separator]
   ,[Line Separator]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Data Exch_ Def$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_ Def$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Def]
LEFT JOIN
   [User] AS [User]
      ON
         [Data Exch. Def].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Data Exch. Def].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Data Exch. Def table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	20	Code	nvarchar(40)
2	Name	Name	Normal	Text	100	Name	nvarchar(200)
3	Type	Type	Normal	Option	4	Type	int
	Available options are: “Bank Statement Import” “Payment Export” “Payroll Import” “Generic Import” “Positive Pay Export” “Generic Export” “EFT Payment Export”
4	Reading/Writing XMLport	Reading/Writing XMLport	Normal	Integer	4	Reading_Writing XMLport	int
5	Header Lines	Header Lines	Normal	Integer	4	Header Lines	int
8	Header Tag	Header Tag	Normal	Text	250	Header Tag	nvarchar(500)
9	Footer Tag	Footer Tag	Normal	Text	250	Footer Tag	nvarchar(500)
10	Column Separator	Column Separator	Normal	Option	4	Column Separator	int
	Available options are: “” “Tab” “Semicolon” “Comma” “Space” “Custom”
11	File Encoding	File Encoding	Normal	Option	4	File Encoding	int
	Available options are: “MS-DOS” “UTF-8” “UTF-16” “WINDOWS”
13	File Type	File Type	Normal	Option	4	File Type	int
	Available options are: “Xml” “Variable Text” “Fixed Text” “Json”
14	Ext. Data Handling Codeunit	Ext. Data Handling Codeunit	Normal	Integer	4	Ext_ Data Handling Codeunit	int
15	Reading/Writing Codeunit	Reading/Writing Codeunit	Normal	Integer	4	Reading_Writing Codeunit	int
16	Validation Codeunit	Validation Codeunit	Normal	Integer	4	Validation Codeunit	int
17	Data Handling Codeunit	Data Handling Codeunit	Normal	Integer	4	Data Handling Codeunit	int
18	User Feedback Codeunit	User Feedback Codeunit	Normal	Integer	4	User Feedback Codeunit	int
19	Custom Column Separator	Custom Column Separator	Normal	Text	10	Custom Column Separator	nvarchar(20)
20	Line Separator	Line Separator	Normal	Option	4	Line Separator	int
	Available options are: “CRLF” “CR” “LF”
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. Def].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Data Exch_ Def$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Def] LEFT JOIN [User] AS [User] ON [Data Exch. Def].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Data Exch. Def].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Data Exch_ Def$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Def] LEFT JOIN [User] AS [User] ON [Data Exch. Def].[$systemModifiedBy] = [User].[User Security ID]