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

Show/hide columns in Planning Component table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Worksheet Template Name Primary Key Searchnvarchar(20)
3Worksheet Batch Name Primary Key Searchnvarchar(20)
4Worksheet 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
       [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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Planning 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
       [Planning Component].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Planning Component$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Planning Component]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Planning 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
       [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]
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)
20Flushing Method Searchint
21Location Code Searchnvarchar(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]
22Shortcut Dimension 1 Code Searchnvarchar(40)
23Shortcut Dimension 2 Code Searchnvarchar(40)
24Bin Code Searchnvarchar(40)
25Supplied-by Line No_ Searchint
26Planning Level Code Searchint
27Ref_ Order Status Searchint
28Ref_ Order No_ Searchnvarchar(40)
29Ref_ Order Line No_ Searchint
30Length Searchdecimal(38,38)
31Width Searchdecimal(38,38)
32Weight Searchdecimal(38,38)
33Depth Searchdecimal(38,38)
34Calculation Formula Searchint
35Quantity per Searchdecimal(38,38)
36Ref_ Order Type Searchint
37Unit Cost Searchdecimal(38,38)
38Cost Amount Searchdecimal(38,38)
39Due Date Searchdatetime
40Due Time Searchdatetime
41Direct Unit Cost Searchdecimal(38,38)
42Indirect Cost _ Searchdecimal(38,38)
43Overhead Rate Searchdecimal(38,38)
44Direct Cost Amount Searchdecimal(38,38)
45Overhead Amount Searchdecimal(38,38)
46Qty_ per Unit of Measure Searchdecimal(38,38)
47Quantity (Base) Searchdecimal(38,38)
48Expected Quantity (Base) Searchdecimal(38,38)
49Original Expected Qty_ (Base) Searchdecimal(38,38)
50Net Quantity (Base) Searchdecimal(38,38)
51Due Date-Time Searchdatetime
52Dimension Set ID Searchint
53Critical Searchtinyint
54Planning Line Origin Searchint
55$systemId Searchuniqueidentifier
56$systemCreatedAt Searchdatetime
57$systemCreatedBy Searchuniqueidentifier
58$systemModifiedAt Searchdatetime
59$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Planning Component table

Leave a Reply

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