| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAvailability Control |
| 1 | FMAVC_RBE_SET | AVC Ledger Settings for RBE | 5 | FUND_TYPE | FM Fund Type | nvarchar | 6 | 0 | | |
| TOPFunctions for U.S. Federal Government |
| 2 | FMFG_BL_YRCL | Customizing Budgetary Ledger Year End closing | 5 | FUND_TYPE | FM Fund Type | nvarchar | 6 | 0 | | |
| TOPFunds Management |
| 3 | FMBUDACL | Rules for Closing Residual Ledger Accounts | 5 | FUND_TYPE | FM Fund Type | nvarchar | 6 | 0 | | |
| 4 | FMBUDBCS | Budgetary ledger account derivation: BCS | 7 | FUND_TYPE | FM Fund Type | nvarchar | 6 | 0 | | |
| 5 | FMBUDDIS | Budgetary ledger account derivation: Budgeting (old) | 7 | FUND_TYPE | FM Fund Type | nvarchar | 6 | 0 | | |
| 6 | FMBUDRES | Budgetary ledger account derivation: Revenue/Statistical | 7 | FUND_TYPE | FM Fund Type | nvarchar | 6 | 0 | | |
| 7 | FMBUDREV | Revenue/Statistical Postings & Open items/actuals Resource | 7 | FUND_TYPE | FM Fund Type | nvarchar | 6 | 0 | | |
| 8 | FMBUDSTA | Budgetary ledger account derivation: Open items/Actuals bdgt | 7 | FUND_TYPE | FM Fund Type | nvarchar | 6 | 0 | | |
| 9 | FMCLOSEOUT | Rules for Closing out Obligations | 4 | FUND_TYPE | FM Fund Type | nvarchar | 6 | 0 | | |
| 10 | FMFG_SAV_FMUSFGA | Saved FMUSFGA data for docs excluded from SL Repost for 600 | 77 | FUND_TYPE | FM Fund Type | nvarchar | 6 | 0 | | |
| 11 | FMFUNDTYPE | FM Fund Types | 3 | FUND_TYPE | FM Fund Type | nvarchar | 6 | 0 | | |
| 12 | FMFUNDTYPET | FM Fund Types Texts | 3 | FUND_TYPE | FM Fund Type | nvarchar | 6 | 0 | | |
| 13 | FMSPLITO | Object table 1 | 15 | FUND_TYPE | FM Fund Type | nvarchar | 6 | 0 | | |
| 14 | FMTABADRHFUNDTYP | Assign FM Fund Category to Strategy Environment | 7 | FUND_TYPE | FM Fund Type | nvarchar | 6 | 0 | | |
| 15 | FMUSFGA | Actual line item table for US Federal Government. | 77 | FUND_TYPE | FM Fund Type | nvarchar | 6 | 0 | | |
| 16 | FMUSFGT | Summary table for US Federal Government | 64 | FUND_TYPE | FM Fund Type | nvarchar | 6 | 0 | | |
| TOPReal Estate Management |
| 17 | S402 | Business entities | 75 | FUND_TYPE | IPD: Classification of participant | nvarchar | 1 | 0 | | |
| 18 | TIVROZ01 | IPD: Classification of participant | 2 | FUND_TYPE | IPD: Classification of participant | nvarchar | 1 | 0 | | |
| 19 | TIVROZ0A | IPD: Classification of participant | 3 | FUND_TYPE | IPD: Classification of participant | nvarchar | 1 | 0 | | |
| 20 | VIROZ | Real Estate: IPD reporting additional fields | 4 | FUND_TYPE | IPD: Classification of participant | nvarchar | 1 | 0 | | |
