| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPGeographical Functions |
1 | GEOLOC | Geo location (lon/lat/alt/...) | 8 | PRECISID | Precision (street, postal code, ...) of a Geo location | nvarchar | 4 | 0 | | |
TOPMaintenance Orders |
2 | /MRSS/D_ADDRESS | Stores Primary/Secondary address | 17 | PRECISID | Geolocation Data Source ID/Geocoder ID | nvarchar | 4 | 0 | | |
3 | /MRSS/D_TOUR_ATT | Attributes of Tour (Centroid) | 9 | PRECISID | Geolocation Data Source ID/Geocoder ID | nvarchar | 4 | 0 | | |
TOPTransportation Planning |
4 | /DSD/RP_DEBGEO | Customer's Geo-Coordinates | 5 | PRECISID | Precision (street, postal code, ...) of a Geo location | nvarchar | 4 | 0 | | |
TOPWorkforce Management Core |
5 | /SAPAPO/LRPLOCD | Demand Locations | 8 | PRECISID | Precision (street, postal code, ...) of a Geo location | nvarchar | 4 | 0 | | |
6 | /SAPAPO/LRPLOCR | WFM Supplied Location Table for Resources | 10 | PRECISID | Precision (street, postal code, ...) of a Geo location | nvarchar | 4 | 0 | | |