DistanceThresholds
DistanceThresholds table for AvalaraAvatax data provider.
A company-distance-threshold model indicates the distance between a company and the taxing borders of various countries. Distance thresholds are necessary to correctly calculate some value-added taxes.
Insert
To create a distance-threshold object you need one of the following user roles: AccountAdmin, CompanyAdmin, CSPAdmin, CSPTester, SiteAdmin, SSTAdmin, SystemAdmin, TechnicalSupportAdmin. At least the following fields should be specified:
INSERT INTO DistanceThresholds (companyId,originCountry,destinationCountry, type) VALUES (283040,'FR','BR', 'Purchase')
Update
To update a distance-threshold, you need to specify Id and CompanyId in WHERE clause.
UPDATE DistanceThresholds SET EffDate = '2019/11/08' WHERE Id = 11785 AND CompanyId = 283040
Delete
To delete a distance-threshold, you need to specify Id and AccountId in WHERE clause.
DELETE FROM DistanceThresholds WHERE Id = 11785 AND CompanyId = 283040
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Int | False |
A unique ID number representing this distance threshold object. |
| CompanyId [KEY] | Int | False |
The ID number of the company that defined this distance threshold. |
| OriginCountry | String | False |
The origin country for this threshold. |
| DestinationCountry | String | False |
The destination country for this threshold. |
| Type | String | False |
Indicates the distance threshold type. This value can be either `Sale` or `Purchase`. |
| EffDate | Datetime | False |
For distance threshold values that change over time, this is the earliest date for which this distance threshold is valid. If null, this distance threshold is valid for all dates earlier than the `endDate` field. |
| EndDate | Datetime | False |
For distance threshold values that change over time, this is the latest date for which this distance threshold is valid. If null, this distance threshold is valid for all dates later than the `effDate` field. |
| ThresholdExceeded | Bool | False |
True if your tax professional has determined that the value-added tax distance threshold is exceeded for this pair of countries. If you set this value to `false`, your value added taxes will be calculated using the origin country. Otherwise, value added taxes will be calculated on the destination country. |
| PageKey | String | False |