Data 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: 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_ 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
   [timestamp]
   ,[Data Exch_ Def Code]
   ,[Data Exch_ Line Def Code]
   ,[Column No_]
   ,[Name]
   ,[Show]
   ,[Data Type]
   ,[Data Format]
   ,[Data Formatting Culture]
   ,[Description]
   ,[Length]
   ,[Constant]
   ,[Path]
   ,[Negative-Sign Identifier]
   ,[Text Padding Required]
   ,[Pad Character]
   ,[Justification]
   ,[Use Node Name as Value]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Data Exch_ Column Def$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Data Exch_ Column Def table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Data Exch_ Def Code Primary Key Searchnvarchar(40)
3Data Exch_ Line Def Code Primary Key Searchnvarchar(40)
4Column No_ Primary Key Searchint
5Name Searchnvarchar(500)
6Show Searchtinyint
7Data Type Searchint
8Data Format Searchnvarchar(200)
9Data Formatting Culture Searchnvarchar(20)
10Description Searchnvarchar(200)
11Length Searchint
12Constant Searchnvarchar(60)
13Path Searchnvarchar(500)
14Negative-Sign Identifier Searchnvarchar(60)
15Text Padding Required Searchtinyint
16Pad Character Searchnvarchar(2)
17Justification Searchint
18Use Node Name as Value Searchtinyint
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 *