Price 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
   [timestamp]
   ,[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]
   ,[$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]

Show/hide columns in Price List Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Description Searchnvarchar(500)
4Source Group Searchint
5Source Type Searchint
6Source No_ Searchnvarchar(40)
7Parent Source No_ Searchnvarchar(40)
8Source ID Searchuniqueidentifier
9Price Type Searchint
10Amount Type Searchint
11Currency Code Searchnvarchar(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]
12Starting Date Searchdatetime
13Ending Date Searchdatetime
14Price Includes VAT Searchtinyint
15VAT Bus_ Posting Gr_ (Price) Searchnvarchar(40)
16Allow Line Disc_ Searchtinyint
17Allow Invoice Disc_ Searchtinyint
18No_ Series Searchnvarchar(40)
19Status Searchint
20Filter Source No_ Searchnvarchar(40)
21Allow Updating Defaults Searchtinyint
22$systemId Searchuniqueidentifier
23$systemCreatedAt Searchdatetime
24$systemCreatedBy Searchuniqueidentifier
25$systemModifiedAt Searchdatetime
26$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Price List Header table

Leave a Reply

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