Structure

This is organizational structure of the client company for which an informational system for business process automation was created:

Description of business process:

• the parent and daughter enterprises place contracts with contractors;
• estimate of costs is specified in the contracts;
• upon complete or partial execution of the contract the parties draw up a formal acceptance act;
• according to the act economic department writes out a pay-sheet – legal document on the basis of which bookkeeping department transfers money;
• the parent enterprises finance the daughter enterprises (contract of financing);
• according to this contract the contents of the work are defined generally, the daughter enterprise usually divides the work into parts, finds contractors and places contracts for this work with them (contractor’s agreement). The daughter enterprise controls execution of the contract. In some cases daughter enterprise can become contractor;
• in some cases the parent enterprise places contracts with contractor simpliciter;
• money is being distributed only by the parent enterprise according to a complex hierarchy of lauses, paragraphs, subparagraphs where they are being grouped according to the purpose of use. One contract can imply work according to different clauses and paragraphs;
• in the beginning of a year an approximate planning of expenses according to the clauses is done. Then upon receiving money on the parent enterprise banking account, the system distributes it in an optimal way between daughter enterprises and contractors. Distribution is executed according to the plan;
• the system forms different accounts for analytic purposes during different periods of time (account of current expenses and companies’ debts, account of evenness of financing, account of the execution of the plan).

Screen shots:

• General view of the program
• Integration with cartographic object

Functions:

• new contract data input;
• new act input;
• new payment input;
• searching of contracts according to the given criteria (external and internal number, date of placement, parties, value of the contract);
• all information on the contract in question is shown in a convenient way (history of acts, payments, analytic information – debt, percentage of plan financing);
• pay-sheets printing – legal document – command from economic department to bookkeeping department to make a payment;
• forming different types of accounts of the financial affairs state;
• control which ensures that access to data is restricted to authorized users (each economist has access only to his or her clause and paragraph and has no access to other information);
• automatic system operations protocol making.

Realization:

• data is stored on the database server Microsoft SQL Server 6.5;
• client application is implemented in MS VB 5.0, access to the database server is carried out through low-level interface DB-Library, which considerably reduces network traffic and allows working on low-speed communication lines;
• in the last versions of client program part of interface was re-written in DHTML (right part of the window on the screen shots), which made interface more intuitive and allowed to add new functionality;
• accounts were formed in HTML on IIS 5.0 server with the use of ASP-ADO.