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 connector 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 connector.
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 |