Whse_ 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
   [timestamp]
   ,[Worksheet Template Name]
   ,[Name]
   ,[Location Code]
   ,[Line No_]
   ,[Source Type]
   ,[Source Subtype]
   ,[Source No_]
   ,[Source Line No_]
   ,[Source Subline No_]
   ,[Source Document]
   ,[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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Whse_ Worksheet Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Whse_ Worksheet Line].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Whse_ Worksheet Line].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
      ON
         [Whse_ Worksheet Line].[Shipping Agent Service Code] = [Shipping Agent Services].[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]

Show/hide columns in Whse_ Worksheet Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Worksheet Template Name Primary Key Searchnvarchar(20)
3Name Primary Key Searchnvarchar(20)
4Location Code Primary Key Searchnvarchar(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]
5Line No_ Primary Key Searchint
6Source Type Searchint
7Source Subtype Searchint
8Source No_ Searchnvarchar(40)
9Source Line No_ Searchint
10Source Subline No_ Searchint
11Source Document Searchint
12Shelf No_ Searchnvarchar(20)
13From Zone Code Searchnvarchar(20)
14From Bin Code Searchnvarchar(40)
15To Bin Code Searchnvarchar(40)
16To Zone Code Searchnvarchar(20)
17Item No_ Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Whse_ Worksheet Line].[Item No_] = [Item].[No_]
18Quantity Searchdecimal(38,38)
19Qty_ (Base) Searchdecimal(38,38)
20Qty_ Outstanding Searchdecimal(38,38)
21Qty_ Outstanding (Base) Searchdecimal(38,38)
22Qty_ to Handle Searchdecimal(38,38)
23Qty_ to Handle (Base) Searchdecimal(38,38)
24Qty_ Handled Searchdecimal(38,38)
25Qty_ Handled (Base) Searchdecimal(38,38)
26From Unit of Measure Code Searchnvarchar(20)
27Qty_ per From Unit of Measure Searchdecimal(38,38)
28Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Whse_ Worksheet Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Worksheet Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Whse_ Worksheet Line].[Unit of Measure Code] = [Unit of Measure].[Code]
29Qty_ per Unit of Measure Searchdecimal(38,38)
30Variant Code Searchnvarchar(20)
31Description Searchnvarchar(200)
32Description 2 Searchnvarchar(100)
33Sorting Sequence No_ Searchint
34Due Date Searchdatetime
35Destination Type Searchint
36Destination No_ Searchnvarchar(40)
37Shipping Agent Code Searchnvarchar(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] AS [Shipping Agent]
              ON
                     [Whse_ Worksheet Line].[Shipping Agent Code] = [Shipping Agent].[Code]
38Shipping Agent Service Code Searchnvarchar(20)
Key to join to the Shipping Agent Services table.

Show/hide example query

SELECT
       [Whse_ Worksheet Line].[Shipping Agent Service Code]
       ,[Shipping Agent Services].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Worksheet Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Worksheet Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
              ON
                     [Whse_ Worksheet Line].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
39Shipment Method Code Searchnvarchar(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]
40Shipping Advice Searchint
41Shipment Date Searchdatetime
42Whse_ Document Type Searchint
43Whse_ Document No_ Searchnvarchar(40)
44Whse_ Document Line No_ Searchint
45Qty_ Rounding Precision Searchdecimal(38,38)
46Qty_ Rounding Precision (Base) Searchdecimal(38,38)
47$systemId Searchuniqueidentifier
48$systemCreatedAt Searchdatetime
49$systemCreatedBy Searchuniqueidentifier
50$systemModifiedAt Searchdatetime
51$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Whse_ Worksheet Line table

Leave a Reply

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