Assembly Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables AAssembly Header

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

Table Type: Company

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

Table Number: 900

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Document Type]
   ,[No_]
   ,[Description]
   ,[Search Description]
   ,[Description 2]
   ,[Creation Date]
   ,[Last Date Modified]
   ,[Item No_]
   ,[Variant Code]
   ,[Inventory Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Location Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Posting Date]
   ,[Due Date]
   ,[Starting Date]
   ,[Ending Date]
   ,[Bin Code]
   ,[Quantity]
   ,[Quantity (Base)]
   ,[Remaining Quantity]
   ,[Remaining Quantity (Base)]
   ,[Assembled Quantity]
   ,[Assembled Quantity (Base)]
   ,[Quantity to Assemble]
   ,[Quantity to Assemble (Base)]
   ,[Planning Flexibility]
   ,[MPS Order]
   ,[Posting No_]
   ,[Unit Cost]
   ,[Cost Amount]
   ,[Indirect Cost _]
   ,[Overhead Rate]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[No_ Series]
   ,[Posting No_ Series]
   ,[Status]
   ,[Dimension Set ID]
   ,[Assigned User ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Assembly 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_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Header]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Assembly Header].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Assembly Header].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Assembly Header].[Document Type] = [Sales Header].[Document Type]
      AND
         [Assembly Header].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Assembly Header].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Assembly Header].[Inventory Posting Group] = [Inventory Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Assembly Header].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Assembly Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Assembly Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [Assembly Header].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Assembly Header].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Assembly Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Assembly Header].[Assigned User ID] = [User Setup].[User ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Assembly Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Assembly Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Assembly Header table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: “Quote” “Order” “Blanket Order”
2	No.	No.	Normal	Code	20	No_	nvarchar(40)
3	Description	Description	Normal	Text	100	Description	nvarchar(200)
4	Search Description	Search Description	Normal	Code	100	Search Description	nvarchar(200)
5	Description 2	Description 2	Normal	Text	50	Description 2	nvarchar(100)
6	Creation Date	Creation Date	Normal	Date	4	Creation Date	datetime
7	Last Date Modified	Last Date Modified	Normal	Date	4	Last Date Modified	datetime
10	Item No.	Item No.	Normal	Code	20	Item No_	nvarchar(40)
	Key to join to the Item table. Show/hide example query SELECT [Assembly Header].[Item No_] ,[Item].[No_] FROM [CRONUS UK Ltd_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Header] LEFT JOIN [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] ON [Assembly Header].[Item No_] = [Item].[No_]
12	Variant Code	Variant Code	Normal	Code	10	Variant Code	nvarchar(20)
	Key to join to the Item Variant table. Show/hide example query SELECT [Assembly Header].[Variant Code] ,[Item Variant].[Code] FROM [CRONUS UK Ltd_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Header] LEFT JOIN [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant] ON [Assembly Header].[Variant Code] = [Item Variant].[Code]
15	Inventory Posting Group	Inventory Posting Group	Normal	Code	20	Inventory Posting Group	nvarchar(40)
	Key to join to the Inventory Posting Group table. Show/hide example query SELECT [Assembly Header].[Inventory Posting Group] ,[Inventory Posting Group].[Code] FROM [CRONUS UK Ltd_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Header] LEFT JOIN [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group] ON [Assembly Header].[Inventory Posting Group] = [Inventory Posting Group].[Code]
16	Gen. Prod. Posting Group	Gen. Prod. Posting Group	Normal	Code	20	Gen_ Prod_ Posting Group	nvarchar(40)
	Key to join to the Gen. Product Posting Group table. Show/hide example query SELECT [Assembly Header].[Gen_ Prod_ Posting Group] ,[Gen. Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Header] LEFT JOIN [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group] ON [Assembly Header].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
19	Comment	Comment	FlowField	Boolean	4
20	Location Code	Location Code	Normal	Code	10	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Assembly Header].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Header] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Assembly Header].[Location Code] = [Location].[Code]
21	Shortcut Dimension 1 Code	Shortcut Dimension 1 Code	Normal	Code	20	Shortcut Dimension 1 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Assembly Header].[Shortcut Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Header] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Assembly Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
22	Shortcut Dimension 2 Code	Shortcut Dimension 2 Code	Normal	Code	20	Shortcut Dimension 2 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Assembly Header].[Shortcut Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Header] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Assembly Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
23	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
24	Due Date	Due Date	Normal	Date	4	Due Date	datetime
25	Starting Date	Starting Date	Normal	Date	4	Starting Date	datetime
27	Ending Date	Ending Date	Normal	Date	4	Ending Date	datetime
	Key to join to the Inventory Period table. Show/hide example query SELECT [Assembly Header].[Ending Date] ,[Inventory Period].[Ending Date] FROM [CRONUS UK Ltd_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Header] LEFT JOIN [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period] ON [Assembly Header].[Ending Date] = [Inventory Period].[Ending Date]
33	Bin Code	Bin Code	Normal	Code	20	Bin Code	nvarchar(40)
	Key to join to the Bin table. Show/hide example query SELECT [Assembly Header].[Bin Code] ,[Bin].[Code] FROM [CRONUS UK Ltd_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Header] LEFT JOIN [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin] ON [Assembly Header].[Bin Code] = [Bin].[Code]
40	Quantity	Quantity	Normal	Decimal	12	Quantity	decimal(38,38)
41	Quantity (Base)	Quantity (Base)	Normal	Decimal	12	Quantity (Base)	decimal(38,38)
42	Remaining Quantity	Remaining Quantity	Normal	Decimal	12	Remaining Quantity	decimal(38,38)
43	Remaining Quantity (Base)	Remaining Quantity (Base)	Normal	Decimal	12	Remaining Quantity (Base)	decimal(38,38)
44	Assembled Quantity	Assembled Quantity	Normal	Decimal	12	Assembled Quantity	decimal(38,38)
45	Assembled Quantity (Base)	Assembled Quantity (Base)	Normal	Decimal	12	Assembled Quantity (Base)	decimal(38,38)
46	Quantity to Assemble	Quantity to Assemble	Normal	Decimal	12	Quantity to Assemble	decimal(38,38)
47	Quantity to Assemble (Base)	Quantity to Assemble (Base)	Normal	Decimal	12	Quantity to Assemble (Base)	decimal(38,38)
48	Reserved Quantity	Reserved Quantity	FlowField	Decimal	12
49	Reserved Qty. (Base)	Reserved Qty. (Base)	FlowField	Decimal	12
50	Planning Flexibility	Planning Flexibility	Normal	Option	4	Planning Flexibility	int
	Available options are: “Unlimited” “None”
51	MPS Order	MPS Order	Normal	Boolean	4	MPS Order	tinyint
54	Assemble to Order	Assemble to Order	FlowField	Boolean	4
63	Posting No.	Posting No.	Normal	Code	20	Posting No_	nvarchar(40)
65	Unit Cost	Unit Cost	Normal	Decimal	12	Unit Cost	decimal(38,38)
67	Cost Amount	Cost Amount	Normal	Decimal	12	Cost Amount	decimal(38,38)
68	Rolled-up Assembly Cost	Rolled-up Assembly Cost	FlowField	Decimal	12
75	Indirect Cost %	Indirect Cost %	Normal	Decimal	12	Indirect Cost _	decimal(38,38)
76	Overhead Rate	Overhead Rate	Normal	Decimal	12	Overhead Rate	decimal(38,38)
80	Unit of Measure Code	Unit of Measure Code	Normal	Code	10	Unit of Measure Code	nvarchar(20)
81	Qty. per Unit of Measure	Qty. per Unit of Measure	Normal	Decimal	12	Qty_ per Unit of Measure	decimal(38,38)
82	Qty. Rounding Precision	Qty. Rounding Precision	Normal	Decimal	12	Qty_ Rounding Precision	decimal(38,38)
83	Qty. Rounding Precision (Base)	Qty. Rounding Precision (Base)	Normal	Decimal	12	Qty_ Rounding Precision (Base)	decimal(38,38)
107	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Assembly Header].[No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Header] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Assembly Header].[No_ Series] = [No. Series].[Code]
108	Posting No. Series	Posting No. Series	Normal	Code	20	Posting No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Assembly Header].[Posting No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Header] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Assembly Header].[Posting No_ Series] = [No. Series].[Code]
120	Status	Status	Normal	Option	4	Status	int
	Available options are: “Open” “Released”
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	Key to join to the Dimension Set Entry table. Show/hide example query SELECT [Assembly Header].[Dimension Set ID] ,[Dimension Set Entry].[Dimension Set ID] FROM [CRONUS UK Ltd_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Header] LEFT JOIN [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry] ON [Assembly Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
9000	Assigned User ID	Assigned User ID	Normal	Code	50	Assigned User ID	nvarchar(100)
	Key to join to the User Setup table. Show/hide example query SELECT [Assembly Header].[Assigned User ID] ,[User Setup].[User ID] FROM [CRONUS UK Ltd_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Header] LEFT JOIN [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup] ON [Assembly Header].[Assigned User ID] = [User Setup].[User ID]
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 [Assembly Header].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Header] LEFT JOIN [User] AS [User] ON [Assembly Header].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Assembly Header table

Dynamics 365 BC Table Reference Tables Company Tables AAssembly Header

Leave a Reply Cancel reply