Vendors

Stores vendor details such as addresses, contact information, and payment terms, for procurement workflows.

Table-Specific Information

The Vendors table is only accessible when connected to a ZohoCRM Enterprise Edition account. If using a different edition, this table may not be available.

Select

This table supports the COQL and BULK APIs for filtering, meaning that most filters comparing columns to values are submitted server-side.

Insert

The following example demonstrates a basic insert operation:

-- Insert a new vendor with a name, email address, and website
INSERT INTO Vendors (VendorName, Email, Website) VALUES ('XYZVendor', '[email protected]', 'vendeverything.xyz')

Required fields: VendorName is required. This identifies the vendor record being created.

Any field which is not read-only (ReadOnly = false in the table schema) can be inserted.

Delete

You must specify the Id column in the WHERE clause to delete a record. The following example demonstrates a delete operation:

-- Delete a vendor by its unique ID
DELETE FROM Vendors WHERE Id = '3152079000000153079'

Update

You must specify the Id column in the WHERE clause to update a record. The following example demonstrates an update operation:

-- Update the description for a specific vendor using its ID
UPDATE Vendors SET Description = 'Changed from the API' WHERE Id = '3152079000000492032'

Required fields: Id is required. The update must target a specific record.

Any field which is not read-only (ReadOnly = false in the table schema) can be updated.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	True	A unique identifier (Id) for the vendor record.
Latitude	Double	False	Latitude coordinate of the vendor's address.
Longitude	Double	False	Longitude coordinate of the vendor's address.
Vendor_Name	String	False	The name of the vendor.
Phone	String	False	The vendor's phone number.
Email	String	False	The vendor's email address.
Website	String	False	The vendor's website URL.
GL_Account	String	False	The general ledger account associated with the vendor.
Category	String	False	The category or classification of the vendor.
Owner_Id	String	False	The unique Id of the user who owns this vendor record.
Owner_FirstName	String	True	The first name of the vendor record owner.
Owner_LastName	String	True	The last name of the vendor record owner.
Owner_Email	String	True	The email address of the vendor record owner.
Created_By_Id	String	False	The unique Id of the user who created this vendor record.
Modified_By_Id	String	False	The unique Id of the user who last modified this vendor record.
Modified_By_FirstName	String	True	The first name of the user who last modified this vendor record.
Modified_By_LastName	String	True	The last name of the user who last modified this vendor record.
Modified_By_Email	String	True	The email address of the user who last modified this vendor record.
Created_Time	Datetime	False	The date and time when the vendor record was created.
Modified_Time	Datetime	False	The date and time when the vendor record was last modified.
Tag	String	False	Any tags associated with this vendor record.
Description	String	False	Additional descriptive information about the vendor.
Record_Image	String	False	The image or logo associated with the vendor.
Id_CustomModule	Long	True	A system-generated record Id for internal reference.
Locked__s	Bool	True	Indicates whether the vendor record is locked from further edits.
Email_Opt_Out	Bool	False	Indicates whether the vendor has opted out of email communication.
Unsubscribed_Mode	String	True	Describes how the vendor unsubscribed from emails.
Unsubscribed_Time	Datetime	True	The date and time when the vendor unsubscribed.
Last_Activity_Time	Datetime	False	The most recent time of activity related to the vendor.
Country	String	False	The country where the vendor is located.
Flat_House_No_Building_Apartment_Name	String	False	Flat/house number, building, or apartment name portion of the vendor's address.
Street	String	False	The street address of the vendor.
City	String	False	The city where the vendor is located.
State	String	False	The state or province where the vendor is located.
Zip_Code	String	False	The postal code of the vendor's address.

Pseudo-Columns

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


Name	Type	Description
DuplicateCheckFields	String	The field(s) to be used for checking duplicate records in an upsert. The REST API allows for more than one field in the duplicate check but the BULK API only allows one field.
Trigger	String	To trigger the rule while inserting record into CRM account.

ADO.NET Provider for Zoho CRM