Posted 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
   [timestamp]
   ,[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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Posted Assembly Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Posted Assembly Line].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Posted Assembly Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Order No_ Searchnvarchar(40)
5Order Line No_ Searchint
6Type Searchint
7No_ Searchnvarchar(40)
8Variant Code Searchnvarchar(20)
9Description Searchnvarchar(200)
10Description 2 Searchnvarchar(100)
11Lead-Time Offset Searchvarchar(32)
12Resource Usage Type Searchint
13Location Code Searchnvarchar(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]
14Shortcut Dimension 1 Code Searchnvarchar(40)
15Shortcut Dimension 2 Code Searchnvarchar(40)
16Bin Code Searchnvarchar(40)
17Position Searchnvarchar(20)
18Position 2 Searchnvarchar(20)
19Position 3 Searchnvarchar(20)
20Item Shpt_ Entry No_ Searchint
21Quantity Searchdecimal(38,38)
22Quantity (Base) Searchdecimal(38,38)
23Due Date Searchdatetime
24Quantity per Searchdecimal(38,38)
25Qty_ per Unit of Measure Searchdecimal(38,38)
26Inventory Posting Group Searchnvarchar(40)
27Gen_ Prod_ Posting Group Searchnvarchar(40)
28Unit Cost Searchdecimal(38,38)
29Cost Amount Searchdecimal(38,38)
30Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Posted Assembly Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Posted Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Assembly Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Posted Assembly Line].[Unit of Measure Code] = [Unit of Measure].[Code]
31Dimension Set ID Searchint
32$systemId Searchuniqueidentifier
33$systemCreatedAt Searchdatetime
34$systemCreatedBy Searchuniqueidentifier
35$systemModifiedAt Searchdatetime
36$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Posted Assembly Line table

Leave a Reply

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