Reservation Entry

Dynamics 365 BC Table ReferenceTablesCompany TablesRReservation 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

   [Entry No_]
   ,[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]
   ,[Positive]
   ,[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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Reservation Entry].[Location Code] = [Location].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Reservation Entry].[Created By] = [User].[User Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Reservation Entry].[Changed By] = [User].[User Name]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Reservation Entry].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Reservation Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Reservation Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Reservation Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. SearchEntry No.NormalInteger4Entry No_int
2Item No. Primary Key SearchItem No.NormalCode20Item 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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
	              ON
	                     [Reservation Entry].[Item No_] = [Item].[No_]
3Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
4Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
5Reservation Status SearchReservation StatusNormalOption4Reservation Statusint
Available options are:
  • “Reservation”
  • “Tracking”
  • “Surplus”
  • “Prospect”
7Description SearchDescriptionNormalText100Descriptionnvarchar(200)
8Creation Date SearchCreation DateNormalDate4Creation Datedatetime
9Transferred from Entry No. SearchTransferred from Entry No.NormalInteger4Transferred from Entry No_int
10Source Type SearchSource TypeNormalInteger4Source Typeint
11Source Subtype SearchSource SubtypeNormalOption4Source Subtypeint
Available options are:
  • “0”
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
  • “7”
  • “8”
  • “9”
  • “10”
12Source ID SearchSource IDNormalCode20Source IDnvarchar(40)
13Source Batch Name SearchSource Batch NameNormalCode10Source Batch Namenvarchar(20)
14Source Prod. Order Line SearchSource Prod. Order LineNormalInteger4Source Prod_ Order Lineint
15Source Ref. No. SearchSource Ref. No.NormalInteger4Source Ref_ No_int
16Item Ledger Entry No. SearchItem Ledger Entry No.NormalInteger4Item Ledger Entry No_int
Key to join to the Item Ledger Entry table.

Show/hide example query

SELECT
	       [Reservation Entry].[Item Ledger Entry No_]
	       ,[Item Ledger Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Reservation Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
	              ON
	                     [Reservation Entry].[Item Ledger Entry No_] = [Item Ledger Entry].[Entry No_]
22Expected Receipt Date SearchExpected Receipt DateNormalDate4Expected Receipt Datedatetime
23Shipment Date SearchShipment DateNormalDate4Shipment Datedatetime
24Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
25Created By SearchCreated ByNormalCode50Created Bynvarchar(100)
Key to join to the User table.

Show/hide example query

SELECT
	       [Reservation Entry].[Created By]
	       ,[User].[User Name]
	FROM
	       [CRONUS UK Ltd_$Reservation Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Entry]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Reservation Entry].[Created By] = [User].[User Name]
27Changed By SearchChanged ByNormalCode50Changed Bynvarchar(100)
Key to join to the User table.

Show/hide example query

SELECT
	       [Reservation Entry].[Changed By]
	       ,[User].[User Name]
	FROM
	       [CRONUS UK Ltd_$Reservation Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Entry]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Reservation Entry].[Changed By] = [User].[User Name]
28Positive SearchPositiveNormalBoolean4Positivetinyint
29Qty. per Unit of Measure Primary Key SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
30Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
31Action Message Adjustment SearchAction Message AdjustmentFlowFieldDecimal12
32Binding SearchBindingNormalOption4Bindingint
Available options are:
  • ” “
  • “Order-to-Order”
33Suppressed Action Msg. SearchSuppressed Action Msg.NormalBoolean4Suppressed Action Msg_tinyint
34Planning Flexibility SearchPlanning FlexibilityNormalOption4Planning Flexibilityint
Available options are:
  • “Unlimited”
  • “None”
38Appl.-to Item Entry SearchAppl.-to Item EntryNormalInteger4Appl_-to Item Entryint
40Warranty Date SearchWarranty DateNormalDate4Warranty Datedatetime
41Expiration Date SearchExpiration DateNormalDate4Expiration Datedatetime
50Qty. to Handle (Base) SearchQty. to Handle (Base)NormalDecimal12Qty_ to Handle (Base)decimal(38,38)
51Qty. to Invoice (Base) SearchQty. to Invoice (Base)NormalDecimal12Qty_ to Invoice (Base)decimal(38,38)
53Quantity Invoiced (Base) SearchQuantity Invoiced (Base)NormalDecimal12Quantity Invoiced (Base)decimal(38,38)
80New Serial No. SearchNew Serial No.NormalCode50New Serial No_nvarchar(100)
81New Lot No. SearchNew Lot No.NormalCode50New Lot No_nvarchar(100)
900Disallow Cancellation SearchDisallow CancelationNormalBoolean4Disallow Cancellationtinyint
5400Lot No. SearchLot No.NormalCode50Lot No_nvarchar(100)
5401Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
	       [Reservation Entry].[Variant Code]
	       ,[Item Variant].[Code]
	FROM
	       [CRONUS UK Ltd_$Reservation Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Entry]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
	              ON
	                     [Reservation Entry].[Variant Code] = [Item Variant].[Code]
5811Appl.-from Item Entry SearchAppl.-from Item EntryNormalInteger4Appl_-from Item Entryint
5817Correction SearchCorrectionNormalBoolean4Correctiontinyint
6505New Expiration Date SearchNew Expiration DateNormalDate4New Expiration Datedatetime
6510Item Tracking SearchItem TrackingNormalOption4Item Trackingint
Available options are:
  • “None”
  • “Lot No.”
  • “Lot and Serial No.”
  • “Serial No.”
  • “Package No.”
  • “Lot and Package No.”
  • “Serial and Package No.”
  • “Lot and Serial and Package No.”
6511Untracked Surplus SearchUntracked SurplusNormalBoolean4Untracked Surplustinyint
6515Package No. SearchPackage No.NormalCode50Package No_nvarchar(100)
6516New Package No. SearchNew Package No.NormalCode50New Package No_nvarchar(100)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [Reservation Entry].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Reservation Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Entry]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Reservation Entry].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Reservation Entry table

Location
Dynamics 365 BC Table ReferenceTablesCompany TablesRReservation Entry

Leave a Reply

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