Reservation Wksh. Line

Dynamics 365 BC Table ReferenceTablesCompany TablesRReservation Wksh. Line

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

Table Type: Company

Table Name: Reservation Wksh. Line
Database Table Name: CRONUS UK Ltd_$Reservation Wksh_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 346

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Journal Batch Name]
   ,[Line No_]
   ,[Source Type]
   ,[Source Subtype]
   ,[Source ID]
   ,[Source Batch Name]
   ,[Source Prod_ Order Line]
   ,[Source Ref_ No_]
   ,[Record ID]
   ,[Item No_]
   ,[Variant Code]
   ,[Location Code]
   ,[Sell-to Customer No_]
   ,[Sell-to Customer Name]
   ,[Description]
   ,[Description 2]
   ,[Demand Date]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Remaining Qty_ to Reserve]
   ,[Rem_ Qty_ to Reserve (Base)]
   ,[Qty_ to Reserve]
   ,[Qty_ to Reserve (Base)]
   ,[Available Qty_ to Reserve]
   ,[Avail_ Qty_ to Reserve (Base)]
   ,[Qty_ in Stock]
   ,[Qty_ in Stock (Base)]
   ,[Qty_ Reserved in Stock]
   ,[Qty_ Reserv_ in Stock (Base)]
   ,[Qty_ in Whse_ Handling]
   ,[Qty_ in Whse_ Handling (Base)]
   ,[Accept]
   ,[Serial No_]
   ,[Lot No_]
   ,[Package No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Reservation Wksh_ 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_$Reservation Wksh_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Wksh. Line]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Reservation Wksh. Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Reservation Wksh. Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Reservation Wksh. Line].[Sell-to Customer Name] = [Customer].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Reservation Wksh. Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Reservation Wksh. Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Reservation Wksh. Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Journal Batch Name Primary Key SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
10Source Type SearchSource TypeNormalInteger4Source Typeint
11Source Subtype SearchSource SubtypeNormalInteger4Source Subtypeint
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
17Record ID SearchRecord IDNormalRecordID448Record IDvarbinary(448)
21Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Reservation Wksh. Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Reservation Wksh_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Wksh. Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Reservation Wksh. Line].[Item No_] = [Item].[No_]
22Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Reservation Wksh. Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Reservation Wksh_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Wksh. Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Reservation Wksh. Line].[Variant Code] = [Item Variant].[Code]
23Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Reservation Wksh. Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Reservation Wksh_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Wksh. Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Reservation Wksh. Line].[Location Code] = [Location].[Code]
24Sell-to Customer No. SearchSell-to Customer No.NormalCode20Sell-to Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Reservation Wksh. Line].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Reservation Wksh_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Wksh. Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Reservation Wksh. Line].[Sell-to Customer No_] = [Customer].[No_]
25Sell-to Customer Name SearchSell-to Customer NameNormalText100Sell-to Customer Namenvarchar(200)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Reservation Wksh. Line].[Sell-to Customer Name]
       ,[Customer].[Name]
FROM
       [CRONUS UK Ltd_$Reservation Wksh_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Wksh. Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Reservation Wksh. Line].[Sell-to Customer Name] = [Customer].[Name]
29Description SearchDescriptionNormalText100Descriptionnvarchar(200)
30Description 2 SearchDescription 2NormalText100Description 2nvarchar(200)
31Demand Date SearchDemand DateNormalDate4Demand Datedatetime
32Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
33Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
41Remaining Qty. to Reserve SearchRemaining Qty. to ReserveNormalDecimal12Remaining Qty_ to Reservedecimal(38,38)
42Rem. Qty. to Reserve (Base) SearchRem. Qty. to Reserve (Base)NormalDecimal12Rem_ Qty_ to Reserve (Base)decimal(38,38)
43Qty. to Reserve SearchQty. to ReserveNormalDecimal12Qty_ to Reservedecimal(38,38)
44Qty. to Reserve (Base) SearchQty. to Reserve (Base)NormalDecimal12Qty_ to Reserve (Base)decimal(38,38)
51Available Qty. to Reserve SearchAvailable Qty. to ReserveNormalDecimal12Available Qty_ to Reservedecimal(38,38)
52Avail. Qty. to Reserve (Base) SearchAvail. Qty. to Reserve (Base)NormalDecimal12Avail_ Qty_ to Reserve (Base)decimal(38,38)
61Qty. in Stock SearchQty. in StockNormalDecimal12Qty_ in Stockdecimal(38,38)
62Qty. in Stock (Base) SearchQty. in Stock (Base)NormalDecimal12Qty_ in Stock (Base)decimal(38,38)
63Qty. Reserved in Stock SearchQty. Reserved from StockNormalDecimal12Qty_ Reserved in Stockdecimal(38,38)
64Qty. Reserv. in Stock (Base) SearchQty. Reserved from Stock (Base)NormalDecimal12Qty_ Reserv_ in Stock (Base)decimal(38,38)
65Qty. in Whse. Handling SearchQty. in Warehouse HandlingNormalDecimal12Qty_ in Whse_ Handlingdecimal(38,38)
66Qty. in Whse. Handling (Base) SearchQty. in Warehouse Handling (Base)NormalDecimal12Qty_ in Whse_ Handling (Base)decimal(38,38)
100Accept SearchAcceptNormalBoolean4Accepttinyint
6501Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
6502Lot No. SearchLot No.NormalCode50Lot No_nvarchar(100)
6503Package No. SearchPackage No.NormalCode50Package 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 Wksh. Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Reservation Wksh_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Wksh. Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Reservation Wksh. Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Reservation Wksh. Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Reservation Wksh_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reservation Wksh. Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Reservation Wksh. Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Reservation Wksh. Line table

LocationUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesRReservation Wksh. Line

Leave a Reply

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