Subscriptions
Subscriptions table for AvalaraAvatax data provider.
Select
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 Subscriptions WHERE SubscriptionDescription LIKE 'AVA%'
Columns
| Name | Type | Description |
| Id [KEY] | Int | The unique ID number of this subscription. |
| AccountId [KEY] | Int | The unique ID number of the account this subscription belongs to. |
| ModifiedUserId | Int | The user ID of the user who last modified this record. |
| CreatedUserId | Int | The User ID of the user who created this record. |
| ModifiedDate | Datetime | The date/time when this record was last modified. |
| EndDate | Date | If the subscription has ended or will end, this date indicates when the subscription ends. |
| SubscriptionTypeId | Int | The unique ID number of the service that the account is subscribed to. If this is provided, subscription description is ignored. |
| EffectiveDate | Date | The date when the subscription began. |
| CreatedDate | Datetime | The date when this record was created. |
| SubscriptionDescription | String | A friendly description of the service that the account is subscribed to. You can either provide the subscription type Id or this but not both. If subscription type Id is provided, then this information is ignored and this field will be updated with the information from subscription type id. |
| PageKey | String |