Work support device, work support method, and work support program

Abstract

To reduce a burden on a worker with respect to cooperative work (collation work) between data of respective files.SOLUTION: A cooperation processing unit collates one or a plurality of pieces of cooperation target detailed data included in a cooperation target file with one or a plurality of pieces of cooperative detailed data included in a cooperative file to detect cooperation target detailed data and cooperative detailed data which are coincide with each other. A cooperative file generation unit generates cooperated detailed data by the detected cooperation target detailed data and the detected cooperative detailed data which are coincide with each other, and generates a cooperated file including one or a plurality of pieces of cooperated detailed data. Thus, a burden on a worker is reduced with respect to cooperative work (collation work) between data of respective files.SELECTED DRAWING: Figure 1

Description

Technical Field

[0001] The present invention relates to a business support device, a business support method, and a business support program.

Background Art

[0002] Today, for example, when receiving an order in cooperation with an external system, an order from a customer is taken in as order receiving data. Then, for this order receiving data, inventory reservation, shipping instruction, delivery date reply, etc. are performed.

[0003] Patent Document 1 (Japanese Unexamined Patent Application Publication No. 2021-012551) discloses an order receiving and issuing management system for transaction products that enables a list display and confirmation of a series of transaction history information such as estimates, order receiving, order issuing, delivery, and payment settlement of various materials required at a construction site.

[0004] This order receiving and issuing management system for transaction products includes a display device having an information display screen for displaying the transaction progress of estimated products. On the information display screen, various data of estimated products arranged and displayed along the column direction in response to orders from customers, etc., are displayed and listed as detail rows along the column direction for each estimated product in a design estimate data display area, and the transaction progress of order receiving, delivery, and payment settlement for the estimated products is displayed and listed along the row direction in the detail rows for each estimated product in a transaction history display area, and they are partitioned and displayed in parallel along the row direction. Then, work columns for each business are partitioned and displayed in the transaction history display area by tags of processing item names in a business selection tag area, and order receiving, delivery, payment settlement, and other transaction histories are displayed in a list in a matrix table format by input display of various data in the processing item column.

Prior Art Documents

Patent Documents

[0005]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0006] Here, the data linking operation (matching operation) for matching the data of each of a plurality of files is a very cumbersome operation because it is necessary to perform a matching process on the data of each file one by one, which has been a burden on the operator.

[0007] The present invention has been made in view of the above-described problems, and an object thereof is to provide a business support apparatus, a business support method, and a business support program that can reduce the burden on an operator due to the data linking operation (matching operation) between the data of each file.

Means for Solving the Problems

[0008] In order to solve the above-described problems and achieve the object, a business support apparatus according to the present invention collates one or more linked detail data included in a linked file with one or more linking detail data included in a linking file, and performs a linking process for detecting the linked detail data and the linking detail data that respectively match, and a linked file generation unit that generates linked detail data with the detected linked detail data and linking detail data that respectively match, and generates a linked file including one or more linked detail data.

[0009] Further, in order to solve the above-described problems and achieve the object, a business support method according to the present invention includes a linking process step in which a linking processing unit collates one or more linked detail data included in a linked file with one or more linking detail data included in a linking file, and performs a linking process for detecting the linked detail data and the linking detail data that respectively match, and a linked file generation step in which a linked file generation unit generates linked detail data with the detected linked detail data and linking detail data that respectively match, and generates a linked file including one or more linked detail data.

[0010] Also, in order to solve the above-described problems and achieve the object, the business support program according to the present invention causes a computer to collate one or more linked detail data included in a linked file with one or more linking detail data included in a link file, and performs a linking process for detecting the linked detail data and the linking detail data that match each other. The computer also functions as a linked file generation unit that generates linked detail data with the detected linked detail data and the linking detail data that match each other, and generates a linked file including one or more pieces of linked detail data.

Effect of the Invention

[0011] The present invention can reduce the burden on an operator due to the linking operation (collation operation) of data between files.

Brief Description of the Drawings

[0012]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Figure 13

Figure 14

Figure 15

Figure 16

Figure 17

Figure 18

DETAILED DESCRIPTION OF THE INVENTION

[0013] Hereinafter, a business support device according to an embodiment to which the present invention is applied will be described in detail with reference to the drawings. This embodiment is an example in which the business support device performs a cooperation process between an order file, which is an example of a file to be linked, and a shipping instruction file, which is an example of a linked file, and generates order data as a result of this cooperation process (order accounting).

[0014] It should be noted that the present invention is not limited to the following embodiments described as an example, as it can be understood that an order approval file or the like may be used instead of the shipping instruction file as long as it is a file capable of determining the appropriateness of order accounting.

[0015] (Hardware Configuration) As shown in FIG. 1, the business support device 1 of the embodiment includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5. An input device 6 and an output device 7 are connected to the input / output interface unit 5. As the output device 7, a display unit such as a monitor device (including a home TV), a printing device, or a speaker device corresponds. As the input device 6, in addition to a keyboard device, a mouse device, and a microphone device, a monitor device that realizes a pointing device function in cooperation with the mouse device can be used.

[0016] The communication interface unit 4 is connected to a network 50 such as a wide area network such as the Internet or a private network such as a LAN (Local Area Network). A person-in-charge terminal device 51 of a person in charge to whom an e-mail attached with the order data as the above-described cooperation process result is transmitted is connected to the network 50.

[0017] As the storage unit 2, for example, a storage device such as a ROM (Read Only Memory), a RAM (Random Access Memory), an HDD (Hard Disk Drive), or an SSD (Solid State Drive) can be used. A business support program that can reduce the burden on the operator by the cooperation operation (collation operation) of the data of each file is stored in the storage unit 2.

[0018] In addition, the storage unit 2 is provided with a cooperation folder 11, an imported folder 12, an order receiving data storage unit 13, a work table 14, an order file storage unit 15, and a shipping instruction file storage unit 16, each of which is a storage area.

[0019] (Functional Configuration of Business Support Device) Next, the control unit 3 functions as an acquisition unit 21, a cooperation processing unit 22, a cooperated file generation unit 23, an output control unit 24, and a communication control unit 25 as shown in FIG. 1 by executing the business support program stored in the storage unit 2.

[0020] The acquisition unit 21 acquires the order file and the shipping instruction file input by the operator of the business support device 1 of the embodiment and stores them in the cooperation folder 11.

[0021] The cooperation processing unit 22 collates one or more linked detail data (order data) included in the linked file (order file) stored in the cooperation folder 11 with one or more cooperation detail data (shipping instruction data) included in the cooperation file (shipping instruction file), and performs a cooperation process of detecting the corresponding linked detail data and cooperation detail data.

[0022] The cooperated file generation unit 23 generates cooperated detail data using the corresponding linked detail data (order data) and cooperation detail data (shipping instruction data) detected by the cooperation processing unit 22, and generates a cooperated file (order receiving data) including one or more pieces of cooperated detail data and stores it in the order receiving data storage unit 13.

[0023] In addition, the cooperation processing unit 22 performs cooperation processing by storing each associated detail data and each cooperation detail data in the cooperation folder 11 which is a storage area of the storage unit 2. By performing the cooperation processing, an associated file (order file) in which all the associated detail data is processed in cooperation with the cooperation detail data, and a cooperation file (shipping instruction file) in which all the cooperation detail data is processed in cooperation with the associated detail data are moved to the imported folder 12 which is a storage area of the storage unit 2.

[0024] In addition, the cooperation processing unit 22 stores, in the work table 14 which is a storage area of the storage unit 2, "each associated detail data for which there is no matching cooperation detail data", "each cooperation detail data for which there is no matching associated detail data", and "each associated detail data and each cooperation detail data that respectively match".

[0025] In addition, for each associated detail data for which there is no matching cooperation detail data and each cooperation detail data for which there is no matching associated detail data, the cooperation processing unit 22 adds a "failed" import result and stores it in the work table 14.

[0026] In addition, for each associated detail data and each cooperation detail data that respectively match, the cooperation processing unit 22 adds a "successful" import result and stores it in the work table 14.

[0027] The cooperation completed file generation unit 23 generates a cooperation completed file from the associated detail data and the cooperation detail data to which the "successful" import result of the work table 14 is attached.

[0028] In addition, when either one of a new associated file and a new cooperation file is input, the cooperation processing unit 22 stores the "input new file", "the associated file in which all the associated detail data was not processed in cooperation with the cooperation detail data during the previous cooperation processing", and "the cooperation file in which all the cooperation detail data was not processed in cooperation with the associated detail data" in the work table 14 and performs cooperation processing.

[0029] Then, for each associated detail data for which there is no matching associated detail data and each associated detail data for which there is no matching associated detail data, the cooperation processing unit 22 attaches a "failure" import result.

[0030] Also, for each associated detail data and each associated detail data that match respectively, the cooperation processing unit 22 attaches a "success" import result, and among the associated detail data and associated detail data stored in the work table 14, for the associated detail data and associated detail data corresponding to the associated file generated based on the "success" import result, a "imported" import result is attached.

[0031] The associated file generation unit 23 generates a new associated file with the associated detail data and associated detail data to which the "success" import result of the work table 14 is attached, and adds it to the previously generated associated file.

[0032] The output control unit 24 outputs the generated associated file (order receiving data) to an output device 7 such as a display unit, a printing device, and a storage device. As a result, the operator can recognize the associated file (order receiving data) via the display unit or printed matter.

[0033] The communication control unit 25 controls the communication unit (communication interface unit 4) to generate an email for notifying the content of the work table 14 to a predetermined person in charge and transmit it to the terminal device of the person in charge (person in charge terminal device 51) via a predetermined network 50.

[0034] After transmitting this email, the cooperation processing unit 22 deletes all the associated detail data and all the associated detail data stored in the work table 14.

[0035] (Cooperation processing operation) Next, in the business support apparatus according to the embodiment, the control unit 3 operates based on the business support program stored in the storage unit 2, functions as the acquisition units 21 to the communication control unit 25, and realizes the cooperation processing operation described below. In this example, the acquisition units 21 to the communication control unit 25 will be described as being realized by software by the business support program. However, all or part of the acquisition units 21 to the communication control unit 25 may be realized by hardware. In any case, the same effects as those described later can be obtained.

[0036] FIG. 2 and FIG. 3 are diagrams showing an overview of the cooperation process. First, in FIG. 2(a), the acquisition unit 21 acquires the order file A and the shipping instruction file A and stores them in the cooperation folder 11. In the case of this example, the order file A includes order data of "C1" and "C2", and the shipping instruction file A includes shipping instruction data of "C1".

[0037] The cooperation processing unit 22 collates the order data of "C1" in the order file A and the shipping instruction data of "C1" in the shipping instruction file A to achieve cooperation. The cooperated file generation unit 23 generates cooperated detail data from the order data of "C1" in the cooperated order file A and the shipping instruction data of "C1" in the shipping instruction file A (details (records) of the "success" import result stored in the work table 14 in FIG. 9). Then, as shown in FIG. 2(a), the cooperated file generation unit 23 generates order data of the order number of "C1" with the newly assigned order number of "A1" based on the details (records) of the "success" import result, and stores it in the order data storage unit 13.

[0038] In addition, since the cooperation processing of the shipping instruction data of "C1" in the shipping instruction file A is completed, and thus the cooperation processing of all the shipping instruction data in the shipping instruction file A is completed, the cooperation processing unit 22 moves and stores this shipping instruction file A in the imported folder 12 as shown in FIG. 2(b).

[0039] Next, as shown in Fig. 3(a), assume that a new shipping instruction file B is acquired and stored in the cooperation folder 11. In this example, the newly acquired shipping instruction file B contains shipping instruction data for "C2". Also, due to the previous cooperation process, the order data for "C2" in the order file A is unlinked (remaining to be linked).

[0040] Therefore, the cooperation processing unit 22 performs a cooperation process on the order data for "C2" in the order file A, which remains to be linked, using the shipping instruction data for "C2" in the newly acquired shipping instruction file B. The cooperated file generation unit 23 generates cooperated detail data using the order data for "C2" in the cooperated order file A and the shipping instruction data for "C2" in the shipping instruction file B (details (records) of the "successful" import result stored in the work table 14 in Fig. 9). Then, based on the details (records) of the "successful" import result as shown in Fig. 3(a), the cooperated file generation unit 23 generates order data with the order number for "C2" assigned the newly assigned order receipt number "A2" and stores it in the order receipt data storage unit 13.

[0041] Also, due to this cooperation process, the cooperation process for all the order data in the order file A and the cooperation process for all the shipping instruction data in the shipping instruction file B are completed. Therefore, as shown in Fig. 3(b), the cooperation processing unit 22 moves the order file A and the shipping instruction file B to the imported folder 12 where the shipping instruction file A has already been moved and stored, and stores them there.

[0042] The following details such a cooperation process. That is, as shown in Fig. 4, assume that the order file A, the order file B, the shipping instruction file a, the shipping instruction file b, and the shipping instruction file c are acquired by the acquisition unit 21 and stored in the cooperation folder 11.

[0043] As shown in FIG. 5, the cooperation processing unit 22 performs the cooperation processing of the order data in the order file A and the shipping instruction data in the shipping instruction file a. Also, it performs the cooperation processing of the order data in the order file B and the shipping instruction data in the shipping instruction file b. Also, it performs the cooperation processing of the order data in the order file C and the shipping instruction data in the shipping instruction file c.

[0044] In the case of the example in FIG. 5, in the order file A and the shipping instruction file a, the order data and the shipping instruction data with the order numbers "C2", "C3", and "C4" are subjected to the cooperation processing. Also, the shipping instruction data with the order number "C6" in the shipping instruction file b is subjected to the cooperation processing with the order data with the order number "C6" in the order file A, and the shipping instruction data with the order number "C7" in the shipping instruction file b is subjected to the cooperation processing with the order data with the order number "C7" in the order file B. Also, the shipping instruction data with the order number "C9" in the shipping instruction file c is subjected to the cooperation processing with the order data with the order number "C9" in the order file B.

[0045] When performing such cooperation processing, the cooperation processing unit 22 generates records corresponding to the order numbers from "C1" to "C10" for the work table 14 shown in FIG. 6, and adds the order date, customer code, and product name to each record. Also, the cooperation processing unit 22 stores in the work table 14 the order file name and the shipping instruction file name including the order number, or the order file name including the order number, or the shipping instruction file name including the order number.

[0046] As a result, as shown in FIG. 6, for the order numbers that have been cooperatively processed, both the order file name and the shipping instruction file name are stored on the work table 14, and for the order numbers that have not been cooperatively processed, either the order file name or the shipping instruction file name is stored on the work table 14.

[0047] Next, as shown in FIG. 7, for the order numbers in which both the order file name and the shipping instruction file name are stored, the cooperation processing unit 22 stores the import result of "success" in the work table 14. In the example of FIG. 7, for each of the order numbers "C2", "C3", "C4", "C6", "C7", and "C9", the import result of "success" is stored in the work table 14.

[0048] Also, as shown in FIG. 7, for the order numbers in which either the order file name or the shipping instruction file name is stored, the cooperation processing unit 22 stores the import result of "failure" in the work table 14. In the example of FIG. 7, for each of the order numbers "C1", "C5", "C8", and "C10", the import result of "failure" is stored in the work table 14.

[0049] Next, as shown in FIG. 8, the cooperation processing unit 22 sorts the details (records) of each order number with the import result of "success" in the order of the order date and in descending order of the order number, and stores them in the work table 14. As a result, although it is an image, the details (records) of each order number with the import result of "success" are arranged in the order of "C2" → "C7" → "C3" → "C4" → "C9" → "C6" along the column direction of the work table 14.

[0050] Similarly, as shown in FIG. 8, the cooperation processing unit 22 sorts the details (records) of each order number with the import result of "failure" in the order of the order date and in descending order of the order number, and stores them in the work table 14. As a result, although it is an image, the details (records) of each order number with the import result of "failure" are arranged in the order of "C1" → "C8" → "C5" → "C10" along the column direction of the work table 14.

[0051] Next, the cooperation processing unit 22 adds an order receiving date such as "August 3rd" to the details (records) of each order number in the "successful" import result after sorting. Also, the cooperation processing unit 22 numbers and adds an order receiving number based on the customer and the order date as shown in Fig. 9(a) to the details (records) of each order number in the "successful" import result after sorting. Specifically, in the case of the example in Fig. 9(a), for the details (records) of the order numbers "C2" and "C7" of the customer with the order date of "August 1st" and the customer code of "T1", the cooperation processing unit 22 numbers and adds the order receiving numbers of "A1" respectively. Also, the cooperation processing unit adds a line number of "1" to the details (records) of the order number of "C2", and adds a line number of "2" to the details (records) of the order number of "C2".

[0052] Also, for the details (records) of the order numbers "C3", "C4", and "C9" of the customer with the order date of "August 2nd" and the customer code of "T1", the cooperation processing unit 22 numbers and adds the order receiving numbers of "A2" respectively. Also, the cooperation processing unit adds a line number of "1" to the details (records) of the order number of "C3", adds a line number of "2" to the details (records) of the order number of "C4", and adds a line number of "2" to the details (records) of the order number of "C9".

[0053] Also, for the details (records) of the order number "C6" of the customer with the order date of "August 2nd" and the customer code of "T2", the cooperation processing unit 22 numbers and adds the order receiving number of "A3", and also adds a line number of "1".

[0054] Next, the generated linked file unit 23 generates the order receiving data shown in Fig. 9(b) based on the details (records) of each order number in the "successful" import result with the order receiving number attached in this way, and stores this in the order receiving data storage unit 13. The order receiving data, as shown in Fig. 9(b), includes the above-mentioned order receiving number and line number, as well as the order receiving date such as "August 3rd", the order date, the customer code, the product code, the order numbers such as "C2", "C7", "C3", and the shipping numbers such as "H1", "H5".

[0055] Next, as shown in FIG. 10, the cooperation processing unit 22 moves and stores in the imported folder 12 the file in which the cooperation processing of all order data or all shipping instruction data among the order file A, the order file B, and the shipping instruction files a to c is completed. In the case of the example in FIG. 10, the cooperation processing of all the shipping instruction data (order numbers C2 to C4) in the shipping instruction file a is completed, and the cooperation processing of all the shipping instruction data (order numbers C6 and C7) in the shipping instruction file b is completed. Therefore, as shown in FIG. 10, the cooperation processing unit 22 moves and stores the shipping instruction file a and the shipping instruction file b from the cooperation folder 11 to the imported folder 12.

[0056] Next, the communication control unit 25 automatically generates an e-mail indicating the content of the coordinated work table 14 shown in FIG. 9(a). Then, the communication interface unit 4 is controlled for communication so as to transmit this e-mail to the person-in-charge terminal device 51 via the network 50. As a result, an e-mail indicating the content of the coordinated work table 14 is transmitted to the person in charge. Then, the person in charge can recognize the current state of the cooperation process based on the transmitted e-mail.

[0057] Thus, when an e-mail indicating the content of the coordinated work table 14 is transmitted, the cooperation processing unit 22 deletes all the order data records and shipping instruction data records stored in the work table 14 as shown in FIG. 11.

[0058] Here, in the cooperation process so far, as shown in FIG. 9(a), the order data with order numbers "C1", "C8", "C5", and the shipping instruction data with order number "C10" remain as unprocessed orders (import result = failure).

[0059] In this state, as shown in FIG. 12, it is assumed that a new order file C, order file D, shipping instruction file d, and shipping instruction file e are acquired by the acquisition unit 21. The acquisition unit 21 stores the newly acquired order file C, order file D, shipping instruction file d, and shipping instruction file e in the cooperation folder 11.

[0060] In addition, the acquisition unit 21 also stores the order file A including the order data of the order numbers of "C1" and "C5" that are the remaining orders, and the order file B including the order data of the order number of "C8" that is the remaining order in the cooperation folder 11. Further, the acquisition unit 21 also stores the shipping instruction file c including the shipping instruction data of the order number of "C10" that is the remaining order in the cooperation folder 11.

[0061] In other words, the acquisition unit 21 stores the newly acquired order file C, order file D, shipping instruction file d, and shipping instruction file e in the cooperation folder 11, and also stores the files that have not been moved to the import completed folder 12 in the previous cooperation process in the cooperation folder 11.

[0062] Next, as shown in FIG. 13, the cooperation processing unit 22 coordinates the order data of the order file and the shipping instruction data of the shipping instruction file based on the order number. As a result, as shown in FIG. 13, the order data of the order number "C1" in the order file A and the shipping instruction data of the order number "C1" in the shipping instruction file d are coordinated. Also, the order data of the order number "C5" in the order file A and the shipping instruction data of the order number "C5" in the shipping instruction file d are coordinated.

[0063] Similarly, the order data of the order number "C9" in the order file B and the shipping instruction data of the order number "C9" in the shipping instruction file c are coordinated. Also, the order data of the order number "C8" in the order file B and the shipping instruction data of the order number "C8" in the shipping instruction file e are coordinated. Also, the order data of the order number "C10" in the order file C and the shipping instruction data of the order number "C10" in the shipping instruction file c are coordinated.

[0064] When performing such cooperation processing, the cooperation processing unit 22 generates records corresponding to the order numbers "C1" to "C10" for the work table 14 shown in FIG. 14, and adds the order date, customer code, and product name to each record. In addition, the cooperation processing unit 22 stores in the work table 14 the order file name and the shipping instruction file name that include the order number, or the order file name that includes the order number, or the shipping instruction file name that includes the order number.

[0065] As a result, as shown in FIG. 6, for the order numbers subjected to the cooperation processing, both the order file name and the shipping instruction file name are stored on the work table 14, and for the order numbers not subjected to the cooperation processing, either the order file name or the shipping instruction file name is stored on the work table 14.

[0066] The example in FIG. 14 is an example in which both the order file name and the shipping instruction file name are stored for the details (records) of each order number of "C1", "C5", "C8" to "C12". This indicates that the cooperation processing has been completed for the details (records) of each order number of "C1", "C5", "C8" to "C12".

[0067] Therefore, as shown in FIG. 15, the cooperation processing unit 22 adds the import result of "success" to the details (records) of each order number of "C1", "C5", "C8" to "C12".

[0068] Here, the cooperation processing unit 22 refers to the order receiving data storage unit 13 shown in FIG. 9(b) and detects the order numbers for which the order receiving data has been created in the previous cooperation processing. In the case of the example in FIG. 9(b), the order receiving data has been created for each order number of "C2", "C3", "C4", "C6", "C7", and "C9".

[0069] Therefore, as shown in FIG. 15, the cooperation processing unit 22 adds the import result of "imported" to the details (records) of each order number of "C2", "C3", "C4", "C6", "C7", and "C9" in the work table 14 respectively.

[0070] Next, as shown in FIG. 16, the cooperation processing unit 22 sorts the details (records) of each order number with the import result of "successful" in the order of the order date and in descending order of the order number, and stores them in the work table 14. Thus, although it is on the image, the details (records) of each order number with the import result of "successful" are arranged along the column direction of the work table 14 in the order of "C1" → "C8" → "C10" → "C11" → "C5" → "C12".

[0071] Similarly, as shown in FIG. 16, the cooperation processing unit 22 sorts the details (records) of each order number with the import result of "imported" in the order of the order date and in descending order of the order number, and stores them in the work table 14. Thus, although it is on the image, the details (records) of each order number with the import result of "imported" are arranged along the column direction of the work table 14 in the order of "C2" → "C7" → "C3" → "C4" → "C9" → "C6".

[0072] Next, for the details (records) of each order number with the import result of "successful" after sorting, as shown in FIG. 17(a), the cooperation processing unit 22 adds the order receiving date such as "August 4th", for example. Also, for the details (records) of each order number with the import result of "successful" after sorting, based on the customer and the order date as shown in FIG. 17(a), the cooperation processing unit 22 assigns and adds the order receiving number.

[0073] Specifically, in the case of the example in FIG. 17(a), for the details (records) of the order numbers of "C1" and "C8" of the customer with the order date of "August 1st" and the customer code of "T1", the cooperation processing unit 22 assigns and adds the order receiving numbers of "A4" respectively. Also, the cooperation processing unit adds the line number of "1" to the details (records) of the order number of "C1", and adds the line number of "2" to the details (records) of the order number of "C8".

[0074] In addition, for the details (records) of the order numbers of "C10" and "C11" of the customer with the order date of "August 2nd" and the customer code of "T1", the cooperation processing unit 22 assigns and adds the order receiving numbers of "A5" respectively. Also, for the details (records) of the order number of "C10", the cooperation processing unit adds the line number of "1", and for the details (records) of the order number of "C11", the cooperation processing unit adds the line number of "2".

[0075] In addition, for the details (records) of the order number of "C5" of the customer with the order date of "August 2nd" and the customer code of "T2", the cooperation processing unit 22 assigns and adds the order receiving number of "A6", and also adds the line number of "1".

[0076] In addition, for the details (records) of the order number of "C12" of the customer with the order date of "August 3rd" and the customer code of "T1", the cooperation processing unit 22 assigns and adds the order receiving number of "A7", and also adds the line number of "1".

[0077] Next, based on the details (records) of the order numbers of "C1", "C8", "C10", "C11", "C5", and "C12" of the "successful" import result with the order receiving numbers attached in this way, the linked file generation unit 23 generates the order receiving data shown in FIG. 17(b). And although it is an image, the linked file generation unit 23 stores the order receiving data of these order numbers of "C1", "C8", "C10", "C11", "C5", and "C12" in the order receiving data storage unit 13 following (continuously in the column direction) the order receiving data of the order numbers of "C2", "C7", "C3", "C4", "C9", and "C6" created during the previous cooperation processing as shown in FIG. 17(b).

[0078] Next, as shown in FIG. 18, the cooperation processing unit 22 moves and stores order files A to D for which the cooperation processing of all order data has been completed and shipping instruction files c to e for which the cooperation processing of all shipping instruction data has been completed from the cooperation folder 11 to the imported folder 12 in which the shipping instruction files a and b have been moved during the previous cooperation processing.

[0079] Next, the communication control unit 25 automatically generates an e-mail indicating the contents of the completed cooperation work table 14 shown in FIG. 17(a). Then, the communication interface unit 4 is controlled to communicate so as to transmit this e-mail to the person-in-charge terminal device 51 via the network 50. As a result, an e-mail indicating the contents of the completed cooperation work table 14 is transmitted to the person in charge. Then, the person in charge can recognize the current state of the cooperation processing based on the transmitted e-mail.

[0080] When an e-mail indicating the contents of the completed cooperation work table 14 is transmitted in this way, the cooperation processing unit 22 deletes all the order data records and shipping instruction data records stored in the work table 14 as described with reference to FIG. 11.

[0081] (Effects of the Embodiment) When collating and linking the data of a plurality of files, for example, while one file has 10 pieces of data, the data of the other file for which linking (collation) is performed is 8 pieces, and the remaining 2 pieces of data occur at a later date. There may be a time lag in the timing when the data of each file matches. As a result, the file linking operation (collation operation) becomes complicated.

[0082] In addition, when an order file has multiple product data, it may be possible to separate the details for which the delivery date can be replied within the first day from those that will be replied at a later date. Also, it is assumed that a shipping instruction file for product data not in the order file may be generated first due to system input omissions by the person in charge or the like. In addition, there may be a need to perform a verification operation in a combined shipping instruction file for the details of order file A and order file B. Due to such reasons, there has been a problem that the management of outstanding orders has become complicated.

[0083] The business support device 1 of the embodiment can distinguish and handle the details that can be counted as orders and the details for which order counting is postponed regardless of which file is generated first among the files to be linked, so that it is possible to eliminate the need for re-linking of files. In addition, it is possible to cope with a time lag at the timing when the data of each file is aligned.

[0084] In addition, each time a linking process is performed, the order numbers are aggregated and issued, and since the order numbers are issued each time in the form of multiple details on one slip, simple management of outstanding orders can be enabled.

[0085] In addition, the business support device 1 of the embodiment can perform a linking process on a plurality of files at an arbitrary timing.

[0086] In addition, it is possible to generate order data by importing only the details that match at the row unit.

[0087] In addition, even for the rows that do not match, when they match by a subsequent file linking process, a linking process can be performed that is distinguished from the already linked rows.

[0088] In addition, the source file for linking can be kept in its original state without performing processing such as splitting, and only the file for which all details have been linked can be moved to backup.

[0089] [Contribution to the Sustainable Development Goals (SDGs) led by the United Nations] According to the present invention, since it can contribute to improving business efficiency and promoting appropriate business judgment of enterprises, it can contribute to the goals of "8" and "9" of the SDGs.

[0090] In addition, according to the present invention, since it can contribute to reducing waste loss and promoting paperless and digitalization, it can contribute to the goals of "12", "13" and "15" of the SDGs.

[0091] In addition, according to the present invention, since it can contribute to strengthening control and governance, it can contribute to the goal of "16" of the SDGs.

[0092] [Other Embodiments] The present invention can be implemented in various different forms within the scope of the technical idea described in the claims even in forms other than the above-described embodiments.

[0093] For example, among the respective processes described in the embodiment, all or part of the processes described as being automatically performed may be performed manually. Or, all or part of the processes described as being performed manually may be automatically performed by a known method or the like.

[0094] In addition, regarding the processing procedures, control procedures, specific names, information including registration data of each process, parameters such as search conditions, screen examples, and database configurations shown in the specification or drawings, they can be arbitrarily changed unless otherwise specified.

[0095] In addition, regarding the business support device 1, each illustrated component is a functional concept, and it is not necessarily required to have the illustrated physical configuration. For example, regarding the processing functions provided in the business support device 1, particularly each processing function performed by the control unit 3, all or any part of them may be realized by a program interpreted and executed by the control unit 3 (CPU: Central Processing Unit), or may be realized by hardware using wired logic.

[0096] Note that the program includes non-temporary computer-readable instructions for causing an information processing apparatus to execute the processes described in the embodiments, and is recorded on a non-temporary computer-readable recording medium, and is mechanically read by the business support apparatus 1 as necessary. That is, in a storage unit 2 such as a ROM or an HDD, a computer program for giving instructions to a control unit 3 (CPU) in cooperation with an OS (Operating System) to perform various processes is recorded. This computer program is loaded into a RAM and expanded, and is appropriately executed by the control unit 3.

[0097] Also, the business support program of this business support apparatus 1 may be stored in another server apparatus connected to the business support apparatus 1 via an arbitrary network, and all or part of it may be downloaded and executed as necessary.

[0098] Also, a business support program for executing the processes described in the embodiments may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product.

[0099] Here, as the "recording medium", any "portable physical medium" such as a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical Disk), a DVD (Digital Versatile Disk), and a Blu-ray (registered trademark) Disc can be used.

[0100] In addition, a "program" is a data processing method described in any language or description method, and is not limited to forms such as source code or binary code.

[0101] Note that the "program" is not necessarily limited to being configured singly, and includes those that are distributed as a plurality of modules or libraries and those that achieve their functions in cooperation with separate programs typified by the OS.

[0102] In addition, regarding the specific configuration, reading procedure, and installation procedure after reading for the recording medium reading unit in the business support apparatus 1 of the embodiment, well-known configurations or procedures can be used.

[0103] The storage unit 2 is a storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and stores various programs, tables, databases, and web page files used for various processes or website provision.

[0104] In addition, the business support apparatus 1 may be configured by a known information processing apparatus such as a personal computer device or a workstation, or may be configured by an information processing apparatus to which an arbitrary peripheral device is connected. Further, the information processing apparatus may be realized by implementing software (including programs or data, etc.) that realizes the processing described in the embodiment.

[0105] Furthermore, the specific forms of distribution and integration of the apparatus are not limited to those illustrated, and all or part of them can be functionally or physically distributed or integrated in arbitrary units according to various additions or according to the function load. That is, the above-described embodiments may be selectively implemented by arbitrarily combining the above-described embodiments.

Industrial Applicability

[0106] The present invention is suitable for application to industries or sectors that require collation processing of multiple types of files at different timings. In particular, it is suitable for application to industries with a long lead time, such as the machinery industry, the semiconductor industry, etc.

Explanation of Signs

[0107] 1 Business support device 2 Storage unit 3 Control unit 4 Communication interface unit 5 Input / output interface unit 6 Input device 7 Output device 11 Collaboration folder 12 Imported folder 13 Order data storage unit 14 Work table 15 Order file storage unit 16 Shipping instruction file storage unit 21 Acquisition unit 22 Collaboration processing unit 23 Generated file for collaboration 24 Output control unit 25 Communication control unit 50 Network 51 Person-in-charge terminal device

Claims

1. A linking processing unit that collates one or more linked detail data included in a linked file with one or more linking detail data included in a linking file, and performs a linking process to detect the linked detail data and the linking detail data that match respectively; A linked file generation unit that generates linked detail data with the detected linked detail data and the linking detail data that match respectively, and generates a linked file including one or more pieces of the linked detail data; A business support device having the above.

2. The linking processing unit stores each of the linked detail data and each of the linking detail data in a linking folder which is a storage area of the storage unit, and performs the linking process. By performing the linking process, the linked file in which all the linked detail data are linked with the linking detail data, and the linking file in which all the linking detail data are linked with the linked detail data are moved to an imported folder which is a storage area of the storage unit. The business support device according to claim 1, characterized in that.

3. The linking processing unit stores in a work table which is a storage area of the storage unit each of the linked detail data for which there is no matching linking detail data, each of the linking detail data for which there is no matching linked detail data, and each of the linked detail data and each of the linking detail data that match respectively, and for each of the linked detail data for which there is no matching linking detail data and each of the linking detail data for which there is no matching linked detail data, an import result of "failure" is added and stored in the work table, for each of the linked detail data and each of the linking detail data that match respectively, an import result of "success" is added and stored in the work table, The linked file generation unit generates the linked file with the linked detail data and the linking detail data to which the import result of "success" in the work table is attached. The business support device according to claim 2, characterized in that.

4. The linking processing unit when either one of a new linked file and a new linking file is input, the input new file, the linked file in which all the linked detail data were not linked with the linking detail data during the previous linking process, and For the linkage files in which all the above linkage detail data have not been processed in linkage with the linked detail data, store them in the work table to perform the linkage process. For each linked detail data where there is no matching linkage detail data, and for each linkage detail data where there is no matching linked detail data, attach the import result of "failure". For each linked detail data and each linkage detail data that match respectively, attach the import result of "success". Among the linked detail data and the linkage detail data stored in the work table, for the linked detail data and the linkage detail data corresponding to the linked file generated based on the import result of "success", attach the import result of "imported". The linked file generation unit generates a new linked file with the linked detail data and the linkage detail data with the import result of "success" in the work table, and adds it to the previously generated linked file. The business support device according to claim 3, characterized in that.

5. The business support device further includes a communication control unit that controls a communication unit to generate an email for notifying the content of the work table to a predetermined person in charge and transmit it to the terminal device of the person in charge via a predetermined network. After transmitting the email, the linkage processing unit deletes all the linked detail data and all the linkage detail data stored in the work table. The business support device according to claim 4, characterized in that.

6. The linked file is an order file for a predetermined business transaction target, the linkage file is a shipping instruction file for performing a shipping instruction for part or all of the business transaction target in the order file, and the linked file is the order received data for the business transaction target. The business support device according to any one of claims 1 to 5, characterized in that.

7. A linkage processing step in which a linkage processing unit collates one or more linked detail data included in a linked file with one or more linkage detail data included in a linkage file, and performs a linkage process to detect the linked detail data and the linkage detail data that match respectively. A linked file generation step in which the linked file generation unit generates linked detail data using the detected corresponding linked detail data and linked detail data, and generates a linked file including one or more pieces of the linked detail data. A business support method having the above.

8. A computer A linking processing unit that performs a linking process of collating one or more linked detail data included in a linked file with one or more linking detail data included in a linking file, and detecting corresponding linked detail data and linking detail data. Function as a linked file generation unit that generates linked detail data using the detected corresponding linked detail data and linked detail data, and generates a linked file including one or more pieces of the linked detail data. A business support program having the above.

Images