Data Exch_ Line Def

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

Table Type: Company

Table Name: Data Exch_ Line Def
Database Table Name: CRONUS UK Ltd_$Data Exch_ Line 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_ Line Def can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Data Exch_ Line Def$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Data Exch_ Def Code]
   ,[Code]
   ,[Name]
   ,[Column Count]
   ,[Data Line Tag]
   ,[Namespace]
   ,[Parent Code]
   ,[Line Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Data Exch_ Line Def$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Data Exch_ Line Def table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Data Exch_ Def Code Primary Key Searchnvarchar(40)
3Code Primary Key Searchnvarchar(40)
4Name Searchnvarchar(200)
5Column Count Searchint
6Data Line Tag Searchnvarchar(500)
7Namespace Searchnvarchar(500)
8Parent Code Searchnvarchar(40)
9Line Type Searchint
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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