| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBudgeting |
1 | FMROLLUP_FTYPE | Preclosing Rollup: Transfer Rules for Fund Type | 4 | FUND_STATUS | FM Fund Status (Unexpired, Expired, Cancelled) | nvarchar | 1 | 0 | | |
2 | FMROLLUP_FUND | Preclosing Rollup: Transfer Rules for Fund | 4 | FUND_STATUS | FM Fund Status (Unexpired, Expired, Cancelled) | nvarchar | 1 | 0 | | |
TOPFunctions for U.S. Federal Government |
3 | FMFG_BL_YRCL | Customizing Budgetary Ledger Year End closing | 6 | FUND_STATUS | FM Fund Status (Unexpired, Expired, Cancelled, *) | nvarchar | 1 | 0 | | |
TOPFunds Management |
4 | FMBPCLOSE_FTYPE | Preclosing Rollup: Transfer Rules for Fund Type | 4 | FUND_STATUS | FM Fund Status (Unexpired, Expired, Cancelled) | nvarchar | 1 | 0 | | |
5 | FMBPCLOSE_FUND | Preclosing Rollup: Transfer Rules for Fund | 4 | FUND_STATUS | FM Fund Status (Unexpired, Expired, Cancelled) | nvarchar | 1 | 0 | | |
6 | FMBUDACL | Rules for Closing Residual Ledger Accounts | 7 | FUND_STATUS | FM Fund Status (Unexpired, Expired, Cancelled) | nvarchar | 1 | 0 | | |
7 | FMBUDREV | Revenue/Statistical Postings & Open items/actuals Resource | 11 | FUND_STATUS | FM Fund Status (Unexpired, Expired, Cancelled) | nvarchar | 1 | 0 | | |
8 | FMBUDSTA | Budgetary ledger account derivation: Open items/Actuals bdgt | 11 | FUND_STATUS | FM Fund Status (Unexpired, Expired, Cancelled) | nvarchar | 1 | 0 | | |
9 | FMCLOSEOUT | Rules for Closing out Obligations | 6 | FUND_STATUS | FM Fund Status (Unexpired, Expired, Cancelled) | nvarchar | 1 | 0 | | |