JDBC Driver for Avalara

Build 22.0.8462

Subscriptions

Subscriptions table for AvalaraAvatax data provider.

Select

The driver 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 driver. 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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462