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
   [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]
   ,[Over-Receipt Quantity]
   ,[Over-Receipt Code]
   ,[$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 Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Warehouse Activity Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
      ON
         [Warehouse Activity Line].[Shipping Agent Code] = [Shipping Agent].[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_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Warehouse Activity Line].[Bin Code] = [Bin].[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]
LEFT JOIN
   [CRONUS UK Ltd_$Bin Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Type]
      ON
         [Warehouse Activity Line].[Bin Type Code] = [Bin Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Over-Receipt Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Over-Receipt Code]
      ON
         [Warehouse Activity Line].[Over-Receipt Code] = [Over-Receipt Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Warehouse Activity Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Warehouse Activity Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Warehouse Activity Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Activity Type Primary Key SearchActivity TypeNormalOption4Activity Typeint
Available options are:
  • ” “
  • “Put-away”
  • “Pick”
  • “Movement”
  • “Invt. Put-away”
  • “Invt. Pick”
  • “Invt. Movement”
2No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
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”
11Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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. SearchShelf No.NormalCode10Shelf No_nvarchar(20)
13Sorting Sequence No. SearchSorting Sequence No.NormalInteger4Sorting Sequence No_int
14Item No. SearchItem No.NormalCode20Item No_nvarchar(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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Warehouse Activity Line].[Item No_] = [Item].[No_]
15Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Warehouse Activity Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Activity Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Warehouse Activity Line].[Variant Code] = [Item Variant].[Code]
16Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
17Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
18Description SearchDescriptionNormalText100Descriptionnvarchar(200)
19Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
20Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
21Qty. (Base) SearchQty. (Base)NormalDecimal12Qty_ (Base)decimal(38,38)
24Qty. Outstanding SearchQty. OutstandingNormalDecimal12Qty_ Outstandingdecimal(38,38)
25Qty. Outstanding (Base) SearchQty. Outstanding (Base)NormalDecimal12Qty_ Outstanding (Base)decimal(38,38)
26Qty. to Handle SearchQty. to HandleNormalDecimal12Qty_ to Handledecimal(38,38)
27Qty. to Handle (Base) SearchQty. to Handle (Base)NormalDecimal12Qty_ to Handle (Base)decimal(38,38)
28Qty. Handled SearchQty. HandledNormalDecimal12Qty_ Handleddecimal(38,38)
29Qty. Handled (Base) SearchQty. Handled (Base)NormalDecimal12Qty_ Handled (Base)decimal(38,38)
31Shipping Advice SearchShipping AdviceNormalOption4Shipping Adviceint
Available options are:
  • “Partial”
  • “Complete”
34Due 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)
42Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(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$ext] AS [Shipping Agent]
              ON
                     [Warehouse Activity Line].[Shipping Agent Code] = [Shipping Agent].[Code]
43Shipping Agent Service Code SearchShipping Agent Service CodeNormalCode10Shipping Agent Service Codenvarchar(20)
44Shipment Method Code SearchShipment Method CodeNormalCode10Shipment Method Codenvarchar(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]
47Starting Date SearchStarting DateNormalDate4Starting Datedatetime
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)
900Assemble to Order SearchAssemble to OrderNormalBoolean4Assemble to Ordertinyint
901ATO Component SearchATO ComponentNormalBoolean4ATO Componenttinyint
6500Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
6501Lot No. SearchLot No.NormalCode50Lot No_nvarchar(100)
6502Warranty Date SearchWarranty DateNormalDate4Warranty Datedatetime
6503Expiration Date SearchExpiration DateNormalDate4Expiration Datedatetime
6504Serial No. Blocked SearchSerial No. BlockedFlowFieldBoolean4
6505Lot No. Blocked SearchLot No. BlockedFlowFieldBoolean4
6515Package No. SearchPackage No.NormalCode50Package No_nvarchar(100)
7300Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Warehouse Activity Line].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Activity Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Warehouse Activity Line].[Bin Code] = [Bin].[Code]
7301Zone Code SearchZone CodeNormalCode10Zone Codenvarchar(20)
7305Action Type SearchAction TypeNormalOption4Action Typeint
Available options are:
  • ” “
  • “Take”
  • “Place”
7306Whse. Document Type SearchWhse. Document TypeNormalOption4Whse_ Document Typeint
Available options are:
  • ” “
  • “Receipt”
  • “Shipment”
  • “Internal Put-away”
  • “Internal Pick”
  • “Production”
  • “Movement Worksheet”
  • “Assembly”
  • “Job”
7307Whse. Document No. SearchWhse. Document No.NormalCode20Whse_ Document No_nvarchar(40)
7308Whse. Document Line No. SearchWhse. Document Line No.NormalInteger4Whse_ Document Line No_int
7309Bin Ranking SearchBin RankingNormalInteger4Bin Rankingint
7310Cubage SearchCubageNormalDecimal12Cubagedecimal(38,38)
7311Weight SearchWeightNormalDecimal12Weightdecimal(38,38)
7312Special Equipment Code SearchSpecial Equipment CodeNormalCode10Special Equipment Codenvarchar(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]
7313Bin Type Code SearchBin Type CodeNormalCode10Bin Type Codenvarchar(20)
Key to join to the Bin Type table.

Show/hide example query

SELECT
       [Warehouse Activity Line].[Bin Type Code]
       ,[Bin Type].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Activity Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bin Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Type]
              ON
                     [Warehouse Activity Line].[Bin Type Code] = [Bin Type].[Code]
7314Breakbulk No. SearchBreakbulk No.NormalInteger4Breakbulk No_int
7315Original Breakbulk SearchOriginal BreakbulkNormalBoolean4Original Breakbulktinyint
7316Breakbulk SearchBreakbulkNormalBoolean4Breakbulktinyint
7317Cross-Dock Information SearchCross-Dock InformationNormalOption4Cross-Dock Informationint
Available options are:
  • ” “
  • “Cross-Dock Items”
  • “Some Items Cross-Docked”
7318Dedicated SearchDedicatedNormalBoolean4Dedicatedtinyint
7319Over-Receipt Quantity SearchOver-Receipt QuantityNormalDecimal12Over-Receipt Quantitydecimal(38,38)
7320Over-Receipt Code SearchOver-Receipt CodeNormalCode20Over-Receipt Codenvarchar(40)
Key to join to the Over-Receipt Code table.

Show/hide example query

SELECT
       [Warehouse Activity Line].[Over-Receipt Code]
       ,[Over-Receipt Code].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Activity Line]
LEFT JOIN
       [CRONUS UK Ltd_$Over-Receipt Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Over-Receipt Code]
              ON
                     [Warehouse Activity Line].[Over-Receipt Code] = [Over-Receipt Code].[Code]
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
       [Warehouse Activity Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Activity Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Warehouse Activity 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
       [Warehouse Activity Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Warehouse Activity Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Activity Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Warehouse Activity Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Warehouse Activity Line table

Leave a Reply

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