JP2002304567A - Merchandise information transmitting program and recording medium with the same recorded - Google Patents

Abstract

PROBLEM TO BE SOLVED: To open quality information of merchandise to the shipping destination for a necessary period so that it can be easily made usable. SOLUTION: A computer functions as an integral merchandise test data base constructing means for recording and preserving data by lot units based on the input of merchandise test and check data, a shipping destination merchandise test data file preparing means for calling data related with shipped merchandise lots from the data base, and for editing and recording the data for each shipping destination according to the input of the shipping information, a merchandise test data transmitting means for outputting the required data from the data file to the shipping destination, and an illegal access preventing means. It is possible to easily prepare data without omission for the periodical examination of ISO by using electronic signatures. Therefore, it is possible to easily prepare statistical data, and to mutually compare different data. Thus, it is possible to contribute to quality improvement or production rationalization, and to quickly facilitate countermeasures to any complaint or the like.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention utilizes a computer to transmit product test data, such as test and inspection results, performed by a shipping source in units of lots on a shipped product, in order to transmit quality information of the product to a destination. A product information transmission program and a computer-readable recording medium that enable a shipping destination to use the above-mentioned data at any time via the Internet as needed, by recording and storing the data into a comprehensive product test database. , A product information transmitting device and a product information transmitting method.

[0002]

2. Description of the Related Art Conventionally, a shipping source that ships various products such as raw materials, products, materials, parts, and products checks the quality of the shipped products as necessary, and assures the quality to the shipping destination. Perform the required tests and inspections, and then write the results on paper and edit them into a quality inspection report or quality test report, etc., and attach them to the shipping product or mail it separately at the same time as shipping. Had been delivered to the destination.

[0003] At the destination, the quality is confirmed based on the received quality inspection report or quality test report, etc., and the product is received. Further, the destination is used for quality control of the product pertaining to the destination itself, or an international standard (such as ISO) is used. Corresponded to the regular examination of It is important to write the quality inspection report and test report without error, deliver it to the shipping destination, and store and manage it at the shipping destination, but it has not been done efficiently and efficiently. Furthermore, if the data described in the documents is accumulated and used for quality improvement, production rationalization, etc., it is valuable for both the shipping destination and the shipping source, but it is disclosed in a state that is difficult to use. It was not fully utilized because it was managed.

As a means for streamlining the above procedure, a quality management system using a computer is described in Japanese Patent Application Laid-Open No. 8-263535. here,
Prepare a product name master that sets the test contents in association with the product name code of the product, automatically create a test request form for the corresponding product by inputting an order, request a test, save the test results, and then repeat the duplicate test. And means for checking whether or not the test result is within a required standard range. That is, the object of the present invention is to automatically prepare a test request form for an article by inputting an order for the article, request a test / inspection to an inspection department so that there is no waste, determine the obtained test results, etc., and perform a test. The purpose is to prepare a certificate and an inspection report, and to convert them into a test report according to the customer's request, if necessary.

Japanese Patent Application Laid-Open No. Hei 9-218898 discloses a method of using a computer in order to create a record of quality data necessary for quality control performed in accordance with ISO 9000 without fail within a required time limit. Manage, create,
Describes how to manage quality records.

[0006]

By the way, the above-mentioned quality inspection report and test report are used as data necessary for quality assurance records and quality improvement of the shipped product at the shipping source, and the quality of the received product at the shipping destination. It is data necessary for inspection, quality record, use or processing of incoming goods and selling to others. For example, depending on international standards, it is necessary to prepare a large number of certified test reports at the time of periodic inspections by the certification body. In this way, although the quality inspection report and test report are important data for both the shipping source and the shipping destination, the actual situation is delivered separately at each shipment, and the data is lost during storage and lost. It often hindered our business, and sometimes even caused data leakage to third parties. The present invention has been completed with the object of disclosing the above valuable data on product quality in a necessary period of time in a manner that is easy to use and effectively utilizing both the shipping source and the shipping destination to contribute to the development of industry. Was.

[0007]

According to the present invention, as a means for solving the above-mentioned problems, first, in order to transmit quality information of a product to a shipping destination, a computer performs a product test and / or a product test conducted in lot units. Means for constructing a comprehensive product test database that classifies the product based on the input of the inspection data and records and stores the data in lot units, and based on the input of product shipping information, A means for calling a predetermined test / inspection data relating to a shipped product lot, creating a destination-specific product test database for editing, recording, and storing the data for each destination; By accessing the separate product testing database,
Functioning as a means for transmitting the product test data for outputting required product test and / or product inspection data and as a means for preventing unauthorized access to prevent a third party from accessing the product test database for each shipping destination. Provide a featured product information transmission program. The computer may function the product test and / or product inspection data as product test and / or product inspection data and other necessary product-related information.

When new product inspection data or product-related information is routinely input to the database, or when the content of the database is updated by changing or correcting already input data, a product test for each shipping destination is performed. It is desirable to provide update information display means for inputting these update information to the database and displaying the update information as update information for a certain period. Furthermore, when new product inspection data or product-related information is input to the comprehensive product test database, or when the content of the database is updated by changing or correcting the already input data, the update information is input to the product test database for each shipping destination. However, if update information notifying means for immediately notifying that the update information is input to the display screen of the product test database for each shipping destination is provided, the shipping destination can always be in contact with the latest update information.

In addition, by discriminating data and information to be input for constructing a comprehensive product test database into those to be disclosed to the shipping destination and those not to be disclosed, each of the shipping destinations is disclosed to the shipping destination. This can be used more conveniently if a destination-specific product test database is created that is edited, recorded, and stored separately for files to be disclosed and files not to be disclosed.

Then, the computer further calls the required test / inspection data from the comprehensive product test database or the product test database for each destination, edits the test report into a predetermined format, and performs an electronic signature. A means for creating a digitally signed test report that stores the created digitally signed test report in a product test database for each shipping destination or in a digitally signed test report file for each shipping destination created separately from the database; By accessing the file related to the user, the required test report with an electronic signature can be made to function as a transmission means of the test report with an electronic signature to be output to the shipping destination, so that the function can be enhanced.

Further, the computer is used to store and retrieve goods,
By linking to an inventory management program that records and manages inventory lots, and by entering the required quality standards for the inquiry products in response to inventory or delivery inquiries from customers,
Product information transmission program and inventory management by functioning as a means of comparing the quality standard of the inquiry product with the test / inspection data of the product lot in stock and searching for inventory product lots that satisfy the quality standard of the inquiry product The usefulness of the program is enhanced.

According to the present invention, there is provided a computer-readable recording medium on which the above-mentioned product information transmission program is recorded, and a method for transmitting quality information of the product to a shipping destination.
A product information transmission device comprising a computer in which the product information transmission program according to any one of claims 1 to 5 is installed.

According to the present invention, in order to transmit quality information of a product to a shipping destination, a computer in which any one of the above-mentioned product information transmission programs is installed is subjected to product test and / or product inspection data performed in lot units. To construct a comprehensive product test database for classifying the product, recording and storing the data in lot units, and then inputting product shipping information to determine a predetermined product lot shipped from the comprehensive product test database. Call out the test / inspection data of each destination, create a destination-specific test database that edits, records and saves the data for each destination, and prevent unauthorized access by a third party to the destination-specific product test database. Implements unauthorized access preventing means, and the shipping destination pertains to its own product testing database. By accessing, providing product information transmission method characterized by outputting the desired product testing and / or product inspection data.

[0014]

BEST MODE FOR CARRYING OUT THE INVENTION The present invention will now be described in detail with reference to embodiments. The present invention
Using a computer and the Internet, the shipping source records, saves, and collectively manages, including quality test data and inspection data that were disclosed in writing attached to the shipping product, or data that was not previously disclosed. , Appropriate data shall be disclosed to the shipping destination and shared by both parties, and only the two parties shall be able to make effective, prompt,
A commodity information transmission program, a recording medium storing the program, a commodity information transmission device, and a commodity information transmission method for convenient use. In order to facilitate understanding of the present invention, FIG. 1 shows a flow chart of an example of an embodiment of the product information transmission program of the present invention.

In the description of the present invention, the computer
In addition to the main unit including the PU and the internal recording device, it also includes peripheral devices such as a keyboard, a scanner, a display, a printer, an external recording device, and an interface. Good. In addition, the relationship between the operation that causes the computer to function and the unit device that configures and functions the computer is as generally known, for example,
"Input data" is an operation equivalent to "input data through an input device such as a keyboard or a scanner", and "Classify products" is "CPU set according to a predetermined standard". It classifies commodities in accordance with a command from the control program. "

Further, in the present invention, in principle, tests and inspections for quality assurance, which are determined by trade or voluntarily, are performed by the time of shipment, and the results are disclosed to the destination. Products in-house, products manufactured and commissioned by other companies, products for resale, etc., or stocks in stock, made-to-order products, etc. do not matter. The person responsible for shipping or quality assurance the product is called the originator or company, and the person responsible for receiving, receiving or checking the quality of the shipped product is the destination or customer, but these are not necessarily limited to one place. In some cases, it may be divided into a plurality. If there are other product information input / output destinations, these may be included. Those who conduct inspections and tests include:
Third-party organizations are examples.

Now, the product information transmission program of the present invention will be described with respect to an embodiment. First, a master file for constructing a comprehensive product test database is provided in a computer by means for constructing a comprehensive product test database. Normally, the testing and inspection of the product are completed in an appropriate lot unit by the time of shipment, and the data obtained as a result are displayed on the computer together with the display of the shipping destination, product classification, for example, product code and lot number. , The information is appropriately classified in the comprehensive product test database, for example, classified by shipping destination, product, product type, and application, and recorded and stored.

If necessary, related information other than test / inspection data, such as test methods, inspection standards, manufacturing records, material history, costs, etc., can be input, recorded, and saved. If there is a complaint, these data can be output from a computer and examined for prompt response. Data is sequentially accumulated as described above, and is constructed as a comprehensive product test database.

More specifically, for example, merchandise information such as shipping destination, merchandise classification, and test / inspection data is edited and recorded and stored in a predetermined format card for each lot of merchandise. Then, in order to select necessary data from the accumulated data and to edit it easily, it is necessary to edit the test / inspection data list, test / inspection item list, test / inspection data list for a certain period, etc. Selection / editing means based on the manufacturer or the like is provided. If necessary, a required card can be selected from the group of cards, and desired data can be selected from data recorded in the card and edited into a desired format. This is convenient because necessary data can be selected and output from a large number of data at any time and edited in an easy-to-use format.

Next, a means for creating a destination-specific product test database causes a computer to create a destination-specific product test database for each destination separately from the comprehensive product test database. The merchandise test database for each shipping destination is linked to, for example, an inventory management system for managing receipt / shipment and inventory of merchandise provided separately from the merchandise information transmission program of the present invention. Then, when the negotiations etc. are completed and the product is shipped, the lot number of the shipped product is known from the shipping information input to the inventory management system, the comprehensive product test database is searched, and the necessary part of the test / inspection data on the shipping lot is found. make a copy. Then, based on the destination name, the corresponding destination-specific product test database is searched and copied data is pasted. Of course, the lot number of the shipped product may be directly input to the comprehensive product test database. Alternatively, a predetermined paper test document may be output separately to create a conventional paper document and attached to the shipping product. Appropriate selection and sorting in the product test database for each shipping destination
It is preferable to provide an editing means or the like. Note that data input can be performed after shipment depending on the situation. The shipping information does not strictly mean the delivery of the product itself, and it does not matter if the order is confirmed in accordance with the actual business.

The main purpose of creating the test database for each shipping destination is to disclose the data stored in the database to the shipping destination and freely browse and use it. However, I want to use it only at the shipping source as a trade secret,
For example, there are many cases where it is desired to store production records separately for each shipping destination. In preparation for such a case, the product shipping information is input to the comprehensive product testing database separately from those to be disclosed to the shipping destination and those not to be disclosed, and further, the test / inspection data called from the comprehensive product testing database is
It is desirable to distinguish between data to be disclosed to the shipper and data not to be disclosed, and to create a test database for each shipper separately for a file to be disclosed to the shipper and a file not to be disclosed.

[0022] The persons concerned within a predetermined range, such as the shipping source and the shipping destination, can transmit the test / inspection data of the shipped or shipped product to the destination by means of transmitting the product test data as necessary. Access the accumulated product test database for each shipping destination via the Internet at any time, read the data shown on the display, or download and edit the required data to facilitate the required purpose. Can be used. At this time, in order to prevent unauthorized access to the shipping destination product test database by a third party, and to prevent the contents of the file from being leaked or rewritten, an unauthorized access preventing means is taken. For example, it is preferable to set a secret password required to access the product test database for each shipping destination.

In the above-mentioned database, new product inspection data or product-related information is routinely input, or the content of the database is often updated by addition, change, correction or the like of already input data. These updates are extremely important at the shipping destination and need to be monitored quickly and without oversight. Also in the present invention, when the update information is input to the comprehensive product test database and the content is updated, the update information is also transmitted to the product test database for each shipping destination and updated, and the update information is displayed as the update information for a certain period of time. It is desirable to provide display means. For example, there is a means for displaying the update information on the display in a special color or font so that the shipping destination can easily recognize the update information. further,
When the update information is input to the comprehensive product test database, update information notifying means for immediately displaying that the update information is input on the display screen of the product test database for each shipping destination is provided. By keeping the display screen open, it is possible to always obtain the latest information including shipping information addressed to the user without omission.

The product information transmission program of the present invention is intended to cause a computer to execute the above-described means. In addition, the computer transmits an electronic signature based on data in a destination-specific product test database. By functioning as a means for preparing an attached test report, its usefulness often increases. For example, there is a wide variety of certifications required for presentation data in ISO periodic examinations, test / inspection data on safety and effectiveness of foods and medicines, and the like. Specifically, at the request of the shipper, the shipper or the tester / inspection performer calls the required test result data from the comprehensive product test result database or the product test result database for each shipper, and edits it in a predetermined format. The electronically signed test report with the electronic signature is stored in the product test result database for each shipping destination, or in a test report file with electronic signature for each shipping destination created separately from the above file. The shipping source or the test or inspection implementer can provide the product test results with the required electronic signature via the Internet at any time upon request. It is convenient for the shipping destination. A public key system or the like may be used for the electronic signature.
FIG. 2 shows a model of a test report with an electronic signature.

Further, the product information transmission program of the present invention comprises:
The computer is further linked to an inventory management program for managing the entry / exit of the product and the inventory lot, and in response to an inquiry from a customer, inputs a quality condition of the product being inquired, a necessary amount, and the like, and stores the product to be stocked. By comparing the lot test / inspection data with the quality conditions of the inquired product and functioning as a means for searching for the presence or absence of a stock product lot that satisfies the conditions, the convenience of the product information transmission program and inventory management program of the present invention can be obtained. Sex can be increased.

The product information transmission program of the present invention described above is recorded on a computer-readable recording medium and is read by a computer, whereby the computer can easily function according to the program.
The computer that has read (installed) the product information transmission program functions as a product information transmission device.

[0027]

According to the present invention, since the inspection and test data can be shared between the shipping source and the shipping destination, and the past and past data can be managed collectively as electronic data, the mutual information can be transmitted quickly and smoothly. . For example, by using the transmission means of the test report with an electronic signature of the present invention at the time of periodic examination of ISO, etc., the shipping destination can easily prepare necessary data without omission. In addition, since creation of statistical data and comparison of different data with each other are facilitated, data can be sufficiently used for quality improvement and production rationalization. Furthermore, it is possible to respond quickly to claims and the like.

[Brief description of the drawings]

FIG. 1 is a flowchart showing an example of an embodiment of a product information transmission program of the present invention.

Fig. 2 Model of test report with electronic signature

Claims (10)

[Claims] In order to transmit quality information of a product to a shipping destination, a computer sorts the product based on input of product test and / or product inspection data performed on a lot basis and sorts the data on a lot basis. Means for constructing a comprehensive product test database to be recorded and stored, and based on input of product shipping information, calls predetermined test / inspection data on the shipped product lots from the comprehensive product test database, and Means for creating a destination-specific product test database that edits, records, and saves the data separately, and that the destination accesses the destination-specific product test database relating to itself, thereby providing a required product test and / or product A means for transmitting product test data that outputs inspection data, and a third party accessing a product test database for each shipping destination As means for preventing unauthorized access to prevent the that product information transmission program for causing to function. 2. The product information transmitting program according to claim 1, wherein the product test and / or product inspection data is the product test and / or product inspection data and other necessary product related information. . 3. When new product inspection data or product-related information is input to the comprehensive product test database, or when the contents of the database are updated by changing or correcting already input data, the product test database for each shipping destination is stored in the comprehensive product test database. 3. The product information transmission program according to claim 1, further comprising update information display means for inputting update information and displaying the update information as update information for a predetermined period. 4. When new product inspection data or product-related information is input to the comprehensive product test database, or when the content of the database is updated by changing or correcting the already input data, the product test database for each shipping destination is stored in the comprehensive product test database. 4. The product according to claim 1, further comprising update information notifying means for inputting the update information and immediately notifying that the update information is input on the display screen of the product test database for each shipping destination. Information transfer program. 5. By discriminating data and information to be input for construction of a comprehensive product test database into those to be disclosed to the shipping destination and those not to be disclosed, each of the shipping destinations is disclosed to the shipping destination. Creating a shipping-specific merchandise test database that edits, records, and saves the files separately for files to be disclosed and files that are not disclosed.
The product information transmission program according to claim 1. 6. The computer further transmits a required test / inspection data from the comprehensive product test database or the product test database for each destination, edits the test report into a predetermined format, and performs an electronic signature on the computer. Means for creating a test report with an electronic signature for storing the created test report with an electronic signature in a product test database for each shipping destination or a test report file with an electronic signature for each shipping destination created separately from the database; 6. The method according to claim 1, further comprising the step of: transmitting the required electronically signed test report to the shipping destination by transmitting the electronically signed test report to the destination by accessing the file relating to the user. Product information transmission program described in any of the above. 7. An inquiry is made by linking with a stock management program for recording and managing goods entry / exit and inventory lots, and inputting a required quality standard for the inquired goods in response to a stock or delivery inquiry from a customer. 7. The method according to claim 1, wherein the product quality standard and the test / inspection data of the product lot to be stocked are compared to function as a means for searching for a stock product lot satisfying the quality standard of the inquiry product. Product information transmission program described in Crab. 8. A computer-readable recording medium on which the product information transmission program according to claim 1 is recorded. 9. A merchandise information transmitting apparatus comprising a computer installed with the merchandise information transmitting program according to any one of claims 1 to 7 for transmitting quality information of the merchandise to a shipping destination. 10. A product test and / or product conducted in lot units on a computer installed with the product information transmission program according to any one of claims 1 to 7 in order to transmit product quality information to a shipping destination. Inspection data is input, the product is classified, the data is recorded in lot units, and a comprehensive product test database is constructed to store and store the data. Next, the product shipping information is input, and the product lot is shipped from the comprehensive product test database. Calling out predetermined test / inspection data, creating a test database for each shipping destination that edits, records and saves the data for each shipping destination, and unauthorized access by a third party to the product testing database for each shipping destination To prevent unauthorized access and ensure that the relevant ship-to By Seth, product information transmission method characterized by outputting the desired product testing and / or product inspection data.