Excel Add-In for Avalara

Build 24.0.9060

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 add-in 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 add-in. 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

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