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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Code  | nvarchar(40) |
| 3 | Name | nvarchar(200) |
| 4 | Type | int |
| 5 | Reading_Writing XMLport | int |
| 6 | Header Lines | int |
| 7 | Header Tag | nvarchar(500) |
| 8 | Footer Tag | nvarchar(500) |
| 9 | Column Separator | int |
| 10 | File Encoding | int |
| 11 | File Type | int |
| 12 | Ext_ Data Handling Codeunit | int |
| 13 | Reading_Writing Codeunit | int |
| 14 | Validation Codeunit | int |
| 15 | Data Handling Codeunit | int |
| 16 | User Feedback Codeunit | int |
| 17 | Custom Column Separator | nvarchar(20) |
| 18 | Line Separator | int |
| 19 | $systemId | uniqueidentifier |
| 20 | $systemCreatedAt | datetime |
| 21 | $systemCreatedBy | uniqueidentifier |
| 22 | $systemModifiedAt | datetime |
| 23 | $systemModifiedBy | uniqueidentifier |