Deals

Last updated: 5/09/05

This collection tracks issuance of all types of capital raising securities and M&A activity. TF has comprehensive information from the company�s inception, through the IPO, to debt financing, to any mergers or acquisition activity and onto bankruptcy, if applicable. Worldwide mergers, acquisitions and alliances covers approximately 182k US M&As from 1977 to present, 292k international M&As from 1985 to present and more than 103k worldwide joint ventures and strategic alliances. 

 Overview

Source name:                      Deals                        

Update Frequency:             M&A: Daily (M-Th) by 12:00p; (Fri) by 9:00a
                                             JV: Daily (Sun-Fri) by 1:00a

Supported Symbols:            SDC CIDGEN

Permissioning:                        Dataworks Enterprise login required 

Request Syntax

M&A Listings:

Syntax:
REQID=MA_LISTING {[[ACQUIROR=cidgen] [TARGET=cidgen]] | [PARTICIPANT=cidgen] } [CREATE_STAMP_START=yyyymmdd CREATE_STAMP_END= yyyymmdd] [STATUSCODE=value] [COUNT=number]

Examples:
Latest 5 M&A Deals Listing: (for MSFT - CIDGEN=3931001)

REQID=MA_LISTING ACQUIROR=3931001 COUNT=5
REQID=MA_LISTING TARGET=3931001 COUNT=5
REQID=MA_LISTING PARTICIPANT=5400001 COUNT=5

M&A Detail:

Syntax:
REQID=MA_DETAIL DEAL_NO=value DEAL_TYPE=value

Example: M&A Detail drill-down
REQID=MA_DETAIL DEAL_NO=1588085020 DEAL_TYPE=MA
(Where DEAL_NO and DEAL_TYPE are from results of the above M&A deal listing)

JV Deals Listings:

Syntax:
REQID=JV_LISTING PARTICIPANT=cidgen [DATEANN_START= yyyymmdd DATEANN_END= yyyymmdd] [STATUSCODE=value] [COUNT=number]

Examples:
Latest 5 JV Deals Listing: (for MSFT - CIDGEN=3931001)
REQID=JV_LISTING PARTICIPANT=3931001 COUNT=5
REQID=JV_LISTING PARTICIPANT=3931001 DATEANN_START=20040101 DATEANN_END=20041001 STATUSCODE=C COUNT=3

JV Detail:

Syntax:
REQID=JV_ DETAIL DEAL_NO=value

Examples:
REQID=JV_DETAIL DEAL_NO=1618289045
(Where DEAL_NO is from results of the above JV deal listing)

League Tables

Syntax:
REQID=LEAGUE_TBLS TABLE=value TABLE_VERSION=value

Examples:
AD1 � Financial Advisor - Worldwide Announced (Year to date)

REQID=LEAGUE_TBLS TABLE=worldwide_announced_advisor_ranking__ad1_.ytd.2 TABLE_VERSION=FR_tdma5

AD1 � Financial Advisor - Worldwide Announced (Year to last full quarter)
REQID=LEAGUE_TBLS TABLE=worldwide_announced_advisor_ranking__ad1_.ytq.2 TABLE_VERSION=FR_tdma5

AE1 � Legal Advisor - Worldwide Announced (Year to date)
REQID=LEAGUE_TBLS TABLE=worldwide_announced_legal_ranking__ae1_.ytd.3 TABLE_VERSION=FR_tdma3

AE1 � Legal Advisor - Worldwide Announced (Year to last full quarter)
REQID=LEAGUE_TBLS TABLE=worldwide_announced_legal_ranking__ae1_.ytq.3 TABLE_VERSION=FR_tdma3

AF1 � Financial Advisor - Worldwide Completed (Year to date)
REQID=LEAGUE_TBLS TABLE=worldwide_completed_advisor_ranking__af1_.ytd.4 TABLE_VERSION=FR_tdma5

AF1 � Financial Advisor - Worldwide Completed (Year to last full quarter)
REQID=LEAGUE_TBLS TABLE=worldwide_completed_advisor_ranking__af1_.ytq.4 TABLE_VERSION=FR_tdma5

AG1 � Legal Advisor - Worldwide Completed (Year to date)
REQID=LEAGUE_TBLS TABLE=worldwide_law_firm_completed_ranking__ag1_.ytd.5 TABLE_VERSION=FR_tdma2

AG1 � Legal Advisor - Worldwide Completed (Year to last full quarter)
REQID=LEAGUE_TBLS TABLE=worldwide_law_firm_completed_ranking__ag1_.ytq.5 TABLE_VERSION=FR_tdma2 

Sample Response

Sample response for M&A Listings:

- <Record xmlns="http://xml.thomson.com/financial/v1/tools/distribution/dataworks/enterprise/2003-07/">
  <Source>Deals</Source>
  <Instrument>REQID=MA_LISTING ACQUIROR=3931001 COUNT=5</Instrument>
  <Tag />
  <StatusType>Connected</StatusType>
  <StatusCode>0</StatusCode>
  <StatusMessage />
- <Fields>
  <XML><qapirequest><dburl name="ny2" tablespace="qapi">jdbc:oracle:thin:qapiqrtabs/qapiqrtabs@(DESCRIPTION =(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.24.24.25)(PORT=1521)) )(CONNECT_DATA=(SID=IBD2B)(SERVER=DEDICATED)))</dburl><request status="0" requestid="2128381" jointype="rulejoinin" hint="rule" statistics="false" billable="false" validatelookup="false" /><database status="0" /><query status="0" tablename="QAPI2128381_1" resultid="1" result="myresult"><select dataitem="acidgen"><listvalue>3931001</listvalue></select></query><extract status="0" result="result2" resultid="2" tablename="QAPI2128381_2" type="table" reportdefinition="custom"></extract><extract status="0" type="report" reportdefinition="standard" reportname="dwe_harbor_ma_deal_list" outputformat="tree" columnheadings="false" preserveorder="true" start="1" count="5"><line id="1"><CREATE_STAMP>20050311</CREATE_STAMP><DATAWORKS_DATE>20050310</DATAWORKS_DATE><AN>Microsoft Corp</AN><TN>Groove Networks Inc</TN><STATUS>Completed</STATUS><RANK_RANKVAL>0</RANK_RANKVAL><ATTITUDE>Friendly</ATTITUDE><MASTER_DEAL_NO>1649476020</MASTER_DEAL_NO><MASTER_DEAL_TYPE>MA</MASTER_DEAL_TYPE><otm00><TLEGAL>DLA Piper Rudnick Gray Cary LLP</TLEGAL></otm00><otm10><ALEGAL/></otm10></line><line id="2"><CREATE_STAMP>20050209</CREATE_STAMP><DATAWORKS_DATE>20050208</DATAWORKS_DATE><AN>Microsoft Corp</AN><TN>Sybari Software Inc </TN><STATUS>Pending</STATUS><RANK_RANKVAL>0</RANK_RANKVAL><ATTITUDE>Friendly</ATTITUDE><MASTER_DEAL_NO>1638069020</MASTER_DEAL_NO><MASTER_DEAL_TYPE>MA</MASTER_DEAL_TYPE><otm00><TLEGAL>Proskauer Rose LLP</TLEGAL></otm00><otm10><ALEGAL/></otm10></line><line id="3"><CREATE_STAMP>20041217</CREATE_STAMP><DATAWORKS_DATE>20041216</DATAWORKS_DATE><AN>Microsoft Corp</AN><TN>GIANT Co Software Inc</TN><STATUS>Completed</STATUS><RANK_RANKVAL>0</RANK_RANKVAL><ATTITUDE>Friendly</ATTITUDE><MASTER_DEAL_NO>1625428020</MASTER_DEAL_NO><MASTER_DEAL_TYPE>MA</MASTER_DEAL_TYPE><otm00><TLEGAL/></otm00><otm10><ALEGAL/></otm10></line><line id="4"><CREATE_STAMP>20040721</CREATE_STAMP><DATAWORKS_DATE>20040720</DATAWORKS_DATE><AN>Microsoft Corp</AN><TN>Microsoft Corp</TN><STATUS>Intended</STATUS><RANK_RANKVAL>30000</RANK_RANKVAL><ATTITUDE>Not Appl.</ATTITUDE><MASTER_DEAL_NO>1588085020</MASTER_DEAL_NO><MASTER_DEAL_TYPE>MA</MASTER_DEAL_TYPE><otm00><TLEGAL/></otm00><otm10><ALEGAL/></otm10></line><line id="5"><CREATE_STAMP>20040721</CREATE_STAMP><DATAWORKS_DATE>20040719</DATAWORKS_DATE><AN>Microsoft Corp</AN><TN>Jiangmin New Science Tech</TN><STATUS>Dis Rumor</STATUS><RANK_RANKVAL>0</RANK_RANKVAL><ATTITUDE>Not Appl.</ATTITUDE><MASTER_DEAL_NO>1588050040</MASTER_DEAL_NO><MASTER_DEAL_TYPE>IMA</MASTER_DEAL_TYPE><otm00><TLEGAL/></otm00><otm10><ALEGAL/></otm10></line></extract></qapirequest></XML>
  </Fields>
  </Record>