| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPCost Element Accounting |
| 1 | COFIP | Single plan items for reconciliation ledger | 31 | SFUND | Partner Fund | nvarchar | 10 | 0 | | |
| 2 | COFIS | Actual line items for reconciliation ledger | 31 | SFUND | Partner Fund | nvarchar | 10 | 0 | | |
| 3 | COFIT | Totals Records for Reconciliation Ledger | 30 | SFUND | Partner Fund | nvarchar | 10 | 0 | | |
| TOPFund Accounting |
| 4 | FMGLFLEX06 | General ledger: Sender SAP additional account assignment | 5 | SFUND | Partner Fund | nvarchar | 10 | 0 | | |
| 5 | FMGLFLEXA | General Ledger: Actual Line Items | 23 | SFUND | Partner Fund | nvarchar | 10 | 0 | | |
| 6 | FMGLFLEXP | General Ledger: Plan Line Items | 25 | SFUND | Partner Fund | nvarchar | 10 | 0 | | |
| 7 | FMGLFLEXT | General Ledger Public Sector: Total | 32 | SFUND | Partner Fund | nvarchar | 10 | 0 | | |
| 8 | PSGLFLEX06 | General ledger: Sender SAP additional account assignment | 5 | SFUND | Partner Fund | nvarchar | 10 | 0 | | |
| 9 | PSGLFLEXA | General Ledger: Actual Line Items | 25 | SFUND | Partner Fund | nvarchar | 10 | 0 | | |
| 10 | PSGLFLEXP | General Ledger: Plan Line Items | 27 | SFUND | Partner Fund | nvarchar | 10 | 0 | | |
| 11 | PSGLFLEXT | General Ledger Public Sector: Total | 34 | SFUND | Partner Fund | nvarchar | 10 | 0 | | |
| TOPFunds Management |
| 12 | FMSPLITA | Actual line item table | 30 | SFUND | Partner Fund | nvarchar | 10 | 0 | | |
| 13 | FMSPLITP | Plan line items table | 30 | SFUND | Fund | nvarchar | 10 | 0 | | |
| 14 | FMSPLITT | Summary table | 31 | SFUND | Partner Fund | nvarchar | 10 | 0 | | |
| TOPMaster Data |
| 15 | GMOMD | Grants Management Object Mapper Table | 9 | SFUND | Fund on incoming grant | nvarchar | 10 | 0 | | |
