Hist. Purchase Recv. Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables HHist. Purchase Recv. Line

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

Table Type: Company

Table Name: Hist. Purchase Recv. Line
Database Table Name:

Table Number: 40909

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

Show/hide columns in Hist. Purchase Recv. Line table

Field No.	Field Name	Field Caption	Class	Type	Length
1	Primary Key	Primary Key	Normal	Integer	4
2	Receipt No.	Receipt No.	Normal	Code	35
3	Line No.	Line No.	Normal	Integer	4
4	PO Number	PO Number	Normal	Code	35
5	Item No.	Item No.	Normal	Code	35
	Key to join to the Item table. Show/hide example query SELECT [Hist. Purchase Recv. Line].[] ,[Item].[No_] FROM [] AS [Hist. Purchase Recv. Line] LEFT JOIN [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] ON [Hist. Purchase Recv. Line].[] = [Item].[No_]
6	Item Desc.	Item Desc.	Normal	Text	100
7	Vendor Item No.	Vendor Item No.	Normal	Text	50
8	Vendor Item Desc.	Vendor Item Desc.	Normal	Text	100
9	Base UofM Qty.	Base UofM Qty.	Normal	Decimal	12
10	Actual Ship Date	Actual Ship Date	Normal	Date	4
11	Unit of Measure	Unit of Measure	Normal	Code	35
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Hist. Purchase Recv. Line].[] ,[Unit of Measure].[Code] FROM [] AS [Hist. Purchase Recv. Line] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Hist. Purchase Recv. Line].[] = [Unit of Measure].[Code]
12	Unit Cost	Unit Cost	Normal	Decimal	12
13	Ext. Cost	Ext. Cost	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. Purchase Recv. Line].[] ,[Location].[Code] FROM [] AS [Hist. Purchase Recv. Line] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Hist. Purchase Recv. Line].[] = [Location].[Code]
16	Audit Code	Audit Code	Normal	Code	35
17	Ship Method	Ship Method	Normal	Text	50
18	Orig. Unit Cost	Orig. Unit Cost	Normal	Decimal	12
19	Orig. Ext. Cost	Orig. Ext. Cost	Normal	Decimal	12
20	Orig. Disc. Taken Amount	Orig. Disc. Taken Amount	Normal	Decimal	12
21	Orig. Trade Disc. Amount	Orig. Trade Disc. Amount	Normal	Decimal	12
22	Orig. Freight Amount	Orig. Freight Amount	Normal	Decimal	12
23	Orig. Misc. Amount	Orig. Misc. Amount	Normal	Decimal	12
24	Quantity Shipped	Quantity Shipped	Normal	Decimal	12
25	Quantity Invoiced	Quantity Invoiced	Normal	Decimal	12
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. Purchase Recv. Line].[] ,[User].[User Security ID] FROM [] AS [Hist. Purchase Recv. Line] LEFT JOIN [User] AS [User] ON [Hist. Purchase Recv. 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. Purchase Recv. Line table

Location

Dynamics 365 BC Table Reference Tables Company Tables HHist. Purchase Recv. Line

Leave a Reply Cancel reply