| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAvailability Control |
1 | FMAVCA | Actual line item table | 14 | RFUND | Fund | nvarchar | 10 | 0 | | |
2 | FMAVCP | Plan line items table | 14 | RFUND | Fund | nvarchar | 10 | 0 | | |
3 | FMAVCT | AVC Summary Table (BCS) | 13 | RFUND | Fund | nvarchar | 10 | 0 | | |
TOPBudgeting |
4 | FMBDA | Actual line item table | 14 | RFUND | Fund | nvarchar | 10 | 0 | | |
5 | FMBDP | FM Budget change line items table | 14 | RFUND | Fund | nvarchar | 10 | 0 | | |
6 | FMBDT | FM budget totals table | 13 | RFUND | Fund | nvarchar | 10 | 0 | | |
7 | FMRBA | Actual line item table | 14 | RFUND | Fund | nvarchar | 10 | 0 | | |
8 | FMRBP | Plan line items table | 14 | RFUND | Fund | nvarchar | 10 | 0 | | |
9 | FMRBT | Summary table | 13 | RFUND | Fund | nvarchar | 10 | 0 | | |
TOPCost Element Accounting |
10 | COFIP | Single plan items for reconciliation ledger | 21 | RFUND | Fund | nvarchar | 10 | 0 | | |
11 | COFIS | Actual line items for reconciliation ledger | 21 | RFUND | Fund | nvarchar | 10 | 0 | | |
12 | COFIT | Totals Records for Reconciliation Ledger | 20 | RFUND | Fund | nvarchar | 10 | 0 | | |
TOPFunctions for U.S. Federal Government |
13 | FMUSFG_TSA | Assign. of FI Doc Type/ Accnt/Fund to Treasury Subclass Code | 4 | RFUND | Fund | nvarchar | 10 | 0 | | |
TOPFund Accounting |
14 | FMCCAVCA | Actual line item table | 15 | RFUND | Fund | nvarchar | 10 | 0 | | |
15 | FMCCAVCP | Plan line items table | 15 | RFUND | Fund | nvarchar | 10 | 0 | | |
16 | FMCCAVCT | Totals Table | 14 | RFUND | Fund | nvarchar | 10 | 0 | | |
17 | FMGLFLEX07 | General Ledger: Reserve Table 1 | 2 | RFUND | Fund | nvarchar | 10 | 0 | | |
18 | FMGLFLEXA | General Ledger: Actual Line Items | 25 | RFUND | Fund | nvarchar | 10 | 0 | | |
19 | FMGLFLEXP | General Ledger: Plan Line Items | 27 | RFUND | Fund | nvarchar | 10 | 0 | | |
20 | FMGLFLEXT | General Ledger Public Sector: Total | 34 | RFUND | Fund | nvarchar | 10 | 0 | | |
21 | PSGLFLEX07 | General Ledger: Reserve Table 1 | 2 | RFUND | Fund | nvarchar | 10 | 0 | | |
22 | PSGLFLEXA | General Ledger: Actual Line Items | 28 | RFUND | Fund | nvarchar | 10 | 0 | | |
23 | PSGLFLEXP | General Ledger: Plan Line Items | 30 | RFUND | Fund | nvarchar | 10 | 0 | | |
24 | PSGLFLEXT | General Ledger Public Sector: Total | 37 | RFUND | Fund | nvarchar | 10 | 0 | | |
TOPFunds Management |
25 | FMFG_SAV_FACTS1A | Saved FACTS1A data for docs excluded from SL Repost for 600 | 15 | RFUND | Fund | nvarchar | 10 | 0 | | |
26 | FMFG_SAV_FACTS2A | Saved FACTS2A data for docs excluded from SL Repost for 600 | 15 | RFUND | Fund | nvarchar | 10 | 0 | | |
27 | FMFG_SAV_FMUSFGA | Saved FMUSFGA data for docs excluded from SL Repost for 600 | 20 | RFUND | Fund | nvarchar | 10 | 0 | | |
28 | FMSPLITA | Actual line item table | 20 | RFUND | Fund | nvarchar | 10 | 0 | | |
29 | FMSPLITP | Plan line items table | 20 | RFUND | Fund | nvarchar | 10 | 0 | | |
30 | FMSPLITT | Summary table | 19 | RFUND | Fund | nvarchar | 10 | 0 | | |
31 | FMUSFGA | Actual line item table for US Federal Government. | 20 | RFUND | Fund | nvarchar | 10 | 0 | | |
32 | FMUSFGFACTS1A | 4Actual line item table | 15 | RFUND | Fund | nvarchar | 10 | 0 | | |
33 | FMUSFGFACTS1P | Plan line items table | 15 | RFUND | Fund | nvarchar | 10 | 0 | | |
34 | FMUSFGFACTS1T | Summary table | 14 | RFUND | Fund | nvarchar | 10 | 0 | | |
35 | FMUSFGFACTS2A | Actual line item table | 15 | RFUND | Fund | nvarchar | 10 | 0 | | |
36 | FMUSFGFACTS2P | Plan line items table | 15 | RFUND | Fund | nvarchar | 10 | 0 | | |
37 | FMUSFGFACTS2T | Summary table | 14 | RFUND | Fund | nvarchar | 10 | 0 | | |
38 | FMUSFGP | Plan line items table | 20 | RFUND | Fund | nvarchar | 10 | 0 | | |
39 | FMUSFGT | Summary table for US Federal Government | 19 | RFUND | Fund | nvarchar | 10 | 0 | | |
TOPGrantee Management |
40 | GMAVCA | Actual line item table | 16 | RFUND | Fund | nvarchar | 10 | 0 | | |
41 | GMAVCP | Plan line items table | 16 | RFUND | Fund | nvarchar | 10 | 0 | | |
42 | GMAVCT | Summary table | 15 | RFUND | Fund | nvarchar | 10 | 0 | | |
43 | GMIA | Actual Line Item Table | 18 | RFUND | Fund | nvarchar | 10 | 0 | | |
44 | GMIP | Plan line items table | 18 | RFUND | Fund | nvarchar | 10 | 0 | | |
45 | GMIT | Summary table | 17 | RFUND | Fund | nvarchar | 10 | 0 | | |
TOPIreland |
46 | T7IEE | EHECS: Return Data | 156 | RFUND | EHECS: Refunds from DSFA & DETE | decimal | 11 | 2 | | |