Warehouse Activity Line

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

Table Type: Company

Table Name: Warehouse Activity Line
Database Table Name: CRONUS UK Ltd_$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5767

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Activity Type]
   ,[No_]
   ,[Line No_]
   ,[Source Type]
   ,[Source Subtype]
   ,[Source No_]
   ,[Source Line No_]
   ,[Source Subline No_]
   ,[Source Document]
   ,[Location Code]
   ,[Shelf No_]
   ,[Sorting Sequence No_]
   ,[Item No_]
   ,[Variant Code]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Description]
   ,[Description 2]
   ,[Quantity]
   ,[Qty_ (Base)]
   ,[Qty_ Outstanding]
   ,[Qty_ Outstanding (Base)]
   ,[Qty_ to Handle]
   ,[Qty_ to Handle (Base)]
   ,[Qty_ Handled]
   ,[Qty_ Handled (Base)]
   ,[Shipping Advice]
   ,[Due Date]
   ,[Destination Type]
   ,[Destination No_]
   ,[Shipping Agent Code]
   ,[Shipping Agent Service Code]
   ,[Shipment Method Code]
   ,[Starting Date]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Assemble to Order]
   ,[ATO Component]
   ,[Serial No_]
   ,[Lot No_]
   ,[Warranty Date]
   ,[Expiration Date]
   ,[Package No_]
   ,[Bin Code]
   ,[Zone Code]
   ,[Action Type]
   ,[Whse_ Document Type]
   ,[Whse_ Document No_]
   ,[Whse_ Document Line No_]
   ,[Bin Ranking]
   ,[Cubage]
   ,[Weight]
   ,[Special Equipment Code]
   ,[Bin Type Code]
   ,[Breakbulk No_]
   ,[Original Breakbulk]
   ,[Breakbulk]
   ,[Cross-Dock Information]
   ,[Dedicated]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Warehouse Activity 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_$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Activity Line]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Warehouse Activity Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Warehouse Activity Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Warehouse Activity 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
         [Warehouse Activity 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
         [Warehouse Activity 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
         [Warehouse Activity Line].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Special Equipment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Special Equipment]
      ON
         [Warehouse Activity Line].[Special Equipment Code] = [Special Equipment].[Code]

Show/hide columns in Warehouse Activity Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Activity Type Primary Key Searchint
3No_ Primary Key Searchnvarchar(40)
4Line No_ Primary Key Searchint
5Source Type Searchint
6Source Subtype Searchint
7Source No_ Searchnvarchar(40)
8Source Line No_ Searchint
9Source Subline No_ Searchint
10Source Document Searchint
11Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Warehouse Activity Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Activity Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Warehouse Activity Line].[Location Code] = [Location].[Code]
12Shelf No_ Searchnvarchar(20)
13Sorting Sequence No_ Searchint
14Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Warehouse Activity Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Activity Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Warehouse Activity Line].[Item No_] = [Item].[No_]
15Variant Code Searchnvarchar(20)
16Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Warehouse Activity Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Activity Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Warehouse Activity Line].[Unit of Measure Code] = [Unit of Measure].[Code]
17Qty_ per Unit of Measure Searchdecimal(38,38)
18Description Searchnvarchar(200)
19Description 2 Searchnvarchar(100)
20Quantity Searchdecimal(38,38)
21Qty_ (Base) Searchdecimal(38,38)
22Qty_ Outstanding Searchdecimal(38,38)
23Qty_ Outstanding (Base) Searchdecimal(38,38)
24Qty_ to Handle Searchdecimal(38,38)
25Qty_ to Handle (Base) Searchdecimal(38,38)
26Qty_ Handled Searchdecimal(38,38)
27Qty_ Handled (Base) Searchdecimal(38,38)
28Shipping Advice Searchint
29Due Date Searchdatetime
30Destination Type Searchint
31Destination No_ Searchnvarchar(40)
32Shipping Agent Code Searchnvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
       [Warehouse Activity Line].[Shipping Agent Code]
       ,[Shipping Agent].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Activity Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
              ON
                     [Warehouse Activity Line].[Shipping Agent Code] = [Shipping Agent].[Code]
33Shipping Agent Service Code Searchnvarchar(20)
Key to join to the Shipping Agent Services table.

Show/hide example query

SELECT
       [Warehouse Activity Line].[Shipping Agent Service Code]
       ,[Shipping Agent Services].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Activity Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
              ON
                     [Warehouse Activity Line].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
34Shipment Method Code Searchnvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Warehouse Activity Line].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Activity Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Warehouse Activity Line].[Shipment Method Code] = [Shipment Method].[Code]
35Starting Date Searchdatetime
36Qty_ Rounding Precision Searchdecimal(38,38)
37Qty_ Rounding Precision (Base) Searchdecimal(38,38)
38Assemble to Order Searchtinyint
39ATO Component Searchtinyint
40Serial No_ Searchnvarchar(100)
41Lot No_ Searchnvarchar(100)
42Warranty Date Searchdatetime
43Expiration Date Searchdatetime
44Package No_ Searchnvarchar(100)
45Bin Code Searchnvarchar(40)
46Zone Code Searchnvarchar(20)
47Action Type Searchint
48Whse_ Document Type Searchint
49Whse_ Document No_ Searchnvarchar(40)
50Whse_ Document Line No_ Searchint
51Bin Ranking Searchint
52Cubage Searchdecimal(38,38)
53Weight Searchdecimal(38,38)
54Special Equipment Code Searchnvarchar(20)
Key to join to the Special Equipment table.

Show/hide example query

SELECT
       [Warehouse Activity Line].[Special Equipment Code]
       ,[Special Equipment].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Activity Line]
LEFT JOIN
       [CRONUS UK Ltd_$Special Equipment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Special Equipment]
              ON
                     [Warehouse Activity Line].[Special Equipment Code] = [Special Equipment].[Code]
55Bin Type Code Searchnvarchar(20)
56Breakbulk No_ Searchint
57Original Breakbulk Searchtinyint
58Breakbulk Searchtinyint
59Cross-Dock Information Searchint
60Dedicated Searchtinyint
61$systemId Searchuniqueidentifier
62$systemCreatedAt Searchdatetime
63$systemCreatedBy Searchuniqueidentifier
64$systemModifiedAt Searchdatetime
65$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Warehouse Activity Line table

Leave a Reply

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