Start Time : 07/08/2024 10:32:16 Get IviewObj from Cache, User: rekhancia Role: Loading iview.aspx before post back (get and set parameters) Get Iview Parameters Call to GetParams Web Service ASB XE3/32/64 DLL running [Compiled on 31/07/2024 1:02:00 PM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(260724)] DB Manager created Current ASB DLL folder : E:\Axpert113\Axpert Web\AxpertWebScripts Connecting to project : trustlineuat Connecting to project found : -1 Session key validation Session key validation completed Db Manager Connection starts Db Manager Connection XML receied : dbPostgredbxlocalhosttrustlineuat\trustlineuat creating connection starts... creating connection end... creating date xds... creating date xds end... PostGreConnect starts... PostGreConnect ends... db user : trustlineuat Select now() as sdt Time elapsed = 2 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 4 axprops xml = images\Agile-TrustLine-UATINR1FFFsmtp.office365.com587portalneo@trustlineindia.com01trust@123*100000FF SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 uXDS\dopen\ Check intransaction Time elapsed = 3 Db Manager Connection ends Connection to DB Successful Executing GetParamsNew webservice ---------------------------------- Received XML + dbPostgredbxlocalhosttrustlineuat\trustlineuattrustlineuataxdefdd/mm/yyyy hh24:mi:ssadminlocalBlackENGLISHtruet\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir\\10.16.248.2\UAT_Attachment\UAT_TLReports\\10.16.248.2\UAT_Attachment\UAT_TLBusiness1025660000000FrekhanciadefaultdefaultFfevgag5szj4b24cs5phvx0utdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*8/7/2024 10:29:20 am*-2592002218~~9867~25~0~0~1~R~false~RccccncccccE:\Axpert113\Axpert Web\AxpertWebScripts Registering app/user variables for the session Registering DBMem variables Registering DBMem variables completed Registering ConfigParam variables Registering ConfigParam variables completed auth_path=E:\Axpert113\Axpert Web\AxpertWebScripts axp_clientlocale=en-us*asia/calcutta^english*8/7/2024 10:29:20 am*-2592002218 axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=fevgag5szj4b24cs5phvx0ut ax_evalcopy=F rolename=default responsibilies=default millions=F axpimageserver= axglo_hide= axp_displaytext= axglo_user= fromuserlogin= axglo_recordid=1025660000000 axpimagepath= AxpServerPath=\\10.16.248.2\UAT_Attachment\UAT_TLBusiness AxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports AxpDbDirPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir LStr : ~~9867~25~0~0~1~R~false~R LReg Type : R User Group default User Roles default Registering app/user variables for the session completed select sessionid from connections where sessionid = :sesid uXDS\dopen\ Check intransaction Time elapsed = 3 Sql : select props from iviews where lower(name)= :name order by blobno Paramval : cldocvie ParamTYpe : c Param List : name select props from iviews where lower(name)= :name order by blobno uXDS\dopen\ Check intransaction Time elapsed = 2 Step5 select count(*) recno from (select a.* from ( select a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T' order by a.createdon desc )a) aa Time elapsed = 0 Sql after pagination change :select a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T' order by a.createdon desc LIMIT 100 Opening Query select a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T' order by a.createdon desc LIMIT 100 Time elapsed = 16 CDS Record Count : 2 Evaluating {PMS} Result = PMS Param Name : pfundcode Param Type : C Param Value : PMS select count(*) recno from (select a.* from ( Select distinct a1.fund_code from fund_scheme_details a1 where a1.cancel = 'F' and a1.active = 'T' order by 1 )a) aa Time elapsed = 0 Sql after pagination change :Select distinct a1.fund_code from fund_scheme_details a1 where a1.cancel = 'F' and a1.active = 'T' order by 1 LIMIT 100 Opening Query Select distinct a1.fund_code from fund_scheme_details a1 where a1.cancel = 'F' and a1.active = 'T' order by 1 LIMIT 100 Time elapsed = 0 CDS Record Count : 2 Evaluating {Intrinsic} Result = Intrinsic Param Name : pschemecode Param Type : C Param Value : Intrinsic CDS Param Name : pfundcode CDS Param Type : c CDS Param Value : PMS pfundcode=PMS select count(*) recno from (select a.* from ( select a.scheme_code from fund_scheme_details a where a.fund_code = :pfundcode and a.active = 'T' and a.cancel = 'F' order by 1 )a) aa pfundcode=PMS Time elapsed = 0 Sql after pagination change :select a.scheme_code from fund_scheme_details a where a.fund_code = :pfundcode and a.active = 'T' and a.cancel = 'F' order by 1 LIMIT 100 Opening Query select a.scheme_code from fund_scheme_details a where a.fund_code = :pfundcode and a.active = 'T' and a.cancel = 'F' order by 1 LIMIT 100 pfundcode=PMS Time elapsed = 0 CDS Record Count : 2 Evaluating {Transaction Report} Result = Transaction Report Param Name : preporttype Param Type : C Param Value : Transaction Report CDS Param Name : pfundcode CDS Param Type : c CDS Param Value : PMS pfundcode=PMS CDS Param Name : pschemecode CDS Param Type : c CDS Param Value : Intrinsic pschemecode=Intrinsic select count(*) recno from (select a.* from ( select unnest(string_to_array(b.report_type, ',')) as reporttype from fund_scheme_details b where b.fund_code = :pfundcode and b.scheme_code = :pschemecode order by 1 )a) aa pfundcode=PMS pschemecode=Intrinsic Time elapsed = 0 Sql after pagination change :select unnest(string_to_array(b.report_type, ',')) as reporttype from fund_scheme_details b where b.fund_code = :pfundcode and b.scheme_code = :pschemecode order by 1 LIMIT 100 CDS Param Name : pfundcode CDS Param Type : c CDS Param Value : PMS CDS Param Name : pschemecode CDS Param Type : c CDS Param Value : Intrinsic Opening Query select unnest(string_to_array(b.report_type, ',')) as reporttype from fund_scheme_details b where b.fund_code = :pfundcode and b.scheme_code = :pschemecode order by 1 LIMIT 100 pfundcode=PMS pschemecode=Intrinsic Time elapsed = 3 CDS Record Count : 3 Evaluating AxpAttachmentPath AxpAttachmentPath = \\10.16.248.2\UAT_Attachment\UAT_TLReports Result = \\10.16.248.2\UAT_Attachment\UAT_TLReports Param Name : mAxpAttachmentPath Param Type : C Param Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Evaluating usergroup usergroup = default Result = default Param Name : paxusergroup Param Type : C Param Value : default Evaluating username username = rekhancia Result = rekhancia Param Name : pusername Param Type : C Param Value : rekhancia CDS Param Name : pusername CDS Param Type : c CDS Param Value : rekhancia pusername=rekhancia CDS Param Name : paxusergroup CDS Param Type : c CDS Param Value : default paxusergroup=default select count(*) recno from (select a.* from ( select a.client_name as choice from client_details a where a.active = 'T' and a.cancel = 'F' and (a.primary_emailid = :pusername or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%') union select 'ALL' as choice from dual order by 1 )a) aa pusername=rekhancia paxusergroup=default paxusergroup=default Time elapsed = 8 Sql after pagination change :select a.client_name as choice from client_details a where a.active = 'T' and a.cancel = 'F' and (a.primary_emailid = :pusername or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%') union select 'ALL' as choice from dual order by 1 LIMIT 100 CDS Param Name : pusername CDS Param Type : c CDS Param Value : rekhancia CDS Param Name : paxusergroup CDS Param Type : c CDS Param Value : default Opening Query select a.client_name as choice from client_details a where a.active = 'T' and a.cancel = 'F' and (a.primary_emailid = :pusername or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%') union select 'ALL' as choice from dual order by 1 LIMIT 100 pusername=rekhancia paxusergroup=default paxusergroup=default Time elapsed = 6 CDS Record Count : 65 select username , config_data from axp_smartviews_config where ivname = 'cldocvie' Time elapsed = 3 GetSmartViewSettings Result : Select cvalue from axpconfigsiv_cldocvie where configname= 'groupbtns' CDS Open Error Msg : csd query : Select cvalue from axpconfigsiv_cldocvie where configname= 'groupbtns' $ Error msg : relation "axpconfigsiv_cldocvie" does not exist uXDS\open\ Exceptio relation "axpconfigsiv_cldocvie" does not exist Creating runtime menu Created runtime menu Global vars in Params :{"globalVars":[{"n":"AxpAttachmentPath","v":"\\10.16.248.2\UAT_Attachment\UAT_TLReports"},{"n":"username","v":"rekhancia"}]} Result :Task1pfinancialyearFinancial YearCharacterfalsefalseselect a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T' order by a.createdon desc0truefalseSelect325false2024-252023-24Task1pfundcodeFund CodeCharacterfalse{PMS}false Select distinct a1.fund_code from fund_scheme_details a1 where a1.cancel = 'F' and a1.active = 'T' order by 1 0truefalseSelect~~pschemecode,preporttype~~325falseAIF1PMSTask1pschemecodeScheme CodeCharacterfalse{Intrinsic}falseselect a.scheme_code from fund_scheme_details a where a.fund_code = :pfundcode and a.active = 'T' and a.cancel = 'F' order by 1 0truefalseSelect~~preporttype~~325falseFloaterIntrinsicTask1preporttypeReport TypeCharacterfalse{Transaction Report}falseselect unnest(string_to_array(b.report_type, ',')) as reporttype from fund_scheme_details b where b.fund_code = :pfundcode and b.scheme_code = :pschemecode order by 1 0truefalseSelect325falseCapital Gain ReportPerformance ReportTransaction ReportTask1mAxpAttachmentPathGlobal File PathCharacterfalseAxpAttachmentPathtrue0truefalseAccept325falseTask1paxusergroupUser RolesCharacterfalseusergrouptrue0truefalseAccept~~pclientname~~325falseTask1pusernameUser NameCharacterfalseusernametrue0truefalseAccept~~pclientname~~325falseTask1pclientnameClient NameCharacterfalsefalseselect a.client_name as choice from client_details a where a.active = 'T' and a.cancel = 'F' and (a.primary_emailid = :pusername or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%') union select 'ALL' as choice from dual order by 10truefalseSelect325falseA R ChitraAkhil VishwanathamALLAmitabh PrasadAnjalidevi RAnnapoorna JAnudita PrasadAravamudhan RajeshAravindan RAruna AruldassB S VijayanandBalaji DhandapaniBalaraman Kuppuswamy Jt Suguna BalaramanBharat TannaC V KamathCorporate testingDeepa Deepak DesaiEshwari Ravindran Ashok KumarGomathi UlaganathanGovind Krishnan Jt Chitra GovindInbaraj RajakumarJanardhanan ShankarJayalakshmi TKalyan Raman Bangalore Janakiraman Jt Nishita Meenakshi KumarKosala Raman Bangalore JanakiramanKrithiga RameshKumaran KandasamyLakshmi PrabhaManohar ChandrasekharMathew K EraliMythri AssociatesN A SomasundariN Rajadurai Jt Mahalakshmi BNaithrav SrinivasanNaozer Cusrow DalalNaozer Cusrow Dalal 1Padmapriya V Jt Sathyanarayanan N BPadmashri KodivalasaPallipattu Srinivasa Lakshmi Narasa ReddyPradeep C RPranav Aditya C P Jt Vikram Adithya C PPrasad Venkatesh BhattPravin Damodar Karve Jt Vaishali Pravin KarveR JayasowmyaRamamurthy PRamanan CRamesh Babu C GS Aramuthan HUFS G Anjana ShankarS N Damani Realty Investors LLPSaravanan Krishnamoorthy MusuvathiShanmugavalli ChandrasekaranSridevi Prasanna Jt Prasanna RamanujamSrikanth NSrikanth NarasimhanSrinivas Mani KolipakkamSrinivasa Raghavan SSubbulakshmi VagulaparananSubhadip SarkarSukanya Misra Jt Praphulla MisraT K Govinda RajanThirukkumaran NagarajanUsha Ratnakumari RajakumarVenkat Ravi ShankarVenkata Raghavan S K SELECT A.STYPE,A.STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'SINGLE' as APPLYON FROM axpstructconfig a, axuserlevelgroups b WHERE A.USERROLES IN ('default') AND B.AXUSERNAME = :uname AND lower(a.stype) = :structure_type AND A.STRUCTNAME not in('ALL Reports','ALL Forms') UNION SELECT A.STYPE,A.STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'SINGLE' as APPLYON FROM axpstructconfig a WHERE coalesce(USERROLES, 'ALL') = 'ALL' AND lower(a.stype) = :structure_type AND structname = :sname AND A.STRUCTNAME not in('ALL Reports','ALL Forms') UNION SELECT A.STYPE, :sname STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'ALL' as APPLYON FROM axpstructconfig a, axuserlevelgroups b WHERE A.USERROLES IN ('default') AND B.AXUSERNAME = :uname AND lower(a.stype) = :structure_type AND A.STRUCTNAME in('ALL Reports','ALL Forms') UNION SELECT A.STYPE, :sname STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'ALL' as APPLYON FROM axpstructconfig a WHERE coalesce(USERROLES, 'ALL') = 'ALL' AND lower(a.stype) = :structure_type AND A.STRUCTNAME in('ALL Reports','ALL Forms') order by STYPE,STRUCTNAME,PROPS,APPLYON DESC uname=rekhancia structure_type=iview structure_type=iview sname=cldocvie sname=cldocvie uname=rekhancia structure_type=iview sname=cldocvie structure_type=iview Time elapsed = 15 GetParamsNew webservice completed # 1#Saving to log insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('fevgag5szj4b24cs5phvx0ut','rekhancia',to_timestamp('07/08/2024 10:32:16','dd/mm/yyyy hh24:mi:ss'),to_timestamp('07/08/2024 10:32:16','dd/mm/yyyy hh24:mi:ss'),null,0,'Getting IView Params New','success',328,65,0) uXDS\pinsert\ Check intransaction Closing connection Freeing AxProvider Resources Freeing DbManager Resources Destroying Default xds in db manager Destroying connect object Disconnecting from db trustlineuat Keep Connection setting false Disconnecting... Disconnected... Dbx name = ConnectionName = DriverName = GetDriverFunc = LibraryName = VendorLib = Successfully disconnected from db trustlineuat Destroyed connect object Destroying GF Loading and setting parameters components Loading and setting parameters components completed End Time : 07/08/2024 10:32:16 Loading iview.aspx after post back (get and load iview data) Get and Load Iviewdata Call to GetIView Web Service for page no 1 ASB XE3/32/64 DLL running [Compiled on 31/07/2024 1:02:00 PM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(260724)] DB Manager created Current ASB DLL folder : E:\Axpert113\Axpert Web\AxpertWebScripts Connecting to project : trustlineuat Connecting to project found : -1 Session key validation Session key validation completed Db Manager Connection starts Db Manager Connection XML receied : dbPostgredbxlocalhosttrustlineuat\trustlineuat creating connection starts... creating connection end... creating date xds... creating date xds end... PostGreConnect starts... PostGreConnect ends... db user : trustlineuat Select now() as sdt Time elapsed = 2 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 3 axprops xml = images\Agile-TrustLine-UATINR1FFFsmtp.office365.com587portalneo@trustlineindia.com01trust@123*100000FF SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 uXDS\dopen\ Check intransaction Time elapsed = 3 Db Manager Connection ends Connection to DB Successful Executing GetIViewNew webservice --------------------------------- Received XML : 2023-24PMSIntrinsicTransaction Report\\10.16.248.2\UAT_Attachment\UAT_TLReportsdefaultrekhanciaN A SomasundaridbPostgredbxlocalhosttrustlineuat\trustlineuattrustlineuataxdefdd/mm/yyyy hh24:mi:ssadminlocalBlackENGLISHtruet\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir\\10.16.248.2\UAT_Attachment\UAT_TLReports\\10.16.248.2\UAT_Attachment\UAT_TLBusiness1025660000000FrekhanciadefaultdefaultFfevgag5szj4b24cs5phvx0utdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*8/7/2024 10:29:20 am*-2592002218~~9867~25~0~0~1~R~false~RccccncccccE:\Axpert113\Axpert Web\AxpertWebScripts Registering app/user variables for the session Registering DBMem variables Registering DBMem variables completed Registering ConfigParam variables Registering ConfigParam variables completed auth_path=E:\Axpert113\Axpert Web\AxpertWebScripts axp_clientlocale=en-us*asia/calcutta^english*8/7/2024 10:29:20 am*-2592002218 axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=fevgag5szj4b24cs5phvx0ut ax_evalcopy=F rolename=default responsibilies=default millions=F axpimageserver= axglo_hide= axp_displaytext= axglo_user= fromuserlogin= axglo_recordid=1025660000000 axpimagepath= AxpServerPath=\\10.16.248.2\UAT_Attachment\UAT_TLBusiness AxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports AxpDbDirPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir LStr : ~~9867~25~0~0~1~R~false~R LReg Type : R User Group default User Roles default Registering app/user variables for the session completed select sessionid from connections where sessionid = :sesid uXDS\dopen\ Check intransaction Time elapsed = 0 >>Reading defintion - cldocvie Initializing Report Preparing SQL statements Assigning values to IView parameters pfinancialyear(c)=2023-24 pfinancialyear=2023-24 mAxpAttachmentPath(c)=\\10.16.248.2\UAT_Attachment\UAT_TLReports mAxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports mAxpAttachmentPath(c)=\\10.16.248.2\UAT_Attachment\UAT_TLReports pfundcode(c)=PMS pfundcode=PMS pschemecode(c)=Intrinsic pschemecode=Intrinsic preporttype(c)=Transaction Report preporttype=Transaction Report pfinancialyear(c)=2023-24 pusername(c)=rekhancia pusername=rekhancia paxusergroup(c)=default paxusergroup=default paxusergroup(c)=default pclientname(c)=N A Somasundari pclientname=N A Somasundari pclientname(c)=N A Somasundari Creating Columns Creating Columns for first time Creating financial_yearcode Creating financialyear_code Creating miles_account_code Creating ucc_code Creating client_code Creating fund_code Creating scheme_code Creating report_type Creating subreport_type Creating document_shortdescription Creating client_name Creating mfundcode Creating docid Creating axzipfilepath Creating axzipfiles Creating axzipfilename Creating recordid Creating date_published Creating axpfilepath_documentupload Creating axpfile_documentupload Creating filedocumentupload Creating axp_emailfrom Creating axp_emailto Creating axp_emailsub Creating axp_emailcc Creating axp_emailbcc Creating axpemailtemplate Creating email Creating Columns for first time completed select a1.documents_segregationid recordid, :pfinancialyear as financial_yearcode, a2.date_published, a2.financialyear_code, a2.fund_code as mfundcode, :mAxpAttachmentPath as axpfilepath_documentupload, a1.axpfile_documentupload, 'download' as filedocumentupload, a2.docid as docid, a1.miles_account_code, a1.client_code||'-'||a3.client_name as client_code, a1.ucc_code, a3.client_name, a2.fund_code, a2.scheme_code, a2.report_type, a2.subreport_type, :mAxpAttachmentPath as AxZIPFilePath, a1.axpfile_documentupload as AxZIPFiles, concat(a1.miles_account_code, '-', a2.report_type ,'-', current_date) as AxZipFileName, a2.document_shortdescription, 'rekhancia@agile-labs.com' as Axp_EMailFrom, a3.primary_emailid as Axp_EMailTo,concat('Trustline PMS App : ','FY ', a2.fincode,' ', a2.notation, ' ', a2.subreport_type,' ', a2.scheme_code) as Axp_EMailSub, a3.cc_mailid1 as Axp_EMailCC, a3.cc_mailid2 as Axp_EMailBCC , (select concat(replace(caption, ' ', '_'), '_', replace(name, 'HP', ''), '.html') as htmlfilename from axpages where lower(caption) = lower('emailrepTransactionreport') and name like 'HP%') as AxpEmailTemplate,'Email' as Email from documents_segregation a1, (select a2.*, a3.financialyear_code as fincode, a3.financialyear_startdate, a3.financialyear_enddate from documents_uploads a2, financial_years a3 where a2.cancel = 'F' and a2.active = 'T' and ((current_date BETWEEN a2.validity_datefrom and a2.validity_dateto) or (a2.validity_datefrom <= current_date and a2.validity_dateto is null)) and ( :pfundcode like '%'|| a2.fund_code||'%' ) and ( :pschemecode like '%'|| a2.scheme_code||'%') and ( :preporttype like '%'|| a2.report_type||'%') and a2.financialyear_code = a3.financial_yearsid and a3.financialyear_code = :pfinancialyear ) a2, client_details a3 where a1.docid = a2.documents_uploadsid and a1.client_code = a3.client_code and a2.cancel = 'F' and a1.active = 'T' and lower(a1.client_code) not like 'invalid%' and (a3.primary_emailid = :pusername or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%') and (a3.client_name = :pclientname or :pclientname = 'ALL') order by a1.miles_account_code,a1.createdon,a2.date_published desc LIMIT 25 pfinancialyear=2023-24 mAxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports mAxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports pfundcode=PMS pschemecode=Intrinsic preporttype=Transaction Report pfinancialyear=2023-24 pusername=rekhancia paxusergroup=default paxusergroup=default pclientname=N A Somasundari pclientname=N A Somasundari Time elapsed = 30 Time elapsed = 31 Copying result to grid Row 1 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction March document_shortdescription = Transaction March client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400079 docid = PMS2023-2400079 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_March_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_March_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108997 recordid = 108997 date_published = 01/04/2024 date_published = 01/04/2024 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_March_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_March_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 March Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 March Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No1 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction March Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400079 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_March_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108997 Column Name : date_published Column Value : 01/04/2024 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_March_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 March Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 2 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction January document_shortdescription = Transaction January client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400025 docid = PMS2023-2400025 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_January_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_January_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108481 recordid = 108481 date_published = 15/03/2024 date_published = 15/03/2024 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_January_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_January_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 January Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 January Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No2 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction January Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400025 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_January_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108481 Column Name : date_published Column Value : 15/03/2024 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_January_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 January Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 3 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction February document_shortdescription = Transaction February client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400049 docid = PMS2023-2400049 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_February_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_February_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108591 recordid = 108591 date_published = 01/02/2024 date_published = 01/02/2024 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_February_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_February_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 February Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 February Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No3 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction February Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400049 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_February_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108591 Column Name : date_published Column Value : 01/02/2024 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_February_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 February Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 4 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction December document_shortdescription = Transaction December client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400078 docid = PMS2023-2400078 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_December_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_December_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108966 recordid = 108966 date_published = 01/01/2024 date_published = 01/01/2024 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_December_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_December_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 December Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 December Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No4 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction December Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400078 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_December_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108966 Column Name : date_published Column Value : 01/01/2024 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_December_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 December Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 5 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction November document_shortdescription = Transaction November client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400077 docid = PMS2023-2400077 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_November_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_November_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108953 recordid = 108953 date_published = 01/12/2023 date_published = 01/12/2023 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_November_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_November_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 November Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 November Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No5 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction November Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400077 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_November_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108953 Column Name : date_published Column Value : 01/12/2023 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_November_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 November Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 6 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction October document_shortdescription = Transaction October client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400076 docid = PMS2023-2400076 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_October_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_October_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108923 recordid = 108923 date_published = 01/11/2023 date_published = 01/11/2023 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_October_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_October_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 October Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 October Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No6 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction October Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400076 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_October_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108923 Column Name : date_published Column Value : 01/11/2023 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_October_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 October Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 7 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction September document_shortdescription = Transaction September client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400075 docid = PMS2023-2400075 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_September_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_September_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108896 recordid = 108896 date_published = 01/10/2023 date_published = 01/10/2023 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_September_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_September_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 September Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 September Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No7 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction September Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400075 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_September_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108896 Column Name : date_published Column Value : 01/10/2023 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_September_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 September Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 8 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction June document_shortdescription = Transaction June client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400072 docid = PMS2023-2400072 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_June_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_June_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108809 recordid = 108809 date_published = 01/07/2023 date_published = 01/07/2023 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_June_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_June_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 June Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 June Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No8 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction June Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400072 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_June_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108809 Column Name : date_published Column Value : 01/07/2023 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_June_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 June Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 9 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction May document_shortdescription = Transaction May client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400071 docid = PMS2023-2400071 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_May_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_May_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108777 recordid = 108777 date_published = 01/06/2023 date_published = 01/06/2023 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_May_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_May_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 May Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 May Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No9 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction May Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400071 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_May_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108777 Column Name : date_published Column Value : 01/06/2023 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_May_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 May Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 10 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction April document_shortdescription = Transaction April client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400064 docid = PMS2023-2400064 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_April_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_April_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108706 recordid = 108706 date_published = 01/04/2023 date_published = 01/04/2023 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_April_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_April_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 April Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 April Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No10 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction April Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400064 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_April_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108706 Column Name : date_published Column Value : 01/04/2023 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_April_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 April Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Rehiding column financial_yearcode Rehiding column financialyear_code Rehiding column miles_account_code Rehiding column ucc_code Rehiding column client_code Rehiding column fund_code Rehiding column scheme_code Rehiding column report_type Rehiding column subreport_type Rehiding column document_shortdescription Rehiding column client_name Rehiding column mfundcode Rehiding column docid Rehiding column axzipfilepath Rehiding column axzipfiles Rehiding column axzipfilename Rehiding column recordid Rehiding column date_published Rehiding column axpfilepath_documentupload Rehiding column axpfile_documentupload Rehiding column filedocumentupload Rehiding column axp_emailfrom Rehiding column axp_emailto Rehiding column axp_emailsub Rehiding column axp_emailcc Rehiding column axp_emailbcc Rehiding column axpemailtemplate Rehiding column email Storing subtotals Storing subtotals at : E:\Axpert113\Axpert Web\AxpertWebScripts\Axpert\fevgag5szj4b24cs5phvx0ut\cldocvie.lst Time elapsed = 828 Total Time elapsed = 924 Creating Report Header/Footer Creating Report Header/Footer over select cvalue, elements from templates where type='Iview' and iviewid = 'cldocvie' Time elapsed = 4 Iview result :{"data":{"reporthf":{"hideprojname":"@","hidereportdate":"@","header":{"h1":{"font":"@clBlack,12,,T","header_aline":"@center","text":" cldocvie"}}},"headrow":{"rowno":{"@hide":"false"},"axrowtype":{"@hide":"true","@width":"80","@dec":"0","@type":"c","#text":"axrowtype"},"axp__font":{"@hide":"true","@width":"80","@dec":"0","@type":"c","#text":"axp__fontdetails"},"financial_yearcode":{"#text":"financial_yearcode","@width":"115","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"financialyear_code":{"#text":"financialyear_code","@width":"115","@dec":"0","@align":"Right","@type":"n","@freezecol":"F","@hide":"true"},"miles_account_code":{"#text":"MILES Account Code","@width":"76","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"ucc_code":{"#text":"UCC Code","@width":"112","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"client_code":{"#text":"Client Code/Name","@width":"76","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"fund_code":{"#text":"Fund Code","@width":"52","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"scheme_code":{"#text":"Scheme Code","@width":"133","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"report_type":{"#text":"Report Type","@width":"63","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"subreport_type":{"#text":"Sub Report Type","@width":"80","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"document_shortdescription":{"#text":"Report Description","@width":"271","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"client_name":{"#text":"Client Name","@width":"185","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"mfundcode":{"#text":"mfundcode","@width":"72","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"docid":{"#text":"Document#","@width":"74","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axzipfilepath":{"#text":"axzipfilepath","@width":"80","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axzipfiles":{"#text":"axzipfiles","@width":"57","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axzipfilename":{"#text":"axzipfilename","@width":"86","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"recordid":{"#text":"recordid","@width":"53","@dec":"0","@align":"Right","@type":"n","@freezecol":"F","@hide":"true"},"date_published":{"#text":"Published On","@width":"144","@dec":"0","@align":"Left","@type":"d","@freezecol":"F","@hide":"false"},"axpfilepath_documentupload":{"#text":"axpfilepath_documentupload","@width":"182","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axpfile_documentupload":{"#text":"Download","@width":"64","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"filedocumentupload":{"#text":"filedocumentupload","@width":"126","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axp_emailfrom":{"#text":"axp_emailfrom","@width":"92","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axp_emailto":{"#text":"axp_emailto","@width":"75","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axp_emailsub":{"#text":"axp_emailsub","@width":"84","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axp_emailcc":{"#text":"axp_emailcc","@width":"75","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axp_emailbcc":{"#text":"axp_emailbcc","@width":"84","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axpemailtemplate":{"#text":"axpemailtemplate","@width":"112","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"email":{"#text":"Email","@width":"63","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"}},"row":[{"rowno":"1","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction March","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400079","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_March_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108997","date_published":"01/04/2024","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_March_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 March Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"2","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction January","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400025","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_January_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108481","date_published":"15/03/2024","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_January_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 January Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"3","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction February","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400049","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_February_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108591","date_published":"01/02/2024","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_February_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 February Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"4","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction December","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400078","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_December_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108966","date_published":"01/01/2024","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_December_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 December Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"5","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction November","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400077","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_November_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108953","date_published":"01/12/2023","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_November_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 November Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"6","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction October","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400076","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_October_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108923","date_published":"01/11/2023","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_October_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 October Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"7","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction September","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400075","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_September_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108896","date_published":"01/10/2023","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_September_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 September Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"8","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction June","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400072","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_June_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108809","date_published":"01/07/2023","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_June_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 June Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"9","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction May","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400071","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_May_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108777","date_published":"01/06/2023","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_May_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 May Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"10","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction April","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400064","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_April_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108706","date_published":"01/04/2023","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_April_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 April Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"}]},"reccount":{"reccount":"10"},"actualrows":{"actualrows":"10"}}#$?#{"templete": [{"CVALUE": "

","ELEMENTS": "email"},{"CVALUE": "

download{{{axpfile_documentupload}}}

","ELEMENTS": "axpfile_documentupload"}]} GetIView webservice completed Time Used : 46.6504392879745 secs # 1#Saving to log insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('fevgag5szj4b24cs5phvx0ut','rekhancia',to_timestamp('07/08/2024 10:32:34','dd/mm/yyyy hh24:mi:ss'),to_timestamp('07/08/2024 10:32:35','dd/mm/yyyy hh24:mi:ss'),'cldocvie',0,'Get IView New','success',1139,42,0) uXDS\pinsert\ Check intransaction Closing connection Freeing AxProvider Resources Freeing DbManager Resources Destroying Default xds in db manager Destroying connect object Disconnecting from db trustlineuat Keep Connection setting false Disconnecting... Disconnected... Dbx name = ConnectionName = DriverName = GetDriverFunc = LibraryName = VendorLib = Successfully disconnected from db trustlineuat Destroyed connect object Destroying GF End Time : 07/08/2024 10:32:35 Get IviewObj from Cache, User: rekhancia Role: Loading iview.aspx before post back (get and set parameters) Get Iview Parameters Call to GetParams Web Service ASB XE3/32/64 DLL running [Compiled on 31/07/2024 1:02:00 PM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(260724)] DB Manager created Current ASB DLL folder : E:\Axpert113\Axpert Web\AxpertWebScripts Connecting to project : trustlineuat Connecting to project found : -1 Session key validation Session key validation completed Db Manager Connection starts Db Manager Connection XML receied : dbPostgredbxlocalhosttrustlineuat\trustlineuat creating connection starts... creating connection end... creating date xds... creating date xds end... PostGreConnect starts... PostGreConnect ends... db user : trustlineuat Select now() as sdt Time elapsed = 2 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 4 axprops xml = images\Agile-TrustLine-UATINR1FFFsmtp.office365.com587portalneo@trustlineindia.com01trust@123*100000FF SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 uXDS\dopen\ Check intransaction Time elapsed = 2 Db Manager Connection ends Connection to DB Successful Executing GetParamsNew webservice ---------------------------------- Received XML + dbPostgredbxlocalhosttrustlineuat\trustlineuattrustlineuataxdefdd/mm/yyyy hh24:mi:ssadminlocalBlackENGLISHtruet\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir\\10.16.248.2\UAT_Attachment\UAT_TLReports\\10.16.248.2\UAT_Attachment\UAT_TLBusiness1025660000000FrekhanciadefaultdefaultFfevgag5szj4b24cs5phvx0utdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*8/7/2024 10:29:20 am*-2592002218~~9867~25~0~0~1~R~false~RccccncccccE:\Axpert113\Axpert Web\AxpertWebScripts Registering app/user variables for the session Registering DBMem variables Registering DBMem variables completed Registering ConfigParam variables Registering ConfigParam variables completed auth_path=E:\Axpert113\Axpert Web\AxpertWebScripts axp_clientlocale=en-us*asia/calcutta^english*8/7/2024 10:29:20 am*-2592002218 axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=fevgag5szj4b24cs5phvx0ut ax_evalcopy=F rolename=default responsibilies=default millions=F axpimageserver= axglo_hide= axp_displaytext= axglo_user= fromuserlogin= axglo_recordid=1025660000000 axpimagepath= AxpServerPath=\\10.16.248.2\UAT_Attachment\UAT_TLBusiness AxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports AxpDbDirPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir LStr : ~~9867~25~0~0~1~R~false~R LReg Type : R User Group default User Roles default Registering app/user variables for the session completed select sessionid from connections where sessionid = :sesid uXDS\dopen\ Check intransaction Time elapsed = 3 Sql : select props from iviews where lower(name)= :name order by blobno Paramval : cldocvie ParamTYpe : c Param List : name select props from iviews where lower(name)= :name order by blobno uXDS\dopen\ Check intransaction Time elapsed = 3 Step5 select count(*) recno from (select a.* from ( select a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T' order by a.createdon desc )a) aa Time elapsed = 3 Sql after pagination change :select a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T' order by a.createdon desc LIMIT 100 Opening Query select a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T' order by a.createdon desc LIMIT 100 Time elapsed = 2 CDS Record Count : 2 Evaluating {PMS} Result = PMS Param Name : pfundcode Param Type : C Param Value : PMS select count(*) recno from (select a.* from ( Select distinct a1.fund_code from fund_scheme_details a1 where a1.cancel = 'F' and a1.active = 'T' order by 1 )a) aa Time elapsed = 3 Sql after pagination change :Select distinct a1.fund_code from fund_scheme_details a1 where a1.cancel = 'F' and a1.active = 'T' order by 1 LIMIT 100 Opening Query Select distinct a1.fund_code from fund_scheme_details a1 where a1.cancel = 'F' and a1.active = 'T' order by 1 LIMIT 100 Time elapsed = 1 CDS Record Count : 2 Evaluating {Intrinsic} Result = Intrinsic Param Name : pschemecode Param Type : C Param Value : Intrinsic CDS Param Name : pfundcode CDS Param Type : c CDS Param Value : PMS pfundcode=PMS select count(*) recno from (select a.* from ( select a.scheme_code from fund_scheme_details a where a.fund_code = :pfundcode and a.active = 'T' and a.cancel = 'F' order by 1 )a) aa pfundcode=PMS Time elapsed = 0 Sql after pagination change :select a.scheme_code from fund_scheme_details a where a.fund_code = :pfundcode and a.active = 'T' and a.cancel = 'F' order by 1 LIMIT 100 Opening Query select a.scheme_code from fund_scheme_details a where a.fund_code = :pfundcode and a.active = 'T' and a.cancel = 'F' order by 1 LIMIT 100 pfundcode=PMS Time elapsed = 0 CDS Record Count : 2 Evaluating {Transaction Report} Result = Transaction Report Param Name : preporttype Param Type : C Param Value : Transaction Report CDS Param Name : pfundcode CDS Param Type : c CDS Param Value : PMS pfundcode=PMS CDS Param Name : pschemecode CDS Param Type : c CDS Param Value : Intrinsic pschemecode=Intrinsic select count(*) recno from (select a.* from ( select unnest(string_to_array(b.report_type, ',')) as reporttype from fund_scheme_details b where b.fund_code = :pfundcode and b.scheme_code = :pschemecode order by 1 )a) aa pfundcode=PMS pschemecode=Intrinsic Time elapsed = 0 Sql after pagination change :select unnest(string_to_array(b.report_type, ',')) as reporttype from fund_scheme_details b where b.fund_code = :pfundcode and b.scheme_code = :pschemecode order by 1 LIMIT 100 CDS Param Name : pfundcode CDS Param Type : c CDS Param Value : PMS CDS Param Name : pschemecode CDS Param Type : c CDS Param Value : Intrinsic Opening Query select unnest(string_to_array(b.report_type, ',')) as reporttype from fund_scheme_details b where b.fund_code = :pfundcode and b.scheme_code = :pschemecode order by 1 LIMIT 100 pfundcode=PMS pschemecode=Intrinsic Time elapsed = 0 CDS Record Count : 3 Evaluating AxpAttachmentPath AxpAttachmentPath = \\10.16.248.2\UAT_Attachment\UAT_TLReports Result = \\10.16.248.2\UAT_Attachment\UAT_TLReports Param Name : mAxpAttachmentPath Param Type : C Param Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Evaluating usergroup usergroup = default Result = default Param Name : paxusergroup Param Type : C Param Value : default Evaluating username username = rekhancia Result = rekhancia Param Name : pusername Param Type : C Param Value : rekhancia CDS Param Name : pusername CDS Param Type : c CDS Param Value : rekhancia pusername=rekhancia CDS Param Name : paxusergroup CDS Param Type : c CDS Param Value : default paxusergroup=default select count(*) recno from (select a.* from ( select a.client_name as choice from client_details a where a.active = 'T' and a.cancel = 'F' and (a.primary_emailid = :pusername or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%') union select 'ALL' as choice from dual order by 1 )a) aa pusername=rekhancia paxusergroup=default paxusergroup=default Time elapsed = 21 Sql after pagination change :select a.client_name as choice from client_details a where a.active = 'T' and a.cancel = 'F' and (a.primary_emailid = :pusername or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%') union select 'ALL' as choice from dual order by 1 LIMIT 100 CDS Param Name : pusername CDS Param Type : c CDS Param Value : rekhancia CDS Param Name : paxusergroup CDS Param Type : c CDS Param Value : default Opening Query select a.client_name as choice from client_details a where a.active = 'T' and a.cancel = 'F' and (a.primary_emailid = :pusername or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%') union select 'ALL' as choice from dual order by 1 LIMIT 100 pusername=rekhancia paxusergroup=default paxusergroup=default Time elapsed = 5 CDS Record Count : 65 select username , config_data from axp_smartviews_config where ivname = 'cldocvie' Time elapsed = 3 GetSmartViewSettings Result : Select cvalue from axpconfigsiv_cldocvie where configname= 'groupbtns' CDS Open Error Msg : csd query : Select cvalue from axpconfigsiv_cldocvie where configname= 'groupbtns' $ Error msg : relation "axpconfigsiv_cldocvie" does not exist uXDS\open\ Exceptio relation "axpconfigsiv_cldocvie" does not exist Creating runtime menu Created runtime menu Global vars in Params :{"globalVars":[{"n":"AxpAttachmentPath","v":"\\10.16.248.2\UAT_Attachment\UAT_TLReports"},{"n":"username","v":"rekhancia"}]} Result :Task1pfinancialyearFinancial YearCharacterfalsefalseselect a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T' order by a.createdon desc0truefalseSelect325false2024-252023-24Task1pfundcodeFund CodeCharacterfalse{PMS}false Select distinct a1.fund_code from fund_scheme_details a1 where a1.cancel = 'F' and a1.active = 'T' order by 1 0truefalseSelect~~pschemecode,preporttype~~325falseAIF1PMSTask1pschemecodeScheme CodeCharacterfalse{Intrinsic}falseselect a.scheme_code from fund_scheme_details a where a.fund_code = :pfundcode and a.active = 'T' and a.cancel = 'F' order by 1 0truefalseSelect~~preporttype~~325falseFloaterIntrinsicTask1preporttypeReport TypeCharacterfalse{Transaction Report}falseselect unnest(string_to_array(b.report_type, ',')) as reporttype from fund_scheme_details b where b.fund_code = :pfundcode and b.scheme_code = :pschemecode order by 1 0truefalseSelect325falseCapital Gain ReportPerformance ReportTransaction ReportTask1mAxpAttachmentPathGlobal File PathCharacterfalseAxpAttachmentPathtrue0truefalseAccept325falseTask1paxusergroupUser RolesCharacterfalseusergrouptrue0truefalseAccept~~pclientname~~325falseTask1pusernameUser NameCharacterfalseusernametrue0truefalseAccept~~pclientname~~325falseTask1pclientnameClient NameCharacterfalsefalseselect a.client_name as choice from client_details a where a.active = 'T' and a.cancel = 'F' and (a.primary_emailid = :pusername or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%') union select 'ALL' as choice from dual order by 10truefalseSelect325falseA R ChitraAkhil VishwanathamALLAmitabh PrasadAnjalidevi RAnnapoorna JAnudita PrasadAravamudhan RajeshAravindan RAruna AruldassB S VijayanandBalaji DhandapaniBalaraman Kuppuswamy Jt Suguna BalaramanBharat TannaC V KamathCorporate testingDeepa Deepak DesaiEshwari Ravindran Ashok KumarGomathi UlaganathanGovind Krishnan Jt Chitra GovindInbaraj RajakumarJanardhanan ShankarJayalakshmi TKalyan Raman Bangalore Janakiraman Jt Nishita Meenakshi KumarKosala Raman Bangalore JanakiramanKrithiga RameshKumaran KandasamyLakshmi PrabhaManohar ChandrasekharMathew K EraliMythri AssociatesN A SomasundariN Rajadurai Jt Mahalakshmi BNaithrav SrinivasanNaozer Cusrow DalalNaozer Cusrow Dalal 1Padmapriya V Jt Sathyanarayanan N BPadmashri KodivalasaPallipattu Srinivasa Lakshmi Narasa ReddyPradeep C RPranav Aditya C P Jt Vikram Adithya C PPrasad Venkatesh BhattPravin Damodar Karve Jt Vaishali Pravin KarveR JayasowmyaRamamurthy PRamanan CRamesh Babu C GS Aramuthan HUFS G Anjana ShankarS N Damani Realty Investors LLPSaravanan Krishnamoorthy MusuvathiShanmugavalli ChandrasekaranSridevi Prasanna Jt Prasanna RamanujamSrikanth NSrikanth NarasimhanSrinivas Mani KolipakkamSrinivasa Raghavan SSubbulakshmi VagulaparananSubhadip SarkarSukanya Misra Jt Praphulla MisraT K Govinda RajanThirukkumaran NagarajanUsha Ratnakumari RajakumarVenkat Ravi ShankarVenkata Raghavan S K SELECT A.STYPE,A.STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'SINGLE' as APPLYON FROM axpstructconfig a, axuserlevelgroups b WHERE A.USERROLES IN ('default') AND B.AXUSERNAME = :uname AND lower(a.stype) = :structure_type AND A.STRUCTNAME not in('ALL Reports','ALL Forms') UNION SELECT A.STYPE,A.STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'SINGLE' as APPLYON FROM axpstructconfig a WHERE coalesce(USERROLES, 'ALL') = 'ALL' AND lower(a.stype) = :structure_type AND structname = :sname AND A.STRUCTNAME not in('ALL Reports','ALL Forms') UNION SELECT A.STYPE, :sname STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'ALL' as APPLYON FROM axpstructconfig a, axuserlevelgroups b WHERE A.USERROLES IN ('default') AND B.AXUSERNAME = :uname AND lower(a.stype) = :structure_type AND A.STRUCTNAME in('ALL Reports','ALL Forms') UNION SELECT A.STYPE, :sname STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'ALL' as APPLYON FROM axpstructconfig a WHERE coalesce(USERROLES, 'ALL') = 'ALL' AND lower(a.stype) = :structure_type AND A.STRUCTNAME in('ALL Reports','ALL Forms') order by STYPE,STRUCTNAME,PROPS,APPLYON DESC uname=rekhancia structure_type=iview structure_type=iview sname=cldocvie sname=cldocvie uname=rekhancia structure_type=iview sname=cldocvie structure_type=iview Time elapsed = 14 GetParamsNew webservice completed # 1#Saving to log insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('fevgag5szj4b24cs5phvx0ut','rekhancia',to_timestamp('07/08/2024 10:34:45','dd/mm/yyyy hh24:mi:ss'),to_timestamp('07/08/2024 10:34:45','dd/mm/yyyy hh24:mi:ss'),null,0,'Getting IView Params New','success',318,66,0) uXDS\pinsert\ Check intransaction Closing connection Freeing AxProvider Resources Freeing DbManager Resources Destroying Default xds in db manager Destroying connect object Disconnecting from db trustlineuat Keep Connection setting false Disconnecting... Disconnected... Dbx name = ConnectionName = DriverName = GetDriverFunc = LibraryName = VendorLib = Successfully disconnected from db trustlineuat Destroyed connect object Destroying GF Loading and setting parameters components Loading and setting parameters components completed End Time : 07/08/2024 10:34:45 Loading iview.aspx after post back (get and load iview data) Get and Load Iviewdata Call to GetIView Web Service for page no 1 ASB XE3/32/64 DLL running [Compiled on 31/07/2024 1:02:00 PM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(260724)] DB Manager created Current ASB DLL folder : E:\Axpert113\Axpert Web\AxpertWebScripts Connecting to project : trustlineuat Connecting to project found : -1 Session key validation Session key validation completed Db Manager Connection starts Db Manager Connection XML receied : dbPostgredbxlocalhosttrustlineuat\trustlineuat creating connection starts... creating connection end... creating date xds... creating date xds end... PostGreConnect starts... PostGreConnect ends... db user : trustlineuat Select now() as sdt Time elapsed = 1 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 3 axprops xml = images\Agile-TrustLine-UATINR1FFFsmtp.office365.com587portalneo@trustlineindia.com01trust@123*100000FF SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 uXDS\dopen\ Check intransaction Time elapsed = 2 Db Manager Connection ends Connection to DB Successful Executing GetIViewNew webservice --------------------------------- Received XML : 2023-24PMSIntrinsicTransaction Report\\10.16.248.2\UAT_Attachment\UAT_TLReportsdefaultrekhanciaN A SomasundaridbPostgredbxlocalhosttrustlineuat\trustlineuattrustlineuataxdefdd/mm/yyyy hh24:mi:ssadminlocalBlackENGLISHtruet\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir\\10.16.248.2\UAT_Attachment\UAT_TLReports\\10.16.248.2\UAT_Attachment\UAT_TLBusiness1025660000000FrekhanciadefaultdefaultFfevgag5szj4b24cs5phvx0utdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*8/7/2024 10:29:20 am*-2592002218~~9867~25~0~0~1~R~false~RccccncccccE:\Axpert113\Axpert Web\AxpertWebScripts Registering app/user variables for the session Registering DBMem variables Registering DBMem variables completed Registering ConfigParam variables Registering ConfigParam variables completed auth_path=E:\Axpert113\Axpert Web\AxpertWebScripts axp_clientlocale=en-us*asia/calcutta^english*8/7/2024 10:29:20 am*-2592002218 axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=fevgag5szj4b24cs5phvx0ut ax_evalcopy=F rolename=default responsibilies=default millions=F axpimageserver= axglo_hide= axp_displaytext= axglo_user= fromuserlogin= axglo_recordid=1025660000000 axpimagepath= AxpServerPath=\\10.16.248.2\UAT_Attachment\UAT_TLBusiness AxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports AxpDbDirPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir LStr : ~~9867~25~0~0~1~R~false~R LReg Type : R User Group default User Roles default Registering app/user variables for the session completed select sessionid from connections where sessionid = :sesid uXDS\dopen\ Check intransaction Time elapsed = 2 >>Reading defintion - cldocvie Initializing Report Preparing SQL statements Assigning values to IView parameters pfinancialyear(c)=2023-24 pfinancialyear=2023-24 mAxpAttachmentPath(c)=\\10.16.248.2\UAT_Attachment\UAT_TLReports mAxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports mAxpAttachmentPath(c)=\\10.16.248.2\UAT_Attachment\UAT_TLReports pfundcode(c)=PMS pfundcode=PMS pschemecode(c)=Intrinsic pschemecode=Intrinsic preporttype(c)=Transaction Report preporttype=Transaction Report pfinancialyear(c)=2023-24 pusername(c)=rekhancia pusername=rekhancia paxusergroup(c)=default paxusergroup=default paxusergroup(c)=default pclientname(c)=N A Somasundari pclientname=N A Somasundari pclientname(c)=N A Somasundari Creating Columns Creating Columns for first time Creating financial_yearcode Creating financialyear_code Creating miles_account_code Creating ucc_code Creating client_code Creating fund_code Creating scheme_code Creating report_type Creating subreport_type Creating document_shortdescription Creating client_name Creating mfundcode Creating docid Creating axzipfilepath Creating axzipfiles Creating axzipfilename Creating recordid Creating date_published Creating axpfilepath_documentupload Creating axpfile_documentupload Creating filedocumentupload Creating axp_emailfrom Creating axp_emailto Creating axp_emailsub Creating axp_emailcc Creating axp_emailbcc Creating axpemailtemplate Creating email Creating Columns for first time completed select a1.documents_segregationid recordid, :pfinancialyear as financial_yearcode, a2.date_published, a2.financialyear_code, a2.fund_code as mfundcode, :mAxpAttachmentPath as axpfilepath_documentupload, a1.axpfile_documentupload, 'download' as filedocumentupload, a2.docid as docid, a1.miles_account_code, a1.client_code||'-'||a3.client_name as client_code, a1.ucc_code, a3.client_name, a2.fund_code, a2.scheme_code, a2.report_type, a2.subreport_type, :mAxpAttachmentPath as AxZIPFilePath, a1.axpfile_documentupload as AxZIPFiles, concat(a1.miles_account_code, '-', a2.report_type ,'-', current_date) as AxZipFileName, a2.document_shortdescription, 'rekhancia@agile-labs.com' as Axp_EMailFrom, a3.primary_emailid as Axp_EMailTo,concat('Trustline PMS App : ','FY ', a2.fincode,' ', a2.notation, ' ', a2.subreport_type,' ', a2.scheme_code) as Axp_EMailSub, a3.cc_mailid1 as Axp_EMailCC, a3.cc_mailid2 as Axp_EMailBCC , (select concat(replace(caption, ' ', '_'), '_', replace(name, 'HP', ''), '.html') as htmlfilename from axpages where lower(caption) = lower('emailrepTransactionreport') and name like 'HP%') as AxpEmailTemplate,'Email' as Email from documents_segregation a1, (select a2.*, a3.financialyear_code as fincode, a3.financialyear_startdate, a3.financialyear_enddate from documents_uploads a2, financial_years a3 where a2.cancel = 'F' and a2.active = 'T' and ((current_date BETWEEN a2.validity_datefrom and a2.validity_dateto) or (a2.validity_datefrom <= current_date and a2.validity_dateto is null)) and ( :pfundcode like '%'|| a2.fund_code||'%' ) and ( :pschemecode like '%'|| a2.scheme_code||'%') and ( :preporttype like '%'|| a2.report_type||'%') and a2.financialyear_code = a3.financial_yearsid and a3.financialyear_code = :pfinancialyear ) a2, client_details a3 where a1.docid = a2.documents_uploadsid and a1.client_code = a3.client_code and a2.cancel = 'F' and a1.active = 'T' and lower(a1.client_code) not like 'invalid%' and (a3.primary_emailid = :pusername or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%') and (a3.client_name = :pclientname or :pclientname = 'ALL') order by a1.miles_account_code,a1.createdon,a2.date_published desc LIMIT 25 pfinancialyear=2023-24 mAxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports mAxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports pfundcode=PMS pschemecode=Intrinsic preporttype=Transaction Report pfinancialyear=2023-24 pusername=rekhancia paxusergroup=default paxusergroup=default pclientname=N A Somasundari pclientname=N A Somasundari Time elapsed = 28 Time elapsed = 28 Copying result to grid Row 1 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction March document_shortdescription = Transaction March client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400079 docid = PMS2023-2400079 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_March_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_March_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108997 recordid = 108997 date_published = 01/04/2024 date_published = 01/04/2024 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_March_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_March_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 March Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 March Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No1 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction March Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400079 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_March_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108997 Column Name : date_published Column Value : 01/04/2024 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_March_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 March Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 2 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction January document_shortdescription = Transaction January client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400025 docid = PMS2023-2400025 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_January_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_January_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108481 recordid = 108481 date_published = 15/03/2024 date_published = 15/03/2024 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_January_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_January_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 January Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 January Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No2 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction January Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400025 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_January_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108481 Column Name : date_published Column Value : 15/03/2024 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_January_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 January Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 3 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction February document_shortdescription = Transaction February client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400049 docid = PMS2023-2400049 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_February_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_February_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108591 recordid = 108591 date_published = 01/02/2024 date_published = 01/02/2024 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_February_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_February_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 February Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 February Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No3 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction February Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400049 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_February_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108591 Column Name : date_published Column Value : 01/02/2024 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_February_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 February Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 4 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction December document_shortdescription = Transaction December client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400078 docid = PMS2023-2400078 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_December_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_December_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108966 recordid = 108966 date_published = 01/01/2024 date_published = 01/01/2024 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_December_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_December_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 December Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 December Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No4 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction December Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400078 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_December_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108966 Column Name : date_published Column Value : 01/01/2024 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_December_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 December Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 5 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction November document_shortdescription = Transaction November client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400077 docid = PMS2023-2400077 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_November_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_November_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108953 recordid = 108953 date_published = 01/12/2023 date_published = 01/12/2023 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_November_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_November_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 November Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 November Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No5 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction November Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400077 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_November_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108953 Column Name : date_published Column Value : 01/12/2023 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_November_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 November Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 6 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction October document_shortdescription = Transaction October client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400076 docid = PMS2023-2400076 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_October_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_October_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108923 recordid = 108923 date_published = 01/11/2023 date_published = 01/11/2023 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_October_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_October_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 October Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 October Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No6 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction October Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400076 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_October_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108923 Column Name : date_published Column Value : 01/11/2023 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_October_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 October Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 7 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction September document_shortdescription = Transaction September client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400075 docid = PMS2023-2400075 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_September_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_September_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108896 recordid = 108896 date_published = 01/10/2023 date_published = 01/10/2023 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_September_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_September_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 September Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 September Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No7 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction September Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400075 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_September_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108896 Column Name : date_published Column Value : 01/10/2023 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_September_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 September Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 8 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction June document_shortdescription = Transaction June client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400072 docid = PMS2023-2400072 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_June_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_June_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108809 recordid = 108809 date_published = 01/07/2023 date_published = 01/07/2023 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_June_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_June_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 June Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 June Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No8 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction June Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400072 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_June_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108809 Column Name : date_published Column Value : 01/07/2023 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_June_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 June Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 9 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction May document_shortdescription = Transaction May client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400071 docid = PMS2023-2400071 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_May_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_May_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108777 recordid = 108777 date_published = 01/06/2023 date_published = 01/06/2023 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_May_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_May_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 May Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 May Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No9 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction May Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400071 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_May_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108777 Column Name : date_published Column Value : 01/06/2023 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_May_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 May Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Row 10 Evaluating column values financial_yearcode = 2023-24 financial_yearcode = 2023-24 financialyear_code = 1126440000000 financialyear_code = 1126440000000 miles_account_code = 20 miles_account_code = 20 ucc_code = TLAX00020 ucc_code = TLAX00020 client_code = 23-N A Somasundari client_code = 23-N A Somasundari fund_code = PMS fund_code = PMS scheme_code = Intrinsic scheme_code = Intrinsic report_type = Transaction Report report_type = Transaction Report subreport_type = Transaction subreport_type = Transaction document_shortdescription = Transaction April document_shortdescription = Transaction April client_name = N A Somasundari client_name = N A Somasundari mfundcode = PMS mfundcode = PMS docid = PMS2023-2400064 docid = PMS2023-2400064 axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfilepath = \\10.16.248.2\UAT_Attachment\UAT_TLReports axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_April_2023-24.pdf axzipfiles = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_April_2023-24.pdf axzipfilename = 20-Transaction Report-2024-08-07 axzipfilename = 20-Transaction Report-2024-08-07 recordid = 108706 recordid = 108706 date_published = 01/04/2023 date_published = 01/04/2023 axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfilepath_documentupload = \\10.16.248.2\UAT_Attachment\UAT_TLReports axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_April_2023-24.pdf axpfile_documentupload = 20_Mrs N A Soma Sundari_Intrinsic_Transaction_April_2023-24.pdf filedocumentupload = download filedocumentupload = download axp_emailfrom = rekhancia@agile-labs.com axp_emailfrom = rekhancia@agile-labs.com axp_emailto = somatcs1@gmail.com axp_emailto = somatcs1@gmail.com axp_emailsub = Trustline PMS App : FY 2023-24 April Transaction Intrinsic axp_emailsub = Trustline PMS App : FY 2023-24 April Transaction Intrinsic axp_emailcc = axp_emailcc = axp_emailbcc = axp_emailbcc = axpemailtemplate = emailrepTransactionreport_1700628989551.html axpemailtemplate = emailrepTransactionreport_1700628989551.html email = Email email = Email Creating Row Row No10 Created Displaying columns Column Name : financial_yearcode Column Value : 2023-24 Column Name : financialyear_code Column Value : 1126440000000 Column Name : miles_account_code Column Value : 20 Column Name : ucc_code Column Value : TLAX00020 Column Name : client_code Column Value : 23-N A Somasundari Column Name : fund_code Column Value : PMS Column Name : scheme_code Column Value : Intrinsic Column Name : report_type Column Value : Transaction Report Column Name : subreport_type Column Value : Transaction Column Name : document_shortdescription Column Value : Transaction April Column Name : client_name Column Value : N A Somasundari Column Name : mfundcode Column Value : PMS Column Name : docid Column Value : PMS2023-2400064 Column Name : axzipfilepath Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axzipfiles Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_April_2023-24.pdf Column Name : axzipfilename Column Value : 20-Transaction Report-2024-08-07 Column Name : recordid Column Value : 108706 Column Name : date_published Column Value : 01/04/2023 Column Name : axpfilepath_documentupload Column Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports Column Name : axpfile_documentupload Column Value : 20_Mrs N A Soma Sundari_Intrinsic_Transaction_April_2023-24.pdf Column Name : filedocumentupload Column Value : download Column Name : axp_emailfrom Column Value : rekhancia@agile-labs.com Column Name : axp_emailto Column Value : somatcs1@gmail.com Column Name : axp_emailsub Column Value : Trustline PMS App : FY 2023-24 April Transaction Intrinsic Column Name : axp_emailcc Column Value : Column Name : axp_emailbcc Column Value : Column Name : axpemailtemplate Column Value : emailrepTransactionreport_1700628989551.html Column Name : email Column Value : Email Rehiding column financial_yearcode Rehiding column financialyear_code Rehiding column miles_account_code Rehiding column ucc_code Rehiding column client_code Rehiding column fund_code Rehiding column scheme_code Rehiding column report_type Rehiding column subreport_type Rehiding column document_shortdescription Rehiding column client_name Rehiding column mfundcode Rehiding column docid Rehiding column axzipfilepath Rehiding column axzipfiles Rehiding column axzipfilename Rehiding column recordid Rehiding column date_published Rehiding column axpfilepath_documentupload Rehiding column axpfile_documentupload Rehiding column filedocumentupload Rehiding column axp_emailfrom Rehiding column axp_emailto Rehiding column axp_emailsub Rehiding column axp_emailcc Rehiding column axp_emailbcc Rehiding column axpemailtemplate Rehiding column email Storing subtotals Storing subtotals at : E:\Axpert113\Axpert Web\AxpertWebScripts\Axpert\fevgag5szj4b24cs5phvx0ut\cldocvie.lst Time elapsed = 688 Total Time elapsed = 768 Creating Report Header/Footer Creating Report Header/Footer over select cvalue, elements from templates where type='Iview' and iviewid = 'cldocvie' Time elapsed = 3 Iview result :{"data":{"reporthf":{"hideprojname":"@","hidereportdate":"@","header":{"h1":{"font":"@clBlack,12,,T","header_aline":"@center","text":" cldocvie"}}},"headrow":{"rowno":{"@hide":"false"},"axrowtype":{"@hide":"true","@width":"80","@dec":"0","@type":"c","#text":"axrowtype"},"axp__font":{"@hide":"true","@width":"80","@dec":"0","@type":"c","#text":"axp__fontdetails"},"financial_yearcode":{"#text":"financial_yearcode","@width":"115","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"financialyear_code":{"#text":"financialyear_code","@width":"115","@dec":"0","@align":"Right","@type":"n","@freezecol":"F","@hide":"true"},"miles_account_code":{"#text":"MILES Account Code","@width":"76","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"ucc_code":{"#text":"UCC Code","@width":"112","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"client_code":{"#text":"Client Code/Name","@width":"76","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"fund_code":{"#text":"Fund Code","@width":"52","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"scheme_code":{"#text":"Scheme Code","@width":"133","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"report_type":{"#text":"Report Type","@width":"63","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"subreport_type":{"#text":"Sub Report Type","@width":"80","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"document_shortdescription":{"#text":"Report Description","@width":"271","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"client_name":{"#text":"Client Name","@width":"185","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"mfundcode":{"#text":"mfundcode","@width":"72","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"docid":{"#text":"Document#","@width":"74","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axzipfilepath":{"#text":"axzipfilepath","@width":"80","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axzipfiles":{"#text":"axzipfiles","@width":"57","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axzipfilename":{"#text":"axzipfilename","@width":"86","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"recordid":{"#text":"recordid","@width":"53","@dec":"0","@align":"Right","@type":"n","@freezecol":"F","@hide":"true"},"date_published":{"#text":"Published On","@width":"144","@dec":"0","@align":"Left","@type":"d","@freezecol":"F","@hide":"false"},"axpfilepath_documentupload":{"#text":"axpfilepath_documentupload","@width":"182","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axpfile_documentupload":{"#text":"Download","@width":"64","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"filedocumentupload":{"#text":"filedocumentupload","@width":"126","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axp_emailfrom":{"#text":"axp_emailfrom","@width":"92","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axp_emailto":{"#text":"axp_emailto","@width":"75","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axp_emailsub":{"#text":"axp_emailsub","@width":"84","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axp_emailcc":{"#text":"axp_emailcc","@width":"75","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axp_emailbcc":{"#text":"axp_emailbcc","@width":"84","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axpemailtemplate":{"#text":"axpemailtemplate","@width":"112","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"email":{"#text":"Email","@width":"63","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"}},"row":[{"rowno":"1","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction March","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400079","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_March_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108997","date_published":"01/04/2024","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_March_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 March Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"2","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction January","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400025","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_January_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108481","date_published":"15/03/2024","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_January_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 January Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"3","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction February","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400049","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_February_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108591","date_published":"01/02/2024","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_February_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 February Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"4","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction December","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400078","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_December_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108966","date_published":"01/01/2024","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_December_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 December Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"5","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction November","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400077","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_November_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108953","date_published":"01/12/2023","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_November_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 November Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"6","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction October","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400076","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_October_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108923","date_published":"01/11/2023","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_October_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 October Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"7","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction September","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400075","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_September_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108896","date_published":"01/10/2023","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_September_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 September Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"8","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction June","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400072","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_June_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108809","date_published":"01/07/2023","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_June_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 June Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"9","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction May","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400071","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_May_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108777","date_published":"01/06/2023","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_May_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 May Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"},{"rowno":"10","financial_yearcode":"2023-24","financialyear_code":"1126440000000","miles_account_code":"20","ucc_code":"TLAX00020","client_code":"23-N A Somasundari","fund_code":"PMS","scheme_code":"Intrinsic","report_type":"Transaction Report","subreport_type":"Transaction","document_shortdescription":"Transaction April","client_name":"N A Somasundari","mfundcode":"PMS","docid":"PMS2023-2400064","axzipfilepath":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axzipfiles":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_April_2023-24.pdf","axzipfilename":"20-Transaction Report-2024-08-07","recordid":"108706","date_published":"01/04/2023","axpfilepath_documentupload":"\\\\10.16.248.2\\UAT_Attachment\\UAT_TLReports","axpfile_documentupload":"20_Mrs N A Soma Sundari_Intrinsic_Transaction_April_2023-24.pdf","filedocumentupload":"download","axp_emailfrom":"rekhancia@agile-labs.com","axp_emailto":"somatcs1@gmail.com","axp_emailsub":"Trustline PMS App : FY 2023-24 April Transaction Intrinsic","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"emailrepTransactionreport_1700628989551.html","email":"Email"}]},"reccount":{"reccount":"10"},"actualrows":{"actualrows":"10"}}#$?#{"templete": [{"CVALUE": "

","ELEMENTS": "email"},{"CVALUE": "

download{{{axpfile_documentupload}}}

","ELEMENTS": "axpfile_documentupload"}]} GetIView webservice completed Time Used : 46.4854409272917 secs # 1#Saving to log insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('fevgag5szj4b24cs5phvx0ut','rekhancia',to_timestamp('07/08/2024 10:34:56','dd/mm/yyyy hh24:mi:ss'),to_timestamp('07/08/2024 10:34:57','dd/mm/yyyy hh24:mi:ss'),'cldocvie',0,'Get IView New','success',976,39,0) uXDS\pinsert\ Check intransaction Closing connection Freeing AxProvider Resources Freeing DbManager Resources Destroying Default xds in db manager Destroying connect object Disconnecting from db trustlineuat Keep Connection setting false Disconnecting... Disconnected... Dbx name = ConnectionName = DriverName = GetDriverFunc = LibraryName = VendorLib = Successfully disconnected from db trustlineuat Destroyed connect object Destroying GF End Time : 07/08/2024 10:34:57