Warehouse Shipment Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables WWarehouse 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	No_	nvarchar(40)
3	Location Code	nvarchar(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]
4	Assigned User ID	nvarchar(100)
5	Assignment Date	datetime
6	Assignment Time	datetime
7	Sorting Method	int
8	No_ Series	nvarchar(40)
9	Bin Code	nvarchar(40)
10	Zone Code	nvarchar(20)
11	Document Status	int
12	Posting Date	datetime
13	Shipping Agent Code	nvarchar(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]
14	Shipping Agent Service Code	nvarchar(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]
15	Shipment Method Code	nvarchar(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]
16	Shipment Date	datetime
17	Status	int
18	External Document No_	nvarchar(70)
19	Create Posted Header	tinyint
20	Shipping No_	nvarchar(40)
21	Last Shipping No_	nvarchar(40)
22	Shipping No_ Series	nvarchar(40)
23	$systemId	uniqueidentifier
24	$systemCreatedAt	datetime
25	$systemCreatedBy	uniqueidentifier
26	$systemModifiedAt	datetime
27	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Warehouse Shipment Header table

Location Shipment Method Shipping Agent Shipping Agent Services

Dynamics 365 BC Table Reference Tables Company Tables WWarehouse Shipment Header

Leave a Reply Cancel reply