14.1 Database Spec ServiceOptimizer Tables sp563
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table holds the definitions of the GEOCODE CACHE
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| ID | int | unique | |
| POSTCODE | varchar(30) | ||
| ADDRESS1 | varchar(50) |  | |
| ADDRESS2 | varchar(50) | | |
| ADDRESS3 | varchar(50) | | |
| ADDRESS4 | varchar(50) | | |
| LAT | number(18,9) | ||
| LON | number(18,9) | ||
| TIMESTAMP | datetime | systime |
Keys
Address1, Address2, Address3, Address4, Postcode
Column Descriptions
| Field | Description |
|---|---|
| ID | Unique ID of the GeoCode being passed |
| POSTCODE | Postcode field intended for customer address data |
| ADDRESS1 | Free text field intended for customer address data |
| ADDRESS2 | Free text field intended for customer address data |
| ADDRESS3 | Free text field intended for customer address data |
| ADDRESS4 | Free text field intended for customer address data |
| LAT | Latitude details of the customer address |
| LON | Longitude details of the customer address |
| TIMESTAMP | Generated by Scheduling |