Hist. Inventory Trx. Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables HHist. Inventory Trx. Line

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

Table Type: Company

Table Name: Hist. Inventory Trx. Line
Database Table Name:

Table Number: 40907

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 Hist. Inventory Trx. Line can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [Hist. Inventory Trx. Line]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Hist. Inventory Trx. Line].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Hist. Inventory Trx. Line].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Hist. Inventory Trx. Line].[Document Type] = [Sales Header].[Document Type]
      AND
         [Hist. Inventory Trx. Line].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Hist. Inventory Trx. Line].[Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Hist. Inventory Trx. Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Hist. Inventory Trx. Line].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Hist. Inventory Trx. Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Hist. Inventory Trx. Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Hist. Inventory Trx. Line table

Field No.	Field Name	Field Caption	Class	Type	Length
1	Primary Key	Primary Key	Normal	Integer	4
2	Audit Code	Audit Code	Normal	Code	35
3	Document Type	Document Type	Normal	Option	4
4	Document No.	Document No.	Normal	Code	35
5	Line Item Sequence	Line Item Sequence	Normal	Integer	4
6	Date	Date	Normal	Date	4
7	Source Description	Source Description	Normal	Text	50
8	Customer No.	Customer No.	Normal	Code	35
	Key to join to the Customer table. Show/hide example query SELECT [Hist. Inventory Trx. Line].[] ,[Customer].[No_] FROM [] AS [Hist. Inventory Trx. Line] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Hist. Inventory Trx. Line].[] = [Customer].[No_]
9	Item No.	Item No.	Normal	Code	35
	Key to join to the Item table. Show/hide example query SELECT [Hist. Inventory Trx. Line].[] ,[Item].[No_] FROM [] AS [Hist. Inventory Trx. Line] LEFT JOIN [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] ON [Hist. Inventory Trx. Line].[] = [Item].[No_]
10	Unit of Measure	Unit of Measure	Normal	Code	35
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Hist. Inventory Trx. Line].[] ,[Unit of Measure].[Code] FROM [] AS [Hist. Inventory Trx. Line] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Hist. Inventory Trx. Line].[] = [Unit of Measure].[Code]
11	Quantity	Quantity	Normal	Decimal	12
12	Unit Cost	Unit Cost	Normal	Decimal	12
13	Ext. Cost	Ext. Cost	Normal	Decimal	12
14	Location Code	Location Code	Normal	Code	35
	Key to join to the Location table. Show/hide example query SELECT [Hist. Inventory Trx. Line].[] ,[Location].[Code] FROM [] AS [Hist. Inventory Trx. Line] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Hist. Inventory Trx. Line].[] = [Location].[Code]
15	Transfer To Location Code	Transfer To Location Code	Normal	Code	35
16	Reason Code	Reason Code	Normal	Code	40
	Key to join to the Reason Code table. Show/hide example query SELECT [Hist. Inventory Trx. Line].[] ,[Reason Code].[Code] FROM [] AS [Hist. Inventory Trx. Line] LEFT JOIN [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code] ON [Hist. Inventory Trx. Line].[] = [Reason Code].[Code]
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [Hist. Inventory Trx. Line].[] ,[User].[User Security ID] FROM [] AS [Hist. Inventory Trx. Line] LEFT JOIN [User] AS [User] ON [Hist. Inventory Trx. Line].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16

Show/hide tables related from Hist. Inventory Trx. Line table

Location Sales Header Sales Header Archive

Dynamics 365 BC Table Reference Tables Company Tables HHist. Inventory Trx. Line

Leave a Reply Cancel reply