Objects/Tables/Table 197 Acc. Sched. KPI Buffer

Table 197 Acc. Sched. KPI Buffer in 18

Jonas Paprotka, Base Application 18.5.29545.46345, checked 2026-09-20

App: Base Application

Fields, 17 Keys, 2 Procedures, 2

Versions171819 20 21 22 23 24 25 26 27 28 latest

Source29

Fields, 17

Id	Name	Type	Obsolete
1	No.	Integer	-
2	Date	Date	-
3	Closed Period	Boolean	-
4	Account Schedule Name	Code[10]	-
5	KPI Code	Code[10]	-
6	KPI Name	Text[50]	-
7	Net Change Actual	Decimal	-
8	Balance at Date Actual	Decimal	-
9	Net Change Budget	Decimal	-
10	Balance at Date Budget	Decimal	-
11	Net Change Actual Last Year	Decimal	-
12	Balance at Date Act. Last Year	Decimal	-
13	Net Change Budget Last Year	Decimal	-
14	Balance at Date Bud. Last Year	Decimal	-
15	Net Change Forecast	Decimal	-
16	Balance at Date Forecast	Decimal	-
17	Dimension Set ID	Integer	-

Keys, 2

Name	Fields	Obsolete
Key1, clustered	No.	-
Key2	Account Schedule Name, KPI Code, Dimension Set ID	-

Procedures, 2

Name	Parameters	Returns	Access	Obsolete
AddColumnValue	(Record Column Layout, Decimal)		public	-
GetColumnValue	(Record Column Layout)	Decimal	public	-