Power BI Connector for Avalara

Build 24.0.9060

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

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