| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAvailability Control |
1 | FMAVCA | Actual line item table | 19 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
2 | FMAVCP | Plan line items table | 19 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
3 | FMAVCT | AVC Summary Table (BCS) | 18 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
TOPBudgeting |
4 | FMBDA | Actual line item table | 19 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
5 | FMBDP | FM Budget change line items table | 19 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
6 | FMBDT | FM budget totals table | 18 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
7 | FMRBA | Actual line item table | 19 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
8 | FMRBP | Plan line items table | 19 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
9 | FMRBT | Summary table | 18 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
TOPCost Element Accounting |
10 | COFIP | Single plan items for reconciliation ledger | 22 | RGRANT_NBR | Receiver Grant | nvarchar | 20 | 0 | | |
11 | COFIS | Actual line items for reconciliation ledger | 22 | RGRANT_NBR | Receiver Grant | nvarchar | 20 | 0 | | |
12 | COFIT | Totals Records for Reconciliation Ledger | 21 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
TOPFund Accounting |
13 | FMCCAVCA | Actual line item table | 17 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
14 | FMCCAVCP | Plan line items table | 17 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
15 | FMCCAVCT | Totals Table | 16 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
16 | FMGLFLEX07 | General Ledger: Reserve Table 1 | 3 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
17 | FMGLFLEXA | General Ledger: Actual Line Items | 26 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
18 | FMGLFLEXP | General Ledger: Plan Line Items | 28 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
19 | FMGLFLEXT | General Ledger Public Sector: Total | 35 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
20 | PSGLFLEX07 | General Ledger: Reserve Table 1 | 3 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
21 | PSGLFLEXA | General Ledger: Actual Line Items | 29 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
22 | PSGLFLEXP | General Ledger: Plan Line Items | 31 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
23 | PSGLFLEXT | General Ledger Public Sector: Total | 38 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
TOPFunds Management |
24 | FMSPLITA | Actual line item table | 23 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
25 | FMSPLITP | Plan line items table | 23 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
26 | FMSPLITT | Summary table | 22 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
TOPGrantee Management |
27 | GMAVCA | Actual line item table | 15 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
28 | GMAVCP | Plan line items table | 15 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
29 | GMAVCT | Summary table | 14 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
30 | GMIA | Actual Line Item Table | 14 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
31 | GMIP | Plan line items table | 14 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
32 | GMIT | Summary table | 13 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |
TOPRevenues and Earnings |
33 | AD01DLI | Dynamic items (DI) | 49 | RGRANT_NBR | Grant | nvarchar | 20 | 0 | | |