Data 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: 0

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
   [timestamp]
   ,[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 columns in Data Exch_ Def table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Name Searchnvarchar(200)
4Type Searchint
5Reading_Writing XMLport Searchint
6Header Lines Searchint
7Header Tag Searchnvarchar(500)
8Footer Tag Searchnvarchar(500)
9Column Separator Searchint
10File Encoding Searchint
11File Type Searchint
12Ext_ Data Handling Codeunit Searchint
13Reading_Writing Codeunit Searchint
14Validation Codeunit Searchint
15Data Handling Codeunit Searchint
16User Feedback Codeunit Searchint
17Custom Column Separator Searchnvarchar(20)
18Line Separator Searchint
19$systemId Searchuniqueidentifier
20$systemCreatedAt Searchdatetime
21$systemCreatedBy Searchuniqueidentifier
22$systemModifiedAt Searchdatetime
23$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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