JPH0896045A - Sales program support system - Google Patents

Abstract

PURPOSE: To provide an information processing system which is suited to sales department. CONSTITUTION: Other information, production progress information, and warehousing/shipping information are inputted to a communication equipment 140 from a sales management system 10, a plant production management system 20, and the stock management systems 30 and 40 respectively. These input information of the equipment 140 are registered in a data base 130 by a host computer 110. When a retrieving request is given from the system 10 or an information processing system 50, the computer 110 retrieves a key word and outputs this retrieving result to the requester.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a sales plan support system capable of providing information on the production progress status, inventory, etc. of products manufactured at a steel mill in a form suitable for the sales department and customers. It is about.

[0002]

2. Description of the Related Art Recently, a system for managing information on product production using a computer has been proposed and put into practical use. As a typical example, a process management system that predicts a product completion date, a product management information stored in a warehouse, a stocking / delivery date, and an inventory management system that stores an inventory amount are famous. In addition, a system has been proposed in which a series of manufacturing history from product ordering to delivery is input and made into a database, and the characteristics of the order are analyzed to be utilized for management (Japanese Patent Laid-Open Nos. 5-324670 and 5-324670). 5-
298327).

[0003]

With the above proposal, it has become possible to record a manufacturing history from the occurrence of a product to its disappearance. However, the management system by business (collectively referred to as a distributed management system) and the consistent The manufacturing history database system cannot be said to be suitable for customers such as sales departments and trading companies in the following points, and a suitable information management system is desired.

1) When the decentralized management system is adopted, the person in the sales department confirms with the person in charge of the factory or the person in charge of the warehouse whether or not the product has been shipped or shipped, and grasps the progress of the product. Progress information cannot be obtained if the person in charge cannot be contacted.

2) Even if data relating to warehousing / delivery and inventory is acquired in a database that stores a consistent information history, a person in the sales department must inform the customer of the acquired data by telephone or facsimile. For this reason, there may be a mistake in listening to information or a mistake in description.

3) A distributed management system for making a sales plan is known, but a person in the sales department needs to input order information to this system.

There is no information management system that can solve the above problems, and various information management systems related to production have not been effectively used for the sales department. Therefore, in view of the above points, an object of the present invention is to provide a sales plan support system that can provide suitable information to the sales department and customers instead of the conventional information management system related to production management.

[0008]

In order to achieve such an object, the invention as set forth in claim 1 shows order information indicating the contents of the ordered product and the progress of manufacturing the product. An input means for inputting manufacturing progress information and warehousing / discharging information indicating warehousing / discharging status of the product in a warehouse; a storage means for storing the input order information, manufacturing progress information, and warehousing / discharging information in the form of a database; A central management system having an information processing unit that receives a keyword from the outside and extracts information related to the keyword from the database and an output unit that outputs the extracted information is installed on the manufacturing company side of the product. Characterize.

In addition to the invention of claim 1, a second aspect of the invention is a sales management system for managing the order information at a sales base, a factory production management system for managing the manufacturing progress information at a manufacturing factory, and a warehouse. Information to be stored in the database from the plurality of distributed management systems to the centralized management system by connecting a plurality of distributed management systems including an inventory management system that manages the warehousing / dispatching information to input means of the centralized management system. It is characterized by transferring.

In the invention of claim 3, in addition to the invention of claim 2, the sales management system of claim 2 gives the keyword of claim 1,
It functions as a terminal device for displaying the information output from the output means described in.

According to a fourth aspect of the present invention, in addition to the first aspect of the present invention, an information processing system for giving the keyword and displaying the information output from the output means is installed on the customer side. To do.

The invention according to claim 5 is a calculation means for calculating inventory information of a product that can be sold and the quantity of the product of the contract remaining product from the order information and the warehousing information stored in the database, and the calculation means. A means for storing the obtained inventory information and the amount of the remaining contract in the database, and when the keyword related to the inventory information and the remaining amount of the contract is received from the information processing system according to claim 4, the database is stored in the database. It is characterized in that the stored inventory information and the remaining quantity of the contract are transferred to the information processing system.

According to a sixth aspect of the invention, in addition to the fifth aspect of the invention, the information processing system creates means for inquiring information indicating the inquiry content of the product based on the transferred inventory information and the quantity of the uncontracted product. The centralized management system according to claim 1 receives the created inquiry information from a plurality of information processing systems on the customer side, and the customer is based on the received inquiry information, the inventory information, and the quantity of the uncontracted customer. It is characterized in that it has means for determining the quantity of products that can be sold on the side.

[0014]

According to the first aspect of the present invention, a person in the sales department receives an order, and obtains the location and completeness by outputting manufacturing progress information, warehousing / discharging information, etc. from the database for manufactured products by keywords. You can

According to the second aspect of the present invention, since the information stored in the database is obtained from the distributed management system which is the source of the information, the user does not need to manually input the information.

According to the third aspect of the present invention, the sales management system installed at the sales base can not only send the order information to the centralized management system but also view the information in the database of the centralized management system.

According to the fourth aspect of the present invention, the customer can also access the database of the centralized management system and view the stored information in the database.

According to the fifth aspect of the present invention, not only the manufacturing progress information of the ordered product, but also the product inventory information necessary for ordering a new product and the remaining quantity of the contract can be provided to the customer.

According to the sixth aspect of the present invention, the customer side prepares the inquiry information, thereby simplifying the manual work on the customer side. Further, the manufacturing company side can adjust the production amount of the product by determining the sales amount based on the inquiry information from the customer side, the inventory information, and the information of the contract balance.

[0020]

Embodiments of the present invention will be described in detail below with reference to the drawings.

(First Embodiment) FIG. 1 shows a system configuration of a sales plan support system to which the present invention is applied. In FIG. 1, a plurality of distributed management systems installed on the manufacturing company side are configured to divide processing steps from product ordering through production to delivery into a plurality of parts, and manage the information generated in the divided processing steps, respectively. Includes a sales management system 10, a factory production management system 20, a distribution base system 30, and a coil center system 40 (the distribution system 30 and the coil center system 40 correspond to the warehouse of the second aspect of the invention). In FIG. 1, a sales management system 10 is installed at a sales base, for example, a sales office including a head office,
The order information and the manufacturing progress information received directly from the factory production management system 20 are registered in the sales management system 10,
It is possible to search registered information by keyword. Order information regarding a formal order from the customer is input to the sales management system 10.

More specifically, as the order information, a customer code indicating a customer who is an orderer or a final user of a trading company or the like, a customer collation number managed and issued by the customer, and issued when placing an order. Customer-related customer information such as contract number, line number (hereinafter referred to as line number) that is the contract number, ordering quantity, order mass and delivery date, and order specification information such as product specifications and dimensions are prepared. There is. These pieces of information correspond to the order information of the invention of claim 1. If any one of the delivery date, standard, or size is different, it is managed as a different line number. Therefore, under the same line number, a packing unit of one or more coils or sheets is generated in the factory. As the manufacturing progress information, process progress information indicating whether the manufacturing process is being performed or the product is stored in the factory's product warehouse and waiting for shipment is prepared.

Definitions of these information are shown in FIG.
Since the main key items of the sales management system 10 are the contract number and the line number, the order information and the manufacturing progress information can be searched and extracted using the contract number and the line number as keywords.

A factory production management system 20 is installed in each factory that produces products. The product means one packaging unit of one coil or sheet, and the factory production management system 20 handles product receipt information and product progress information. The main key item of the factory production management system 20 is an inspection number issued to each coil or sheet packing unit when a product is produced in the inspection process.

Product warehousing information is composed of basic product information, delivery information, product location information, and search key items. Product progress information is obtained after the product is stored in the warehouse of the factory (hereinafter referred to simply as warehousing). Progress of each work until shipment (shipment order, loading, shipment hold, customs clearance, etc.)
It consists of the latest delivery information, the latest location information, and search key items. Basic product information includes inspection number, standard, size,
It consists of actual product specification items such as product type, receipt date, number of products, product mass, etc.

The product delivery information is composed of information such as a delivery place of the product, a waypoint code, and a delivery instruction date at the time of receiving the product. In the latest delivery information, the delivery information is attached to the product to be shipped. The invoice number, which is the number of the invoice, and the invoice number line number, which is the details of the invoice number, are newly added, and other information is also updated.

Those items of delivery information, which are input to the sales management system 10 as customer request items, are sent to the factory production management system 20.

The product location information is composed of information such as a product warehouse name at the time of product receipt. In the latest location information, the code of the distribution base or the coil center, which is the destination of the shipped product, is used. In addition to new additions, other information has been updated.

As the search key item, in addition to the inspection number, the customer code, the customer collation number, the contract number, the line number, etc. used in the search of the order information held by the upstream sales production management system 10 Is also registered.

In the distribution base system 30, each work (storage, name change, processing, shipment, etc.) from shipment from a shipping place such as a factory to receipt of goods at the service center of the distribution base and delivery from the service center is performed. Handling information such as actual date and weight, in addition to invoice number and invoice number line number,
It is possible to perform a keyword search using search key items in the sales management system 10 and the factory production management system 20.

The coil center system 40 is also shipped from a factory or a shipping center such as a service center of the above-mentioned distribution base, and is stored in a coil center (sometimes abbreviated as CC) and is delivered from the coil center. Handling information such as actual dates and weights of work (stocking, processing, shipping, etc.), inventory number for coil center management, upstream sales management system 10, factory production management system 20,
It is possible to perform a keyword search using the search key item in the distribution base system 30.

Information on the above-mentioned factory production management system 20 from receipt to shipment to the product warehouse and distribution base system 30.
The information from the receipt of goods to the receipt of goods and the information from the receipt of the coil center system 40 can be searched by the keyword of the inspection number as a consistent key when finally stored in the database 130 in the sales planning support system. is there.

Next, the system configuration of the centralized management system 300 which is installed on the manufacturing company side, receives information related to products from the plurality of distributed management systems, and manages the information in the form of a database will be described. Central management system 300
Is mainly the host computer 110 and the database 130.
And a communication device 140 that communicates with the plurality of distributed management systems.

The host computer 110 serves as the information processing means of claim 1 via the communication device 140, the plurality of distributed management systems, that is, the sales management system 10, the factory production management system 20, the distribution base system 30, and the coil center system 40. Information is exchanged in real time, and the collected data is registered in the database 130.

When an inquiry instruction is issued from the terminal device 120, the host computer 110 reads the relevant information from the database 130 according to the instruction and displays it on the display of the terminal device 120.

The main structure of the database 130 is shown in FIG. In FIG. 3, the database 130 is the row number table 1
31, product basic table 132, CC product table 13
3 and an error table 134. In the line number table 131, product-related information stored in the product basic table 132 and information indicating a mutual information relation between the entry / exit information stored in the CC product table 133 are described. More specifically, the order information and the product information indicated by ◯, Δ, − symbols are described in FIG. Here, the description position of the O symbol indicates the process of registering the information in the line number table 131, the product basic table 132, and the CC product table 133. The position indicated by the triangle symbol indicates that the information corresponding to the triangle symbol is updated each time each process is completed. The-symbol indicates that the information after registration will be entered as is.

In this embodiment, the distributed management system 20 described above is used.
4 is extracted from the information sent from 0, the specific information is processed and edited, registered in the line number table 131, and updated thereafter. . The person in the sales department is this row number table 13
By inquiring the information of No. 1, it is possible to obtain information related to the progress status and delivery date of the product and explain it to the customer.

As shown in FIG. 4, in the line number table 131, at the time of receiving an order, from the sales and production management system 10, as shown in FIG.
The order information is registered, and the order information is not updated until the management by the entire system of the present invention is completed, from the order receipt to the shipment to the customer, that is, the factory shipment, the delivery of the service center or the delivery of the coil center. further,
In the row number table 131, the manufacturing progress information and the product addition and aggregation information are registered as the performance information corresponding to the order information, and are sequentially updated from the factory manufacturing process to the coil center delivery.
First, during the factory manufacturing process, each time the manufacturing progress information of FIG. 2 is changed, information is transferred from the factory production management system 20 to the sales production management system 10 and reflected in the row number table. After the receiving stage at the factory, the factory production management system 2
0, distribution base system 30, coil center system 40
Further, according to each progress, the product mass and the like are added and aggregated for each identical contract number and each line number from the receipt to the CC delivery shown in FIG. 5 to update the product addition and aggregation information for each process.

In the product basic table 132 of FIG. 3, the information sent from the sales management system 10, the factory production management system 20, the distribution base system 30, and the coil center system 40 in the distributed management system is used as the contract number and line number. ,
Store in association with the examination number.

The product basic table 132 manages the information for each product in the distributed management system. First, the factory production management system 20 sends the product receipt information of FIG. 2 and registers it in this table. It Unit of product is 1
Since it is one packing unit of a coil or a sheet, the inspection number corresponding to one unit of the product, the contract number and the line number which are higher-level search key items, and the basic product information do not change after this time. The product delivery information and the product location information will be updated according to the progress of the process thereafter, and the progress record date will be sequentially additionally registered. The information that is updated or additionally registered is generated between the receipt of the factory and the shipment from the factory, and is sent from the factory production management system 20 to the centralized management system 300 each time the information is generated. Is stored in a predetermined address. In exactly the same manner, warehousing to warehousing at the distribution base and warehousing to warehousing at the coil center are processed based on the information sent from the distribution base system 30 and the coil center system 40, respectively.

The CC product table 133 is the receipt / delivery information and the inventory information sent from the distribution base system 30 and the coil center system 40 in the distributed management system, the invoice number, the invoice number, the line number and the inventory number. Memorize in association with.

In the coil center, when a coil, which is one unit of a product, is processed, it is divided into two or more units of coils or packing units (called a product). A product inventory number is assigned as a search key item to one unit of product, and in this table, the product inventory number is included for each unit of product, as well as the higher-level search key items such as contract number, line number and inspection number, coil center. The information such as the progress date, product mass, and quality of each product is stored.

The error table 134 stores error contents when there is an error in the information sent from the distributed management system.

The database 1 is used to detect the presence or absence of an error.
It is performed before registering data in 30.

Basic information registration processing and search processing executed in such a system configuration will be described with reference to FIGS. Note that FIG. 5 shows the row number table 13
1. Product basic table 132 and CC product table 1
33 shows the correspondence of 33 with respect to the mass of the product.

FIG. 6 shows an example of a display screen for searching and inquiring according to the embodiment of the present invention. FIG. 7 shows another display screen for searching and inquiring according to the embodiment of the present invention. FIG. 8 shows a basic processing procedure executed by the host computer 110 shown in FIG.

1) Registration of Order Information When a new order occurs, the sales management system 10 sends the order information to the communication device 140 of the centralized management system 300. In response to the interrupt request from the communication device 140, the host computer 110 interrupts the current processing, temporarily stores the information received via the communication device 140 internally, and then registers it in the database 130 (steps S10 → S2).
0 → S30 → S40). Therefore, the communication device 140 operates as the input means of the invention of claim 1. The contract number, line number, and order specification information (see FIG. 4) are extracted from the received order information and registered in the line number table 131 of the database 130. For example, as shown in FIG. 5, the data of the ordered mass with respect to the line number is written in the item “order” in the column related to the mass in the line number table 131. At this point, the other items are blank.

2) Registration of production status In the production factory, the factory production management system 20 executes processing related to production, for example, processing such as process design and production instruction, and periodically, manufacturing progress information shown in FIG. , Product receipt information and product progress information are transmitted to the centralized management system 300. When the host computer 110 receives the progress information and the product related information via the communication device 140, the host computer 110 records them in the line number table 131 and the product basic file 132 (S10 to S40 in FIG. 8). Information is repeatedly sent from the factory production management system 20 while the product is produced (processed) in the factory. Therefore, the database 13
Information about the manufacturing process of the line number table 131 of 0 (see FIG.
Information (see FIG. 5) and mass information (see FIG. 5) are updated each time data is received.

When the product is completed and carried into the warehouse in the factory, information indicating that the product has reached the process is sent from the factory production management system 20. The computer 110 updates the manufacturing progress information (see FIG. 4) in the row number table 131 of the database 130, keeps the control limit division information defining the control range of the product within the range of the manufacturing factory, or updates it from the manufacturing factory to the warehouse side. Or Further, information relating to loading / unloading, storage, and inventory (see FIG. 4) is newly added to the row number table 13.
It is registered in one dedicated item.

Thereafter, if any information is changed during the storage of the product, the change information is sent from the factory production management system 20, so that the centralized management system 300 also corrects and registers the change information in the database 130 in real time.
After that, the product is transported to the delivery base, that is, the distribution base or the coil center, and the distribution base system 30 or the coil center system 40 moves from the distribution base system 30 to the coil center system 40 each time the storage position of the product changes.
Since information relating to loading / unloading, storage, and inventory as shown in FIG.
As for 1 as well, the entry / exit related information is updated or newly registered each time (step S40 in FIG. 8).

In this manner, since the information indicating the position and progress of the product is reflected in real time on the row number table 131 on the database 130, a person in the sales department can display the contents of the row number table 131 on the display screen. You can accurately respond to customer inquiries by looking at.

3) Retrieval and inquiry of data The host computer 110 is the above-mentioned distributed management system 2
The processing for registration and update of the information sent from 00 is executed in real time, but while the information is not sent from the distributed management system 200, a request for search or inquiry to the database 130 is accepted, and batch processing or real time processing is performed. Meet the demands of processing.

That is, the person who wants to perform a search or inquiry displays the search request screen of FIG. 6 or the inquiry screen of FIG. 7 on the display using the keyboard of the terminal device 120 or the sales management system 10. Next, after inputting the information required for the search and inquiry, the search and inquiry are requested. At this time, it goes without saying that the sales management system 10 functions as a terminal device via the communication device 140.

In the case of batch processing, when this request is sent to the host computer 110 of the centralized management system 300, the host computer 110 executes the step S5 of FIG.
The request is detected at 0, the search and inquiry requests are registered in the internal memory, and the processing is reserved (step S6 in FIG. 8).
0).

When there is no request for information registration in the database 130 or batch processing, the processing procedure of the host computer 110 shown in FIG. 8 proceeds from step S10 to step S70, where data retrieval and inquiry are performed in the order of reservation. The data search is a keyword search, and a series of data having the designated keyword is read from the database 130,
It is sent to the requester for processing. In the case of the inquiry process, for example, in the case of inquiring about the stock of a product, the stock-related information about the instructed product is read from the line number table 131 and the product basic table 132, and is displayed in total.

Needless to say, when the communication device 140 receives the registration information in the database 130 during the execution of such batch processing, the batch processing is interrupted and the registration processing in the database is executed in real time. Yes.

(Second Embodiment) The host computer 110 of the sales plan support system 400 in the first embodiment shown in FIG. 1 described above is provided with a sales plan creation function, and a plurality of information processing systems 50 are provided to the customer side. FIG. 9 shows the second embodiment in which the table is installed
Shown in. 9, the same parts as those in the embodiment of FIG. 1 are designated by the same reference numerals, and the distributed management system on the manufacturing company side is not shown.

Since the function of the sales plan support system 400 is almost the same as that of the first embodiment, the duplicated description will be omitted and only the difference from the first embodiment will be explained.

The first major difference is that the information processing system 50 installed on the customer side is the sales planning support system 40.
0 database 130 (see FIG. 12), the key items (consisting of a customer code, standards, and dimensions, hereinafter referred to as a sales plan key) for receipt and payment used for making a sales plan, and the basics associated with the key items. Only the information (the product inventory and contract remaining amount on the manufacturing company side of each decentralized management system, that is, the weight of the order mass excluding the shipping record from each shipping site) is provided, and the data that can be inquired for each customer is the above. It is limited to the scope of the sales plan key, that is, the customer's own data.

The second major difference is the information processing system 5.
Sales plan support system 40
In addition to 0 being registered in the database 130, the product sales plan is created using the order information, inquiry information, and payment information sent from the information processing system 50. Small differences will be explained in the system description of the second embodiment below.

Next, an outline of sales planning will be described (Fig. 1
1). The host computer 110 reads out, from the database 130 in the first embodiment, available-for-sale inventory information and contract-remaining information of products on the manufacturing company side used for receipt and payment of the sales plan, and edits the same for the sales and customers. It is possible to provide. The available inventory information and the remaining contract information are calculated by the host computer 110 at regular intervals from the order information and the warehousing information in the database 130, and the calculation result in the database 130, that is,
Available-for-sale inventory information and contract remaining information are registered. The host computer 110 at the time of executing the above processing operates as an arithmetic unit and a storage unit. Also.
When a keyword is received from the outside, the host computer 110 extracts this information from the database 130 and outputs it.

The receipt and payment of product inventory and inquiry information will be described with reference to FIG.
Information Transfer between Host and Host Computer 110
This will be explained in Section 4. As the information of the product inventory receipt and payment of FIG. 13, the inventory of the manufacturing company for each site of each decentralized management system, the inventory of the trading company grasped by the customer, and the receipt information of the product in consideration of the lead time of the product on a monthly basis. The predicted receipt amount is used as the information, and the payment amount is the planned receipt amount on the customer side. As a result of payment, the inquiry amount, which is the main item of the sales plan, is calculated (see FIG. 13). Next, FIG. 14 shows the points of the second embodiment.
From the information processing system 50 on the customer side, a customer code and a keyword with an instruction to create a sales plan trading company proposal are transmitted to make a search request.

The host computer 110 side extracts the product inventory and the remaining contract weight within the designated customer code range from the database 130 and sends the basic information together with the keyword. The trading company on the customer side receives the product shown in FIG. 14 on the information processing system 50 side, calculates the inquiry amount, and sends it to the host computer 110 on the manufacturing company side as a trading company proposal (see FIG. 14). At this time, the information processing apparatus in the information processing system 50, for example, the CPU operates as the inquiry information creating means of the invention of claim 6. In this case, the activation is performed from the customer side. However, the product computer and the contract remaining weight are prepared for each customer in advance from the host computer 110 on the manufacturing company side, and are periodically sent from the manufacturing company side. May be.

As described above, regarding the customer, the information is aggregated in units of items of the sales plan key and the basic information accompanying it is provided to the information processing system 50 such as a trading company (S20).
0). The information processing system 50 predicts the inquiry information, that is, the warehousing information as a result of the payment, and provides it to the sales plan support system 400 (S210). Based on this prediction information, the host computer 110 aggregates the entire company and finally determines the sales adjustment amount of the manufacturing company, that is, the predicted storage amount (S221). At this time, the host computer 110 operates as a means for determining the salable quantity of claim 6.

After the sales adjustment amount as the sales plan is determined, the trading company is distributed (S222). Next, as a result of the sales plan adjustment, we implement factory allocation for production at each factory,
The processing amount of the factory equipment replaced with the production plan is calculated to verify the capacity of each line (S2
30). Further, the customer such as a trading company links the order information as the formal ordering work in consideration of the concrete delivery date with the inputting work of the sales management system 10 after the adjustment in the series of sales planning works (S240).

When a sales plan is created by the host computer 110, the host computer 110 is shown in FIG.
The program for sales plan is started and a sales plan is created using the order information, inquiry information, and payment information. Based on the above sales plan, a production plan created in consideration of equipment conditions of various production equipments and a production order of a product in which the production plan is embodied are factory production management system 20 (FIG. 1).
2)).

As described above, since sales information such as inquiries, receipts and payments, orders, etc. can be automatically incorporated into the sales plan, the sales department can reduce the effort of preparing materials for making the sales plan. . FIG. 10 shows a processing procedure executed by the host computer 110 of the sales plan support system of FIG.

The system operation of FIG. 10 will be described below with reference to FIG. When the host computer 110 receives an access request from the information processing system 50 on the customer side, it starts the processing procedure of FIG. As a result, the host computer 110 accepts the user ID and password and the processing request transmitted from the information processing system 50. The user ID is a number which is predetermined for each customer and has been contacted with the customer. The password is a number for permitting access to the sales planning support system 400.

In this embodiment, an example in which an information processing system such as a workstation is used to manage information on the customer side is also shown, but if the terminal has a data input, display and communication function, the function of the present invention is used. Can be achieved (for example, a host computer system such as a trading company may be used). The host computer 110 determines whether the user ID and the password are authentic in advance, and excludes access requests from customers other than the customer here. User ID,
If it is determined that the access is not permitted by checking the password and the password, the received data up to this point is accumulated in the error file 133 (step S110 → S1 in FIG. 10).
20 → S121), error information is transmitted to the user ID transmission destination, and communication is cut off (step S122).

On the other hand, when the user ID and the password are valid, the response process according to the process request is executed. That is, for inquiries about the product inventory of the sales plan, a keyword for data search, for example, the sales plan key item is transmitted to the customer information processing system 50 (step S131 in FIG. 10). On the customer side, the information processing system 50 designates a keyword to be used for data retrieval, and the database 130 retrieval is instructed.

Upon receipt of this instruction, the host computer 110 of the sales planning support system 400 collates the keyword contained in the instruction with the customer code or the like managed by the host computer 110 side, and the collation result shows that there is no discrepancy. In this case, it is determined that the customer is illegally using the terminal device.

As a result, the host computer 110 records the received record so far in the error table 134 and sends an error message in response to the information processing system 50 on the customer side. The customer must perform the correct operation again (step S120 → S121 → S12 in FIG. 10).
2). On the other hand, when it is determined that the data search instruction operation is correct, the host computer 110 searches the database 130 with the given keyword, reads the data related to the keyword from the database 130,
It is transmitted to the information processing system 50 on the customer side (steps S133 → S134 → S135 in FIG. 10). Hereinafter, the customer changes the given keyword within the allowable range and retrieves various data, for example, the stock amount and contract remaining amount of the line number table used for inquiry from the database 130,
It is transmitted to the information processing system 50 on the customer side (loop processing of steps S133 to 136 in FIG. 10). In response to the end instruction from the information processing system 50 on the customer side, the host computer 110 ends the processing procedure of FIG.

From the information processing device 50 on the customer side, for example,
When order processing is instructed, the host computer 1
10 receives the order information from the information processing system 50 and stores it in the internal order information file (step S in FIG. 10).
140 → S141). When the inquiry processing is instructed, the contents of the inquiry are also stored in the dedicated file (inquiry / acceptance processing in step S151 of FIG. 10).

By executing the above processing by the host computer 110, the customer side can directly check the inventory and the remaining contract weight of the database 130 without going through the sales on the manufacturing company side. Also on the manufacturing company side, people in the sales department are freed from the task of responding to inquiries from customers,
You can concentrate on your original sales activities.

Further, since the area of the database 130 accessible by the person on the customer side is limited to the data having the same customer code, the confidentiality of the data of other customers and the data of the company can be protected.

In addition to this embodiment, the following example can be carried out.

1) In the present embodiment, the mesh for the receipt and payment of the sales plan is the standard and the dimensional unit, but the keys for the special sales plan are standardized and managed with a coarser mesh to carry out the receipt and payment of the sales plan. You may.

2) In this embodiment, the keywords used for searching the database 130 are used as they are for the database 130.
Although it is used to determine whether to permit access to the database, if the keyword used inside the host computer 130 is different from the keyword presented to the customer, the security of the database 130 is improved. In this case, a conversion table in which the keywords used inside the system and the keywords for customer presentation are written together is prepared inside the host computer, and when transmitting from the sales planning support system 400 to the outside or receiving the keyword from the outside. Keywords are converted using this conversion table. In the conversion table, for example, the contents of keywords on the customer side are changed on a monthly basis. Since the customer displays the keyword, the data search request can be executed without any problem even if the content of the keyword changes from the previous month. Also,
The manufacturing company can also keep the keyword for actually accessing the database 130 secret.

3) In this embodiment, an example in which the data on the database 130 is used for the sales plan and the production plan has been shown, but the same applies to the use of planning for delivery.

4) In the above-described embodiment, an example in which the information registration process to the database and the sales plan creation process are automatically started has been shown, but the terminal device 12 is used for the purpose of correcting the information.
The registration process and the sales plan creation process may be activated by an instruction from 0 and the host computer 110 may be caused to execute the process.

[0081]

As described above, according to the inventions of claims 1 and 2, not only the order information but also the manufacturing progress information and the warehousing / discharging information are retrieved from the database in the sales department, so that the product location, It is possible to grasp the production progress status. According to the invention of claim 2, by connecting the distributed processing system and the centralized processing system, the input of information to be stored in the database can be automated.

According to the third aspect of the present invention, in the sales management system, the information stored in the database can be input and the information in the database can be displayed, and the sales department can quickly obtain the information corresponding to the customer.

According to the fourth and fifth aspects of the invention, the customer side can also obtain the information to be referred to when ordering the product.

According to the invention of claim 6, it becomes possible to make a sales adjustment based on the inquiry information sent from the customer side.
It becomes possible to partially mechanize the work that relied on human labor.

[Brief description of drawings]

FIG. 1 is a block diagram showing a system configuration of the present invention.

FIG. 2 is an explanatory diagram showing a relationship between main information and keys according to the embodiment of this invention.

3 is an explanatory diagram showing an internal configuration of a database 130 of FIG.

FIG. 4 is a row number table 131 and a basic product table 132
FIG. 7 is an explanatory diagram showing information contents of the other (error) table 134 and registration update timing.

5 is an explanatory diagram showing an example of registration information in a database 130. FIG.

FIG. 6 is an explanatory diagram showing a display screen for searching and inquiring according to the embodiment of the present invention.

FIG. 7 is an explanatory diagram showing a display screen for searching and inquiring according to the embodiment of the present invention.

8 is a flowchart showing a processing procedure executed by the host computer 110 of FIG.

FIG. 9 is a block diagram showing a system configuration of a second embodiment of the present invention.

10 is a flowchart showing a processing procedure executed by the host computer 110 of FIG.

FIG. 11 is a flowchart showing a data update procedure of the database 130 regarding a sales plan.

FIG. 12 is a block diagram showing a system configuration of a second embodiment of the present invention.

FIG. 13 is an explanatory diagram of payment and receipt of a sales plan according to the second embodiment of the present invention.

FIG. 14 is an explanatory diagram showing a flow of information according to the second embodiment of the present invention.

[Explanation of symbols]

 10 Sales Management System 20 Factory Production Management System 30 Distribution Base System 40 Coil Center System 50 Information Processing System 110 Host Computer 120 Terminal Device 130 Database 140 Communication Device 200 Distributed Management System 300 Centralized Management System 400 Sales Planning Support System

Claims (6)

[Claims] 1. Input means for inputting order information indicating the contents of an ordered product, manufacturing progress information indicating a progress status of manufacturing the product, and warehousing information indicating a warehousing status of the product in a warehouse. Storage means for storing the input order information, manufacturing progress information, and warehousing information in the form of a database, and information processing means for accepting a keyword from the outside and extracting the information related to the keyword from the database. A sales planning support system, characterized in that a centralized management system having an output means for outputting the extracted information is installed on the manufacturing company side of the product. 2. A plurality of distributed systems comprising a sales management system for managing the order information at a sales base, a factory production management system for managing the manufacturing progress information at a manufacturing factory, and an inventory management system for managing the entry / exit information at a warehouse. 2. The sales plan according to claim 1, wherein a management system is connected to an input means of the centralized management system, and information stored in the database is transferred from the plurality of distributed management systems to the centralized management system. Support system. 3. The sales management system according to claim 2 functions as a terminal device which gives the keyword according to claim 1 and displays the information output from the output means according to claim 1. The sales plan support system according to claim 2. 4. The sales plan support system according to claim 1, wherein an information processing system that gives the keyword and displays the information output from the output unit is installed on the customer side. 5. Computation means for computing inventory information of products that can be sold and quantity of products of uncontracted products based on order information and inventory information stored in the database, and inventory information and contracts obtained by the computation. A means for storing the remaining quantity in the database, the inventory information and the contract stored in the database when the inventory information and the keyword relating to the contract remaining quantity are received from the information processing system according to claim 4. The sales plan support system according to claim 1, wherein the remaining quantity is transferred to the information processing system. 6. The centralized management system according to claim 1, wherein the information processing system has means for creating inquiry information indicating the inquiry contents of the product based on the transferred inventory information and the quantity of the remaining contract. Receiving the inquired information from a plurality of information processing systems on the customer side, and having means for determining the quantity of the product that can be sold to the customer side based on the received inquiry information, the inventory information, and the quantity of the contract balance. The sales plan support system according to claim 5, which is characterized in that.