| DB | Areas | X-idx | Tables | Sequences | <- sys-taxrate | sys-trntype -> | HtmlDict 11 |
Cities, suburbs and postal codes
| Area | SysData |
|---|---|
| Dumpname | town |
| Label | Cities, suburbs and postal codes |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 30 | city | X | City | character | x(24) | |||
| 60 | country-cde | X | Country Code | character | x(3) | |||
| 10 | dist-cde | X | District Code | integer | 999 | 0 | ||
| 50 | post-cde | X | Postal Code | character | 9999 | |||
| 70 | province | X | Province | character | x(15) | |||
| 40 | st-cde | X | Street Code | character | 9999 | |||
| 20 | suburb | X | Suburb | character | x(24) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| city-suburb | P U | city (+) | character |
| suburb (+) | character | ||
| country-cde | country-cde (+) | character | |
| distr-cde | dist-cde (+) | integer | |
| post-cde | post-cde (+) | character | |
| st-cde | st-cde (+) | character | |
| suburb-city | suburb (+) | character | |
| city (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| sys-district |
| generated 24-6-2026 08:41 |