Data Exch. Column Def – Dynamics 365 BC Table Reference

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

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

Table Type: Company

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

Table Number: 1223

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Data Exch_ Def Code]
   ,[Column No_]
   ,[Name]
   ,[Show]
   ,[Data Type]
   ,[Data Format]
   ,[Data Formatting Culture]
   ,[Description]
   ,[Data Exch_ Line Def Code]
   ,[Length]
   ,[Constant]
   ,[Path]
   ,[Negative-Sign Identifier]
   ,[Text Padding Required]
   ,[Pad Character]
   ,[Justification]
   ,[Use Node Name as Value]
   ,[Blank Zero]
   ,[Export If Not Blank]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Data Exch. Column Def table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Data Exch. Def Code	Data Exch. Def Code	Normal	Code	20	Data Exch_ Def Code	nvarchar(40)
	Key to join to the Data Exch. Def table. Show/hide example query SELECT [Data Exch. Column Def].[Data Exch_ Def Code] ,[Data Exch. Def].[Code] FROM [CRONUS UK Ltd_$Data Exch_ Column Def$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Column Def] LEFT JOIN [CRONUS UK Ltd_$Data Exch_ Def$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Def] ON [Data Exch. Column Def].[Data Exch_ Def Code] = [Data Exch. Def].[Code]
2	Column No.	Column No.	Normal	Integer	4	Column No_	int
3	Name	Name	Normal	Text	250	Name	nvarchar(500)
4	Show	Show	Normal	Boolean	4	Show	tinyint
5	Data Type	Data Type	Normal	Option	4	Data Type	int
	Available options are: “Text” “Date” “Decimal” “DateTime”
6	Data Format	Data Format	Normal	Text	100	Data Format	nvarchar(200)
7	Data Formatting Culture	Data Formatting Culture	Normal	Text	10	Data Formatting Culture	nvarchar(20)
8	Description	Description	Normal	Text	100	Description	nvarchar(200)
10	Data Exch. Line Def Code	Data Exch. Line Def Code	Normal	Code	20	Data Exch_ Line Def Code	nvarchar(40)
	Key to join to the Data Exch. Line Def table. Show/hide example query SELECT [Data Exch. Column Def].[Data Exch_ Line Def Code] ,[Data Exch. Line Def].[Code] FROM [CRONUS UK Ltd_$Data Exch_ Column Def$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Column Def] LEFT JOIN [CRONUS UK Ltd_$Data Exch_ Line Def$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Line Def] ON [Data Exch. Column Def].[Data Exch_ Line Def Code] = [Data Exch. Line Def].[Code]
11	Length	Length	Normal	Integer	4	Length	int
12	Constant	Constant	Normal	Text	30	Constant	nvarchar(60)
13	Path	Path	Normal	Text	250	Path	nvarchar(500)
14	Negative-Sign Identifier	Negative-Sign Identifier	Normal	Text	30	Negative-Sign Identifier	nvarchar(60)
15	Text Padding Required	Text Padding Required	Normal	Boolean	4	Text Padding Required	tinyint
16	Pad Character	Pad Character	Normal	Text	1	Pad Character	nvarchar(2)
17	Justification	Justification	Normal	Option	4	Justification	int
	Available options are: “Right” “Left”
18	Use Node Name as Value	Use Node Name as Value	Normal	Boolean	4	Use Node Name as Value	tinyint
19	Blank Zero	Blank Zero	Normal	Boolean	4	Blank Zero	tinyint
20	Export If Not Blank	Export If Not Blank	Normal	Boolean	4	Export If Not Blank	tinyint
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. Column Def].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Data Exch_ Column Def$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exch. Column Def] LEFT JOIN [User] AS [User] ON [Data Exch. Column Def].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier