DynamicsDocs.com

Diagrams

Table

CRM Businessunit

Fields |
Keys |
Relations To |
Relations From

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

#	Name	Type
1	BusinessUnitId	GUID	ExternalName: businessunitid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the business unit.
2	OrganizationId	GUID	ExternalName: organizationid ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the organization associated with the business unit. TableRelation: "CRM Organization".OrganizationId
3	Name	Text160	ExternalName: name ExternalType: String Description: Name of the business unit.
4	Description	BLOB [Memo]	ExternalName: description ExternalType: Memo Description: Description of the business unit.
5	DivisionName	Text100	ExternalName: divisionname ExternalType: String Description: Name of the division to which the business unit belongs.
6	FileAsName	Text100	ExternalName: fileasname ExternalType: String Description: Alternative name under which the business unit can be filed.
7	TickerSymbol	Text10	ExternalName: tickersymbol ExternalType: String Description: Stock exchange ticker symbol for the business unit.
8	StockExchange	Text20	ExternalName: stockexchange ExternalType: String Description: Stock exchange on which the business is listed.
9	UTCOffset	Integer	MinValue: -1500 MaxValue: 1500 ExternalName: utcoffset ExternalType: Integer Description: UTC offset for the business unit. This is the difference between local time and standard Coordinated Universal Time.
10	CreatedOn	DateTime	ExternalName: createdon ExternalType: DateTime ExternalAccess: Read Description: Date and time when the business unit was created.
11	ModifiedOn	DateTime	ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read Description: Date and time when the business unit was last modified.
12	CreditLimit	Decimal	ExternalName: creditlimit ExternalType: Double Description: Credit limit for the business unit.
13	CostCenter	Text100	ExternalName: costcenter ExternalType: String Description: Name of the business unit cost center.
14	WebSiteUrl	Text200 [URL]	ExternalName: websiteurl ExternalType: String Description: Website URL for the business unit.
15	FtpSiteUrl	Text200 [URL]	ExternalName: ftpsiteurl ExternalType: String Description: FTP site URL for the business unit.
16	EMailAddress	Text100 [E-Mail]	ExternalName: emailaddress ExternalType: String Description: Email address for the business unit.
17	InheritanceMask	Integer	MaxValue: 1000000000 ExternalName: inheritancemask ExternalType: Integer ExternalAccess: Insert Description: Inheritance mask for the business unit.
18	CreatedBy	GUID	ExternalName: createdby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who created the business unit. TableRelation: "CRM Systemuser".SystemUserId
19	ModifiedBy	GUID	ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who last modified the business unit. TableRelation: "CRM Systemuser".SystemUserId
20	WorkflowSuspended	Boolean	ExternalName: workflowsuspended ExternalType: Boolean Description: Information about whether workflow or sales process rules have been suspended.
21	ParentBusinessUnitId	GUID	ExternalName: parentbusinessunitid ExternalType: Lookup Description: Unique identifier for the parent business unit. TableRelation: "CRM Businessunit".BusinessUnitId
22	IsDisabled	Boolean	ExternalName: isdisabled ExternalType: Boolean ExternalAccess: Read Description: Information about whether the business unit is enabled or disabled.
23	DisabledReason	Text250	ExternalName: disabledreason ExternalType: String ExternalAccess: Read Description: Reason for disabling the business unit.
24	VersionNumber	BigInteger	ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read Description: Version number of the business unit.
25	ParentBusinessUnitIdName	Text160	ExternalName: parentbusinessunitidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Businessunit".Name WHERE (BusinessUnitId=FIELD(ParentBusinessUnitId)))	FlowField
26	Address1_AddressId	GUID	ExternalName: address1_addressid ExternalType: Uniqueidentifier Description: Unique identifier for address 1.
27	Address1_AddressTypeCode	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address1_addresstypecode ExternalType: Picklist Description: Type of address for address 1, such as billing, shipping, or primary address.
28	Address1_Name	Text100	ExternalName: address1_name ExternalType: String Description: Name to enter for address 1.
29	Address1_Line1	Text250	ExternalName: address1_line1 ExternalType: String Description: First line for entering address 1 information.
30	Address1_Line2	Text250	ExternalName: address1_line2 ExternalType: String Description: Second line for entering address 1 information.
31	Address1_Line3	Text250	ExternalName: address1_line3 ExternalType: String Description: Third line for entering address 1 information.
32	Address1_City	Text80	ExternalName: address1_city ExternalType: String Description: City name for address 1.
33	Address1_StateOrProvince	Text50	ExternalName: address1_stateorprovince ExternalType: String Description: State or province for address 1.
34	Address1_County	Text50	ExternalName: address1_county ExternalType: String Description: County name for address 1.
35	Address1_Country	Text80	ExternalName: address1_country ExternalType: String Description: Country/region name for address 1.
36	Address1_PostOfficeBox	Text20	ExternalName: address1_postofficebox ExternalType: String Description: Post office box number for address 1.
37	Address1_PostalCode	Text20	ExternalName: address1_postalcode ExternalType: String Description: ZIP Code or postal code for address 1.
38	Address1_UTCOffset	Integer	MinValue: -1500 MaxValue: 1500 ExternalName: address1_utcoffset ExternalType: Integer Description: UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time.
39	Address1_UPSZone	Text4	ExternalName: address1_upszone ExternalType: String Description: United Parcel Service (UPS) zone for address 1.
40	Address1_Latitude	Decimal	ExternalName: address1_latitude ExternalType: Double Description: Latitude for address 1.
41	Address1_Telephone1	Text50	ExternalName: address1_telephone1 ExternalType: String Description: First telephone number associated with address 1.
42	Address1_Longitude	Decimal	ExternalName: address1_longitude ExternalType: Double Description: Longitude for address 1.
43	Address1_ShippingMethodCode	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address1_shippingmethodcode ExternalType: Picklist Description: Method of shipment for address 1.
44	Address1_Telephone2	Text50	ExternalName: address1_telephone2 ExternalType: String Description: Second telephone number associated with address 1.
45	Address1_Telephone3	Text50	ExternalName: address1_telephone3 ExternalType: String Description: Third telephone number associated with address 1.
46	Address1_Fax	Text50	ExternalName: address1_fax ExternalType: String Description: Fax number for address 1.
47	Address2_AddressId	GUID	ExternalName: address2_addressid ExternalType: Uniqueidentifier Description: Unique identifier for address 2.
48	Address2_AddressTypeCode	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address2_addresstypecode ExternalType: Picklist Description: Type of address for address 2, such as billing, shipping, or primary address.
49	Address2_Name	Text100	ExternalName: address2_name ExternalType: String Description: Name to enter for address 2.
50	Address2_Line1	Text250	ExternalName: address2_line1 ExternalType: String Description: First line for entering address 2 information.
51	Address2_Line2	Text250	ExternalName: address2_line2 ExternalType: String Description: Second line for entering address 2 information.
52	Address2_Line3	Text250	ExternalName: address2_line3 ExternalType: String Description: Third line for entering address 2 information.
53	Address2_City	Text80	ExternalName: address2_city ExternalType: String Description: City name for address 2.
54	Address2_StateOrProvince	Text50	ExternalName: address2_stateorprovince ExternalType: String Description: State or province for address 2.
55	Address2_County	Text50	ExternalName: address2_county ExternalType: String Description: County name for address 2.
56	Address2_Country	Text80	ExternalName: address2_country ExternalType: String Description: Country/region name for address 2.
57	Address2_PostOfficeBox	Text20	ExternalName: address2_postofficebox ExternalType: String Description: Post office box number for address 2.
58	Address2_PostalCode	Text20	ExternalName: address2_postalcode ExternalType: String Description: ZIP Code or postal code for address 2.
59	Address2_UTCOffset	Integer	MinValue: -1500 MaxValue: 1500 ExternalName: address2_utcoffset ExternalType: Integer Description: UTC offset for address 2. This is the difference between local time and standard Coordinated Universal Time.
60	Address2_UPSZone	Text4	ExternalName: address2_upszone ExternalType: String Description: United Parcel Service (UPS) zone for address 2.
61	Address2_Latitude	Decimal	ExternalName: address2_latitude ExternalType: Double Description: Latitude for address 2.
62	Address2_Telephone1	Text50	ExternalName: address2_telephone1 ExternalType: String Description: First telephone number associated with address 2.
63	Address2_Longitude	Decimal	ExternalName: address2_longitude ExternalType: Double Description: Longitude for address 2.
64	Address2_ShippingMethodCode	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address2_shippingmethodcode ExternalType: Picklist Description: Method of shipment for address 2.
65	Address2_Telephone2	Text50	ExternalName: address2_telephone2 ExternalType: String Description: Second telephone number associated with address 2.
66	Address2_Telephone3	Text50	ExternalName: address2_telephone3 ExternalType: String Description: Third telephone number associated with address 2.
67	Address2_Fax	Text50	ExternalName: address2_fax ExternalType: String Description: Fax number for address 2.
68	CreatedByName	Text200	ExternalName: createdbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedBy)))	FlowField
69	ModifiedByName	Text200	ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedBy)))	FlowField
70	OrganizationIdName	Text160	ExternalName: organizationidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Organization".Name WHERE (OrganizationId=FIELD(OrganizationId)))	FlowField
71	OverriddenCreatedOn	Date	ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert Description: Date and time that the record was migrated.
72	ImportSequenceNumber	Integer	ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert Description: Unique identifier of the data import or data migration that created this record.
73	CreatedOnBehalfBy	GUID	ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the delegate user who created the businessunit. TableRelation: "CRM Systemuser".SystemUserId
74	CreatedOnBehalfByName	Text200	ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedOnBehalfBy)))	FlowField
75	ModifiedOnBehalfBy	GUID	ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the delegate user who last modified the businessunit. TableRelation: "CRM Systemuser".SystemUserId
76	ModifiedOnBehalfByName	Text200	ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedOnBehalfBy)))	FlowField
77	TransactionCurrencyId	GUID	ExternalName: transactioncurrencyid ExternalType: Lookup Description: Unique identifier of the currency associated with the businessunit. TableRelation: "CRM Transactioncurrency".TransactionCurrencyId
78	TransactionCurrencyIdName	Text100	ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Transactioncurrency".CurrencyName WHERE (TransactionCurrencyId=FIELD(TransactionCurrencyId)))	FlowField
79	ExchangeRate	Decimal	ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read Description: Exchange rate for the currency associated with the businessunit with respect to the base currency.

Keys

#	Fields
0	BusinessUnitId		Clustered: Yes
1	Name

Table Relations To Other Tables

Field	Related Table	Related Field
ParentBusinessUnitId	CRM Businessunit	BusinessUnitId	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
OrganizationId	CRM Organization	OrganizationId	TableRelation: "CRM Organization".OrganizationId	1..n
ModifiedOnBehalfBy	CRM Systemuser	SystemUserId	TableRelation: "CRM Systemuser".SystemUserId	1..n
TransactionCurrencyId	CRM Transactioncurrency	TransactionCurrencyId	TableRelation: "CRM Transactioncurrency".TransactionCurrencyId	1..n

Table Relations From Other Tables

From Table	From Field
CRM Account	OwningBusinessUnit	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
CRM Businessunit	ParentBusinessUnitId	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
CRM Contact	OwningBusinessUnit	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
CRM Contract	OwningBusinessUnit	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
CRM Customeraddress	OwningBusinessUnit	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
CRM Incident	OwningBusinessUnit	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
CRM Incidentresolution	OwningBusinessUnit	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
CRM Invoice	OwningBusinessUnit	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
CRM Opportunity	OwningBusinessUnit	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
CRM Post	RegardingObjectOwningBusinessU	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
CRM Quote	OwningBusinessUnit	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
CRM Salesorder	OwningBusinessUnit	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
CRM Systemuser	BusinessUnitId	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
CRM Team	BusinessUnitId	TableRelation: "CRM Businessunit".BusinessUnitId	1..n