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

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

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

Table Type: Company

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

Table Number: 40903

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. Sales 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. Sales Trx. Line]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Hist. Sales Trx. Line].[Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Hist. Sales Trx. Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Hist. Sales Trx. Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Hist. Sales Trx. Line].[SystemModifiedBy] = [User].[User Security ID]

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

Field No.	Field Name	Field Caption	Class	Type	Length
1	Primary Key	Primary Key	Normal	Integer	4
2	Sales Trx. Type	Sales Type	Normal	Option	4
3	Sales Header No.	Sales Header No.	Normal	Code	35
4	Line Item Sequence No.	Line Item Sequence No.	Normal	Integer	4
5	Component Sequence	Component Sequence	Normal	Integer	4
6	Item No.	Item No.	Normal	Code	35
	Key to join to the Item table. Show/hide example query SELECT [Hist. Sales Trx. Line].[] ,[Item].[No_] FROM [] AS [Hist. Sales Trx. Line] LEFT JOIN [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] ON [Hist. Sales Trx. Line].[] = [Item].[No_]
7	Item Description	Item Description	Normal	Text	100
8	Unit of Measure	Unit of Measure	Normal	Code	35
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Hist. Sales Trx. Line].[] ,[Unit of Measure].[Code] FROM [] AS [Hist. Sales Trx. Line] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Hist. Sales Trx. Line].[] = [Unit of Measure].[Code]
9	Unit Cost	Unit Cost	Normal	Decimal	12
10	Unit Price	Unit Price	Normal	Decimal	12
11	Quantity	Quantity	Normal	Decimal	12
12	Ext. Cost	Ext. Cost	Normal	Decimal	12
13	Ext. Price	Ext. Price	Normal	Decimal	12
14	Tax Amount	Tax Amount	Normal	Decimal	12
15	Location Code	Location Code	Normal	Code	35
	Key to join to the Location table. Show/hide example query SELECT [Hist. Sales Trx. Line].[] ,[Location].[Code] FROM [] AS [Hist. Sales Trx. Line] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Hist. Sales Trx. Line].[] = [Location].[Code]
16	Ship-to Name	Ship-to Name	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. Sales Trx. Line].[] ,[User].[User Security ID] FROM [] AS [Hist. Sales Trx. Line] LEFT JOIN [User] AS [User] ON [Hist. Sales 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. Sales Trx. Line table

Location

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

Leave a Reply Cancel reply