CData JDBC Driver for Reckon 2019 - Online Help
Questions / Feedback?

Vendors

CData JDBC Driver for Reckon 2019 - Build 19.0.7354

Create, update, delete, and query Reckon Vendors.

Table Specific Information

This table has a Custom Fields column. See the Custom Fields page for more information.

Select

By default, SupportEnhancedSQL is set to true, and the following will be honored if present. Other filters will be executed client side. If SupportEnhancedSQL is set to false, only the following filters will be honored.

Reckon allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can only be used with the equals or = comparison. The available columns for the Vendors table are Id, TimeModified, Balance, and Name. TimeModified may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. Balance may be used with the >=, <=, or = conditions but cannot be used to specify a range. Name may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax. For example:

SELECT * FROM Vendors WHERE TimeModified > '1/1/2011' AND TimeModified < '2/1/2011' AND Name LIKE '%12345%'

Insert

To add a Vendor, specify the Name column.

Columns

Name Type ReadOnly References Description
ID [KEY] String True

The unique identifier of the Vendor.

Name String False

The vendor's name. This is required to have a value when inserting.

Salutation String False

A salutation, such as Mr., Mrs., etc.

FirstName String False

A first name.

MiddleInitial String False

The middle initial.

LastName String False

A last name.

Company String False

The vendor's company name.

Contact String False

The contact's name.

AccountNumber String False

The account number for this vendor.

Type String False

The type of vendor, predefined in Reckon.

TypeId String False

The type of vendor, predefined in Reckon.

CreditLimit Double False

The credit limit for this vendor.

TaxIdentity String False

String that identifies the vendor to the IRS.

AlternateContact String False

The alternate contact's name.

Phone String False

The vendor's telephone number.

Fax String False

The vendor's fax number.

AlternatePhone String False

The vendor's alternate telephone number.

Email String False

The vendor's email address.

Notes String False

Notes on this vendor.

Address String True

Full address returned by Reckon.

Line1 String False

First line of the address.

Line2 String False

Second line of the address.

Line3 String False

Third line of the address.

Line4 String False

Fourth line of the address.

Line5 String False

Fifth line of the address.

City String False

City name for the address of the vendor.

State String False

State name for the address of the vendor.

PostalCode String False

Postal code for the address of the vendor.

Country String False

Country for the address of the vendor.

Note String False

Note for the address of the vendor.

Balance Double True

Open balance for this vendor.

Terms String False

A reference to terms of payment for this vendor. A typical example might be '2% 10 Net 60'. This field can be set in inserts but not in updates.

TermsId String False

A reference to terms of payment for this vendor.

EligibleFor1099 Boolean False

Whether this vendor is eligible for 1099.

NameOnCheck String False

The name to be printed on checks.

IsActive Boolean False

Whether or not the vendor is active.

CustomFields String False

Custom fields returned from Reckon and formatted into XML.

EditSequence String True

An identifier for this copy of the object.

TimeModified Datetime True

When the vendor was last modified.

TimeCreated Datetime True

When the vendor was created.

PrefillAccountId1 String False

Id of an Account Prefill defined for this vendor.

PrefillAccountName1 String False

Name of an Account Prefill defined for this vendor.

PrefillAccountId2 String False

Id of an Account Prefill defined for this vendor.

PrefillAccountName2 String False

Name of an Account Prefill defined for this vendor.

PrefillAccountId3 String False

Id of an Account Prefill defined for this vendor.

PrefillAccountName3 String False

Name of an Account Prefill defined for this vendor.

Pseudo-Columns

Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
StartModifiedDate String

This pseudo column is deprecated and should no longer be used. Earliest modified date to search for.

EndModifiedDate String

This pseudo column is deprecated and should no longer be used. Latest modified date to search for.

ActiveStatus String

This pseudo column is deprecated and should no longer be used. Limits the search to active or inactive records only or all records.

The allowed values are ALL, ACTIVE, INACTIVE, NA.

The default value is ALL.

NameMatchType String

This pseudo column is deprecated and should no longer be used. Type of match to perform on name.

The allowed values are EXACT, STARTSWITH, ENDSWITH, CONTAINS.

The default value is CONTAINS.

MaxBalance String

The maximum balance amount to return results for. Cannot be specified is MinBalance is specified.

MinBalance String

The minimum balance amount to return results for. Cannot be specified if MaxBalance is specified.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0