Miniform Line

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

Table Type: Company

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Miniform Code]
   ,[Line No_]
   ,[Area]
   ,[Field Type]
   ,[Table No_]
   ,[Field No_]
   ,[Text]
   ,[Field Length]
   ,[Call Miniform]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Miniform Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Miniform Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Miniform Code Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Area Searchint
5Field Type Searchint
6Table No_ Searchint
7Field No_ Searchint
8Text Searchnvarchar(60)
9Field Length Searchint
10Call Miniform Searchnvarchar(40)
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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