Acc. Sched. KPI Buffer – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables AAcc. 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

   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Acc_ Sched_ KPI Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Sched. KPI Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Acc_ Schedule Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Schedule Name]
      ON
         [Acc. Sched. KPI Buffer].[Account Schedule Name] = [Acc. Schedule Name].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Acc. Sched. KPI Buffer].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Acc. Sched. KPI Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Acc. Sched. KPI Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Acc. Sched. KPI Buffer table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	No.	No.	Normal	Integer	4	No_	int
2	Date	Date	Normal	Date	4	Date	datetime
3	Closed Period	Closed Period	Normal	Boolean	4	Closed Period	tinyint
4	Account Schedule Name	Row Definition Name	Normal	Code	10	Account Schedule Name	nvarchar(20)
	Key to join to the Acc. Schedule Name table. Show/hide example query SELECT [Acc. Sched. KPI Buffer].[Account Schedule Name] ,[Acc. Schedule Name].[Name] FROM [CRONUS UK Ltd_$Acc_ Sched_ KPI Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Sched. KPI Buffer] LEFT JOIN [CRONUS UK Ltd_$Acc_ Schedule Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Schedule Name] ON [Acc. Sched. KPI Buffer].[Account Schedule Name] = [Acc. Schedule Name].[Name]
5	KPI Code	KPI Code	Normal	Code	10	KPI Code	nvarchar(20)
6	KPI Name	KPI Name	Normal	Text	50	KPI Name	nvarchar(100)
7	Net Change Actual	Net Change Actual	Normal	Decimal	12	Net Change Actual	decimal(38,38)
8	Balance at Date Actual	Balance at Date Actual	Normal	Decimal	12	Balance at Date Actual	decimal(38,38)
9	Net Change Budget	Net Change Budget	Normal	Decimal	12	Net Change Budget	decimal(38,38)
10	Balance at Date Budget	Balance at Date Budget	Normal	Decimal	12	Balance at Date Budget	decimal(38,38)
11	Net Change Actual Last Year	Net Change Actual Last Year	Normal	Decimal	12	Net Change Actual Last Year	decimal(38,38)
12	Balance at Date Act. Last Year	Balance at Date Act. Last Year	Normal	Decimal	12	Balance at Date Act_ Last Year	decimal(38,38)
13	Net Change Budget Last Year	Net Change Budget Last Year	Normal	Decimal	12	Net Change Budget Last Year	decimal(38,38)
14	Balance at Date Bud. Last Year	Balance at Date Bud. Last Year	Normal	Decimal	12	Balance at Date Bud_ Last Year	decimal(38,38)
15	Net Change Forecast	Net Change Forecast	Normal	Decimal	12	Net Change Forecast	decimal(38,38)
16	Balance at Date Forecast	Balance at Date Forecast	Normal	Decimal	12	Balance at Date Forecast	decimal(38,38)
17	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	Key to join to the Dimension Set Entry table. Show/hide example query SELECT [Acc. Sched. KPI Buffer].[Dimension Set ID] ,[Dimension Set Entry].[Dimension Set ID] FROM [CRONUS UK Ltd_$Acc_ Sched_ KPI Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Sched. KPI Buffer] LEFT JOIN [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry] ON [Acc. Sched. KPI Buffer].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Acc. Sched. KPI Buffer].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Acc_ Sched_ KPI Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Acc. Sched. KPI Buffer] LEFT JOIN [User] AS [User] ON [Acc. Sched. KPI Buffer].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier