Information for the Location
Columns
Id
(datatype: int) Required Primary Key
ParentLocationId
(datatype: int) Required Primary Key
Name
(datatype: nvarchar(100)) Required Primary Key
IsActive
(datatype: bit) Required Primary Key
LocationTypeValueId
(datatype: int) Required Primary Key
GeoPoint
(datatype: geography) Required Primary Key
GeoFence
(datatype: geography) Required Primary Key
Street1
(datatype: nvarchar(100)) Required Primary Key
Street2
(datatype: nvarchar(100)) Required Primary Key
City
(datatype: nvarchar(50)) Required Primary Key
State
(datatype: nvarchar(50)) Required Primary Key
Country
(datatype: nvarchar(50)) Required Primary Key
AssessorParcelId
(datatype: nvarchar(50)) Required Primary Key
StandardizeAttemptedDateTime
(datatype: datetime) Required Primary Key
StandardizeAttemptedServiceType
(datatype: nvarchar(50)) Required Primary Key
StandardizeAttemptedResult
(datatype: nvarchar(200)) Required Primary Key
StandardizedDateTime
(datatype: datetime) Required Primary Key
GeocodeAttemptedDateTime
(datatype: datetime) Required Primary Key
GeocodeAttemptedServiceType
(datatype: nvarchar(50)) Required Primary Key
GeocodeAttemptedResult
(datatype: nvarchar(200)) Required Primary Key
GeocodedDateTime
(datatype: datetime) Required Primary Key
PrinterDeviceId
(datatype: int) Required Primary Key
Guid
(datatype: uniqueidentifier) Required Primary Key
CreatedDateTime
(datatype: datetime) Required Primary Key
ModifiedDateTime
(datatype: datetime) Required Primary Key
CreatedByPersonAliasId
(datatype: int) Required Primary Key
ModifiedByPersonAliasId
(datatype: int) Required Primary Key
IsGeoPointLocked
(datatype: bit) Required Primary Key
ForeignKey
(datatype: nvarchar(100)) Required Primary Key
ImageId
(datatype: int) Required Primary Key
PostalCode
(datatype: nvarchar(50)) Required Primary Key
ForeignGuid
(datatype: uniqueidentifier) Required Primary Key
ForeignId
(datatype: int) Required Primary Key
County
(datatype: nvarchar(50)) Required Primary Key
Barcode
(datatype: nvarchar(40)) Required Primary Key
SoftRoomThreshold
(datatype: int) Required Primary Key
FirmRoomThreshold
(datatype: int) Required Primary Key