Database Spec ServiceOptimizer Tables sp563
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
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 |