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 |