| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | REFXCN_WF_AGENT | Maintain Workflow Agent for REFX | 4 | RECNTYPE | External Real Estate contract type | nvarchar | 4 | 0 | | |
| 2 | REFXCN_WF_PARAM | Approval Process for Contract Version | 3 | RECNTYPE | External Real Estate contract type | nvarchar | 4 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 3 | TIVXABDCNACCT | FI-CA: Contract Acct Category per Contract and Partner Role | 2 | RECNTYPE | Contract Type | nvarchar | 4 | 0 | | |
| TOPFlexible Real Estate Management |
| 4 | TIVCNCCTBPROLE | OBSOLETE: Role Categories to Be Excluded per Contract Type | 2 | RECNTYPE | Contract Type | nvarchar | 4 | 0 | | |
| 5 | TIVCNOBJ | OBSOLETE: Permitted Object Types per Contract Type | 2 | RECNTYPE | External Real Estate contract type | nvarchar | 4 | 0 | | |
| 6 | TIVHOCCPAR | Mandatsverw: Parameter Kontoauszug | 3 | RECNTYPE | Externe Vertragsart Immobilien | nvarchar | 4 | 0 | | |
| 7 | TIVLSCNSTYPE | LUM: Untervertragsart | 2 | RECNTYPE | Externe Vertragsart Immobilien | nvarchar | 4 | 0 | | |
| 8 | TIVLSCNSTYPET | LUM: Untervertragsart - Texte | 2 | RECNTYPE | Externe Vertragsart Immobilien | nvarchar | 4 | 0 | | |
| TOPLand Use Management |
| 9 | TIVLMCN | LUM Settings per Contract Type | 2 | RECNTYPE | External Real Estate contract type | nvarchar | 4 | 0 | | |
| TOPLocalization |
| 10 | TIVXCJPLICT | Lease-In Contract Types | 2 | RECNTYPE | External Real Estate contract type | nvarchar | 4 | 0 | | |
| 11 | TIVXCPTPOSTPAR | Technical Parameters for Postings and Payments (obsolate) | 10 | RECNTYPE | External Real Estate contract type | nvarchar | 4 | 0 | | |
| 12 | TIVXCPTPOSTPARN | Technical Parameters for Cash Flow Creation | 4 | RECNTYPE | Contract Type | nvarchar | 4 | 0 | | |
| 13 | TIVXCPTSTCNTYPE | Stamp Tax Type - Contract Type Mapping | 2 | RECNTYPE | Contract Type for Stamp Tax | nvarchar | 4 | 0 | | |
| TOPOffer and Rental Request |
| 14 | VIOROF | Contract Offer | 18 | RECNTYPE | Contract Type | nvarchar | 4 | 0 | | |
| TOPPublic Sector Contract Accounts Receivable and Payable |
| 15 | TFMCA_PT_BRFPLUS | BRFPlus Config Table | 2 | RECNTYPE | Contract Type | nvarchar | 4 | 0 | | |
| 16 | TFMCA_TRM_BRFPLS | Test BRFPlus Config Table | 2 | RECNTYPE | Contract Type | nvarchar | 4 | 0 | | |
| TOPReal Estate Contract |
| 17 | VICNCN | Real Estate Contract | 19 | RECNTYPE | Contract Type | nvarchar | 4 | 0 | | |
| TOPReal Estate Management |
| 18 | TIVCN07 | Assignment Contract Type <-> Object Category | 2 | RECNTYPE | External Real Estate contract type | nvarchar | 4 | 0 | | |
| 19 | TIVCNADJT | Contract Type <-> Adjustment Type Assignment | 2 | RECNTYPE | External Real Estate contract type | nvarchar | 4 | 0 | | |
| 20 | VICN01 | Real Estate Contract: Contract Data | 4 | RECNTYPE | External Real Estate contract type | nvarchar | 4 | 0 | | |
| TOPService Charge Settlement |
| 21 | TIVSCCHRGCN | Calculation of Surcharges Dependent on Contract | 3 | RECNTYPE | Contract Type | nvarchar | 4 | 0 | | |
