Warehouse Shipment Line

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

Table Type: Company

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

Table Number: 7321

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Line No_]
   ,[Source Type]
   ,[Source Subtype]
   ,[Source No_]
   ,[Source Line No_]
   ,[Source Document]
   ,[Location Code]
   ,[Shelf No_]
   ,[Bin Code]
   ,[Zone Code]
   ,[Item No_]
   ,[Quantity]
   ,[Qty_ (Base)]
   ,[Qty_ Outstanding]
   ,[Qty_ Outstanding (Base)]
   ,[Qty_ to Ship]
   ,[Qty_ to Ship (Base)]
   ,[Qty_ Picked]
   ,[Qty_ Picked (Base)]
   ,[Qty_ Shipped]
   ,[Qty_ Shipped (Base)]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Variant Code]
   ,[Description]
   ,[Description 2]
   ,[Status]
   ,[Sorting Sequence No_]
   ,[Due Date]
   ,[Destination Type]
   ,[Destination No_]
   ,[Cubage]
   ,[Weight]
   ,[Shipping Advice]
   ,[Shipment Date]
   ,[Completely Picked]
   ,[Not upd_ by Src_ Doc_ Post_]
   ,[Posting from Whse_ Ref_]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Assemble to Order]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Warehouse Shipment 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 Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Line]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Warehouse Shipment Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Warehouse Shipment Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Warehouse Shipment Line].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Warehouse Shipment Line table

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

Show/hide example query

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

Show/hide example query

SELECT
       [Warehouse Shipment Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Warehouse Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Warehouse Shipment Line].[Item No_] = [Item].[No_]
14Quantity Searchdecimal(38,38)
15Qty_ (Base) Searchdecimal(38,38)
16Qty_ Outstanding Searchdecimal(38,38)
17Qty_ Outstanding (Base) Searchdecimal(38,38)
18Qty_ to Ship Searchdecimal(38,38)
19Qty_ to Ship (Base) Searchdecimal(38,38)
20Qty_ Picked Searchdecimal(38,38)
21Qty_ Picked (Base) Searchdecimal(38,38)
22Qty_ Shipped Searchdecimal(38,38)
23Qty_ Shipped (Base) Searchdecimal(38,38)
24Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Warehouse Shipment Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Warehouse Shipment Line].[Unit of Measure Code] = [Unit of Measure].[Code]
25Qty_ per Unit of Measure Searchdecimal(38,38)
26Variant Code Searchnvarchar(20)
27Description Searchnvarchar(200)
28Description 2 Searchnvarchar(100)
29Status Searchint
30Sorting Sequence No_ Searchint
31Due Date Searchdatetime
32Destination Type Searchint
33Destination No_ Searchnvarchar(40)
34Cubage Searchdecimal(38,38)
35Weight Searchdecimal(38,38)
36Shipping Advice Searchint
37Shipment Date Searchdatetime
38Completely Picked Searchtinyint
39Not upd_ by Src_ Doc_ Post_ Searchtinyint
40Posting from Whse_ Ref_ Searchint
41Qty_ Rounding Precision Searchdecimal(38,38)
42Qty_ Rounding Precision (Base) Searchdecimal(38,38)
43Assemble to Order Searchtinyint
44$systemId Searchuniqueidentifier
45$systemCreatedAt Searchdatetime
46$systemCreatedBy Searchuniqueidentifier
47$systemModifiedAt Searchdatetime
48$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Warehouse Shipment Line table

Leave a Reply

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