Registered Whse_ Activity Line

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

Table Type: Company

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

Table Number: 5773

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Registered Whse_ 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)]
   ,[Shipping Advice]
   ,[Due Date]
   ,[Destination Type]
   ,[Destination No_]
   ,[Whse_ Activity No_]
   ,[Shipping Agent Code]
   ,[Shipping Agent Service Code]
   ,[Shipment Method Code]
   ,[Starting Date]
   ,[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_]
   ,[Cubage]
   ,[Weight]
   ,[Special Equipment Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Registered Whse_ 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_$Registered Whse_ Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Registered Whse_ Activity Line]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Registered Whse_ Activity Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Registered Whse_ Activity Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Registered Whse_ 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
         [Registered Whse_ 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
         [Registered Whse_ 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
         [Registered Whse_ Activity Line].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Special Equipment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Special Equipment]
      ON
         [Registered Whse_ Activity Line].[Special Equipment Code] = [Special Equipment].[Code]

Show/hide columns in Registered Whse_ 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
       [Registered Whse_ Activity Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Registered Whse_ Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Registered Whse_ Activity Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Registered Whse_ 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
       [Registered Whse_ Activity Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Registered Whse_ Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Registered Whse_ Activity Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Registered Whse_ 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
       [Registered Whse_ Activity Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Registered Whse_ Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Registered Whse_ Activity Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Registered Whse_ 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)
22Shipping Advice Searchint
23Due Date Searchdatetime
24Destination Type Searchint
25Destination No_ Searchnvarchar(40)
26Whse_ Activity No_ Searchnvarchar(40)
27Shipping Agent Code Searchnvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Registered Whse_ Activity Line].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Registered Whse_ Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Registered Whse_ Activity Line]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Registered Whse_ Activity Line].[Shipment Method Code] = [Shipment Method].[Code]
30Starting Date Searchdatetime
31Serial No_ Searchnvarchar(100)
32Lot No_ Searchnvarchar(100)
33Warranty Date Searchdatetime
34Expiration Date Searchdatetime
35Package No_ Searchnvarchar(100)
36Bin Code Searchnvarchar(40)
37Zone Code Searchnvarchar(20)
38Action Type Searchint
39Whse_ Document Type Searchint
40Whse_ Document No_ Searchnvarchar(40)
41Whse_ Document Line No_ Searchint
42Cubage Searchdecimal(38,38)
43Weight Searchdecimal(38,38)
44Special Equipment Code Searchnvarchar(20)
Key to join to the Special Equipment table.

Show/hide example query

SELECT
       [Registered Whse_ Activity Line].[Special Equipment Code]
       ,[Special Equipment].[Code]
FROM
       [CRONUS UK Ltd_$Registered Whse_ Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Registered Whse_ Activity Line]
LEFT JOIN
       [CRONUS UK Ltd_$Special Equipment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Special Equipment]
              ON
                     [Registered Whse_ Activity Line].[Special Equipment Code] = [Special Equipment].[Code]
45$systemId Searchuniqueidentifier
46$systemCreatedAt Searchdatetime
47$systemCreatedBy Searchuniqueidentifier
48$systemModifiedAt Searchdatetime
49$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Registered Whse_ Activity Line table

Leave a Reply

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