JP2002099793A - Product order support system, product order support method, and customer server - Google Patents

Abstract

[57] [Summary] [Problem] To be able to disclose necessary information to customers while achieving the confidentiality of mission-critical databases, reduce the number of processing tasks for sales staff, and respond to inquiries from customers. Product ordering support system that can respond immediately,
An object of the present invention is to provide a product ordering support method and a customer server. SOLUTION: A back-office database 3 for storing information on ordering of goods, and a back-office database 3
A part of the information stored in the customer database 7 is read, and a customer database 7 for storing the read information is processed, and the information stored in the customer database 7 is processed, and the information to be disclosed to the customer is disclosed for each customer. And stores it in the customer database 7 while providing the information created and stored for each customer in response to a request from the customer, while providing information on the ordering of goods provided by the customer in the customer database 7. To solve the above problem.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a merchandise ordering support system, a merchandise ordering support method, and a server for a customer. The present invention relates to a product ordering support system, a product ordering support method, and a customer server that support processing.

[0002]

2. Description of the Related Art For example, a sales company of electronic parts sells various kinds of electronic parts to customers such as manufacturers or trading companies (agents) who directly purchase the parts. An electronic parts sales company builds a business system that uses an intranet within the sales company, and sales representatives and sales assistants connect in-house terminals to the business system to receive orders and order products. , Shipping, receiving, order approval, inventory allocation, inventory check, etc. Also, regarding the quotation work, a sales person or the like uses an in-house terminal to check a delivery date, a price, and the like.

Conventionally, a sales representative who has received an inquiry from a customer regarding product prices, stocks, and the like, checks the product prices, stocks, and the like by connecting an in-house terminal to a business-use system, and reports the result of the check by telephone. Answer by facsimile, etc.
The customer prepares an order form according to the response result and sends it to the sales representative of the sales company by mail or facsimile. Then, the sales person who received the order form connects the in-house terminal to the core business system, and processes the order by operating the in-house terminal. Further, the salesperson performs a shipping process when the delivery date comes and a billing process when the billing time comes.

[0004]

[Problems to be Solved by the Invention]
In order to respond to inquiries about inventory, etc., a large number of sales representatives are required, and a lot of time and work will be required until the order is confirmed, such as asking the customer to judge again according to the shortage of the inquiry product or the delivery date situation Is required. On the other hand, sales of products containing technical content such as electronic components require technical knowledge such as marketing information, product information, and usage methods. There was a problem that they were not able to acquire the necessary knowledge enough because they were busy responding to inquiries. Therefore, there has been a problem that it is not possible to sufficiently respond to the needs of the customer, the sales opportunity of the product is lost, and the service to the customer is reduced.

[0005] Therefore, by permitting the customer to connect to the core business system, the customer can also confirm information such as the product price and stock. However, if all information of the core business database included in the business system is disclosed to the customer, there is a problem in maintaining confidentiality. Therefore, it is necessary to add or process the information of the business database for each customer. Therefore, there is a problem that the load on the core business database increases and extra time is required for information maintenance.

SUMMARY OF THE INVENTION The present invention has been made in view of the above points, and it is possible to disclose necessary information to a customer while achieving confidentiality of a core business database, thereby reducing the processing work of a salesperson. It is an object of the present invention to provide a merchandise ordering support system, a merchandise ordering support method, and a customer server that can respond to inquiries from customers immediately.

[0007]

SUMMARY OF THE INVENTION In order to solve the above-mentioned problems, the present invention provides a database for a core business that stores information on the ordering of goods, and a method for storing the information stored in the database for a core business. Section is read, a customer database for storing the read information, and processing information stored in the customer database,
While information to be disclosed to the customer is created for each customer and stored in the customer database, the information created and stored for each customer is provided in response to a request from the customer,
A customer server for storing information on ordering of goods provided by the customer in the customer database.

According to the present invention, a part of the information stored in the core business database is read, and the read information is processed to create information to be disclosed to the customer for each customer. Stored in the customer database. By storing the information to be disclosed to the customer in the customer database separately from the core business database, a part of the information can be disclosed to the customer while maintaining the confidentiality of the core business database. Further, since the customer database is provided separately from the core business database, the load on the core business database does not increase.

[0009] Further, the customer himself can check the information stored in the customer database, thereby reducing the processing tasks of the salesperson. Therefore, the salesperson can sufficiently acquire technical knowledge such as marketing information, product information, and usage, and can respond to customer needs.

[0010] In order to solve the above-mentioned problem, the present invention relates to a server for receiving and placing an order for a product supplied from the terminal for customer among information stored in the database for customer at predetermined time intervals. The information is supplied to the core business database, and the information stored in the core business database is reflected in the information stored in the customer database.

According to the present invention, information on ordering of goods supplied from the customer terminal out of the information stored in the customer database every predetermined time is supplied to the core business database, and the information is stored in the core business database. Reflect the stored information in the core business database. Therefore, for example, order information supplied by the customer to the customer database using the customer terminal can be supplied to the core business database at predetermined time intervals. Further, information stored in the core business database can be reflected in the information stored in the customer database, for example, updated stock information and price information of products can be reflected in the customer database.

According to another aspect of the present invention, the customer server processes information stored in the customer database, and obtains stock information and price of goods as information to be disclosed for each customer. The information is created and stored in the customer database.

According to the present invention, the information stored in the core business database is processed to create stock information and price information of the product for each customer, and stored in the customer database. By storing the information to be disclosed to the customer in the customer database separately from the core business database, the stock information and the price information can be disclosed to the customer while maintaining the confidentiality of the core business database.

In order to solve the above-mentioned problems, the present invention provides the above-mentioned customer server, wherein the customer server divides the product into a plurality of product groups and sets a plurality of multiplication factors for each of the product groups. The selling price of each product is calculated by associating one of the plurality of rates for each product group.

According to the present invention, the product is divided into a plurality of product groups, a plurality of rates are set for each of the product groups, and one of the plurality of rates is associated with each customer and each product group. By calculating the sales price for each product, it is possible to set detailed sales prices for each customer and each product group.

[0016]

Next, embodiments of the present invention will be described with reference to the drawings. In the present embodiment, a product ordering support system that supports electronic component ordering processing will be described as an example of a product ordering support system. However, the present invention is not limited to this, and can be applied to any product.

FIG. 1 shows a system configuration diagram of an embodiment of a product ordering support system 1 of the present invention. The commodity ordering support system 1 of FIG. 1 is roughly divided into a main business server 2, a main business database (hereinafter, referred to as a main business DB) 3, internal terminals 4a to 4n, and a network 5 such as an intranet. Core business system, customer server 6, customer database (hereinafter customer DB)
7, for example, a network 8 such as the Internet, and a customer system including customer terminals 9a to 9m.

In the core business system, a business server 2 and in-house terminals 4 a to 4 n are connected via a network 5. In addition, the main business server 2 is connected to a main business DB 3 that stores information on the main business. On the other hand, in the customer system, a customer server 6 and customer terminals 9 a to 9 m are connected via a network 8. The customer server 6 stores a customer D that stores information to be disclosed to customers as described below for each customer.
B7 is connected. The customer server 6 is connected to the network 8 while being connected to the network 8.

For example, the in-house terminals 4a to 4n are arranged not only at the head office but also at a sales office or the like. By connecting the in-house terminals 4a to 4n to the back-office server 2 via the network 5, the sales rep, etc., perform operations such as order receiving, ordering, shipping, receiving, order approval, inventory allocation, and inventory confirmation. Can be performed. In addition, the salesperson or the like sets various conditions relating to the commodity ordering support system 1 described later by connecting the in-house terminals 4a to 4n to the customer server 6 via the network 5.

The core business server 2 has in-house terminals 4 a to 4
In addition to providing or updating the information stored in the core business DB 3 in response to a request from n, an inquiry process, an order receiving process, an ordering process, an accounting process, a delivery process, a correction process, and the like are performed. In addition, the core business DB 3 stores information on product order processing such as inventory information, order information, and order information for each product. For example, the stock information includes information such as quantity, purchase cost, purchase time, and supplier. The order information includes information such as quantity, unit price, delivery date, and supplier. The order information includes information such as quantity, unit price, order receiving party, and delivery date.

On the other hand, the customer terminals 9a to 9m are owned by a customer such as a maker that directly purchases electronic components or a trading company (agent) that wholesales electronic components. By connecting the customer terminals 9a to 9m to the customer server 6 via the network 8, the customer can perform processes such as inquiry, order, correction, and reference. For example, each of the customer terminals 9a to 9m includes a terminal capable of connecting to the Internet and software capable of browsing information on the Internet.

The customer server 6 has customer terminals 9a to 9m.
In addition to providing or updating the information stored in the customer DB 7 in response to a request from the customer, it performs inquiry processing, order processing, correction processing, reference processing, and the like. The customer server 6 receives a part of the information (for example, price information, stock information, etc.) stored in the core business DB 3 every predetermined time (for example, one day), and receives a part of the information. Is stored. At this time, the customer server 6 processes the information stored in the customer DB 7 as necessary, creates information to be disclosed to the customer for each customer, and stores the information in the customer DB 7.

The customer server 6 is provided with a customer terminal 9a.
The information of the customer DB 7 updated in response to a request (for example, an order processing request, a correction processing request, etc.) is transmitted to the core business DB 3 every predetermined time (for example, one day). Each time the information in the customer DB 7 is updated, the updated information may be transmitted to the core business server 2.

When the updated information in the customer DB 7 is transmitted from the customer server 6, the core business server 2 performs the same processing as the information transmitted from the in-house terminals 4a to 4n. For example, when there is an order processing request from the customer terminals 9a to 9m, subsequent order processing, accounting processing, delivery processing, and correction processing are performed in accordance with the instructions of the in-house terminals 4a to 4n, and the order progress and delivery progress occurring in the middle are performed. This is reflected in the information in the customer DB 7.

In the commodity ordering support system 1 described above, information such as the commodity price and the delivery date is disclosed to the customer within a predetermined range, so that the salesperson does not need to respond to the inquiry from the customer. Therefore, it is possible to reduce the processing tasks of the salesperson.

FIG. 2 is a block diagram showing one embodiment of a computer system for realizing the customer server 6 of the present invention. In FIG. 2, the computer system includes an input device 10, a display device 11, a drive device 12, a recording medium 13, an auxiliary storage device 14, a memory device 15, Arithmetic processing unit 16
And interface devices 17 and 18.

The input device 10 includes a keyboard and a mouse operated by a user of the computer system, and is used to input various operation signals to the computer system. The display device 11 displays various windows and data necessary for operating the computer system. The interface device 17 is an interface for connecting the computer system to the network 5, and is composed of, for example, a LAN adapter. The interface device 18 is an interface for connecting the computer system to the network 8, and is composed of, for example, a modem. If the networks 5 and 8 are the same type of network, one of the interface devices 17 and 18 can be omitted.

The program relating to the customer server 6 is provided by a recording medium 13 such as a CD-ROM. The recording medium 13 is set in the drive device 12,
The program is stored in the auxiliary storage device 1 via the drive device 12.
4 installed. The memory device 15 reads a program from the auxiliary storage device 14 when the computer system is started, and stores the program. The arithmetic processing device 16 executes a process related to the product ordering support system according to a program stored in the memory device 15.

Hereinafter, the functions of the customer server 6 of the present invention will be described. The customer server 6 receives a part of the information stored in the core business DB 3 and stores the information in the customer DB 7, while responding to requests from the customer terminals 9a to 9m stored in the customer DB 7. The updated information is read and transmitted to the core business server 2. Such transmission and reception of information between the core business DB 3 and the customer DB 7 may be performed, for example, by nighttime batch processing after the end of the service. The nighttime batch processing is executed by the core business server 2 and the customer server 6, respectively.

FIG. 3 is a linkage diagram showing an example of information stored in the core business DB and the customer DB. The core business DB 3 includes an order table 20, an order table 21, a processing result table 22, a supplier master 23, a customer customer management master 24, a product master 25, an inventory table 26, an inventory allocation table 27, an order table 28, an order table. 2
9. It has a stock allocation table 30.

The customer DB 7 includes a customer order table 38, a core order table 39, a customer supplier master 40,
It has a customer product master 41, a customer supplier master 42, a customer inventory master 43, a customer order remaining table 44, a customer-specific master 45, and a supplier-specific master 46.

The core business server 2 creates various interface data (hereinafter, referred to as IF data) from the information stored in the business DB 3 by performing batch processing, and transmits it to the client server 6. Further, the customer server 6 performs the batch processing to obtain the customer D
It creates IF data from the information stored in B7 and sends it to the core business server 2. Then, the core business server 2 and the customer server 6 update the information stored in the core business DB 3 and the customer DB 7 using the received IF data. Below, DB3 for core business and D for customer
The cooperation of the information stored in B7 will be described in detail.

The core business server 2 is provided with a business partner master 23
And customer IF data 3 from the customer customer management master 24
2 and sends the customer IF data 32 to the customer server 6. FIG. 4 shows a configuration diagram of an example of a supplier master. FIG. 5 shows a configuration diagram of an example of the customer customer management master.

The supplier IF data 32 includes a supplier code,
Dummy key, Kanji supplier name 1, Kanji supplier name 2, Kana supplier name 1, Kana supplier name 2, Simplified supplier name, Kanji address 1, Kanji address 2, Kanji address 3, Delivery receipt number, Customer phone It has a number, a supplier FAX number, a normal limit, a customer transaction status, and an update date, and is created using information stored in the supplier master 23 and the customer customer management master 24. The customer server 6 receives the customer IF data 32,
A customer supplier master 40 is created from the supplier IF data 32. FIG. 6 shows a configuration diagram of an example of the customer supplier master. The customer server 6 stores the created customer supplier master 4
0 is stored in the customer DB 7.

The core business server 2 creates the product IF data 33 from the product master 25, and transmits the product IF data 33 to the customer server 6. FIG. 7 shows a configuration diagram of an example of the product master. The product IF data 33 includes a product code, a dummy key, a product name, an allocation expiration date, a last-by expiration date, a comment, a stock status category, a kanji supplier name, and an update date, and uses information stored in the product master 25. Created.

The customer server 6 receives the product IF data 33 and uses the product IF data 33 to store the customer product master 41.
Then, the customer supplier master 42 is created. FIG. 8 shows a configuration diagram of an example of the customer product master. FIG. 9 shows a configuration diagram of an example of the customer supplier master. Customer server 6
Stores the created customer product master 41 and customer supplier master 42 in the customer DB 7.

In addition, the core business server 2 obtains the product price IF data 34 from the product master 25 and the stock table 26.
And transmits the commodity price IF data 34 to the customer server 6. FIG. 10 shows a configuration diagram of an example of the stock table. The product price IF data 34 has a product code, a dummy key, and a stock unit price, and is created using information stored in the product master 25 and the stock table 26.

Further, the core business server 2 creates the inventory quantity IF data 35 from the inventory allocation table 27 and the order receipt table 28, and transmits the inventory quantity IF data 35 to the customer server 6. FIG. 11 shows a configuration diagram of an example of the inventory allocation table. FIG. 12 shows a configuration diagram of an example of the order receiving table. The stock quantity IF data 35 includes a product code, a dummy key, and a stock quantity, and is stored in the stock allocation table 2.
7 and information stored in the order table 28.

The customer server 6 stores the commodity price IF data 34
And the stock quantity IF data 35, and the product price I
A customer inventory master 43 is created from the F data 34 and the inventory quantity IF data 35. FIG. 13 shows a configuration diagram of an example of the customer stock master. The customer server 6 stores the created customer inventory master 43 in the customer DB 7.

Further, the core business server 2 creates the unordered IF data 36 from the order table 29 and transmits the unordered IF data 36 to the customer server 6. FIG.
15 shows a configuration diagram of an example of an order table. Backlog I
The F data 36 includes the product code, the dummy key, the remaining order number this month, the remaining order number one month later, the remaining order number two months later, and the remaining order number 3
Each month is created using the information stored in the order table 29. The customer server 6 receives the unordered IF data 36, and creates a customer unordered table 44 from the unordered IF data 36. FIG. 16 shows a configuration diagram of an example of the customer order remaining table. The customer server 6 stores the created customer order remaining table 44 in the customer DB 7.

The customer server 6 creates a customer-specific merchandise master 45 from the customer supplier master 40 and the customer merchandise master 41 created as described above, while the customer supplier master 40 and the customer supplier master 42. , A supplier-specific master 46 is created. FIG. 17 shows a configuration diagram of an example of a supplier-specific product-specific master. FIG. 18 shows a configuration diagram of an example of a supplier-specific and supplier-specific master.

On the other hand, the customer server 6 has a customer terminal 9a.
Orders from .about.9 m are stored in the customer order table 38. FIG. 19 shows a configuration diagram of an example of the customer order table. The customer server 6 creates the same-day order IF data 37 from the customer order table 38 and transmits the same-day order IF data 37 to the core business server 2.

On the day's order IF data 37, the entry number, data creation date, supplier code, order number, product code, purchaser, order quantity, order unit price, delivery date, delivery destination name 1, delivery destination name 2, delivery destination Delivery address 1, Delivery address 2, Delivery address 3, Delivery reception place, Delivery telephone number, Delivery slip, Operation number, Special code 1, Special code 2, Special code 3,
It has special code 4, special code 5, and special notes 72A,
It is created using information stored in the customer order table 38.

Upon receiving the same-day order IF data 37, the core business server 2 retrieves the same-day order IF data 37 from FIG.
Is created, and the order table 20 is stored in the core business DB 3. FIG. 20 shows a configuration diagram of an example of the order table. When the order table 20 is created, the core business server 2 sends the order table 20
Is used to create an order receiving table 21 as shown in FIG.

Then, the core business server 2 creates an inventory allocation table 30 as shown in FIG. 11 using the order receiving table 21 and also generates a processing result table 22 using the order receiving table 21 and the inventory allocation table 30. create. FIG. 21 is a configuration diagram of an example of the processing result table 22. The core business server 2 creates the processing result IF data 31 from the processing result table 22 and
The data 31 is transmitted to the customer server 6.

The processing result IF data 31 includes the delivery destination name 1, the delivery destination name 2, the delivery address 1, the delivery address 2, the delivery address 3, the delivery reception place, and the delivery destination name among the information stored in the processing result table. It has information excluding a delivery destination telephone number, a delivery slip, and a new arrival flag, and is created using information stored in the processing result table 22.

The customer server 6 receives the created processing result IF data 31 and creates a core order table 39 from the processing result IF data 31. FIG. 22 shows a configuration diagram of an example of the core order table. The customer server 6 stores the created core order table 39 in the customer DB 7.
The customer server 6 reflects the information stored in the core order table 39 on the customer order table 38.

By performing the above-described series of processing in, for example, nighttime batch processing, it is possible to link information stored in the core business DB 3 shown in FIG. 3 with information stored in the customer DB 7. . It should be noted that various transmitted IFs
The data does not have to include all information,
The updated information and the new information on the day may be used.

Using the information stored in the customer DB 7, the customer server 6 supports the electronic part ordering process. For example, when the customer connects to the customer server 6 using the customer terminals 9a to 9m or the sales representative using the in-house terminals 4a to 4n, the customer logs in to the display devices of the customer terminals 9a to 9m or the in-house terminals 4a to 4n. The screen is displayed.

[0050] The log-in screen shows the supplier code, the person in charge I
D, has an input field for inputting a password. When the supplier code, contact ID, and password are entered in the input fields of the login screen, the customer server 6 authenticates the user making the connection request according to the supplier code, contact ID, and password. I do.

The commodity ordering support system 1 classifies users into a customer manager, a customer manager, a system manager, and a system manager, and according to the classification of the user, the customer manager and the system manager. Administrator mode used by the administrator,
The customer-side staff operation mode used by the customer staff and the system-side staff operation mode used by the system staff are operated.

The administrator mode has a person maintenance function for registering a customer side person and a system side person in charge, and a delivery destination maintenance function for registering information on a delivery destination. The customer administrator and the system administrator use the contact maintenance function to register the customer and system administrators, while the customer administrator uses the delivery destination maintenance function to provide information about the delivery destination. Register

It should be noted that the customer manager can register a plurality of customer contacts and delivery destinations. Information on the registered customer-side person in charge is stored in the person-in-charge master in the customer DB 7. Further, information on the registered delivery destination is stored in a delivery destination master included in the customer DB 7. On the other hand, the system administrator can register a plurality of system personnel. The registered information on the system side person in charge is stored in, for example, a person in charge master included in the customer DB 7.

The system-side clerk operation mode includes a common information setting function, a rank and special price setting function for each supplier, a product master updating function, a product display setting function, a supplier rate setting function, a stock updating function, a customer disguising function, It has an order search function on the day. The common information setting function is a function for setting common information about the product ordering support system 1 such as an opening message.

The rank & special price setting function for each supplier is a function for setting a unit price rank for each supplier and each supplier. Here, “by customer” means by customer. When the customer-specific rank & special price setting function is selected, the customer server 6
Requests the system person in charge to enter the customer's supplier code for setting the unit price rank.

When the supplier code is input, the customer server 6 searches for information corresponding to the input supplier code from the supplier-specific supplier-specific master 46. Then, the customer server 6 is displayed on the display device of the in-house terminal 4a, for example, as shown in FIG.
The unit price rank by supplier and supplier as shown in is displayed.

The person in charge on the system side can set the unit price rank (for example, A to C) for each supplier by referring to the unit price rank for each supplier as shown in FIG. When the unit price rank for each supplier is set, the server for customer 6 updates the information stored in the master 46 for each supplier according to the set contents.

The rank and special price setting function for each customer is
It also has a function to set a unit price for each product for each business partner. When the supplier code is input, the customer server 6 searches for information corresponding to the input supplier code from the supplier-specific product master 45. Then, the customer server 6 displays, for example, a unit price for each supplier and each product as shown in FIG. 24 on a display device of the in-house terminal 4a.

The person in charge on the system side can set a unit price for each product (for example, 1,500 yen) by referring to a unit price for each product for each supplier as shown in FIG. When the unit price for each supplier and each product is set, the customer server 6 updates the information stored in the supplier-specific product master 45 according to the set contents.

The product master update function is a function for correcting detailed information on a product. When the product master update function is selected, the server for customer 6 requests a person in charge of the system to input a product code. When the product code is input, the customer server 6 searches for information corresponding to the part code input from the customer product master 41. Then, the customer server 6 displays the detailed information corresponding to the supplied product code, for example, on the display device of the in-house terminal 4a. In addition, the input of the product code can use a head-on or tail-on search. When a search is used, a product code list corresponding to the search condition is displayed. When a desired product is selected from the product code list, the customer server 6 displays detailed information corresponding to the selected product.

The person in charge on the system side refers to the detailed information corresponding to the selected product and sets detailed information such as the minimum order quantity, packing unit, and lead time for each product included in the customer product master 41. it can. When detailed information such as the minimum order quantity, packing unit, and lead time for each product is set, the customer server 6 updates the information stored in the customer product master 41 according to the set contents.

The product display setting function is a function for setting whether or not the product information is disclosed and whether or not the stock quantity is disclosed for each product. When the product display setting function is selected, the customer server 6
Requests the person in charge of the system to enter the product code. When the product code is input, the customer server 6 searches for information corresponding to the part code input from the customer product master 41. The customer server 6 is, for example, an in-house terminal 4a.
Of the product corresponding to the input product code is displayed on the display device. In addition, similarly to the product master function, the input of the product code can be performed by using a front match search or a backward match search.

The person in charge of the system can refer to the presence / absence of a product display and the presence / absence of a product corresponding to the input product code, and can set the presence / absence of a product display and the presence / absence of a stock display of the product. When the presence / absence of product display and the presence / absence display of the product are set, the customer server 6 updates the information stored in the customer product master 41 according to the settings.

The supplier rate setting function is a function for setting a supplier rate. When the supplier-specific rate setting function is selected, the customer server 6 requests a system-side person to input a supplier code or a supplier name. The input of the supplier code can use a range search (for example, the supplier codes “01” to “12”).

When the supplier code or the supplier name is entered, the server 6 for customer uses the customer supplier master 42
Searches for information corresponding to the supplier code or supplier name input from. Then, the customer server 6 displays a supplier list corresponding to the supplied supplier code or supplier name, for example, on a display device of the in-house terminal 4a.

Then, when a desired supplier is selected from the supplier list, the customer server 6 reads out a rate per unit price rank corresponding to the selected supplier from the customer supplier master 42. Then, the customer server 6 displays, for example, the rate by unit price rank as shown in FIG. 25 on the display device of the in-house terminal 4a. For example, when “A” to “C” are set as unit price ranks for each supplier, a cost rate can be set for each unit price rank. FIG.
Then, the cost rate of unit price rank "A" is "0.85"
Is set. When the rate for each unit price rank is set for each supplier, the customer server 6 updates the information stored in the customer supplier master 42 according to the set contents.

The stock update function is a function for setting an adjustment quantity for increasing or decreasing the stock quantity to be disclosed. When the inventory update function is selected, the customer server 6 requests the system person in charge to input the product code or the product name of the product for which the adjustment quantity is to be set. In addition, the input of the product code or the product name can be performed by using a head match, a tail match, or a partial search. When the product code or the product name is input, the customer server 6 searches the information corresponding to the product code or the product name input from the customer stock master 43. And the customer server 6
Displays a product list corresponding to the supplied product code or product name, for example, on the display device of the in-house terminal 4a.

When a desired product is selected from the product list, the customer server 6 displays a detailed screen including the stock quantity, the adjustment quantity, and the like corresponding to the selected product. The system person in charge can set the adjustment quantity for each product, and can make the released stock quantity the actual stock quantity plus the adjustment quantity. For example, if the actual inventory quantity is “1000” and the adjustment quantity is “−500”, the released inventory quantity is “500”.

The customer disguise function is a function in which the system-side person impersonates the customer-side person and operates the customer-side person operation mode. In this case, the customer server 6 shifts from the system-side clerk operation mode to the camouflage mode. The camouflage mode is mainly used for maintenance. The order-of-the-day search function is a function of displaying information registered on the day of order registration for each supplier. When the same-day order search function is selected, the customer server 6 stores the customer order table 38
, The order registration registered on the day is searched, and a list of order registrations registered on the day can be displayed on the display device of the in-house terminal 4a, for example. The order search function on the day displays order registrations that are not linked to the order table 20 of the core business DB 3 by batch processing.

Next, the customer side operation mode will be described. The customer side staff operation mode has a product list display function, an order registration function, an order search / change function on the day, and an order search function. The product list display function is a function of performing a product search according to a condition designated by the user and displaying a list of the searched products.

When the merchandise list display function is selected, the customer server 6 displays, for example, on the display device of the customer terminal 9a as shown in FIG.
Is displayed as shown in FIG. FIG.
The search condition input screen 50 has input fields for inputting presence / absence of stock, search target, manufacturer name, product name, and product code.

When all of the search conditions or a part of the search conditions are input to the search condition input screen 50, the client server 6 searches for a product corresponding to the input search conditions, and searches as shown in FIG. The result screen 51 is displayed. "In stock" included in the search condition is a search condition based on the presence or absence of stock,
“Search target” is a search condition based on past order results.
"Manufacturer name" is a search condition by supplier name.
“Product name” is a search condition by product name, and “product code” is a search condition by product code. In addition, in the search using the “product name” and the “product code”, forward matching, backward matching, and partial search can be used.

For example, when searching for “in stock”,
The customer server 6 determines that the stock quantity is 0 from the customer stock master 43.
While searching for a larger product, a product whose stock display flag is “display” is searched from the customer product master 41. Then, the customer server 6 displays, for example, on the display device of the in-house terminal 4a, a product whose stock quantity is larger than 0 and whose stock display flag is “display” on the search result screen 51.

The search result screen 51 is displayed so as to include the product code, the product name, the unit price, the stock, and the arrival schedule of the searched product. For example, the product code is the customer product master 41
When the last-by expiration date of the product is set, the product with the last-by expiration date can be distinguished from other products by displaying the product in a color different from the normal color. As for the stock, the stock quantity and the adjusted quantity of the corresponding product are detected from the customer stock master 43, and the quantity obtained by adding the stock quantity and the adjusted quantity is displayed as stock on the search result screen 51.

The unit price is calculated according to the following procedure. First, the unit price for each product (class D unit price in FIG. 17) of the corresponding product is detected from the product master 45 for each customer, and if the unit price for each product is set, the product for each customer is detected. Another unit price is displayed on the search result screen 51 as a sales unit price. On the other hand, if the supplier-specific unit price is not set, the inventory unit price of the corresponding product is detected from the customer inventory master 42, and the rate of the corresponding product is determined from the supplier-specific supplier master 46 and the customer supplier master 42. Is detected. Then, the sales unit price is calculated by the following equation (1).

(Sales Unit Price) = (Inventory Unit Price) ÷ (Acquisition Rate) (1) The calculated sales unit price is displayed on the search result screen 51 as the unit price of the product. As described above, it is possible to set the unit price rank for each supplier for each supplier, and it is also possible to set multiple rates for each supplier.
The unit price displayed on the search result screen 51 can be set finely.

When a desired product is selected from the search result screen 51, the customer server 6 displays detailed information corresponding to the selected product. The detailed information corresponding to the selected product includes the product code, product name,
Consists of allocation, lead time, comment, minimum order quantity, packing unit, etc.

The order registration function uses the search condition input screen 52 of FIG. 27 to search for a product that satisfies the search conditions, and displays a search result screen 53, similarly to the product list display function.
In the search result screen 53, the unit price and the stock are set in the same manner as in the product list display function. When a desired product is selected from the search result screen 53, the customer server 6 displays the selected product on the order registration list screen 54. A desired product is selected from the products displayed on the order registration list screen 54,
An order content registration screen for setting more detailed order content can be displayed.

The order search / change function on the day is a function for searching, changing, and canceling the order registration registered on the day. The order search function is a function for displaying information on data ordered up to the previous day. The order search / change function on the day and the order search function have a search function and can also display detailed information on ordered data.

Note that the commodity ordering support system 1 of the present invention
In order to allow a customer to place an order for a product without the intervention of a sales representative, the processing results of the core business system are reflected in the core order table 39. It has the function of automatically transmitting to

Specifically, upon receiving the processing result IF data 31 created from the processing result table 22, the client server 6 performs the processing based on the supplier code and the product code contained in the processing result IF data 31. The sales representative included in the separate supplier master 46 is extracted. And
The customer server 6 extracts the mail address of the sales representative from the sales representative ID, and sends the processing result for each customer in charge of the sales representative to the mail address. Therefore,
The salesperson can easily grasp the order status of the customer in charge.

[0082]

As described above, according to the present invention, the information disclosed to the customer is stored in the customer database separately from the core business database, so that the confidentiality of the core business database can be maintained while providing the customer with the confidentiality. Some information can be disclosed. Further, since the customer database is provided separately from the core business database, the load on the core business database does not increase.

Further, the customer himself / herself can check the information stored in the customer database, and the processing tasks of the salesperson can be reduced. Therefore, the salesperson can sufficiently acquire technical knowledge such as marketing information, product information, and usage, and can respond to customer needs. In addition, since the order from the customer is supplied as electronic data, it is possible to reduce data entry errors by the sales representative.

Further, the product is divided into a plurality of product groups, a plurality of rates are set for each of the product groups, and one of the plurality of rates is corresponded to each customer and each product group so as to correspond to each product. By calculating the selling price of the customer, it is possible to set a fine selling price for each customer and each product group.

[0085]

[Brief description of the drawings]

FIG. 1 is a system configuration diagram of an embodiment of a product ordering / support system according to the present invention.

FIG. 2 is a configuration diagram of an embodiment of a computer system for realizing a server for customers of the present invention.

FIG. 3 is a cooperation diagram of an example of information stored in a core business DB and a customer DB;

FIG. 4 is a configuration diagram of an example of a supplier master;

FIG. 5 is a configuration diagram of an example of a customer customer management master.

FIG. 6 is a configuration diagram of an example of a customer supplier master.

FIG. 7 is a configuration diagram of an example of a product master.

FIG. 8 is a configuration diagram of an example of a customer product master.

FIG. 9 is a configuration diagram of an example of a customer supplier master.

FIG. 10 is a configuration diagram of an example of a stock table.

FIG. 11 is a configuration diagram of an example of a stock allocation table.

FIG. 12 is a configuration diagram of an example of an order receiving table.

FIG. 13 is a configuration diagram of an example of a customer stock master.

FIG. 14 is a configuration diagram of an example of an order table.

FIG. 15 is a configuration diagram of an example of an order table.

FIG. 16 is a configuration diagram of an example of a customer order remaining table.

FIG. 17 is a configuration diagram of an example of a supplier-specific product-specific master;

FIG. 18 is a configuration diagram of an example of a supplier-specific and supplier-specific master.

FIG. 19 is a configuration diagram of an example of a customer order table.

FIG. 20 is a configuration diagram of an example of an order table.

FIG. 21 is a configuration diagram of an example of a processing result table.

FIG. 22 is a diagram illustrating an example of a basic order table.

FIG. 23 is a screen diagram displaying an example of a supplier-specific unit price rank.

FIG. 24 is a screen view showing an example of a unit price for each supplier and each product.

FIG. 25 is a screen view showing an example of a supplier-specific payout ratio.

FIG. 26 is a screen diagram displaying an example of a search condition input screen and a search result screen.

FIG. 27 is a screen diagram displaying an example of an order registration screen.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Merchandise ordering support system 2 Core business server 3 Core business database (core business DB) 4a-4n In-house terminal 5.8 Network 6 Customer server 7 Customer database (customer DB) 9 Customer terminal 9a- 9m 10 Input device 11 Display device 12 Drive device 13 Recording medium 14 Auxiliary storage device 15 Memory device 16 Arithmetic processing device 17, 18 Interface device 45 Master for each product by supplier 46 Master for each supplier

Claims (10)

[Claims] 1. A core business database for storing information on ordering of goods, a part of information stored in the core business database being read, and a customer business storing the read information. A database, processing information stored in the customer database, creating information to be disclosed to the customer for each customer and storing the information in the customer database, and creating and storing the information created and stored for each customer in the database. A product server for providing information in response to a request from a customer and storing information on ordering of a product provided by the customer in the database for the customer. 2. A merchandise ordering support system that supports processing related to merchandise ordering using a core business system and a customer system connected to the core business system, wherein the core business system is provided. Has a core business server that performs processing related to the ordering of products, and a core business database that stores information related to the ordering of the products. The customer system includes a customer terminal, and the core business database. A part of the information stored in the customer database is read out, and a customer database for storing the read information, and information stored in the customer database are processed, and information to be disclosed to the customer is disclosed for each customer. And store it in the customer database, and provide the information created and stored for each customer in response to a request from the customer terminal. Product ordering support system characterized by having a customer server that stores information about ordering of products supplied from the customer terminal to the customer database. 3. The customer server is connected to the customer terminal via a network, and the information created and stored for each customer in response to a request from the customer terminal via the network. 3. The merchandise ordering support system according to claim 2, wherein information on ordering of merchandise supplied from the customer terminal via a network is stored in the database for the customer. 4. The server for customers supplies information on the ordering of goods supplied from the terminal for customers among the information stored in the database for customers at predetermined time intervals to the database for core business. 4. The commodity ordering support system according to claim 2, wherein information stored in the core business database is reflected in information stored in the customer database. 5. The server for customer, when reflecting the information stored in the database for core business in the information stored in the database for customer, reflects the processing result of each customer regarding the ordering of goods to the core business. The product ordering support system according to any one of claims 2 to 4, wherein a notification is made via a network to a person in charge registered for each customer on the system side. 6. The customer server processes information stored in the customer database, creates stock information and price information of products as information to be disclosed for each customer, and stores the information in the customer database. The product ordering support system according to any one of claims 2 to 5, wherein: 7. The customer server divides the product into a plurality of product groups, sets a plurality of rates for each product group, and sets one of the plurality of rates for each customer and each product group. 7. The commodity ordering support system according to claim 6, wherein a selling price for each commodity is calculated in correspondence with the one. 8. A product ordering / supporting method for supporting a process for ordering a product using a core business system and a customer system connected to the core business system, comprising: Referring to information on ordering of goods stored in the core business database included in the database, and storing a part of the information on ordering of the goods in the customer database included in the customer system; and Processing the information stored in the customer database, creating information to be disclosed to the customer for each customer, and storing the information in the customer database; and in response to a request from a customer terminal included in the customer system. Providing the information created and stored for each customer, and storing information on ordering of goods in the customer database, Product ordering support method characterized in that it comprises a step to be reflected in the mission-critical database information on ordering of goods supplied every predetermined time from the customer terminal of the information stored in the database. 9. Providing information created and stored for each customer in response to a request from a customer terminal included in the customer system, and storing information on an order for a product in the customer database. Authenticating a customer who operates the customer terminal, and reading information corresponding to the authenticated customer from information created and stored for each customer, and providing the information to the customer terminal. 9. The method of claim 8, further comprising the steps of: 10. A customer server connected to an enterprise business system, a customer database, and a customer terminal, for supporting processing related to ordering of goods, the enterprise server being included in the enterprise business system. Storage processing means for referring to information on ordering of goods stored in the database for the customer, storing a part of the information on ordering of the goods in the database for the customer, and information stored in the database for the customer. Processing means for processing and creating information to be disclosed to the customer for each customer and storing the information in the customer database; and providing information created and stored for each customer in response to a request from the customer terminal On the other hand, order processing means for storing information on ordering of goods in the customer database; and information processing of information stored in the customer database. For customers and having a Chi said information reflecting means for reflecting the mission-critical database information on ordering of goods supplied every predetermined time from the customer terminal server.