The project is intended to manage and handle contracts. The project must be developed in VB .Net 2005. Relational database must be dynamically selected at setup.
## Deliverables
**Workflow Description:
**System must allows to create a workflow.
the workflow begins with a company with different departments. Each one has its own budget. Every one can send a contract requisition to the system providing all the details of contract such as contract type*. Systems validate requisition against budget and approved next step. If there is a problem with requisition, system will send it back to the user or list of user defined in the workflow. Once everything is ok with requisition, the workflow continues with draft** contract generation. At this step, clauses can be added to the draft contract generated. A lawyer revision can be included at this step to validate the whole contract. Draft contract can be modified several times. Each time it is modified a new version is created. Each file created has to be recorded in the database. If something needs changes then will send user list specified in the workflow. If draft is ok, it goes to contract signing. Here the contract is run against vendors to validate if they have all the documents required by company to sign contracts. Also, any list of task required by company to be accomplished will be added at this step. All pending task have to be finished by a timeframe defined at company level (e.g. 15 days to sign contract with everything required). System must include the option to scan the missing documents at this step until everything’s ready. If everything is ok, contract is printed. There will be a task that describe the signing of each party. Once done, document signed is scanned, form needed from entity is generated and contract is finished.
*An entity is assigned by contract type. Each entity will add at the signing process its own list of requisites to comply with before sending them the contract. This will include a form to be filled with data of running contract.
**A draft is generated based on template selected in requisition.
**Reminder**
Must provide a list of contract due to a future date. Also, according to timeframe, must provide a list of contract within timeframe to avoid the past due contract.
**Contract Signing****
**Before contract is ready for signing, a list of pre-requisites and documents must be fulfilled. Once everything is accomplished, contract is printed. Also, contract has a time constraint to be signed. E.g. Contract must be signed and all pre-requisites fulfilled within 15 days.
**Document Management****
**Each vendor has a list of document in order to contract with company. The documents has a date timeframe. Image of each document must be attached to vendor.
**Clause**
System must allows to create clauses. Each one will have conditions to be triggered by some requisite specified in the requisition (e.g. contract over 500,000 will include this clause)
**Contract****
**Different type of contract template must be defined within the system. These templates must allow defining wildcard with in. These wildcards will insert text from the requisition such as vendor name, address, item contracted, etc.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows XP
RDBMS options:
MS SQL Server
Oracle
Informix
MySQL