Invt. Document Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IInvt. 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$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_$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_$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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: “Receipt” “Shipment”
2	Line No.	Line No.	Normal	Integer	4	Line No_	int
3	Item No.	Item No.	Normal	Code	20	Item 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_]
4	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
5	Document Date	Document Date	Normal	Date	4	Document Date	datetime
7	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
8	Description	Description	Normal	Text	100	Description	nvarchar(200)
9	Location Code	Location Code	Normal	Code	10	Location Code	nvarchar(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]
10	Inventory Posting Group	Inventory Posting Group	Normal	Code	20	Inventory Posting Group	nvarchar(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]
13	Quantity	Quantity	Normal	Decimal	12	Quantity	decimal(38,38)
16	Unit Amount	Unit Amount	Normal	Decimal	12	Unit Amount	decimal(38,38)
17	Unit Cost	Unit Cost	Normal	Decimal	12	Unit Cost	decimal(38,38)
18	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
23	Salespers./Purch. Code	Salespers./Purch. Code	Normal	Code	20	Salespers__Purch_ Code	nvarchar(40)
26	Source Code	Source Code	Normal	Code	10	Source Code	nvarchar(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]
29	Applies-to Entry	Applies-to Entry	Normal	Integer	4	Applies-to Entry	int
32	Item Shpt. Entry No.	Item Shpt. Entry No.	Normal	Integer	4	Item Shpt_ Entry No_	int
34	Shortcut Dimension 1 Code	Shortcut Dimension 1 Code	Normal	Code	20	Shortcut Dimension 1 Code	nvarchar(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]
35	Shortcut Dimension 2 Code	Shortcut Dimension 2 Code	Normal	Code	20	Shortcut Dimension 2 Code	nvarchar(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]
37	Indirect Cost %	Indirect Cost %	Normal	Decimal	12	Indirect Cost _	decimal(38,38)
38	Gross Weight	Gross Weight	Normal	Decimal	12	Gross Weight	decimal(38,38)
39	Net Weight	Net Weight	Normal	Decimal	12	Net Weight	decimal(38,38)
40	Units per Parcel	Units per Parcel	Normal	Decimal	12	Units per Parcel	decimal(38,38)
41	Unit Volume	Unit Volume	Normal	Decimal	12	Unit Volume	decimal(38,38)
42	Reason Code	Reason Code	Normal	Code	10	Reason Code	nvarchar(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]
55	Last Item Ledger Entry No.	Last Item Ledger Entry No.	Normal	Integer	4	Last 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_]
57	Gen. Bus. Posting Group	Gen. Bus. Posting Group	Normal	Code	20	Gen_ Bus_ Posting Group	nvarchar(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]
58	Gen. Prod. Posting Group	Gen. Prod. Posting Group	Normal	Code	20	Gen_ Prod_ Posting Group	nvarchar(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]
65	Posting No. Series	Posting No. Series	Normal	Code	20	Posting No_ Series	nvarchar(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]
72	Unit Cost (ACY)	Unit Cost (ACY)	Normal	Decimal	12	Unit Cost (ACY)	decimal(38,38)
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	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]
5402	Variant Code	Variant Code	Normal	Code	10	Variant Code	nvarchar(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]
5403	Bin Code	Bin Code	Normal	Code	20	Bin Code	nvarchar(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]
5404	Qty. per Unit of Measure	Qty. per Unit of Measure	Normal	Decimal	12	Qty_ per Unit of Measure	decimal(38,38)
5405	Qty. Rounding Precision	Qty. Rounding Precision	Normal	Decimal	12	Qty_ Rounding Precision	decimal(38,38)
5406	Qty. Rounding Precision (Base)	Qty. Rounding Precision (Base)	Normal	Decimal	12	Qty_ Rounding Precision (Base)	decimal(38,38)
5407	Unit of Measure Code	Unit of Measure Code	Normal	Code	10	Unit of Measure Code	nvarchar(20)
5413	Quantity (Base)	Quantity (Base)	Normal	Decimal	12	Quantity (Base)	decimal(38,38)
5470	Reserved Quantity Inbnd.	Reserved Quantity Inbnd.	FlowField	Decimal	12
5471	Reserved Quantity Outbnd.	Reserved Quantity Outbnd.	FlowField	Decimal	12
5472	Reserved Qty. Inbnd. (Base)	Reserved Qty. Inbnd. (Base)	FlowField	Decimal	12
5473	Reserved Qty. Outbnd. (Base)	Reserved Qty. Outbnd. (Base)	FlowField	Decimal	12
5704	Item Category Code	Item Category Code	Normal	Code	20	Item Category Code	nvarchar(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]
5706	Purchasing Code	Purchasing Code	Normal	Code	10	Purchasing Code	nvarchar(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]
5725	Item Reference No.	Item Reference No.	Normal	Code	50	Item Reference No_	nvarchar(100)
5726	Item Reference Unit of Measure	Item Reference Unit of Measure	Normal	Code	10	Item Reference Unit of Measure	nvarchar(20)
5727	Item Reference Type	Item Reference Type	Normal	Option	4	Item Reference Type	int
	Available options are: ” “ “Customer” “Vendor” “Bar Code”
5728	Item Reference Type No.	Item Reference Type No.	Normal	Code	30	Item Reference Type No_	nvarchar(60)
5801	Item Charge No.	Item Charge No.	Normal	Code	20	Item 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_]
5807	Applies-from Entry	Applies-from Entry	Normal	Integer	4	Applies-from Entry	int
5811	Applied Amount	Applied Amount	Normal	Decimal	12	Applied Amount	decimal(38,38)
5812	Update Standard Cost	Update Standard Cost	Normal	Boolean	4	Update Standard Cost	tinyint
5813	Amount (ACY)	Amount (ACY)	Normal	Decimal	12	Amount (ACY)	decimal(38,38)
5819	Applies-to Value Entry	Applies-to Value Entry	Normal	Integer	4	Applies-to Value Entry	int
12450	FA No.	FA No.	Normal	Code	20	FA 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_]
12451	FA Entry No.	FA Entry No.	Normal	Integer	4	FA Entry No_	int
12452	Depreciation Book Code	Depreciation Book Code	Normal	Code	10	Depreciation Book Code	nvarchar(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	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 [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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Invt. Document Line table

Dynamics 365 BC Table Reference Tables Company Tables IInvt. Document Line

Leave a Reply Cancel reply