We are a payment disbursement company, where clients send us payment information and money and we send their payments (checks, wires, etc) out for a fee. We are working on designing and implementing a system to make some of our processes easier. This system we envision is a database system that can manage client and payout information.
We need a database where information is stored, and we can run reports off of the DB information and export those as file(s) to our printer or to one of the other payment methods, we need an API written in one of the common standards (clients will only be dropping data off directly or indirectly through this API and not taking anything), and a login-based web interface for clients to display some of their information. We may also need assistance with creating some of the queries/reports we will need
Database – we need to store the following information.
Contact information (clients/prospects/referrers) –Client ID, Admin name, Contact name, Company name, DBA, Company address, Email, admin username/password, Phone #, IM information, Start date, Contract (y/n), Setup fee received, Referral ID, Notes, import method, rates for checks/wires/ACH, etc.
Payout information - Date, Client ID, Payee name, Memo, Amount, Reference, Payout amount, Street address, City, State, Zip country, Routing #, Account #, Bank name, Beneficiary name, Email address, Epass id, Swift code, Correspondence bank info, Paypal id, etc
Payment types, cost for each type, and the related mapping – Cost per check, wire, ach deposit, epassport payment, etc.
Security - Once our clients post their data to our API, there should be no direct way to access our database, even if a manual process is required to move data from one server to another.
Scripts – we may need to have one or more scripts written where they would move data and transfer it to the DB.
We need the technical documents for the API
and we would prefer to use MS SQL server, but are flexible here