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

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

Show/hide columns in Assembly Line table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: “Quote” “Order” “Blanket Order”
2	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
3	Line No.	Line No.	Normal	Integer	4	Line No_	int
10	Type	Type	Normal	Option	4	Type	int
	Available options are: ” “ “Item” “Resource”
11	No.	No.	Normal	Code	20	No_	nvarchar(40)
12	Variant Code	Variant Code	Normal	Code	10	Variant Code	nvarchar(20)
	Key to join to the Item Variant table. Show/hide example query SELECT [Assembly Line].[Variant Code] ,[Item Variant].[Code] FROM [CRONUS UK Ltd_$Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Line] LEFT JOIN [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant] ON [Assembly Line].[Variant Code] = [Item Variant].[Code]
13	Description	Description	Normal	Text	100	Description	nvarchar(200)
14	Description 2	Description 2	Normal	Text	50	Description 2	nvarchar(100)
18	Lead-Time Offset	Lead-Time Offset	Normal	DateFormula	32	Lead-Time Offset	varchar(32)
19	Resource Usage Type	Resource Usage Type	Normal	Option	4	Resource Usage Type	int
	Available options are: ” “ “Direct” “Fixed”
20	Location Code	Location Code	Normal	Code	10	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]
21	Shortcut Dimension 1 Code	Shortcut Dimension 1 Code	Normal	Code	20	Shortcut Dimension 1 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Assembly Line].[Shortcut Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Line] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Assembly Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
22	Shortcut Dimension 2 Code	Shortcut Dimension 2 Code	Normal	Code	20	Shortcut Dimension 2 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Assembly Line].[Shortcut Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Line] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Assembly Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
23	Bin Code	Bin Code	Normal	Code	20	Bin Code	nvarchar(40)
	Key to join to the Bin table. Show/hide example query SELECT [Assembly Line].[Bin Code] ,[Bin].[Code] FROM [CRONUS UK Ltd_$Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Line] LEFT JOIN [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin] ON [Assembly Line].[Bin Code] = [Bin].[Code]
25	Position	Position	Normal	Code	10	Position	nvarchar(20)
26	Position 2	Position 2	Normal	Code	10	Position 2	nvarchar(20)
27	Position 3	Position 3	Normal	Code	10	Position 3	nvarchar(20)
38	Appl.-to Item Entry	Appl.-to Item Entry	Normal	Integer	4	Appl_-to Item Entry	int
39	Appl.-from Item Entry	Appl.-from Item Entry	Normal	Integer	4	Appl_-from Item Entry	int
40	Quantity	Quantity	Normal	Decimal	12	Quantity	decimal(38,38)
41	Quantity (Base)	Quantity (Base)	Normal	Decimal	12	Quantity (Base)	decimal(38,38)
42	Remaining Quantity	Remaining Quantity	Normal	Decimal	12	Remaining Quantity	decimal(38,38)
43	Remaining Quantity (Base)	Remaining Quantity (Base)	Normal	Decimal	12	Remaining Quantity (Base)	decimal(38,38)
44	Consumed Quantity	Consumed Quantity	Normal	Decimal	12	Consumed Quantity	decimal(38,38)
45	Consumed Quantity (Base)	Consumed Quantity (Base)	Normal	Decimal	12	Consumed Quantity (Base)	decimal(38,38)
46	Quantity to Consume	Quantity to Consume	Normal	Decimal	12	Quantity to Consume	decimal(38,38)
47	Quantity to Consume (Base)	Quantity to Consume (Base)	Normal	Decimal	12	Quantity to Consume (Base)	decimal(38,38)
48	Reserved Quantity	Reserved Quantity	FlowField	Decimal	12
49	Reserved Qty. (Base)	Reserved Qty. (Base)	FlowField	Decimal	12
50	Avail. Warning	Avail. Warning	Normal	Boolean	4	Avail_ Warning	tinyint
51	Substitution Available	Substitution Available	FlowField	Boolean	4
52	Due Date	Due Date	Normal	Date	4	Due Date	datetime
53	Reserve	Reserve	Normal	Option	4	Reserve	int
	Available options are: “Never” “Optional” “Always”
60	Quantity per	Quantity per	Normal	Decimal	12	Quantity per	decimal(38,38)
61	Qty. per Unit of Measure	Qty. per Unit of Measure	Normal	Decimal	12	Qty_ per Unit of Measure	decimal(38,38)
62	Inventory Posting Group	Inventory Posting Group	Normal	Code	20	Inventory Posting Group	nvarchar(40)
	Key to join to the Inventory Posting Group table. Show/hide example query SELECT [Assembly Line].[Inventory Posting Group] ,[Inventory Posting Group].[Code] FROM [CRONUS UK Ltd_$Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Line] LEFT JOIN [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group] ON [Assembly Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
63	Gen. Prod. Posting Group	Gen. Prod. Posting Group	Normal	Code	20	Gen_ Prod_ Posting Group	nvarchar(40)
	Key to join to the Gen. Product Posting Group table. Show/hide example query SELECT [Assembly Line].[Gen_ Prod_ Posting Group] ,[Gen. Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Line] LEFT JOIN [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group] ON [Assembly Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
65	Unit Cost	Unit Cost	Normal	Decimal	12	Unit Cost	decimal(38,38)
67	Cost Amount	Cost Amount	Normal	Decimal	12	Cost Amount	decimal(38,38)
72	Date Filter	Date Filter	FlowFilter	Date	4
80	Unit of Measure Code	Unit of Measure Code	Normal	Code	10	Unit of Measure Code	nvarchar(20)
82	Qty. Rounding Precision	Qty. Rounding Precision	Normal	Decimal	12	Qty_ Rounding Precision	decimal(38,38)
83	Qty. Rounding Precision (Base)	Qty. Rounding Precision (Base)	Normal	Decimal	12	Qty_ Rounding Precision (Base)	decimal(38,38)
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	Key to join to the Dimension Set Entry table. Show/hide example query SELECT [Assembly Line].[Dimension Set ID] ,[Dimension Set Entry].[Dimension Set ID] FROM [CRONUS UK Ltd_$Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Line] LEFT JOIN [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry] ON [Assembly Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
7301	Pick Qty.	Pick Qty.	FlowField	Decimal	12
7302	Pick Qty. (Base)	Pick Qty. (Base)	FlowField	Decimal	12
7303	Qty. Picked	Qty. Picked	Normal	Decimal	12	Qty_ Picked	decimal(38,38)
7304	Qty. Picked (Base)	Qty. Picked (Base)	Normal	Decimal	12	Qty_ Picked (Base)	decimal(38,38)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Assembly Line].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Assembly Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Assembly Line] LEFT JOIN [User] AS [User] ON [Assembly Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Assembly Line table

Dynamics 365 BC Table Reference Tables Company Tables AAssembly Line

Leave a Reply Cancel reply