Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | ModifiedOn (ModifiedOn) | DateTime | ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read
|
|
2 | ActualStart (ActualStart) | Date | ExternalName: actualstart ExternalType: DateTime
|
|
3 | CreatedBy (CreatedBy) | GUID | ExternalName: createdby ExternalType: Lookup ExternalAccess: Read
|
|
4 | ActualDurationMinutes (ActualDurationMinutes) | Integer | ExternalName: actualdurationminutes ExternalType: Integer
|
|
5 | IsWorkflowCreated (IsWorkflowCreated) | Boolean | ExternalName: isworkflowcreated ExternalType: Boolean
|
|
6 | ScheduledEnd (ScheduledEnd) | Date | ExternalName: scheduledend ExternalType: DateTime
|
|
7 | Category (Category) | Text250 | ExternalName: category ExternalType: String
|
|
8 | IsBilled (IsBilled) | Boolean | ExternalName: isbilled ExternalType: Boolean
|
|
9 | ActivityId (ActivityId) | GUID | ExternalName: activityid ExternalType: Uniqueidentifier ExternalAccess: Insert
|
|
10 | StateCode (StateCode) | Option | [Open,Completed,Canceled] OptionOrdinalValues: [0;1;2] InitValue: Open ExternalName: statecode ExternalType: State ExternalAccess: Modify
|
|
11 | Description (Description) | BLOB [Memo] | ExternalName: description ExternalType: Memo
|
|
12 | StatusCode (StatusCode) | Option | [ ,Open,Closed,Canceled] OptionOrdinalValues: [-1;1;2;3] InitValue: [ ] ExternalName: statuscode ExternalType: Status
|
|
13 | OwnerId (OwnerId) | GUID | ExternalName: ownerid ExternalType: Owner
|
|
14 | TimeSpent (TimeSpent) | Integer | ExternalName: timespent ExternalType: Integer
|
|
15 | Subject (Subject) | Text200 | ExternalName: subject ExternalType: String
|
|
16 | CreatedOn (CreatedOn) | DateTime | ExternalName: createdon ExternalType: DateTime ExternalAccess: Read
|
|
17 | ModifiedBy (ModifiedBy) | GUID | ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read
|
|
18 | ScheduledStart (ScheduledStart) | Date | ExternalName: scheduledstart ExternalType: DateTime
|
|
19 | ScheduledDurationMinutes (ScheduledDurationMinutes) | Integer | ExternalName: scheduleddurationminutes ExternalType: Integer ExternalAccess: Read
|
|
20 | VersionNumber (VersionNumber) | BigInteger | ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read
|
|
21 | ActualEnd (ActualEnd) | Date | ExternalName: actualend ExternalType: DateTime
|
|
22 | OwningBusinessUnit (OwningBusinessUnit) | GUID | ExternalName: owningbusinessunit ExternalType: Lookup ExternalAccess: Read
|
|
23 | IncidentId (IncidentId) | GUID | ExternalName: incidentid ExternalType: Lookup
|
|
24 | Subcategory (Subcategory) | Text250 | ExternalName: subcategory ExternalType: String
|
|
25 | OwningUser (OwningUser) | GUID | ExternalName: owninguser ExternalType: Lookup ExternalAccess: Read
|
|
26 | CreatedByName (CreatedByName) | Text200 | ExternalName: createdbyname ExternalType: String ExternalAccess: Read
|
FlowField |
27 | IncidentIdName (IncidentIdName) | Text200 | ExternalName: incidentidname ExternalType: String ExternalAccess: Read
|
FlowField |
28 | ModifiedByName (ModifiedByName) | Text200 | ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read
|
FlowField |
29 | OwnerIdType (OwnerIdType) | Option | [ ,systemuser,team] ExternalName: owneridtype ExternalType: EntityName |
|
30 | ImportSequenceNumber (ImportSequenceNumber) | Integer | ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert
|
|
31 | TimeZoneRuleVersionNumber (TimeZoneRuleVersionNumber) | Integer | MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer
|
|
32 | UTCConversionTimeZoneCode (UTCConversionTimeZoneCode) | Integer | MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer
|
|
33 | OverriddenCreatedOn (OverriddenCreatedOn) | Date | ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert
|
|
34 | IncidentIdType (IncidentIdType) | Option | [ ,incident] ExternalName: incidentidtype ExternalType: EntityName ExternalAccess: Read |
|
35 | CreatedOnBehalfBy (CreatedOnBehalfBy) | GUID | ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
36 | CreatedOnBehalfByName (CreatedOnBehalfByName) | Text200 | ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
37 | ModifiedOnBehalfBy (ModifiedOnBehalfBy) | GUID | ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
38 | ModifiedOnBehalfByName (ModifiedOnBehalfByName) | Text200 | ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
39 | IsRegularActivity (IsRegularActivity) | Boolean | ExternalName: isregularactivity ExternalType: Boolean ExternalAccess: Read
|
|
40 | OwningTeam (OwningTeam) | GUID | ExternalName: owningteam ExternalType: Lookup ExternalAccess: Read
|
Keys
# | Fields | ||
---|---|---|---|
0 | ActivityId (ActivityId) | Clustered: Yes | |
1 | Subject (Subject) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
OwningBusinessUnit (OwningBusinessUnit) | CRM Businessunit | BusinessUnitId (BusinessUnitId) |
|
1..n |
IncidentId (IncidentId) | CRM Incident | IncidentId (IncidentId) |
|
1..n |
ModifiedOnBehalfBy (ModifiedOnBehalfBy) | CRM Systemuser | SystemUserId (SystemUserId) |
|
1..n |
OwningTeam (OwningTeam) | CRM Team | TeamId (TeamId) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
CRM Post | RegardingObjectId (RegardingObjectId) |
|
1..n |