Vendors
Create, update, delete, and query Reckon Vendors.
Table Specific Information
This table has a Custom Fields column. See the カスタムフィールド 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. | |
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
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. 使用できる値は次のとおりです。ALL, ACTIVE, INACTIVE, NA デフォルト値はALLです。 |
NameMatchType | String |
This pseudo column is deprecated and should no longer be used. Type of match to perform on name. 使用できる値は次のとおりです。EXACT, STARTSWITH, ENDSWITH, CONTAINS デフォルト値は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. |