Invt. Document Line

Dynamics 365 BC Table ReferenceTablesCompany TablesIInvt. Document Line

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

Table Type: Company

Table Name: Invt. Document Line
Database Table Name: CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5851

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Document Type]
   ,[Line No_]
   ,[Item No_]
   ,[Posting Date]
   ,[Document Date]
   ,[Document No_]
   ,[Description]
   ,[Location Code]
   ,[Inventory Posting Group]
   ,[Quantity]
   ,[Unit Amount]
   ,[Unit Cost]
   ,[Amount]
   ,[Salespers__Purch_ Code]
   ,[Source Code]
   ,[Applies-to Entry]
   ,[Item Shpt_ Entry No_]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Indirect Cost _]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Units per Parcel]
   ,[Unit Volume]
   ,[Reason Code]
   ,[Last Item Ledger Entry No_]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Posting No_ Series]
   ,[Unit Cost (ACY)]
   ,[Dimension Set ID]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[Item Category Code]
   ,[Purchasing Code]
   ,[Item Reference No_]
   ,[Item Reference Unit of Measure]
   ,[Item Reference Type]
   ,[Item Reference Type No_]
   ,[Item Charge No_]
   ,[Applies-from Entry]
   ,[Applied Amount]
   ,[Update Standard Cost]
   ,[Amount (ACY)]
   ,[Applies-to Value Entry]
   ,[FA No_]
   ,[FA Entry No_]
   ,[Depreciation Book Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Invt_ Document 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_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Invt. Document Line].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Invt. Document Line].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Invt. Document Line].[Document Type] = [Sales Header].[Document Type]
      AND
         [Invt. Document Line].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Invt. Document Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Invt. Document Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Invt. Document Line].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Invt. Document Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Invt. Document Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Invt. Document Line].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Invt. Document Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Invt. Document Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Invt. Document Line].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Invt. Document Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
      ON
         [Invt. Document Line].[Purchasing Code] = [Purchasing].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
      ON
         [Invt. Document Line].[Depreciation Book Code] = [Depreciation Book].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Invt. Document Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Invt. Document Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Invt. Document Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Receipt”
  • “Shipment”
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Item No. Primary Key SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Item No_]
	       ,[Item].[No_]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
	              ON
	                     [Invt. Document Line].[Item No_] = [Item].[No_]
4Posting Date SearchPosting DateNormalDate4Posting Datedatetime
5Document Date SearchDocument DateNormalDate4Document Datedatetime
7Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
8Description Primary Key SearchDescriptionNormalText100Descriptionnvarchar(200)
9Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Location Code]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Invt. Document Line].[Location Code] = [Location].[Code]
10Inventory Posting Group SearchInventory Posting GroupNormalCode20Inventory Posting Groupnvarchar(40)
Key to join to the Inventory Posting Group table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Inventory Posting Group]
	       ,[Inventory Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
	              ON
	                     [Invt. Document Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
13Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
16Unit Amount SearchUnit AmountNormalDecimal12Unit Amountdecimal(38,38)
17Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
18Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
23Salespers./Purch. Code SearchSalespers./Purch. CodeNormalCode20Salespers__Purch_ Codenvarchar(40)
26Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Source Code]
	       ,[Source Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
	              ON
	                     [Invt. Document Line].[Source Code] = [Source Code].[Code]
29Applies-to Entry SearchApplies-to EntryNormalInteger4Applies-to Entryint
32Item Shpt. Entry No. SearchItem Shpt. Entry No.NormalInteger4Item Shpt_ Entry No_int
34Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Shortcut Dimension 1 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Invt. Document Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
35Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Shortcut Dimension 2 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Invt. Document Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
37Indirect Cost % SearchIndirect Cost %NormalDecimal12Indirect Cost _decimal(38,38)
38Gross Weight SearchGross WeightNormalDecimal12Gross Weightdecimal(38,38)
39Net Weight SearchNet WeightNormalDecimal12Net Weightdecimal(38,38)
40Units per Parcel SearchUnits per ParcelNormalDecimal12Units per Parceldecimal(38,38)
41Unit Volume SearchUnit VolumeNormalDecimal12Unit Volumedecimal(38,38)
42Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Reason Code]
	       ,[Reason Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
	              ON
	                     [Invt. Document Line].[Reason Code] = [Reason Code].[Code]
55Last Item Ledger Entry No. SearchLast Item Ledger Entry No.NormalInteger4Last Item Ledger Entry No_int
Key to join to the Item Ledger Entry table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Last Item Ledger Entry No_]
	       ,[Item Ledger Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
	              ON
	                     [Invt. Document Line].[Last Item Ledger Entry No_] = [Item Ledger Entry].[Entry No_]
57Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Gen_ Bus_ Posting Group]
	       ,[Gen. Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
	              ON
	                     [Invt. Document Line].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
58Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Gen_ Prod_ Posting Group]
	       ,[Gen. Product Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
	              ON
	                     [Invt. Document Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
65Posting No. Series SearchPosting No. SeriesNormalCode20Posting No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Posting No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Invt. Document Line].[Posting No_ Series] = [No. Series].[Code]
72Unit Cost (ACY) SearchUnit Cost (ACY)NormalDecimal12Unit Cost (ACY)decimal(38,38)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Dimension Set ID]
	       ,[Dimension Set Entry].[Dimension Set ID]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
	              ON
	                     [Invt. Document Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Variant Code]
	       ,[Item Variant].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
	              ON
	                     [Invt. Document Line].[Variant Code] = [Item Variant].[Code]
5403Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Bin Code]
	       ,[Bin].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
	              ON
	                     [Invt. Document Line].[Bin Code] = [Bin].[Code]
5404Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
5405Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
5406Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
5407Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
5413Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
5470Reserved Quantity Inbnd. SearchReserved Quantity Inbnd.FlowFieldDecimal12
5471Reserved Quantity Outbnd. SearchReserved Quantity Outbnd.FlowFieldDecimal12
5472Reserved Qty. Inbnd. (Base) SearchReserved Qty. Inbnd. (Base)FlowFieldDecimal12
5473Reserved Qty. Outbnd. (Base) SearchReserved Qty. Outbnd. (Base)FlowFieldDecimal12
5704Item Category Code SearchItem Category CodeNormalCode20Item Category Codenvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Item Category Code]
	       ,[Item Category].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
	              ON
	                     [Invt. Document Line].[Item Category Code] = [Item Category].[Code]
5706Purchasing Code SearchPurchasing CodeNormalCode10Purchasing Codenvarchar(20)
Key to join to the Purchasing table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Purchasing Code]
	       ,[Purchasing].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
	              ON
	                     [Invt. Document Line].[Purchasing Code] = [Purchasing].[Code]
5725Item Reference No. SearchItem Reference No.NormalCode50Item Reference No_nvarchar(100)
5726Item Reference Unit of Measure SearchItem Reference Unit of MeasureNormalCode10Item Reference Unit of Measurenvarchar(20)
5727Item Reference Type SearchItem Reference TypeNormalOption4Item Reference Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Bar Code”
5728Item Reference Type No. SearchItem Reference Type No.NormalCode30Item Reference Type No_nvarchar(60)
5801Item Charge No. SearchItem Charge No.NormalCode20Item Charge No_nvarchar(40)
Key to join to the Item Charge table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Item Charge No_]
	       ,[Item Charge].[No_]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Charge$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Charge]
	              ON
	                     [Invt. Document Line].[Item Charge No_] = [Item Charge].[No_]
5807Applies-from Entry SearchApplies-from EntryNormalInteger4Applies-from Entryint
5811Applied Amount SearchApplied AmountNormalDecimal12Applied Amountdecimal(38,38)
5812Update Standard Cost SearchUpdate Standard CostNormalBoolean4Update Standard Costtinyint
5813Amount (ACY) SearchAmount (ACY)NormalDecimal12Amount (ACY)decimal(38,38)
5819Applies-to Value Entry SearchApplies-to Value EntryNormalInteger4Applies-to Value Entryint
12450FA No. SearchFA No.NormalCode20FA No_nvarchar(40)
Key to join to the Fixed Asset table.

Show/hide example query

SELECT
	       [Invt. Document Line].[FA No_]
	       ,[Fixed Asset].[No_]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
	              ON
	                     [Invt. Document Line].[FA No_] = [Fixed Asset].[No_]
12451FA Entry No. SearchFA Entry No.NormalInteger4FA Entry No_int
12452Depreciation Book Code SearchDepreciation Book CodeNormalCode10Depreciation Book Codenvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
	       [Invt. Document Line].[Depreciation Book Code]
	       ,[Depreciation Book].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
	              ON
	                     [Invt. Document Line].[Depreciation Book Code] = [Depreciation Book].[Code]
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
	       [Invt. Document Line].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Document Line]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Invt. Document Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Invt. Document Line table

Item CategoryLocationSales HeaderSales Header ArchiveUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesIInvt. Document Line

Leave a Reply

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