Sales Planning Line

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

Table Type: Company

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

Table Number: 99000800

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Sales Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Sales Order No_]
   ,[Sales Order Line No_]
   ,[Item No_]
   ,[Description]
   ,[Shipment Date]
   ,[Available]
   ,[Next Planning Date]
   ,[Expected Delivery Date]
   ,[Planning Status]
   ,[Needs Replanning]
   ,[Variant Code]
   ,[Planned Quantity]
   ,[Low-Level Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Sales Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Sales Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Planning Line]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Sales Planning Line].[Item No_] = [Item].[No_]

Show/hide columns in Sales Planning Line table

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

Show/hide example query

SELECT
       [Sales Planning Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Sales Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Planning Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Sales Planning Line].[Item No_] = [Item].[No_]
5Description Searchnvarchar(200)
6Shipment Date Searchdatetime
7Available Searchdecimal(38,38)
8Next Planning Date Searchdatetime
9Expected Delivery Date Searchdatetime
10Planning Status Searchint
11Needs Replanning Searchtinyint
12Variant Code Searchnvarchar(20)
13Planned Quantity Searchdecimal(38,38)
14Low-Level Code Searchint
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Sales Planning Line table

Leave a Reply

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