TaxCodes
TaxCodes table for AvalaraAvatax data provider.
Insert
Create one or more new taxcode objects attached to a company specifying at least CompanyId, TaxCode, TaxCodeTypeId:
INSERT INTO TaxCodes (TaxCode, taxCodeTypeId, CompanyId) VALUES ('PS081283', 'P', '283040')
Update
Avalara allows one of the following user roles: AccountAdmin, CompanyAdmin, CSPTester, SSTAdmin, TechnicalSupportAdmin to update TaxCode objects. CompanyId and Id should be specified in the WHERE clause.
UPDATE TaxCodes SET Description = 'Yarn' WHERE Id = 85083 AND CompanyId = 283040
Delete
To delete a TaxCode object CompanyId and Id should be specified in the WHERE clause:
DELETE FROM TaxCodes WHERE Id = 85083 AND CompanyId = 283040
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | Int | False |
The unique ID number of this tax code. |
CompanyId [KEY] | Int | False |
The unique ID number of the company that owns this tax code. |
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. |
EntityUseCode | String | False |
The Avalara Entity Use Code represented by this tax code. |
ModifiedDate | Datetime | False |
The date/time when this record was last modified. |
TaxCodeTypeId | String | False |
The type of this tax code. |
GoodsServiceCode | Int | False |
The Avalara Goods and Service Code represented by this tax code. |
IsSSTCertified | Bool | False |
True if this tax code has been certified by the Streamlined Sales Tax governing board. |
TaxCode | String | False |
A code string that identifies this tax code. |
Description | String | False |
A friendly description of this tax code. |
IsPhysical | Bool | False |
True if this tax code type refers to a physical object. Read only field. |
IsActive | Bool | False |
True if this tax code is active and can be used in transactions. |
CreatedDate | Datetime | False |
The date when this record was created. |
PageKey | String | False |