Data Exch. Def

Dynamics 365 BC Table ReferenceTablesCompany TablesDData 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code SearchCodeNormalCode20Codenvarchar(40)
2Name Primary Key SearchNameNormalText100Namenvarchar(200)
3Type SearchTypeNormalOption4Typeint
Available options are:
  • “Bank Statement Import”
  • “Payment Export”
  • “Payroll Import”
  • “Generic Import”
  • “Positive Pay Export”
  • “Generic Export”
  • “EFT Payment Export”
4Reading/Writing XMLport SearchReading/Writing XMLportNormalInteger4Reading_Writing XMLportint
5Header Lines SearchHeader LinesNormalInteger4Header Linesint
8Header Tag SearchHeader TagNormalText250Header Tagnvarchar(500)
9Footer Tag SearchFooter TagNormalText250Footer Tagnvarchar(500)
10Column Separator SearchColumn SeparatorNormalOption4Column Separatorint
Available options are:
  • “”
  • “Tab”
  • “Semicolon”
  • “Comma”
  • “Space”
  • “Custom”
11File Encoding SearchFile EncodingNormalOption4File Encodingint
Available options are:
  • “MS-DOS”
  • “UTF-8”
  • “UTF-16”
  • “WINDOWS”
13File Type SearchFile TypeNormalOption4File Typeint
Available options are:
  • “Xml”
  • “Variable Text”
  • “Fixed Text”
  • “Json”
14Ext. Data Handling Codeunit SearchExt. Data Handling CodeunitNormalInteger4Ext_ Data Handling Codeunitint
15Reading/Writing Codeunit SearchReading/Writing CodeunitNormalInteger4Reading_Writing Codeunitint
16Validation Codeunit SearchValidation CodeunitNormalInteger4Validation Codeunitint
17Data Handling Codeunit SearchData Handling CodeunitNormalInteger4Data Handling Codeunitint
18User Feedback Codeunit SearchUser Feedback CodeunitNormalInteger4User Feedback Codeunitint
19Custom Column Separator SearchCustom Column SeparatorNormalText10Custom Column Separatornvarchar(20)
20Line Separator SearchLine SeparatorNormalOption4Line Separatorint
Available options are:
  • “CRLF”
  • “CR”
  • “LF”
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesDData Exch. Def

Leave a Reply

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