接続の確立

Avalara への接続を追加

Avalara への接続を追加するには：

アプリケーションコンソールで、接続ページに移動します。
接続の追加パネルで、追加したい接続のアイコンを選択します。
Avalara アイコンが利用できない場合は、Add More アイコンをクリックしてCData サイトからAvalara コネクタをダウンロードおよびインストールします。

必須プロパティについては、設定タブを参照してください。

通常必須ではない接続プロパティについては、高度な設定タブを参照してください。

Connecting to Avalara

By default, the Sync App connects to a production environment. Set UseSandbox to true to configure the Sync App to connect to a Avalara sandbox environment.

Authenticating to Avalara

There are two authentication methods available for connecting to the Avalara data source: Basic and LicenseKey.

Login Credentials

To use login credentials for authentication, set the following:

AuthScheme: Set this to Basic.
User: Set this to your Avalara username.
Password: Set this to your Avalara password.

Account Number and License Key

Alternatively, you can authenticate using your account number and license key. Connect to the data source using the following:

AuthScheme: Set this to LicenseKey.
AccountId: Set this to your Avalara Account Id. The Account Id is listed in the upper right-hand corner of the Avalara admin console.
LicenseKey: Set this to your Avalara license key. You can generate a license key by logging into Avalara as an account adminstrator and navigating to Settings > Reset License Key.

データアクセスのファインチューニング

Fine Tuning Data Access

You can use the following properties to gain more control over the data returned from Avalara:

CompanyCode: Only transaction information tied to this company code will be returned.
IncludeAdjustedTransactions: Set this to true to include adjusted transactions in the transaction listing.

高度な機能

このセクションでは、Avalara Sync App の高度な機能を厳選して説明します。

ユーザー定義ビュー

Sync App はユーザー定義ビューの使用をサポートします。これは事前設定されたユーザー定義クエリによって内容が決定される仮想テーブルです。このビューは、ドライバーに発行されるクエリを直接制御できない場合に有効です。カスタムビューの作成と設定の概要については、ユーザー定義ビューを参照してください。

SSL の設定

SSL の設定を使用して、Sync App が証明書のネゴシエーションをどのように扱うかを調整します。さまざまな証明書形式を選択できます。詳しくは、「接続文字列オプション」にあるSSLServerCert プロパティを参照してください。

ファイアウォールとプロキシ

Windows プロキシとHTTP プロキシを含むファイアウォールとプロキシに合致するようSync App を設定します。トンネル接続を設定することもできます。

クエリ処理

Sync App は、Avalara にできるだけ多くのSELECT ステートメント処理をオフロードし、残りのクエリをクライアント側のインメモリで処理します。

詳しくは、クエリ処理を参照してください。

ログ

CData ログを調整するために使用可能な設定の概要については、ログを参照してください。基本的なロギングに必要なのは2つの接続プロパティだけですが、より詳細なロギングをサポートする多くの機能があり、LogModules 接続プロパティを使用してロギングする情報のサブセットを指定することができます。

SSL の設定

SSL 設定のカスタマイズ

デフォルトでは、Sync App はサーバーとのTLS のネゴシエーションを試みます。サーバー証明書は、デフォルトのシステム信頼済み証明書ストアで検証されます。SSLServerCert 接続プロパティを使用して、証明書の検証方法をオーバーライドできます。

別の証明書を指定するには、SSLServerCert 接続プロパティを参照してください。

ファイアウォールとプロキシ

Firewall またはProxy 経由の接続

HTTP プロキシ

HTTP プロキシへの認証には、以下のように設定します。

ProxyServer：HTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレス。
ProxyPort：プロキシサーバーが起動しているTCP ポート。
ProxyAuthScheme：プロキシサーバーに対して認証する際にSync App が使用する認証方法。
ProxyUser：プロキシサーバーに登録されているユーザーアカウントのユーザー名。
ProxyPassword：ProxyUser に紐付けられたパスワード。

その他のプロキシ

次のプロパティを設定します。

プロキシベースのファイヤーウォールを使用するには、FirewallType、FirewallServer、およびFirewallPort を設定します。
接続をトンネルするには、FirewallType をTUNNEL に設定します。
認証するには、FirewallUser とFirewallPassword を設定します。
SOCKS プロキシへの認証には、さらにFirewallType をSOCKS5 に設定します。

データモデル

Overview

This section shows the available API objects and provides more information on executing SQL to Avalara APIs.

Key Features

The Sync App models Avalara entities as relational views, allowing you to write SQL to query Avalara data.
Stored procedures allow you to execute operations to Avalara.
Live connectivity to these objects means any changes to your Avalara account are immediately reflected when using the Sync App.

Tables

テーブル describes the available tables. Tables are statically defined to model Accounts, Transactions, Users, and more.

Views

ビュー describes the available views. Views are statically defined to model Reports, Subscriptions, and more.

Stored Procedures

ストアドプロシージャ are function-like interfaces to Avalara. Stored procedures allow you to execute operations to Avalara, including downloading documents and moving envelopes.

テーブル

Sync App はAvalara のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。

Avalara Connector for CData Sync テーブル


Name	Description
Accounts	Accounts table for AvalaraAvatax data provider.
Batches	Batches table for AvalaraAvatax data provider.
Companies	Companies table for AvalaraAvatax data provider.
Contacts	Contacts table for AvalaraAvatax data provider.
Customers	Customers table for AvalaraAvatax data provider.
DataSources	DataSources table for AvalaraAvatax data provider.
DistanceThresholds	DistanceThresholds table for AvalaraAvatax data provider.
FilingCalendars	FilingCalendars table for AvalaraAvatax data provider.
Items	Items table for AvalaraAvatax data provider.
Locations	Locations table for AvalaraAvatax data provider.
MultiDocument	MultiDocument table for AvalaraAvatax data provider.
Nexus	Nexus table for AvalaraAvatax data provider.
Notices	Notices table for AvalaraAvatax data provider.
Notifications	Notifications table for AvalaraAvatax data provider.
Settings	Settings table for AvalaraAvatax data provider.
TaxCodes	TaxCodes table for AvalaraAvatax data provider.
TaxRules	TaxRules table for AvalaraAvatax data provider.
TransactionLines	TransactionLines view for AvalaraAvatax data provider.
Transactions	Transactions table for AvalaraAvatax data provider.
Upcs	Upcs table for AvalaraAvatax data provider.
Users	Users table for AvalaraAvatax data provider.

Accounts

Accounts table for AvalaraAvatax data provider.

Select

The Sync App 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 Sync App. For example, the following query is processed server side:

SELECT * FROM Accounts WHERE accountStatusId = 'Active' AND accountTypeId = 'Regular1'

Insert

To add an Account.

INSERT INTO Accounts (id, name, effectiveDate, accountStatusId, accountTypeId) VALUES ('12345', 'Test Account', '2019-06-24T00:00:00+00:00', 'Test', 'Regular')

Update

Avalara allows updates Accounts columns.

UPDATE Accounts SET crmid = '0010b000Ardit' WHERE Id = 2000137504

In order to update AccountsSubscriptions #TEMP table should be used.

INSERT INTO AccountsSubscriptions#TEMP (subscriptionDescription, id) VALUES ('Avacert2', '567961')
UPDATE Accounts SET linkedSubscriptions = 'AccountsSubscriptions#TEMP', crmid = '0010b000Ardit' WHERE Id = 2000137504

Delete

Accounts can be deleted by providing the Id of the address and issuing a DELETE statement.

DELETE FROM Accounts WHERE Id = 100

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	The unique ID number assigned to this account.
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.
AccountTypeId	String	False	The type of this account.
AccountStatusId	String	False	The current status of this account.
CrmId	String	False	For system registrar use only.
LinkedSubscriptions	String	False	A list of subscriptions granted to this account.
Name	String	False	The name of this account.
LinkedUsers	String	False	A list of all the users belonging to this account.
ModifiedDate	Datetime	False	The date/time when this record was last modified.
EndDate	Datetime	False	If this account has been closed, this is the last date the account was open.
EffectiveDate	Datetime	False	The earliest date on which this account may be used.
CreatedDate	Datetime	False	The date when this record was created.
PageKey	String	False

Batches

Batches table for AvalaraAvatax data provider.

Insert

Create batch objects attached to a company. Each batch object must have one file object. When a batch is created, it is added to the AvaTax Batch Queue and will be processed as quickly as possible in the order it was received. As a result of this operation you will get the status of a batch. First insert the file, referencing the local path of the file on your machine, using #TEMP table:

INSERT INTO File#TEMP (Name, FileLocalPath, ContentType) VALUES ('samplebatch.csv', 'C:\\Users\\User\\Desktop\\BatchFile.csv', 'text/csv')

Then insert in the main Batches table. The following fielda are required:

INSERT INTO Batches (CompanyId, Name, LinkedFiles, Type) VALUES ('247015', 'TestBatch2', 'File#TEMP', 'TransactionImport')

Update

UPDATE operation is not supported for Batches table.

Delete

If you attempt to delete a batch that is being processed, you will receive an error message. Deleting a batch does not delete any transactions that were created by importing the batch. Deleting a batch requires one of the following user roles: CSPAdmin, CSPTester, SSTAdmin, SystemAdmin, SystemOperator, TechnicalSupportAdmin; Companyid and Id should be specified in the WHERE clause.

DELETE FROM Batches WHERE Id = 9030440 AND CompanyId = 247015

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	The unique ID number of this batch.
CompanyId [KEY]	Int	False	The Company ID number of the company that owns this batch.
BatchAgent	String	False	The agent used to create this batch.
CurrentRecord	Int	False	The current record being processed
CompletedDate	Datetime	False	The date/time when this batch was completely processed.
LinkedFiles	String	False	The list of files contained in this batch.
Name	String	False	The user-friendly readable name for this batch.
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.
Status	String	False	This batch's current processing status.
RecordCount	Int	False	The number of records in this batch; determined by the server.
ModifiedDate	Datetime	False	The date/time when this record was last modified.
AccountId	Int	False	The Account ID number of the account that owns this batch.
Type	String	False	The type of this batch.Possible values are:ItemImport, CompanyLocationImport, ExemptCertImport, TaxRuleImport, TransactionImport, UPCBulkImport.
StartedDate	Datetime	False	The date/time when this batch started processing.
CreatedDate	Datetime	False	The date when this record was created.
Options	String	False	Any optional flags provided for this batch.
PageKey	String	False

Companies

Companies table for AvalaraAvatax data provider.

Insert

To insert a new company to an existing account you need to specify AccountId, CompanyCode, Name and DefaultCountry fields.

INSERT INTO Companies (AccountId, CompanyCode, Name, defaultCountry) VALUES ('2000137504', 'SAB', 'SAB&Co', 'US')

Update

Avalara allows UPDATEs on Companies columns, expect for aggregate columns. Aggregate columns can not be updated.

UPDATE Companies SET Name = 'UpdatedName' WHERE Id = 283040

Delete

A company can be deleted by providing the Id of the company and issuing a DELETE statement.

DELETE FROM Companies WHERE Id = 283040

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	The unique ID number of this company.
DefaultLocationId	Int	False	If set, this is the unique ID number of the default location for this company.
LinkedNexus	String	False	Optional: A list of nexus defined for this company. To fetch this list, add the query string `?$include=Nexus` to your URL.
NonReportingChildCompanies	String	False
TaxDependencyLevelId	String	False	Used to apply tax detail dependency at a jurisdiction level.
DefaultCountry	String	False	The two character ISO-3166 country code of the default country for this company.
LinkedTaxRules	String	False	Optional: A list of tax rules defined for this company.
Name	String	False	The name of this company, as shown to customers.
CreatedDate	Datetime	False	The date when this record was created.
MossCountry	String	False	The country code of the mini-one-stop-shop used for Value Added Tax (VAT) processing.
LinkedContacts	String	False	Optional: A list of contacts defined for this company.
CompanyCode	String	False	A unique code that references this company within your account.
WarningsEnabled	Bool	False	Set this value to true to receive warnings in API calls via SOAP.
LinkedLocations	String	False	Optional: A list of locations defined for this company.
LinkedItems	String	False	Optional: A list of items defined for this company.
CreatedUserId	Int	False	The User ID of the user who created this record.
AccountId	Int	False	The unique ID number of the account this company belongs to.
ModifiedDate	Datetime	False	The date/time when this record was last modified.
RoundingLevelId	String	False	Indicates whether this company prefers to round amounts at the document level or line level.
BusinessIdentificationNo	String	False	Business Identification No.
LinkedUpcs	String	False	Optional: A list of UPCs defined for this company.
InProgress	Bool	False	Set this value to true to indicate that you are still working to finish configuring this company. While this value is true, no tax reporting will occur and the company will not be usable for transactions.
IsReportingEntity	Bool	False	Set this flag to true if this company must file its own tax returns. For users who have Returns enabled, this flag turns on monthly Worksheet generation for the company.
LinkedTaxCodes	String	False	Optional: A list of tax codes defined for this company.
ParentCompanyId	Int	False	If this company is fully owned by another company, this is the unique identity of the parent company.
BaseCurrencyCode	String	False	This is the three character ISO-4217 currency code of the default currency used by this company.
IsTest	Bool	False	Set this flag to true to indicate that this company is a test company. If you have Returns enabled, Test companies will not file tax returns and can be used for validation purposes.
IsActive	Bool	False	This flag indicates whether tax activity can occur for this company. Set this flag to true to permit the company to process transactions.
SstEffectiveDate	Date	False	If this company participates in Streamlined Sales Tax, this is the date when the company joined the SST program.
MossId	String	False	The unique identifier of the mini-one-stop-shop used for Value Added Tax (VAT) processing.
ModifiedUserId	Int	False	The user ID of the user who last modified this record.
LinkedSettings	String	False	Optional: A list of settings defined for this company.
SstPid	String	False	If this company files Streamlined Sales Tax, this is the PID of this company as defined by the Streamlined Sales Tax governing board.
TaxpayerIdNumber	String	False	For United States companies, this field contains your Taxpayer Identification Number. This is a nine digit number that is usually called an EIN for an Employer Identification Number if this company is a corporation, or SSN for a Social Security Number if this company is a person. This value is required if the address provided is inside the US and if you subscribed to the Avalara Managed Returns or SST Certified Service Provider service. Otherwise it is optional.
IsDefault	Bool	False	This flag is true if this company is the default company for this account. Only one company may be set as the default.
HasProfile	Bool	False	Set this flag to true to give this company its own unique tax profile. If this flag is true, this company will have its own Nexus, TaxRule, TaxCode, and Item definitions. If this flag is false, this company will inherit all profile values from its parent.

Contacts

Contacts table for AvalaraAvatax data provider.

Select

The Sync App 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 Sync App. For example, the following query is processed server side:

SELECT * FROM Contacts WHERE companyid = 247015
SELECT * FROM Contacts WHERE companyid = 247015 AND region = 'NY'

Insert

To add a Contact, ContactCode is a required field.

INSERT INTO Contacts (companyId, contactCode, firstName, lastName, title, line1, city, region, postalCode, country, email, phone) VALUES ('247015', 'TestContactc7356131ca2442', " +
          "'Bob', 'McExample', 'Owner', '2000 Main Street', 'Irvine', 'CA', '92614', 'US', '[email protected]', '714 555-1212')

Update

Avalara allows updates Contacts columns. To update a Contact, Id and CompanyId should be specified in the WHERE clause of the Update statement.

UPDATE Contacts SET firstName = 'tidra' WHERE CompanyId = 247015 AND Id = 175596

Delete

Contacts can be deleted by providing the Companyid and Id of the Contact and issuing a DELETE statement.

DELETE FROM Contacts WHERE Id = 100

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	The unique ID number of this contact.
FirstName	String	False	The first or given name of this contact.
CreatedUserId	Int	False	The User ID of the user who created this record.
Mobile	String	False	The mobile phone number for this contact.
Region	String	False	Name or ISO 3166 code identifying the region within the country.
ModifiedDate	Datetime	False	The date/time when this record was last modified.
Phone	String	False	The main phone number for this contact.
Line3	String	False	The third line of the postal mailing address of this contact.
PostalCode	String	False	The postal code or zip code of the postal mailing address of this contact.
Line2	String	False	The second line of the postal mailing address of this contact.
Line1	String	False	The first line of the postal mailing address of this contact.
LastName	String	False	The last or family name of this contact.
ModifiedUserId	Int	False	The user ID of the user who last modified this record.
CompanyId [KEY]	Int	False	The unique ID number of the company to which this contact belongs.
Email	String	False	The email address of this contact.
Country	String	False	Name or ISO 3166 code identifying the country.
City	String	False	The city of the postal mailing address of this contact.
MiddleName	String	False	The middle name of this contact.
Fax	String	False	The facsimile phone number for this contact.
CreatedDate	Datetime	False	The date when this record was created.
Title	String	False	Professional title of this contact.
ContactCode	String	False	A unique code for this contact.
PageKey	String	False

Customers

Customers table for AvalaraAvatax data provider.

Select

To retrieve Customer records from Customers table, at least CompanyId or CompanyId and CustomerCode should be specified in the WHERE clause. The Sync App will use the Avalara API to process WHERE clause conditions built with the following columns and operators. CompanyId and CustomerCode fields support server side filtering with the = operator. The rest of the filter is executed client side within the Sync App. For example, the following query is processed server side:

SELECT * FROM Customers WHERE CompanyId = '247015'
SELECT * FROM Contacts WHERE CompanyId = 247015 AND CustomerCode = 'CC001'

Columns


Name	Type	ReadOnly	Description
Id	Int	False	Unique ID number of this customer.
CompanyId [KEY]	Int	False	The unique ID number of the AvaTax company that recorded this customer.
CustomerCode [KEY]	String	False	The unique code identifying this customer. Must be unique within your company.
AlternateId	String	False	A customer-configurable alternate ID number for this customer. You may set this value to match any other system that would like to reference this customer record.
IsShip	Bool	False	True if this customer record is specifically used for ship-to purposes.
LinkedShipTos	String	False	A list of ship-to customer records that are connected to this bill-to customer.
Region	String	False	ISO 3166 code identifying the region within the country.
IsBill	Bool	False	True if this customer record is specifically used for bill-to purposes.
EmailAddress	String	False	The main email address for this customer.
LinkedCustomFields	String	False	A list of custom fields defined on this customer.
TaxpayerIdNumber	String	False	For customers in the United States, this field is the federal taxpayer ID number. For businesses, this is a Federal Employer Identification Number. For individuals, this will be a Social Security Number.
ModifiedDate	Datetime	False	The date/time when this record was last modified.
LinkedCertificates	String	False	A list of exemption certficates that apply to this customer.
FaxNumber	String	False	The fax phone number for this customer, if any.
AttnName	String	False	Indicates the 'Attn' component of the address for this customer, if this customer requires mailings to be shipped to the attention of a specific person or department name.
PhoneNumber	String	False	The main phone number for this customer.
PostalCode	String	False	Postal Code / Zip Code component of the address of this customer.
Line2	String	False	Second line of the street address of this customer.
Line1	String	False	First line of the street address of this customer.
LastTransaction	Datetime	False	Date when this customer last executed a transaction.
Country	String	False	Name or ISO 3166 code identifying the country.
City	String	False	City component of the street address of this customer.
LinkedExposureZones	String	False	A list of exposure zones where you do business with this customer.
ContactName	String	False	The name of the main contact person for this customer.
CreatedDate	Datetime	False	The date when this record was created.
Name	String	False	A friendly name identifying this customer.

DataSources

DataSources table for AvalaraAvatax data provider.

Insert

To create a data source at least CompanyId and Source should be specified.

INSERT INTO DataSources (CompanyId, Source) VALUES (247015, 'Amazon v2 Extractor')

Update

To update a data source, you need to specify Id and CompanyId in WHERE clause.

UPDATE DataSources SET isEnabled = true WHERE Id = 297 AND CompanyId = 247015

Delete

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

DELETE FROM DataSources WHERE Id = 297 AND CompanyId = 247015

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	The id of the datasource.
CompanyId [KEY]	Int	False	The id of the company to which the datasource belongs to.
Source	String	False	The extractor/connector id.
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.
ModifiedDate	Datetime	False	The date/time when this record was last modified.
IsAuthorized	Bool	False	True if this data source is authorized.
LastSyncedDate	Datetime	False	The date when the information was last synched.
IsSynced	Bool	False	If all the information has been transferred from the extractor to the database.
DeletedDate	Datetime	False	The date when this record was deleted.
IsEnabled	Bool	False	The connection using the connection_id is enabled. The customer is responsible to enable or disable.
Instance	String	False	The unique ID number of this connection.
CreatedDate	Datetime	False	The date when this record was created.
Recalculate	Bool	False	Specifies whether transactions created by this data source needs to re-calculate tax or not
PageKey	String	False

DistanceThresholds

DistanceThresholds table for AvalaraAvatax data provider.

A company-distance-threshold model indicates the distance between a company and the taxing borders of various countries. Distance thresholds are necessary to correctly calculate some value-added taxes.

Insert

To create a distance-threshold object you need one of the following user roles: AccountAdmin, CompanyAdmin, CSPAdmin, CSPTester, SiteAdmin, SSTAdmin, SystemAdmin, TechnicalSupportAdmin. At least the following fields should be specified:

INSERT INTO DistanceThresholds (companyId, originCountry, destinationCountry, type) VALUES (283040, 'FR', 'BR', 'Purchase')

Update

To update a distance-threshold, you need to specify Id and CompanyId in WHERE clause.

UPDATE DistanceThresholds SET EffDate = '2019/11/08' WHERE Id = 11785 AND CompanyId = 283040

Delete

To delete a distance-threshold, you need to specify Id and AccountId in WHERE clause.

DELETE FROM DistanceThresholds WHERE Id = 11785 AND CompanyId = 283040

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	A unique ID number representing this distance threshold object.
CompanyId [KEY]	Int	False	The ID number of the company that defined this distance threshold.
OriginCountry	String	False	The origin country for this threshold.
DestinationCountry	String	False	The destination country for this threshold.
Type	String	False	Indicates the distance threshold type. This value can be either `Sale` or `Purchase`.
EffDate	Datetime	False	For distance threshold values that change over time, this is the earliest date for which this distance threshold is valid. If null, this distance threshold is valid for all dates earlier than the `endDate` field.
EndDate	Datetime	False	For distance threshold values that change over time, this is the latest date for which this distance threshold is valid. If null, this distance threshold is valid for all dates later than the `effDate` field.
ThresholdExceeded	Bool	False	True if your tax professional has determined that the value-added tax distance threshold is exceeded for this pair of countries. If you set this value to `false`, your value added taxes will be calculated using the origin country. Otherwise, value added taxes will be calculated on the destination country.
PageKey	String	False

FilingCalendars

FilingCalendars table for AvalaraAvatax data provider.

Select

To retrieve records from FilingCalendar table, at least CompanyId should be specified in the WHERE clause. The Sync App 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 Sync App. For example, the following query is processed server side:

SELECT * FROM FilingCalendars WHERE CompanyId = '247015' AND Success = False

Columns


Name	Type	ReadOnly	Description
CompanyId [KEY]	Int	False	CompanyId of the request
ActivePoa	Bool	False	Notes if there is an actice POA
ExpirationDate	Datetime	False	End Date of POA
LinkedAvailablePOA	String	False	POA download
Bytes	String	False	Bytes of the file
Filename	String	False	Original filename
Success	Bool	False	True if this download succeeded
ContentType	String	False	Mime content type
Region	String	False	Region POA is for
EffectiveDate	Datetime	False	Effective Date of the POA
Country	String	False	Country POA is for

Items

Items table for AvalaraAvatax data provider.

Select

The Sync App 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 Sync App. 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

Locations

Locations table for AvalaraAvatax data provider.

Insert

To create a location at least the following fields should be specified.

INSERT INTO Locations (CompanyId, Line1, LocationCode, AddressTypeId, AddressCategoryId, PostalCode, Country) VALUES (247015, '2000 Main Street', 'L001', 'Location', 'MainOffice', 92614, 'US')

Update

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

UPDATE Locations SET City = 'Irvine' WHERE Id = 56789 AND CompanyId = 247015

Delete

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

DELETE FROM Locations WHERE Id = 56789 AND CompanyId = 247015

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	The unique ID number of this location.
CompanyId [KEY]	Int	False	The unique ID number of the company that operates at this location.
RegisteredDate	Datetime	False	The date when this location was registered with a tax authority. Not required.
DbaName	String	False	If this location has a different business name from its legal entity name, specify the 'Doing Business As' name for this location.
EffectiveDate	Date	False	The date when this location was opened for business, or null if not known.
CreatedUserId	Int	False	The User ID of the user who created this record.
AddressCategoryId	String	False	Indicates the type of place of business represented by this location.
Region	String	False	Name or ISO 3166 code identifying the region within the country of the physical address of this location.
LastTransactionDate	Datetime	False	The most recent date when a transaction was processed for this location. Set by AvaTax.
ModifiedDate	Datetime	False	The date/time when this record was last modified.
OutletName	String	False	A friendly name for this location.
IsRegistered	Bool	False	Set this flag to true to indicate that this location has been registered with a tax authority.
Line3	String	False	The third line of the physical address of this location.
LocationCode	String	False	A code that identifies this location. Must be unique within your company.
PostalCode	String	False	The postal code or zip code of the physical address of this location.
Line2	String	False	The second line of the physical address of this location.
Line1	String	False	The first line of the physical address of this location.
AddressTypeId	String	False	Indicates whether this location is a physical place of business or a temporary salesperson location.
ModifiedUserId	Int	False	The user ID of the user who last modified this record.
Country	String	False	Name or ISO 3166 code identifying the country of the physical address of this location.
City	String	False	The city of the physical address of this location.
Description	String	False	A friendly name for this location.
County	String	False	The county name of the physical address of this location. Not required.
IsDefault	Bool	False	Set this flag to true to indicate that this is the default location for this company.
EndDate	Date	False	If this place of business has closed, the date when this location closed business.
LinkedSettings	String	False	Extra information required by certain jurisdictions for filing.
CreatedDate	Datetime	False	The date when this record was created.
PageKey	String	False

MultiDocument

MultiDocument table for AvalaraAvatax data provider.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	The unique ID number of this MultiDocument object.
Code [KEY]	String	False	The transaction code of the MultiDocument transaction. All individual transactions within this MultiDocument object will have this code as a prefix.
Type [KEY]	String	False	Indicates the type of MultiDocument transaction.
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.
ModifiedDate	Datetime	False	The date/time when this record was last modified.
AccountId	Int	False	The unique ID number of the AvaTax customer account that created this MultiDocument object.
LinkedDocuments	String	False	A separate document will exist for each unique combination of buyer and seller in this MultiDocument transaction.
CreatedDate	Datetime	False	The date/time when this record was created.

Nexus

Nexus table for AvalaraAvatax data provider.

Insert

To create a nexus declaration for your company, you must first obtain a list of Avalara-defined nexus querying NexusDefinitions table. Once you have determined which nexus you wish to declare, you should customize only the user-selectable fields in this object. The user selectable fields for the nexus object are CompanyId, EffectiveDate, EndDate, LocalNexusTypeId, TaxId, NexusTypeId, HasPermanentEstablishment, and IsSellerImporterOfRecord. When calling CreateNexus or UpdateNexus, all values in your nexus object except for the user-selectable fields must match an Avalara-defined system nexus object. If any data does not match, AvaTax may not recognize your nexus declaration. To create a Nexus you must specify Country, Region, JurisdictionTypeId, JurisCode, JurisName, ShortName, NexusTaxTypeGroup of an existing Avalara-defined system nexus object and optionally any other selectable field.

INSERT INTO Nexus (CompanyId, Country, Region, JurisdictionTypeId, JurisCode, JurisName, ShortName, NexusTaxTypeGroup, EffectiveDate) VALUES (283040, 'US', 'US', 'Country', 'US', 'UNITED STATES', 'UNITED STATES', 'Hospitality', '2019-11-08')

Update

Only user selectable fields can be updated. To update a nexus object, you need to specify Id and CompanyId in WHERE clause.

UPDATE Nexus SET HasPermanentEstablishment = true WHERE Id = 20684351 AND CompanyId = 283040

Delete

To delete a nexus object, you need to specify Id and CompanyId in WHERE clause.

DELETE FROM Nexus WHERE Id = 20684351 AND CompanyId = 283040

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	The unique ID number of this declaration of nexus.
CompanyId [KEY]	Int	False	The unique ID number of the company that declared nexus.
TaxAuthorityId	Int	False	A unique ID number of the tax authority that is associated with this nexus.
IsSellerImporterOfRecord	Bool	False	For nexus declarations at the country level, specifies whether this company is considered the importer of record in this nexus region. Set this value to `true` to consider your company as the importer of record and collect these taxes. Leave this value as false or null and taxes will be calculated as if your company is not the importer of record.
StateAssignedNo	String	False	The state assigned number of this jurisdiction.
Sourcing	String	False	Indicates whether this nexus is defined as origin or destination nexus.
JurisName	String	False	The common name of the jurisdiction in which this company declared nexus.
TaxId	String	False	Optional - the tax identification number under which you declared nexus.
JurisCode	String	False	The code identifying the jurisdiction in which this company declared nexus.
EffectiveDate	Date	False	The date when this nexus began. If not known, set to null.
CreatedUserId	Int	False	The User ID of the user who created this record.
Region	String	False	Name or ISO 3166 code identifying the region within the country.
ModifiedDate	Datetime	False	The date/time when this record was last modified.
NexusTaxTypeGroup	String	False	The type of nexus that this company is declaring. Replaces NexusTypeId.
ShortName	String	False	The short name of the jurisdiction.
IsSSTActive	Bool	False	For the United States, this flag indicates whether this particular nexus falls within a U.S.
JurisdictionTypeId	String	False	The type of the jurisdiction in which this company declared nexus.
HasLocalNexus	Bool	False	True if you are also declaring local nexus within this jurisdiction. Many U.S. states have options for declaring nexus in local jurisdictions as well as within the state.
ModifiedUserId	Int	False	The user ID of the user who last modified this record.
Country	String	False	Name or ISO 3166 code identifying the country in which this company declared nexus.
HasPermanentEstablishment	Bool	False	Set this value to true if your company has a permanent establishment within this jurisdiction.
NexusTypeId	String	False	The type of nexus that this company is declaring.
EndDate	Date	False	If this nexus will end or has ended on a specific date, set this to the date when this nexus ends.
LocalNexusTypeId	String	False	If you are declaring local nexus within this jurisdiction, this indicates whether you are declaring only a specified list of local jurisdictions, all state-administered local jurisdictions, or all local jurisdictions.
SignatureCode	String	False	The signature code of the boundary region as defined by Avalara.
CreatedDate	Datetime	False	The date when this record was created.
PageKey	String	False

Nexus table for AvalaraAvatax data provider.

Insert

To create a nexus declaration for your company, you must first obtain a list of Avalara-defined nexus querying NexusDefinitions table. Once you have determined which nexus you wish to declare, you should customize only the user-selectable fields in this object. The user selectable fields for the nexus object are CompanyId, EffectiveDate, EndDate, LocalNexusTypeId, TaxId, NexusTypeId, HasPermanentEstablishment, and IsSellerImporterOfRecord. When calling CreateNexus or UpdateNexus, all values in your nexus object except for the user-selectable fields must match an Avalara-defined system nexus object. If any data does not match, AvaTax may not recognize your nexus declaration. To create a Nexus you must specify Country, Region, JurisdictionTypeId, JurisCode, JurisName, ShortName, NexusTaxTypeGroup of an existing Avalara-defined system nexus object and optionally any other selectable field.

INSERT INTO Nexus (CompanyId, Country, Region, JurisdictionTypeId, JurisCode, JurisName, ShortName, NexusTaxTypeGroup, EffectiveDate) VALUES (283040, 'US', 'US', 'Country', 'US', 'UNITED STATES', 'UNITED STATES', 'Hospitality', '2019-11-08')

Update

Only user selectable fields can be updated. To update a nexus object, you need to specify Id and CompanyId in WHERE clause.

UPDATE Nexus SET HasPermanentEstablishment = true WHERE Id = 20684351 AND CompanyId = 283040

Delete

To delete a nexus object, you need to specify Id and CompanyId in WHERE clause.

DELETE FROM Nexus WHERE Id = 20684351 AND CompanyId = 283040

Columns


Name	Type	Description
Id [KEY]	Int	The unique ID number of this declaration of nexus.
TaxAuthorityId	Int	A unique ID number of the tax authority that is associated with this nexus.
IsSellerImporterOfRecord	Bool	For nexus declarations at the country level, specifies whether this company is considered the importer of record in this nexus region. Set this value to `true` to consider your company as the importer of record and collect these taxes. Leave this value as false or null and taxes will be calculated as if your company is not the importer of record.
StateAssignedNo	String	The state assigned number of this jurisdiction.
Sourcing	String	Indicates whether this nexus is defined as origin or destination nexus.
JurisName	String	The common name of the jurisdiction in which this company declared nexus.
TaxId	String	Optional - the tax identification number under which you declared nexus.
JurisCode	String	The code identifying the jurisdiction in which this company declared nexus.
EffectiveDate	Date	The date when this nexus began. If not known, set to null.
CreatedUserId	Int	The User ID of the user who created this record.
Region	String	Name or ISO 3166 code identifying the region within the country.
ModifiedDate	Datetime	The date/time when this record was last modified.
NexusTaxTypeGroup	String	The type of nexus that this company is declaring. Replaces NexusTypeId.
ShortName	String	The short name of the jurisdiction.
IsSSTActive	Bool	For the United States, this flag indicates whether this particular nexus falls within a U.S.
JurisdictionTypeId	String	The type of the jurisdiction in which this company declared nexus.
HasLocalNexus	Bool	True if you are also declaring local nexus within this jurisdiction. Many U.S. states have options for declaring nexus in local jurisdictions as well as within the state.
ModifiedUserId	Int	The user ID of the user who last modified this record.
Country	String	Name or ISO 3166 code identifying the country in which this company declared nexus.
HasPermanentEstablishment	Bool	Set this value to true if your company has a permanent establishment within this jurisdiction.
NexusTypeId	String	The type of nexus that this company is declaring.
EndDate	Date	If this nexus will end or has ended on a specific date, set this to the date when this nexus ends.
LocalNexusTypeId	String	If you are declaring local nexus within this jurisdiction, this indicates whether you are declaring only a specified list of local jurisdictions, all state-administered local jurisdictions, or all local jurisdictions.
SignatureCode	String	The signature code of the boundary region as defined by Avalara.
CreatedDate	Datetime	The date when this record was created.
PageKey	String

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Rows@Next	String	Identifier for the next page of results. Do not set this value manually.

Notices

Notices table for AvalaraAvatax data provider.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	The unique ID number of this notice.
CompanyId [KEY]	Int	False	The unique ID number of the company to which this notice belongs.
TicketReferenceNo	String	False	The ticket reference number of the notice.
ExpectedResolutionDate	Datetime	False	Expected resolution date of the notice.
ShowResolutionDateToCustomer	Bool	False	Indicator to show customer this resolution date.
ClosedDate	Datetime	False	The closed date of the notice.
FilingFrequency	String	False	The filing frequency of the notice.
LinkedComments	String	False	Additional comments on the notice.
CustomerTypeId	String	False	NoticeCustomerTypeID can be retrieved from the definitions API.
ReceivedDate	Datetime	False	The received date of the notice.
PriorityId	String	False	The priority of the notice.
TypeId	Int	False	The tax notice type id.
JurisdictionType	String	False	The jurisdiction type of the notice.
SalesForceCaseUrl	String	False	The URL to the sales force case.
Description	String	False	The description of the notice.
Reason	String	False	The notice reason.
TaxPeriod	String	False	The tax period of the notice.
CreatedDate	Datetime	False	The date when this record was created.
TotalRemit	String	False	The total remmitance amount for the notice.
CreatedUserId	Int	False	The User ID of the user who created this record.
StatusId	Int	False	The status id of the notice.
ModifiedDate	Datetime	False	The date/time when this record was last modified.
JurisdictionName	String	False	The jurisdiction name of the notice.
FilingTypeId	String	False	The filing type of the notice.
ComplianceContactId	Int	False	The id of the compliance contact.
Status	String	False	The status of the notice.
TaxAuthorityId	Int	False	The tax authority id of the notice.
CustomerComment	String	False	Comments from the customer on this notice.
TaxFormCode	String	False	The tax form code of the notice.
RevenueContactId	Int	False	The id of the revenue contact.
DocumentReference	String	False	The document reference of the notice.
ReasonId	Int	False	The notice reason id.
LinkedRootCause	String	False	Notice Root Cause Details.
ClosedByUserId	Int	False	The unique ID number of the user that closed the notice.
Country	String	False	Name or ISO 3166 code identifying the country that sent this notice.
TicketReferenceUrl	String	False	The ticket reference url of the notice.
CreatedByUserName	String	False	The user who created the notice.
OwnedByUserId	Int	False	The unique ID number of the user that owns the notice.
HideFromCustomer	Bool	False	Indicator to hide from customer.
LinkedResponsibility	String	False	Notice Responsibility Details.
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 within the country that sent this notice.
CustomerFundingOptionId	String	False	The notice customer funding options.
AvaFileFormId	Int	False	The ava file form id of the notice.
SalesForceCase	String	False	The sales force case of the notice.
LinkedFinances	String	False	Finance details of the notice.
Type	String	False	The tax notice type description.
PageKey	String	False

Notifications

Notifications table for AvalaraAvatax data provider.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	The unique id of the notification.
CompanyId	Int	False	If this notification was tied to a specific company, this will be the unique ID number of the company that received the notification.
CreatedUserId	Int	False	The unique ID number of the user who created the notification.
ActionDueDate	Datetime	False	If there is a specific action suggested by this notification, and if this action is requested by a specific due date, this value will be the due date for the action.
ActionName	String	False	If there is a specific action suggested by this notification, this is the name of the action.
ReferenceObject	String	False	The type name of object referred to by this notification, if any.
Dismissed	Bool	False	Wether the notification is dismissed.
ModifiedDate	Datetime	False	The UTC timestamp of the time when this notification was last modified.
ReferenceId	Int	False	The unique reference Id number of the object referred to by this notification, if any.
Message	String	False	The message for this notification. This is a friendly description of the notification and any relevant information that can help you decide what kind of action, if any, to take in response.
ActionLink	String	False	If there is a specific action suggested by this notification, this is the URL of the action.
DismissedDate	Datetime	False	If this notification has been dismissed, this indicates the timestamp (in UTC time) when the user dismissed the notification.
ModifiedUserId	Int	False	The unique ID number of the user who most recently modified this notification.
ExpireDate	Datetime	False	If this notification is time sensitive, this is the latest date when the notification should be displayed to the user.
NeedsAction	Bool	False	If this notification object requires user action to resolve, this value will be set to true.
DismissedByUserId	Int	False	If this notification has been dismissed, this indicates the unique ID number of the user that dismissed the notification.
Category	String	False	The category of this notification.
Topic	String	False	The topic of this notification.
AccountId	Int	False	The unique ID number of the account that received this notification.
CreatedDate	Datetime	False	The UTC timestamp of the time when this notification was created.
SeverityLevelId	String	False	The severity level of the notification.
PageKey	String	False

Settings

Settings table for AvalaraAvatax data provider.

The company settings system is a metadata system that you can use to store extra information about a company. Your integration or connector could use this data storage to keep track of preference information, reminders, or any other storage that would need to persist even if the customer uninstalls your application.

Insert

A setting can refer to any type of data you need to remember about this company object. When creating this object, you may define your own set, name, and value parameters. To define your own values, please choose a set name that begins with X- to indicate an extension. CompanyId, Set and Name are required fields.

INSERT INTO Settings (CompanyId, Set, Name) VALUES (283040, 'ItemsToRemember', 'Texas')

Update

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

UPDATE Settings SET Value = 'Alamo' WHERE Id = 297847 AND CompanyId = 283040

Delete

To delete a setting, you need to specify Id and CompanyId in WHERE clause.

DELETE FROM Settings WHERE Id = 297847 AND CompanyId = 283040

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	The unique ID number of this setting.
CompanyId [KEY]	Int	False	The unique ID number of the company this setting refers to.
Name	String	False	A user-defined name for this name-value pair.
Value	String	False	The value of this name-value pair.
Set	String	False	A user-defined set containing this setting.
PageKey	String	False

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

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

TransactionLines

TransactionLines view for AvalaraAvatax data provider.

Select

The Sync App will use the Avalara API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App. By default the lines of Adjusted transactions will not be listed. If you want to include them, you need to set IncludeAdjustedTransactions to true.

TrsnactionId, TransactionCode support the '=', IN operator.

For example, the following query is processed server side:

SELECT * FROM TransactionLines WHERE TransactionCode IN ('Code1', 'Code2')

Delete

To delete a TransactionLine item, you need to specify the TransactionCode and LineNumber in the WHERE clause.

DELETE FROM TransactionLines WHERE TransactionCode = 'TC001' AND LineNumber = 1

Columns


Name	Type	ReadOnly	Description
Id	Long	False	The unique ID number of this transaction line item.
TransactionId	Long	False	The unique ID number of the transaction to which this line item belongs.
TransactionStatus	String	False	The status of the transaction to which this line item belongs.
TransactionCode [KEY]	String	False	A unique customer-provided code identifying this transaction.
DestinationAddressId	Long	False	The unique ID number of the destination address where this line was delivered or sold. In the case of a point-of-sale transaction, the destination address and origin address will be the same. In the case of a shipped transaction, they will be different.
TaxCalculated	String	False	The amount of tax that AvaTax calculated for the transaction.
DiscountAmount	String	False	The amount of discount that was applied to this line item.
HsCode	String	False	The cross-border harmonized system code (HSCode) used to calculate tariffs and duties for this line item.
DiscountTypeId	Int	False	The type of discount, if any, that was applied to this line item.
TaxableAmount	String	False	The taxable amount of this line item.
CostInsuranceFreight	String	False	Indicates the cost of insurance and freight for this line.
CertificateId	String	False	The CertCapture Certificate ID
TaxDate	Date	False	The date that was used for calculating tax amounts for this line item.
Ref2	String	False	A user-defined reference identifier for this transaction line item.
EntityUseCode	String	False	The entity use code for this line item. Usage type often affects taxability rules.
Description	String	False	A description of the item or service represented by this line.
Ref1	String	False	A user-defined reference identifier for this transaction line item.
ExemptNo	String	False	The customer Tax Id Number (tax_number) associated with a certificate.
Quantity	String	False	The quantity of products sold on this line item.
TaxCode	String	False	The code string for the tax code that was used to calculate this line item.
TaxOverrideType	String	False	If a tax override was specified, this indicates the type of tax override.
LineNumber [KEY]	String	False	The line number or code indicating the line on this invoice or receipt or document.
BusinessIdentificationNo	String	False	VAT business identification number used for this transaction.
ReportingDate	Date	False	The date when this transaction should be reported. By default, all transactions are reported on the date when the actual transaction took place. In some cases, line items may be reported later due to delayed shipments or other business reasons.
VatNumberTypeId	Int	False	Indicates the VAT number type for this line item.
VatCode	String	False	Indicates the VAT code for this line item.
LineAmount	String	False	The total amount of the transaction, including both taxable and exempt.
Tax	String	False	The tax for this line in this transaction.
LinkedLineLocationTypes	String	False	Optional: A list of location types for this line item.
IsItemTaxable	Bool	False	True if this item is taxable.
TaxOverrideAmount	String	False	If a tax override was specified, this indicates the amount of tax that was requested.
ExemptCertId	Int	False	The unique ID number of the exemption certificate that applied to this line item. It is the calc_id associated with a certificate in CertCapture.
ItemCode	String	False	The code string of the item represented by this line item.
BoundaryOverrideId	Int	False	The unique ID number of the boundary override applied to this line item.
OriginAddressId	Long	False	The unique ID number of the origin address where this line was delivered or sold.
TaxOverrideReason	String	False	If a tax override was specified, represents the reason for the tax override.
ExemptAmount	String	False	The amount of this line item that was exempt.
TaxIncluded	Bool	False	Indicates whether the amount for this line already includes tax.
IsSSTP	Bool	False	True if this item is a Streamlined Sales Tax line item.
Sourcing	String	False	Indicates whether this line item was taxed according to the origin or destination.
TaxEngine	String	False	The tax engine identifier that was used to calculate this line item.
TaxCodeId	Int	False	The unique ID number for the tax code that was used to calculate this line item.
RevAccount	String	False	The revenue account number for this line item.
CompanyCode	String	False	The code of the company that recorded this transaction.

Transactions

Transactions table for AvalaraAvatax data provider.

Select

The Sync App 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 Sync App. By default the Adjusted transactions will not be listed. If you want to include them, you need to set IncludeAdjustedTransactions to true. For example, the following query is processed server side:

SELECT * FROM Transactions WHERE AdjustmentReason = 'PriceAdjusted'
SELECT * FROM Items WHERE Status = 'Cancelled'

Insert

To add a new Transaction item, the following columns need to be specified: CustomerCode, Date, Type, LinkedLines, Code, LinkedAddresses. If you want to commit the transaction, set the Commit flag in the request to true. The linked columns can be inserted using a #TEMP table or by passing the aggregate value.

The LinkedAddresses aggregate must include information about the origin and destination address. If this transaction occurred at a retail point-of-sale location, provide that single address here and leave all other address types null. If origin differs from destination, insert both ShipFrom and ShipTo address types. If you wish to use the address of an existing location for the actual company, specify the address in the addressType_locationCode field.

The examples below illustrate the aforementioned scenarios.

Inserting LinkedAddresses aggregate through #TEMP table with SingleLocation:

INSERT INTO Addresses#TEMP (SingleLocation_line1, SingleLocation_City, SingleLocation_County, SingleLocation_PostalCode) VALUES ('2000 Main Street', 'Irvine', 'US', '92614')")
INSERT INTO Addresses#TEMP (SingleLocation_locationCode) VALUES ('LC001')")

Inserting LinkedAddresses aggregate through #TEMP table with ShipFrom and ShipTo locations:

INSERT INTO Addresses#TEMP (shipTo_line1, shipTo_City, shipTo_County, shipTo_PostalCode, shipFrom_line1, shipFrom_City, shipFrom_Country, shipFrom_PostalCode) VALUES ('2000 Main Street', 'Irvine', 'US', '92614', '', '', 'US', '')")
INSERT INTO Addresses#TEMP (shipTo_locationCode, shipFrom_locationCode) VALUES ('LC001', 'LC002')")

Insert line items aggregate using #TEMP table. For a list of the columns you can insert into the temporary table, refer to TransactionLines table.

INSERT INTO TransactionLines#TEMP (ItemCode, Quantity, LineAmount) VALUES ('IC005', 3, 300)")

Insert into the main Transactions table :

INSERT INTO Transactions (LinkedLines, LinkedAddresses, Code, CompanyId, CustomerCode, Date, Type, Commit, TotalTax) VALUES (TransactionLines#TEMP, Addresses#TEMP, DC008, 247015, 'CC002', '09/30/2019', 'SalesInvoice', true, 12.0)")

Update

Avalara allows updates on Transactions. To update a transaction, AdjustmentReason and Adjustment description are required fields. Additionally, you need to specify the Code of the transaction you are updating in the WHERE clause.

Similarly, to Insert, you can update line items using temporary tables. To update an existing line, include the LineNumber of the line you wish to update. To insert a new line in the transaction, set the LineNumber to a new, non-existing value.

When a transaction is updated, the actual transaction's status changes to Adjusted and a new transaction with the updated information is created. The new transaction will have the same document code, but a different id and status: Saved or Commited. If you wish to commit the new updated transaction, set the Commit flag in the request to true.

INSERT INTO TransactionLines#TEMP (ItemCode, Quantity, LineAmount, LineNumber) VALUES (IC007, 3, 300, 3)
UPDATE Transactions SET LinkedLines = 'TransactionLines#TEMP', AdjustmentDescription = 'MyDescription', AdjustmentReason = 'PriceAdjusted' WHERE Code = '051349'

Columns


Name	Type	ReadOnly	Description
Id	Long	False	The unique ID number of this transaction.
Code [KEY]	String	False	A unique customer-provided code identifying this transaction.
CompanyId	Int	False	The unique ID number of the company that recorded this transaction.
ExchangeRateEffectiveDate	Date	False	If this transaction included foreign currency exchange, this is the date as of which the exchange rate was calculated.
SalespersonCode	String	False	The salesperson who provided this transaction. Not required.
AdjustmentDescription	String	False	If this transaction was adjusted, indicates a description of the reason why the transaction was adjusted.
DestinationAddressId	Long	False	The unique ID number of the destination address for this transaction.
LinkedLocationTypes	String	False	A list of location types in this transaction.
IsSellerImporterOfRecord	Bool	False	By default, the value is null, when the value is null, the value can be set at nexus level and used. If the value is not null, it will override the value at nexus level. If true, this seller was considered the importer of record of a product shipped internationally.
BatchCode	String	False	If this transaction was created as part of a batch, this code indicates which batch.
LinkedTaxDetailsByTaxType	String	False	Contains the tax details per tax type
TaxDate	Datetime	False	Tax date for this transaction
EntityUseCode	String	False	The entity use code for this transaction. Entity use codes often affect exemption or taxability rules.
LinkedInvoiceMessages	String	False	Invoice messages associated with this transaction. Currently, this stores legally-required VAT messages.
Description	String	False	Description of this transaction. Field permits unicode values.
LinkedAddresses	String	False	A list of addreses used in this transaction.
TotalTax	String	False	The total tax for all lines in this transaction.
LinkedMessages	String	False	List of informational and warning messages regarding this API call. These messages are only relevant to the current API call.
ExemptNo	String	False	The customer Tax Id Number (tax_number) associated with a certificate.
TotalTaxable	String	False	The portion of the total amount of this transaction that was taxable.
ModifiedDate	Datetime	False	The date/time when this record was last modified.
Email	String	False	Email address associated with this transaction.
TaxOverrideType	String	False	If a tax override was applied to this transaction, indicates what type of tax override was applied.
BusinessIdentificationNo	String	False	VAT business identification number used for this transaction.
ReportingLocationCode	String	False	For customers who use location-based tax reporting, this field controls how this transaction will be filed for multi-location tax filings.
TotalTaxCalculated	String	False	The amount of tax that AvaTax calculated for the transaction.
ExchangeRate	String	False	If this transaction included foreign currency exchange, this is the exchange rate that was used.
CustomerCode	String	False	Unique code identifying the customer that requested this transaction.
Locked	Bool	False	If this transaction has been reported to a tax authority, this transaction is considered locked and may not be adjusted after reporting.
Status	String	False	The status of the transaction.
TotalAmount	String	False	The total amount of this transaction.
LinkedLines	String	False	A list of line items in this transaction.
TotalDiscount	String	False	The total amount of discounts applied to all lines within this transaction.
AdjustmentReason	String	False	If this transaction was adjusted, indicates the unique ID number of the reason why the transaction was adjusted.
TaxOverrideAmount	String	False	If a tax override was applied to this transaction, indicates the amount of tax that was requested by the customer.
SoftwareVersion	String	False	The software version used to calculate this transaction.
Country	String	False	The two-character ISO 3166 code of the country for this transaction.
CurrencyCode	String	False	The three-character ISO 4217 currency code that was used for payment for this transaction.
OriginAddressId	Long	False	The unique ID number of the origin address for this transaction.
TotalExempt	String	False	The amount of this transaction that was exempt.
PurchaseOrderNo	String	False	The customer-supplied purchase order number of this transaction.
TaxOverrideReason	String	False	If a tax override was applied to this transaction, indicates the reason for the tax override.
TaxOverrideDate	Date	False	The override tax date to use
LinkedParameters	String	False	Contains a list of extra parameters that were set when the transaction was created.
LinkedSummary	String	False	Contains a summary of tax on this transaction.
Version	Int	False	If this transaction was adjusted, this indicates the version number of this transaction. Incremented each time the transaction is adjusted.
Date	Date	False	The date on which this transaction occurred.
ModifiedUserId	Int	False	The user ID of the user who last modified this record.
Region	String	False	The two-or-three character ISO region code of the region for this transaction.
ReferenceCode	String	False	A user-defined reference code for this transaction.
Reconciled	Bool	False	If this transaction has been reconciled against the company's ledger, this value is set to true.
Type [KEY]	String	False	The type of the transaction.
Commit	Boolean	False	Wether to commit a transaction on creation. Used only on inserts
CompanyCode	String	False	The code of the company that recorded this transaction.

Upcs

Upcs table for AvalaraAvatax data provider.

A UPC represents a single Universal Product Code in your catalog and matches this product to the tax code identified by this UPC.

Insert

To create a UPC object CompanyId, Upc and Description are required fields.

INSERT INTO Upcs (CompanyId, Upc, Description) VALUES (283040, '023032550992', 'Yarn')

Update

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

UPDATE Upcs SET LegacyTaxCode = 'PS081282' WHERE Id = 123456789 AND CompanyId = 283040

Delete

To delete a Upc, you need to specify Id and CompanyId in WHERE clause.

DELETE FROM Upcs WHERE Id = 123456789 AND CompanyId = 283040

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	The unique ID number for this UPC.
CompanyId [KEY]	Int	False	The unique ID number of the company to which this UPC belongs.
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.
Upc	String	False	The 12-14 character Universal Product Code, European Article Number, or Global Trade Identification Number.
ModifiedDate	Datetime	False	The date/time when this record was last modified.
EndDate	Date	False	If this UPC expired or will expire on a certain date, this contains the last date on which the UPC was effective.
LegacyTaxCode	String	False	Legacy Tax Code applied to any product sold with this UPC.
Usage	Int	False	A usage identifier for this UPC code.
IsSystem	Int	False	A flag indicating whether this UPC code is attached to the AvaTax system or to a company.
EffectiveDate	Date	False	If this UPC became effective on a certain date, this contains the first date on which the UPC was effective.
Description	String	False	Description of the product to which this UPC applies.
CreatedDate	Datetime	False	The date when this record was created.
PageKey	String	False

Users

Users table for AvalaraAvatax data provider.

Insert

To create a new user the following fields should be specified. A newly created user will receive an email inviting them to create their password. This means that you must provide a valid email address for all user accounts created.

INSERT INTO Users (AccountId, UserName, FirstName, LastName, Email, securityRoleId) VALUES (2000137504, 'user123', 'James', 'Smith', '[email protected]', 'AccountUser')

Update

Only user selectable fields can be updated. To update a user, you need to specify Id and AccountId in WHERE clause.

UPDATE Users SET IsActive = true WHERE Id = 332668 AND AccountId = 2000137504

Delete

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

DELETE FROM Users WHERE Id = 332668 AND AccountId = 2000137504

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	The unique ID number of this user.
AccountId [KEY]	Int	False	The unique ID number of the account to which this user belongs.
PostalCode	String	False	The postal code in which this user resides.
SecurityRoleId	String	False	The security level for this user.
ModifiedDate	Datetime	False	The date/time when this record was last modified.
PasswordStatus	String	False	The status of the user's password. For a new user created, this is always going to be `UserMustChange`.
Email	String	False	The email address to be used to contact this user. If the user has forgotten a password, an email can be sent to this email address with information on how to reset this password.
UserName	String	False	The username which is used to log on to the AvaTax website, or to authenticate against API calls.
CompanyId	Int	False	If this user is locked to one company (and its children), this is the unique ID number of the company to which this user belongs.
FirstName	String	False	The first or given name of the user.
LastName	String	False	The last or family name of the user.
IsActive	Bool	False	True if this user is currently active.
CreatedDate	Datetime	False	The date when this record was created.
PageKey	String	False

ビュー

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

Avalara Connector for CData Sync ビュー


Name	Description
BatchFiles	BatchFiles view for AvalaraAvatax data provider.
CustomerCustomFields	CustomerCustomFields view for AvalaraAvatax data provider.
CustomerExposureZones	CustomerExposureZones view for AvalaraAvatax data provider.
FilingCalendarAvailablePOA	FilingCalendarAvailablePOA view for AvalaraAvatax data provider.
ItemClassifications	ItemClassifications view for AvalaraAvatax data provider.
ItemParameters	ItemParameters view for AvalaraAvatax data provider.
LocationSettings	LocationSettings view for AvalaraAvatax data provider.
Nexus	Nexus table for AvalaraAvatax data provider.
NoticeComments	NoticeComments view for AvalaraAvatax data provider.
NoticeFinances	NoticeFinances view for AvalaraAvatax data provider.
NoticeResponsibility	NoticeResponsibility view for AvalaraAvatax data provider.
NoticeRootCause	NoticeRootCause view for AvalaraAvatax data provider.
PostalCodes	PostalCodes view for the Avalara Avatax data provider.
Regions	Regions view for the Avalara Avatax data provider.
ReportParameters	ReportParameters view for AvalaraAvatax data provider.
Reports	Reports table for AvalaraAvatax data provider.
Subscriptions	Subscriptions table for AvalaraAvatax data provider.
TaxRatesByAddress	Retrieve real-time estimated tax rates based on an address using the Avalara Avatax data provider.
TaxRatesByZipCode	Retrieve estimated tax rates by zip code for a specific date using the Avalara Avatax data provider.
TransactionAddresses	TransactionAddresses view for AvalaraAvatax data provider.
TransactionInvoiceMessages	TransactionInvoicemessages view for AvalaraAvatax data provider.
TransactionLocationTypes	TransactionLocationTypes view for AvalaraAvatax data provider.
TransactionMessages	TransactionMessages view for AvalaraAvatax data provider.
TransactionParameters	TransactionParameters view for AvalaraAvatax data provider.
TransactionSummary	TransactionSummary view for AvalaraAvatax data provider.
TransactionTaxDetailsByTaxType	TransactionTaxdetailsbytaxtype view for AvalaraAvatax data provider.

BatchFiles

BatchFiles view for AvalaraAvatax data provider.

Columns


Name	Type	Description
Id [KEY]	Int	The unique ID number assigned to this batch file.
BatchId	Int	The unique ID number of the batch that this file belongs to.
CompanyId [KEY]	Int	The Company ID number of the company that owns this batch.
Name	String	Logical Name of file.
ContentLength	Int	Size of content, in bytes.
FilePath	String	Path to the file - name/S3 key.
FileExtension	String	File extension (e.g. CSV).
FileLocalPath	String	Local path of the file.
ErrorCount	Int	Number of errors that occurred when processing this file.
ContentType	String	Content mime type (e.g. text/csv). This is used for HTTP downloading.

CustomerCustomFields

CustomerCustomFields view for AvalaraAvatax data provider.

Select

To retrieve records from CustomerCustomFields view, at least CompanyId or CompanyId and CompanyCode should be specified in the WHERE clause. The Sync App will use the Avalara API to process WHERE clause conditions built with the following columns and operators. CompanyId and CompanyCode support server side filtering with the = operator. The rest of the filter is executed client side within the Sync App. For example, the following query is processed server side:

SELECT * FROM CustomerCustomFields WHERE CompanyId = '247015' AND CustomerCode = 'CC001'

Columns


Name	Type	Description
CompanyId [KEY]	String	The company Id of the parent record.
CustomerCode [KEY]	String	The customer code this record is associated to.
Name	String	The name of the custom field.
Value	String	The value of the custom field.

CustomerExposureZones

CustomerExposureZones view for AvalaraAvatax data provider.

Select

To retrieve records from CustomerExposureZones view, at least CompanyId or CompanyId and CompanyCode should be specified in the WHERE clause. The Sync App will use the Avalara API to process WHERE clause conditions built with the following columns and operators. CompanyId and CompanyCode support server side filtering with the = operator. The rest of the filter is executed client side within the Sync App. For example, the following query is processed server side:

SELECT * FROM CustomerExposureZones WHERE CompanyId = '247015' AND CustomerCode = 'CC001'

Columns


Name	Type	Description
Id	Int	A unique ID number representing this exposure zone.
CompanyId [KEY]	Int	The unique ID number of the AvaTax company that recorded this customer.
CustomerCode [KEY]	String	The customer code this record is associated to.
Name	String	The short name of this exposure zone, suitable for use in a drop-down list.
Country	String	Two character ISO 3166 county code for the country component of this exposure zone.
Created	Datetime	The date when this record was created.
Region	String	Two or three character ISO 3166 region, province, or state name of this exposure zone.
Description	String	A more complete description of this exposure zone, suitable for use as a tooltip or help text.
Modified	Datetime	The date/time when this record was last modified.
Tag	String	A tag indicating

FilingCalendarAvailablePOA

FilingCalendarAvailablePOA view for AvalaraAvatax data provider.

Columns


Name	Type	Description
CompanyId [KEY]	String	Company Id of the parent record.
Bytes	String	Bytes of the file.
Filename	String	Original filename.
Success	Bool	True if this download succeeded.
ContentType	String	Mime content type.

ItemClassifications

ItemClassifications view for AvalaraAvatax data provider.

Columns


Name	Type	Description
CompanyId [KEY]	String	The CompanyId of the parent record.
ItemId [KEY]	String	The unique ID number of the item this product belongs to.
SystemCode	String	The system code in which the product belongs.
ProductCode	String	The product code of an item in a given system.

ItemParameters

ItemParameters view for AvalaraAvatax data provider.

Columns


Name	Type	Description
Id [KEY]	Int	The id of the parameter.
CompanyId [KEY]	String	The CompanyId of the parent record.
ItemId [KEY]	Int	The item id.
Name	String	The parameter's name.
Unit	String	The unit of measurement code for the parameter.
Value	String	The value for the parameter.

LocationSettings

LocationSettings view for AvalaraAvatax data provider.

Columns


Name	Type	Description
CompanyId [KEY]	String	CompanyId of the parent record.
LocationId [KEY]	String	The LocationId that this setting is associated to.
QuestionId	Int	The unique ID number of the location question answered.
QuestionName	String	The name of the question.
Value	String	The answer the user provided.

Nexus

Nexus table for AvalaraAvatax data provider.

Insert

To create a nexus declaration for your company, you must first obtain a list of Avalara-defined nexus querying NexusDefinitions table. Once you have determined which nexus you wish to declare, you should customize only the user-selectable fields in this object. The user selectable fields for the nexus object are CompanyId, EffectiveDate, EndDate, LocalNexusTypeId, TaxId, NexusTypeId, HasPermanentEstablishment, and IsSellerImporterOfRecord. When calling CreateNexus or UpdateNexus, all values in your nexus object except for the user-selectable fields must match an Avalara-defined system nexus object. If any data does not match, AvaTax may not recognize your nexus declaration. To create a Nexus you must specify Country, Region, JurisdictionTypeId, JurisCode, JurisName, ShortName, NexusTaxTypeGroup of an existing Avalara-defined system nexus object and optionally any other selectable field.

INSERT INTO Nexus (CompanyId, Country, Region, JurisdictionTypeId, JurisCode, JurisName, ShortName, NexusTaxTypeGroup, EffectiveDate) VALUES (283040, 'US', 'US', 'Country', 'US', 'UNITED STATES', 'UNITED STATES', 'Hospitality', '2019-11-08')

Update

Only user selectable fields can be updated. To update a nexus object, you need to specify Id and CompanyId in WHERE clause.

UPDATE Nexus SET HasPermanentEstablishment = true WHERE Id = 20684351 AND CompanyId = 283040

Delete

To delete a nexus object, you need to specify Id and CompanyId in WHERE clause.

DELETE FROM Nexus WHERE Id = 20684351 AND CompanyId = 283040

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Int	False	The unique ID number of this declaration of nexus.
CompanyId [KEY]	Int	False	The unique ID number of the company that declared nexus.
TaxAuthorityId	Int	False	A unique ID number of the tax authority that is associated with this nexus.
IsSellerImporterOfRecord	Bool	False	For nexus declarations at the country level, specifies whether this company is considered the importer of record in this nexus region. Set this value to `true` to consider your company as the importer of record and collect these taxes. Leave this value as false or null and taxes will be calculated as if your company is not the importer of record.
StateAssignedNo	String	False	The state assigned number of this jurisdiction.
Sourcing	String	False	Indicates whether this nexus is defined as origin or destination nexus.
JurisName	String	False	The common name of the jurisdiction in which this company declared nexus.
TaxId	String	False	Optional - the tax identification number under which you declared nexus.
JurisCode	String	False	The code identifying the jurisdiction in which this company declared nexus.
EffectiveDate	Date	False	The date when this nexus began. If not known, set to null.
CreatedUserId	Int	False	The User ID of the user who created this record.
Region	String	False	Name or ISO 3166 code identifying the region within the country.
ModifiedDate	Datetime	False	The date/time when this record was last modified.
NexusTaxTypeGroup	String	False	The type of nexus that this company is declaring. Replaces NexusTypeId.
ShortName	String	False	The short name of the jurisdiction.
IsSSTActive	Bool	False	For the United States, this flag indicates whether this particular nexus falls within a U.S.
JurisdictionTypeId	String	False	The type of the jurisdiction in which this company declared nexus.
HasLocalNexus	Bool	False	True if you are also declaring local nexus within this jurisdiction. Many U.S. states have options for declaring nexus in local jurisdictions as well as within the state.
ModifiedUserId	Int	False	The user ID of the user who last modified this record.
Country	String	False	Name or ISO 3166 code identifying the country in which this company declared nexus.
HasPermanentEstablishment	Bool	False	Set this value to true if your company has a permanent establishment within this jurisdiction.
NexusTypeId	String	False	The type of nexus that this company is declaring.
EndDate	Date	False	If this nexus will end or has ended on a specific date, set this to the date when this nexus ends.
LocalNexusTypeId	String	False	If you are declaring local nexus within this jurisdiction, this indicates whether you are declaring only a specified list of local jurisdictions, all state-administered local jurisdictions, or all local jurisdictions.
SignatureCode	String	False	The signature code of the boundary region as defined by Avalara.
CreatedDate	Datetime	False	The date when this record was created.
PageKey	String	False

Nexus table for AvalaraAvatax data provider.

Insert

To create a nexus declaration for your company, you must first obtain a list of Avalara-defined nexus querying NexusDefinitions table. Once you have determined which nexus you wish to declare, you should customize only the user-selectable fields in this object. The user selectable fields for the nexus object are CompanyId, EffectiveDate, EndDate, LocalNexusTypeId, TaxId, NexusTypeId, HasPermanentEstablishment, and IsSellerImporterOfRecord. When calling CreateNexus or UpdateNexus, all values in your nexus object except for the user-selectable fields must match an Avalara-defined system nexus object. If any data does not match, AvaTax may not recognize your nexus declaration. To create a Nexus you must specify Country, Region, JurisdictionTypeId, JurisCode, JurisName, ShortName, NexusTaxTypeGroup of an existing Avalara-defined system nexus object and optionally any other selectable field.

INSERT INTO Nexus (CompanyId, Country, Region, JurisdictionTypeId, JurisCode, JurisName, ShortName, NexusTaxTypeGroup, EffectiveDate) VALUES (283040, 'US', 'US', 'Country', 'US', 'UNITED STATES', 'UNITED STATES', 'Hospitality', '2019-11-08')

Update

Only user selectable fields can be updated. To update a nexus object, you need to specify Id and CompanyId in WHERE clause.

UPDATE Nexus SET HasPermanentEstablishment = true WHERE Id = 20684351 AND CompanyId = 283040

Delete

To delete a nexus object, you need to specify Id and CompanyId in WHERE clause.

DELETE FROM Nexus WHERE Id = 20684351 AND CompanyId = 283040

Columns


Name	Type	Description
Id [KEY]	Int	The unique ID number of this declaration of nexus.
TaxAuthorityId	Int	A unique ID number of the tax authority that is associated with this nexus.
IsSellerImporterOfRecord	Bool	For nexus declarations at the country level, specifies whether this company is considered the importer of record in this nexus region. Set this value to `true` to consider your company as the importer of record and collect these taxes. Leave this value as false or null and taxes will be calculated as if your company is not the importer of record.
StateAssignedNo	String	The state assigned number of this jurisdiction.
Sourcing	String	Indicates whether this nexus is defined as origin or destination nexus.
JurisName	String	The common name of the jurisdiction in which this company declared nexus.
TaxId	String	Optional - the tax identification number under which you declared nexus.
JurisCode	String	The code identifying the jurisdiction in which this company declared nexus.
EffectiveDate	Date	The date when this nexus began. If not known, set to null.
CreatedUserId	Int	The User ID of the user who created this record.
Region	String	Name or ISO 3166 code identifying the region within the country.
ModifiedDate	Datetime	The date/time when this record was last modified.
NexusTaxTypeGroup	String	The type of nexus that this company is declaring. Replaces NexusTypeId.
ShortName	String	The short name of the jurisdiction.
IsSSTActive	Bool	For the United States, this flag indicates whether this particular nexus falls within a U.S.
JurisdictionTypeId	String	The type of the jurisdiction in which this company declared nexus.
HasLocalNexus	Bool	True if you are also declaring local nexus within this jurisdiction. Many U.S. states have options for declaring nexus in local jurisdictions as well as within the state.
ModifiedUserId	Int	The user ID of the user who last modified this record.
Country	String	Name or ISO 3166 code identifying the country in which this company declared nexus.
HasPermanentEstablishment	Bool	Set this value to true if your company has a permanent establishment within this jurisdiction.
NexusTypeId	String	The type of nexus that this company is declaring.
EndDate	Date	If this nexus will end or has ended on a specific date, set this to the date when this nexus ends.
LocalNexusTypeId	String	If you are declaring local nexus within this jurisdiction, this indicates whether you are declaring only a specified list of local jurisdictions, all state-administered local jurisdictions, or all local jurisdictions.
SignatureCode	String	The signature code of the boundary region as defined by Avalara.
CreatedDate	Datetime	The date when this record was created.
PageKey	String

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Rows@Next	String	Identifier for the next page of results. Do not set this value manually.

NoticeComments

NoticeComments view for AvalaraAvatax data provider.

Columns


Name	Type	Description
Id [KEY]	Int	The unique ID number of this notice.
CompanyId [KEY]	Int	The company ID to which this file will be attached.
NoticeId [KEY]	Int	The ID of the notice this comment is attached too.
ModifiedUserId	Int	The user ID of the user who last modified this record.
AttachmentUploadRequest	String	An attachment to the detail
ResourceFileTypeId	Int	The resource type ID of this file.
Name	String	The original name of this file.
Content	String	This stream contains the bytes of the file being uploaded.
Length	Int	Length of the file in bytes.
Username	String	The username adding the file
AccountId	Int	The account ID to which this file will be attached.
Date	Datetime	The date this comment was entered
ResourceFileId	Int	resourceFileId
ModifiedDate	Datetime	The date/time when this record was last modified.
CommentTypeId	Int	taxNoticeCommentTypeId
Comment	String	TaxNoticeComment
CommentType	String	taxNoticeCommentType
CommentUserName	String	TaxNoticeCommentUserName
TaxNoticeFileName	String	TaxNoticeFileName
CommentLink	String	TaxNoticeCommentLink
CommentUserId	Int	TaxNoticeCommentUserId

NoticeFinances

NoticeFinances view for AvalaraAvatax data provider.

Columns


Name	Type	Description
Id [KEY]	Int	The Unique Id of the Finance Model.
CompanyId [KEY]	Int	The company ID to which this file will be attached.
NoticeId	Int	The unique ID of the the tax notice associated with the the finance detail.
NoticeNumber	String	The sequential number of the notice.
Penalty	String	The amount of penalty listed on the notice.
TaxAbated	String	The amount of tax abated on the notice.
ResourceFileId	Int	The ResourceFileId of the finance detail attachment.
CreatedUserId	Int	The User ID of the user who created this record.
ModifiedDate	Datetime	The date/time when this record was last modified.
TaxDue	String	The amount of tax due on the notice.
Interest	String	The amount of interest listed on the notice.
AttachmentUploadRequest	String	An attachment to the finance detail.
ResourceFileTypeId	Int	The resource type ID of this file.
Name	String	The original name of this file.
Content	String	This stream contains the bytes of the file being uploaded..
Length	Int	Length of the file in bytes.
Username	String	The username adding the file.
AccountId	Int	The account ID to which this file will be attached.
Credits	String	The amount of credits listed on the notice.
CspFeeRefund	String	The amount of CSP Fee Refund on the notice.
NoticeDate	Datetime	The date of the notice.
ModifiedUserId	Int	The user ID of the user who last modified this record.
CustomerPenalty	String	The amount of customer penalty on the notice.
DueDate	Datetime	The due date of the notice.
CustomerInterest	String	The amount of customer interest on the notice.
FileName	String	The name of the file attached to the finance detail.
CreatedDate	Datetime	The date when this record was created.

NoticeResponsibility

NoticeResponsibility view for AvalaraAvatax data provider.

Columns


Name	Type	Description
Id [KEY]	Int	The unique ID number of this filing frequency.
CompanyId [KEY]	String	The CompanyId of the parent record.
NoticeId	Int	TaxNoticeId
TaxNoticeResponsibilityId	Int	TaxNoticeResponsibilityId
Description	String	The description name of this filing frequency.

NoticeRootCause

NoticeRootCause view for AvalaraAvatax data provider.

Columns


Name	Type	Description
Id [KEY]	Int	The unique ID number of this filing frequency.
CompanyId [KEY]	String	The CompanyId of the parent record.
NoticeId [KEY]	Int	TaxNoticeId
Description	String	The description name of this root cause.
TaxNoticeRootCauseId	Int	TaxNoticeRootCauseId

PostalCodes

PostalCodes view for the Avalara Avatax data provider.

Select

The Sync App 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 Sync App.

IncludeExpiredPostalCodes supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM PostalCodes WHERE EffectiveDate >= '2018-09-01' AND EffectiveDate <= '2022-02-01' AND Region='NY' AND TaxRegionId  IN ('4001027','4001022')
SELECT * FROM PostalCodes WHERE IncludeExpiredPostalCodes = true

Columns


Name	Type	Description
PostalCode [KEY]	String	The postal code.
Country	String	The country in which this postal code is located.
Region	String	The region, state, or province where this postal code is located.
TaxRegionId	Int	An Avalara-assigned tax region Id associated with the postal code.
EffectiveDate	Date	The date the postal code becomes active.
EndDate	Date	The date the postal code expires.
IncludeExpiredPostalCodes	Bool	If set to true, returns expired postal codes. Defaults to false.

Regions

Regions view for the Avalara Avatax data provider.

Select

The Sync App will use the Avalara API to process WHERE clause conditions built with the following columns and operators. Most columns except for LocalizedNames 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 Sync App. For example, the following query is processed server side:

SELECT * FROM Regions where CountryCode='US' AND IsRegionTaxable=false AND Code!='MT' AND (Name LIKE '%KA' OR NAME LIKE 'OR%')

Columns


Name	Type	Description
CountryCode	String	The two-character ISO 3166 country code this region belongs to.
Code	String	The three-character ISO 3166 region code.
Name	String	The full name, in uppercase, using localized characters specific to this region.
LocalizedNames	String	A list of localized names in various languages.
Classification	String	The term used in the local language that describes this region.
IsRegionTaxable	Bool	Indicates whether the region collects tax. This field is only populated for the US and is null for all other countries.
StreamlinedSalesTax	Bool	In the US, this flag indicates whether a state participates in the Streamlined Sales Tax program. For countries outside the US, this flag is null.

ReportParameters

ReportParameters view for AvalaraAvatax data provider.

Columns


Name	Type	Description
ReportId [KEY]	String	The Id of the parent Report.
CurrencyCode	String	The currency code used for your report.
State	String	The state filter used for your report.
DateFormat	String	The date format used for your report.
StartDate	Datetime	The start date filter used for your report.
Country	String	The country filter used for your report.
Culture	String	The culture used your report.
DateFilter	String	The date type filter used for your report.
EndDate	Datetime	The end date filter used for your report.
DocType	String	The doc type filter used for your report.

Reports

Reports table for AvalaraAvatax data provider.

Columns


Name	Type	Description
Id [KEY]	Int	The unique identifier of the report task.
CompletedDate	Datetime	The time when the report was finished building, if completed.
CreatedUser	String	The userName of the user who initiated the report task.
CreatedUserId	Int	The Id of the user who initiated this task.
File	String	The name of the report file, if available.
Status	String	The current status of the report building task.
ReportType	String	The type of the report: ExportDocumentLine, etc.
AccountId	Int	The ID of the account the reported transactions are from.
Format	String	The format of the report file.
CompanyId	Int	The ID of the company the reported transactions are from.
LinkedParameters	String	The parametes used to build the report.
CurrencyCode	String	The currency code used for your report.
State	String	The state filter used for your report.
DateFormat	String	The date format used for your report.
StartDate	Datetime	The start date filter used for your report.
Country	String	The country filter used for your report.
Culture	String	The culture used your report.
DateFilter	String	The date type filter used for your report.
EndDate	Datetime	The end date filter used for your report.
DocType	String	The doc type filter used for your report.
CreatedDate	Datetime	The time when the report task was initiated.
Size	Int	The size of the report file, if available.
PageKey	String

Subscriptions

Subscriptions table for AvalaraAvatax data provider.

Select

The Sync App 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 Sync App. For example, the following query is processed server side:

SELECT * FROM Subscriptions WHERE SubscriptionDescription LIKE 'AVA%'

Columns


Name	Type	Description
Id [KEY]	Int	The unique ID number of this subscription.
AccountId [KEY]	Int	The unique ID number of the account this subscription belongs to.
ModifiedUserId	Int	The user ID of the user who last modified this record.
CreatedUserId	Int	The User ID of the user who created this record.
ModifiedDate	Datetime	The date/time when this record was last modified.
EndDate	Date	If the subscription has ended or will end, this date indicates when the subscription ends.
SubscriptionTypeId	Int	The unique ID number of the service that the account is subscribed to. If this is provided, subscription description is ignored.
EffectiveDate	Date	The date when the subscription began.
CreatedDate	Datetime	The date when this record was created.
SubscriptionDescription	String	A friendly description of the service that the account is subscribed to. You can either provide the subscription type Id or this but not both. If subscription type Id is provided, then this information is ignored and this field will be updated with the information from subscription type id.
PageKey	String

TaxRatesByAddress

Retrieve real-time estimated tax rates based on an address using the Avalara Avatax data provider.

Select

The Sync App will use the Avalara API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

PostalCode supports the '=' comparison operator.
Region supports the '=' comparison operator.
City supports the '=' comparison operator.
Line1 supports the '=' comparison operator.
Line2 supports the '=' comparison operator.
Line3 supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM TaxRatesByAddress WHERE PostalCode='99950' AND Region='AK' AND City='KETCHIKAN' AND Line1='Whale Pass'

Columns


Name	Type	Description
Rate	Decimal	The sales tax rate for general tangible personal property in this jurisdiction.
Name	String	A readable name of the tax or taxing jurisdiction related to this tax rate.
Type	String	The type of jurisdiction associated with this tax rate.
PostalCode	String	The postal code of the location.
Region	String	Name or ISO 3166 code identifying the region within the country.
City	String	The city name of the location.
Line1	String	The street address of the location.
Line2	String	The street address of the location.
Line3	String	The street address of the location.

TaxRatesByZipCode

Retrieve estimated tax rates by zip code for a specific date using the Avalara Avatax data provider.

Select

The Sync App will use the Avalara API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Sync App.

StateAbbreviation supports the '=' comparison operator.
Date supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM TaxRatesByZipCode WHERE StateAbbreviation='NY' AND Date='2020-01-01'

Columns


Name	Type	Description
ZipCode [KEY]	String	The five digit zip code for this record.
StateAbbreviation	String	A valid two-character US state abbreviation for this record.
CountyName	String	A valid county name for this record. Zip codes may span multiple counties.
CityName	String	A valid city name for this record. Zip codes may span multiple cities.
StateSalesTax	Decimal	The state component of the sales tax rate.
StateUseTax	Decimal	The state component of the use tax rate.
CountySalesTax	Decimal	The county component of the sales tax rate.
CountyUseTax	Decimal	The county component of the use tax rate.
CitySalesTax	Decimal	The city component of the sales tax rate.
CityUseTax	Decimal	The city component of the use tax rate.
TotalSalesTax	Decimal	The total sales tax rate for this postal code. This value may differ from the sum of state, county, and city taxes due to special jurisdiction rules.
TotalUseTax	Decimal	The total use tax rate for this postal code. This value may differ from the sum of state, county, and city rates due to special tax jurisdiction rules.
TaxShippingAlone	Bool	Whether shipping is taxable.
TaxShippingAndHandlingTogether	Bool	Whether shipping and handling are taxable when sent together.
Date	Date	The date for which the point-of-sale data is calculated. Defaults to today.

TransactionAddresses

TransactionAddresses view for AvalaraAvatax data provider.

Columns


Name	Type	Description
Id	Long	The unique ID number of this address.
TransactionId	Long	The unique ID number of the document to which this address belongs.
TransactionCode [KEY]	String	A unique customer-provided code identifying this transaction.
TransactionStatus	String	The status of the transaction to which this line item belongs.
PostalCode	String	The postal code or zip code for the address.
Longitude	String	Longitude for this address
TaxRegionId	Int	The unique ID number of the tax region for this address.
Country	String	The ISO 3166 country code
City	String	The city for the address.
Latitude	String	Latitude for this address
Region	String	The ISO 3166 region code. E.g., the second part of ISO 3166-2.
Line3	String	The third line of the address.
Line2	String	The second line of the address.
Line1	String	The first line of the address.
BoundaryLevel	String	The boundary level at which this address was validated.
CompanyCode	String	The code of the company that recorded this transaction.

TransactionInvoiceMessages

TransactionInvoicemessages view for AvalaraAvatax data provider.

Columns


Name	Type	Description
TransactionId [KEY]	Long	The transaction code of the parent record.
TransactionCode [KEY]	String	A unique customer-provided code identifying this transaction.
TransactionStatus	String	The status of the transaction to which this line item belongs.
LineNumbers	String	The applicable tax line numbers and codes.
Content	String	The content of the invoice message.
CompanyCode	String	The code of the company that recorded this transaction.

TransactionLocationTypes

TransactionLocationTypes view for AvalaraAvatax data provider.

Columns


Name	Type	Description
TransactionId	Long	Transaction ID
TransactionCode [KEY]	String	A unique customer-provided code identifying this transaction.
TransactionStatus	String	The status of the transaction to which this line item belongs.
TransactionAddressId	Long	Address ID for the transaction.
TransactionLocationTypeId	Int	Location type ID for this location type in transaction.
LocationTypeCode	String	Location type code
CompanyCode	String	The code of the company that recorded this transaction.

TransactionMessages

TransactionMessages view for AvalaraAvatax data provider.

Columns


Name	Type	Description
TransactionId [KEY]	Long	The transaction id of the parent record.
TransactionCode [KEY]	String	The transaction code of the parent record.
TransactionStatus	String	The status of the transaction to which this line item belongs.
RefersTo	String	Information about what object in your request this message refers to.
Summary	String	A brief summary of what this message tells us.
Severity	String	A category that indicates how severely this message affects the results.
Source	String	The name of the code or service that generated this message.
Details	String	Detailed information that explains what the summary provided.
CompanyCode	String	The code of the company that recorded this transaction.

TransactionParameters

TransactionParameters view for AvalaraAvatax data provider.

Columns


Name	Type	Description
TransactionId [KEY]	Long	The transaction id of the parent record.
TransactionCode [KEY]	String	The transaction code of the parent record.
TransactionStatus	String	The status of the transaction to which this line item belongs.
Name	String	The name of the parameter.
Unit	String	The unit of measure of the parameter value.
Value	String	The value of the parameter.
CompanyCode	String	The code of the company that recorded this transaction.

TransactionSummary

TransactionSummary view for AvalaraAvatax data provider.

Columns


Name	Type	Description
TransactionId [KEY]	Long	The transaction id this summary is associated to.
TransactionCode [KEY]	String	A unique customer-provided code identifying this transaction.
TransactionStatus	String	The status of the transaction to which this line item belongs.
StateAssignedNo	String	The state assigned number of the jurisdiction that collects this tax.
JurisName	String	The name of the jurisdiction that collects this tax.
TaxGroup	String	Group code when special grouping is enabled.
JurisCode	String	Jurisdiction Code for the taxing jurisdiction
Region	String	Two or three character ISO region, state or province code, if applicable.
JurisType	String	The type of jurisdiction that collects this tax.
RateTypeCode	String	Indicates the code of the rate type.
TaxSubType	String	The tax subtype of this tax.
NonTaxable	String	The amount of the transaction that was non-taxable.
TaxName	String	The name of the tax.
TaxAuthorityType	Int	The unique ID of the Tax Authority Type that collects this tax.
Tax	String	Tax amount - The calculated tax (Base * Rate).
Taxable	String	Tax Base - The adjusted taxable amount.
Country	String	Two character ISO-3166 country code.
TaxCalculated	String	The amount of tax that AvaTax calculated for the transaction.
Exemption	String	The amount of the transaction that was exempt.
TaxType	String	The tax type of this tax.
Rate	String	Tax Rate - The rate of taxation, as a fraction of the amount.
CompanyCode	String	The code of the company that recorded this transaction.

TransactionTaxDetailsByTaxType

TransactionTaxdetailsbytaxtype view for AvalaraAvatax data provider.

Columns


Name	Type	Description
TransactionId [KEY]	String
TransactionCode	String	A unique customer-provided code identifying this transaction.
TransactionStatus	String	The status of the transaction to which this line item belongs.
TotalNonTaxable	String	Total non taxable by tax type.
LinkedTaxSubTypeDetails	String	Tax subtype details.
TotalExempt	String	Total exempt by tax type.
TotalTaxable	String	Total taxable amount by tax type.
TotalTax	String	Total tax by tax type.
TaxType	String	Tax Type.
CompanyCode	String	The code of the company that recorded this transaction.

ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、Avalara の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらずSync App の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにAvalara から関連するレスポンスデータを返します。

Avalara Connector for CData Sync ストアドプロシージャ


Name	Description
CommitTransaction	Commit a transaction for reporting.
RefundTransaction	Refund a transaction.
VoidTransaction	Void a transaction.

CommitTransaction

Commit a transaction for reporting.

Input


Name	Type	Required	Description
TransactionCode	String	True	Code of the transaction to commit.

DownloadBatch

Download a single batch file.

Input


Name	Type	Required	Description
CompanyId	String	True	The ID of the company that owns this batch
BatchId	String	True	The ID of the batch object.
FileId	String	True	The primary key of this batch file object.
FilePath	String	False	The full path (including the file's name) where the file will be downloaded.

Result Set Columns


Name	Type	Description
FileData	String	The file's data encoded in Base64 will be outputted if FilePath and FileStream are not set.

RefundTransaction

Refund a transaction.

Input


Name	Type	Required	Description
TransactionCode	String	True	Code of the transaction to refund.
RefundTransactionCode	String	True	The transaction code for the refund. This code will be saved to the ReturnInvoice transaction, and does not need to match the code of the original sale.
RefundDate	String	True	The date of the refund.
RefundType	String	True	Type of this refund. To submit a full refund, specify Full. To refund only specific lines from the transaction, specify Partial and indicate the lines you wish to apply in the refundLines field. To refund the tax that was paid in the previous transaction, specify TaxOnly. To issue a percentage-based discount, specify Percentage.
RefundPercentage	String	False	The percentage for refund. This value only applies if you choose Percentage or Partial refund type.
RefundLines	String	False	A comma separated list of the line numbers to refund for.
ReferenceCode	String	False	A user-defined reference field containing information about this refund.

VoidTransaction

Void a transaction.

Input


Name	Type	Required	Description
TransactionCode	String	True	Code of the transaction to void.

接続文字列オプション

接続文字列プロパティは、接続を確立するために使用できるさまざまなオプションです。このセクションでは、本プロバイダーの接続文字列で設定できるオプションの一覧を示します。詳細については各リンクをクリックしてください。

接続を確立する方法について詳しくは、接続の確立を参照してください。

Authentication

プロパティ	説明
AuthScheme	The scheme used for authentication. Accepted entries are Basic and LicenseKey.
UseSandbox	A boolean indicating whether you are using a Sandbox account. The provider makes requests to the production environment by default.
User	認証するユーザーのユーザーID を指定します。
Password	認証するユーザーのパスワードを指定します。
AccountId	The account ID number of your Avalara account.
LicenseKey	The license key generated by an account administrator on the Avalara website.

Connection

プロパティ	説明
CompanyCode	Only transaction information tied to this company code will be returned.

SSL

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続する際に、サーバーが受け入れ可能な証明書を指定します。

Firewall

プロパティ	説明
FirewallType	provider がプロキシベースのファイアウォールを介してトラフィックをトンネリングするために使用するプロトコルを指定します。
FirewallServer	ファイアウォールを通過し、ユーザーのクエリをネットワークリソースに中継するために使用されるプロキシのIP アドレス、DNS 名、またはホスト名を識別します。
FirewallPort	プロキシベースのファイアウォールで使用するTCP ポートを指定します。
FirewallUser	プロキシベースのファイアウォールに認証するアカウントのユーザーID を識別します。
FirewallPassword	プロキシベースのファイアウォールで認証するユーザーアカウントのパスワードを指定します。

Proxy

プロパティ	説明
ProxyAutoDetect	provider が、手動で指定されたプロキシサーバーを使用するのではなく、既存のプロキシサーバー構成についてシステムプロキシ設定をチェックするかどうかを指定します。
ProxyServer	HTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレスを指定します。
ProxyPort	クライアントとの間でHTTP トラフィックをルーティングするために予約された、指定されたプロキシサーバーのTCP ポートを指定します。
ProxyAuthScheme	ProxyServer 接続プロパティで指定されたプロキシサーバーに対して認証する際にprovider が使用する認証方法を指定します。
ProxyUser	ProxyServer 接続プロパティで指定されたプロキシサーバーに登録されているユーザーアカウントのユーザー名を提供します。
ProxyPassword	ProxyUser 接続プロパティで指定されたユーザーのパスワードを指定します。
ProxySSLType	ProxyServer 接続プロパティで指定されたプロキシサーバーに接続する際に使用するSSL タイプを指定します。
ProxyExceptions	ProxyServer 接続プロパティで設定されたプロキシサーバー経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリストを指定します。

Logging

プロパティ	説明
LogModules	ログファイルに含めるコアモジュールを指定します。セミコロンで区切られたモジュール名のリストを使用します。デフォルトでは、すべてのモジュールがログに記録されます。

Schema

プロパティ	説明
Location	テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリの場所を指定します。サービスの要件に応じて、これは絶対パスまたは相対パスのいずれかで表されます。
BrowsableSchemas	レポートされるスキーマを利用可能なすべてのスキーマのサブセットに制限するオプション設定。例えば、 BrowsableSchemas=SchemaA,SchemaB,SchemaC です。
Tables	レポートされるテーブルを利用可能なすべてのテーブルのサブセットに制限するオプション設定。例えば、 Tables=TableA,TableB,TableC です。
Views	レポートされたビューを使用可能なテーブルのサブセットに制限するオプション設定。例えば、 Views=ViewA,ViewB,ViewC です。

Miscellaneous

プロパティ	説明
GenerateSchemaFiles	スキーマを生成して保存するユーザーの好みのタイミングを示します。
IncludeAdjustedTransactions	Whether or not to include adjusted transactions in the transaction listing.
MaxRows	集計やGROUP BY を含まないクエリで返される最大行数を指定します。
Other	特定の問題に対処するため、特殊なシナリオ向けの高度な接続プロパティを指定します。このプロパティは、サポートチームの指示がある場合にのみ使用してください。
Pagesize	The maximum number of results to return per page from Avalara when using client paging.
PseudoColumns	テーブルカラムとして公開する擬似カラムを、'TableName=ColumnName;TableName=ColumnName' の形式の文字列で指定します。
Timeout	provider がタイムアウトエラーを返すまでにサーバーからの応答を待機する最大時間を秒単位で指定します。
UserDefinedViews	カスタムビューを定義するJSON 構成ファイルへのファイルパスを指定します。provider は、このファイルで指定されたビューを自動的に検出して使用します。

Authentication

このセクションでは、本プロバイダーの接続文字列で設定可能なAuthentication プロパティの全リストを提供します。

プロパティ	説明
AuthScheme	The scheme used for authentication. Accepted entries are Basic and LicenseKey.
UseSandbox	A boolean indicating whether you are using a Sandbox account. The provider makes requests to the production environment by default.
User	認証するユーザーのユーザーID を指定します。
Password	認証するユーザーのパスワードを指定します。
AccountId	The account ID number of your Avalara account.
LicenseKey	The license key generated by an account administrator on the Avalara website.

AuthScheme

The scheme used for authentication. Accepted entries are Basic and LicenseKey.

解説

Basic: Set this to use Basic User / Password authentication.
LicenseKey: Set to this to perform the authentication using the AccountId and the LicenseKey properties.

UseSandbox

A boolean indicating whether you are using a Sandbox account. The provider makes requests to the production environment by default.

解説

If you are using a production account, this property can be left blank.

User

認証するユーザーのユーザーID を指定します。

解説

認証サーバーは、ユーザーのID を検証するためにUser とPassword の両方を必要とします。

Password

認証するユーザーのパスワードを指定します。

解説

認証サーバーは、ユーザーのID を検証するためにUser とPassword の両方を必要とします。

AccountId

The account ID number of your Avalara account.

解説

The Account Id is listed in the upper right hand corner of the Avalara admin console.

LicenseKey

The license key generated by an account administrator on the Avalara website.

解説

You can generate a license key as follows:

Log into Avalara as an account administrator.
Select Settings.
Select Reset License Key.

Connection

このセクションでは、本プロバイダーの接続文字列で設定可能なConnection プロパティの全リストを提供します。

プロパティ	説明
CompanyCode	Only transaction information tied to this company code will be returned.

CompanyCode

Only transaction information tied to this company code will be returned.

解説

Only transaction information tied to this company code will be returned.

SSL

このセクションでは、本プロバイダーの接続文字列で設定可能なSSL プロパティの全リストを提供します。

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続する際に、サーバーが受け入れ可能な証明書を指定します。

SSLServerCert

TLS/SSL を使用して接続する際に、サーバーが受け入れ可能な証明書を指定します。

解説

TLS/SSL 接続を使用している場合は、このプロパティを使用して、サーバーが受け入れるTLS/SSL 証明書を指定できます。このプロパティに値を指定すると、マシンによって信頼されていない他の証明書はすべて拒否されます。

このプロパティは、次のフォームを取ります：


説明	例
フルPEM 証明書（例では省略されています）	`-----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----`
証明書を保有するローカルファイルへのパス。	C:\cert.cer
公開鍵（例では省略されています）	`-----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----`
MD5 Thumbprint（hex 値はスペースまたはコロン区切り）	`ecadbdda5a1529c58a1e9e09828d70e4`
SHA1 Thumbprint（hex 値はスペースまたはコロン区切り）	`34a929226ae0819f2ec14b4a3d904f801cbb150d`

Note：'*' を使用してすべての証明書を受け入れるように指定することも可能ですが、セキュリティ上の懸念があるため推奨されません。

Firewall

このセクションでは、本プロバイダーの接続文字列で設定可能なFirewall プロパティの全リストを提供します。

プロパティ	説明
FirewallType	provider がプロキシベースのファイアウォールを介してトラフィックをトンネリングするために使用するプロトコルを指定します。
FirewallServer	ファイアウォールを通過し、ユーザーのクエリをネットワークリソースに中継するために使用されるプロキシのIP アドレス、DNS 名、またはホスト名を識別します。
FirewallPort	プロキシベースのファイアウォールで使用するTCP ポートを指定します。
FirewallUser	プロキシベースのファイアウォールに認証するアカウントのユーザーID を識別します。
FirewallPassword	プロキシベースのファイアウォールで認証するユーザーアカウントのパスワードを指定します。

FirewallType

provider がプロキシベースのファイアウォールを介してトラフィックをトンネリングするために使用するプロトコルを指定します。

解説

プロキシベースのファイアウォール（またはプロキシファイアウォール）は、ユーザーのリクエストとそれがアクセスするリソースの間に介在するネットワークセキュリティデバイスです。プロキシは認証済みのユーザーのリクエストを受け取り、ファイアウォールを通過して適切なサーバーにリクエストを送信します。

プロキシは、リクエストを送信したユーザーに代わってデータバケットを評価し転送するため、ユーザーはサーバーに直接接続することなく、プロキシのみに接続します。

Note：デフォルトでは、Sync App はシステムプロキシに接続します。この動作を無効化し、次のプロキシタイプのいずれかに接続するには、ProxyAutoDetect をfalse に設定します。

次の表は、サポートされている各プロトコルのポート番号情報です。


プロトコル	デフォルトポート	説明
TUNNEL	80	Sync App がAvalara への接続を開くポート。トラフィックはこの場所のプロキシを経由して行き来します。
SOCKS4	1080	Sync App がAvalara への接続を開くポート。SOCKS 4 は次にFirewallUser 値をプロキシに渡し、接続リクエストが許容されるかどうかを決定します。
SOCKS5	1080	Sync App がAvalara にデータを送信するポート。SOCKS 5 プロキシに認証が必要な場合には、FirewallUser およびFirewallPassword をプロキシが認識する認証情報に設定します。

HTTP プロキシへの接続には、ProxyServer およびProxyPort ポートを使ってください。HTTP プロキシへの認証には、ProxyAuthScheme、ProxyUser、およびProxyPassword を使ってください。

FirewallServer

ファイアウォールを通過し、ユーザーのクエリをネットワークリソースに中継するために使用されるプロキシのIP アドレス、DNS 名、またはホスト名を識別します。

解説

プロキシベースのファイアウォール（またはプロキシファイアウォール）は、ユーザーのリクエストとそれがアクセスするリソースの間に介在するネットワークセキュリティデバイスです。プロキシは認証済みのユーザーのリクエストを受け取り、ファイアウォールを通過して適切なサーバーにリクエストを送信します。

プロキシは、リクエストを送信したユーザーに代わってデータバケットを評価し転送するため、ユーザーはサーバーに直接接続することなく、プロキシのみに接続します。

FirewallPort

プロキシベースのファイアウォールで使用するTCP ポートを指定します。

解説

プロキシベースのファイアウォール（またはプロキシファイアウォール）は、ユーザーのリクエストとそれがアクセスするリソースの間に介在するネットワークセキュリティデバイスです。プロキシは認証済みのユーザーのリクエストを受け取り、ファイアウォールを通過して適切なサーバーにリクエストを送信します。

プロキシは、リクエストを送信したユーザーに代わってデータバケットを評価し転送するため、ユーザーはサーバーに直接接続することなく、プロキシのみに接続します。

FirewallUser

プロキシベースのファイアウォールに認証するアカウントのユーザーID を識別します。

解説

プロキシベースのファイアウォール（またはプロキシファイアウォール）は、ユーザーのリクエストとそれがアクセスするリソースの間に介在するネットワークセキュリティデバイスです。プロキシは認証済みのユーザーのリクエストを受け取り、ファイアウォールを通過して適切なサーバーにリクエストを送信します。

プロキシは、リクエストを送信したユーザーに代わってデータバケットを評価し転送するため、ユーザーはサーバーに直接接続することなく、プロキシのみに接続します。

FirewallPassword

プロキシベースのファイアウォールで認証するユーザーアカウントのパスワードを指定します。

解説

プロキシベースのファイアウォール（またはプロキシファイアウォール）は、ユーザーのリクエストとそれがアクセスするリソースの間に介在するネットワークセキュリティデバイスです。プロキシは認証済みのユーザーのリクエストを受け取り、ファイアウォールを通過して適切なサーバーにリクエストを送信します。

プロキシは、リクエストを送信したユーザーに代わってデータバケットを評価し転送するため、ユーザーはサーバーに直接接続することなく、プロキシのみに接続します。

Proxy

このセクションでは、本プロバイダーの接続文字列で設定可能なProxy プロパティの全リストを提供します。

プロパティ	説明
ProxyAutoDetect	provider が、手動で指定されたプロキシサーバーを使用するのではなく、既存のプロキシサーバー構成についてシステムプロキシ設定をチェックするかどうかを指定します。
ProxyServer	HTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレスを指定します。
ProxyPort	クライアントとの間でHTTP トラフィックをルーティングするために予約された、指定されたプロキシサーバーのTCP ポートを指定します。
ProxyAuthScheme	ProxyServer 接続プロパティで指定されたプロキシサーバーに対して認証する際にprovider が使用する認証方法を指定します。
ProxyUser	ProxyServer 接続プロパティで指定されたプロキシサーバーに登録されているユーザーアカウントのユーザー名を提供します。
ProxyPassword	ProxyUser 接続プロパティで指定されたユーザーのパスワードを指定します。
ProxySSLType	ProxyServer 接続プロパティで指定されたプロキシサーバーに接続する際に使用するSSL タイプを指定します。
ProxyExceptions	ProxyServer 接続プロパティで設定されたプロキシサーバー経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリストを指定します。

ProxyAutoDetect

provider が、手動で指定されたプロキシサーバーを使用するのではなく、既存のプロキシサーバー構成についてシステムプロキシ設定をチェックするかどうかを指定します。

解説

この接続プロパティをTrue に設定すると、Sync App は既存のプロキシサーバー構成についてシステムプロキシ設定をチェックします（プロキシサーバーの詳細を手動で入力する必要はありません）。

この接続プロパティは他のプロキシ設定より優先されます。特定のプロキシサーバーに接続するためにSync App を構成する場合は、ProxyAutoDetect をFalse に設定します。

HTTP プロキシへの接続には、ProxyServer を参照してください。SOCKS やトンネリングなどの他のプロキシには、FirewallType を参照してください。

ProxyServer

HTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレスを指定します。

解説

ProxyAutoDetect がFalse に設定されている場合、Sync App はこの接続プロパティで指定されたプロキシサーバーを通じてのみHTTP トラフィックをルーティングします。

ProxyAutoDetect がTrue（デフォルト）に設定されている場合、Sync App は代わりにシステムプロキシ設定で指定されたプロキシサーバーを介してHTTP トラフィックをルーティングします。

ProxyPort

クライアントとの間でHTTP トラフィックをルーティングするために予約された、指定されたプロキシサーバーのTCP ポートを指定します。

解説

ProxyAutoDetect がFalse に設定されている場合、Sync App はこの接続プロパティで指定されたProxyServer ポートを通じてのみHTTP トラフィックをルーティングします。

ProxyAutoDetect がTrue（デフォルト）に設定されている場合、Sync App は代わりにシステムプロキシ設定で指定されたプロキシサーバーポートを介してHTTP トラフィックをルーティングします。

その他のプロキシタイプについては、FirewallType を参照してください。

ProxyAuthScheme

ProxyServer 接続プロパティで指定されたプロキシサーバーに対して認証する際にprovider が使用する認証方法を指定します。

解説

サポートされる認証の種類：

BASIC：Sync App はHTTP Basic 認証を行います。
DIGEST：Sync App はHTTP ダイジェスト認証を行います。
NTLM：Sync App はNTLM トークンを取得します。
NEGOTIATE： Sync App は認証において有効なプロトコルに応じて、NTLM もしくはKerberos トークンを取得します。
NONE：ProxyServer が認証を必要としないことを示します。

NONE 以外のすべての値については、ProxyUser およびProxyPassword 接続プロパティも設定する必要があります。

SOCKS 5 認証のような他の認証タイプを使用するには、FirewallType を参照してください。

ProxyUser

ProxyServer 接続プロパティで指定されたプロキシサーバーに登録されているユーザーアカウントのユーザー名を提供します。

解説

ProxyUser および ProxyPassword 接続プロパティは、ProxyServer で指定されたHTTP プロキシに対して接続よび認証するために使用されます。

ProxyAuthScheme で利用可能な認証タイプを1つ選択した後、このプロパティを以下のように設定します。


ProxyAuthScheme の値	ProxyUser に設定する値
BASIC	プロキシサーバーに登録されているユーザーのユーザー名。
DIGEST	プロキシサーバーに登録されているユーザーのユーザー名。
NEGOTIATE	プロキシサーバーが属するドメインまたは信頼されたドメイン内の有効なユーザーであるWindows ユーザーのユーザー名。`user@domain` または`domain\user` の形式で指定。
NTLM	プロキシサーバーが属するドメインまたは信頼されたドメイン内の有効なユーザーであるWindows ユーザーのユーザー名。`user@domain` または`domain\user` の形式で指定。
NONE	ProxyPassword 接続プロパティは設定しないでください。

Note：Sync App は、ProxyAutoDetect がFalse に設定されている場合にのみ、このユーザー名を使用します。 ProxyAutoDetect がTrue（デフォルト）に設定されている場合、Sync App は代わりにシステムのプロキシ設定で指定されているユーザー名を使用します。

ProxyPassword

ProxyUser 接続プロパティで指定されたユーザーのパスワードを指定します。

解説

ProxyUser および ProxyPassword 接続プロパティは、ProxyServer で指定されたHTTP プロキシに対して接続よび認証するために使用されます。

ProxyAuthScheme で利用可能な認証タイプを1つ選択した後、このプロパティを以下のように設定します。


ProxyAuthScheme の値	ProxyPassword に設定する値
BASIC	ProxyUser で指定したプロキシサーバーユーザーに紐付けられたパスワード。
DIGEST	ProxyUser で指定したプロキシサーバーユーザーに紐付けられたパスワード。
NEGOTIATE	ProxyUser で指定したWindows ユーザーアカウントに紐付けられたパスワード。
NTLM	ProxyUser で指定したWindows ユーザーアカウントに紐付けられたパスワード。
NONE	ProxyPassword 接続プロパティは設定しないでください。

SOCKS 5 認証もしくは、トンネリングは、FirewallType を参照してください。

Note：Sync App は、ProxyAutoDetect がFalse に設定されている場合にのみ、このパスワードを使用します。 ProxyAutoDetect がTrue（デフォルト）に設定されている場合、Sync App は代わりにシステムのプロキシ設定で指定されているパスワードを使用します。

ProxySSLType

ProxyServer 接続プロパティで指定されたプロキシサーバーに接続する際に使用するSSL タイプを指定します。

解説

このプロパティは、ProxyServer で指定されたHTTP プロキシへの接続にSSL を使用するかどうかを決定します。この接続プロパティには、以下の値を設定できます。


AUTO	デフォルト設定。ProxyServer がHTTPS URL に設定されている場合、Sync App は、TUNNEL オプションを使用します。ProxyServer がHTTP URL に設定されている場合、コンポーネントはNEVER オプションを使用します。
ALWAYS	接続は、常にSSL 有効となります。
NEVER	接続は、SSL 有効になりません。
TUNNEL	接続はトンネリングプロキシ経由で行われます。プロキシサーバーがリモートホストへの接続を開き、プロキシを経由して通信が行われます。

ProxyExceptions

ProxyServer 接続プロパティで設定されたプロキシサーバー経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリストを指定します。

解説

ProxyServer は、このプロパティで定義されたアドレスを除くすべてのアドレスに使用されます。セミコロンを使用してエントリを区切ります。

Note：Sync App はデフォルトでシステムプロキシ設定を使用するため、それ以上の設定は必要ありません。この接続にプロキシ例外を明示的に設定する場合は、ProxyAutoDetect をFalse に設定します。

Logging

このセクションでは、本プロバイダーの接続文字列で設定可能なLogging プロパティの全リストを提供します。

プロパティ	説明
LogModules	ログファイルに含めるコアモジュールを指定します。セミコロンで区切られたモジュール名のリストを使用します。デフォルトでは、すべてのモジュールがログに記録されます。

LogModules

ログファイルに含めるコアモジュールを指定します。セミコロンで区切られたモジュール名のリストを使用します。デフォルトでは、すべてのモジュールがログに記録されます。

解説

Sync App は、実行する各操作の詳細を Logfile 接続プロパティで指定されたログファイルに書き込みます。

ログに記録される各操作は、モジュールと呼ばれるカテゴリに分類されます。各モジュールには対応する短いコードがあり、個々の Sync App の操作がどのモジュールに属するかを示すラベルとして使用されます。

この接続プロパティにモジュールコードをセミコロン区切りのリストで設定すると、指定したモジュールに属する操作のみがログファイルに書き込まれます。この設定は今後のログ記録にのみ適用され、既存のログファイルの内容には影響しません。例: INFO;EXEC;SSL;META;

デフォルトでは、すべてのモジュールの操作がログに含まれます。

モジュールを明示的に除外するには、先頭に「-」を付けます。例: -HTTP

サブモジュールにフィルターを適用するには、<モジュール名>.<サブモジュール名> の構文で指定します。たとえば、次の値を設定すると、Sync App は HTTP モジュールに属するアクションのみをログに記録し、さらに HTTP モジュールの Res サブモジュールに属するアクションを除外します: HTTP;-HTTP.Res

Verbosity 接続プロパティによるログファイルのフィルタリングは、この接続プロパティによるフィルタリングよりも優先されます。そのため、Verbosity 接続プロパティで指定したレベルよりも高い詳細レベルの操作は、この接続プロパティで指定したモジュールに属していても、ログファイルには出力されません。

使用可能なモジュールとサブモジュールは次のとおりです。


モジュール名	モジュールの説明	サブモジュール
INFO	一般情報。接続文字列、製品バージョン（ビルド番号）、および初期接続メッセージが含まれます。	Connec — 接続の作成または破棄に関連する情報。 Messag — 接続、接続文字列、製品バージョンに関するメッセージの汎用ラベル。これらのメッセージは通常、サービスから直接受信して転送されるものではなく、Sync App 固有のものです。
EXEC	クエリ実行。ユーザーが記述した SQL クエリ、解析済み SQL クエリ、正規化済み SQL クエリの実行メッセージが含まれます。クエリおよびクエリページの成功/失敗メッセージもここに表示されます。	Messag — クエリ実行に関するメッセージ。これらのメッセージは通常、サービスから直接受信して転送されるものではなく、Sync App 固有のものです。 Normlz — クエリの正規化ステップ。クエリの正規化とは、ユーザーが送信したクエリを、最適なパフォーマンスで同じ結果を得られるように書き換える処理です。 Origin — ユーザーの元のクエリ（ユーザーが実行した正確で未変更の非正規化クエリ）を記録するメッセージに適用されるラベル。 Page — クエリのページングに関連するメッセージ。 Parsed — クエリの解析ステップ。解析とは、ユーザーが送信したクエリを、処理しやすい標準化された形式に変換するプロセスです。
HTTP	HTTP プロトコルメッセージ。HTTP リクエスト/レスポンス（POST メッセージを含む）、および Kerberos 関連のメッセージが含まれます。	KERB — Kerberos に関連する HTTP リクエスト。 Messag — HTTP プロトコルに関するメッセージ。これらのメッセージは通常、サービスから直接受信して転送されるものではなく、Sync App 固有のものです。 Unpack — サービス API から返された圧縮データを製品が解凍する際のメッセージに適用されるラベル。 Res — HTTP レスポンスを含むメッセージ。 Req — HTTP リクエストを含むメッセージ。
WSDL	WSDL/XSD ファイルの生成に関するメッセージ。	—
SSL	SSL 証明書メッセージ。	Certif — SSL 証明書に関するメッセージ。
AUTH	認証関連の失敗/成功メッセージ。	Messag — 認証に関するメッセージ。これらのメッセージは通常、サービスから直接受信して転送されるものではなく、Sync App 固有のものです。 OAuth — OAuth 認証に関連するメッセージ。 Krbros — Kerberos 関連の認証メッセージ。
SQL	SQL トランザクション、SQL 一括転送メッセージ、および SQL 結果セットメッセージが含まれます。	Bulk — 一括クエリ実行に関するメッセージ。 Cache — パフォーマンス向上のため、製品のキャッシュへの行データの読み書きに関連するメッセージ。 Messag — SQL トランザクションに関するメッセージ。これらのメッセージは通常、サービスから直接受信して転送されるものではなく、Sync App 固有のものです。 ResSet — クエリの結果セット。 Transc — 実行されたジョブ数やバックアップテーブルの処理に関する情報を含む、トランザクション処理に関連するメッセージ。
META	メタデータキャッシュとスキーマメッセージ。	Cache — パフォーマンス向上のため、製品のキャッシュ内のカラムおよびテーブル定義の読み取りと変更に関連するメッセージ。 Schema — サービススキーマからのメタデータの取得またはサービススキーマの変更に関連するメッセージ。 MemSto — インメモリメタデータキャッシュへの書き込みまたは読み取りに関連するメッセージ。 Storag — メモリ内ではなく、ディスクまたは外部データストアへのメタデータの保存に関連するメッセージ。
FUNC	SQL 関数の実行に関連する情報。	Errmsg — SQL 関数の実行に関連するエラーメッセージ。
TCP	TCP トランスポートレイヤーメッセージでの送受信生バイト。	Send — TCP プロトコル経由で送信された生データ。 Receiv — TCP プロトコル経由で受信した生データ。
FTP	File Transfer Protocol に関するメッセージ。	Info — FTP プロトコルでの通信に関連するステータスメッセージ。 Client — FTP 通信中に FTP クライアント（製品）が実行したアクションに関連するメッセージ。 Server — FTP 通信中に FTP サーバーが実行したアクションに関連するメッセージ。
SFTP	Secure File Transfer Protocol に関するメッセージ。	Info — SFTP プロトコルでの通信に関連するステータスメッセージ。 To_Server — SFTP 通信中に SFTP クライアント（製品）が実行したアクションに関連するメッセージ。 From_Server — SFTP 通信中に SFTP サーバーが実行したアクションに関連するメッセージ。
POP	Post Office Protocol 経由で転送されるデータに関するメッセージ。	Client — POP 通信中に POP クライアント（製品）が実行したアクションに関連するメッセージ。 Server — POP 通信中に POP サーバーが実行したアクションに関連するメッセージ。 Status — POP プロトコルでの通信に関連するステータスメッセージ。
SMTP	Simple Mail Transfer Protocol 経由で転送されるデータに関するメッセージ。	Client — SMTP 通信中に SMTP クライアント（製品）が実行したアクションに関連するメッセージ。 Server — SMTP 通信中に SMTP サーバーが実行したアクションに関連するメッセージ。 Status — SMTP プロトコルでの通信に関連するステータスメッセージ。
CORE	他のモジュールでカバーされていない、さまざまな製品内部操作に関連するメッセージ。	—
DEMN	SQL リモーティングに関連するメッセージ。	—
CLJB	一括データアップロード（クラウドジョブ）に関するメッセージ。	Commit — 一括データアップロードの送信。
SRCE	他のモジュールに属さない、製品が生成するその他のメッセージ。	—
TRANCE	低レベルの製品操作に関する高度なメッセージ。	—

Schema

このセクションでは、本プロバイダーの接続文字列で設定可能なSchema プロパティの全リストを提供します。

プロパティ	説明
Location	テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリの場所を指定します。サービスの要件に応じて、これは絶対パスまたは相対パスのいずれかで表されます。
BrowsableSchemas	レポートされるスキーマを利用可能なすべてのスキーマのサブセットに制限するオプション設定。例えば、 BrowsableSchemas=SchemaA,SchemaB,SchemaC です。
Tables	レポートされるテーブルを利用可能なすべてのテーブルのサブセットに制限するオプション設定。例えば、 Tables=TableA,TableB,TableC です。
Views	レポートされたビューを使用可能なテーブルのサブセットに制限するオプション設定。例えば、 Views=ViewA,ViewB,ViewC です。

Location

テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリの場所を指定します。サービスの要件に応じて、これは絶対パスまたは相対パスのいずれかで表されます。

解説

Location プロパティは、定義をカスタマイズしたり（例えば、カラム名を変更する、カラムを無視するなど）、新しいテーブル、ビュー、またはストアドプロシージャでデータモデルを拡張する場合にのみ必要です。

指定しない場合、デフォルトの場所は%APPDATA%\\CData\\Avalara Data Provider\\Schema となり、%APPDATA%はユーザーのコンフィギュレーションディレクトリに設定されます：


プラットフォーム	%APPDATA%
Windows	APPDATA 環境変数の値
Linux	~/.config

BrowsableSchemas

レポートされるスキーマを利用可能なすべてのスキーマのサブセットに制限するオプション設定。例えば、 BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

解説

利用可能なデータベーススキーマをすべてリストすると余分な時間がかかり、パフォーマンスが低下します。接続文字列にスキーマのリストを指定することで、時間を節約しパフォーマンスを向上させることができます。

Tables

レポートされるテーブルを利用可能なすべてのテーブルのサブセットに制限するオプション設定。例えば、 Tables=TableA,TableB,TableC です。

解説

データベースによっては、利用可能なすべてのテーブルをリストするのに時間がかかり、パフォーマンスが低下する場合があります。接続文字列にテーブルのリストを指定することで、時間を節約しパフォーマンスを向上させることができます。

利用可能なテーブルがたくさんあり、すでに作業したいテーブルが決まっている場合、このプロパティを使用して対象のテーブルのみに表示を制限することができます。これを行うには、カンマ区切りのリストで使用したいテーブルを指定します。各テーブルは、角かっこ、二重引用符、またはバッククオートを使用してエスケープされた特殊文字列を含む有効なSQL 識別子である必要があります。例えば、Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space` です。

Note：複数のスキーマまたはカタログを持つデータソースに接続する場合は、表示する各テーブルを完全修飾名で指定する必要があります。これにより、複数のカタログやスキーマに存在するテーブルが混同されることを防ぎます。

Views

レポートされたビューを使用可能なテーブルのサブセットに制限するオプション設定。例えば、 Views=ViewA,ViewB,ViewC です。

解説

データベースによっては、利用可能なすべてのビューをリストするのに時間がかかり、パフォーマンスが低下する場合があります。接続文字列にビューのリストを指定することで、時間を節約しパフォーマンスを向上させることができます。

利用可能なビューがたくさんあり、すでに作業したいビューが決まっている場合、このプロパティを使用して対象のビューのみに表示を制限することができます。これを行うには、カンマ区切りのリストで使用したいビューを指定します。各ビューは、角かっこ、二重引用符、またはバッククオートを使用してエスケープされた特殊文字列を含む有効なSQL 識別子である必要があります。例えば、Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space` です。

Note：複数のスキーマまたはカタログを持つデータソースに接続する場合は、確認する各ビューを完全修飾名で指定する必要があります。これにより、複数のカタログやスキーマに存在するビューが混同されることを防ぎます。

Miscellaneous

このセクションでは、本プロバイダーの接続文字列で設定可能なMiscellaneous プロパティの全リストを提供します。

プロパティ	説明
GenerateSchemaFiles	スキーマを生成して保存するユーザーの好みのタイミングを示します。
IncludeAdjustedTransactions	Whether or not to include adjusted transactions in the transaction listing.
MaxRows	集計やGROUP BY を含まないクエリで返される最大行数を指定します。
Other	特定の問題に対処するため、特殊なシナリオ向けの高度な接続プロパティを指定します。このプロパティは、サポートチームの指示がある場合にのみ使用してください。
Pagesize	The maximum number of results to return per page from Avalara when using client paging.
PseudoColumns	テーブルカラムとして公開する擬似カラムを、'TableName=ColumnName;TableName=ColumnName' の形式の文字列で指定します。
Timeout	provider がタイムアウトエラーを返すまでにサーバーからの応答を待機する最大時間を秒単位で指定します。
UserDefinedViews	カスタムビューを定義するJSON 構成ファイルへのファイルパスを指定します。provider は、このファイルで指定されたビューを自動的に検出して使用します。

GenerateSchemaFiles

スキーマを生成して保存するユーザーの好みのタイミングを示します。

解説

このプロパティは、Location で指定されたパスの.rsd ファイルにスキーマをアウトプットします。

有効な設定は次のとおりです。

Never：スキーマファイルは生成されません。
OnUse：スキーマファイルがまだ存在していない場合に、初めてテーブルが参照されるときにスキーマファイルが生成されます。
OnStart：現在スキーマファイルを持たないあらゆるテーブルに対して、接続時にスキーマファイルが生成されます。
OnCreate：CREATE TABLE SQL クエリを実行すると、スキーマファイルが生成されます。

ファイルを再生成したい場合には、既存のファイルを削除する必要があることに注意してください。

SQL でスキーマを生成する

GenerateSchemaFiles をOnUse に設定すると、Sync App はSELECT クエリを実行したときにスキーマを生成します。スキーマはクエリのそれぞれの参照されたテーブルに対して生成されます。

GenerateSchemaFiles をOnCreate に設定すると、CREATE TABLE クエリが実行されたときにのみスキーマが生成されます。

接続時にスキーマを生成する

このプロパティのもう一つの使い方は、接続するときにデータベース内のすべてのテーブルのスキーマを取得することです。これには、GenerateSchemaFiles をOnStart に設定して接続します。

IncludeAdjustedTransactions

Whether or not to include adjusted transactions in the transaction listing.

解説

Whether or not to include adjusted transactions in the transaction listing.

MaxRows

集計やGROUP BY を含まないクエリで返される最大行数を指定します。

解説

このプロパティのデフォルト値である-1 は、クエリに明示的にLIMIT 句が含まれていない限り、行の制限が適用されないことを意味します。（クエリにLIMIT 句が含まれている場合、クエリで指定された値がMaxRows 設定よりも優先されます。）

MaxRows を0より大きい整数に設定することで、クエリがデフォルトで過度に大きな結果セットを返さないようにします。

このプロパティは、非常に大きなデータセットを返す可能性のあるクエリを実行する際に、パフォーマンスを最適化し、過剰なリソース消費を防ぐのに役立ちます。

Other

特定の問題に対処するため、特殊なシナリオ向けの高度な接続プロパティを指定します。このプロパティは、サポートチームの指示がある場合にのみ使用してください。

解説

このプロパティにより、シニアユーザーはサポートチームのアドバイスに基づいて、特定の状況に対応する隠しプロパティを設定できます。これらの設定は通常のユースケースには必要ありませんが、特定の要件に対応したり、追加の機能を提供したりすることができます。複数のプロパティを定義するには、セミコロンで区切られたリストを使用します。

Note：特定のシナリオや問題に対処するためにサポートチームから助言があった場合にのみ、これらのプロパティを設定することを強く推奨します。

統合およびフォーマット


プロパティ	説明
DefaultColumnSize	データソースがメタデータにカラムの長さを提供しない場合に、文字列フィールドのデフォルトの長さを設定します。デフォルト値は2000です。
ConvertDateTimeToGMT=True	日時の値を、マシンのローカルタイムではなくGMT グリニッジ標準時に変換します。デフォルト値はFalse（ローカルタイムを使用）です。
RecordToFile=filename	基底のソケットデータ転送を指定のファイルに記録します。

Pagesize

The maximum number of results to return per page from Avalara when using client paging.

解説

The Pagesize property affects the maximum number of results to return per page from Avalara when using client paging. A higher value will return more results per page, but may also cause a timeout exception. If you must use client paging on your server and have a fast server, setting a higher Pagesize may be desirable. We recommend testing various sizes against a large resultset to determine what works best in your use case.

PseudoColumns

テーブルカラムとして公開する擬似カラムを、'TableName=ColumnName;TableName=ColumnName' の形式の文字列で指定します。

解説

このプロパティを使用すると、Sync App がテーブルカラムとして公開する擬似カラムを定義できます。

個々の擬似カラムを指定するには、以下の形式を使用します。

Table1=Column1;Table1=Column2;Table2=Column3

すべてのテーブルのすべての擬似カラムを含めるには、次を使用してください：

*=*

Timeout

provider がタイムアウトエラーを返すまでにサーバーからの応答を待機する最大時間を秒単位で指定します。

解説

タイムアウトは、クエリや操作全体ではなくサーバーとの個々の通信に適用されます。例えば、各ページング呼び出しがタイムアウト制限内に完了する場合、クエリは60秒を超えて実行を続けることができます。

タイムアウトはデフォルトで60秒に設定されています。タイムアウトを無効にするには、このプロパティを0に設定します。

タイムアウトを無効にすると、操作が成功するか、サーバー側のタイムアウト、ネットワークの中断、またはサーバーのリソース制限などの他の条件で失敗するまで無期限に実行されます。

Note： このプロパティは慎重に使用してください。長時間実行される操作がパフォーマンスを低下させたり、応答しなくなる可能性があるためです。

UserDefinedViews

カスタムビューを定義するJSON 構成ファイルへのファイルパスを指定します。provider は、このファイルで指定されたビューを自動的に検出して使用します。

解説

UserDefinedViews を使用すると、UserDefinedViews.json というJSON 形式の構成ファイルを通じてカスタムビューを定義および管理できます。これらのビューはSync App によって自動的に認識され、標準のデータベースビューのようにカスタムSQL クエリを実行できるようになります。 JSON ファイルは、各ビューをルート要素として定義し、その子要素として"query" を持ちます。この"query" にはビューのSQL クエリが含まれています。

次に例を示します。

{
	"MyView": {
		"query": "SELECT * FROM Transactions WHERE MyColumn = 'value'"
	},
	"MyView2": {
		"query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
	}
}

このプロパティを使用して、1つのファイルに複数のビューを定義し、ファイルパスを指定できます。次に例を示します。

UserDefinedViews=C:\Path\To\UserDefinedViews.json

UserDefinedViews でビューを指定すると、Sync App はそのビューだけを参照します。

詳しくは、ユーザー定義ビューを参照してください。

Third Party Copyrights

LZMA from 7Zip LZMA SDK

LZMA SDK is placed in the public domain.

Anyone is free to copy, modify, publish, use, compile, sell, or distribute the original LZMA SDK code, either in source code form or as a compiled binary, for any purpose, commercial or non-commercial, and by any means.

LZMA2 from XZ SDK

Version 1.9 and older are in the public domain.

Xamarin.Forms

Xamarin SDK

The MIT License (MIT)

Copyright (c) .NET Foundation Contributors

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

NSIS 3.10

Copyright (C) 1999-2025 Contributors THE ACCOMPANYING PROGRAM IS PROVIDED UNDER THE TERMS OF THIS COMMON PUBLIC LICENSE ("AGREEMENT"). ANY USE, REPRODUCTION OR DISTRIBUTION OF THE PROGRAM CONSTITUTES RECIPIENT'S ACCEPTANCE OF THIS AGREEMENT.

1. DEFINITIONS

"Contribution" means:

a) in the case of the initial Contributor, the initial code and documentation distributed under this Agreement, and b) in the case of each subsequent Contributor:

i) changes to the Program, and

ii) additions to the Program;

where such changes and/or additions to the Program originate from and are distributed by that particular Contributor. A Contribution 'originates' from a Contributor if it was added to the Program by such Contributor itself or anyone acting on such Contributor's behalf. Contributions do not include additions to the Program which: (i) are separate modules of software distributed in conjunction with the Program under their own license agreement, and (ii) are not derivative works of the Program.

"Contributor" means any person or entity that distributes the Program.

"Licensed Patents " mean patent claims licensable by a Contributor which are necessarily infringed by the use or sale of its Contribution alone or when combined with the Program.

"Program" means the Contributions distributed in accordance with this Agreement.

"Recipient" means anyone who receives the Program under this Agreement, including all Contributors.

2. GRANT OF RIGHTS

a) Subject to the terms of this Agreement, each Contributor hereby grants Recipient a non-exclusive, worldwide, royalty-free copyright license to reproduce, prepare derivative works of, publicly display, publicly perform, distribute and sublicense the Contribution of such Contributor, if any, and such derivative works, in source code and object code form.

b) Subject to the terms of this Agreement, each Contributor hereby grants Recipient a non-exclusive, worldwide, royalty-free patent license under Licensed Patents to make, use, sell, offer to sell, import and otherwise transfer the Contribution of such Contributor, if any, in source code and object code form. This patent license shall apply to the combination of the Contribution and the Program if, at the time the Contribution is added by the Contributor, such addition of the Contribution causes such combination to be covered by the Licensed Patents. The patent license shall not apply to any other combinations which include the Contribution. No hardware per se is licensed hereunder.

c) Recipient understands that although each Contributor grants the licenses to its Contributions set forth herein, no assurances are provided by any Contributor that the Program does not infringe the patent or other intellectual property rights of any other entity. Each Contributor disclaims any liability to Recipient for claims brought by any other entity based on infringement of intellectual property rights or otherwise. As a condition to exercising the rights and licenses granted hereunder, each Recipient hereby assumes sole responsibility to secure any other intellectual property rights needed, if any. For example, if a third party patent license is required to allow Recipient to distribute the Program, it is Recipient's responsibility to acquire that license before distributing the Program.

d) Each Contributor represents that to its knowledge it has sufficient copyright rights in its Contribution, if any, to grant the copyright license set forth in this Agreement.

3. REQUIREMENTS

A Contributor may choose to distribute the Program in object code form under its own license agreement, provided that:

a) it complies with the terms and conditions of this Agreement; and

b) its license agreement:

i) effectively disclaims on behalf of all Contributors all warranties and conditions, express and implied, including warranties or conditions of title and non-infringement, and implied warranties or conditions of merchantability and fitness for a particular purpose;

ii) effectively excludes on behalf of all Contributors all liability for damages, including direct, indirect, special, incidental and consequential damages, such as lost profits;

iii) states that any provisions which differ from this Agreement are offered by that Contributor alone and not by any other party; and

iv) states that source code for the Program is available from such Contributor, and informs licensees how to obtain it in a reasonable manner on or through a medium customarily used for software exchange.

When the Program is made available in source code form:

a) it must be made available under this Agreement; and

b) a copy of this Agreement must be included with each copy of the Program.

Contributors may not remove or alter any copyright notices contained within the Program.

Each Contributor must identify itself as the originator of its Contribution, if any, in a manner that reasonably allows subsequent Recipients to identify the originator of the Contribution.

4. COMMERCIAL DISTRIBUTION

Commercial distributors of software may accept certain responsibilities with respect to end users, business partners and the like. While this license is intended to facilitate the commercial use of the Program, the Contributor who includes the Program in a commercial product offering should do so in a manner which does not create potential liability for other Contributors. Therefore, if a Contributor includes the Program in a commercial product offering, such Contributor ("Commercial Contributor") hereby agrees to defend and indemnify every other Contributor ("Indemnified Contributor") against any losses, damages and costs (collectively "Losses") arising from claims, lawsuits and other legal actions brought by a third party against the Indemnified Contributor to the extent caused by the acts or omissions of such Commercial Contributor in connection with its distribution of the Program in a commercial product offering. The obligations in this section do not apply to any claims or Losses relating to any actual or alleged intellectual property infringement. In order to qualify, an Indemnified Contributor must: a) promptly notify the Commercial Contributor in writing of such claim, and b) allow the Commercial Contributor to control, and cooperate with the Commercial Contributor in, the defense and any related settlement negotiations. The Indemnified Contributor may participate in any such claim at its own expense.

For example, a Contributor might include the Program in a commercial product offering, Product X. That Contributor is then a Commercial Contributor. If that Commercial Contributor then makes performance claims, or offers warranties related to Product X, those performance claims and warranties are such Commercial Contributor's responsibility alone. Under this section, the Commercial Contributor would have to defend claims against the other Contributors related to those performance claims and warranties, and if a court requires any other Contributor to pay any damages as a result, the Commercial Contributor must pay those damages.

5. NO WARRANTY

EXCEPT AS EXPRESSLY SET FORTH IN THIS AGREEMENT, THE PROGRAM IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, EITHER EXPRESS OR IMPLIED INCLUDING, WITHOUT LIMITATION, ANY WARRANTIES OR CONDITIONS OF TITLE, NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Each Recipient is solely responsible for determining the appropriateness of using and distributing the Program and assumes all risks associated with its exercise of rights under this Agreement, including but not limited to the risks and costs of program errors, compliance with applicable laws, damage to or loss of data, programs or equipment, and unavailability or interruption of operations.

6. DISCLAIMER OF LIABILITY

EXCEPT AS EXPRESSLY SET FORTH IN THIS AGREEMENT, NEITHER RECIPIENT NOR ANY CONTRIBUTORS SHALL HAVE ANY LIABILITY FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING WITHOUT LIMITATION LOST PROFITS), HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OR DISTRIBUTION OF THE PROGRAM OR THE EXERCISE OF ANY RIGHTS GRANTED HEREUNDER, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.

7. GENERAL

If any provision of this Agreement is invalid or unenforceable under applicable law, it shall not affect the validity or enforceability of the remainder of the terms of this Agreement, and without further action by the parties hereto, such provision shall be reformed to the minimum extent necessary to make such provision valid and enforceable.

If Recipient institutes patent litigation against a Contributor with respect to a patent applicable to software (including a cross-claim or counterclaim in a lawsuit), then any patent licenses granted by that Contributor to such Recipient under this Agreement shall terminate as of the date such litigation is filed. In addition, if Recipient institutes patent litigation against any entity (including a cross-claim or counterclaim in a lawsuit) alleging that the Program itself (excluding combinations of the Program with other software or hardware) infringes such Recipient's patent(s), then such Recipient's rights granted under Section 2(b) shall terminate as of the date such litigation is filed.

All Recipient's rights under this Agreement shall terminate if it fails to comply with any of the material terms or conditions of this Agreement and does not cure such failure in a reasonable period of time after becoming aware of such noncompliance. If all Recipient's rights under this Agreement terminate, Recipient agrees to cease use and distribution of the Program as soon as reasonably practicable. However, Recipient's obligations under this Agreement and any licenses granted by Recipient relating to the Program shall continue and survive.

Everyone is permitted to copy and distribute copies of this Agreement, but in order to avoid inconsistency the Agreement is copyrighted and may only be modified in the following manner. The Agreement Steward reserves the right to publish new versions (including revisions) of this Agreement from time to time. No one other than the Agreement Steward has the right to modify this Agreement. IBM is the initial Agreement Steward. IBM may assign the responsibility to serve as the Agreement Steward to a suitable separate entity. Each new version of the Agreement will be given a distinguishing version number. The Program (including Contributions) may always be distributed subject to the version of the Agreement under which it was received. In addition, after a new version of the Agreement is published, Contributor may elect to distribute the Program (including its Contributions) under the new version. Except as expressly stated in Sections 2(a) and 2(b) above, Recipient receives no rights or licenses to the intellectual property of any Contributor under this Agreement, whether expressly, by implication, estoppel or otherwise. All rights in the Program not expressly granted under this Agreement are reserved.

This Agreement is governed by the laws of the State of New York and the intellectual property laws of the United States of America. No party to this Agreement will bring a legal action under this Agreement more than one year after the cause of action arose. Each party waives its rights to a jury trial in any resulting litigation.

Avalara Connector for CData Sync

Avalara Connector for CData Sync

概要

Avalara バージョンサポート

接続の確立

Avalara への接続を追加

Connecting to Avalara

Authenticating to Avalara

Login Credentials

Account Number and License Key

データアクセスのファインチューニング

Fine Tuning Data Access

高度な機能

ユーザー定義ビュー

SSL の設定

ファイアウォールとプロキシ

クエリ処理

ログ

SSL の設定

SSL 設定のカスタマイズ

ファイアウォールとプロキシ

Firewall またはProxy 経由の接続

HTTP プロキシ

その他のプロキシ

データモデル

Overview

Key Features

Tables

Views

Stored Procedures

テーブル

Avalara Connector for CData Sync テーブル

Accounts

Select

Insert

Update

Delete

Columns

Batches

Insert

Update

Delete

Columns

Companies

Insert

Update

Delete

Columns

Contacts

Select

Insert

Update

Delete

Columns

Customers

Select

Columns

DataSources

Insert

Update

Delete

Columns

DistanceThresholds

Insert

Update

Delete

Columns

FilingCalendars

Select

Columns

Items

Select

Insert

Update

Delete

Columns

Locations

Insert

Update

Delete