Internal Movement Header

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

Table Type: Company

Table Name: Internal Movement Header
Database Table Name: CRONUS UK Ltd_$Internal Movement Header$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 7346

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 Internal Movement Header can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Internal Movement 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]
   ,[No_ Series]
   ,[To Bin Code]
   ,[Due Date]
   ,[Sorting Method]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Internal Movement 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_$Internal Movement Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Internal Movement Header]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Internal Movement Header].[Location Code] = [Location].[Code]

Show/hide columns in Internal Movement 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
       [Internal Movement Header].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Internal Movement Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Internal Movement Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Internal Movement Header].[Location Code] = [Location].[Code]
4Assigned User ID Searchnvarchar(100)
5Assignment Date Searchdatetime
6Assignment Time Searchdatetime
7No_ Series Searchnvarchar(40)
8To Bin Code Searchnvarchar(40)
9Due Date Searchdatetime
10Sorting Method Searchint
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Internal Movement Header table

Leave a Reply

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