Reservation 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 IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Positive Primary Key Searchtinyint
4Item No_ Searchnvarchar(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_]
5Location Code Searchnvarchar(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]
6Quantity (Base) Searchdecimal(38,38)
7Reservation Status Searchint
8Description Searchnvarchar(200)
9Creation Date Searchdatetime
10Transferred from Entry No_ Searchint
11Source Type Searchint
12Source Subtype Searchint
13Source ID Searchnvarchar(40)
14Source Batch Name Searchnvarchar(20)
15Source Prod_ Order Line Searchint
16Source Ref_ No_ Searchint
17Item Ledger Entry No_ Searchint
18Expected Receipt Date Searchdatetime
19Shipment Date Searchdatetime
20Serial No_ Searchnvarchar(100)
21Created By Searchnvarchar(100)
22Changed By Searchnvarchar(100)
23Qty_ per Unit of Measure Searchdecimal(38,38)
24Quantity Searchdecimal(38,38)
25Binding Searchint
26Suppressed Action Msg_ Searchtinyint
27Planning Flexibility Searchint
28Appl_-to Item Entry Searchint
29Warranty Date Searchdatetime
30Expiration Date Searchdatetime
31Qty_ to Handle (Base) Searchdecimal(38,38)
32Qty_ to Invoice (Base) Searchdecimal(38,38)
33Quantity Invoiced (Base) Searchdecimal(38,38)
34New Serial No_ Searchnvarchar(100)
35New Lot No_ Searchnvarchar(100)
36Disallow Cancellation Searchtinyint
37Lot No_ Searchnvarchar(100)
38Variant Code Searchnvarchar(20)
39Appl_-from Item Entry Searchint
40Correction Searchtinyint
41New Expiration Date Searchdatetime
42Item Tracking Searchint
43Untracked Surplus Searchtinyint
44Package No_ Searchnvarchar(100)
45New Package No_ Searchnvarchar(100)
46$systemId Searchuniqueidentifier
47$systemCreatedAt Searchdatetime
48$systemCreatedBy Searchuniqueidentifier
49$systemModifiedAt Searchdatetime
50$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Reservation Entry table

Leave a Reply

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