JP2001229191A - System and method for providing raw material information - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a raw material information providing system which can easily and speedily provide raw material information. SOLUTION: This raw material information providing system has a database (2a) which stores raw material information, a specifying means (2) which specifies a raw material, and a display means (2) which retrieves raw material information corresponding to the raw material specified by the specifying means from the database and displays the information.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to a technique for providing raw material information, and more particularly to a technique for providing raw material information based on a database.

[0002]

2. Description of the Related Art A large company has a plurality of offices. Each business place independently orders parts or raw materials,
I do not know the ordering status of other offices. Each office is
Parts or raw materials may be purchased from different suppliers or the same supplier at different unit prices. Further, in the above-mentioned ordering, transactions are often performed using paper order forms and slips.

[0003]

[Problems to be solved by the invention] In the development department of a company,
There are the following problems. (1) Parts or raw materials used at other business sites are not known. (2) The choice of parts and raw materials is narrow. (3) Information on substitutes is scarce. (4)
New product information cannot be obtained quickly.

The procurement department of a company has the following problems. (1) The purchase unit price and the supplier of the same parts or raw materials at each business site are not known. (2) Information on substitutes is scarce. (3) The customer's capabilities (eg, production type and production volume) and status are unknown. (4) I do not know the purchase status of the entire company group. An object of the present invention is to provide a raw material information providing system, a raw material information providing method, and a recording medium that can provide raw material information easily and quickly.

[0005]

According to one aspect of the present invention, a database for storing raw material information, a designating means for designating raw materials, and raw material information corresponding to the raw materials designated by the designating means are stored in the database. And a display means for searching and displaying the information.

According to another aspect of the present invention, raw material information comprising: (a) a step of specifying a raw material; and (b) a step of searching and displaying raw material information corresponding to the specified raw material from a database. A providing method is provided.

According to yet another aspect of the present invention, (a)
There is provided a computer-readable recording medium recording a program for causing a computer to execute a procedure of designating a part and a procedure of (b) searching and displaying raw material information corresponding to the specified raw material from a database. You.

According to the present invention, raw material information can be obtained quickly and easily, and raw materials can be selected and procured quickly and efficiently. Large companies can obtain raw material information of each business establishment and purchase raw materials at the lowest possible price based on the raw material information. In addition, a large amount of raw materials can be purchased at low cost by placing orders at each business office in a lump.

[0009]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS The embodiments of the present invention will be described below with reference to the accompanying drawings. FIG. 1 is a block diagram showing a configuration of a procurement information system (procurement information providing system) 13 and a purchase system 21 according to an embodiment of the present invention. The purchasing system 21 has an ordering system 22 and a production management system 23. Procurement information system 13
Is a component information system (component information providing system) 11,
The system includes a cost reduction support system 5, a procurement record system 6, a supplier system 12, a supplier sales system 9, and a bulletin board mail system 10. The component information system 11 includes an electronic component system 1, a raw material system 2, a mechanical component system 3, and an entire number system 4. The supplier system 12 has a supplier card information system 7 and a supplier map system 8.

The electronic component system 1 has a database 1a, the raw material system 2 has a database 2a, the mechanical component system 3 has a database 3a, the whole number system 4 has a database 4a, and a cost reduction support system. 5 has a database 5a, the procurement record system 6 has a database 6a, the supplier card information system 7 has a database 7a, the supplier map system 8 has a database 8a, and the supplier sales system 9 has It has a database 9a. These databases 1a to 9a do not necessarily need to be prepared for each individual system, and may be shared by each system as one database. If a database is prepared individually, the search in the database can be performed at high speed, and if the database is shared, the waste of duplicating data can be reduced.

The electronic component system 1 is a system for providing users with procurement information (including specification information and quality information) of electronic components (including semiconductors). The raw material system 2 is a system that provides users with procurement information of raw materials for molds and pressed parts. The mechanical component system 3 is a system for providing mechanical component procurement information to a user. The all-number system 4 is a system that provides the user with all-number (all parts) procurement information. The cost reduction support system 5 is a system that provides users with price difference information between companies of the same parts or raw materials. The procurement record system 6 is a system that provides the user with total information on the procurement record of the group. The supplier card information system 7 is a system for providing card information (supplier information) of a supplier to a user. The supplier map system 8 includes map information (position information) of the supplier, equipment owned by the supplier (processing equipment), and business relationships with other companies (secondary subcontracting).
Is a system that provides users with the information. The supplier sales system 9 is a system that provides users with sales information registered by suppliers and manufacturers. Bulletin board mail system 1
Reference numeral 0 denotes a system for providing various information to users through bulletin boards and mail.

The user's computer 31 is, for example, a personal computer, and can be used only by a registered user. The user is, for example, an employee of a specific department of the company, and can use the procurement information system 13 using the computer 31. However, the information provided is limited depending on the department to which the user belongs. The user can use, for example, Web browser software (Ne
tscape and Internet Explorer)
Thus, the procurement information system 13 can be used.

The procurement information system 13 is an information support system for selecting and procuring parts and materials around the world quickly and efficiently. The user can search for procurement information from the computer 31 on the WWW (world wide web). Large companies often have a plurality of offices, and each office often orders parts or materials independently.
Each business establishment may purchase parts or materials from different business partners or the same business partner at different unit prices. The ordering / ordering system 22 can acquire transaction information of each business establishment and purchase parts or materials at a low price based on the transaction information. In addition, the ordering system 21 can purchase a large number of parts or materials at low cost by performing ordering for each business site in a lump. Specifically, the ordering system 22 accesses the parts information system 11, the cost reduction support system 5, and the procurement results system 6,
An order is placed with respect to the computer 32 of the business partner.

The procurement information system 13 can satisfy the following requirements in the development department of a company. (1) I want to know parts and materials used at other business sites. (2)
I want to select the best parts and materials from a wide range of information.
(3) I want to obtain information on alternative products. (4) I want to get new product information quickly.

The procurement information system 13 can satisfy the following requirements in a procurement department of a company.
(1) I want to know the purchase price and supplier of the same parts and materials at each business site. (2) I want to quickly find information on alternative products.
(3) I want to know the capabilities (for example, production type and production volume) and status of the business partner. (4) I want to know the purchase status of the entire group.

The procurement information system 13 can input data from an external database 34 and register it in the databases 1a to 9a. The external database 34 is, for example, a semiconductor industry newspaper published by Sangyo Times, an external database (electronic device information service), product or component catalog information, and a database of each business office.

The supplier computer 32 provides card information, map information, and sales information to the supplier card information system 7, the supplier map system 8, and the supplier sales system 9, respectively, by the operation of the person in charge of the supplier. I do. The computer 33 provides various information to the bulletin board mail system 10 by the operation of the information provider.

The computer 31 of the user, the computer 33 of the information provider, the computer 32 of the business partner, and the external database 34
They are connected by a network such as AN or WAN. FIG.
9 is a flowchart showing the processing of the procurement information system 13. When the user logs in from the computer 31, the procurement information system 13 can be activated. In step S1, a menu of the procurement information system is displayed on the user's computer 31. Users can select menu items such as electronic parts system, raw material system, mechanical parts system, total number system, cost reduction support system, procurement record system, supplier card information system, supplier map system, supplier sales system, bulletin board mail It is possible to select from among the systems. In step S2, it is determined which system has been selected, and according to the selection, steps S3, S4,
S5, S6, S7, S8, S9, S10, S11, S1
Proceed to 2 to perform the processing of each system.

Hereinafter, each system in the procurement information system 13 will be described. [1. Electronic Component System] FIG. 3 is a block diagram showing a configuration of electronic component system 1 shown in FIG. The electronic component system 1 includes a web server 1001, an application server 1002, and a web database server 100.
3. Image server 1004, CD changer 1005, operation machine 1006, update database server 100
7 and a magnetic tape device 1008. The database server 1003 has a database 1a (FIG. 1).

The user's computer 31 is, for example, a standard personal computer serving as a client, and can access the electronic component system 1. The external database 1012 has electronic component specification information and catalog image information. The catalog image information is image information obtained by reading a catalog printed on paper with an image scanner. These pieces of information are provided to the electronic component system 1 via a CD-ROM or a network. The electronic component specification information is provided to the operation machine 1006.
The catalog image information is provided to the CD changer 1005.

An information source 1015 has recommendation information of electronic parts such as semiconductor parts and general electronic parts, and the information is supplied to the operation machine 10 via a floppy disk or a network.
06. The information source 1006 has quality certification information of electronic components such as semiconductor components and capacitors, and the information is supplied to the operation machine 1006 via a floppy disk or a network. Information source (HR department) 101
Reference numeral 7 has personnel data, and the data is supplied to the operation machine 1006 via a floppy disk or a network. The personnel data includes information on personnel changes, and the electronic component system 1 can automatically change the department to which the registered user belongs. If necessary, the registration of the changed user can be deleted. The semiconductor industry newspaper 1018 has market price information on semiconductors and liquid crystals in Japan, and the information is supplied to the operation machine 1006 via operator maintenance or a network. In addition, information on the replacement parts of the semiconductor being sold is stored in the operating machine 1 via a magnetic tape or a network.
006. The operation machine 1006 stores the information in the database 1 in the database server 1003.
Register in a. The personnel data supplied by the information source 1017 is supplied not only to the electronic component system 1 but also to other systems such as the raw material system 2.

The factory and production affiliate 1014 have inspection information, order schedule information, unit price history information, configuration information, product name information, substitute part information, general purchase inspection information, material master information, and the like. These information are stored in the data processing section 101
The data is processed in step 3 and supplied to a magnetic tape device 1008 by a magnetic tape cartridge. Note that a method of transferring data via a network may be used.
The operation machine 1006 registers the information in the cartridge read by the magnetic tape device 1008 in the database 1a in the database server 1003.

The above information is stored in the operation machine 1006
Is preferably provided online via a network. The operation machine 1006 requests the factory and the production affiliated company 1014 to investigate the part number or model number,
The survey result is received from the factory and the production affiliated company 1014, and the database 1 in the database server 1003 is
Register in a. The operation machine 1006 is the database 1
The update database server 1007 is requested to perform update processing of a. The update database server 1007 creates a data file accordingly, and
To supply. The operation machine 1006 updates the database 1a in the database server 1003.

The image server 1004 is a CD changer 1
The catalog image information read from the CD-ROM by 005 is supplied to the Web server 1001 and the application server 1002. The catalog image information can be registered in the database 1a in the database server 1003.

The computer 31 of the user makes various requests to the Web server 1001 and receives responses. The Web server 1001 makes various requests to the application server 1002 and receives the responses. The application server 1002 sends to the database server 1003
Make various requests and receive their responses. W
The eb server 1001 stores a computer program and performs a unified menu display for a user to select according to the computer program. The application server 1002 stores a computer program and operates the electronic component system 1 according to the computer program. Database server 1003
Has a database 1a and manages registration, deletion, update and search of the database 1a.

FIG. 4 is a schematic diagram showing the configuration of the database 1a in the database server 1003. The database 1a includes part number inspection result information 1aa, product order information 1ab, order schedule information 1ac, and procurement contact information 1
ad, part number-specific replacement information 1ae, master unit price information 1af of all departments, part quality certification information 1ag, recommended part information 1
ah, semiconductor and liquid crystal market price information 1ai, component specification information 1aj, component replacement information 1ak, original catalog information (catalog image information) 1al, exchange rate information 1
am, user information (user ID, password, department to which the user belongs, etc.) 1an, and security information 1ao.

FIG. 5 is a flowchart showing the processing of the electronic component system 1, and corresponds to the processing of step S3 in FIG. In step SAA1, the screen shown in FIG. 10 is displayed on the computer 31 of the user, and waits for the input of the user ID and the input of the password. The user can input a user ID in area 1101 of FIG. 10 and a password in area 1102. By allowing the user to input the user ID 1101 and the password 1102, security can be enhanced and login by an unauthorized person can be prevented.

As displayed in the display area 1105,
The following two measures are taken to enhance security. (1) If there is no access (login) for 90 calendar days, the access right (login right) is automatically deleted. In that case, it is necessary to submit a use application again when using the service. (2) The user must change the password once a month for security protection. The password can be changed by clicking the password change button 1104 with a mouse.

Note that these two processes for enhancing security are performed not only by the electronic component system but also by another system such as a raw material system. If the user clicks login button 1103 with a mouse, and if the entered user ID and password are correct, the user is logged in and proceeds to step SAA2.

At step SAA2, a menu screen shown in FIG. 11 is displayed. The display area 1111 displays what time the information is. Display area 1112 displays a login user ID (user ID).
Display area 1113 displays the date of login. Display area 1114 displays the logged-in IP address. Based on this IP address, it is possible to know which department the user is. These display areas 1112 to 11
With the display of 14, it is possible to specify the source when the screen is hard-copied, so that information leakage to the outside can be prevented. That is, since the information of the user who made the hard copy is displayed, there is an effect that the user hesitates to make a hard copy. Further, by displaying "this information is confidential to the company" in the display area 1115, it is possible to prevent the information from leaking outside.

The menu items 1116 include “1. Search by part number”, “2. Search by model name”, “3. External database information search”, “4. Search for parts (displaying alternative part numbers) ",
“5. Unit price master change information list”, “6. Unit price master history information search”, “7. Order schedule information search by part number”,
“8. Search for ordering information by model name”, “9. Information search for alternative parts on characteristics by model name”, “10. Search by price market of semiconductor and liquid crystal”, “61. Exchange rate information”, “ SU1. User maintenance "and" SU
2. Preference information "is displayed.

The user maintenance process refers to user information and log information registered in the database,
Register user information and security management. In the preference information processing, information necessary for operating the system is set. The display area 1117 displays the following two items to enhance security. (1) "Confirmation of confidentiality: Copying of information without permission is prohibited. Use by anyone other than registered employees is also prohibited." (2)
"Employment regulations sanctions: Procurement information system information is confidential. If leaked outside the company, you will be punished by internal regulations."

The user can select a desired item from the menu items 1116 described above. When the user selects an item, in step SAA3 of FIG. 5, it is checked which number the user has selected. When No. 1 is selected, a search process based on the part number is performed in step SAA4.
When No. 2 is selected, a search process based on the model name is performed in step SAA5. When No. 3 is selected, a search process for external database information is performed in step SAA6. When No. 10 is selected, a search process is performed in step SAA7 based on price prices of semiconductors and liquid crystals. If No. 61 is selected, step S
The exchange rate information is processed in AA8. If another number is selected, the process of the other number is performed in step SAA9. Hereinafter, details of each processing of steps SAA4 to SAA8 will be described.

FIG. 6 is a flowchart showing details of the search processing by the part number in step SAA4 shown in FIG.
In this process, an electronic component can be searched using a part number as a keyword. In step SAB1, the condition input screen shown in FIG. FIG.
In the second title area 1125, "(1) Search / condition input screen by part number" is displayed. Display area 111
1 to 1115 are the same as above. Display area 1126
Displays information of "owned part number / temporary unit price is not provided", masks the information according to the department to which the user belongs, and provides only predetermined information. For example,
By not providing the user of the development department with the information of the part number and the provisional unit price, it is possible to prohibit the trial calculation of the design and the estimate based on the information.

In the condition input area 1127, a part number, green certification in consideration of environmental problems (for example, presence or absence of harmful substances and presence or absence of recycling), recommended information (inventory status in the prototype section), purchase source, name of country of origin, item Product code (for example, a code indicating a semiconductor), supplier code (code for a store),
A user can input a supplier name, a maker code, a maker name, and how much or less than an acceptance unit price (local currency) for actually conducting a transaction. In addition to the part number, all or part of the above conditions can be input. Clicking the clear button 1129 with the mouse
The above conditions can be satisfied. Search
If button 1128 is clicked on with a mouse, it proceeds to step S
The process proceeds to step SAB3 via AB2, and an electronic component that satisfies the input condition is searched based on the database 1a. Thereafter, the process proceeds to Step SAB4. Note that the search button 1128 is not clicked and the buttons 1121 to 1
When 124 is clicked, the process proceeds to step SAB10.

Step SAB10 includes buttons 1121-
Reference numeral 1124 denotes processing when the button is clicked. When the menu button 1121 is clicked, step S in FIG.
Returning to AA2, the menu screen shown in FIG. 11 is displayed.
When the back page button 1122 is clicked, the screen returns to the previous screen display. When logout button 1123 is clicked, the procurement information system ends. When the mail button 1124 is clicked, transmission of a mail or confirmation of a received mail can be performed.

After the above search, in step SAB4,
The search result list screen shown in FIG. 13 is displayed. When the buttons 1121 to 1124 in FIG. 13 are clicked,
Proceed to step SAB10 via step SAB5,
The same processing as above is performed. Display areas 1111-111
5, 1126, the same display as above is performed. In the list display area 1135, information on, for example, seven electronic components is displayed as a search result. Specifically, the list display area 1135 includes a part number and dimensions determined by the company, a model name determined by the manufacturer, a manufacturer name, presence or absence of catalog image information, recommendation (prototype stock status), quality certification, and a base name ( Office name),
The business partner name (seller name), inspection date, inspection unit price, currency, inspection quantity, drawing number, correction number, process, and small order (parts order) are displayed. As for the quality certification, “go” is passed, “article” is passed conditionally, and “no” is not passed. When the catalog image information is "present", clicking the "present" portion with a mouse displays the catalog image information based on the database 1a (FIG. 4). The catalog image information is image information obtained by reading a catalog printed on paper with an image scanner.

There is a continuation to the right of the screen. When scroll bar switch 1137 is clicked on with a mouse, the screen scrolls to the left. If scroll bar switch 1138 is clicked on with a mouse, the screen scrolls to the right and a subsequent screen shown in FIG. 14 is displayed. List display area 11
In addition to the above, the window, the name of the country of origin, the type of product, and the function classification number are displayed in 35.

The seven electronic components in the list display area 1135 can be rearranged. First, sort item 11
For example, “part number” is selected as 32. Next, if rearrangement (sort) button 1133 is clicked on with a mouse, it is rearranged in list display area 1135 in the order of part numbers. Items other than the part number can be selected and rearranged as the rearrangement items.

When "detailed screen" is selected as link destination screen 1134 shown in FIG. 13 and button 1136 of electronic part number 6 is clicked on with a mouse, a step SAB5 is performed.
To the step SAB6, and retrieves detailed information of the electronic part number 6 based on the database 1a. Next, the process proceeds to step SAB7, where a screen of detailed information of the electronic part number 6 is displayed as shown in FIG. Note that not only the above “detailed screen” but also the link destinations 1151 to 1
The same item for linking to 154 can be specified.

The title area 1141 in FIG.
"(1) Search / detail screen by part number" is displayed. The display in the display areas 1111 to 1115 is the same as described above. In the part information area 1144, the part number, dimensions, process,
The part information including the drawing number, correction number, part name, model name, manufacturer name, country of origin, function classification, maintenance schedule, and abolition schedule is displayed. The specification information area 1145 displays specification information of an external database. If there is no specification information, it is displayed that there is no specification information as shown in FIG. When there is the specification information, for example, the specification information as shown in FIG. 25 is displayed. FIG.
Will be described later. The recommended product information area 1146 includes a recommended rank (prototype inventory status rank),
The box number and data registration date are displayed. The quality certification information area 1147 displays the quality certification, comments, functions, structure, and scale. There is a continuation below this screen.

When scroll bar switch 1142 is clicked on with a mouse, the screen scrolls up. If you click the scroll bar switch 1143 with the mouse,
The screen scrolls down to display the subsequent screen shown in FIG. In addition to the above, the following display is performed on the display screen. The green certification information area 1148 displays green certification information, certification date, and comments. Green certification information is judged based on the presence or absence of harmful substances and the presence or absence of recycling based on whether it is environmentally friendly or not. The acceptance / purchase unit price information area 1149 includes a base (office), a window, a small order (parts order), an inspection date, an inspection quantity, a master unit price indicating an estimated price for reference, an inspection unit price, an inspection amount, a currency, The unit price category, unit price condition, supplier, and item type are displayed. If the user belongs to the development department, the provisional unit price is not displayed for the above-mentioned reason.

As described above, the search speed can be improved by first displaying the list screen of the search results and then displaying the detailed screen of each electronic component. That is, a necessary display can be performed on the list screen as much as possible, and thereafter, a detailed screen of each electronic component can be displayed on a one-to-one basis.

In the link area 1150 to the sub screen,
There are four buttons 1150-1154. Button 115
When any of 0 to 1154 is clicked with the mouse,
The process advances to step SAB9 via step SAB8 to perform link processing. When the buttons 1121 to 1124 are clicked, the process proceeds to step SAB10 via step SAB8, and performs the same processing as described above.

FIG. 7 is a flowchart showing details of the link processing in step SAB9 shown in FIG. When first button 1151 in FIG. 16 is clicked on with a mouse, it proceeds to step SAC2 via the branch process in step SAC1, and searches for alternative component information based on database 1a. Next, in step SAC3, an alternative parts list screen shown in FIG. 17 is displayed.

FIG. 17 shows an alternative parts list screen. The title area 1161 displays "List of alternative component search results by part number". Display areas 1111 to 1115
Displays the same display as above. List display area 11
In 63, for example, alternative component information of two electronic components is displayed. As the alternative part information of the list display area 1163, a part number, a dimension, a supplier name, a base, an alternative part number, an alternative dimension, an alternative supplier name, an alternative type name, an alternative manufacturer name, a parent part number, a dimension, a parent drawing number Is displayed. By displaying the substitute component information, when the electronic component cannot be obtained or the like, it is possible to know which electronic component substitutes for the electronic component. In addition, by displaying the information of the parent part number and the parent drawing number, it is possible to know the product in which the electronic component is used.

The two electronic components in the list display area 1163 can be rearranged. First, sort item 11
As 61, for example, “part number” is selected. Next, if rearrangement (sort) button 1162 is clicked on with a mouse, it proceeds to step SAC5 via step SAC4 and performs electronic component rearrangement processing in the order of part numbers. Next, returning to step SAC3, list display area 1163
The list of electronic components after the sorting is displayed. Items other than the part number can be selected and rearranged as the rearrangement items. The buttons 1121 to 1124 in FIG.
Is clicked, the process proceeds to step SAC12 via step SAC4, and proceeds to step SAB10 in FIG.
The same processing is performed.

When second button 1152 in FIG. 16 is clicked on with a mouse, it proceeds to step SAC6 via the branch process in step SAC1 in FIG. 7, and searches for product / product information based on database 1a. Next, step SA
At C7, the product / product information screen shown in FIG. 18 is displayed.

FIG. 18 shows a product / product information screen. Title area 1171 includes “Product / Product Information (Product /
Product order) "is displayed. Display area 1111
At 1115, a display similar to the above is performed. In the product / product information display area 1172, for example, six pieces of product / product information on a desired part number (for example, WA5-0000-000) are displayed. Specifically, the product / product information display area 1172 displays an order number, an order name, supply, a base name, the number of members (the number of target parts), a model group, and a product group. By displaying the product / product information, it is possible to know which product or product the electronic component is used for. Then, the above step SAC
Then, the process proceeds to step S12, where the buttons 1121 to 1124 in FIG.

When third button 1153 in FIG. 16 is clicked on with a mouse, it proceeds to step SAC8 via the branch process in step SAC1 in FIG. 7, and searches for order schedule information based on database 1a. Next, step SAC
At 9, the order schedule information screen shown in FIG. 19 is displayed.

FIG. 19 shows an order schedule information screen. The title area 1181 includes “List of ordering information by part number”.
Is displayed. The same display as described above is performed in the display areas 1111 to 1115. Order schedule information display area 11
82, for example, a desired part number (for example, WA5-0000-
000) are displayed.
Specifically, the order schedule information display area 1182 displays a base name, a supplier name, a model name, a manufacturer name, a currency, a planned quantity and a planned amount for each year and month. By displaying the order schedule information, it is possible to know the order quantity and order amount of the electronic component for each future month. Thereafter, the flow advances to step SAC12 described above, and the buttons 1121 to 1 in FIG.
The process at 124 is performed.

When the fourth button 1154 in FIG. 16 is clicked on with a mouse, it proceeds to step SAC10 via the branch process in step SAC1 in FIG.
The search history information is searched based on. Next, step SA
At C11, the inspection history information screen shown in FIG. 20 is displayed.

FIG. 20 shows an inspection history information screen. Title area 1191 displays "accepted unit price history information (24 generations including the latest, temporary unit price is not displayed)". The same display as described above is performed in the display areas 1111 to 1115. In the inspection unit price history information display area 1192, for example, two pieces of inspection unit price history information on a desired company base (for example, A office), a desired part number (for example, WA5-0000-000), and a desired business partner (for example, AAA) are displayed. Is displayed. Specifically, the inspection unit price history information display area 119
In the column 2, the inspection date, the inspection unit price, the inspection quantity, the inspection amount, the drawing number, the correction number, the small order, and the currency are displayed. By displaying the inspection unit price history information, it is possible to know the transition of the past inspection unit price. Then, the above step SAC
Proceeding to step S12, the processing of the buttons 1121 to 1124 in FIG.

In the menu screen shown in FIG. 11, "2.
When "Search by type name" is selected, step S shown in FIG.
The process proceeds to the search process based on the model name of AA5, and a condition input screen shown in FIG. 21 is displayed. Title area 1201 in FIG.
Displays a "search / condition input screen by type name". The same display as described above is performed in the display areas 1111 to 1115. In the condition input area 1202, a model name, green certification information, recommended information, quality certification information, a maker code, a maker name, and purchased information can be input. In addition to the model name, all or part of the above conditions can be input. If clear button 1204 is clicked on with a mouse, the above conditions can be cleared. When search button 1203 is clicked on with a mouse,
An electronic component that satisfies the input condition is searched based on the database 1a, and the search result is displayed. Subsequent processing is the same as step SAA4 of the search processing by the part number.

The type name may be slightly different between the one created by the external database 34 (FIG. 1) and the one created by the in-house database. This is because the external database 34 uses the type name used in the catalog. In this case, the electronic information system 1 has the above-mentioned two types of type name information in the database 1a, and if there is a part of the leading digit, it is highly probable that the type names are the same. Is displayed as a candidate. Since the user only has to select one of these type name candidates that matches, the search load is reduced. At this time, those that do not match the in-house type name are only displayed.

In the menu screen shown in FIG. 11, "3.
When "external database information search" is selected, the process proceeds to the external database information search process of step SAA6 shown in FIG. FIG. 8 is a flowchart showing details of the external database information search processing in step SAA6 shown in FIG. In step SAD1, a large category selection screen shown in FIG. 22 is displayed. In the title area 1211 of FIG.
“(3) External database information search—major classification” is displayed. The major category selection menu 1212 includes “001. microcomputer”, “002. peripheral / interface”,.
・, “015. Optical element” and the like are displayed. The user can select one from the large category selection menu 1212. Buttons 1121 to 1124 or Button 121
When 3,1214 is clicked on with a mouse, a step S
The process proceeds to step SAD12 via AD2. Step S
In the AD 12, the same processing as described above is performed for the menu button 1121, the back page button 1122, the logout button 1123, and the mail button 1124. When help button 1213 is clicked on with a mouse,
Displays help to help the user. When a contact button 1214 is clicked, the contact information on the electronic component system and the contact information of the procurement department of each factory / production affiliate are displayed.

When the user selects, for example, “015. Optical element” from the large category selection menu 1212, the process proceeds to Step SAD3 via Step SAD2, and selects the intermediate category (part) of “Optical element” shown in FIG. Display the screen. By selecting the medium classification next to the large classification, the user can easily and quickly select a desired electronic component. In the title area 1221 of FIG. 23, “(3) External database information search—medium classification” is displayed. “01. Communication LED”, “0.
3. “Laser diode / array”,..., “07. Photointerrupter”, etc. are displayed. The user can select one from the middle category selection menu 1222. Button 1121 to 1124 or button 1213,
When 1214 is clicked on with a mouse, step SAD
Then, the process proceeds to step SAD12 via step 4, and the same processing as described above is performed.

When the user selects, for example, “07. Photointerrupter” from the middle category selection menu 1222, the process proceeds to Step SAD5 via Step SAD4, and a condition input screen of “Photointerrupter” shown in FIG. 24 is displayed. . In the title area 1231 of FIG.
"(3) Search / condition input screen by type name" is displayed. The same display as described above is performed in the display areas 1111 to 1115. In the condition input area 1233, a model name, a maker, an output format, a light receiving format, an input forward voltage, an input forward current, and the like can be input. The electronic component system is supplied with electronic component specification information search items from an external database, and creates a condition input screen with the specification information items as conditions. By inputting the condition of the specification information, the user can instruct a search for only electronic components that satisfy the condition.

If clear button 1235 is clicked on with a mouse, the above conditions can be cleared. When search (search) button 1234 is clicked on with a mouse,
The process proceeds to step SAD7 via step SAD6, and an electronic component that satisfies the above-mentioned input condition is searched based on the database 1a. Thereafter, the process proceeds to step SAD8.
The buttons 1121 to 1124 and 1213 in FIG.
When the button 1214 is clicked, the flow advances to step SAD12 via step SAD6, and the same processing as described above is performed.

In step SAD8, a search result list screen shown in FIG. 25 is displayed. Title area 12 in FIG.
41 displays “(3) List of external database search results (specifications)”. Display areas 1111-111
5 is displayed in the same manner as described above. The error display area 1232 displays an error content when an error occurs in the search result. For example, if no electronic component that meets the conditions is found, the error display area 1232 displays
"No data found" is displayed. In the total number display area 1242, the number (for example, 150) of electronic components (for example, photo interrupters) corresponding to the condition is displayed. The list display area 1246 displays the first six photo interrupters out of 150. Specifically, list information 1246 displays specification information such as model name, manufacturer, output format, light receiving format, input forward voltage, and input forward current. If previous list button 1243 is clicked on with a mouse, it displays a list before the currently displayed data. If next list button 1244 is clicked on with a mouse, the next list of currently displayed data is displayed. Enter the start number in the left column of the start number button
When 45 is clicked on with a mouse, a list is displayed from that number. If button 1247 of electronic part number 1 in list display area 1246 is clicked, it proceeds to step SAD10 via step SAD9, and searches for part information of electronic part number 1 based on database 1a. Thereafter, the process proceeds to step SAD11. The button 112 in FIG.
When 1 to 1124, 1213, and 1214 are clicked, the process proceeds to step SAD12 via step SAD9, and performs the same processing as described above.

In step SAD11, as shown in FIG. 26, a component information screen showing the search results is displayed. FIG.
In the title area 1251, "(3) List of external database search results" is displayed. Display area 1111
The display similar to the above is performed on to 1115. The error display area 1232, the total number display area 1242, the previous list button 1243, the next list button 1244, and the start number button 1245 are the same as described above. The link destination screen area 1134, the sorting area 1132, and the sorting (sort) button 1133 are the same as those shown in FIG. The list display area 1255 displays the same component information as the list display area 1135 shown in FIG. “Yes” area 1256 of the image in list display area 1255
Clicking with the mouse displays the catalog image information. When button 1257 of electronic part number 1 is clicked, as shown in FIGS.
Displays detailed part information. Then, step SAD1
Proceed to 2 to perform the same processing as above.

In the menu screen shown in FIG.
0. If you select "Search by semiconductor / liquid crystal price market",
The process proceeds to a search process based on the price of the semiconductor and the liquid crystal in step SAA7 shown in FIG. When the user specifies an item for semiconductor and liquid crystal, a semiconductor and liquid crystal price screen shown in FIG. 27 is displayed. Title area 1281 in FIG.
Displays "(10) Search / type list screen for semiconductor / liquid crystal prices". Display areas 1111 to 11
15 is displayed in the same manner as described above. In the price display area 1282, for example, the market prices of seven types of desired items (for example, item A) are displayed. In particular,
The type name, date, minimum market price, maximum market price, and price trend of each product are displayed. The price trend is displayed as rising or falling. When button 1283 of each type is clicked with a mouse, the past price history of the type is displayed. When the buttons 1121 to 1124 in FIG. 27 are clicked, the same processing as described above is performed.

In the menu screen shown in FIG.
1. When "exchange rate information" is selected, the flow proceeds to the exchange rate information processing in step SAA8 shown in FIG. FIG. 9 is a flowchart showing details of the exchange rate information processing in step SAA8. In step SAE1, a currency list screen shown in FIG. 28 is displayed. Title area 12 in FIG.
61, "(61) Exchange rate information / currency list screen"
Is displayed. The same display as described above is performed in the display areas 1111 to 1115. Currency list display area 1262
Displays the conversion source currency, conversion destination currency, rate, and year and month for each currency based on the database 1a. For example, one Australian dollar (AUD) is 86.04 yen (JPY). For example, if the button 1263 for the Australian dollar is clicked, the process proceeds to step SAE3 via step SAE2. Note that button 11 in FIG.
When clicking on 21 to 1124, step SA
The process proceeds to step SAE4 via E2, and performs the same processing as step SAB10 in FIG.

In step SAE3, a history screen of exchange rates shown in FIG. 29 is displayed. Title area 1271
"(61) Exchange rate information (monthly average-past 120
Monthly "is displayed. Display areas 1111 to 1115
Displays the same display as above. History display area 12
In 72, the history of the monthly average exchange rate from the Australian dollar to the Japanese yen for the past 120 months is displayed based on the database 1a. Thereafter, the flow advances to step SAE4 to perform the same processing as described above.

By displaying the exchange rate, it is possible to know the price when the electronic component is purchased locally, and to compare the case where the electronic component is purchased locally with the case where the electronic component is purchased in Japan. When displaying the unit price of the electronic component, both the price in the local currency and the price in Japanese yen can be displayed.

As described above, the electronic component system 1 can select an optimal electronic component in development design and the like. Users in the development department and the procurement department can search for desired electronic components quickly and easily. By providing the unit price information of the electronic component, the cost of the electronic component can be reduced.

[2. Raw Material System] FIG. 30 is a block diagram showing the configuration of the raw material system (raw material information providing system) 2 shown in FIG. Raw material system 2 is We
b server 2001, application server 2002,
Web database server 2003, operation machine 20
06 and an update database server 2007. The database server 2003 stores the database 2a
(FIG. 1). The user's computer 31 is, for example, a standard personal computer serving as a client, and can access the raw material system 2.

The information source 2011 has material contract information such as a maker code and a unit price.
6. The information source (personnel department) 2014 has personnel data, and the data is supplied to the operation machine 2006. The personnel data includes information on personnel changes, and the raw material system 2 can automatically change the department to which the registered user belongs. If necessary, the registration of the changed user can be deleted.

The factory and production affiliates 2013 include inspection information, order schedule information, raw material information constituting the product, product name information, resin (MO) material information, metal (PX) material information, inspection order schedule information, and color approval. Information, specification information, and the like. These pieces of information are supplied to the operation machine 2006.

The operation machine 2006 registers such information in the database 2a in the database server 2003. It is preferable that the above information be provided to the operation machine 2006 online via a network.

The operation machine 2006 has the database 2a
Is requested to the update database server 2007. The update database server 2007 creates a data file and supplies it to the operation machine 2006 accordingly. The operation machine 2006 updates the database 2a in the database server 2003.

The computer 31 of the user makes various requests to the Web server 2001 and receives the responses. The Web server 2001 makes various requests to the application server 2002 and receives responses. The application server 2002 sends a request to the database server 2003
Make various requests and receive their responses. W
The eb server 2001 stores a computer program and performs a unified menu display for a user to select according to the computer program. The application server 2002 stores a computer program and operates the raw material system 2 according to the computer program. Database server 2003
Has a database 2a and manages registration, deletion, update and search of the database 2a.

FIG. 31 is a schematic diagram showing the configuration of the database 2a in the database server 2003. The database 2a includes material price information 2aa, material purchase result information 2ab, product order information 2ac, and material usage (weight).
Results and forecast information 2ad, material price results information 2a
e, material price forecast information 2af, material specification information 2a
g, color approval information 2ah, user information (user ID, password, user section, etc.) 2ai, security information 2aj, and green certification information 2ak in consideration of environmental issues.

FIG. 32 is a flowchart showing the processing of the raw material system 2, and corresponds to the processing of step S4 in FIG. In step SBA1, the login screen shown in FIG. 42 is displayed on the computer 31 of the user, and waits for the input of the login name (user ID) and the input of the password. The user can input a user ID in area 2101 of FIG. 42 and can input a password in area 2102. By allowing the user to input the user ID 2101 and the password 2102, security can be strengthened and an unauthorized person can be prevented from logging in.

The user must change the password once a month for security protection. The password can be changed by clicking the password change button 2104 with a mouse.

If the user clicks login button 2103 with a mouse, and if the entered user ID and password are correct, the user is logged in and proceeds to step SBA2. In step SBA2, a menu screen shown in FIG. 43 is displayed. The display area 2111 displays what time the information is. Display area 2112 displays a login user ID (user ID). Display area 2
In 113, the date of login is displayed. By displaying these display areas 2112 and 2113, the source at the time of hard copy of the screen can be specified, so that information leakage to the outside can be prevented. As in the case of the electronic component system, an IP address may be displayed in addition to the user ID and the login date.

As menu items 2126, “1. material unit price information”, “2. material use information”, “3. material summary information”, “4. specification information”, “5. color approval information”, “I. .. user maintenance "and" II. Preference information "are displayed. Further, "1. material unit price information" is divided into "11-management unit price information", "12-management / real unit price information", "13-actual purchase unit price information", and "14-overseas unit price information". 2. Material usage information ”is“ 21
-Use information by part number "," 22-Material cost detail information by part number "
Divided into

The user maintenance process refers to user information and log information registered in the database,
Register user information and security management. In the preference information processing, information necessary for operating the system is set.

The user can select a desired item from the above menu items 2126. In this case, the user can select the MO button 2127 or the PX button 2128 by clicking with a mouse.
The MO button 2127 means a resin (MO) material.
The PX button 2128 indicates a metal (PX) material.
When the user selects an item, step SBA3 in FIG.
Now, check which number the user has selected.
If No. 1 is selected, material unit price information processing is performed in step SBA4. As shown in FIG. 33, the sub-classification is 1
If No. 1 is selected, management unit price information processing is performed in step SBA10, and if No. 12 is selected, step SBA11
When the management / substantial unit price information processing is performed and No. 13 is selected, the actual purchase unit price information processing is performed in step SBA12 and 1
If No. 4 is selected, overseas unit price information processing is performed in step SBA13.

In FIG. 32, when No. 2 is selected, material use information processing is performed in step SBA5. As shown in FIG. 34, if the sub-category 21 is selected, use information processing by part number is performed in Step SBA14, and if No. 22 is selected, detailed information processing of material cost by part number is performed in Step SBA15.

In FIG. 32, when No. 3 is selected, summary information processing for each material is performed in step SBA6. When No. 4 is selected, specification information processing is performed in step SBA7. When No. 5 is selected, color approval information processing is performed in step SBA8. If any other number is selected, step SB
In A9, the processing of the other numbers is performed. Hereinafter, step SB
Details of each process of A4 to SBA8 will be described. Hereinafter, a case where a resin (MO) material is selected will be described as an example, but the same applies to a case where a metal (PX) material is used.

FIG. 35 is a flowchart showing step SBA1 shown in FIG.
It is a flowchart which shows the detail of management unit price information processing of 0. In this process, it is possible to search for raw materials by inputting management unit price information as conditions. In step SBB1, FIG.
4 is displayed on the computer 31. In the title area 2136 of FIG. 44, “11. MO material management unit price information search screen” is displayed. Display areas 2112 and 2113 are the same as above.

In the search condition input area 2132, the user inputs the material symbol, maker code, maker name, grade number (model number of raw material), color identification, coloring number, in-house coloring number, and management unit price range. can do. In addition to the management unit price information, all or a part of the above conditions can be input. Material symbol button 21
When 31 is clicked, table data 2133 is displayed on the right. The table data 2133 displays a list of material symbols. The user can select, for example, the third “ABS” from the table data 2133.
Clicking the button of another item displays the table data of that item, and the user can select from the table data.

By clicking on condition clear button 2135 with a mouse, the above conditions can be cleared. If search button 2134 is clicked on with a mouse, it proceeds to step SBB3 via step SBB2, and searches for a raw material satisfying the above entered conditions based on database 2a. Thereafter, the process proceeds to step SBB4. Note that the search button 2134 is not clicked and the buttons 2121 to 2121 are not clicked.
When 125 is clicked, the flow advances to step SBB8 via step SBB2.

Step SBB8 is composed of buttons 2121 to 2
This is the process when 125 is clicked. As in the case of the above electronic component system, the menu button 2121
Is clicked, the process returns to step SBA2 in FIG. 32, and the menu screen shown in FIG. 43 is displayed. When back page button 2122 is clicked, the display returns to the previous display screen. When logout button 2123 is clicked, the procurement information system ends. Help button 212
When 4 is clicked, a help screen is displayed. When mail button 2125 is clicked, mail transmission or received mail confirmation can be performed.

After the above search, in step SBB4,
The search result list screen shown in FIG. 45 is displayed. Title area 2141 displays "11. MO material management unit price information". The display similar to the above is performed on the display areas 2112 and 2113. List display area 215
1 displays information on raw materials that satisfy the search conditions.
Specifically, the list display area 2151 includes a material symbol,
The maker code, maker name, grade number, color identification, coloring number, in-house coloring number, and management unit price are displayed.

The information in list display area 2151 can be sorted. Items are input to the first sort key 2143, the second sort key 2144, and the third sort key 2145. After that, if the ascending sort button 2146 is clicked, the information is sorted in ascending order, and the descending sort button 2146 is sorted.
Clicking on 47 sorts the information in descending order. For example, sorting can be performed in the order of material symbol, maker code, and grade number.

Further, the continuation of the information in list display area 215 can be displayed. Previous list button 2148
By clicking, you can display the material information of the previous number. When a next list button 2149 is clicked, the next number of raw material information can be displayed.
Enter a number in the area to the left of button 2150 and press button 2
When the user clicks 150, the raw material information can be displayed from that number. When the buttons 1121 to 1125 are clicked, the process proceeds to step SBB8 via step SBB5, and performs the same processing as described above.

For example, when button 2152 of material number 1 is clicked, step SBB is performed via step SBB5.
Proceeding to B6, the detailed information of the raw material number 1 is searched based on the database 2a. Next, the process proceeds to step SBB7, and a screen for detailed information of the raw material number 1 is displayed as shown in FIG.

In the title area 2155 of FIG.
“11. MO material management unit price detailed information” is displayed.
The display in the display areas 2112 and 2113 is the same as described above. The material information area 2158 displays a material symbol, a maker code, a maker name, a grade number, a color identification, a coloring number, and a company coloring number. Unit price history information area 2159 contains currency units, weight units,
The supplier limited type, the lot type, the execution date and the management unit price are displayed. The specification information area 2160 includes features, applications, fillers, processing methods (injection), flammability classes,
The sheet thickness, density, water absorption, tensile yield strength, tensile modulus, bending strength, etc. are displayed.

As described above, the search speed can be improved by first displaying the list screen of the search results and then displaying the detailed screen of each raw material. That is, necessary display is performed on the list screen as much as possible,
A detailed screen of each raw material can be displayed on a one-to-one basis.

Next, when a list screen button 2156 is clicked, the flow returns to step SBB4, and the list screen shown in FIG. 45 is displayed. If search button 2157 is clicked, it returns to step SBB1 and displays the search screen shown in FIG. In step SBB8, the button 21 is pressed.
When 21-21125 is clicked, the same processing as above is performed.

In FIG. 33, the management / substantial unit price information processing in step SBA11 can perform a search using the management unit price information and / or the substantive unit price information as a search condition. The search processing is the same as the management unit price information processing in step SBA10 described above. The actual purchase unit price information processing in step SBA12 can perform a search using the actual purchase unit price information as a search condition. The search processing is performed in step SBA1 described above.
This is the same as the management unit price information processing of 0.

On the menu screen shown in FIG.
When "overseas unit price information" is selected, the process proceeds to overseas unit price information processing in step SBA13 shown in FIG. FIG.
6 is a flowchart showing details of overseas unit price information processing in step SBA13 shown in FIG. In step SBC1,
The search screen shown in FIG. 47 is displayed. Title area 21
In the field 65, "14. MO material Overseas office actual purchase unit price information search" is displayed. Display areas 2112 and 2113
Is the same as above.

In the search condition input area 2166, a user can input a base code, a material symbol, a manufacturer name, a grade number, a color identification, a coloring number, and a company coloring number. In addition to the management unit price information, all or a part of the above conditions can be input.

By clicking on condition clear button 2168 with a mouse, the above conditions can be cleared. If search button 2167 is clicked on with a mouse, it proceeds to step SBC3 via step SBC2, and searches for raw material information of an overseas office satisfying the above entered conditions based on database 2a. Thereafter, the process proceeds to step SBC4. When the search button 2167 is not clicked and the buttons 2121 to 2125 are clicked, the process proceeds to step SBC8 via step SBC2. Step SBC8 is a process similar to the above when the buttons 2121 to 2125 are clicked.

After the above search, in step SBC4,
The search result list screen shown in FIG. 48 is displayed. Title area 2171 displays "14. MO material Overseas office unit price information". Display areas 2112 and 211
3 is the same as above. The list display area 2175 displays information on raw materials of overseas offices that satisfy the search conditions. Specifically, the list display area 2175 displays a management / actual purchase unit price, a base, a material symbol, a manufacturer name, a grade number, a color identification, a coloring number, and a company coloring number.

Information in list display area 2175 can be sorted. Information is sorted by inputting items into the first sort key 2143, the second sort key 2144, and the third sort key 2145, and then clicking an ascending sort button 2146 or a descending sort button 2147. Also, a previous list button 2148 and a next list button 2
149 and the start number button 2150 are the same as above. For example, when button 2174 of raw material number 1 is clicked, a search for the detailed information is performed, and a screen similar to the detailed screen shown in FIG. 46 is displayed. The search speed can be improved by first displaying the list screen of the search results and then displaying the detailed screen of each raw material.

When buttons 2121 to 2125 in FIG. 48 are clicked, step SBC5 is entered via step SBC5.
Proceed to step 8 to perform the same processing as described above. Search screen button 2
If 172 is clicked, the process returns to step SBC1 via step SBC5, and displays the search screen of FIG.
If exchange rate display button 2173 is clicked, it proceeds to step SBC6 via step SBC5, and searches for exchange rate information based on database 2a.

Next, at step SBC7, an exchange rate screen shown in FIG. 49 is displayed. Title area 2181
Indicates "14. MO material Overseas office unit price Exchange rate". The display in the display areas 2112 and 2113 is the same as described above. In the exchange rate area 2184, a currency unit and its exchange rate are displayed. For example,
The exchange rate for two periods when the unit price of the raw material is input can be displayed. By inputting the currency unit and the exchange rate, the exchange rate of each currency unit can be registered in the database 2a.

Next, when a list screen button 2182 is clicked, the flow returns to step SBC4, and the list screen shown in FIG. 48 is displayed. If search screen button 2183 is clicked, it returns to step SBC1 and displays the search screen shown in FIG. When the buttons 2121 to 2125 are clicked, the same processing as described above is performed in step SBC8.

On the menu screen shown in FIG.
When "-use information by part number" is selected, the process proceeds to use information by part number in step SBA14 shown in FIG. FIG.
35 is a flowchart showing details of part number-specific use information processing in step SBA14 shown in FIG. 34. Step SBD1
Then, a search screen shown in FIG. 50 is displayed. Title area 2191 contains "21. MO material part number usage information
Search screen "is displayed. Display areas 2112 and 21
13 is the same as above.

In the search condition input area 2192, a company code, a base division, a used part number, a supplier code, a supplier name, a material symbol, a maker code, a maker name, a grade number, a color identification, a coloring number, and an in-house coloring number are provided. Can be input by the user. In addition to the use part number, all or part of the above conditions can be input.

Clicking on a company code button 2196 displays table data 2193 on the right. The table data 2193 displays a list of company codes. The user can select a desired company code from the table data 2193. Clicking the button of another item displays the table data of that item, and the user can select from the table data.

By clicking on condition clear button 2195 with a mouse, the above conditions can be cleared. If search button 2194 is clicked on with a mouse, it proceeds to step SBD3 via step SBD2, and searches for raw material use information that satisfies the above entered conditions based on database 2a. Thereafter, the process proceeds to step SBD4. Note that the search button 2194 is not clicked and the button 21 is not clicked.
Steps SB when 21-2125 are clicked
The process proceeds to step SBD10 via D2, and performs the same processing as step SBC8 in FIG.

After the above search, in step SBD4,
The search result list screen shown in FIG. 51 is displayed. Title area 2201 displays “21. MO material part number use information”. Display areas 2112 and 2113
Is the same as above. In the list display area 2204,
Information on the use of raw materials that meet the search conditions is displayed. More specifically, in the list display area 2204, the company, base division, base, used part number, dimensions, process drawing number, supplier code,
The supplier name, material code, manufacturer code, manufacturer name, and grade number are displayed. Furthermore, when the screen is scrolled to the right, the display area 2204 displays the color identification, the coloring number, the in-house coloring number, the actual weight, the estimated weight, the actual amount, and the estimated amount.

The raw material use information in the list display area 2204 can be sorted. A first sort key 2143,
By inputting an item into the second sort key 2144 and the third sort key 2145 and then clicking the ascending sort button 2146 or the descending sort button 2147, the raw material use information is sorted. Also, the previous list button 214
8, next list button 2149, start number button 2150
Is the same as above. When buttons 2121 to 2125 are clicked, step SB is executed via step SBD5.
Proceed to D10 to perform the same processing as described above. For example, when the button 2203 of the raw material number 1 is clicked, a step S
The process proceeds to step SBD6 via BD5.

In step SBD6, the database 2a
, For example, the product information of the raw material of the raw material number 1 is searched. Next, in step SBD7, a product information screen shown in FIG. 52 is displayed. First, a list screen of search results is displayed, and then product information of each raw material is displayed, so that the product in which the raw material is used can be known.

In the title area 2211 of FIG. 52,
"21. MO material Product information screen" is displayed. The display in the display areas 2112 and 2113 is the same as described above. In the product information area 2215, product information in which the use part number specified above (for example, FA2-8225-000) is used is displayed. Specifically, the product information area 2215 displays an order number (product number), a base, an order name, the number of members, a product group, and a model group.

Next, when the buttons 2121 to 2125 are clicked, the process proceeds to step SBD1 via step SBD8.
The process proceeds to 0, and the same processing as above is performed. List screen button 2
When 212 is clicked, the process returns to step SBD4 via step SBD8, and the list screen shown in FIG. 51 is displayed. If search screen button 2213 is clicked, it returns to step SBD1 via step SBD8, and displays the search screen shown in FIG. When a material cost detail button 2214 is clicked, the process proceeds to step SBD8 through step SBD8.
Proceed to BD9, and perform material cost detail information processing by part number. This part number material cost detail processing is performed in step SBA shown in FIG.
This is the same as the processing of No. 15.

In the menu screen shown in FIG.
When "-part number-specific material cost detail information" is selected, the flow proceeds to part number-specific material cost detail information processing in step SBA15 shown in FIG. FIG. 38 is a flowchart showing details of the part number-specific material cost detail information processing in step SBA15 shown in FIG. 34 and step SBD9 shown in FIG. Step SBE
At 1, a search screen shown in FIG. 53 is displayed. The title area 2221 displays “22. MO material Part number material cost detail information search screen”. Display area 2112
And 2113 are the same as above.

The search condition input area 2223 includes a company code, a base division, a use part number, a supplier code, a supplier name, a material symbol, a maker code, a maker name, a grade number, a color identification, a coloring number, and an in-house coloring number. Can be input by the user. In addition to the use part number, all or part of the above conditions can be input.

As described above, the company code button 2222
When is clicked, table data 2224 is displayed on the right, and a desired company code can be selected. Clicking the button of another item displays the table data of that item, and the user can select from the table data.

By clicking on condition clear button 2226 with a mouse, the above conditions can be cleared. If search button 2225 is clicked on with a mouse, it proceeds to step SBE3 via step SBE2, and searches for material cost detail information that satisfies the above entered conditions based on database 2a. Thereafter, the process proceeds to step SBE4.
Note that the search button 2225 is not clicked, and the button 2225 is not clicked.
Steps S11 to S12125 when clicked
The process proceeds to step SBE10 via BE2, and performs the same processing as step SBC8 in FIG.

After the above search, in step SBE4,
The search result list screen shown in FIG. 54 is displayed. Title area 2231 displays “22. MO material Part number material cost detail information”. Display areas 2112 and 21
13 is the same as above. The list display area 2233 displays material cost detail information of the raw materials satisfying the search condition. Specifically, the list display area 2233 displays the company, base division, base, used part number, dimensions, process drawing number, supplier code, supplier name, material code, manufacturer code, manufacturer name, and grade number. Is done. further,
When the screen is scrolled to the right, a display area 2233 includes a color identification, a coloring number, an in-house coloring number, a weight classification, a material unit price, a material usage weight, a virgin rate (1 if no recycled material is contained), a defective rate, and a material. The management cost rate, other expenses, product weight, additional weight (weight of material necessary for parts other than the product), the number of pieces taken, the setup weight, and the molding lot are displayed.

The material cost detail information in the list display area 2233 can be sorted. A first sort key 2143,
If an item is input to the second sort key 2144 and the third sort key 2145 and then the ascending sort button 2146 or the descending sort button 2147 is clicked, the material cost detail information is sorted. Also, the previous list button 214
8, next list button 2149, start number button 2150
Is the same as above. When a search screen button 2232 is clicked, step SBE is performed via step SBE5.
1 and the search screen shown in FIG. 53 is displayed. If the user clicks the buttons 2121 to 2125, the process proceeds to step S
The process proceeds to step SBE10 via BE5 and performs the same processing as described above. Also, for example, the button 22 of the raw material number 1
When 34 is clicked, the flow advances to step SBE6 via step SBE5.

In step SBE6, the database 2a
, For example, the product information of the raw material of the raw material number 1 is searched. Next, in a step SBE7, a product information screen shown in FIG. 55 is displayed. By displaying product information of a raw material, it is possible to know a product in which the raw material is used.

In the title area 2241 of FIG.
“22. MO material Product information screen” is displayed. The display in the display areas 2112 and 2113 is the same as described above. The product information area 2245 displays product information in which the use part number specified above (for example, FA2-8225-000) is used. Specifically, the product information area 2245 displays an order number (product number), a base, an order name, the number of members, a product group, and a model group.

Next, when a list screen button 2242 is clicked, the flow returns to step SBE4 via step SBE8, and the list screen shown in FIG. 54 is displayed. When the search screen button 2243 is clicked, the process returns to step SBE1 via step SBE8, and displays the search screen shown in FIG. Clicking the buttons 2121-2125
Proceeding to step SBE10 via step SBE8,
The same processing as above is performed. When the usage information button 2244 is clicked, the process proceeds to step SB via step SBE8.
The process proceeds to E9, where part-specific use information processing is performed. This part number use information processing is performed in step SBA14 shown in FIG.
Is the same as the processing of

In the menu screen shown in FIG. 43, “3.
When "summary information by material (31-summary information by material)" is selected, the flow proceeds to the material summary information processing of step SBA6 shown in FIG.

FIG. 39 is a flowchart showing step SBA6 shown in FIG.
6 is a flowchart showing details of the material-specific summary information processing. In step SBF1, a search screen shown in FIG. 56 is displayed. Title area 2251 contains “31.MO
Material Summary information search screen by material "is displayed. Display areas 2112 and 2113 are the same as above.

In the search condition input area 2252, the user inputs a material code, a maker code, a maker name, a grade number, a color identification, a coloring number, an in-house coloring number, and a name of a site where the raw material is used. Can be. In addition to the material symbol, all or part of the above conditions can be input.

As described above, when the material symbol button 2253 is clicked, table data 2253 is displayed on the right, and a desired material symbol can be selected. Clicking the button of another item displays the table data of that item, and the user can select from the table data.

By clicking clear condition button 2256 with the mouse, the above conditions can be cleared. If amount button 2254 is clicked on with a mouse, it proceeds to step SBF3 via step SBF2, and searches for amount information of raw materials satisfying the above entered conditions based on database 2a. Thereafter, the flow advances to step SBF4 to display a price information screen shown in FIG. On the other hand, FIG.
If weight button 2255 of No. 6 is clicked on with a mouse, it proceeds to step SBF6 via step SBF2 and searches for weight information of raw materials satisfying the above-mentioned input conditions based on database 2a. Then, step SBF7
Then, the weight information screen shown in FIG. 58 is displayed. In addition,
When the buttons 2121 to 2125 in FIG. 56 are clicked, the process advances to step SBF9 via step SBF2, and performs the same processing as step SBC8 in FIG.

FIG. 57 shows a money amount information screen. Title area 2261 displays "31. MO material Summary information by material (amount)". The display in the display areas 2112 and 2113 is the same as described above. Amount information area 2
In H.264, information on the price of the raw material satisfying the search condition is displayed. Specifically, in the price information area 2264, a maker code, a material symbol, a grade number, a color identification, a coloring number, an in-house coloring number, a base, and a monthly amount (actual and predicted) of the used raw material are displayed.

The information in the money amount information area 2264 can be sorted. Information is sorted by inputting items into the first sort key 2143, the second sort key 2144, and the third sort key 2145, and then clicking an ascending sort button 2146 or a descending sort button 2147. Also, a previous list button 2148 and a next list button 2
149 and the start number button 2150 are the same as above. Also, when the search screen button 2262 is clicked,
Returning to step SBF1 via step SBF5, the search screen shown in FIG. 56 is displayed. Also, the weight button 22
When 63 is clicked, the flow advances to step SBF6 via step SBF5 to search for weight information, and the weight information screen of FIG. 58 described below is displayed. Button 2
Steps S11 to S12125 when clicked
The process proceeds to step SBF9 via BF5, and performs the same processing as described above.

FIG. 58 shows a weight information screen. Title area 2271 displays "31. MO material Summary information (weight) by material". The display in the display areas 2112 and 2113 is the same as described above. Weight information area 2
In 274, the weight information of the raw material satisfying the search condition is displayed. Specifically, in the weight information area 2274, a maker code, a material symbol, a grade number, a color identification, a coloring number, an in-house coloring number, a base, and the weight of the used raw materials (actual and predicted) are displayed every month.

Information in the weight information area 2274 can be sorted. Information is sorted by inputting items into the first sort key 2143, the second sort key 2144, and the third sort key 2145, and then clicking an ascending sort button 2146 or a descending sort button 2147. Also, a previous list button 2148 and a next list button 2
149 and the start number button 2150 are the same as above. Also, when the search screen button 2272 is clicked,
Returning to step SBF1 via step SBF8, the search screen shown in FIG. 56 is displayed. In addition, the amount button 22
When 73 is clicked, the flow advances to step SBF3 via step SBF8, and the above-described amount information search is performed.
7 is displayed. Note that buttons 2121 to 2112
When 2125 is clicked, the flow advances to step SBF9 via step SBF8, and the same processing as described above is performed.

On the menu screen shown in FIG. 43, “4.
When you select "Spec Information (41-Spec Information)"
The process proceeds to the specification information processing of step SBA7 shown in FIG. FIG. 40 is a flowchart showing details of the specification information processing in step SBA7 shown in FIG. In step SBG1, a search screen shown in FIG. 59 is displayed. Title area 2281 displays “41. MO material specification information search screen”. Display area 2112
And 2113 are the same as above.

In the search condition input area 2282, a material symbol, a maker code, a maker name, a grade number, a material management category, a filler, a processing method, a flammability class,
The user can input the hot runner results, MF test conditions, melt flow, characteristics, and use (for example, a copying machine). All or some of the above conditions can be entered.

When material symbol button 2283 is clicked, table data 2284 is displayed on the right, and a desired material symbol can be selected. Clicking the button of another item displays the table data of that item, and the user can select from the table data.

By clicking on condition clear button 2286 with a mouse, the above conditions can be cleared. If search button 2285 is clicked on with a mouse, it proceeds to step SBG3 via step SBG2, and searches for specification information of the raw material satisfying the above entered conditions based on database 2a. Thereafter, the process proceeds to step SBG4. When the buttons 2121 to 2125 are clicked, the processing proceeds to step SBG9 via step SBG2.
Then, the same processing as in step SBC8 of FIG. 36 is performed.

After the above search, in step SBG4,
The search result list screen shown in FIG. 60 is displayed. Title area 2291 displays “41. MO material specification information”. Display areas 2112 and 2113
Is the same as above. In the list display area 2293,
The specification information of the raw material satisfying the search condition is displayed.
Specifically, the list display area 2293 includes a material symbol,
Manufacturer code, manufacturer name, grade number, material management classification, filler, flammability class, etc. are displayed.

Information in list display area 2293 can be sorted. Information is sorted by inputting items into the first sort key 2143, the second sort key 2144, and the third sort key 2145, and then clicking an ascending sort button 2146 or a descending sort button 2147. Also, when the search screen button 2292 is clicked,
Returning to step SBG1 via step SBG5, the search screen shown in FIG. 59 is displayed. Button 2121
When the user clicks ２2125, the process advances to step SBG9 via step SBG5, and the same processing as above is performed.
Further, for example, when the button 2294 of the raw material number 1 is clicked, the process proceeds to step SBG6 via step SBG5.

At step SBG6, the database 2a
, For example, the detailed specification information of the raw material of the raw material number 1 is searched. Next, in step SBG7, a detailed specification information screen shown in FIG. 61 is displayed. First, a search result list screen is displayed, and thereafter, detailed information is displayed, so that detailed information is provided only when necessary, thereby improving the search speed.

The title area 2301 in FIG.
"41. MO material specification information detail screen" is displayed. The display in the display areas 2112 and 2113 is the same as described above. The detailed information area 2302 displays detailed specification information of the raw material specified above. Specifically, the detailed information area 2302 includes a material symbol, a maker code, a maker name, a grade number, a material management category, a filler, a processing method, a flammability class, a hot runner record, a feature, an application, and a sheet thickness. , Bending strength, bending elastic modulus and the like are displayed.

Next, when a management unit price information screen button 2303 is clicked, the flow advances to management unit price information processing in step SBA10 in FIG. Management / real unit price information screen button 23
When 04 is clicked, the flow proceeds to the management / substantial unit price information processing in step SBA11 in FIG. Search screen button 230
When 5 is clicked, the flow returns to step SBG1 via step SBG8, and the search screen of FIG. 59 is displayed. When list screen button 2306 is clicked, step SBG
Then, the process returns to step SBG4 via 8 to display the list screen shown in FIG. When the buttons 2121 to 2125 are clicked, the process advances to step SBG9 via step SBG8, and performs the same processing as described above.

On the menu screen shown in FIG. 43, “5.
When "color approval information (51-color approval information)" is selected, FIG.
The process proceeds to the color approval information processing in step SBA8 shown in FIG. The color approval is an approval as to whether or not each manufacturer can adopt as a unique color representing its own product, and only a color that has been determined to pass in the color approval can be adopted as a product.

FIG. 41 is a flowchart showing step SBA8 shown in FIG.
6 is a flowchart showing details of the color approval information processing of FIG.
In step SBH1, a search screen shown in FIG. 62 is displayed. Title area 2311 contains “51. MO material
"Color approval information search screen" is displayed. Display area 21
12 and 2113 are the same as above.

In the search condition input area 2312, the judgment report management number, material symbol, maker code, maker name, grade number, maker management number, color number, color name, judgment result, judgment date, supervisory department, attached data, Comments can be entered by the user. The user can input all or a part of the above search conditions.

When the material symbol button 2313 is clicked, table data 2314 is displayed on the right, and a desired material symbol can be selected. Clicking the button of another item displays the table data of that item, and the user can select from the table data.

By clicking on condition clear button 2316 with a mouse, the above conditions can be cleared. If search button 2315 is clicked on with a mouse, it proceeds to step SBH3 via step SBH2, and searches for color approval information of the raw material that satisfies the above entered conditions based on database 2a. Thereafter, the process proceeds to step SBH4. When the buttons 2121 to 2125 are clicked, the process advances to step SBH9 via step SBH2, and performs the same processing as step SBC8 in FIG.

After the above search, in step SBH4,
The search result list screen shown in FIG. 63 is displayed. Title area 2321 contains “51. MO material color approval information”.
Is displayed. Display areas 2112 and 2113 are the same as above. In the list display area 2327, color approval information of raw materials that satisfy the search condition is displayed. Specifically, the list display area 2327 includes the presence / absence of a comment, a judgment management number, a maker code, a maker name, a material symbol, a grade number, a maker management number, a color number, a color name, a judgment result, a judgment date, The department, attached data, etc. are displayed.

Information in list display area 2327 can be sorted. By inputting an item into the first sort key 2143, the second sort key 2144, and the third sort key 2145, and then clicking the ascending sort button 2146 or the descending sort button 2147, the information of the raw materials is sorted. The previous list button 2148, next list button 2149, and start number button 2150 are the same as described above.

By clicking the radio button 2328 of the raw material number, the raw material can be selected. After the selection, by clicking the next button, the processing for the selected raw material is performed. When comment screen button 2322 is clicked, step SBH5
To step SBH6, and retrieves the comment of the color approval information of the selected raw material based on the database 2a. Next, a comment screen shown in FIG. 64 is displayed in step SBH7. Also, a search screen button 232 in FIG.
When 3 is clicked, the flow returns to step SBH1 via step SBH5, and the search screen shown in FIG. 62 is displayed.
When the management unit price screen button 2324 is clicked, FIG.
The process proceeds to management unit price information processing in step SBA10. When the management / effective unit price screen button 2325 is clicked, FIG.
The process proceeds to management / substantial unit price information processing in step SBA11 of step 3. When actual purchase unit price screen button 2326 is clicked, it proceeds to actual purchase unit price information processing in step SBA12 of FIG.
When the buttons 2121 to 2125 are clicked, the process advances to step SBH9 via step SBH5, and the same processing as described above is performed.

FIG. 64 is a comment screen for color approval information. Title area 2331 includes "51. MO material
"Color approval information comment content" is displayed. Display area 2
The display of 112 and 2113 is the same as above. In the comment area 2332, a comment of the color approval information of the raw material specified above is displayed.

Next, when list screen button 2333 is clicked, control returns to step SBH4 via step SBH8, and the list screen shown in FIG. 63 is displayed. When search screen button 2334 is clicked, control returns to step SBH1 via step SBH8, and the search screen in FIG. 62 is displayed. When the management unit price screen button 2335 is clicked, the process proceeds to management unit price information processing in step SBA10 in FIG.
When management / substantial unit price information screen button 2336 is clicked, the flow proceeds to management / substantial unit price information processing in step SBA11 of FIG. When actual purchase unit price screen button 2337 is clicked, it proceeds to actual purchase unit price information processing in step SBA12 in FIG. Clicking the buttons 2121-2125
The process proceeds to step SBH9 via step SBH8, and performs the same processing as described above.

As in the case of the electronic component system, FIG.
Based on the green certification information 2ak in the database 2a, green certification information considering environmental issues can be displayed for each raw material. For example, green certification information is certified in consideration of environmental issues such as the presence or absence of harmful substances and the presence or absence of recycling. In addition, it is possible to display which product uses the raw material having the predetermined green certification information.

As described above, the raw material system can provide the raw material information to the user. For example, if each establishment uses materials that differ only slightly in color, it is possible to purchase raw materials at low cost by unifying the colors and purchasing large quantities of the same color materials at once. it can. Further, when a certain raw material becomes unavailable from the manufacturer, it is possible to check the stock of another business establishment and to order the raw material from another business establishment.

[3. Mechanical Component System] A mechanical component system 3 (FIG. 1) stores mechanical component information in a database 3a and provides mechanical component information to a user. The system content is the same as that of the electronic component system 1 described above. is there.

[4. All-number system] FIG.
1 is a block diagram showing a configuration of an all-number system (all-number information providing system) 4 shown in FIG. All number system 4 is W
eb server 3001, application server 300
2. It has a Web database server 3003, an operation machine 3004, and an update database server 3005. The database server 3003 is the database 4
a (FIG. 1). The user's computer 31 is, for example, a standard personal computer serving as a client, and can access the all-number system 4.

The computer 3011 of the production affiliate company
It has purchase (acceptance) result information, unit price history information, and order schedule information, and supplies these information to the operation machine 3004.
The personnel department computer 3012 has personnel data and supplies the personnel data to the operation machine 3004. The personnel data includes information on personnel changes, and the all-number system 4
The department to which the registered user belongs can be automatically changed. If necessary, the registration of the changed user can be deleted.

The operation machine 3004 registers the information in the database 4a in the database server 3003. It is preferable that the above information be supplied to the operation machine 3004 online via a network. The database server 3003 manages registration, search, deletion, and the like for the database 4a. The operation machine 3004, upon receiving the purchase result information and the like from the computer 3011 of the production affiliated company, updates the database 4a as necessary,
005. The conversion database 3005 creates an update data file and supplies it to the operation machine 3004. The operation machine 3004 updates the database 4a in the database 3003 accordingly.

The application server 3002 stores a computer program and operates the all-number system 4 according to the computer program. Web
The server 3001 stores a computer program,
A unified screen display is performed according to the computer program. The Web server 3001 makes various requests to the application server 3002 and receives responses. Application server 300
2 makes various requests to the database server 3003 and receives the responses.

The user's computer 31 is, for example, a standard personal computer serving as a client.
Make various requests to the eb server 3001,
You can receive that response. For example, the user's computer 31 can instruct the Web server 3001 to search and browse purchase result information and the like of a desired part number. The Web server 3001 searches the database 4a for purchase record information and the like via the application server 3002, and displays the purchase record information and the like on the screen of the computer 31 of the user. The user can quickly obtain desired purchase result information and the like.

FIG. 155 is a schematic diagram showing the structure of the database 4a. The database 4a includes purchase (acceptance) result information 4aa of all numbers, unit price history information 4ab, order schedule information 4ac, exchange rate information 4ad, user information (user ID, password, user affiliation section, etc.) 4ae, security information 4af.

FIG. 156 is a flowchart showing the processing of the all-numbering system 4, and corresponds to the processing of step S6 in FIG. In step SCA1, the login screen shown in FIG. 157 is displayed on the computer 31 of the user, and waits for the input of the user ID and the input of the password. The user can input a user ID in the area 3101 of FIG. 157 and can input a password in the area 3102. By inputting the user ID 3101 and the password 3102, security can be enhanced, and login by an unauthorized person can be prevented.

For security protection, the user can change the password by clicking on password change button 3104 with a mouse. If the user clicks login button 3103 with a mouse, and if the entered user ID and password are correct, the user is logged in and proceeds to step SCA2 in FIG. 156.

In step SCA2, a menu screen shown in FIG. 158 is displayed. The display area 3111 displays what time the information is. Display area 3112 displays a login user ID (user ID).
Display area 3113 displays the date of login. Display area 3114 displays the logged-in IP address. Based on this IP address, it is possible to know which department the user is. These display areas 3112 to 31
With the display of 14, it is possible to specify the source when the screen is hard-copied, so that information leakage to the outside can be prevented.

When menu button 3121 is clicked on with a mouse, this menu screen shown in FIG. 158 is displayed. When back page button 3122 is clicked on with a mouse, it returns to the previous display screen. Logout button 3
When 123 is clicked on with a mouse, the procurement information system ends. If information collection base button 3124 is clicked on with a mouse, it displays the collection status of purchase result information and the like for each base. When contact button 3125 is clicked on with a mouse, it displays the contact information of the support contact of all numbering system 4 (the contact of each procurement department). Mail button 3126
When is clicked, transmission of mail or confirmation of received mail can be performed.

As the selection menu item 3131, “1.
Purchase (acceptance) performance information (latest / history) search "," 2. Unit price history information (latest / history) search "," 3. Order schedule information search "," 4. Exchange rate information (latest / history) search " Is displayed. If No. 1 is selected, step SC in FIG.
Proceed to A4 to perform a purchase (acceptance) result latest information search process. In this process, the screen shown in FIG. 159 is displayed. 2
When the number is selected, the process proceeds to step SCA7 in FIG.
Perform unit price history latest information search processing. In this process, FIG.
The screen shown at 62 is displayed. When No. 3 is selected, FIG.
The process proceeds to step SCA10 of step 6, where order schedule information search processing is performed. In this process, a screen shown in FIG. 165 is displayed. When No. 4 is selected, step SCA12 in FIG.
Then, the latest exchange rate information list display processing is performed. In this process, a screen shown in FIG. 167 is displayed.

FIG. 159 is a flowchart showing the operation of step SC shown in FIG.
The screen displayed by the purchase (inspection) result latest information search processing of A4 is shown. The display of the display areas 3111 to 1114 and the buttons 3121 to 3126 are the same as described above. The search condition input area 3141 includes a part number, green certification information,
A model name (part number), procurement base, country of origin, item type code, supplier code, supplier name, maker code, maker name, and range of acceptance unit price (local currency) can be entered. By clicking on clear button 3144 with the mouse,
The above search conditions can be cleared. If search button 3143 is clicked on with a mouse after inputting search conditions, the latest purchase (acceptance) result information that satisfies the search conditions is searched for, and the flow proceeds to step SCA5 in FIG. 156. Step SC
In A5, a purchase (acceptance) result latest information list display process is performed. It should be noted that “reference” of each item of the condition input area 3141 is referred to.
If an area is clicked on with a mouse, it proceeds to step SCA3 in FIG. 156 and performs code help processing.

FIG. 169 is a flowchart showing the operation of step SCA3 in FIG.
2 shows a screen of another window displayed in the code help process of FIG. On this screen, an item type code or the like is searched and displayed, and input of the item type code in FIG. 159 is facilitated. In the search condition area 3251, a table (for example, an item type), a search item (for example, a code), a match type (for example, prefix match), and an input area (input of data serving as a search condition key) can be input. After input, when search button 3252 is clicked on with a mouse, items that satisfy the search conditions are displayed in search result area 3253. For example, in the search result area 3253, a list of item type codes and their names is displayed. If previous list button 3152 is clicked on with a mouse, it returns to search result area 325 at present.
The list before the list displayed in 3 is displayed. By clicking the next list button 3153 with the mouse,
A list next to the list displayed in the search result area 3253 is displayed. If a head number to be displayed is input to input box 3154 and button 3155 is clicked on with a mouse, a list from that head number is displayed in search result area 32.
Display at 53. If button 3254 of each item of the search result is clicked on with a mouse, that item is input to condition input area 3141 in FIG. 159 described above.

FIG. 160 is a flowchart showing the operation of step SCA5 in FIG.
The screen displayed in the purchase (acceptance) results latest information list display processing of the above is shown. The display of the display areas 3111 to 1114 and the buttons 3121 to 3126 are the same as described above. As a result of searching for the latest purchase (acceptance) result information that satisfies the above search conditions, if there is applicable information, the corresponding information is displayed in the search result area 3162. There is no. " In the search result area 3162, the date of inspection, unit price of inspection, currency, inspection quantity, country of origin, variety, functional classification, figure number,
In addition to the correction number, process, order, part number, dimensions, model name, manufacturer, presence / absence of image (use image of electronic component system 1), green certification information, recommendation, certification, base name, window,
View accounts. Previous list button 3152, Next list button 3153, Input box 3154, Button 315
5 is the same as above. To sort the display items in the search result area 3162, the first sort key 3156,
A second sort key 3157 and a third sort key 3158 can be input. Then, ascending sort button 315
If you click on the number 9 with the mouse, the sort keys 3156-3
When the latest purchase (acceptance) result information is sorted in ascending order using 158 as a key, and the descending sort button 3160 is clicked on with a mouse, the latest purchase (acceptance) result information is sorted in descending order using the sort keys 3156 to 3158 as keys and searched. It is displayed in the result area 3162.

On the link destination screen 3161, the link destination when clicking the number button 3163 of each purchase (acceptance) result latest information with the mouse can be selected. As the link destination, purchase (acceptance) result history information processing (FIG. 156)
Step SCA6), unit price history latest information list display processing (step SCA8), and order schedule information list display processing (step SCA10) can be selected. For example,
If purchase number history information processing is selected as link destination screen 3161 and number button 3163 is clicked on with a mouse, it proceeds to step SCA6 in FIG. 156 and proceeds to purchase (acceptance) result history information (history including the latest information) for that number Information) processing.

FIG. 161 is a flowchart showing the operation of step SC shown in FIG.
13 shows a screen displayed in A6 purchase (acceptance) result history information processing. The display of the display areas 3112 to 3114 and the buttons 3121 to 3126 are the same as described above. The display area 2111 may be displayed. History information area 31
Reference numeral 71 indicates green certification information in consideration of environmental issues, in addition to company base, window, part number, dimensions, process, item type, part name, supplier, processing destination code, manufacturer, model name, currency name, product code. And the inspection result history information is displayed. As the above green certification information, the certification category, certification name, certification date and comments are displayed. As the above-mentioned inspection result history information, the inspection unit price, inspection quantity, inspection amount, figure number, correction number, small order, order / order category / name, unit price category / name, set unit price condition, material Costs, processing costs,
The management fee, distribution cost, paid supply category / name, and paid payment amount are displayed. The user can know the inspection result history information of each part number (parts or raw materials).

FIG. 162 is a flowchart showing the operation of step SC shown in FIG.
9 shows a screen displayed in unit price history latest information search processing of A7. Display of display areas 3111 to 1114 and button 3
121 to 126 are the same as above. In the condition input area 3181, a part number, a model name, a procurement base, a supplier code,
You can enter the name of the supplier, the manufacturer code, the manufacturer name, and the range of the latest unit price history application date. If the "reference" area of each item is clicked on with a mouse, it proceeds to step SCA3 in FIG. 156 and displays the code help screen in FIG. 169 described above. Clear button 3 in FIG. 162
By clicking on 184 with the mouse, the above search conditions can be cleared. If search button 3183 is clicked on with a mouse after inputting search conditions, the latest unit price history information that satisfies the search conditions is searched, and step SCA in FIG.
Proceed to 8. In step SCA8, a unit price history latest information list display process is performed.

FIG. 163 corresponds to step SCA8 of FIG.
13 shows a screen displayed in the unit price history latest information list display processing. Display of display areas 3111 to 1114 and button 3
121 to 126 are the same as above. As a result of the search for the latest unit price history information that satisfies the above search conditions, if there is applicable information, the corresponding information is displayed in the search result area 3192. Is displayed. The search result area 3192 includes a part number, a dimension, a process, a drawing number, a switching date, a currency, a master unit price, a material cost, a processing cost, a management cost, a distribution cost,
Displays the quotation classification code, quotation classification name, company base, contact, supplier code, supplier name, current code, current name, correction number, order, model name, manufacturer name, and registration date. Previous list button 3152, Next list button 315
3, input box 3154, button 3155, sort keys 3156 to 3158, ascending sort button 3159, descending sort button 3160, and link destination screen 3161 are the same as above.

Inspection history information processing is selected as the link destination screen 3161, and the number button 3193 of each unit price history information is selected.
When the mouse is clicked, the step SCA in FIG. 156 is performed.
Then, the process proceeds to step S9, and unit price history information (history information including the latest information) for the number is processed.

FIG. 164 is a flowchart showing the operation of step SC shown in FIG.
13 shows a screen displayed in unit price history history information processing of A9.
Display of display areas 3111 to 1114 and buttons 312
1-3126 are the same as above. History information area 32
01, green certification information and unit price master history information in consideration of environmental issues, as well as company base, contact information, part number, dimensions, process, part name, supplier, processing code, manufacturer, model name, currency name, etc. indicate. As the above green certification information, the certification category, certification name, certification date and comments are displayed. The above unit price master history information includes a master unit price, a material cost, a processing cost, an administration cost, a logistics cost, an estimate classification code, an interim code, a drawing number, a correction number, an order, and a registration date for each switching day (every year). Is displayed. The user can know the unit price history history information of each part number (part or raw material).

FIG. 165 corresponds to step SC shown in FIG.
13 shows a screen displayed in order schedule information search processing of A10. Display of display areas 3111 to 1114 and button 3
121 to 126 are the same as above. A part number 3211 or a model name 3212 can be input as a search condition. If the clear button 3214 is clicked on with a mouse, the above search conditions can be cleared. If search button 3213 is clicked on with a mouse after inputting search conditions, order schedule information that satisfies the search conditions is searched.
The process proceeds to Step SCA11 of Step 6. In step SCA11, an order schedule information list display process is performed.

FIG. 166 corresponds to step SCA1 in FIG.
5 shows a screen displayed in order schedule information list display processing of No. 1. Display of display areas 3111 to 1114 and button 3
121 to 126 are the same as above. As a result of the search for the order schedule information that satisfies the above search conditions, if there is applicable information, the applicable information is displayed in the search result area 3221. The search result area 3221 displays a part number, a dimension, a process, a drawing number, a model name, a maker, a company base, a supplier name, a processing code, a currency, a planned quantity and a planned amount for each month. Previous list button 3152, Next list button 315
3, input box 3154, button 3155, sort keys 3156 to 3158, ascending sort button 3159, descending sort button 3160, and link destination screen 3161 are the same as above.

FIG. 167 is a flowchart showing the operation of step SC shown in FIG.
13 shows a screen displayed in the exchange rate latest information list display processing of A12. The display of the display areas 3111 to 1114 and the buttons 3121 to 3126 are the same as described above. The exchange rate list area 3231 displays, for each currency, a source currency, a destination currency, a rate, and a year and month based on the database 4a. For example, one Australian dollar (AUD) is 91.85 yen (JPY). If button 3232 of each currency is clicked on with a mouse, it proceeds to step SCA13 of FIG. 156 and performs exchange rate history information processing for that currency.

FIG. 168 is a flowchart showing the operation of step SC shown in FIG.
13 shows a screen displayed in the exchange rate history information processing of A13. Display of display areas 3111 to 1114 and button 3
121 to 126 are the same as above. In the exchange rate history area 3241, for example, the history of the exchange rate from the US dollar to Japan for each month is displayed. By displaying the exchange rate, it can be converted into Japanese yen based on the local price.

As described above, the all-number system 4 can provide the user with purchase (acceptance) result information, unit price history information, order schedule information, and exchange rate information. The purchase result information, the unit price history information, and the order schedule information can be displayed after searching by a desired key, and then only the corresponding information can be displayed.

[5. Cost Down Support System] FIG. 65 is a block diagram showing a configuration of the cost down support system (price information providing system) 5 shown in FIG. The cost reduction support system 5 includes a Web server 4001, an application server 4002, a Web database server 4003, and operation machines 4004 and 4006. The database server 4003 has a database 5a (FIG. 1).

At each base (office) 4011, a computer 4012 for storing price information of each base and a user's computer 31 are arranged. The computer 4012 at each site stores price information such as the inspection unit price of electronic components and mechanical components at its own site, and supplies it to the operation machine 4004. The user's computer 31 is, for example, a standard personal computer serving as a client, and can access the cost reduction support system 5.

The personnel department computer 4013 stores personnel data, and the data is supplied to the operation machine 4004. The personnel data includes information on personnel changes, and the cost reduction support system 5 can automatically change the department to which the registered user belongs. If necessary, the registration of the changed user can be deleted.

It is preferable that operation machine 4004 receives the above information online via a network. The operation machine 4004 receives the above information, performs processing for comparing the unit price of the electronic component and the mechanical component for each site, and supplies the operation machine 4006. The operation machine 4006 stores necessary information in the database server 4003.
In the database 5a.

The database server 4003 has a database 5a.
Manage updates and searches. Application server 40
02 stores a computer program, and operates the cost reduction support system 5 according to the computer program. The Web server 4001 stores a computer program, and performs a unified screen display according to the computer program. Web server 4
001 to the application server 4002
Make various requests and receive their responses. The application server 4002 makes various requests to the database server 4003 and receives the responses. The user's computer 31 is
Various requests are made to the server 4001 and responses are received. For example, the computer 31 of the user can download price information from the Web server 4001, edit the information, and upload the edited information to the Web server 4001. Web server 4001
Supplies the uploaded information to the operation machine 4006. The operation machine 4006 automatically sums up the price information of each base based on the information, and
Email to.

The user can know the price at which another site has purchased the same electronic component or mechanical component. In addition, it is possible to download information such as a purchase price at another base which is purchased at a cheaper price than the own base. The user
Based on the information, negotiation for cost reduction can be performed with the business partner. In addition, the negotiation results are
By uploading to the server 4001, the next negotiation strategy can be set.

FIG. 66 is a schematic diagram showing the structure of the database 5a in the database server 4003. The database 5a includes a part number 5aa, a process 5ab, a figure number 5ac, a supplier 5ad,
Inspection (purchase) date 5ae, total number of inspections 5af, inspection unit price 5
ag, exchange rate 5ah, cost reduction information 5ai, master information 5aj such as master (estimated) unit price, and user information (user ID, password, user affiliation section, etc.) 5a.
k and security information 5al.

FIG. 67 is a flowchart showing the processing of the cost reduction support system 5, and corresponds to the processing of step S7 in FIG. In step SDA1, FIG.
Is displayed on the computer 31 of the user, and waits for the input of the user ID and the input of the password. The user can input a user ID in the area 4101 of FIG. 68 and can input a password in the area 4102. By inputting the user ID 4101 and the password 4102, it is possible to enhance security and prevent an unauthorized person from logging in.

As shown in display area 4105,
The following two measures are taken to enhance security. (1) If there is no access (login) for 90 calendar days, the access right (login right) is automatically deleted. In that case, it is necessary to submit a use application again when using the service. (2) The user must change the password once a month for security protection. The password can be changed by clicking the password change button 4104 with a mouse.

If the user clicks login button 4103 with a mouse, and if the entered user ID and password are correct, the user is logged in and proceeds to step SDA2. In step SDA2, a list screen shown in FIG. 69 is displayed. The display area 4111 displays what time the information is. Display area 4112 displays a login user ID (user ID). Display area 41
13 displays the date of login. Display area 4114 displays the logged-in IP address. Based on this IP address, it is possible to know which department the user is. By displaying these display areas 4112 to 4114, the source when the screen is hard-copyed can be specified, so that information leakage to the outside can be prevented. That is, since the information of the user who made the hard copy is displayed, there is an effect that the user hesitates to make a hard copy. The display areas 4111 to 4114 can also be displayed in FIGS. 70 to 72 described later.

[0186] In the title area 4131, "List of cost down support data number" is displayed. In the list area 4133, inspection (purchase) data of a part number higher than the other bases and inspection data of a part number lower than the other bases are displayed for each company base. As each inspection data,
The number and type of parts are displayed. For example, a part number higher than that of the other bases in the B office indicates that there are 63 mechanical parts.

While pressing the shift key on the keyboard, the user presses the download button 4134 of the mechanical part, for example.
Is clicked on with a mouse, step SDA3 in FIG.
The process proceeds to step SDA4 via, and download processing is performed. By clicking the download button 4134 of the mechanical part, it is possible to download the inspection data at the other base with respect to the part number (part) of the mechanical part which is higher than the other base. By clicking the electronic component download button 4135, it is possible for the B office to download the inspection data of another base with the part number of the electronic component higher than the other base. By clicking the download button 4136 of the mechanical part, the B office can download the inspection data of the other part for the part number of the mechanical part which is cheaper than the other part. When electronic component download button 4137 is clicked, the B office can download the inspection data of the other part for the part number of the electronic component that is cheaper than the other part. For download, the Web server 4001 in FIG. 65 receives the inspection data from the operation machine 4006, and
From 01, the inspection data is downloaded to the user's computer 31 and stored.

FIG. 70 shows an inspection data screen displayed on the computer 31 after downloading. In the inspection data list area 4141, the company base 4141a, the part number 4141b for the part, the process 4141c, and the drawing number 4
141d, customer 4141e, acceptance date 4141f, and currency 4141g are displayed.

FIG. 71 shows the list area 414 shown in FIG.
It is an acceptance data screen following to the right of 1. List area 414
1 includes, in addition to the above items, the total number of inspections 4141h for the relevant part in the relevant month, the latest inspection unit price 4141i in the local currency, and the total amount of inspections in the local currency (total monthly amount) 41
41j, average exchange rate for the month (1 when currency 4141g is Japanese yen) 4141k, latest acceptance unit price in Japanese yen (latest acceptance unit price in local currency x average exchange rate) 4141l, total acceptance amount in Japanese yen (Total acceptance amount in local currency x average exchange rate) 4141m is displayed.

FIG. 72 shows the list area 414 shown in FIG.
It is an acceptance data screen following to the right of 1. List area 414
1 includes, in addition to the above items, the difference between the acceptance unit price in Japanese yen for the parts to be compared (the acceptance unit price of your business office-
The lowest acceptance unit price at other business establishments) 4141n, the difference in the total acceptance amount in terms of Japanese yen for the parts to be compared (the difference in the acceptance unit price x the total number of inspections) 4141o, the unit price after cost reduction in the local currency 4141p, input date 4141
q, Cost reduction negotiation result 4141r is displayed.

By referring to the difference 4141n in the inspection unit price and the difference 4141o in the total inspection amount, it is possible to know the difference between the inspection price of the own business and the inspection price of the other business. It is possible to determine whether it is worthwhile to negotiate cost reduction. When the cost reduction is negotiated, the user of each office inputs the unit price 4141p after the cost reduction, the input date 4141q, and the cost reduction negotiation result 4141r. Upon input, the flow advances to step SDA5 in FIG. 67 to perform input processing. In the cost reduction negotiation result 4141r, for example, if the negotiation has been established, enter, for example, “the price after the cost reduction will be applied from October 1998”. Enter a reason such as down failure. Each business establishment can formulate a strategy for the next cost reduction negotiation based on the negotiation result 4141r.

When the cost reduction negotiations are concluded, the user of each business establishment will receive the unit price 4141 after the cost reduction.
p is input, and the unit price 4141p after cost reduction and / or the cost reduction negotiation result 4141r are input.
Enter 141q.

When the display of list area 4141 ends, the process returns to step SDA2 in FIG. 67, and the list screen in FIG. 69 is displayed. If upload button 4132 in FIG. 69 is clicked on with a mouse, it proceeds to step SDA6 via step SDA3 in FIG. 67 and performs upload processing. That is, list area 414 shown in FIGS.
The inspection data of No. 1 is uploaded from the user's computer 31 shown in FIG. 65 to the Web server 4001.
The Web server 4001 receives the uploaded unit price after the cost reduction, the result of the cost reduction negotiation, and the like from the user's computer 31 and transfers them to the operation machine 4006.

Next, in step SDA7 of FIG. 67, the operation machine 4006 automatically totals the price information of each base based on the uploaded information and reflects it on the data of the next month and thereafter. The operation machine 4006 transmits the result of the aggregation to the user's computer 31 by e-mail.
Thereafter, the flow returns to step SDA2, and the list screen shown in FIG. 69 is displayed.

Referring to FIG. 69, menu button 412
1, back page button 4122, logout button 4
123, help button 4124, mail button 4125
Is clicked on with a mouse, step SDA3 in FIG.
To step SDA8 via. Menu button 41
When 21 is clicked, this list screen shown in FIG. 69 is displayed. When back page button 4122 is clicked, the display returns to the previous display screen. Logout button 41
When 23 is clicked, the procurement information system ends. When help button 4124 is clicked, a help screen is displayed. When mail button 4125 is clicked, mail transmission or received mail confirmation can be performed. These buttons 4121 to 4125 are shown in FIG.
72 can also be displayed on the acceptance data screen of FIG.

As described above, according to the cost reduction support system 5, when there is a variation in parts costs and product costs among offices, the cost difference of the same parts between offices is calculated by each business. Can be provided to the users of the office. Each business establishment can efficiently negotiate cost reductions of parts with business partners by obtaining information on the difference between costs with other business establishments. Also, by uploading the negotiation results, the next negotiation strategy can be effectively set.

The cost reduction support system 5
Can be applied not only to the past inspection price but also to the master (estimated) price. Further, the present invention can be applied to not only the price of parts but also the price of a product.

[6. Procurement record system]
Procurement record system (transaction record information providing system)
6 is a block diagram showing a configuration of FIG. Procurement record system 6
Are the Web server 5001 and the application server 5
002, a Web database server 5003, and an operation machine 5004. Database server 500
3 has a database 6a (FIG. 1).

Computer 5011 at each base (office)
Stores the inspection data (including the inspection amount) and the paid data (including the paid amount) of its own base, and supplies the data to the operation machine 5004. The inspection amount is the amount of purchased parts and the like. The paid amount is the purchase amount when the company purchases for a fee and delivers it to the business partner. Business partners are
For a variety of reasons, for example, the company may collectively purchase parts and the like from a plurality of business partners to reduce costs, supply parts and the like stably, and for a variety of reasons. In addition, the computers 5011 at each base can access the procurement record system 6.

The personnel department computer 5012 stores personnel data, and the data is supplied to the operation machine 5004. The personnel data includes information on personnel changes, and the procurement record system 6 can automatically change the department to which the registered user belongs. Also, if necessary,
The registration of the transferred user can be deleted.

It is preferable that operation machine 5004 receives the above information online via a network. The operation machine 5004 receives the above information, and stores the inspection data and the paid data in the database server 50.
03 is registered in the database 6a.

[0202] The database server 5003 has a database 6a.
Manage updates and searches. Application server 50
02 stores a computer program, and operates the procurement record system 6 according to the computer program. Web server 5001 stores a computer program, and according to the computer program,
Perform a unified screen display. The Web server 5001 makes various requests to the application server 5002 and receives responses. The application server 5002 makes various requests to the database server 5003 and receives the responses. The computer 5011 at each base is connected to the Web server 5
Various requests are made to 001 and responses are received. For example, the computer 5011 of the user at each base searches the inspection data or the paid data in the database 6a under predetermined conditions by using the Web server 5001.
To instruct. The application server 5002 searches for the acceptance data and the paid data in the database 6a under predetermined conditions, and performs a totaling process for the first half, the second half, and each year.
The Web server 5001 displays the result of the search satisfying the above conditions on the screen of the computer 5011 at each site.
The user at each site can know the inspection data and the paid data for each site, each business partner, or each item.

FIG. 74 is a schematic diagram showing the configuration of database 6a in database server 5003. The database 6a includes inspection data 6aa for each site / customer / item, paid data 6a for each site / customer.
b, user information (user ID, password, user section, etc.) 6ac and security information 6ad.

FIG. 75 is a flowchart showing the processing of the procurement record system 6, and corresponds to the processing of step S8 in FIG. In step SEA1, the login screen shown in FIG. 77 is displayed on the computer 5011 (FIG. 73) of the user, and the user waits for the input of the user ID and the input of the password.
The user can input a user ID in the area 5101 in FIG. 77 and can input a password in the area 5102. By inputting the user ID 5101 and the password 5102, it is possible to enhance security and prevent an unauthorized person from logging in.

As displayed in the display area 5105,
The following two measures are taken to enhance security. (1) If there is no access (login) for 90 calendar days, the access right (login right) is automatically deleted. In that case, it is necessary to submit a use application again when using the service. (2) The user must change the password once a month for security protection. The password can be changed by clicking password change button 5104 with a mouse.

If the user clicks login button 5103 with a mouse, and if the entered user ID and password are correct, the user is logged in and proceeds to step SEA2. At step SEA2, a menu screen shown in FIG. 78 is displayed. The display area 5111 displays what time the information is. Display area 5112 displays a login user ID (user ID). The display area 5113 displays the date of login. Display area 5114 displays the logged-in IP address. Based on this IP address, it is possible to know which department the user is. By displaying these display areas 5112 to 5114, the source when the screen is hard-copyed can be specified, so that information leakage to the outside can be prevented. That is, since the information of the user who made the hard copy is displayed, there is an effect that the user hesitates to make a hard copy. For a normal user, FIG. 79 is displayed instead of FIG. 78 after inputting the password.

As menu items, "I. Procurement record search", "II. User maintenance", and "III. Preference information" are displayed. If display button 5131 for procurement record search is clicked on with a mouse, it proceeds to step SEA4 in FIG. 75 and performs procurement record search processing. The procurement record search process searches for acceptance data or paid supply data that satisfies predetermined conditions, and performs a totaling process. If user maintenance update button 5132 is clicked on with a mouse, it proceeds to step SEA5 in FIG. 75 and performs user maintenance processing. The user maintenance process is performed in the database 6
Reference is made to user information and log information registered in a, and registration of user information and security management is performed. If preference information update button 5133 is clicked on with a mouse, it proceeds to step SEA6 of FIG. 75 and performs preference information processing. In the preference information processing, information necessary for operating the procurement record system is set.

When menu button 5121, back page button 5122, logout button 5123, or mail button 5124 is clicked on with a mouse, it proceeds to step SEA7 of FIG. 75 and performs other processing. When menu button 5121 is clicked, this menu screen shown in FIG. 78 is displayed. Back page button 5122
When is clicked, the screen returns to the previous display screen. When logout button 5123 is clicked, the procurement information system ends. When mail button 5124 is clicked, mail transmission or received mail confirmation can be performed.

FIG. 76 is a flowchart showing step SEA4 shown in FIG.
13 is a flowchart showing details of a procurement record search process. At step SEB1, a search screen shown in FIG. 79 is displayed. Display areas 5112 to 5114 and buttons 51
21 to 5124 are the same as above. The search screen includes a counting method selection area 5141, a condition input area 5142,
And a condition input auxiliary screen area 5143.

FIG. 80 shows the above-described totaling method selection area 51.
It is an enlarged view of 41. The user first selects a procurement result totaling method in the totaling method selection area 5141. As selection items, “A. Purchase results by item and window” and “B.
"Results of purchase by customer by item", "C. Results of purchase by customer by contact by item", "D. Results of purchase by contact by customer by item", "E. Results of purchase by customer by contact", " F. Purchase results by customer at each window (paid), G. Purchase results at each window by item, H. Purchase results by customer at each window,
"I. Purchase Results by Contact by Item by Contact", "J. Results of Purchase by Contact by Contact", "K. Purchase Result by Contact by Contact (Paid)", "L. Purchase by Item by Contact" Purchase Performance ",
"M. Purchase results by contact item per supplier" and "N. Purchase results by contact point per supplier and item" are displayed. By clicking the button 5151 of each item with a mouse, each item can be selected.

FIG. 81 shows the condition input area 5142 described above.
And an enlarged view of a condition input auxiliary screen area 5143.
In the condition input area 5142, the actual year, item type, supplier, target range, and target contact can be input. In addition to directly inputting these conditions, the condition input auxiliary screen area 5
143 can be used to enter a condition. For example,
When item type button 5161 is clicked on with a mouse, item type code and name are displayed in condition input auxiliary screen area 5143. This condition input auxiliary screen area 514
3, a desired product type can be selected. For example, when button 29 is clicked with a mouse in condition input auxiliary screen area 5143, condition input area 51
“M290” is automatically input as the 42 item types. The user can easily and easily input a condition item by using the condition input auxiliary screen area 5143. The condition input auxiliary screen area 5143 can also be used for the supplier condition. If condition clear button 5163 is clicked on with a mouse, conditions in condition input area 5142 can be cleared. If search button 5162 is clicked on with a mouse, it proceeds to step SEB2 in FIG. 76 and searches for procurement record (transaction record) information satisfying the above conditions. Thereafter, the flow advances to step SEB3 to display a search result screen shown in FIG.

FIG. 82 shows a search result screen. Display areas 5112 to 5114 and buttons 5121 to 5124
Is the same as above. The search result screen has a search condition display area 5171 and a search count result area 5172.

FIG. 83 shows the search condition display area 51 described above.
It is an enlarged view of 71. The counting method display area 5181 displays the counting method selected in the counting method selection area 5141 in FIG. In the search condition display area 5183,
The condition input in the condition input area 5142 of FIG. 81 is displayed. In the amount unit area 5183, the unit of the amount displayed in the search totaling result area 5172 of FIG. 82 is displayed.

FIG. 84 is a view showing the search result total area 5 of FIG.
FIG. 172 is an enlarged view of FIG. In the search totaling result area 5172, the amounts of the search results satisfying the above conditions are totaled and displayed for each base, each month, the first half, the second half, and the year. The amount is, for example, in units of 1000 yen. For example, the first half is 1
The month is from June to June, and the second half is from July to December. When the amount of money for each month is displayed in one horizontal line, one amount is displayed on one screen or one sheet of paper.
The whole amount of money for the year cannot be displayed, and it protrudes. The first half is displayed in the upper row, the second half is displayed in the lower row, and the amount for one year is divided into multiple rows and displayed. Can be easily compared.

When menu button 5121, back page button 5122, logout button 5123, and mail button 5124 in FIG. 82 are clicked on with a mouse, they can be clicked on FIG.
To step SEB4, and performs the same processing for each button as described above.

As described above, according to the procurement record system, procurement record (transaction record) information under predetermined conditions is searched,
Aggregate processing. The procurement record information includes the inspection amount and the paid amount. The user can make various trading strategies by referring to the total result. For example, by summarizing each business partner and calculating the business ratio of each business partner, create a strategy to disperse the business ratio in order to avoid the risk of concentration of business on a specific business partner Can be. In addition, the number of business partners can be increased or decreased based on the business ratio of each business partner. Further, by analyzing the time transition of the procurement results, future procurement can be predicted or adjusted.

FIG. 85 is a flowchart showing the processing of the procurement record data management system. This procurement record data management system is a system for managing procurement record data used in the above-mentioned procurement record system 6. In step SEC1, a menu screen shown in FIG. 86 is displayed. “Registration”, “maintenance”, “term end processing”, “print”, “log information”, and “end” are displayed as menu items. If registration button 5191 is clicked on with a mouse, it proceeds to step SEC3 in FIG. 85 and performs registration processing. The registration process registers results, paid performance, item type, and supplier information. If maintenance button 5192 is clicked on with a mouse, it proceeds to step SEC4 in FIG. 85 and performs maintenance processing. The maintenance process is
Perform maintenance of the company base table. If period end processing button 5193 is clicked on with a mouse, it proceeds to step SEC5 in FIG. 85 and performs period end processing. The term end processing deletes the performance and paid performance data and backs up the deleted data. Details of the term end processing will be described later with reference to FIG. If print button 5194 is clicked on with a mouse, it proceeds to step SEC6 in FIG. 85 and performs print processing. The printing process prints item type, company base, and supplier information. If log information button 5195 is clicked on with a mouse, it proceeds to step SEC7 in FIG. 85 and performs log information processing. The log information processing outputs or deletes log information. If end button 5196 is clicked on with a mouse, it proceeds to step SEC8 in FIG. 85 and ends the procurement record data management system.

FIG. 87 is a display screen for the end-of-term processing in step SEC5 described above.
3 is displayed by clicking the mouse. If all of the past procurement record data is stored in the database 6a, the amount of data increases, the search speed becomes slow, and the storage capacity of the database 6a becomes insufficient. Therefore, the procurement record data four years ago or earlier is deleted and backed up. The database 6a stores only procurement results data for the past three years. A first area 5207 and a second area 5208 are displayed on the term end processing screen.

By automatically displaying the year four years ago in the year column 5201, the procurement record data four years ago is deleted in principle and a text-format backup is taken.
In the year column 5201, another year may be input. Procurement record data is deleted on a yearly basis. Note that all of the procurement record data before a predetermined time may be deleted.
The first area 5207 displays a check box for deletion, the name of the data to be deleted, and the number of records. By clicking the deletion check column 5202 with a mouse, data to be deleted and backed up can be selected.
Specifically, acceptance data and / or paid data can be selected. In a second area 5208, a check box for selection, a name of data to be backed up in a text format, and the number of data are displayed. Selection check column 52
By clicking 03 with a mouse, data to be backed up can be selected. Specifically, supplier data, item type data, and / or company base name data can be selected.

Next, when the execute button 5205 is clicked on with a mouse, the data checked in the above-described deletion check box 5202 and selection check box 5203 is executed. By clicking setting button 5204 with a mouse, the path name of a file to be backed up can be set. If button 5206 is clicked on with a mouse, term end processing ends.

As described above, by performing the term-end processing, it is possible to delete and back up the procurement result data of the past four years or earlier, thereby increasing the free space of the storage device and improving the search speed. Can be.

[7. Customer Card Information System] FIG.
FIG. 2 is a block diagram showing a configuration of a supplier card information system (supplier card information providing system) 7 shown in FIG. The customer card information system 7 is a Web server 60
01, an application server 6002, a Web database server 6003, an operation machine 6004, and an image scanner 6005. The database server 6003 has a database 7a (FIG. 1).

[0223] The supplier 6011 writes the supplier information on the paper supplier card and provides it to the supplier card information system 7. The operation machine 6004 is an image scanner 6
005 reads the paper-based business card and
Format image information and convert it to a database server 6003
Is registered in the database 7a. In the database 7a, in addition to the image information of the supplier card, the supplier name and the like are also registered.

The personnel department computer 6012 stores personnel data, and the data is supplied to the operation machine 6004. The personnel data includes personnel change information, and the supplier card information system 7 can automatically change the department to which the registered user belongs. If necessary, the registration of the changed user can be deleted. It is preferable that operation machine 6004 receives the above-mentioned personnel data online via a network.

[0225] The database server 6003 has a database 7a.
Manage updates and searches. Application server 60
02 stores a computer program, and operates the supplier card information system 7 according to the computer program. Web server 6001 stores a computer program and performs a unified screen display according to the computer program. Web server 600
1 makes various requests to the application server 6002 and receives the responses. The application server 6002 is a database server 60
03, various requests are made, and the responses are received.

The user's computer 31 is, for example, a standard personal computer serving as a client.
Make various requests to the eb server 6001,
You can receive that response. For example, a search for a business partner card of a desired business partner can be instructed. The Web server 6001 searches for the supplier card of the supplier via the application server 6002 and the database server 6003, and displays the image information of the supplier card on the screen of the computer 31 of the user. A user in the company can instantly obtain a business partner card of a desired business partner.

FIG. 89 is a schematic diagram showing the structure of the database 7a in the database server 6003. The database 7a stores supplier information 602 for each supplier.
0, user information (user ID, password, user section, etc.) 7ah, and security information 7ai. The supplier information 6020 of each supplier includes, in addition to the image information 7ag of the supplier card, a supplier code 7aa, a supplier name 7ab, a supplier name (kana) 7ac, and a corporate code 7a.
d, card number 7ae, and registration year 7af.

FIG. 90 is a flowchart showing the processing of the supplier card information system, and corresponds to the processing of step S9 in FIG. In step SFA1, the login screen shown in FIG. 92 is displayed on the user's computer 31 (FIG. 88), and waits for the input of the user ID and the input of the password. The user can input a user ID in area 6101 of FIG. 92 and a password in area 6102. By inputting the user ID 6101 and the password 6102, security can be enhanced and login by an unauthorized person can be prevented.

For security protection, the user can change the password by clicking on password change button 6104 with a mouse. If the user clicks login button 6103 with a mouse, and if the entered user ID and password are correct, the user is logged in and proceeds to step SFA2.

In step SFA2, a menu screen shown in FIG. 93 is displayed. This is a screen that is not displayed to a normal user and is a screen that is displayed to an administrator. Display area 6111 displays the time of the information. Display area 6112 displays a login user ID (user ID). Display area 6113 displays the date of login. Display area 6114 displays the logged-in IP address. This IP
Based on the address, it is possible to know which department the user is. By displaying these display areas 6112 to 6114, the source when the screen is hard-copyed can be specified, so that information leakage to the outside can be prevented. That is, since the information of the user who made the hard copy is displayed, there is an effect that the user hesitates to make a hard copy.

As menu items, “I. Customer card information search”, “II. User maintenance”, “II.
I. Preference information "is displayed. If display button 6131 for supplier card information search is clicked on with a mouse, it proceeds to step SFA4 in FIG. 90 and performs supplier card information search processing. The supplier card information search process searches for and displays a supplier card that satisfies a predetermined condition. If user maintenance update button 6132 is clicked on with a mouse, it proceeds to step SFA5 in FIG. 90 and performs user maintenance processing. The user maintenance process refers to user information and log information registered in the database 7a, and registers user information and security management. If preference information update button 6133 is clicked on with a mouse, it proceeds to step SFA6 in FIG. 90 and performs preference information processing. In the preference information processing, information necessary for operating the supplier card information system is set.

When menu button 6121, back page button 6122, logout button 6123, or mail button 6124 is clicked on with a mouse, it proceeds to step SFA7 in FIG. 90 and performs processing for each button. When menu button 6121 is clicked, this menu screen shown in FIG. 93 is displayed. Back page button 612
When 2 is clicked, the display returns to the previous display screen. When logout button 6123 is clicked, the procurement information system ends. When the mail button 6124 is clicked, transmission of a mail or confirmation of a received mail can be performed.

FIG. 91 is a flowchart showing step SFA4 shown in FIG.
It is a flowchart which shows the detail of the supplier card information search processing of this. In step SFB1, a search screen shown in FIG. 94 is displayed. The display in the display areas 6112 to 6114 is the same as described above. In the condition input area 6141,
Year 6142, supplier code 6143, supplier name 614
4. A business partner name 6145 written in a pseudonym can be input. The supplier code 6143, the supplier name 6144,
It is not necessary to input all the business partner names 6145 written in pseudonyms, and it is sufficient to input any one of them. By clicking on condition clear button 6147 with a mouse, the above conditions can be cleared. A search button 6146 can be used to assist in the above condition input. If search button 6146 is clicked on with a mouse, a search result list 6152 is displayed on the right. List of search results 615
2 shows a list of supplier codes, supplier names, and supplier names in pseudonym notation. The user can search the search result list 61
A desired business partner can be selected from 52. Specifically, by clicking on a supplier code button 6153 with a mouse, the supplier code, supplier name, and pseudonym-supplied supplier name corresponding to the button are automatically displayed in the left condition input area 6141. Entered and displayed. The user can easily input a condition in the condition input area 6141 by selecting a business partner from the list 6152.

Next, button 6 of "view customer card"
When mouse 161 is clicked on with a mouse, it returns to step S in FIG.
In FB2, supplier card information satisfying the above conditions is searched, and in step SFB3, a supplier card browsing screen shown in FIG. 95 is displayed. On the other hand, if "logout" button 6162 in FIG. 94 is clicked on with a mouse, the procurement information system ends.

FIG. 95 shows a supplier card browsing screen.
The display in the display areas 6112 to 6114 is the same as described above. In the condition display area 6179, the supplier code, the supplier name, and the supplier name in pseudonym input on the condition input screen are displayed. In the center of the screen, an image 6181 obtained by reading a supplier card with an image scanner is displayed. The supplier card image 6181 is the supplier card image of the supplier input on the condition input screen. The supplier card contains the date of creation, creator, supplier code, company name, head office representative telephone number, fax number, head office location, capital, number of employees, representative, shareholder name, officer,
History, location map etc. are described. Since the business card contains a map of the location of the business partner,
It is highly valuable to provide users with image information obtained by reading a paper supplier card with an image scanner. Also, in consideration of the convenience of the paper medium, it is highly valuable to use the image information based on the paper medium. Further, the information of the supplier card may be received from the supplier through online communication of the computer. However, when there is a business partner who does not have computer communication facilities, a method of receiving a paper business card from the business partner is preferable.

In year area 6177, the year in which the supplier card was registered is displayed. The supplier card is updated every year by the supplier. Therefore, there may be multiple transaction cards for each supplier each year. When a year is entered in the year area 6177, an image 6181 of the supplier card for the entered year is displayed.
When another year is entered in the year area 6177, the process advances to step SFB5 via step SFB4 in FIG. Perform a card search. The reason will be described. When a plurality of supplier codes belong to one corporation code, that is, for example, when a plurality of establishments (suppliers) belong to one company (corporation), one supplier card is used for the plurality of suppliers. There are only cases. In addition, the organization of the office of the company may change. For example, as shown in FIG. 96, it is assumed that the company A (corporation) in 1997 had three business partners, the A business, the B business, and the C business. However, 1998
In the year, the establishment C may disappear and the establishment D may be newly established. That is, the company A in 1998 has three business partners, the A business, the B business, and the D business.
In this case, if the year is switched to 1997 while the supplier card of the D office in 1998 is displayed, the D office does not exist, which causes inconvenience. Therefore, in this case, the company code of the D office (A
Based on the company), the year was switched and a search was performed.
The customer card of company A for the year is displayed. After the search, the process returns to step SFB3 in FIG. 91 to display the supplier card.

In FIG. 95, a search screen button 617
1. When the first page button 6172, the previous page button 6173, the next page button 6174, the last page button 6175, the enlargement / reduction button 6176, and the logout button 6178 are clicked on with a mouse, the flow advances to step SFB6 via step SFB4 in FIG. , Processing of each button. When the search screen button 6171 is clicked, the flow returns to step SFB1 in FIG. 91, and the search screen in FIG. 94 is displayed. When the first page button 6175 is clicked, the first supplier card among all the supplier cards is displayed. Clicking the previous page button 6173 displays the supplier card of the previous page. When a next page button 6174 is clicked, a business card on the next page is displayed. When the last page button 6175 is clicked, the last supplier card among all the supplier cards is displayed. When an enlargement / reduction button 6176 is clicked, it is possible to switch between an enlarged display and a reduced display of the supplier card image 6181. Logout button 61
Clicking on 78 ends the procurement information system.

As described above, when starting a transaction, the supplier is required to describe and submit the contents of the supplier card.
If you want to continue the transaction, have your supplier card updated and submitted every year. These supplier cards are read by an image scanner, image information is generated, and registered in the database 7a. By using the supplier card information system, a user in the company can view the supplier card of the desired supplier and know the supplier information described in the supplier card. The supplier card is collectively managed by the supplier card information system 7, so that each user does not need to own it.

[8. Business Partner Map System] FIG.
FIG. 2 is a block diagram showing a configuration of a supplier map system (map information providing system) 8 shown in FIG. 1. The supplier map system 8 includes a Web server 7001, an operation machine 700
2 and a computer 7005 at each base. The operation machine 7002 includes the database 8a, the SQL server 7,
003 and a MapInfo server 7004.

[0240] The supplier 7011 supplies the supplier map system 8 with a survey table describing factory information (including information on the self (supplier) in charge of the factory). The computer 7005 at each base is, for example, a standard personal computer handled by a person in charge. The factory information in the above-mentioned survey table is input to the computer 7005 at each base, and factory information of electronic data is generated. The computer 7005 at each base supplies factory information to the operation machine 7002. In addition, business partner 70
11 may directly supply the operation machine 7002 with the factory information of the electronic data.

The SQL server 7003 registers the above factory information in the database 8a. The database 8a stores map information and loaned asset information in addition to factory information. Factory information and map information are stored in association with each other. That is, it is possible to know where each factory is located on the map. SQL Server 700
Reference numeral 3 manages registration and search of factory information and loaned asset information in the database 8a. The MapInfo server 7004 manages registration and search of map information in the database 8a.

The personnel department computer 7012 stores personnel data, and the data is supplied to the operation machine 7002. The personnel data includes information on personnel changes, and the supplier map system 8 can automatically change the department to which the registered user belongs. If necessary, the registration of the changed user can be deleted.

The operating machine 7002 stores a computer program, and operates the supplier map system 8 according to the computer program. Web server 7001 stores a computer program and performs a unified screen display according to the computer program. The Web server 7001 makes various requests to the operation machine 7002 and receives the responses. The operation machine 7002 is a computer 7 at each site.
Various requests are made to 005 and responses are received.

The user's computer 31 is, for example, a standard personal computer serving as a client.
Make various requests to the eb server 7001,
You can receive that response. For example, it is possible to instruct to search for a factory that has predetermined factory equipment and that is located near the establishment (factory) to which the user belongs. The Web server 7001 searches for a factory via the operation machine 7002, and displays factory information and map information of the factory on a screen of the computer 31 of the user. The user can quickly obtain factory information and map information of a desired factory.

FIG. 98 is a schematic diagram showing the structure of the database 8a. The database 8a includes factory information (including information on suppliers to which the factory belongs) 8aa, map information 8ab,
It has loaned asset information 8ac, user information (user ID, password, user affiliation, etc.) 8ad, and security information 8ae. The factory information 8aa and the map information 8ab are linked and stored. The factory information 8aa includes equipment information (information on manufacturing equipment, processing equipment, search equipment, and the like) for each type of business and each business partner, secondary processing equipment information, and external manufacturing equipment (customers after grandchildren).

FIG. 99 is a flowchart showing the processing of the supplier map system, and corresponds to the processing of step S10 in FIG. In step SGA1, the log-in screen shown in FIG. 100 is displayed on the user's computer 31 (FIG. 97), and waits for the input of the user ID and the input of the password. The user enters the user ID in area 7101 of FIG.
, And a password can be input in the area 7102. User ID 7101 and password 7102
, Security can be enhanced and unauthorized persons can be prevented from logging in.

For security protection, the user can change the password by clicking on password change button 7104 with a mouse. If the user clicks login button 7103 with a mouse, and if the entered user ID and password are correct, the user is logged in and proceeds to step SGA2. In step SGA2, a registration status display screen shown in FIG. 101 is displayed.

FIG. 101 shows a registration status display screen. In the map area 7131, a world map is displayed on the entire screen. Clicking an arbitrary point on the map with the mouse causes the zoom area 7 to be centered on the clicked point.
The map is enlarged and redisplayed with the zoom value input to 132. If you expand Japan, you can display a map of each prefecture. The zoom value is, for example, 500 to 42,000 km
It is. The total table 7133 displays the total number of factories by business type in each region displayed in the map area 7131. The type of business is, for example, a mold, a press, or the like. According to the zoom value, totals by country or by prefecture are displayed. The total value is displayed as a bar graph at a corresponding position on the map area 7131.

If search condition button 7134 is clicked on with a mouse, it proceeds to step SGA4 in FIG.
The search condition / result display screen shown in is displayed. Further, when route search button 7135 is clicked on with a mouse, it returns to FIG.
To step SGA10, and a route search (input) screen shown in FIG. 109 is displayed. If factory (processing destination) search button 7136 is clicked on with a mouse, it proceeds to step SGA3 in FIG. 99 and displays a factory (processing destination) search screen shown in FIG.

FIG. 102 shows the step SGA shown in FIG.
3 shows a factory (machining destination) search screen of No. 3; Factory name area 71
In 41, the name of the factory to be searched is entered in katakana. The factory is equivalent to a subcontracting factory of a business partner. Search button 71
If you click on 42 with the mouse, the factory name area 7141
For example, a search is made for the factory name input in the search result area 7144 by searching for a prefix. Search result area 7144
Displays a list of found factories. Specifically, the search result area 7144 displays a factory number, a factory name, a factory type, a factory address, a factory contact telephone number, a supplier code, and a supplier name. Here, the factory A (factory) corresponds to a subcontract factory of the factory B (customer).
That is, the relationship between the business partner and the subcontract factory can be known. If registration state display button 7143 is clicked on with a mouse, it returns to step SGA2 in FIG.
Display the registration status display screen.

FIG. 103 shows the step SGA shown in FIG.
4 shows a search condition / result display screen of No. 4. As search condition specification items, it is possible to specify a supplier specification 7151, a region specification 7152, a purchase base specification 7153, a business type specification 7154, a machine equipment (including manufacturing equipment and processing equipment) specification 7155, and a specification 7156 such as inspection equipment. it can. With these designations, the factories to be searched can be narrowed down. If not specified, all factories are searched.

In the supplier designation 7151, "No condition",
Either “supplier code” or “supplier name” can be specified. In the region designation 7152, "No condition"
Either "area designation" or "reference point designation" can be designated. “Region designation” can designate two regions by an OR condition. The "designation of reference point" can search for a factory located within a designated radius from the factory of the company serving as a reference. At this time, a scale (km) can be designated.

In the purchase base designation 7153, a purchase base can be designated. You can search based on the delivery record information. In the type of business designation 7154, the type of business can be specified. In the equipment designation 7155, the equipment and its specifications (equipment capacity) can be designated. Mechanical equipment includes manufacturing equipment and processing equipment. The specification of the mechanical equipment is, for example, the tonnage that can be molded in the resin molding injection molding equipment. In the designation 7156 of the inspection equipment or the like, the inspection equipment and other equipment can be specified.

When search start button 7157 is clicked on with a mouse, it performs search under the above designated conditions and displays a list of search results in search result area 7165 at the bottom. Note that when the search condition clear button 7158 is clicked on with a mouse, the above designated conditions are cleared and the help button 71158 is cleared.
If you click on 59 with the mouse, the step SGA in FIG.
Proceed to step 5 to display the help screen shown in FIG.

The search result area 7165 of FIG.
Factories that meet the above specified conditions are displayed. Specifically, the search result area 7165 displays radio buttons, factory numbers, supplier codes, Japanese / non-Japanese, supplier names, status, factory codes, factory names, factory locations, factory types, and industries. If Next button 7164 is clicked on with a mouse, it displays the next 10 factories after the currently displayed 10 factories. If the previous 10 factories exist, Prev
A button is displayed, and when the Prev button is clicked on with a mouse, the previous 10 factories are displayed.

If map display button 7160 is clicked on with a mouse, it proceeds to step SGA6 in FIG.
Is displayed. If the whole map display button 7161 is clicked on with a mouse, the process also proceeds to step SGA6, where the map display screen for full map display shown in FIG. 105 is displayed. Also, a factory information button 7162
Click on with the mouse to proceed to step SGA7,
The factory information screen shown in FIG. 106 is displayed. If route search button 7163 is clicked on with a mouse, it proceeds to step SGA9 and displays the route search (selection) screen shown in FIG.

FIG. 104 shows the step SGA shown in FIG.
5 shows a help screen. Step SG is displayed on the help screen.
A description of the search condition specification method on the search condition / result display screen (FIG. 103) of A4 is displayed. "Back" button 71
When mouse 70 is clicked on with a mouse, step SG in FIG. 99 is performed.
Returning to A4, the search condition / result display screen of FIG. 103 is displayed.

FIG. 105 shows the step SGA shown in FIG.
6 shows a map display screen of FIG. In map area 7171,
When the map display button 7160 or the entire map display button 7161 is clicked on the search condition / result display screen in FIG. 103, a map indicating the position of the corresponding factory is displayed. When the reference point is designated, the zoom point is displayed at a zoom value of 5 km around the reference factory. If a scale is designated, a circle is displayed on the designated scale centering on the reference factory. If no reference point is specified, a map is displayed with a zoom value of 5 km around the specified factory. When the entire map display button 7161 (FIG. 103) is clicked, all the found factories are displayed.

The zoom area 7174 contains, for example,
A zoom value can be input in a range of 5 to 40,000 km. When a scale is designated in the “designated area” of the search condition / result display screen in FIG. 103, the scale area 7175 displays the scale value. The map area 7171 displays the scale circle.

When an arbitrary point in the map area 7171 is clicked, a circle having a predetermined radius is displayed centering on the clicked point, and it is searched and displayed whether or not there is a factory in the circle. I do. When the factory is selected by clicking with the mouse, the process proceeds to step SGA7 in FIG. 99, and the factory information screen in FIG. 106 is displayed. On the other hand, when the factory is not selected, the map is redisplayed with the designated zoom value centering on the clicked location.

By clicking on “Return to initial display” button 7172 with the mouse, the above initial map area 71
71 is displayed again. If “search condition” button 7173 is clicked on with a mouse, it returns to step SGA4 in FIG. 99 and displays the search condition / results display screen in FIG. 103.

FIG. 106 shows the step SGA shown in FIG.
7 shows a factory information screen 7. The factory information screen includes a supplier overview 7181, a factory overview 7182, and factory equipment 7183.
Is displayed. The supplier summary 7181 includes the survey date, update date, supplier code, supplier name, Japanese / non-Japanese, membership / non-membership of the Global Cooperation Association, company status, postal code of head office,
Head office address, nationality, name of research office, capital, listing category, subcontract category, homepage URL, salesperson name, salesperson title, salesperson telephone number, salesperson FAX number, salesperson E-mail Is displayed.

The factory outline 7182 includes a survey date, an update date,
Factory Code, Factory Name, Factory Type, Japanese / Non-Japanese, Capital, Factory Postal Code, Factory Address, Factory Location, Factory Contact Phone Number, Number of Employees, Factory Contact FAX Number, Main Delivery Items, Industry, Delivery Record Is displayed.

The factory equipment 7183 includes equipment numbers, equipment types, machine types, specifications (tons for molds and presses, mm for grinds and headers), press machine specifications, machine equipment manufacturer names, machine models, Displays the number of equipment.

If search condition button 7184 is clicked on with a mouse, it returns to step SGA4 of FIG.
The search condition / result display screen of is displayed. If secondary processing button 7185 is clicked on with a mouse, it proceeds to step SGA8 in FIG. 99 and displays the secondary processing screen shown in FIG. 107.

FIG. 107 shows the step SGA shown in FIG.
8 shows a secondary processing screen of No. 8. On the secondary processing screen, a supplier outline 7191, a factory outline 7192, and a secondary processing and workable special material 7193 are displayed. The supplier summary 7191 displays the same items as the supplier summary 7181 shown in FIG. The factory outline 7192 displays the same items as the factory outline shown in FIG. The secondary processing and workable special material 7193 displays a secondary processing classification name (PX (press), PX material, etc.) and a secondary processing name (spot welding, arc welding, etc.). In the table, a mark “加工” indicates that there is a processing result in the own factory, a mark “△” indicates that there is a processing result only in other than the own factory, and a mark “◎” indicates that there is both processing results. If search condition button 7194 is clicked on with a mouse, it returns to step SGA4 in FIG. 99 and displays the search condition / result display screen in FIG.

FIG. 108 shows a step SGA shown in FIG.
9 shows a path search (selection) screen of No. 9; On the route search (selection) screen, a destination base 7201 and a departure base 7202 are displayed. In the case where “designation of reference point” is designated in the search condition / result display screen of FIG. 103, the destination is displayed in the destination base 7201. If "reference point designation" is not designated, a predetermined base name is displayed. In the departure base 7202, the total number of found factories (To
tal), a check box, a searched factory number (No), a type of business, a supplier code, a supplier code, a supplier name, and a factory name. In the destination base 7201, a desired destination base (for example, a company's factory) can be input or selected. By checking the above-mentioned check box for the departure base 7202, a desired departure base (customer subcontract factory) can be selected.

If route search button 7203 is clicked on with a mouse, it determines the check state of the above check box. If none is checked, an error message is displayed. If one or more is checked, an error message is displayed. Proceeding to step SGA11 in FIG. 99, the route display screen shown in FIG. 110 is displayed. On the other hand, if search condition button 7204 in FIG. 108 is clicked on with a mouse, it returns to step SGA4 in FIG. 99 and displays the search condition / result display screen in FIG. 103.

FIG. 109 shows the step SGA shown in FIG.
10 shows ten route search (input) screens. Route search (input)
The screen displays a route search (input) 7211 and a supplier code search 7214. In the route search (input) 7211, a destination base and a departure base (supplier code and factory code) can be input. The destination base and the departure base are the destination base 7201 and the departure base 72 shown in FIG.
Same as 02.

[0270] If route search button 7212 is clicked on with a mouse, it will display the destination base, supplier code,
A route is searched based on the factory code, and step SG in FIG.
The process proceeds to A11, and the route display screen of FIG. 110 is displayed. If registration status display button 7213 is clicked on with a mouse, it returns to step SGA2 in FIG. 99 and displays the registration status display screen in FIG. 101.

In the supplier code search 7214, either the supplier name 7215 or the supplier code 7216 is clicked, and the supplier name 7215 or the supplier code 7216 is entered. Next, when supplier search button 7217 is clicked on with a mouse, supplier name 7
A factory belonging to the supplier is searched based on 215 or the supplier code 7216 and displayed in the search result area 7218. This search result area 7218 displays a supplier code, a supplier name, a factory code, and a factory name as search results. By referring to the search result area 7218, the supplier code and the factory code of the route search (input) 7211 can be easily input.

FIG. 110 shows the step SGA shown in FIG.
11 shows an eleventh route display screen. In the map area 7221, a map is displayed with a zoom that displays all the target base factories and the respective departure base factories specified on the route search (selection) screen of FIG. 108 or the route search (input) screen of FIG. In the map area 7221, the route from each departure base factory to the destination base factory is displayed by a solid red line, and the route distance and the required time by car between them are displayed on the route.

In the zoom area 7224, for example, 0.5
A zoom value can be input in a range of up to 3,000 km. If an arbitrary point in map area 7221 is clicked on with a mouse, a map is displayed again with the zoom value input in zoom area 7224 centering on the clicked point.

[0274] If "Return to initial display" button 7222 is clicked on with a mouse, it returns to the initial display of map area 7221 before inputting the zoom value. The “search condition” button 7223 will be described. Step SGA in FIG. 99
When the screen transitions from the route search (selection) screen of No. 9 to the route display screen of step SGA11, the “search condition” button 722 is displayed.
If 3 is clicked on with a mouse, it returns to step SGA4 and displays the search condition / results display screen of FIG. 103. On the other hand, when the screen transits from the route search (input) screen of step SGA10 of FIG. 99 to the route display screen of step SGA11, if the "search condition" button 7223 is clicked on with a mouse, it returns to step SGA2 and the registration status display screen of FIG. Is displayed.

Next, the location information of the loan asset will be described. For example, a mold used for molding is a rental asset, which is lent to a business partner or a factory. For example, when a business partner or the like is going to go bankrupt, it is necessary to collect loaned assets. Therefore, it is important to grasp the location information of the loaned assets. Register the number of the mold (rental asset), the part number of the raw material used for the molding, the part number of the part completed by the molding, the factory code of the factory that performed the molding, and the supplier code of the business partner in the database 8a. By doing so, it is possible to retrieve the location information of the type and provide the user with the location on the map where the type is located. The user can immediately collect necessary rental assets based on the location information.

When a disaster such as an earthquake occurs,
The factories around it are likely to fail. In this case, by using the disaster occurrence point as a reference point and searching for a factory within a predetermined radius of the factory, information on a factory that may suffer damage can be found and countermeasures can be taken.

As described above, by linking the factory information (including the supplier information) and the map information and storing them in the database, the map information can be known based on the factory information. You can know factory information. For example, a factory search can be performed based on factory location information and factory equipment information, and a user can be notified of a factory that satisfies the search conditions. Further, a route from the departure base to the destination base is shown on a map, and the distance and the required time of the route can be notified.

[9. Supplier sales system] FIG.
FIG. 2 is a block diagram showing a configuration of a supplier sales system 9 shown in FIG. The supplier sales system 9 includes a Web server 8001, an application server 8002, and a Web server 8001.
b database server 8003, operation machine 800
4. It has a conversion database server 8005, a mail server 8006, and an administrator computer 8007. The database server 8003 is a database 9a
Having.

[0279] The computer 8011 of each supplier sends a use application form for the supplier sales system 9 to the administrator's computer 8007. Administrator's computer 8007
Provides (transmits) a setup program for selling based on the supplier selling system 9 to the trader's computer 8011 in response to the use application. By installing the setup program, the trader's computer 8011 can execute the self (business partner).
Can be transmitted to the operation machine 8004. The sales information is, for example, latest component information, substitute component information, person in charge information, and the like. When receiving the sales information, the operation machine 8004 registers the sales information in the database 9a in the database server 8003. When the operation machine 8004 receives the new sales information, the mail server 8006 notifies the user's computer 31 of the arrival of the latest sales information by e-mail.

The personnel department computer 8012 stores personnel data, and the data is supplied to the operation machine 8004. The personnel data includes personnel change information, and the supplier sales system 9 can automatically change the department to which the registered user belongs. If necessary, the registration of the changed user can be deleted.

The database server 8003 manages registration, search, deletion, and the like for the database 9a. When the operating machine 8004 receives the sales information from the computer 8011 of the business partner, the operation machine 8004 updates the database 9a as necessary, and updates the database 9a.
To instruct. The conversion database 8005 performs an update process, creates a log file, and requests the operation machine 8004 to transfer data. The operation machine 8004 updates the database 9a in the database 8003 accordingly.

The application server 8002 stores a computer program, and operates the supplier sales system 9 according to the computer program.
Web server 8001 stores a computer program and performs a unified screen display according to the computer program. The Web server 8001 makes various requests to the application server 8002 and receives responses. The application server 8002 sends a request to the database server 8003
Make various requests and receive their responses.

The user's computer 31 is, for example, a standard personal computer serving as a client.
Make various requests to the eb server 8001,
You can receive that response. The user's computer 31 searches, for example, desired sales information,
It is possible to instruct the Web server 8001 to browse. The Web server 8001 searches for sales information in the database 9a via the application server 8002, and stores the sales information in the computer 3 of the user.
1 is displayed on the screen. The user can quickly obtain desired sales information. The user's computer 3
1 is a computer 8 of a business partner based on the sales information.
It is possible to send an e-mail to 011 or access and display a business partner's homepage.

FIG. 112 is a schematic diagram showing the structure of the database 9a. The database 9a includes parts sales information 9aa, substitute parts information 9ab, approach information 9ac, sales information including staff information 9ad, user information (user ID, password, user affiliation section, etc.) 9ae and security information 9af. Having.

FIG. 113 shows a computer 801 of a business partner.
111 is a flowchart showing supplier sales information registration processing in FIG. 1 (FIG. 111). In step SHA1, FIG.
The menu screen shown in FIG. 14 is displayed. Menu items include “1. Electronic component information”, “2.
"3. Person in charge information" is displayed. If electronic component information registration button 8131 is clicked on with a mouse, it proceeds to step SHA2 in FIG. 113 and displays the component information registration screen shown in FIG. 115. In addition, the registration button 813 of the listening information
When mouse 2 is clicked on with a mouse, step SH in FIG. 113 is performed.
The process advances to A5, and an opening information registration screen shown in FIG. 118 is displayed. Further, when a registration button 8133 for contact information is clicked on with a mouse, a contact information registration screen shown in FIG. 119 is displayed. Then, when transmission button 8134 is clicked on with a mouse, the registered information of the above three items of sales information is transmitted from transaction computer 8011 of FIG. 111 to operation machine 8004. End button 813
If 5 is clicked on with a mouse, the process ends. In addition,
The above electronic component information is an example of component information, and can be applied to other component information such as mechanical components and raw material information.

FIG. 115 is a flowchart showing step SH shown in FIG. 113.
13 shows a part information registration screen of A2. On the part information registration screen, the part information 8141, the country of origin 8142, the schedule information 81
43, an introduction sentence 8144 can be registered. In the part information 8141, a title, a model name, a maker, and a function classification can be input. In the country of origin 8142, the country of the pre-process, the country of the post-process, the regulated material, and the product state can be input. In the schedule information 8143, a maintenance schedule, an abolition schedule, a sample schedule, and a specification schedule can be input. The flag 8145 indicates a progress flag (transmitted, transmission target, approval waiting, approval rejected) and a deletion flag. If the progress flag is set to “transmission target” and registered, the input information can be transmitted. Checking the delete flag and sending it allows the registered content to be deleted.

[0287] By clicking on input information clear button 8149 with a mouse, the above input information can be cleared. If you click the register button 8150 with the mouse,
The above input information can be registered. End button 8
If 151 is clicked on with a mouse, it returns to step SHA1 in FIG. 113 and displays the menu screen in FIG. 114.
If part number information button 8147 is clicked on with a mouse, it proceeds to step SHA3 in FIG. 113 and displays the part number information registration screen shown in FIG. If replacement information button 8148 is clicked on with a mouse, it proceeds to step SHA4 in FIG. 113 and displays a replacement information registration screen shown in FIG. 117.

FIG. 116 is a flowchart showing step SH shown in FIG. 113.
13 shows a part number information registration screen of A3. On the part number information registration screen, part information 8161, company internal number information 8162, product information 8163, and reference price / month 8164 can be registered. In the part information 8161, a title, a model name, a maker, and a function classification can be input. In the company internal number information 8162, a part number and dimensions can be input. In the product information 8163, a package, quality standard information, production information, delivery date information, delivery packing form, environmental consideration, currency, and unit of quantity can be input. Flag 8145
Indicates a progress flag (transmitted, transmission target, approval pending, approval rejected) and a deletion flag.

By clicking on input information clear button 8149 with a mouse, the above input information can be cleared. If you click the register button 8150 with the mouse,
The above input information can be registered. End button 8
If 151 is clicked on with a mouse, it returns to step SHA1 in FIG. 113 and displays the menu screen in FIG. 114.
If component information button 8146 is clicked on with a mouse, it returns to step SHA2 in FIG. 113 and displays the component information registration screen shown in FIG. 115. If replacement information button 8148 is clicked on with a mouse, it proceeds to step SHA4 in FIG. 113 and displays a replacement information registration screen shown in FIG. 117.

FIG. 117 is a flowchart showing step SH shown in FIG. 113.
13 shows a replacement information (substitute information) registration screen of A4. On the replacement information registration screen, component information 8171, replacement information 8172
Can be registered. In the part information 8171, a title, a model name, a maker, and a function classification can be input. In the replacement information (replacement information) 8172, a replaceable model name, manufacturer name, and replacement condition can be input. Traders can sell parts and products that can be replaced with parts and products from other manufacturers. The flag 8145 is a progress flag (transmitted, transmission target, approval waiting, approval rejected)
And a deletion flag.

By clicking input information clear button 8149 with a mouse, the above input information can be cleared. If you click the register button 8150 with the mouse,
The above input information can be registered. End button 8
If 151 is clicked on with a mouse, it returns to step SHA1 in FIG. 113 and displays the menu screen in FIG. 114.
If component information button 8146 is clicked on with a mouse, it returns to step SHA2 in FIG. 113 and displays the component information registration screen shown in FIG. 115. If part number information button 8147 is clicked on with a mouse, it proceeds to step SHA3 in FIG. 113 and displays the part number information registration screen shown in FIG.

FIG. 118 is a flowchart showing step SH shown in FIG. 113.
9 shows an A5 listening information registration screen. On the opening information registration screen, the opening information 8181 can be registered. In the listening information 8181, the information content, the target period, the title, the detailed content, the homepage address, and the information deletion desired date can be input. The above information content includes
In addition to the introduction of new products, company status / topics, periodicals / catalogs, exhibition / study conferences, latest technology information (specific technology), new equipment introduction, production / sales status, market trends (tightness, surplus parts) ), Select environmental assurance etc. (input)
can do. If the registration button 8150 is clicked on with a mouse, the above input information can be registered.
When end button 8151 is clicked on with a mouse, it returns to FIG.
Returning to step SHA1 of FIG. 3, the menu screen of FIG. 114 is displayed.

FIG. 119 is a flowchart showing step SH shown in FIG. 113.
14 shows an A6 person information registration screen. On the clerk information registration screen, the clerk information 8191, the responsible area and business 8192 within the company, the main handling item 8193 for the company, the handling maker 8194, and the comment 8195 can be registered. In the person in charge information 8191, the name of the person in charge, an e-mail (e-mail) address, a job title, a person in charge code,
Affiliation name, contact address, telephone number, FAX number, and homepage address can be entered. Flag 8
Reference numeral 196 denotes a transmission flag (transmission target, transmitted) and a deletion flag. If the registration button 8150 is clicked on with a mouse, the above input information can be registered. If end button 8151 is clicked on with a mouse, it returns to step SHA1 in FIG. 113 and displays the menu screen in FIG. 114.

FIG. 120 is a flowchart showing the processing of the supplier sales system 9 when the sales information is received from the supplier. In step SHB1, the operating machine 8004 (FIG. 111) receives the sales information registered and transmitted by the supplier. In step SHB2, operation machine 8004 stores database 9 in database 8003
The received sales information is registered in a. Step SHB
In 3, the operation machine 8004 is used every day by the computer 8007 (FIG. 111) of the administrator of the supplier sales system 9.
Then, an email is sent to notify how many sales information items have been received. The operation machine 8004 notifies the computer 31 (FIG. 111) of the user of the outline of the newly provided sales information by mail. Each user can specify the type of information received by email. For example, a person in charge of electronic components does not need information on mechanical components, and can receive only information on electronic components by mail. The user can know the outline of the latest sales information by the e-mail, and can know the details by accessing the supplier sales system 9 described below.

FIG. 121 is a flowchart showing the processing of the supplier sales system 9 when the user accesses. When the user's computer 31 (FIG. 111) accesses the supplier sales system 9, the supplier sales system 9 performs the following processing. In step SHC1, FIG.
The login screen shown in FIG.
(FIG. 111), and waits for the input of the user ID and the input of the password. The user can check the area 8201 in FIG.
, A user ID can be input, and a password can be input in an area 8202. By inputting the user ID 8201 and the password 8202, it is possible to enhance security and prevent an unauthorized person from logging in.

For security protection, the user can change the password by clicking on password change button 8204 with a mouse. If the user clicks login button 8203 with a mouse, and if the entered user ID and password are correct, the user is logged in and proceeds to step SHC2. In step SHC2, a menu screen shown in FIG. 123 is displayed.

FIG. 123 is different from FIG.
2 shows a menu screen. The display area 8111 displays the time of the information. Display area 8112 displays a login user ID (user ID).
Display area 8113 displays the date of login. Display area 8114 displays the logged-in IP address. Based on this IP address, it is possible to know which department the user is. These display areas 8112 to 81
With the display of 14, it is possible to specify the source when the screen is hard-copied, so that information leakage to the outside can be prevented. That is, since the information of the user who made the hard copy is displayed, there is an effect that the user hesitates to make a hard copy.

As menu items 8211, “1. Latest part sales information”, “2.
“3. Latest information on hearing” and “4. Latest information and information search for business partner person” are displayed. The user can select a desired item from these four items. When item No. 1 is selected, the process proceeds to step SHC3 in FIG. 121, where a component information list screen is displayed. If you select item 2
The flow advances to step SHC6 in FIG. 121 to display a substitute component information search screen shown in FIG. 126. When item No. 3 is selected, the process proceeds to step SHC9 in FIG. 121, and an approach information list screen shown in FIG. 129 is displayed. In item 4
"Contact Information Updates" and "Contact Information Updates"
When one of the two is selected, the process proceeds to step SHC12 in FIG.
The list screen or the business partner person search screen of FIG. 132 is displayed.

In step SHC3 of FIG. 121, a component information list screen is displayed. The component information list screen is similar to the list screen of FIG. 128 described later, and displays a list of component information. In the list screen, if the search button for parts information is clicked with a mouse, the process proceeds to step SHC4,
The component information search screen shown in FIG. 124 is displayed. Further, if a detail display button of predetermined component information is clicked on with a mouse, it proceeds to step SHC5 and displays a component information detail screen shown in FIG.

FIG. 124 is a flowchart showing step SH shown in FIG. 121.
13 shows a part information search screen of C4. Display area 8111-
The display of 8114 is the same as above. Menu button 8
When the button 121 is clicked, a menu screen shown in FIG. 123 is displayed. When back page button 8122 is clicked, the display returns to the previous display screen. When logout button 8123 is clicked, the procurement information system ends. When a mail button 8124 is clicked, transmission of a mail or confirmation of a received mail can be performed.

[0301] In the search condition input area 8221, the type of business,
Manufacturer code, manufacturer name, model name, function classification code,
You can enter the parts status, regulated supplies, country of origin of the previous process, country of origin of the post-process, supplier code, supplier name, company part number, and update date. By clicking "reference" of each item with a mouse, each item is searched and displayed, so that a desired item can be easily input. Clear button 8
By clicking on 223 with a mouse, the above input conditions can be cleared. If search button 8222 is clicked on with a mouse, it searches for component information that satisfies the above input conditions, proceeds to step SHC3 in FIG. 121, and displays a component information list screen. When a detailed display of predetermined component information is instructed on the component information list screen, the flow advances to step SHC5 in FIG. 121 to display a component information detailed screen shown in FIG.

FIG. 125 is a flowchart showing step SH shown in FIG. 121.
13 shows a component information detail screen of C5. Display area 8111-
The display 8114 and the buttons 8121 to 8124 are the same as above. In the detailed display area 8231 of the part information,
Title, model name, manufacturer, industry, function classification, information number, supplier name, supplier code, management department signature, name of person in charge, person in charge code, country of origin of the previous process, country of origin of the post process,
Displays the regulated supplies, product status, maintenance schedule, abolition schedule, sample schedule, specification schedule, introduction text, our company number, our dimensions, and package.

FIG. 126 is a flowchart showing step SH shown in FIG.
13 shows a substitute part information search screen of C6. Display area 811
The display of 1 to 8114 and the buttons 8121 to 8124 are the same as described above. In the search condition input area 8241, a type name to be replaced, a function classification code to be replaced, and a maker name to be replaced can be input. By clicking on clear button 8244 with a mouse, the above input conditions can be cleared. Search button 824
When mouse 3 is clicked on with a mouse, a search is made for a replacement part that satisfies the above input conditions, and the process proceeds to step SHC7, where FIG.
Is displayed.

If the "reference" area 8242 of the function classification code is clicked on with a mouse, it proceeds to step SHC16 in FIG. 121 and displays the code help screen shown in FIG. 127. In the condition input area 8251, a table, a search item, a match type, and a search keyword can be input. Thereafter, when search button 8252 is clicked on with a mouse, a function classification code or the like that satisfies the above input conditions is searched for and displayed. This facilitates input of a function classification code and the like. Items other than the function category code can also be searched.

FIG. 128 is a flowchart showing step SH shown in FIG. 121.
14 shows an alternative component information list screen of C7. Display area 811
The display of 1 to 8114 and the buttons 8121 to 8124 are the same as described above. The list area 8266 displays a list of alternative component information satisfying the above input conditions. Specifically, the list area 8266 includes an update date, a search type name,
Displays the function classification, manufacturer, model name of replacement part, manufacturer, etc. If previous list button 8261 is clicked on with a mouse, a list before the currently displayed alternative component information is displayed. If the start number of the alternative part information to be displayed is input in head number area 8262 and button 8263 is clicked on with a mouse, alternative part information is displayed from that start number. Input the sort item 8264 and press the sort button 8
If mouse button 265 is clicked on with a mouse, alternative component information is sorted and displayed in the order of the items. If button 8267 of each alternative part information is clicked on with a mouse, it proceeds to step SHC8 in FIG. 121 and displays the alternative part information detail screen similar to that in FIG. 125. The alternative part information detail screen is shown in FIG.
Is the same as the detail screen. Also, a search screen button 826
When mouse 8 is clicked with a mouse, step SH in FIG.
Returning to C6, the substitute component information search screen of FIG. 126 is displayed. The user can search for an advantageous part to replace the part currently used.

FIG. 129 is a flowchart showing step SH shown in FIG. 121.
14 shows an approach information list screen of C9. Display area 8111
8114 to 8114 and buttons 8121 to 8124 are the same as above. In a list area 8281, a list of listening information is displayed. Specifically, the list area 8281 includes the number of the listening information, the name of the person in charge, the update date, the type of business,
Title, business partner, information content, homepage address,
Display the target period (start date) and target period (end date).
Enter the sort item 8284 and press the sort button 8285
If you click on the mouse, you will sort and display the information about the items in that order. Clicking on a representative name area 8283 of each piece of incoming information with a mouse displays the contact information of the responsible person. Also, if the number button 8282 of each approach information is clicked on with a mouse, it proceeds to step SHC11 in FIG. 121 and displays the approach information detailed screen shown in FIG. 131. If search button 8286 is clicked on with a mouse, it proceeds to step SHC10 in FIG. 121 and displays an approach information search screen in FIG. 130.

FIG. 130 is a flowchart showing step SH shown in FIG. 121.
13 shows an approach information search screen of C10. Display area 811
The display of 1 to 8114 and the buttons 8121 to 8124 are the same as described above. In the condition input area 8271, the type of business,
You can enter the supplier code, supplier name, information content, title, and update date. By clicking on a “reference” area 8272 of each item with a mouse, FIG.
To the code help screen (FIG. 1)
27) is displayed. If clear button 8275 is clicked on with a mouse, the above input conditions are cleared.
If the search button 8274 is clicked on with a mouse after inputting the conditions, the search for the approach information that satisfies the above input conditions is performed, the process proceeds to step SHC9 in FIG. 121, and the approach information list screen in FIG. 129 is displayed.

FIG. 131 is a flowchart showing step SH shown in FIG. 121.
13 shows an approach information detail screen of C11. Display area 811
The display of 1 to 8114 and the buttons 8121 to 8124 are the same as described above. The detail display area 8291 displays the details of the predetermined listening information specified above. Specifically, the detail display area 8291 includes a supplier name, a supplier code, a department name, a management department code, a person in charge,
Contact person code, business type, information number, information content, homepage address, title, details, target period (start date),
Displays the target period (end date) and the desired date of deletion. As a general rule, the supplier sales system 9
The information of the listening is deleted from the database 9a. When search screen button 8292 is clicked on with a mouse, it returns to FIG.
The process returns to step SHC10 of FIG. 1 to display an approach information search screen shown in FIG.

FIG. 132 is a flowchart showing step SH shown in FIG. 121.
14 shows a contact person search screen of C12. Display area 81
The display of 11 to 8114 and the buttons 8121 to 8124 are the same as described above. In the condition input area 8301, a business type, a business partner code, a business partner name, a manufacturer code, and a manufacturer name can be input. When a “reference” area 8302 of each item is clicked with a mouse, FIG.
The process proceeds to step SHC16 of step 1 to display a code help screen (FIG. 127). If clear button 8304 is clicked on with a mouse, it clears the above input conditions.
Also, when search button 8303 is clicked on with a mouse,
The system searches for contact person information that satisfies the above input conditions, proceeds to step SHC13 in FIG. 121, and displays the contact person list screen shown in FIG. 133.

FIG. 133 is a flowchart showing step SH shown in FIG. 121.
15 shows a contact person list screen of C13. Display area 81
The display of 11 to 8114 and the buttons 8121 to 8124 are the same as described above. The list area 8311 displays a list of supplier contact information that satisfies the above input conditions. Specifically, the list area 8311 displays the number of the contact person information, the update date, the supplier code, the supplier name, the type of business, the person in charge, the telephone number, the e-mail address, and the manager mark. I do. If e-mail address area 8313 of each person in charge information is clicked on with a mouse, it proceeds to step SHC17 in FIG. 121 and can transmit e-mail to the e-mail address. Clicking on the number button 8312 of each person in charge information with the mouse, FIG.
The process then proceeds to step SHC14, where the supplier contact details screen shown in FIG. 134 is displayed. Also, a search screen button 831
If mouse button 4 is clicked, step SH in FIG. 121 is performed.
The process returns to C12, and displays the supplier contact search screen shown in FIG.

FIG. 134 is a flowchart showing step SH shown in FIG. 121.
15 shows a contact person details screen of C14. Display area 81
The display of 11 to 8114 and the buttons 8121 to 8124 are the same as described above. The detail display area 8321 displays the details of the predetermined person in charge information specified above. Specifically, the detail display area 8321 includes the type of business, business partner name, business partner code, department name, management department code, person in charge title, manager mark, person in charge name, address, zip code, and telephone number. , Fax number, e-mail address, homepage address, responsible district or office, main products handled,
Displays the manufacturer, comment, update date, and participation application date. If e-mail address area 8322 is clicked on with a mouse, it proceeds to step SHC17 in FIG. 121 and
An e-mail can be sent to the e-mail address. If homepage address area 8323 is clicked on with a mouse, it proceeds to step SHC15 in FIG. 121 and displays the homepage at that homepage address. If search button 8324 is clicked on with a mouse, it returns to step SHC12 in FIG.
A 32 contact person search screen is displayed.

[0312] As described above, the supplier can actively sell to the supplier sales system 9.
The employee of the company having the supplier sales system 9 can browse the sales information from the supplier irrespective of time and distance restrictions. In addition, by sharing sales information, valuable information resources can be used meaningfully. In addition, employees of the company can know the latest trends and information and perform preemptive activities without going to business partners. The supplier sales system 9 also supports the sales activities of the suppliers, and the suppliers can register and transmit the sales information to provide the information to all the employees at once.

When information indicating that a part is to be discontinued is received, if the information is provided to the design drawing creation database of the design department in the company, the part will not be used in the future. Thus, the part can be deleted from the design target.

[0314] The above-mentioned sales information can be applied not only to parts information but also to raw material information and product information. In the above description, the homepage address of the supplier is displayed, and when the address is specified, the homepage of the address is displayed. However, if the corresponding product guide is available on the homepage of the supplier, the product guide is displayed. Is displayed, and by specifying the address, a home page such as a product guide indicated by the address can be displayed.

Further, it is possible to register information via the Internet for places where there is a transaction with the company (contract: yes) and places where there is no transaction yet. Furthermore, at the time of registration, it is possible to specify to whom the company wants to send (by business division, etc.). On the Internet, a supplier card information system, a supplier map system, a part or product model name, manufacturer information, environmental information, and the like can also be registered, changed, and deleted.

[10. Bulletin board mail system] FIG. 135
2 is a block diagram showing a configuration of the bulletin board mail system 10 shown in FIG. The bulletin board mail system 10 uses We
It has a b server 9001 and a script server 9002, and can be divided into a bulletin board information providing system and a supplier evaluation system. The web server 9001 stores a computer program, operates the bulletin board information providing system according to the computer program, and provides a first service 9003 and a second service 9004. The first service 9003 has an electronic conference room service. The second service 9004 has services such as a member table list, a meeting guide, a minutes list, a free talk, and an online manual. The first service 9003 and the second service 9004 are bulletin board information of parts or raw materials. Script server 9002,
Storing the computer program, operating the supplier evaluation system according to the computer program,
Service 9005 is provided. Third service 900
5 has a supplier evaluation service.

By accessing the Web server 9001, the user's computer 31 exchanges opinions with other members via the first service (electronic conference room) 9003, and exchanges opinions with the second service (electronic conference room). Various materials can be browsed via a member list 9004). In addition, the computer 31 of the user at each base inputs the evaluation points of each business partner in the business partner evaluation sheet and transmits the evaluation points to the script server 9002. Script server 9002
Receives the supplier evaluation sheets from the respective bases, and automatically sums up the evaluation points input to the supplier evaluation sheets at all the bases. The user computer 31 is connected to the script server 9
By receiving the evaluation result of each supplier from e-mail 002 or the like or by accessing the script server 9002, the evaluation result of each supplier can be browsed and used.

FIG. 136 shows a bulletin board information providing system (W
It is a flowchart which shows the process of eb server 9001). When the user's computer 31 (FIG. 135) accesses the Web server 9001 (bulletin board information providing system), the bulletin board information providing system performs the following processing. At step SIA1, the login screen shown in FIG. 139 is displayed on the computer 31 of the user, and waits for the input of the user ID and the input of the password. The user can input a user ID in the area 9101 of FIG. 139 and can input a password in the area 9102. User ID 9101
By inputting the password 9102 and the password 9102, security can be enhanced, and login by an unauthorized person can be prevented.

For security protection, the user can change the password by clicking on password change button 9104 with a mouse. If the user clicks login button 9103 with a mouse, and if the entered user ID and password are correct, the user is logged in and proceeds to step SIA2. In step SIA2, a menu screen shown in FIG. 140 is displayed.

FIG. 140 is a flowchart showing the operation of step SI shown in FIG.
3 shows a menu screen of A2. In the display area 9131,
Display title. The display area 9132 displays the number of accesses. In the menu area 9133, the selected menu items are “1. electronic conference room”, “2. member list”, “3. meeting information”, “4. minutes list”, “5. free talk”, “6. "Online manual" and "7. Support window" are displayed. When each number is selected, through the judgment step of step SIA3,
Proceed to any of steps SIA4 to SIA10.

When No. 1 is selected, the flow advances to step SIA4 to perform electronic conference room processing. The electronic conference room process is an electronic bulletin board for the purpose of exchanging information, in which a user can freely write and all other users can see the written content. If No. 2 is selected, the process proceeds to step SIA5, where a member list process is performed. The member list process displays a member table of each organization. When No. 3 is selected, the process proceeds to step SIA6, and a conference holding guidance process is performed. The conference holding guidance process provides bulletin board information of the meeting holding guidance. When No. 4 is selected, the process proceeds to step SIA7, where a minutes list process is performed. In the minutes list processing, the minutes of the meeting are stored, and the user can browse the minutes.
When No. 5 is selected, the process proceeds to step SIA8, where a free talk process is performed. The free talk process is an electronic bulletin board for the purpose of freely exchanging opinions, in which a user can freely write, and the writing can be shared by all other users. When No. 6 is selected, the process proceeds to step SIA9, where online manual processing is performed. In the online manual processing, an instruction manual on how to use the bulletin board information providing system is provided online. If No. 7 is selected, the process proceeds to step SIA10, where support window processing is performed. The support window processing informs a method of contacting the support window of the bulletin board information providing system, and enables an inquiry to the support window by e-mail or the like.

FIG. 137 shows the step SI shown in FIG. 136.
It is a flowchart which shows the electronic conference room processing of A4. In step SIB1, the menu screen of the electronic conference room shown in FIG. 141 is displayed. The display in the display areas 9131 to 9133 is the same as described above. As a selection menu item of the electronic conference room, a new comment 9141, a category 9142, a creator 9143, and a creation date order 9144 are displayed. When each item is selected, the process proceeds to any of steps SIB3 to SIB6 via the judgment step of step SIB2. When the category 9142 is selected, the process proceeds to step SIB3, where a category-based process is performed. When the creator-specific process 9143 is selected, the process proceeds to step SIB4, where the creator-specific process is performed. When the order of creation date 9144 is selected, step SIB5
Go to and create date order processing. When the new comment 9141 is selected, the process proceeds to step SIB6, and a new comment process is performed.

FIG. 138 shows the step SI shown in FIG.
It is a flowchart which shows the detail of the process classified by category of B3. In step SIC1, the electronic conference room screen for each category shown in FIG. 142 is displayed. Display areas 9131-9
The display of 133 is the same as above. Area 9 by category
In 154, the items of the electronic conference room classified by category are listed and displayed. When a word to be searched is input in input box 9151 and search button 9152 is clicked on with a mouse, an electronic meeting room having a document including the input word is searched for and displayed in category-specific area 9154. If the area of a desired electronic conference room item in category-based area 9154 is clicked on with a mouse, it can be step SIC in FIG. 138.
The process proceeds to step SIC3 via the determination step 2 to display a comment content screen shown in FIG. 143.

FIG. 143 shows the step SI shown in FIG. 138.
13 shows a comment content screen of C3. Display areas 9131 to 91
The display of 33 is the same as above. Comment content area 916
1 displays the contents of the remark in the electronic conference room selected above. If category-specific area 9162 is clicked on with a mouse, it returns to step SIC1 in FIG. 138 and displays the category-specific screen in FIG. 142. In addition, area 91 by creator
If mouse button 63 is clicked, step S in FIG. 137 is performed.
Proceed to IB4. If creation date order area 9164 is clicked on with a mouse, it proceeds to step SIB5 in FIG. 137. If a response to a document in the electronic conference room is to be made, clicking response area 9165 with a mouse proceeds to step SIC4 in FIG. 138, and displays the response screen shown in FIG. 144.

FIG. 144 is a flowchart showing the operation of step SI shown in FIG.
13 shows a response screen of C4. Display areas 9131-9
The display of 133 is the same as above. On the response screen, the title 9171, the creator 9172, the reply content 91
73 can be entered. After input, send button 91
When 77 is clicked on with a mouse, the entered content is returned (transmitted). If category area 9174 is clicked on with a mouse, it returns to step SIC1 in FIG. 138 and displays the category screen in FIG. 142. Clicking the creator-specific area 9175 with a mouse,
Proceed to step SIB4 of step S37. If creation date order area 9176 is clicked on with a mouse, it proceeds to step SIB5 in FIG. 137.

In the category screen shown in FIG. 142, when new comment area 9153 is clicked on with a mouse, it can be moved to FIG.
The process proceeds to step SIC5 via step SIC2 of No. 8, and a new comment screen shown in FIG. 145 is displayed. Also, at step SIB6 in FIG. 137, the new comment screen shown in FIG. 145 is displayed.

FIG. 145 shows a new comment screen. The display in the display areas 9131 to 9133 is the same as described above. In the new comment screen, the mandatory input items 9181 and the input items 91
82, a comment content 9183 can be input. In the required input item 9181, a title, a creator, and a category can be input. In the input item 9182, a supplier code, a supplier name, a maker code, a maker name,
Part number and model name can be entered. Reset button 9
By clicking on 185 with the mouse, the input contents can be reset. If registration button 9184 is clicked on with a mouse, it proceeds to step SIC6 in FIG. 138 and displays the registration screen shown in FIG. 146.

FIG. 146 shows the step SI shown in FIG.
13 shows a registration screen of C6. Display areas 9131 to 9133
Is the same as above. The above-mentioned registered content is transmitted, and registered and reflected in the electronic conference room about 5 minutes later. If rereading is performed after about 5 minutes, the sent message content is displayed on the electronic bulletin board. Area 919 by category
When mouse 1 is clicked on with a mouse, step SI in FIG. 138 is performed.
Returning to C1, the category screen of FIG. 142 is displayed. If creator-specific area 9192 is clicked on with a mouse, it proceeds to step SIB4 in FIG. If mouse is clicked on creation date order area 9193 with a mouse, FIG.
To step SIB5.

The details of the category-specific processing in step SIB3 shown in FIG. 137 have been described above.
The creator-specific process and the creation date order process of step SIB5 are the same as the above-described category-based process except that the electronic conference rooms are displayed in order of creator and creation date.

FIG. 147 shows the step SI shown in FIG.
14 shows a member table screen displayed in the member list process of C5. The display in the display areas 9131 to 9133 is the same as described above. A member table 9201 of each organization is displayed on the member table screen. For example, the member table 9201 displays a member number, a post, a business office name, an affiliated department name, an affiliated section name, a name, and the like.

FIG. 148 shows the step SI shown in FIG.
13 shows a conference holding guidance screen displayed in the conference holding guidance process of C6. The display in the display areas 9131 to 9133 is the same as described above. In the meeting holding guidance area 9213, items of the meeting holding guidance are listed and displayed. Specifically, in the conference holding guidance area 9213, a message and an issue date of each item are displayed. When a word or phrase to be searched is entered in input box 9211 and search button 9212 is clicked on with a mouse, a meeting holding guide having a document including the input word is searched and displayed in meeting holding guide area 9213. If a desired conference holding guidance item in conference holding guidance area 9213 is clicked on with a mouse, a content screen of the conference holding guidance shown in FIG. 149 is displayed.

FIG. 149 shows a content screen of the conference holding guidance. The display in the display areas 9131 to 9133 is the same as described above. The conference holding guide 9221 displays, for example, the content of the conference holding guide such as the date and time, place, and agenda of the meeting. This conference holding guide 9221 can also be printed.

FIG. 150 is a flowchart showing the processing of the supplier evaluation system. In step SID1, when the user requests the input of the trader's evaluation sheet, FIG.
1 is displayed on the computer 31 of the user. The user is the supplier 923 to be evaluated.
1. Evaluator 9232 and supplier's evaluation point 9241 are input. Specifically, the evaluation point 9241 is a quality evaluation point 9241.
33, cost evaluation point 9234, delivery date evaluation point 923
5. The evaluation point 9236 of the response ability (sales ability) and the evaluation point 9237 of the technical ability are input. The evaluation point of the responsiveness is, for example, whether or not it is possible to respond to a design change of the drawing, or the evaluation of the responsiveness when it is possible. Evaluation points 9233 to 923
7 is evaluated, for example, out of 10 points. In addition, the evaluator only needs to check the evaluation items in addition to inputting the evaluation points, and the evaluation points may be automatically assigned based on the check items. If transmission button 9238 is clicked on with a mouse, it proceeds to step SID2 in FIG. 150 and stores the evaluation sheet in script server 9002 (FIG. 13).
Send to 5). When the clear button 9239 is clicked on with a mouse, the above input can be cleared. If end button 9240 is clicked on with a mouse, it ends the process.

FIG. 152 shows the script server 9002
It is a flowchart which shows the process of the supplier evaluation system which (FIG. 135) performs. In step SIE1, the script server 9002 receives the above evaluation sheet from the computer 31 of the user at each site. Step SIE2
Then, the evaluation sheets received from the respective bases are automatically totaled, the evaluation points for each business partner are calculated, and the business partners are ranked. In step SIE3, the evaluation result screen shown in FIG.
To be displayed. The evaluation result table 9251 displays the ranking of the business partner, the business partner name, and the total evaluation score. The user can know the comprehensive evaluation of each business partner including other bases, and can consider future measures. The above evaluation result table 92
51 may be transmitted to the user's computer 31 by e-mail.

[0335] As described above, the bulletin board information providing system provides the user with bulletin board information of parts or raw materials including the electronic conference room, the list of members, the list of meetings, the list of minutes, and free talk. Can share various information and exchange opinions, and can quickly obtain various information. When a user logs in to the bulletin board information providing system, for each organization to which the user belongs, or for each type of parts or raw materials handled by the user,
Another electronic conference room, a list of members, a list of meetings, a list of minutes, a free talk, an online manual, and a support window may be accessed. For example, it can be divided into electronic components and mechanical components.

The supplier evaluation system totals the evaluations of the suppliers at each base, calculates the total evaluation score for each supplier,
By ranking, an objective evaluation of the business partner can be performed. The user at each site can know the comprehensive evaluation including the evaluation of each business partner at another site. The evaluation will be an important reference in future transactions with business partners.

As described above, the procurement information system 13
Parts and raw materials around the world can be quickly and efficiently selected and procured. Large enterprises sometimes purchase parts or raw materials from different suppliers or the same supplier at different unit prices. According to the procurement information system 13, the procurement information The parts or raw materials can be purchased as cheaply as possible based on the procurement information. In addition, a large number of parts or raw materials can be purchased at a low price by placing orders at each business office in a lump.

Further, the procurement information system 13 can satisfy the following requirements in the development department of the company.
(1) I want to know the parts and raw materials used at other business sites. (2) I want to select optimal parts and raw materials from a wide range of information. (3) I want to obtain information on alternative products. (4) I want to get new product information quickly.

Further, the procurement information system 13 can satisfy the following requirements in the procurement department of the company.
(1) I want to know the purchase price and suppliers for the same parts and raw materials at each business site. (2) I want to quickly find information on alternative products. (3) I want to know the business partner's capabilities (eg, production type and production volume) and status (including world trends including market conditions). (4) I want to know the purchase status of the entire group.

Note that software program codes for realizing the functions of the above-described embodiment are supplied to the system.
Computer (CPU or MPU) of the system
The present invention also includes those implemented by operating the various devices according to the programs stored in the program.

In this case, the program code itself of the software realizes the function of the above-described embodiment, and the program code itself and a means for supplying the program code to the computer, for example, storing the program code The recorded recording medium constitutes the present invention. As a recording medium for storing such a program code, for example, a floppy disk, a hard disk,
An optical disk, a magneto-optical disk, a CD-ROM, a magnetic tape, a nonvolatile memory card, a ROM, or the like can be used.

Each of the above embodiments is merely an example of an embodiment for carrying out the present invention.
These should not be construed as limiting the technical scope of the present invention. That is, the present invention can be embodied in various forms without departing from the spirit or main features thereof.

[0343]

As described above, according to the present invention, raw material information can be obtained quickly and easily, and raw materials can be selected and procured quickly and efficiently. Large companies can obtain raw material information of each business establishment and purchase raw materials at the lowest possible price based on the raw material information. In addition, a large amount of raw materials can be purchased at low cost by placing orders at each business office in a lump.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a configuration of a procurement information system according to an embodiment of the present invention.

FIG. 2 is a flowchart illustrating processing of a procurement information system according to the present embodiment.

FIG. 3 is a block diagram illustrating a configuration of an electronic component system according to the present embodiment.

FIG. 4 is a schematic diagram showing the contents of a database of the electronic component system.

FIG. 5 is a flowchart illustrating processing of the electronic component system.

FIG. 6 is a flowchart showing details of a search process based on part numbers shown in FIG. 5;

FIG. 7 is a flowchart showing details of a link process shown in FIG. 6;

FIG. 8 is a flowchart showing details of an external database information search process shown in FIG. 5;

FIG. 9 is a flowchart showing details of the exchange rate information processing shown in FIG. 5;

FIG. 10 is a diagram showing a login screen.

FIG. 11 is a diagram showing a menu screen.

FIG. 12 is a diagram showing a condition input screen when performing a search by part number;

FIG. 13 is a diagram showing a list screen of a search result by a part number.

FIG. 14 is a diagram showing a list screen following a search result by a part number;

FIG. 15 is a diagram showing a detailed screen of a search result by a part number.

FIG. 16 is a diagram showing a detailed screen subsequent to a search result by a part number.

FIG. 17 is a diagram showing a list screen of a search result of a substitute part by a part number.

FIG. 18 is a diagram showing a product / product information screen.

FIG. 19 is a diagram showing a part number-based order schedule information list screen.

FIG. 20 is a diagram showing an inspection unit price history information screen.

FIG. 21 is a diagram showing a condition input screen when performing a search by type name.

FIG. 22 is a diagram showing a major category selection screen when searching for external database information.

FIG. 23 is a diagram showing a middle category selection screen when searching for external database information.

FIG. 24 is a diagram showing a condition input screen when searching for external database information.

FIG. 25 is a diagram showing a list screen of a search result of external database information.

FIG. 26 is a diagram showing a component information screen of a search result of external database information.

FIG. 27 is a diagram showing a market price screen of the semiconductor and liquid crystal markets.

FIG. 28 is a diagram showing a currency list screen of exchange rates.

FIG. 29 is a diagram showing an exchange rate transition screen.

FIG. 30 is a block diagram illustrating a configuration of a raw material system according to the present embodiment.

FIG. 31 is a schematic view showing the contents of a database of a raw material system.

FIG. 32 is a flowchart showing processing of the raw material system.

FIG. 33 is a flowchart showing details of material unit price information processing shown in FIG. 32.

FIG. 34 is a flowchart showing details of material use information processing shown in FIG. 32.

FIG. 35 is a flowchart showing details of management unit price information processing shown in FIG. 33;

36 is a flowchart showing details of overseas unit price information processing shown in FIG. 33.

FIG. 37 is a flowchart illustrating details of part number use information processing shown in FIG. 34;

38 is a flowchart showing details of part number-specific material cost detail information processing shown in FIG. 34.

39 is a flowchart showing details of material-specific summary information processing shown in FIG. 32.

FIG. 40 is a flowchart showing details of the spec information processing shown in FIG. 32.

FIG. 41 is a flowchart showing details of the color approval information processing shown in FIG. 32;

FIG. 42 is a diagram showing a login screen.

FIG. 43 is a diagram showing a menu screen.

FIG. 44 is a diagram showing a search screen for management unit price information processing.

FIG. 45 is a diagram showing a list screen of a search result of management unit price information processing.

FIG. 46 is a diagram showing a detailed screen of a search result of management unit price information processing.

FIG. 47 is a diagram showing a search screen for overseas business unit actual purchase unit price information processing.

FIG. 48 is a view showing a list screen of search results of overseas business unit actual purchase unit price information processing.

FIG. 49 is a diagram showing an exchange rate screen for overseas business unit actual purchase unit price information processing.

FIG. 50 is a diagram showing a search screen for use information processing by part number.

FIG. 51 is a diagram showing a search result screen of use information processing by part number.

FIG. 52 is a diagram showing a product information screen of use information processing by part number.

FIG. 53 is a diagram showing a search screen for material cost detail information processing by part number.

FIG. 54 is a diagram showing a search result screen of material cost detail information processing by part number.

FIG. 55 is a diagram showing a product information screen of material cost detail information processing by part number.

FIG. 56 is a diagram showing a search screen for summary information processing by material.

FIG. 57 is a diagram showing a price information screen of material-specific summary information processing.

FIG. 58 is a diagram showing a weight information screen of material-specific summary information processing.

FIG. 59 is a diagram showing a search screen for specification information processing.

FIG. 60 is a diagram showing a list screen of a search result of the specification information processing.

FIG. 61 is a diagram showing a detailed screen of a search result of specification information processing.

FIG. 62 is a diagram showing a search screen for color approval information processing.

FIG. 63 is a diagram showing a search result screen of color approval information processing.

FIG. 64 is a diagram showing a comment screen for color approval information processing.

FIG. 65 is a block diagram illustrating a configuration of a cost reduction support system according to the present embodiment.

FIG. 66 is a schematic diagram showing contents of a database of the cost reduction support system.

FIG. 67 is a flowchart showing processing of the cost reduction support system.

FIG. 68 is a diagram showing a login screen.

FIG. 69 is a diagram showing an inspection data list screen.

FIG. 70 is a diagram showing an inspection data screen.

FIG. 71 is a diagram showing an inspection data screen.

FIG. 72 is a diagram showing an inspection data screen.

FIG. 73 is a block diagram illustrating a configuration of a procurement record system according to the present embodiment.

FIG. 74 is a schematic diagram showing the contents of a database of a procurement record system.

FIG. 75 is a flowchart showing processing of the procurement record system.

FIG. 76 is a flowchart showing a procurement record search process.

FIG. 77 is a diagram showing a login screen.

FIG. 78 is a diagram showing a menu screen.

FIG. 79 is a diagram showing a procurement record search screen.

FIG. 80 is a diagram showing an aggregation method selection area.

FIG. 81 is a diagram showing a condition input area and a condition input auxiliary screen area.

FIG. 82 is a view showing a procurement result search result screen.

FIG. 83 is a diagram showing a search condition display area.

FIG. 84 is a diagram showing an aggregation result area.

FIG. 85 is a flowchart showing processing of the procurement record data management system.

FIG. 86 is a diagram showing a menu screen.

FIG. 87 is a diagram showing a term end processing screen.

FIG. 88 is a block diagram showing a configuration of a supplier card information system according to this embodiment.

FIG. 89 is a schematic diagram showing the contents of a database of a supplier card information system.

FIG. 90 is a flowchart showing processing of the supplier card information system.

FIG. 91 is a flowchart showing a supplier card information search process.

FIG. 92 is a diagram showing a login screen.

FIG. 93 is a diagram showing a menu screen.

FIG. 94 is a diagram showing a supplier card information search screen.

FIG. 95 is a diagram showing a supplier card information search result screen.

FIG. 96 is a diagram showing a relationship between a fiscal year, a corporation, and a business partner.

FIG. 97 is a block diagram illustrating a configuration of a supplier map system according to the present embodiment.

FIG. 98 is a schematic view showing the contents of a database of a supplier map system.

FIG. 99 is a flowchart showing the processing of the supplier map system.

FIG. 100 is a diagram showing a login screen.

FIG. 101 is a diagram showing a registration status display screen.

FIG. 102 is a diagram showing a factory (machining destination) search screen.

FIG. 103 is a diagram showing a search condition / result display screen.

FIG. 104 is a diagram showing a help screen.

FIG. 105 is a diagram showing a map display screen.

FIG. 106 is a diagram showing a factory information screen.

FIG. 107 is a diagram showing a secondary processing screen.

FIG. 108 is a diagram showing a route search (selection) screen.

FIG. 109 is a diagram showing a route search (input) screen.

FIG. 110 is a diagram showing a route display screen.

FIG. 111 is a block diagram showing a configuration of a supplier sales system according to the embodiment.

FIG. 112 is a schematic diagram showing the contents of a database of the supplier sales system.

FIG. 113 is a flowchart showing supplier sales information registration processing.

Fig. 114 is a diagram showing a menu screen.

FIG. 115 is a diagram showing a component information registration screen.

FIG. 116 is a diagram showing a part number information registration screen.

FIG. 117 is a diagram showing a replacement (alternative) information registration screen.

FIG. 118 is a diagram showing an approach information registration screen.

FIG. 119 is a diagram showing a staff information registration screen.

FIG. 120 is a flowchart showing the processing of the supplier sales system.

FIG. 121 is a flowchart showing the processing of the supplier sales system.

FIG. 122 is a diagram showing a login screen.

FIG. 123 is a diagram showing a menu screen.

FIG. 124 is a diagram showing a sales information search screen.

FIG. 125 is a diagram showing a sales information detail screen.

FIG. 126 is a diagram showing an alternative component information search screen.

Fig. 127 is a diagram illustrating a code help screen.

FIG. 128 is a diagram showing an alternative component information list screen.

Fig. 129 is a diagram showing an approach information list screen.

FIG. 130 is a diagram showing an approach information search screen.

FIG. 131 is a diagram showing an approach information detail screen.

FIG. 132 is a diagram showing a staff information search screen.

FIG. 133 is a diagram showing a staff information list screen.

FIG. 134 is a diagram showing a person in charge information detail screen.

FIG. 135 is a block diagram illustrating a configuration of a bulletin board mail system according to the present embodiment.

FIG. 136 is a flowchart showing processing of the bulletin board information providing system.

FIG. 137 is a flowchart showing details of electronic conference room processing.

FIG. 138 is a flowchart showing details of a category-specific process.

FIG. 139 is a diagram showing a login screen.

FIG. 140 is a diagram showing a menu screen of the bulletin board information providing system.

FIG. 141 is a diagram showing a menu screen of the electronic conference room.

FIG. 142 is a diagram showing a category-specific screen.

Fig. 143 is a diagram showing a comment content screen.

FIG. 144 is a diagram showing a response screen.

Fig. 145 is a diagram showing a new comment screen.

Fig. 146 is a diagram showing a registration screen.

Fig. 147 is a diagram showing a member list screen.

Fig. 148 is a diagram showing a conference holding guidance screen.

Fig. 149 is a diagram showing a detailed screen of a conference holding guide.

FIG. 150 is a flowchart showing the processing of the supplier evaluation system.

FIG. 151 is a diagram showing a supplier evaluation input screen.

FIG. 152 is a flowchart showing processing of the supplier evaluation system.

FIG. 153 is a diagram showing a supplier evaluation result screen.

FIG. 154 is a block diagram illustrating a configuration of an all-number system according to the present embodiment.

FIG. 155 is a schematic diagram showing the contents of a database of the all-number system.

FIG. 156 is a flowchart showing processing of an all-number system.

FIG. 157 is a diagram showing a login screen.

FIG. 158 is a diagram showing a menu screen.

FIG. 159 is a view showing a purchase (acceptance) result latest information search screen.

FIG. 160 is a diagram showing a purchase (acceptance) result latest information list screen.

FIG. 161 is a view showing a purchase (acceptance) result history information screen.

FIG. 162 is a diagram showing a unit price history latest information search screen.

FIG. 163 is a diagram showing a unit price history latest information list screen.

FIG. 164 is a view showing a unit price history history information screen.

FIG. 165 is a diagram showing an order schedule information search screen.

FIG. 166 is a view showing an order schedule information list screen.

FIG. 167 is a view showing an exchange rate latest information list screen.

FIG. 168 is a diagram showing an exchange rate history information screen.

FIG. 169 is a diagram showing a code help screen.

[Explanation of symbols]

 REFERENCE SIGNS LIST 1 electronic component system 2 raw material system 3 mechanical component system 4 whole number system 5 cost reduction support system 6 procurement record system 7 supplier card information system 8 supplier map system 9 supplier sales system 10 bulletin board mail system 1a to 9a database 11 parts Information system 12 Supplier system 13 Procurement information system 21 Purchasing system 22 Ordering system 23 Production management system 31 Computer of user 32 Computer of supplier 33 Computer of information provider 34 External database 1001 Web server 1002 Application server 1003 Database server 1004 Image server 1005 CD changer 1006 Operation machine 1007 Update database server 1008 Magnetic tape device 1012 External database 1013 Data processing section 1014 Production affiliate company 1015, 1016, 1017 Information source 1018 Semiconductor Industry News 2001 Web server 2002 Application server 2003 Database server 2006 Operation machine 2007 Update database server 2013 Production affiliate company 2011, 2014 Information source 3001 Web Server 3002 Application server 3003 Database server 3004 Operation machine 3005 Update database server 3011 Computer of a production affiliate company 3012 Computer of human resources department 4001 Web server 4002 Application server 4003 Database server 4004 Operation machine 4006 Operation machine 4011 Each base 4012 Computer of each base 4013 Computer in the human resources department 5001 Web server 5002 Application server 5003 Database server 5004 Operation machine 5011 Computer in each base 5012 Computer in the human resources department 6001 Web server 6002 Application server 6003 Database server 6004 Operation machine 6005 Image scanner 6011 Business partner 6012 Human resources department Computer 7001 Web server 7002 Operation machine 7003 SQL server 7004 MapInfo server 7005 Computer at each base 7011 Business partner 7012 Human resources computer 8001 Web server 8002 Application server 8003 Database server 8004 Operation machine 8005 Database server 800 6 Mail server 8007 Administrator computer 8011 Business partner computer 8012 Human resources computer 9001 Web server 9002 Script server 9003 First service 9004 Second service 9005 Third service

 ──────────────────────────────────────────────────続 き Continuing on the front page (72) Nobuyuki Hirai, 3-30-2 Shimomaruko, Ota-ku, Tokyo Within Canon Inc. (72) Inventor Makoto Nakamura 3-30-2 Shimomaruko, Ota-ku, Tokyo Canon Inc. (72) Inventor Toshiaki Takahashi 3-30-2, Shimomaruko 3-chome, Ota-ku, Tokyo Canon Inc. ( 72) Inventor Takashi Nakano 3- 30-2 Shimomaruko, Ota-ku, Tokyo Canon Inc. (72) Inventor Kiyohisa Matsunaga 3- 30-2 Shimomaruko 3-chome, Ota-ku, Tokyo Canon Inc. (72) Invention Person Mutsui Terada 3-30-2 Shimomaruko, Ota-ku, Tokyo Inside Canon Inc. (72) Inventor Kinya Okada 3-30-2 Shimomaruko, Ota-ku, Tokyo Canon within Co., Ltd. (72) inventor Masaaki Sawabe Tsukuba, Ibaraki Prefecture pill removal 1868 F-term (reference) 5B049 AA06 BB07 CC05 EE05 FF01 5B075 ND20 PQ02 UU22

Claims (24)

[Claims] 1. Raw material information having a database for storing raw material information, designating means for designating raw materials, and display means for retrieving and displaying raw material information corresponding to the raw materials specified by the designating means from the database. Offer system. 2. The raw material information providing system according to claim 1, wherein said database stores resin material information or metal material information, and said specifying means specifies a resin material or a metal material. 3. The database according to claim 1, wherein said database stores price information of raw materials, and said display means displays said price information.
Or the raw material information providing system according to 2. 4. The database stores raw material unit price information, and the display unit displays the unit price information.
Raw material information providing system described. 5. A raw material information providing system according to claim 4, wherein said database stores unit price information of raw materials at overseas offices, and said display means displays said unit price information. 6. The database according to claim 1, wherein the database stores weight information of the raw material, and the display unit displays the weight information.
A raw material information providing system according to any one of claims 1 to 4. 7. The raw material information providing system according to claim 1, wherein the database stores an exchange rate in addition to the raw material information, and the display unit displays the exchange rate based on the database. 8. The database stores product information,
The raw material information providing system according to any one of claims 1 to 7, wherein the display unit displays information on a product in which the specified raw material is used. 9. The raw material information providing system according to claim 1, wherein the database stores specification information of the raw material, and the display unit displays the specification information. 10. The raw material information providing system according to claim 1, wherein the database stores color approval information of the raw material, and the display unit displays the color approval information. 11. The raw material information providing system according to claim 1, wherein the database stores green certification information in consideration of environmental issues of the raw materials, and the display unit displays the green certification information. 12. A user ID input by a user
The material information providing system according to any one of claims 1 to 11, further comprising: a login unit configured to log in if a password is correct, and the designation unit can designate the raw material after the login. 13. The raw material information providing system according to claim 12, wherein said display means displays said user ID together with said raw material information. 14. The raw material information providing system according to claim 13, wherein said display means displays said user ID and a login date together with said raw material information. 15. The raw material information providing system according to claim 12, wherein said log-in means deletes the log-in right of the user when the user does not log in for a predetermined period. 16. The raw material information providing system according to claim 1, wherein said specifying means specifies a material of the raw material. 17. The raw material information providing system according to claim 1, wherein said specifying means specifies a raw material maker. 18. The raw material information providing system according to claim 1, wherein said specifying means specifies a color of the raw material. 19. The raw material information providing system according to claim 1, wherein said specifying means specifies the price of the raw material. 20. The raw material information providing system according to claim 1, wherein said specifying means specifies a base where the raw material is used. 21. The raw material information providing system according to claim 1, wherein said specifying means specifies a grade number of the raw material. 22. The raw material information providing system according to claim 1, wherein said specifying means specifies a part number of the raw material. 23. A method for providing raw material information, comprising: (a) specifying a raw material; and (b) searching and displaying raw material information corresponding to the specified raw material from a database. 24. A computer storing a program for causing a computer to execute (a) a procedure for designating parts and (b) a procedure for searching and displaying raw material information corresponding to the specified raw material from a database. A readable recording medium.