| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | FMFGHKEY | Hash Key for Facts-Attributes for Ledger 95 | 19 | LEGIS | Type of Legislation | nvarchar | 1 | 0 | | |
TOPAccounting Interface |
2 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 426 | LEGIS | Type of Legislation | nvarchar | 1 | 0 | | |
3 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 426 | LEGIS | Type of Legislation | nvarchar | 1 | 0 | | |
TOPBudgeting |
4 | FMBH | Funds management budget header (entry documents) | 26 | LEGIS | Type of Legislation | nvarchar | 1 | 0 | | |
5 | FMHBH | Funds management budget header (held documents) | 21 | LEGIS | Type of Legislation | nvarchar | 1 | 0 | | |
6 | FMPEP_VARIANTH | Session variants (header part) for transaction FMPEP | 20 | LEGIS | Type of Legislation | nvarchar | 1 | 0 | | |
TOPFunctions for U.S. Federal Government |
7 | FMFGYECLAA | US Federal Gov't : Y/E Pre-Closing of Anticipated Accounts | 8 | LEGIS | Type of Legislation | nvarchar | 1 | 0 | | |
TOPFunds Management |
8 | BPREP_HRFPM_BCS | Variants of Budget Creation for PBC | 12 | LEGIS | Type of Legislation | nvarchar | 1 | 0 | | |
9 | FMFG_SAV_FMUSFGA | Saved FMUSFGA data for docs excluded from SL Repost for 600 | 51 | LEGIS | Type of Legislation | nvarchar | 1 | 0 | | |
10 | FMUSFGA | Actual line item table for US Federal Government. | 51 | LEGIS | Type of Legislation | nvarchar | 1 | 0 | | |
11 | FMUSFGFACTS2O | Object table 1 | 17 | LEGIS | Type of Legislation | nvarchar | 1 | 0 | | |