| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OA2_SR_CTX | OAuth2 ServerContext (Server Implementation, Runtime) | 7 | GRANT_TYPE | OAuth 2.0 Grant Type | nvarchar | 1 | 0 | | |
2 | CMACGRANT | Grant Master Data | 3 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
TOPActual Update and Commitment Update |
3 | GMREVBDGTFM1 | Defult settings for GM revaluation of currency | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
TOPBudgeting and Availability Control |
4 | GMBDGTFM | FM defaults for Interface with GM Budget | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
TOPGrantee Management |
5 | GMDEFARCHIVE | Define Archiving Settings for GM | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
TOPMaster Data |
6 | GMBDGTLAYOUT | Grants Management Budget Layout | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
7 | GMCOA | Special GL accounts in chart of accounts for grants mgmt | 3 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
8 | GMFGC | Obsolete - do not use. | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
9 | GMFGC_1 | Obsolete - do not use | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
10 | GMFGC_LIFE | Field group criteria (Grants) | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
11 | GMFGC_USER | Field group criteria (Grants) system+user status | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
12 | GMGR | Grant Master | 8 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
13 | GMGRTYPE | Grant type | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
14 | GMGRTYPEREPORT | GM Reports from Grant Type | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
15 | GMGRTYPETEXTS | Grant type texts | 3 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
16 | GMGTSPONSOR | Sponsor Master: Grant Type dependant attributes | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
17 | GMRMGRTYPE | Grant Types - Records Managment Interface | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
18 | GMRMGRTYPE_ACT | Grant Types - Records Management Interface | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
19 | GMSMVALUETYPE | Value type control by grant type and status | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
20 | GMSMVALUETYPE_1 | Value type control by grant type and status | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
21 | GMSPAGT | Allowed Grant Types for Sponsor | 3 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
22 | GMSTATNET | Grants Management Status Network | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |
23 | GMSTATNET_INT | Grants Management Status Network | 2 | GRANT_TYPE | Grant Type | nvarchar | 2 | 0 | | |