Order Promising Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables OOrder Promising Line

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

Table Type: Company

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

Table Number: 99000880

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 Order Promising Line can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Order Promising Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Entry No_]
   ,[Item No_]
   ,[Variant Code]
   ,[Location Code]
   ,[Quantity]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Unavailable Quantity]
   ,[Quantity (Base)]
   ,[Unavailable Quantity (Base)]
   ,[Required Quantity (Base)]
   ,[Source Type]
   ,[Source Subtype]
   ,[Source ID]
   ,[Source Batch Name]
   ,[Source Line No_]
   ,[Description]
   ,[Required Quantity]
   ,[Requested Delivery Date]
   ,[Planned Delivery Date]
   ,[Original Shipment Date]
   ,[Earliest Shipment Date]
   ,[Requested Shipment Date]
   ,[Unavailability Date]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Order Promising Line table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Item No_	nvarchar(40)
	Key to join to the Item table. Show/hide example query SELECT [Order Promising Line].[Item No_] ,[Item].[No_] FROM [CRONUS UK Ltd_$Order Promising Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Order Promising Line] LEFT JOIN [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item] ON [Order Promising Line].[Item No_] = [Item].[No_]
4	Variant Code	nvarchar(20)
5	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Order Promising Line].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Order Promising Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Order Promising Line] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Order Promising Line].[Location Code] = [Location].[Code]
6	Quantity	decimal(38,38)
7	Unit of Measure Code	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Order Promising Line].[Unit of Measure Code] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Order Promising Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Order Promising Line] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Order Promising Line].[Unit of Measure Code] = [Unit of Measure].[Code]
8	Qty_ per Unit of Measure	decimal(38,38)
9	Unavailable Quantity	decimal(38,38)
10	Quantity (Base)	decimal(38,38)
11	Unavailable Quantity (Base)	decimal(38,38)
12	Required Quantity (Base)	decimal(38,38)
13	Source Type	int
14	Source Subtype	int
15	Source ID	nvarchar(40)
16	Source Batch Name	nvarchar(20)
17	Source Line No_	int
18	Description	nvarchar(200)
19	Required Quantity	decimal(38,38)
20	Requested Delivery Date	datetime
21	Planned Delivery Date	datetime
22	Original Shipment Date	datetime
23	Earliest Shipment Date	datetime
24	Requested Shipment Date	datetime
25	Unavailability Date	datetime
26	$systemId	uniqueidentifier
27	$systemCreatedAt	datetime
28	$systemCreatedBy	uniqueidentifier
29	$systemModifiedAt	datetime
30	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Order Promising Line table

Item Location Unit of Measure

Dynamics 365 BC Table Reference Tables Company Tables OOrder Promising Line

Leave a Reply Cancel reply