Config_ Template Line

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

Table Type: Company

Table Name: Config_ Template Line
Database Table Name: CRONUS UK Ltd_$Config_ Template Line$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 Config_ Template Line can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Data Template Code]
   ,[Line No_]
   ,[Type]
   ,[Field ID]
   ,[Field Name]
   ,[Table ID]
   ,[Template Code]
   ,[Mandatory]
   ,[Reference]
   ,[Default Value]
   ,[Skip Relation Check]
   ,[Language ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Config_ Template Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Config_ Template Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Data Template Code Primary Key Searchnvarchar(20)
3Line No_ Primary Key Searchint
4Type Searchint
5Field ID Searchint
6Field Name Searchnvarchar(60)
7Table ID Searchint
8Template Code Searchnvarchar(20)
9Mandatory Searchtinyint
10Reference Searchnvarchar(500)
11Default Value Searchnvarchar(4096)
12Skip Relation Check Searchtinyint
13Language ID Searchint
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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