Price Calculation Setup

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

Table Type: Company

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

Table Number: 7006

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 Calculation Setup can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Method]
   ,[Type]
   ,[Asset Type]
   ,[Group Id]
   ,[Implementation]
   ,[Enabled]
   ,[Default]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Price Calculation Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Price Calculation Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(200)
3Method Searchint
4Type Searchint
5Asset Type Searchint
6Group Id Searchnvarchar(200)
7Implementation Searchint
8Enabled Searchtinyint
9Default Searchtinyint
10$systemId Searchuniqueidentifier
11$systemCreatedAt Searchdatetime
12$systemCreatedBy Searchuniqueidentifier
13$systemModifiedAt Searchdatetime
14$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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