CustomerHierarchyColumnFlattenedExtractPVO
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. |
| Dep0CustPartyId | |
| Dep0PartyId | The unique identifier of the account at depth 0 in the hierarchy. This is a foreign key to Party view object. |
| Dep0PartyName | The name of the account at depth 0 in the hierarchy. |
| Dep0PartyNumber | The unique identification number for the account at depth 0 in the hierarchy. |
| Dep0PartyUniqueName | The unique name of the account at depth 0 in the hierarchy. |
| Dep0SalesAccountId | The unique identifier of the sales account at depth 0 in the hierarchy. |
| Dep1CustPartyId | |
| Dep1PartyId | The unique identifier of the account at depth 1 in the hierarchy. This is a foreign key to Party view object. |
| Dep1PartyName | The name of the account at depth 1 in the hierarchy. |
| Dep1PartyNumber | The unique identification number for the account at depth 1 in the hierarchy. |
| Dep1PartyUniqueName | The unique name of the account at depth 1 in the hierarchy. |
| Dep1SalesAccountId | The unique identifier of the sales account at depth 1 in the hierarchy. |
| Dep2CustPartyId | |
| Dep2PartyId | The unique identifier of the account at depth 2 in the hierarchy. This is a foreign key to Party view object. |
| Dep2PartyName | The name of the account at depth 2 in the hierarchy. |
| Dep2PartyNumber | The unique identification number for the account at depth 2 in the hierarchy. |
| Dep2PartyUniqueName | The unique name of the account at depth 2 in the hierarchy. |
| Dep2SalesAccountId | The unique identifier of the sales account at depth 2 in the hierarchy. |
| Dep3CustPartyId | |
| Dep3PartyId | The unique identifier of the account at depth 3 in the hierarchy. This is a foreign key to Party view object. |
| Dep3PartyName | The name of the account at depth 3 in the hierarchy. |
| Dep3PartyNumber | The unique identification number for the account at depth 3 in the hierarchy. |
| Dep3PartyUniqueName | The unique name of the account at depth 3 in the hierarchy. |
| Dep3SalesAccountId | The unique identifier of the sales account at depth 3 in the hierarchy. |
| Dep4CustPartyId | |
| Dep4PartyId | The unique identifier of the account at depth 4 in the hierarchy. This is a foreign key to Party view object. |
| Dep4PartyName | The name of the account at depth 4 in the hierarchy. |
| Dep4PartyNumber | The unique identification number for the account at depth 4 in the hierarchy. |
| Dep4PartyUniqueName | The unique name of the account at depth 4 in the hierarchy. |
| Dep4SalesAccountId | The unique identifier of the sales account at depth 4 in the hierarchy. |
| Dep5CustPartyId | |
| Dep5PartyId | The unique identifier of the account at depth 5 in the hierarchy. This is a foreign key to Party view object. |
| Dep5PartyName | The name of the account at depth 5 in the hierarchy. |
| Dep5PartyNumber | The unique identification number for the account at depth 5 in the hierarchy. |
| Dep5PartyUniqueName | The unique name of the account at depth 5 in the hierarchy. |
| Dep5SalesAccountId | The unique identifier of the sales account at depth 5 in the hierarchy. |
| Dep6CustPartyId | |
| Dep6PartyId | The unique identifier of the account at depth 6 in the hierarchy. This is a foreign key to Party view object. |
| Dep6PartyName | The name of the account at depth 6 in the hierarchy. |
| Dep6PartyNumber | The unique identification number for the account at depth 6 in the hierarchy. |
| Dep6PartyUniqueName | The unique name of the account at depth 6 in the hierarchy. |
| Dep6SalesAccountId | The unique identifier of the sales account at depth 6 in the hierarchy. |
| Dep7CustPartyId | |
| Dep7PartyId | The unique identifier of the account at depth 7 in the hierarchy. This is a foreign key to Party view object. |
| Dep7PartyName | The name of the account at depth 7 in the hierarchy. |
| Dep7PartyNumber | The unique identification number for the account at depth 7 in the hierarchy. |
| Dep7PartyUniqueName | The unique name of the account at depth 7 in the hierarchy. |
| Dep7SalesAccountId | The unique identifier of the sales account at depth 7 in the hierarchy. |
| Dep8CustPartyId | |
| Dep8PartyId | The unique identifier of the account at depth 8 in the hierarchy. This is a foreign key to Party view object. |
| Dep8PartyName | The name of the account at depth 8 in the hierarchy. |
| Dep8PartyNumber | The unique identification number for the account at depth 8 in the hierarchy. |
| Dep8PartyUniqueName | The unique name of the account at depth 8 in the hierarchy. |
| Dep8SalesAccountId | The unique identifier of the sales account at depth 8 in the hierarchy. |
| Dep9CustPartyId | |
| Dep9PartyId | The unique identifier of the account at depth 9 in the hierarchy. This is a foreign key to Party view object. |
| Dep9PartyName | The name of the account at depth 9 in the hierarchy. |
| Dep9PartyNumber | The unique identification number for the account at depth 9 in the hierarchy. |
| Dep9PartyUniqueName | The unique name of the account at depth 9 in the hierarchy. |
| Dep9SalesAccountId | The unique identifier of the sales account at depth 9 in the hierarchy. |
| 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. |
| ParentCustPartyId | |
| ParentDunsNumber | The unique nine-digit identification number that's assigned to business entities by Dun and Bradstreet for the parent account in the hierarchy. |
| ParentPartyId | The unique identifier of the parent account. This is a foreign key to the Party view object. |
| ParentPartyName | The name of the parent account in the hierarchy. |
| ParentPartyNumber | The unique identification number for the parent account in the hierarchy. |
| ParentPartyUniqueName | The unique name of the parent account in the hierarchy. |
| ParentSalesAccountId | The unique identifier of the parent sales account in the hierarchy. |
| 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. |