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
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
[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 Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
ON
[Sales Planning Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
[User] AS [User]
ON
[Sales Planning Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Sales Planning Line].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Sales Planning Line table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Sales Order No.   | Sales Order No. | Normal | Code | 20 | Sales Order No_ | nvarchar(40) |
| 2 | Sales Order Line No. | Sales Order Line No. | Normal | Integer | 4 | Sales Order Line No_ | int |
| 3 | Item No. | Item No. | Normal | Code | 20 | Item No_ | nvarchar(40) |
Key to join to the Item table.Show/hide example querySELECT
[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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
ON
[Sales Planning Line].[Item No_] = [Item].[No_] | |||||||
| 4 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
| 5 | Shipment Date | Shipment Date | Normal | Date | 4 | Shipment Date | datetime |
| 6 | Available | Available | Normal | Decimal | 12 | Available | decimal(38,38) |
| 7 | Next Planning Date | Next Planning Date | Normal | Date | 4 | Next Planning Date | datetime |
| 8 | Expected Delivery Date | Expected Delivery Date | Normal | Date | 4 | Expected Delivery Date | datetime |
| 9 | Planning Status | Planning Status | Normal | Option | 4 | Planning Status | int |
Available options are:
| |||||||
| 10 | Needs Replanning | Needs Replanning | Normal | Boolean | 4 | Needs Replanning | tinyint |
| 11 | Variant Code | Variant Code | Normal | Code | 10 | Variant Code | nvarchar(20) |
Key to join to the Item Variant table.Show/hide example querySELECT
[Sales Planning Line].[Variant Code]
,[Item Variant].[Code]
FROM
[CRONUS UK Ltd_$Sales Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Planning Line]
LEFT JOIN
[CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
ON
[Sales Planning Line].[Variant Code] = [Item Variant].[Code] | |||||||
| 12 | Planned Quantity | Planned Quantity | Normal | Decimal | 12 | Planned Quantity | decimal(38,38) |
| 15 | Low-Level Code | Low-Level Code | Normal | Integer | 4 | Low-Level Code | int |
| 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 querySELECT
[Sales Planning Line].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Sales Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Planning Line]
LEFT JOIN
[User] AS [User]
ON
[Sales Planning Line].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Sales Planning Line].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Sales Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Planning Line]
LEFT JOIN
[User] AS [User]
ON
[Sales Planning Line].[$systemModifiedBy] = [User].[User Security ID] | |||||||