Miniform Header

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

Table Type: Company

Table Name: Miniform Header
Database Table Name: CRONUS UK Ltd_$Miniform Header$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 7700

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 Header can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Description]
   ,[No_ of Records in List]
   ,[Form Type]
   ,[Start Miniform]
   ,[Handling Codeunit]
   ,[Next Miniform]
   ,[XMLin]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Miniform Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Miniform Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Description Searchnvarchar(60)
4No_ of Records in List Searchint
5Form Type Searchint
6Start Miniform Searchtinyint
7Handling Codeunit Searchint
8Next Miniform Searchnvarchar(40)
9XMLin Searchimage
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 *