Table 5364 "CRM Businessunit"

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

Properties

Property	Value
Caption	CRM Businessunit
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	BusinessUnitId Δ BC28	Guid	Specifies the ID of the business unit.
2	OrganizationId	Guid	Organization caption	TableRelation Table 5363 “CRM Organization” (“CRM Organization”.OrganizationId)
3	Name Δ BC28	Text[160]	Specifies the Name of the business unit.
4	Description	BLOB	—
5	DivisionName	Text[100]	Division caption
6	FileAsName	Text[100]	File as Name caption
7	TickerSymbol	Text[10]	Ticker Symbol caption
8	StockExchange	Text[20]	Stock Exchange caption
9	UTCOffset	Integer	UTC Offset caption
10	CreatedOn	DateTime	Created On caption
11	ModifiedOn	DateTime	Modified On caption
12	CreditLimit Δ BC28	Decimal	Credit Limit caption
13	CostCenter	Text[100]	Cost Center caption
14	WebSiteUrl	Text[200]	Website caption
15	FtpSiteUrl	Text[200]	FTP Site caption
16	EMailAddress	Text[100]	Email caption
17	InheritanceMask	Integer	Inheritance Mask caption
18	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
19	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
20	WorkflowSuspended	Boolean	Workflow Suspended caption
21	ParentBusinessUnitId	Guid	Parent Business caption	TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId)
22	IsDisabled	Boolean	Is Disabled caption
23	DisabledReason	Text[250]	Disable Reason caption
24	VersionNumber	BigInteger	Version number caption
25	ParentBusinessUnitIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Businessunit”.Name where(BusinessUnitId = field(ParentBusinessUnitId)))
26	Address1_AddressId	Guid	Address 1: ID caption
27	Address1_AddressTypeCode	Option	Address 1: Address Type caption	OptionCaption: Default Value
28	Address1_Name	Text[100]	Address 1: Name caption
29	Address1_Line1	Text[250]	Bill To Street 1 caption
30	Address1_Line2	Text[250]	Bill To Street 2 caption
31	Address1_Line3	Text[250]	Bill To Street 3 caption
32	Address1_City	Text[80]	Bill To City caption
33	Address1_StateOrProvince	Text[50]	Bill To State/Province caption
34	Address1_County	Text[50]	Address 1: County caption
35	Address1_Country	Text[80]	Bill To Country/Region caption
36	Address1_PostOfficeBox	Text[20]	Address 1: Post Office Box caption
37	Address1_PostalCode	Text[20]	Bill To ZIP/Postal Code caption
38	Address1_UTCOffset	Integer	Address 1: UTC Offset caption
39	Address1_UPSZone	Text[4]	Address 1: UPS Zone caption
40	Address1_Latitude Δ BC28	Decimal	Address 1: Latitude caption
41	Address1_Telephone1	Text[50]	Main Phone caption
42	Address1_Longitude Δ BC28	Decimal	Address 1: Longitude caption
43	Address1_ShippingMethodCode	Option	Address 1: Shipping Method caption	OptionCaption: Default Value
44	Address1_Telephone2	Text[50]	Other Phone caption
45	Address1_Telephone3	Text[50]	Address 1: Telephone 3 caption
46	Address1_Fax	Text[50]	Address 1: Fax caption
47	Address2_AddressId	Guid	Address 2: ID caption
48	Address2_AddressTypeCode	Option	Address 2: Address Type caption	OptionCaption: Default Value
49	Address2_Name	Text[100]	Address 2: Name caption
50	Address2_Line1	Text[250]	Ship To Street 1 caption
51	Address2_Line2	Text[250]	Ship To Street 2 caption
52	Address2_Line3	Text[250]	Ship To Street 3 caption
53	Address2_City	Text[80]	Ship To City caption
54	Address2_StateOrProvince	Text[50]	Ship To State/Province caption
55	Address2_County	Text[50]	Address 2: County caption
56	Address2_Country	Text[80]	Ship To Country/Region caption
57	Address2_PostOfficeBox	Text[20]	Address 2: Post Office Box caption
58	Address2_PostalCode	Text[20]	Ship To ZIP/Postal Code caption
59	Address2_UTCOffset	Integer	Address 2: UTC Offset caption
60	Address2_UPSZone	Text[4]	Address 2: UPS Zone caption
61	Address2_Latitude Δ BC28	Decimal	Address 2: Latitude caption
62	Address2_Telephone1	Text[50]	Address 2: Telephone 1 caption
63	Address2_Longitude Δ BC28	Decimal	Address 2: Longitude caption
64	Address2_ShippingMethodCode	Option	Address 2: Shipping Method caption	OptionCaption: Default Value
65	Address2_Telephone2	Text[50]	Address 2: Telephone 2 caption
66	Address2_Telephone3	Text[50]	Address 2: Telephone 3 caption
67	Address2_Fax	Text[50]	Address 2: Fax caption
68	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
69	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
70	OrganizationIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Organization”.Name where(OrganizationId = field(OrganizationId)))
71	OverriddenCreatedOn	Date	Record Created On caption
72	ImportSequenceNumber	Integer	Import Sequence Number caption
73	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
74	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
75	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
76	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
77	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
78	TransactionCurrencyIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
79	ExchangeRate Δ BC28	Decimal	Exchange Rate caption

Keys

Key1: BusinessUnitId (clustered)
Key2: Name

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”
TransactionCurrencyIdName: CalcFormula Table 5345 “CRM Transactioncurrency”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
OrganizationIdName: CalcFormula Table 5363 “CRM Organization”
OrganizationId: TableRelation Table 5363 “CRM Organization”
ParentBusinessUnitIdName: CalcFormula Table 5364 “CRM Businessunit”
ParentBusinessUnitId: TableRelation Table 5364 “CRM Businessunit”

Referenced by

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

Table 5340 “CRM Systemuser”: BusinessUnitIdName, BusinessUnitId
Table 5359 “CRM Team”: BusinessUnitIdName, BusinessUnitId
Table 5364 “CRM Businessunit”: ParentBusinessUnitIdName, ParentBusinessUnitId
Table 6206 “FS Resource Pay Type”: OwningBusinessUnitName, OwningBusinessUnit
Table 6616 “FS Resource Pay Type”: OwningBusinessUnitName, OwningBusinessUnit
Table 7206 “CRM Company”: OwningBusinessUnitName, OwningBusinessUnit
Table 5341 “CRM Account”: OwningBusinessUnit
Table 5342 “CRM Contact”: OwningBusinessUnit
Table 5343 “CRM Opportunity”: OwningBusinessUnit
Table 5344 “CRM Post”: RegardingObjectOwningBusinessU
Table 5349 “CRM Incident”: OwningBusinessUnit
Table 5350 “CRM Incidentresolution”: OwningBusinessUnit
Table 5351 “CRM Quote”: OwningBusinessUnit
Table 5353 “CRM Salesorder”: OwningBusinessUnit
Table 5355 “CRM Invoice”: OwningBusinessUnit
Table 5357 “CRM Contract”: OwningBusinessUnit
Table 5360 “CRM Customeraddress”: OwningBusinessUnit
Table 5389 “CRM Role”: BusinessUnitId
Table 5393 “CDS Company”: OwningBusinessUnit
Table 6242 “Sust. Assessment”: OwningBusinessUnit
Table 6243 “Sust. Assessment Req. Fact”: OwningBusinessUnit
Table 6244 “Sust. Assessment Requirement”: OwningBusinessUnit
Table 6245 “Sust. Concept”: OwningBusinessUnit
Table 6246 “Sust. ESG Fact”: OwningBusinessUnit
Table 6247 “Sust. Range Period”: OwningBusinessUnit
Table 6248 “Sust. Requirement Concept”: OwningBusinessUnit
Table 6249 “Sust. Standard”: OwningBusinessUnit
Table 6251 “Sust. Unit”: OwningBusinessUnit
Table 6254 “Sust. Standard Requirement”: OwningBusinessUnit
Table 6400 “FS Work Order”: OwningBusinessUnit
Table 6402 “FS Work Order Product”: OwningBusinessUnit
Table 6403 “FS Work Order Incident”: OwningBusinessUnit
Table 6406 “FS Work Order Service”: OwningBusinessUnit
Table 6408 “FS Work Order Substatus”: OwningBusinessUnit
Table 6409 “FS Work Order Type”: OwningBusinessUnit
Table 6410 “FS Bookable Resource”: OwningBusinessUnit
Table 6412 “FS Bookable Resource Booking”: OwningBusinessUnit
Table 6413 “FS BookableResourceBookingHdr”: OwningBusinessUnit
Table 6420 “FS Customer Asset”: OwningBusinessUnit
Table 6422 “FS Customer Asset Category”: OwningBusinessUnit
Table 6610 “FS Bookable Resource”: OwningBusinessUnit
Table 6611 “FS Bookable Resource Booking”: OwningBusinessUnit
Table 6612 “FS BookableResourceBookingHdr”: OwningBusinessUnit
Table 6613 “FS Customer Asset”: OwningBusinessUnit
Table 6614 “FS Customer Asset Category”: OwningBusinessUnit
Table 6617 “FS Work Order”: OwningBusinessUnit
Table 6618 “FS Work Order Incident”: OwningBusinessUnit
Table 6619 “FS Work Order Product”: OwningBusinessUnit
Table 6620 “FS Work Order Service”: OwningBusinessUnit
Table 6621 “FS Work Order Substatus”: OwningBusinessUnit
and 1 more objects (1 fields): data/code/relations/29.json

Pages and codeunits on this table

Page 7203 “CDS Business Units” (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: "CRM Businessunit"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.