Service Item Trend Buffer

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

Table Type: Company

Table Name: Service Item Trend Buffer
Database Table Name: CRONUS UK Ltd_$Service Item Trend Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 931

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 Service Item Trend Buffer can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Service Item Trend Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Period Type]
   ,[Period Start]
   ,[Period Name]
   ,[Period End]
   ,[Prepaid Income]
   ,[Posted Income]
   ,[Parts Used]
   ,[Resources Used]
   ,[Cost Used]
   ,[Profit]
   ,[Profit _]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Service Item Trend Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Service Item Trend Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Period Type Primary Key Searchint
3Period Start Primary Key Searchdatetime
4Period Name Searchnvarchar(100)
5Period End Searchdatetime
6Prepaid Income Searchdecimal(38,38)
7Posted Income Searchdecimal(38,38)
8Parts Used Searchdecimal(38,38)
9Resources Used Searchdecimal(38,38)
10Cost Used Searchdecimal(38,38)
11Profit Searchdecimal(38,38)
12Profit _ Searchdecimal(38,38)
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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