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 |