Acc_ Sched_ KPI Buffer

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

Table Type: Company

Table Name: Acc_ Sched_ KPI Buffer
Database Table Name: CRONUS UK Ltd_$Acc_ Sched_ KPI Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 197

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 Acc_ Sched_ KPI Buffer can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Acc_ Sched_ KPI Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Date]
   ,[Closed Period]
   ,[Account Schedule Name]
   ,[KPI Code]
   ,[KPI Name]
   ,[Net Change Actual]
   ,[Balance at Date Actual]
   ,[Net Change Budget]
   ,[Balance at Date Budget]
   ,[Net Change Actual Last Year]
   ,[Balance at Date Act_ Last Year]
   ,[Net Change Budget Last Year]
   ,[Balance at Date Bud_ Last Year]
   ,[Net Change Forecast]
   ,[Balance at Date Forecast]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Acc_ Sched_ KPI Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Acc_ Sched_ KPI Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchint
3Date Searchdatetime
4Closed Period Searchtinyint
5Account Schedule Name Searchnvarchar(20)
6KPI Code Searchnvarchar(20)
7KPI Name Searchnvarchar(100)
8Net Change Actual Searchdecimal(38,38)
9Balance at Date Actual Searchdecimal(38,38)
10Net Change Budget Searchdecimal(38,38)
11Balance at Date Budget Searchdecimal(38,38)
12Net Change Actual Last Year Searchdecimal(38,38)
13Balance at Date Act_ Last Year Searchdecimal(38,38)
14Net Change Budget Last Year Searchdecimal(38,38)
15Balance at Date Bud_ Last Year Searchdecimal(38,38)
16Net Change Forecast Searchdecimal(38,38)
17Balance at Date Forecast Searchdecimal(38,38)
18Dimension Set ID Searchint
19$systemId Searchuniqueidentifier
20$systemCreatedAt Searchdatetime
21$systemCreatedBy Searchuniqueidentifier
22$systemModifiedAt Searchdatetime
23$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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