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

   [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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Whse. Item Tracking Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Whse. Item Tracking Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Whse. Item Tracking Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Whse. Item Tracking Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Whse. Item Tracking Line table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
2	Item No.	Item No.	Normal	Code	20	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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] ON [Whse. Item Tracking Line].[Item No_] = [Item].[No_]
3	Location Code	Location Code	Normal	Code	10	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]
4	Quantity (Base)	Quantity (Base)	Normal	Decimal	12	Quantity (Base)	decimal(38,38)
7	Description	Description	Normal	Text	100	Description	nvarchar(200)
10	Source Type	Source Type	Normal	Integer	4	Source Type	int
11	Source Subtype	Source Subtype	Normal	Option	4	Source Subtype	int
	Available options are: “0” “1” “2” “3” “4” “5” “6” “7” “8” “9” “10”
12	Source ID	Source ID	Normal	Code	20	Source ID	nvarchar(40)
13	Source Batch Name	Source Batch Name	Normal	Code	10	Source Batch Name	nvarchar(20)
14	Source Prod. Order Line	Source Prod. Order Line	Normal	Integer	4	Source Prod_ Order Line	int
15	Source Ref. No.	Source Ref. No.	Normal	Integer	4	Source Ref_ No_	int
24	Serial No.	Serial No.	Normal	Code	50	Serial No_	nvarchar(100)
29	Qty. per Unit of Measure	Qty. per Unit of Measure	Normal	Decimal	12	Qty_ per Unit of Measure	decimal(38,38)
40	Warranty Date	Warranty Date	Normal	Date	4	Warranty Date	datetime
41	Expiration Date	Expiration Date	Normal	Date	4	Expiration Date	datetime
50	Qty. to Handle (Base)	Qty. to Handle (Base)	Normal	Decimal	12	Qty_ to Handle (Base)	decimal(38,38)
51	Qty. to Invoice (Base)	Qty. to Invoice (Base)	Normal	Decimal	12	Qty_ to Invoice (Base)	decimal(38,38)
52	Quantity Handled (Base)	Quantity Handled (Base)	Normal	Decimal	12	Quantity Handled (Base)	decimal(38,38)
53	Quantity Invoiced (Base)	Quantity Invoiced (Base)	Normal	Decimal	12	Quantity Invoiced (Base)	decimal(38,38)
60	Qty. to Handle	Qty. to Handle	Normal	Decimal	12	Qty_ to Handle	decimal(38,38)
70	Buffer Status	Buffer Status	Normal	Option	4	Buffer Status	int
	Available options are: ” “ “MODIFY”
71	Buffer Status2	Buffer Status2	Normal	Option	4	Buffer Status2	int
	Available options are: “” “ExpDate blocked”
80	New Serial No.	New Serial No.	Normal	Code	50	New Serial No_	nvarchar(100)
81	New Lot No.	New Lot No.	Normal	Code	50	New Lot No_	nvarchar(100)
90	Source Type Filter	Source Type Filter	FlowFilter	Option	4
91	Qty. Registered (Base)	Qty. Registered (Base)	Normal	Decimal	12	Qty_ Registered (Base)	decimal(38,38)
92	Put-away Qty. (Base)	Put-away Qty. (Base)	FlowField	Decimal	12
93	Pick Qty. (Base)	Pick Qty. (Base)	FlowField	Decimal	12
94	Created by Whse. Activity Line	Created by Whse. Activity Line	Normal	Boolean	4	Created by Whse_ Activity Line	tinyint
5400	Lot No.	Lot No.	Normal	Code	50	Lot No_	nvarchar(100)
5401	Variant Code	Variant Code	Normal	Code	10	Variant Code	nvarchar(20)
	Key to join to the Item Variant table. Show/hide example query SELECT [Whse. Item Tracking Line].[Variant Code] ,[Item Variant].[Code] FROM [CRONUS UK Ltd_$Whse_ Item Tracking Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Item Tracking Line] LEFT JOIN [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant] ON [Whse. Item Tracking Line].[Variant Code] = [Item Variant].[Code]
6505	New Expiration Date	New Expiration Date	Normal	Date	4	New Expiration Date	datetime
6515	Package No.	Package No.	Normal	Code	50	Package No_	nvarchar(100)
6516	New Package No.	New Package No.	Normal	Code	50	New Package No_	nvarchar(100)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Whse. Item Tracking Line].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Whse_ Item Tracking Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Whse. Item Tracking Line] LEFT JOIN [User] AS [User] ON [Whse. Item Tracking Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Whse. Item Tracking Line table

Dynamics 365 BC Table Reference Tables Company Tables WWhse. Item Tracking Line

Leave a Reply Cancel reply