Posted Assembly Line

Dynamics 365 BC Table ReferenceTablesCompany TablesPPosted Assembly Line

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

Table Type: Company

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

Table Number: 911

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Document No_]
   ,[Line No_]
   ,[Order No_]
   ,[Order Line No_]
   ,[Type]
   ,[No_]
   ,[Variant Code]
   ,[Description]
   ,[Description 2]
   ,[Lead-Time Offset]
   ,[Resource Usage Type]
   ,[Location Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Bin Code]
   ,[Position]
   ,[Position 2]
   ,[Position 3]
   ,[Item Shpt_ Entry No_]
   ,[Quantity]
   ,[Quantity (Base)]
   ,[Due Date]
   ,[Quantity per]
   ,[Qty_ per Unit of Measure]
   ,[Inventory Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Unit Cost]
   ,[Cost Amount]
   ,[Unit of Measure Code]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Posted Assembly Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
2Document No. Primary Key SearchDocument No.NormalCode20Document No_nvarchar(40)
3Line No. Primary Key SearchLine No.NormalInteger4Line No_int
8Order No. SearchOrder No.NormalCode20Order No_nvarchar(40)
9Order Line No. SearchOrder Line No.NormalInteger4Order Line No_int
10Type SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “Item”
  • “Resource”
11No. SearchNo.NormalCode20No_nvarchar(40)
12Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Posted Assembly Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Posted Assembly Line].[Variant Code] = [Item Variant].[Code]
13Description SearchDescriptionNormalText100Descriptionnvarchar(200)
14Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
18Lead-Time Offset SearchLead-Time OffsetNormalDateFormula32Lead-Time Offsetvarchar(32)
19Resource Usage Type SearchResource Usage TypeNormalOption4Resource Usage Typeint
Available options are:
  • ” “
  • “Direct”
  • “Fixed”
20Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Posted Assembly Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Posted Assembly Line].[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 Line].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Posted Assembly Line].[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 Line].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Posted Assembly Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
23Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Posted Assembly Line].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Posted Assembly Line].[Bin Code] = [Bin].[Code]
25Position SearchPositionNormalCode10Positionnvarchar(20)
26Position 2 SearchPosition 2NormalCode10Position 2nvarchar(20)
27Position 3 SearchPosition 3NormalCode10Position 3nvarchar(20)
39Item Shpt. Entry No. SearchItem Shpt. Entry No.NormalInteger4Item Shpt_ Entry No_int
40Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
41Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
52Due Date SearchDue DateNormalDate4Due Datedatetime
60Quantity per SearchQuantity perNormalDecimal12Quantity perdecimal(38,38)
61Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
62Inventory Posting Group SearchInventory Posting GroupNormalCode20Inventory Posting Groupnvarchar(40)
Key to join to the Inventory Posting Group table.

Show/hide example query

SELECT
       [Posted Assembly Line].[Inventory Posting Group]
       ,[Inventory Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
              ON
                     [Posted Assembly Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
63Gen. 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 Line].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Posted Assembly Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
65Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
67Cost Amount SearchCost AmountNormalDecimal12Cost Amountdecimal(38,38)
80Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

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

Show/hide tables related from Posted Assembly Line table

LocationUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesPPosted Assembly Line

Leave a Reply

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