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
   [timestamp]
   ,[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_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Warehouse Shipment Header].[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 Shipment Header].[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 Shipment Header].[Shipment Method Code] = [Shipment Method].[Code]

Show/hide columns in Warehouse Shipment Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Location Code Searchnvarchar(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]
4Assigned User ID Searchnvarchar(100)
5Assignment Date Searchdatetime
6Assignment Time Searchdatetime
7Sorting Method Searchint
8No_ Series Searchnvarchar(40)
9Bin Code Searchnvarchar(40)
10Zone Code Searchnvarchar(20)
11Document Status Searchint
12Posting Date Searchdatetime
13Shipping Agent Code Searchnvarchar(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] AS [Shipping Agent]
              ON
                     [Warehouse Shipment Header].[Shipping Agent Code] = [Shipping Agent].[Code]
14Shipping Agent Service Code Searchnvarchar(20)
Key to join to the Shipping Agent Services table.

Show/hide example query

SELECT
       [Warehouse Shipment Header].[Shipping Agent Service Code]
       ,[Shipping Agent Services].[Code]
FROM
       [CRONUS UK Ltd_$Warehouse Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
              ON
                     [Warehouse Shipment Header].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
15Shipment Method Code Searchnvarchar(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]
16Shipment Date Searchdatetime
17Status Searchint
18External Document No_ Searchnvarchar(70)
19Create Posted Header Searchtinyint
20Shipping No_ Searchnvarchar(40)
21Last Shipping No_ Searchnvarchar(40)
22Shipping No_ Series Searchnvarchar(40)
23$systemId Searchuniqueidentifier
24$systemCreatedAt Searchdatetime
25$systemCreatedBy Searchuniqueidentifier
26$systemModifiedAt Searchdatetime
27$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Warehouse Shipment Header table

Leave a Reply

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