of 76

280 data query_language_user_guide

1. Data Query Language User Guide MX.3 Release 28 2014-08-22 MUREX+MDM Murex Integration DMM Team All intellectual property rights and other proprietary rights in and…
18 views76 pages
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Documenttranscript
  • 1. Data Query Language User Guide MX.3 Release 28 2014-08-22 MUREX+MDM Murex Integration DMM Team All intellectual property rights and other proprietary rights in and associated with the whole and every part of this document (including all text, logos, graphics and images) shall at all times remain vested in Murex S.A.S.. You shall do all that is necessary to protect these rights, including but not limited to, taking all measures necessary to keep confidential the information contained herein and/or notified by Murex S.A.S. and not, directly or indirectly, using or divulging, or allowing to be used or divulged such information to or by any third party. In addition, you shall not reproduce, copy, distribute, republish, download, display, post or transmit this document or any part thereof in any form or by any means whatsoever. You may also not mirror any content contained herein on any other server. Nothing in this document or the present notice shall be construed as conferring any license of any of Murex S.A.S.'s intellectual property rights, whether by estoppel, implication or otherwise. Any unauthorised use of any content contained in this document may violate copyright laws, trademark laws, the laws of privacy and publicity, and communications regulations and statutes. If you are aware of any unauthorised use affecting our rights and interests in and associated with this document, you will immediately notify Murex S.A.S.. RT_NBDAYS
  • 2. Table of Contents Data Query Language User Guide......................................................................................................................................1 1 - Operator..............................................................................................................................................................1 2 - Wild Card.............................................................................................................................................................2 3 - Table....................................................................................................................................................................2 4 - Frequently Used Fields........................................................................................................................................3 5 - Parser Functions.................................................................................................................................................5 5.1 - User Defined Data.....................................................................................................................................5 5.1.1 - CTABLE..........................................................................................................................................5 5.1.2 - DTABLE..........................................................................................................................................6 5.1.3 - NTABLE..........................................................................................................................................6 5.1.4 - CUSR..............................................................................................................................................6 5.1.5 - DUSR..............................................................................................................................................7 5.1.6 - NUSR..............................................................................................................................................7 5.1.7 - C_TRNUDT.....................................................................................................................................7 5.1.8 - D_TRNUDT.....................................................................................................................................7 5.1.9 - N_TRNUDT.....................................................................................................................................8 5.2 - Settlement Instructions..............................................................................................................................8 5.2.1 - C_TRNSI.........................................................................................................................................8 5.2.2 - N_TRNSI.........................................................................................................................................9 5.2.3 - D_TRNSI.........................................................................................................................................9 5.2.4 - NSETTL..........................................................................................................................................9 5.3 - Portfolio and Counterparty........................................................................................................................9 5.3.1 - CPCENTER....................................................................................................................................9 5.3.2 - CTRPPAR.....................................................................................................................................10 5.3.3 - PFOLIOPAR..................................................................................................................................10 5.3.4 - PTF_ASCEND..............................................................................................................................10 5.3.5 - PTF_IN..........................................................................................................................................11 5.4 - Global Operating Model..........................................................................................................................11 5.4.1 - ENT_PLCURR..............................................................................................................................11 5.4.2 - C_ENTITY.....................................................................................................................................11 5.4.3 - DPC...............................................................................................................................................12 5.4.4 - DPLCC..........................................................................................................................................12 5.4.5 - DFOD............................................................................................................................................12 5.4.6 - DORG...........................................................................................................................................12 5.5 - Date - Day Count - Date Shifter - Date Format.......................................................................................13 5.5.1 - DATE.............................................................................................................................................13 5.5.2 - TIME..............................................................................................................................................13 5.5.3 - DAY...............................................................................................................................................13 5.5.4 - MONTH.........................................................................................................................................14 5.5.5 - YEAR............................................................................................................................................14 5.5.6 - STRMONTH..................................................................................................................................14 5.5.7 - DTFMT..........................................................................................................................................15 5.5.8 - DT_WDAY.....................................................................................................................................15 5.5.9 - RT_NBDAYS.................................................................................................................................15 5.5.10 - RT_NUMBASE............................................................................................................................16 5.5.11 - RT_NUMBASL............................................................................................................................16 5.5.12 - RT_NUMBASO...........................................................................................................................17 5.5.13 - DT_SHIFTER..............................................................................................................................17 5.5.14 - DT_SKIP.....................................................................................................................................18 5.5.15 - DT_XSKIP...................................................................................................................................18 5.5.16 - GROUP_TZ.................................................................................................................................19 5.5.17 - TZ_DATECONV..........................................................................................................................19 i
  • 3. Table of Contents Data Query Language User Guide 5.5.18 - TZ_TIMECONV...........................................................................................................................20 5.6 - Value in Dynamic Tables.........................................................................................................................20 5.6.1 - CINTFIELD....................................................................................................................................20 5.6.2 - DINTFIELD....................................................................................................................................21 5.6.3 - NINTFIELD....................................................................................................................................21 5.7 - Value in Transaction Header...................................................................................................................21 5.7.1 - CTRNFIELD..................................................................................................................................21 5.7.2 - DTRNFIELD..................................................................................................................................21 5.7.3 - NTRNFIELD..................................................................................................................................22 5.8 - Value in Table.........................................................................................................................................22 5.8.1 - CTBLFIELD...................................................................................................................................22 5.8.2 - DTBLFIELD...................................................................................................................................23 5.8.3 - NTBLFIELD...................................................................................................................................23 5.9 - Rate and FX Market Parameters.............................................................................................................23 5.9.1 - CVFXFF........................................................................................................................................23 5.9.2 - CVFXSPT......................................................................................................................................23 5.9.3 - NFXPARAM..................................................................................................................................24 5.9.4 - FIXCV............................................................................................................................................25 5.9.5 - HRTECV.......................................................................................................................................25 5.9.6 - PRCCV..........................................................................................................................................26 5.9.7 - PRDASG.......................................................................................................................................26 5.9.8 - RTECV..........................................................................................................................................26 5.9.9 - RTECVI.........................................................................................................................................27 5.9.10 - RTECVC.....................................................................................................................................27 5.9.11 - RT_EQRATE...............................................................................................................................28 5.9.12 - RT_FFROMR..............................................................................................................................28 5.9.13 - SPTCV........................................................................................................................................29 5.9.14 - HSPTCV......................................................................................................................................29 5.9.15 - MR...............................................................................................................................................30 5.9.16 - NFINFIELD..................................................................................................................................31 5.10 - Security Data.........................................................................................................................................32 5.10.1 - BONDDATA................................................................................................................................32 5.10.2 - SECDATA...................................................................................................................................33 5.10.3 - CSECDATA.................................................................................................................................33 5.11 - Equity Data............................................................................................................................................34 5.11.1 - RT_HISPRICE............................................................................................................................34 5.11.2 - RT_LHISPRICE..........................................................................................................................34 5.11.3 - RT_SCUTOFF............................................................................................................................35 5.11.4 - RT_MCUTOFF............................................................................................................................35 5.12 - FX Data.................................................................................................................................................36 5.12.1 - CFXCURDATA............................................................................................................................36 5.12.2 - NFXCURDATA............................................................................................................................36 5.12.3 - CFXDATA...................................................................................................................................37 5.12.4 - NFXDATA...................................................................................................................................38 5.13 - Generic Market Parameters (GMP) Data..............................................................................................38 5.13.1 - NGMPDATA................................................................................................................................38 5.13.2 - CGMPDATA................................................................................................................................39 5.13.3 - DGMPDATA................................................................................................................................40 5.14 - Commodity Data....................................................................................................................................41 5.14.1 - UNITCV.......................................................................................................................................41 5.15 - Access Rights........................................................................................................................................41 ii
  • 4. Table of Contents Data Query Language User Guide 5.15.1 - RGT_DESC.................................................................................................................................41 5.15.2 - RGT_ITEM..................................................................................................................................41 5.15.3 - RGT_LEVEL...............................................................................................................................42 5.16 - Accounting Data....................................................................................................................................42 5.16.1 - ACC_CMNT................................................................................................................................42 5.16.2 - ACC_CODE................................................................................................................................43 5.16.3 - ACC_LABEL...............................................................................................................................43 5.17 - Cash Flows............................................................................................................................................43 5.18 - Environment Variables..........................................................................................................................44 5.18.1 - CENV..........................................................................................................................................44 5.18.2 - DENV..........................................................................................................................................44 5.18.3 - NENV..........................................................................................................................................45 5.19 - Mathematical functions..........................................................................................................................45 5.19.1 - BASECONV................................................................................................................................45 5.19.2 - ISODD.........................................................................................................................................46 5.19.3 - ABS.............................................................................................................................................46 5.19.4 - INT..............................................................................................................................................46 5.19.5 - MOD.........................................
  • Advertisement
    MostRelated
    View more
    We Need Your Support
    Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

    Thanks to everyone for your continued support.

    No, Thanks
    SAVE OUR EARTH

    We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

    More details...

    Sign Now!

    We are very appreciated for your Prompt Action!

    x