JP3657566B2 - Order item integration support system, order item integration support method, and computer-readable recording medium recording program - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to an order item integration support system that organizes representative names and group names from order items included in order information and supports systematization of the order items.
[0002]
[Prior art]
In order to make purchasing activities more efficient, it is desirable to handle order items with a unified name and handle them in a unified manner.
[0003]
However, when the business is carried out by a large number of counters or persons in charge, the names of the ordered items tend to vary and cannot be easily unified.
[0004]
Even if the names actually used differ objectively, they may point to substantially the same name. For example, it is a so-called common name or abbreviation. Therefore, there is also a problem that the actual ordering cannot be grasped due to the difference in names.
[0005]
[Problems to be solved by the invention]
The present invention has been made in order to eliminate the above-described drawbacks of the prior art. The purpose of the present invention is to manage one item uniquely, but it is important to manage one item. It is difficult for a person to register a master from scratch if there are many items handled, due to problems with time and personnel. Therefore, using the provisional classification system that has been established, it is efficient to determine the uniform name of the ordered product from a large amount of ordering information, and it is processed by a person other than the party, such as a common name or abbreviation, by mistake. It is an object of the present invention to provide a technology that enables easy-to-handle names to be handled as a group and supports creation of an item group.
[0006]
[Means for Solving the Problems]
The order item integration support system according to the present invention includes:
It has the following elements
(1) An order information database that stores a plurality of order information codes and order items in association with each other.
(2) Temporary classification master table for storing a plurality of temporary classification codes and temporary classification items in association with each other
(3) Temporary classification item sorting processing unit that determines whether or not each order item stored in the order information database matches each provisional classification item stored in the provisional classification master table.
(4) An ordering information code group storage unit adapted to a temporary classification item that stores a plurality of ordering information codes of ordering items suitable for any temporary classification item in association with the temporary classification code of the temporary classification item
(5) The ordering information code corresponding to the provisional classification code of the designated temporary classification item is read from the ordering information code group storage unit suitable for the temporary classification item, and the ordering item corresponding to the read ordering information code is ordered. A conforming ordering item list display unit that reads out from the database and generates a conforming ordering item list including the read ordering items.
[0007]
Furthermore, it has the following elements,
(6) An item group registration unit that registers at least a part of the ordered items on the ordered item list, the designated representative name being associated with the provisional classification code of the designated provisional classification item.
(7) An item group table that stores the representative name registered in association with the item group registration unit in association with the temporary classification code.
[0008]
The item group registration unit further associates the designated in-group name with the provisional classification code of the designated provisional classification item, which is at least a part of the order items on the conformity ordering item list. Register,
The item group table further stores the in-group name registered in association with the item group registration unit in association with the temporary classification code.
[0009]
Furthermore, it has the following elements,
(8) An order information code group storage unit that does not conform to the provisionally classified item that stores the order information code of the order item that does not conform to any provisionally classified item
(9) When non-conformity is designated, the order information code stored in the order information code group storage unit not conforming to the provisional classification item is read, and the order item corresponding to the read order information code is read from the order information database. A nonconforming part ordering item list display unit that generates a nonconforming part ordering information processing screen including the read ordering item.
[0010]
Furthermore, it has the following elements,
(10) When the sorting temporary classification is selected for the order item on the non-conforming product ordering information processing screen, the order information code of the order item is associated with the temporary classification code of the selected temporary classification. A nonconforming order information sorting unit registered in the ordering information code group storage unit conforming to the provisionally classified item.
[0011]
Furthermore, it has the following elements,
(11) When an additional provisional classification is specified for an order item on the nonconforming product order information processing screen, the order information code of the order item is assigned to the new provisional classification code in association with the new provisional classification code. A nonconforming order information classification adding unit that registers in the ordering information code group storage unit conforming to the temporary classification item as an ordering information code group conforming to the temporary classification item.
[0012]
The nonconforming order information sorting unit further deletes the ordering information code of the ordering item from the ordering information code group storage unit incompatible with the temporary classification item.
[0013]
The nonconforming order information classification adding unit further deletes the ordering information code of the ordering item from the ordering information code group storage unit incompatible with the temporary classification item.
[0014]
Furthermore, it has the following elements,
(12) When a non-conforming item is specified for the order item on the order information processing screen for the non-conforming product, the order information code of the order item is obtained from the order information code group storage unit that is non-conforming to the temporary classification item. Excluded processing unit to be deleted.
[0015]
The order information database further stores order information other than the ordered items in association with each other,
The nonconforming part ordered item list display unit arranges the ordering items included in the nonconforming part ordering information processing screen in order according to the ranking result for the ordering information stored in the ordering information database.
[0016]
The order information database stores a plurality of items as order information other than the order items,
The nonconforming part ordered item list display unit performs ranking according to designated items.
[0017]
The temporary classification code has a hierarchical system,
The temporary classification master table is configured according to the hierarchical system,
The provisional classification item sorting processing unit processes according to the hierarchical system,
The order information code group storage unit suitable for the provisional classification item is configured according to the hierarchical system,
The order information code group storage unit that is incompatible with the provisional classification item is configured according to the hierarchical system,
The conforming ordering item list display unit performs processing according to the hierarchical system.
[0018]
Ordering item integration support method according to the present invention,
By an order item integration support system having an order information database that stores a plurality of order information codes in association with order items, a temporary classification code, and a temporary classification master table that stores a plurality of provisional classification items in association with each other. Order item integration support method, characterized by having the following elements:
(1) A step of determining whether or not each order item stored in the order information database matches each provisional classification item stored in the provisional classification master table.
(2) A step of storing a plurality of ordering information codes of ordering items suitable for any temporary classification item in association with the temporary classification code of the temporary classification item
(3) Read out the ordering information code corresponding to the provisional classification code of the designated provisional classification item, read out the ordering item corresponding to the read out ordering information code from the ordering information database, and place an order for compatible products including the read out ordering item. Process to generate item list.
[0019]
A computer-readable recording medium on which a program according to the present invention is recorded includes a plurality of order information databases storing a plurality of order information codes in association with order items, a provisional classification code, and provisional classification items in association with each other. A computer-readable recording medium recording a program for causing a computer to be an order item integration support system having a temporary classification master table to be stored to execute the following processing:
(1) Processing for determining whether or not each order item stored in the order information database matches each provisionally classified item stored in the provisional classification master table.
(2) A process of storing a plurality of order information codes of ordering items suitable for any temporary classification item in association with the temporary classification code of the temporary classification item
(3) Read out the ordering information code corresponding to the provisional classification code of the designated provisional classification item, read out the ordering item corresponding to the read out ordering information code from the ordering information database, and place an order for compatible products including the read out ordering item. Process to generate item list.
[0020]
The program according to the present invention is:
An ordering item integration support system having an ordering information database that stores a plurality of order information codes and order items in association with each other, a temporary classification code, and a temporary classification master table that stores a plurality of provisional classification items in association with each other A program for causing a computer to execute the following procedure:
(1) Procedure for judging whether or not each order item stored in the order information database matches each provisional classification item stored in the provisional classification master table
(2) Procedure for storing a plurality of ordering information codes of ordering items conforming to any temporary classification item in association with the temporary classification code of the temporary classification item
(3) Read out the ordering information code corresponding to the provisional classification code of the designated provisional classification item, read out the ordering item corresponding to the read out ordering information code from the ordering information database, and place an order for compatible products including the read out ordering item. Procedure for generating a list of items.
[0021]
DETAILED DESCRIPTION OF THE INVENTION
Embodiment 1 FIG.
Hereinafter, the present invention will be described based on embodiments shown in the drawings.
First, the order information database will be described. FIG. 1 is a diagram illustrating a configuration example of an order information database. A record is provided for each ordering information, and each of the records 151 to 157 is configured to store the ordering information code 101 and the ordering information 102 in association with each other. The order information 102 includes items of an order item 103, an order unit 104, an order quantity 105, an order place 106, and a delivery date 107. These items are examples, and may be other items such as an orderer name and an order date.
[0022]
Next, a process for sorting the order items included in the order information database according to a provisionally determined provisional classification will be described. FIG. 2 is a diagram showing the overall processing flow of provisionally classified item sorting.
The provisional classification in this example has a three-level system. From the upper layer, the order information that matches the provisional large classification item is extracted (S201), and the order information that conforms to the provisional medium classification item is extracted. Processing (S202), and processing (S203) for extracting ordering information suitable for the provisional small classification item. Hereinafter, these processes will be described in order.
[0023]
Details of the process (S201) of extracting order information that matches the provisional large classification item in FIG. 2 will be described.
FIG. 3 is a diagram illustrating a configuration related to provisional large classification item sorting in the order item integration support system. 1 is an order information database, 2 is a provisional large classification master table, 5 is a provisional large classification item sorting processing unit, 8 is an order information code group storage unit suitable for the provisional large classification item, and 9 is a provisional large classification. This is an order information code group storage unit that is incompatible with the item.
[0024]
FIG. 4 is a diagram illustrating a configuration example of the provisional large classification master table. A record is provided for each temporary large classification, and each of the records 451 to 453 stores a temporary large classification code 401 and a temporary large classification item 402 in association with each other. The file name “provisional ROOT.TBL” indicates the highest hierarchy.
[0025]
FIG. 5 is a diagram showing a flow of temporary large classification item sorting processing. These processes are performed by the provisional large classification item sorting processing unit 5.
The provisional large classification item sorting processing unit 5 sequentially reads provisional large classification items together with the provisional large classification code from the temporary large classification master table 2 (S501), and repeats the following processing. The order item in the order information database 1 is searched using the provisionally classified item as a key (S502). For example, when the provisionally classified item is “electric pole”, an order item including various items is searched using “electric pole” as a key. At this time, it is conceivable to use various search methods. In addition to the whole match search, a partial match search or an idea search using synonym dictionary data may be used.
[0026]
As a result of the search, an order information code group of the matched order information is acquired (S503). The acquired order information code group is stored in the order information code group storage unit 8 suitable for the provisional large classification item as an order information code group suitable for the provisional large classification item for each provisional large classification item (S504). More specifically, for example, a method of storing the provisional large classification code and the order information code group items in association with each other as a table record, or an order information code group in a file with a file name including the temporary large classification code group. A method of storing can be considered.
[0027]
When processing is performed for all temporary large classification items (S505), an order information code group of order information that does not match in any search using the temporary large classification item as a key is extracted (S506), and the extracted order information code group Are stored in the order information code group storage unit 9 that is incompatible with the provisional large classification item as an order information code group that is incompatible with the provisional large classification item (S507).
[0028]
Next, the details of the process (S202) of extracting order information that matches the provisionally classified item in FIG. 2 will be described.
FIG. 6 is a diagram illustrating a configuration related to provisional classification item sorting of the order item integration support system. In the figure, 3 is a provisional classification master table, 6 is a provisional classification item sorting processing section, 10 is an order information code group storage section suitable for provisional classification items, and 11 is not suitable for provisional classification items. This is an order information code group storage unit. Other elements are the same as described above.
[0029]
FIG. 7 is a diagram illustrating a configuration example of the provisional classification master table. It is stored in association with a provisional major classification code 700 that identifies the major classification of the upper layer. As items, provisional classification code 701 and provisional classification item 702 are included. In this example, the upper layer major classification code can also be specified from the file name “temporary 10003.TBL”.
[0030]
FIG. 8 is a diagram showing a flow of the provisionally classified item sorting process. This process is performed by the provisionally classified item sorting processing unit 6. The provisional large item code of the provisional large classification item is sequentially read from the provisional large classification master table 2 (S801), and the following processing is repeated. Further, a provisional classification master table corresponding to the lower order of the read provisional large classification item is identified, provisional classification items are sequentially read from the identified provisional classification master table (S802), and the following processing is repeated.
[0031]
The provisional classification item sorting processing unit 6 performs the provisional classification for the ordering item corresponding to each ordering information code of the ordering information code group suitable for the provisional large classification item among the ordering information included in the ordering information database 1. A search is performed using the item as a key (S803). The search method is the same as described above. The order information code group of the order information adapted by the search is acquired (S804), and the obtained order information code group is set as the order information code group suitable for the provisional intermediate classification item for each provisional intermediate classification item. Stored in the order information code group storage unit 10 suitable for the item (S805). More specifically, for example, a method of storing in association with a record of a table in which items of provisional classification codes and order information code groups are stored, or an order information code group in a file having a file name including the provisional classification code group. A method of storing can be considered.
[0032]
When all the provisional classification items are processed (S806), the order information code group of the ordering information that does not match in any search using the provisional classification item corresponding to the lower order of the provisional large classification item as a key is extracted. (S807) The extracted ordering information code group is stored in the ordering information code group storage unit 11 that is incompatible with the provisional classification item as an ordering information code group that is incompatible with the provisional classification item corresponding to the lower order of the provisional large classification item. Store (S808).
[0033]
When all temporary large classification items have been processed (S809), the process ends.
[0034]
Next, the details of the process (S203) of extracting order information that matches the provisional small classification item of FIG. 2 will be described.
FIG. 9 is a diagram showing a configuration related to provisional small classification item sorting of the order item integration support system. In the figure, 4 is a temporary minor classification master table, 7 is a temporary minor classification item sorting processing unit, 12 is an order information code group storage unit suitable for the temporary minor classification item, and 13 is not suitable for the temporary minor classification item. This is an order information code group storage unit. Other elements are the same as described above.
[0035]
FIG. 10 is a diagram illustrating a configuration example of the temporary small classification master table. It is stored in association with the provisional classification code 1000 that identifies the middle classification of the upper layer. As items, a temporary small classification code 1001 and a temporary small classification item 1002 are included. In this example, the upper layer middle classification code can also be specified from the file name “temporary 1000320001.TBL”.
[0036]
FIG. 11 is a diagram showing a flow of temporary small classification item sorting processing. This process is performed by the provisional small classification item sorting processing unit 7. The provisional major classification items are sequentially read from the provisional major classification master table 2 (S1101), and the following processing is repeated. Further, provisional intermediate classification items are sequentially read from the provisional intermediate classification master table 3 corresponding to the lower order of the read provisional large classification items (S1102), and the following processing is repeated. Further, temporary minor classification items are sequentially read from the temporary minor classification master table 4 corresponding to the lower order of the read temporary intermediate classification items (S1103), and the following processing is repeated.
[0037]
Among the order information included in the order information database 1, a search is performed for the order item corresponding to each order information code of the order information code group suitable for the provisional classification item using the provisional small classification item as a key (S1104). ). The search method is the same as described above. An ordering information code group of ordering information adapted by the search is obtained (S1105), and the obtained ordering information code group is set as the ordering information code group suitable for the provisional minor classification item for each provisional minor classification item. The order information code group storage unit 12 suitable for the classification item is stored (S1106). Specifically, for example, a method of storing the table as a table record in which items of the provisional small classification code and the order information code group are associated with each other, or the order information code group is stored in a file having a file name including the temporary small classification code group A method of storing can be considered.
[0038]
When processing is performed for all temporary minor classification items (S1107), an order information code group of ordering information that does not match in any search using the temporary minor classification item corresponding to the lower order of the temporary middle classification item as a key is extracted. (S1108) The extracted ordering information code group is stored in the ordering information code group storage unit 13 that is incompatible with the provisional minor classification item as an ordering information code group that is incompatible with the provisional minor classification item corresponding to the lower order of the provisional intermediate classification item. Store (S1109).
[0039]
If all temporary provisional classification items are processed (S1110) and further all temporary provisional classification items are processed (S1111), the process ends.
[0040]
Next, processing for registering an item group based on the processing result of the above-described provisional classification item sorting will be described.
FIG. 12 is a diagram showing a configuration relating to item group registration of the order item integration support system. 21 is an item group registration unit, 22 is an item group table, 23 is a conforming ordering item list display unit, 24 is a nonconforming ordering item list display unit, 25 is a nonconforming ordering information sorting unit, and 26 is nonconforming. This is an order information classification addition unit. Other elements are the same as described above.
[0041]
FIG. 13 is a diagram showing a flow of item group registration processing. The item group registration unit 21 displays an initial item group registration screen (S1301). The item group registration screen is configured as shown in FIG.
[0042]
Wait for input to the item group registration screen (S1302). When the provisionally classified item is selected (S1303), the process proceeds to the order item list display process (S1304).
[0043]
The order item list display process will be described in detail. FIG. 14 is a flowchart illustrating the order item list display process.
If there is no designation of non-conformity in the provisionally classified item (S1401), the process shifts to the conforming ordering item list display process (S1402). (S1403).
[0044]
Further, the conformity ordering item list display process (S1402) will be described in detail. FIG. 15 is a diagram illustrating a flow of the compatible order item list display process.
The conforming ordering item list display unit 23 includes an ordering information code group suitable for the provisional classification item specified by the input on the item group registration screen, an ordering information code group storage unit 8 suitable for the provisional large classification item, It is specified from either the order information code group storage unit 10 suitable for the classified item or the order information code group storage unit 12 suitable for the temporary small category item (S1501). For example, when the provisional medium classification item and the provisional small classification item are set to “not set”, the order information code group storage unit 8 suitable for the provisional large classification item is targeted. In addition, when all of the temporary large classification item, temporary intermediate classification item, and temporary small classification item are designated, the temporary minor classification item is stored in the order information code group storage unit 12 suitable for the temporary small classification item. Target the corresponding ones.
[0045]
The conforming ordering item list display unit 23 reads the ordering item corresponding to the ordering information code included in the specified ordering information code group from the ordering information database (S1502), and the read ordering item has a representative name check box, Add a check box for the name in the group. The item group registration unit 21 arranges this on the item group registration screen (S1503), and redisplays the item group registration screen (S1504).
[0046]
The figure shows an example of the redisplay result described above. FIG. 16 is a diagram illustrating an example of an item group registration screen. In this example, based on the order information code group in the order information code group storage unit 10 suitable for the provisional classification item, the order item that conforms to the provisional classification item is displayed. Among these, what is typically used as the name of an item is selected in the representative name box, and what is used as a name to be included in these groups can be selected in the in-group name box. In this example, the entire order item is used as each name, but it is also effective to specify a part of the order item and use it as each name.
In addition, by the above-described processing, by specifying an item in the upper classification box, it is possible to display the ordered items that are suitable as the sorting result of each layer, and to select each box in the same manner.
[0047]
For example, when the determination button is selected in the state of FIG. 16, the item group registration unit 21 associates the representative name and the in-group name with the provisional classification code according to the determination of S1310 of FIG. 22 is registered. The item group table 22 is as shown in FIG.
FIG. 17 is a diagram illustrating a configuration example of the item group table. A table is provided in association with the provisional large classification code 1700 that specifies the classification of the upper layer. Each record is configured to store a provisional classification code 1701, a representative name 1702, and an in-group name 1703 in association with each other. Normally, the representative name 1702 is processed so as to be unique (S1306 and S1307 in FIG. 13), but it is effective to allow a plurality of in-group names 1703 to be registered (S1309 in FIG. 13).
[0048]
On the other hand, by specifying "Nonconformity" in any of the classification boxes at the top of the item group registration screen, it is possible to display the ordered items that have become nonconforming due to sorting at any level and instruct their handling. .
In this case, the process of S1403 is performed according to the determination of S1401 of FIG. This process will be described in detail. FIG. 18 is a diagram showing a flow of the nonconforming order item list display process.
The non-conforming ordering item list display unit 24, in accordance with the provisional classification item specified by the input to the item group registration screen, the ordering information code group storage unit 9 that is nonconforming to the provisional large classification item and the ordering information that is nonconforming to the provisional classification From the code group storage unit 11 or the order information code group storage unit 13 that is incompatible with the provisional small classification item, an order information code group that is incompatible with the provisional classification item is specified (S1801). For example, if the provisional large classification item is “nonconforming”, the order information code group storage unit 9 that does not conform to the temporary large classification item is targeted. Further, when the temporary minor classification item is “nonconforming”, the nonconforming ordering information code group corresponding to the lower order of the temporary intermediate classification item which is the upper layer is stored in the ordering information code group storage unit not conforming to the temporary minor classification item. 13 is specified.
[0049]
The non-conforming order item list display unit 24 reads the order item corresponding to the order information code included in the specified order information code group from the order information database (S1802), and displays the read order item. In this example, the same ordered items are grouped into one line. Further, ordering is performed according to the designated ranking item (S1803). For example, tabulation is performed based on the order information items 102 to 107 other than the order items shown in FIG. As ranking items, for example, the number of orders, the number of orderers, and the like can be considered. However, the ranking items are not limited to these, and any items that can be compared based on the order information are sufficient. It is also effective to limit the ordering information to be counted for a predetermined handling period. This makes it possible to provide ranking items such as the number of recent orders and the number of recent orderers.
[0050]
The non-conforming ordering item list display unit 24 attaches menus of “sorting instruction”, “add to classification”, and “non-target” to the ordered ordering information and arranges them as a list on the nonconforming order information processing screen (S1804). ). Then, a nonconforming order information processing screen including a ranking item selection button is displayed (S1805).
[0051]
FIG. 19 is a diagram illustrating an example of a nonconforming order information processing screen. In this example, the order items that match the temporary large classification item “electric pole” and do not match any of the subordinate intermediate classification items are displayed in order of the number of orders.
When any ranking item is selected on the nonconforming order information processing screen of FIG. 19, the process proceeds to the processing of ordering according to the ranking item (S1807, S1803 of FIG. 18).
[0052]
When one of the ordered items is selected on this screen, a menu that allows selection of “sorting instruction”, “add to classification”, and “not applicable” is displayed (S1808 in FIG. 18). .
[0053]
If “sorting instruction” is selected in this menu (S1809), the process proceeds to nonconforming order information sorting instruction processing (S1810). The nonconforming order information sorting unit 25 displays a sort provisional classification selection screen. FIG. 20 is a diagram illustrating an example of a sorting provisional classification selection screen. When a temporary classification item to be sorted is selected from this screen, the ordering information code group memory corresponding to the selected temporary classification item is stored with the ordering information code of the ordering item associated with the temporary classification code of the selected temporary classification item. Register with the department. As a result, it is registered in the order information code group storage unit 8 suitable for the provisional large classification item, the order information code group storage unit 10 suitable for the provisional medium classification item, or the order information code group storage unit 12 suitable for the provisional small classification item. As described above, the processing by the item group registration unit 21 enables registration as a representative name or an in-group name in the item group table. FIG. 21 is a diagram illustrating an example in which the nonconforming order item “con utility pole” is once sorted into the temporary classification “concrete utility pole” and registered in the item group table by subsequent item group processing.
Further, the nonconforming order information sorting unit 25 deletes the ordering information code of the ordering item from the ordering information code group storage unit that is nonconforming to the original temporary classification item.
[0054]
When “add to classification” is selected in the above-described menu (S1811), the process proceeds to nonconforming order information classification addition processing (S1812). The nonconforming order information classification adding unit 26 displays an additional provisional classification selection screen. FIG. 22 is a diagram illustrating an example of the additional provisional classification selection screen. From this screen, if a higher temporary classification item in the case of adding a new temporary classification is specified, the nonconforming order information classification adding unit 26 associates the new temporary classification code with the new temporary classification code, and orders the order information code of the order item. Are registered in the order information code group storage unit suitable for the designated temporary classification item as an order information code group suitable for the new temporary classification item.
Also, the ordering information code of the ordering item is added to the temporary classification master table in association with the new temporary classification code. FIG. 23 is a diagram illustrating an example of a provisional classification master table into which nonconforming order information is classified and added. This is a reflection of the processing when selection is selected in the state of FIG.
Further, the nonconforming order information classification adding unit 26 deletes the ordering information code of the ordering item from the ordering information code group storage unit incompatible with the original temporary classification item.
[0055]
When “not subject” is selected in the above-described menu (S1813), the process proceeds to a subject process (S1814). The non-target processing unit (not shown) deletes the order information code of the order item from the order information code group storage unit that is incompatible with the original temporary classification item.
FIG. 24 is a diagram illustrating an example of a nonconforming order information processing screen excluding nonconforming order information. This figure shows the processing result when selecting “electric pole” in the state of FIG.
[0056]
When an end button (a button displaying “return” in the figure) is selected in FIG. 19, it is determined that the process is ended as shown in FIG. To do.
[0057]
The order item integration support system described above is a computer, and each element can execute processing by a program. Further, the program can be stored in a storage medium and read from the storage medium by a computer. It is also effective to configure as a server on the network.
[0058]
【The invention's effect】
In the present invention, for each temporary classification item stored in the temporary classification master table, it is determined whether or not each order item stored in the order information database is compatible, and a list of the order items for the compatible order items. Therefore, it is possible to easily know how the order item can be described in the actual order information for a specific provisional classification.
[0059]
The specified representative name that is at least part of the ordered items on the list of conforming items and registered in the item group table is unified from the ordered items that are actually described in the ordering information. It is possible to easily select a name suitable for use in the management, and it becomes easier to manage the name.
[0060]
Since the specified group name is registered in the item group table and is at least part of the ordered items on the compatible item ordered item list, the group can be selected from the ordered items actually listed in the ordering information. It is possible to easily select a name that is suitable for handling, and the management becomes easier.
[0061]
Order items that do not conform to any provisionally classified item are generated as an order information processing screen for non-conforming items, so it is possible to easily confirm the order items that are missing in the search. In particular, it is useful for confirming names that are widely used, such as common names and popular names, but are more suitable by search logic.
[0062]
Since the compatible ordering information sorting unit is provided, the names that should be included in the group, like the above-mentioned common names and popular names, can be handled in the same manner as the compatible ordered items.
[0063]
Since the nonconforming order information classification addition unit is provided, it is possible to incorporate into the classification system what does not belong to any group of the classification system.
[0064]
Since the nonconforming order information sorting unit deletes the ordering information code of the ordering item from the nonconforming ordering information code group storage unit, it is possible to easily know the unprocessed part of the nonconforming ordering item. Thereby, the process of an unprocessed part is accelerated | stimulated.
[0065]
The nonconforming order information classification adding unit deletes the ordering information code of the ordering item from the nonconforming ordering information code group storage unit, and therefore can easily know the unprocessed part of the nonconforming ordering item. Thereby, the process of an unprocessed part is accelerated | stimulated.
[0066]
Since the non-target processing unit is provided, it is possible to positively exclude order items that do not need to be included in the classification system, and to easily know the unprocessed items among the non-conforming order items. Thereby, the process of an unprocessed part is accelerated | stimulated.
[0067]
The nonconforming part ordered item list display section arranges the ordering items included in the nonconforming part ordering information processing screen according to the ranking result for the ordering information stored in the ordering information database. It is possible to increase the efficiency of processing by highlighting highly important ordered items, such as those with a large number of customers.
[0068]
In particular, since ranking is performed according to designated items, ranking display can be performed according to the weighting of the operator. This is effective when the importance of the ordered item needs to be judged from various perspectives.
[0069]
Since it can cope with the classification of a hierarchical system, it is particularly effective when dealing with a wide variety of orders.
[Brief description of the drawings]
FIG. 1 is a diagram showing a configuration example of an order information database.
FIG. 2 is a diagram showing a flow of overall processing of provisionally classified item sorting.
FIG. 3 is a diagram showing a configuration relating to provisional large classification item sorting in the order item integration support system;
FIG. 4 is a diagram illustrating a configuration example of a provisional large classification master table.
FIG. 5 is a diagram showing a flow of provisional large classification item sorting processing;
FIG. 6 is a diagram showing a configuration relating to provisional classification item sorting of the order item integration support system;
FIG. 7 is a diagram illustrating a configuration example of a provisional classification master table.
FIG. 8 is a diagram illustrating a flow of provisional classification item sorting processing;
FIG. 9 is a diagram showing a configuration relating to provisional small classification item sorting of the order item integration support system;
FIG. 10 is a diagram illustrating a configuration example of a temporary small classification master table.
FIG. 11 is a diagram showing a flow of provisional small classification item sorting processing;
FIG. 12 is a diagram showing a configuration relating to item group registration of the order item integration support system;
FIG. 13 is a diagram illustrating a flow of an item group registration process.
FIG. 14 is a flowchart illustrating an order item list display process;
FIG. 15 is a diagram showing a flow of a compatible ordering item list display process;
FIG. 16 is a diagram illustrating an example of an item group registration screen.
FIG. 17 is a diagram illustrating a configuration example of an item group table.
FIG. 18 is a diagram showing a flow of nonconforming item ordered item list display processing;
FIG. 19 is a diagram showing an example of a nonconforming order information processing screen.
FIG. 20 is a diagram illustrating an example of a sorting provisional classification selection screen.
FIG. 21 is a diagram illustrating an example of an item group table.
FIG. 22 is a diagram showing an example of an additional provisional classification selection screen.
FIG. 23 is a diagram illustrating an example of a provisional classification master table in which nonconforming order information is classified and added.
FIG. 24 is a diagram showing an example of a nonconforming order information processing screen that excludes nonconforming order information.
[Explanation of symbols]
1 Order Information Database, 2 Temporary Large Classification Master Table, 3 Temporary Medium Classification Master Table, 4 Temporary Small Classification Master Table, 5 Temporary Large Classification Item Sorting Processing Section, 6 Temporary Medium Classification Item Sorting Processing Section, 7 Temporary Small Classification Item Sorting Processing unit, 8 Ordering information code group storage unit suitable for provisional large classification item, 9 Ordering information code group storage unit not suitable for provisional large classification item, 10 Ordering information code group storage unit suitable for provisional classification item, 11 Temporary Order information code group storage unit that does not conform to medium classification items, 12 Order information code group storage unit that conforms to temporary sub-classification items, 13 Order information code group storage unit that does not conform to temporary sub-classification items, 21 Item group registration unit, 22 Item group table, 23 conformity ordering item list display section, 24 nonconformance ordering item list display section, 25 nonconformance order information sorting section, 26 nonconformance order information classification adding section.

Claims (14)

An ordering item integration support system that supports the work of determining a unified name of an ordering item, and has the following elements: (1) an ordering information code, an ordering item, and Order information database (2) that stores a plurality of temporary classification codes in association with each other and temporary classification master table that stores a plurality of temporary classification items in association with each other (3) for each temporary classification item stored in the temporary classification master table Whether or not each order item stored in the order information database is compatible is determined by searching for the order item in the order information database using the temporary classification item as a key. Temporary Classification Item Sorting Processing Unit for Acquiring Information Code Group (4) The order information code of the ordered item that matches one of the temporary classification items is stored in the temporary classification code of the temporary classification item. Order information code group storage unit adapted to the temporary classification item stored in association with a plurality of temporary classification items (5) Order information corresponding to the temporary classification code of the designated temporary classification item and the order information corresponding to the temporary classification item A conforming ordered item list display unit that reads out the ordered item corresponding to the read ordering information code from the code group storage unit and generates a list of conforming ordered items including the read ordered item ( 6 ) When the non-conforming order information code group storage unit ( 7 ) non-conformity is specified for the temporary classification item that stores the order information code of the ordering item that does not conform to any temporary classification item, the non-conformance ordering information for the temporary classification item The order information code stored in the code group storage unit is read, and the order item corresponding to the read order information code is read from the order information database. , Non-conforming worth ordering the item list display unit to generate a non-conforming items worth ordering information processing screen, including the read-out order items. The order item integration support system ( 8 ) according to claim 1, further comprising the following elements: In association with the provisional classification code of the designated temporary classification item, the representative group name registered in association with the item group registration section ( 9 ) to be registered is associated with the temporary classification code. Item group table to remember. The item group registration unit further associates the designated in-group name with the provisional classification code of the designated provisional classification item, which is at least a part of the order items on the conformity ordering item list. Register,
The order item integration support according to claim 2, wherein the item group table further stores the in-group name registered in association with the item group registration unit in association with the temporary classification code. system. Furthermore, with respect to the order item ordered material integrated support system (10) nonconforming products partial ordering information screen according to claim 1, characterized by the following elements, when selected sorting provisional classification A nonconforming order information sorting unit that registers the ordering information code of the ordering item in the ordering information code group storage unit suitable for the temporary classifying item in association with the temporary classification code of the selected temporary classification. Furthermore, with respect to the order item ordered material integrated support system (11) nonconforming products partial ordering information screen according to claim 1, characterized by the following elements, when specified additional provisional classification In association with the new temporary classification code, the order information code of the order item is registered in the order information code group storage unit suitable for the temporary classification item as an order information code group suitable for the new temporary classification item. Non-conforming ordering information classification addition part. 5. The order item integration support according to claim 4, wherein the nonconforming order information sorting unit further deletes the order information code of the ordering item from the order information code group storage unit incompatible with the temporary classification item. system. 6. The order item integration according to claim 5, wherein the nonconforming order information classification adding unit further deletes the order information code of the order item from the order information code group storage unit incompatible with the temporary classification item. Support system. The order item integration support system according to claim 1 , further comprising the following elements: (12) When an out-of-order item is specified for an order item on the order information processing screen for nonconforming product A non-target processing unit that deletes the ordering information code of the ordering item from the ordering information code group storage unit that is incompatible with the temporary classification item. The order information database further stores order information other than the ordered items in association with each other,
The nonconforming part ordered item list display unit arranges the ordering items included in the nonconforming part ordering information processing screen in order according to the ranking result for the ordering information stored in the ordering information database. 1. The order item integration support system according to 1. The order information database stores a plurality of items as order information other than the order items,
10. The order item integration support system according to claim 9, wherein the non-conformance order item list display unit performs ranking according to designated items. The temporary classification code has a hierarchical system,
The temporary classification master table is configured according to the hierarchical system,
The provisional classification item sorting processing unit processes according to the hierarchical system,
The order information code group storage unit suitable for the provisional classification item is configured according to the hierarchical system,
The order information code group storage unit that is incompatible with the provisional classification item is configured according to the hierarchical system,
2. The order item integration support system according to claim 1, wherein the conforming order item list display unit performs processing according to the hierarchical system. An ordering item integration support system that supports the work of determining a unified name of an ordering item, an ordering information database that stores a plurality of ordering information codes and ordering items associated with each other, a temporary classification code, and a temporary classification Ordered items having a provisional classification master table that stores a plurality of items associated with each other, and an order information code group storage unit that is incompatible with provisional classification items that stores ordering information codes of ordering items that do not conform to any temporary classification item An ordering item integration support method using an integration support system, characterized in that it has the following elements: (1) The provisional classification item sorting processing unit of the ordering item integration support system is For each temporary classification item stored in the classification master table, whether or not each order item stored in the order information database is compatible, using the temporary classification item as a key The order information code group storage unit of the order item integration support system is determined by searching for an order item in the order information database, and obtains an order information code group of the order information that conforms as a result of the search. A step of storing a plurality of ordering information codes of ordering items conforming to any temporary classification item in association with the temporary classification code of the temporary classification item (3) Ordering item list display section of the ordering item integration support system Reads out the ordering information code corresponding to the provisional classification code of the specified provisional classification item, reads out the ordering item corresponding to the read out ordering information code from the ordering information database, and orders the conforming item including the read out ordering item. Process to generate list
(4) When the nonconforming part ordering item list display unit of the ordering item integration support system is designated as nonconforming, it reads out the ordering information code stored in the ordering information code group storage unit that does not conform to the provisional classification item. A step of reading out an order item corresponding to the read order information code from the order information database and generating an order information processing screen for nonconforming product including the read order item . An ordering item integration support system that supports the work of determining a unified name of an ordering item, an ordering information database that stores a plurality of ordering information codes and ordering items associated with each other, a temporary classification code, and a temporary classification Ordered items having a provisional classification master table that stores a plurality of items associated with each other, and an order information code group storage unit that is incompatible with provisional classification items that stores ordering information codes of ordering items that do not conform to any temporary classification item A computer-readable recording medium that records a program for executing the following processing in a computer that is an integrated support system. (1) The provisional classification item sorting processing unit of the order item integration support system stores the temporary classification master table. For each temporary classified item stored, whether or not each ordered item stored in the ordering information database matches, (2) Processing for obtaining the order information code group of the order information that conforms as a result of the search by searching for the order item in the order information database (2) Order information code group storage of the order item integration support system Processing in which the department stores a plurality of order information codes of ordering items that match one of the temporary classification items in association with the temporary classification code of the temporary classification item. The list display unit reads the ordering information code corresponding to the provisional classification code of the designated temporary classification item, reads the ordering item corresponding to the read ordering information code from the ordering information database, and conforms to the ordering item including the read ordering item Process for generating a partial order item list
(4) When the nonconforming part ordering item list display unit of the ordering item integration support system is designated as nonconforming, it reads out the ordering information code stored in the ordering information code group storage unit that does not conform to the provisional classification item. The process of reading the order item corresponding to the read order information code from the order information database and generating the order information processing screen for the nonconforming product including the read order item . An ordering item integration support system that supports the work of determining a unified name of an ordering item, an ordering information database that stores a plurality of ordering information codes and ordering items associated with each other, a temporary classification code, and a temporary classification Ordered items having a provisional classification master table that stores a plurality of items associated with each other, and an order information code group storage unit that is incompatible with provisional classification items that stores ordering information codes of ordering items that do not conform to any temporary classification item A program for causing a computer as an integrated support system to execute the following procedure: (1) The temporary classification item sorting processing unit of the order item integrated support system stores each temporary classified item stored in the temporary classification master table. Whether the order items stored in the order information database are compatible or not, using the temporary classification item as a key, order items in the order information database Procedure to obtain the order information code group of the order information that has been matched as a result of the search as a result of the search (2) The order information code group storage unit of the order item integration support system conforms to any temporary classification item Procedure for storing a plurality of order information codes of the ordered items in correspondence with the temporary classification codes of the temporary classification items (3) The ordering item integrated display system of the ordering item integration support system displays the designated temporary classification item To read the order information code corresponding to the provisional classification code of, read the order item corresponding to the read order information code from the order information database, and generate a list of conforming order items including the read order item
(4) When the nonconforming part ordering item list display unit of the ordering item integration support system is designated as nonconforming, it reads out the ordering information code stored in the ordering information code group storage unit that does not conform to the provisional classification item. A procedure for reading out an ordering item corresponding to the read out ordering information code from the ordering information database and generating an order information processing screen for nonconforming items including the read out ordering item .

Images