JDBC Driver for Avalara

Build 22.0.8462

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462