This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4813 IT projects that we have successfully completed with our customers.How can we support you?
Interface between quotation data and costs database
Project duration: 7 years, 2 months
Brief description
Interface (MS Excel – MS Access – Oracle) for data from the quotation process that is to be used subsequently in a central, operative system (costs database).
Supplement
A prototype is created as the basis for discussions with the specialist department. In the course of the ongoing support, the application was converted from MS Access 2.0 to MS Access 97 and adjusted to new requirements (structural changes, Y2K adjustment, EURO changeover). The quotation data is available in the form of multiple Excel calculation sheets (work packages and power plant components). The task of the application is to import this data into a conversion program, to validate the data and to convert the structures to the target system (costs database). Before the data is transferred, a visual check of the data integrity takes place in a dialog (by means of check totals).
Subject description
The quotation area works from a different perspective than the commercial area. The structures are oriented towards allocating (very detailed) individual task areas to different production sites. The costs database then records all the individual areas into less detailed cost items.
IT project data
- Industries mechanical and plant engineering
- Specialist tasks order processing, processing quotations
- DP tasks customised software new development
- System environments Client/Server
- Procedure model PTA project manual
- Programming languages VBA
- Databases MS Access, Oracle Database
Project period01.04.1997 - 31.05.2004
Customers who trust us
