| Data element |
Definition |
| Allocatesortorder Indexed - no
Format - Number
May be Null? Y | |
| Categoryid Indexed - no
Format - Number
May be Null? Y | |
| City Indexed - no
Format - Varchar2(240)
May be Null? Y | |
| Comments Indexed - no
Format - Varchar2(800)
May be Null? Y | |
| Countryid Indexed - no
Format - Number
May be Null? Y | |
| Custombit1 Indexed - no
Format - Varchar2(40)
May be Null? Y | |
| Custombit2 Indexed - no
Format - Varchar2(40)
May be Null? Y | |
| Customdate1 Indexed - no
Format - Date
May be Null? Y | |
| Customdate2 Indexed - no
Format - Date
May be Null? Y | |
| Customstring1 Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Customstring2 Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Customstring3 Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Customstring4 Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Customstring5 Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Customstring6 Indexed - no
Format - Varchar2(200)
May be Null? Y | |
| Description Indexed - no
Format - Varchar2(100)
May be Null? Y | |
| Gendertypeenum Indexed - no
Format - Number
May be Null? Y | |
| Lease Indexed - no
Format - Varchar2(40)
May be Null? Y | |
| Nonresidential Indexed - no
Format - Varchar2(40)
May be Null? Y | |
| Recordtypeenum Indexed - no
Format - Number
May be Null? Y | |
| Roomlocationareaid Indexed - no
Format - Number
May be Null? Y | |
| Roomlocationid Indexed - yes
Format - Number
May be Null? N | |
| Stateprovince Indexed - no
Format - Varchar2(240)
May be Null? Y | |
| Viewonweb Indexed - no
Format - Varchar2(40)
May be Null? Y | |
| Webcomments Indexed - no
Format - Clob
May be Null? Y | |
| Webdescription Indexed - no
Format - Varchar2(4000)
May be Null? Y | |
| Webimagelocation Indexed - no
Format - Varchar2(800)
May be Null? Y | |
| Zippostcode Indexed - no
Format - Varchar2(60)
May be Null? Y | |
