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
   [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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. Primary Key SearchEntry No.NormalInteger4Entry No_int
2Item No. SearchItem No.NormalCode20Item 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_]
3Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
4Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
7Description SearchDescriptionNormalText100Descriptionnvarchar(200)
10Source Type SearchSource TypeNormalInteger4Source Typeint
11Source Subtype SearchSource SubtypeNormalOption4Source Subtypeint
Available options are:
  • “0”
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
  • “7”
  • “8”
  • “9”
  • “10”
12Source ID SearchSource IDNormalCode20Source IDnvarchar(40)
13Source Batch Name SearchSource Batch NameNormalCode10Source Batch Namenvarchar(20)
14Source Prod. Order Line SearchSource Prod. Order LineNormalInteger4Source Prod_ Order Lineint
15Source Ref. No. SearchSource Ref. No.NormalInteger4Source Ref_ No_int
24Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
29Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
40Warranty Date SearchWarranty DateNormalDate4Warranty Datedatetime
41Expiration Date SearchExpiration DateNormalDate4Expiration Datedatetime
50Qty. to Handle (Base) SearchQty. to Handle (Base)NormalDecimal12Qty_ to Handle (Base)decimal(38,38)
51Qty. to Invoice (Base) SearchQty. to Invoice (Base)NormalDecimal12Qty_ to Invoice (Base)decimal(38,38)
52Quantity Handled (Base) SearchQuantity Handled (Base)NormalDecimal12Quantity Handled (Base)decimal(38,38)
53Quantity Invoiced (Base) SearchQuantity Invoiced (Base)NormalDecimal12Quantity Invoiced (Base)decimal(38,38)
60Qty. to Handle SearchQty. to HandleNormalDecimal12Qty_ to Handledecimal(38,38)
70Buffer Status SearchBuffer StatusNormalOption4Buffer Statusint
Available options are:
  • ” “
  • “MODIFY”
71Buffer Status2 SearchBuffer Status2NormalOption4Buffer Status2int
Available options are:
  • “”
  • “ExpDate blocked”
80New Serial No. SearchNew Serial No.NormalCode50New Serial No_nvarchar(100)
81New Lot No. SearchNew Lot No.NormalCode50New Lot No_nvarchar(100)
90Source Type Filter SearchSource Type FilterFlowFilterOption4
91Qty. Registered (Base) SearchQty. Registered (Base)NormalDecimal12Qty_ Registered (Base)decimal(38,38)
92Put-away Qty. (Base) SearchPut-away Qty. (Base)FlowFieldDecimal12
93Pick Qty. (Base) SearchPick Qty. (Base)FlowFieldDecimal12
94Created by Whse. Activity Line SearchCreated by Whse. Activity LineNormalBoolean4Created by Whse_ Activity Linetinyint
5400Lot No. SearchLot No.NormalCode50Lot No_nvarchar(100)
5401Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(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]
6505New Expiration Date SearchNew Expiration DateNormalDate4New Expiration Datedatetime
6515Package No. SearchPackage No.NormalCode50Package No_nvarchar(100)
6516New Package No. SearchNew Package No.NormalCode50New Package No_nvarchar(100)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Whse. Item Tracking Line].[$systemModifiedBy]
       ,[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].[$systemModifiedBy] = [User].[User Security ID]

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

Leave a Reply

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