Registered Whse_ Activity Hdr_ – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables RRegistered Whse_ Activity Hdr_

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

Table Type: Company

Table Name: Registered Whse_ Activity Hdr_
Database Table Name: CRONUS UK Ltd_$Registered Whse_ Activity Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5772

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 Registered Whse_ Activity Hdr_ can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Registered Whse_ Activity Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Assigned User ID]
   ,[Assignment Date]
   ,[Assignment Time]
   ,[Sorting Method]
   ,[Registering Date]
   ,[No_ Series]
   ,[Whse_ Activity No_]
   ,[No_ Printed]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Registered Whse_ Activity Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Registered Whse_ Activity Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Registered Whse_ Activity Hdr_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Registered Whse_ Activity Hdr_].[Location Code] = [Location].[Code]

Show/hide columns in Registered Whse_ Activity Hdr_ table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Type	int
3	No_	nvarchar(40)
4	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Registered Whse_ Activity Hdr_].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Registered Whse_ Activity Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Registered Whse_ Activity Hdr_] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Registered Whse_ Activity Hdr_].[Location Code] = [Location].[Code]
5	Assigned User ID	nvarchar(100)
6	Assignment Date	datetime
7	Assignment Time	datetime
8	Sorting Method	int
9	Registering Date	datetime
10	No_ Series	nvarchar(40)
11	Whse_ Activity No_	nvarchar(40)
12	No_ Printed	int
13	$systemId	uniqueidentifier
14	$systemCreatedAt	datetime
15	$systemCreatedBy	uniqueidentifier
16	$systemModifiedAt	datetime
17	$systemModifiedBy	uniqueidentifier