| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | VIXCITCADAO | Temporary architectural object data | 68 | DSCHLUSS | Final Inspection | nvarchar | 8 | 0 | ||
| Basic Data | ||||||||||
| 2 | VIBDAO | Architectural Object | 65 | DSCHLUSS | Final Inspection | nvarchar | 8 | 0 | ||
| 3 | VIBDBU | Building | 39 | DSCHLUSS | Final Inspection | nvarchar | 8 | 0 | ||
| Loans Management | ||||||||||
| 4 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 212 | DSCHLUSS | Datum des Geschäftsabschlusses | nvarchar | 8 | 0 | ||
| 5 | VDHOBJ | Collateral Objects | 25 | DSCHLUSS | Final Inspection | nvarchar | 8 | 0 | ||
| Real Estate Management | ||||||||||
| 6 | S405 | Building | 74 | DSCHLUSS | Date: final inspection | nvarchar | 8 | 0 | ||
| 7 | VIOB03 | Real estate building master | 24 | DSCHLUSS | Final Inspection | nvarchar | 8 | 0 | ||
| 8 | VIRPS405 | Building | 74 | DSCHLUSS | Final Inspection | nvarchar | 8 | 0 | ||
| Transaction Manager | ||||||||||
| 9 | TRDT_SEC_FLOW | Persistent distributor flows: Part for BEPP adaptor | 16 | DSCHLUSS | Date of business closing | nvarchar | 8 | 0 | ||
| 10 | VWBEPI | Treasury Securities: Actual Flows - Item | 91 | DSCHLUSS | Date of business closing | nvarchar | 8 | 0 | ||
| 11 | VWBEPP | Treasury Securities: Planned Flows | 136 | DSCHLUSS | Date of business closing | nvarchar | 8 | 0 | ||
| 12 | VWORDE | Order Data | 91 | DSCHLUSS | Date of business closing | nvarchar | 8 | 0 | ||