| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPOffer and Rental Request |
| 1 | TIVORBPROLEMOD | Transfer of Role from Contract Offer to Role in RE Contract | 2 | CNTYPE | Contract Type | nvarchar | 4 | 0 | | |
| TOPPhilippines |
| 2 | T7PHRS | Receipt number and Issue dates-Company Grouping. | 2 | CNTYPE | Social Security System (SSS) Contribution Type | nvarchar | 2 | 0 | | |
| TOPReal Estate Contract |
| 3 | TIVCNMEASCN | Measurement: Settings per Contract Type | 3 | CNTYPE | Contract Type | nvarchar | 4 | 0 | | |
| TOPRental Accounting |
| 4 | TIVEXCNTYPE | Funds Management Settings for Contract Type | 2 | CNTYPE | Contract Type | nvarchar | 4 | 0 | | |
| TOPTour Status |
| 5 | /DSD/ST_CSCEN_SH | Assignment shipment <-> delivery scenario | 2 | CNTYPE | Connected medium (mobile, paper) | nvarchar | 1 | 0 | | |
| 6 | /DSD/ST_CSCEN_VL | Assignment visit list <-> sales scenario | 2 | CNTYPE | Connected medium (mobile, paper) | nvarchar | 1 | 0 | | |
| 7 | /DSD/ST_CTYPE_SH | Shipment relevant for DSD | 4 | CNTYPE | Connected medium (mobile, paper) | nvarchar | 1 | 0 | | |
| 8 | /DSD/ST_CTYPE_VL | Visit list relevant for DSD | 3 | CNTYPE | Connected medium (mobile, paper) | nvarchar | 1 | 0 | | |
