Analysis of the information management system of t

With the rapid development of computer network technology, more and more enterprises use information systems to improve their management level and strive to remain invincible in the fierce market competition. As a traditional processing industry, the printing process is complex and has many links. If you don't pay attention to it, it will make mistakes and cause great waste. Therefore, it is very important to use information system for management

before the printing enterprise establishes the information management system, the selection of database is very important, which should be combined with the specific system functional requirements and comprehensively consider various factors. The web FOXBASE database has strong processing power and high flexibility, which can meet the needs of printing enterprises. It is also a kind of database widely used by printing enterprises at present. This paper mainly studies how printing enterprises build their own information management system after the implementation of the "plastic restriction order" for more than 7 years on the basis of FOXBASE database

composition of database

printing enterprises can establish corresponding information management system user database according to actual needs. The user database is mainly composed of the following sub databases

1. Business management

includes order management, quotation management, customer information management and customer service. Customer contact can be achieved. Supply contact, business plan arrangement, coordination with the dispatching center, arrangement of printing, summary of business completion, outsourcing plan, reminder of unpaid funds beyond the scheduled period, customer service management (customer feedback/complaints, etc.) and other basic functions

2. Production management

includes scheduling center system, prepress, printing and post printing subsystems, and equipment management. It is the core of printing enterprises

3. Material management

includes material inventory, material purchase, finished/semi-finished products, picking and returning materials, and material inventory

4. Financial management

conduct cost analysis, calculation and cost variance analysis management, business accounting, material accounting, cashier, audit management, wages, accounts, fixed assets management

5. Statistics and analysis of other personnel and public information

data flow analysis

the business department contacts the customer, obtains the order and contacts with the relevant departments (whether the materials can be met and whether the production can be met). If it passes the review, it will be submitted to the scheduling center, which will schedule according to the delivery date and give a reply that it can deliver on time. The business department needs the dispatching center to arrange appropriate prepress according to the progress and printing demand. The printing and post press processes are combined and rolled close to the pressure to produce printed copies

after the order is confirmed, it is handed over to the scheduling center for production arrangement. The dispatching center determines the production priority, the satisfaction of materials and production resources, arranges the appropriate progress, issues a production order, determines the production process, and transfers it to the production department (prepress, printing, and post press processing). When the materials cannot be met, it is necessary to contact the material department, which will make a purchase plan

the prepress department shall contact the material department according to the production order and the process requirements to obtain the required materials (film, alcohol, developer, etc.) and mark the relevant matters. After the production is completed, the next production can be carried out and handed over to the next process

the printing department shall contact the prepress department, and feed back the information to the prepress department if there is any problem. The printing department shall contact the material department as required to receive the required materials (paper, ink, etc.) for printing. After printing, indicate that it is completed, indicating that other printing arrangements can be accepted, and hand over the semi-finished products to the post press processing department at the same time

the post press processing department should also feed back the information of finished cattle products, and contact the material department to obtain relevant materials. After the finished products are finished, count the quantity of qualified products, contact the dispatching center in time, fill up the mantissa, and then pack and put into storage

the customer needs to contact the business department before picking up the goods, and the business department issues the bill. The products will be delivered to the designated place according to the order. The finance department is responsible for the specific payment and tracking and managing the settlement

in addition to the daily management of raw materials, semi-finished products/finished products (semi-finished products in printing enterprises generally flow in the workshop, and inventory is not managed; but semi-finished products are warehoused when suspended), the material department is also responsible for the purchase of materials, the management of material suppliers, etc. After purchasing raw materials, the material department shall check and accept them for warehousing. If any problem is found, return the materials and fill in the relevant documents. When receiving raw materials, the production department shall fill in the material requisition, and the remaining materials in the production process shall be returned to the warehouse

the information flow between departments can be realized through the local area within the enterprise, and the information exchange with the outside can be realized through the Internet

specific contents of the database

1. Shared database

(1) business departments mainly use the following databases:

order Library - mainly storing order numbers and customer codes. Product name, required quantity, specification and unit price. Whether to sign and print the sample sheet, signing date, delivery date, delivery method, delivery place, transportation expenses, settlement method, settlement period, currency, business personnel, receipt time, packaging instructions (packaging method, size, etc.), remarks, etc

customer management Library - mainly stores customer information, customer code, customer name, region, address, contact information, contact person, remarks, etc

customer service Library - mainly stores order number, customer code, service content, reason, remarks, etc

(2) the production department mainly uses the following databases:

scheduling information database - mainly stores production order number, order number, scheduling date, completion date, pre press and printing and post press processing process requirements, scheduling personnel, confirmation personnel, responsible personnel, remarks, etc

prepress information base - mainly stores production order number, order number, prepress category, producer 1, producer 2..., prepress requirements, division, old and new editions, completion date, remarks, etc

printing information base - mainly stores production order number, order number, printing category, unit 1, unit 2,..., printing requirements, printing method, completion date, paper name, total number of papers, quantity of semi-finished products, color code or description, quantity of damage, remarks, etc

post press information base - mainly stores production order number, order number, post press category, arrangement information, post press requirements, completion date, etc

equipment management Library - mainly stores equipment files, equipment registration cards, equipment use files, equipment maintenance, equipment renewal, transformation, depreciation, scrap, equipment changes, configuration changes, remarks, etc

(3) the database used by the material management department includes:

material management Library - mainly storing material number, name, specification, quantity, unit price, amount, purchase, acceptance, storage, bookkeeping, supplier, invoice number, date, and it is also equipped with two guide rail remarks for guidance

picking warehouse - mainly storage number, name, specification, unit, quantity (planned/issued), unit price, amount, picking person, handler, date, remarks, etc

material return warehouse - mainly storage number, name, specification, unit, quantity, material return person, handler, date, remarks, etc

finished/semi-finished product database - mainly storage number, name, specification, unit, quantity, warehousing personnel, handler, warehousing date, remarks, etc. A reliable testing laboratory is needed to provide supporting services

inventory Library - mainly storage number, name, specification, unit, book, number of accounts, actual count, stockist, custodian, date, remarks, etc

purchasing and material supplier library - mainly stores the supplier's material code, commodity name, price, price change, batch requirements, specifications, delivery place, transportation method, payment method, currency, supplier code, name, address, contact information, contact person, reputation record (on-time delivery/quality/after-sales service, etc.), supplier's technical level, equipment and ability, Purchase order confirmation (confirmed/unconfirmed/in progress/completed), etc

(4) personnel information base: it mainly stores the code, name, personal data and other information of employees

(5) financial information base: it mainly stores payment management information, salary management and financial information

2. The non shared database is a non shared and exclusive database, which depends on the specific internal situation of the printing enterprise. In principle, in order to reduce the pressure of network transmission and server and improve the performance of the whole system, it should be placed on the local machine

the data operations involved in the above systems mainly include: data entry, update, deletion, backup, data statistics, sorting and indexing, retrieval, database association, update and link, etc