Posted Assembly Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPosted 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Document No_	nvarchar(40)
3	Line No_	int
4	Order No_	nvarchar(40)
5	Order Line No_	int
6	Type	int
7	No_	nvarchar(40)
8	Variant Code	nvarchar(20)
9	Description	nvarchar(200)
10	Description 2	nvarchar(100)
11	Lead-Time Offset	varchar(32)
12	Resource Usage Type	int
13	Location Code	nvarchar(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]
14	Shortcut Dimension 1 Code	nvarchar(40)
15	Shortcut Dimension 2 Code	nvarchar(40)
16	Bin Code	nvarchar(40)
17	Position	nvarchar(20)
18	Position 2	nvarchar(20)
19	Position 3	nvarchar(20)
20	Item Shpt_ Entry No_	int
21	Quantity	decimal(38,38)
22	Quantity (Base)	decimal(38,38)
23	Due Date	datetime
24	Quantity per	decimal(38,38)
25	Qty_ per Unit of Measure	decimal(38,38)
26	Inventory Posting Group	nvarchar(40)
27	Gen_ Prod_ Posting Group	nvarchar(40)
28	Unit Cost	decimal(38,38)
29	Cost Amount	decimal(38,38)
30	Unit of Measure Code	nvarchar(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]
31	Dimension Set ID	int
32	$systemId	uniqueidentifier
33	$systemCreatedAt	datetime
34	$systemCreatedBy	uniqueidentifier
35	$systemModifiedAt	datetime
36	$systemModifiedBy	uniqueidentifier