| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBudgeting and Availability Control |
1 | GMBASOBJNR | Object numbers of GM addresses | 9 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
2 | GMBDGTFYDLINE | GM Budgeting Fiscal Year Distribution Lines | 8 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
3 | GMBDGTLINE | Budget Document Line | 7 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
4 | GMFMRECS | GM RIB: FM Receivers (obsolete) | 5 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
5 | GMHBDGTFYDLINE | GM Budgeting Fiscal Year Distribution Lines | 9 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
6 | GMHBDGTLINE | Budget Line: Held Documents | 8 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
TOPGrantee Management |
7 | GMAVCO | Object table 1 | 11 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
8 | GMIO | Object table GMIO | 10 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
TOPMaster Data |
9 | GMASPCLASS | Sponsored Class - Sponsor Specific Data | 3 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
10 | GMGRCOSTSHARE | Cost sharing master data | 6 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
11 | GMGRIDCCAP | Grant IDC Cap (Program + Class) | 4 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
12 | GMGRIDCCAP_O | Grant IDC Cap (Program + Class) for outgoing grant | 5 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
13 | GMGRSPONSOREDOBJ | Grant sponsored objects | 4 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
14 | GMGSPCLASS | Grant specific sponsored class details | 3 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
15 | GMINDIRECTCOST | IDC rates for directly sponsored grants [incoming grants] | 4 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
16 | GMINDIRECTCOST_O | Indirect costs for outgoing grants | 5 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
17 | GMINDIRECTCOST_R | Indirect costs for recipient | 4 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
18 | GMSPCLASS | Sponsored Class Master | 2 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
19 | GMSPCLASSTEXTS | Sponsored Class Description texts | 3 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
20 | GMSPCLASS_FMBA | Sponsored Class Master Data - Budget Allowed Object | 2 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
21 | GMSPCLASS_FMBT | Sponsored Class Master Data - Budget Transfer Object | 2 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |
TOPRevenues and Earnings |
22 | AD01DLI | Dynamic items (DI) | 55 | SPONSORED_CLASS | Sponsored Class | nvarchar | 20 | 0 | | |