Prod. Order Line

Dynamics 365 BC Table ReferenceTablesCompany TablesPProd. Order Line

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

Table Type: Company

Table Name: Prod. Order Line
Database Table Name: CRONUS UK Ltd_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5406

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Status]
   ,[Prod_ Order No_]
   ,[Line No_]
   ,[Item No_]
   ,[Variant Code]
   ,[Description]
   ,[Description 2]
   ,[Location Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Bin Code]
   ,[Quantity]
   ,[Finished Quantity]
   ,[Remaining Quantity]
   ,[Scrap _]
   ,[Due Date]
   ,[Starting Date]
   ,[Starting Time]
   ,[Ending Date]
   ,[Ending Time]
   ,[Planning Level Code]
   ,[Priority]
   ,[Production BOM No_]
   ,[Routing No_]
   ,[Inventory Posting Group]
   ,[Routing Reference No_]
   ,[Unit Cost]
   ,[Cost Amount]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[Finished Qty_ (Base)]
   ,[Remaining Qty_ (Base)]
   ,[Starting Date-Time]
   ,[Ending Date-Time]
   ,[Dimension Set ID]
   ,[Cost Amount (ACY)]
   ,[Unit Cost (ACY)]
   ,[Production BOM Version Code]
   ,[Routing Version Code]
   ,[Routing Type]
   ,[Qty_ per Unit of Measure]
   ,[MPS Order]
   ,[Planning Flexibility]
   ,[Indirect Cost _]
   ,[Overhead Rate]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Prod_ Order 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_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod. Order Line]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Prod. Order Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Prod. Order Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Prod. Order Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Prod. Order Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Prod. Order Line].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [Prod. Order Line].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Prod. Order 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
         [Prod. Order Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Prod. Order Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Prod. Order Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Prod. Order Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Status Primary Key SearchStatusNormalOption4Statusint
Available options are:
  • “Simulated”
  • “Planned”
  • “Firm Planned”
  • “Released”
  • “Finished”
2Prod. Order No. Primary Key SearchProd. Order No.NormalCode20Prod_ Order No_nvarchar(40)
3Line No. Primary Key SearchLine No.NormalInteger4Line No_int
11Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Prod. Order Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Prod. Order Line].[Item No_] = [Item].[No_]
12Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Prod. Order Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Prod. Order Line].[Variant Code] = [Item Variant].[Code]
13Description SearchDescriptionNormalText100Descriptionnvarchar(200)
14Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
20Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Prod. Order Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Prod. Order 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
       [Prod. Order Line].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Prod. Order 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
       [Prod. Order Line].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Prod. Order 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
       [Prod. Order Line].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Prod. Order Line].[Bin Code] = [Bin].[Code]
40Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
41Finished Quantity SearchFinished QuantityNormalDecimal12Finished Quantitydecimal(38,38)
42Remaining Quantity SearchRemaining QuantityNormalDecimal12Remaining Quantitydecimal(38,38)
45Scrap % SearchScrap %NormalDecimal12Scrap _decimal(38,38)
47Due Date SearchDue DateNormalDate4Due Datedatetime
48Starting Date SearchStarting DateNormalDate4Starting Datedatetime
49Starting Time SearchStarting TimeNormalTime4Starting Timedatetime
50Ending Date SearchEnding DateNormalDate4Ending Datedatetime
Key to join to the Inventory Period table.

Show/hide example query

SELECT
       [Prod. Order Line].[Ending Date]
       ,[Inventory Period].[Ending Date]
FROM
       [CRONUS UK Ltd_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
              ON
                     [Prod. Order Line].[Ending Date] = [Inventory Period].[Ending Date]
51Ending Time SearchEnding TimeNormalTime4Ending Timedatetime
52Planning Level Code SearchPlanning Level CodeNormalInteger4Planning Level Codeint
53Priority SearchPriorityNormalInteger4Priorityint
60Production BOM No. SearchProduction BOM No.NormalCode20Production BOM No_nvarchar(40)
Key to join to the Production BOM Header table.

Show/hide example query

SELECT
       [Prod. Order Line].[Production BOM No_]
       ,[Production BOM Header].[No_]
FROM
       [CRONUS UK Ltd_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Production BOM Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Header]
              ON
                     [Prod. Order Line].[Production BOM No_] = [Production BOM Header].[No_]
Part of multi-key to join to the Production BOM Line table.

Show/hide example query

SELECT
       [Prod. Order Line].[Production BOM No_]
       ,[Production BOM Line].[Production BOM No_]
FROM
       [CRONUS UK Ltd_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
              ON
                     [Prod. Order Line].[Production BOM No_] = [Production BOM Line].[Production BOM No_]
              AND
                     [Prod. Order Line].[BOM Line No_] = [Production BOM Line].[Line No_]
61Routing No. SearchRouting No.NormalCode20Routing No_nvarchar(40)
Key to join to the Routing Header table.

Show/hide example query

SELECT
       [Prod. Order Line].[Routing No_]
       ,[Routing Header].[No_]
FROM
       [CRONUS UK Ltd_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Routing Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Header]
              ON
                     [Prod. Order Line].[Routing No_] = [Routing Header].[No_]
62Inventory Posting Group SearchInventory Posting GroupNormalCode20Inventory Posting Groupnvarchar(40)
Key to join to the Inventory Posting Group table.

Show/hide example query

SELECT
       [Prod. Order Line].[Inventory Posting Group]
       ,[Inventory Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
              ON
                     [Prod. Order Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
63Routing Reference No. SearchRouting Reference No.NormalInteger4Routing Reference No_int
65Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
67Cost Amount SearchCost AmountNormalDecimal12Cost Amountdecimal(38,38)
68Reserved Quantity SearchReserved QuantityFlowFieldDecimal12
70Capacity Type Filter SearchCapacity Type FilterFlowFilterOption4
71Capacity No. Filter SearchCapacity No. FilterFlowFilterCode20
72Date Filter SearchDate FilterFlowFilterDate4
73Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
74Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
80Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
81Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
82Finished Qty. (Base) SearchFinished Qty. (Base)NormalDecimal12Finished Qty_ (Base)decimal(38,38)
83Remaining Qty. (Base) SearchRemaining Qty. (Base)NormalDecimal12Remaining Qty_ (Base)decimal(38,38)
84Reserved Qty. (Base) SearchReserved Qty. (Base)FlowFieldDecimal12
90Expected Operation Cost Amt. SearchExpected Operation Cost Amt.FlowFieldDecimal12
91Total Exp. Oper. Output (Qty.) SearchTotal Exp. Oper. Output (Qty.)FlowFieldDecimal12
94Expected Component Cost Amt. SearchExpected Component Cost Amt.FlowFieldDecimal12
198Starting Date-Time SearchStarting Date-TimeNormalDateTime8Starting Date-Timedatetime
199Ending Date-Time SearchEnding Date-TimeNormalDateTime8Ending Date-Timedatetime
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Prod. Order Line].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod. Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Prod. Order Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
5831Cost Amount (ACY) SearchCost Amount (ACY)NormalDecimal12Cost Amount (ACY)decimal(38,38)
5832Unit Cost (ACY) SearchUnit Cost (ACY)NormalDecimal12Unit Cost (ACY)decimal(38,38)
99000750Production BOM Version Code SearchProduction BOM Version CodeNormalCode20Production BOM Version Codenvarchar(40)
99000751Routing Version Code SearchRouting Version CodeNormalCode20Routing Version Codenvarchar(40)
99000752Routing Type SearchRouting TypeNormalOption4Routing Typeint
Available options are:
  • “Serial”
  • “Parallel”
99000753Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
99000754MPS Order SearchMPS OrderNormalBoolean4MPS Ordertinyint
99000755Planning Flexibility SearchPlanning FlexibilityNormalOption4Planning Flexibilityint
Available options are:
  • “Unlimited”
  • “None”
99000764Indirect Cost % SearchIndirect Cost %NormalDecimal12Indirect Cost _decimal(38,38)
99000765Overhead Rate SearchOverhead RateNormalDecimal12Overhead Ratedecimal(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
       [Prod. Order Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod. Order Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Prod. Order 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
       [Prod. Order Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod. Order Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Prod. Order Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Prod. Order Line table

LocationUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesPProd. Order Line

Leave a Reply

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