Registered 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 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
       [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]
4Assigned User ID Searchnvarchar(100)
5Assignment Date Searchdatetime
6Assignment Time Searchdatetime
7Registering Date Searchdatetime
8No_ Series Searchnvarchar(40)
9Invt_ Movement No_ Searchnvarchar(40)
10No_ Printed Searchint
11Posting Date Searchdatetime
12Source No_ Searchnvarchar(40)
13Source Document Searchint
14Source Type Searchint
15Source Subtype Searchint
16Destination Type Searchint
17Destination No_ Searchnvarchar(40)
18External Document No_ Searchnvarchar(70)
19Shipment Date Searchdatetime
20External Document No_2 Searchnvarchar(70)
21$systemId Searchuniqueidentifier
22$systemCreatedAt Searchdatetime
23$systemCreatedBy Searchuniqueidentifier
24$systemModifiedAt Searchdatetime
25$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Registered Invt_ Movement Hdr_ table

Leave a Reply

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