Whse. Worksheet Line

Dynamics 365 BC Table ReferenceTablesCompany TablesWWhse. Worksheet Line

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

Table Type: Company

Table Name: Whse. Worksheet Line
Database Table Name: CRONUS UK Ltd_$Whse_ Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 7326

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Worksheet Template Name]
   ,[Name]
   ,[Line No_]
   ,[Source Type]
   ,[Source Subtype]
   ,[Source No_]
   ,[Source Line No_]
   ,[Source Subline No_]
   ,[Source Document]
   ,[Location Code]
   ,[Shelf No_]
   ,[From Zone Code]
   ,[From Bin Code]
   ,[To Bin Code]
   ,[To Zone Code]
   ,[Item No_]
   ,[Quantity]
   ,[Qty_ (Base)]
   ,[Qty_ Outstanding]
   ,[Qty_ Outstanding (Base)]
   ,[Qty_ to Handle]
   ,[Qty_ to Handle (Base)]
   ,[Qty_ Handled]
   ,[Qty_ Handled (Base)]
   ,[From Unit of Measure Code]
   ,[Qty_ per From Unit of Measure]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Variant Code]
   ,[Description]
   ,[Description 2]
   ,[Sorting Sequence No_]
   ,[Due Date]
   ,[Destination Type]
   ,[Destination No_]
   ,[Shipping Agent Code]
   ,[Shipping Agent Service Code]
   ,[Shipment Method Code]
   ,[Shipping Advice]
   ,[Shipment Date]
   ,[Whse_ Document Type]
   ,[Whse_ Document No_]
   ,[Whse_ Document Line No_]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Whse_ Worksheet 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_$Whse_ Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Worksheet Line]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Whse. Worksheet Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Whse. Worksheet Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
      ON
         [Whse. Worksheet Line].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Whse. Worksheet Line].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Whse. Worksheet Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Whse. Worksheet Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Whse. Worksheet Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Worksheet Template Name Primary Key SearchWorksheet Template NameNormalCode10Worksheet Template Namenvarchar(20)
2Name Primary Key SearchNameNormalCode10Namenvarchar(20)
3Line No. Primary Key SearchLine No.NormalInteger4Line No_int
4Source Type SearchSource TypeNormalInteger4Source Typeint
5Source Subtype SearchSource SubtypeNormalOption4Source Subtypeint
Available options are:
  • “0”
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
  • “7”
  • “8”
  • “9”
  • “10”
6Source No. SearchSource No.NormalCode20Source No_nvarchar(40)
7Source Line No. SearchSource Line No.NormalInteger4Source Line No_int
8Source Subline No. SearchSource Subline No.NormalInteger4Source Subline No_int
9Source Document SearchSource DocumentNormalOption4Source Documentint
Available options are:
  • ” “
  • “Sales Order”
  • “Sales Return Order”
  • “Purchase Order”
  • “Purchase Return Order”
  • “Inbound Transfer”
  • “Outbound Transfer”
  • “Prod. Consumption”
  • “Prod. Output”
  • “Service Order”
  • “Assembly Consumption”
  • “Assembly Order”
  • “Job Usage”
10Location Code Primary Key SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Whse. Worksheet Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Worksheet Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Whse. Worksheet Line].[Location Code] = [Location].[Code]
11Shelf No. SearchShelf No.NormalCode10Shelf No_nvarchar(20)
12From Zone Code SearchFrom Zone CodeNormalCode10From Zone Codenvarchar(20)
13From Bin Code SearchFrom Bin CodeNormalCode20From Bin Codenvarchar(40)
14To Bin Code SearchTo Bin CodeNormalCode20To Bin Codenvarchar(40)
15To Zone Code SearchTo Zone CodeNormalCode10To Zone Codenvarchar(20)
16Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Whse. Worksheet Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Whse_ Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Worksheet Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Whse. Worksheet Line].[Item No_] = [Item].[No_]
17Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
18Qty. (Base) SearchQty. (Base)NormalDecimal12Qty_ (Base)decimal(38,38)
19Qty. Outstanding SearchQty. OutstandingNormalDecimal12Qty_ Outstandingdecimal(38,38)
20Qty. Outstanding (Base) SearchQty. Outstanding (Base)NormalDecimal12Qty_ Outstanding (Base)decimal(38,38)
21Qty. to Handle SearchQty. to HandleNormalDecimal12Qty_ to Handledecimal(38,38)
22Qty. to Handle (Base) SearchQty. to Handle (Base)NormalDecimal12Qty_ to Handle (Base)decimal(38,38)
23Qty. Handled SearchQty. HandledNormalDecimal12Qty_ Handleddecimal(38,38)
24Qty. Handled (Base) SearchQty. Handled (Base)NormalDecimal12Qty_ Handled (Base)decimal(38,38)
27From Unit of Measure Code SearchFrom Unit of Measure CodeNormalCode10From Unit of Measure Codenvarchar(20)
28Qty. per From Unit of Measure SearchQty. per From Unit of MeasureNormalDecimal12Qty_ per From Unit of Measuredecimal(38,38)
29Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
30Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
31Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Whse. Worksheet Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Worksheet Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Whse. Worksheet Line].[Variant Code] = [Item Variant].[Code]
32Description SearchDescriptionNormalText100Descriptionnvarchar(200)
33Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
35Sorting Sequence No. SearchSorting Sequence No.NormalInteger4Sorting Sequence No_int
36Due Date SearchDue DateNormalDate4Due Datedatetime
39Destination Type SearchDestination TypeNormalOption4Destination Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Location”
  • “Item”
  • “Family”
  • “Sales Order”
40Destination No. SearchDestination No.NormalCode20Destination No_nvarchar(40)
41Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
       [Whse. Worksheet Line].[Shipping Agent Code]
       ,[Shipping Agent].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Worksheet Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
              ON
                     [Whse. Worksheet Line].[Shipping Agent Code] = [Shipping Agent].[Code]
42Shipping Agent Service Code SearchShipping Agent Service CodeNormalCode10Shipping Agent Service Codenvarchar(20)
43Shipment Method Code SearchShipment Method CodeNormalCode10Shipment Method Codenvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Whse. Worksheet Line].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Worksheet Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Whse. Worksheet Line].[Shipment Method Code] = [Shipment Method].[Code]
44Shipping Advice SearchShipping AdviceNormalOption4Shipping Adviceint
Available options are:
  • “Partial”
  • “Complete”
45Shipment Date SearchShipment DateNormalDate4Shipment Datedatetime
46Whse. Document Type SearchWhse. Document TypeNormalOption4Whse_ Document Typeint
Available options are:
  • ” “
  • “Receipt”
  • “Shipment”
  • “Internal Put-away”
  • “Internal Pick”
  • “Production”
  • “Whse. Mov.-Worksheet”
  • “Internal Movement”
  • “Assembly”
  • “Job”
47Whse. Document No. SearchWhse. Document No.NormalCode20Whse_ Document No_nvarchar(40)
48Whse. Document Line No. SearchWhse. Document Line No.NormalInteger4Whse_ Document Line No_int
50Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
51Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
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
       [Whse. Worksheet Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Whse_ Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Worksheet Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Whse. Worksheet 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
       [Whse. Worksheet Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Whse_ Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Worksheet Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Whse. Worksheet Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Whse. Worksheet Line table

LocationShipment MethodShipping AgentShipping Agent ServicesUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesWWhse. Worksheet Line

Leave a Reply

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