| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBasic Functions |
| 1 | FILCA | FI-LC: Actual journal entry table with 2 object tables | 19 | RLEVL | Posting level | nvarchar | 1 | 0 | | |
| 2 | FILCC | FI-LC: Transaction-related fields for table FILCT | 3 | RLEVL | Posting level | nvarchar | 1 | 0 | | |
| 3 | FILCP | FI-LC: Plan line items for object table | 19 | RLEVL | Posting level | nvarchar | 1 | 0 | | |
| 4 | FILCT | FI-LC: Global totals table with 2 object tables | 18 | RLEVL | Posting level | nvarchar | 1 | 0 | | |
| 5 | GLPO2 | Plan Line Items for Object Table Global | 20 | RLEVL | Posting level | nvarchar | 1 | 0 | | |
| 6 | GLSO2 | FI-SL Table with Objects, Structure corresponds to GLS2 | 20 | RLEVL | Posting level | nvarchar | 1 | 0 | | |
| 7 | GLTO2 | FI-SL Table with Objects, Structure Corresponds to GLT2 | 17 | RLEVL | Posting level | nvarchar | 1 | 0 | | |
| 8 | T851 | Changes in Investments | 29 | RLEVL | Posting level | nvarchar | 1 | 0 | | |
| 9 | T869 | Consolidation methods | 20 | RLEVL | Posting level for inclusion in consolidation of investments | nvarchar | 1 | 0 | | |
| 10 | T871 | Changes in investee equity | 19 | RLEVL | Posting level | nvarchar | 1 | 0 | | |
| 11 | T876 | Consolidation document types | 4 | RLEVL | Posting level | nvarchar | 1 | 0 | | |
| TOPConsolidation |
| 12 | TF500 | Document Types | 4 | RLEVL | Posting level | nvarchar | 2 | 0 | | |
