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

Show/hide columns in Untracked Planning Element 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
5Track Line No_ Primary Key Searchint
6Item No_ Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Untracked Planning Element].[Item No_] = [Item].[No_]
7Variant Code Searchnvarchar(20)
8Location Code Searchnvarchar(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]
9Source Type Searchint
10Source ID Searchnvarchar(40)
11Parameter Value Searchdecimal(38,38)
12Untracked Quantity Searchdecimal(38,38)
13Track Quantity From Searchdecimal(38,38)
14Track Quantity To Searchdecimal(38,38)
15Source Searchnvarchar(400)
16Warning Level Searchint
17$systemId Searchuniqueidentifier
18$systemCreatedAt Searchdatetime
19$systemCreatedBy Searchuniqueidentifier
20$systemModifiedAt Searchdatetime
21$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Untracked Planning Element table

Leave a Reply

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