| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CCEE/RSFIAA_NBV | NBV of asset capitalized before 2003 year | 5 | FROM_YEAR | Fiscal year in which first acquisition was posted | nvarchar | 4 | 0 | | |
2 | HRP1714 | DB Table for Infotype 1714 | 21 | FROM_YEAR | External Academic Year in Which Visiting Studies Started | nvarchar | 4 | 0 | | |
TOPAvailability Control |
3 | FMAVCACTCD | Activation of Change Documents for FMAVCT Records | 3 | FROM_YEAR | Fiscal Year From Which Validity Begins | nvarchar | 4 | 0 | | |
4 | FMAVC_RBE_SET | AVC Ledger Settings for RBE | 4 | FROM_YEAR | Fiscal year from which validity begins | nvarchar | 4 | 0 | | |
TOPBudgeting |
5 | FMCONSUM_FTYPE | Consumable budget type for Fund Type | 4 | FROM_YEAR | Fiscal year from which validity begins | nvarchar | 4 | 0 | | |
6 | FMCONSUM_FUND | Consumable budget type for Fund | 4 | FROM_YEAR | Fiscal year from which validity begins | nvarchar | 4 | 0 | | |
7 | FMMAPERC | Standard percentage set for multi-annual budgeting | 5 | FROM_YEAR | Fiscal year from which validity begins | nvarchar | 4 | 0 | | |
8 | FMRBACTCD | Activation of Change Documents for FMRBT Records | 3 | FROM_YEAR | Fiscal Year From Which Validity Begins | nvarchar | 4 | 0 | | |
9 | FMREL_FTYPE | Consumable budget type for Fund Type | 4 | FROM_YEAR | Fiscal year from which validity begins | nvarchar | 4 | 0 | | |
10 | FMREL_FUND | Release settings for Fund | 4 | FROM_YEAR | Fiscal year from which validity begins | nvarchar | 4 | 0 | | |
TOPFunds Management |
11 | FMCLOSEOUT | Rules for Closing out Obligations | 3 | FROM_YEAR | From year | nvarchar | 4 | 0 | | |
12 | TBPAS_FTYPE | Budget Subtypes for Availability Control for Each Fund Type | 3 | FROM_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
13 | TBPAS_FUND | Budget Subtypes for Availability Control Per Fund | 3 | FROM_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |