CompanyDeals
Retrieve all deals of a company.
Columns
| Name | Type | References | |
| Id [KEY] | Integer | ||
| Name | String | ||
| CompanyId | Integer |
Companies.Id | |
| CompanyName | String | ||
| Status | Integer | ||
| Summary | String | ||
| Value | Double | ||
| ValueInCents | Double | ||
| ClosedTime | Datetime | ||
| Collaborators | String | ||
| CreatedAt | Datetime | ||
| UpdatedAt | Datetime | ||
| UpdatedByUser | String | ||
| UpdatedByUserId | String | ||
| CreatedByUser | String | ||
| CreatedByUserId | String | ||
| CurrencyCode | String | ||
| CurrencyName | String | ||
| CurrencySymbol | String | ||
| CustomFields | String | ||
| DateOfFirstActivity | String | ||
| DaysInStage | Integer | ||
| DaysSinceLastActivity | String | ||
| DealCopy | String | ||
| DealLossReasonId | Integer | ||
| DealLossReasonName | String | ||
| DealLossReasonId | Integer | ||
| DealLossReasonNotes | String | ||
| DealPipelineDefault | Boolean | ||
| DealPipelineId | Integer | ||
| DealPipelineName | String | ||
| DealPipelineId | Integer | ||
| DealProductLinesIds | String | ||
| DealStageId | Integer | ||
| DealStageName | String | ||
| DealStagePercent | Integer | ||
| DealStageId | Integer | ||
| DealWonReason | String | ||
| DealWonReasonId | String | ||
| DealWonReasonNotes | String | ||
| ExpectedCloseDate | String | ||
| ExpectedCloseDateEventId | String | ||
| HoursToFirstActivity | String | ||
| ImportId | String | ||
| IsArchived | Boolean | ||
| IsExample | String | ||
| IsSample | Boolean | ||
| People | String | ||
| PersonIds | String | ||
| PrimaryContactEmail | String | ||
| PrimaryContactEmail2 | String | ||
| PrimaryContactFirstName | String | ||
| PrimaryContactHomeEmail | String | ||
| PrimaryContactHomePhone | String | ||
| PrimaryContactId | Integer | ||
| PrimaryContactLastName | String | ||
| PrimaryContactMobile | String | ||
| PrimaryContactPhone | String | ||
| PrimaryContactId | Integer | ||
| Probability | Integer | ||
| RevenueType | String | ||
| RevenueTypeId | String | ||
| SharedUserIds | String | ||
| SourceId | Integer | ||
| SourceName | String | ||
| SourceId | Integer | ||
| UserFirstName | String | ||
| UserId | Integer | ||
| UserLastName | String | ||
| UserId | Integer |