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