JDBC Driver for SuiteCRM

Build 22.0.8462

Accounts

Create, update, delete, and query accounts created in SuiteCRM

Table Specific Information

Select

You can query the Accounts table using any criteria in the WHERE clause. The driver will use the SuiteCRM API to filter the results.

SELECT * FROM Accounts WHERE Name = 'test'

Insert

Create a SuiteCRM Account by specifying any writable column.

INSERT INTO Accounts (Id, Name) VALUES ('id', 'Energy')

Update

You can update any Account column that is writable, by specifying the Id.

UPDATE Accounts SET Name = 'new name', Description = 'Desc' WHERE Id = 'Test123'

Delete

Remove an Account by specifying the Account's Id.

DELETE FROM Accounts WHERE Id = 'account21'

Columns

Name Type ReadOnly Description
Id [KEY] String False

The unique identifier of the account.

Name String False

The name of the account.

DateEntered Datetime False

The date the record was created.

DateModified Datetime False

The date the record was last modified.

ModifiedUserId String False

The Id of the user who last modified the record.

ModifiedByName String True

The name of the user who last modified the record.

CreatedBy String False

The Id of the user who created the record.

CreatedByName String True

The name of the user who created the record.

Description String False

The full text of the alert.

Deleted Bool False

The record deletion indicator.

CreatedByLink String True

Link to the record who created it

ModifiedUserLink String True

Link to the record who modified it.

AssignedUserId String False

The Id of the user assigned to the record.

AssignedUserName String True

The user name of the user assigned to the record.

AssignedUserLink String True

Link to the user which the record has been assigned to

SecurityGroups String True

The security group associated with the record.

AccountType String False

The type of the account.

Industry String False

The industry that the account belongs in.

AnnualRevenue String False

Annual revenue for this account.

PhoneFax String False

The fax phone number of this account.

BillingAddressStreet String False

The first line of the billing address.

BillingAddressStreet2 String False

The second line of the billing address.

BillingAddressStreet3 String False

The third line of the billing address.

BillingAddressStreet4 String False

The fourth line of the billing address.

BillingAddressCity String False

The city used for the billing address.

BillingAddressState String False

The state used for the billing address.

BillingAddressPostalcode String False

The postal code used for the billing address.

BillingAddressCountry String False

The country used for the billing address.

Rating String False

An arbitrary rating for this account for use in comparisons with others.

PhoneOffice String False

The office phone number.

PhoneAlternate String False

An alternate phone number.

Website String False

The URL of the website for the account.

Ownership String False

The ownership of the account.

Employees String False

Number of employees. Can be a number (100) or range (50-100)

TickerSymbol String False

The stock trading (ticker) symbol for the account.

ShippingAddressStreet String False

The first line of the shipping address.

ShippingAddressStreet2 String False

The second line of the shipping address.

ShippingAddressStreet3 String False

The third line of the shipping address.

ShippingAddressStreet4 String False

The fourth line of the shipping address.

ShippingAddressCity String False

The city used for the shipping address.

ShippingAddressState String False

The state used for the shipping address.

ShippingAddressPostalcode String False

The ZIP code used for the shipping address.

ShippingAddressCountry String False

The country used for the shipping address.

Email1 String False

Email address.

EmailAddressesPrimary String True

Primary email address.

EmailAddresses String True

Alternate Email address.

EmailAddressesNonPrimary String False

Non primary email address.

ParentId String False

The Id of the parent of this account.

SicCode String False

SIC code of the account.

ParentName String True

The name of the parent of this account.

Members String True

MemberOf String True

EmailOptOut Bool False

Whether the account has opted out of emails.

InvalidEmail Bool False

Whether the email address of the account has been marked as invalid.

Cases String True

The cases associated with the record.

Email String False

Email address

Tasks String True

The tasks associated with the record.

Notes String True

The notes associated with the record.

Meetings String True

The meetings associated with the record.

Calls String True

The calls associated with the record

Emails String True

The emails associated with the record

Documents String True

The documents associated with the record.

Bugs String True

The bugs associated with the record.

Contacts String True

The contacts associated with the record

Opportunities String True

The opportunities associated with the record.

Project String True

The project associated with the record.

Leads String True

The leads associated with the record.

Campaigns String True

The campaigns associated with the account.

CampaignAccounts String True

CampaignId String False

The Id of the campaign associated with the record.

CampaignName String True

The name of the campaign associated with the record.

ProspectLists String True

AosQuotes String True

AosInvoices String True

AosContracts String True

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