Diagrams


Table

Acc. Sched. KPI Buffer

Fields

# Name Type
1 No. (No.) Integer
2 Date (Date) Date
3 Closed Period (Closed Period) Boolean
4 Account Schedule Name (Account Schedule Name) Code10
5 KPI Code (KPI Code) Code10
6 KPI Name (KPI Name) Text50
7 Net Change Actual (Net Change Actual) Decimal
8 Balance at Date Actual (Balance at Date Actual) Decimal
9 Net Change Budget (Net Change Budget) Decimal
10 Balance at Date Budget (Balance at Date Budget) Decimal
11 Net Change Actual Last Year (Net Change Actual Last Year) Decimal
12 Balance at Date Act. Last Year (Balance at Date Act. Last Year) Decimal
13 Net Change Budget Last Year (Net Change Budget Last Year) Decimal
14 Balance at Date Bud. Last Year (Balance at Date Bud. Last Year) Decimal
15 Net Change Forecast (Net Change Forecast) Decimal
16 Balance at Date Forecast (Balance at Date Forecast) Decimal
17 Dimension Set ID (Dimension Set ID) Integer

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Account Schedule Name,KPI Code,Dimension Set ID (Account Schedule Name,KPI Code,Dimension Set ID)

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field