CRM Team

Diagrams

Table

CRM Team

Fields |
Keys |
Relations To |
Relations From

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 Description: Unique identifier for the team.
2	OrganizationId (OrganizationId)	GUID	ExternalName: organizationid ExternalType: Uniqueidentifier ExternalAccess: Read Description: Unique identifier of the organization associated with the team.
3	BusinessUnitId (BusinessUnitId)	GUID	ExternalName: businessunitid ExternalType: Lookup Description: Unique identifier of the business unit with which the team is associated. TableRelation: "CRM Businessunit".BusinessUnitId
4	Name (Name)	Text160	ExternalName: name ExternalType: String Description: Name of the team.
5	Description (Description)	BLOB [Memo]	ExternalName: description ExternalType: Memo Description: Description of the team.
6	EMailAddress (EMailAddress)	Text100 [E-Mail]	ExternalName: emailaddress ExternalType: String Description: Email address for the team.
7	CreatedOn (CreatedOn)	DateTime	ExternalName: createdon ExternalType: DateTime ExternalAccess: Read Description: Date and time when the team was created.
8	ModifiedOn (ModifiedOn)	DateTime	ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read Description: Date and time when the team was last modified.
9	CreatedBy (CreatedBy)	GUID	ExternalName: createdby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who created the team. TableRelation: "CRM Systemuser".SystemUserId
10	ModifiedBy (ModifiedBy)	GUID	ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who last modified the team. TableRelation: "CRM Systemuser".SystemUserId
11	VersionNumber (VersionNumber)	BigInteger	ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read Description: Version number of the team.
12	CreatedByName (CreatedByName)	Text200	ExternalName: createdbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedBy)))	FlowField
13	ModifiedByName (ModifiedByName)	Text200	ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedBy)))	FlowField
14	BusinessUnitIdName (BusinessUnitIdName)	Text160	ExternalName: businessunitidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Businessunit".Name WHERE (BusinessUnitId=FIELD(BusinessUnitId)))	FlowField
15	ImportSequenceNumber (ImportSequenceNumber)	Integer	ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert Description: Unique identifier of the data import or data migration that created this record.
16	OverriddenCreatedOn (OverriddenCreatedOn)	Date	ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert Description: Date and time that the record was migrated.
17	AdministratorId (AdministratorId)	GUID	ExternalName: administratorid ExternalType: Lookup Description: Unique identifier of the user primary responsible for the team. TableRelation: "CRM Systemuser".SystemUserId
18	IsDefault (IsDefault)	Boolean	ExternalName: isdefault ExternalType: Boolean ExternalAccess: Read Description: Information about whether the team is a default business unit team.
19	AdministratorIdName (AdministratorIdName)	Text200	ExternalName: administratoridname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(AdministratorId)))	FlowField
20	YomiName (YomiName)	Text160	ExternalName: yominame ExternalType: String Description: Pronunciation of the full name of the team, written in phonetic hiragana or katakana characters.
21	CreatedOnBehalfBy (CreatedOnBehalfBy)	GUID	ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the delegate user who created the team. TableRelation: "CRM Systemuser".SystemUserId
22	CreatedOnBehalfByName (CreatedOnBehalfByName)	Text200	ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedOnBehalfBy)))	FlowField
23	ModifiedOnBehalfBy (ModifiedOnBehalfBy)	GUID	ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the delegate user who last modified the team. TableRelation: "CRM Systemuser".SystemUserId
24	ModifiedOnBehalfByName (ModifiedOnBehalfByName)	Text200	ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedOnBehalfBy)))	FlowField
25	TraversedPath (TraversedPath)	Text250	ExternalName: traversedpath ExternalType: String Description: For internal use only.
26	TransactionCurrencyId (TransactionCurrencyId)	GUID	ExternalName: transactioncurrencyid ExternalType: Lookup Description: Unique identifier of the currency associated with the team. TableRelation: "CRM Transactioncurrency".TransactionCurrencyId
27	TransactionCurrencyIdName (TransactionCurrencyIdName)	Text100	ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Transactioncurrency".CurrencyName WHERE (TransactionCurrencyId=FIELD(TransactionCurrencyId)))	FlowField
28	ExchangeRate (ExchangeRate)	Decimal	ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read Description: Exchange rate for the currency associated with the team with respect to the base currency.
29	TeamType (TeamType)	Option	[Owner,Access] OptionOrdinalValues: [0;1] InitValue: Owner ExternalName: teamtype ExternalType: Picklist ExternalAccess: Insert Description: Select the team type.
30	RegardingObjectId (RegardingObjectId)	GUID	ExternalName: regardingobjectid ExternalType: Lookup ExternalAccess: Insert Description: Choose the record that the team relates to. TableRelation: IF (RegardingObjectTypeCode=CONST(opportunity)) "CRM Opportunity".OpportunityId
31	SystemManaged (SystemManaged)	Boolean	ExternalName: systemmanaged ExternalType: Boolean ExternalAccess: Read Description: Select whether the team will be managed by the system.
32	RegardingObjectTypeCode (RegardingObjectTypeCode)	Option	[ ,opportunity] ExternalName: regardingobjecttypecode ExternalType: EntityName ExternalAccess: Insert Description: Type of the associated record for team - used for system managed access teams only.
33	StageId (StageId)	GUID	ExternalName: stageid ExternalType: Uniqueidentifier Description: Shows the ID of the stage.
34	ProcessId (ProcessId)	GUID	ExternalName: processid ExternalType: Uniqueidentifier Description: Shows the ID of the process.

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)	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
RegardingObjectId (RegardingObjectId)	CRM Opportunity	OpportunityId (OpportunityId)	TableRelation: IF (RegardingObjectTypeCode=CONST(opportunity)) "CRM Opportunity".OpportunityId	1..n
ModifiedOnBehalfBy (ModifiedOnBehalfBy)	CRM Systemuser	SystemUserId (SystemUserId)	TableRelation: "CRM Systemuser".SystemUserId	1..n
TransactionCurrencyId (TransactionCurrencyId)	CRM Transactioncurrency	TransactionCurrencyId (TransactionCurrencyId)	TableRelation: "CRM Transactioncurrency".TransactionCurrencyId	1..n

Table Relations From Other Tables

From Table	From Field
CRM Account	OwningTeam (OwningTeam)	TableRelation: "CRM Team".TeamId	1..n
CRM Contact	OwningTeam (OwningTeam)	TableRelation: "CRM Team".TeamId	1..n
CRM Contract	OwningTeam (OwningTeam)	TableRelation: "CRM Team".TeamId	1..n
CRM Customeraddress	OwnerId (OwnerId)	TableRelation: IF (OwnerIdType=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (OwnerIdType=CONST(team)) "CRM Team".TeamId;	1..n
CRM Incident	OwningTeam (OwningTeam)	TableRelation: "CRM Team".TeamId	1..n
CRM Incidentresolution	OwningTeam (OwningTeam)	TableRelation: "CRM Team".TeamId	1..n
CRM Invoice	OwningTeam (OwningTeam)	TableRelation: "CRM Team".TeamId	1..n
CRM Invoicedetail	OwnerId (OwnerId)	TableRelation: IF (OwnerIdType=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (OwnerIdType=CONST(team)) "CRM Team".TeamId;	1..n
CRM Opportunity	OwningTeam (OwningTeam)	TableRelation: "CRM Team".TeamId	1..n
CRM Post	RegardingObjectOwnerId (RegardingObjectOwnerId)	TableRelation: IF (RegardingObjectOwnerIdType=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (RegardingObjectOwnerIdType=CONST(team)) "CRM Team".TeamId;	1..n
CRM Quote	OwningTeam (OwningTeam)	TableRelation: "CRM Team".TeamId	1..n
CRM Quotedetail	OwnerId (OwnerId)	TableRelation: IF (OwnerIdType=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (OwnerIdType=CONST(team)) "CRM Team".TeamId;	1..n
CRM Salesorder	OwningTeam (OwningTeam)	TableRelation: "CRM Team".TeamId	1..n
CRM Salesorderdetail	OwnerId (OwnerId)	TableRelation: IF (OwnerIdType=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (OwnerIdType=CONST(team)) "CRM Team".TeamId;	1..n