| 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 | | |