Information processing systems, information processing methods, and programs
The information processing system addresses the inefficiency of manual product information linking by using a correspondence table for automatic association, thereby reducing user workload and enhancing order processing efficiency.
Patent Information
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- CO NECT CO LTD
- Filing Date
- 2024-11-06
- Publication Date
- 2026-05-19
AI Technical Summary
Existing systems burden users with the manual task of linking product information from a product master with detailed information each time an order is placed, leading to inefficiencies in inventory management.
An information processing system that utilizes a correspondence table to associate master-side product identification information with ordering-side product identification information, allowing automatic linking of detail information with product information from the product master, and provides user interfaces for manual association when necessary.
Reduces the burden on users by automating the linking process, minimizing the need for manual intervention with product masters during order processing, thereby enhancing efficiency and reducing workload.
Smart Images

Figure 2026082099000001_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to an information processing system that executes processing related to a product master, an information processing method by the information processing system, and a program executed by a computer of the information processing system.
Background Art
[0002] Conventionally, in enterprises, individuals, and other entities (hereinafter referred to as "activity entities") that conduct economic activities, there are activity entities that receive an order from an orderer and execute delivery operations and other operations in response to the order. When placing an order, the orderer generally designates the product to be ordered (regardless of whether it is tangible or intangible, and services are also included in the product). Activity entities usually have a product master in which product ID, product name, unit price, and other product-related information are registered for each product that can be ordered, and manage each product centrally using the product master. Then, when receiving an order from an orderer, the activity entity associates the information related to the product specified in the order (hereinafter referred to as "detail information") with the information corresponding to the specified product among the product information in the product master, and uses the associated information to perform delivery operations and other operations.
[0003] Regarding the product master, Patent Document 1 describes the following technology. That is, when there is an order for a product from a store and the product is shipped from a warehouse to the store, the product inventory management device 100 acquires shipment data including the product code for logistics of the product and the shipment quantity, updates the inventory data, and when there is a receipt of the product at the store, acquires store receipt data including the product code for logistics of the product and the receipt quantity, and based on the product master, acquires product change data that defines the transfer of the product code for logistics included in the store receipt data to the product code for the store, and updates the inventory data. The above technology is described. According to Patent Document 1, it becomes possible to perform inventory management using different product codes for logistics management and store management for the same product.
Prior Art Documents
Patent Documents
[0004] [Patent Document 1] Japanese Patent Publication No. 2019-164483 [Overview of the project] [Problems that the invention aims to solve]
[0005] As mentioned above, when an order is placed by a client, the organizing body is responsible for linking the detailed information with the product information in the product master. Traditionally, the organizing body had to select the product information from the product master that corresponds to the detailed information each time an order was placed and then link them, which placed a heavy burden on the organizing body.
[0006] This invention was made to solve these problems and aims to reduce the burden on users regarding the product master data in response to orders from clients. [Means for solving the problem]
[0007] To solve the above-mentioned problems, the present invention comprises the following configuration. The information processing system acquires order information based on an order from a customer, which includes detail information having at least ordering-side product identification information for identifying a product, identifies one of the detail information to be processed as detail information, refers to a correspondence table in which master-side product identification information of a product master is associated with the ordering-side product identification information, determines on the correspondence table whether the master-side product identification information is associated with the ordering-side product identification information of the detail information to be processed, links the detail information to be processed with the product information from the product master that corresponds to the master-side product identification information associated with the ordering-side product identification information of the detail information to be processed on the correspondence table, and provides the user with a first user interface for setting the desired master-side product identification information to be associated with the ordering-side product identification information of the detail information to be processed on the correspondence table, and includes an information processing unit that has a function to update the contents of the correspondence table so that the setting made to the first user interface is reflected. [Effects of the Invention]
[0008] According to the present invention configured as described above, once a master-side product identification information is associated with a single ordering-side product identification information on the correspondence relationship table, thereafter, when an order is placed for that single ordering-side product identification information, the correspondence relationship table is used to automatically link the detail information related to that single ordering-side product identification information with the product information in the product master. Therefore, the user (active entity) does not need to "link the detail information with the product information in the product master every time an order is placed," and the burden of work that the user has to do with the product master in response to orders from ordering parties is reduced. Furthermore, when an order is placed, if the master-side product identification information is not associated with the ordering-side product identification information of the processing target detail information on the correspondence relationship table, the user is provided with a user interface to set up the association of the desired master-side product identification information with the ordering-side product identification information of the processing target detail information. Therefore, the user can register in the correspondence relationship table by simple means, and in this respect as well, the burden of work that the user has to do with the product master in response to orders from ordering parties is reduced. [Brief explanation of the drawing]
[0009] [Figure 1] This figure shows an example configuration of a control system according to one embodiment. [Figure 2] This block diagram shows an example of the functional configuration of an information processing server and a user terminal according to one embodiment. [Figure 3] This figure shows an example of a purchase order. [Figure 4] This figure shows an example of the contents of the product master. [Figure 5] This flowchart shows the information processing methods for user terminals and information processing servers. [Figure 6] This figure shows an example of the contents of basic order data 24. [Figure 7] This is a flowchart showing the information processing methods of an information processing server. [Figure 8] This figure shows an example of the contents of a correspondence table. [Figure 9] This is a diagram used to explain the master data update information. [Figure 10] It is a diagram showing an example of the content of the coefficient table. [Figure 11] It is a diagram showing an example of the order-related screen. [Figure 12] It is a flowchart showing an information processing method of the user terminal and the information processing server. [Figure 13] It is a diagram showing an example of the screen for registering the correspondence relationship. [Figure 14] It is a diagram showing an example of the content of the correspondence table. [Figure 15] It is a flowchart showing an information processing method of the user terminal and the information processing server. [Figure 16] It is a diagram showing an example of the screen for registering the adjustment coefficient. [Figure 17] It is a diagram showing an example of the content of the coefficient table. [Figure 18] It is a diagram showing an example of the order-related screen. [Figure 19] It is a diagram showing the input and output of the present model. [Figure 20] It is a diagram showing a configuration example of the information processing system.
Embodiments for Carrying Out the Invention
[0010] Hereinafter, an embodiment of the present invention will be described based on the drawings. FIG. 1 is a diagram showing a configuration example of a control system 1 (information processing system) according to the present embodiment. As shown in FIG. 1, the control system 1 includes an information processing server 2 (information processing system, server, computer) and a user terminal 3 (information processing system, terminal, computer). Both the information processing server 2 and the user terminal 3 can be connected to a network N including the Internet, a telephone network, and other communication networks.
[0011] The information processing server 2 is a server device connected to the network N. The information processing server 2 has a function of providing various services to be described later to the user. Hereinafter, the services provided by the information processing server 2 are referred to as "the services of this case". The user has registered for the services of this case and can log in to the account of the services of this case using his / her own login information (for example, a combination of a login ID and a password). In FIGS. 1 and 2, the information processing server 2 is represented by one block. However, this does not mean that the information processing server 2 is composed of a single device. For example, the information processing server 2 may include virtual servers. Also, for example, the information processing server 2 may be composed of a plurality of devices. In this case, the devices constituting the information processing server 2 may include a web server, a web application server, or a database server. Also, in this case, the information processing server 2 may be composed of a plurality of server devices that are load-balanced by a load balancer. When the information processing server 2 is composed of a plurality of devices, each of the information processing units of the plurality of devices, or a plurality of combinations, functions as an "information processing unit".
[0012] The user terminal 3 is a terminal used by the user. In the present embodiment, the user refers to one who can use the services of this case. However, as the user, a subject (hereinafter referred to as "activity subject") that conducts some economic activities and receives an order from a business partner (a concept including customers here) in the process of economic activities is assumed. The activity subject is, for example, an organization or an individual that conducts economic activities related to retail, wholesale, service, food and beverage, construction, and other industries. As described above, the user may be an organization, but hereinafter, for convenience of explanation, not only the user as an organization but also an individual belonging to the organization is simply expressed as "user". The type of the user terminal 3 may be anything. For example, a desktop computer, a notebook computer, a tablet computer (including a so-called smartphone), or a wearable terminal can function as the user terminal 3.
[0013] Figure 2 is a block diagram showing an example of the functional configuration of the information processing server 2 and the user terminal 3. As shown in Figure 2, the information processing server 2 has a functional configuration comprising a server information processing unit 10 (information processing unit), a server communication unit 11, and a server storage unit 12. The user terminal 3 has a functional configuration comprising a terminal information processing unit 13 (information processing unit), a terminal communication unit 14, a terminal display unit 15, a terminal input unit 16, and a terminal storage unit 17.
[0014] The server information processing unit 10 comprises a processing unit including a processor and a primary storage device. The server information processing unit 10 performs processing by having the processing unit read programs stored in the storage area of the server storage unit 12 (or other storage areas) into the primary storage device and execute them. In other words, the server information processing unit 10 performs processing through the cooperation of hardware and software. The server communication unit 11 comprises a communication device including a communication control device and a network interface. The server communication unit 11 communicates with external devices via the communication device under the control of the server information processing unit 10. Hereinafter, it will be assumed that communication by the information processing server 2 is appropriately performed by the server communication unit 11, and explanations regarding communication will be omitted. The server storage unit 12 stores data in non-volatile memory. Non-volatile memory is, for example, a hard disk drive (or other magnetic storage device), ROM, or flash memory.
[0015] The terminal information processing unit 13 comprises a processing unit including a processor and a primary storage device. The terminal information processing unit 13 performs processing by having the processing unit read a program stored in the storage area of the terminal storage unit 17 (or other storage area) into the primary storage device and execute it. In other words, the terminal information processing unit 13 performs processing through the cooperation of hardware and software. The terminal communication unit 14 comprises a communication device including a communication control device and a network interface. The terminal communication unit 14 communicates with external devices via the communication device under the control of the terminal information processing unit 13. Hereinafter, communication by the user terminal 3 will be appropriately performed by the terminal communication unit 14, and explanations regarding communication will be omitted. The terminal display unit 15 comprises a liquid crystal panel, an organic EL panel, or other display device. The terminal display unit 15 displays an image on the display device under the control of the terminal information processing unit 13. The terminal input unit 16 detects input to an input device and outputs the detection result to the terminal information processing unit 13. Input devices include, for example, a keyboard, mouse, touch panel, and camera. The terminal storage unit 17 stores data in non-volatile memory.
[0016] Next, we will explain the operation of control system 1. In the following explanation, we will assume that "User of Interest" is one of the users. This User of Interest is a company that supplies food and beverages. The User of Interest has multiple customers and receives orders from multiple customers. Orders from customers can be made in various ways, but one method is for purchase orders to be sent by fax, email attachment, or other means. Figure 3 shows purchase order H1, which is an example of a purchase order provided to the User of Interest by T1 Corporation, one of the Customer of Interest's customers. Purchase order H1 records the order date and time, desired delivery date, information about the orderer, information about the delivery address, the subtotal (amount excluding tax) for the entire order, and the total (amount including tax) for the entire order. Although the format of purchase orders varies, it is common for this information to be recorded on the purchase order.
[0017] As shown in Figure 3, the order form H1 is provided with a detail area 20, and in the detail area 20, order item information 21 (detail line) is recorded for each item being ordered. The order item information 21 related to the order form H1 includes the ordering party's part number (labeled as part number in Figure 3), the ordering party's product name (labeled as product name in Figure 3), the ordering party's quantity (labeled as quantity in Figure 3), the ordering party's unit (labeled as unit in Figure 3), which is the unit of quantity for the product, the ordering party's unit price (labeled as unit price in Figure 3), and the ordering party's remarks (labeled as remarks in Figure 3). In this embodiment, the combination of the ordering party's part number and the ordering party's product name functions as identification information to identify the product. Hereinafter, the combination of the ordering party's part number and the ordering party's product name will be referred to as the "ordering party product ID" (ordering party product identification information).
[0018] It is common for the item values exemplified in Purchase Order H1 in Figure 3 to be recorded in the ordered product information of the purchase order. However, other information such as subtotals may also be recorded in the ordered product information. As mentioned above, orders can be placed by means other than sending a purchase order. For example, they can be placed by sending a CSV file containing information that replaces the purchase order. However, regardless of the method of ordering, in principle, the ordering party will communicate information equivalent to the ordered product information 21 to the operating entity for each ordered product. In the following, the operation of the control system 1 will be explained using the case in which a user of interest receives Purchase Order H1 shown in Figure 3 and uses the service in relation to this Purchase Order H1 as an example.
[0019] Furthermore, the server storage unit 12 stores a product master 22 for each user, and a product master 22 is also stored for the user of interest. Figure 4 is a diagram showing the contents of the product master 22 for the user of interest. As shown in Figure 4, the product master 22 has a product master record 23 (record) for each product. The product master record 23 corresponds to the product information of the product master 22. As shown in Figure 4, the product master record 23 is composed of a master-side product ID (master-side product identification information), which is the identification information of the product; a master-side product name, which indicates the product name; a master-side unit, which is the unit of quantity of the product; a master-side unit price, which indicates the unit price of the product; and a master-side remark, which indicates a note. In addition to the information in the product master record 23 of the product master 22 according to this embodiment, the product master record 23 of the product master 22 may also contain various other information about the product. In the following description, the product master 22 used for the user of interest is the product master 22 of the user of interest unless otherwise specified.
[0020] Figure 5 is a flowchart showing the operation of the control system 1. The symbol FA indicates the information processing method by the user terminal 3, and the symbol FB indicates the information processing method by the information processing server 2. When using the service, the user in question launches the browser on the user terminal 3 and instructs it to access a predetermined URL on the information processing server 2. This predetermined URL is the URL of the main screen of the service. In response to this instruction, the terminal information processing unit 13 accesses the predetermined URL using the browser's functions. When accessing the URL, the user in question logs in to the service using an appropriate method. When the server information processing unit 10 of the information processing server 2 receives access to the predetermined URL, it performs the necessary authentication and responds to the terminal information processing unit 13 with display data (HTML file and data attached to the HTML file) to display the main screen. The terminal information processing unit 13 receives the display data and displays the main screen on the terminal display unit 15 based on the display data using the browser's functions.
[0021] In the following, it is assumed that HTTP communication with the server information processing unit 10 naturally occurs when the terminal information processing unit 13 displays various screens, and therefore, detailed explanations regarding such HTTP communication may be omitted. Furthermore, the detection of operations on various screens displayed based on the display data sent from the server information processing unit 10 to the terminal information processing unit 13, the acquisition of information entered into various screens, the dynamic modification of various screens, and other screen-related processing are assumed to be appropriately executed by the server information processing unit 10 and the terminal information processing unit 13 using CGI, JavaScript (registered trademark), Ajax, DHTML, and other technologies, and detailed explanations will not be provided. In the following, the display of various screens on the terminal display unit 15 by the terminal information processing unit 13 using the functions of a browser or other program will be expressed as "the terminal information processing unit 13 works with the server information processing unit 10 to display the ○○ screen on the terminal display unit 15" or simply "the terminal information processing unit 13 displays the ○○ screen."
[0022] Referring to flowchart FA, after the main screen is displayed, the user in question performs a predetermined operation on the main screen to instruct the display of the upload screen (step SA1). In response to this instruction, the terminal information processing unit 13 displays the upload screen on the terminal display unit 15 (step SA2). The upload screen is for uploading basic order data 24 to the information processing server 2. Basic order data 24 is structured data in which the detailed information 25 of the basic purchase order (or information equivalent to a purchase order) for the target order is recorded in a predetermined data structure. The detailed information 25 is information that holds specific item values among the item values of the ordered product information 21. All combinations of the detailed information 25 correspond to "order information 26". The basic order data 24 can be configured as, for example, CSV data, JSON data, or "data in a predetermined file format related to spreadsheet software".
[0023] The user generates basic order data 24 in advance for purchase order H1 and stores it in the terminal storage unit 17. Figure 6 shows the basic order data 24 based on purchase order H1. As shown in Figure 6, the basic order data 24 includes detail information 25-1 to 25-4 corresponding to each of the ordered product information 21-1 to 21-4 of purchase order H1. The detail information 25 includes the ordering party's product number, ordering party's product name, ordering party's quantity, ordering party's unit, ordering party's unit price, and ordering party's remarks as item values. As mentioned above, in the detail information 25, the combination of the ordering party's product number and ordering party's product name corresponds to the "ordering party's product ID". Hereafter, the specific value of the ordering party's product ID will be expressed in the format "product number-product name". For example, the ordering party's product ID for detail information 25-1 in Figure 6 will be expressed as "XY01-milk". Order information 26 is "order information based on an order from the ordering party, which includes detailed information 25 that has at least an ordering party product ID (ordering party product identification information) for identifying the product."
[0024] The user in question specifies the basic order data 24 on the upload screen and instructs the upload of the data (step SA3). In response to this instruction, the terminal information processing unit 13 uploads (sends) the basic order data 24 to the information processing server 2 (step SA4). As shown in the flowchart FB, the server information processing unit 10 receives the basic order data 24 (step SB1). Next, the server information processing unit 10 performs the initial analysis process (step SB2). Step SB2 will be described in detail below.
[0025] The symbol FC in Figure 7 is a flowchart showing the information processing method of the information processing server 2 when it performs the initial analysis process. As shown in Figure 7, the server information processing unit 10 obtains order information 26 from the received basic order data 24 (step SC1). Next, the server information processing unit 10 obtains each of the detail information 25 included in the order information 26 (step SC2). Next, the server information processing unit 10 determines whether or not there is any unprocessed detail information 25 (step SC3). If there is none (step SC3: NO), the server information processing unit 10 terminates the initial analysis process. If there is any (step SC3: YES), the server information processing unit 10 identifies one of the unprocessed detail information 25 as the detail information to be processed (step SC4). Hereinafter, the ordering side product ID of the detail information to be processed will be referred to as the "processing target ID". Furthermore, the ordering party's part number, ordering party's product name, ordering party's quantity, ordering party's unit, ordering party's unit price, and ordering party's remarks in the details information to be processed are referred to as the processing target part number, processing target product name, processing target quantity, processing target unit, processing target unit price, and processing target remarks, respectively.
[0026] Next, the server information processing unit 10 refers to the correspondence table 28 (step SC5). Figure 8 shows the contents of the correspondence table 28 in this example. As shown in Figure 8, the correspondence table 28 is a table in which master product IDs are associated with ordering product IDs, and a correspondence record 29 is registered for each combination of ordering product ID and master product ID. The correspondence record 29 means that the product corresponding to the corresponding ordering product ID and the product corresponding to the corresponding master product ID are in correspondence (match).
[0027] For example, if we focus on the first correspondence record in the correspondence table 28 in Figure 8, in this correspondence record, the ordering product ID: "XY01-Milk" is associated with the master product ID: "MS01". This means that the product with ordering product ID: "XY01-Milk" and the product with master product ID: "XY01" are associated (match). As will be described later, the setting to associate the ordering product ID with the master product ID on the correspondence table 28 (= registration of correspondence records 29 in the correspondence table 28) is done according to the user's instructions. For this reason, there may be ordering product IDs on the correspondence table 28 that have not yet been associated with a master product ID. As shown in Figure 8, in this example, in the correspondence table 28, the ordering product ID "XY01-Milk" is associated with the master product ID "MS01", the ordering product ID "XY02-Chicken" is associated with the master product ID "MS02", and the ordering product ID "XY03-Pork Shoulder Loin" is associated with the master product ID "MS03". On the other hand, the ordering product ID "XY04-Cabbage" (the ordering product ID corresponding to detail information 25-4) does not yet have a master product ID associated with it. In the following explanation, the process of setting up the association of ordering product IDs with master product IDs in the correspondence table 28 may be simply referred to as "registering a correspondence".
[0028] After step SC5, the server information processing unit 10 determines whether a master product ID is associated with the processing target ID on the correspondence table 28 (whether a correspondence record 29 corresponding to the processing target ID exists) (step SC6). If no association is made (step SC6: NO), the server information processing unit 10 determines that the status of the processing target detail information is "correspondence not registered" (step SC7). Next, the server information processing unit 10 generates master reflected detail information 30 based on the processing target detail information (step SC8). Figure 9 is a diagram used to explain the master reflected detail information 30 in this example. In Figure 9, information used for explanation is recorded in addition to the master reflected detail information 30. As shown in Figure 9, the master reflected detail information 30 has the following item values: reflected product number, reflected product name, reflected quantity, reflected unit, reflected unit price, reflected ordering side remarks, and reflected master side remarks.
[0029] In this embodiment, the server information processing unit 10 generates master reflected detail information 30 in which all item values are null for detail information to be processed whose status is "correspondence not registered". Therefore, in step SC8, the server information processing unit 10 generates master reflected detail information 30 in which all item values are null. In this example, detail information 25-4 for ordering side product ID: "XY04-Cabbage" does not have a correspondence registered in the correspondence table 28 (see Figure 8). Therefore, if detail information 25-4 is detail information to be processed, the server information processing unit 10 determines its status to be "correspondence not registered" in step SC7 and generates master reflected detail information 30 in step SC8 in which each item value is null. After step SC8, the server information processing unit 10 moves the processing procedure to step SC3.
[0030] On the other hand, if it is determined in SC6 that a correspondence exists (step SC6: YES), the server information processing unit 10 executes the linking-related processing (step SC9). The linking-related processing is the process of linking the "record in the product master record 23 (product information) of the product master 22 that corresponds to the master-side product ID that is associated with the ordering-side product ID of the processing target detail information on the correspondence relationship table 28" with the processing target detail information. Step SC9 will be described in detail below. In step SC9, the server information processing unit 10 refers to the correspondence relationship table 28 and identifies the master-side product ID that is associated with the processing target ID in that table. Next, the server information processing unit 10 refers to the product master 22 and identifies the record in the product master record 23 of the product master 22 that corresponds to the identified master-side product ID. Hereinafter, the product master record identified here will be called the "specific product master record". In this embodiment, identifying the specific product master record corresponds to linking the product master record 23 of the product master 22 with the processing target detail information.
[0031] For example, referring to Figures 6 and 8, if the item information to be processed is item information 25-1, the product master record 23 with master product ID: "MS01" is identified as the specific product master record. Also, for example, if the item information to be processed is item information 25-2, the product master record 23 with master product ID: "MS02" is identified as the specific product master record. Also, for example, if the item information to be processed is item information 25-3, the product master record 23 with master product ID: "MS03" is identified as the specific product master record. This concludes the explanation of step SC9. Note that the specific details of the linking are not limited to those exemplified in this embodiment. In other words, any content is acceptable as long as the product master record corresponding to the item information to be processed is identified.
[0032] After step SC9, the server information processing unit 10 determines whether the ordering unit of the item information to be processed and the master unit of the specific product master record are identical (step SC10). Identical means that they are substantially the same regardless of their display format or string consistency. For example, "kg" and "kg" are naturally identical as ordering unit and master unit, but "kg" and "kilogram" are also identical. On the other hand, "kg" and "pack" are not identical for each piece of information.
[0033] If the items are identical (Step SC10: YES), the server information processing unit 10 determines the status of the item information to be processed as "Registration Complete" (Step SC11). Next, the server information processing unit 10 generates master reflected item information 30 based on the item information to be processed (Step SC12). In detail, referring to Figure 9, if the status is "Registration Complete," the server information processing unit 10 generates master reflected item information 30 in the following way. Specifically, the server information processing unit 10 uses the master-side item number, master-side item name, master-side unit, master-side unit price, and master-side remarks of the specific product master record for the reflected item number, reflected item name, reflected unit, reflected unit price, and reflected master-side remarks among the item values of the master reflected item information 30. The server information processing unit 10 also uses the ordering-side quantity and ordering-side remarks of the item information to be processed for the reflected quantity and reflected ordering-side remarks of the item information to be processed. In this example, if detail information 25-1 is the detail information to be processed, the server information processing unit 10 reflects its status as "Registration Complete" in step SC11, and generates master-reflected detail information 30 in step SC12 using the method described above. Master-reflected detail information 30 can be described as information obtained by converting the predetermined item values of detail information 25 to item values managed in the product master 22. Because master-reflected detail information 30 is this type of information, it is data that can be handled by the core system of a user of interest who performs various processes using the product master 22. The above is a detailed explanation of step SC12. After step SC12, the server information processing unit 10 moves the processing procedure to step SC3.
[0034] If it is determined in step SC10 that the products do not have the same identity (step SC10: NO), the server information processing unit 10 refers to the coefficient table 32 (step SC13). Figure 10 shows an example of the contents of the coefficient table 32. The coefficient table 32 is a table in which adjustment coefficients are associated with ordering product IDs, and a record (hereinafter referred to as "coefficient record") is registered for each combination of ordering product ID and adjustment coefficient. An adjustment coefficient is a coefficient that should be multiplied by the ordering quantity when changing the ordering unit to the master unit. The adjustment coefficient will be explained below with a specific example. In this example, T1 Corporation, a trading partner of the user of interest, manages the quantity of "chicken" in "kg" (see Figures 3 and 6). Therefore, as shown in Figure 6, the ordering unit in the detailed information 25-2 related to the ordering of chicken is "kg". On the other hand, the user of interest manages chicken in "packs" of 500g. Therefore, as shown in Figure 4, in the product master 22, the master unit for the product master record 23 related to "chicken" (the record with master product ID: "MS02") is "pack". In this situation, if T1 Corporation places an order for 3 kg of chicken, the user in question needs to replace this with 6 packs of chicken (500g per pack x 6 = 3 kg) and deliver 6 packs of chicken. Therefore, in order to change the order unit to the master unit, the order quantity must be multiplied by a coefficient of "2". In other words, in order to change the "3 kg" in the order to "6 packs" as reflected in the product master 22, the order quantity value "3" must be multiplied by a coefficient of "2". This coefficient "2" corresponds to the adjustment coefficient.
[0035] As will be described later, the setting to associate adjustment coefficients with ordering product IDs on the coefficient table 32 (= registration of coefficient records in the coefficient table 32) is performed according to the user's instructions. For this reason, there may be ordering product IDs to which adjustment coefficients should be associated, but which have not yet been associated with adjustment coefficients on the coefficient table 32. Referring to Figure 10, and taking the above circumstances into account, in the coefficient table 32 related to this example, the adjustment coefficient "2" is associated with ordering product ID: "XY02-Chicken". On the other hand, the adjustment coefficient has not yet been associated with ordering product ID: "XY03-Pork Shoulder Loin". In the following explanation, the setting to associate adjustment coefficients with ordering product IDs on the coefficient table 32 may be simply expressed as "registering adjustment coefficients".
[0036] After step SC13, the server information processing unit 10 determines whether or not an adjustment coefficient has been associated with the processing target ID (step SC14). If it has been associated (step SC14; YES), the server information processing unit 10 determines the status of the processing target detail information to be "Coefficient Registered" (step SC15). Next, the server information processing unit 10 derives a quantity obtained by multiplying the processing target quantity by the adjustment coefficient (the adjustment coefficient associated with the processing target ID) (step SC16). Hereinafter, the quantity derived here will be called the "adjusted quantity". Next, the server information processing unit 10 generates master reflected detail information 30 based on the processing target detail information and the adjusted quantity (step SC17). For details, refer to Figure 9, and when the status is coefficient registered, the server information processing unit 10 generates master reflected detail information 30 in the following way. In other words, the server information processing unit 10 sets the reflected product number, reflected product name, reflected unit, reflected unit price, and reflected master-side remarks of the specific product master record as the master-side product number, master-side product name, master-side unit, master-side unit price, and master-side remarks of the reflected product details information 30. The server information processing unit 10 also sets the reflected quantity as the "adjusted quantity" among the item values of the master reflected product details information 30. Furthermore, the server information processing unit 10 sets the reflected ordering-side remarks of the reflected ordering-side remarks of the processed product details information 30 as the ordering-side remarks of the processed product details information. In this example, if product details information 25-2 is the processed product details information, the server information processing unit 10 determines its status as "coefficient registered" in step SC15, derives the adjusted quantity in step SC16, and generates the master reflected product details information 30 in step SC17 using the method described above. The above is the details of step SC17. After step SC17, the server information processing unit 10 moves the processing procedure to step SC3.
[0037] If it is determined in step SC14 that no correspondence exists (step SC14: NO), the server information processing unit 10 determines the status of the processing target detail information to be "Coefficient not registered" (step SC18). Next, the server information processing unit 10 generates master reflected detail information 30 based on the processing target detail information (step SC19). In detail, referring to Figure 9, if the status is coefficient not registered, the server information processing unit 10 generates master reflected detail information 30 in the following way. Specifically, the server information processing unit 10 sets the reflected part number, reflected product name, reflected unit price, and reflected master-side remarks of the item values of the master reflected detail information 30 to the master-side part number, master-side product name, master-side unit price, and master-side remarks of the specific product master record. The server information processing unit 10 also sets the reflected quantity and reflected unit of the item values of the master reflected detail information 30 to "null value". The server information processing unit 10 also sets the reflected ordering-side remarks of the processing target detail information to the ordering-side remarks of the item value of the master reflected detail information. In this example, if detail information 25-3 is the detail information to be processed, the server information processing unit 10 determines its status to be "coefficient not registered" in step SC18, and generates master reflected detail information 30 in step SC19 using the method described above. The above is a detailed explanation of step SC19. After step SC19, the server information processing unit 10 moves the processing procedure to step SC3.
[0038] The above is a detailed description of the initial analysis process. Once the initial analysis process is complete, the status of each item in the order information 26 is determined, and master reflected item information 30 is generated. The server information processing unit 10 registers each of the master reflected item information 30 in a predetermined database.
[0039] Now, referring to the flowchart FB in Figure 5, the server information processing unit 10 generates display data for the initial order-related screen 33 using at least the basic order data 24 and the master reflected detail information 30 for each detail information 25, and sends it to the terminal information processing unit 13 (step SB3). The terminal information processing unit 13 receives the display data and displays the initial order-related screen 33 on the terminal information processing unit 13 based on the display data (step SA5).
[0040] Figure 11 shows the initial state of the order-related screen 33. As shown in Figure 11, the order information 26 recorded in the basic order data 24 is displayed at the top of the order-related screen 33. In the order information 26, a record is created for each of the detail information 25, and the contents of each detail information 25 are clearly indicated. Also, below the order information 26 on the order-related screen 33, the master-reflected order information 34 is displayed. The master-reflected order information 34 consists of each of the master-reflected detail information 30 that corresponds to each of the detail information 25. In the master-reflected order information 34, a record is created for each of the master-reflected detail information 30. In each record, a cell 35 (square) is provided for each item value, and the item value is shown in each cell 35. However, if the item value is a null value, the cell is left blank, and it is clearly indicated that the item value is a null value. The default background color of the cell 35 is "white". Each cell 35 is selectable, and when a cell 35 is selected, the item value of that cell 35 becomes editable. Editing item values includes setting new values for null values. The server information processing unit 10 works in cooperation with the terminal information processing unit 13 to update the contents of the master reflection detail information 30 registered in a predetermined database when an item value of a certain master reflection detail information 30 is edited.
[0041] In Figure 11, the master reflection detail information 30-1, 30-2, 30-3, and 30-4 correspond to detail information 25-1, 25-2, 25-3, and 25-4, respectively. Below, the status of detail information 25 and master reflection detail information 30 are the same. As mentioned above, the status of master reflection detail information 30-1 is "Registration Complete," the status of master reflection detail information 30-2 is "Coefficient Registered," the status of master reflection detail information 30-3 is "Coefficient Not Registered," and the status of master reflection detail information 30-4 is "Correspondence Not Registered." In the master reflection order information 34, the terminal information processing unit 13 changes the background color of the cell 35 corresponding to the reflection quantity and reflection unit to yellow for master reflection detail information 30 in the master reflection detail information 30 where the coefficient is not registered, thereby notifying the user of interest that the adjustment coefficient is not registered. Furthermore, the terminal information processing unit 13 displays a coefficient registration button 36 to the right of the master reflection detail information 30 in the state where the coefficient has not been registered. This button is selected when setting up the process to associate a desired adjustment coefficient with the corresponding ordering side product ID (ordering side product identification information of the processing target detail information) on the coefficient table 32.
[0042] Furthermore, in the master reflected order information 34, the terminal information processing unit 13 sets the background color of all corresponding cell 35s to yellow for master reflected detail information 30 where the correspondence relationship has not been registered. This notifies the user of interest that the correspondence relationship has not been registered. In addition, the terminal information processing unit 13 displays a correspondence relationship registration button 37 to the right of the master reflected detail information 30 where the correspondence relationship has not been registered. This button is selected when setting up the correspondence relationship table 28 to associate the desired master product ID with the corresponding ordering product ID (ordering product identification information of the processing target detail information).
[0043] The following describes the operation of the control system 1 when the corresponding relationship registration button 37 is selected by the user of interest, and the operation of the control system 1 when the coefficient registration button 36 is selected.
[0044] ● Operation of the control system 1 when the correspondence registration button 37 is selected. Figure 12 is a flowchart showing an example of the operation of the control system 1 when the correspondence registration button 37 is selected. In Figure 12, the symbol FD indicates the information processing method by the user terminal 3, and the symbol FE indicates the information processing method by the information processing server 2. As shown in flowchart FD, the user of interest selects the correspondence registration button 37 (step SD1). In response to this selection, the terminal information processing unit 13 notifies the server information processing unit 10 that the button has been selected (step SD2). Upon receiving this notification, the server information processing unit 10 executes the proposed information identification process (step SE1). Step SE1 will be described in detail below. In the following explanation, the detail information 25 (processing target detail information) corresponding to the master reflected detail information 30 for which the correspondence registration button 37 was selected will be referred to as the "first detail information".
[0045] First, the server information processing unit 10 derives the similarity between the ordering party's product name corresponding to the first detail information and the master-side product name of each product in the product master 22. The server storage unit 12 stores a program that implements an algorithm to derive similarity between two different product names, reflecting the string matching / similarity, and the server information processing unit 10 derives the similarity using the function of this program. Next, the server information processing unit 10 identifies the product master record 23 corresponding to the master-side product name whose similarity is above a predetermined threshold. Hereafter, the product master record 23 identified here will be called the "proposed product master record" (proposed information). The higher the similarity between the ordering party's product name and the master-side product name, the higher the probability that each product corresponds to each product. The above is a detailed explanation of step SE1.
[0046] After step SE1, the server information processing unit 10 generates display data to display the correspondence registration screen 40 (first user interface) based on the identified proposed product master record, product master 22, and other information, and transmits it to the terminal information processing unit 13 (step SE2). The terminal information processing unit 13 receives the display data and displays the correspondence registration screen 40 based on the display data. Figure 13 shows an example of the correspondence registration screen 40 in this example.
[0047] As shown in Figure 13, the correspondence registration screen 40 displays the first detail information (in this example, detail information 25-4). The correspondence registration screen 40 also displays the ordering side product ID to which the master side product ID should be associated using this screen. The correspondence registration screen 40 also has a product master display area 41 in which each of the product master records 23 of the product master 22 is displayed in a list. In this area, radio buttons 42 are provided in association with each of the product master records 23, allowing the user to select any one product master record 23. The user can use the radio buttons 42 to select the master side product ID from the product master records 23 to be associated with the ordering side product ID.
[0048] In the product master display area 41, the proposed product master record identified in the proposed information identification process of step SE1 is displayed at the top of the area, and an exclamation mark is associated with it. In other words, the proposed product master record is displayed with a high priority. This allows the user to accurately recognize master product IDs that are highly likely to be associated with the ordering product ID, prioritizing their recognition. This reduces the burden on the user in searching for the appropriate master product ID.
[0049] The interested user checks the radio button 42 for the desired product master record 23 and then selects the confirm button 43, thereby setting the desired master product ID to correspond to the ordering product ID of the item to be processed on the correspondence table 28 (step SD4). The correspondence registration screen 40 corresponds to "the first user interface for setting the desired master product ID to correspond to the ordering product ID of the item to be processed on the correspondence table 28" and "the first user interface in which the product master record 23 (product information) of the product master 22 is displayed with the similarity reflected." The terminal information processing unit 13 has the function of providing the first user interface to the user.
[0050] When the confirmation button 43 is selected, the terminal information processing unit 13 notifies the server information processing unit 10 that the confirmation button 43 has been selected (step SD5). In response to this notification, the server information processing unit 10 updates the contents of the correspondence table 28 so that the settings made on the correspondence registration screen 40 are reflected (step SE3). In this example, the user of interest uses the correspondence registration screen 40 in Figure 13 to associate the ordering side product ID: "XY04-Cabbage" with the master side product ID: "MS04". Figure 14 shows how, as a result of the settings made by the user of interest in this example, the master side product ID: "MS04" is associated with the ordering side product ID: "XY04-Cabbage" on the correspondence table 28.
[0051] Thus, once a specific master product ID (in this example, "MS04") is associated with the ordering product ID "XY04-Cabbage" on the correspondence table 28, when a customer places an order for a product related to ordering product ID "XY04-Cabbage" and the initial analysis process is performed, the correspondence table 28 is referenced for the detail information 25 of ordering product ID "XY04-Cabbage," and the link between the detail information 25 and the product master record is automatically executed. In other words, the user of interest no longer needs to register the correspondence for ordering product ID "XY04-Cabbage," thus reducing the workload for the user of interest.
[0052] After step SE3, the server information processing unit 10 refers to the updated correspondence table 28 for the "first detail information" and associates it with the appropriate product master record 23, and generates master reflection detail information using the associated product master record 23 (step SE4). Next, the server information processing unit 10 sends the generated master reflection detail information to the terminal information processing unit 13 and instructs it to update the order-related screen 33 (step SE5). The terminal information processing unit 13 updates the master reflection detail information of the first detail information in accordance with the instruction (step SD6). The above is a description of the operation of the control system 1 when the correspondence registration button 37 is selected.
[0053] ● Operation of the control system 1 when the coefficient registration button 36 is selected. Figure 15 is a flowchart showing an example of the operation of the control system 1 when the coefficient registration button 36 is selected. In Figure 15, the symbol FF indicates the information processing method by the user terminal 3, and the symbol FG indicates the information processing method by the information processing server 2. As shown in flowchart FF, the user of interest selects the coefficient registration button 36 associated with the master reflected detail information 30 (step SF1). In the following explanation, the detail information 25 (processing target detail information) corresponding to the master reflected detail information 30 for which the coefficient registration button 36 was selected will be referred to as the "second detail information".
[0054] In response to the selection of the coefficient registration button 36, the terminal information processing unit 13, in cooperation with the server information processing unit 10, displays the coefficient registration screen 45 on the terminal display unit 15 (step SF2). Figure 16 shows an example of the coefficient registration screen 45 in this example. As shown in Figure 16, the coefficient registration screen 45 displays the second detail information. The coefficient registration screen 45 also displays the product master record 23 linked to the second detail information. The coefficient registration screen 45 is provided with an adjustment coefficient input field 46, which is an input field for entering the value of the adjustment coefficient. In this example, the user of interest enters an appropriate value for the adjustment coefficient (in this example, "2") in the adjustment coefficient input field 46 and selects the confirmation button 47 (step SF3). This allows the user of interest to set up the coefficient table 32 to associate the desired value of the adjustment coefficient with the ordering product ID of the processing target detail information. The coefficient registration screen 45 corresponds to "a second user interface for setting up the coefficient table 32 to associate the desired value of the adjustment coefficient with the ordering product ID of the processing target detail information." The terminal information processing unit 13 has a function to provide the user with a second user interface.
[0055] When the confirmation button 47 is selected, the terminal information processing unit 13 notifies the entered adjustment coefficient (step SF4). In response to this notification, the server information processing unit 10 updates the contents of the coefficient table 32 so that the settings made on the coefficient registration screen 45 are reflected (step SG1). Figure 17 shows how, in this example, as a result of the settings made by the user of interest, the adjustment coefficient "2" is associated with the ordering product ID "XY03-Pork Shoulder Loin" on the coefficient table 32.
[0056] In this way, once an adjustment coefficient is associated with the ordering party product ID: "XY03-Pork Shoulder Loin" on the coefficient table 32, thereafter, when a customer places an order for the product related to ordering party product ID: "XY03-Pork Shoulder Loin" and the initial analysis process is performed, the coefficient table 32 is referenced for the detailed information 25 of ordering party product ID: "XY03-Pork Shoulder Loin" and the quantity and unit are adjusted. In other words, the user of interest does not need to perform the task of adjusting the quantity and unit for ordering party product ID: "XY03-Pork Shoulder Loin" thereafter, thus reducing the workload of the user of interest.
[0057] After step SG1, the server information processing unit 10 refers to the updated coefficient table 32 for the "second detail information" to derive the adjusted quantity from the ordering quantity, and uses this to generate the master reflected detail information 30 (step SG2). Next, the server information processing unit 10 sends the generated master reflected detail information 30 to the terminal information processing unit 13 and instructs it to update the order-related screen 33 (step SG3). The terminal information processing unit 13 updates the master reflected detail information 30 of the second detail information (master reflected detail information 30-3 in this example) in response to this instruction (step SF5). The above is a description of the operation of the control system 1 when the correspondence registration button 37 is selected.
[0058] Figure 18 shows the order-related screen 33 of Figure 11 after the master reflection detail information 30-3 and master reflection detail information 30-4 have been updated. As shown in Figure 18, below the master reflection order information 34 on the order-related screen 33, there is a CSV generation button 48 that instructs the generation of CSV data for the master reflection order information 34. When the CSV generation button 48 is selected, the server information processing unit 10 generates one CSV data (structured data) containing all the master reflection detail information 30 of the master reflection order information 34. To the right of the CSV generation button 48, there is a JSON generation button 49 that instructs the generation of JSON data for the master reflection order information 34. When the JSON generation button 49 is selected, the server information processing unit 10 generates one JSON data containing all the master reflection detail information of the master reflection order information 34, and the terminal information processing unit 13 downloads the generated JSON data to the terminal storage unit 17. The downloaded CSV data and JSON data are structured data and can be processed, for example, by the core system of the user of interest.
[0059] As described above, the information processing unit (server information processing unit 10, terminal information processing unit 13) of the information processing system (control system 1, information processing server 2, user terminal 3) according to this embodiment has the following functions. In other words, the information processing unit acquires order information 26, which is information based on an order from the ordering party and includes detail information 25 that has at least ordering party product identification information to identify the product, identifies one of the detail information 25 as the detail information to be processed, refers to a correspondence table 28 in which the master product ID of the product master 22 is associated with the ordering party product ID, determines whether or not the master product ID is associated with the processing target ID on the correspondence table 28, and if it is associated, links the record in the product master record 23 (product information) of the product master 22 that corresponds to the master product ID associated with the processing target ID on the correspondence table 28 with the processing target detail information, and if it is not associated, provides the user with a correspondence registration screen 40 to set the desired master product ID to be associated with the processing target ID on the correspondence table 28, and has a function to update the contents of the correspondence table 28 so that the setting made on the screen is reflected.
[0060] According to this embodiment, once a master product ID is associated with a single ordering product ID on the correspondence table 28, thereafter, when an order is placed for that ordering product ID, the correspondence table 28 is used to automatically link the detail information 25 related to that ordering product ID with the product master record 23 in the product master 22. Therefore, the user (active entity) does not need to "link the detail information 25 with the product master record 23 every time an order is placed," reducing the burden of work the user has to do with the product master 22 in response to orders from ordering parties. Furthermore, if a master product ID is not associated with a processing target ID on the correspondence table 28 when an order is placed, the user is provided with a user interface to set up the association of the desired master product ID with the processing target ID. Therefore, the user can register in the correspondence table 28 by simple means, which also reduces the burden of work the user has to do with the product master 22 in response to orders from ordering parties.
[0061] <Variation> Although one embodiment of the present invention has been described above, the above embodiment is merely an example of how the present invention can be implemented, and the technical scope of the present invention should not be interpreted as being limited by it. That is, the present invention can be implemented in various forms without departing from its gist or its main features. The following are modifications of the above embodiment. The following modifications may be applied in combination where possible.
[0062] The following configuration may be used for the proposed information identification process and related processes. Specifically, the machine learning model 50 is stored in the server storage unit 12. Figure 19 shows the input and output of the model 50. As shown in Figure 19, the model 50 takes the processing target detail information (even if only some of the information) and the product master 22 (even if only some of the information is used for the product master record) as input. The model 50 also outputs accuracy information 51. The accuracy information 51 is information that records the accuracy of each product master record (product) in the product master 22, indicating the likelihood that it corresponds to the product corresponding to the processing target detail information. The model 50 is machine-learned using ground truth data, which includes combinations of detail information (even if only some of the information) and the corresponding product master record 23 (even if only some of the information), as training data. Of course, the ground truth data may be generated by reflecting the linking of detail information and product master records 23 that has actually been performed in the past. In this modified example, the server information processing unit 10 generates accuracy information 51 in the proposed information identification process using the functions of a machine learning model. This process corresponds to deriving an accuracy score that indicates the likelihood that a product in the product master 22 corresponds to a product in the detailed information to be processed. The terminal information processing unit 13 also provides the user with a correspondence registration screen 40 displaying the product master record 23 of the product master 22 with the accuracy score reflected. The above configuration is also possible.
[0063] The following configuration may be used for the proposed information identification process and related processes. Specifically, the server information processing unit 10 generates a prompt in the proposed information identification process that requests the deriving of an accuracy indicating the likelihood that a product in the product master corresponds to the product in the processing target detail information. In addition to the product master, the prompt may also record examples of linking detail information and product master records 23 that have been performed in the past. The server information processing unit 10 sends the generated prompt to the generating AI model server and receives a response from the generating AI model server that records the accuracy of the product in the product master 22. The terminal information processing unit 13 provides the user with a correspondence registration screen 40 in which the product master record 23 of the product master 22 is displayed with the accuracy of the product in the product master 22 recorded in the response reflected.
[0064] • In the above embodiment, an example of a method for preferentially displaying suggested product master records on the correspondence registration screen 40 was shown, but the method is not limited to the example shown. For example, the similarity level may be clearly indicated for each suggested product master record, and the suggested product master records may be displayed in order of decreasing similarity. In addition, the background color may be changed or emphasis text may be used for suggested product master records with a similarity level above a certain level. In the above embodiment, the terminal information processing unit 13 provided the correspondence registration screen 40 for detail information 25 that was in a state where correspondence relationships had not been registered, only after receiving instructions from the user. In this regard, the terminal information processing unit 13 may be configured to provide the user with the correspondence registration screen 40 for detail information 25 that was in a state where correspondence relationships had not been registered, without receiving instructions from the user. The same applies to the coefficient registration screen 45. In the above embodiment, the ordering party's product ID was a combination of the ordering party's product number and the ordering party's product name, but it goes without saying that the form of the ordering party's product ID is not limited to the form exemplified.
[0065] In the above embodiment, it is also possible to configure the server information processing unit 10 to store some or all of the data that the server storage unit 12 is supposed to store in a storage unit of an external device that is accessible to the server information processing unit 10. Regarding the above embodiment, it is also possible to configure the system so that some or all of the processes described as being executed by the browser are executed by an application other than the browser. The functional blocks shown in the above embodiments can be implemented using any hardware, or through the collaboration of any hardware and any software. In other words, these functional blocks are not limited to specific hardware. Furthermore, the embodiment may include providing a program to be executed by the computer of the information processing server 2 or the user terminal 3. The embodiment may also include providing a recording medium on which the program is recorded in a way that allows it to be read by a computer. The recording medium can be a magnetic, optical, or semiconductor memory device. Specifically, examples include portable or fixed recording media such as flexible disks, HDDs (Hard Disk Drives), CD-ROMs (Compact Disk Read Only Memory), DVDs (Digital Versatile Disks), Blu-ray® Discs, magneto-optical disks, flash memory, and card-type recording media.
[0066] Furthermore, in the above embodiment, the device having one function is not limited to the device exemplified as the device having one function. For example, consider a function that determines whether a master-side product ID is associated with an ordering-side product ID of the processing target detail information on the correspondence relationship table 28 (hereinafter referred to as the "first function") and a function that provides the user with a correspondence relationship registration screen 40 (hereinafter referred to as the "second function"). In the above embodiment, as shown in Figure 20(A), the server information processing unit 10 of the information processing server 2 has the first function, and the terminal information processing unit 13 of the user terminal 3 has the second function. In this configuration, the combination of the information processing server 2 and the user terminal 3 functions as an "information processing system". Also, the server information processing unit 10 and the terminal information processing unit 13 each function as an "information processing unit". On the other hand, as shown in Figure 20(B), the terminal information processing unit 13 of the user terminal 3 may have both the first and second functions. In this configuration, the user terminal 3 functions as an "information processing system", and the terminal information processing unit 13 functions as an "information processing unit". Furthermore, as shown in Figure 20(C), the server information processing unit 10 may be configured to have both a first and a second function. In this configuration, the information processing server 2 functions as an "information processing system," and the server information processing unit 10 functions as an "information processing unit." When the server information processing unit 10 and the terminal information processing unit 13 each function as an "information processing unit," the functions provided in each information processing unit are not limited. Also, a configuration in which one function is realized through the cooperation of the server information processing unit 10 and the terminal information processing unit 13 is also possible. Moreover, the device that realizes a certain function may be a device other than the information processing server 2 and the user terminal 3. [Explanation of Symbols]
[0067] 1. Control System (Information Processing System) 2. Information Processing Server (Information Processing System) 3. User terminal (information processing system) 10. Server Information Processing Unit (Information Processing Unit) 13 Terminal Information Processing Unit (Information Processing Unit) 28 Correspondence Table 32 Coefficient Table 40. Screen for registering correspondence relationships 45. Screen for registering coefficients
Claims
1. We obtain order information that is based on an order from the ordering party and includes detailed information that has at least ordering party product identification information to identify the product. One of the aforementioned detail information items is identified as the detail information item to be processed, Refer to the correspondence table in which the master-side product identification information of the product master is associated with the ordering-side product identification information, and determine whether the master-side product identification information is associated with the ordering-side product identification information of the processing target detail information on the correspondence table. If a correspondence exists, the product information from the product master that corresponds to the master-side product identification information associated with the ordering-side product identification information of the processing target detail information on the correspondence relationship table is linked to the processing target detail information. If no association is made, the system includes an information processing unit that provides the user with a first user interface for setting up the association of the desired master-side product identification information with the ordering-side product identification information of the processing target details information on the association relationship table, and has a function to update the contents of the association relationship table so that the setting made on the first user interface is reflected. An information processing system characterized by the following:
2. The aforementioned information processing unit, If it is determined in the correspondence table that the master-side product identification information is not associated with the ordering-side product identification information of the processing target details, the system has a function to derive the similarity between the product name of the product corresponding to the ordering-side product identification information of the processing target details and the product name of the product in the product master, and to provide the user with the first user interface in which the product information of the product master is displayed with the similarity reflected. The information processing system according to feature 1.
3. The aforementioned information processing unit, If it is determined that the master-side product identification information is not associated with the ordering-side product identification information of the processing target details information on the correspondence relationship table, the machine learning model derives an accuracy indicating the likelihood that the product in the product master corresponds to the product in the processing target details information, and provides the user with the first user interface in which the product information of the product master is displayed with the accuracy reflected. The information processing system according to feature 1.
4. The aforementioned information processing unit, If it is determined that the master-side product identification information is not associated with the ordering-side product identification information of the processing target detail information on the correspondence table, The system includes the following functions: generating a prompt requesting the system to derive an accuracy indicating the likelihood that a product in the product master corresponds to the product in the processing target detail information; transmitting the prompt to the generating AI model server; receiving a response from the generating AI model server in which the accuracy of the product in the product master is recorded; and providing the user with the first user interface in which the product information in the product master is displayed with the accuracy of the product in the product master recorded in the response reflected. The information processing system according to feature 1.
5. The aforementioned detailed information further includes a quantity on the ordering side indicating the quantity of goods and a unit on the ordering side indicating the unit of said quantity. The aforementioned information processing unit, After linking the processing target detail information with the product information of the product master, it is determined whether the ordering unit of the processing target detail information and the master unit indicating the unit of quantity of the product in the linked product information are identical. If they are not identical, the coefficient table associated with the ordering party product identification information is referenced, and it is determined whether the adjustment coefficient is associated with the ordering party quantity in the coefficient table when changing the ordering party unit to the master unit. If a correspondence exists, the quantity obtained by multiplying the ordering party's quantity in the processing target details information by the adjustment coefficient is derived. If the data is not already associated, the system provides the user with a second user interface to set up the association of the desired value of the adjustment coefficient with the ordering party product identification information of the processing target details information on the coefficient table, and includes a function to update the contents of the coefficient table so that the settings made on the second user interface are reflected. The information processing system according to any one of claims 1 to 4.
6. The information processing system obtains order information, which is information based on an order from a customer and includes detailed information that has at least customer-side product identification information for identifying the product, The information processing system includes the step of identifying one of the detail information items as the detail information item to be processed, The information processing system includes the steps of: referring to a correspondence table in which master-side product identification information of the product master is associated with the ordering-side product identification information; determining on the correspondence table whether the master-side product identification information is associated with the ordering-side product identification information of the processing target detail information; if an association is made, linking the information from the product master corresponding to the master-side product identification information associated with the ordering-side product identification information of the processing target detail information on the correspondence table with the processing target detail information; and if an association is not made, providing the user with a first user interface for setting the desired master-side product identification information to be associated with the ordering-side product identification information of the processing target detail information on the correspondence table; and updating the contents of the correspondence table so that the setting made on the first user interface is reflected. An information processing method characterized by the following:
7. A program executed by a computer in an information processing system, The aforementioned computer We obtain order information that is based on an order from the ordering party and includes detailed information that has at least ordering party product identification information to identify the product. One of the aforementioned detail information items is identified as the detail information item to be processed, Refer to the correspondence table in which the master-side product identification information of the product master is associated with the ordering-side product identification information, and determine whether the master-side product identification information is associated with the ordering-side product identification information of the processing target detail information on the correspondence table. If a correspondence exists, the product information from the product master that corresponds to the master-side product identification information associated with the ordering-side product identification information of the processing target detail information on the correspondence relationship table is linked to the processing target detail information. If no association exists, the system functions as an information processing unit that provides the user with a first user interface to set up the association of the desired master-side product identification information with the ordering-side product identification information of the processing target details information on the association relationship table, and updates the contents of the association relationship table so that the settings made on the first user interface are reflected. A program characterized by the following features.