Diagrams


Table

Acc. Sched. KPI Buffer

Fields

# Name Type
1 No. Integer
2 Date Date
3 Closed Period Boolean
4 Account Schedule Name Code10
5 KPI Code Code10
6 KPI Name Text50
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

# Fields
0 No. Clustered: Yes
1 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