Whse_ Item Tracking Line

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

Table Type: Company

Table Name: Whse_ Item Tracking Line
Database Table Name: CRONUS UK Ltd_$Whse_ Item Tracking Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 6550

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Item No_]
   ,[Location Code]
   ,[Quantity (Base)]
   ,[Description]
   ,[Source Type]
   ,[Source Subtype]
   ,[Source ID]
   ,[Source Batch Name]
   ,[Source Prod_ Order Line]
   ,[Source Ref_ No_]
   ,[Serial No_]
   ,[Qty_ per Unit of Measure]
   ,[Warranty Date]
   ,[Expiration Date]
   ,[Qty_ to Handle (Base)]
   ,[Qty_ to Invoice (Base)]
   ,[Quantity Handled (Base)]
   ,[Quantity Invoiced (Base)]
   ,[Qty_ to Handle]
   ,[Buffer Status]
   ,[Buffer Status2]
   ,[New Serial No_]
   ,[New Lot No_]
   ,[Qty_ Registered (Base)]
   ,[Created by Whse_ Activity Line]
   ,[Lot No_]
   ,[Variant Code]
   ,[New Expiration Date]
   ,[Package No_]
   ,[New Package No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Whse_ Item Tracking 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_$Whse_ Item Tracking Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Item Tracking Line]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Whse_ Item Tracking Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Whse_ Item Tracking Line].[Location Code] = [Location].[Code]

Show/hide columns in Whse_ Item Tracking Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Item No_ Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Whse_ Item Tracking Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Whse_ Item Tracking Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Item Tracking Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Whse_ Item Tracking Line].[Item No_] = [Item].[No_]
4Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Whse_ Item Tracking Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Whse_ Item Tracking Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse_ Item Tracking Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Whse_ Item Tracking Line].[Location Code] = [Location].[Code]
5Quantity (Base) Searchdecimal(38,38)
6Description Searchnvarchar(200)
7Source Type Searchint
8Source Subtype Searchint
9Source ID Searchnvarchar(40)
10Source Batch Name Searchnvarchar(20)
11Source Prod_ Order Line Searchint
12Source Ref_ No_ Searchint
13Serial No_ Searchnvarchar(100)
14Qty_ per Unit of Measure Searchdecimal(38,38)
15Warranty Date Searchdatetime
16Expiration Date Searchdatetime
17Qty_ to Handle (Base) Searchdecimal(38,38)
18Qty_ to Invoice (Base) Searchdecimal(38,38)
19Quantity Handled (Base) Searchdecimal(38,38)
20Quantity Invoiced (Base) Searchdecimal(38,38)
21Qty_ to Handle Searchdecimal(38,38)
22Buffer Status Searchint
23Buffer Status2 Searchint
24New Serial No_ Searchnvarchar(100)
25New Lot No_ Searchnvarchar(100)
26Qty_ Registered (Base) Searchdecimal(38,38)
27Created by Whse_ Activity Line Searchtinyint
28Lot No_ Searchnvarchar(100)
29Variant Code Searchnvarchar(20)
30New Expiration Date Searchdatetime
31Package No_ Searchnvarchar(100)
32New Package No_ Searchnvarchar(100)
33$systemId Searchuniqueidentifier
34$systemCreatedAt Searchdatetime
35$systemCreatedBy Searchuniqueidentifier
36$systemModifiedAt Searchdatetime
37$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Whse_ Item Tracking Line table

Leave a Reply

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