Planning Component

Dynamics 365 BC Table ReferenceTablesCompany TablesPPlanning Component

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

Table Type: Company

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

Table Number: 99000829

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Worksheet Template Name]
   ,[Worksheet Batch Name]
   ,[Worksheet 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]
   ,[Flushing Method]
   ,[Location Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Bin Code]
   ,[Supplied-by Line No_]
   ,[Planning Level Code]
   ,[Ref_ Order Status]
   ,[Ref_ Order No_]
   ,[Ref_ Order Line No_]
   ,[Length]
   ,[Width]
   ,[Weight]
   ,[Depth]
   ,[Calculation Formula]
   ,[Quantity per]
   ,[Ref_ Order Type]
   ,[Unit Cost]
   ,[Cost Amount]
   ,[Due Date]
   ,[Due Time]
   ,[Direct Unit Cost]
   ,[Indirect Cost _]
   ,[Overhead Rate]
   ,[Direct Cost Amount]
   ,[Overhead Amount]
   ,[Qty_ per Unit of Measure]
   ,[Quantity (Base)]
   ,[Expected Quantity (Base)]
   ,[Original Expected Qty_ (Base)]
   ,[Net Quantity (Base)]
   ,[Due Date-Time]
   ,[Dimension Set ID]
   ,[Critical]
   ,[Planning Line Origin]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Planning 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_$Planning Component$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Planning Component]
LEFT JOIN
   [CRONUS UK Ltd_$Routing Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Link]
      ON
         [Planning Component].[Routing Link Code] = [Routing Link].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Planning Component].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Planning Component].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Planning Component].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Planning Component].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Planning Component].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Planning Component].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Planning Component].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Planning Component].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Planning Component table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Worksheet Template Name Primary Key SearchWorksheet Template NameNormalCode10Worksheet Template Namenvarchar(20)
2Worksheet Batch Name Primary Key SearchWorksheet Batch NameNormalCode10Worksheet Batch Namenvarchar(20)
3Worksheet Line No. Primary Key SearchWorksheet Line No.NormalInteger4Worksheet Line No_int
5Line 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
       [Planning Component].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Planning Component$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Planning Component]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Planning Component].[Item No_] = [Item].[No_]
12Description SearchDescriptionNormalText100Descriptionnvarchar(200)
13Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
14Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
15Position SearchPositionNormalCode10Positionnvarchar(20)
16Position 2 SearchPosition 2NormalCode10Position 2nvarchar(20)
17Position 3 SearchPosition 3NormalCode10Position 3nvarchar(20)
18Lead-Time Offset SearchLead-Time OffsetNormalDateFormula32Lead-Time Offsetvarchar(32)
19Routing Link Code SearchRouting Link CodeNormalCode10Routing Link Codenvarchar(20)
Key to join to the Routing Link table.

Show/hide example query

SELECT
       [Planning Component].[Routing Link Code]
       ,[Routing Link].[Code]
FROM
       [CRONUS UK Ltd_$Planning Component$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Planning Component]
LEFT JOIN
       [CRONUS UK Ltd_$Routing Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Link]
              ON
                     [Planning Component].[Routing Link Code] = [Routing Link].[Code]
20Scrap % SearchScrap %NormalDecimal12Scrap _decimal(38,38)
21Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Planning Component].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Planning Component$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Planning Component]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Planning Component].[Variant Code] = [Item Variant].[Code]
22Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
23Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
25Expected Quantity SearchExpected QuantityNormalDecimal12Expected Quantitydecimal(38,38)
28Flushing Method SearchFlushing MethodNormalOption4Flushing Methodint
Available options are:
  • “Manual”
  • “Forward”
  • “Backward”
  • “Pick + Forward”
  • “Pick + Backward”
30Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Planning Component].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Planning Component$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Planning Component]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Planning Component].[Bin Code] = [Bin].[Code]
35Supplied-by Line No. SearchSupplied-by Line No.NormalInteger4Supplied-by Line No_int
36Planning Level Code SearchPlanning Level CodeNormalInteger4Planning Level Codeint
37Ref. Order Status SearchRef. Order StatusNormalOption4Ref_ Order Statusint
Available options are:
  • “Simulated”
  • “Planned”
  • “Firm Planned”
  • “Released”
  • “Finished”
38Ref. Order No. SearchRef. Order No.NormalCode20Ref_ Order No_nvarchar(40)
39Ref. Order Line No. SearchRef. Order Line No.NormalInteger4Ref_ Order Line No_int
40Length SearchLengthNormalDecimal12Lengthdecimal(38,38)
41Width SearchWidthNormalDecimal12Widthdecimal(38,38)
42Weight SearchWeightNormalDecimal12Weightdecimal(38,38)
43Depth SearchDepthNormalDecimal12Depthdecimal(38,38)
44Calculation Formula SearchCalculation FormulaNormalOption4Calculation Formulaint
Available options are:
  • ” “
  • “Length”
  • “Length * Width”
  • “Length * Width * Depth”
  • “Weight”
  • “Fixed Quantity”
45Quantity per SearchQuantity perNormalDecimal12Quantity perdecimal(38,38)
46Ref. Order Type SearchRef. Order TypeNormalOption4Ref_ Order Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Prod. Order”
  • “Transfer”
  • “Assembly”
50Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
51Cost Amount SearchCost AmountNormalDecimal12Cost Amountdecimal(38,38)
52Due Date SearchDue DateNormalDate4Due Datedatetime
53Due Time SearchDue TimeNormalTime4Due Timedatetime
55Direct Unit Cost SearchDirect Unit CostNormalDecimal12Direct Unit Costdecimal(38,38)
56Indirect Cost % SearchIndirect Cost %NormalDecimal12Indirect Cost _decimal(38,38)
57Overhead Rate SearchOverhead RateNormalDecimal12Overhead Ratedecimal(38,38)
58Direct Cost Amount SearchDirect Cost AmountNormalDecimal12Direct Cost Amountdecimal(38,38)
59Overhead Amount SearchOverhead AmountNormalDecimal12Overhead Amountdecimal(38,38)
60Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
62Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
63Reserved Qty. (Base) SearchReserved Qty. (Base)FlowFieldDecimal12
71Reserved Quantity SearchReserved QuantityFlowFieldDecimal12
73Expected Quantity (Base) SearchExpected Quantity (Base)NormalDecimal12Expected Quantity (Base)decimal(38,38)
74Original Expected Qty. (Base) SearchOriginal Expected Qty. (Base)NormalDecimal12Original Expected Qty_ (Base)decimal(38,38)
75Net Quantity (Base) SearchNet Quantity (Base)NormalDecimal12Net Quantity (Base)decimal(38,38)
76Due Date-Time SearchDue Date-TimeNormalDateTime8Due Date-Timedatetime
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Planning Component].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Planning Component$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Planning Component]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Planning Component].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
99000875Critical SearchCriticalNormalBoolean4Criticaltinyint
99000915Planning Line Origin SearchPlanning Line OriginNormalOption4Planning Line Originint
Available options are:
  • ” “
  • “Action Message”
  • “Planning”
  • “Order Planning”
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
       [Planning Component].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Planning Component$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Planning Component]
LEFT JOIN
       [User] AS [User]
              ON
                     [Planning Component].[$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
       [Planning Component].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Planning Component$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Planning Component]
LEFT JOIN
       [User] AS [User]
              ON
                     [Planning Component].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Planning Component table

LocationRouting LinkUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesPPlanning Component

Leave a Reply

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