Internal Movement Line

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

Table Type: Company

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

Table Number: 7347

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 Line can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Internal Movement Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Line No_]
   ,[Location Code]
   ,[Shelf No_]
   ,[From Bin Code]
   ,[To Bin Code]
   ,[Item No_]
   ,[Quantity]
   ,[Qty_ (Base)]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Variant Code]
   ,[Description]
   ,[Description 2]
   ,[Sorting Sequence No_]
   ,[Due Date]
   ,[Cubage]
   ,[Weight]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Internal Movement Line$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 Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Internal Movement Line]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Internal Movement Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Internal Movement Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Internal Movement Line].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Internal Movement Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Internal Movement Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Internal Movement Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Internal Movement Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Internal Movement Line].[Location Code] = [Location].[Code]
5Shelf No_ Searchnvarchar(20)
6From Bin Code Searchnvarchar(40)
7To Bin Code Searchnvarchar(40)
8Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Internal Movement Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Internal Movement Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Internal Movement Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Internal Movement Line].[Item No_] = [Item].[No_]
9Quantity Searchdecimal(38,38)
10Qty_ (Base) Searchdecimal(38,38)
11Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Internal Movement Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Internal Movement Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Internal Movement Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Internal Movement Line].[Unit of Measure Code] = [Unit of Measure].[Code]
12Qty_ per Unit of Measure Searchdecimal(38,38)
13Variant Code Searchnvarchar(20)
14Description Searchnvarchar(200)
15Description 2 Searchnvarchar(100)
16Sorting Sequence No_ Searchint
17Due Date Searchdatetime
18Cubage Searchdecimal(38,38)
19Weight Searchdecimal(38,38)
20$systemId Searchuniqueidentifier
21$systemCreatedAt Searchdatetime
22$systemCreatedBy Searchuniqueidentifier
23$systemModifiedAt Searchdatetime
24$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Internal Movement Line table

Leave a Reply

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