Prod_ Order Component

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

Table Type: Company

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

Table Number: 5407

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Prod_ Order Component$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Status]
   ,[Prod_ Order No_]
   ,[Prod_ Order Line No_]
   ,[Line No_]
   ,[Item No_]
   ,[Description]
   ,[Unit of Measure Code]
   ,[Quantity]
   ,[Position]
   ,[Position 2]
   ,[Position 3]
   ,[Lead-Time Offset]
   ,[Routing Link Code]
   ,[Scrap _]
   ,[Variant Code]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Expected Quantity]
   ,[Remaining Quantity]
   ,[Flushing Method]
   ,[Location Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Bin Code]
   ,[Supplied-by Line No_]
   ,[Planning Level Code]
   ,[Item Low-Level Code]
   ,[Length]
   ,[Width]
   ,[Weight]
   ,[Depth]
   ,[Calculation Formula]
   ,[Quantity per]
   ,[Unit Cost]
   ,[Cost Amount]
   ,[Due Date]
   ,[Due Time]
   ,[Qty_ per Unit of Measure]
   ,[Remaining Qty_ (Base)]
   ,[Quantity (Base)]
   ,[Expected Qty_ (Base)]
   ,[Due Date-Time]
   ,[Dimension Set ID]
   ,[Original Item No_]
   ,[Original Variant Code]
   ,[Qty_ Picked]
   ,[Qty_ Picked (Base)]
   ,[Completely Picked]
   ,[Direct Unit Cost]
   ,[Indirect Cost _]
   ,[Overhead Rate]
   ,[Direct Cost Amount]
   ,[Overhead Amount]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Prod_ Order Component$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 Component$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod_ Order Component]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Prod_ Order Component].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Prod_ Order Component].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Routing Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Link]
      ON
         [Prod_ Order Component].[Routing Link Code] = [Routing Link].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Prod_ Order Component].[Location Code] = [Location].[Code]

Show/hide columns in Prod_ Order Component table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Status Primary Key Searchint
3Prod_ Order No_ Primary Key Searchnvarchar(40)
4Prod_ Order Line No_ Primary Key Searchint
5Line No_ Primary Key Searchint
6Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Prod_ Order Component].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Prod_ Order Component$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod_ Order Component]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Prod_ Order Component].[Item No_] = [Item].[No_]
7Description Searchnvarchar(200)
8Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Prod_ Order Component].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Prod_ Order Component$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod_ Order Component]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Prod_ Order Component].[Unit of Measure Code] = [Unit of Measure].[Code]
9Quantity Searchdecimal(38,38)
10Position Searchnvarchar(20)
11Position 2 Searchnvarchar(20)
12Position 3 Searchnvarchar(20)
13Lead-Time Offset Searchvarchar(32)
14Routing Link Code Searchnvarchar(20)
Key to join to the Routing Link table.

Show/hide example query

SELECT
       [Prod_ Order Component].[Routing Link Code]
       ,[Routing Link].[Code]
FROM
       [CRONUS UK Ltd_$Prod_ Order Component$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod_ Order Component]
LEFT JOIN
       [CRONUS UK Ltd_$Routing Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Link]
              ON
                     [Prod_ Order Component].[Routing Link Code] = [Routing Link].[Code]
15Scrap _ Searchdecimal(38,38)
16Variant Code Searchnvarchar(20)
17Qty_ Rounding Precision Searchdecimal(38,38)
18Qty_ Rounding Precision (Base) Searchdecimal(38,38)
19Expected Quantity Searchdecimal(38,38)
20Remaining Quantity Searchdecimal(38,38)
21Flushing Method Searchint
22Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Prod_ Order Component].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Prod_ Order Component$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Prod_ Order Component]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Prod_ Order Component].[Location Code] = [Location].[Code]
23Shortcut Dimension 1 Code Searchnvarchar(40)
24Shortcut Dimension 2 Code Searchnvarchar(40)
25Bin Code Searchnvarchar(40)
26Supplied-by Line No_ Searchint
27Planning Level Code Searchint
28Item Low-Level Code Searchint
29Length Searchdecimal(38,38)
30Width Searchdecimal(38,38)
31Weight Searchdecimal(38,38)
32Depth Searchdecimal(38,38)
33Calculation Formula Searchint
34Quantity per Searchdecimal(38,38)
35Unit Cost Searchdecimal(38,38)
36Cost Amount Searchdecimal(38,38)
37Due Date Searchdatetime
38Due Time Searchdatetime
39Qty_ per Unit of Measure Searchdecimal(38,38)
40Remaining Qty_ (Base) Searchdecimal(38,38)
41Quantity (Base) Searchdecimal(38,38)
42Expected Qty_ (Base) Searchdecimal(38,38)
43Due Date-Time Searchdatetime
44Dimension Set ID Searchint
45Original Item No_ Searchnvarchar(40)
46Original Variant Code Searchnvarchar(20)
47Qty_ Picked Searchdecimal(38,38)
48Qty_ Picked (Base) Searchdecimal(38,38)
49Completely Picked Searchtinyint
50Direct Unit Cost Searchdecimal(38,38)
51Indirect Cost _ Searchdecimal(38,38)
52Overhead Rate Searchdecimal(38,38)
53Direct Cost Amount Searchdecimal(38,38)
54Overhead Amount Searchdecimal(38,38)
55$systemId Searchuniqueidentifier
56$systemCreatedAt Searchdatetime
57$systemCreatedBy Searchuniqueidentifier
58$systemModifiedAt Searchdatetime
59$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Prod_ Order Component table

Leave a Reply

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