SuiteCRM Connector Objects (suitecrmv8 Schema)

note: This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms. If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at datacloud-connectors-beta@salesforce.com.

Objects Supported

Name	Description
Accounts	Create, update, delete, and query accounts created in SuiteCRM
Calls	Create, update, delete, and query the SuiteCRM project's Calls
Campaigns	Create, update, delete, and query the SuiteCRM project's campaigns
Cases	Create, update, delete, and query the SuiteCRM cases
Contacts	Create, update, delete, and query the contacts in SuiteCRM
Contracts	Create, update, delete, and query contracts in SuiteCRM
Documents	Create, update, delete, and query Documents created in SuiteCRM
Emails	Create, update, delete, and query the SuiteCRM Emails
EmailTemplates	Create, update, delete, and query email templates to be used for emails
Events	Create, update, delete, and query events registered in the SuiteCRM project
Invoices	Create, update, delete, and query the invoices saved in the SuiteCRM
KBCategories	Create, update, delete, and query the KBCategories saved in the SuiteCRM
KnowledgeBase	Create, update, delete, and query the Knowledge Base saved in the SuiteCRM
Leads	Create, update, delete, and query the registered Leads
Locations	Create, update, delete, and query locations in SuiteCRM
Maps	Create, update, delete, and query the map information of SuiteCRM
MapsAddressCache	Create, update, delete, and query information on the Map Address saved in the server cache
MapsAreas	Create, update, delete, and query maps via Google Maps.
MapsMarkers	Create, update, delete, and query Google Maps Map Markers saved in SuiteCRM
Meetings	Create, update, delete, and query Meetings created in SuiteCRM
Notes	Create, update, delete, and query Notes created in SuiteCRM
Opportunities	Create, update, delete, and query opportunities saved in SuiteCRM
PDFTemplates	Create, update, delete, and query PDFTemplates table.
Products	Create, update, delete, and query the products registered for the SuiteCRM project
ProductsCategories	Create, update, delete, and query the product categories.
Projects	Create, update, delete, and query projects registered in SuiteCRM
ProjectsTemplates	Create, update, delete, and query any saved project template.
Quotes	Create, update, delete, and query quotes saved in SuiteCRM
Reports	Create, update, delete, and query information on reports made in SuiteCRM.
Spots	Create, update, delete, and query the saved spots.
Surveys	Create, update, delete, and query the surveys saved in the SuiteCRM
Tasks	Create, update, delete, and query Tasks created in SuiteCRM
WorkFlow	Create, update, delete, and query the wokflow actions in SuiteCRM

Accounts

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the account.
Name	String	False	No	The name of the account.
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	The full text of the alert.
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No	The user name of the user assigned to the record.
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
AccountType	String	False	No	The type of the account.
Industry	String	False	No	The industry that the account belongs in.
AnnualRevenue	String	False	No	Annual revenue for this account.
PhoneFax	String	False	No	The fax phone number of this account.
BillingAddressStreet	String	False	No	The first line of the billing address.
BillingAddressStreet2	String	False	No	The second line of the billing address.
BillingAddressStreet3	String	False	No	The third line of the billing address.
BillingAddressStreet4	String	False	No	The fourth line of the billing address.
BillingAddressCity	String	False	No	The city used for the billing address.
BillingAddressState	String	False	No	The state used for the billing address.
BillingAddressPostalcode	String	False	No	The postal code used for the billing address.
BillingAddressCountry	String	False	No	The country used for the billing address.
Rating	String	False	No	An arbitrary rating for this account for use in comparisons with others.
PhoneOffice	String	False	No	The office phone number.
PhoneAlternate	String	False	No	An alternate phone number.
Website	String	False	No	The URL of the website for the account.
Ownership	String	False	No	The ownership of the account.
Employees	String	False	No	Number of employees. Can be a number (100) or range (50-100)
TickerSymbol	String	False	No	The stock trading (ticker) symbol for the account.
ShippingAddressStreet	String	False	No	The first line of the shipping address.
ShippingAddressStreet2	String	False	No	The second line of the shipping address.
ShippingAddressStreet3	String	False	No	The third line of the shipping address.
ShippingAddressStreet4	String	False	No	The fourth line of the shipping address.
ShippingAddressCity	String	False	No	The city used for the shipping address.
ShippingAddressState	String	False	No	The state used for the shipping address.
ShippingAddressPostalcode	String	False	No	The ZIP code used for the shipping address.
ShippingAddressCountry	String	False	No	The country used for the shipping address.
Email1	String	False	No	Email address.
EmailAddressesPrimary	String	True	No	Primary email address.
EmailAddresses	String	True	No	Alternate Email address.
EmailAddressesNonPrimary	String	False	No	Non primary email address.
ParentId	String	False	No	The Id of the parent of this account.
SicCode	String	False	No	SIC code of the account.
ParentName	String	True	No	The name of the parent of this account.
Members	String	True	No
MemberOf	String	True	No
EmailOptOut	Bool	False	No	Whether the account has opted out of emails.
InvalidEmail	Bool	False	No	Whether the email address of the account has been marked as invalid.
Cases	String	True	No	The cases associated with the record.
Email	String	False	No	Email address
Tasks	String	True	No	The tasks associated with the record.
Notes	String	True	No	The notes associated with the record.
Meetings	String	True	No	The meetings associated with the record.
Calls	String	True	No	The calls associated with the record
Emails	String	True	No	The emails associated with the record
Documents	String	True	No	The documents associated with the record.
Bugs	String	True	No	The bugs associated with the record.
Contacts	String	True	No	The contacts associated with the record
Opportunities	String	True	No	The opportunities associated with the record.
Project	String	True	No	The project associated with the record.
Leads	String	True	No	The leads associated with the record.
Campaigns	String	True	No	The campaigns associated with the account.
CampaignAccounts	String	True	No
CampaignId	String	False	No	The Id of the campaign associated with the record.
CampaignName	String	True	No	The name of the campaign associated with the record.
ProspectLists	String	True	No
AosQuotes	String	True	No
AosInvoices	String	True	No
AosContracts	String	True	No

Return to Top

Calls

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the call.
Name	String	False	No	A brief description of the call.
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	The full text of the note.
Deleted	Bool	False	No	Record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
DurationHours	String	False	No	The hours portion of the call duration.
DurationMinutes	String	False	No	The minutes portion of the call duration.
DateStart	Datetime	False	No
DateEnd	Datetime	False	No
ParentType	String	False	No	The type of the parent Sugar object related to the call.
ParentName	String	True	No	The name of the parent of this account.
Status	String	False	No	The status of the record.
Direction	String	False	No	Indicates whether call is inbound or outbound.
ParentId	String	False	No	The Id of the parent of this account.
ReminderChecked	Bool	False	No	The checkbox indicating whether or not the reminder value is set.
ReminderTime	String	False	No	When a reminder alert should be issued. -1 means no alert; otherwise, the number of seconds prior to the start.
EmailReminderChecked	Bool	False	No
EmailReminderTime	String	False	No	When a email reminder alert should be issued. -1 means no alert; otherwise, the number of seconds prior to the start.
EmailReminderSent	Bool	False	No	Whether the email reminder is already sent.
Reminders	String	False	No	List of reminders for the call
OutlookId	String	False	No	When the Suite Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item Id.
AcceptStatus	String	False	No
SetAcceptLinks	String	False	No
ContactName	String	False	No
Opportunities	String	True	No	The opportunities associated with the record.
Leads	String	True	No	The leads associated with the record.
Project	String	True	No	The project associated with the record.
Case	String	True	No
Accounts	String	True	No	The accounts associated with the record
Contacts	String	True	No	The contacts associated with the record
AosContracts	String	True	No
Users	String	True	No
Notes	String	True	No	The notes associated with the record.
ContactId	String	False	No	The Id of the contact for the call.
RepeatType	String	False	No	The type of recurrence.
RepeatInterval	String	False	No	The interval of recurrence.
RepeatDow	String	False	No	The days of week in recurrence.
RepeatUntil	String	False	No	Repeat until the specified date.
RepeatCount	String	False	No	Number of recurrences.
RepeatParentId	String	False	No	The Id of the first element of recurring records.
RecurringSource	String	False	No	The recurring source requesting the call
RescheduleHistory	String	False	No
RescheduleCount	String	False	No
CallsReschedule	String	True	No

Return to Top

Campaigns

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the campaign.
Name	String	False	No	The name of the campaign.
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	The description for the campaign.
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No	The user name of the user assigned to the record.
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
TrackerKey	String	False	No
TrackerCount	String	False	No	The number of accesses made to the tracker URL; no longer used as of 4.2. (See CampaignTrackers.)
ReferUrl	String	False	No
TrackerText	String	False	No
StartDate	String	False	No	Starting date of the campaign.
EndDate	String	False	No	Ending date of the campaign.
Status	String	False	No	The status of the record.
Impressions	String	False	No	Expected click throughs manually entered by the campaign manager.
CurrencyId	String	False	No
Budget	String	False	No	Budgeted amount for the campaign.
ExpectedCost	String	False	No	Expected cost of the campaign.
ActualCost	String	False	No	Actual cost of the campaign.
ExpectedRevenue	String	False	No	Expected revenue stemming from the campaign.
CampaignType	String	False	No
Objective	String	False	No	The objective of the campaign.
Content	String	False	No	The campaign description.
Prospectlists	String	True	No
Emailmarketing	String	True	No
Queueitems	String	True	No
LogEntries	String	True	No
TrackedUrls	String	True	No
Frequency	String	False	No	Frequency of the campaign.
Leads	String	True	No	The leads associated with the record.
Opportunities	String	True	No	The opportunities associated with the record.
Contacts	String	True	No	The contacts associated with the record
Accounts	String	True	No	The accounts associated with the record
Survey	String	True	No
SurveyName	String	True	No
SurveyId	String	False	No
SurveyresponsesCampaigns	String	True	No

Return to Top

Cases

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier for the record.
Name	String	False	No
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	The full text of the note.
Deleted	Bool	False	No	Record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The user Id assigned to the record.
AssignedUserName	String	True	No	The name of the user assigned to the record.
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
CaseNumber	String	False	No
Type	String	False	No	The type of case.
Status	String	False	No	The status of the record.
Priority	String	False	No	The priority of the record.
Resolution	String	False	No	The resolution of the case.
WorkLog	String	False	No	Free-form text used to denote activities of interest.
SuggestionBox	String	False	No
AccountName	String	False	No	The name of the associated account.
AccountName1	String	False	No	A second account for the case
AccountId	String	False	No	The Id of the associated account.
State	String	False	No	State the case is left in
CaseAttachmentsDisplay	String	False	No
CaseUpdateForm	String	False	No
ContactCreatedBy	String	True	No
ContactCreatedByName	String	True	No
ContactCreatedById	String	False	No
Tasks	String	True	No	The tasks associated with the record.
Notes	String	True	No	The notes associated with the record.
Meetings	String	True	No	The meetings associated with the record.
Emails	String	True	No	The emails associated with the record
Documents	String	True	No	The documents associated with the record.
Calls	String	True	No	The calls associated with the record
Bugs	String	True	No	The bugs associated with the record.
Contacts	String	True	No	The contacts associated with the record
Accounts	String	True	No	The accounts associated with the record
Project	String	True	No	The project associated with the record.
UpdateText	String	False	No	Text associated with an update on the case.
Internal	Bool	False	No
AopCaseUpdatesThreaded	String	False	No
AopCaseUpdates	String	True	No
AopCaseEvents	String	True	No

Return to Top

Contacts

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier for the record.
Name	String	False	No	The name of the contact.
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	The full text of the note.
Deleted	Bool	False	No	Record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
Salutation	String	False	No	The contact salutation (e.g., Mr. or Ms.).
FirstName	String	False	No	The first name of the contact.
LastName	String	False	No	The last name of the contact.
FullName	String	False	No	The full name of hte contact.
Title	String	False	No	The title of the contact.
Photo	String	False	No	The avatar for the contact.
Department	String	False	No	The department of the contact.
DoNotCall	Bool	False	No	An indicator of whether the contact can be called.
PhoneHome	String	False	No
Email	String	False	No	The email and name of the contact.
PhoneMobile	String	False	No
PhoneWork	String	False	No
PhoneOther	String	False	No
PhoneFax	String	False	No
Email1	String	False	No	Email address.
Email2	String	False	No
InvalidEmail	Bool	False	No	Whether the email address of the account has been marked as invalid.
EmailOptOut	Bool	False	No	Whether the contact has opted out of emails.
LawfulBasis	String	False	No
DateReviewed	String	False	No
LawfulBasisSource	String	False	No
PrimaryAddressStreet	String	False	No	The street address for the alternate address.
PrimaryAddressStreet2	String	False	No	The second line of the alternate address.
PrimaryAddressStreet3	String	False	No	The third line of the alternate address.
PrimaryAddressCity	String	False	No	The city for the primary address.
PrimaryAddressState	String	False	No	The state for the primary address.
PrimaryAddressPostalcode	String	False	No	The postal code for the primary address.
PrimaryAddressCountry	String	False	No	The country for primary address.
AltAddressStreet	String	False	No
AltAddressStreet2	String	False	No
AltAddressStreet3	String	False	No
AltAddressCity	String	False	No
AltAddressState	String	False	No
AltAddressPostalcode	String	False	No
AltAddressCountry	String	False	No
Assistant	String	False	No	The name of the assistant of the contact.
AssistantPhone	String	False	No	The phone number of the assistant of the contact.
EmailAddressesPrimary	String	True	No	Primary email address.
EmailAddresses	String	True	No	Alternate Email address.
EmailAddressesNonPrimary	String	False	No	Non primary email address.
EmailAndName1	String	False	No
LeadSource	String	False	No	The lead source for the contact.
AccountName	String	False	No	The name of the account associated with the contact.
AccountId	String	False	No	The Id of the account associated with the contact.
OpportunityRoleFields	String	True	No	The opportunity role fields.
OpportunityRoleId	String	False	No	The Id of the opportunity role.
OpportunityRole	String	False	No	The opportunity role.
ReportsToId	String	False	No	The Id of the contact this contact reports to.
ReportToName	String	False	No
Birthdate	String	False	No	The birthdate of the contact.
Accounts	String	True	No	The accounts associated with the record
ReportsToLink	String	True	No
Opportunities	String	True	No	The opportunities associated with the record.
Bugs	String	True	No	The bugs associated with the record.
Calls	String	True	No	The calls associated with the record
Cases	String	True	No	The cases associated with the record.
DirectReports	String	True	No
Emails	String	True	No	The emails associated with the record
Documents	String	True	No	The documents associated with the record.
Leads	String	True	No	The leads associated with the record.
Meetings	String	True	No	The meetings associated with the record.
Notes	String	True	No	The notes associated with the record.
Project	String	True	No	The project associated with the record.
ProjectResource	String	True	No
AmProjecttemplatesResources	String	True	No
AmProjecttemplatesContacts1	String	True	No
Tasks	String	True	No	The tasks associated with the record.
TasksParent	String	True	No
NotesParent	String	True	No
UserSync	String	True	No
CampaignId	String	False	No	The Id of the campaign associated with the record.
CampaignName	String	True	No	The name of the campaign associated with the record.
Campaigns	String	True	No	The campaigns associated with the account.
CampaignContacts	String	True	No
CAcceptStatusFields	String	True	No
MAcceptStatusFields	String	True	No
AcceptStatusId	String	False	No	The Id of the accept status.
AcceptStatusName	String	False	No	The name of the accept status.
ProspectLists	String	True	No
SyncContact	Bool	False	No
FpEventsContacts	String	True	No
AosQuotes	String	True	No
AosInvoices	String	True	No
AosContracts	String	True	No
EInviteStatusFields	String	True	No
EventStatusName	String	False	No
EventInviteId	String	False	No
EAcceptStatusFields	String	True	No
EventAcceptStatus	String	False	No
EventStatusId	String	False	No
ProjectContacts1	String	True	No
AopCaseUpdates	String	True	No
JoomlaAccountId	String	False	No	Id of the contact's Joomla account.
PortalAccountDisabled	Bool	False	No
JoomlaAccountAccess	String	False	No
PortalUserType	String	False	No	Type of the contact's portal account.

Return to Top

Contracts

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the contract.
Name	String	False	No
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	Description for the contract
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the contract manager.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
ReferenceCode	String	False	No	Reference code of the contract
StartDate	String	False	No	Date the contract is valid from
EndDate	String	False	No	Date until the contract expires
TotalContractValue	String	False	No
TotalContractValueUsdollar	String	False	No
CurrencyId	String	False	No
Status	String	False	No	The status of the record.
CustomerSignedDate	String	False	No	Date the customer signed the contract
CompanySignedDate	String	False	No	Date the company signed the contract
RenewalReminderDate	Datetime	False	No	Date to remind for the contract renewal
ContractType	String	False	No	Type of the contract
ContractAccountId	String	False	No	Id of the Account linked to the contract
ContractAccount	String	True	No
OpportunityId	String	False	No	Id of the opportunity linked to the contract
Opportunity	String	True	No	Name of the opportunity linked to the contract
ContactId	String	False	No	Id of the contact linked to the account
Contact	String	True	No	Name of the contact linked to the account
CallId	String	False	No	Id of the call linked to the contract
LineItems	String	False	No	Line items of the contract
TotalAmt	String	False	No
TotalAmtUsdollar	String	False	No
SubtotalAmount	String	False	No
SubtotalAmountUsdollar	String	False	No
DiscountAmount	String	False	No
DiscountAmountUsdollar	String	False	No
TaxAmount	String	False	No
TaxAmountUsdollar	String	False	No
ShippingAmount	String	False	No
ShippingAmountUsdollar	String	False	No
ShippingTax	String	False	No	Shipping tax costs
ShippingTaxAmt	String	False	No
ShippingTaxAmtUsdollar	String	False	No
TotalAmount	String	False	No
TotalAmountUsdollar	String	False	No
Accounts	String	True	No	The accounts associated with the record
Contacts	String	True	No	The contacts associated with the record
Tasks	String	True	No	The tasks associated with the record.
Notes	String	True	No	The notes associated with the record.
Meetings	String	True	No	The meetings associated with the record.
Calls	String	True	No	The calls associated with the record
Emails	String	True	No	The emails associated with the record
AosQuotesAosContracts	String	True	No
Documents	String	True	No	The documents associated with the record.
AosProductsQuotes	String	True	No
AosLineItemGroups	String	True	No

Return to Top

Documents

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier for the record.
Name	String	False	No	The name of the document.
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	The full text of the note.
Deleted	Bool	False	No	Record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
DocumentName	String	False	No	The document name.
DocId	String	False	No
DocType	String	False	No
DocUrl	String	False	No
Filename	String	False	No	The file name of the document attachment.
ActiveDate	String	False	No
ExpDate	String	False	No
CategoryId	String	False	No
SubcategoryId	String	False	No
StatusId	String	False	No	The Id of the document status.
Status	String	False	No	The status of the record.
DocumentRevisionId	String	False	No	The Id of the document revision.
Revisions	String	True	No
Revision	String	False	No	The revision number.
LastRevCreatedName	String	False	No
LastRevMimeType	String	False	No
LatestRevision	String	False	No	The latest revision.
LastRevCreateDate	String	False	No
Contracts	String	True	No
Leads	String	True	No	The leads associated with the record.
Accounts	String	True	No	The accounts associated with the record
Contacts	String	True	No	The contacts associated with the record
Opportunities	String	True	No	The opportunities associated with the record.
Cases	String	True	No	The cases associated with the record.
Bugs	String	True	No	The bugs associated with the record.
RelatedDocId	String	False	No
RelatedDocName	String	True	No
RelatedDocRevId	String	False	No
RelatedDocRevNumber	String	False	No
IsTemplate	Bool	False	No
TemplateType	String	False	No
LatestRevisionName	String	False	No
SelectedRevisionName	String	False	No	The name of the selected revision.
ContractStatus	String	False	No	The document's contract status.
ContractName	String	False	No	The name of the document's contract
LinkedId	String	False	No	The Id of the linked record.
SelectedRevisionId	String	False	No	The Id of the selected revision.
LatestRevisionId	String	False	No	The Id of the latest revision.
SelectedRevisionFilename	String	False	No	The filename of the selected revision.
AosContracts	String	True	No

Return to Top

Emails

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the email.
Name	String	False	No	The subject of the email.
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	The description for the email.
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
Orphaned	Bool	False	No
LastSynced	Datetime	False	No
FromAddrName	String	False	No	The from address in the email.
ReplyToAddr	String	False	No	The reply-to address in the email.
ToAddrsNames	String	False	No	The to addresses in the email.
CcAddrsNames	String	False	No	The cc addresses in the email.
BccAddrsNames	String	False	No	The bcc addresses in the email.
ImapKeywords	String	False	No
RawSource	String	False	No	The raw source for the email.
DescriptionHtml	String	False	No	The HTML description for the email.
DateSentReceived	Datetime	False	No
MessageId	String	False	No	The Id of the email item obtained from the email transport system.
Type	String	False	No	The type of the email (e.g., draft).
Status	String	False	No	The status of the record.
Flagged	Bool	False	No	The flagged status of the email.
ReplyToStatus	Bool	False	No	The reply-to status of the email. If you reply to an email then the reply-to status of original email is set.
Intent	String	False	No	The target of the action used in the Inbound Email assignment.
MailboxId	String	False	No
ParentName	String	True	No	The name of the parent of this account.
ParentType	String	False	No	The type of the Sugar module associated with the email. (Deprecated as of 4.2.)
ParentId	String	False	No	The Id of the parent of this account.
Indicator	String	False	No
Subject	String	False	No
Attachment	String	False	No
Uid	String	False	No
Msgno	String	False	No
Folder	String	False	No
FolderType	String	False	No
InboundEmailRecord	String	False	No
IsImported	String	False	No
HasAttachment	String	False	No
IsOnlyPlainText	Bool	False	No
Accounts	String	True	No	The accounts associated with the record
Bugs	String	True	No	The bugs associated with the record.
Cases	String	True	No	The cases associated with the record.
Contacts	String	True	No	The contacts associated with the record
Leads	String	True	No	The leads associated with the record.
Opportunities	String	True	No	The opportunities associated with the record.
Project	String	True	No	The project associated with the record.
Projecttask	String	True	No
Prospects	String	True	No
AosContracts	String	True	No
Tasks	String	True	No	The tasks associated with the record.
Users	String	True	No
Notes	String	True	No	The notes associated with the record.
Meetings	String	True	No	The meetings associated with the record.
CategoryId	String	False	No
EmailsEmailTemplates	String	True	No
EmailsEmailTemplatesName	String	True	No
EmailsEmailTemplatesIdb	String	True	No
OptIn	String	False	No

Return to Top

EmailTemplates

Name	Type	ReadOnly	FilterOnly	Description
SecurityGroups	String	True	No	The security group associated with the record.
Id [KEY]	String	False	No	The unique identifier of the email template.
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
Published	String	False	No	The published status of the record.
Name	String	False	No	The name of the email template.
Description	String	False	No	The description for the email template.
Subject	String	False	No	The subject of the resulting email.
Body	String	False	No	Plaintext body of the resulting email.
BodyHtml	String	False	No
Deleted	Bool	False	No	The record deletion indicator.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No	The user name of the user assigned to the record.
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
TextOnly	Bool	False	No	Whether the email template is to be sent in text only.
Type	String	False	No	The type of the email template.

Return to Top

Events

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the event.
Name	String	False	No	Name given to the event
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	Description given for the event
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
DurationHours	String	False	No	Number of hours the event lasts
DurationMinutes	String	False	No	Number of minutes the event lasts
DateStart	Datetime	False	No
DateEnd	Datetime	False	No
Link	String	False	No
LinkDeclined	String	False	No
Budget	String	False	No	Budget set for the event
CurrencyId	String	False	No
Duration	String	False	No	Complete duration of the event
InviteTemplates	String	False	No
AcceptRedirect	String	False	No
DeclineRedirect	String	False	No
FpEventsContacts	String	True	No
FpEventsProspects1	String	True	No
FpEventsLeads1	String	True	No
FpEventLocationsFpEvents1	String	True	No
FpEventLocationsFpEvents1Name	String	True	No
FpEventLocationsFpEvents1fpEventLocationsIda	String	True	No
ActivityStatusType	String	False	No

Return to Top

Invoices

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the invoice.
Name	String	False	No
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	Description provided for the
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
BillingAccountId	String	False	No	Id of the billing account
BillingAccount	String	True	No
BillingContactId	String	False	No	Id of the billing contact
BillingContact	String	True	No
BillingAddressStreet	String	False	No	The first line of the billing address.
BillingAddressCity	String	False	No	The city used for the billing address.
BillingAddressState	String	False	No	The state used for the billing address.
BillingAddressPostalcode	String	False	No	The postal code used for the billing address.
BillingAddressCountry	String	False	No	The country used for the billing address.
ShippingAddressStreet	String	False	No	The first line of the shipping address.
ShippingAddressCity	String	False	No	The city used for the shipping address.
ShippingAddressState	String	False	No	The state used for the shipping address.
ShippingAddressPostalcode	String	False	No	The ZIP code used for the shipping address.
ShippingAddressCountry	String	False	No	The country used for the shipping address.
Number	String	False	No
LineItems	String	False	No	The invoice's list of line items
TotalAmt	String	False	No
TotalAmtUsdollar	String	False	No
SubtotalAmount	String	False	No
SubtotalAmountUsdollar	String	False	No
DiscountAmount	String	False	No
DiscountAmountUsdollar	String	False	No
TaxAmount	String	False	No
TaxAmountUsdollar	String	False	No
ShippingAmount	String	False	No
ShippingAmountUsdollar	String	False	No
ShippingTax	String	False	No	Shipping tax costs
ShippingTaxAmt	String	False	No
ShippingTaxAmtUsdollar	String	False	No
TotalAmount	String	False	No
TotalAmountUsdollar	String	False	No
CurrencyId	String	False	No
QuoteNumber	String	False	No	Number of the invoice quote
QuoteDate	String	False	No	Date of the invoice quote
InvoiceDate	String	False	No	Date the invoice was issued
DueDate	String	False	No	Due date of the invoice
Status	String	False	No	The status of the record.
TemplateDdownC	String	False	No
SubtotalTaxAmount	String	False	No	Subtotal and tax amount in the invoice in the system's default currency
SubtotalTaxAmountUsdollar	String	False	No
Accounts	String	True	No	The accounts associated with the record
Contacts	String	True	No	The contacts associated with the record
AosQuotesAosInvoices	String	True	No
AosProductsQuotes	String	True	No
AosLineItemGroups	String	True	No

Return to Top

KBCategories

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No
Name	String	False	No
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No
Deleted	Bool	False	No
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
AokKnowledgebaseCategories	String	True	No

Return to Top

KnowledgeBase

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No
Name	String	False	No
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No
Deleted	Bool	False	No
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
Status	String	False	No	The status of the record.
Revision	String	False	No
AdditionalInfo	String	False	No
UserIdC	String	False	No
Author	String	True	No
UserId1C	String	False	No
Approver	String	True	No
AokKnowledgebaseCategories	String	True	No

Return to Top

Leads

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the record.
Name	String	False	No	The name of the lead.
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	Date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	Full text of the note.
Deleted	Bool	False	No	Record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
Salutation	String	False	No	The lead salutation (e.g., Mr. or Ms.).
FirstName	String	False	No	The first name of the lead.
LastName	String	False	No	The last name of the lead.
FullName	String	False	No	The full name of the lead.
Title	String	False	No	The title of the lead.
Photo	String	False	No	The picture for the lead.
Department	String	False	No	The department of the lead.
DoNotCall	Bool	False	No	An indicator of whether the lead can be called.
PhoneHome	String	False	No
Email	String	False	No
PhoneMobile	String	False	No
PhoneWork	String	False	No
PhoneOther	String	False	No
PhoneFax	String	False	No
Email1	String	False	No	Email address.
Email2	String	False	No
InvalidEmail	Bool	False	No	Whether the email address of the account has been marked as invalid.
EmailOptOut	Bool	False	No	Whether the lead has opted out of radio.
LawfulBasis	String	False	No
DateReviewed	String	False	No
LawfulBasisSource	String	False	No
PrimaryAddressStreet	String	False	No	The street address used for the primary address.
PrimaryAddressStreet2	String	False	No	The second line of the primary address.
PrimaryAddressStreet3	String	False	No	The third line of the primary addrss.
PrimaryAddressCity	String	False	No	The city for the primary address.
PrimaryAddressState	String	False	No	The state for the primary address.
PrimaryAddressPostalcode	String	False	No	The postal code for the primary address.
PrimaryAddressCountry	String	False	No	The country for the primary address.
AltAddressStreet	String	False	No	The street address for the alternate address.
AltAddressStreet2	String	False	No	The second line of the alternate address.
AltAddressStreet3	String	False	No	The third line of the alternate address.
AltAddressCity	String	False	No	The city for the alternate address.
AltAddressState	String	False	No	The state for the alternate address.
AltAddressPostalcode	String	False	No	The postal code for the alternate address.
AltAddressCountry	String	False	No	The country for the alternate address.
Assistant	String	False	No	The name of the assistant of the lead.
AssistantPhone	String	False	No	The phone number of the assistant of the lead.
EmailAddressesPrimary	String	True	No	Primary email address.
EmailAddresses	String	True	No	Alternate Email address.
EmailAddressesNonPrimary	String	False	No	Non primary email address.
Converted	Bool	False	No	Whether the lead has been converted.
ReferedBy	String	False	No
LeadSource	String	False	No	How the lead came to be known.
LeadSourceDescription	String	False	No	Description of the lead source.
Status	String	False	No	The status of the record.
StatusDescription	String	False	No	A description for the status
ReportsToId	String	False	No	The name the updates for the lead will be reported to
ReportToName	String	False	No
ReportsToLink	String	True	No
Reportees	String	True	No
Contacts	String	True	No	The contacts associated with the record
AccountName	String	False	No	The name of the associated acocunt.
Accounts	String	True	No	The accounts associated with the record
AccountDescription	String	False	No	Description for the lead's account
ContactId	String	False	No	Main contact for the lead
Contact	String	True	No
AccountId	String	False	No	Account the lead is linked to
OpportunityId	String	False	No	The Opportunity the lead was generated from
Opportunity	String	True	No
OpportunityName	String	False	No	The name of the opportunity the lead was generated from
OpportunityAmount	String	False	No	The amount the opportunity yields
CampaignId	String	False	No	The Id of the campaign associated with the record.
CampaignName	String	True	No	The name of the campaign associated with the record.
CampaignLeads	String	True	No
CAcceptStatusFields	String	True	No
MAcceptStatusFields	String	True	No
AcceptStatusId	String	False	No	The Id of the accept status.
AcceptStatusName	String	False	No	The name of the accept status.
WebtoleadEmail1	String	False	No
WebtoleadEmail2	String	False	No
WebtoleadEmailOptOut	Bool	False	No
WebtoleadInvalidEmail	Bool	False	No
Birthdate	String	False	No	The birthdate of the lead.
PortalName	String	False	No	The Joomla portal name of the lead
PortalApp	String	False	No
Website	String	False	No	The lead's website
Tasks	String	True	No	The tasks associated with the record.
Notes	String	True	No	The notes associated with the record.
Meetings	String	True	No	The meetings associated with the record.
Calls	String	True	No	The calls associated with the record
Oldmeetings	String	True	No
Oldcalls	String	True	No
Emails	String	True	No	The emails associated with the record
Campaigns	String	True	No	The campaigns associated with the account.
ProspectLists	String	True	No
FpEventsLeads1	String	True	No
EInviteStatusFields	String	True	No
EventStatusName	String	False	No
EventInviteId	String	False	No
EAcceptStatusFields	String	True	No
EventAcceptStatus	String	False	No
EventStatusId	String	False	No	Id of the lead's event status.

Return to Top

Locations

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the location.
Name	String	False	No	Name assigned to the location
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	Description for the location
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
FpEventLocationsFpEvents1	String	True	No
Address	String	False	No	Street address of the location
AddressCity	String	False	No
AddressCountry	String	False	No
AddressPostalcode	String	False	No
AddressState	String	False	No
Capacity	String	False	No	Capacity estimated for the location

Return to Top

Maps

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the map.
Name	String	False	No	Name assigned to the map
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	Description for the map
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
Distance	Double	False	No
UnitType	String	False	No	Length unit expressing the radius
ModuleType	String	False	No
ParentName	String	True	No	The name of the parent of this account.
ParentType	String	False	No	Type of the map's parent
ParentId	String	False	No	The Id of the parent of this account.
Accounts	String	True	No	The accounts associated with the record
Contacts	String	True	No	The contacts associated with the record
Leads	String	True	No	The leads associated with the record.
Opportunities	String	True	No	The opportunities associated with the record.
Cases	String	True	No	The cases associated with the record.
Projects	String	True	No
Meetings	String	True	No	The meetings associated with the record.
Prospects	String	True	No

Return to Top

MapsAddressCache

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the address cache.
Name	String	False	No
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	Description for the cached address
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
Lat	Double	False	No
Lng	Double	False	No

Return to Top

MapsAreas

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the map area.
Name	String	False	No	Name assigned to the line items group
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	Description for the map area
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
City	String	False	No	City of the map area
State	String	False	No	State of the location
Country	String	False	No	Country of the map area
Coordinates	String	False	No	Geographical coordinates of the map area
JjwgMapsJjwgAreas	String	True	No

Return to Top

MapsMarkers

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the map marker.
Name	String	False	No	Name assigned to the map marker
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	Description for the map marker
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
City	String	False	No	City of the map marker
State	String	False	No	State of the map marker
Country	String	False	No	Country of the map marker
JjwgMapsLat	Double	False	No
JjwgMapsLng	Double	False	No
MarkerImage	String	False	No
JjwgMapsJjwgMarkers	String	True	No

Return to Top

Meetings

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier for the meeting.
Name	String	False	No
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	Full text of the note.
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
AcceptStatus	String	False	No
SetAcceptLinks	String	False	No
Location	String	False	No	The location of the meeting.
Password	String	False	No
JoinUrl	String	False	No
HostUrl	String	False	No	The host URL.
DisplayedUrl	String	False	No
Creator	String	False	No
ExternalId	String	False	No
DurationHours	String	False	No	The duration (hours).
DurationMinutes	String	False	No	The duration (minutes).
DateStart	Datetime	False	No
DateEnd	Datetime	False	No
ParentType	String	False	No	Module the meeting is associated with.
Status	String	False	No	The status of the record.
Type	String	False	No	Meeting type (e.g., WebEx, or Other).
Direction	String	False	No	Whether the meeting is inbound or outbound.
ParentId	String	False	No	The Id of the parent of this account.
ReminderChecked	Bool	False	No	Whether or not the reminder value is set.
ReminderTime	String	False	No	Specifies when a reminder alert should be issued: -1 means no alert; otherwise the number of seconds prior to the start.
EmailReminderChecked	Bool	False	No
EmailReminderTime	String	False	No	Specifies when a email reminder alert should be issued: -1 means no alert; otherwise the number of seconds prior to the start.
EmailReminderSent	Bool	False	No	Whether the email reminder is already sent.
Reminders	String	False	No	List of reminders set for the meetings
OutlookId	String	False	No	When the Sugar Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item Id.
Sequence	String	False	No
ContactName	String	False	No
Contacts	String	True	No	The contacts associated with the record
ParentName	String	True	No	The name of the parent of this account.
Users	String	True	No
Accounts	String	True	No	The accounts associated with the record
Leads	String	True	No	The leads associated with the record.
Opportunity	String	True	No
Case	String	True	No
AosContracts	String	True	No
Notes	String	True	No	The notes associated with the record.
ContactId	String	False	No	The Id of the associated contact.
RepeatType	String	False	No	Type of a recurring meeting.
RepeatInterval	String	False	No	The interval of a recurring meeting.
RepeatDow	String	False	No	The day of week of a meeting.
RepeatUntil	String	False	No	Repeat until the specified date.
RepeatCount	String	False	No	Number of recurrences.
RepeatParentId	String	False	No	Id of the first element of recurring records.
RecurringSource	String	False	No	Source of recurring meeting.
Duration	String	False	No	Duration handler dropdown.
GsyncId	String	False	No
GsyncLastsync	String	False	No
JjwgMapsLatC	Double	False	No
JjwgMapsLngC	Double	False	No
JjwgMapsGeocodeStatusC	String	False	No
JjwgMapsAddressC	String	False	No

Return to Top

Notes

Name	Type	ReadOnly	FilterOnly	Description
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
Id [KEY]	String	False	No	Unique identifier of the record.
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Name	String	False	No
FileMimeType	String	False	No
FileUrl	String	False	No
Filename	String	False	No
ParentType	String	False	No	Sugar module the Note is associated with.
ParentId	String	False	No	The Id of the parent of this account.
ContactId	String	False	No	The Id of the contact the note is associated with.
PortalFlag	Bool	False	No
EmbedFlag	Bool	False	No
Description	String	False	No
Deleted	Bool	False	No	The record deletion indicator.
ParentName	String	True	No	The name of the parent of this account.
ContactName	String	True	No
ContactPhone	String	False	No
ContactEmail	String	False	No
AccountId	String	False	No	The Id of the account associated with the note.
OpportunityId	String	False	No	The Id of the opportunity associated with the note.
AcaseId	String	False	No
LeadId	String	False	No	The Id of the lead associated with the note.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
Contact	String	True	No	The name of the contact associated with the note.
Cases	String	True	No	The cases associated with the record.
Accounts	String	True	No	The accounts associated with the record
Opportunities	String	True	No	The opportunities associated with the record.
Leads	String	True	No	The leads associated with the record.
Bugs	String	True	No	The bugs associated with the record.
AosContracts	String	True	No
Emails	String	True	No	The emails associated with the record
Projects	String	True	No
ProjectTasks	String	True	No
Meetings	String	True	No	The meetings associated with the record.
Calls	String	True	No	The calls associated with the record
Tasks	String	True	No	The tasks associated with the record.

Return to Top

Opportunities

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the opportunity.
Name	String	False	No
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	Full text of the note.
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
OpportunityType	String	False	No
AccountName	String	False	No	The name of the associated account.
AccountId	String	False	No	The Id of the associated account.
CampaignId	String	False	No	The Id of the campaign associated with the record.
CampaignName	String	True	No	The name of the campaign associated with the record.
CampaignOpportunities	String	True	No
LeadSource	String	False	No	Source of the opportunity.
Amount	String	False	No	Formatted amount of the opportunity.
AmountUsdollar	String	False	No
CurrencyId	String	False	No
CurrencyName	String	True	No	The name of the currency used for display purposes.
CurrencySymbol	String	True	No	The symbol of the currency used for display purposes.
DateClosed	String	False	No
NextStep	String	False	No	The next step in the sales process.
SalesStage	String	False	No	Indication of progression towards closure.
Probability	String	False	No
Accounts	String	True	No	The accounts associated with the record
Contacts	String	True	No	The contacts associated with the record
Tasks	String	True	No	The tasks associated with the record.
Notes	String	True	No	The notes associated with the record.
Meetings	String	True	No	The meetings associated with the record.
Calls	String	True	No	The calls associated with the record
Emails	String	True	No	The emails associated with the record
Documents	String	True	No	The documents associated with the record.
Project	String	True	No	The project associated with the record.
Leads	String	True	No	The leads associated with the record.
Campaigns	String	True	No	The campaigns associated with the account.
CampaignLink	String	True	No
Currencies	String	True	No
AosQuotes	String	True	No
AosContracts	String	True	No
JjwgMapsLatC	Double	False	No
JjwgMapsLngC	Double	False	No
JjwgMapsGeocodeStatusC	String	False	No
JjwgMapsAddressC	String	False	No

Return to Top

PDFTemplates

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier for the pdf template.
Name	String	False	No	The template's name.
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	Date when the template was modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No
Deleted	Bool	False	No	Whether the template was deleted.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The unique identifier of the assignee.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
Active	Bool	False	No	Whether or not the template is active.
Type	String	False	No	The type of the template.
Sample	String	False	No
InsertFields	String	False	No	The fields that can be inserted.
Pdfheader	String	False	No
Pdffooter	String	False	No
MarginLeft	String	False	No	Value of the left margin for the template.
MarginRight	String	False	No	Value of the right margin for the template.
MarginTop	String	False	No	Value of the top margin for the template.
MarginBottom	String	False	No	Value of the bottom margin for the template.
MarginHeader	String	False	No	Value of the margin for the template's header.
MarginFooter	String	False	No	Value of the margin for the template's footer.
PageSize	String	False	No	The size of the template.
Orientation	String	False	No	Orientation of the template.

Return to Top

Products

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the ACL Action.
Name	String	False	No
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	The action description.
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
AosProductsPurchases	String	True	No
Maincode	String	False	No
PartNumber	String	False	No	Part number of the product.
Category	String	False	No	Name of the product's category.
Type	String	False	No	Type of the product.
Cost	String	False	No	Cost of the product.
CostUsdollar	String	False	No
CurrencyId	String	False	No
Price	String	False	No	Price of the product.
PriceUsdollar	String	False	No
Url	String	False	No	Url where the product can be seen.
ContactId	String	False	No	Product's point of contact id.
Contact	String	True	No	Product's point of contact name.
ProductImage	String	False	No	Image uploaded for the product.
FileUrl	String	False	No
AosProductCategory	String	True	No
AosProductCategoryName	String	True	No
AosProductCategoryId	String	False	No

Return to Top

ProductsCategories

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the inbound.
Name	String	False	No	Name assigned to the category
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	Description for the category
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
IsParent	Bool	False	No
AosProducts	String	True	No
SubCategories	String	True	No
ParentCategory	String	True	No	Name of the parent category
ParentCategoryName	String	True	No
ParentCategoryId	String	False	No	Id of the category's parent category

Return to Top

Projects

Name	Type	ReadOnly	FilterOnly	Description
SecurityGroups	String	True	No	The security group associated with the record.
Id [KEY]	String	False	No	The unique identifier of the project.
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
AssignedUserId	String	False	No
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Name	String	False	No	Project name.
Description	String	False	No	Project description.
Deleted	Bool	False	No	The record deletion indicator.
EstimatedStartDate	String	False	No
EstimatedEndDate	String	False	No
Status	String	False	No	The status of the record.
Priority	String	False	No	The priority of the record.
TotalEstimatedEffort	String	False	No
TotalActualEffort	String	False	No
Accounts	String	True	No	The accounts associated with the record
Quotes	String	True	No
Contacts	String	True	No	The contacts associated with the record
Opportunities	String	True	No	The opportunities associated with the record.
Notes	String	True	No	The notes associated with the record.
Tasks	String	True	No	The tasks associated with the record.
Meetings	String	True	No	The meetings associated with the record.
Calls	String	True	No	The calls associated with the record
Emails	String	True	No	The emails associated with the record
Projecttask	String	True	No
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
AssignedUserName	String	False	No
Cases	String	True	No	The cases associated with the record.
Bugs	String	True	No	The bugs associated with the record.
Products	String	True	No
ProjectUsers1	String	True	No
AmProjecttemplatesProject1	String	True	No
AmProjecttemplatesProject1Name	String	True	No
AmProjecttemplatesProject1amProjecttemplatesIda	String	True	No
ProjectContacts1	String	True	No
AosQuotesProject	String	True	No
OverrideBusinessHours	Bool	False	No
JjwgMapsLatC	Double	False	No
JjwgMapsLngC	Double	False	No
JjwgMapsGeocodeStatusC	String	False	No
JjwgMapsAddressC	String	False	No

Return to Top

ProjectsTemplates

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the project template.
Name	String	False	No
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user the template has been assigned to.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
Status	String	False	No	The status of the record.
Priority	String	False	No	The priority of the record.
AmProjecttemplatesProject1	String	True	No
AmTasktemplatesAmProjecttemplates	String	True	No
AmProjecttemplatesUsers1	String	True	No
AmProjecttemplatesContacts1	String	True	No
OverrideBusinessHours	Bool	False	No

Return to Top

Quotes

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	null
Name	String	False	No
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	Description for the quote
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	null
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
ApprovalIssue	String	False	No
BillingAccountId	String	False	No	Id of the billing account
BillingAccount	String	True	No
BillingContactId	String	False	No	Id of the billing contact
BillingContact	String	True	No
BillingAddressStreet	String	False	No	The first line of the billing address.
BillingAddressCity	String	False	No	The city used for the billing address.
BillingAddressState	String	False	No	The state used for the billing address.
BillingAddressPostalcode	String	False	No	The postal code used for the billing address.
BillingAddressCountry	String	False	No	The country used for the billing address.
ShippingAddressStreet	String	False	No	The first line of the shipping address.
ShippingAddressCity	String	False	No	The city used for the shipping address.
ShippingAddressState	String	False	No	The state used for the shipping address.
ShippingAddressPostalcode	String	False	No	The ZIP code used for the shipping address.
ShippingAddressCountry	String	False	No	The country used for the shipping address.
Expiration	String	False	No
Number	String	False	No
OpportunityId	String	False	No	Opportunity Id of the quote
Opportunity	String	True	No	Opportunity name of the quote
TemplateDdownC	String	False	No
LineItems	String	False	No	The list of the quote's line items
TotalAmt	String	False	No
TotalAmtUsdollar	String	False	No
SubtotalAmount	String	False	No
SubtotalAmountUsdollar	String	False	No
DiscountAmount	String	False	No
DiscountAmountUsdollar	String	False	No
TaxAmount	String	False	No
TaxAmountUsdollar	String	False	No
ShippingAmount	String	False	No
ShippingAmountUsdollar	String	False	No
ShippingTax	String	False	No	The quote's shipping tax costs
ShippingTaxAmt	String	False	No
ShippingTaxAmtUsdollar	String	False	No
TotalAmount	String	False	No
TotalAmountUsdollar	String	False	No
CurrencyId	String	False	No
Stage	String	False	No
Term	String	False	No
TermsC	String	False	No
ApprovalStatus	String	False	No	null
InvoiceStatus	String	False	No	Quote's invoice status
SubtotalTaxAmount	String	False	No	The quotes's subtotal and tax amount in the system's default currency
SubtotalTaxAmountUsdollar	String	False	No
Accounts	String	True	No	The accounts associated with the record
Contacts	String	True	No	The contacts associated with the record
Opportunities	String	True	No	The opportunities associated with the record.
AosQuotesProject	String	True	No
AosQuotesAosInvoices	String	True	No
AosQuotesAosContracts	String	True	No
AosProductsQuotes	String	True	No
AosLineItemGroups	String	True	No

Return to Top

Reports

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the report.
Name	String	False	No	Name assigned to the report
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	Description for the report
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
ReportModule	String	False	No	The module the report has targeted
GraphsPerRow	String	False	No
FieldLines	String	False	No
ConditionLines	String	False	No
AorFields	String	True	No
AorConditions	String	True	No
AorCharts	String	True	No
AorScheduledReports	String	True	No

Return to Top

Spots

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the record.
Name	String	False	No	The name of the spot.
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	Full text of the note.
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
Config	String	False	No	The the configuration set of the spot.
Type	String	False	No	The field this spot is targeting.
ConfigurationGUI	String	False	No

Return to Top

Surveys

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No
Name	String	False	No
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No
Deleted	Bool	False	No
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
Status	String	False	No	The status of the record.
SurveyQuestionsDisplay	String	False	No
SurveyUrlDisplay	String	False	No
SubmitText	String	False	No
SatisfiedText	String	False	No
NeitherText	String	False	No
DissatisfiedText	String	False	No
SurveysSurveyquestions	String	True	No
SurveysSurveyresponses	String	True	No

Return to Top

Tasks

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the record.
Name	String	False	No
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	The full text of the note.
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
Status	String	False	No	The status of the record.
DateDueFlag	Bool	False	No
DateDue	Datetime	False	No
TimeDue	Datetime	False	No
DateStartFlag	Bool	False	No
DateStart	Datetime	False	No
ParentType	String	False	No	The type of the Sugar item to which the call is related.
ParentName	String	True	No	The name of the parent of this account.
ParentId	String	False	No	The Id of the parent of this account.
ContactId	String	False	No	The Id of the associated contact.
ContactName	String	True	No	The name of the associated contact.
ContactPhone	String	False	No	The phone of the associated contact.
ContactEmail	String	False	No
Priority	String	False	No	The priority of the record.
Contacts	String	True	No	The contacts associated with the record
Accounts	String	True	No	The accounts associated with the record
Opportunities	String	True	No	The opportunities associated with the record.
Cases	String	True	No	The cases associated with the record.
Bugs	String	True	No	The bugs associated with the record.
Leads	String	True	No	The leads associated with the record.
Projects	String	True	No
ProjectTasks	String	True	No
AosContracts	String	True	No
Notes	String	True	No	The notes associated with the record.
ContactParent	String	True	No

Return to Top

WorkFlow

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier of the inbound.
Name	String	False	No	Name assigned to the workflow
DateEntered	Datetime	False	No	The date the record was created.
DateModified	Datetime	False	No	The date the record was last modified.
ModifiedUserId	String	False	No	The Id of the user who last modified the record.
ModifiedByName	String	True	No	The name of the user who last modified the record.
CreatedBy	String	False	No	The Id of the user who created the record.
CreatedByName	String	True	No	The name of the user who created the record.
Description	String	False	No	Description for the worflow
Deleted	Bool	False	No	The record deletion indicator.
CreatedByLink	String	True	No	Link to the record who created it
ModifiedUserLink	String	True	No	Link to the record who modified it.
AssignedUserId	String	False	No	The Id of the user assigned to the record.
AssignedUserName	String	True	No
AssignedUserLink	String	True	No	Link to the user which the record has been assigned to
SecurityGroups	String	True	No	The security group associated with the record.
FlowModule	String	False	No
FlowRunOn	String	False	No
Status	String	False	No	The status of the record.
RunWhen	String	False	No
MultipleRuns	Bool	False	No
ConditionLines	String	False	No
ActionLines	String	False	No
AowConditions	String	True	No
AowActions	String	True	No
AowProcessed	String	True	No

Return to Top