Table 5359 "CRM Team"

Base Application · Microsoft.Integration.D365Sales · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	CRM Team
TableType	CRM
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	TeamId	Guid	Team caption
2	OrganizationId	Guid	Organization caption
3	BusinessUnitId	Guid	Business Unit caption	TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId)
4	Name	Text[160]	Team Name caption
5	Description	BLOB	—
6	EMailAddress	Text[100]	Email caption
7	CreatedOn	DateTime	Created On caption
8	ModifiedOn	DateTime	Modified On caption
9	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
10	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
11	VersionNumber	BigInteger	Version number caption
12	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
13	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
14	BusinessUnitIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Businessunit”.Name where(BusinessUnitId = field(BusinessUnitId)))
15	ImportSequenceNumber	Integer	Import Sequence Number caption
16	OverriddenCreatedOn	Date	Record Created On caption
17	AdministratorId	Guid	Administrator caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
18	IsDefault	Boolean	Is Default caption
19	AdministratorIdName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(AdministratorId)))
20	YomiName	Text[160]	Yomi Name caption
21	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
22	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
23	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
24	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
25	TraversedPath	Text[250]	Traversed Path caption
26	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
27	TransactionCurrencyIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
28	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
29	TeamType	Option	Team Type caption	OptionCaption: Owner,Access
30	RegardingObjectId	Guid	Regarding Object Id caption	TableRelation Table 5343 “CRM Opportunity” (if (RegardingObjectTypeCode = const(opportunity)) “CRM Opportunity”.OpportunityId)
31	SystemManaged	Boolean	Is System Managed caption
32	RegardingObjectTypeCode	Option	Regarding Object Type caption	OptionCaption: ,opportunity
33	StageId	Guid	Process Stage caption
34	ProcessId	Guid	Process caption

Keys

Key1: TeamId (clustered)
Key2: Name

Relations

AdministratorIdName: CalcFormula Table 5340 “CRM Systemuser”
CreatedByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
AdministratorId: TableRelation Table 5340 “CRM Systemuser”
CreatedBy: TableRelation Table 5340 “CRM Systemuser”
CreatedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
RegardingObjectId: TableRelation Table 5343 “CRM Opportunity”
TransactionCurrencyIdName: CalcFormula Table 5345 “CRM Transactioncurrency”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
BusinessUnitIdName: CalcFormula Table 5364 “CRM Businessunit”
BusinessUnitId: TableRelation Table 5364 “CRM Businessunit”

Referenced by

66 fields in 52 objects relate to this table (TableRelation or CalcFormula).

Table 5393 “CDS Company”: DefaultOwningTeamName, DefaultOwningTeam, OwnerId, OwningTeam
Table 7206 “CRM Company”: cdm_defaultowningteamName, cdm_defaultowningteam, OwningTeam
Table 5341 “CRM Account”: OwnerId, OwningTeam
Table 5342 “CRM Contact”: OwnerId, OwningTeam
Table 5343 “CRM Opportunity”: OwnerId, OwningTeam
Table 5349 “CRM Incident”: OwnerId, OwningTeam
Table 5350 “CRM Incidentresolution”: OwnerId, OwningTeam
Table 5351 “CRM Quote”: OwnerId, OwningTeam
Table 5353 “CRM Salesorder”: OwnerId, OwningTeam
Table 5355 “CRM Invoice”: OwnerId, OwningTeam
Table 5357 “CRM Contract”: OwnerId, OwningTeam
Table 5344 “CRM Post”: RegardingObjectOwnerId
Table 5352 “CRM Quotedetail”: OwnerId
Table 5354 “CRM Salesorderdetail”: OwnerId
Table 5356 “CRM Invoicedetail”: OwnerId
Table 5360 “CRM Customeraddress”: OwnerId
Table 5396 “CDS Teamroles”: TeamId
Table 5397 “CDS Teammembership”: TeamId
Table 6206 “FS Resource Pay Type”: OwningTeam
Table 6242 “Sust. Assessment”: OwningTeam
Table 6243 “Sust. Assessment Req. Fact”: OwningTeam
Table 6244 “Sust. Assessment Requirement”: OwningTeam
Table 6245 “Sust. Concept”: OwningTeam
Table 6246 “Sust. ESG Fact”: OwningTeam
Table 6247 “Sust. Range Period”: OwningTeam
Table 6248 “Sust. Requirement Concept”: OwningTeam
Table 6249 “Sust. Standard”: OwningTeam
Table 6251 “Sust. Unit”: OwningTeam
Table 6254 “Sust. Standard Requirement”: OwningTeam
Table 6400 “FS Work Order”: OwningTeam
Table 6402 “FS Work Order Product”: OwningTeam
Table 6403 “FS Work Order Incident”: OwningTeam
Table 6406 “FS Work Order Service”: OwningTeam
Table 6408 “FS Work Order Substatus”: OwningTeam
Table 6409 “FS Work Order Type”: OwningTeam
Table 6410 “FS Bookable Resource”: OwningTeam
Table 6412 “FS Bookable Resource Booking”: OwningTeam
Table 6413 “FS BookableResourceBookingHdr”: OwningTeam
Table 6420 “FS Customer Asset”: OwningTeam
Table 6422 “FS Customer Asset Category”: OwningTeam
Table 6610 “FS Bookable Resource”: OwningTeam
Table 6611 “FS Bookable Resource Booking”: OwningTeam
Table 6612 “FS BookableResourceBookingHdr”: OwningTeam
Table 6613 “FS Customer Asset”: OwningTeam
Table 6614 “FS Customer Asset Category”: OwningTeam
Table 6616 “FS Resource Pay Type”: OwningTeam
Table 6617 “FS Work Order”: OwningTeam
Table 6618 “FS Work Order Incident”: OwningTeam
Table 6619 “FS Work Order Product”: OwningTeam
Table 6620 “FS Work Order Service”: OwningTeam
and 2 more objects (2 fields): data/code/relations/29.json

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "CRM Team"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Across versions

Neighbourhood 56 connected objects and pages