AccountFlattenedHierarchy

Represents a flattened, denormalized view of an account’s ancestor chain — up to 15 levels of parent accounts — so queries and reports can filter or group by any level of the hierarchy without recursively walking Account.ParentId. This object is available in API version 68.0 and later.

Supported Calls 

create(), delete(), describeLayout(), describeSObjects(), getDeleted(), getUpdated(), query(), retrieve(), search(), undelete(), update(), upsert()

Special Access Rules 

Available only in orgs with Manufacturing Cloud, Automotive Cloud, or Consumer Goods Cloud enabled, or with the relevant Account Hierarchy / B2B relationship features licensed.

Fields 

AccountId 

Type: reference

Properties: Create, Filter, Group, Sort, Update

Description: The account whose hierarchy is being flattened.

Relationship Name: Account

Refers To: Account

AccountLevel01Id – AccountLevel15Id 

Type: reference

Properties: Create, Filter, Group, Nillable, Sort, Update

Description: Fifteen parallel fields, one per hierarchy level, each holding the account ID of AccountId’s ancestor at that level (Level01 = immediate parent, up to Level15).

Relationship Name: AccountLevel01 … AccountLevel15 (one per field)

Refers To: Account

CurrencyIsoCode 

Type: picklist

Properties: Create, Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort, Update

Description: ISO code for the currency of this record. Possible values are: AED (UAE Dirham), USD (U.S. Dollar), and every other active currency ISO code configured for the org. The default value is USD.

ExecutionRefIdentifier 

Type: string

Properties: Create, Filter, Group, Nillable, Sort, Update

Description: Identifier for the batch/job execution that generated or last refreshed this flattened-hierarchy record.

InternalOrganizationUnitId 

Type: reference

Properties: Create, Filter, Group, Nillable, Sort, Update

Description: The internal organization unit this flattened hierarchy record applies to.

Relationship Name: InternalOrganizationUnit

Refers To: InternalOrganizationUnit

IsPromotionRole 

Type: boolean

Properties: Create, Defaulted on create, Filter, Group, Sort, Update

Description: Indicates whether AccountId holds a promotion-related role in this hierarchy. The default value is false.

IsStoreRole 

Type: boolean

Properties: Create, Defaulted on create, Filter, Group, Sort, Update

Description: Indicates whether AccountId holds a store role in this hierarchy. The default value is false.

LastReferencedDate 

Type: dateTime

Properties: Filter, Nillable, Sort

Description: Date on which a user last viewed a record related to this flattened-hierarchy record.

LastViewedDate 

Type: dateTime

Properties: Filter, Nillable, Sort

Description: Date on which a user last viewed this record.

Name 

Type: string

Properties: Autonumber, Defaulted on create, Filter, idLookup, Sort

Description: Auto-generated name for the flattened-hierarchy record.

NodeLevel 

Type: int

Properties: Create, Filter, Group, Nillable, Sort, Update

Description: The depth of AccountId within its hierarchy (number of ancestor levels populated).

OwnerId 

Type: reference

Properties: Create, Defaulted on create, Filter, Group, Sort, Update

Description: The user or queue that owns this record.

Relationship Name: Owner

Refers To: Group, User

Source 

Type: picklist

Properties: Create, Filter, Group, Nillable, Restricted picklist, Sort, Update

Description: The source object this flattened hierarchy was generated from. Possible values are Account and AccountAccountRelation.

UsageType 

Type: picklist

Properties: Create, Filter, Group, Restricted picklist, Sort, Update

Description: The usage context for this flattened hierarchy, for example, Retail.

Associated Objects 

This object has the following associated objects. If the API version isn’t specified, they’re available in the same API versions as this object. Otherwise, they’re available in the specified API version and later.

• AccountFlattenedHierarchyChangeEvent: Change events are available for the object.
• AccountFlattenedHierarchyFeed: Feed tracking is available for the object.
• AccountFlattenedHierarchyHistory: History is available for tracked fields of the object.
• AccountFlattenedHierarchyOwnerSharingRule: Sharing rules are available for the object.
• AccountFlattenedHierarchyShare: Sharing is available for the object.