Returns CRM Company Relationship Module (Subsidiaries)

The following sample query returns all current subsidiaries and its headquarters of a parent company along with the total revenue reported and converted to USD of the subsidiary companies., Note: Change the parent companyId as needed, currently it runs for IBM. For current investment change the companyRelTypeId=1

Enhancement Date: 7/10/2021

  • SourceMarket Intelligence
  • Data Packages Required
    Base CompanyBase Data Item MasterBase Exchange RatesBase Foundation Company DailyFinancials Premium Intraday Cap Structure NAPubFinancials Premium Intraday CoreIntel Company Relationships
  • Associated Datasets
    Company RelationshipsS&P Capital IQ Financials

Query Types

  • MSSQL
  • Snowflake