Table 197 "Acc. Sched. KPI Buffer"

Base Application · Microsoft.Finance.FinancialReports · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 198 “Acc. Sched. KPI WS Dimensions” (7 Learn pages), Page 197 “Acc. Sched. KPI Web Service” (6).

Properties

Property	Value
Caption	Acc. Sched. KPI Buffer
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	No. Δ BC29	Integer	Specifies the number of the involved entry or record, according to the specified number series.	DataClassification SystemMetadata
2	Date Δ BC29	Date	Specifies the date on which the KPI figures are calculated.	DataClassification SystemMetadata
3	Closed Period Δ BC29	Boolean	Specifies whether the fiscal year is closed.	DataClassification SystemMetadata
4	Account Schedule Name Δ BC29	Code[10]	Specifies the name of the account schedule that the KPI web service is based on.	DataClassification SystemMetadata
5	KPI Code Δ BC29	Code[10]	Specifies a code for the financial report KPI web service.	DataClassification SystemMetadata
6	KPI Name Δ BC29	Text[50]	Specifies a name of the account-schedule KPI web service.	DataClassification SystemMetadata
7	Net Change Actual Δ BC28 Δ BC29	Decimal	Specifies changes in the actual general ledger amount, for closed accounting periods, up until the date in the Date field.	DataClassification SystemMetadata
8	Balance at Date Actual Δ BC28 Δ BC29	Decimal	Specifies the actual general ledger balance, based on closed accounting periods, on the date in the Date field.	DataClassification SystemMetadata
9	Net Change Budget Δ BC28 Δ BC29	Decimal	Specifies changes in the budgeted general ledger amount, based on the general ledger budget, up until the date in the Date field.	DataClassification SystemMetadata
10	Balance at Date Budget Δ BC28 Δ BC29	Decimal	Specifies the budgeted general ledger balance, based on the general ledger budget, on the date in the Date field.	DataClassification SystemMetadata
11	Net Change Actual Last Year Δ BC28 Δ BC29	Decimal	Specifies actual changes in the general ledger amount, based on closed accounting periods, up until the date in the Date field in the previous accounting year.	DataClassification SystemMetadata
12	Balance at Date Act. Last Year Δ BC28 Δ BC29	Decimal	Specifies the actual general ledger balance, based on closed accounting periods, on the date in the Date field in the previous accounting year.	DataClassification SystemMetadata
13	Net Change Budget Last Year Δ BC28 Δ BC29	Decimal	Specifies budgeted changes in the general ledger amount, based on the general ledger budget, up until the date in the Date field in the previous year.	DataClassification SystemMetadata
14	Balance at Date Bud. Last Year Δ BC28 Δ BC29	Decimal	Specifies the budgeted general ledger balance, based on the general ledger budget, on the date in the Date field in the previous accounting year.	DataClassification SystemMetadata
15	Net Change Forecast Δ BC28 Δ BC29	Decimal	Specifies forecasted changes in the general ledger amount, based on open accounting periods, up until the date in the Date field.	DataClassification SystemMetadata
16	Balance at Date Forecast Δ BC28 Δ BC29	Decimal	Specifies the forecasted general ledger balance, based on open accounting periods, on the date in the Date field.	DataClassification SystemMetadata
17	Dimension Set ID Δ BC29	Integer	Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table.	DataClassification SystemMetadata

Keys

Key1: No. (clustered)
Key2: Account Schedule Name, KPI Code, Dimension Set ID

Procedures

AddColumnValue(ColumnLayout: Record "Column Layout"; Value: Decimal): Adds a calculated value to the appropriate KPI field based on column layout configuration. Determines whether to update actual, budget, forecast, or comparative values.
GetColumnValue(ColumnLayout: Record "Column Layout"): Decimal: Retrieves the appropriate KPI value based on column layout configuration and calculation parameters. Returns actual, budget, forecast, or comparative values depending on column type and date formula.

Pages and codeunits on this table

Page 197 “Acc. Sched. KPI Web Service” (source table)
Page 198 “Acc. Sched. KPI WS Dimensions” (source table)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Acc. Sched. KPI Buffer"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.