Design And Implementation Of Oilfield Material Company Internal Control And Refined Management Information System

DaQing Oilfield Material Company is large-scale material supply department and social logistics enterprise which collects material purchase,material supply,material storage and material processing and manufacturing ,and which is certified as a 5A-class logistics business enterprise qualification with worldwide recognized, which owns 25 directly affiliated institutions including Mechanical and Electrical Equipment Company,Metal Company,Construction materials company,Chemical Company and so on, and which owns more than 5400 supplier's material supply resource network. Providing the reliable resource support for all kinds of materials which DaQing oilfield purchase more than 210 billion yuan every year.Over the years, In order to reduce oilfield operating costs and provide high quality service support, Material Company face difficulties, according to self business trait, Digging management potential and improving service quality, Material Company reduced the managed cost and achieved enterprise healthy development.The System is a set of management information system with regarding junior management as weight, the ways by controlling management, looking on refined management as standard, setting to improve work efficiency and reduce consumption as objective. The management information system could normalize the enterprise internal management and controlling method, that could reduce enterprise integrated operating costs.The system could realize the controlling management of the enterprise internal resource consumption and working process, it could realize the refined billing management including three level management controlling system of the enterprise junior team or group,junior large team and corporate office. Through production schedule,inspection plan,working arrangement,allocation of funds,scheduled control,purchasing and inventory ,water and electricity metering and so on, the system could normalize the enterprise operating and cost controlling management. The system consist of four sections, which are operating,cost control,report query and system management. The system refer to all kinds of users ,for example the manager of corporate office, system administrator, the manager of junior three lever units and the operator of junior team or group.In order to being fit for the enterprise internal control and refined management, the system use client/server technical structure. Developing the system by PowerBuilder software, the client side adopt user's operation interface, the server side store data and handle the operation logical by using stored procedure and applying the centralized program. The system adopt the object-oriented design method. During the process of the exploitation of the design, Combining PowerBuilder software feature fully, extracting common object, the program development become the construction of building block system. On the database design side, using SQL Server's stored procedure and trigger fully ,to realize the operation ruler by background database. System database include 44 reports ,for example the operation report,cost controlling report,the basic information report and system report and so on .According to the enterprise situation, the system owns lots of characteristic. During Oilfield material enterprise internal control and refined management, the system owns rigorous consume control system, freedom definition operation flow, useful work reminding, powerful report management platform, fast data share and data interface, modularized design and integrated program mode, data by centralizing storage, scheduled backup in order to ensure data safety and so on.The system get the best results after applying in the DaQing oilfield material Co. internal 25 units. It comes true about the enterprise flow control, refined management control, reducing the enterprise operating cost . After implement the system, the enterprise management level improved obviously and good execution. Via processing the transaction on the internet, we have finished 3239 internal planning,4404 transfer slips and 2399.8 million planning amounts only in 2009. The reports and invoices could be printed directly, which facilitates junior team or group , saves the cost of the enterprise and improves the working efficiency.By contrast, Applying the system makes the enterprise resource consumption more effective, which could realize refined billing according to projects, personnel,devices and location and so on, which could reduce purchase costs and transfer the reports and plans on the internet, which could print transfer slips ,which don't need use the vehicles and staffs. Which enhance the enterprise operating executive force, which promote work to be accomplished on time and reduce the work to be delayed.In short, the System play an improving role actively in order to set up the Hundred Year's oilfield and establish problem-solution pattern society as a set of the enterprise management software. It also play a crucial role to normalize the enterprise internal management and control method, improve work efficiency and reduce the consumption for DaQing Oilfield Material Company.