| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting Interface |
1 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 423 | BDGT_SUBTYPE | Budget Subtype | nvarchar | 4 | 0 | | |
2 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 423 | BDGT_SUBTYPE | Budget Subtype | nvarchar | 4 | 0 | | |
TOPFunctions for U.S. Federal Government |
3 | FMFGYECLAA | US Federal Gov't : Y/E Pre-Closing of Anticipated Accounts | 7 | BDGT_SUBTYPE | Budget Subtype | nvarchar | 4 | 0 | | |
TOPFunds Management |
4 | FMBUDDIS | Budgetary ledger account derivation: Budgeting (old) | 8 | BDGT_SUBTYPE | Budget Subtype | nvarchar | 4 | 0 | | |
5 | FMBUDRES | Budgetary ledger account derivation: Revenue/Statistical | 8 | BDGT_SUBTYPE | Budget Subtype | nvarchar | 4 | 0 | | |
6 | TBPAS_FTYPE | Budget Subtypes for Availability Control for Each Fund Type | 5 | BDGT_SUBTYPE | Budget Subtype | nvarchar | 4 | 0 | | |
7 | TBPAS_FUND | Budget Subtypes for Availability Control Per Fund | 5 | BDGT_SUBTYPE | Budget Subtype | nvarchar | 4 | 0 | | |