| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | VIYCCE2POOL | Cost Elements in Pool | 9 | CAP | Number of CAM Capping Terms | nvarchar | 4 | 0 | | |
2 | VIYCCN | Table for assignment of CAM Terms to a RE Contract | 4 | CAP | Number of CAM Capping Terms | nvarchar | 4 | 0 | | |
3 | VIYCCNPOOL | CAM Pool in CAM Recovery | 11 | CAP | Number of CAM Capping Terms | nvarchar | 4 | 0 | | |
4 | VIYCEXP | Expense Type to Expense Pool | 6 | CAP | Number of CAM Capping Terms | nvarchar | 4 | 0 | | |
5 | VIYCEXPPOOL | Expense Pool in CAM | 18 | CAP | Number of CAM Capping Terms | nvarchar | 4 | 0 | | |
TOPItaly |
6 | T5IT35 | Sender and CoCoCo Sections (Emens Declaration) | 10 | CAP | CoCoCo - Zip code | nvarchar | 5 | 0 | | |
TOPMaster Data |
7 | GMFUNDRECOVER_O | Fund recovery for outgoing grants | 9 | CAP | Grant Revenue Cap | decimal | 12 | 2 | | |
8 | GMGRFUNDRECOVER | Fund recovery | 7 | CAP | Grant Revenue Cap | decimal | 12 | 2 | | |
9 | GMGRIDCCAP | Grant IDC Cap (Program + Class) | 7 | CAP | Maximum IDC allowed | decimal | 12 | 2 | | |
10 | GMGRIDCCAP2 | Grant IDC Cap (Grant level) | 5 | CAP | Maximum IDC allowed | decimal | 12 | 2 | | |
11 | GMGRIDCCAP2_O | Grant IDC Cap (Grant level) for outgoing grant | 6 | CAP | Maximum IDC allowed | decimal | 12 | 2 | | |
12 | GMGRIDCCAP_O | Grant IDC Cap (Program + Class) for outgoing grant | 8 | CAP | Maximum IDC allowed | decimal | 12 | 2 | | |
TOPWorkbench Utilities |
13 | FLIGHTM | Flight master data | 5 | CAP | Capacity | int | 10 | 0 | | |