Request for

Send us an email Microsoft Partner Network membership
Microsoft BizSpark Startup member
VMWare member
Valid XHTML 1.0 Transitional Valid CSS!

Postcode Anywhere

PayPal for Business

Case studies
On-line Statement Retrieval System

On-line Statement Retrieval System

The client

IKANO Financial Services Limited, a part of The IKANO Group, operates throughout Scandinavia and Germany, providing a range of easy-to-use financial services. Its UK business is based in Nottingham and was established in 1994. IKANO provides customized convenient financial products and support services, including multi-product credit services to multiple retailers, store and budget card, interest free credit and interest bearing loan agreements.


Career 1   Career 2
"I think you've done a good job and worked very hard to get the project to a stable enough state before we brought it in house..."

Ms. Gemma Brierley
IKANO Financial Service Ltd.
Career 3   Career 4


What IKANO wanted

In order to establish its customer service network, IKANO needed to develop an On-line Statement Retrieval System, which enabled the customers to retrieve their statement, including information in transaction history, balance, credit limit, etc., through the company's website In addition, this system should offer a back-end administration system to the administrator.


The key elements of the solution are as follows:

  • The conversion of the EBCDIC code data file to SQL Server 7.0 database. The EBCDIC file, with the record format of 500 bytes fixed- length, comes from another system, which records the recent one month consumption details of each account. In order to import the EBCDIC code data file into SQL Server 7.0 database, we need to convert the data file of EBCDIC code to ASCII code and then write to database.
  • The on-line generation of printable bill with changeable format. Another function of the system was to offer on-line bill inquiry for the customer. Different customer might get different account format after login, i.e. with or without Logo. To achieve this function, we needed to offer a customisable template. We adopted PDF for development. The different PDF templates could be added to the different customers. When the customers login and inquiry their bill, the system used the corresponding template and the data imported into the SQL Server database to generate a PDF file for customers to view and print.
  • View bills after the installation of Acrobat Reader4.0 at the customer end.
    Users could not view the bills with Acrobat Reader4.0 or former version installed at the client end. We named the PDF file according to the user session ID and linked the URL address of the file to the browser. In this way, the PDF files could be viewed by all version of Acrobat Reader.


Abstract Technology adopted the three-layer architecture (Business logical layer, Business data layer, Business presentation layer) to design and develop the whole system. Such system has great flexibilities and capability for future development.

Download the complete case study PDF file format Contact sales Mail icon
Home | Contact us | Site map | Terms of use | Privacy | Resources | Newsletter subscription | FAQ
© 2004 - Abstract Technology Ltd. Online Payment Enabler & Offshore Outsourcing System Development