ADO.NET Provider for Avalara

Build 24.0.9060

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060