Table 5083 "Team"
Base Application · Microsoft.CRM.Team
Across versions
- BC23present
- BC24declaration changed
- BC25-27unchanged
- BC283 fields changed
- BC29-30unchanged
Neighbourhood 11 connected objects and pages
Base Application · Microsoft.CRM.Team · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Team |
| 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 | Code Δ BC28 | Code[10] | Specifies the code for the team. | NotBlank |
| 2 | Name Δ BC28 | Text[50] | Specifies the name of the team. | |
| 3 | Next Task Date Δ BC28 | Date | Specifies the date of the next task involving the team. | FlowField: min(“To-do”.Date where(“Team Code” = field(Code), Closed = const(false))); not editable |
| 4 | Date Filter | Date | — | FlowFilter |
| 5 | Contact Filter | Code[20] | — | TableRelation Table 5050 “Contact”; FlowFilter |
| 6 | Contact Company Filter | Code[20] | — | TableRelation Table 5050 “Contact” (Contact where(Type = const(Company))); FlowFilter |
| 7 | Task Status Filter | Enum “Task Status” | — | FlowFilter; enum Enum 5081 “Task Status” |
| 8 | Task Closed Filter | Boolean | — | FlowFilter |
| 9 | Priority Filter | Option | — | FlowFilter; OptionCaption: Low,Normal,High |
| 11 | Salesperson Filter | Code[20] | — | TableRelation Table 13 “Salesperson/Purchaser” (Salesperson/Purchaser); FlowFilter |
| 12 | Campaign Filter | Code[20] | — | TableRelation Table 5071 “Campaign”; FlowFilter |
| 13 | Task Entry Exists | Boolean | — | FlowField: exist(“To-do” where(“Team Code” = field(Code), “Contact No.” = field(“Contact Filter”), “Contact Company No.” = field(“Contact Company Filter”), “Salesperson Code” = field(“Salesperson Filter”), “Campaign No.” = field(“Campaign Filter”), Status = field(“Task Status Filter”), Closed = field(“Task Clo…; not editable |
Keys
- Key1: Code (clustered)
Triggers
OnDelete
Relations
- drill-down page Page 5105 “Teams”
- lookup page Page 5105 “Teams”
- Salesperson Filter: TableRelation Table 13 “Salesperson/Purchaser”
- Contact Company Filter: TableRelation Table 5050 “Contact”
- Contact Filter: TableRelation Table 5050 “Contact”
- Campaign Filter: TableRelation Table 5071 “Campaign”
- Next Task Date: CalcFormula Table 5080 “To-do”
- Task Entry Exists: CalcFormula Table 5080 “To-do”
Referenced by
8 fields in 6 objects relate to this table (TableRelation or CalcFormula).
- Table 5080 “To-do”: Team Name, Team Code
- Table 5084 “Team Salesperson”: Team Name, Team Code
- Table 13 “Salesperson/Purchaser”: Team Filter
- Table 5050 “Contact”: Team Filter
- Table 5071 “Campaign”: Team Filter
- Table 5102 “RM Matrix Management”: Team Filter
Pages and codeunits on this table
- Page 5105 “Teams” (source table)
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: "Team"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.