Registered Invt_ Movement Hdr_ – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables RRegistered Invt_ Movement Hdr_

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

Table Type: Company

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

Table Number: 7344

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 Invt_ Movement Hdr_ can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Registered Invt_ Movement Hdr_$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]
   ,[Registering Date]
   ,[No_ Series]
   ,[Invt_ Movement No_]
   ,[No_ Printed]
   ,[Posting Date]
   ,[Source No_]
   ,[Source Document]
   ,[Source Type]
   ,[Source Subtype]
   ,[Destination Type]
   ,[Destination No_]
   ,[External Document No_]
   ,[Shipment Date]
   ,[External Document No_2]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Registered Invt_ Movement 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 Invt_ Movement Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Registered Invt_ Movement Hdr_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Registered Invt_ Movement Hdr_].[Location Code] = [Location].[Code]

Show/hide columns in Registered Invt_ Movement Hdr_ 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 [Registered Invt_ Movement Hdr_].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Registered Invt_ Movement Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Registered Invt_ Movement Hdr_] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Registered Invt_ Movement Hdr_].[Location Code] = [Location].[Code]
4	Assigned User ID	nvarchar(100)
5	Assignment Date	datetime
6	Assignment Time	datetime
7	Registering Date	datetime
8	No_ Series	nvarchar(40)
9	Invt_ Movement No_	nvarchar(40)
10	No_ Printed	int
11	Posting Date	datetime
12	Source No_	nvarchar(40)
13	Source Document	int
14	Source Type	int
15	Source Subtype	int
16	Destination Type	int
17	Destination No_	nvarchar(40)
18	External Document No_	nvarchar(70)
19	Shipment Date	datetime
20	External Document No_2	nvarchar(70)
21	$systemId	uniqueidentifier
22	$systemCreatedAt	datetime
23	$systemCreatedBy	uniqueidentifier
24	$systemModifiedAt	datetime
25	$systemModifiedBy	uniqueidentifier