Miniform Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables MMiniform 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

   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Miniform Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Miniform Header]
LEFT JOIN
   [CRONUS UK Ltd_$Miniform Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Miniform Header]
      ON
         [Miniform Header].[Next Miniform] = [Miniform Header].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Miniform Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Miniform Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Miniform Header table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	20	Code	nvarchar(40)
11	Description	Description	Normal	Text	30	Description	nvarchar(60)
12	No. of Records in List	No. of Records in List	Normal	Integer	4	No_ of Records in List	int
13	Form Type	Form Type	Normal	Option	4	Form Type	int
	Available options are: “Card” “Selection List” “Data List” “Data List Input”
15	Start Miniform	Start Miniform	Normal	Boolean	4	Start Miniform	tinyint
20	Handling Codeunit	Handling Codeunit	Normal	Integer	4	Handling Codeunit	int
21	Next Miniform	Next Miniform	Normal	Code	20	Next Miniform	nvarchar(40)
25	XMLin	XMLin	Normal	BLOB	8	XMLin	image
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Miniform Header].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Miniform Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Miniform Header] LEFT JOIN [User] AS [User] ON [Miniform Header].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Miniform Header].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Miniform Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Miniform Header] LEFT JOIN [User] AS [User] ON [Miniform Header].[$systemModifiedBy] = [User].[User Security ID]