Warehouse Shipment Header

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

Table Type: Company

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

Table Number: 7320

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [No_]
   ,[Location Code]
   ,[Assigned User ID]
   ,[Assignment Date]
   ,[Assignment Time]
   ,[Sorting Method]
   ,[No_ Series]
   ,[Bin Code]
   ,[Zone Code]
   ,[Document Status]
   ,[Posting Date]
   ,[Shipping Agent Code]
   ,[Shipping Agent Service Code]
   ,[Shipment Method Code]
   ,[Shipment Date]
   ,[Status]
   ,[External Document No_]
   ,[Create Posted Header]
   ,[Shipping No_]
   ,[Last Shipping No_]
   ,[Shipping No_ Series]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Warehouse Shipment Header$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 Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Header]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Warehouse Shipment Header].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Warehouse Shipment Header].[Assigned User ID] = [User Setup].[User ID]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Warehouse Shipment Header].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
      ON
         [Warehouse Shipment Header].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Warehouse Shipment Header].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Warehouse Shipment Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Warehouse Shipment Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Warehouse Shipment Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Warehouse Shipment Header].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Warehouse Shipment Header].[Location Code] = [Location].[Code]
3Assigned User ID SearchAssigned User IDNormalCode50Assigned User IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
       [Warehouse Shipment Header].[Assigned User ID]
       ,[User Setup].[User ID]
FROM
       [CRONUS UK Ltd_$Warehouse Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
              ON
                     [Warehouse Shipment Header].[Assigned User ID] = [User Setup].[User ID]
4Assignment Date SearchAssignment DateNormalDate4Assignment Datedatetime
5Assignment Time SearchAssignment TimeNormalTime4Assignment Timedatetime
6Sorting Method SearchSorting MethodNormalOption4Sorting Methodint
Available options are:
  • “None”
  • “Item”
  • “Document”
  • “Shelf or Bin”
  • “Due Date”
  • “Destination”
7No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Shipment Header].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Shipment Header].[No_ Series] = [No. Series].[Code]
11Comment SearchCommentFlowFieldBoolean4
12Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Warehouse Shipment Header].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Warehouse Shipment Header].[Bin Code] = [Bin].[Code]
13Zone Code SearchZone CodeNormalCode10Zone Codenvarchar(20)
34Document Status SearchDocument StatusNormalOption4Document Statusint
Available options are:
  • ” “
  • “Partially Picked”
  • “Partially Shipped”
  • “Completely Picked”
  • “Completely Shipped”
39Posting Date SearchPosting DateNormalDate4Posting Datedatetime
41Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
       [Warehouse Shipment Header].[Shipping Agent Code]
       ,[Shipping Agent].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
              ON
                     [Warehouse Shipment Header].[Shipping Agent Code] = [Shipping Agent].[Code]
42Shipping Agent Service Code SearchShipping Agent Service CodeNormalCode10Shipping Agent Service Codenvarchar(20)
43Shipment Method Code SearchShipment Method CodeNormalCode10Shipment Method Codenvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Warehouse Shipment Header].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Warehouse Shipment Header].[Shipment Method Code] = [Shipment Method].[Code]
45Shipment Date SearchShipment DateNormalDate4Shipment Datedatetime
46Completely Picked SearchCompletely PickedFlowFieldBoolean4
47Status SearchStatusNormalOption4Statusint
Available options are:
  • “Open”
  • “Released”
48External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
50Create Posted Header SearchCreate Posted HeaderNormalBoolean4Create Posted Headertinyint
61Shipping No. SearchShipping No.NormalCode20Shipping No_nvarchar(40)
62Last Shipping No. SearchLast Shipping No.NormalCode20Last Shipping No_nvarchar(40)
Key to join to the Posted Whse. Shipment Header table.

Show/hide example query

SELECT
       [Warehouse Shipment Header].[Last Shipping No_]
       ,[Posted Whse. Shipment Header].[No_]
FROM
       [CRONUS UK Ltd_$Warehouse Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Posted Whse_ Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse. Shipment Header]
              ON
                     [Warehouse Shipment Header].[Last Shipping No_] = [Posted Whse. Shipment Header].[No_]
63Shipping No. Series SearchShipping No. SeriesNormalCode20Shipping No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Warehouse Shipment Header].[Shipping No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Warehouse Shipment Header].[Shipping No_ Series] = [No. Series].[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 Shipment Header].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Warehouse Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Warehouse Shipment Header].[$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 Shipment Header].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Warehouse Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Warehouse Shipment Header].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Warehouse Shipment Header table

Leave a Reply

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