CaseEntries
List notes, emails and completed tasks for cases.
Columns
| Name | Type | References | |
| CaseId | Integer |
Cases.Id | |
| Id [KEY] | Integer | ||
| Type | String | ||
| ActivityTypeIconDisplayName | String | ||
| ActivityTypeIconIconName | String | ||
| ActivityTypeIconId | String | ||
| ActivityTypeIconIsSystem | Boolean | ||
| ActivityTypeIconOrder | Integer | ||
| ActivityTypeId | Integer | ||
| ActivityTypeName | String | ||
| ActivityTypeUpdateLastContacted | Boolean | ||
| Attachments | String | ||
| Content | String | ||
| CreatedAt | Datetime | ||
| UpdatedAt | Datetime | ||
| CreatorClickToCallPreference | String | ||
| CreatorCurrency | String | ||
| CreatorEmailPreference | String | ||
| CreatorId | Integer | ||
| CreatorLastLoginAt | Datetime | ||
| CreatorLocale | String | ||
| CreatorLoggedIn | Boolean | ||
| CreatorName | String | ||
| CreatorPartyFirstName | String | ||
| CreatorPartyId | Integer | ||
| CreatorPartyLastName | String | ||
| CreatorPartyPictureURL | String | ||
| CreatorPartyType | String | ||
| CreatorPictureURL | String | ||
| CreatorPreferredEmailFromAddress | String | ||
| CreatorStatus | String | ||
| CreatorTaskReminder | Boolean | ||
| CreatorTimezone | String | ||
| CreatorUsername | String | ||
| EntryAt | Datetime | ||
| Kase | String | ||
| Opportunity | String | ||
| OpportunityClosedOn | Datetime | ||
| OpportunityCreatedAt | Datetime | ||
| OpportunityDescription | String | ||
| OpportunityDuration | String | ||
| OpportunityDurationBasis | String | ||
| OpportunityExpectedCloseOn | Datetime | ||
| OpportunityId | Integer | ||
| OpportunityLastContactedAt | Datetime | ||
| OpportunityLastOpenMilestoneId | Integer | ||
| OpportunityLastOpenMilestoneName | String | ||
| OpportunityLastStageChangedAt | Datetime | ||
| OpportunityLostReason | String | ||
| OpportunityMilestoneId | Integer | ||
| OpportunityMilestoneName | String | ||
| OpportunityName | String | ||
| OpportunityOwnerId | Integer | ||
| OpportunityOwnerName | String | ||
| OpportunityOwnerPictureURL | String | ||
| OpportunityOwnerUsername | String | ||
| OpportunityPartyId | Integer | ||
| OpportunityPartyName | String | ||
| OpportunityPartyPictureURL | String | ||
| OpportunityPartyType | String | ||
| OpportunityProbability | Integer | ||
| OpportunityTeam | String | ||
| OpportunityUpdatedAt | Datetime | ||
| OpportunityValueAmount | Double | ||
| OpportunityValueCurrency | String | ||
| Party | String | ||
| PartyAbout | String | ||
| PartyAddresses | String | ||
| PartyCreatedAt | Datetime | ||
| PartyEmailAddresses | String | ||
| PartyFirstName | String | ||
| PartyJobTitle | String | ||
| PartyLastContactedAt | Datetime | ||
| PartyLastName | String | ||
| PartyOrganisation | String | ||
| PartyOwnerId | Integer | ||
| PartyOwnerName | String | ||
| PartyOwnerPictureURL | String | ||
| PartyOwnerUsername | String | ||
| PartyPhoneNumbers | String | ||
| PartyPictureURL | String | ||
| PartyTeam | String | ||
| PartyTitle | String | ||
| PartyType | String | ||
| PartyUpdatedAt | Datetime | ||
| PartyWebsites | String |