| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAvailability Control |
1 | BUAVCLDGR | Availability Control Ledger | 2 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
2 | FMAVCBUDFILTB | AVC filter settings for FM budget values: valid budget types | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
3 | FMAVCBUDFILTH | AVC filter settings for FM budget values: header entries | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
4 | FMAVCLDGRACT | Activation of availability ledger for Funds Management | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
5 | FMAVCLDGRATT | Attributes of Availability Control Ledger (Funds Management) | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
6 | FMAVCLDGRGAT | Year-Independent Attributes of Control Ledger (FM) | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
7 | FMAVCUPDFILTH | AVC Filter Settings for FM Posting Data: Header Entries | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
8 | FMAVCUPDFILTV | AVC Filter Settings for Posting Data: Excluded Value Types | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
9 | FMAVC_RBE_SET | AVC Ledger Settings for RBE | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
TOPBudgeting |
10 | FMCECVGRP | Cover Groups | 7 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
11 | FMMACGPERC | Percentage per cover group (Multi-annual budgeting) | 4 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
12 | FMMAPERC | Standard percentage set for multi-annual budgeting | 4 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
TOPBudgeting and Availability Control |
13 | GMAVCBUDFILTH | AVC filter settings for GM budget values: header entries | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
14 | GMAVCLDGRACT | Activation of availability ledger for Grants Management | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
15 | GMAVCLDGRATT | Attributes of Availability Control Ledger -Grants Management | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
16 | GMAVCLDGRGAT | Year-Independent Attributes of Control Ledger (GM) | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
TOPFund Accounting |
17 | FMCCAVCFILTACC | Cash Control filter settings: detail entries | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
18 | FMCCAVCFILTH | Cash Control filter settings: header entries | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
19 | FMCCAVCLDGRACT | Activation of control ledger for Cash Control | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
20 | FMCCAVCLDGRATT | Attributes of Cash Control Ledger (CC) | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |
21 | FMCCAVCLDGRGAT | Year-Independent Attributes of Control Ledger (FMCC) | 3 | ALDNR | Control Ledger | nvarchar | 2 | 0 | | |