Items
Items table for AvalaraAvatax data provider.
Select
The provider will use the Avalara API to process WHERE clause conditions built with the following columns and operators. Most of the columns support server side filtering with the following operators: =,>,<,<=,>=,IN,NOT,IN,AND,OR,LIKE. The rest of the filter is executed client side within the provider.
For example, the following query is processed server side:
SELECT * FROM Items WHERE CompanyId = 247015 AND Description LIKE '%MUG' SELECT * FROM Items WHERE CompanyId = 247015 AND ModifiedUserId IN (289767, 1354)
Insert
To add an Item.
INSERT INTO Items (companyId, itemCode, taxCode, description, itemGroup) VALUES ('247015', 'CERMUG1', 'P0000000', 'Ceramic Mug', 'Mugs')")
In order to add an item with ItemsClassifications #TEMP table should be used
INSERT INTO Itemsclassifications#TEMP (productCode, systemCode) VALUES ('P0000000', 'TARIC')") INSERT INTO Items (companyId, itemCode, taxCode, description, itemGroup, Linkedclassifications) VALUES ('247015', 'CERMUG', 'P0000000', 'Ceramic Mug', 'Mugs', 'Itemsclassifications#TEMP')") INSERT INTO Items (companyId, itemCode, taxCode, description, itemGroup) VALUES ('247015', 'CERMUG1', 'P0000000', 'Ceramic Mug', 'Mugs')")
Update
Avalara allows updates to Items columns.
UPDATE Items SET Description = 'description', itemcode = 'CERMUG' WHERE Id = '189117938' AND CompanyId = '247015'
In order to update ItemsClassifications, a #TEMP table should be used.
INSERT INTO Itemsclassifications#TEMP (systemcode, productcode) VALUES ('P0000001', 'AVATAXCEDE')") UPDATE items SET description = 'description', itemcode = 'CERMUG', linkedclassifications = 'Itemsclassifications#TEMP' WHERE id = '189117938' AND companyId = '247015'")
Delete
Items can be deleted by providing the Id of the address and issuing a DELETE statement.
DELETE FROM Items WHERE Id = 100
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | Int | False |
The unique ID number of this item. |
CompanyId [KEY] | Int | False |
The unique ID number of the company that owns this item. |
ItemCode | String | False |
A unique code representing this item. |
ModifiedUserId | Int | False |
The user ID of the user who last modified this record. |
LinkedClassifications | String | False |
List of classifications that belong to this item. A single classification consists of a productCode and a systemCode for a particular item. |
CreatedUserId | Int | False |
The User ID of the user who created this record. |
ItemGroup | String | False |
A way to group similar items. |
ModifiedDate | Datetime | False |
The date/time when this record was last modified. |
Description | String | False |
A friendly description of this item in your product catalog. |
LinkedParameters | String | False |
List of item parameters. |
CreatedDate | Datetime | False |
The date when this record was created. |
TaxCode | String | False |