Reservation Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables RReservation Entry

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

Table Type: Company

Table Name: Reservation Entry
Database Table Name: CRONUS UK Ltd_$Reservation Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 337

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 Reservation Entry can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Reservation Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Entry No_]
   ,[Positive]
   ,[Item No_]
   ,[Location Code]
   ,[Quantity (Base)]
   ,[Reservation Status]
   ,[Description]
   ,[Creation Date]
   ,[Transferred from Entry No_]
   ,[Source Type]
   ,[Source Subtype]
   ,[Source ID]
   ,[Source Batch Name]
   ,[Source Prod_ Order Line]
   ,[Source Ref_ No_]
   ,[Item Ledger Entry No_]
   ,[Expected Receipt Date]
   ,[Shipment Date]
   ,[Serial No_]
   ,[Created By]
   ,[Changed By]
   ,[Qty_ per Unit of Measure]
   ,[Quantity]
   ,[Binding]
   ,[Suppressed Action Msg_]
   ,[Planning Flexibility]
   ,[Appl_-to Item Entry]
   ,[Warranty Date]
   ,[Expiration Date]
   ,[Qty_ to Handle (Base)]
   ,[Qty_ to Invoice (Base)]
   ,[Quantity Invoiced (Base)]
   ,[New Serial No_]
   ,[New Lot No_]
   ,[Disallow Cancellation]
   ,[Lot No_]
   ,[Variant Code]
   ,[Appl_-from Item Entry]
   ,[Correction]
   ,[New Expiration Date]
   ,[Item Tracking]
   ,[Untracked Surplus]
   ,[Package No_]
   ,[New Package No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Reservation Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

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

Show/hide columns in Reservation Entry table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Positive	tinyint
4	Item No_	nvarchar(40)
	Key to join to the Item table. Show/hide example query SELECT [Reservation Entry].[Item No_] ,[Item].[No_] FROM [CRONUS UK Ltd_$Reservation Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Entry] LEFT JOIN [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item] ON [Reservation Entry].[Item No_] = [Item].[No_]
5	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Reservation Entry].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Reservation Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Entry] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Reservation Entry].[Location Code] = [Location].[Code]
6	Quantity (Base)	decimal(38,38)
7	Reservation Status	int
8	Description	nvarchar(200)
9	Creation Date	datetime
10	Transferred from Entry No_	int
11	Source Type	int
12	Source Subtype	int
13	Source ID	nvarchar(40)
14	Source Batch Name	nvarchar(20)
15	Source Prod_ Order Line	int
16	Source Ref_ No_	int
17	Item Ledger Entry No_	int
18	Expected Receipt Date	datetime
19	Shipment Date	datetime
20	Serial No_	nvarchar(100)
21	Created By	nvarchar(100)
22	Changed By	nvarchar(100)
23	Qty_ per Unit of Measure	decimal(38,38)
24	Quantity	decimal(38,38)
25	Binding	int
26	Suppressed Action Msg_	tinyint
27	Planning Flexibility	int
28	Appl_-to Item Entry	int
29	Warranty Date	datetime
30	Expiration Date	datetime
31	Qty_ to Handle (Base)	decimal(38,38)
32	Qty_ to Invoice (Base)	decimal(38,38)
33	Quantity Invoiced (Base)	decimal(38,38)
34	New Serial No_	nvarchar(100)
35	New Lot No_	nvarchar(100)
36	Disallow Cancellation	tinyint
37	Lot No_	nvarchar(100)
38	Variant Code	nvarchar(20)
39	Appl_-from Item Entry	int
40	Correction	tinyint
41	New Expiration Date	datetime
42	Item Tracking	int
43	Untracked Surplus	tinyint
44	Package No_	nvarchar(100)
45	New Package No_	nvarchar(100)
46	$systemId	uniqueidentifier
47	$systemCreatedAt	datetime
48	$systemCreatedBy	uniqueidentifier
49	$systemModifiedAt	datetime
50	$systemModifiedBy	uniqueidentifier