Assembly Header

Dynamics 365 BC Table ReferenceTablesCompany TablesAAssembly 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document Type Primary Key SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Quote”
  • “Order”
  • “Blanket Order”
2No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
3Description SearchDescriptionNormalText100Descriptionnvarchar(200)
4Search Description SearchSearch DescriptionNormalCode100Search Descriptionnvarchar(200)
5Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
6Creation Date SearchCreation DateNormalDate4Creation Datedatetime
7Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
10Item No. SearchItem No.NormalCode20Item 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_]
12Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(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]
15Inventory Posting Group SearchInventory Posting GroupNormalCode20Inventory Posting Groupnvarchar(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]
16Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(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]
19Comment SearchCommentFlowFieldBoolean4
20Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
21Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(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]
22Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(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]
23Posting Date SearchPosting DateNormalDate4Posting Datedatetime
24Due Date SearchDue DateNormalDate4Due Datedatetime
25Starting Date SearchStarting DateNormalDate4Starting Datedatetime
27Ending Date SearchEnding DateNormalDate4Ending Datedatetime
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]
33Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(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]
40Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
41Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
42Remaining Quantity SearchRemaining QuantityNormalDecimal12Remaining Quantitydecimal(38,38)
43Remaining Quantity (Base) SearchRemaining Quantity (Base)NormalDecimal12Remaining Quantity (Base)decimal(38,38)
44Assembled Quantity SearchAssembled QuantityNormalDecimal12Assembled Quantitydecimal(38,38)
45Assembled Quantity (Base) SearchAssembled Quantity (Base)NormalDecimal12Assembled Quantity (Base)decimal(38,38)
46Quantity to Assemble SearchQuantity to AssembleNormalDecimal12Quantity to Assembledecimal(38,38)
47Quantity to Assemble (Base) SearchQuantity to Assemble (Base)NormalDecimal12Quantity to Assemble (Base)decimal(38,38)
48Reserved Quantity SearchReserved QuantityFlowFieldDecimal12
49Reserved Qty. (Base) SearchReserved Qty. (Base)FlowFieldDecimal12
50Planning Flexibility SearchPlanning FlexibilityNormalOption4Planning Flexibilityint
Available options are:
  • “Unlimited”
  • “None”
51MPS Order SearchMPS OrderNormalBoolean4MPS Ordertinyint
54Assemble to Order SearchAssemble to OrderFlowFieldBoolean4
63Posting No. SearchPosting No.NormalCode20Posting No_nvarchar(40)
65Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
67Cost Amount SearchCost AmountNormalDecimal12Cost Amountdecimal(38,38)
68Rolled-up Assembly Cost SearchRolled-up Assembly CostFlowFieldDecimal12
75Indirect Cost % SearchIndirect Cost %NormalDecimal12Indirect Cost _decimal(38,38)
76Overhead Rate SearchOverhead RateNormalDecimal12Overhead Ratedecimal(38,38)
80Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
81Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
82Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
83Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
107No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(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]
108Posting No. Series SearchPosting No. SeriesNormalCode20Posting No_ Seriesnvarchar(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]
120Status SearchStatusNormalOption4Statusint
Available options are:
  • “Open”
  • “Released”
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
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]
9000Assigned User ID SearchAssigned User IDNormalCode50Assigned User IDnvarchar(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 SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Assembly Header].[$systemModifiedBy]
       ,[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].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Assembly Header table

LocationSales HeaderSales Header ArchiveUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesAAssembly Header

Leave a Reply

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