JP2001312536A - Server device for production control, method for production control of commodities and storage medium with program for realizing a method of production control of commodities recorded thereon - Google Patents

Abstract

PROBLEM TO BE SOLVED: To shorten the delivery time to customer in a case of consigning the production of commodities to the outside. SOLUTION: Server device for production control 60 accepts information on the order of commodities, production and distribution of commodities from production control data base 88 and computer 62, 64, 66 that is linked to the Internet 54 and computer 82, 84 that is linked to the Intranet 52, and includes a data input part 80 that maintains the data base 88 and an access preparation part 80 that prepares web page for accessing to some data of data base 88 in WWW server 58 outside fire wall 56 in responding to data of given category input and a notification part 80 that notifies URL of web page prepared in information sharing server 58 to each unit by e-mail, in responding to data of given category input.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION The present invention relates to the present invention, in which not only the inside of a company but also the outside of the company is cooperated to start the production of products in a timely manner in accordance with the expected demand, and when a real demand arises, an appropriate amount of products is appropriately The present invention relates to a production management system for commodities so that it can be supplied to various stores. In particular, the present invention relates to, for example, overseas design consignment (ODM: Own Design Manuactur).
ing) In a system in which the production of products is commissioned first and the products are delivered directly to the final customer such as a mass retailer via a logistics company, the product is distributed to each of the ODM customer, the final customer, and the main company. The present invention relates to a production management system for commodities that can manage orders, production, shipping, delivery, and the like in a shorter cycle based on the movement, production schedule, demand forecast, and actual sales information.

[0002]

2. Description of the Related Art In the field of products such as personal computers, product development competition among companies is fierce, but technically there is not much difference between them, and sales differ mainly due to price and product supply. There is a phenomenon of coming. In particular, it is necessary to reduce the production cost of a product such as a personal computer in which cost competition is intense. For this purpose, we commission the production of products to ODM destinations in areas where high quality labor can be obtained at a low labor cost or where quality parts can be obtained at a low price. A production management system according to a method of delivering to a final consumption place by using a transportation means such as an aircraft is used.

In such a production management system, an ODM source company needs to notify a contractor company of monthly or weekly production plans and orders. Conventionally, electronic mail via the Internet or facsimile via an international telephone line has been mainly used.

[0004] In addition, the sales department of an ODM-originating company often exchanges information with domestic customers to place orders, and the means used for that purpose are mainly e-mail and facsimile. Particularly in the case of hurry, it is common practice to negotiate with customers over the phone and place orders on the spot.

[0005] Based on such order information, sales information, and production information, the ODM source company issues a production instruction to the ODM destination and a report on the expected delivery to the customer. In such management, since the prediction can be made empirically based on a certain cycle, production management is also performed based on that cycle. In this cycle,
It was usually done on a monthly basis.

[0006] Under these circumstances, with the spread of the so-called Internet in recent years, there has been proposed a system for connecting the inside and outside of a company using the Internet. For example, in Japanese Patent Application Laid-Open No. H10-97966, a plurality of factories equipped with industrial equipment such as semiconductor manufacturing equipment and a host management system installed by vendors of these industrial equipment are connected via the Internet, and the vendor directly A system for maintaining each industrial device is disclosed.

[0007]

Problems to be Solved by the Invention
The system disclosed in Japanese Patent Publication No. 6 is a system for limited industrial equipment, and cannot be applied to general consumer goods. In particular, this system is not for a production management system, but for maintenance of equipment, and cannot be applied to a production management system for products related to an external ODM such as a personal computer. .

[0008] In particular, information devices such as personal computers are often handled in mass retailers. Moreover, it is handled in large quantities in a small part of the city. Also, when handled at a large-scale suburban store, the amount handled is large. Further, since information devices have a somewhat high price, products are often determined on Saturdays, Sundays, public holidays, and the like, rather than purchased casually on weekdays. Therefore, most of the sales are concentrated on these holidays, especially on weekends. In addition, as a general consumer tendency, the buying behavior is often influenced by the weekend weather. In addition, since the price is relatively high, the day on which sales are concentrated depends on special factors, such as a payday or a bonus payment date or a mass retailer's campaign date. In addition, there are disparities in sales among mass retailers, and the disparities also differ from week to week. For example, a store that had high sales one week may not have the same high sales next week.

[0009] Under such circumstances, it has become necessary to manage management tasks such as production management and business management which have been performed on a monthly basis in a shorter cycle. That is,
In order to increase sales, it is necessary to accurately deliver products that sell well to stores that sell well when selling well, and forecasts for this are too slow in monthly units.

[0010] As a result, the ODM source company has
It is necessary to make the coordination between the M destination and each customer more dense than before, exchange information with each other more quickly, and reflect such information more quickly in production and distribution.
In doing so, it has been recognized that the most efficient production and distribution of goods within the limited production capacity, and thereby achieving greater sales, is an important issue.

However, if information is exchanged by e-mail and facsimile as in the past, a time lag occurs, for example, in reflecting the order information in the production information. When communicating with overseas ODM destinations, prompt information transmission may not be possible due to time differences. Further, even if the information arrives at an early stage by e-mail or facsimile, for example, to the department of the salesperson, if the salesperson happens to go out, the information cannot be quickly transmitted. If the salesperson is on a business trip for a few days, the impact will be significant. As a result, timely production and delivery of goods cannot be performed.

[0012] Further, in the sales department of a company, it takes time to collect and arrange accurate information on the delivery schedule and the number of orders for each customer. Even if information can be collected and organized, OD
Often just before the start of production at the destination M. As a result, it is difficult to quickly transmit sufficient information to the ODM destination. As a result, at the ODM destination, there is a problem that it is difficult to set up an accurate production schedule not only on a weekly basis but also on a monthly basis.

Conversely, information on the factory shipping time and shipping amount of the product from the ODM destination, and the ETD (Esti
mated Time Departure) / ETA (Estimated Time of
Arrival) There is a problem that it is difficult for the sales department to make a final sales plan because the information does not immediately enter the business of the company. Similarly, since such information is not transmitted to each customer in a timely manner, each customer has a problem that it is difficult to make a final version of the actual sales plan on the weekend.

Conventionally, such exchange of information is not performed in a timely manner or the content of the information is not accurate in many cases. Therefore, it is not possible to make an appropriate production plan at the ODM destination, and as a result, the inventory becomes insufficient. Often it is not the right amount. For example, there may be cases where the amount produced in weekly units becomes excessive, resulting in inventory remaining. Conversely, when the order quantity from the business was changed immediately before and increased, there were cases where the ODM destination could not meet the order and as a result, the shipment volume from the ODM destination became smaller than expected. In such a case, the originally expected sales cannot be obtained.

Further, the conventional method has a problem that it is difficult to efficiently deliver a limited amount of goods. For example, the total number of orders from customers may naturally exceed the production capacity. Such situations will often occur, especially for products that sell well and products that are rapidly becoming popular.

In this case, as a business policy of the company, it is a common practice to distribute goods so as to maximize the total actual sales. For example, products are sold preferentially to stores that sell well, and products to stores that do not sell well are put off. For example, it is assumed that the same order of 100 units is received for the same product from Store A and Store B, and that the production capacity of the external ODM destination of the product is only 180 in the designated period. In this case, it is necessary to distribute 180 merchandise to the A store and the B store according to some policy.

In this case, for example, it is assumed that the sales performance of the product at the store A is better than that at the store B. Then, under the policy of trying to increase the total sales of this product at all stores, for example, store A will deliver 100 units of products as requested, and store B will distribute only 80 units. The number of goods delivered will be adjusted accordingly. Traditionally, these adjustments were made by the company's sales department based on individual negotiations by telephone, email, or facsimile,
It was very time consuming and the adjustments made were often incorrect, resulting in less than optimal delivery. In order to make such adjustments optimally, the management of the prerequisite orders, orders, sales forecasts, actual sales information, product quantities in each production process and distribution stage, etc., should be performed in real time as much as possible and It is premised that all the departments that do this can obtain the information they need in a timely manner.

The conventional system proposed to use the Internet does not presuppose such ODM and direct delivery of goods to customers, and cannot solve the above-mentioned various problems.

Therefore, an object of the present invention is to provide a production management server device, a production management method for a product, and a program therefor, which can shorten the delivery time to a customer when the production of the product is outsourced. Is to provide a computer-readable recording medium on which is recorded.

Another object of the present invention is to shorten the delivery time to a customer when the production of goods is outsourced,
A production management server device, a production management method for commodities, and a computer-readable recording medium on which a program for recording the program is recorded, in which each related department can easily confirm the status of the order during production. It is.

[0021]

According to a first aspect of the present invention, a production management server device is connected to an intranet in a company, is connected to the Internet via a firewall, and stores a product outsourced to a subcontractor outside the company. It is a production management server device used for managing production. Outside the firewall, there is provided an information providing server capable of providing information to the computer connected to the Internet in a format that can be accessed from the outside and that allows the information in the production management server device to be viewed from the outside. The production management server device is connected to an external computer and an intranet connected to a database means for holding data necessary for managing a desired part of product ordering, production and distribution. Data input means for receiving information on ordering, production and logistics of goods from a computer in a company, and maintaining data held in a database means; Access preparation means for preparing, in the information providing server, access means for accessing a data portion corresponding to a predetermined type of data in the database means, in response to the input to the information providing server, A predetermined type of data is input to the production management server device by means In response, the information for accessing the access means which is prepared in the information providing the server by the access preparing means, and a notifying means for notifying a predetermined destination according to a predetermined type of information.

When a predetermined type of data is input to the database means, the access preparation means prepares an access means for accessing a data portion corresponding to the input predetermined type of data in the information providing server. You. Information for accessing the access means is notified to a predetermined destination. As soon as the database means is updated, the destination associated with the data is notified. The person in charge at the destination can access new data immediately by accessing the access means according to the notification. This access means is outside the firewall and is easily accessible. Therefore, not only the ODM company that operates the production management server device but also related parties outside the company, such as customers, ODMs, etc.
First, a distributor can share information necessary for production management in real time. As a result, each department can obtain appropriate information at various stages such as ordering, production, distribution, etc., and can deliver an appropriate number of products to a final customer in a timely manner.

[0023] In the production management server device according to the second invention, the information providing server includes a WWW server. The access preparing means includes means for preparing a page prepared for browsing information related to the predetermined type of data in the WWW server in response to input of the predetermined type of data. Including. The notifying unit includes a unit for transmitting an e-mail including the URL of the prepared page to an e-mail address predetermined for a predetermined type.

Since the WWW server is used as the information providing server, each related person easily accesses a necessary page in the WWW server using a general browser, and obtains information necessary for production management through the page. be able to. For the parties outside the company, there is no need to introduce a dedicated system to obtain information, and the burden of performing production management can be reduced.

In the production management server device according to the third invention, the data input means responds to the electronic mail,
An electronic mail processing means for performing predetermined processing on each predetermined data portion of the database means according to the destination address of the electronic mail.

The processing corresponding to the data input is selected according to the destination address of the electronic mail. For the parties outside the company, there is no need to introduce a dedicated system for inputting data, and the burden of performing production management can be reduced.

In the production management server device according to the fourth invention, the e-mail processing means responds to the e-mail having the attached document according to the destination address of the e-mail. Attachment processing means for updating the portion using data included in the attachment according to a predetermined method.

Based on the contents of the document attached to the e-mail, a process selected according to the destination address of the e-mail is performed. The attached document may be created by a general spreadsheet program as long as it follows a predetermined format. Therefore, it is easy to prepare the attached document, and it is not necessary to introduce a dedicated system for that purpose. As a result, it is not necessary for stakeholders outside the company to introduce a dedicated system to input data, and it is possible to input a large amount of data without errors by easy operation, and to perform production management. The burden on the user can be reduced.

According to a fifth aspect of the present invention, there is provided a production management method for commodities, which is outsourced to a third party outside the enterprise using a production management server connected to an intranet in the enterprise and connected to the Internet via a firewall. This is a product production management method for managing the production of a product. Outside the firewall, there is provided an information providing server capable of providing information to the computer connected to the Internet in a format that can be accessed from the outside and that allows the information in the production management server device to be viewed from the outside. This method for managing the production of a product comprises the steps of: preparing a database means in the production management server device for holding data necessary for managing a desired part of ordering, production and distribution of the product; Receiving information on ordering, production and distribution of goods from an external computer connected to the computer and an in-company computer connected to the intranet, and maintaining the data held by the database means; and Preparing, in the information providing server, access means for accessing a data portion of the database means corresponding to the predetermined type of data in response to the type of data being input to the production management server device; Data of a predetermined type by the data input means. Notifying the information to access the access means prepared in the information providing server by the preparing step in response to the input to the predetermined destination according to the predetermined type of information. Including.

When a predetermined type of data is input to the database means, an access means for accessing a data portion corresponding to the input predetermined type of data is prepared in the information providing server. Information for accessing the access means is notified to a predetermined destination. As soon as the database means is updated, the destination associated with the data is notified. The person in charge at the destination can access new data immediately by accessing the access means according to the notification. This access means is outside the firewall and is easily accessible. Therefore, not only the ODM source company operating the production management server device but also related parties outside the company, for example, customers, ODM destinations, and logistics companies can share information necessary for production management in real time. .
As a result, each department can obtain appropriate information at various stages such as ordering, production, logistics, etc.
It is possible to deliver an appropriate number of products.

[0031] In the product production management method according to the sixth invention, the information providing server includes a WWW server. The preparing step includes preparing, in response to the input of the predetermined type of data, a page prepared for browsing information related to the predetermined type of data in the WWW server. The step of notifying is
The method includes a step of transmitting an e-mail including a URL of the prepared page to an e-mail address predetermined for a predetermined type.

Since the WWW server is used as the information providing server, each related person easily accesses a necessary page in the WWW server using a general browser, and obtains information necessary for production management via the page. be able to. For the parties outside the company, there is no need to introduce a dedicated system to obtain information, and the burden of performing production management can be reduced.

In the method for managing production of commodities according to the seventh invention, the step of maintaining is performed in response to the e-mail in response to the destination address of the e-mail for each predetermined data portion of the database means. The method includes a step of performing a predetermined process.

The processing corresponding to the data input is selected according to the destination address of the electronic mail. For the parties outside the company, there is no need to introduce a dedicated system for inputting data, and the burden of performing production management can be reduced.

In the method for managing production of commodities according to the eighth invention, the step of performing the predetermined processing is performed in response to the e-mail having the attached document in accordance with the destination address of the e-mail. Updating a predetermined data portion using data included in the attached document according to a predetermined method.

Based on the contents of the document attached to the e-mail, a process selected according to the destination address of the e-mail is performed. The attached document may be created by a general spreadsheet program as long as it follows a predetermined format. Therefore, it is easy to prepare the attached document, and it is not necessary to introduce a dedicated system for that purpose. As a result, it is not necessary for stakeholders outside the company to introduce a dedicated system to input data, and it is possible to input a large amount of data without errors by easy operation, and to perform production management. The burden on the user can be reduced.

The computer-readable recording medium according to the ninth aspect is entrusted to an outsourcing company outside the company using a production management server device connected to an intranet within the company and connected to the Internet via a firewall. A computer-readable storage medium that stores a program for implementing a product production management method for managing the production of a given product. Outside the firewall, there is provided an information providing server capable of providing information to the computer connected to the Internet in a format that can be accessed from the outside and that allows the information in the production management server device to be viewed from the outside. The production management method of a product realized by this program prepares a database means in the production management server device for holding data necessary for managing a desired part of product ordering, production and distribution. Receiving information on ordering, producing, and distributing goods from an external computer connected to the Internet and a computer in a company connected to the intranet, and maintaining the data held by the database means; In response to the predetermined type of data being input to the computer-readable recording medium by the input unit, the access unit for accessing the data portion of the database unit corresponding to the predetermined type of data is provided as information. The step of preparing in the providing server and the data input means In response to the predetermined type of data being input to the production management server device, information for accessing the access means prepared in the information providing server by the preparing step is prepared in advance according to the predetermined type of information. Notifying a predetermined destination.

When a predetermined type of data is input to the database means, an access means for accessing a data portion corresponding to the input predetermined type of data is prepared in the information providing server. Information for accessing the access means is notified to a predetermined destination. As soon as the database means is updated, the destination associated with the data is notified. The person in charge at the destination can access new data immediately by accessing the access means according to the notification. This access means is outside the firewall and is easily accessible. Therefore, not only the ODM source company operating the production management server device but also related parties outside the company, for example, customers, ODM destinations, and logistics companies can share information necessary for production management in real time. .
As a result, each department can obtain appropriate information at various stages such as ordering, production, logistics, etc.
It is possible to deliver an appropriate number of products.

[0039] In the computer-readable recording medium according to the tenth aspect, the information providing server includes a WWW server, and the step of preparing is performed in response to input of a predetermined type of data. Preparing a page prepared for viewing information related to the predetermined type of data. The step of notifying includes a step of transmitting an e-mail including a URL of the prepared page to an e-mail address predetermined for a predetermined type.

Since the WWW server is used as the information providing server, each related person easily accesses a necessary page in the WWW server using a general browser, and obtains information necessary for production management via the page. be able to. For the parties outside the company, there is no need to introduce a dedicated system to obtain information, and the burden of performing production management can be reduced.

In the computer readable recording medium according to the eleventh aspect, the step of maintaining is performed in response to the e-mail, in accordance with the destination address of the e-mail, for each predetermined data portion of the database means. Respectively performing a predetermined process.

The processing corresponding to the data input is selected according to the destination address of the electronic mail. For the parties outside the company, there is no need to introduce a dedicated system for inputting data, and the burden of performing production management can be reduced.

In the computer-readable recording medium according to the twelfth aspect, the step of performing the predetermined process is performed in response to an electronic mail having an attached document.
Updating each predetermined data portion of the database means according to the destination address of the e-mail according to a predetermined method using data included in the attached document.

Based on the contents of the document attached to the e-mail, a process selected according to the destination address of the e-mail is performed. The attached document may be created by a general spreadsheet program as long as it follows a predetermined format. Therefore, it is easy to prepare the attached document, and it is not necessary to introduce a dedicated system for that purpose. As a result, it is not necessary for stakeholders outside the company to introduce a dedicated system to input data, and it is possible to input a large amount of data without errors by easy operation, and to perform production management. The burden on the user can be reduced.

[0045]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Referring to FIG. 1, a product production management system 50 according to the present invention includes an ODM destination 62, a
6 is connected to the ODM source company 60, and the goods are directly transferred overseas without the intervention of the ODM source company 60 by the logistics 68 from the overseas ODM destination 62 to the logistics company 64 and the logistics 70 from the logistics company 64 to the customer 66. Is a system designed to timely deliver from the ODM destination 62 to the customer destination 66. It is assumed that the ODM source company 60 has an intranet 52 connected to the Internet 54 via a firewall 56.

This product production management system 50 is provided connected to the intranet 52, and provides predicted order information of a product over a predetermined period, reservation information corresponding to a tentative order for a more accurate order in a shorter period. , ODM
Store entrance schedule information input from the front, actual sales information input from the customer, firmed order information that collects and inputs orders from the customer in the sales department, and manages the production results of the ODM destination for each stage of production Production performance information, ETD information input by overseas logistics companies indicating shipping by air mail, warehouse information on product acceptance by domestic logistics companies and storage at ODM sources, product production for each product, and for each order , A database 88 for storing status information indicating the status related to physical distribution, the Internet 54, the firewall 56
And overseas ODM destinations 6 via the intranet 52
2. Receiving information by e-mail from the distributor 64 and the customer 66, and further receiving the OD via the intranet 52
An EDP for maintaining the contents of the database 88 by receiving information by e-mail from a sales company 86 associated with the ODM original company 60 connected to the production management system 82, the sales department system 84, and the intranet 52 of the M original company 60. (Electronic Data Processing) System 8
0 and the contents of the database 88 are changed, the ODM destination 62, the logistics agency 64 and the customer 66
EDP system 8 that should be presented to external parties outside the DM
0, which stores information extracted from the information stored in the storage device and transmits the information to the other party in response to a browsing request transmitted via the Internet. And a shared information server 58 prepared for sharing by related parties.

The shared information server 58 is provided outside the firewall 56. Therefore overseas ODM
Information to be shared can be easily browsed from outside the ODM source company 60, such as the destination 62, the distributor 64, and the customer 66, using a general browser program. On the other hand, each department (production management department, sales department, etc.) inside the ODM source company can access a database via its own intranet and browse necessary information.

The shared information server 58 displays appropriate information in an appropriate format in response to a request from a browser program executed on a computer owned by the viewer, or receives input of predetermined information. For displaying an appropriate form for the application. Since the functions themselves are well known, detailed description thereof will not be repeated here. In the following description, all information provided from the ODM source company to outside the company basically passes through the shared information server 58, unless otherwise specified.

Referring to FIG. 2, the EDP system 80 and the database 88 include the production management department system 82, the sales department system 84, the sales company 86, and the customer 6 of the ODM source company.
6. Overseas ODM destination 62, Overseas logistics company system 10
0, and an order / shipment sharing information system 110 for maintaining the order / shipment / shipment sharing information of the product based on information received from the domestic distribution company system 102, and an overseas ODM destination 62 from the ordering / shipment sharing information system 110. To extract the information (order information, etc.) necessary for the production instruction to the ODM destination 62 overseas by converting it into a standard format (EDI) common to the industry and ordering via an unillustrated ordering path. And a domestic logistics / order receiving system 114 for managing the logistics and order receiving of goods in Japan based on the warehouse information provided from the domestic logistics agent system 102.

Referring to FIG. 3, database 88 stores prediction / order information for holding long-term order prediction information (F / C information) and medium-term more accurate reservation order information (P / O information). A reservation information DB 150, a warehouse entry schedule / actual sale information DB 152 for holding warehouse entry schedule information from the ODM destination and actual sales information from the customer, and a one-week unit determination issued from the sales department to the ODM destination. It includes a firm order information DB 154 for holding order information, and a status-related DB 156 for maintaining an order state for each product model and each order number.

The EDP system 80 uses the prediction / reservation information D
For updating the prediction / reservation information receiving subsystem 120 for updating B150, the actual sales information input subsystem 126 for inputting the contents of the warehouse entry schedule / actual sales information DB 152, and for updating the contents of the firm order information DB 154. Confirmed order reception subsystem 130 and status-related DB 156
, An ETD information input subsystem 138 for inputting ETD information to the status-related DB 156, and a warehouse input information sub-system for inputting to the status-related DB 156. System 140 and status-related DB 15
And a warehouse receiving / shipping result reflecting subsystem 144 for reflecting the warehouse receiving / shipping result with respect to 6.

The EDP system 80 uses the prediction / reservation information D
Among the contents of B150, information to be presented to a specific partner is extracted, a web page storing the information is prepared in shared information server 58, and a URL (Uniform Resource) of the web page is further provided to the specific partner. Locator) is calculated based on the contents of the prediction / reservation information inquiry subsystem 122 for transmitting the e-mail and the warehouse entry schedule / actual sales information DB 152, and the shared information server 58
Prepares a web page storing the information, and sends the URL of the web page to the sales department by e-mail.
Based on the contents of the firm order information DB 154, firm order information confirmation information is transmitted to the production and purchase management system 112, and a web page storing the information is prepared in the shared information server 58. A firm order confirmation subsystem 132 for sending the URL of the web page by e-mail,
When B156 is updated, its status related DB15
Of the status information of each product based on the content of the product management unit 6 (the production management unit 82, the sales unit 84, and the sales company 8).
Status information for extracting information to be presented in 6), preparing a web page in which the information is stored in the shared information server 58, and transmitting the URL of the web page to the specific party by e-mail; And a query subsystem 142.

Referring to FIG. 4, overseas ODM destination 62 connected to the present system obtains prediction / reservation order information 16 from EDI information 160 received from production / purchase management system 112.
2 and a production management system 170 for extracting firmed order information 164 and performing production management of production in the company, and a spreadsheet program for creating a production performance table 176 based on the production performance by the production management system 170. Result input subsystem 172 consisting of
6 is an electronic mail 178 attached as an attached production performance input table 166, and the production performance report system 174 and the production performance report system 174 for transmitting the production performance report to the order receiving / shipping shared information system 110 as an electronic performance report. And an address book 168 that is referred to when determining the destination of the mail.

Referring to FIG. 5, the distributor 64 includes the overseas distributor system 100 and the domestic distributor system 102 as described above. Each terminal of these distributors 64 is provided at a distribution base for transporting goods, and is connected to the Internet.

The system 100 of the overseas distributor is ETD
An ETD information input system 180 for inputting information and transmitting it as an e-mail 182 to the order receiving / shipping shared information system 110 is included.

The domestic distributor system 102 is a warehouse for creating an e-mail 194 for transmitting warehouse information to the address book 192 and the ordering / shipment sharing information system 110 with reference to the address book 192. Based on the input of the warehouse information input subsystem 190 and warehouse input information subsystem 190, the warehouse information is created and the domestic logistics
And a warehouse entry result subsystem 196 for transmission to the order receiving system 114.

Referring to FIG. 6, production management system 82
Is a browser for receiving the e-mail 212 from the prediction / pre-order information input subsystem 200 and the status information inquiry subsystem 142 and displaying the product status information by accessing the URL included in the e-mail 212 Status information inquiry processing unit 2 consisting of
10 is included.

Referring to FIG. 7, the sales department system 84 includes:
Receiving the e-mail 222 from the shippable quantity calculation subsystem 124, and confirming the shippable quantity consisting of a browser program for displaying a web page for confirming the shippable quantity by accessing the URL included in the email 222. Receiving the e-mail 226 from the subsystem 220 and the confirmed order confirmation sub-system 132, and accessing the URL included in the e-mail 226 to perform display processing for order confirmation.
E-mail 2 from order confirmation subsystem 224 composed of a browser and status information inquiry subsystem 142
And a status information inquiry subsystem 228 comprising a browser for displaying the status information of the product by accessing the URL included in the e-mail 230 in response to the request.

Referring to FIG. 8, in the system of customer 66 (including a plurality of customers such as customer 66A, customer 66B, and customer 66C), portions related to the present system are respectively shown. Receiving the e-mail 242 from the shippable quantity confirmation sub-system 220 and accessing the URL included in the e-mail 242 to present the number-of-delivery-information to the person in charge of the customer by providing the number-of-delivery-submission sub-server. A system 240, an actual sales information input subsystem 246 composed of a spreadsheet program for inputting actual sales information at the customer's store to create an actual sales information spreadsheet program document 248, and an EDP system Address book 25 storing e-mail addresses for transmission to appropriate mailboxes in each of the mail boxes 80
4, an actual sales information report subsystem 244 for transmitting the actual sales information spreadsheet document 248 as an attachment 252 of the electronic mail 250 to the EDP system 80;
An order input subsystem 258 composed of a spreadsheet program for inputting an order of each product in the store and creating an order input spreadsheet program 260, and an order input spreadsheet program 260 are stored in the EDP system 80.
Information transmission subsystem 256 for performing processing to transmit as an attached document 268 of an e-mail 262 to
E-mail 2 from the confirmed order confirmation subsystem 132
66, and an order reception confirmation subsystem 264 for presenting the order reception information to the customer by accessing the URL included in the e-mail 266.

Referring to FIGS. 9 and 10, a method of exchanging information by electronic mail in this system will be described. Referring to FIG. 9, consider a case where, for example, production record table 176 is transmitted to EDP system 80. In this case, in the transmission side system 280 (ODM destination 62), the production result table 176 is created in advance by a spreadsheet program.
Then, a process of attaching the production record table 176 to the electronic mail as the attached document 296 is performed by the mail program 290. At this time, the production result reception address registered in the address book 168 in advance as the destination address of the e-mail is set as the e-mail address 292. Although any information may be entered in the subject field 294 of the e-mail, in this embodiment, "PCTDS" which is an abbreviation of this system is automatically inserted.

The production result table 176 is attached as an attached production result input table 166 to the e-mail 178 created by the transmission system 280 in this way, and transmitted to the EDP system 80.

Referring to FIG. 10, receiving system 320
(EDP system 80) includes an ODM destination 62 and each customer 66
The e-mail 178 and the e-mail 262 transmitted from the server are distributed to appropriate mailboxes such as the production result mailbox 330 or the order information mailbox 332 according to the respective e-mail addresses. The attached production result input table 1 is attached to the e-mail 178 arriving at the production result mailbox 330.
66 is attached and the production result input subsystem 334 executes the production result DB 338 according to the contents.
(Part of the status-related DB 156) is updated, and an acknowledgment mail 314 is sent to the source of the e-mail 178.
Send With respect to the e-mail 262 arriving at the order information mailbox 332, the firm order reception subsystem 336 (the firm order reception subsystem 130 and the firm order confirmation subsystem 132) performs the firm order according to the contents of the attached document 268 attached thereto. Information DB 154
Is updated, and an acknowledgment mail 314 is transmitted to the transmission source of the e-mail 262.

The exchange of information and the update of the database are carried out for the other information by roughly the same operation. As described above, in the system according to the present embodiment, electronic mail is used, and different processing is automatically performed depending on the address. Therefore, there is no delay in processing due to the absence of the person in charge of receiving the e-mail as in the related art. The contents of the database are always kept up to date.

Referring to FIG. 11, the contents of the documents attached to each mail and the contents of the database related to them will be described. The production result DB 338 (part of the status-related DB 156) includes a product model number, an order (P / O) number, a date, and an ODM destination code (OD).
M) as a set of records, and for each record, SMT (work of mounting each component on a board),
Stores the completed quantity of each stage of assembly, completion, inspection, and factory shipment. This database is attached production results input table 16
6 updated. “Year / Month / Day” indicates the date on which the record was created. Therefore, the production performance DB 338
Stores information for each day.

An ETD (Estimated Time Departure) information database 340 (part of the status-related DB 156) includes a model number of a product, an order number, a delivery request (D / R) field, the number of products to be shipped, and It is a collection of records including flight information on the flight of the aircraft to be dispatched and an invoice number. Delivery request is determined by order number 4
This is a field for separately storing the number of orders for four weeks obtained by dividing the orders for weeks for each week. This database is ET
It is updated by the e-mail 182 to which the D information is attached.

The warehouse information database 342 (part of the status-related DB 156) stores a product model number, an order number, a delivery request field, a number of received items,
It is an aggregate of records composed of the number of inputs and the number of warehouses.
This database is updated by the e-mail 204 attached with the deposit application information.

The status information DB 344 (part of the status related DB 156) includes a production result DB 338, an ETD
It is generated from the information in the information DB 340 and the warehouse information DB 342. The model number, the order number, the delivery request, and the ODM destination information are used as keys, and the quantities of the SMT, assembly, completion, inspection, and factory shipment are determined. , ETD,
It is an aggregate of records including the number of receipts, the number of inputs, and the number of stores.

Referring to FIG. 12, actual sales information DB 350
(Part of the warehouse entry schedule / actual sales information DB 152) includes a model number, information indicating a week serving as a reference, store information (store code), a store number field belonging to the store, It is an aggregate of records including the actual sales volume and the inventory volume of the week at the store. Here, “week” refers to the number of weeks counted in the full year.

Similarly, the warehouse entrance schedule DB 352 (a part of the warehouse entrance schedule / actual sales information DB 152) is an aggregate of records including a model number, a week, the date of warehouse entrance, and the number of warehouse entrances. is there.

The P / O information DB 360 (part of the prediction / reservation information DB 150) stores a model number, a week, and information for specifying the week for which the reservation order is to be made based on the week. This is a collection of records including a “week” field and the number of reserved orders for the week specified in the corresponding week field.

F / C information DB 362 (prediction / reservation information D
B150) is an aggregate of records including a model number, a week, a corresponding week field, and a predicted number of vehicles for the week specified by the corresponding week field.

The firm order information DB 154 is an aggregate of records including a model number, a week, the number of deliveries in the week, the number of preorders, and the number of firm orders. The contents of the confirmed order information DB 154 include an actual sales information DB 350, a warehouse entry schedule DB 352, a P / O information DB 360, and F / C information D.
It is obtained by counting B362.

As described above, in the system according to the present embodiment, information necessary for updating the database is transmitted to the EDP system 80 by electronic mail, and the corresponding database is updated by the address of the electronic mail. The control structure of software that actually performs such an update in this system will be described below.

FIG. 13 is a flowchart showing a schematic control structure of software for that purpose. Referring to FIG. 13, this process starts when an email is received (step 400; hereinafter, "step" is omitted).
It is determined whether a spreadsheet is attached to the e-mail (402). If there is no attached document, or if it is attached but it is not a spreadsheet, it is determined that an error has occurred and the contents of the error are notified (416), and the processing for this e-mail is terminated.

If there is an attached document and it is a predetermined spreadsheet, it is determined whether the e-mail address is correct (404). If the e-mail address is not correct, the contents of the error are notified to the transmission source of the e-mail by e-mail (416), and the processing for the e-mail is terminated. If the e-mail address is correct, the following processing is performed according to the e-mail address.

First, it is determined whether or not the e-mail address is an address assigned to processing 1 (for example, processing for updating the production result DB) (406A). If the e-mail address is for process 1, control goes to step 408A, otherwise control goes to step 406B.
Then, go to each.

At step 408A, it is determined whether or not the spreadsheet attached to the electronic mail conforms to the format for processing 1. If they do not match, an error content is notified (416), and the process is terminated.
If they match, processing 1 (for example, updating the production result DB) is performed based on the attached document. This processing itself is performed by a normal database program, and the content is not particularly new. Step 4
If an error occurs in the processing of 10A (for example, if the model number is invalid) (Step 4)
12A) The contents of the error are notified to the sender of the e-mail by e-mail (416), and the process ends. If the processing 1 is normally completed, the update result is notified to the transmission source of the electronic mail by an electronic mail (414), and the processing for the electronic mail is ended.

When the control advances from step 406A to step 406B, the electronic mail address is changed to processing 2 (for example, processing of order information) similarly to step 406A.
It is determined whether or not the address matches the address.
If they do not match, control proceeds to the next step (not shown, for example, step 406C), and if they do match, control proceeds to step 408B. Hereinafter, step 408
B, 410B, and 412B in step 40, respectively.
8A, 410A, and 412A (however, processing 2
Is performed, and an update result is notified in step 414.

Similarly, after step 406C, the same processing as described above is performed for each mail address up to the number of prepared processing (for example, step 406N).

In this way, by storing the address corresponding to each process in the e-mail address and attaching the spreadsheet corresponding to the process assigned to the address to the e-mail, an appropriate database can be stored in the attached document. Is updated according to the content of

Referring to FIG. 14 and FIGS. 15 to 17,
How the production management using this system is operated will be described. The feature of this production management method is that the production management department first holds a monthly production and sales meeting,
From that point, make a rough production forecast for 13 weeks to start material preparation, etc., make a reservation order in 4 week units, and decide the quantity to be actually delivered in 1 week unit and place a firm order That, by placing a firm order on the ODM destination on one Wednesday of the week, the product will be delivered directly from the ODM destination via a logistics agent to a domestic distributor on the same Friday, and The point is that the product can be delivered in units.

As shown in FIG. 14, first, at the monthly production and sales meeting in the production management department / sales department of the ODM company, the production / production in the range from that week to 13 weeks later (about 3 months). A production plan is created based on the forecast of the number of units sold (Fig. 1
5 S1). In the figures after FIG. 14, "W-1
Notation such as "3", generally "W-n" (where n is a number) is "W-0" (or simply "W") 13 weeks after the monthly commercial sales meeting. , The number of weeks that have passed since then is indicated by “n”. Therefore, "W-13" indicates the week in which this monthly live sales conference was held. The production plan held at this monthly sales conference for W-13 is described as "13 Week Forecast (F /
C) ". The 13-week forecast is input to the EDP system 80 by the production management system 82 (S2 in FIG. 15). FIG. 19 shows an example of the input screen at this time. This screen is realized by displaying a form on a browser accessing the shared information server 58. This same screen is also used for inputting four-week pre-order information described later. In FIG. 19, “N month” indicates the month to which the week 13 weeks after the forecasting belongs, and “N−n month” (n is 1 to 3) indicates that One month ago, two months ago, and three months ago. In FIG. 19, the column with the heading “Week” indicates the number of each week calculated for the full year as described above. Wk-n indicates the week n weeks before the week (Wk) 13 weeks after the time of prediction.

Therefore, in the table of FIG. 19, Wk-13
At the time of the week, the prediction of the week from Wk-12 to Wk is performed and input.

In this 13-week forecast, an overseas ODM destination can be confirmed in real time through the above-described system via the Internet (the EDI information 160 and the predicted / reserved order information 162 in FIG. 4 and the S / S information in FIG. 15).
3). The ODM destination creates a list of parts necessary for production based on the prediction information (S4 in FIG. 15), and prepares for material ordering.

4 weeks before the target week (W-4)
Then, at the monthly production / sales meeting held by the in-house production management department / sales department, a production plan with higher accuracy for the next four weeks is drafted (S5 in FIG. 15). A reservation order for four weeks (about one month) is created based on this production plan. This is called 4-week pre-order information. The four-week pre-order information is the quantity of the total reservation for production to the ODM destination for the next four weeks. At this stage, the numbers for each week have not been determined.

The production management section inputs a pre-order to the EDP system 80 based on the 4-week pre-order information (FIG. 15).
S6). The production / purchase management system 112 generates a 4-week pre-order (4-week P / O) based on the pre-order based on the ODM.
It is issued first (S7 in FIG. 15). This pre-order is made via the above-mentioned system via the Internet,
The information is transmitted first (the EDI information 160 and the predicted / pre-order information 162 in FIG. 4). The ODM destination places an order for materials based on the reservation order (S8 in FIG. 15), and further creates a production schedule for the next four weeks. The ODM destination inputs this production schedule to the EDP system 80 (S9 and S9 in FIG. 15).
10). By this input, information on the production schedule is registered in the production result DB 338, and a web page for browsing the information is registered in the shared information server 58. Then, the URL of the web page is notified to each management section (production management section 82, sales section 84, and sales company 86) by e-mail. The production schedule input from the ODM destination is output at an appropriate timing (FIG. 15).
S11).

At three weeks before the target week (W-3), the sales department sales department (the department that has direct business with the customer) and the customer are based on the four-week pre-order information and the production schedule. Between,
Business negotiations are performed via the Internet described above. Based on the result, the sales department (the department that supervises sales company sales) creates a monthly warehouse schedule (total quantity / delivery schedule) together with the production management department (S12 in FIG. 15). This information is used by the production management department to predict / preorder information input subsystem 200
Is input to the EDP system 80 by using (S1 in FIG. 15).
3). With this input, information on the warehouse entrance schedule is registered in the warehouse entrance schedule DB 352, and the shared information server 5
A web page for browsing the information is registered in 8. And the URL of the web page is e-mail 2
22 is notified to the sales department 84 (S1 in FIG. 15).
4).

The sales department 84 uses the shippable quantity confirmation subsystem 220 to create monthly storeable number information for each customer based on the monthly storehouse schedule information and input it to the storehouse schedule DB 352 ( S15 and S16 in FIG. 15). With this input, a web page for browsing the information is registered in the shared information server 58, and the URL of the web page is notified to the sales company 86 by e-mail.

The sales company 86 can browse the web page and find out the number of monthly stores that can be put into each customer. The screen displayed at this time is shown in FIG. Further, the URL of the web page for browsing the information is also notified to each customer by e-mail 242, and each customer can know the number of units that can be stored in the monthly storage by the delivery number presentation subsystem 240 (FIG. 16). S31). FIG. 21 shows an example of the screen at this time. As a matter of course, at this time, security management is performed by the shared information server 58 so that information on other dealers is not displayed.

Every Monday, each customer totals the actual sales data for the week before that (Monday to Friday) and the weekend (Saturday to Sunday) when the personal computer sells best. The tabulated data is provided from each customer to the EDP system 80 via the above-described system (S32 in FIG. 16), and the database is updated according to the information (S33 in FIG. 16). This is the actual sales information. FIG. 22 shows an example of a screen for inputting actual sales information. Since the information here is managed on a monthly basis, past information for that month is also displayed on this screen. Therefore, security management is performed by the shared information server 58 so that information of other stores is not displayed here. EDP system 8
0 calculates the weekly sales forecast number based on the actual sales information and the warehouse entry schedule information (S34 in FIG. 16), and further calculates the weekly warehouseable quantity (S35 in FIG. 16). The sales department sees the number of weekly warehousing units and informs each customer of the number of weekly warehousing units through the sales department of the sales company (S36 in FIG. 16). The sales company sales department adjusts the expected weekly order volume for each customer. The sales department sums them up.

The sales department inputs the expected weekly order information to the EDP system 80 (S37 and S39 in FIG. 16). Overseas ODM destinations can know the expected weekly order information in real time through the system described above (S40 in FIG. 16). At the ODM destination, make-to-stock / make-to-stock (BTR: Build To Replenishment) based on this weekly order forecast
Is started (S41 in FIG. 16). That is, the ODM destination is
Make-to-order production (BTO) that starts production after receiving an order for a product
Unlike formal orders, the company predicts formal orders and starts production. If production management is to be performed on a weekly basis, such expected production is necessary because the period from formal order receipt to delivery is limited.

Every Tuesday, each customer inputs the weekly order quantity to the EDP system 80 toward the weekend of this week (S42 and S43 in FIG. 16). This information is weekly confirmed order information. FIG. 23 shows an example of a screen displayed at this time.
Shown in Here also, security management is performed by the EDP system 80 so that information on other dealers is not displayed. The sales department and the sales department sales department confirm these order quantities via the order confirmation subsystem 224 (S44 and S45 in FIG. 16). FIG. 24 shows an example of a screen displayed for confirming a confirmed order.

On Wednesday, the order quantity received so far is put together as a firm order and input to the EDP system 80 (S46 and S47 in FIG. 16). Based on this information, a formal weekly firm order (P / O) including the quantity of products to be delivered on the weekend of the week is issued to the ODM destination by the production and purchase management system 112 (see FIG. 17). S
51). This confirmed order information is transmitted as EDI information 160 to the ODM destination via the Internet. The ODM destination officially starts build-to-order production (BTO) based on the confirmed order information (S52 in FIG. 17).

Thereafter, the ODM destination operates according to the order, and the completed personal computer is shipped from the factory on the night of the following day (Thursday). Factory shipment information including information on each stage such as assembly, completion, and inspection is input as production performance information from the ODM destination to the production performance input subsystem 134 by the above-described system (S53 in FIG. 17), and the status-related DB 156 is accordingly entered. Is updated (S54 in FIG. 17). By this input, a web page for browsing the production result information is registered in the shared information server 58, and the URL of the web page is notified to the production management unit by the electronic mail 212. The production management unit sees this information (S55 in FIG. 17) and manages the progress of the production (S56 in FIG. 17). FIG. 25 shows an example of a screen displaying the production record table. As shown in FIG. 25, the results of each stage of production (from SMT input to factory shipment) are tabulated weekly and monthly. Since the production status can be grasped by the production management department in almost real time, if any trouble occurs and the shipping schedule of the product is changed, immediately take necessary measures, for example, contact the ODM and take appropriate measures Can be easily performed.

Every Friday morning, an overseas logistics company transports the finished product from the ODM destination to the nearest airport, clears the country's customs clearance, and places it on a flight (ETD). This distributor supplies the ETD information of the product to the EDP system 80 via the ETD information input subsystem 138 as the ETD warehouse entry result information (S57 in FIG. 17), and updates the status-related DB 156 according to the information (FIG. 17). 17 S58). FIG. 26 shows an example of the ETD information input screen.

Here, it is assumed that a product arrives at a domestic airport within the day and is delivered to a domestic logistics company. The domestic logistics agency will process customs clearance (ETA) when the aircraft arrives. Domestic logistics companies ED ETA information
The data is input to the P system 80 (S59 in FIG. 17). The server updates the status-related DB 156 according to this information (S60 in FIG. 17). The example of the ETA information input screen is not shown for simplicity.

When the domestic logistics company receives the product, it uses the warehouse input information subsystem 190 to receive the number of products and the number of products (input number) extracted from the received products to be shipped. And the product quantity (the number of warehouses) to be included in the inventory of the company operating this system (the ODM source company). Figure 2 shows an example of the screen displayed at this time.
FIG.

This input information is given as an e-mail 194 (see FIG. 5) to the order / shipment / shipment sharing information system 110, and the warehouse information DB 342 is updated.

The domestic distribution company delivers the goods to the designated customer on Friday. By accessing the shared information server 58, it is possible to know the deposit application permission information in real time, and thus it is possible to make a delivery on the weekend.

[0100] Each customer is requested to complete the delivery of the product (Fig. 1
7 is “YES” in S61. ), And inputs the delivery information to the server (S62 in FIG. 17). The database is updated with this delivery information (S63 in FIG. 17).

The status of production from the start of production to delivery can be grasped in real time by the production management unit, the sales department, and the sales company by using the status information inquiry screens of the status information inquiry subsystems 210 and 228. Figure 2 shows an example of the screen displayed when status information is queried
FIG. As shown in FIG. 28, the ODM destination and the status of various stages of overseas and domestic physical distribution can be confirmed for each model, each order number, and each week.

Referring to FIG. 18, a description will be given of a method of efficiently delivering goods using this system.
Now, it is assumed that there are three stores (A store, B store and C store) as shown in FIG. It is assumed that the past sales are as shown in FIG. FIG.
In (N−n) weeks, n weeks from the week when actual sales are predicted
The week before.

The sales volume from the week before the actual sales forecast to three weeks before is averaged weekly for each store, and the result is predicted as the sales volume for the next week (N week). According to the numbers shown in FIG. 18, the predicted numbers of the stores A, B and C next week are 5
0, 40, and 30 units.

Here, it is assumed that orders of 90 units, 40 units and 60 units (a total of 190 units) have been received from stores A, B and C as orders for the next week, respectively. On the other hand, it is assumed that the production capacity including the ODM destination is only 160 units. At this time, a problem is how to achieve the most efficient delivery for the highest sales.

In the system of this embodiment, first, when the number of orders of a store is less than the predicted sales volume of the store, all of the orders are delivered to the store. In the example shown in FIG. 18, this corresponds to the store B. Therefore, first, 40 units, which are the number ordered from the B store, are delivered to the B store. 120 remaining production capacity
It is a stand.

Next, how to distribute the rest of the production capacity to a store that has ordered more than the predicted sales volume is a problem. There are various ways to do this. As a first method, it is conceivable to deliver goods according to the ratio of predicted sales volume. In the example shown in FIG. 18, the predicted sales volume of the A store and the C store is 50:30. Therefore, 120 × (50 ÷ 80) = 75 units are assigned to store A, and 120 × (30 ÷ 80) = 45 units are assigned to store C.

As a second method, it is conceivable to carry out delivery according to the ratio of the number of ordered units. In the example shown in FIG. 18, the order number of the stores A and C is 90:60. Therefore, 120 × (90 ÷ 150) = 72 units are allocated to the store A. 120 × (60 ÷ 150) = 48 for store C
A table is assigned.

[0108] The third method is considered to be to deliver goods at the average ratio between the predicted sales quantity and the ordered quantity. In the example shown in FIG. 18, the average of the predicted sales volume (50) and the order volume (90) in the store A is (50 + 90) / 2 = 70.
In the same manner, the average is (30 + 60) / 2 = 45 at the store C. Therefore, store A has 120 × (70 ÷ 115) =
73 units and 120 × (45Ｃ115) = 47 units are allocated to the C store.

By doing so, it is possible to reduce the possibility of unsold products at each store, and as a result, it is possible to increase sales under the constraint that production capacity is limited. The nature becomes high.

As described above, in the system according to this embodiment, not only the production management department and the sales department, but also persons involved outside the ODM source company, for example, customers and ODM destinations, transfer information for production management. Can be shared. In addition, each person can directly input information for production management into the production management server device at the ODM destination. Therefore, the state of the production management server device is kept up-to-date, and all the concerned parties can take appropriate actions based on the latest information.

The embodiments disclosed this time are to be considered in all respects as illustrative and not restrictive. The scope of the present invention is defined by the terms of the claims, rather than the description above, and is intended to include any modifications within the scope and meaning equivalent to the terms of the claims.

[0112]

As described above, according to the first aspect, not only the ODM company that operates the production management server device but also related parties outside the company, for example, customers, ODM destinations, and distribution companies. Can share information necessary for production management in real time. Therefore, each department can obtain appropriate information at various stages such as ordering, production, distribution, etc.
It is possible to deliver an appropriate number of products to the final customer in a timely manner. As a result, it is possible to provide a production management server device capable of further shortening the delivery date to the customer.

According to the second invention, each related person can easily access a necessary page in the WWW server using a general browser and obtain information necessary for production management via the page. it can. For stakeholders outside the company, there is no need to introduce a dedicated system to obtain information,
It is possible to provide a production management server device capable of further shortening the delivery date to a customer without imposing a heavy burden on a related person.

According to the third aspect, the processing corresponding to the data input is selected according to the destination address of the electronic mail. For the parties outside the company, there is no need to introduce a dedicated system for inputting data, and the burden of performing production management can be reduced. As a result, it is possible to provide a production management server device capable of further shortening the delivery date to a customer without imposing a heavy burden on a related person.

According to the fourth aspect, the processing selected according to the destination address of the e-mail is performed based on the contents of the document attached to the e-mail in a predetermined format. It is easy to prepare the attachments and there is no need to introduce a dedicated system therefor. As a result, it is not necessary for stakeholders outside the company to introduce a dedicated system to input data, and it is possible to input a large amount of data without errors by easy operation, and to perform production management. The burden on the user can be reduced. As a result, it is possible to provide a production management server device capable of further shortening the delivery date to a customer without imposing a heavy burden on a related person.

According to the fifth aspect, when the database means is updated, the destination associated with the data is immediately notified. The person in charge at the destination can access new data immediately by accessing the access means according to the notification. Therefore, not only the ODM source company operating the production management server device but also related parties outside the company, for example, customers, ODM destinations, and logistics companies can share information necessary for production management in real time. . Therefore, each department can obtain appropriate information at various stages such as ordering, production, distribution, etc., and can deliver the appropriate number of products to the final customer in a timely manner,
The delivery date to the customer can be further shortened.

According to the sixth aspect, each related person can easily access a necessary page in the WWW server using a general browser and obtain information necessary for production management via the page. it can. For stakeholders outside the company, there is no need to introduce a dedicated system to obtain information,
The burden of managing production is reduced. As a result, the delivery date to the customer can be further reduced without imposing a heavy burden on the concerned parties.

According to the seventh aspect, the processing corresponding to the data input is selected according to the destination address of the electronic mail. For the parties outside the company, there is no need to introduce a dedicated system for inputting data, and the burden of performing production management can be reduced. As a result, the delivery date to the customer can be further reduced without imposing a heavy burden on the concerned parties.

According to the eighth aspect, the processing selected according to the destination address of the electronic mail is performed based on the contents of the document attached to the electronic mail in a predetermined format. It is easy to prepare the attachments and there is no need to introduce a dedicated system therefor. As a result, it is not necessary for stakeholders outside the company to introduce a dedicated system to input data, and it is possible to input a large amount of data without errors by easy operation, and to perform production management. The burden on the user can be reduced. As a result, the delivery date to the customer can be further reduced without imposing a heavy burden on the concerned parties.

According to the ninth aspect, when the database means is updated, a notification is immediately sent to a destination associated with the data. The person in charge of the destination can access new data immediately and easily by accessing the access means according to the notification. Not only the ODM source company that operates the production management server device but also related parties outside the company, such as customers, ODM destinations, and distribution companies, can share information necessary for production management in real time. Therefore, each department can obtain appropriate information at various stages such as ordering, production, logistics, etc., and can deliver the appropriate number of products to the final customer in a timely manner. Can be shortened.

According to the tenth aspect, each related person can easily access a necessary page in the WWW server using a general browser and obtain information necessary for production management via the page. it can. For stakeholders outside the company,
There is no need to introduce a dedicated system to obtain information, and the burden of performing production management can be reduced. As a result, the delivery date to the customer can be further reduced without imposing a heavy burden on the concerned parties.

According to the eleventh aspect, the processing corresponding to the data input is selected according to the destination address of the electronic mail. For the parties outside the company, there is no need to introduce a dedicated system for inputting data, and the burden of performing production management can be reduced. As a result, the delivery date to the customer can be further reduced without imposing a heavy burden on the concerned parties.

According to the twelfth aspect, the processing selected according to the destination address of the electronic mail is performed based on the contents of the document attached to the electronic mail in a predetermined format. It is easy to prepare the attachments and there is no need to introduce a dedicated system therefor. as a result,
For stakeholders outside the company, there is no need to introduce a dedicated system for inputting data, and large amounts of data can be input without errors by easy operation, which imposes a burden on production management. Lighter. As a result, the delivery date to the customer can be further reduced without imposing a heavy burden on the concerned parties.

[Brief description of the drawings]

FIG. 1 is an overall system diagram of an embodiment of the present invention.

FIG. 2 is a block diagram of an EDP system including a production management server device according to one embodiment of the present invention.

FIG. 3 is a block diagram of a production management server device according to an embodiment of the present invention.

FIG. 4 is a block diagram of a system of an overseas ODM destination company.

FIG. 5 is a block diagram showing a system of a distributor.

FIG. 6 is a block diagram of a system of a production management unit of an ODM source company.

FIG. 7 is a block diagram of a system of a sales department of an ODM former company.

FIG. 8 is a block diagram of a customer company system.

FIG. 9 is a schematic diagram showing a data input mode to a production management server device according to an embodiment of the present invention.

FIG. 10 is a schematic diagram showing a processing mode of data input by e-mail in the production management server device according to one embodiment of the present invention.

FIG. 11 is a diagram showing a configuration of a status information-related database in the system according to the embodiment of the present invention.

FIG. 12 is a diagram showing a configuration of a database relating to order information in the system according to the embodiment of the present invention;

FIG. 13 is a flowchart showing a flow of processing of data input by electronic mail in the system according to the embodiment of the present invention.

FIG. 14 is a system flowchart of a system according to an embodiment of the present invention.

FIG. 15 is a system flowchart showing processing in each related department in the system according to the embodiment of the present invention (part 1);
It is.

FIG. 16 is a system flowchart showing processing in each related department in the system according to the embodiment of the present invention (part 2);
It is.

FIG. 17 is a system flowchart (part 3) showing processing in each of the related departments in the system according to the embodiment of the present invention.

FIG. 18 is a diagram illustrating an example of a method of delivering goods using the system according to the embodiment of the present invention.

FIG. 19 is a diagram showing an input screen for prediction / reservation order information.

FIG. 20 is a diagram showing a total shipment number confirmation screen.

FIG. 21 is a diagram showing a deliverable number presentation / confirmation screen.

FIG. 22 is a diagram showing an input screen for actual sales information.

FIG. 23 is a diagram showing a confirmed order input screen.

FIG. 24 is a view showing a confirmed order confirmation.

FIG. 25 is a diagram showing a production result table screen.

FIG. 26 is a diagram showing an ETD information input screen.

FIG. 27 is a diagram showing a warehouse entry information input screen.

FIG. 28 is a diagram showing a status information inquiry screen.

[Explanation of symbols]

50 product production management system, 52 intranet, 54 internet, 56 firewall,
58 information sharing server, 62 overseas ODM destinations, 64 distributors, 66 customers, 80 EDP system, 82 production management system, 84 sales department system, 86 sales company, 88 database, 110 ordering / shipment sharing information system, 112 production Purchasing management system, 114 domestic logistics / order receiving system.

Continued on the front page F-term (reference)

Claims (12)

[Claims] 1. A production management server device connected to an intranet in a company, connected to the Internet via a firewall, and used for managing the production of commodities entrusted to a subcontractor outside the company. Outside the firewall, there is provided an information providing server that can be provided to a computer connected to the Internet in a format that can be accessed from the outside and information in the production management server device can be viewed from the outside, The production management server device includes: database means for retaining data necessary for managing a desired part of ordering, production, and distribution of goods; an external computer connected to the Internet; and the intranet. Ordering, production and logistics from computers in the enterprise connected to Data input means for receiving information about the data and maintaining the data held by the database means, and in response to a predetermined type of data being input to the production management server device by the data input means, Access preparation means for preparing in the information providing server access means for accessing a data portion corresponding to the predetermined type of data in the database means; and In response to the data being input to the production management server device,
Notification means for notifying information for accessing the access means prepared in the information providing server by the access preparation means to a predetermined destination according to the predetermined type of information. Management server device. 2. The information providing server includes a WWW server, and the access preparation unit stores the predetermined type of data in the WWW server in response to input of the predetermined type of data. Means for preparing a page prepared for browsing relevant information, wherein the notifying means sends an e-mail address of the prepared page to a predetermined e-mail address corresponding to the predetermined type. The production management server device according to claim 1, further comprising a unit for transmitting an e-mail including a URL. 3. The data input means according to claim 1, wherein said data input means performs predetermined processing on each predetermined data portion of said database means according to a destination address of said electronic mail. 3. The production management server device according to claim 1, further comprising an electronic mail processing unit. 4. The e-mail processing means includes, in response to an e-mail having an attached document, a predetermined data portion of the database means included in the attached document according to a destination address of the e-mail. 4. The production management server device according to claim 3, further comprising: an attached document processing unit for updating the data according to a predetermined method using the data to be updated. 5. Use of a production management server device connected to an intranet within a company and connected to the Internet via a firewall to control the production of products outsourced to a subcontractor outside the company. An information providing server which is capable of providing a computer connected to the Internet in a format which can be accessed from outside and which can read information in the production management server device from outside, outside the firewall. The production management method for commodities includes a database means for holding data necessary for managing a desired part of ordering, production, and distribution of commodities in the production management server device. Preparing an external computer connected to the Internet and the intranet. Receiving information on ordering, producing, and distributing goods from a computer in the company connected to the server and maintaining the data held by the database means; and a predetermined type of data is stored in the production management server by the data input means. Preparing, in the information providing server, access means for accessing a data portion of the database means corresponding to the predetermined type of data in response to the input to the device; In response to the predetermined type of data being input to the production management server device by the input means,
Notifying, to the predetermined destination according to the predetermined type of information, information for accessing the access means prepared in the information providing server by the preparing step. Method. 6. The information providing server includes a WWW server, and the preparing includes, in response to the input of the predetermined type of data, storing the predetermined type of data in the WWW server. Preparing a page prepared for browsing related information, wherein the notifying step comprises: sending a URL of the prepared page to an e-mail address predetermined for the predetermined type. The method according to claim 5, further comprising transmitting an e-mail including: 7. The step of performing the maintenance includes, in response to an electronic mail, performing a predetermined process on each of predetermined data portions of the database means according to a destination address of the electronic mail. The production management method for commodities according to claim 5 or 6, comprising: 8. The step of performing the predetermined processing includes, in response to an electronic mail having an attached document, storing each predetermined data portion of the database means in accordance with a destination address of the electronic mail. 8. The method according to claim 7, further comprising the step of updating the data according to a predetermined method using data included in the attached document.
Product production management method described in. 9. Use of a production management server device connected to an intranet in a company and connected to the Internet via a firewall to control the production of products outsourced to a subcontractor outside the company. A computer-readable storage medium on which a program for realizing a production management method is recorded. The computer-readable storage medium is capable of externally accessing the information outside the firewall and externally browsing information in the production management server device. An information providing server which can be provided to a computer connected to the Internet in a format, wherein the production management method of the product is necessary to manage a desired part of ordering, production and distribution of the product. Preparing database means in the production management server device for holding important data; Receiving information on ordering, production and distribution of goods from an external computer connected to the Internet and a computer in a company connected to the intranet, and maintaining data held by the database means; and Access means for accessing a data portion of the database means corresponding to the predetermined type of data in response to input of the predetermined type of data to the computer-readable recording medium by the input means; Preparing in the information providing server, and in response to the predetermined type of data being input to the production management server device by the data input means,
Notifying the information for accessing the access means prepared in the information providing server by the preparing step to a predetermined destination according to the predetermined type of information. recoding media. 10. The information providing server includes a WWW server, and the preparing includes, in response to the input of the predetermined type of data, storing the predetermined type of data in the WWW server. Preparing a page prepared for browsing related information, wherein the notifying step comprises: sending a URL of the prepared page to an e-mail address predetermined for the predetermined type. The computer-readable medium according to claim 9, further comprising a step of transmitting an e-mail including: 11. The step of performing the maintenance includes, in response to an electronic mail, performing a predetermined process on each predetermined data portion of the database means according to a destination address of the electronic mail. The computer-readable recording medium according to claim 9, comprising: 12. The method according to claim 11, wherein the step of performing the predetermined processing includes: in response to an e-mail having an attached document, storing each predetermined data portion of the database means in accordance with a destination address of the e-mail. The computer-readable storage medium according to claim 11, further comprising a step of updating the data using data included in the attached document according to a predetermined method.