JDBC Driver for Avalara

Build 22.0.8462

DataSources

DataSources table for AvalaraAvatax data provider.

Insert

To create a data source at least CompanyId and Source should be specified.

INSERT INTO DataSources (CompanyId, Source) VALUES (247015, 'Amazon v2 Extractor')

Update

To update a data source, you need to specify Id and CompanyId in WHERE clause.

UPDATE DataSources SET isEnabled = true WHERE Id = 297 AND CompanyId = 247015

Delete

To delete a user, you need to specify Id and AccountId in WHERE clause.

DELETE FROM DataSources WHERE Id = 297 AND CompanyId = 247015

Columns

Name Type ReadOnly Description
Id [KEY] Int False

The id of the datasource.

CompanyId [KEY] Int False

The id of the company to which the datasource belongs to.

Source String False

The extractor/connector id.

ModifiedUserId Int False

The user ID of the user who last modified this record.

CreatedUserId Int False

The User ID of the user who created this record.

ModifiedDate Datetime False

The date/time when this record was last modified.

IsAuthorized Bool False

True if this data source is authorized.

LastSyncedDate Datetime False

The date when the information was last synched.

IsSynced Bool False

If all the information has been transferred from the extractor to the database.

DeletedDate Datetime False

The date when this record was deleted.

IsEnabled Bool False

The connection using the connectionMyUserd is enabled. The customer is responsible to enable or disable.

Instance String False

The unique ID number of this connection.

CreatedDate Datetime False

The date when this record was created.

Recalculate Bool False

Specifies whether transactions created by this data source needs to re-calculate tax or not

PageKey String False

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