ADO.NET Provider for Avalara

Build 24.0.9060

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

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