Account

Represents an account within Salesforce Marketing Cloud. Each record defines the configuration, credentials, and organizational context of a Marketing Cloud account. This table supports management of account-level metadata for system integration and user provisioning.

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 Account WHERE Id = 123

SELECT * FROM Account WHERE Id IN (123, 456)

SELECT * FROM Account WHERE CreatedDate > '2017/01/25'

Insert

You must specify the Name column when executing an insert against this table.

INSERT INTO Account (Name) VALUES ('Test')

Update

You must specify the Id in the WHERE clause when executing an update against this table.

UPDATE Account SET Fax = '1123123' WHERE Id = 123

Delete

You must specify the Id in the WHERE clause when executing a delete against this table.

DELETE FROM Account WHERE Id = 123

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Int	False	Specifies the unique identifier (Id) of the account. This Id distinguishes the account within the Salesforce Marketing Cloud environment and is used to reference it in configuration, hierarchy, and API operations.
AccountType	String	False	Specifies the type of Salesforce Marketing Cloud account (for example, 'BUSINESS_UNIT or 'ENTERPRISE_2'). This value determines the features, permissions, and structural capabilities available to the account. The allowed 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 of the parent account for hierarchical configurations such as Lock and Publish, On Your Behalf, Enterprise, and Enterprise 2.0 models. This value links the account to the business unit or enterprise structure that governs it.
BrandID	Int	False	Specifies the Id of the branding profile that is associated with the account. Branding profiles provide sender identity details such as logos, colors, and footers that are applied to email assets.
PrivateLabelID	Int	False	Specifies the Id of the private label configuration for the account. Private label settings control custom branding for login pages, navigation, and account-level interfaces.
ReportingParentID	Int	False	Specifies the Id of the parent account that is used for consolidated reporting within an account hierarchy. This value determines which higher-level account receives aggregated metrics and roll-up reporting for the current business unit.
Name	String	False	Specifies the name of the account as displayed in the Salesforce Marketing Cloud interface and in administrative tools.
Email	String	False	Specifies the default email address that is associated with the account. This address can be used for administrative communications and determines whether subscriber information is eligible for email sends.
FromName	String	False	[DEPRECATED] Specifies the default 'From Name' value that is applied to email messages.
BusinessName	String	False	Specifies the business name of the account owner. This value often appears in email footers, compliance displays, and account-level branding.
Phone	String	False	Specifies the primary phone number that is associated with the account owner or business entity.
Address	String	False	Specifies the physical address that is used for compliance purposes when communicating with a person. This address can appear in the required footer of commercial messages.
Fax	String	False	Specifies the fax number that is associated with the account owner, when it is applicable.
City	String	False	Specifies the city portion of the account owner's physical mailing address. This value appears in the required footer of email messages.
State	String	False	Specifies the geographic state or region that is associated with the account owner's physical mailing address.
Zip	String	False	Specifies the postal or ZIP code of the account owner's physical mailing address.
Country	String	False	Specifies the country associated with the account owner's physical mailing address. This value appears in the required footer of email messages to support compliance with regional regulations.
IsActive	Boolean	False	Specifies whether the account is currently active. A value of 'true' indicates that the account can be used for sends, API requests, and administrative operations.
IsTestAccount	Bool	False	Specifies whether the account is classified as a test account. A value of 'true' indicates that the account is designated for testing or non-production use.
Client_ClientID1	Int	True	Specifies the client Id that is associated with the account within the broader Salesforce Marketing Cloud client structure.
DBID	Int	False	Specifies the internal database Id that Salesforce Marketing Cloud uses to reference the account within its underlying platform infrastructure. This value is system-generated, read-only, and not used in customer-facing operations.
CustomerID	Long	False	Specifies the long-form internal customer Id that Salesforce Marketing Cloud assigns to the account for backend processing and system reconciliation. This value is system-generated, read-only, and not exposed in standard UI workflows.
DeletedDate	Datetime	True	Specifies the date and time when the account was deleted or scheduled for deactivation.
EditionID	Int	False	Specifies the edition of the Salesforce Marketing Cloud product that the account uses. Product editions determine feature availability and capacity limits.
ModifiedDate	Datetime	False	Specifies the date and time when the account information was last modified through the interface or an API call.
CreatedDate	Datetime	False	Specifies the date and time when the account was originally created within Salesforce Marketing Cloud.
ParentName	String	False	Specifies the name of the parent account that appears in the account hierarchy. This value helps administrators understand business unit inheritance and governance relationships.
Subscription_SubscriptionID	String	True	Specifies the internal subscription Id that Salesforce Marketing Cloud assigns for backend subscription management and billing alignment. This value is system-generated, read-only, and not surfaced in standard UI workflows.
Subscription_HasPurchasedEmails	Bool	True	Indicates whether the subscription record is associated with purchased email-sending capacity. This value reflects backend subscription metadata and is not typically used in customer-facing operations.
Subscription_EmailsPurchased	Int	True	Specifies the number of email sends that the account has purchased as part of its subscription.
Subscription_Period	String	True	Specifies the subscription term that Salesforce Marketing Cloud records for internal billing and entitlement tracking. This value represents the period that is associated with the account's contracted services and is system-managed rather than used in customer-facing operations.
Subscription_AccountsPurchased	Int	True	Specifies the total number of Salesforce Marketing Cloud accounts that are included in the subscription.
Subscription_LPAccountsPurchased	Int	True	Specifies the number of Lock and Publish accounts that are purchased as part of the subscription.
Subscription_DOTOAccountsPurchased	Int	True	Specifies the number of Salesforce Marketing Cloud agency reseller accounts that are purchased for the subscription.
Subscription_BUAccountsPurchased	Int	True	Specifies the number of business units that are purchased for the subscription.
Subscription_AdvAccountsPurchased	Int	True	Specifies the number of advertising accounts that are included in the subscription.
Subscription_BeginDate	Datetime	True	Specifies the date when the subscription term begins.
Subscription_EndDate	Datetime	True	Specifies the date when the subscription term ends.
Subscription_Notes	String	True	[DEPRECATED] This field is no longer used.
PartnerKey	String	False	Specifies the unique partner-supplied Id for the account. This value is available only through the API.
Client_PartnerClientKey	String	True	Specifies the partner client key that is associated with the account within the partner integration.
InheritAddress	Bool	False	Specifies whether an Enterprise 2.0 business unit inherits its physical address information from its parent business unit.
UnsubscribeBehavior	Int	True	Specifies how the system handles unsubscribe actions for the account. The value determines the unsubscribe model that is applied.
Subscription_ContractNumber	String	True	Specifies the contract number that is associated with the subscription. This value is not currently exposed in Salesforce Marketing Cloud but is expected to represent a contractual reference Id that licensing and billing systems use for cross-system reconciliation.
Subscription_ContractModifier	String	True	Specifies an optional modifier value that is associated with the subscription contract.
IsTrialAccount	Bool	False	Indicates whether the account operates under a trial subscription. This field is not currently in active use but is expected to help distinguish trial environments from paid environments for entitlement and feature-availability logic.
Client_EnterpriseID	Long	True	Specifies the read-only Id of the enterprise to which the client belongs.
ParentAccount_ID	Int	False	Specifies the read-only Id of the account's parent within the hierarchy.
ParentAccount_Name	String	True	Specifies the name of the account's parent within the hierarchy.
ParentAccount_ParentID	Int	True	Specifies the read-only Id of the parent's parent account within the hierarchy.
ParentAccount_CustomerKey	String	True	Specifies the customer key for the parent account. The customer key uniquely identifies the parent account within its object type.
ParentAccount_AccountType	String	True	Specifies the account type of the parent account (for example, an enterprise or business unit account).
CustomerKey	String	False	Specifies the user-supplied unique Id for the account object within its object type.
Locale_LocaleCode	String	True	Specifies the locale code that is associated with the account's localization settings.
TimeZone_ID	Int	True	Specifies the read-only Id of the timezone that is assigned to the account.
TimeZone_Name	String	True	Specifies the descriptive name of the timezone that is assigned to the account.
Roles	String	False	Specifies the collection of roles that are assigned to the account for permission and access control.
ContextualRoles	Int	True	Specifies the contextual role assignments that are applied to the account based on feature usage or business unit context.
ObjectState	String	False	Specifies an internal state value that represents the account's current system-level condition. This field supports lifecycle tracking, such as indicating whether an account configuration is being provisioned, updated, or archived.
LanguageLocale_LocaleCode	String	True	Specifies the locale code that is associated with the language layout for the account.
IndustryCode	String	False	Specifies the industry classification code that is associated with the account.
AccountState	Int	False	Specifies the operational state of the account, such as active or inactive.
SubscriptionRestrictionFlags	Long	False	Specifies restriction settings that apply to the subscription. These flags control subscription-level limitations and operational constraints.