Prod_ 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
   [timestamp]
   ,[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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Prod_ Order Line].[Item No_] = [Item].[No_]
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_$Production BOM Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Header]
      ON
         [Prod_ Order Line].[Production BOM No_] = [Production BOM Header].[No_]
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_]
LEFT JOIN
   [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
      ON
         [Prod_ Order Line].[BOM Line No_] = [Production BOM Line].[Line No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Prod_ Order Line].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Prod_ Order Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Status Primary Key Searchint
3Prod_ Order No_ Primary Key Searchnvarchar(40)
4Line No_ Primary Key Searchint
5Item No_ Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Prod_ Order Line].[Item No_] = [Item].[No_]
6Variant Code Searchnvarchar(20)
7Description Searchnvarchar(200)
8Description 2 Searchnvarchar(100)
9Location Code Searchnvarchar(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]
10Shortcut Dimension 1 Code Searchnvarchar(40)
11Shortcut Dimension 2 Code Searchnvarchar(40)
12Bin Code Searchnvarchar(40)
13Quantity Searchdecimal(38,38)
14Finished Quantity Searchdecimal(38,38)
15Remaining Quantity Searchdecimal(38,38)
16Scrap _ Searchdecimal(38,38)
17Due Date Searchdatetime
18Starting Date Searchdatetime
19Starting Time Searchdatetime
20Ending Date Searchdatetime
21Ending Time Searchdatetime
22Planning Level Code Searchint
23Priority Searchint
24Production BOM No_ Searchnvarchar(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_]
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_]
25Routing No_ Searchnvarchar(40)
26Inventory Posting Group Searchnvarchar(40)
27Routing Reference No_ Searchint
28Unit Cost Searchdecimal(38,38)
29Cost Amount Searchdecimal(38,38)
30Qty_ Rounding Precision Searchdecimal(38,38)
31Qty_ Rounding Precision (Base) Searchdecimal(38,38)
32Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Prod_ Order Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Prod_ Order Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod_ Order Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Prod_ Order Line].[Unit of Measure Code] = [Unit of Measure].[Code]
33Quantity (Base) Searchdecimal(38,38)
34Finished Qty_ (Base) Searchdecimal(38,38)
35Remaining Qty_ (Base) Searchdecimal(38,38)
36Starting Date-Time Searchdatetime
37Ending Date-Time Searchdatetime
38Dimension Set ID Searchint
39Cost Amount (ACY) Searchdecimal(38,38)
40Unit Cost (ACY) Searchdecimal(38,38)
41Production BOM Version Code Searchnvarchar(40)
42Routing Version Code Searchnvarchar(40)
43Routing Type Searchint
44Qty_ per Unit of Measure Searchdecimal(38,38)
45MPS Order Searchtinyint
46Planning Flexibility Searchint
47Indirect Cost _ Searchdecimal(38,38)
48Overhead Rate Searchdecimal(38,38)
49$systemId Searchuniqueidentifier
50$systemCreatedAt Searchdatetime
51$systemCreatedBy Searchuniqueidentifier
52$systemModifiedAt Searchdatetime
53$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Prod_ Order Line table

Leave a Reply

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