| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPFlexible Real Estate Management |
| 1 | VIAKHOBD | DTA externe HKA D-Band Übernahme | 10 | ABNNR | Identifikation des Mietvertrags beim Abrechnungsunternehmen | nvarchar | 20 | 0 | | |
| 2 | VIAKHODD | DTA externe HKA D-Band Diskette Übernahme | 8 | ABNNR | Identifikation des Mietvertrags beim Abrechnungsunternehmen | nvarchar | 20 | 0 | | |
| TOPMerchandise Distribution |
| 3 | FRET | Assignment of Procurement to Issue Docs in Mdse Distribution | 30 | ABNNR | Number of recipient | nvarchar | 10 | 0 | | |
| TOPPurchasing |
| 4 | WDFR_POET | Perishables Planning Item Delivery Phase | 10 | ABNNR | Item number of inbound document buffer | nvarchar | 5 | 0 | | |
| TOPReal Estate Management |
| 5 | S406 | Rental units | 92 | ABNNR | Settlement firm: number | nvarchar | 20 | 0 | | |
| 6 | S407 | Rental agreements | 23 | ABNNR | Settlement firm: number | nvarchar | 20 | 0 | | |
| 7 | VIMI01 | Rental unit - Master data | 53 | ABNNR | Identification of lease-out at settlement company | nvarchar | 20 | 0 | | |
| 8 | VIMI04 | Old. replaced in 3.0 with VIMIMV | 73 | ABNNR | Identification of lease-out at settlement company | nvarchar | 20 | 0 | | |
| 9 | VIMIMV | Lease-Out | 53 | ABNNR | Identification of lease-out at settlement company | nvarchar | 20 | 0 | | |
| 10 | VIRPS406 | Rental units | 91 | ABNNR | Settlement firm: number | nvarchar | 20 | 0 | | |
| 11 | VIRPS407 | Rental agreements | 23 | ABNNR | Settlement firm: number | nvarchar | 20 | 0 | | |
