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
   [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 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_$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_$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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document Type Primary Key SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Quote”
  • “Order”
  • “Blanket Order”
2Document No. Primary Key SearchDocument No.NormalCode20Document No_nvarchar(40)
3Line No. Primary Key SearchLine No.NormalInteger4Line No_int
10Type SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “Item”
  • “Resource”
11No. SearchNo.NormalCode20No_nvarchar(40)
12Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(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]
13Description SearchDescriptionNormalText100Descriptionnvarchar(200)
14Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
18Lead-Time Offset SearchLead-Time OffsetNormalDateFormula32Lead-Time Offsetvarchar(32)
19Resource Usage Type SearchResource Usage TypeNormalOption4Resource Usage Typeint
Available options are:
  • ” “
  • “Direct”
  • “Fixed”
20Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
21Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(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]
22Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(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]
23Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(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]
25Position SearchPositionNormalCode10Positionnvarchar(20)
26Position 2 SearchPosition 2NormalCode10Position 2nvarchar(20)
27Position 3 SearchPosition 3NormalCode10Position 3nvarchar(20)
38Appl.-to Item Entry SearchAppl.-to Item EntryNormalInteger4Appl_-to Item Entryint
39Appl.-from Item Entry SearchAppl.-from Item EntryNormalInteger4Appl_-from Item Entryint
40Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
41Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
42Remaining Quantity SearchRemaining QuantityNormalDecimal12Remaining Quantitydecimal(38,38)
43Remaining Quantity (Base) SearchRemaining Quantity (Base)NormalDecimal12Remaining Quantity (Base)decimal(38,38)
44Consumed Quantity SearchConsumed QuantityNormalDecimal12Consumed Quantitydecimal(38,38)
45Consumed Quantity (Base) SearchConsumed Quantity (Base)NormalDecimal12Consumed Quantity (Base)decimal(38,38)
46Quantity to Consume SearchQuantity to ConsumeNormalDecimal12Quantity to Consumedecimal(38,38)
47Quantity to Consume (Base) SearchQuantity to Consume (Base)NormalDecimal12Quantity to Consume (Base)decimal(38,38)
48Reserved Quantity SearchReserved QuantityFlowFieldDecimal12
49Reserved Qty. (Base) SearchReserved Qty. (Base)FlowFieldDecimal12
50Avail. Warning SearchAvail. WarningNormalBoolean4Avail_ Warningtinyint
51Substitution Available SearchSubstitution AvailableFlowFieldBoolean4
52Due Date SearchDue DateNormalDate4Due Datedatetime
53Reserve SearchReserveNormalOption4Reserveint
Available options are:
  • “Never”
  • “Optional”
  • “Always”
60Quantity per SearchQuantity perNormalDecimal12Quantity perdecimal(38,38)
61Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
62Inventory Posting Group SearchInventory Posting GroupNormalCode20Inventory Posting Groupnvarchar(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]
63Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(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]
65Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
67Cost Amount SearchCost AmountNormalDecimal12Cost Amountdecimal(38,38)
72Date Filter SearchDate FilterFlowFilterDate4
80Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
82Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
83Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
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]
7301Pick Qty. SearchPick Qty.FlowFieldDecimal12
7302Pick Qty. (Base) SearchPick Qty. (Base)FlowFieldDecimal12
7303Qty. Picked SearchQty. PickedNormalDecimal12Qty_ Pickeddecimal(38,38)
7304Qty. Picked (Base) SearchQty. Picked (Base)NormalDecimal12Qty_ Picked (Base)decimal(38,38)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Assembly Line].[$systemModifiedBy]
       ,[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].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Assembly Line table

Leave a Reply

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