| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FMFGHKEY | Hash Key for Facts-Attributes for Ledger 95 | 21 | COHORT | Reporting Year for Cohort | nvarchar | 4 | 0 | | |
TOPAccounting Interface |
2 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 424 | COHORT | Reporting Year for Cohort | nvarchar | 4 | 0 | | |
3 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 424 | COHORT | Reporting Year for Cohort | nvarchar | 4 | 0 | | |
TOPBudgeting |
4 | FMBH | Funds management budget header (entry documents) | 24 | COHORT | Reporting Year for Cohort | nvarchar | 4 | 0 | | |
5 | FMHBH | Funds management budget header (held documents) | 19 | COHORT | Reporting Year for Cohort | nvarchar | 4 | 0 | | |
6 | FMPEP_VARIANTH | Session variants (header part) for transaction FMPEP | 18 | COHORT | Reporting Year for Cohort | nvarchar | 4 | 0 | | |
TOPFunds Management |
7 | BPREP_HRFPM_BCS | Variants of Budget Creation for PBC | 11 | COHORT | Reporting Year for Cohort | nvarchar | 4 | 0 | | |
8 | FMFG_SAV_FMUSFGA | Saved FMUSFGA data for docs excluded from SL Repost for 600 | 49 | COHORT | Reporting Year for Cohort | nvarchar | 4 | 0 | | |
9 | FMUSFGA | Actual line item table for US Federal Government. | 49 | COHORT | Reporting Year for Cohort | nvarchar | 4 | 0 | | |
10 | FMUSFGFACTS2O | Object table 1 | 19 | COHORT | Reporting Year for Cohort | nvarchar | 4 | 0 | | |