Assembly Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables AAssembly Line

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

Table Type: Company

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

Table Number: 901

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Document Type]
   ,[Document No_]
   ,[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]
   ,[Appl_-to Item Entry]
   ,[Appl_-from Item Entry]
   ,[Quantity]
   ,[Quantity (Base)]
   ,[Remaining Quantity]
   ,[Remaining Quantity (Base)]
   ,[Consumed Quantity]
   ,[Consumed Quantity (Base)]
   ,[Quantity to Consume]
   ,[Quantity to Consume (Base)]
   ,[Avail_ Warning]
   ,[Due Date]
   ,[Reserve]
   ,[Quantity per]
   ,[Qty_ per Unit of Measure]
   ,[Inventory Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Unit Cost]
   ,[Cost Amount]
   ,[Unit of Measure Code]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Dimension Set ID]
   ,[Qty_ Picked]
   ,[Qty_ Picked (Base)]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Assembly Line table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Document Type	int
3	Document No_	nvarchar(40)
4	Line No_	int
5	Type	int
6	No_	nvarchar(40)
7	Variant Code	nvarchar(20)
8	Description	nvarchar(200)
9	Description 2	nvarchar(100)
10	Lead-Time Offset	varchar(32)
11	Resource Usage Type	int
12	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Assembly Line].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Line] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Assembly Line].[Location Code] = [Location].[Code]
13	Shortcut Dimension 1 Code	nvarchar(40)
14	Shortcut Dimension 2 Code	nvarchar(40)
15	Bin Code	nvarchar(40)
16	Position	nvarchar(20)
17	Position 2	nvarchar(20)
18	Position 3	nvarchar(20)
19	Appl_-to Item Entry	int
20	Appl_-from Item Entry	int
21	Quantity	decimal(38,38)
22	Quantity (Base)	decimal(38,38)
23	Remaining Quantity	decimal(38,38)
24	Remaining Quantity (Base)	decimal(38,38)
25	Consumed Quantity	decimal(38,38)
26	Consumed Quantity (Base)	decimal(38,38)
27	Quantity to Consume	decimal(38,38)
28	Quantity to Consume (Base)	decimal(38,38)
29	Avail_ Warning	tinyint
30	Due Date	datetime
31	Reserve	int
32	Quantity per	decimal(38,38)
33	Qty_ per Unit of Measure	decimal(38,38)
34	Inventory Posting Group	nvarchar(40)
35	Gen_ Prod_ Posting Group	nvarchar(40)
36	Unit Cost	decimal(38,38)
37	Cost Amount	decimal(38,38)
38	Unit of Measure Code	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Assembly Line].[Unit of Measure Code] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Line] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Assembly Line].[Unit of Measure Code] = [Unit of Measure].[Code]
39	Qty_ Rounding Precision	decimal(38,38)
40	Qty_ Rounding Precision (Base)	decimal(38,38)
41	Dimension Set ID	int
42	Qty_ Picked	decimal(38,38)
43	Qty_ Picked (Base)	decimal(38,38)
44	$systemId	uniqueidentifier
45	$systemCreatedAt	datetime
46	$systemCreatedBy	uniqueidentifier
47	$systemModifiedAt	datetime
48	$systemModifiedBy	uniqueidentifier