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 |