Whse_ Item Tracking Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables WWhse_ 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Entry No_	int
3	Item No_	nvarchar(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_]
4	Location Code	nvarchar(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]
5	Quantity (Base)	decimal(38,38)
6	Description	nvarchar(200)
7	Source Type	int
8	Source Subtype	int
9	Source ID	nvarchar(40)
10	Source Batch Name	nvarchar(20)
11	Source Prod_ Order Line	int
12	Source Ref_ No_	int
13	Serial No_	nvarchar(100)
14	Qty_ per Unit of Measure	decimal(38,38)
15	Warranty Date	datetime
16	Expiration Date	datetime
17	Qty_ to Handle (Base)	decimal(38,38)
18	Qty_ to Invoice (Base)	decimal(38,38)
19	Quantity Handled (Base)	decimal(38,38)
20	Quantity Invoiced (Base)	decimal(38,38)
21	Qty_ to Handle	decimal(38,38)
22	Buffer Status	int
23	Buffer Status2	int
24	New Serial No_	nvarchar(100)
25	New Lot No_	nvarchar(100)
26	Qty_ Registered (Base)	decimal(38,38)
27	Created by Whse_ Activity Line	tinyint
28	Lot No_	nvarchar(100)
29	Variant Code	nvarchar(20)
30	New Expiration Date	datetime
31	Package No_	nvarchar(100)
32	New Package No_	nvarchar(100)
33	$systemId	uniqueidentifier
34	$systemCreatedAt	datetime
35	$systemCreatedBy	uniqueidentifier
36	$systemModifiedAt	datetime
37	$systemModifiedBy	uniqueidentifier