Serv_ Price Group Setup

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

Table Type: Company

Table Name: Serv_ Price Group Setup
Database Table Name: CRONUS UK Ltd_$Serv_ Price Group Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 6081

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 Serv_ Price Group Setup can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Serv_ Price Group Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Service Price Group Code]
   ,[Fault Area Code]
   ,[Cust_ Price Group Code]
   ,[Currency Code]
   ,[Starting Date]
   ,[Serv_ Price Adjmt_ Gr_ Code]
   ,[Include Discounts]
   ,[Adjustment Type]
   ,[Amount]
   ,[Include VAT]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Serv_ Price Group Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Serv_ Price Group Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Serv_ Price Group Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Serv_ Price Group Setup].[Currency Code] = [Currency].[Code]

Show/hide columns in Serv_ Price Group Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Service Price Group Code Primary Key Searchnvarchar(20)
3Fault Area Code Primary Key Searchnvarchar(20)
4Cust_ Price Group Code Primary Key Searchnvarchar(20)
5Currency Code Primary Key Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Serv_ Price Group Setup].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Serv_ Price Group Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Serv_ Price Group Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Serv_ Price Group Setup].[Currency Code] = [Currency].[Code]
6Starting Date Primary Key Searchdatetime
7Serv_ Price Adjmt_ Gr_ Code Searchnvarchar(20)
8Include Discounts Searchtinyint
9Adjustment Type Searchint
10Amount Searchdecimal(38,38)
11Include VAT Searchtinyint
12$systemId Searchuniqueidentifier
13$systemCreatedAt Searchdatetime
14$systemCreatedBy Searchuniqueidentifier
15$systemModifiedAt Searchdatetime
16$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Serv_ Price Group Setup table

Leave a Reply

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