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