Untracked Planning Element – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables UUntracked Planning Element

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

Table Type: Company

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

Table Number: 99000855

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Untracked Planning Element$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_]
   ,[Track Line No_]
   ,[Item No_]
   ,[Variant Code]
   ,[Location Code]
   ,[Source Type]
   ,[Source ID]
   ,[Parameter Value]
   ,[Untracked Quantity]
   ,[Track Quantity From]
   ,[Track Quantity To]
   ,[Source]
   ,[Warning Level]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Untracked Planning Element$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Untracked Planning Element]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Untracked Planning Element].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Untracked Planning Element].[Location Code] = [Location].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Untracked Planning Element].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Untracked Planning Element].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Untracked Planning Element table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Worksheet Template Name	Worksheet Template Name	Normal	Code	10	Worksheet Template Name	nvarchar(20)
2	Worksheet Batch Name	Worksheet Batch Name	Normal	Code	10	Worksheet Batch Name	nvarchar(20)
3	Worksheet Line No.	Worksheet Line No.	Normal	Integer	4	Worksheet Line No_	int
4	Track Line No.	Track Line No.	Normal	Integer	4	Track Line No_	int
11	Item No.	Item No.	Normal	Code	20	Item No_	nvarchar(40)
	Key to join to the Item table. Show/hide example query SELECT [Untracked Planning Element].[Item No_] ,[Item].[No_] FROM [CRONUS UK Ltd_$Untracked Planning Element$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Untracked Planning Element] LEFT JOIN [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] ON [Untracked Planning Element].[Item No_] = [Item].[No_]
12	Variant Code	Variant Code	Normal	Code	10	Variant Code	nvarchar(20)
	Key to join to the Item Variant table. Show/hide example query SELECT [Untracked Planning Element].[Variant Code] ,[Item Variant].[Code] FROM [CRONUS UK Ltd_$Untracked Planning Element$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Untracked Planning Element] LEFT JOIN [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant] ON [Untracked Planning Element].[Variant Code] = [Item Variant].[Code]
13	Location Code	Location Code	Normal	Code	10	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Untracked Planning Element].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Untracked Planning Element$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Untracked Planning Element] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Untracked Planning Element].[Location Code] = [Location].[Code]
21	Source Type	Source Type	Normal	Integer	4	Source Type	int
23	Source ID	Source ID	Normal	Code	20	Source ID	nvarchar(40)
70	Parameter Value	Parameter Value	Normal	Decimal	12	Parameter Value	decimal(38,38)
71	Untracked Quantity	Untracked Quantity	Normal	Decimal	12	Untracked Quantity	decimal(38,38)
72	Track Quantity From	Track Quantity From	Normal	Decimal	12	Track Quantity From	decimal(38,38)
73	Track Quantity To	Track Quantity To	Normal	Decimal	12	Track Quantity To	decimal(38,38)
74	Source	Source	Normal	Text	200	Source	nvarchar(400)
75	Warning Level	Warning Level	Normal	Option	4	Warning Level	int
	Available options are: “” “Emergency” “Exception” “Attention”
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Untracked Planning Element].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Untracked Planning Element$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Untracked Planning Element] LEFT JOIN [User] AS [User] ON [Untracked Planning Element].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Untracked Planning Element table

Location

Dynamics 365 BC Table Reference Tables Company Tables UUntracked Planning Element

Leave a Reply Cancel reply