XM_LOCATION
| Entity Name | XM_Location |
|---|---|
| Entity Type | Independent |
| Definition | This table is used for supporting the concept of location. |
Attributes
| Attribute | Datatype | Width | Definition |
|---|---|---|---|
| LOCATION_ID | Integer | 11 | PK |
| STATE_NAME | Varchar | 25 | State name |
| CITY_NAME | Varchar | 52 | City name |
| COUNTRY_NAME | Varchar | 28 | Country name |
| COUNTRY_ISO_CODE | Varchar | 2 | Country iso code |
| TAX_PERCENTAGE | Float | 3 | Tax rate |
| EST_HOTEL_TAX | Float | 3 | Estimate hotel tax |
| EST_CAR_TAX | Float | 3 | Estimate car tax |
| CHANGE_TIMESTAMP | Date Time | ||
| USER_ID | Integer | 11 | Creator user id |
| SUBURB_NAME | Varchar | 255 | Suburb name |
| STREET_NAME | Varchar | 255 | Street name |
| POSTAL_CODE | Varchar | 50 | Postal code |