Temporary product number management device, temporary product number management method, and temporary product number management program

Abstract

To provide a temporary article number management device and the like which perform management so as to enable order acceptance and order placement using a temporary article number for a new product such that order acceptance from a customer and order placement to a manufacturer can be performed in a preceding manner even when a wholesaler who wholesales the new product of the manufacturer and delivers the product to the customer has not completed number assignment of the official article number for the new product yet.SOLUTION: A temporary article number management device according to the present embodiment (1) acquires a manufacturer article number in order acceptance data including order acceptance detail data including the manufacturer article number and a manufacturer code and an actual article number associated with the manufacturer code from an article number master including the manufacturer article number, the manufacturer code and the actual article number, acquires a temporary article number from a temporary article number master when the actual article number cannot be acquired, (2) completes the order acceptance data by storing the acquired actual article number or temporary article number in each order acceptance detail data, and (3) generates order placement data including order placement detail data including the manufacturer article number, the manufacturer code and the actual article number or temporary article number on the basis of the generated order acceptance data.SELECTED DRAWING: Figure 6

Description

[Technical Field]

[0001] The present invention relates to a temporary part number management device, a temporary part number management method, and a temporary part number management program. [Background technology]

[0002] Patent Document 1 discloses an automobile parts smart catalog system that enables a maintenance shop that has been requested to perform maintenance on a certain vehicle to intuitively and easily grasp the replacement parts that they should consider ordering from a parts dealer for the maintenance (parts that are likely to need to be replaced for the maintenance = parts that are likely to be replaced), or enables a parts dealer to intuitively and easily grasp the replacement parts that they should suggest to the maintenance shop to purchase for the maintenance (parts that are likely to need to be replaced for the maintenance = parts that are likely to be replaced) (see paragraph 0006 of Patent Document 1). [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Patent No. 4486165 Summary of the Invention [Problem to be solved by the invention]

[0004] In an industry that handles parts such as those described in Patent Document 1, when a commercial flow exists consisting of three parties, a supplier (manufacturer), a wholesaler, and a customer, as shown in FIG. 2, the following problems have conventionally occurred.

[0005] Wholesalers receive reports of new product launches from their suppliers (manufacturers) almost every month, but in order for the wholesalers to take orders from customers and place orders with the suppliers (manufacturers) for these new products, they need to assign their own product numbers. This is because the manufacturer's product numbers used by suppliers (manufacturers) usually have a large number of digits, which is not ideal for inventory management within the wholesaler.

[0006] However, since it takes a certain amount of time (up to two days) for wholesalers to assign product numbers to their own products, customers who prefer quick delivery end up placing their orders with other wholesalers, which can result in lost business.

[0007] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a temporary product number management device, a temporary product number management method, and a temporary product number management program that manages orders and orders using temporary product numbers for new products so that wholesalers can receive orders from customers and place orders with suppliers (manufacturers) in advance even when the wholesaler has not yet completed the assignment of official product numbers for new products within the company. [Means for solving the problem]

[0008] In order to solve the above-mentioned problems and achieve the object, the temporary product number management device of the present invention is a temporary product number management device that manages orders and orders using temporary product numbers for new products so that a wholesaler that wholesales new products from a manufacturer that is a supplier and delivers them to a customer can receive orders from the customer and place orders with the manufacturer in advance even when the wholesaler has not yet completed the assignment of a formal product number for the new product within the company, and the storage unit contains a product number master that includes a manufacturer product number that is a product number assigned by the manufacturer to identify the manufacturer's products, a manufacturer code that is a code for identifying the manufacturer, and a real product number that is a formal product number used by the wholesaler to identify the product within the company, and a temporary product number that is the only temporary product number used by the wholesaler to identify the product within the company until the real product number is assigned. and a temporary part number master including the manufacturer part number and the manufacturer code, and the control unit is provided with part number acquisition means for acquiring from the part number master a real part number linked to the manufacturer part number and the manufacturer code in order data managing information related to orders from the customer, including order specification data having the manufacturer part number and the manufacturer code, and, if the real part number cannot be acquired, acquiring the temporary part number from the temporary part number master; order data generation means for completing the order data by storing the real part number or the temporary part number acquired by the part number acquisition means in the order specification data; and order data generation means for generating, based on the order data generated by the order data generation means, order data managing information related to orders to the manufacturer, including order specification data having the manufacturer part number, the manufacturer code, and the real part number or the temporary part number.

[0009] In addition, in the temporary product number management device according to the present invention, the detailed order data further includes a planned arrival date for the product, and the control unit further includes: detailed order display means for displaying the detailed order data containing the temporary product numbers in order of earliest expected arrival date when a person in charge of the wholesaler assigns a real product number to the product to which the temporary product number has been assigned; and part number master updating means for updating the part number master by adding, when the person in charge of the wholesaler assigns a real product number to the product in the detailed order data displayed by the detailed order display means, a new record consisting of the assigned real product number, the manufacturer part number in the detailed order data that was the subject of the assignment of the real product number, and the manufacturer code in the detailed order data that was the subject of the assignment of the real product number.

[0010] Furthermore, in the temporary part number management device according to the present invention, the control unit acquires the real part number linked to the manufacturer part number and manufacturer code in the order specification data having the temporary part number from the part number master updated by the part number master updating means, and transfers the temporary part number in the order specification data to the acquired real part number, and on the other hand, further comprises temporary part number transfer means for acquiring the real part number linked to the manufacturer part number and manufacturer code in the order specification data having the temporary part number from the part number master updated by the part number master updating means, and transferring the temporary part number in the order specification data to the acquired real part number.

[0011] In addition, in the temporary product number management device of the present invention, the control unit is further characterized by having an error display means for displaying an error when an arrival input is made for a product identified in the order detail data having the temporary product number.

[0012] In addition, the temporary part number management device according to the present invention is characterized in that the product is a mechanical part or an electronic part, and the number of digits in the manufacturer part number is greater than the number of digits in the real part number and the temporary part number.

[0013] Furthermore, the temporary product number management method according to the present invention is a method executed by an information processing device having a control unit and a storage unit, which is capable of managing orders and orders using temporary product numbers for new products so that a wholesaler who wholesales new products from a manufacturer that is a supplier and delivers them to a customer can receive orders from the customer and place orders with the manufacturer in advance even when the wholesaler has not yet completed the assignment of official product numbers for the new products within the company, and the storage unit includes a product number master including a manufacturer product number, which is a product number assigned by the manufacturer to identify the manufacturer's products, a manufacturer code, which is a code for identifying the manufacturer, and a real product number, which is a real product number used by the wholesaler to identify the products within the company, and a temporary product number master, which is the only temporary product number used by the wholesaler to identify the products within the company and is used until the real product number is assigned. and a temporary part number master including the manufacturer part number and the manufacturer code, and is stored in the part number master, and is executed by the control unit to obtain from the part number master a real part number linked to the manufacturer part number and the manufacturer code in order data managing information related to orders from the customer, including order detail data having the manufacturer part number and the manufacturer code, and, if the real part number cannot be obtained, obtain the temporary part number from the temporary part number master; an order data generation step to complete the order data by storing the real part number or the temporary part number obtained in the part number acquisition step in the order detail data; and an order data generation step to generate order data managing information related to orders to the manufacturer, including order detail data having the manufacturer part number, the manufacturer code, and the real part number or the temporary part number, based on the order data generated in the order data generation step.

[0014] Furthermore, the temporary product number management program of the present invention is executed by an information processing device having a control unit and a storage unit, and is capable of managing orders and orders using a temporary product number for the new product so that a wholesaler who wholesales new products from a manufacturer that is a supplier and delivers them to a customer can receive orders from the customer and place orders with the manufacturer in advance even when the wholesaler has not yet completed the assignment of a formal product number for the new product within the company. The temporary product number management program is executed by an information processing device having a control unit and a storage unit, and the storage unit includes a product number master including a manufacturer product number which is a product number assigned by the manufacturer to identify the manufacturer's products, a manufacturer code which is a code for identifying the manufacturer, and a real product number which is a real product number used by the wholesaler to identify the product within the company, and a temporary product number which is the only temporary product number used by the wholesaler to identify the product within the company until the real product number is assigned. and a temporary part number master including the manufacturer part number and the manufacturer code, and for execution by the control unit, includes a part number acquisition step of acquiring from the part number master a real part number linked to the manufacturer part number and the manufacturer code in order data managing information regarding orders from the customer, including order detail data having the manufacturer part number and the manufacturer code, and if the real part number cannot be acquired, acquiring the temporary part number from the temporary part number master; an order data generation step of completing the order data by storing the real part number or the temporary part number acquired in the part number acquisition step in the order detail data; and an order data generation step of generating order data managing information regarding orders to the manufacturer, including order detail data having the manufacturer part number, the manufacturer code, and the real part number or the temporary part number, based on the order data generated in the order data generation step. [Effects of the Invention]

[0015] According to the present invention, even when a wholesaler has not yet completed the assignment of official product numbers for new products within the company, it is possible to manage the system so that orders can be received from customers and orders can be placed with suppliers (manufacturers) in advance using temporary product numbers for new products. [Brief explanation of the drawings]

[0016] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a temporary product number management device. [Figure 2] FIG. 2 is an image diagram showing an example of a trade flow consisting of three parties: a supplier (manufacturer), a wholesaler, and a customer. [Figure 3] FIG. 3 is a diagram showing an example of how product numbers are assigned when receiving and placing an order. [Figure 4] FIG. 4 is a diagram showing an example of items included in each master and each data. [Figure 5] FIG. 5 is a diagram showing an example of a processing flow according to this embodiment. [Figure 6] FIG. 6 is a diagram showing an example of the product number master, the temporary product number master, and the order data before the company's product numbers are stored. [Figure 7] FIG. 7 is a diagram showing an example of the order data after the company's product number is stored and the order data generated based on the order data. [Figure 8] FIG. 8 is a diagram showing an example of order data that is the basis for issuing a purchase order. [Figure 9] FIG. 9 is a diagram showing an example of registration of a real product number in the product number master. [Figure 10] FIG. 10 is a diagram showing an example of part number transfer from a temporary part number to a real part number. DETAILED DESCRIPTION OF THE INVENTION

[0017] Hereinafter, embodiments of a temporary part number management device, a temporary part number management method, and a temporary part number management program according to the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to these embodiments.

[0018] [1. Overview] In the industry that wholesales mechanical and electronic parts, it is common for manufacturer part numbers and company part numbers to be managed using different code systems. For this reason, when a manufacturer releases a new product, the wholesaler must assign a company part number to it, but this numbering process can take a considerable amount of time (up to two days in some cases).

[0019] As a result, order processing is backed up, and wholesalers are unable to deliver customer orders promptly, which ultimately leads to lost business. This problem is particularly pronounced in the above industry, where new products from manufacturers appear almost every month, requiring wholesalers to create their own product numbers almost daily. As such, it is important to shorten the lead time from receiving an order from a customer to delivering the product.

[0020] Therefore, in this embodiment, for example, for products for which the actual part number is not registered at the time of receiving an order or placing an order, a temporary part number is registered, allowing order-taking and ordering operations to begin in advance until the actual part number is registered. This allows order processing and ordering to be carried out even with a temporary part number, preventing business backlogs caused by the period when the part number has not been registered. Furthermore, since the manufacturer code and manufacturer part number are also registered when the temporary part number is registered, the manufacturer code and manufacturer part number are also printed on the purchase order, and as a result, wholesalers can place orders with their suppliers, the manufacturers, without any problems, as before.

[0021] In other words, in order to meet the demand for being able to process orders and purchase orders even if the product number has not been registered, in this embodiment, the wholesaler's person in charge registers the manufacturer code and manufacturer product number when registering the order and purchase order, (1) If the actual part number has not yet been registered in the part number master, as shown in Figure 3 (1), the temporary part number registered in the temporary part number master can be set as the company's part number. (2) If this part number has already been registered in the part number master, it can now be set as the company's own part number, as shown in Figure 3 (2). In this way, by using temporary part numbers, it is now possible to proceed with order and purchase order processing even if the actual part number has not yet been registered.

[0022] In this embodiment, for example, the actual product number is registered before the receiving process, and product number transfer processing can be performed for slips registered with temporary product numbers. The product number transfer processing is performed using the manufacturer code and manufacturer product number as key information.

[0023] In other words, in this embodiment, the temporary part numbers in the order receipt slip and order slip can be transferred to the actual part numbers. More specifically, in both normal order placement and order placement, and direct order placement and order placement, the temporary part numbers in the order receipt data and order placement data can be transferred to the actual part numbers.

[0024] The specific configuration and operation will be described below.

[0025] [2. Configuration] An example of the configuration of a temporary part number management device 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of the temporary part number management device 100.

[0026] The temporary part number management device 100 is a commercially available desktop personal computer. Note that the temporary part number management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

[0027] Temporary product number management device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units comprised in temporary product number management device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0028] The communication interface unit 104 communicatively connects the temporary part number management device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has the function of communicating data with other devices via the communication line. Here, the network 300 has the function of connecting the temporary part number management device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data such as various masters described below may be stored in the server 200, for example.

[0029] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to achieve a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0030] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.

[0031] The storage unit 106 includes, for example, a product number master 106a, a temporary product number master 106b, order data 106c, and order data 106d. The items included in each master and each data are as shown in FIG. 4, and will be described in detail below.

[0032] As shown in FIG. 6 etc., the product number master 106a includes a manufacturer product number, which is a product number assigned by the manufacturer to identify the manufacturer's products, a manufacturer code, which is a code for identifying the manufacturer, and a real product number, which is a formal product number used by the wholesaler to identify the product within its own company.

[0033] As shown in FIG. 6 and other figures, temporary product number master 106b includes a single temporary product number that is used by the wholesaler to identify products within the wholesaler's own company until the real product number is assigned.

[0034] Here, the product is, for example, a mechanical part or an electronic part. In the case of a mechanical part or an electronic part, the number of digits in the manufacturer's part number is usually greater than the number of digits in the real part number and the temporary part number. For example, in the example of FIG. 6, the real part number is 9 digits, the temporary part number is 10 digits, and the manufacturer's part number is 20 digits. If the number of digits is large, it is difficult for the wholesaler to manage its own inventory, so it is necessary to assign the real part number and the temporary part number with fewer digits.

[0035] The order data 106c is data for managing information related to orders from customers. The order data 106c includes order detail data. As shown in FIG. 7, the order detail data includes, for example, an order number, an order line number, an order number, an order line number, the manufacturer's part number, the manufacturer's code, and the company's part number. The company's part number is a concept that encompasses the real part number and the provisional part number.

[0036] Of the information contained in the order specification data, all information other than the company's product number is input by the wholesaler's staff or automatically assigned, while the company's product number is information acquired by a product number acquisition unit 102a (described later) and stored in the order specification data.

[0037] The order data 106d is data for managing information related to orders to the manufacturer. The order data 106d includes order detail data. As shown in FIG. 7, the order detail data includes, for example, the order number, the order line number, the expected arrival date, the manufacturer's product number, the manufacturer code, and the company's product number.

[0038] Among the information contained in the order detail data, the expected arrival date is information input by the person in charge of the wholesaler, while the information other than the expected arrival date is information inherited from the order detail data.

[0039] The control unit 102 is a CPU or the like that performs overall control of the temporary product number management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs.

[0040] The control unit 102 has, in terms of functional concept, for example: (1) a part number acquiring unit 102a as part number acquiring means for acquiring from the part number master a real part number linked to the manufacturer part number and the manufacturer code in the order data managing information regarding orders from the customer, including detailed order data having the manufacturer part number and the manufacturer code, and, if the real part number cannot be acquired, acquiring the temporary part number from the temporary part number master; (2) an order data generating unit 102b as order data generating means for completing the order data by storing the real part number or the temporary part number acquired by the part number acquiring means in each of the detailed order data; (3) an order data generating unit 102c as order data generating means for generating order data managing information regarding orders to the manufacturer, including detailed order data having the manufacturer part number, the manufacturer code, and the real part number or the temporary part number, based on the order data generated by the order data generating means; and (4) a part number acquiring unit 102c as order data generating means for generating order data managing information regarding orders to the manufacturer, including detailed order data having the manufacturer part number, the manufacturer code, and the real part number or the temporary part number, when the person in charge of the wholesaler assigns a real part number to a product to which the temporary part number has been assigned, by sorting the detailed order data having the temporary part number in order of the earliest expected arrival date. (5) a part number master updating unit 102e as part number master updating means for updating the part number master by adding a new record to the part number master, the new record consisting of the real part number that has been assigned, the manufacturer part number in the order specification data that has been the subject of the real part number assignment, and the manufacturer code in the order specification data that has been the subject of the real part number assignment; and (6) a part number master updating unit 102f as part number master updating means for updating the part number master by adding a new record to the part number master, the new record consisting of the real part number that has been assigned, the manufacturer part number in the order specification data that has been the subject of the real part number assignment, and the manufacturer code in the order specification data that has been the subject of the real part number assignment. a temporary product number transfer unit 102f as temporary product number transfer means for acquiring the real product number linked to the manufacturer product number and manufacturer code in the order specification data having the temporary product number from the product number master updated by the update means, and transferring the temporary product number in the order specification data to the acquired real product number, and for acquiring the real product number linked to the manufacturer product number and manufacturer code in the order specification data having the temporary product number from the product number master updated by the product number master update means, and transferring the temporary product number in the order specification data to the acquired real product number;(7) An error display unit 102g is provided as an error display means for displaying an error when an arrival input is made for a product specified in the order detail data having the temporary product number. Details of the processing executed by each unit will be explained in [4. Specific example of processing] below.

[0041] [3. Processing flow] In this section, an outline of the processing flow according to this embodiment will be described with reference to FIG.

[0042] First, when a wholesaler receives an order from a customer, the wholesaler's staff member begins registering the order. As shown in FIG. 5, order data 106c and order placement data 106d are generated by order entry. When generating order data 106c, the manufacturer's part number and manufacturer code are used as key information, and the part number is set as the company's part number in order data 106c by referencing part number master 106a. If the part number is not registered in part number master 106a, the temporary part number in temporary part number master 106b is set as the company's part number in order data 106c. Details of the generation of order data 106c and order placement data 106d described in this paragraph will be explained in [4-1] below.

[0043] Next, a purchase order is issued as shown in Figure 5. Details of issuing a purchase order are explained in [4-2] below.

[0044] Next, as shown in Fig. 5, it is determined whether or not product numbers have been registered (whether the actual product numbers have been registered) for all products in the order data 106c. If the actual product numbers have already been registered for all products in the order data 106c (if "Registered" in Fig. 5), receiving and shipping processes are carried out as shown in Fig. 5.

[0045] On the other hand, if there is even one product in the order data 106c for which the real part number has not been registered (in the case of "Not registered" in Figure 5), the real part number is registered for the unregistered part, and the part number master 106a is updated, as shown in Figure 5. Details of the real part number registration described in this paragraph will be explained in [4-3] below.

[0046] Next, as shown in Figure 5, temporary part number transfer processing is performed with reference to the updated part number master 106a, and the temporary part numbers in the order data 106c and the order data 106d are transferred to the actual part numbers. The transfer is performed using the manufacturer's part number and manufacturer code as key information. Details of the transfer from temporary part numbers to actual part numbers described in this paragraph are explained in [4-4] below.

[0047] After the transfer to the real part number is complete, the receiving and shipping processes will be carried out. Note that control (for example, an error display) will be implemented to prevent receiving processes from being carried out while the part number is temporary. Details of the error display described in this paragraph will be explained in [4-5] below.

[0048] [4. Specific examples of processing] In this section, a specific example of the processing according to this embodiment will be described. The input work described in this section is performed by, for example, a person in charge at a wholesaler.

[0049] [4-1. Generation of order data and purchase order data] This section describes the generation of the order data 106c and the order data 106d that are performed when an order is entered. Note that the order entry may be for either a normal order or a direct order.

[0050] As a premise for the explanation in this section, it is assumed that item number master 106a, temporary item number master 106b, and order data 106c have been registered in advance by a person in charge at the wholesaler with the contents shown in FIG.

[0051] (1) Obtaining the product number First, product number obtaining unit 102a obtains the real product number linked to the manufacturer product number and manufacturer code in order data 106c from product number master 106a, and if the real product number cannot be obtained, obtains the temporary product number from temporary product number master 106b.

[0052] Specifically, for the detailed order data on the second line (order line number 2) and the detailed order data on the third line (order line number 3) of the order data 106c in Fig. 6, referring to the product number master 106a in Fig. 6, there is a real product number linked to the manufacturer product number and manufacturer code contained in the detailed order data. Therefore, the product number acquisition unit 102a acquires the real product number "HON000001" for the detailed order data on the second line, and the real product number "HON000002" for the detailed order data on the third line.

[0053] In contrast, for the first line of the detailed order data (order line number 1) and the fourth line of the detailed order data (order line number 4) in the order data 106c of Fig. 6, when referring to the part number master 106a of Fig. 6, there is no real part number linked to the manufacturer part number and manufacturer code contained in the detailed order data. In this case, for these two pieces of detailed order data, the part number acquisition unit 102a acquires the temporary part number "KARI000001" from the temporary part number master 106b of Fig. 6.

[0054] (2) Generation of order data Next, the order data generating unit 102b completes the order data 106c by storing the real product number or the temporary product number acquired by the product number acquiring unit 102a in the respective order specification data.

[0055] Specifically, the order data generation unit 102b stores the temporary product number "KARI000001" in the first line of order specification data, the actual product number "HON000001" in the second line of order specification data, the actual product number "HON000002" in the third line of order specification data, and the temporary product number "KARI000001" in the fourth line of order specification data, thereby completing the order data 106c shown in Figure 7. The actual product number or the temporary product number is stored as the "company product number" in the order data 106c of Figure 7.

[0056] (3) Generation of order data Finally, the order data generating unit 102c generates order data 106d based on the order data 106c generated by the order data generating unit 102b.

[0057] Specifically, the order data generation unit 102c generates the order data 106d shown in Fig. 7 by inheriting the order number, order line number, manufacturer part number, manufacturer code, and company part number in the order receipt data 106c in Fig. 7. On the other hand, the "expected arrival date" in the order data 106d in Fig. 7 was entered by the person in charge at the wholesaler.

[0058] As explained above in section [4-1], the temporary product number management device 100 according to this embodiment allows a wholesaler to manage orders and orders using temporary product numbers for new products so that orders can be received from customers and orders can be placed with suppliers (manufacturers) in advance, even when the wholesaler has not yet completed internally assigning official product numbers to new products (in this example, the products identified in the order detail data on the first line and the products identified in the order detail data on the fourth line). This enables prompt delivery to customers.

[0059] [4-2. Issuance of purchase order] Next, an issuance document (not shown) is issued based on the generated order data 106d of Fig. 8. Note that for the order details on the first and fourth lines, the company's product number is a temporary product number rather than a real product number, but as long as the order document includes the manufacturer's product number and manufacturer code, there is no problem with the temporary product number because it does not interfere with ordering operations.

[0060] In this way, the temporary product number management device 100 according to this embodiment can issue a certificate of issue without waiting for the allocation of a permanent product number.

[0061] [4-3. Registration of this product number] This section explains how to register real product numbers. If temporary product numbers remain, it may cause problems in inventory management within the wholesaler. For example, in the example of order data 106d shown in Figure 8, the products in two details (the order detail data on the first line and the order detail data on the fourth line) that have temporary product numbers will be managed with the same temporary product number, causing problems in inventory management. For this reason, it is necessary to register real product numbers before performing the receiving process.

[0062] When the wholesaler's staff member assigns the real product number to the product to which the temporary product number has been assigned, the order details display unit 102d displays the order details data having the temporary product number in order of the earliest expected arrival date.

[0063] Specifically, in the order data 106d shown in Fig. 8, the detailed order data having a temporary product number are the detailed order data in the first line and the detailed order data in the fourth line. The expected arrival date of the detailed order data in the first line is 8 / 15, and the expected arrival date of the detailed order data in the fourth line is 8 / 10. Therefore, the detailed order display unit 102d displays the detailed order data in the fourth line, which has the earliest expected arrival date, at the top, and the detailed order data in the first line, which has the latest expected arrival date, at the bottom, as shown in the example screen of "List of detailed order data with temporary product number (ordered by expected arrival date)" in Fig. 9.

[0064] In this way, with the temporary product number management device 100 according to this embodiment, the wholesaler's staff can accurately and easily grasp order detail data with an earlier expected arrival date, and can therefore assign permanent product numbers to products whose arrival is imminent so as to ensure that they arrive in time.

[0065] When the person in charge assigns a real part number to a product in the order detail data displayed in the order detail display unit 102d, the part number master update unit 102e updates the part number master 106a by adding a new record to the part number master 106a consisting of the assigned real part number, the manufacturer part number in the order detail data for which the real part number was assigned, and the manufacturer code in the order detail data for which the real part number was assigned.

[0066] Specifically, suppose that the wholesaler's staff member assigns the real product number "HON000003" to the detailed order data on line 4, which has an earlier expected arrival date (expected arrival date: 8 / 10). In this case, the product number master update unit 102e adds a new record to the product number master 106a, consisting of the assigned real product number "HON000003," the manufacturer's product number in the detailed order data on line 4, and the manufacturer's code in the detailed order data on line 4.

[0067] Also, assume that for the first line of detailed order data with a later expected arrival date (expected arrival date: 8 / 15), the wholesaler's employee has assigned a permanent product number "HON000004." In this case, the product number master update unit 102e adds a new record to the product number master 106a, consisting of the assigned permanent product number "HON000004," the manufacturer's product number in the first line of detailed order data, and the manufacturer's code in the first line of detailed order data.

[0068] The two records added in this way are indicated by hatching in the product number master 106a (after product number registration) in Fig. 9. The product number master update unit 102e updates the product number master 106a by adding the two records.

[0069] [4-4. Transferring temporary part numbers to real part numbers] This section explains how to transfer from a temporary part number to a real part number.

[0070] (1) Transfer of temporary part numbers in order data The temporary part number transfer unit 102f acquires the real part number linked to the manufacturer part number and the manufacturer code in the order specification data that contains the temporary part number from the part number master 106a updated by the part number master update unit 102e, and transfers the temporary part number in the order specification data to the acquired real part number.

[0071] Specifically, in order data 106c (before temporary part number transfer) in Fig. 10, the detailed order data having a temporary part number is the detailed order data in the first line (order line number 1) and the detailed order data in the fourth line (order line number 4). Therefore, temporary part number transfer section 102f obtains, from updated part number master 106a in Fig. 10, "HON000004" as the real part number linked to the manufacturer part number and manufacturer code in the detailed order data in the first line, and obtains "HON000003" as the real part number linked to the manufacturer part number and manufacturer code in the detailed order data in the fourth line.

[0072] Then, the temporary product number transfer unit 102f transfers the temporary product number "KARI000001" in the order detail data on the first line to "HON000004" and the temporary product number "KARI000001" in the order detail data on the fourth line to "HON000003", as shown in the order data 106c (after temporary product number transfer) in Figure 10.

[0073] (2) Transfer of temporary part numbers in order data The temporary part number transfer unit 102f acquires the real part number linked to the manufacturer part number and the manufacturer code in the order specification data that contains the temporary part number from the part number master 106a updated by the part number master update unit 102e, and transfers the temporary part number in the order specification data to the acquired real part number.

[0074] Specifically, in order data 106d in Fig. 10 (before temporary part number transfer), the detailed order data having temporary part numbers are the detailed order data in the first line (order number H001) and the detailed order data in the fourth line (order number H004). Therefore, temporary part number transfer unit 102f obtains "HON000004" from updated part number master 106a in Fig. 10 as the real part number linked to the manufacturer part number and manufacturer code in the detailed order data in the first line, and obtains "HON000003" as the real part number linked to the manufacturer part number and manufacturer code in the detailed order data in the fourth line.

[0075] Then, the temporary part number transfer unit 102f transfers the temporary part number "KARI000001" in the order detail data on the first line to "HON000004" and the temporary part number "KARI000001" in the order detail data on the fourth line to "HON000003", as shown in the order data 106d (after temporary part number transfer) in Figure 10.

[0076] In this way, with the temporary product number management device 100 according to this embodiment, as long as the wholesaler's staff member has registered the actual product number in the product number master 106a, the temporary product number can be automatically transferred to the actual product number, eliminating input errors that may occur during the transfer process and reducing the workload of the staff member.

[0077] [4-5. Error display] This section explains the error message that appears when an attempt is made to process a product with a temporary product number. As explained at the beginning of [4-3], if a product with the same temporary product number is processed, problems will arise in inventory management.

[0078] Therefore, the error display unit 102g displays an error when an arrival entry is made for a product specified by the order specification data having the temporary product number.

[0079] In this way, according to the temporary product number management device 100 of this embodiment, by displaying an error when an arrival process is attempted for a product with a temporary product number, even if the wholesaler's staff member has forgotten to transfer the temporary product number to the actual product number, the staff member can be made aware of this before the arrival process begins.

[0080] [5. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of SDGs Goals 8 and 9.

[0081] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0082] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.

[0083] 6. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0084] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0085] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed as desired unless otherwise specified.

[0086] Furthermore, with regard to the temporary product number management device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0087] For example, all or any part of the processing functions of temporary product number management device 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory, computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by temporary product number management device 100 as needed. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to issue commands to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

[0088] This computer program may also be stored in an application program server connected to temporary product number management device 100 via any network, and all or part of it may be downloaded as needed.

[0089] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.

[0090] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0091] The various databases stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

[0092] The temporary product number management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as an information processing device connected to any peripheral device. The temporary product number management device 100 may also be realized by installing software (including programs, data, etc.) that causes the device to perform the processing described in this embodiment.

[0093] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Industrial Applicability]

[0094] The present invention is useful, for example, in the wholesale industry, where it is necessary to manage manufacturer part numbers with large numbers of digits and also to separately manage one's own company's part numbers, and is particularly useful in industries such as machinery wholesale, electrical materials wholesale, and electronic parts wholesale. [Explanation of symbols]

[0095] 100 Temporary part number management device 102 Control section 102a Part Number Acquisition Department 102b Order data generation unit 102c Order data generation unit 102d Order details display section 102e Part Number Master Update Section 102F Temporary Part Number Transfer Section 102g Error display section 104 Communication interface unit 106 Storage section 106a Part Number Master 106b Temporary part number master 106c Order Data 106d Order Data 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. A temporary product number management device including a control unit and a storage unit, which manages a temporary product number management so that a wholesaler who wholesales new products from a manufacturer as a supplier and delivers them to a customer can receive orders from the customer and place orders with the manufacturer in advance even when the wholesaler has not yet completed the allocation of official product numbers for the new products within the company, and can manage the orders and orders using temporary product numbers for the new products, The storage unit includes: a product number master including a manufacturer product number, which is a product number assigned by the manufacturer to identify the manufacturer's product, a manufacturer code, which is a code for identifying the manufacturer, and a real product number, which is a formal product number used by the wholesaler to identify the product within the wholesaler's company; A temporary product number master containing a temporary product number which is a single temporary product number for the wholesaler to identify products within the wholesaler's company and is used until the real product number is assigned; is stored, The control unit a part number acquisition means for acquiring, from the part number master, a real part number linked to the manufacturer part number and the manufacturer code in order data managing information relating to orders from the customer, including order specification data having the manufacturer part number and the manufacturer code, and for acquiring the temporary part number from the temporary part number master when the real part number cannot be acquired; an order data generating means for completing the order data by storing the real part number or the temporary part number acquired by the part number acquiring means in each of the order specification data; an order data generation means for generating order data for managing information relating to orders to the manufacturer, including order specification data having the manufacturer part number, the manufacturer code, and the real part number or the temporary part number, based on the order data generated by the order data generation means; To have A temporary product number management device characterized by the above.

2. The order detail data further includes a scheduled arrival date of the product, The control unit an order detail display means for displaying the order detail data having the temporary part number in order of the earliest expected arrival date when the person in charge of the wholesaler assigns the real part number to the product to which the temporary part number has been assigned; a part number master updating means for updating the part number master when the person in charge assigns a real part number to a product in the order detail data displayed by the order detail display means, by adding a new record to the part number master, the new record consisting of the assigned real part number, the manufacturer part number in the order detail data that was the subject of the assignment of the real part number, and the manufacturer code in the order detail data that was the subject of the assignment of the real part number; Further comprising:

2. The temporary product number management device according to claim 1, wherein:

3. The control unit a temporary part number transfer means for acquiring the real part number linked to the manufacturer part number and the manufacturer code in the order specification data having the temporary part number from the part number master updated by the part number master update means, and transferring the temporary part number in the order specification data to the acquired real part number, and for acquiring the real part number linked to the manufacturer part number and the manufacturer code in the order specification data having the temporary part number from the part number master updated by the part number master update means, and transferring the temporary part number in the order specification data to the acquired real part number Further comprising:

3. The temporary product number management device according to claim 2, wherein:

4. The control unit An error display means for displaying an error when an arrival input is made for a product specified by the order detail data having the temporary product number. Further comprising:

2. The temporary product number management device according to claim 1, wherein:

5. The product is a mechanical part or an electronic part, The number of digits in the manufacturer's part number is greater than the number of digits in the real part number and the temporary part number; 5. The temporary product number management device according to claim 1, wherein:

6. A temporary product number management method executed by an information processing device having a control unit and a storage unit, which is capable of managing orders and orders using temporary product numbers for new products so that a wholesaler that wholesales new products from a manufacturer that is a supplier and delivers them to a customer can receive orders from the customer and place orders with the manufacturer in advance even when the wholesaler has not yet completed the allocation of official product numbers for the new products within the company, The storage unit includes: a product number master including a manufacturer product number, which is a product number assigned by the manufacturer to identify the manufacturer's product, a manufacturer code, which is a code for identifying the manufacturer, and a real product number, which is a formal product number used by the wholesaler to identify the product within the wholesaler's company; A temporary product number master containing a temporary product number which is a single temporary product number for the wholesaler to identify products within the wholesaler's company and is used until the real product number is assigned; is stored, Executed by the control unit, a part number acquisition step of acquiring, from the part number master, a real part number linked to the manufacturer part number and the manufacturer code in order data managing information relating to orders from the customer, including order detail data having the manufacturer part number and the manufacturer code, and, if the real part number cannot be acquired, acquiring the temporary part number from the temporary part number master; an order data generating step of completing the order data by storing the real part number or the temporary part number acquired in the part number acquiring step in each of the order detail data; an order data generation step of generating order data for managing information relating to orders to the manufacturer, including order specification data having the manufacturer part number, the manufacturer code, and the real part number or the temporary part number, based on the order data generated in the order data generation step; containing, A temporary product number management method characterized by the above.

7. A temporary product number management program executed by an information processing device having a control unit and a storage unit, which is capable of managing orders and orders using temporary product numbers for new products so that a wholesaler that wholesales new products from a manufacturer that is a supplier and delivers them to a customer can receive orders from the customer and place orders with the manufacturer in advance even when the wholesaler has not yet completed the allocation of official product numbers for the new products within the company, The storage unit includes: a product number master including a manufacturer product number, which is a product number assigned by the manufacturer to identify the manufacturer's product, a manufacturer code, which is a code for identifying the manufacturer, and a real product number, which is a formal product number used by the wholesaler to identify the product within the wholesaler's company; A temporary product number master containing a temporary product number which is a single temporary product number for the wholesaler to identify products within the wholesaler's company and is used until the real product number is assigned; is stored, To cause the control unit to execute a part number acquisition step of acquiring, from the part number master, a real part number linked to the manufacturer part number and the manufacturer code in order data managing information relating to orders from the customer, including order detail data having the manufacturer part number and the manufacturer code, and, if the real part number cannot be acquired, acquiring the temporary part number from the temporary part number master; an order data generating step of completing the order data by storing the real part number or the temporary part number acquired in the part number acquiring step in each of the order detail data; an order data generation step of generating order data for managing information relating to orders to the manufacturer, including order specification data having the manufacturer part number, the manufacturer code, and the real part number or the temporary part number, based on the order data generated in the order data generation step; containing, A temporary part number management program featuring:

Images