| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBasic Data |
| 1 | TIVBDLOCHIER | Assignment of Hierarchical Locations to Location Structure | 2 | LOCSYS | ID of Hierarchical Location Structure | nvarchar | 4 | 0 | | |
| 2 | TIVBDLOCITEM | Hierarchical Locations in Location Structure | 2 | LOCSYS | ID of Hierarchical Location Structure | nvarchar | 4 | 0 | | |
| 3 | TIVBDLOCOBJ | Allowed Hier. Location Structures per Object Type | 3 | LOCSYS | ID of Hierarchical Location Structure | nvarchar | 4 | 0 | | |
| 4 | TIVBDLOCSYS | Hierarchical Location Structure | 2 | LOCSYS | ID of Hierarchical Location Structure | nvarchar | 4 | 0 | | |
| 5 | TIVBDLOCSYST | Hierarchical Location Structure - Texts | 3 | LOCSYS | ID of Hierarchical Location Structure | nvarchar | 4 | 0 | | |
| 6 | VIBDLOCHIER | Hierarchical Object Location | 3 | LOCSYS | ID of Hierarchical Location Structure | nvarchar | 4 | 0 | | |
| TOPFunds Management |
| 7 | KBLK_USER | Fields for addtl funds commt, funds precommt etc. hdr data | 6 | LOCSYS | Specification from local system | nvarchar | 20 | 0 | | |
