BusinessUnit
Represents a business unit within an Enterprise or Enterprise 2.0 Salesforce Marketing Cloud account. Each business unit defines a logical partition for users, data, and permissions. This table supports query and update operations but does not allow deletions to maintain enterprise hierarchy integrity.
Table-Specific Information
Select
The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.
For example, the following (but not only) queries are processed server side:
SELECT * FROM BusinessUnit WHERE Id = 123 SELECT * FROM BusinessUnit WHERE Id IN (123, 456) SELECT * FROM BusinessUnit WHERE CreatedDate > '2017/01/25'
Update
You must specify the Id in the WHERE clause when executing an update against this table.
UPDATE BusinessUnit SET Name = 'Changed' WHERE Id = 123
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | Int | False |
Specifies the system-generated identifier (Id) that uniquely represents the business unit within the Marketing Cloud hierarchy. |
| AccountType | String | False |
Specifies the Salesforce Marketing Cloud account classification assigned to the business unit. Valid values include BUSINESS_UNIT, CHANNEL_CONNECT, CONNECT, DOTO_MEMBER, ENTERPRISE_2, EXACTTARGET, LP_MEMBER, None, PRO_CONNECT, and PRO_CONNECT_CLIENT. This classification determines feature access, provisioning rules, and administrative scope. |
| ParentID | Int | False |
Specifies the Id of the parent account or enterprise business unit. This value determines the hierarchical structure that governs permissions, shared content, and inherited settings. |
| BrandID | Int | False |
Specifies the branding profile that is associated with the business unit. This value determines which brand tags and identity properties apply to messages sent from the unit. |
| PrivateLabelID | Int | False |
Specifies the private label configuration that is associated with the business unit. This configuration customizes interface elements and branding in supported contexts. |
| ReportingParentID | Int | False |
Specifies the Id of the parent account used for consolidated roll-up reporting. This value determines where the business unit's tracking and performance metrics aggregate within an enterprise hierarchy. |
| Name | String | False |
Specifies the display name that is assigned to the business unit. This value appears in Salesforce Marketing Cloud Administration and in business-unit selection menus. |
| String | False |
Specifies the default email address that is associated with the business unit. Systems use this address as the default sender context when subscriber information does not provide an override. | |
| FromName | String | False |
Specifies the default 'From Name' value that is used for email messages that originate from the business unit. This value helps establish sender identity in outbound communications. |
| BusinessName | String | False |
Specifies the legal or operational business name that is associated with the business unit. This value is included in required physical mailing address components in email footers. |
| Phone | String | False |
Specifies the contact phone number that is associated with the business unit. This value appears in compliance-required physical address details. |
| Address | String | False |
Specifies the mailing address that is associated with the business unit. This address appears in the physical address footer that all compliant email messages must include. |
| Fax | String | False |
Specifies the fax number that is associated with the business unit. This value is maintained for completeness within the physical address profile. |
| City | String | False |
Specifies the city component of the business unit's physical mailing address. This value appears in the required footer of all outbound email messages. |
| State | String | False |
Specifies the state component of the physical mailing address associated with the business unit. |
| Zip | String | False |
Specifies the postal or zip code for the business unit's physical address. |
| Country | String | False |
Specifies the country component of the physical mailing address that is associated with the business unit. |
| IsActive | Bool | False |
Returns a value of 'true' when the business unit is active and available for use. It returns a value of 'false' when the business unit is inactive or restricted through administrative controls. |
| IsTestAccount | Bool | False |
Returns a value of 'true' when the business unit is designated as a test account. It returns a value of 'false' when the business unit operates as a production environment. |
| Client_ID | Int | False |
Specifies the internal client Id that is assigned to the business unit. This value determines the organizational and billing scope of the unit. |
| DBID | Int | False |
Specifies an internal database Id that is maintained for system-level operations. This value is not used in customer-facing processes. |
| CustomerID | Long | False |
Specifies the customer-level Id that is associated with the business unit. This value supports billing, entitlements, and account provisioning. |
| DeletedDate | Datetime | False |
Specifies the date and time when the business unit was marked for deletion. Administrators must set this value before the system can remove the business unit. |
| EditionID | Int | False |
Specifies the Salesforce Marketing Cloud product edition assigned to the business unit. This edition determines available features and entitlement boundaries. |
| IsTrialAccount | Bool | False |
Returns a value of 'true' when the business unit operates under a trial subscription. It returns a value of 'false' when the business unit is fully licensed. |
| Locale_LocaleCode | String | True |
Specifies the locale code that determines the business unit's default regional formatting, such as date, time, and number display rules. |
| Client_EnterpriseID | Long | True |
Specifies the enterprise-level Id that is associated with the business unit. This value defines the top-level organizational context for hierarchy and permissions. |
| ModifiedDate | Datetime | False |
Indicates the most recent date and time when the business unit's configuration or metadata was updated. |
| CreatedDate | Datetime | False |
Specifies the date and time when the business unit was created within the enterprise hierarchy. |
| Subscription_SubscriptionID | String | True |
Specifies the internal subscription Id that is associated with the business unit's licensed services. This value supports contract alignment and entitlement tracking. |
| Subscription_HasPurchasedEmails | Bool | True |
Returns a value of 'true' when the subscription record is associated with purchased email-sending capacity. It returns a value of 'false' when the subscription does not include email sends. |
| Subscription_EmailsPurchased | Int | True |
Specifies the number of email messages that the business unit is licensed to send under its subscription agreement. |
| Subscription_Period | String | True |
Specifies the subscription term that Salesforce Marketing Cloud records for internal billing and entitlement tracking. This value represents the contract period that is associated with licensed services. |
| Subscription_AccountsPurchased | Int | True |
Specifies the number of Salesforce Marketing Cloud accounts that are included in the subscription. This value determines how many child business units the organization can provision. |
| Subscription_LPAccountsPurchased | Int | True |
Specifies the number of Lock and Publish accounts that the subscription supports. These accounts enable controlled asset distribution and governance. |
| Subscription_DOTOAccountsPurchased | Int | True |
Specifies the number of Salesforce Marketing Cloud agency reseller accounts that are included in the subscription. These accounts support distributed operations across multiple customer entities. |
| Subscription_BUAccountsPurchased | Int | True |
Specifies the number of business units that the subscription allows the customer to create within the enterprise hierarchy. |
| Subscription_AdvAccountsPurchased | Int | True |
Specifies the number of advertising accounts that the business unit is licensed to use. These accounts support integrated advertising activities across connected channels. |
| Subscription_BeginDate | Datetime | True |
Specifies the date and time when the subscription term for the business unit begins. This value determines when licensed capabilities and entitlements become active. |
| Subscription_EndDate | Datetime | True |
Specifies the date and time when the subscription term ends. This value determines when licensed services expire unless the subscription is renewed. |
| Subscription_Notes | String | True |
Contains internal notes or annotations that are associated with the subscription record. This field is retained for compatibility but is not commonly used in modern subscription workflows. |
| Subscription_ContractNumber | String | True |
Specifies the contract number that is associated with the business unit's subscription. This value supports internal billing, licensing reconciliation, and cross-system contract tracking. |
| Subscription_ContractModifier | String | True |
Specifies an optional modifier or qualifier that is associated with the subscription contract. This value can represent amendments or special terms that affect the contract configuration. |
| PartnerKey | String | False |
Specifies the unique partner-supplied Id that is associated with the business unit. This value is available only through the API and allows external systems to map or track the account consistently. |
| Client_PartnerClientKey | String | True |
Specifies the partner client key that external systems provide for the business unit. This value enables cross-system reference, synchronization, and partner-level reporting. |
| ParentName | String | False |
Specifies the display name of the parent account that governs the business unit. This value reflects the hierarchical structure within the enterprise. |
| ParentAccount_ID | Int | True |
Specifies the Id of the parent account in the Salesforce Marketing Cloud hierarchy. This value determines which account provides inherited settings and administrative oversight. |
| ParentAccount_Name | String | True |
Specifies the display name of the parent account from which the business unit inherits configuration and permissions. |
| CustomerKey | String | False |
Specifies the user-defined unique Id that is assigned to the business unit within its object type. This value supports cross-system references and environment migrations. |
| Description | String | False |
Provides a human-readable description that communicates the purpose, characteristics, or administrative role of the business unit within the enterprise. |
| DefaultSendClassification_ObjectID | String | True |
Specifies the system-controlled, read-only Id of the default send classification that governs how commercial or transactional sends are defined for the business unit. |
| DefaultHomePage_ID | String | True |
Specifies the Id of the home page that users see when they access the business unit. This value determines the default landing experience in the user interface. |
| InheritAddress | Bool | False |
Returns a value of 'true' when the business unit inherits its address information from its parent account. It returns a value of 'false' when the business unit maintains its own address configuration. |
| ContextualRoles | Int | True |
Specifies the contextual role assignments that apply to the business unit. These values determine which permissions, capabilities, and feature-level access rights are available within this specific account context. |
| LanguageLocale_LocaleCode | String | True |
Specifies the locale code that governs language presentation within the business unit. This value determines the regional language format used in the interface. |