Posted Assembly Header

Dynamics 365 BC Table ReferenceTablesCompany TablesPPosted Assembly Header

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

Table Type: Company

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

Table Number: 910

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [No_]
   ,[Description]
   ,[Search Description]
   ,[Description 2]
   ,[Order No_]
   ,[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]
   ,[Item Rcpt_ Entry No_]
   ,[Quantity]
   ,[Quantity (Base)]
   ,[Unit Cost]
   ,[Cost Amount]
   ,[Indirect Cost _]
   ,[Overhead Rate]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Reversed]
   ,[No_ Series]
   ,[Posting No_ Series]
   ,[Order No_ Series]
   ,[Dimension Set ID]
   ,[User ID]
   ,[Source Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Posted Assembly Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
2No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
3Description SearchDescriptionNormalText100Descriptionnvarchar(200)
4Search Description SearchSearch DescriptionNormalCode100Search Descriptionnvarchar(200)
5Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
9Order No. SearchOrder No.NormalCode20Order No_nvarchar(40)
10Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Posted Assembly Header].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Posted 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
       [Posted Assembly Header].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Posted 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
       [Posted Assembly Header].[Inventory Posting Group]
       ,[Inventory Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
              ON
                     [Posted 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
       [Posted Assembly Header].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Posted 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
       [Posted Assembly Header].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Posted 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
       [Posted Assembly Header].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Posted 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
       [Posted Assembly Header].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Posted 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
       [Posted Assembly Header].[Ending Date]
       ,[Inventory Period].[Ending Date]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
              ON
                     [Posted 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
       [Posted Assembly Header].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Posted Assembly Header].[Bin Code] = [Bin].[Code]
39Item Rcpt. Entry No. SearchItem Rcpt. Entry No.NormalInteger4Item Rcpt_ Entry No_int
40Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
41Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
54Assemble to Order SearchAssemble to OrderFlowFieldBoolean4
65Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
67Cost Amount SearchCost AmountNormalDecimal12Cost Amountdecimal(38,38)
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)
100Reversed SearchReversedNormalBoolean4Reversedtinyint
107No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Posted Assembly Header].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Posted 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
       [Posted Assembly Header].[Posting No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Posted Assembly Header].[Posting No_ Series] = [No. Series].[Code]
109Order No. Series SearchOrder No. SeriesNormalCode20Order No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Posted Assembly Header].[Order No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Posted Assembly Header].[Order No_ Series] = [No. Series].[Code]
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Posted Assembly Header].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Posted Assembly Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
9010User ID SearchUser IDNormalCode50User IDnvarchar(100)
9020Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Posted Assembly Header].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Posted Assembly Header].[Source Code] = [Source Code].[Code]
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
       [Posted Assembly Header].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Posted 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
       [Posted Assembly Header].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Posted Assembly Header].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Posted Assembly Header table

LocationUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesPPosted Assembly Header

Leave a Reply

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