Table 5393 "CDS Company"

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

Learn documents this table through its pages: Page 7214 “CDS Companies” (1 Learn page).

Properties

Property	Value
Caption	Company
TableType	CRM
DataClassification	CustomerContent
LookupPageId	CDS Companies
DrillDownPageId	CDS Companies

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	CompanyId Δ BC28	Guid	Specifies the ID of the company.	DataClassification SystemMetadata
2	CreatedOn	DateTime	Created On caption	DataClassification SystemMetadata
3	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId); DataClassification EndUserPseudonymousIdentifiers
4	ModifiedOn	DateTime	Modified On caption	DataClassification SystemMetadata
5	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId); DataClassification EndUserPseudonymousIdentifiers
6	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId); DataClassification EndUserPseudonymousIdentifiers
7	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId); DataClassification EndUserPseudonymousIdentifiers
8	OwnerId	Guid	Owner caption	TableRelation Table 5340 “CRM Systemuser”, Table 5359 “CRM Team” (if (OwnerIdType = const(systemuser)) “CRM Systemuser”.SystemUserId else if (OwnerIdType = const(team)) “CRM Team”.TeamId); DataClassification EndUserPseudonymousIdentifiers
9	OwnerIdType	Option	—	DataClassification SystemMetadata
10	OwningBusinessUnit	Guid	Owning Business Unit caption	TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId); DataClassification OrganizationIdentifiableInformation
11	OwningUser	Guid	Owning User caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId); DataClassification EndUserPseudonymousIdentifiers
12	OwningTeam	Guid	Owning Team caption	TableRelation Table 5359 “CRM Team” (“CRM Team”.TeamId); DataClassification EndUserPseudonymousIdentifiers
13	statecode	Option	Status caption	OptionCaption: ,Active,Inactive; DataClassification SystemMetadata
14	statuscode	Option	Status Reason caption	OptionCaption: ,Active,Inactive; DataClassification SystemMetadata
15	VersionNumber	BigInteger	Version Number caption	DataClassification SystemMetadata
16	ImportSequenceNumber	Integer	Import Sequence Number caption	DataClassification SystemMetadata
17	OverriddenCreatedOn	DateTime	Record Created On caption	DataClassification SystemMetadata
18	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption	DataClassification SystemMetadata
19	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption	DataClassification SystemMetadata
20	ExternalId	Text[36]	‘Specifies the ID of the Dataverse company.’, Comment = ‘Dataverse is the name of a Microsoft Service and should not be translated.’ via Page 7214 “CDS Companies”	DataClassification OrganizationIdentifiableInformation
21	DefaultOwningTeam	Guid	Default owning team ID caption	TableRelation Table 5359 “CRM Team” (“CRM Team”.TeamId); DataClassification EndUserPseudonymousIdentifiers
22	Name Δ BC28	Text[30]	Specifies the name of the company.	DataClassification OrganizationIdentifiableInformation
23	DefaultOwningTeamName Δ BC24	Text[160]	Default owning team name caption	FlowField: lookup(“CRM Team”.Name where(TeamId = field(DefaultOwningTeam)))
24	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
25	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
26	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
27	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))

Keys

Key1: CompanyId (clustered)
Key2: ExternalId

Relations

drill-down page Page 7214 “CDS Companies”
lookup page Page 7214 “CDS Companies”
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”
OwnerId: TableRelation Table 5340 “CRM Systemuser” (conditional)
OwningUser: TableRelation Table 5340 “CRM Systemuser”
DefaultOwningTeamName: CalcFormula Table 5359 “CRM Team”
DefaultOwningTeam: TableRelation Table 5359 “CRM Team”
OwnerId: TableRelation Table 5359 “CRM Team” (conditional)
OwningTeam: TableRelation Table 5359 “CRM Team”
OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”

Referenced by

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

Table 5341 “CRM Account”: CompanyId
Table 5342 “CRM Contact”: CompanyId
Table 5343 “CRM Opportunity”: CompanyId
Table 5346 “CRM Pricelevel”: CompanyId
Table 5348 “CRM Product”: CompanyId
Table 5351 “CRM Quote”: CompanyId
Table 5353 “CRM Salesorder”: CompanyId
Table 5355 “CRM Invoice”: CompanyId
Table 6400 “FS Work Order”: CompanyId
Table 6402 “FS Work Order Product”: CompanyId
Table 6404 “FS Project Task”: CompanyId
Table 6406 “FS Work Order Service”: CompanyId
Table 6410 “FS Bookable Resource”: CompanyId
Table 6420 “FS Customer Asset”: CompanyId
Table 6610 “FS Bookable Resource”: CompanyId
Table 6611 “FS Bookable Resource Booking”: CompanyId
Table 6613 “FS Customer Asset”: CompanyId
Table 6615 “FS Project Task”: CompanyId
Table 6617 “FS Work Order”: CompanyId
Table 6618 “FS Work Order Incident”: CompanyId
Table 6619 “FS Work Order Product”: CompanyId
Table 6620 “FS Work Order Service”: CompanyId
Table 6622 “FS Work Order Type”: CompanyId
Table 6624 “FS Warehouse”: CompanyId

Pages and codeunits on this table

Page 7214 “CDS Companies” (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: "CDS Company"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Across versions

Neighbourhood 29 connected objects and pages