Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | TeamId (TeamId) | GUID | ExternalName: teamid ExternalType: Uniqueidentifier ExternalAccess: Insert
|
|
2 | OrganizationId (OrganizationId) | GUID | ExternalName: organizationid ExternalType: Uniqueidentifier ExternalAccess: Read
|
|
3 | BusinessUnitId (BusinessUnitId) | GUID | ExternalName: businessunitid ExternalType: Lookup
|
|
4 | Name (Name) | Text160 | ExternalName: name ExternalType: String
|
|
5 | Description (Description) | BLOB [Memo] | ExternalName: description ExternalType: Memo
|
|
6 | EMailAddress (EMailAddress) | Text100 [E-Mail] | ExternalName: emailaddress ExternalType: String
|
|
7 | CreatedOn (CreatedOn) | DateTime | ExternalName: createdon ExternalType: DateTime ExternalAccess: Read
|
|
8 | ModifiedOn (ModifiedOn) | DateTime | ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read
|
|
9 | CreatedBy (CreatedBy) | GUID | ExternalName: createdby ExternalType: Lookup ExternalAccess: Read
|
|
10 | ModifiedBy (ModifiedBy) | GUID | ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read
|
|
11 | VersionNumber (VersionNumber) | BigInteger | ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read
|
|
12 | CreatedByName (CreatedByName) | Text200 | ExternalName: createdbyname ExternalType: String ExternalAccess: Read
|
FlowField |
13 | ModifiedByName (ModifiedByName) | Text200 | ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read
|
FlowField |
14 | BusinessUnitIdName (BusinessUnitIdName) | Text160 | ExternalName: businessunitidname ExternalType: String ExternalAccess: Read
|
FlowField |
15 | ImportSequenceNumber (ImportSequenceNumber) | Integer | ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert
|
|
16 | OverriddenCreatedOn (OverriddenCreatedOn) | Date | ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert
|
|
17 | AdministratorId (AdministratorId) | GUID | ExternalName: administratorid ExternalType: Lookup
|
|
18 | IsDefault (IsDefault) | Boolean | ExternalName: isdefault ExternalType: Boolean ExternalAccess: Read
|
|
19 | AdministratorIdName (AdministratorIdName) | Text200 | ExternalName: administratoridname ExternalType: String ExternalAccess: Read
|
FlowField |
20 | YomiName (YomiName) | Text160 | ExternalName: yominame ExternalType: String
|
|
21 | CreatedOnBehalfBy (CreatedOnBehalfBy) | GUID | ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
22 | CreatedOnBehalfByName (CreatedOnBehalfByName) | Text200 | ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
23 | ModifiedOnBehalfBy (ModifiedOnBehalfBy) | GUID | ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
24 | ModifiedOnBehalfByName (ModifiedOnBehalfByName) | Text200 | ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
25 | TraversedPath (TraversedPath) | Text250 | ExternalName: traversedpath ExternalType: String
|
|
26 | TransactionCurrencyId (TransactionCurrencyId) | GUID | ExternalName: transactioncurrencyid ExternalType: Lookup
|
|
27 | TransactionCurrencyIdName (TransactionCurrencyIdName) | Text100 | ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read
|
FlowField |
28 | ExchangeRate (ExchangeRate) | Decimal | ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read
|
|
29 | TeamType (TeamType) | Option | [Owner,Access] OptionOrdinalValues: [0;1] InitValue: Owner ExternalName: teamtype ExternalType: Picklist ExternalAccess: Insert
|
|
30 | RegardingObjectId (RegardingObjectId) | GUID | ExternalName: regardingobjectid ExternalType: Lookup ExternalAccess: Insert
|
|
31 | SystemManaged (SystemManaged) | Boolean | ExternalName: systemmanaged ExternalType: Boolean ExternalAccess: Read
|
|
32 | RegardingObjectTypeCode (RegardingObjectTypeCode) | Option | [ ,opportunity] ExternalName: regardingobjecttypecode ExternalType: EntityName ExternalAccess: Insert
|
|
33 | StageId (StageId) | GUID | ExternalName: stageid ExternalType: Uniqueidentifier
|
|
34 | ProcessId (ProcessId) | GUID | ExternalName: processid ExternalType: Uniqueidentifier
|
Keys
# | Fields | ||
---|---|---|---|
0 | TeamId (TeamId) | Clustered: Yes | |
1 | Name (Name) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
BusinessUnitId (BusinessUnitId) | CRM Businessunit | BusinessUnitId (BusinessUnitId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Opportunity | OpportunityId (OpportunityId) |
|
1..n |
ModifiedOnBehalfBy (ModifiedOnBehalfBy) | CRM Systemuser | SystemUserId (SystemUserId) |
|
1..n |
TransactionCurrencyId (TransactionCurrencyId) | CRM Transactioncurrency | TransactionCurrencyId (TransactionCurrencyId) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
CRM Account | OwningTeam (OwningTeam) |
|
1..n |
CRM Contact | OwningTeam (OwningTeam) |
|
1..n |
CRM Contract | OwningTeam (OwningTeam) |
|
1..n |
CRM Customeraddress | OwnerId (OwnerId) |
|
1..n |
CRM Incident | OwningTeam (OwningTeam) |
|
1..n |
CRM Incidentresolution | OwningTeam (OwningTeam) |
|
1..n |
CRM Invoice | OwningTeam (OwningTeam) |
|
1..n |
CRM Invoicedetail | OwnerId (OwnerId) |
|
1..n |
CRM Opportunity | OwningTeam (OwningTeam) |
|
1..n |
CRM Post | RegardingObjectOwnerId (RegardingObjectOwnerId) |
|
1..n |
CRM Quote | OwningTeam (OwningTeam) |
|
1..n |
CRM Quotedetail | OwnerId (OwnerId) |
|
1..n |
CRM Salesorder | OwningTeam (OwningTeam) |
|
1..n |
CRM Salesorderdetail | OwnerId (OwnerId) |
|
1..n |