Table 7206 "CRM Company"
Base Application · Microsoft.Integration.D365Sales
Across versions
- BC23present
- BC24declaration changed
- BC25-30unchanged
Neighbourhood 4 connected objects and pages
Base Application · Microsoft.Integration.D365Sales · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| 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 | cdm_companyId | GUID | Company caption | |
| 2 | CreatedOn | Datetime | Created On caption | |
| 3 | CreatedBy | GUID | Created By caption | TableRelation Table 5340 “CRM Systemuser” (“CRM SystemUser”.SystemUserId) |
| 4 | ModifiedOn | Datetime | Modified On caption | |
| 5 | ModifiedBy | GUID | Modified By caption | TableRelation Table 5340 “CRM Systemuser” (“CRM SystemUser”.SystemUserId) |
| 6 | CreatedOnBehalfBy | GUID | Created By (Delegate) caption | TableRelation Table 5340 “CRM Systemuser” (“CRM SystemUser”.SystemUserId) |
| 7 | ModifiedOnBehalfBy | GUID | Modified By (Delegate) caption | TableRelation Table 5340 “CRM Systemuser” (“CRM SystemUser”.SystemUserId) |
| 8 | CreatedByName | Text[200] | Created By Name caption | FlowField: lookup(“CRM SystemUser”.FullName where(SystemUserId = field(CreatedBy))) |
| 10 | CreatedOnBehalfByName | Text[200] | Created On Behalf By Name caption | FlowField: lookup(“CRM SystemUser”.FullName where(SystemUserId = field(CreatedOnBehalfBy))) |
| 12 | ModifiedByName | Text[200] | Modified By Name caption | FlowField: lookup(“CRM SystemUser”.FullName where(SystemUserId = field(ModifiedBy))) |
| 14 | ModifiedOnBehalfByName | Text[200] | Modified On Behalf By Name caption | FlowField: lookup(“CRM SystemUser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy))) |
| 16 | OwnerId | GUID | Owner caption | |
| 21 | OwningBusinessUnit | GUID | Owning Business Unit caption | TableRelation Table 5364 “CRM Businessunit” (“CRM BusinessUnit”.BusinessUnitId) |
| 22 | OwningUser | GUID | Owning User caption | TableRelation Table 5340 “CRM Systemuser” (“CRM SystemUser”.SystemUserId) |
| 23 | OwningTeam | GUID | Owning Team caption | TableRelation Table 5359 “CRM Team” (“CRM Team”.TeamId) |
| 24 | OwningBusinessUnitName | Text[160] | — | FlowField: lookup(“CRM BusinessUnit”.Name where(BusinessUnitId = field(OwningBusinessUnit))) |
| 25 | statecode | Option | Status caption | |
| 27 | statuscode | Option | Status Reason caption | |
| 29 | VersionNumber | BigInteger | Version Number caption | |
| 30 | ImportSequenceNumber | Integer | Import Sequence Number caption | |
| 31 | OverriddenCreatedOn | Date | Record Created On caption | |
| 32 | TimeZoneRuleVersionNumber | Integer | Time Zone Rule Version Number caption | |
| 33 | UTCConversionTimeZoneCode | Integer | UTC Conversion Time Zone Code caption | |
| 34 | cdm_CompanyCode | Text[30] | Company Code caption | |
| 35 | cdm_defaultowningteam | GUID | Default owning team caption | TableRelation Table 5359 “CRM Team” (“CRM Team”.TeamId) |
| 36 | cdm_IsEnabledforDualWrite | Boolean | Is Enabled for Dual Write caption | |
| 38 | cdm_Name | Text[100] | Name caption | |
| 39 | cdm_defaultowningteamName | Text[160] | Default Owning Team Name caption | FlowField: lookup(“CRM Team”.Name where(TeamId = field(cdm_defaultowningteam))) |
Keys
- PK: cdm_companyId (clustered)
- Name: cdm_CompanyCode
Relations
- CreatedByName: CalcFormula Table 5340 “CRM Systemuser”
- CreatedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
- ModifiedByName: CalcFormula Table 5340 “CRM Systemuser”
- ModifiedOnBehalfByName: CalcFormula 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”
- OwningUser: TableRelation Table 5340 “CRM Systemuser”
- cdm_defaultowningteamName: CalcFormula Table 5359 “CRM Team”
- cdm_defaultowningteam: TableRelation Table 5359 “CRM Team”
- OwningTeam: TableRelation Table 5359 “CRM Team”
- OwningBusinessUnitName: CalcFormula Table 5364 “CRM Businessunit”
- OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”
Referenced by
2 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 7207 “CRM BC Virtual Table Config.”: msdyn_DefaultCompanyIdName, msdyn_DefaultCompanyId
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 Company"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.