Assembly 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
   [timestamp]
   ,[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_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Assembly Header].[Item No_] = [Item].[No_]
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_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Assembly Header].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Assembly Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document Type Primary Key Searchint
3No_ Primary Key Searchnvarchar(40)
4Description Searchnvarchar(200)
5Search Description Searchnvarchar(200)
6Description 2 Searchnvarchar(100)
7Creation Date Searchdatetime
8Last Date Modified Searchdatetime
9Item No_ Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Assembly Header].[Item No_] = [Item].[No_]
10Variant Code Searchnvarchar(20)
11Inventory Posting Group Searchnvarchar(40)
12Gen_ Prod_ Posting Group Searchnvarchar(40)
13Location Code Searchnvarchar(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]
14Shortcut Dimension 1 Code Searchnvarchar(40)
15Shortcut Dimension 2 Code Searchnvarchar(40)
16Posting Date Searchdatetime
17Due Date Searchdatetime
18Starting Date Searchdatetime
19Ending Date Searchdatetime
20Bin Code Searchnvarchar(40)
21Quantity Searchdecimal(38,38)
22Quantity (Base) Searchdecimal(38,38)
23Remaining Quantity Searchdecimal(38,38)
24Remaining Quantity (Base) Searchdecimal(38,38)
25Assembled Quantity Searchdecimal(38,38)
26Assembled Quantity (Base) Searchdecimal(38,38)
27Quantity to Assemble Searchdecimal(38,38)
28Quantity to Assemble (Base) Searchdecimal(38,38)
29Planning Flexibility Searchint
30MPS Order Searchtinyint
31Posting No_ Searchnvarchar(40)
32Unit Cost Searchdecimal(38,38)
33Cost Amount Searchdecimal(38,38)
34Indirect Cost _ Searchdecimal(38,38)
35Overhead Rate Searchdecimal(38,38)
36Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Assembly Header].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Header]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Assembly Header].[Unit of Measure Code] = [Unit of Measure].[Code]
37Qty_ per Unit of Measure Searchdecimal(38,38)
38Qty_ Rounding Precision Searchdecimal(38,38)
39Qty_ Rounding Precision (Base) Searchdecimal(38,38)
40No_ Series Searchnvarchar(40)
41Posting No_ Series Searchnvarchar(40)
42Status Searchint
43Dimension Set ID Searchint
44Assigned User ID Searchnvarchar(100)
45$systemId Searchuniqueidentifier
46$systemCreatedAt Searchdatetime
47$systemCreatedBy Searchuniqueidentifier
48$systemModifiedAt Searchdatetime
49$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Assembly Header table

Leave a Reply

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