| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAvailability Control |
1 | FMAVCA | Actual line item table | 22 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
2 | FMAVCC | Object table 2 | 7 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
3 | FMAVCP | Plan line items table | 22 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
4 | FMAVCT | AVC Summary Table (BCS) | 21 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
TOPBudgeting |
5 | FMBDA | Actual line item table | 21 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
6 | FMBDC | Object table 2 | 9 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
7 | FMBDP | FM Budget change line items table | 21 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
8 | FMBDT | FM budget totals table | 20 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
9 | FMRBA | Actual line item table | 22 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
10 | FMRBC | Object table 2 | 6 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
11 | FMRBP | Plan line items table | 22 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
12 | FMRBT | Summary table | 21 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
TOPFunctions for U.S. Federal Government |
13 | FMFGKEY96 | Key for FACTS - Attributes for Ledger 96/FMUSFGFACTS1T | 12 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
14 | FMFGKEY97 | Key for FACTS - Attributes for Ledger 97/FMUSFGFACTS2T | 11 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
TOPFunds Management |
15 | FMFG_SAV_FACTS1A | Saved FACTS1A data for docs excluded from SL Repost for 600 | 77 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
16 | FMFG_SAV_FACTS2A | Saved FACTS2A data for docs excluded from SL Repost for 600 | 81 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
17 | FMFG_SAV_FMUSFGA | Saved FMUSFGA data for docs excluded from SL Repost for 600 | 95 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
18 | FMUSFGA | Actual line item table for US Federal Government. | 95 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
19 | FMUSFGFACTS1A | 4Actual line item table | 77 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
20 | FMUSFGFACTS1T | Summary table | 74 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
21 | FMUSFGFACTS2A | Actual line item table | 81 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
22 | FMUSFGFACTS2T | Summary table | 78 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |
23 | FMUSFGT | Summary table for US Federal Government | 69 | BUDGET_PD_9 | FM: Budget Period | nvarchar | 10 | 0 | | |