JDBC Driver for Avalara

Build 22.0.8462

TaxRules

TaxRules table for AvalaraAvatax data provider.

Insert

You can create custom tax rules to customize the behavior of AvaTax to match specific rules that are custom to your business. If you have obtained a ruling from a tax auditor that requires custom tax calculations, you can use custom tax rules to redefine the behavior for your company or item.

INSERT INTO TaxRules (CompanyId, JurisCode, JurisName, JurisdictionTypeId, TaxRuleTypeId, Country, TaxTypeId, TaxCode, TaxCodeId, TaxTypeGroup, TaxSubType) VALUES ('283040','013','MARICOPA','County','ProductTaxabilityRule', 'US', 'BothSalesAndUseTax','PS081283','85083', 'SalesAndUse', 'ALL')

Update

To update a tax rule, you need to specify Id and CompanyId in WHERE clause.

UPDATE TaxRules SET Description='Freight' WHERE Id = 56789 AND CompanyId = 247015

Delete

To delete a tax rule, you need to specify Id and AccountId in WHERE clause.

DELETE FROM TaxRules WHERE Id=56789 AND CompanyId = 247015

Columns

Name Type ReadOnly Description
Id [KEY] Int False

The unique ID number of this tax rule.

CompanyId [KEY] Int False

The unique ID number of the company that owns this tax rule.

UomId Int False

For tax rules that are calculated using units of measurement, this indicates the unit of measurement type used to calculate the amounts for this rule.

Threshold String False

The per-unit threshold that must be met before this rule applies.

TaxRuleTypeId String False

This type value determines the behavior of the tax rule.

JurisCode String False

The code of the jurisdiction to which this tax rule applies.

EntityUseCode String False

The entity use code to which this rule applies.

NonPassthroughExpression String False

Reserved for Avalara internal usage. Leave this field null.

Description String False

A friendly name for this tax rule.

CreatedDate Datetime False

The date when this record was created.

CountyFIPS String False

For U.S. tax rules, this is the county's Federal Information Processing Standard (FIPS) code.

CreatedUserId Int False

The User ID of the user who created this record.

EndDate Date False

The last date for which this rule applies. If `null`, this rule will apply to all dates after the effective date.

TaxSubType String False

This field has different behavior based on the type of rule. For a product taxability rule, if the rule applies to an item, this value will override the tax sub type of the original product. For other rules, this value determines what tax sub types will be affected by the rule.

ModifiedDate Datetime False

The date/time when this record was last modified.

TaxCode String False

For rules that apply to a specific tax code only, this specifies which tax code is affected by this rule.

Options String False

Supports custom options for your tax rule.

JurisName String False

The name of the jurisdiction to which this tax rule applies.

TaxTypeGroup String False

This field has different behavior based on the type of rule. For a product taxability rule, if the rule applies to an item, this value will override the tax type group of the original product. For other rules, this value determines what tax type groups will be affected by the rule.

JurisdictionTypeId String False

The type of the jurisdiction to which this tax rule applies.

Cap String False

The maximum cap for the price of this item according to this rule. Any amount above this cap will not be subject to this rule.

Country String False

Name or ISO 3166 code identifying the country where this rule will apply.

Value String False

This field has different behavior based on the type of the tax rule. For a product taxability rule, this value is either 1 or 0, indicating taxable or non-taxable. For a rate override rule, this value is the corrected rate stored as a decimal, for example, a rate of 5% would be stored as 0.05 decimal. If you use the special value of 1.0, only the cap and threshold values will be applied and the rate will be left alone.

PreferredProgramId Int False

Reserved for Avalara internal usage. Leave this field null.

CurrencyCode String False

The currency code to use for this rule.

EffectiveDate Date False

The first date at which this rule applies. If `null`, this rule will apply to all dates prior to the end date.

StateFIPS String False

For U.S. tax rules, this is the state's Federal Information Processing Standard (FIPS) code.

RateTypeCode String False

Indicates the code of the rate type that applies to this rule.

ModifiedUserId Int False

The user ID of the user who last modified this record.

Region String False

Name or ISO 3166 code identifying the region where this rule will apply.

TaxTypeId String False

Some tax type groups contain multiple different types of tax. To create a rule that affects only one type of tax within a tax type group, set this value to the code matching the specific tax type within that group.

Sourcing String False

The sourcing types to which this rule applies.

TaxCodeId Int False

For rules that apply to a specific tax code only, this specifies which tax code is affected by this rule.

IsAllJuris Bool False

Allows you to make tax rules apply to lower jurisdictions. This feature is only available in the United States and Canada.

PageKey String False

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462