| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPLoans Management |
1 | TTONFTVVZZKOPO | Test neue Fima: VVZZKOPO | 31 | SPARTNR | Geschäftspartnernummer | nvarchar | 10 | 0 | | |
2 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 130 | SPARTNR | Geschäftspartnernummer | nvarchar | 10 | 0 | | |
3 | VDBLKO | Debit types-Header data | 2 | SPARTNR | Business Partner Number | nvarchar | 10 | 0 | | |
4 | VDBLPO | Debit types-Items | 2 | SPARTNR | Business Partner Number | nvarchar | 10 | 0 | | |
TOPMaster Data |
5 | VDESCROWKOPO0 | TEMPORARY USE: Escrow Condition Items | 30 | SPARTNR | Business Partner Number | nvarchar | 10 | 0 | | |
TOPReal Estate Management |
6 | S406 | Rental units | 116 | SPARTNR | Partner number | nvarchar | 10 | 0 | | |
7 | S407 | Rental agreements | 126 | SPARTNR | Partner number | nvarchar | 22 | 0 | | |
8 | VICN01 | Real Estate Contract: Contract Data | 47 | SPARTNR | Business Partner Number | nvarchar | 10 | 0 | | |
9 | VIEIGE | Owners of real estate objects | 8 | SPARTNR | Business Partner Number | nvarchar | 10 | 0 | | |
10 | VIEIGT | OLD, replaced by VIEIGE in 3.0 | 8 | SPARTNR | Partner number | nvarchar | 10 | 0 | | |
11 | VIMI04 | Old. replaced in 3.0 with VIMIMV | 79 | SPARTNR | Alternative payer (partner number) | nvarchar | 10 | 0 | | |
12 | VIMI33 | Offers for a rental unit (-> VIMIMV) | 45 | SPARTNR | Partner number | nvarchar | 10 | 0 | | |
13 | VIMIEV | Supplementary lease-outs | 6 | SPARTNR | Alternative payer (partner number) | nvarchar | 10 | 0 | | |
14 | VIMIMV | Lease-Out | 59 | SPARTNR | Alternative payer (partner number) | nvarchar | 10 | 0 | | |
15 | VIRPS406 | Rental units | 115 | SPARTNR | Partner number | nvarchar | 10 | 0 | | |
16 | VIRPS407 | Rental agreements | 126 | SPARTNR | Partner number | nvarchar | 10 | 0 | | |
TOPReceivablesPayment Management |
17 | VDAD_CONTROL | Table with Dates for Auto Debit Run | 4 | SPARTNR | Business Partner Number | nvarchar | 10 | 0 | | |
TOPTreasury |
18 | VZZKOPO | Table condition items | 33 | SPARTNR | Business Partner Number | nvarchar | 10 | 0 | | |