Hi Frends,
As we know in TN from Transaction Analysis we do get al the details of transactions which have been taken place. I want to get the same results in the db as well. Could anyone specify what all tables I need to check to get all the transactions which takes place on a given day.

Why do you want to query backend tables when TA could provide all the data to you out of box.

Anyways here is the SQL (table info below) from the transaction analysis for Date Received (as Today selection)

SELECT
d.DocID,
d.DocTimestamp,
t.TypeName,
s.CorporationName AS SenderCorp,
s.OrgUnitName AS SenderUnit,
r.CorporationName AS ReceiverCorp,
r.OrgUnitName AS ReceiverUnit,
d.RoutingStatus,
d.UserStatus,
d.NativeID,
d.GroupID,
d.ConversationID
FROM
BizDocTypeDef t,
Partner s,
Partner r,
BizDoc d
WHERE
d.DocTypeID = t.TypeID AND
d.SenderID = s.PartnerID AND
d.ReceiverID = r.PartnerID
AND d.DocTimestamp > {ts ‘2013-08-29 00:00:00.0’} AND
d.DocTimestamp < {ts ‘2013-08-30 00:00:00.0’}
ORDER BY d.DocTimestamp DESC

HTH,
RMG

Hi RMG,
Thanks for swift response. Could you please tell me where did you get those details ?

TN & MWS is heavly depend on DB to get data and show you in customized way

You can see any results in MWS as you required. Once after creating your basic/Advanced search in MWS transaction tab, just cick on show sql button. you can see query that got created as per your requirements

From the TN Console–>Transactions–>View SQL tab

HTH,
RMG

Thanks RMG for your help !!!

your welcome: