Home

Corporate Costs Administrator III - T

1. S A CORPORATE COSTS ADMINISTRATOR Us pertaining fo the Corporate Costs Administrator Sctwars application the Applica Republic 4 8 The de ale saian rey noni De rc dif a by the License pro din the documentabor redal ni gio T Mobile Crach wded bo third partes oO umed fa ear othe than a ile pui salu lo the apka re Wench Mobile aac E E E i oN ich a ET farted De losers to ihe Lene User s Manual Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill Content Caption Corporate Costs Administrator Ill 6 Ae HWSW Te QUISE MENS esse ces nm rte san dune liada ida 6 2 ANStall ana Uninstall o an re 8 BOGAN A 11 NOM A Re declan ND eut er te cies hs eas ere tae 18 EXISUNO SOL Sres A a aii 23 Database ST ie nd cn na a te EEE DR teeta 24 3 Used Shortcuts NN da O 26 4 Versions 2 and 3 differences 0cccccoccococococcccococonononnnoncncnnnnnnnnnnnnrnnnnnnrnnnrnrnnnnnnrnrnrnrnannnnrnrnramanas 26 Caption Il Application 31 SA A A A A 34 2 Gnecktor UD GALES cintia aa a aaa ia 34 DS EXPO A aan 35 AA os 36 9 NUMPDEF NAM caia 36 A A ties a nee eee eue ane ad teen ten tasses este 37 1 termet CONNECTION AR A AS eue ae ON tue AA Sd 40 8 Batch Mode e 42 9 FINAL TEO in nett ne o 44 VOTANOS EEE CE RS A SR Re e NE 45 11 PrFOM S ini mn im AE a nee lent das 46 12 OOOIMO see ctr sista ces rc asec A ide 47 SOIR loci sere eee ere 47 Caption III Main modules 49 1 Downlo
2. Copyright 2015 by T Mobile Czech Republic a s Application 41 https sfn t mobile cz sfn hello A BOX 2 t mobile cz fi v w 3 cm Le Page Safety y Tools y Y lt xml version 1 0 encoding UTF 8 gt lt sfnServlet gt lt version gt 2 0 56 lt version gt lt sfnServlet gt CCA servlet version Manual certificate validation check If verification function https sfn t mobile cz sfn hello run without any problem in web browser and application still displays invalid certificate warning it is possible to check certificate validity manually Instructions were prepared for English version of Internet Explorer 9 process in other versions are very similar 1 Start Internet Explorer and fill address https sfn t mobile cz sfn hello 2 Click on secured connection button in older version button is situated left from the address field On displayed form click on view certificates VeriSign has identified this site as sfn t mobile cz This connection to the server is encrypted Should I trust this site View certificates Security 3 Visual certificate check On the first tab there are information about certification authority issuing the certificate and certificate validity dates Root authority certificate must be installed in trusted root certification authorities On last tab there is path to current certificate certificate must have more the one item in certificate
3. Legend Function is available but in worse quality Function is available and was improved extended m OL database icrosoft NET asic modules analysis settings YES atabase backup oplication parameters hange password of logged user ser profile Data and documents directoryYES worse access access Database performance ES with optimization Detail information about connected database i ES more comfortable S S utomatic update S S m un C PIO Y rt fa O D un D n O 5 D Q ER O 5 un D ct my 5 O un support Visibly displayed connection Visibly displayed currently logged user Inteligent reaction of database connection loss asic logging Advanced logging application and installer nternet access ES modern comm technologies rint reports preview ES modern print report S server Quick print and export of displayed grids ser Management Capability to connect to database with different name than SFN Minimal resolution optimization 024x768 Access to non database configuration if database is not available Old export formats paradox dbase etc Database management asy installation guide atch mode nformation channel o O ct O oO O un D un un un E mim m m m mim m m m mim m mim IT im im im imam o lam un J Q un J un m ES extended un G O TD O ES moved to invoices ES more sophistic installe
4. 603898022 MIE 50225000 604881576 602286683 602348607 602375707 602416854 VO joj Private numbers Private services On this tab sheet it is possible to mark specific services as private Services mark as private are colored differently Private services is defined for all phone numbers Private calls Private serv Xx ASEM Pret services Private services Private service GPRS EDGE 3G GPRS EDGE 3G Internet GPRS EDGE 3G Internet zdarma GPRS EDGE 3G wap Happy roaming incoming zone 2 EU Private services Watched calls This module allows to define phone numbers number masks which user want to watch in CCA application for each calling phone number These watched numbers are then used to identify watched calls in other module re invoicing analysis and graphs etc Module contains two tab sheets Tab sheets Watched calls Grid contains list of calling phone numbers for assigning watched calls list Each calling phone number can have one or none assigned watched calls list Copyright O 2015 by T Mobile Czech Republic a s Settings 91 Watched calls x watchea cls EE gt Telephone number calling Watched call list 603280923 no watched list x 603898022 no watched list X ET ETE Watched calls Watched calls lists User defined watched calls list might be defined on this tab sheet Lis
5. Microsoft NET Framework 6 Microsoft SQL Server 6 Migration 99 Module 26 32 Module switching 32 Modules 32 49 Most called destination 83 Most called number 83 Most expensive calls 83 Most expensive destination 83 Move database 99 MSSQL 6 Naming 36 Naming button 36 Naming columns 87 Naming definition 36 Network installation 18 New version 34 Number naming 87 O Operating system 7 Operation result 44 OS 7 P Parameters 42 102 Password 110 Password change 110 Pasword 106 Performance 93 Print 36 58 59 74 Print of re invoicing 74 Print table 36 Print to file 58 59 Private calls 81 89 Private numbers 89 Private services 89 Problem solving 101 Profiles 46 Q Questions 118 Quick export 35 Quick help 47 Quick module switching 32 Quick print 36 R Records order 45 Re invoicing 70 Re invoicing algorithm 74 Re invoicing filter 70 Re invoicing of services 71 Re invoicing output 73 Re invoicing settings 71 Report 44 Report for technical support 110 Requirements 6 Restore 99 Restore database 93 Ribbon 26 32 Rights administration 106 Run 31 S Secured connection 40 Select 37 Select destinations 37 Select dialog 37 Select dialogs 37 Select groups 37 Select invoices 37 Select phone numbers 37 Select services 37 Select tariffs 37 Send by e mail 69 76 Send export 69 Send logs 110 Copyright 2015 by T Mobile Czech Republic a s 130 Corporate Costs Adm
6. 2015 by T Mobile Czech Republic a s 40 Corporate Costs Administrator Ill 2 Internet connection Supported communication interfaces communication protocols and authorization protocols are based on Internet Explorer support and Microsoft NET Framework 4 technology Communication protocols HTTP version 1 1 port 80 used for downloading info channel and checking or downloading new application version HTTPS TLS port 443 method GET HTTP compression GZIP DEFLATE IDENTITY no compression used for downloading invoices Certificates While using secured connection with TLS Transport Layer Security application strictly validate certificate provided by server side If certificate validation fails no secured connection may be established It is necessary to regularly update list of root certificates using Windows Update service or Microsoft Update actualization for Windows XP system may be downloaded here Microsoft corporation releases ones in time period an optional actualization which contains list of trusted root certification authorities List of all installed certificates on your computer may be displayed using application certmgr msc Secured connection with TLS is always used in downloading invoices Application take server certificate and validates it according to trusted root certification authorities and check also its validation date List of trusted root certification authorities are tak
7. 9 Select import type De Invoice import type Single invoice Allows you to select and import a single invoice from a file on disk All invoices Traverses the directory for the downloaded data and imports all the downloaded documents are notin the database Import type Export Module for export of downloaded invoices in format defined by user Exported data are prepared to be used in third party application accounting software information systems etc Export is not designed for create print reports or exports in graphic form For these cases user can use mass print of invoices on invoices module Main control buttons In bottom panel of this module special buttons for controlling of export creation are situated Profile allows to load and save settings from to profile Export starts export according to user settings to selected destination directory Send by email starts export according to user settings and sending these export files by email Send by e mail Buttons Copyright 2015 by T Mobile Czech Republic a s Main modules 61 3 3 1 Filter Filter allows to selected export data source and selected data to be exported Filter is situated in ribbon menu above the module D Statement of Services by Numbers From 12 E o gt According to call time A Itemized Statement of Services Paym Trans a ra d Ll Export Acco
8. Fast type of backup restore User Backup restore is provided by CCA application It is possible to backup restore whole database or only some selected modules It is not important if it is local or remote SQL server this type of backup restore work for both Backup contain only pure data no database structure or indexes are included This is relative slow backup restore Backup created in very old version o application shouldn t be restored in new version of application if major database structure changed User backup limitations This type of backup does no guarantee that older backup will be able to be restored on newer version of CCA application Content of backuped tables are during backup stored in local computer memory This may cause problem for huge databases because the maximum memory limit is connected with operation system This limit is quite low on 32 bit operation systems Database selection Because it is possible to module independently without CCA application there is database selection on every operation Backed up database Current CCA I database Server APC 1007 SFN Database SFN Another database AAA Database selection Copyright O 2015 by T Mobile Czech Republic a s Tools 97 Current CCA III database database actually used by CCA application Another database it is possible to define connection string to any other database Backup file selection Backup file must be situa
9. If any Other payments for re invoicing are included then they are re invoicing with defined mode and amount to each phone number Limits are applied according to limits settings Each limit might decrease price of linked items on re invoicing If limit type is defined on more items for example more type of calls then limit is applied to each item till the limit amount is consumed Application of limits on re invoicing is explained in legend Application of limits example Lump sum limit 500 CZK Items Lump sum T80 450 CZK Lump sum extra 150 CZK After limit application Lump sum T80 O Kc limit applied in amount 450 CZK Lump sum extra 100 CZK limit applied in amount 50 CZK Re invoicing with ltemized Statement of Services Payment Transactions data source For each calling number Itemized Statement of Services is obtained and percentage of re invoicing set in Services section is applied to each item If re invoicing of private or watched calls is defined then these items are identified and percentage of re invoicing is applied on them If any Services from Statement of Services are set for re invoicing then they are re invoiced with defined mode and percentage If any Other payments for re invoicing are included then they are re invoicing with defined mode and amount to each phone number Limits are applied according to limits settings Each limit might decrease price of linked items on re invoicing If limit type is de
10. 7 e Send report to technical support Predefined form for communication with technical support In case of detected issues you can send a message to technical support detailing your issue with CCA III application The message contains application log Correct setting of SMTP server in application settings is required In some cases sending this report may be requested by technical support T Mobile declares that no private data are sent and all information will be used solely for problem analysis and subsequent communication with You Recipients e mail address Default technical support address SFN_podpora_TMCZ t mobile cz recommended Custom defined address Customer can be changed in customer profile Contact e mail karel novak domain com pret telephone 420 555 555 555 Message x s Reinvoicing I define an email address Thank you and best regards Karel Novak Hello during sending reinvoicing by email I ve got an error message The email address is not defined Where can Report for technical support Auxiliary tools Auxiliary tools are used to solve some critical problems when CCA III cannot be started In most cases damaged configuration files is responsible for problems with starting application Configuration file might be damaged several ways for example during incorrect application or system shut down Trying to load damaged configuration file will cause application
11. Click to Exit button to exit setup Step 5 database install remove finished Used shortcuts List of used shortcuts CCA Corporate Costs Administrator SFN Czech shortcut of Corporate Costs Administrator Spr vce firemn ch n kladu l Statements of Services Invoice SSS Summary Statement of Services SSTN Summary Statement of Services by Telephone Numbers corresponds to Shortcut SS Summary Statement from CCA II ISS Itemized Statement of Services corresponds to shortcut ILC Itemized List of Calls from CCA II ISPT Itemized Statement of Payment Transactions Ribbon Ribbon menu with buttons on top panel of form like in Microsoft Office 2007 and 2010 Module Library of functions for example export re invoicing groups etc SQL Server Related database and analytics system Instance One named copy of SQL Serveru application service Database Named collection of tables inside SQL Serveru instance Versions 2 and 3 differences Description of main differences between versions CCA II and CCA III Performance Version 3 uses Microsoft NET Framework which bring new modern technologies but it also have higher memory and processor time requirements Similar to JAVA applications code of NET application is runtime compiled directly for current processor which might result in little slowdown during application modules initialization This slowdown might be seen on application startup because all necessary li
12. Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill 9 TO SFN3setupAll2008R2x86 exe Properties SFN3setupAle008R 2086 exe Type of file Application e0e Description SFN CCA III Setup Location CA Users Master Desktop Size 102 ME 107 327 736 bytes Size on disk 102 MB 107 331 584 bytes Created 14 listopadu 2011 17 31 16 Modified 14 listopadu 2011 17 31 25 Accessed 14 listopadu 2011 17 31 16 Attributes Installer properties unblock Cannot install SQL Server In recommended installation no error messages are displayed during SQL Server installation installation works autonomously If installation of SQL Server will fail user do not get any detail information In this case run installation again a select advanced installation of SQL Server this installation will inform you about any problem during SQL Server installation and can handle those Cannot run SQL Server after installation In this case it is necessary to run service manually from list of services or restart computer if services cannot be run anyway Than it is necessary to install database structure by another start of installer now without the SQL Server installation or manually using SFNDBSetup exe application Database structure cannot be created If database structure for CCA was not created on SQL Server application CCA III cannot access the database then it needs to run SFNDBSetup exe application
13. Corporate Costs Administrator II Check required components Before installing is necessary to check the status of required components Name Status Microsoft NET Framework 4 0 Client Profile All required components for installation are installed Architecture x64 64 bit Installation step 4 required components check 5 Select installation destination directory and continue by click on Next button Copyright 2015 by T Mobile Czech Republic a s 14 Corporate Costs Administrator Ill 6 Setup Corporate Costs Administrator II Select Destination Location Where should CCA III be installed Setup will install CCA III into the following folder To continue dick Next If you would like to select a different folder dick Browse C Program Files T Mobile SFN III Browse Architecture x64 64 bit Installation step 5 destination location 6 Select Start menu folder where to install program s shortcuts and continue by click on Next button 6 Setup Corporate Costs Administrator III Select Start Menu Folder Where should Setup place the program s shortcuts fl Setup will create the program s shortcuts in the following Start Menu folder To continue dick Next If you would like to select a different folder dick Browse T Mobile SFN III Browse E Don t create a Start Menu folder Architecture x64 64 bit Installation step 6 start menu folder 7 Choos
14. Re invoicing according to CCA 2 0 os gt Currently displayed table ala peda frio jp Y Color services by operators A as w Preview print Send by e mail Export Export definition Re nvoicing SA CCA Export directory C Users novak Documents T Mobi 66 76 439 87653 Re invoicing output Control buttons Copyright 2015 by T Mobile Czech Republic a s 74 Corporate Costs Administrator III 3 4 4 3 4 5 On bottom panel under the grid there are special control buttons Detail displays re invoicing detail of selected phone numbers by default all phone number are selected after re invoicing finish List return back from re invoicing detail to list of phone numbers Back return back to re invoicing settings Print On the right top side of re invoicing output dialog there is panel with control buttons for print_of re invoicing Export On the right bottom side of re invoicing output dialog there is panel with control buttons for export of re invoicing Re invoicing algorithm Re invoicing with Statement of Services by Numbers data source For each calling number Statement of Services by Numbers is obtained and percentage of re invoicing set in Services section is applied to each item If any Services from Statement of Services are set for re invoicing then they are re invoiced with defined mode and percentage
15. and install database manually Installation steps description Installation differs for each installation type description of each installation might be found in corresponding chapter Application can be installed only under user with administration rights Start installer and select language After installer start on operation system Windows Vista and newer UAC dialog might be displayed it is necessary to confirm administrator rights for the installer At first select setup language is displayed Select installation language click OK button This step is common for all installations Copyright 2015 by T Mobile Czech Republic a s 10 Corporate Costs Administrator Ill Select the language to use during the installation Installation Select language Uninstall of Corporate Costs Administrator III Application might be uninstalled from lint in start menu or directly from control panel using add and remove programs Only application and its files are removed If needed SQL Server have to be removed manually using control panel Uninstall steps description 1 Uninstall guide will ask whether you want to remove product and all its parts confirm it using Yes button Corporate Costs Administrator M Uninstall CR Are you sure you want to completely remove Corporate Costs Administrator M and all of its components Uninstall step 1 confirmation 2 Uninstall guide will uninstall Corporate Cos
16. automatic check for new CCA application version detail description might be found in chapter Check for updates In Address for getting updates field is address pointing to actual information about last application version It is possible to set how often will be automatic check for new version provided Info channel Option allow to display info channel on application main form If option is turned on and internet access is available then information from T Mobile company for example information about new version etc are displayed on main form except the image with logo Info channel is visible only when all modules are closed Rights administration Option module of application which is inactive by default It might be turned on in application parameters Rights administration allows to control who can use this application and which modules will be accessible for each user Setting of user accounts and their rights Module allows to add delete or edit users Predefined user account ADMIN cannot be deleted only Copyright 2015 by T Mobile Czech Republic a s Tools 107 6 3 2 password might be changed For each user it is possible to setup User name Password after login user can change his password It is possible to allow or restrict access to these modules and functions Download Invoices Export Re invoicing Totals Calls Extremes Statistics Groups Number nam
17. failure or fall down This problem might be solved by deleting configuration files Manual deleting of configuration file might be bit complicated because there are three types of configuration files which are stored on different places and they are also mirrored for terminal servers The easiest way to delete configuration files is to used auxiliary tools Auxiliary tools is independent application installed together with CCA II application It is installed into root directory of CCA application It can be started using SFN Tools exe file newer installation will create a shortcut called Tools in directory T Mobile SFN III in operation system start menu It is not always necessary to delete all configuration files Recommended steps for solving problem with starting application 1 Run SFN Tools exe file 2 Click Delete user configuration button 3 Start CCA III application 4 If CCA application will not start click Delete user configuration and Delete application configuration buttons 5 Start CCA III application 6 If CCA application will not start click Delete user configuration Delete application configuration and Delete installation configuration buttons 7 Start CCA III application 8 If CCA application will not start even after these steps please contact technical support Copyright O 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill 112 o 01 Auxiliary tools for app
18. install or otherwise use the Corporate Costs Administrator Ill software END USER LICENSE AGREEMENT Corporate Costs Administrator np 8 I accept the agreement 5 1 do not accept the agreement Architecture x64 64 bit Installation step 2 licence agreement the licence agreement to continue Select I 3 Select installation type and components Confirm it by click on Next button Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill 13 6 Setup Corporate Costs Administrator III Select Components Which components should be installed Select the components you want to install dear the components you do not want to install Click Next when you are ready to continue Recommended installation x Recommended configuration Advanced configuration customize SQL server Do not install Recommended configuration Advanced configuration show installer Do not run Architecture x64 64 bit Installation step 3 select installation type and components 4 Check for required components will be started If one or more components is missing installer will not let you continue Required components might differ according to selected installation components By click on component name download page of current product is open in web browser If all necessary components are installed continue by click on Next button 5 Setup
19. mass print of document on SSTN and ISS ISPT Turned Turned on off Invoices and filter Invoices Displays all invoices imported in database with information about detail Manual documents are marked with red color Each record in the grid contains special buttons for printing and viewing its details Button for printing Summary Statement of Services is hidden on invoices created before color invoices came because these Copyright 2015 by T Mobile Czech Republic a s Main modules 53 3 2 2 older invoices does not contain Summary Statement of Services For each invoice Summary Statement of Services Statement of Services by Numbers Itemized Statement of Services Payment Transactions Corrective invoices credit notes debit notes and Statement of services in PDF format might be displayed Statement of services in PDF is available only when PDF column contains red icon Print save button in right bottom corner of this module allows mass print of selected invoices and their details Invoices Corporate Costs Administrator I Invoices Display invoices for last X months only 24 LA Invoices Ey r Invoice number Date from Dateto Y Reg number Biling arrangement Contactname Bill name Amount SSS SSTN ISS ISPT Corre 3503515099 PE EEE 1601515057 5 1 2011 5 31 2011 25206122 51017289 Ing Karel Nov k ABCD s r 45 398 00 CZK 0 PE 1004517235 3 1 2011 3 31 2011 25206122 52796869 I
20. or moved to another computer Module might be open directly from CCA III application or as independent application SFN Backup exe Guide Simple guide will lead you in several steps through whole process of creating database backup or restoring database from backup Select operation At first choose which operation you want to perform backup or restore Copyright 2015 by T Mobile Czech Republic a s 96 Corporate Costs Administrator Ill Which operation to perform G Create backup wy Restore data from backup Select operation Backup restore type In next step choose type of backup or restore Each type of backup is different and cannot be combined are not compatible it means that server backup cannot be restored using user restore and vice versa Select backup restore mode Server a Backup restore full database via SQL server Ww User recommended Backuplrestore full database or selected modules Backup restore type Server Backup restore is provided using SQL server Complete database backup is made with all data table structure and indexes Database user must have necessary rights for creating backup this is not guaranteed when using own SQL server Then it is necessary start application directly on computer with SQL server or have SQL server installed locally because path to backup file will be searched locally and this might be confusing when accessing remote server
21. to filter list of invoices by special filter placed above the module in ribbon panel It is possible to display invoices only for last defined amount of months and invoices containing one certain phone number Filter settings are visible only on main invoice list it is hidden on invoice detail screens Database management Button for database management are situated in left bottom corner of this module Manual documents If original invoice was canceled on T Mobile side and replaced with manual document then this new invoice after download and import replaces the old original one This invoice might be recognized by different color row is highlighted by red color on list of invoices Original invoice is deleted from database and it is replaced with new manual document with its own new number different from the original one In details of SSTN and ISS and warning on manual document is displayed Correctness of calculated discounts on manual documents might not be guaranteed Copyright 2015 by T Mobile Czech Republic a s 54 Corporate Costs Administrator Ill 3 2 3 1 SSS Statement of Services Summary Statement of Services might be displayed using double click on any invoice row or by ellipsis button on SSS column Basic information about invoice are displayed on top panel Detail of invoice contains two tab sheets Invoices Corporate Costs Administrator I Invoices Statement of Services Summary Statement of S
22. tools for displaying print reports and charts Features of print reports were move technologically forward and some older settings used in version 2 might not be supported in version 3 Export definition file splitting and file naming In this section some corrections for quicker and easier access were done in version 3 Internet access Version 3 uses communication technology od NET so it is capable to connect anywhere where it is possible to connect using Internet Explorer Version 2 uses older components which brings some problems with internet connectivity on some networks Security Version 3 compare to version 2 has strict rules on certificates validity while using secured internet connection this affect not even invoice downloading but also email sending New operation systems support Version 3 compare to version 2 better runs on new operation systems like Windows 7 or Windows Server 2008 R2 Technology Version 3 is written for Microsoft NET Framework 4 0 Windows Forms technology which allow to use all NET technology features Version 2 uses standard Win32 API interface Database connection Version 3 compare to version 2 allows to use different database name than SEN this allow to install more then one CCA database on one instance of SQL server each with different name Summary grid overview of functions and technologies Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill 29
23. usii sndaa aia a a a 90 Tools 93 FOIdETS iia ne AA 93 Database an E A cs ccm on ess ou Les 93 Backup and FOSLORG nadaa 95 A o a EN 99 Error messages iii idad 101 PODEM SOI a ce aes Te Pt er aes 101 Wrong database AnQUAgS ES oa 101 ADPIICATION para Meters adicionan eau Inia Anno eu 102 RIGHTS administration A nette remit es 106 SMIP A O 107 CUSTOMER Prol ica aia 109 PassWord change naci tai 110 SENG ODO da 110 AMAN OS dat 111 Discounts changes after 2 28 2013 114 Help 116 Copyright O 2015 by T Mobile Czech Republic a s 4 Corporate Costs Administrator Ill Caption IX Frequently asked questions 118 Caption X License agreement 121 Caption XI Contact 124 Caption XII Version 126 Index 127 Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator III Caption Corporate Costs Administrator Ill Part Corporate Costs Administrator Ill 1 1 Corporate Costs Administrator Ill _ Application Corporate Costs Administrator III can be used to view and print copies of Statements of Services Summarized Statements or Services SSS Statements of Services by Telephone Numbers SSTN Itemized Statements of Services ISS and correction documents Credit notes and Debit notes which are issued to customers of T Mobile Czech Republic a s with CCA III you can also run analysis of telephone calls do re invoicing and export data HW SW requirements CCA III appli
24. 008 R2 P o Please wait while SQL Server 2008 R2 Setup processes the current operation Installation step 12 installation of MSSQL server 2008 Express 13 If SFN instance of MSSQL server is installed with the application then it might happen that MSSQL server installation will fail in this case below mentioned message is displayed Turn off the installer and restart computer Immediately after operation system is initialized start the installation again i MSSQL Server 2008 R2 x86 failed to install Probably need to reboot the en system before installing or it is not installed some required component After the restart run installation again Installation step 13 MSSQL server 2008 installation error 14 If SFN instance of MSSQL server is installed with the application and all conditions for installation are Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill 17 met then MSSQL server 2008 installer window is displayed This operation can take several minutes depending on computer configuration Please wait till the installation is finished FE TH SQL Server 2008 R2 Setup Installation Progress Installation Progress Initializing Windows Installer actions Next gt Cancel Help Installation step 14 MSSQL 2008 installer j 15 If CCA database is installed with the application and system requires restart after MSSQL installation then in
25. Czech Republic a s 102 Corporate Costs Administrator Ill 6 3 Cause Unknown This was not replicated yet CCA database installer always set database language to czech and this setting is taken by database table columns during creation so it is theoretically impossible to achieve this state without manipulation with database structure Indication Incorrect display of diacritics in text loaded from database This can be seen for example on invoice prints or on naming module Missing diacritics is unfortunately lost and cannot be recovered elsewhere than manually Solution 1 Create user backup of current database Beware of user backup limits This procedure does not always apply 2 Install new_database using SFNDBSetup exe tool In database connection setting set new name of database for example SFN2 3 Set database connection to new database in CCA application To field Database set new database name 4 Restore user backup from step 1 to new database 5 Manually correct missing diacritics in all modules where it is possible 6 Fixing of language setting on documents 6 1 For downloaded documents it is possible to add missing diacritics by deleting and re importing of these documents Warning this procedure can be used only for document two month old for older documents detail itemized list is not available anymore 6 2 Alternative for previous step is to delete invoices and run import of previously downloaded
26. Download data to Download directory C Users novak AppData ocal T Mobile SFN III Data 4 Download data Open module Download after application start Determines whether module Download might be open after application start Automatic module download is always opened on application start On request on application start user is ask if the module download might be opened Do not open module download and even no request is displayed on application start Download data to Defining of directory where all downloaded documents in XML format are stored Connection Communication parameters settings Copyright O 2015 by T Mobile Czech Republic a s Tools 105 Application parameters Download data Connection User management Application update SMTP server for sending emails er smtp com Test IT Use proxy Sender s e mail address Security TLS SSL V SMTP server requires authentication novak domain com Authentication method Autodetection Reply to User name novak domain com Password bussines domain com Expand Connection to T Mobile server Primary address https sfn t mobile cz sfn 4 Switch addresses Secondary address 4 Type of connection Direct connection A E re Use proxy server User name Password ae a PA Pripojen SMTP server for sending emails SMTP server settings for sending e mails More info
27. N III Setup type Recommended installation Selected components Architecture x64 64 bit Installation step 9 summary information 10 Progress of copying files please wait till the operation is finished Copyright 2015 by T Mobile Czech Republic a s 16 Corporate Costs Administrator Ill i Setup Corporate Costs Administrator III Please wait while Setup installs CCA III on your computer TO C Program Files T Mobile SFN III DevExpress Utils v 10 2 dll Architecture x64 64 bit Installation step 10 copying files 11 If SFN instance of MSSQL server is installed with the application then extracting of files for MSSQL 2008 installer is started after files copying is finished this operation can take several minutes depending on computer configuration Please wait till the extraction is finished Extracting Files Extracting File 64 setup sql_engine_core_inst_msi pfiles sqls To Directory C Users eee App Data Local Temp is F laa LL SS Installation step 11 extracting of files for MSSQL 2008 installer 12 If SFN instance of MSSQL server is installed with the application then installation or SFN instance of MSSQL server is started after files extraction is finished this operation can take several minutes depending on computer configuration installer windows might be displayed during installation Please wait till the installation is finished SQL Server 2
28. P servers sending e mails without user authentication because of protection against spam messages Most of private SMTP servers in companies uses additional security rules for user authentication Copyright 2015 by T Mobile Czech Republic a s 108 Corporate Costs Administrator Ill Authentication method Method used for user authentication message encryption against SMTP server Automatic application will try to get list of accepted authentication methods from SMTP server and pick one of them Recommended setting TLS simple text authentication standard RFC 2595 Digest MD5 authentication standard RFC 2831 Cram MD5 authentication standard RFC 2195 Name and password standard authentication method using name and password NTLM uses user authentication in domain by NTLM protocol This method does not allow to specify user name and password integrated Windows security is used instead GSSAPI SSPI Kerberos uses user authentication in domain through GSSAPI SSPI provider using Kerberos protocol This method does not allow to specify user name and password integrated Windows security is used instead GSSAPI SSPI NTLM uses user authentication in domain through GSSAPI SSPI provider using NTLM protocol This method does not allow to specify user name and password integrated Windows security is used instead GSSAPI SSPI Negotiate SPNEGO uses user authentication in domain through GSSA
29. PI SSPI provider using Negotiate SPNEGO protocol This method does not allow to specify user name and password integrated Windows security is used instead User name Name used for authentication against SMTP server Name is used for some authentication methods Password Password used for authentication against SMTP server Password is used for some authentication methods Addresses Sender s e mail address e mail address displayed on e mail message as sender Reply to e mail address which will be used when user will try to reply on e mail message If not defined sender e mail is used instead Advanced settings Contains advanced settings for sending e mails through SMTP server design for expert users By default only security setting is displayed Button Expand displays the rest of settings Security Disabled secured communication is turned off Connection to SMTP server is realized without information about supported protocols and encryption None secured communication is turned off but connection to SMTP server is realized with information about supported protocols and encryption TLS SSL insecure communication to SMTP server is established and then it is switched to secured communication using TLS or SSL Only TLS SSL secured communication to SMTP server is established directly using TLS or SSL Most of servers does not accept this type of connection Allowed protocols Determines which securi
30. a s 50 Corporate Costs Administrator Ill 3 1 2 User information Settings O Download all available invoices Username k most Download only invoices from the specified date Password XXXXXXXX Login and settings Login and download list of invoices After filling of name and password and click on Log in button the connection with TMCZ server is established and user login is verified and if login is verified list of available invoices is prepared and return to application Connection status and download progress is displayed in special download dialog Log in to T Mobile server o Downloading invoice fist Account lock While accessing the T Mobile server one of below mentioned error messages might occur Account is temporary locked Probably incorrect password was entered 3 times in last 24 hours P adres is temporary blocked Probably incorrect password was entered from this IP address several times in last 24 hours Account is temporary locked Locked on the system level LDAP Account is locked Locked on the system level LDAP Download invoices Display list of invoices After successful login to server list of invoices available for download is displayed List is displayed in the grid where already downloaded and imported invoices are marked with dark gray color If last column called PDF contains red icon of PDF document than this invoice i
31. abase installer SFNDBSetup exe This application is installed with application to subdirectory DB of CCA III application directory By default you might be able to find it on path C Program Files T Mobile SFN 111 DB SFNDBSetup exe This application is also used by standard installer in recommended settings but if needed it might be started by user manually to install CCA database to selected server CCA database language CCA III database installer automatically set database language to czech Czech_Cl_ AS Installation steps description 1 On first screen select installation type whether it install or remove database Confirm it by click on Next button Hy Setup type Choose the setup type that best suits your needs Install CCA database to your computer Remove CCA database from your computer Step 1 select installation type 2 For both installation types database connection settings are displayed Here you can select standard connection settings to SFN instance of SQL Server which is installed using CCA III installer or select advanced settings and define connection to database server for creating removing database manually It is also possible to set different database name than SFN Confirm settings by click on Next button O care mi D D Install database connection settings Y Choose the database connection type for installation Standard The setup will connect SFN instance MSSQL on local computer with defau
32. abcd PROFILE Export ISS for SAP EXPORTPATH C CCA Export SAP Only data export user management disabled SFNC exe EXECUTE EXPORT PROFILE Export ISS for SAP EXPORTPATH C CCA Export SAP Create batch file SFNC exe CREATESECUREBATCH EXECUTE DOWNLOAD EXPORT LOGIN smith PASSWORD 123abcd SENLOGIN smith SFNPASSWORD smi 123 xAz PROFILE Export ISS for SAP EXPORTPATH C CCA Export SAP BATCHFILENAMEBE C CCA CCA EXPOrtscma Exit codes 0 success 1800 runtime error 1900 unauthorized syntax 1901 EXECUTE parameter not defined 1902 TMCZ credentials not defined 1903 profile not defined 1904 batch file not defined 1905 encrypted data not defined 1906 illegal syntax 2000 configuration not exists 2001 unable to connect database 2002 database need update 2003 undefined database version 2004 bad CCA database 2005 database not initialized 2006 login required but not defined 2007 bad user name or password Copyright O 2015 by T Mobile Czech Republic a s 44 Corporate Costs Administrator Ill 2 9 2008 database connection lost 2009 profile not exists 2010 export definition not exists 2100 error creating secure batch 2101 download error 2102 export error Final report Result of several operations such as download and import of invoices export re invoicing etc is displayed using spe
33. able to check database version and compatibility with CCA Ill CCA III is compatible with database version 41 which corresponds with CCA Il version 2 1 37 129 or higher If older version of CCA II is installed it is necessary to update CCA II application update will actualize database and will guarantee compatibility with CCA III 2 Create database backup on first computer in CCA II Run CCA II application select Tools option from menu and choose item Backup and restore On Backup tab sheet create complete database backup Backup of modules from CCA II is not compatible with any backup type of CCA III Only one compatible backup type between CCA II and CCA III are Complete backup in CCA II and Server backup in CCA III Show Analysis and graphs Setting Tools Help Main menu Backup Restore Complete backup Complete backup saves full content of database to file including invoices You will restore all data from complete backup Backup filename C Users novak Documents T Mobile SFN IT CCA backup from 22 me Modules backup Modules backup allow to backup only selected modules You can also select only particular modules to restore during restore operation VW Number naming Groups Prnfilsc Database backup in SFN II 3 Moving backup to second computer It is necessary to transfer backup file to second computer using CD DVD flash FTP shared directory on network etc Move backup file to direc
34. ad dala 2e di es Re M tie 49 eTel a ON a EE E E A Alia 49 Download invoices a ee ce ice nca G o ae elec 50 2 HAW OIC OS LE daa 52 INVOICES Ani TOR conan ii 52 Manual documents a a ne a 53 EEI nt e a ld O os Den en ue E 54 SSTN ca e e e Os ROD da RR IIT ST OND nn re ete ue nr 55 ISS SPV ee e de dd ee ie ie 56 Correclive MVOICES A A A 57 INVOICES DIM lt sia 58 Database O O e a dd 59 A Et dd ered denen 60 Ei PS PR ER ARR A e RS ER ARRETE DIET ERREURS SRE EE RES AR EN RAILS 61 EXPO CIE HINITIONE SES ne in ed dat ess ni eine tes ends es teens sue ee tan RE 62 Copyright 2015 by T Mobile Czech Republic a s Content 3 Caption IV Caption VI 1 2 Y on BR Caption VII Caption VIII Splitting and TE MAMIAG 2222522858 anaua anaa tenu a ania re eee editer ns 68 EXPO AE SRE eee Re ee RER RER nn en N 68 SENG DY CM aria AA A AAA AAA ANA AA AA A ia cri 69 ROSINVOICIN O rita A aid 70 ai LA CE ER RAR Eee RER RER ARR 70 A en eee en conne cannes cit aE aa dm nn cn nosces ten ee te ce El en 71 Display FC INVOICINQ cita ia a 73 Re INVOICINO ADO OM sr ner nee nennncne nn A A trees t encre ne 74 PANE E 74 EXPO A e e E peee 75 Send Dre ase 76 Analysis and graphs 79 Piter cleats a E AAE AEO t a AG kccs 80 Totals e NT 81 Calls pio OEE 82 EX OMES oia 83 SaS CICS iaa oia creido 83 Graph Settings decai 84 Settings 86 GrOUPS nr en ii 86 Number RAMA odia 87 EUNIS aaa 88 Private calls nana 89 Watened Cals
35. ad Invoices Export Re nvoicing Totals Calls Extremes Statistics data Administrato ssssessssessseseseueses 4 Mobile aa MAA Server APC1007 SFN Database SFN Main application form Main application menu Main application menu with additional functions are displayed by click to a round logo button in left top corner of the main form Copyright 2015 by T Mobile Czech Republic a s 32 Corporate Costs Administrator Ill Corporate Costs Administrator M About Information about provider and program version Corporate Cost Administrator TI Web T Mobile 3 12 Visit T Mobile homepage Send report Send report to technical support Customer profile Allows to set customer identification data Change password Allows to change password of currentty logged in user Check updates Search and download application updates Exit Exit the application _ SE Main application menu Info channel Application logo is displayed on main form empty working place which is used for displaying modules If displaying of info channel is enabled in application parameters and computer is connected to internet than after successful download an info channel is displayed Info channel is displayed only when no other module is opened Application menu Functions and modules are available from ribbonu tabbed menu on top part of main form Menu is accessible using mouse or keyboard by
36. agree thereto without reservations If you do not agree to these terms and conditions you may not install or otherwise use the Corporate Costs Administrator 111 software END USER LICENSE AGREEMENT Corporate Costs Administrator 111 1 SOFTWARE copyright The title and copyright to the Corporate Costs Administrator III software SOFTWARE are owned by T Mobile Czech Republic a s T Mobile which is authorized to grant the right to use the SOFTWARE to the extent specified below This EULA is an agreement between the end user of the SOFTWARE an individual or a legal entity and T Mobile concerning the SOFTWARE including a computer program and may contain documents in paper or electronic form Statutory protection of SOFTWARE The SOFTWARE is protected by Copyright Act No 121 2000 Coll as amended as well as by the related legal regulations in particular by international copyright agreements The end user shall adhere to any and all legal regulations governing the statutory protection of the SOFTWARE Scope of the licence agreement T Mobile hereby grants to the end user a non exclusive non transferable and temporally unlimited right to use the SOFTWARE The end user may use the SOFTWARE only in accordance with this EULA in the ways specified below Use of SOFTWARE Based on this EULA an authorized end user may 1 install the SOFTWARE 2 copy the SOFTWARE for their personal needs 3 use the SOFTWARE only for the inten
37. alysis and graphs 79 4 Analysis and graphs Module allows to display different analysis in grid table or using graphs Common analysis properties Type of analysis and chart All analysis modules have list of analysis types on the left side Analysis result might be displayed as grid table or chart Chart view does not contain all important data from table view Settings Settings on the right side might be different for each analysis It usually contains setting of value for chart axes number naming settings etc Control buttons Options button switch module to analysis selection and settings it is active only on table or chart view Table starts analysis calculation and displays result in table view Same effect will have double click on analysis name in list of analysis types Graph starts analysis calculation and displays result in chart view Control buttons Table view buttons On the right side of panel below the analysis table view there are special control buttons Preview print shows report preview of currently displayed analysis Export allows to export currently displayed analysis to defined file format Preview print Le Export Buttons below analysis table view Chart view buttons On the right side of panel below the analysis chart view there are special control buttons Settings opens dialog for editing chart properties Preview print shows chart preview of cur
38. alysis and graphs 79 Analysis by day 83 Analysis by day in the week 83 Analysis by hour of day 83 Analysis by months 83 Analysis filter 80 Application 31 Application help 116 Application log 47 Application manual 116 Application parameters 102 Application settings 102 Auxiliary tools 111 B Backup 96 98 Backup and restore 93 95 Backup file 97 Batch mode 42 Browser 8 Busiest day by number of calls 83 Busiest hour of day by number of calls 83 C Calls 82 Calls analysis 82 CCA 6 26 CCA2 26 CCA3 26 CCA Il 26 CCA III 26 Certificate validity 40 Certificates 40 Changes 114 Check 51 Command line 42 Confidentiality 61 71 Configuration 111 Connected database 31 93 Connection 40 104 Connection settings 94 Contact 124 Contact information 109 Corporate Costs Administrator 6 Corrections 57 Corrective invoice 57 Credit Note 57 Customer profile 109 D Data 93 Database 6 24 26 93 95 99 Database backup 95 Database connection settings 93 Database errors 101 Database installation 24 Database language 101 Database management 59 Database migration 99 Database restore 95 Database settings 94 Debit Note 57 Delete invoices 59 Detail 55 57 Discounts 114 Discounts button 52 Document 54 Documents 93 DOTNET 6 Download 51 Download data 49 104 Download invoices 49 50 Download list of invoices 49 Copyright 2015 by T Mobile Czech Republic a s 128 Corporate Costs Admi
39. ample Notice SMS has usually zero price and is not included in SSS SSTN but SMS for free to T mobile has also zero price and even though it is included in SSS SSTN Free units Analysis is based on SSTN and displays count and percentage of free units Analysis might be calculated for phone numbers groups or combination of both Analysis contains bar chart with option of units count or percentage on vertical axes Number naming might be turned on and naming columns defined for calling phone numbers VPN calls Analysis is based on ISS ISPT and displays calls length and price in and outside VPN Analysis might be calculated for phone numbers groups or combination of both or also for project codes Analysis contains bar chart with option of price or call length on vertical axes Number naming might be turned on and naming columns defined for calling phone numbers Volume discounts Analysis is based on Invoice SSS SSTN and displays price before discount price with discount and Copyright 2015 by T Mobile Czech Republic a s 82 Corporate Costs Administrator Ill 4 3 discount Analysis might be calculated for invoices or services Private calls Analysis is based on ISS ISPT and displays calls count SMS MMS amount of transferred data calls length and charged price Analysis might be calculated for phone numbers groups or combination of both or also for project codes Analysis contains bar chart with optio
40. and database structure to your own instance of SQL Server 3 Migrate database between old and new instance of SQL Server it it same like migration between two computers It is possible to create new CCA III database and the current one keep as backup for older data which you may return to when needed In this case it will not be able to work with old data in original database and with new data in new database together 1 Install another CCA database and database structure database must have different name than existing database SFN 2 Manually or using user backup transfer application parameters setting from original database to newly created database 3 Download new invoice only to the newly created database 4 Switching between databases is done by changing database name in database connection setting When using full version of your own MSSQL Server In this case contact your database administrator If you will have any questions please contact our technical support Problem solving List of instruction for solving different problem on database Wrong database language Wrong database language Error text After application start this error message is displayed Database or some table columns are in wrong language Error message is generated by CCA application after unsuccessful database or database table columns language check Language check is run after each application start Copyright O 2015 by T Mobile
41. ault when opened Automatically offer nameless numbers to be named if turned on then after invoice download containing new nameless numbers application will be switched to number naming module and nameless numbers will be offered to be named Warning Turns on off displaying of manual invoice warning in Invoices module when viewing detail of SSTN or ISS ISPT Warning is display as top panel of these dialogs Export Turns on usage of predefined format for dates numbers etc when exporting to Excel Automatically open the file Option allows to open exported file using quick export with associated application Visual effects Copyright 2015 by T Mobile Czech Republic a s 104 Corporate Costs Administrator Ill If option is turned on and module containing filter in ribbon is displayed then filter flashes several times to be noticed be user Timeout for database operations Limit in second for database request if this limit is exceed the error report is displayed For customers with huge amount of data it is recommended to increase this limit Import data Option turns on quick bulk inserting to database Function might be used only when SQL server is installed on local computer same as CCA application Download data Contains settings for downloading invoices Application parameters xl E e Open module Download after application start Automatic On request Do not open
42. be in size of tens of MB so import of these data might take even tens of minutes Download el signed Statement of Services PDF if available allows to download and import Invoice in electronically signed PDF document form Options also contains special buttons helping with mass selecting of invoices for download and import Control buttons Invoices check starts special function for check of completeness of already downloaded and imported invoices Print grid Export grid Download starts download and import of selected invoices Log off return to login screen Legislative restrictions impact Detail services statement for invoice is according to legislative restrictions available only for last two month Detail service statements for older invoice cannot be downloaded any more Invoices check This special function check completeness of invoices stored in CCA application database If for example customer orders ISS to already imported or any option for downloading additional documents was unchecked during import then this function will allow you to add additional document to the invoice Function checks if invoice in database contains all ISS and PDF available on TMCZ server Progress of this operation is displayed using special dialog After the check is finished result of the operation is display in report Download and import of invoices During downloading XML files with data are stored in directory spec
43. ber turns on off displaying of Most called number graph for each phone number on re invoicing report graph is situated below the grid with re invoicing of current phone number Telephone numbers to separate pages options defines whether re invoicing of each phone number will start on separate page Color services by operators option will color services on graph Totals by destinations according to operators Control buttons Preview print displays re invoicing report preview for actually selected phone numbers preview allows to manage print and page settings and also export report to several file formats Send by e mail sends re invoicing report in PDF format via e mail 3 4 6 Export Export of re invoicing is similar to export of invoices in export module allows to export data from re invoicing in defined format Format of output data is defined in export definition It is also possible to send export via e mail Export Export definition Re4nvwoicing SSTN SFN Export directory C Users novak Pocuments T Moabi gt Export Send by e mail Export of reinvoicing Settings Export definition quick option allowing to select export definition button opens dialog with re invoicing export definition allowing to setup splitting and file naming Export directory destination directory for saving re invoicing export files Button on right side of the edit field allows to select di
44. braries of NET Framework are loaded Basically some functions of version 2 are faster than version 3 and otherwise Design Version 3 was completely redesigned compare to version 2 application main menu and side panel Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill 27 navigator of version 2 were transfer to Ribbon If internet connection is active in version 3 then information channel will appear in a while on main form replacing static picture from version 2 amp amp Corporate Costs Administration II Show en an a Setting Tools Help Main menu Upgrade to new version SFN III More information SFN II support ended 6 30 2011 gt ve u ER ff tl CE Analysis and graphs Setting orporate Costs Administrator I aes ine aane y a wre ie Aeon a MAA Server APC 1007 SFN Database SFN CCA III application main form Filters In version 3 analysis filter invoices filter and data source selections for export and re invoicing were moved to separate tab sheet on ribbon for quicker and easier access Copyright 2015 by T Mobile Czech Republic a s 28 Corporate Costs Administrator Ill Invoices orporate Costs Administrator I Statement of Services by Numbers Itemized Statement of Services Paym Trans Analysis and graphs CCA III filters Prints and charts Version 3 contains new
45. by Microsoft company as Supported for SQL Server 2008 R2 installation It is not recommended to install SQL Server on computer which is configured as domain controller If domain controller is detected then SQL Server installation can be run only in advanced mode Other necessary software Microsoft Internet Explorer 6 SP1 or higher For proper work of CCA III application we recommend at least version 8 Windows Installer 3 1 or higher enough version for installation without SQL server Windows Installer 4 5 or higher minimum version for installation with SQL server Windows PowerShell 1 0 or higher compatible with version 1 0 only for installation with SQL server Microsoft NET Framework 3 5 SP1 only for installation with SQL server Adobe Reader 7 0 5 or higher with time signatures support Installation of required components Some required components for example Microsoft NET Framework is possible to install using system build in functions This is recommended mostly on newer operation systems Windows Vista 7 2008 8 2012 Control panel gt Programs and Features gt Turn Windows features on or off Unsupported operation systems Windows XP Due to end of manufacturer s support Windows Server 2003 Due to end of manufacturer s support Linux Unix Mac OS All other that was not released by Microsoft company and does not have support for Microsoft NET Framework CCA can run on these unsupported systems only in
46. cation Corporate Costs Administrator III requires computer compatible with operation system Microsoft Windows Application CCA III is designed for Microsoft NET Framework 4 0 which is not part of standard installation Microsoft SQL Server is used as application data storage and it is included in standard installation Application CCA III is build to run on any hardware architecture 32 bit or 64 bit According to operation system architecture CCA III process is started in 32 bit or 64 bit mode HW and SW requirements of CCA Ill application are based on requirements of used components and technologies Microsoft NET Framework 4 0 There are two versions of Framework 4 0 CCA III runs on both of them Microsoft NET Framework 4 0 Client Profile Small and compact version containing all that CCA III needs it is possible to download and install it using Windows Update service or on Microsoft Update Microsoft NET Framework 4 0 Full Full version available on address http www microsoft com download en details aspx id 17718 Microsoft SQL Server There are several version of SQL Server CCA III can work with versions 2000 2005 2008 2008 R2 2012 and probably also with new future versions Standard installation of CCA III contains installation of Microsoft SQL Server 2008 R2 Express 32 bit 64 bit It is free version of SQL Server which has some limitations these limitations can impact downloading new data into CCA III applicatio
47. cial dialog like well arranged graphic report Report is in HTML format more precisely XHTML 1 0 and it is displayed using COM object WebBrowser of Internet Explorer applicaiton Report contains inline graphics which requires installed Internet Explorer version 8 or higher to be displayed properly Report has several kinds of information and each kind uses different font color Statistic including duration of operation is presented on the end of the report Report is design as log of the operation which affect the result statistics If report contains an error record there are usually separeted into two error notes error description and error message which means that in report statistics it will be count as two errors Navigation buttons left to right Save save current report report to file HTML TXT Copy as text copy the current report to clipboard as plain text Copy as HTML copy the current report to clipboard in HTML format Print display print preview of the current report Send report display dialog for sending report to technical support Close close report Arrows down and up are displayed only when report contains any warning or error records allows to quick navigation between those records Open directory button is displayed only if operation is connected whit any file or directory for example export operation button opens the specific directory A E Download import final report Dow
48. click on ALT key this key displays for each item an activation key gan a 0000000860 lr Invoices Export Re nvoidng Totals Calls Extremes Statistics Groups Number Limits Private Watched naming calls calls Ribbon Quick help All buttons and some special edit boxes displays additional help in hint Hint is displayed after pointing with mouse cursor on current button or edit box Display print preview with possibility to print the table or export to various formats Bubble help Quick module navigation Modules with filter panel have an additional button in left corner which allows an quick navigation to Copyright 2015 by T Mobile Czech Republic a s Application 33 another module Modules Tools Download data Invoices a Export Re invoicing Quick module navigation Logged in user If rights administration is allowed in application parameters logged in user is displayed in top right corner of main form of CCA application User NOVAK Logged in user Connected database Information about server name and database name is displayed in bottom right corner of main form Server APC 1007 S5FN Database SFN Connected database SQL request progress Application load and save data from database During processing of database operations an SQL text with animated progress bar is displayed in left bottom corner of main form Some database operati
49. d and invoice number is set with file naming mask period INV invoicel csv then final export of invoices Jan0000001 Jan0000002 and Feb0000003 for period January and February of year 2011 will be split to files 01 2011 INV_JanOO0001 csv 01 2011 INV_J an000002 csv 02 2011 INV_Feb000003 csv Export The export to file according selected definition to chosen destination directory is started by Export button Progress Copyright 2015 by T Mobile Czech Republic a s Main modules 69 Status of operations is displayed using progress on special dialog Result After finishing the export result is displayed in final report which contains list of exported files and total export time Dialog contains button Open directory which allows to open export directory of currently finished export in Windows Explorer 3 3 5 Send by e mail Sending export according selected definition by email is started using Send by e mail button At first a dialog for setting message subject file name message body and recipient address is displayed E Send by e mail Send by e mail User data export Export csv Dear user custom defined export is attached Your CCA E mail address Split by groups and send by e mail to group address Split by phone num and send by e mail to address according to num naming Sending export Masks Message subject file name a
50. d application for opening PDF file generated from CCA III application what can do It is necessary to download and install PDF viewer Adobe Reader 7 0 5 or higher with time signatures support We recommend to always install the latest version of PDF viewer Latest version of Adobe Reader can be downloaded from address http get adobe com reader Connecting to TMCZ I ve got problems connecting to TMCZ server what can I do For proper work of application it is necessary to allow access to IP address 62 141 16 202 port 443 https sfn t mobile cz sfn To verify wether this address is accessible in your network it is possible to type verifying address https sfn t mobile cz sfn hello to your internet explorer If access is enabled then below mention lines will appear in your explorer in several seconds lt xml version 1 0 encoding UTF 8 gt lt sfnServlet gt lt version gt actual version lt version gt lt sfinServlet gt Warning Internet explorer after user interaction allows to connect to server even if server certificate was not accepted and verified application CCA III does not allow to connect to server without verifying of its certificate More information about this topic can be found in chapter internet connection Incorrect certificate error occurs when connecting to TMCZ or while sending email what can do Solution of this problem is described in chapter internet connection Copyright 2015 by T M
51. d the functioning of other applications In the event of incompatibility of the SOFTWARE with other applications as well as in the event of limited functioning of other applications as a result of installation or use of the SOFTWARE the SOFTWARE may be uninstalled When installing uninstalling and using the SOFTWARE the end user shall proceed in accordance with these terms and conditions and the User s Manual T Mobile shall not be liable for any damage resulting from the fact that the end user acted at variance with these terms and conditions or the User s Manual The end user and T Mobile have hereby agreed that the aggregate foreseeable damage that may be incurred by the Copyright O 2015 by T Mobile Czech Republic a s 122 Corporate Costs Administrator Ill end user in connection with the use of the SOFTWARE hereunder shall be limited to CZK 500 Term of licence agreement This EULA has been entered into for an unlimited period effective from the date of the end user s confirmation of consent to this EULA Either of the parties may withdraw from this EULA in the event that the other party breaches the obligations specified herein and if remedy is possible fails to remedy this breach within 30 days of the delivery of the notice of such breach of obligations to the other party Following the termination of this EULA the end user shall immediately destroy or delete the SOFTWARE including all of its copies and documenta
52. ded purposes as specified in the SOFTWARE user s manual User s Manual The user acknowledges that the SOFTWARE may be used only on a computer that meets the technical criteria specified in the User s Manual Limitations of use of the SOFTWARE The SOFTWARE may not be 1 copied for needs other than the personal needs of the end user in particular it may not be copied for commercial purposes 2 redistributed 3 leased 4 sublicensed 5 lent or 6 modified or otherwise altered by the end user The SOFTWARE may not be reverse engineered modified decompiled or disassembled The end user may not modify or remove the copyright notice or other identification signs of the SOFTWARE Limitation of liability This EULA is a gratuitous contract which means that the SOFTWARE is provided free of charge Therefore the performance under this EULA is not related to liability for defects on the part of T Mobile T Mobile does not guarantee that the SOFTWARE will be suitable for a particular purpose that it will be fully functional and free of defects Thus T Mobile shall not be liable for any potential damage resulting from the inability to use the SOFTWARE T Mobile shall also not be liable for any potential damage incurred as a result of data loss destruction or damage as a result of the end user s utilisation of the SOFTWARE In the case of installation of the SOFTWARE T Mobile does not guarantee the compatibility thereof with other applications an
53. displays all numbers regardless of naming definition Only unnamed numbers displays only numbers without defined naming Only named numbers displays only numbers with defined naming If filter for unnamed or named numbers is applied and user defines naming or clears naming of any number than after changes confirmation record with this number will became hidden because it does not fit the filter any more Number naming METAS prem Reg number BA Biling address Contact add Tariff E mail Name Surname Limit MojeDatum a 38303 383031111 383032011 383032442 Pavel Nov k 383032450 383032484 383033440 383033614 383034014 Petra Nov kov EE A E E 383034200 383034227 383034306 Display Filter Calling numbers Called numbers All numbers No numbers filter Only unnamed numbers Only named numbers zx ojo Number naming Buttons Special buttons and are situated on right side of bottom panel these buttons allows to add or remove phone number to from number naming Naming columns List of naming columns First column contains checkbox defining visibility of column in number naming Second column contains user defined name for naming column Buttons below the grid allow to change order of displayed naming columns Copyright 2015 by T Mobile Czech Republic a s 88 Corporate Costs Administrator Ill 9 3 Number naming x as ronron Fi
54. documents This allow to import also previously downloaded detail services statements This step may be used only when user has on local disk downloaded documents including detail statements which user wants to access in CCA application Application parameters Configuration of application functions Module has five tab sheets which includes settings of specific type Most of the parameters is store in database and common for all users Some parameters like application language are stored in file configuration and might be different for each application user On the right side of bottom panel there are two buttons Button Save saves all changes Button Cancel discards all unsaved changes Cancel Control buttons General Contains general settings of basic application functions Copyright 2015 by T Mobile Czech Republic a s Tools 103 Application parameters x conca Download data Connection User management _ Application update Application language Currency format Language English Angli tina Currency format 42 2 220 00 CZK Groups Project codes F Allow to add one telephone number to more groups T Project codes support enabled Number naming 7 Use number naming F Use number naming by default F Automatically offer nameless numbers to be named Warning Export Y Display warning about manual invoices When exporting to Excel workbo
55. e database When sharing CCA application on company network with more users it is useful to specify the profile name precisely to avoid duplicit and confusing profiles always think that profiles are visible for every user on the same database Logging Application automatically generates an log file where application run is monitored Creating of log file is automatic and it cannot be switched of or setup Log files are created inf local application data directory in users profile Log is not design to be readable but it might be processed using computer Application keeps only last five logs older log are automatically deleted When sending report to technical support all existing log are attached to the report and sent for analysis In most cases log helps to localize identify problem For monitoring activity of user working with CCA application an database log in application parameters is used Announcement T Mobile Czech Republic a s company declares that all log file is used only for application run analysis No personal data are purposely collected All data are processed according to low for protecting personal data no 101 2000 Dg in full text of the Act What is logged Basic information about application version and operation system it runs on Initialization operations Opening of modules Running of specific operation on modules Operation final reports Detail description of invoice import progress Errors includi
56. e memory requirements suitable for 64 bit systems Compact Slower has a small memory requirements suitable for 32 bit systems User backup Copyright 2015 by T Mobile Czech Republic a s Tools 99 6 2 1 1 Database restore Server Select file containing database backup and database to be restored Button Run will start database restoration E Server restore Restore settings Filename with path C Wsersovak Documents T Mobile SFN IIT Zaloha SFN3_2011 07 27 server backup Database being restored Current CCA III database Server APC1007 SFN Database SFN Another database Server restore User Select file containing database backup Button Load will load file content a displays list of modules included in backup file Button Info displays information about backup file Select database to be restored Button Run will start restoration of selected modules W User restore Restore settings Filename with path C Users novak Documents T Mobile SFN III Zaloha SFN3_2011 07 27 user backup hi Info Select modules to restore Invoices and configurations Limits Settings Export definitions Private calls Database log Y Groups Watched calls Y Number naming Profiles Database being restored Current CCA III database Server APC 1007 SFN Database SFN Another database Restore method e Default Fast has a large memory requirement
57. e numbers belonging to group Phone numbers might be added and deleted using and buttons below the grid Checkbox Including members in subgroups defines if list of phone numbers will contain also numbers from subgroups of current group Possibility of adding one number to more than one group is defined in application parameters Phone numbers might be moved between groups using drag amp drop method Limits definition of limits for current group of phone numbers Limits might be added and deleted using and buttons below the grid Copyright 2015 by T Mobile Czech Republic a s Settings 87 9 2 Number naming Number naming is universal and easy way for extending of phone numbers identification Naming structure might be design be user himself There are 15 free fields which might be named and included to phone number naming It is possible to set naming for all phone numbers that means calling and called numbers Module contains the tab sheets Tab sheets Number naming Tab sheet contains phone numbers and naming columns for editing Active naming columns for editing might be configured on Naming columns tab sheet Options Additional options are displayed below the grid Display Calling numbers includes calling numbers to the grid Called numbers includes called numbers to the grid All numbers includes calling and called numbers to the grid Filter No numbers filter
58. e numbers or all phone number whit tariff in specific list of tariffs which will be included in analysis Destination Selection of specific list of services destinations or called phone numbers or all items which will be included in analysis Settings Additional settings affects output column formats of some analysis Confidentiality How many digits in phone number from the right will be replaced by X character for keeping privacy If value is set to 3 then phone number 603111111 will be displayed as 603111XXX Generated items Copyright 2015 by T Mobile Czech Republic a s Analysis and graphs 81 4 2 Option allows to include generated items items from SSS added to ISS ISPT to analysis Time format Selecting time unit of analysis output Second or minutes Display price Option allows to include exclude discount from prices entering the analysis Option is available only when any invoice contains charge extract Data If filter is change on displayed analyses then it is possible to actualize displayed analyses using Re calculate button This will re calculate all values according to new filter Totals Totals module contains analysis of aggregating values for different indicators Type of analysis Totals Analysis might be calculated from SSTN or ISS ISPT and displays calls count SMS MMS amount of transferred data calls length and charged price Analysis might be calculated for phone numbers gr
59. e of column this name will be displayed in header of final export Header style setting of column header design font font color and alignment This settings is available only for Excel workbook Office 97 2003 XLS and Excel format XLSX formats Value selection of database field which value will be filled to final export Cell style setting of column cells design excluding header font font color and alignment This settings is available only for Excel workbook Office 97 2003 XLS and Excel format Copyright 2015 by T Mobile Czech Republic a s Main modules 63 XLSX formats Column definition buttons Control buttons are situated above the export columns grid Add column adds new column to export definition Remove column removes column from export definition Up moves actually selected column one position higher in the grid Down moves actually selected column one position lower in the grid Export settings File format Export support several different file formats Others setting options might differ according to selected file format Text file separated by semicolon CSV Text file TXT allows to set own separator or fixed length of text HTML file HTM XML file XML Excel workbook Office 97 2003 XLS Excel format XLSX Totals This option is same for all file formats Amounts without sums final export contains
60. e wether you want to install other shortcuts and continue by click on Next button 6 Setup Corporate Costs Administrator III Select Additional Tasks Which additional tasks should be performed Select the additional tasks you would like Setup to perform while installing CCA III then dick Next Additional icons IV Create a desktop icon Architecture x64 64 bit Installation step 7 other shortcuts Copyright O 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill 15 8 Optionally it is possible to fill information about Your company for future usage during communication with technical support and continue by click on Next button 6 Setup Corporate Costs Administrator II Customer information Basic data for communication with technical support from T Mobile Contact information will be used for contacting technical support from SFN III application Architecture x64 64 bit Installation step 8 customer information 9 Displays summary information about selected components for installation including destination directory and other options click button Install to start installation 5 Setup Corporate Costs Administrator II Ready to Install Setup is now ready to begin installing CCA III on your computer Click Install to continue with the installation or dick Back if you want to review or change any settings Destination location C Program Files T Mobile SF
61. ecipient addresses and total sending time If export was not sent then dialog contains warning for example missing group or phone number email address or error for example incorrect email address or incorrect SMTP server setting Re invoicing Module serves for re invoicing of data for internal use of customer Funkcionality of re invoicing allow to re invoice original costs of summary statement by numbers or itemized statement of services Costs might be re invoiced for selected phone numbers or defined group of numbers Filter Filter might be used to select data for re invoicing Filter is located in ribbon menu above re invoicing module mm gy m Statement of Services by Numbers ia Em According to call time 14 EI 3 A _invoici ized f Servi Trans E ding to invoice period i z Re invoicing Itemized Statement of Services Paym Trans To Em According to invoice perio Fast cho ce i ca Cals Ee sas L INVOICES Re invoicing i Telephone number list NE ER Billing a Invoice Date from Date to Reg n Teleph Tariff Selected invoices Define 51017289 160151 5 1 2011 5 31 2011 25206122 603282 Kredit 1601515057 1601515038 J 51012683 160151 5 1 2011 5 31 2011 25206122 603280 reat Filter Filter items from left Module provide quick navigation to other modules Data source select of data source for re i
62. ecting specific invoices phone numbers and groups which will be included in final export Each button displays context dialog this dialog allows to select list for filtering and by click on Define button selection dialog is displayed allowing to select items which will be included into final export Filtering according to any list of items is signalized by small start displayed on current filter button Invoices Selection of specific list of invoices for export or export of all invoices If all invoices are selected then invoices are filtered based on defined time period Telephone numbers calling Selection of specific list of number groups or specific list of phone numbers or all phone number whit tariff in specific list of tariffs which will be included into final export Option is not available for Invoices data source Settings Correction documents items Option allows to include items from correction documents credit and debit notes to export Setting is accessible only for Statement of Services by Numbers and Invoices data source Copyright 2015 by T Mobile Czech Republic a s 62 Corporate Costs Administrator Ill 3 3 2 Export definition Export definition contains setting of format and design of final export Definition allows to set column included in export format of output files including item separator sum definitions and dates and numbers formats In standard view all export defini
63. ed to each phone number according to total sum on SSS Other payments to re invoice In this section user might add its own services using and buttons These services will be added to re invoicing using defined re invoicing mode defined amount and VAT rate Re invoicing mode for Other payments Percentually according to SSTN service price will be split and calculated to each phone number according to total sum on SSS Sum for each invoice equals to amount set by user Proportionally according to SIM count service price will be divided by count of SIM and calculated to each phone number with the same price Sum for each invoice equals to amount set by Copyright 2015 by T Mobile Czech Republic a s Main modules 73 user Absolutely whole amount service price is calculated with full amount to each phone number Limits and number naming Show original price and legend turns on displaying of original price price used for calculating re invoicing and legend Legend contain percentage of re invoicing and limits application Private calls re invoice differently allows to change percentage of re invoicing for private calls It option is turned off private calls are re invoiced in full price 100 Watched calls re invoice differently allows to change percentage of re invoicing for watched calls It option is turned off watched calls are re invoiced in full price 100 Use limits turn
64. efinition Recipient Email address re invoicing export report is stored into one file and sent to set e mail address It is possible to set more addresses split by comma or semicolon Split by groups and send by e mail to group address re invoicing export report is split according to phone number groups one file for each group and sent to email address of current group Split be phone num and send by e mail to address according to num naming re invoicing export report is split according to phone numbers one file for each phone number and sent to email address of current phone number defined in number naming Copyright O 2015 by T Mobile Czech Republic a s Main modules 17 Control buttons Send sends re invoicing export report according to setting to email addresses Cancel cancel sending of re invoicing export report Progress Status of operations is displayed using progress on special dialog Result After finishing the re invoicing export report sending by email result is displayed in final report which contains list of email recipient addresses and total sending time If export was not sent then dialog contains warning for example missing group or phone number email address or error for example incorrect email address or incorrect SMTP server setting Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator III Caption Analysis and graphs Part An
65. eld titles and enumeration E Show Column name E E mail Y Name Y Surname Field 3 Field 4 Field 5 Field 6 y jol Naming columns Predefined fields might be also used for number naming Reg number company identification number BA billing arrangement Billing address customer name from billing address address first row Contact address customer name from contact address address first row Tariff tariff name E mail phone number user e mail address Forename phone number user forename Surname phone number user surname Some predefined columns like Reg number BA Billing address Contact address Tariff are filled automatically and their names cannot be changed Column e mail has different color and its name cannot be changed Other column names might be changed Limits Limits are used for re invoicing Limits might be defined for each phone number individually Mass definition of limits for more phone numbers might be defined in groups Module contains two tab sheets Tab sheets Telephone number limits List of phone numbers for defining limits is situated on the left side Phone number with any defined limit has different color column Count displays count of defined limits for each phone number On the right side there is list of limits for actually selected phone number Buttons and below the list of limits might be used to add or delete limits Telephone number limits MEAN 3 p
66. em start installation using SFNsetupDB2008R2x86 exe file it is possible to download installer on address www t mobile cz sfn3setupdb Installer with MSSQL 2008 R2 Express x64 designed for 64 bit operation system instalace se spoust souborem SFNsetupDB2008R2x64 exe file it is possible to download installer on address www t mobile cz sfn3setupdb64 These installations contains only SQL server a database for CCA III application It is designed for installation of database server onto physical server in company network as common storage of data for more users of CCA III Installer does not contains application files Installers sizes are between 75 to 85 Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill 19 MB After installation no files outside SQL Server will leave on server Installation steps description 1 After selecting language product information is displayed Confirm it by click on Next button 6 Setup Corporate Costs Administrator IM Database Welcome to the Corporate Costs Administrator III Database Setup Wizard This will install Corporate Costs Administrator III Database on your computer It is recommended that you dose all other applications before Click Next to continue or Cancel to exit Setup lt VR Mobile lt r ri gt Architecture x64 64 bit I nstallation step 1 basic information 2 Licence agreement is displayed it is necessary
67. en from local computer so it is necessary to keep this list actualized If certificate is not valid according to above mention validation connection to server is not established and user may get this error The underlying connection was closed Could not establish secure channel for SSL TLS The remote certificate is invalid according to the validation procedure Proxy server If you used and proxy server with HTTPS inspection creating own connection to remote server instead of direct connection than it is necessary to install root certificate of your proxy server into trusted root certification authorities on every client computer with CCA application Cipher suites for TLS For secured connection with TLS are allowed only cipher suites with high security Download data may not work in unsupported operating systems like as Windows XP or Windows Server 2003 due to missing Support for new safer cipher suites Server accessibility check CCA III using same connecting method as Internet Explorer if there are any problems with connection we recommend to try open verification function https sfn t mobile cz sfn hello in Internet Explorer If CCA servlet version is displayed properly without any problems any security warning same way as it is displayed on picture below displayed in compatibility mod browser IE 9 then invoice download will work as well in CCA III application if As Internet Explorer parameter is set in application parameters
68. epublic a s 36 Corporate Costs Administrator Ill 2 4 2 5 HTML Internet page MHT Web archive PDF Document POF ej 7 Export format Export selection Print On many place in CCA III application where grid view of data is used quick print button allows to print displayed table Accessibility of this button may be restricted be user rights It is necessary to divide this print of displayed table from proper invoice print reports i 3 Print Report preview Report preview contains several tools Load and save print report Print and preview setting Paper setting Navigation Zoom Colors and watermarks Export to several different formats Number naming Application CCA III contains special button for number naming which instead of display naming on grids and exports allows also define display naming columns Turn off Turn on Copyright O 2015 by T Mobile Czech Republic a s Application 37 Hide number naming Shows or hides number naming Define naming Defines naming columns to be displayed Number naming options 2 6 Select dialogs Overview of standard select dialogs in CCA III Select invoices List of invoices is display almost same way as it is on module module Invoices including filter First column Select contains check box which is used to mark invoices as selected Buttons Print quick table pr
69. er in login chapter LOGI N name login name for downloading invoices from TMCZ mandatory for download PASSWORD password user password for downloading invoices from TMCZ mandatory for download PROFILE name export profile name used for exporting downloaded invoices mandatory for DOWNLOAD EXPORT or EXPORT SFNLOGIN name login name for CCA application mandatory only when user management is enabled SFNPASSWORD password user password for CCA application mandatory only when user management is enabled EXPORTPATH path directory for invoices export if it is not specified then directory defined in profile is used instead optional used only for DOWNLOAD EXPORT or EXPORT BATCHFILENAME file name of created batch file mandatory for CREATESECUREBATCH Important information for setting parameters All parameters must be set with or prefix Order of parameters does not matter Most of the parameters contain mandatory suffix which is followed by defined value Parameters with spaces like user name password or path must be closed in double quotes otherwise they might be proceeded incorrectly Some examples Download and import data user management enabled SFNC exe EXECUTE DOWNLOAD LOGIN smith PASSWORD 123abcd SFNLOGIN smith SFNPASSWORD smi 123 xAz Download and export user management disabled SFNC exe EXECUTE DOWNLOAD EXPORT LOGIN smith PASSWORD 123
70. ervices Invoice Invoice Number Billing period 9 1 2010 10 1 2010 Items TEE Materiel Happy roaming incoming zone 2 EU in 5 852 00 CZK Happy roaming incoming zone 2 outside EU in 48 00 CZK T Mobile I Call zone 1 in 6 404 47 CZK GPRS EDGE 3G wap 5 00 CZK Individual discount 16 000 00 CZK TIT O T T T O O O a pc SMS Payments 130 00 CZK Ea A A EE E TT TE o Server APC1007 SFN Database SFN a I SSS Items Grid contains summary statement of services including total sums and VAT information Total sums are differed by color Ordering n this grid is disabled to keep the grid well formed Additional information Contains additional information from invoice headers etc Buttons Bottom part of dialog contains control buttons Display SSTN displays Statement of Services by Numbers if it is available Display ISS displays Itemized Statement of Services Payment Transactions if it is available Print quick table print Export quick table export Back return to list of invoices Copyright 2015 by T Mobile Czech Republic a s Main modules 55 3 2 4 SSTN Statement of Services by Numbers if invoice contains them might be displayed using ellipsis button in SSTN column on appropriate row of invoice list or on detail dialog of 1 SSS E Invoices Corporate Costs Administrator II Modules Tools Invoices Statement of Services by Numbers x State
71. ess of computer with installed SQL server Instance name might be added to server name behind backslash SERVER INSTANCE Database database name to connected from application default name is SFN Copyright O 2015 by T Mobile Czech Republic a s Tools 95 Use Windows integrated security Windows user authentication is used for logging into SQL server Use entered user name and password defined user name and password is used for logging into SQL server Use internal login if this options is checked user name and password cannot be filled and for logging into SQL server is used internal name and password from SQL server installation This option can be used only when SQL server was installed with application Cannot be used when customer uses its own SQL server Test connection button starts database connection check Set default button sets default database connection for recommended SQL server installation on local computer Server name APCIOO7SN D Database 5 Use Windows integrated security Use entered user name and password Use internal login Set default Database connection settings Database backup and restore Module allows to backup database data to be later restored or migrated to another computer more information in chapter Backup and restore 6 2 1 Backup and restore Module allows to create database backup to be later restored if needed
72. etail list of calls all type of analysis are based on ISS ISPT Analysis does not contains chart view and might be order by phone number combination of group and phone number or phone call start time Number naming might be turned on and naming columns defined for both calling and called phone numbers Type of analysis List of calls Analysis display all activities destinations for phone numbers when they happen date time to who they were routed called number length units and charged price List of private calls Analysis is similar to List of calls but output contains only private calls List of watched calls Analysis is similar to List of calls but output contains only watched calls Copyright 2015 by T Mobile Czech Republic a s Analysis and graphs 83 4 4 4 5 Extremes Extremes module contains analysis studying extreme values in certain indicator All extremes analysis contains pie chart Parameter Record count defines number of records in analysis output for example ten most called numbers Type of analysis Most called number Analysis displays called numbers which were called the most times Number naming might be turned on and naming columns defined for called phone numbers Busiest day by number of calls Analysis displays charged price length and number of calls for days when most calls were realized Busiest hour of day by number of calls Analysis displays charged price
73. ether invoices will be filtered according to billing period or according to each detail item call time Fast choice button provides quick setting of date according to predefined templates Period days selecting of specific days in week which will be included in analysis Fast choice button provides quick setting of days in week according to predefined templates Period time selecting of specific time range in a day which will be included in analysis Fast choice button provides quick setting of time according to predefined templates Filter bounding data by choosing specific items for analysis Settings additional analysis settings Profile allows to load and save settings from to profile Data refreshing of displayed data Filter Contains button for selecting specific invoices phone numbers and groups which will be included in analysis Each button displays context dialog this dialog allows to select list for filtering and by click on Define button selection dialog is displayed allowing to select items which will be included into final export Filtering according to any list of items is signalized by small start displayed on current filter button Invoices Selection of specific list of invoices or all invoices for analysis If all invoices are selected then invoices are filtered based on defined time period Telephone numbers calling Selection of specific list of number groups or specific list of phon
74. example PostgreSQL MySQL etc No application is primary designed for Microsoft SQL Server database Application When turning application CCA III off Program compatibility check is displayed with message This program requires flash ocx which is not install on this version of Windows This problem is connected with 64 bits systems where 64 bits flash player plugin is not installed in Internet Explorer It is only notification you can simply close this dialog using button This application works correctly In export re invoicing or analysis only data for one invoice are displayed what can do to see all data Check filter of current module if there is no filter according to invoices phone numbers enabled or any different restriction set Filter according to any of selected items is identified by star appearing in left corner of filter icon What can I do when application did not start In most cases it is because of damaged configuration file which have to be deleted For deleting configuration files you can use auxiliary tools Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator III Caption License agreement Part License agreement 121 10 License agreement By installing copying or otherwise using the Corporate Costs Administrator 111 software you confirm that you have read the following terms and conditions of the End User License Agreement EULA and that you
75. fined on more items for example more type of calls then limit is applied to each item till the limit amount is consumed Application of limits on re invoicing is explained in legend Print Print of re invoicing allows to display re invoicing report preview print re invoicing report and also send re invoicing report via email as PDF file in attachment or save re invoicing report into one of supported text or graphic formats Copyright O 2015 by T Mobile Czech Republic a s Main modules 15 Print Re nvoicdng according to CCA 2 0 5 Re nvoicing according to CCA 3 0 5 Currently displayed table Elva dra Pah 4 Color services by operators bi E Pa h gt e gt wp Preview print Send by e mail Print of re invoicing Settings Re invoicing according to CCA 2 0 print re invoicing in original design of CCA 2 0 Re invoicing according to CCA 3 0 print re invoicing in new design of CCA 3 0 Currently displayed table print actually visible grid in re invoicing module Totals by destinations turns on off displaying of Totals by destinations graph for each phone number on re invoicing report graph is situated below the grid with re invoicing of current phone number Analysis by day turns on off displaying of Analysis by day graph for each phone number on re invoicing report graph is situated below the grid with re invoicing of current phone number Most called num
76. following services Microsoft update lt http update microsoft com microsoftupdate gt Windows update Architecture x64 64 bit Installation step 17 additional information 18 After successful installation finish result information are displayed Here it is possible to choose to run Corporate Costs Administrator 111 application and open web page with last version of Adobe Acrobat Reader If system restart is required then option with restart immediately or restart later is displayed Installer will be closed using Finish button 5 Setup Corporate Costs Administrator III x Setup Corporate Costs Administrator III Completing the CCA III Setup Completing the CCA III Setup F Wizard Wizard To complete the installation of CCA III Setup must restart Setup has finished installing CCA III on your computer The your computer Would you like to restart now application may be launched by selecting the installed icons 5 Yes restart the computer now Click Finish to exit Setup No I will restart the computer later FL hc sie Canis Adsh siuler TE F Go to Adobe Acrobat Reader download web SD Mobile mue r gF Architecture x64 64 bit f i Architecture x64 64 bit Installation step 18 installation finished Network Installation of Microsoft SQL Serveru 2008 R2 Express and database Installer types Installer with MSSQL 2008 R2 Express x86 designed for 32 bit operation syst
77. for one service for each of selected document phone number with total price Sum of selected Sum of prices for each item service for all selected documents phone numbers Supplementary information Contains information from invoice headers etc ISS ISPT Itemized Statement of Services Payment Transactions if invoice contains them might be displayed using ellipsis button in ISS ISPT column on appropriate row of invoice list or on detail dialog of 1 SSS Contains detail information about every phone calls or data transfer E d Invoices Corporate Costs Administrator I Modules Invoices Itemized Statement of Services Payment Transactions rennes Statements of Services Payment Transactions _ Additional information Tel Number ariff Reg number Customer name Receiver name 603898022 Kredit 2000 52796869 25206122 Ing Karel Nov k 210 80 CZK m 604881576 Kredit 1200 HIT 52796869 25206122 ABCD s r o Ing Karel Novak 791 3813 00 CZK 1831 4023 80 CZK CIE iii Server APC1007 SFN Database SFN ISS ISPT Context menu Right click on displayed grid opens a context menu allowing to navigate between different document types set naming of numbers etc Dialog contains two tab sheets Itemized Statement of Services Payment Transactions Displays summary list of phone numbers First column contains button gt gt for displaying document detail Last column contains button for docume
78. formation that CCA database will be finished after computer restart is displayed Confirm it by click on Next button After operation system is restarted installation automatically continue Installation of CCA database will done after the system reboot Installation step 15 CCA database installation restart required 16 If CCA database is installed with the application and system does not require restart then CCA database installation is started this operation can take several minutes depending on computer configuration Please wait till the installation is finished If advanced installation was selected then CCA database installation guide is displayed 17 If SFN instance of MSSQL server is installed with the application then after successful installation finish additional information are displayed It is recommended to download and install all available actualizations using web page Windows Update or Microsoft update Copyright 2015 by T Mobile Czech Republic a s 18 Corporate Costs Administrator Ill 1 2 2 5 Setup Corporate Costs Administrator III Information Please read the following important information before continuing TO When you are ready to continue with Setup dick Next Additional information You installed SFN instance MSSQL Server 2008 R2 Express We recommend to check whether new updates are available to this and other products Updates can search using the
79. hange any settings Setup type Recommended installation Architecture x64 64 bit Installation step 5 summary information 6 If SFN instance of MSSQL server is installed with the application then extracting of files for MSSQL 2008 installer is started after files copying is finished this operation can take several minutes depending on computer configuration Please wait till the extraction is finished Extracting Files Extracting File 64 setup sql_engine_core_inst_msi pfiles sqls To Directory C Users yee App Data Local Temp is F Installation Step 6 extracting of files for MSSQL 2008 installer 7 If SFN instance of MSSQL server is installed with the application then installation or SFN instance of MSSQL server is started after files extraction is finished this operation can take several minutes depending on computer configuration installer windows might be displayed during installation Please wait till the installation is finished SQL Server 2008 R2 An Please wait while SQL Server 2008 R2 Setup processes the current operation Installation step 7 installation of MSSQL server 2008 Express 8 If SFN instance of MSSQL server is installed with the application then it might happen that MSSQL server installation will fail in this case below mentioned message is displayed Turn off the installer and restart computer Immediately after operation system is initialized start the installat
80. hs in analysis module Generally the grid view has several common properties used in most of the modules 4 Invoice number Date from Date to YF Reg number Billing arrange Corre PDF Grid view Records order To order records by specific column simply click on the column title By another click order direction is turned over By holding SHIFT key and click to column title an additional column might be included in order sequence By holding CTRL key and click on column title column is removed from order sequence Each column used for ordering is mark by dark arrow on the right side of column title Arrow direction corresponds with an order direction ascending descending Filter Records in grid view might be also filtered Filter mean decrease amount of displayed records by specific criteria Filter might be set according to value of one or more columns Filter is activated be pointing on the column title where small filter symbol is displayed By click on the symbol context menu is displayed here an specific value might be selected or own user criteria set Column with active filter is highlighted using blue and bold font Actual filter is also displayed under the grid written by blue font Left from the filter cross button is displayed this might be used to cancel the filter check box might be used to temporally switch the filter off On the right side there is a flat button Edit Filter this button allows
81. ified in application parameters After download of each invoice invoice is imported to database Invoices imported to database might be viewed in invoices module Operation progress is displayed in special dialog At the end of the operation final report is displayed Copyright 2015 by T Mobile Czech Republic a s 52 Corporate Costs Administrator Ill 3 2 3 2 1 one O Downloading data mm A Downloading invoice 1561515057 Processing part of invoice Downloading Summary Statement of Services Transferred data 169 13 kB y Download and import progress Operation might be aborted using Cancel button Process will be aborted after finishing actually running operation on the lowest level so after finished of invoice download invoice import or import of any of invoice additional document Invoices Module for viewing and printing of imported invoices and their details Invoices and their details might be repeatedly walked though to more detail levels it might be returned to higher level using Back button or by pressing of BACKSPACE key Discounts If invoice contains charge extract then discount button is displayed on detail of ISS this button allows to control viewing of discount column in grids Poi Turned Turned off on Print summary or itemized statements on separate pages Button turns on off printing of each telephone number to separate page This option affects
82. in most cases only one correction is issued to one invoice so grid usually contains only on row First column contains gt gt button displaying detail of correction 1 SSS Correction might contain Summary Statement by Numbers or electronically signed invoice in PDF format Correction might be downloaded for an invoice which is still yet not imported in database of SFN application In this Copyright 2015 by T Mobile Czech Republic a s 58 Corporate Costs Administrator Ill 3 2 7 case an empty invoice is automatically generated during correction import and correction is assigned to it Control buttons Print quick table print Export quick table export Print save display print preview of selected documents phone numbers Back returns back to previous invoice or list of invoices Invoices print In invoices module selected invoices and their detail documents might be mass printed or mass save to different file formats a Print invoice Summary Statement of Services Statement of Services by Telephone Numbers MV Itemized Statement of Services Itemized Statement of Payment Options F Telephone numbers to separate pages Show discounts on summary or itemized statement of services ha h A la Preview print Print to file Invoices print Print area Statement of Services invoice if checked then Statement of Services report is printed for selected invoices Summary S
83. ing Limits Private calls Watched calls Application parameters Database management Backup and restore database User profile Sending of e mails Export to file Print SMTP SMTP connection settings Application allows to send e mail from export re invoicing modules and from report for technical support Proper setting of SMTP server connection is necessary for sending e mails in application SMTP is configured in application parameters SMTP server for sending emails Server smtp domain com Port 25 Ad Advanced settings smtp resy tting F Use proxy Sender s e mail address Security TLS SSL V SMTP server requires authentication novak domain com Allowed protocols 7 Ts 1 0 7 SSL 3 0 Authentication method Autodetection Reply to Allowed ciphers Secure only y User name novak domain com Password re bussines domain com 40h Use extended protocol ESMTP 7 SMTP settings SMTP server Address of SMTP serveru and port used for sending e mails Default port value for SMTP protocol is 25 Proxy Option turns on off usage of proxy server for e mail sending This option is accepted only when in Connection to T Mobile server section parameter connection type is set to Use proxy server Authentication Option SMTP server requires authentication turns on user authentication against SMTP server Today there only a few public SMT
84. ing download and import of invoices from TMCZ server Activation fees Lump sums National calls excluding VPN VPN calls SMS MMS Roaming incoming Roaming outgoing International calls Data transfers WAP Other Penalties Discounts Private calls This module allows to define private phone numbers for each calling phone number These private numbers with private services are then used to identify private calls in other module re invoicing analysis and graphs etc Module contains two tab sheets Tab sheets Private numbers List of calling phone numbers for assigning private numbers is situated on the left side Calling phone number with any assigned private number has different color column Count displays count of assigned private numbers for each calling phone number On the right side there is list of private numbers for Copyright 2015 by T Mobile Czech Republic a s 90 Corporate Costs Administrator Ill 9 5 actually selected calling phone number Buttons and below the list of private numbers might be used to add or delete private numbers Button also contains drop down button with two options add phone number from the list or add phone number manually Private calls Private numbers x Private numbers Private services services r y RI Al Telephone number calling Count Private numbers E 603280923 0 Telephone number called
85. ing numbers on off OK confirm selection Cancel cancel selection Select phone numbers Select tariffs Copyright 2015 by T Mobile Czech Republic a s Application 39 Tariffs are displayed in overview list First column Select contains check box which is used to mark tariffs as selected Buttons Print quick table print Export quick table export Select all tariffs Cancel selection of all tariffs OK confirm selection Cancel cancel selection Active Nonstop ADSL Premium bez pevn linky ADSL Premium k pevn lince ADSL Standard bez pevn linky ADSL Standard k pevn lince Select tariffs Select services destinations Services are displayed in overview list First column Select contains check box which is used to mark services as selected Buttons Print quick table print Export quick table export Select all services Cancel selection of all services OK confirm selection Cancel cancel selection Activation data fax number Activation Fixed Data Network Activation Internet OA ehun Hanm Teta ob A ooo lt a 590 ES C ET Select services Lu a Copyright
86. ing percen 100 Hr Settings Option Do not re invoice selected services or re invoice them differently turns on off possibility to set percentage of re invoicing for each service If option is turned off all services are re invoiced in full price 100 Comment If more then one service is selected it is possible to set percentage for all selected services using panel below the grid of services Mass change of percentage have to be confirmed by thick button next to the edit field Example If re invoicing percentage of Calls T Mobile network is set to 50 then this service will be re invoiced with half price compare to SSTN or ISS ISPT Services from Statement of Services Option Do not re invoice invoiced services or re invoice them differently turns on of possibility to set percentage of re invoicing for service appearing only on Statement of Services 1 If option is turned off services from Statement of Services are not included in re invoicing 0 Comment If more then one service is selected it is possible to set percentage for all selected services using panel below the grid of services Mass change of percentage have to be confirmed by thick button next to the edit field Re invoicing mode for Services from Statement of Services According to SIM count service price will be divided by count of SIM and calculated to each phone number with the same price According to SSS service price will be split and calculat
87. inistrator Ill Send re invoicing 76 Send report 110 Send report to technical support 110 Server backup 95 98 Server restore 95 99 Settings 61 71 80 86 111 SFN 26 SFNC 42 Shortcuts 26 SMTP 107 SMTP connection settings 107 Software 6 Specialtools 111 Splitting and file naming 68 SQL request 31 SQL Server 26 SQL Server limits 6 SSL 40 SSS 26 54 SSTN 26 55 Statement of Services 54 Statement of Services by Numbers 55 Statistics 83 Statistics analysis 83 Summary Statement of Services 54 Supported systems 6 SW 6 Switch modules 31 System 7 T Task bar 31 Telephone number limits 88 TLS 40 Tools 983 111 Totals 81 Totals called numbers 81 Totals analysis 81 Totals by destionations 81 Turnonnaming 36 U Uninstallation 8 Unix 7 Update 106 Updates 34 User 106 User backup 95 96 98 User backup limitations 96 User management 102 105 User restore 95 99 _V Version 34 126 Version differences 26 Volume discounts 81 VPN calls 81 _W Watched calls 81 90 Watched calls list 90 Watched telephone numbers 90 WebBrowser 8 Window 31 Copyright 2015 by T Mobile Czech Republic a s
88. int Export quick table export Select all invoices Cancel selection of all invoices OK confirm selection Cancel cancel selection E g Invoices Filter Invoices of given phone number Oooo Display invoices for last X months only ES Ln m as a e els Al 100451 aaa ES CE MEE Select invoices Select groups Billing arr 91017289 51013683 52796869 se 10 saa 00 0 0 0 0 0 0 22 0 o 1 0 22 0 22 0 22 0 22 0 22 0 o 1 0 mea Copyright 2015 by T Mobile Czech Republic a s 38 Corporate Costs Administrator Ill Groups are display hierarchically in tree structure Column Select contains check box which is used to mark groups as selected Buttons Select all groups Cancel selection of all groups OK confirm selection Cancel cancel selection Select groups Select phone numbers Phone numbers are displayed in two lists Available phone numbers are displayed in left list selected phone numbers are displayed in right list Phone numbers are moved by buttons placed between these two lists Filter below the lists allows to reduce amount of displayed phone numbers according to defined prefix Buttons gt select marked phone numbers lt unselect marked phone numbers gt gt select all phone numbers lt lt unselect all phone numbers Turn prefix on off Turn nam
89. ion again i MSSQL Server 2008 R2 x86 failed to install Probably need to reboot the dan system before installing or it is not installed some required component After the restart run installation again Installation step 8 MSSQL server 2008 installation error 9 If SFN instance of MSSQL server is installed with the application and all conditions for installation are Copyright 2015 by T Mobile Czech Republic a s 22 Corporate Costs Administrator Ill met then MSSQL server 2008 installer window is displayed This operation can take several minutes depending on computer configuration Please wait till the installation is finished SQL Server 2008 R2 Setup SE Installation Progress Initializing Windows Installer actions Cancel Installation step 9 MSSQL 2008 installer 10 If CCA database is installed with the application and system requires restart after MSSQL installation then information that CCA database will be finished after computer restart is displayed Confirm it by click on Next button After operation system is restarted installation automatically continue Installation of CCA database will done after the system reboot Installation step 10 CCA database installation restart required 11 If CCA database is installed with the application and system does not require restart then CCA database installation is started this operation can take several mi
90. itting and file naming Save to directory C Users novak Documents T Mobile SFN III Print File naming pre defined masks export pdf File splitting Y Everything to one file Print to file Database management Allows to manage data stored in database Allows to delete invoices and import sooner downloaded invoices in XML format Database Management is available in module invoices precisely on list_of invoices represented by two button in left bottom corner of this module Accessibility of these button might be restricted by user rights Database management Control buttons Delete delete selected invoices from database including all assigned corrective invoices detail documents and unused configurations Status and progress of invoice deleting is displayed in special dialog Import import to database of single invoice or all invoices downloaded before and not yet imported in database Invoice import After click on Import button a dialog for import type selection is displayed Import type Copyright 2015 by T Mobile Czech Republic a s 60 Corporate Costs Administrator Ill 3 3 Single invoice Imports one selected invoice to database After choosing of this option and click on OK button dialog for selecting invoice for import is displayed All invoices Application will ho through the directory for downloading invoices and import all invoice not yet found in database
91. length and number of calls for day and hour when most calls were realized Most expensive calls Analysis displays detail information about most expensive calls like date and time of call calling and called phone number destination call length and original and charged price Analysis is counted from original price without discount Number naming might be turned on and naming columns defined for both calling and called phone numbers Longest call Analysis displays detail information about longest calls Analysis is similar to Most expensive calls Number naming might be turned on and naming columns defined for both calling and called phone numbers Most called destination Analysis displays destination with calls count and price where most calls were realized Most expensive destination Analysis displays most expensive destination with calls count and price Analysis is similar to most called destination Option allows to count analysis based on original or charged price Statistics Statistics module contains analysis studying count length and price of calls in different time periods All Statistics analysis contains bar chart with option of calls count length or price on vertical axes Type of analysis Analysis by hour of day Analysis displays calls statistics by hours of day when any call was realized in that period Analysis by day Analysis displays calls statistics by calendar days when any call was realized in that pe
92. ler will be closed using Finish button 5 Setup Corporate Costs Administrator IM Database Setup Corporate Costs Administrator IM Database g g Completing the CCA III Database Completing the CCA III Database 4 Setup Wizard 4 Setup Wizard To complete the installation of CCA III Database Setup must Setup has finished installing CCA III Database on your restart your computer Would you like to restart now computer O No I will restart the computer later Architecture x64 64 bit i i Architecture x64 64 bit Installation step 13 installation finished Existing SQL Server Installation of CCA III application on own existing SQL Server Installation steps are the same as for installation on local computer with two differences 1 SQL Serveru option is set to Do not install 2 CCA III Database SFN option is set to Advanced configuration show installer After installer starts Advanced option is selected on Install database connection settings setup connection to existing SQL Server and name for newly created database It is also necessary to set connection to SQL Server and database name manually in application Copyright 2015 by T Mobile Czech Republic a s 24 Corporate Costs Administrator Ill 1 2 4 Database Install database of Corporate Costs Administrator 111 Installation of CCA III database and table structure is provided by special application called CCA III dat
93. lication CCA TH If unable to run the application CCA Do Delete installation configuration III may be corrupted configuration file In this case itis necessary to ICC remove the configuration file Log Tool launched Monday December 12 2011 10 13 51 AM Auxiliary tools Copyright O 2015 by T Mobile Czech Republic a s Corporate Costs Administrator III Caption Discounts changes after 2 28 2013 Part Vi 114 Corporate Costs Administrator IlI 7 Discounts changes after 2 28 2013 Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator III Caption Help Part Vi 116 Corporate Costs Administrator Ill 8 Help Application help is available on separate tab on ribbon menu in all supported languages Help is available in CHM HTML format and manual in PDF format HE EA F Czech English Czech English Help Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator III Caption Frequently asked questions Part 118 Corporate Costs Administrator Ill Frequently asked questions List of frequently asked questions SFN compatibility Can CCA III application use data from CCA I No format of invoices was changed and extended so invoices cannot be imported from CCA to CCA III and otherwise But it is possible to have both application installed on one co
94. lt superuser account The setup will connect user defined MSSQL instance on user defined server with default superuser account or user defined superuser account APC 1007 SFN Database SFN User defined login default Windows authentication Step 2 database server connection settings Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill 25 3 For both installation types summary information about selected option from previous steps are displayed Confirm it by click on Install Remove button O canine NN c Install database The setup is ready to begin installation Step 3 summary information 4A If Install was selected then database and table structure installation progress is displayed a Installing database The database features are being installed H sysindexes where indexes where de j H EE H Step 4A installation progress 4B If Remove was selected then remove animation is displayed 5 When database install remove is finished then information about successful finish or list of occurred errors is displayed Installer will be closed using Finish button Copyright 2015 by T Mobile Czech Republic a s 26 Corporate Costs Administrator Ill 1 3 1 4 CCA I database installer Install completed y A The setup has successfully installed CCA database Installation passed without serious error
95. mended configuration Advanced configuration customize SQL server Do not install Recommended configuration Advanced configuration show installer Do not run Architecture x64 64 bit Installation step 3 select installation type and components 4 Check for required components will be started If one or more components is missing installer will not let you continue Required components might differ according to selected installation components By click On Component name download page of current product is open in web browser If all necessary components are installed continue by click on Next button 6 Setup Corporate Costs Administrator II Database Check required components Before installing is necessary to check the status of required components Name Status All required components for installation are installed Architecture x64 64 bit Installation step 4 required components check 5 Displays summary information about selected components for installation including destination directory and other options click button Install to start installation Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill 21 6 Setup Corporate Costs Administrator IM Database Ready to Install Setup is now ready to begin installing CCA III Database on your computer Click Install to continue with the installation or dick Back if you want to review or c
96. ment of Services by Telephone Numbers Suplemen itary informa tion Tel number ariff Billing arrangement Reg number Customer name Receiver name Items WEZE Kredit 2000 52796869 25206122 ABCD s r o Ing Karel Nov k la 360 80 CZK gt 604881576 Kredit 1200 HIT 52796869 25206122 ABCD s r o Ing Karel Novak 5048 00 CZK 7 20 5 408 80 CZK EB AS RS Pi Server APC1007 SFN Database SFN SSTN Context menu Right click on displayed grid opens a context menu allowing to navigate between different document types set naming of numbers etc Dialog contains two tab sheets Statement of Services by Telephone Numbers Displays summary list of phone numbers First column contains button gt gt for displaying document detail Last column contains button for document print preview Supplementary information Contains information from invoice headers etc Control buttons Show allows to display detail of select documents phone numbers Naming show hide naming columns Print quick table print Export quick table export Print save display print preview of selected documents phone numbers Back returns back to previous invoice or list of invoices Detail of selected documents Detail contains three tab sheets Copyright 2015 by T Mobile Czech Republic a s 56 Corporate Costs Administrator Ill 3 2 5 Detail selected Displays list of items each
97. mproving hint Log files for further analysis and error identification is automatically included into sent message For proper work of sending reports it is necessary to have correctly configured SMTP server connection in application parameters All fields are mandatory and must be filled Log files for further analysis and error identification is automatically included as attachment of sent message If any problem occurs it is recommended to send this report to technical support instead of any other communication In most case technical support will ask for this report anyway Announcement T Mobile Czech Republic a s company declares that all log file is used only for application run analysis No personal data are purposely collected All data are processed according to low for protecting personal data no 101 2000 Dg in full text of the Act What is sent Original message Application log files Installation log files Messages from system event viewer inserted by CCA application Information about connected database if available Installation configuration and application metadata with several configuration parameters Buttons Send sends message using SMTP server defined in application parameters Create tries to create message using default email client using MAPI interface Generate generates attachment for sending of report manually Copyright 2015 by T Mobile Czech Republic a s Tools 111 6
98. mputer and view old invoices in CCA and new invoices in CCA III SFN 11 compatibility Can CCA III application use data from CCA 117 Yes application CCA III is compatible with CCA II application CCA III application only need to add their own column into CCA II application database to work properly For this purpose it is necessary to have CCA II database version 41 which corresponds with CCA II version 2 1 37 129 or higher If older version of CCA II is installed it is necessary to update CCA Il application update will actualize database and will guarantee compatibility with CCA III Invoices What is the difference between ISS and I SPT Itemized statement of services ISS detail information about all made calls sent SMS MMS data transfers etc Contains also all data for payment transactions Itemized statement of payment transactions ISPT information about payment transactions like SMS payment m payment DMS etc Why is my itemized statement of services empty Maybe your itemized statement of payment transactions is activated This statement contains information about used payment transactions like SMS payment m payment DMS and payment transactions price If you need complete list of all made calls sent SMS data transfers etc then it is necessary to activate itemized statement of services It is possible to order this document also retroactively up to 2 month to the past Export to PDF System cannot fin
99. n For big companies downloading and importing big amount of data it is recommended to buy full version of Microsoft SQL Server 2008 R2 without any limitations Limitations of free version Microsoft SQL Server 2008 R2 Express Maximum database size 10 GB Maximum operation memory usage 1 GB Maximum processors used 1 Supported operation systems Client 32 bit 64 bit Windows 8 1 Windows 8 Windows 7 Windows Vista R2 Windows Vista Server 32 bit 64 bit Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill 7 Windows Server 2012 R2 Windows Server 2012 Windows Essential Business Server only Microsoft NET Framework 4 0 Full Windows Small Business Server 2008 Windows Server 2008 R2 Windows Server 2008 Updates Service Packs and operation system versions By above mentioned operation systems all released version are supported Home Professional Standard Business Ultimate etc and all available Service Packs SP1 SP2 SP3 etc if not specified differently Limitations of some operation systems Microsoft NET Framework Client Profile is not supported for architecture A 64 Itanium Microsoft NET Framework 4 is not supported on system Windows Server 2008 Core Role or Windows Server 2008 R2 Core Role For Windows 2003 Server it is necessary to install Windows Imaging Component WIC Essential Business Servers and Small Business Servers are not mentioned
100. n of price or call length on vertical axes Number naming might be turned on and naming columns defined for calling phone numbers Watched calls Analysis is based on ISS ISPT and displays calls count SMS MMS amount of transferred data calls length and charged price Analysis might be calculated for phone numbers groups or combination of both or also for project codes Analysis contains bar chart with option of price or call length on vertical axes Number naming might be turned on and naming columns defined for calling phone numbers Similar to private calls analysis Lump sums count Analysis is based on SSTN and displays tariffs and phone numbers count belonging to each tariff Analysis does not have any additional setting and does not include chart view Invoicing Analysis is based on Invoice SSS and displays total charged price for each customer Analysis does not have any additional setting and does not include chart view Totals called numbers Analysis is based on ISS ISPT and displays calls count SMS MMS amount of transferred data calls length and charged price for each called phone number Analysis might be calculated for phone numbers groups or combination of both or also for project codes Analysis contains bar chart with option of price or call length on vertical axes Number naming might be turned on and naming columns defined for both calling and called phone numbers Calls Calls module contains analysis using d
101. nd message body might contain masks which are thereafter during sending replaced by information from sent data Masks might be inserted using ln button Mask list period invoice period in MM YYYY format regno company registration number BA billing group invoice invoice number group group name number telephone number naming naming according to chosen definition Recipient Email address export is stored into one file and sent to set e mail address It is possible to set more addresses split by comma or semicolon Split by groups and send by e mail to group address export is split according to phone number groups one file for each group and sent to email address of current group Split be phone num and send by e mail to address according to num naming export is split according to phone numbers one file for each phone number and sent to email address of current phone number defined in number naming Copyright O 2015 by T Mobile Czech Republic a s 70 Corporate Costs Administrator Ill 3 4 3 4 1 Control buttons Send starts generating of export and sends export according to setting to email addresses Cancel cancel sending of export Progress Status of operations is displayed using progress on special dialog Result After finishing the export sending by email result is displayed in final report which contains list of email r
102. ng Karel Nov k ABCD s r 1648 00 CZK D 9711000250 3 2011 3 31 2011 25206122 52796869 CT ABCD s r 0 00 C2K Moe D Das 9711000248 3 1 2011 3 31 2011 226172 ones ICA HE 5 5 Sac 1004516212 1 1 2011 1 31 2011 52796869 ABCD s r 0 ABCD s r 0 00 CZK A A 0 0 1004517207 1 1 2011 1 31 2011 52796869 Ing Karel Nov k ABCD s r 10 606 00 CZK E 2 Ol 1004516207 1 1 2011 1 31 2011 52796869 Ing Karel Nov k ABCD s r 10 606 00 CZK Er 2 O 1506500177 10 1 2010 10 31 2010 51017289 ABCD s r 0 ABCD s r 0 00 CZK A 5 ES E lO 2 Ol 2 0 2 0 1004515039 9 1 2010 10 1 2010 52796869 Ing Karel Novak ABCD s r 10 606 00 CZK 1004515020 9 1 2010 10 1 2010 52796869 Ing Karel Novak ABCD s r 10 606 00 CZK 1004515009 9 1 2010 10 1 2010 52796869 Ing Karel Novak ABCD s r 10 606 00 CZK 1417515057 1 1 2010 1 31 2010 51017289 Ing Karel Novak ABCD s r 45 398 00 CZK 1346515057 1 1 2010 1 31 2010 51017289 Ing Karel Novak ABCD s r 45 398 00 CZK P AL A A O O O O O m O 0 236 270 00 ee eee Server APC 1007 SFN Database SFN Invoice list with filter Filter Except standard filter in the grid it is possible
103. ng application heap record Amount of memory allocated by application Quick help In some modules special small round blue buttons with question mark might be found By click on this button an special hint with detail information for current section is displayed Field titles and enumeration Selected columns will be shown in number naming for all modules Quick help Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator III Caption Main modules Part Main modules 49 3 1 3 1 1 Main modules Main application modules are the most import parts of application containing basic function for working with invoices sucha as download and import view and print export and re invoicing Download data Before working with Invoices SSS SSTN or ISS ISPT in CCA application it is necessary to download data from T Mobile server and import them into database For this purpose download data module might be used Data are available on T Mobile Czech Republic a s company server to all customers meeting this rules Customer have enabled Invoice Administrator ADF This Administrator is registered on t zones portal and has its login and password Customer must belong to one of supported segment LE VSE or must have activated the ProfiNet servis Data are available for download on the server for download sixth days after the end of current billing period P
104. nistrator Ill Es E mail 69 76 Error messages 101 Errors 101 EULA 121 Existing SQL Server 23 Export 35 60 68 75 Export definition 62 Export filter 61 Export format 62 Export of re invoicing 75 Export table 35 Extremes 83 Extremes analysis 83 S FAQ 118 File masks 68 File naming 68 Filter 45 52 61 70 80 Final report 44 Folders 93 Free units 81 Frequently asked questions 118 cn General 102 Graph settings 84 Graphs 79 Grids 45 Groups 86 H Hardware 6 Help 31 47 116 HW 6 54 IE 6 8 Import 51 59 Import invoices 59 Info channel 31 Installation 8 Installation on existing SQL Server 23 Instance 26 Internet 40 Internet Explorer 6 8 Invoice 54 Invoice export 60 Invoice import 59 Invoice list 52 Invoices 52 Invoices check 50 Invoices print 58 Invoicing 81 ISPT 26 56 57 ISS 26 56 57 Itemized Statement of Payment Transactions 56 Itemized Statement of Services 56 _L Language 101 Language errors 101 License 121 Limittypes 88 Limits 6 88 Linux 7 List of calls 82 List of private calls 82 List of watched calls 82 Load 93 Local installation 11 Log 105 Logged user 31 Logging 47 105 Logging to database 102 Login 49 Longest call 83 Lump sums count 81 M Mac 7 Main form 31 Copyright 2015 by T Mobile Czech Republic a s Index 129 Main menu 31 Main modules 49 Manual 31 116 Manual documents 53 Menu 31 32
105. nload import final report Operation failed Invoice 1561515032 Downloading invoice 1561515032 OK Invoice 1561515032 analysis OK Importing invoice 1561515032 OK Downloading Summary Statement of Services OK Importing Summary Statement of Services OK Downloading Statement of Services by Numbers OK none Downloading Itemized Statement of Services OK none Downloading discounts extract OK none Copy of services from Statement to Summary Statement OK Copy of services from Summary Statement to Itemized Statements OK Applying discount OK Update invoice detail counts OK Number naming OK Invoice 1561515060 Downloading invoice 156151506 0 OK Invoice 1561515060 analysis OK Importing invoice 1561515060 0K Downloading Summary Statement of Services OK Importing Summary Statement of Services OK Downloading Statement of Services by Numbers OK none Downloading Itemized Statement of Services OK none Downloading discounts extract OK none Copy of services from Statement to Summary Statement OK Copy of services from Summary Statement to Itemized Statements OK Final report Copyright O 2015 by T Mobile Czech Republic a s Application 45 2 10 Grids Grid view of records is used in most of the application modules Grid view is well arranged and it is Suitable to display huge amount of data compare to different information view kinds such as grap
106. nt print preview Supplementary information Contains information from invoice headers etc Copyright O 2015 by T Mobile Czech Republic a s Main modules 57 Control buttons Show allows to display detail of select documents phone numbers Naming show hide naming columns Discounts show hide discount columns only when invoice contains charge extract Print quick table print Export quick table export Print save display print preview of selected documents phone numbers Back returns back to previous invoice or list of invoices Detail of selected documents Detail contains two tab sheets Detail selected Displays list of items for each of selected document phone number Additional information Contains information from invoice headers etc 3 2 6 Corrective invoices Corrective invoices if invoice contains them might be displayed using ellipsis button in Corrections column on appropriate row of invoice list Corrective invoices are credit notes or debit notes issued later for correcting of an original invoice Y Corporate Costs Administrator III WM Modules Tools Help Invoices Corrections x Document Type Invoice number Items count mee RS fg TET 84 178 00 CZK mu anna prenne mean siete i Server APC1007 SFN Database SFN Corrections credit notes debit notes Corrective documents Grid contains list of corrections
107. numbers calling Selection of specific list of number groups or specific list of phone numbers or all phone number whit tariff in specific list of tariffs which will be included in re invoicing Calls Select type of calls to be included in re invoicing private watched others Filter is accessible only for Itemized Statement of Services Payment Transactions data source Settings Called number confidentiality How many digits in called phone number from the right will be replaced by X character for keeping privacy If value is set to 3 then phone number 420603111111 will be displayed as 420603111XXX Setting is accessible only for Itemized Statement of Services Payment Transactions data source Correction documents items Option allows to include items from correction documents credit and debit notes to re invoicing Setting is accessible only for Statement of Services by Numbers data source Note In grid view items from correction documents are highlighted by red color Data If filter is change on displayed re invoicing then it is possible to actualize displayed re invoicing using Re calculate button This will re calculate all values according to new filter Settings In re invoicing settings it is possible to set percentage of re invoicing for each service add own services to re invoicing set re invoicing percentage of discounts private calls and watched calls involve setting of limits etc Cop
108. nutes depending on computer configuration Please wait till the installation is finished If advanced installation was selected then CCA database installation guide is displayed 12 If SFN instance of MSSQL server is installed with the application then after successful installation finish additional information are displayed It is recommended to download and install all available actualizations using web page Windows Update or Microsoft update Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill 23 1 2 3 6 Setup Corporate Costs Administrator II Database Information Please read the following important information before continuing When you are ready to continue with Setup click Next Additional information You installed SFN instance MSSQL Server 2008 R2 Express We recommend to check whether new updates are available to this and other products Updates can search using the following services Microsoft update lt http update microsoft com microsoftupdate gt Windows update Architecture x64 64 bit Installation step 12 additional information 13 After successful installation finish result information are displayed Here it is possible to choose to run Corporate Costs Administrator 111 application and open web page with last version of Adobe Acrobat Reader If system restart is required then option with restart immediately or restart later is displayed Instal
109. nvoicing SSTN ISS Period date time period settings which bounds invoices selected for re invoicing It is possible to choose whether invoices will be filtered according to billing period or according to each detail item call time Fast choice button provides quick setting of date according to predefined templates Option According to call time is enabled only for ISS data source Filter bounding data by choosing specific items for re invoicing Settings additional settings for re invoicing for example confidentiality Data refreshing of displayed data Data source As data source it is possible to choose Statement of Services by Numbers SSTN or Itemized Statement of Services Payment Transactions ISS ISPT Filter Contains button for selecting specific invoices phone numbers and groups which will be included in Copyright 2015 by T Mobile Czech Republic a s Main modules 71 3 4 2 re invoicing Each button displays context dialog this dialog allows to select list for filtering and by click on Define button selection_dialog is displayed allowing to select items which will be included into final export Filtering according to any list of items is signalized by small start displayed on current filter button Invoices Selection of specific list of invoices or all invoices for re invoicing If all invoices are selected then invoices are filtered based on defined time period Telephone
110. obile Czech Republic a s Frequently asked questions 119 During attempt to login to TMCZ server is displayed message Neither primary nor secondary server available what can do This message may appear due to several different causes 1 Server has outage due to some reason It is recommended to wait about an hour and then attempt to connect again 2 There are wrong setup primary and secondary servers in application params Right address is https sfn t mobile cz sfn 3 There is wring setup proxy server in application params Change the settings according to your network specifications or select choice As Internet Explorer 4 You use unsupported operating system Windows XP or Windows Server 2003 These systems don t Support new safer encryption methods for secure communication due to server reject these connections Please update to newer operating system Version differences What are the differences between versions CCA II and CCA 111 Description of main differences is described in chapter versions 2 and 3 differences Software and database Why Internet Explorer 8 is recommended for CCA III if did not use it Explanation can be found in chapter HW SW requirements It is possible to use CCA III on different operation system than Microsoft Windows Basically NOT More information about this topic can be found in chapter HW SW requirements It is possible to use CCA III on different database than MSSQL for
111. ok use predefined formats Automatically open the file Visual effects 7 Open file after save 7 Allow filter flash when opening module Timeout for database operations Import data Timeout in seconds 600 Y Use fast insert to database Timeout in seconds for database server to answer finish operation return result before Specia mode for importing data into database will be used BULK INSERT ar e mui operation is canceled Setting timeout shorter than 30s is not recommended faster This feature is available when application is connected to SQL server running on local PC General Application language Changes application language Texts in database typed by user will not be translated for example limit types groups currency formats number naming etc Currency format It is possible to specify format for displaying currency in application outputs Major affect might be seen in table view of invoices Groups When this options is turned on it allows to add one phone number to more than one group Project codes If project code support is enabled then project code are extracted from phone numbers during invoice import and project code is store in separated column Project codes might be displayed in Invoices module _ Number naming Option determines wether number naming will be used in application Use number naming by default if turned on then each module supporting number naming will have this option turn on by def
112. on may take longer time and application may not allow any button click or module switch it looks like that application freeze This is a feature of application which disables all controls on SQL request startup and enables them on request finish This feature may cause an window blinking a 5 SQL Copyright 2015 by T Mobile Czech Republic a s 34 Corporate Costs Administrator Ill 2 1 2 2 Version CCA III application version Application version is displayed on several places 1 Left side of main form caption panel 2 Right side of application main menu 3 In about box Here the additional build number BUILD may be found About box dialog Displays basic information about the product and supplier Dialog may be opened from application main menu or by double click on version number on left side of main form caption panel E About a S T Mobile Corporate Costs Administrator III Version 3 22 Copyright 2013 by T Mobile Czech Republic a s Web http www t mobile cz Build 69 About box Check for updates Application CCA III allows an automatic check for updates If new update is available application allows user to install actualization Check for update may be also run manually from application main menu Default address for checking for new updates is http www t mobile cz sfn3update Automatic check for updates may be configured in applica
113. only rows with data total sums and sums for each phone number are no included Amounts with sums final export contains data total sums and sums for each phone number Totals only final export contains only sums for each phone number and total sums Comment If ISS ISPT data source is selected then final export contains only sums for each phone number total sums on the end of each exported file are not included Settings Display column names determine if exported file will contain header with column names Text string when exporting to text files Text file separated by semicolon CSV and Text file TXT determine how the text strings will be identified enclosed Separator sets the columns delimiter Only for Text file TXT format Fixed width sets the fixed with of columns Ony for Text file TXT format Formats Formats of date time and decimal number for current export definition might be defined on this tab sheet Export free charged units as integer number units in export are exported without format as integer numbers instead of 2 30 min s as 150 s Encoding Encoding setting for exported file Only for text formats Text file separated by semicolon CSV a Text file TXT If Custom option is chosen then code page selection is displayed Columns available for export Columns for export of Statement of Services by Telephone Numbers SSTN Phone number Invoice n
114. ore details in rights administration Logging to database Turning of this option on will start logging operations into database Using Display log button it is possible to view stored logs Button Delete log will delete all records in log If ADMIN is displayed in Copyright 2015 by T Mobile Czech Republic a s 106 Corporate Costs Administrator Ill 6 3 1 column User it means that rights administration was switched off during this operation If logging is enabled then it is recommend to delete logs ones in certain period These operations are logged User login and log out Data download Invoices print Starting of re invoicing Starting of export Displaying of analysis and chart Change of groups Change of number naming Change of limits Change of private calls Change of watched calls Change of application parameters Application update Contains settings for application update Application parameters x Automatic update Y Allow automatic update check Address for getting updates h fwww t mobile cz sfn3update Check new applicatio n version It ae a z m aa a z a bp aus auc FE sis a pia sr a a ae ss y An ons and new appiicauon ennancement On application startup Every day Every 7 days Info channel 7 Allow display information channel on main application window application restart needed Update Automatic update Turns on off
115. oups or combination of both or also for project codes Analysis contains bar chart with option of price or call length on vertical axes Number naming might be turned on and naming columns defined for calling phone numbers Items with zero price might be excluded from the analysis Comment Option Include items with zero price into analyses should move calls count and units count SMS MMS Data Call length closer to SSS or SSTN However it is only approximate criterion and calls units count may not correspond with SSS SSTN For example Notice SMS has usually zero price and is not included in SSS SSTN but SMS for free to T mobile has also zero price and even though it is included in SSS SSTN Totals by destinations Analysis might be calculated from SSTN or ISS ISPT and displays services number of calls number of units unit name average calls length and charged price Analysis might be calculated for phone numbers groups or combination of both or for project codes Analysis contains bar and pie chart with option of price or call length on vertical axes Number naming might be turned on and naming columns defined for calling phone numbers Items with zero price might be excluded from the analysis Comment Option Include items with zero price into analyses should move calls count and units count SMS MMS Data Call length closer to SSS or SSTN However it is only approximate criterion and calls units count may not correspond with SSS SSTN For ex
116. r ES console security option mim im files Access to turn on naming A ES redesigned in modules nf ojm a D O SA cr O un h O s o D D cr 5 te O h O O 5 gt 0 Copyright O 2015 by T Mobile Czech Republic a s Corporate Costs Administrator III Caption Application Part Application 31 2 Application Run application On application startup all necessary Microsoft NET Framework libraries are loaded This may cause an delay before displaying splash screen After splash screen is displayed all necessary libraries are loaded and application initialization starts Initialization state is displayed on green progress bar in bottom part of the form under the T Mobile logo L me CORPORATE COSTS ADMINISTRATOR III Any and all copyrights pertaining to the Corporate Coste Administrator software application the Applicaton jbelongto T Mobile Czech Republic as The Application may mot be modified bythe License provided to third partes or used in a way other than forthe purpose whach Ss specited inthe documentation relating to the application and for which T Mobile Czech Republic a granted the licence tothe Licensee SE Mobile m LIFE i FOR SHARING Ld Splash screen Main application form All functions and tools are available on the main application form displayed after application initialization is done Corporate Costs Administrator III Downlo
117. r Ill 3 3 3 Splitting and file naming 3 3 4 Splitting and file naming allows to choose export directory splitting of export to more files according to defined parameters and defining naming mask of result files Splitting and file naming E Export directory D T Mobile CCA III Export File naming pre defined masks dd bn export csv O IE Y Everything to one file 77 rz A 4 4 rz Hide Splitting and file naming Control buttons Splitting display detail of splitting and file naming Hide minimize detail of splitting and file naming into compact size Export directory Text field for definition of export destination directory where result file or files will be saved Using button On the right side of text field it is possible to select directory in standard system dialog for selecting directory File naming pre defined masks Export output might be split to files according to parameters Period Reg number Billing arrangement Invoice number Group Telephone number or store whole export into one file Each parameter might be added to file mask using button with pencil icon next to checkbox Buttons Add predefined mask Remove predefined mask Button with pencil icon inserts mask of current parameter Period Reg number Billing arrangement Invoice number Group Telephone number into file naming mask Example If splitting according to perio
118. r calling numbers Group name Predefined export definitions for I SS I SPT For easier export of Itemized Statement of Services from SFN III application some predefined export definitions were added Copyright 2015 by T Mobile Czech Republic a s 66 Corporate Costs Administrator Ill Predefined export 1SS ISPT according to SFN I Predefined export according to original definition from SFN I text file separated by semicolon in standard encoding including total sums and sums for each phone number Contains columns Phone number Tariff Service name Called number Date Start time Units Original price Charged price VAT Predefined export ISS ISPT without sum with sum only sum Three variants of predefined export containing all available information from Itemized Statement of Services text file separated by semicolon in standard encoding variants Amounts without sums Amounts with sums and Totals only Contains columns Phone number Invoice number Billing group Billing period from Billing period to Tariff Service name Called number Date Start time Units Unit Original price Charged price Discount Discounted price VAT Naming for calling numbers Naming for called numbers Group name Predefined export definitions for Invoices For easier export of Invoices Statement of Services from SFN III application some predefined export definitions were added Predefined expo
119. ra number calling 4 Count Limits 60528002 NT CEST ET 604881576 0 9119 Telephone number limits Copyright O 2015 by T Mobile Czech Republic a s Settings 89 9 4 Limit types Limit types are defined on this tab sheet these limit types might be assigned to phone numbers or groups List of limit types is situated on the right side Buttons and below the list of limit types might be used to add new limit types or delete own created limit types On the right side there is list of services belonging to actually selected limit type Buttons and below the list of services might be used to add or delete services to from the limit type List of limit types contains several predefined limit types these limit types are mark with gray color these limit types and their services cannot be changed R ER Limit types cu Services included in the limit Activation fees Service name Lump sums SMS National calls excluding VPN SMS Info VPN calls SMS My limit NE ss pecs MMS SMS T Mobile Information server Roaming incoming Roaming outgoing SMS Chat International calls SMS Chat notifications Data transfers SMS Chat entries WAP SMS My Info Other SMS My Info distributed Penalties SMS roaming 0119 OU 1 Limit types Predefined limit types Application installation contains predefined limit types these limit types cannot be changed these limit types are actualized automatically dur
120. rd of automatic installer Installer of CCA ITI contains Microsoft SQL Serveru 2008 R2 Express installer and allows to install own instance of database server for CCA III in recommended installation with SFN name in advanced installation with defined name SQL Server installation can be skipped if customer wants to have CCA III database installed on his own SQL server Installation may be divided according to purpose to several types Installation on local computer Network installation only SOL Server and database Installation to existing SQL Server General recommendation Always install on fully actualized operation system This mean that all recommended actualizations are installed using Windows Update service or Microsoft Update It is also recommended to install optional actualization for operation system or NET Frameworku This recommendation might avoid future potential problems Database server and database language If SQL Server is installed with the application then SQL Server language is automatically set to czech Czech_Cl_ AS Created database has language also automatically set to czech Czech CI AS Possible problems with installation Cannot run installer and no error is displayed If you download installer from internet and you use any newer operation system like Windows Vista then it might happen that installer will be blocked This problem can be solved by manual unblocking of installer in file properties
121. rding to invoice period Invoice Statement of Services To Fast choice voic Telephone ectic M v numbers ts Invoices All invoices under period Export definition Splittig Selected invoices Define Export definition Export d 1601515057 1601515038 Predefined export SSN according to SFN I x Oj LA gt px e WW Define Filter Filter items from left Module provide quick navigation to other modules Data source select of data source for export SSTN ISS Invoices Period date time period settings which bounds invoices selected for export It is possible to choose whether invoices will be filtered according to billing period or according to each detail item call time Fast choice button provides quick setting of date according to predefined templates Option According to call time is enabled only for ISS data source Filter bounding exported data by choosing specific items for export Settings additional settings for export for example correction documents items Data source As data source it is possible to choose Statement of Services by Numbers SSTN Itemized Statement of Services Payment Transactions ISS ISPT Invoices Statement of Services SS This option has impact on list of offered export definitions a theirs columns Filter Contains button for sel
122. rectory using standard system dialog Copyright 2015 by T Mobile Czech Republic a s 76 Corporate Costs Administrator Ill Control buttons Export starts re invoicing export for actually selected phone numbers and displays result in final report Send by e mail sends re invoicing export via e mail 3 4 7 Send by e mail Send re invoicing export and print according to defined settings via e mail is started using Send by e mail button in re invoicing output section At first a dialog for setting message subject file name message body and recipient address is displayed Send by e mail Send by e mail Statement of Services Reinvoicing pdf Dear user re invoicing of telecommunication services for Your subscription is attached Your CCA E mail address Split by groups and send by e mail to group address Split by phone num and send by e mail to address according to num naming Sending re invoicing Masks Message subject file name and message body might contain masks which are thereafter during sending replaced by information from sent data Masks might be inserted using ca button Mask list period invoice period in MM YYYY format regno company registration number BA billing group invoice invoice number group group name number telephone number naming naming according to chosen d
123. rently displayed analysis Export allows to export currently displayed chart to defined file format ij Settings 1 Preview print L Export Buttons below analysis chart view Copyright O 2015 by T Mobile Czech Republic a s 80 Corporate Costs Administrator Ill 4 1 Filter For all types of analysis there is one common filter used to selected data entering the analysis Filter is located in ribbon menu above analysis and graphs module E wane Analysis and graphs Corporate Costs TTEN Do Modules Tools Help Ill i is According to cal time 12 a Y aj O ns Totals To According to invoice period Al cae Med Sat Fast choice ro Fast choice ESE Destination n o a E ese 7 pra Profile v HA v numbers M Invoices Totals Al invoices under period y Type of analysis and chart Sums for O Selected invoices Define Tolis by destins Telephone numbers 1551515060 1561515057 Free units Groups VPN calls J Volume discounts Telephone numbers and groups Private calls Watched calls Project codes Lump sums count Invoicing Axis Y Totals called numbers Analysis filter Filter items from left Module provide quick navigation to other modules Period date time period settings which bounds invoices selected for analysis It is possible to choose wh
124. riod Analysis by day in the week Analysis displays calls statistics by days in week when any call was realized in that period Copyright 2015 by T Mobile Czech Republic a s 84 Corporate Costs Administrator Ill 4 6 Analysis by months Analysis displays calls statistics by calendar months when any call was realized in that period Graph settings Dialog for setting of chart properties contains several tab sheets with specific options Graph settings dialog Tab sheets General Contains settings for chart design like color scheme fill pattern and color of chart Limits Settings for bounding amount of displayed values It is possible to show all records or only specific amount by setting bounding criteria Axis Defines which axes will be visible their positions and orientation of their labels labels belonging to axis Labels Defines visibility of additional labels for chart values Legend Defines visibility position and content of chart legend Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator III Caption Settings Part 86 Corporate Costs Administrator Ill 9 1 Settings Group of modules for setting of important lists these lists are used in other modules Common control buttons Export exports data of module to file on hard drive in defined format Import imports data of mod
125. rmation can be found in chapter SMTP Connection to T Mobile server Defines T Mobile server connection settings If proxy server requires authentication then it is possible to set user name and password for user authentication Two address to T Mobile server are defined here these addresses are used while trying to download data If connection using primary address is unsuccessful secondary address is used instead Primary address should be always set to https sfn t mobile cz sfn Timeout for server answer Timeout in second for downloading one file from T Mobile server User management Management and monitoring of user accesses to application using name and password Manages user accounts and rights Application parameters x RES ine e rer AS Rights administration Y Controlled access to application User must use username and password to access the application In Settings you can create delete user accounts and grant them access to selected parts of the application Settings Logging to database Enable events log Selected application events invoked by user are logged into database It is recommended to periodically delete the log to free database space Display log Delete log User management Rights administration After turning of this option on users have to login to application using user name and password Using Settings button it is possible to define user accounts m
126. rocess of downloading invoices has two steps 1 Login to T Mobile server using name and password 2 Download of selected invoices Login Mandatory items In the first step user name and password might be typed down It is the user name and password used to access t zones Warning Necessary condition for downloading data are active access rights to t zones portal registered to phone number with Invoice administrator status Invoice administrator has access to Invoices SSS SSTN and ordered ISS Customer must be in supported segment LE VSE or must have activated the ProfiNet service Settings CCA III brings new comfort way to decrease amount of invoices displayed in Download data module New functions is design mainly for users downloading big amount of invoices every month With every new month amount of invoices available for download increases and after few years list may contains thousands of invoices Decreasing amount of invoice will short down the time between user login and displaying of available invoices Download all available invoices with this option the list of all available invoices for logged user is downloaded this option corresponds with the functionality of previous CCA version Download only invoices from the specified date here date can be set list of invoices is filled from this date included Invoices are filtered according to billing period TO date Copyright 2015 by T Mobile Czech Republic
127. rt Tax overview Predefined export for accounting purpose including VAT base and VAT rate text file separated by semicolon in standard encoding including only total sums for each invoice Contains columns Invoice number Billing group Company Reg No Billing period from Billing period to Issue date Tax date Due date Price without VAT VAT VAT rate VAT Base 0 Copyright 2015 by T Mobile Czech Republic a s Main modules 67 VAT Base 17 5 VAT Base 19 VAT Base 20 VAT Base 21 VAT 0 VAT 17 5 VAT 19 VAT 20 VAT 21 Price with VAT Taxfree overpayment Heller balancing Total amount due Predefined export Statement of Services Predefined export of statement of services including VAT base and VAT rate text file separated by semicolon in standard encoding including total sums for each invoice Contains columns Invoice number Billing group Company Reg No Billing period from Billing period to Issue date Tax date Due date Service name Free units Billed units Unit Price without discount Price without VAT VAT VAT rate VAT Base 0 VAT Base 17 5 VAT Base 19 VAT Base 20 VAT Base 21 VAT 0 VAT 17 5 VAT 19 VAT 20 VAT 21 Price with VAT Taxfree overpayment Heller balancing Total amount due Copyright O 2015 by T Mobile Czech Republic a s 68 Corporate Costs Administrato
128. s suitable for 64 bit systems C Compact Slower has a small memory requirements suitable for 32 bit systems User restore Migration Migration of CCA 3 database between two computers SFN 111 database migration is a simple operation which can be done in a few steps 1 Create database backup on first computer Run CCA III application open module backup and restore database and choose Create backup operation User can choose backup type server or user we recommend to use user backup Backup file is created on hard drive Beware of user backup limits Copyright O 2015 by T Mobile Czech Republic a s 100 Corporate Costs Administrator Ill 2 Moving backup to second computer It is necessary to transfer backup file to second computer using CD DVD flash FTP shared directory on network etc Move backup file to directory where application or SQL server has access 3 Restore database on second computer Run CCA III application open module backup and restore database and choose Restore data from backup operation Backup type must be the same as selected in first step server or user restoration After finishing of database restore operation database is ready for use Migration of CCA 2 database from on PC to another PC with CCA 3 Migration of database between two versions of CCA is bit more difficult 1 Check CCA II version on first computer At first it is necessary to check CCA II version to be
129. s also available as electronically signed PDF document Second column with title Download contains check box used to mark invoices to be downloaded and imported to database Copyright 2015 by T Mobile Czech Republic a s Main modules 51 Download List of invoices available for download Imported Downl Invoice n Date f Date to Y Reg nu Billing arrang Name II CA v 1561515032 5 1 2011 5 31 2011 25206122 51017289 Ing Karel Nov k 45 398 0 E A Y 1561515060 5 1 2011 5 31 2011 25206122 51017289 Ing Karel Nov k Invoice 45 398 0 Ce a posere ia cn a oras memes eme a os u an aos soras roan me 8 5 398 0 TA gt ro 1601515060 5 1 2011 5 31 2 51017289 Ing Karel Novak NO 1551515032 5 1 2011 5 31 2011 25206122 51017289 Ing Karel Novak Invoice NO IF 1551515057 5 1 2011 5 31 2011 25206122 51017289 Ing Karel Novak 256 3 1718 x Y Name Ing Karel Novak Options V Download Itemized Statement of Services if available V Download el signed Statement of Services PDF if available Bt ES CRE List of available invoices Settings Options In detail settings it is possible to determine if additional documents will be downloaded Download Itemized Statement of Services if available allows to download and import ISS it work only when ISS are ordered These documents contains detail information about calls Amount of these data might
130. s on off application of limits during re invoicing calculation Detail application of each limit is specified in legend Use number naming turns on off displaying of naming columns in re invoicing grids prints and exports Number naming setup is common for calling and called phone numbers Show information about transferred and used units turns on off displaying of free units in re invoicing prints and exports Use original price for re invoicing if option is turned on then original price before counting of free units and other discounts is used for re invoicing Use discounted price for re invoicing turns on off usage of discounts in re invoicing User can set discount re invoicing percentage Option is available only when any invoice contains charge extract Control buttons On bottom panel of this module there are special control buttons Profile allows to load and save settings from to profile Re invoicing starts re invoicing according to defined settings and displays output in grid with more other options 3 4 3 Display re invoicing After finishing re invoicing of services output is displayed in the grid as list of phone numbers included in re invoicing Re invoicing Telephone number fist Billing a Invoice Date from Date to Reg n Teleph Tariffn Items c Charge Re nvoic Print 51017289 160151 5 1 2011 5 31 2011 25206122 603282 Kredit 2 33 38219 43826 5
131. ssible to download installer on address www t mobile cz sfn3install64 Installers sizes are between 105 to 115 MB Installation steps description 1 After selecting language product information is displayed Confirm it by click on Next button Copyright O 2015 by T Mobile Czech Republic a s 12 Corporate Costs Administrator Ill 6 Setup Corporate Costs Administrator II Welcome to the Corporate Costs Administrator III Setup Wizard This will install Corporate Costs Administrator III on your computer It is recommended that you close all other applications before Click Next to continue or Cancel to exit Setup VB Mobile FA e E Architecture x64 64 bit Installation step 1 basic information 2 Licence agreement is displayed it is necessary to accept accept the agreement and continue by click on Next button 6 Setup Corporate Costs Administrator II License Agreement Please read the following important information before continuing Please read the following License Agreement You must accept the terms of this agreement before continuing with the installation By installing copying or otherwise using the Corporate Costs Administrator Ill software you confirm that you have read the following terms and conditions of the End User License Agreement EULA and that you agree thereto without reservations If you do not agree to these terms and conditions you may not
132. systems Backup restore method Control buttons On the right side of bottom panel there are special control buttons Control buttons Run starts selected operation Back one step back in the guide Operation progress Status of every operation is indicated on progress with percentage specification displayed on it Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill Operation progress Operation result After finishing backup or restore operation final report is displayed Database backup Server Select database and file for creating database backup Button Run will start backup creation a Server backup Backup settings Backed up database Current CCA IM database Server APC1007 SFN Database SFN Another database Filename with path C ProgramData T Mobile SFN IIT Backup SFN3_2011 09 20 server backup 4 Server backup User Select modules to be included in backup or backup whole database than select database and file for creating backup Button Run will start backup creation W User backup Backup settings Full database backup Backup selected modules Backed up database Current CCA III database Server APC100715FN Database SFN Another database Filename with path C Users novak Documents T Mobile SFN ITI Backup SFN3_2011 09 21 user backup oo 4 Backup method e Default Fast has a larg
133. t of watched calls lists is situated on the left side buttons and below the list might be used to create or delete watched calls lists On the right side there are number masks belonging to actually selected watched calls list buttons and below number masks might be used to add or delete number masks Watched telephone numbers Watched phone number might be specified by whole number or using mask mask support these special characters any character any text zero or more characters NE mask negation Number will meet this condition if it does not fit to the mask Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator III Caption Tools Part Tools 93 6 1 6 2 Tools Special tools for CCA III application Used for parameters configuration easy access to data files and providing of different important information Folders Auxiliary buttons Used for quick access to default directories of data files or export and re invoicing outputs opened in Windows explorer mil Data Documents Folders Data opens directory with configuration files application logs and downloaded data if not defined differently Documents opens default directory for export re invoicing and database backups Database Database tools Slou pro konfiguraci optimalizaci a zjiStov n nejruznejsich informac spojen ch s datab z nebo datab
134. tatement of Services if checked then Summary Statement of Services report is printed for selected invoices Statement of Services by Telephone Numbers if checked then Statement of Services by Telephone Numbers report is printed for selected invoices Itemized Statement of Services Itemized Statement of Payment if checked then Itemized Statement of Services Payment Transactions report is printed for selected invoices Options Telephone numbers to separate pages if checked then document for each telephone number is printed on separate pages If unchecked and document details are short then more then one telephone number might be printed on same page Show discounts on summary or itemized statement of services if checked then values on Statement of Services by Telephone Numbers and Itemized Statement of Services are printed including discounts Control buttons Copyright 2015 by T Mobile Czech Republic a s Main modules 59 3 2 8 Preview Print generates report previews of selected invoices according to user settings Print to file prints report in selected format to file on disk Profile allows to load and save settings from to profile Close closes dialog Print to file While printing to file it is possible to define directory file name mask and file splitting Using button Print to file list of supported file formats is displayed and by selecting one of them print to file is started Spl
135. te VAT Base 0 VAT Base 17 5 VAT Base 19 VAT Base 20 VAT Base 21 VAT 0 Copyright O 2015 by T Mobile Czech Republic a s Main modules 65 VAT 17 5 VAT 19 VAT 20 VAT 21 Price with VAT Taxfree overpayment Heller balancing Total amount due Predefined export definitions Predefined export definitions are included in application installation Predefined export definitions for SSTN For easier export of Statement of Services by Numbers from SFN III application some predefined export definitions were added Predefined export SSN according to SFN Predefined export according to original definition from SFN I text file separated by semicolon in standard encoding including total sums and sums for each phone number Contains columns Phone number Tariff Service name Free units Billed units Unit Price VAT Predefined export SSN without sum with sum only sum Three variants of predefined export containing all available information from Statement of Services by Numbers text file separated by semicolon in standard encoding variants Amounts without sums Amounts with sums and Totals only Contains columns Phone number Invoice number Billing group Billing period from Billing period to Tariff Service name Free units Billed units Unit Price Discount Discounted price VAT FUOM name Current FUOMs Spare FUOMs FUOM unit Naming fo
136. ted for example by using task scheduler CCA III used for this function extra executable exe file SFNC exe which is full valued console application that means application runs in command line console Information about progress and result of batch mode operations are written during the process onto the console command line Logo Supported operations Download and import of new invoices Export of new downloaded and imported invoices Command line parameters description or HELP displays help how to use console application SFNC exe N denies display of operation progress this is used mostly when standard output is redirected to file CREATESECUREBATCH creates batch file with extension cmd with decrypted login information for protecting of user name and password EXECUTE DOWNLOAD DOWNLOAD EXPORT runs typed command DOWNLOAD downloads and imports all available invoices DOWNLOAD EXPORT same as DOWNLOAD but all newly imported invoices are than exported to file EXECUTE EXPORT executes invoice export Export profile defines invoices for export DATEFROM date date from which invoices are downloaded Date must be in D M Y format day month year or M D Y format month day year for example 25 2 2011 2 25 2011 or might be according to local settings optional Copyright 2015 by T Mobile Czech Republic a s Application 43 Find out more information about this paramet
137. ted in any directory were application and in case of server backup also SQL server has rights for reading and writing Field for specifying backup file has two buttons Filename with path Backup file selection Button opens dialog for file selection Button lt for selected operation chooses the best backup directory with proper rights and file name Selection of database backup or restore method User backup and restore contains two methods how it can be performed Both methods are compatible they are generating the same data Default This method process data only in memory Each table is whole loaded into memory and then it is processed This is fast method This method has a large memory requirements Backup of 70 Invoices with Itemized Statement of Services take about 1 5 GB of memory Database which contains thousands Invoices with ISS will takes tens GB of memory It is suitable for 64 bit systems Compact This method process data by small chunks Each table is read from database or file continuously by small parts and each part is separately processed This method should be slower as Default method Due to used manner this method takes only small amount of memory about 10 MB It is suitable for 32 bit systems Backup method 0 Default Fast has a large memory requirements suitable for 64 bit systems Compact Slower has a small memory requirements suitable for 32 bit
138. th technical support These information are send with report to technical support for quick customer identification and easier communication Filling of these parameters is import and it will soeed up your communication with technical support For bigger companies we recommend to mention contact person which is responsible for CCA application in your company Edit customer profile Company name Contact person Contact e mail Contact telephone 420 555 555 555 mer ore CR ee ee Co Miss de oo dt a file contains basic information for Your quick identification a Tania tar Ti ETES p E g with T mobile technical support This information is used wher sno ta toarhrniral es art Airaris Gam PA rahan A sage to technical support directly from CCA application All info Customer profile Copyright 2015 by T Mobile Czech Republic a s 110 Corporate Costs Administrator Ill 6 5 6 6 Password change Password change of actually logged user Function is available only when controlled access to application is enabled in application parameters Users have to login to application using name and password r O Change password Change password logged in user Old D ord sssssss XXXXXXXXXX IIA Password change Send report Send report to technical support dialog Easy and quick way to communicate with technical support Allows to send error report question or i
139. tion Closing provisions T Mobile may update otherwise modify or terminate the grant of the right to use the SOFTWARE at its own discretion at any time T Mobile may change the terms and conditions of this EULA at its own discretion Any changes Shall become effective in relation to the end user upon the end user being informed of such changes provided that the end user continues using the SOFTWARE after receiving such notification This EULA shall be governed by the laws of the Czech Republic with the exclusion of conflict rules Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator III Caption Contact Part 124 Corporate Costs Administrator Ill 11 Contact Customer Service Business T Mobile Czech Republic a s Tomickova 2144 1 149 00 Praha 4 Phno 4644 from T Mobile network Phno 420 603 604 644 Fax 420 603 604 646 E mail business t mobile cz Internet http www t mobile cz Web CCA http www t mobile cz web cz firmy a verejna sprava muj t mobile vyuctovani spravce firemnich naklad Copyright O 2015 by T Mobile Czech Republic a s Corporate Costs Administrator III Caption Version Part Xl 126 Corporate Costs Administrator Ill 12 Version Manual version 21 Copyright O 2015 by T Mobile Czech Republic a s index 127 Index NET 6 A About 34 Access 106 Analysis 79 An
140. tion detail and file naming and splitting information hidden out Export definition Export definition gt Predefined export SSN without sum pAy gt iOi O JO Column name Value gt rat borne OOP islo faktury Invoice Number Za tek fakturacniho obdob Billing Period From Konec faktura niho obdob Billing Period To P Export settings File format Text file separated by semicolons CSV X EETA or EA Date format Time format Number format Decimal separator Thousand separator dd MM yy HH mm ss 0 00 v 01 02 2012 06 07 08 1234 50 Export free charged units as integer numbers ry 3 ia Hide Export definition Control buttons Naming show hide columns with naming For adding naming column into final export it is necessary to add column with naming Naming of calling numbers nebo Naming of called numbers into export definition Definition displays detail of export definition Hide hides detail of export definition Export definition name and selection Export definition might be selected on left top panel of dialog On the right side of this panel buttons for adding editing and removing of definition are situated Special dialog is displayed to enter definition name while adding new or editing current definition Columns definition List of data columns included in export Column name user defined nam
141. tion parameters New version found If application finds new version information window in right bottom corner is displayed Download of the new version is started be click on this information window px Check updates New update available Current version 3 10 Mew version 3 11 Click here to download and install the update New version available Copyright O 2015 by T Mobile Czech Republic a s Application 35 2 3 Actualization download Internet connection and access to T Mobile server is necessary to proper work of check for new updates Downloading new version Dowloading actualization Actualization install Installation may run two different ways 1 If only actualization of application files is needed then actualization tool SFNU exe is started which overwrites all necessary files This is done in 95 causes pro spole n z itky coeseeeeestees obile Application files actualization 2 If actualization or installation of third party component is needed then standard setup is started which updates all necessary files Export On many place in CCA III application where grid view of data is used quick export button allows to export displayed table Accessibility of this button may be restricted be user rights It is necessary to divide this export of displayed table from Export module which offers a powerful tools for exporting data Copyright 2015 by T Mobile Czech R
142. to accept the licence agreement to continue Select I accept the agreement and continue by click on Next button ts Setup Corporate Costs Administrator IM Database License Agreement Please read the following important information before continuing Please read the following License Agreement You must accept the terms of this agreement before continuing with the installation By installing copying or otherwise using the Corporate Costs Administrator Ill software you confirm that you have read the following terms and conditions of the End User License Agreement EULA and that you agree thereto without reservations If you do not agree to these terms and conditions you may not install or otherwise use the Corporate Costs Administrator Ill software END USER LICENSE AGREEMENT Corporate Costs Administrator nw I accept the agreement 1 do not accept the agreement Architecture x64 64 bit Installation step 2 licence agreement 3 Select installation type and components Confirm it by click on Next button Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill 6 Setup Corporate Costs Administrator IM Database Select Components Which components should be installed Select the components you want to install dear the components you do not want to install Click Next when you are ready to continue Recommended installation Recom
143. tory where application or SQL server has access 4 Restore database on second computer Run CCA III application open module backup and restore database and choose Restore data from backup operation Select server restoration type After finishing of database restore operation database is ready for use Copyright 2015 by T Mobile Czech Republic a s Tools 101 6 2 2 6 2 3 6 2 3 1 Error messages List of known database error messages and their solution Message Allowed database space was exceeded This problem might happen in case when free version of MSSQL server is used This version is distributed with SFN application and has limitations on database size More about limitations of free version of SQL server might be found in section HW SW requirements When using MSDE 2000 distributed with SFN 11 It is possible to install MSSQL Server 2008 R2 Express distributed with SFN III which has 5 times higher limitation on database size 1 Make database server backup 2 Uninstall CCA instance of MSDE 2000 using control panel 3 Using CCA III installer install CCA instance of SQL Serveru 2008 R2 Express 4 Run SFN with parameter BACKUP 5 Make database server restore When using MSSQL Server 2008 R2 distributed with SFN III It is possible to buy and install full version of MSSQL Server which has no limitations on database size 1 Install any instance of your own SQL Server 2 Install CCA database
144. tree and icons of each item cannot contain any warning signs If there is only one item in the certificate tree than necessary root certificates are not installed If some icon contains any warning sign it shows on problem with certificate validation expired not trusted certificate etc In any of these cases it is necessary to actualize root certificate Copyright 2015 by T Mobile Czech Republic a s 42 Corporate Costs Administrator Ill 2 8 Certificate Certificate General Details Certification Path General Details Certification Path Certification path j Certificate Information q VeriSign La VeriSign Class 3 International Server CA G3 This certificate is intended for the following purpose s El Ensures the identity of a remote computer Refer to the certification authority s statement for details Issued to sfn t mobile cz Issued by VeriSign Class 3 International Server CA G3 Valid from 9 5 2011 to 9 5 2012 Certificate status is certificate is OK Install Certificate Issuer Statement Learn more about certificates Learn more about certification paths Trusted certificate Batch mode Application allows to provide some operations automatically without user interface and with interaction with user This is called batch mode which provides operations according to command line parameters Batch mode might be automatically star
145. ts Administrator 111 application from your computer Corporate Costs Administrator M Uninstall Uninstall Status Please wait while CCA III is removed from your computer Uninstalling CCA TT Cancel Uninstall step 2 progress 3 A After successful finishing of application uninstall information about uninstall completeness is displayed Confirm in using OK button Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill 11 1 2 1 Corporate Costs Administrator M Uninstall 3 B After finishing of application uninstall information about uninstall completeness is displayed Confirm in using OK button Some times installer cannot remove all files usually because application is still running In this case remove the rest of files manually Corporate Costs Administrator M uninstall complete Some elements could not be removed These can be removed manually Uninstall step 3B Uninstall done with some detail information Local Installation of Corporate Costs Administrator lll on local computer Installer types Installer with MSSQL 2008 R2 Express x86 designed for 32 bit operation system start installation using SFNsetupAll2008R2x86 exe file it is possible to download installer on address www t mobile cz sfn3install Installer with MSSQL 2008 R2 Express x64 designed for 64 bit operation system start installation using SFNsetupAll2008R2x64 exe file it is po
146. ts of Ser Paym Trans 1688 0 13 ME Configurations 5 0 01MB Number naming 5012 0 76 MB Performance is normal server should perform optimally and fast Database indexes 109 F 4 Level Fragmentation Fragmentation gt 2 ok Discounts CLUSTERED INDEX Export_Columns pk_Export_Columns CLUSTERED INDEX FUOMs pk_FUOMs CLUSTERED INDEX LimitType_Items pk_LimitType_Items CLUSTERED INDEX MetaGroupHeaderFooter pk_MetaGroupHeaderFooter CLUSTERED INDEX Overall_Services pk_Overall_Services CLUSTERED INDEX PhoneDetail pk_PhoneDetail CLUSTERED INDEX PhoneDetail_ServiceDets pk_PhoneDetail_ServiceDets CLUSTERED INDEX 67 High 75 Very high 50 High 75 Very high 67 High 24 Medium 60 High OO 14 v Miss aa Server performance is not affected Note Not e all indexes can be defragmented Defrag Database performance Connected database Displays detail information about actual database and SQL server APC1007 SFN 10 50 2500 0 SP1 Express Edition 64 bit Czech_CI_AS DISABLED NO Microsoft SQL Server 2008 R2 SP1 10 50 2500 0 X64 Jun 17 2011 00 54 03 Copyright c Microsoft Corporation Express Edition 64 bit on Windows NT 6 1 lt X64 gt Build 7601 Service Pack 1 E Database Database name Database language Recovery model Connected database Database connection settings Allow to setup database connection Server name name or IP addr
147. ty protocols are accepted by CCA application for SMTP server communication If more protocols are allow then protocol supported by SMTP server is used If no protocol is allowed then application acts like security is disabled Allowed ciphers Application support lots of ciphers this option allows to decide whether all ciphers might be allowed or only group of ciphers classified as secured might be allowed Cipher usage always depend on ciphers Supported by SMTP server Copyright 2015 by T Mobile Czech Republic a s Tools 109 6 4 Use extended protocol ESMTP If option is turned on and SMTP server supports extended instructions of SMTP protocol then these instructions are used during communication Some SMTP servers sends information about extended instructions support but instructions support is not implemented for these cases it is recommended to turn ESMTP protocol off SMTP extra settings A separate dialog containing all other settings for SMTP You can change the timeout for sending email and the maximum retries on failure Send timeout seconds The maximum retries on failure SMTP Extra Settings Test Button Test will try to send test e mail to sender address according to actual communication settings After finishing of message sending message about operation success is displayed Customer profile Special dialog for setting of contact information These information are used for communication wi
148. ule from file on hard drive in defined format Preview print displays current module data report preview Button is not available in number naming module Number naming turns on off displaying of phone number naming in current module Button is not available in number naming module Control buttons Groups Groups allows to join phone numbers to groups and define common properties for this group of numbers Application supports groups hierarchy that means groups might belong to another superior group Application installation contains predefined structure of group which might be customized by any user f Name E Whole company by departments Group name Group description i Sales Group e mail Whole company by limits TEE croup menverstio RETA in Other Telephone number calling 604881576 F Induding members in subgroups Tree of all groups is situated in left part of the module Each group has its own properties Groups might be added and deleted using and buttons below the groups tree groups in tree hierarchy might be moved using drag amp drop method Group properties Name define displayed group name Description additional description for easier group identification E mail e mail address for whole group of phone numbers this e mail address is used while sending export or re invoicing via e mail Group membership list of phon
149. umber Billing group Billing period from Billing period to Tariff Copyright O 2015 by T Mobile Czech Republic a s 64 Corporate Costs Administrator Ill Service name Free units Billed units Unit Price Discount Discounted price VAT FUOM name Current FUOMs Spare FUOMs FUOM unit Naming for calling numbers if naming is enabled then this column will be replaced by columns from naming of calling number Group name list of groups delimited by comma which includes current phone number Columns for Itemized Statement of Services Payment Transactions ISS I SPT Phone number Invoice number Billing group Billing period from Billing period to Tariff Service name Called number Date Start time Units Unit Original price Charged price Discount Discounted price VAT Naming for calling numbers if naming is enabled then this column will be replaced by columns from naming of calling number Naming for called numbers if naming is enabled then this column will be replaced by columns from naming of called number Group name list of groups delimited by comma which includes current calling phone number Columns for export of Invoices Statement of Services SS Invoice number Billing group Company Reg No Billing period from Billing period to Issue date Tax date Due date Service name Free units Billed units Unit Price without discount Price without VAT VAT VAT ra
150. user to modified filter criteria Amount ice Blanks 45 398 00 C2 Non blanks 0 00 CZK 1648 00 CZK 10 606 00 CZK PUE 45 398 00 CZK 0 00 Ca Select value for filter Copyright O 2015 by T Mobile Czech Republic a s 46 Corporate Costs Administrator Ill Custom AutoFilter Show rows where Amount And or Define own filter criteria Lia Filter Editor And i Billing arrangement Equals 51013683 Edit filter 2 11 Profiles Profiles are used for quick and easy setup of predefined options Profiles might be found in print invoices export re invoicing and analysis filter profiles are stored in database and are accessible for every user working with CCA application on the same database Usage User usually needs in one module like export periodically generate specific outputs for other systems and repeated setting of options might by time consuming Function allows to store each setting as one profile and if needed load the specific profile from database Access Profiles are accessed using special profile button which allows to load save and delete profiles Profil is identified by its name which is set while saving profile Profile Tips Rename profile Profile might be renamed by loading the profile than deleting it and saving it whit the new name Copyright 2015 by T Mobile Czech Republic a s Application 47 2 12 2 13 Remot
151. virtual machine where Microsoft Windows it is necessary to own licence are install and than CCA Hardware requirements Minimal Procesor 1 GHz Operation memory 512 MB Space on hard drive NET SQL Server CCA III 2 GB 32 bit system 3 GB 64 bit system amount of processed data downloaded XML invoices Recommended Procesor 2 6 GHz dual core or more Operation memory 3 GB and more 64 bit operation system Copyright 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill 1 2 Ideal PC configuration for CCA III Procesor 3 GHz quad core Operation memory 4 GB Operation system Microsoft Windows 7 64 bit Internet Explorer 10 or 11 Internet Explorer It is necessary to have installed latest version of Internet Explorer and all important actualizations Even if you do not use Internet Explorer many services and application do including CCA application In CCA Internet Explorer resp its part COM component WebBrowser is used to display final report of different operations lite download and import of invoices export re invoicing Final report is designed for XHTML 1 0 standard which might be displayed incorrectly in older versions of Internet Explorer It is recommended to have at least Internet Explorer version 8 Install and uninstall Installation of Corporate Costs Administrator 111 Installation of CCA III application is provided by simple wiza
152. yright 2015 by T Mobile Czech Republic a s 72 Corporate Costs Administrator III Re invoicing Settings Services E Services from Statement of Services Limits and number naming Y Do not re nvoice selected services or re invoice them differer V Do not re nvoice services from SSS or re invoice them diffe Y Show original price and legend A Service name Re nvoid Service name Re invoicing mode Re nvoicing pe Y Private call re nvoice differently gt Calls coloured lines gt Volume discount according to SIM Re invoicing percentage 20 eset anc F Watched calls re invoice differently Calls free 100 Calls O2 network 100 Y Use limits Calls T Mobile fixed network 100 Re Calls T Mobile network 100 Limits def e Calls U fon network 100 Other payments to re invoice E Both imit types number limits has higher prior Calls Vodafone network 100 F a1 Calls VPN PN preys Item name Re nvoicing mode Amount VAT V Use number naming Due pesen co 520010 7 M eee GPRS EDGE 3G 100 pS A ELNE GPRS EDGE 3G Internet 100 7 Show information about transferred and used units GPRS EDGE 3G Internet zdarma 100 Y Use original price for re invoicing Internet for a travelling 100 without free minutes or any other discounts Itemized Statement of Services 100 V Use discounted price for re invoicing MMS 100 Pe Discount re invoic
153. zov m serverem PE Es E Performance Connected Database connection Backup and restore database settings database Database tools Performance Monitors database data amount and database indexes fragmentation If data amount in any module exceeded defined limit then database performance might be decreased Dialog monitors database state and displays warning when any limit is exceeded High index fragmentation might have also impact on database performance Using defragmentation it is possible to optimize some indexes and speed up application operations Dialog displays also information about size of all downloaded data Application keeps downloaded documents on hard drive in case of future import of previosly downloaded documents Copyright O 2015 by T Mobile Czech Republic a s Corporate Costs Administrator Ill Database pertormance M a O a Database performance Description Database performace is informative only It can be used as indication to identify possible issues caused by huge data volume increase Data base load computation does not take into consideration hardware used for database server and can thus be misleading Information about database performance and current HW configuration may be required by T Mobile support when solving an issue Size and amount of data Module name Count size Items size Statement of Services 5 E Statement of Services by Numbers 1728 0 14 MB Itemized Statemen

Corporate Costs Administrator III - T

Contents

Download Pdf Manuals

Related Search

Related Contents