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

Show/hide columns in Posted Assembly Header table

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

Show/hide example query

SELECT
       [Posted Assembly Header].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Header]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Posted Assembly Header].[Unit of Measure Code] = [Unit of Measure].[Code]
27Qty_ per Unit of Measure Searchdecimal(38,38)
28Reversed Searchtinyint
29No_ Series Searchnvarchar(40)
30Posting No_ Series Searchnvarchar(40)
31Order No_ Series Searchnvarchar(40)
32Dimension Set ID Searchint
33User ID Searchnvarchar(100)
34Source Code Searchnvarchar(20)
35$systemId Searchuniqueidentifier
36$systemCreatedAt Searchdatetime
37$systemCreatedBy Searchuniqueidentifier
38$systemModifiedAt Searchdatetime
39$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Posted Assembly Header table

Leave a Reply

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