JDBC Driver for Avalara

Build 22.0.8462

Settings

Settings table for AvalaraAvatax data provider.

The company settings system is a metadata system that you can use to store extra information about a company. Your integration or connector could use this data storage to keep track of preference information, reminders, or any other storage that would need to persist even if the customer uninstalls your application.

Insert

A setting can refer to any type of data you need to remember about this company object. When creating this object, you may define your own set, name, and value parameters. To define your own values, please choose a set name that begins with X- to indicate an extension. CompanyId, Set and Name are required fields.

INSERT INTO Settings (CompanyId, Set, Name) VALUES (283040, 'ItemsToRemember', 'Texas')

Update

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

UPDATE Settings SET Value = 'Alamo' WHERE Id = 297847 AND CompanyId = 283040

Delete

To delete a setting, you need to specify Id and CompanyId in WHERE clause.

DELETE FROM Settings WHERE Id = 297847 AND CompanyId = 283040

Columns

Name Type ReadOnly Description
Id [KEY] Int False

The unique ID number of this setting.

CompanyId [KEY] Int False

The unique ID number of the company this setting refers to.

Name String False

A user-defined name for this name-value pair.

Value String False

The value of this name-value pair.

Set String False

A user-defined set containing this setting.

PageKey String False

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