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 Supported Symbols:
SDC CIDGEN Permissioning:
Dataworks Enterprise login
required Request
Syntax M&A Listings: Syntax: Examples: M&A Detail: Syntax: Example: M&A Detail drill-down JV Deals Listings: Syntax: Examples: JV Detail: Syntax: Examples: League Tables Syntax: Examples: AD1 � Financial Advisor - Worldwide Announced (Year to last full
quarter) AE1 � Legal Advisor - Worldwide Announced (Year to date) AE1 � Legal Advisor - Worldwide Announced (Year to last full quarter) AF1 � Financial Advisor - Worldwide Completed (Year to date) AF1 � Financial Advisor - Worldwide Completed (Year to last full
quarter) AG1 � Legal Advisor - Worldwide Completed (Year to date) AG1 � Legal Advisor - Worldwide Completed (Year to last full quarter) Sample
Response Sample response for M&A Listings: - <Record xmlns="http://xml.thomson.com/financial/v1/tools/distribution/dataworks/enterprise/2003-07/">Deals
JV: Daily (Sun-Fri) by 1:00a
REQID=MA_LISTING {[[ACQUIROR=cidgen] [TARGET=cidgen]] | [PARTICIPANT=cidgen]
} [CREATE_STAMP_START=yyyymmdd CREATE_STAMP_END= yyyymmdd] [STATUSCODE=value]
[COUNT=number]
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
REQID=MA_DETAIL DEAL_NO=value DEAL_TYPE=value
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)
REQID=JV_LISTING PARTICIPANT=cidgen [DATEANN_START= yyyymmdd DATEANN_END=
yyyymmdd] [STATUSCODE=value] [COUNT=number]
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
REQID=JV_ DETAIL DEAL_NO=value
REQID=JV_DETAIL DEAL_NO=1618289045
(Where DEAL_NO is from results of the above JV deal listing)
REQID=LEAGUE_TBLS TABLE=value TABLE_VERSION=value
AD1 � Financial Advisor - Worldwide Announced (Year to date)
REQID=LEAGUE_TBLS
TABLE=worldwide_announced_advisor_ranking__ad1_.ytd.2 TABLE_VERSION=FR_tdma5
REQID=LEAGUE_TBLS TABLE=worldwide_announced_advisor_ranking__ad1_.ytq.2
TABLE_VERSION=FR_tdma5
REQID=LEAGUE_TBLS
TABLE=worldwide_announced_legal_ranking__ae1_.ytd.3 TABLE_VERSION=FR_tdma3
REQID=LEAGUE_TBLS
TABLE=worldwide_announced_legal_ranking__ae1_.ytq.3 TABLE_VERSION=FR_tdma3
REQID=LEAGUE_TBLS
TABLE=worldwide_completed_advisor_ranking__af1_.ytd.4 TABLE_VERSION=FR_tdma5
REQID=LEAGUE_TBLS TABLE=worldwide_completed_advisor_ranking__af1_.ytq.4
TABLE_VERSION=FR_tdma5
REQID=LEAGUE_TBLS
TABLE=worldwide_law_firm_completed_ranking__ag1_.ytd.5 TABLE_VERSION=FR_tdma2
REQID=LEAGUE_TBLS
TABLE=worldwide_law_firm_completed_ranking__ag1_.ytq.5 TABLE_VERSION=FR_tdma2
<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>