Production Order

Dynamics 365 BC Table ReferenceTablesCompany TablesPProduction Order

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

Table Type: Company

Table Name: Production Order
Database Table Name: CRONUS UK Ltd_$Production Order$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5405

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Status]
   ,[No_]
   ,[Description]
   ,[Search Description]
   ,[Description 2]
   ,[Creation Date]
   ,[Last Date Modified]
   ,[Source Type]
   ,[Source No_]
   ,[Routing No_]
   ,[Variant Code]
   ,[Inventory Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Gen_ Bus_ Posting Group]
   ,[Starting Time]
   ,[Starting Date]
   ,[Ending Time]
   ,[Ending Date]
   ,[Due Date]
   ,[Finished Date]
   ,[Blocked]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Location Code]
   ,[Bin Code]
   ,[Replan Ref_ No_]
   ,[Replan Ref_ Status]
   ,[Low-Level Code]
   ,[Quantity]
   ,[Unit Cost]
   ,[Cost Amount]
   ,[No_ Series]
   ,[Planned Order No_]
   ,[Firm Planned Order No_]
   ,[Simulated Order No_]
   ,[Starting Date-Time]
   ,[Ending Date-Time]
   ,[Dimension Set ID]
   ,[Assigned User ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Production Order$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Order]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Production Order].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Production Order].[Inventory Posting Group] = [Inventory Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [Production Order].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Production Order].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Production Order].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Production Order].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Production Order].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
      ON
         [Production Order].[Work Center Filter] = [Work Center].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Production Order].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Production Order].[Assigned User ID] = [User Setup].[User ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Production Order].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Production Order].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Production Order table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Status Primary Key SearchStatusNormalOption4Statusint
Available options are:
  • “Simulated”
  • “Planned”
  • “Firm Planned”
  • “Released”
  • “Finished”
2No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
3Description SearchDescriptionNormalText100Descriptionnvarchar(200)
4Search Description SearchSearch DescriptionNormalCode100Search Descriptionnvarchar(200)
5Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
6Creation Date SearchCreation DateNormalDate4Creation Datedatetime
7Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
9Source Type SearchSource TypeNormalOption4Source Typeint
Available options are:
  • “Item”
  • “Family”
  • “Sales Header”
10Source No. SearchSource No.NormalCode20Source No_nvarchar(40)
11Routing No. SearchRouting No.NormalCode20Routing No_nvarchar(40)
Key to join to the Routing Header table.

Show/hide example query

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

Show/hide example query

SELECT
       [Production Order].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Production Order$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Order]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Production Order].[Variant Code] = [Item Variant].[Code]
15Inventory Posting Group SearchInventory Posting GroupNormalCode20Inventory Posting Groupnvarchar(40)
Key to join to the Inventory Posting Group table.

Show/hide example query

SELECT
       [Production Order].[Inventory Posting Group]
       ,[Inventory Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Production Order$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Order]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
              ON
                     [Production Order].[Inventory Posting Group] = [Inventory Posting Group].[Code]
16Gen. 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
       [Production Order].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Production Order$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Order]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Production Order].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
17Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Production Order].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Production Order$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Order]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Production Order].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
19Comment SearchCommentFlowFieldBoolean4
20Starting Time SearchStarting TimeNormalTime4Starting Timedatetime
21Starting Date SearchStarting DateNormalDate4Starting Datedatetime
22Ending Time SearchEnding TimeNormalTime4Ending Timedatetime
23Ending Date SearchEnding DateNormalDate4Ending Datedatetime
Key to join to the Inventory Period table.

Show/hide example query

SELECT
       [Production Order].[Ending Date]
       ,[Inventory Period].[Ending Date]
FROM
       [CRONUS UK Ltd_$Production Order$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Order]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
              ON
                     [Production Order].[Ending Date] = [Inventory Period].[Ending Date]
24Due Date SearchDue DateNormalDate4Due Datedatetime
25Finished Date SearchFinished DateNormalDate4Finished Datedatetime
28Blocked SearchBlockedNormalBoolean4Blockedtinyint
30Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Production Order].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Production Order$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Order]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Production Order].[Shortcut Dimension 1 Code] = [Dimension].[Code]
31Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Production Order].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Production Order$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Order]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Production Order].[Shortcut Dimension 2 Code] = [Dimension].[Code]
32Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Production Order].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Production Order$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Order]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Production Order].[Location Code] = [Location].[Code]
33Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Production Order].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Production Order$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Order]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Production Order].[Bin Code] = [Bin].[Code]
34Replan Ref. No. SearchReplan Ref. No.NormalCode20Replan Ref_ No_nvarchar(40)
35Replan Ref. Status SearchReplan Ref. StatusNormalOption4Replan Ref_ Statusint
Available options are:
  • “Simulated”
  • “Planned”
  • “Firm Planned”
  • “Released”
  • “Finished”
38Low-Level Code SearchLow-Level CodeNormalInteger4Low-Level Codeint
40Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
41Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
42Cost Amount SearchCost AmountNormalDecimal12Cost Amountdecimal(38,38)
47Work Center Filter SearchWork Center FilterFlowFilterCode20
48Capacity Type Filter SearchCapacity Type FilterFlowFilterOption4
49Capacity No. Filter SearchCapacity No. FilterFlowFilterCode20
50Date Filter SearchDate FilterFlowFilterDate4
51Expected Operation Cost Amt. SearchExpected Operation Cost Amt.FlowFieldDecimal12
52Expected Component Cost Amt. SearchExpected Component Cost Amt.FlowFieldDecimal12
55Actual Time Used SearchActual Time UsedFlowFieldDecimal12
56Allocated Capacity Need SearchAllocated Capacity NeedFlowFieldDecimal12
57Expected Capacity Need SearchExpected Capacity NeedFlowFieldDecimal12
80No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Production Order].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Production Order$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Order]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Production Order].[No_ Series] = [No. Series].[Code]
82Planned Order No. SearchPlanned Order No.NormalCode20Planned Order No_nvarchar(40)
83Firm Planned Order No. SearchFirm Planned Order No.NormalCode20Firm Planned Order No_nvarchar(40)
85Simulated Order No. SearchSimulated Order No.NormalCode20Simulated Order No_nvarchar(40)
92Expected Material Ovhd. Cost SearchExpected Material Ovhd. CostFlowFieldDecimal12
94Expected Capacity Ovhd. Cost SearchExpected Capacity Ovhd. CostFlowFieldDecimal12
98Starting Date-Time SearchStarting Date-TimeNormalDateTime8Starting Date-Timedatetime
99Ending 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
       [Production Order].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Production Order$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Order]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Production Order].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
7300Completely Picked SearchCompletely PickedFlowFieldBoolean4
9000Assigned User ID SearchAssigned User IDNormalCode50Assigned User IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
       [Production Order].[Assigned User ID]
       ,[User Setup].[User ID]
FROM
       [CRONUS UK Ltd_$Production Order$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Order]
LEFT JOIN
       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
              ON
                     [Production Order].[Assigned User ID] = [User Setup].[User ID]
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
       [Production Order].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Production Order$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Order]
LEFT JOIN
       [User] AS [User]
              ON
                     [Production Order].[$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
       [Production Order].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Production Order$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Order]
LEFT JOIN
       [User] AS [User]
              ON
                     [Production Order].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Production Order table

Location
Dynamics 365 BC Table ReferenceTablesCompany TablesPProduction Order

Leave a Reply

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