**_Transactional History Database (backend)
In addition to the needs below, please see the attached [url removed, login to view] file for additional clarification. This file contains needs.doc.
We need to develop a MS SQL database to be the home for our transactional data. Transactional data is stored for each of our customers and consists of information similar to what would be found on a bank statement. Transactional history consists of drafts, payments, refunds, credits, fees, and etc.
Customers have key identifiers similar to account numbers that would identify them in the database along with their name.
We require the ability to import this data from excel spreadsheets.
This database needs to be accessable through a web interface. This web interface would eventually be set inside Microsoft CRM to provide account history to our Customer Service reps.
1) Complete and fully-functional working database meeting requirements stated and the approval of our company.
Running on MS Windows Server 2003 with MS SQL Server. Should have web interface that will run on MSIE.