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 companys
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>