JP2009245067A - Appropriateness confirmation system and program of business process - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a technology for sequentially confirming consistency among three types of data or more resulting from the same transaction each time data arrives. <P>SOLUTION: This appropriateness confirmation system 12 of a business process is provided with: a data shaping part 44 for converting various received data to be confirmed into a standard format and storing the converted data into a confirmation data storing part 46; a confirmation processing part 50 for confirming whether other types of confirmation data associated with each other required for confirming the appropriateness of a business process exist in the confirmation data storing part 46 on the basis of a transaction ID of each confirmation data, comparing values between predetermined data items between data of a prescribed type in the required data provided, and confirming the appropriateness of the values; and a display image generating part 52 for generating an image of a confirmation result. The display image generating part 52 generates a list image obtained by vertically arranging a row of data including the type and collation results of each confirmation data in a group unit. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to a business process suitability confirmation system and program, and in particular, based on various data transmitted via a network, by confirming the lack of necessary data and the consistency between data, the business process can be properly performed. The present invention relates to a technique for automatically determining whether or not an execution has been performed and displaying the result on a display.

  Several techniques have already been proposed for determining whether or not the values of various types of data generated through the transaction of goods and services match each other and displaying the result on a display.

  For example, in the case of “Accounts receivable collation system” in Patent Document 1, the sales data of the seller and the inspection data of the purchaser are automatically collated by the collation system on the seller side, and the collation result is stored in the database as collation history information. A technique for displaying on a display is disclosed.

According to this accounts receivable collation system, when displaying the collation result, sales data is listed on the left side of the screen and at the same time the corresponding inspection data is listed on the right side of the screen. It is possible to recognize at a glance the difference in unit price and amount.
JP 7-129685 A

  However, in the case of this conventional verification system, the target of verification is limited to two types of data, sales and acceptance, so there is certainly an advantage that it is easy for humans to compare verification results. It was insufficient to achieve the purpose of confirming the suitability of the process. Hereinafter, this problem will be described while exemplifying specific data generated in association with a product sales transaction.

  That is, as shown in FIG. 15, when an order for a product enters the seller from the product purchaser, the order data is input to the computer 80 of the sales office that receives the order. Further, delivery instruction data is generated based on the order data and transmitted to the computer 81 at the delivery center. Upon receiving this, the computer 81 of the delivery center generates shipping data, and based on this, the delivery of the product to the purchaser is performed. When the purchaser notifies the completion of the inspection, the inspection data is input to the computer 82 of the head office accounting department. The computer 82 in the head office accounting department collates the first order data and the current acceptance data, and if the two match, the computer 82 regards the delivery as complete and generates invoice data. Next, the invoice output based on the invoice data is sent to the purchaser, and remittance processing from the purchaser's bank account to the seller's bank account is executed. When a payment notice is received from the seller's bank, the payment data is input to the computer 82 in the head office accounting department. Finally, the computer 82 in the head office accounting department compares the invoice data with the deposit data and confirms that they match.

  In such a transaction form, after an order for a quantity of 100 is issued from the purchaser to the seller, when a correction request for reducing the quantity by 20 is made, as shown in FIG. The first order data 83 having the quantity “100” and the second order data 84 having the quantity “−20” having the same order number are input. Therefore, “100−20 = 80” pieces of delivery instruction data and shipment data should be generated originally, but 100 items are delivered from the seller to the buyer with a delay in the correction timing. Assume that you have. In such a case, it is only necessary to detect that 20 or more items have been delivered at the time of acceptance by the purchaser. However, since at least 80 items have been delivered, there is a possibility that an acceptance completion notification will be issued as “appropriate”. Is expensive. For this reason, the acceptance data 85 of the quantity “80” is input to the computer 82 of the head office accounting department, and at the time of the above verification, the order quantity = 80 and the acceptance quantity = 80 result in a match. Invoices will be issued. In short, the overdelivery of 20 items is not detected by the above collation process, and disappears in the dark.

  Originally, in addition to the above-mentioned order data 83, 84 and acceptance data 85, if matching processing is performed with at least one of delivery instruction data 86 or shipping data 87 that occurs in the middle, there is a mismatch between them. However, since the conventional collation system is only intended for collation between two types of data, as described above, it can be detected between three or more types of data including data that occurs midway. There was a risk of overlooking the inconsistency in.

  Of course, it is not impossible to solve the above problem by executing a plurality of collation processes even in a conventional collation system having only a collation function between two types of data. That is, as shown in FIG. 17, first, collation processing is executed between order data and shipping data (or delivery instruction data), intermediate quantity confirmation data is generated, and this is collated with inspection data to perform collation. If invoice data is generated for a completed case, it is possible to detect in advance the quantity mismatch in the middle as described above and take corrective action before the invoice data is generated. However, such a method of repeating the collation between the two types of data in multiple stages naturally increases the number of collations, resulting in a complicated process. Moreover, since it is necessary to wait for necessary data to be prepared for each collation, there arises a problem that the overall processing time becomes long. Further, intermediate data used only for the collation process is also generated, resulting in wasting system resources.

  The automatic matching process by the computer is important not only for the above-mentioned commodity transaction but also for the financial commodity transaction. As an example, FIG. 18 shows that the trust bank system 90 confirms the propriety of stock trading between institutional investors and securities companies, and based on the results, the ledger of the institutional investors entrusted with management (this The example shows the processing and data flow when updating the fund ledger and stock ledger).

  First, when an institutional investor issues a stock purchase order to a securities company, order data 60 is transmitted from the institutional investor system 24 to the trust bank system 90. After that, the order data is transmitted from the securities company system 26 to the exchange system (not shown), and when the sale is completed, the contract communication data (breaking news) 61 is transmitted from the securities company system 26 to the trust bank system 90. .

  Receiving this, the trust bank system 90 collates the order data 60 and the contract communication data (breaking news) 61 by nightly batch processing (order confirmation processing 91), and if the order contents match, an intermediate order is placed. Confirmation data 92 is generated. Next, trading report data (final report) 62 to which actual costs, fees, taxes, etc. required for the current transaction are added is transmitted from the securities company system 26 to the trust bank system 90. Receiving this, the system 90 of the trust bank collates the order confirmation data 92 and the trading report data (final report) 62 that have been generated earlier by the nighttime batch processing (order completion confirmation processing 93), and the order is completed. Make sure you did. When the collation is completed, transfer instruction data 68 for the bank account of the securities company is generated by the trust bank system 90 and transmitted to the bank system 30. At the same time, the trust bank system 90 generates stock certificate warehousing instruction data 69 and transmits it to the system 32 of the securities custody transfer organization (hereinafter “vibration”).

  In the bank system 30, the necessary amount is transferred to the bank account of the securities company, and the deposit / withdrawal completion report data 65 as a result is transmitted to the trust bank system 90. Similarly, in the vibration proofing system 32, the designated stock certificate entry process is executed, and the resulting entry / exit completion report data 66 is transmitted to the trust bank system 90.

  The trust bank system 90 first collates the transfer instruction data 68 with the deposit / withdrawal completion report data 65 (transfer confirmation processing 94). Next, the trust bank system 90 collates the warehousing instruction data 69 with the warehousing / unloading completion report data 66 (a warehousing / excluding confirmation process 95). When the transfer confirmation process 94 and the entry / exit confirmation process 95 are completed, the trust bank system 90 assumes that the current transaction has been successfully completed, and updates the institutional investor's ledger database (the ledger update process 96 ).

  As described above, under the conventional method in which the collation process between two types of data is repeated many times in a nightly batch, the settlement of the stock trading transaction is completed after the trade date (T) 4 It took a day (this is called T + 4 settlement). On the other hand, the idea that settlement should be completed the day after the contract date has been proposed in order to reduce the risk of being unable to settle due to bankruptcy of financial institutions in securities transactions including stocks. (This is referred to as “T + 1 payment”) As long as the nighttime batch verification between only two types of data is assumed, there is no realization of realizing T + 1 payment.

  In addition, the ledger update process 96 should be executed with extreme caution and strictness in order to directly relate to the interests of institutional investors, and after the transfer confirmation process 94 and the receipt / exit confirmation process 95, It can be said that it is desirable to check the data consistency between the entry / exit completion report data and the order data 60 and the trade report data 62 again. However, in the case of the conventional collation system, as described above, since it is merely determined whether the value of a specific item matches or does not match between only two types of data, it is further necessary to confirm the inconsistency of the business process. It was necessary to provide many verification steps, which was unrealistic.

  The present invention has been devised to solve the problems of such a conventional collation system, and it is possible to check the consistency between three or more types of data resulting from the same transaction each time data arrives. The purpose is to provide a technology that can check the suitability of the business process during the execution and can display the check result with high visibility.

  In order to achieve the above object, the business process suitability confirmation system according to claim 1 is capable of confirming compatibility between three or more types of data generated by the progress of a business process and displaying a confirmation result. This is a process suitability confirmation system that converts various received data to be confirmed into a standard format and stores them in a common confirmation object data storage means, based on the value of a specific data item of this confirmation object data Means for confirming whether or not other types of mutually relevant confirmation target data necessary for confirming the suitability of the business process exist in the confirmation target data storage means, and necessary confirmation target data If there is a set of data items, the means for comparing the values of the predetermined data items between the predetermined types of data in the data and confirming the suitability thereof, and the above confirmation result are Screen generating means for generating a screen to be displayed on the spray, and this screen generating means includes at least a plurality of data items in the horizontal one-line format including at least the type of each check target data and the check result, which are mutually related. It is characterized in that a list screen arranged in a vertical direction in a group unit that is a collection of types of data is generated.

  The business process suitability confirmation system according to claim 2 is the system according to claim 1, and the screen generation means has received only a part of the required type of confirmation target data, Generates a list screen in which data in one horizontal row including at least the type of each received confirmation target data and the reception date and time are arranged in the vertical direction when all necessary confirmation target data is not available It is said.

  The business process suitability confirmation program described in claim 3 is a business process suitability confirmation program that enables confirmation of compatibility between three or more types of data generated by the progress of a business process and display of the confirmation result. The computer converts various received data to be confirmed into a standard format and stores it in a common confirmation target data storage means, and the suitability of the business process based on the value of a specific data item of the confirmation target data If there is a means for confirming whether or not other types of confirmation target data that are necessary for confirmation in the confirmation target data storage means are present, Means for comparing the values of predetermined data items among predetermined types of data among them, and confirming their suitability, the above confirmation result on the display Functioning as a screen generating means for generating a screen for display, and this screen generating means generates at least a plurality of types of data in a horizontal line including at least a type of each check target data and a check result. A feature is that it has a function of generating a list screen arranged in a vertical direction in a group unit that is a collection of data.

According to the business process suitability confirmation system described in claim 1 and the business process suitability confirmation program described in claim 3, there are three or more types generated according to a business process that is developed based on a single transaction. Therefore, it is possible to determine the suitability of the values of the necessary data items, and to confirm the suitability of the business process with higher accuracy.
In addition, each time new data to be confirmed sent from the transmission source through the network or the like is stored, the data alignment necessary for the confirmation processing is checked, and the confirmation processing is executed in order from the group in which the data is complete. Compared to conventional verification systems based on nighttime batches, rapid processing is possible.
Furthermore, the confirmation results are displayed on the display in a state where each piece of data to be confirmed is arranged in a list in the vertical direction in the form of one horizontal row, and is also grouped in groups of a series of data resulting from the same transaction. It is possible to efficiently check the collation result between three or more types of data.

The advantage of the present invention is that the conventional collation system has moved away from the idea that “only two types of data comparisons that humans have performed have been replaced with machines”, and “collective collation of three or more types of data that cannot be done manually. It is said that it has achieved both the operational accuracy and response.
In the case of a conventional collation system, since collation processing between two types of data is premised, it is necessary to repeat collation processing in multiple stages as described above in order to confirm the suitability of a business process. It was necessary to wait for the necessary types of data to be available. On the other hand, in the case of the present invention, all types of data necessary for determining the suitability of business processes are stored in the common confirmation target data storage means, and the necessary data is prepared without being bound by the arrival order of each data. Since batch processing becomes possible at the time, the overall processing speed can be improved.

  In the business process suitability determination system according to claim 2, since the type and the reception date and time are displayed in a list format for the data for which the necessary data to be confirmed is not available, the necessary data delay trouble is caused. A quick response is possible.

  FIG. 1 shows a trust bank system 10. The trust bank system 10 includes a business process suitability confirmation system 12, a ledger management system 18, and an operation terminal 20 composed of a PC.

  The business process suitability confirmation system 12 and the ledger management system 18 and the operation terminal 20 and the business process suitability confirmation system 12 are respectively connected by a communication network such as a LAN. The operating terminal 20 includes an OS and a data display program.

  An institutional investor system 24 and a securities company system 26 are connected to the business process suitability confirmation system 12 via a communication network 22, and a bank system 30 and an anti-vibration system 32 are connected via a communication network 28. Is connected.

  FIG. 2 is a block diagram showing a functional configuration of the business process suitability confirmation system 12. The data reception unit 40, the received data storage unit 42, the data shaping unit 44, the confirmation target data storage unit 46, and the confirmation process Unit 50, display screen generation unit 52, and confirmation result transmission unit 54. The data receiving unit 40, the data shaping unit 44, the confirmation processing unit 50, the display screen generation unit 52, and the confirmation result transmission unit 54 are configured so that the CPU of the computer constituting the business process suitability confirmation system 12 is in accordance with the OS and a dedicated application program. This is realized by executing necessary processing. The reception data storage unit 42 and the confirmation target data storage unit 46 are provided in the hard disk of the computer.

  As shown in FIG. 3, the business process suitability confirmation system 12 includes an order data 60 transmitted from the institutional investor system 24, a contract communication data (preliminary report) 61 and a trade report data transmitted from the securities company system 26. (Confirmation report) 62, order completion confirmation processing (first business process confirmation processing) for determining the presence / absence of corresponding data among the three types of data and the match / mismatch of the values of the specific data items, as shown in FIG. The deposit / withdrawal completion report data 65 sent from the bank system 30, the receipt / withdrawal completion report data 66 sent from the vibration isolation system 32, the accumulated standard formatted order data 60 ′, the accumulated standard format To determine the presence / absence of corresponding data among the four types of data of the converted sales report data 62 ′ and the matching / non-matching or suitability of the value of a predetermined item between specific data Confirmation process performs two confirmation processing (second business process confirmation process) (described in detail later).

Next, the order completion confirmation process in the business process suitability confirmation system 12 will be described with reference to the flowchart of FIG. First, when the business process suitability confirmation system 12 receives the confirmation target data transmitted from the institutional investor system 24 or the securities company system 26 (S10), the data reception unit 40 stores the data in the received data storage unit 42. (S11). The types of verification target data transmitted here include the following (1) to (3). The data receiving unit 40 adds reception date and time information to these three types of data, and stores them in the reception data storage unit 42 in the order of reception.
(1) Stock order data 60 having the same content as sent from the institutional investor system 24 to the securities company system 26
(2) Contract communication data (breaking news) 61 with the same contents as sent from the securities company system 26 to the institutional investor system 24
(3) Trading report data (final report) 62 with the same content as sent from the securities company's system 26 to the institutional investor's system 24

When new data is stored in the received data storage unit 42, the data shaping unit 44 is activated, and after sequentially converting the verification target data into the standard format (S12), the data is stored in the verification target data storage unit 46 (S13). . In other words, since the data (1) to (3) have their own data items and data formats, it is difficult to efficiently collate the data as it is. Therefore, the data formatter 44 converts the data into a common format in advance. As an example, the following conversion process is executed by the data shaping unit 44.
(B) Unify the order of data items of each verification target data to the order of data items of standard data.
(B) Replenish data items necessary for subsequent verification processing and settlement processing.
(C) Supply necessary values from other databases. For example, for data in which only the broker name is described, the broker code DB is referred to and the corresponding broker code is supplemented.

  FIG. 6 illustrates various confirmation object data stored in the confirmation object data storage unit 46 and converted into the standard format, that is, order data 60 ′, execution contact data 61 ′, and sales report data 62 ′. Transaction ID, group ID, date and time of reception, confirmation result (first / second), confirmation date and time (first / second), data type, broker code, brand code, trade date, trade type, trade quantity, contract price, Data items such as deposit / withdrawal and deposit / withdrawal are provided. As shown in the drawing, regardless of the type of data (data type), each check target data has the same data item. Although not shown in the figure, the data to be verified includes other fees, taxes, transferee name, transferee account, transfer amount, transfer date, receiving brokerage company name, receiving brokerage company code, and issuing brokerage company name. It has a number of data items that are assumed to be necessary for the exchange of financial related data, such as the issuing securities company code and the date of entry / exit.

  In the “transaction ID” data item, the transaction ID originally included in the three types of check target data is described as it is. This transaction ID itself is an identification code of the order data 60 transmitted from the institutional investor system 24, which is directly carried over by the contract communication data and trading report data. Different types of data depend on the identity of this transaction ID. They are recognized as related data related to a series of transactions.

  On the other hand, when new data is stored in the confirmation target data storage unit 46, the confirmation processing unit 50 is activated to check whether or not a group necessary for the order completion confirmation processing is prepared. Specifically, referring to the transaction ID of the new data, it is determined whether data having the same transaction ID exists in the confirmation target data storage unit 46 (S14), and the same transaction ID is provided. If the preceding data exists, the group ID of the existing data is assigned to the new data (S15).

  Next, the confirmation processing unit 50 determines whether or not necessary types of data are prepared (S17). In other words, in this scene (order completion confirmation processing), it is set in advance so that proper confirmation processing can be performed only when three types of order data 60 ′, contract communication data 61 ′, and sales report data 62 ′ are prepared. Therefore, the confirmation processing unit 50 determines whether or not three types of confirmation target data having the same group ID are arranged in the confirmation target data storage unit 46.

  If the determination result is YES, the confirmation processing unit 50 determines the data items necessary for order completion confirmation (for example, the broker) for the three types of confirmation target data of order, contract communication, and sales report related to the same transaction ID. Code, brand code, execution date, transaction type, transaction quantity, contract unit price) is checked to see if the values are appropriate (S20). If they are appropriate, the data item of the first confirmation result of each check target data “OK” is recorded (S21). At this time, the confirmation date is also recorded in the first confirmation date item.

  When “OK” is recorded for the data in the confirmation target data storage unit 46, the confirmation result transmission unit 54 is activated, and a transfer instruction for the stock purchase price is issued based on the confirmation result = OK trading report data 62 ′. Data 68 is generated and transmitted to the bank system 30 (S23). This transfer instruction data 68 includes at least a transaction ID, a transfer destination name (a brokerage company name), a transfer destination account (a bank account of a securities company), and a transfer amount (transaction quantity x contract price + commission + tax). It is. In addition, the confirmation result transmission unit 54 records the data for which the transfer instruction has been given for the deposit / withdrawal items of the order data 60 ′ and the sales report data 62 ′ stored in the confirmation target data storage unit 46 (S24).

  At the same time, the confirmation result transmission unit 54 generates warehousing instruction data 69 for the purchased stock certificate based on the sales report data 62 ′ and transmits it to the vibration isolating system 32 (S25). This warehousing instruction data includes at least a transaction ID, warehousing company name, warehousing company code, brand code, and warehousing quantity. In addition, the confirmation result transmission unit 54 records the warehousing-instructed data for the warehousing / excluding items of the order data 60 ′ and the sales report data 62 ′ stored in the confirmation target data storage unit 46 (S26).

  If there is no preceding data with the same transaction ID in S14, the confirmation processing unit 50 waits until subsequent data with the same transaction ID is stored without assigning a group ID to the newly registered data. (S16). On the other hand, if there is only one data with the same transaction ID, the confirmation processing unit 50 assigns a common group ID to both the existing data and the newly registered data (S15), and at the same time, the required three types of data Since no data is available (S17 / N), “NG” is recorded in each first confirmation result item (S18). In this case, the suitability of the value between the specific data items is determined at the time when the missing data is registered, and if so, “OK” is recorded in the first confirmation result item of each data (S17, S20, S21). Further, although not related to the current process, it is determined as NG because it is not a normal state even when a plurality of identical records are stored for reasons such as erroneous double transmission.

  In this business process suitability confirmation system 12, each time new data is registered in the confirmation target data storage unit 46, it is confirmed whether or not the necessary type of data is prepared and the necessary type of data. Since it is determined whether or not the values of predetermined data items coincide with each other at the time when the data are collected, it is possible to perform a quick process as compared with the conventional collation system based on the night batch. As a result, the order completion confirmation process is executed on the trade date, and the transfer instruction data 68 can be transmitted to the bank system 30 and the receipt instruction data 69 can be transmitted to the vibration preservation system 32. Even when nighttime batches in the vibration isolating system 32 are taken into consideration, it becomes possible to realize T + 1 settlement intended for settlement on the next day.

  Next, a procedure for displaying the result of the confirmation process will be described with reference to the flowcharts of FIGS. First, when a confirmation result display request is transmitted from the operation terminal 20, the display screen generation unit 52 that receives the request (S30 in FIG. 7) transmits a display target selection screen 70 shown in FIG. 10 (S31).

  On this display target selection screen 70, the operator clicks the result under the confirmed folder 72 included in the order / contract notification / trading report folder 71: the NG folder 73, and selects an arbitrary date from among the expanded folders by date. When a folder (for example, 2007/07/12) is selected, a request for a confirmation result NG list screen relating to confirmation target data having a corresponding reception date is transmitted to the business process suitability confirmation system 12.

  Upon receipt of this, the display screen generation unit 52 of the business process suitability confirmation system 12 (S32) extracts data with a confirmation result of NG from the confirmation target data storage unit 46 (S33), and generates a confirmation result NG list screen. Then, it transmits to the operation terminal 20 (S34).

  FIG. 11 shows an example of the confirmation result NG list screen 74 displayed on the display of the operation terminal 20. The order data 60 ′, the contract communication data 61 ′, and the sales report data 62 ′ in the horizontal one-line format are It is displayed in a list state that is divided in units of confirmation groups and arranged vertically.

  For example, in the case of the confirmation group “X02155”, the contract communication data 61 ′ and the sales report data 62 ′ are prepared, but since the corresponding order data 60 ′ does not exist, the character “NG” is displayed in the confirmation result display item. At the same time, the data type item is highlighted.

  On the other hand, in the case of the confirmation group “X02164”, the transaction quantity of the order data 60 ′ is “300”, whereas the transaction quantity of the contract communication data 61 ′ and the sales report data 62 ′ is “200”. Since the values do not match, the transaction quantity item is highlighted and the “NG” character is displayed in the confirmation result display item.

  In the case of the confirmation group “X02188”, “3214” is displayed as the stock code only in the order data 60 ′, and the stock code is blank in both the contract communication data 61 ′ and the sales report data 62 ′. Since the values still do not match, the brand code item is highlighted and the characters “NG” are displayed in the confirmation result display item.

  In this way, since the confirmation target data in the horizontal one-line format is displayed on the display in a list state arranged in the vertical direction for each confirmation group, the operator can confirm the confirmation result even if there are three or more types of confirmation target data. Can be easily listed, and the location of the problem can be immediately grasped. Note that the operator must investigate the cause of each confirmation group with “NG” displayed and make a confirmation request or retransmission request to the data transmission source. Corrections can also be made.

  The operator can also browse the confirmation result of “OK”. That is, on the display target selection screen 70 in FIG. 10, when the operator clicks the result: OK folder 75 under the confirmed folder 72, and selects a folder with an arbitrary date from among the expanded folders by date (not shown). The confirmation result OK list screen request related to the confirmation target data having the corresponding reception date is transmitted to the business process suitability confirmation system 12.

  Receiving this (S35 in FIG. 8), the display screen generating unit 52 extracts the data whose confirmation result is OK from the confirmation target data storage unit 46 (S36), and after generating the confirmation result OK list screen, the operation terminal 20 (S37). As a result, although not shown, a confirmation result OK list screen is displayed on the display of the operation terminal 20. Also in this screen, the order data 60 ′, the contract communication data 61 ′, and the sales report data 62 ′ in the horizontal one-line format are divided in groups and displayed in a list state in which each is arranged in the vertical direction. And the character of “OK” is described in the item of the confirmation result of each data.

  When the operator clicks the standby folder 76 on the display target selection screen 70 in FIG. 10 and selects a folder with an arbitrary date from among the expanded folders by date (not shown), a confirmation with a corresponding reception date is provided. A request for the standby data list screen related to the target data is transmitted to the business process suitability confirmation system 12.

  Receiving this, the display screen generation unit 52 (S38 in FIG. 9) extracts the data to which the group ID is not assigned from the confirmation target data storage unit 46 (S39), generates the standby data list screen, and then operates the operation terminal. It transmits to 20 (S40). As a result, although not shown, a standby data list screen is displayed on the display of the operation terminal 20. In this screen, the confirmation target data in the horizontal one-line format to which the group ID has not yet been assigned is displayed for each item in the order of the reception date and time. If the reception date and time of the standby data is still new, it is sufficient to wait for the arrival of other necessary data, but if the predetermined time has elapsed from the data reception date and time, the operator recognizes that some trouble has occurred, Take necessary actions in a timely manner.

Next, according to the flowchart of FIG. 12, the procedure of the payment completion confirmation process in the business process suitability confirmation system 12 will be described. First, when the business process suitability confirmation system 12 receives the confirmation target data transmitted from the bank system 30 or the vibration isolation system 32 (S50), the data reception unit 40 stores it in the received data storage unit 42 (S51). . The verification target data transmitted here includes the following (1) and (2). The data receiving unit 40 adds reception date and time information to these two types of data, and stores them in the reception data storage unit 42 in the order of reception.
(1) Deposit / withdrawal completion report data 65 sent from the bank system 30
(2) Entry / exit completion report data 66 sent from the vibration isolation system 32

  When new data is stored in the received data storage unit 42, the data shaping unit 44 is activated, and the verification target data is converted into the standard deposit / withdrawal completion report data 65 'or the entry / exit completion report data 66 in the same manner as described above. After being sequentially converted to '(S52), it is stored in the confirmation object data storage unit 46 (S53).

  On the other hand, when new data is stored in the confirmation target data storage unit 46, the confirmation processing unit 50 is activated to check whether or not a group necessary for the payment completion confirmation process is prepared. That is, the deposit / withdrawal completion report data 65 ′ and the deposit / withdrawal completion report data 66 ′ each include a transaction ID inherited from the order data 60. Therefore, the confirmation processing unit 50 refers to the transaction ID of the new data and determines whether or not the order data 60 ′ and the sale report data 62 ′ having the same transaction ID exist in the confirmation target data storage unit 46. (S54) If these data exist, the group ID of the existing data is assigned to the new data (S55). On the other hand, if there is no order data 60 ′ and trading report data 62 ′ having the same transaction ID, there will be no business process itself that is the premise of deposit / withdrawal or deposit / withdrawal. “NG” is immediately recorded for the second confirmation result item of the data (S56).

  Next, the confirmation processing unit 50 determines whether or not necessary types of data are prepared (S57). In other words, in this scene (settlement completion confirmation process), the appropriate confirmation process is not performed until four types of order data 60 ', trading report data 62', deposit / withdrawal completion report data 65 ', and receipt / withdrawal completion report data 66' are available. Therefore, the confirmation processing unit 50 determines whether or not four types of confirmation target data having the same group ID are arranged in the confirmation target data storage unit 46.

  When the determination result is YES, the confirmation processing unit 50 matches the data item values necessary for confirming the completion of settlement for at least some of the four types of verification target data related to the same group ID. Whether or not the value is appropriate (S59), and the result (OK / NG) is recorded in the second confirmation result item of each confirmation target data (S60, S61). At this time, the confirmation date is also recorded in the second confirmation date item. If the determination result in S57 is NO, the confirmation processing unit 50 records NG in the second confirmation result item of the confirmation target data (S58).

  FIG. 13 is a diagram for explaining the confirmation items in the settlement completion confirmation process. Data items of order data 60 ′, trading report data 62 ′, deposit / withdrawal completion report data 65 ′, and receipt / withdrawal completion report data 66 ′. A part of is described. In this case, the confirmation processing unit 50 executes the following confirmation processing, for example.

(1) Deposit / withdrawal confirmation process “Instructed” is recorded in the deposit / withdrawal item of order data 60 ′ and trading report data 62 ′, and “Done” is recorded in the deposit / withdrawal item of deposit / withdrawal completion report data 65 ′ is being done.
(2) Confirmation process of entry / exit "Instructed" is recorded in the entry / exit item of order data 60 'and trading report data 62', and "Completed" is recorded in the entry / exit item of entry / exit completion report data 66 ' is being done.
(3) Transfer amount confirmation process The total amount calculated from the transfer amount `` 629675 '' in the deposit / withdrawal completion report data 65 'and the transaction volume, contract price, commission, and tax values in the sales report data 62' Match.
(4) Confirmation process of incoming / outgoing quantity The transaction quantity of order data 60 ', sales report data 62', and incoming / outgoing completion report data 66 'must match.
(5) Transaction type confirmation processing The transaction types of order data 60 ', trading report data 62', deposit / withdrawal completion report data 65 ', and receipt / withdrawal completion report data 66' are consistent. That is, if the order data 60 ′ and the sales report data 62 ′ are “purchase”, the deposit / withdrawal completion report data 65 ′ is “withdrawal”, and the deposit / withdrawal completion report data 66 ′ is “receipt”. If the data 60 ′ and the trading report data 62 ′ are “sale”, the deposit / withdrawal completion report data 65 ′ is “payment”, and the deposit / withdrawal completion report data 66 ′ is “issue”.

  As is clear from the above, the confirmation processing unit 50 does not simply check whether or not the values between the specific items of all the confirmation target data match, but also between some data belonging to the same confirmation group. Whether the value of one item and other items are consistent (no conflict), the calculated value of the item in a certain range of certain data matches the value of a specific item of other data Multi-faceted confirmation processing from different viewpoints, such as whether or not there is, can be executed collectively. The above confirmation items are merely examples, and the operator can set various confirmation patterns (confirmation rules) in advance as necessary. When all the above (1) to (5) have been confirmed, the confirmation processing unit 50 records “OK” in the second confirmation result item of each data.

  When “OK” is recorded in the second confirmation result item of the data stored in the confirmation object data storage unit 46, the confirmation result transmission unit 54 is activated and transmits the ledger update data to the ledger management system 18 (S62). ). Receiving this, the ledger management system 18 executes necessary update processing on the amount of funds of the institutional investor and the stock held in the ledger database.

  The operator clicks one after another on the display / selection report 70 shown in FIG. 10 in the order / sales report / receipt / withdrawal completion report / receipt / receipt completion report folder 77, confirmed folder 78, and result: NG folder (not shown). By selecting a folder with an arbitrary date from among the expanded folders by date, it is possible to request a confirmation result NG list screen relating to the confirmation target data having a corresponding reception date.

  Upon receiving this, the display screen generation unit 52 extracts the data in which “NG” is recorded in the second confirmation result item from the confirmation target data storage unit 46, and confirms them by group ID unit and reception date unit. After the result NG list screen is generated, it is transmitted to the operation terminal 20.

  As a result, although not shown, a confirmation result NG list screen is displayed on the display of the operation terminal 20. On this screen, the order data 60 ', sales report data 62', deposit / withdrawal completion report data 65 ', and receipt / withdrawal completion report data 66' in the horizontal one-line format are divided into confirmation groups and displayed in a list in the vertical direction. Are displayed side by side. Each item of the matching result is displayed with the word “NG” and the item that caused it is highlighted, so the operator immediately recognizes the problem and takes the necessary action. It becomes possible.

  The operator can also confirm the confirmation result OK list screen and the standby data list screen on the operation terminal 20 by following the same procedure as described above.

  In the above description, the example in which the business process suitability confirmation system 12 is used for confirmation processing between various data generated in financial transactions has been described. However, the system can be applied to confirmation processing between data accompanying goods transactions. Is of course possible. For example, if the first order data 83, the second order data 84, the inspection data 85, the delivery instruction data 86, and the shipping data 87 described in FIG. 16 are transmitted to the business process suitability confirmation system 12 in a timely manner, the data receiving unit Each data is temporarily stored in the received data storage unit 42 by 40, and then sequentially converted into a standard format by the data shaping unit 44. The first order data 83 ′, the second order data 84 ′, the inspection data 85 ′, It is stored in the confirmation object data storage unit 46 as delivery instruction data 86 ′ and shipping data 87 ′. Then, a confirmation process of the business process is performed on each data by the confirmation processing unit 50, and the determination result is recorded in the confirmation result item of each data.

  FIG. 14 shows the confirmation result NG list screen 79 generated in this case by the display screen generation unit 52. The determination result item “NG” is displayed in the confirmation result item of each data, and the quantity item As a result, the operator will notice at a glance that the delivery instruction data 85 ′ and the shipping data 86 ′ are illegal, and the invoice will be issued without overlooking the inconsistency of the business process. Can be prevented.

  In addition, the confirmation system 12 exhibits its main part in the confirmation processing between three or more types of data, but it goes without saying that the confirmation system 12 can also be applied to the confirmation processing between two types of data.

  Furthermore, instead of grouping each piece of confirmation target data based on the group ID as described above, the confirmation processing unit 50 can also group based on the transaction ID assigned to each piece of confirmation target data. In addition, items for grouping each data are not limited to a single key item such as a transaction ID, but a plurality of types of data to be grouped are recognized by combining a plurality of data items. You may comprise as follows.

1 is an overall configuration diagram of a trust bank system including a business process suitability confirmation system according to the present invention. FIG. It is a block diagram which shows the function structure of the suitability confirmation system of a business process. It is a figure which shows the flow of various data centering on the order completion confirmation process in the suitability confirmation system of a business process. It is a figure which shows the flow of various data centering on the payment completion confirmation process in the suitability confirmation system of a business process. It is a flowchart which shows the procedure of an order completion confirmation process. It is a figure which shows the confirmation object data converted into the standard format. It is a flowchart which shows the process sequence which concerns on the result display of a confirmation process. It is a flowchart which shows the process sequence which concerns on the result display of a confirmation process. It is a flowchart which shows the process sequence which concerns on the result display of a confirmation process. It is a figure which shows a display target selection screen. It is a figure which shows an example of a confirmation result NG list screen. It is a flowchart which shows the procedure of a payment completion confirmation process. It is a figure for demonstrating the confirmation matter in a payment completion confirmation process. It is a figure which shows an example of a confirmation result NG list screen at the time of applying the suitability confirmation system of a business process to the confirmation process between the data accompanying incidental goods transaction. It is a schematic diagram which shows an example of the data which generate | occur | produces accompanying the sales transaction of goods. It is a figure explaining the problem of the conventional data collation. It is a conceptual diagram which shows the example which performs the conventional data collation in multiple steps. It is a schematic diagram which shows the example which applied the conventional data collation to the transaction of financial products.

Explanation of symbols

10 Trust bank system
12 Business process suitability confirmation system
18 Ledger management system
20 Operation terminal
22 Communication network
24 Institutional Investor System
26 Securities company system
28 Communication network
30 Banking system
32 Vibration isolation system
40 Data receiver
42 Receive data storage
44 Data shaping section
46 Confirmation target data storage
50 Confirmation processing section
52 Display screen generator
54 Confirmation result transmitter
60 Order data
60 'standard formatted order data
61 Contract communication data
61 'Standard formatted contract communication data
62 Trading report data
62 'Standard formatted trading report data
65 Deposit / withdrawal completion report data
65 'Standardized deposit / withdrawal completion report data
66 Entry / exit completion report data
66 'Entry / exit completion report data in standard format
70 Display target selection screen
74 Confirmation result NG list screen
79 Confirmation result NG list screen
83 '1st order data in standard format
84 '2nd order data in standard format
85 'standard formatted acceptance data
86 'Standardized delivery instruction data
87 'Standard formatted shipping data

Claims (3)

A business process suitability confirmation system that enables confirmation of compatibility between three or more types of data generated by the progress of a business process and display of confirmation results,
Means for converting various received data to be confirmed into a standard format and storing them in a common confirmation object data storage means;
Based on the value of the specific data item of the confirmation target data, is there any other type of confirmation target data that is necessary for confirming the suitability of the business process in the confirmation target data storage means? A means of confirming whether or not,
A means for comparing the values of predetermined data items among predetermined types of data when necessary check target data is prepared, and confirming the suitability;
Screen generating means for generating a screen for displaying the confirmation result on the display,
This screen generation means is a list screen in which data in a horizontal line format including at least the type of each check target data and the check result are arranged in a vertical direction in groups each of which is a collection of a plurality of types of mutually related data. A business process suitability confirmation system characterized by generating   The above screen generation means has received only a part of the required type of confirmation target data, and when all of the necessary confirmation target data is not complete, at least the type of each confirmation target data received. 2. The business process suitability confirmation system according to claim 1, wherein a list screen in which data in a horizontal line format including reception date and time is arranged in a vertical direction is generated. A business process suitability confirmation program that enables confirmation of compatibility between three or more types of data generated by the progress of a business process and the display of the confirmation results.
Means for converting various received data to be confirmed into a standard format and storing them in a common confirmation object data storage means;
Based on the value of the specific data item of the confirmation target data, is there any other type of confirmation target data that is necessary for confirming the suitability of the business process in the confirmation target data storage means? A means of confirming whether or not
Means for comparing the values of predetermined data items among predetermined types of data among the necessary data to be confirmed, and confirming their suitability;
Function as screen generation means for generating a screen for displaying the confirmation result on the display,
A list screen in which the screen generation means arranges data in a horizontal one-line format including at least the type of each check target data and the check result in a group unit that is a collection of a plurality of types of mutually related data. Business process suitability confirmation program characterized by having a function to generate

Images