| 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 | 8 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
2 | GMBDGTFYDLINE | GM Budgeting Fiscal Year Distribution Lines | 7 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
3 | GMBDGTLINE | Budget Document Line | 6 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
4 | GMFMRECS | GM RIB: FM Receivers (obsolete) | 4 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
5 | GMHBDGTFYDLINE | GM Budgeting Fiscal Year Distribution Lines | 8 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
6 | GMHBDGTLINE | Budget Line: Held Documents | 7 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
TOPGrantee Management |
7 | GMAVCO | Object table 1 | 10 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
8 | GMIO | Object table GMIO | 9 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
TOPMaster Data |
9 | GMASPPROG | Sponsored Program - Sponsor Specific Data | 3 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
10 | GMGRCOSTSHARE | Cost sharing master data | 5 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
11 | GMGRIDCCAP | Grant IDC Cap (Program + Class) | 3 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
12 | GMGRIDCCAP_O | Grant IDC Cap (Program + Class) for outgoing grant | 4 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
13 | GMGRSPONSOREDOBJ | Grant sponsored objects | 3 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
14 | GMGSPPROGRAM | Grant specific sponsored program details | 3 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
15 | GMINDIRECTCOST | IDC rates for directly sponsored grants [incoming grants] | 3 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
16 | GMINDIRECTCOST_O | Indirect costs for outgoing grants | 4 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
17 | GMINDIRECTCOST_R | Indirect costs for recipient | 3 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
18 | GMSPPROGRAM | Sponsored program master | 2 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
19 | GMSPPROGRAMTEXTS | Sponsored Program texts | 3 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
20 | GMSPPROGRAM_FMBA | Sponsored Program Master Data - Budget Allowed Object | 2 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
21 | GMSPPROGRAM_FMBT | Sponsored Program Master Data - Budget Transfer Objects | 2 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
22 | GMSPRESPONSIBLE | Objects responsible for the sponsored program | 2 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |
TOPRevenues and Earnings |
23 | AD01DLI | Dynamic items (DI) | 54 | SPONSORED_PROG | Sponsored Program | nvarchar | 20 | 0 | | |