Invenias Power BI: Company Relationships View

The Company Relationships view is a supporting view used to return the external ids for a Company entity.

This feature is used to document relationships between Company records such as “Parent, Child, etc”.

Columns

This view returns the following columns:

Column Name

Column Type

Remarks

Joins To

ParentId

Guid

 N/A

CompanyView

ParentCompanyType

String

Returns 'Parent', 'Investor', 'Partner', 'Client', 'Competitor' depending on the relation type

 N/A

ChildId

Guid

  

CompanyView

ChildCompanyType

String

Returns 'Subsidiary', 'Portfolio/Investment', 'Partner', 'Supplier', 'Competitor' depending on the relation type

 N/A

StartDate

DateTime

 N/A N/A

EndDate

DateTime

 N/A N/A

Note

String

 N/A N/A

CreatorId

Guid

 N/A

UserInformationView

DateCreated

DateTime

 N/A N/A

ModifierId

Guid

 N/A

UserInformationView

DateModified

DateTime

 N/A N/A

OwnerId

Guid

 N/A

UserInformationView