Excel Add-In for Salesforce Marketing Cloud

Build 20.0.7695

BusinessUnit

A unit within a larger Enterprise or Enterprise 2.0 account. This table supports queries and updates only.

Table-Specific Information

Select

The add-in 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 add-in processes other filters client-side within the add-in. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will cause an error.

For example, the following (but not only) queries are processed server side:

SELECT * FROM BusinessUnit

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

Identifier for an object.

AccountType String False

Type of Marketing Cloud account. Valid values are BUSINESS_UNIT, CHANNEL_CONNECT, CONNECT, DOTO_MEMBER, ENTERPRISE_2, EXACTTARGET, LP_MEMBER, None, PRO_CONNECT, PRO_CONNECT_CLIENT.

ParentID Int False

Specifies the ID number of the parent account.

BrandID Int False

Specifies brand tags to use on an account.

PrivateLabelID Int False

Specifies the private label for an account.

ReportingParentID Int False

Reserved for future use..

Name String False

Name of the object or property.

Email String False

Default email address for object.

FromName String False

Specifies the default email message From Name.

BusinessName String False

Business name of an account's owner.

Phone String False

Specifies a phone number.

Address String False

The address used to communicate with a Person.

Fax String False

Fax number of the account's owner.

City String False

City of an account's owner to be displayed in the physical mailing address required at the bottom of all email messages.

State String False

Specifies the geographical state of the account's owner.

Zip String False

Specifies the zip code of the account's owner.

Country String False

Country of an account's owner, as displayed in the physical mailing address required at the bottom of all email messages.

IsActive Bool False

Specifies whether or not the object is active.

IsTestAccount Bool False

Specifies whether or not an account is a 'Test' account.

Client_ID Int False

The Id of the client.

DBID Int False

Reserved for future use.

CustomerID Long False

The Id of the customer.

DeletedDate Datetime False

Date and time of an account's deletion (the value of this property must be set before the account can be deleted).

EditionID Int False

Specifies the product edition of the account.

IsTrialAccount Bool False

Reserved for future use.

Locale_LocaleCode String True

The locale code of the locale.

Client_EnterpriseID Long True

The enterprise Id of the client.

ModifiedDate Datetime False

Indicates the last time object information was modified.

CreatedDate Datetime False

Date and time of the object's creation.

Subscription_SubscriptionID String True

The subscription id of the subscription.

Subscription_HasPurchasedEmails Bool True

Reserved for future use..

Subscription_EmailsPurchased Int True

Specifies the number of emails purchased in a subscription..

Subscription_Period String True

Reserved for future use..

Subscription_AccountsPurchased Int True

Marketing Cloud Accounts purchased.

Subscription_LPAccountsPurchased Int True

Specifies the number of Lock and Publish account purchased.

Subscription_DOTOAccountsPurchased Int True

Specifies number of Marketing Cloud agency reseller accounts purchased.

Subscription_BUAccountsPurchased Int True

Defines the number of business units purchased for a subscription.

Subscription_AdvAccountsPurchased Int True

This property represents the number of advertising accounts purchased for the account.

Subscription_BeginDate Datetime True

Specifies the date a subscription begins..

Subscription_EndDate Datetime True

Specifies the end data of an activity..

Subscription_Notes String True

Deprecated..

Subscription_ContractNumber String True

Reserved for future use..

Subscription_ContractModifier String True

Reserved for future use..

PartnerKey String False

Unique identifier provided by partner for an object, accessible only via API.

Client_PartnerClientKey String True

Unique identifier provided by partner for an object, accessible only via API.

ParentName String False

Specifies the name of the Parent account.

ParentAccount_ID Int True

The Id of the parent account.

ParentAccount_Name String True

The name of the parent account.

CustomerKey String False

User-supplied unique identifier for an object within an object type.

Description String False

Describes and provides information regarding the object.

DefaultSendClassification_ObjectID String True

System-controlled, read-only text string identifier for object.

DefaultHomePage_ID String True

The Id of the default home page..

InheritAddress Bool False

Specifies that an Enterprise 2.0 business unit will inherit the address from the parent business unit.

ContextualRoles Int True

The contextual roles of the business unit.

LanguageLocale_LocaleCode String True

The locale code of the language locale.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695