Assembly 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Document Type Primary Key Searchint
3Document No_ Primary Key Searchnvarchar(40)
4Line No_ Primary Key Searchint
5Type Searchint
6No_ Searchnvarchar(40)
7Variant Code Searchnvarchar(20)
8Description Searchnvarchar(200)
9Description 2 Searchnvarchar(100)
10Lead-Time Offset Searchvarchar(32)
11Resource Usage Type Searchint
12Location Code Searchnvarchar(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]
13Shortcut Dimension 1 Code Searchnvarchar(40)
14Shortcut Dimension 2 Code Searchnvarchar(40)
15Bin Code Searchnvarchar(40)
16Position Searchnvarchar(20)
17Position 2 Searchnvarchar(20)
18Position 3 Searchnvarchar(20)
19Appl_-to Item Entry Searchint
20Appl_-from Item Entry Searchint
21Quantity Searchdecimal(38,38)
22Quantity (Base) Searchdecimal(38,38)
23Remaining Quantity Searchdecimal(38,38)
24Remaining Quantity (Base) Searchdecimal(38,38)
25Consumed Quantity Searchdecimal(38,38)
26Consumed Quantity (Base) Searchdecimal(38,38)
27Quantity to Consume Searchdecimal(38,38)
28Quantity to Consume (Base) Searchdecimal(38,38)
29Avail_ Warning Searchtinyint
30Due Date Searchdatetime
31Reserve Searchint
32Quantity per Searchdecimal(38,38)
33Qty_ per Unit of Measure Searchdecimal(38,38)
34Inventory Posting Group Searchnvarchar(40)
35Gen_ Prod_ Posting Group Searchnvarchar(40)
36Unit Cost Searchdecimal(38,38)
37Cost Amount Searchdecimal(38,38)
38Unit of Measure Code Searchnvarchar(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]
39Qty_ Rounding Precision Searchdecimal(38,38)
40Qty_ Rounding Precision (Base) Searchdecimal(38,38)
41Dimension Set ID Searchint
42Qty_ Picked Searchdecimal(38,38)
43Qty_ Picked (Base) Searchdecimal(38,38)
44$systemId Searchuniqueidentifier
45$systemCreatedAt Searchdatetime
46$systemCreatedBy Searchuniqueidentifier
47$systemModifiedAt Searchdatetime
48$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Assembly Line table

Leave a Reply

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