Customer Hierarchy Column Flattened

This Column Flattened Customer Hierarchy VO stores the account hierarchy for sales accounts.

Data Store Key : CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.CustomerHierarchyColumnFlattenedExtractPVO

Primary Keys : PartyId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
CreatedBy	The user who created the account hierarchy row.
CreationDate	The date and time when the account hierarchy row was created.
Dep0PartyId	The unique identifier of the account at depth 0 in the hierarchy. This is a foreign key to Party view object.
Dep1PartyId	The unique identifier of the account at depth 1 in the hierarchy. This is a foreign key to Party view object.
Dep2PartyId	The unique identifier of the account at depth 2 in the hierarchy. This is a foreign key to Party view object.
Dep3PartyId	The unique identifier of the account at depth 3 in the hierarchy. This is a foreign key to Party view object.
Dep4PartyId	The unique identifier of the account at depth 4 in the hierarchy. This is a foreign key to Party view object.
Dep5PartyId	The unique identifier of the account at depth 5 in the hierarchy. This is a foreign key to Party view object.
Dep6PartyId	The unique identifier of the account at depth 6 in the hierarchy. This is a foreign key to Party view object.
Dep7PartyId	The unique identifier of the account at depth 7 in the hierarchy. This is a foreign key to Party view object.
Dep8PartyId	The unique identifier of the account at depth 8 in the hierarchy. This is a foreign key to Party view object.
Dep9PartyId	The unique identifier of the account at depth 9 in the hierarchy. This is a foreign key to Party view object.
Distance	The distance from the top level in the hierarchy for the account. The top level account will have distance 0, the next level will have distance 1, and so on. The maximum distance is 9.
FixedHierarchyLevel	The level or depth of the account in the hierarchy with 10 being the highest level supported. The party identifier of the account will be repeated in the hierarchy columns (Dep0PartyId,Dep1PartyId...) for depths below this value.
LastUpdateDate	The date and time when the account hierarchy row was last updated.
LastUpdatedBy	The user who last updated the account hierarchy row.
ParentPartyId	The unique identifier of the parent account. This is a foreign key to the Party view object.
PartyId	The unique identifier of the hierarchy row. This is a foreign key to the Party view object.
PartyLastUpdateDate	The date and time when the party was last updated.
TreeCode	The user defined Identifier for tree code.
TreeStructureCode	The unique Identifier for a tree structure.
TreeVersionId	The unique Identifier for the tree version.