Standard Purchase Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SStandard Purchase Line

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

Table Type: Company

Table Name: Standard Purchase Line
Database Table Name: CRONUS UK Ltd_$Standard Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 174

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 Standard Purchase Line can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Standard Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Standard Purchase Code]
   ,[Line No_]
   ,[Type]
   ,[No_]
   ,[Description]
   ,[Quantity]
   ,[Amount Excl_ VAT]
   ,[Unit of Measure Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Variant Code]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Standard Purchase 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_$Standard Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Purchase Line]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Standard Purchase Line].[Unit of Measure Code] = [Unit of Measure].[Code]

Show/hide columns in Standard Purchase Line table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Standard Purchase Code	nvarchar(20)
3	Line No_	int
4	Type	int
5	No_	nvarchar(40)
6	Description	nvarchar(200)
7	Quantity	decimal(38,38)
8	Amount Excl_ VAT	decimal(38,38)
9	Unit of Measure Code	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Standard Purchase Line].[Unit of Measure Code] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Standard Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Purchase Line] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Standard Purchase Line].[Unit of Measure Code] = [Unit of Measure].[Code]
10	Shortcut Dimension 1 Code	nvarchar(40)
11	Shortcut Dimension 2 Code	nvarchar(40)
12	Variant Code	nvarchar(20)
13	Dimension Set ID	int
14	$systemId	uniqueidentifier
15	$systemCreatedAt	datetime
16	$systemCreatedBy	uniqueidentifier
17	$systemModifiedAt	datetime
18	$systemModifiedBy	uniqueidentifier