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 |