Vendors

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 Accounts Hosted 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.