Price List Header

Dynamics 365 BC Table ReferenceTablesCompany TablesPPrice List Header

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

Table Type: Company

Table Name: Price List Header
Database Table Name: CRONUS UK Ltd_$Price List Header$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 7000

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 Price List Header can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Price List Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Description]
   ,[Source Group]
   ,[Source Type]
   ,[Source No_]
   ,[Parent Source No_]
   ,[Source ID]
   ,[Price Type]
   ,[Amount Type]
   ,[Currency Code]
   ,[Starting Date]
   ,[Ending Date]
   ,[Price Includes VAT]
   ,[VAT Bus_ Posting Gr_ (Price)]
   ,[Allow Line Disc_]
   ,[Allow Invoice Disc_]
   ,[No_ Series]
   ,[Status]
   ,[Filter Source No_]
   ,[Allow Updating Defaults]
   ,[Assign-to No_]
   ,[Assign-to Parent No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Price List Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Price List Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price List Header]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Price List Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [Price List Header].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
   [User] AS [User]
      ON
         [Price List Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Price List Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Price List Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code SearchCodeNormalCode20Codenvarchar(40)
2Description Primary Key SearchDescriptionNormalText250Descriptionnvarchar(500)
3Source Group SearchAssign-to GroupNormalOption4Source Groupint
Available options are:
  • “All”
  • “Customer”
  • “Vendor”
  • “Job”
4Source Type SearchAssign-to TypeNormalOption4Source Typeint
Available options are:
  • “All”
  • “All Customers”
  • “Customer”
  • “Customer Price Group”
  • “Customer Disc. Group”
  • “All Vendors”
  • “Vendor”
  • “All Jobs”
  • “Job”
  • “Job Task”
  • “Campaign”
  • “Contact”
5Source No. SearchAssign-to No. (custom)NormalCode20Source No_nvarchar(40)
6Parent Source No. SearchAssign-to Parent No. (jobs)NormalCode20Parent Source No_nvarchar(40)
7Source ID SearchAssign-to IDNormalGUID16Source IDuniqueidentifier
8Price Type SearchPrice TypeNormalOption4Price Typeint
Available options are:
  • “Any”
  • “Sale”
  • “Purchase”
9Amount Type SearchDefinesNormalOption4Amount Typeint
Available options are:
  • “Any”
  • “Price”
  • “Cost”
  • “Discount”
10Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
	       [Price List Header].[Currency Code]
	       ,[Currency].[Code]
	FROM
	       [CRONUS UK Ltd_$Price List Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price List Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	              ON
	                     [Price List Header].[Currency Code] = [Currency].[Code]
11Starting Date SearchStarting DateNormalDate4Starting Datedatetime
12Ending Date SearchEnding DateNormalDate4Ending Datedatetime
Key to join to the Inventory Period table.

Show/hide example query

SELECT
	       [Price List Header].[Ending Date]
	       ,[Inventory Period].[Ending Date]
	FROM
	       [CRONUS UK Ltd_$Price List Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price List Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
	              ON
	                     [Price List Header].[Ending Date] = [Inventory Period].[Ending Date]
13Price Includes VAT SearchPrice Includes TaxNormalBoolean4Price Includes VATtinyint
14VAT Bus. Posting Gr. (Price) SearchVAT Bus. Posting Gr. (Price)NormalCode20VAT Bus_ Posting Gr_ (Price)nvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
	       [Price List Header].[VAT Bus_ Posting Gr_ (Price)]
	       ,[VAT Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Price List Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price List Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
	              ON
	                     [Price List Header].[VAT Bus_ Posting Gr_ (Price)] = [VAT Business Posting Group].[Code]
15Allow Line Disc. SearchAllow Line Disc.NormalBoolean4Allow Line Disc_tinyint
16Allow Invoice Disc. SearchAllow Invoice Disc.NormalBoolean4Allow Invoice Disc_tinyint
17No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [Price List Header].[No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Price List Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price List Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Price List Header].[No_ Series] = [No. Series].[Code]
18Status SearchStatusNormalOption4Statusint
Available options are:
  • “Draft”
  • “Active”
  • “Inactive”
19Filter Source No. SearchFilter Source No.NormalCode20Filter Source No_nvarchar(40)
20Allow Updating Defaults SearchAllow Updating DefaultsNormalBoolean4Allow Updating Defaultstinyint
21Assign-to No. SearchAssign-to No.NormalCode20Assign-to No_nvarchar(40)
22Assign-to Parent No. SearchAssign-to Parent No.NormalCode20Assign-to Parent No_nvarchar(40)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [Price List Header].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Price List Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Price List Header]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Price List Header].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Price List Header table

Currency
Dynamics 365 BC Table ReferenceTablesCompany TablesPPrice List Header

Leave a Reply

Your email address will not be published. Required fields are marked *