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

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

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

Table Type: Company

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

Table Number: 40906

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. Header 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. Header]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Hist. Inventory Trx. Header].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Hist. Inventory Trx. Header].[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. Header].[Document Type] = [Sales Header].[Document Type]
      AND
         [Hist. Inventory Trx. Header].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Hist. Inventory Trx. Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Hist. Inventory Trx. Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Hist. Inventory Trx. Header 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	Document Date	Document Date	Normal	Date	4
6	Batch No.	Batch No.	Normal	Code	35
7	Batch Source	Batch Source	Normal	Text	50
8	Post Date	Post Date	Normal	Date	4
9	Source Reference No.	Source Reference No.	Normal	Code	35
10	Source Indicator	Source Indicator	Normal	Text	65
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. Header].[] ,[User].[User Security ID] FROM [] AS [Hist. Inventory Trx. Header] LEFT JOIN [User] AS [User] ON [Hist. Inventory Trx. Header].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16