| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAvailability Control |
1 | FMAVCBUDFILTB | AVC filter settings for FM budget values: valid budget types | 5 | FISCYEARFROM | Fiscal Year From Which Validity Begins | nvarchar | 4 | 0 | | |
2 | FMAVCBUDFILTH | AVC filter settings for FM budget values: header entries | 5 | FISCYEARFROM | Fiscal Year From Which Validity Begins | nvarchar | 4 | 0 | | |
3 | FMAVCLDGRACT | Activation of availability ledger for Funds Management | 4 | FISCYEARFROM | Fiscal Year From Which Validity Begins | nvarchar | 4 | 0 | | |
4 | FMAVCLDGRATT | Attributes of Availability Control Ledger (Funds Management) | 5 | FISCYEARFROM | Fiscal Year From Which Validity Begins | nvarchar | 4 | 0 | | |
5 | FMAVCUPDFILTH | AVC Filter Settings for FM Posting Data: Header Entries | 4 | FISCYEARFROM | Fiscal Year From Which Validity Begins | nvarchar | 4 | 0 | | |
6 | FMAVCUPDFILTV | AVC Filter Settings for Posting Data: Excluded Value Types | 4 | FISCYEARFROM | Fiscal Year From Which Validity Begins | nvarchar | 4 | 0 | | |
TOPBudgeting |
7 | FMBS_HIE_ACT | Activation of Hierarchical Budget Structure | 3 | FISCYEARFROM | Fiscal Year From Which Validity Begins | nvarchar | 4 | 0 | | |
TOPBudgeting and Availability Control |
8 | GMAVCBUDFILTH | AVC filter settings for GM budget values: header entries | 5 | FISCYEARFROM | AVC filter settings for GM budgeting, header part | nvarchar | 4 | 0 | | |
9 | GMAVCLDGRACT | Activation of availability ledger for Grants Management | 4 | FISCYEARFROM | AVC filter settings for GM budgeting, header part | nvarchar | 4 | 0 | | |
10 | GMAVCLDGRATT | Attributes of Availability Control Ledger -Grants Management | 4 | FISCYEARFROM | Fiscal Year From Which Validity Begins | nvarchar | 4 | 0 | | |
TOPFund Accounting |
11 | FMCCAVCFILTACC | Cash Control filter settings: detail entries | 5 | FISCYEARFROM | Cash ctl filter settings for consumable cash, header part | nvarchar | 4 | 0 | | |
12 | FMCCAVCFILTH | Cash Control filter settings: header entries | 5 | FISCYEARFROM | Cash ctl filter settings for consumable cash, header part | nvarchar | 4 | 0 | | |
13 | FMCCAVCLDGRACT | Activation of control ledger for Cash Control | 4 | FISCYEARFROM | Cash ctl filter settings for consumable cash, header part | nvarchar | 4 | 0 | | |
14 | FMCCAVCLDGRATT | Attributes of Cash Control Ledger (CC) | 4 | FISCYEARFROM | Fiscal Year From Which Validity Begins | nvarchar | 4 | 0 | | |