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 cmdlet 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