CN1669038A

CN1669038A - Transaction management system

Info

Publication number: CN1669038A
Application number: CN 03816859
Authority: CN
Inventors: J·M·维尔; M·普莱尔; T·安托恩; N·H·吴; T·维宁; A·布迪哈乔
Original assignee: Colonial First State Investments Ltd
Current assignee: Colonial First State Investments Ltd
Priority date: 2002-05-17
Filing date: 2003-05-19
Publication date: 2005-09-14
Also published as: WO2003098494A1

Abstract

The invention relates to a computer-based method of and system for matching a set of transaction instructions received from a submitting entity with a record data set of a receiving entity. The record data set includes a plurality of account records and an associated match key data set comprising a plurality of match keys, wherein each match key identifies an associated account record. The method comprises searching the match key data set using a match key derived from a received funds transfer instruction to identify an account record in said record data set thereby automatically matching said instruction to said identified record. The submitting entity selects a particular unmatched record of said data set, thereby manually matching said instruction to said selected record. Updating of the match key data set with the derived match keys of manually matched records enables later instructions providing substantially identical match keys to be automatically matched to their associated records in the account record data set.

Description

Trade managing system

Copyright statement/permission

This patent file comprises material protected by copyright.In case it appears in the disclosed Patent Office record, then the copyright holder does not oppose by anyone copy patent file, but the copyright holder still keeps all copyrights.Following statement is applicable to following illustrated and illustrated software and data: copyright 2002,2003, Colonial First State Invest Lt, all rights reserved.

Invention field

The present invention relates to the system and method for managing transaction, a specific use of described system and method is to help a plurality of investor accounts are distributed in a plurality of fund transaction.Furthermore, the present invention relates to check two may wrong coupling data sets so that can conclude the business at second data set exactly from the instruction that obtains of deriving of first data set.Preferred embodiment of the present invention relates to the pension contribution payment of management from employer to the account who is managed by the fund manager.

Background of invention

A subject matter relevant with management pension and similar fund is need regularly constantly accurately change from investor's relatively little contribution in a large number to advance corresponding great amount of investment person account.Common in-house official as the wage clerical staff, provides the details that single is paid and how this payment divides to the pension fund keeper in this tissue employee's individual pension account.Owing to, can have a large amount of mistake couplings usually to individual investor and the frequent change of their account details.The pension fund keeper accepts to solve the heavy legal liabilities of these things usually by convention, and this is as breaching one of cost relevant with total benefit of fund manager.

In some cases, the pension fund keeper enables electronic service and assists them to submit the contribution file to.Some electronic service allows the contribution file to comprise the detailed transaction instruction that sends with Email with specified format simply.And other begin to develop the complicated more system based on the internet, and they provide by employer and are used to set up contribution data strip purpose " Web list ".Usually, can use the third party to use, they can not be closely integrated with the kernal computer system of supporting the pension fund management as a result.The existing realization of these systems also makes mistakes easily, as investor's repetition with by exception report and the manual mistake of handling that solves.Though these are the improvement to manual off-line method, in case file through accepting, the pension keeper finally will bear the responsibility that addresses these problems.

In addition, the mode self of carrying out collation process may trend towards being checked data integrity is had a negative impact.

Brief summary of the invention

According to a first aspect of the invention, the computer-based method of the one group of instruction that provides that coupling receives from sending entity and the log data set of receiving entity, described log data set comprises a plurality of records and relevant match keywords data set, described match keywords data set comprises a plurality of match keywords, wherein each match keywords all identifies relevant account record, and described method comprises step:

Search for described match keywords data set from the instruction that the receives use match keywords that obtains of deriving,, thereby automatically mate the record of described instruction and described sign with identification record in described log data set;

To at least one not instruction of coupling automatically, support described submission entity to concentrate and select a plurality of records, thereby manually mate the record of described instruction and described selection at described record data;

Use is upgraded the match keywords data set from the instruction of the manual coupling described match keywords that obtains of deriving, to help in the back the instruction that coupling automatically receives and the record of selection.

Preferably, upgrade the match keywords data set and make the back provide that the instruction and the record data of identical match key word are concentrated relative record coupling in essence with the derive match keywords that obtains of manual matched record.

Easily, to the instruction of coupling automatically of those warps, support can be made the step of manual coupling by the contribution entity, allows the manual coupling of back to take place so that those that the contribution entity can cover or wrong coupling is mated automatically mate.

Advantageously, described method comprises that being independent of other concentrated records of record data upgrades match keywords data sets, so that record data concentrate any data field except that the match keywords field to keep not changing in essence.

Described method can comprise and be independent of any other record that the match keywords data set upgrades log data set, do not influence the record that receives later and the automatic coupling of described record so that upgrade log data set.

Usually, match keywords that will be relevant with record is as the field store of representative record, so that the match keywords data set comprises the match keywords field of data set record, and upgrade the match keywords data set by the copy of the described match keywords that obtains of deriving of storage in the described match keywords field of described manual matched record.

Described method preferably comprises the match keywords of using the predetermined match keywords rule relevant with the special instruction collection to create the special instruction collection, thereby the data elements fields of being scheduled in the combined command obtains the step of this match keywords.

Usually handle a plurality of instruction set, each instruction set all comprises relevant match keywords rule, data elements fields in the instruction that the appointment of described match keywords rule will merge, described method comprise that match keywords rule each in instruction set of using this instruction set derived in instructing and obtain match keywords.

Easily, when introducing or revising the match keywords rule of special instruction collection, the match keywords rule is written as the new regulation of corresponding match keywords data set, and produces new match keywords collection and constitute new match keywords data set.

Described method comprises by writing the match keywords data set from the instruction that the receives match keywords that obtains of deriving, creates to the step of small part match keywords in the match keywords data centralization.

Advantageously, described method is included in the user interface generation and to submitting to entity to present the command status details, comprises coupling and unmatched list of instructions, to support submitting to the remote manual of entity sign on to mate.

Preferably, described method is included in to support during the manual matching treatment all records are moved to from " not matching " classification and finishes the classification, the described classification of finishing comprises coupling and classification that ignore, and prevent to accept instruction set to be further processed, all from " not matching " classification, remove up to all records.

Described method can comprise the error in data in the sign instruction set and automatically remove the step that there is the instruction of error in data in those from the instruction that will mate.

Usually, the match keywords data set further comprises a plurality of match keywords correlation rules, relation between the match keywords that independent described match keywords correlation rule definition is derived the match keywords that obtains and is associated with record from instruction is wherein upgraded the match keywords data set by the correlation rule between the described match keywords of storing described the derive match keywords that obtains and the described record that is associated with coupling.

Easily, described method comprises that the described submission entity of prompting provides search criteria, automatically fixed one or more records of the criterion that provides by described submission entity with true coupling of the described data set of search, and point out described submission entity from described definite record, to select record.

When instruction coupling during by the record of described submission entity selection, described method may further comprise the related of data set record from described match keywords data centralization deletion described derive match keywords that obtains and the record that removes selection.

Instruction set can be submitted to according to the format character of special submission entity, described method comprises, derive obtain match keywords before, instruction set is converted to and the form that meets by the log data set compatibility of the mapping ruler collection of the feature formal definition of submitting entity to.

Described mapping ruler is variable, to respond the format change of submitting to entity to make.

The form of instruction set can be to make the payment instruction of many payments, and described log data set is for regularly collecting to the account who wherein makes payment.

In a kind of form of the present invention, described method comprises with respect to calculating difference for account's the polymerization of coupling in real time based on available fund, and allows to make the payment of described difference.

The present invention further provides coupling from first trading instruction data set of submission entity reception and the method for second data set on receiving entity, described trading instruction data set comprises a plurality of trading instructions, described second data set comprises a plurality of records and relevant match keywords data set, and described method comprises step:

-deriving from the trading instruction of described correspondence obtains a plurality of match keywords;

-use the described match keywords that obtains described second data set of search automatically of deriving, with in described second data centralised identity corresponding record, thereby mate the instruction and the described record of described selection;

-not to the instruction that receives automatically during the record of identification, the record of supporting the described data centralization of described submission entity selection is with the described instruction of manual coupling; And

-those are manually carried out trading instruction with the record that mates automatically.

Easily, be used to upgrade the match keywords data set, so that the back provides the relative record of the automatic matched record data centralization of instruction of identical in essence match keywords from the instruction of the manual coupling match keywords that obtains of deriving.

The present invention includes the computer-readable media that comprises program code, described program code is used to control the programmable processor that at least one carries out above-mentioned any method.

According to another aspect of the present invention, provide the instruction set of coupling from submitting entity to and receiving and the system of the log data set of receiving entity, described log data set comprises a plurality of records, and described system comprises:

-comprise the match keywords data set of a plurality of match keywords, each match keywords relevant record of identification record data centralization all wherein;

-match keywords the deriving method of deriving and obtaining match keywords from instruction;

-use the described match keywords that obtains of deriving to search for described data set, with identification record in described log data set, thereby mate the search engine of the record of described instruction and described sign automatically;

-be used to support described submission entity selection instruction and manually mate it and the system of selection of the record of selecting; And

-use from the instruction of the manual coupling match keywords that obtains the update method of deriving with the record that helps automatic matching instruction in back and record data and concentrate.

Preferably, described system of selection comprise support to cover or wrong coupling automatically those of coupling mate the method for the manual coupling generation that allows the back.

Easily, described update method comprises with the manual record of the coupling match keywords that obtains of deriving upgrades the match keywords data set, so that the instruction that the back the provides identical in essence match keywords relative record of matched record data centralization automatically.

Advantageously, described update method comprises that being independent of other concentrated records of record data upgrades match keywords data sets, so that any data field of log data set except that the match keywords field all keeps the method that do not change in essence, and be independent of any other record that match keywords data set renewal record data are concentrated, so that the renewal of log data set does not influence the instruction of automatic coupling reception and the method for described record.

Described system can comprise and being used for the field store of the match keywords relevant with record as respective record, so that the match keywords data set comprises the storer of the match keywords field of data set record, and be stored in by copy in the described match keywords field of record of described manual coupling and upgrade the match keywords data set the described match keywords that obtains of deriving.

Preferably provide disposal route to be used to handle a plurality of instruction set, and provide storage means to be used to store each instruction set and relevant match keywords rule, described match keywords rule is specified the data elements fields in the instruction that will merge to this instruction set.

Easily, described system comprises that match keywords regular record method is used for when the match keywords rule is introduced or revised to the special instruction collection match keywords rule being written as the new regulation of corresponding match keywords data set, and is used to produce the match keywords production method that new match keywords collection constitutes new match keywords data set.

Described system can comprise by writing the method to the small part match keywords that the match keywords data set is created the match keywords data centralization from the instruction that the receives match keywords that obtains of deriving.

Described system of selection can be included in that user interface produces and to submitting to entity to present the command status details, comprises coupling and unmatched list of instructions, with the method for the remote manual coupling of supporting to submit to the entity sign on.

Described system of selection can comprise that support moves to the method for finishing the classification with all records from " not matching " classification, the described classification of finishing comprises coupling and classification that ignore, and prevent to accept instruction set to be further processed, write down the method that all from " not matching " classification, has removed up to all.

Described search engine can comprise that the described submission entity of prompting provides the method for search criteria, automatically the method for fixed one or more records of the criterion that provided by described submission entity with true coupling of the described data set of search, and the described submission entity of prompting is selected the method that writes down from described definite record.

Can be provided for supporting the related method of the data set record from described match keywords data centralization deletion described derive match keywords that obtains and the record that removes manually selection.

Easily, described system comprises that the instruction set that is used for having the format character of special submission entity is converted to the data transformation engine with the form of the log data set compatibility that meets the mapping ruler collection of being determined by the form of submitting entity to.

Can comprise and be used to change mapping ruler is submitted the format change that entity makes to response method.

Easily, the form of instruction set is to make the payment instruction of many payments, and described log data set is for regularly collecting to the account who wherein makes payment.

Described system can comprise with respect to calculating difference for account's the polymerization of coupling in real time based on available fund, and allows to make the method for the payment of described difference.

According to a further aspect of the invention, be provided for mating the system of the log data set of the instruction set that receives from long-range submission entity and receiving entity, described log data set comprises a plurality of records, and described system comprises:

The described log data set of-storage and comprise the method for the record match keywords data set of a plurality of match keywords, wherein each match keywords relevant record of identification record data centralization all;

-deriving from instruction obtains instructing the match keywords deriving method of match keywords;

-use the described match keywords that obtains of deriving to search for described match keywords data set, concentrate record to be identified at described match keywords record data, and mate the search engine of the record of described instruction and described sign automatically;

-to the server method of submission entity output interactive user interface, described interactive user interface is supported described submission entity selection instruction and the record that manually mates it and select, described interactive user interface comprises the command status details; And

-use from the manual matching instruction match keywords that obtains the update method of deriving with the record that helps automatic matching instruction in back and record data and concentrate.

The present invention further provides the system of the log data set of instruction set that coupling receives from long-range submission entity and receiving entity, described log data set comprises a plurality of records, and described system comprises:

The record management system of the described data set of-management, described record management system comprises the record storage method that is used to store described record, and the relevant record match keywords data set that comprises a plurality of match keywords, the wherein relative recording of each match keywords identification record data centralization;

-use the described match keywords that obtains of deriving to search for described match keywords data set, with the record and the automatic search engine that mates the record of described instruction and described sign of marking matched keyword record data centralization;

-to the server method of submission entity output interactive user interface, described interactive user interface is supported described submission entity selection instruction and the record that manually mates it and select, described interactive user interface comprises the command status details.

Described system can be the interfund transfer system, and the form of described instruction set is interfund transfer instruction, and described record management system comprises fund administration system, and described system comprises and is used for managing with the interfund transfer protocol gateway of interfund transfer to fund administration system.

The interfund transfer system can comprise the data transformation engine that is used to change the data stream between long-range submission entity and the fund administration system, thereby long-range submission entity can the instruction of executed in real time interfund transfer.

The form of described system can be the product order system, wherein the relation between instruction set and the log data set can for one to one, one-to-many and/or many-to-many relationship.

In whole instructions, unless the needs of context or representation language or necessary implication use word " to comprise " according to the meaning of " comprising ", that is, and illustrated characteristic can with the further association of characteristics in the various embodiments of the invention.

Description of drawings

Fig. 1 is a schematic block diagram, shows the system that realizes fund coupling of the present invention and funds transfer system;

Fig. 2 is a schematic block diagram, shows fund coupling of the present invention and funds transfer system;

Fig. 3 a is a process flow diagram, shows automatic account's matching treatment;

Fig. 3 b is a process flow diagram, shows manual account's matching treatment;

Fig. 4 is the part of screen display, shows that typical file uploads the result;

Fig. 5 is a schematic block diagram, shows that the account clears processing;

Fig. 6 shows the exemplary screen layout of summarizing online contribution file;

Fig. 7 shows and the similar screen layout of Fig. 5, and has added new verification file;

Fig. 8 is a screen layout, shows and uploads the included step of contribution file;

Fig. 9 is the exemplary screen layout during affirmation is handled, and shows two records that comprise error in data;

The exemplary screen layout of Figure 10 for confirming to handle showed some unmatched files;

The exemplary screen layout of Figure 11 for confirming to handle is made at the trial that does not match and mate between record and the existing account therein;

Figure 12 is a further step in the matching treatment, shows the result of account's coupling that search is possible;

Figure 13 is for confirming the exemplary screen layout of first step of the record of all couplings of support affirmation in the processing;

Figure 14 is the exemplary screen layout, shows the further step of handling the record of ignoring in confirming to handle;

Figure 15 is for confirming the exemplary screen layout of affirmation step last in the processing;

Figure 16 a to 16c goes on foot the exemplary screen layout of payment processes for using three of direct debit instrument;

Figure 17 provides the exemplary screen layout of authority to pay for guides user;

Figure 18 a and 18b are screen layout, show match keywords renewal processing;

Figure 19 is illustrated in the sample screenshotss of the subrecord structure of using in the file conversion processing;

Figure 20 is illustrated in the sample screenshotss that connect source record and target record in the file conversion processing;

Figure 21 shows the internuncial high level view of DCM gateway;

Figure 22 shows sample file structure and the framework of first message sink in the stage;

Figure 23 shows sample file structure and the framework in second stage that is mapped as inner SuperEC;

Figure 24 shows sample file structure and the framework of the 3rd message sink in the stage;

Figure 25 shows sample file structure and the framework in the 4th output and the FMS response phase;

Figure 26 shows the sample frame of FTP gateway;

Figure 27 shows the message flow of DMC to main frame;

Figure 28 shows the message flow from the main frame to DMC;

Figure 29 shows the sample frame arrangement;

Figure 30 shows the transaction log in the automatic matching treatment original state before;

Figure 31 shows to derive from instruction and obtains transaction log after the match keywords;

Figure 32 show instruction mated FMS account after transaction log;

Figure 33 shows the state with the record of the wrong coupling of FMS account;

Figure 34 shows that this record that is recorded in of Figure 34 mates state afterwards with other FMS records;

The state of the account of Figure 35 display record and coupling after confirming instruction; And

Figure 36 shows the state of the mistake coupling account with sky match keywords field.

The detailed description of embodiment

Now to the processing among the investor account preferred embodiment of the present invention is described with respect to the pension contribution.In company, requiring employer usually is that the employee makes payment, for example, and pension contribution, insurance payment or the like.This need pay to a plurality of employee accounts, and this comprises by submission by the wage clerical staff of contribution entity or through payment office usually and formulates trading instruction by the transaction file of a plurality of trading instructions of system handles and carry out in the present invention.

The total method of the present invention is that the user in the hypothesis contribution entity is responsible for and has the right to solve any transaction issues the contribution file is finally accepted to be assigned to the contribution amount of money with appointment among the investor account of appointment by the fund administration system of receiving entity before.

Be accepted and be used for final handle and dispensing transaction is instructed before investor account's the affirmation submitting to entity to receive file, will comprise the transaction file of the instruction that can not check by system database,, turned back to the submission entity preferably in real time.

Wherein trading instruction can not be comprised that the contribution data have specified the investor of system's the unknown or specified incorrect contribution type by the example that system database is checked.

At first, schematically showed system architecture 10, can realize preferred embodiment of the present invention thereon with reference to figure 1.System 10 comprises two primary clusterings, i.e. fund administration system (FMS) 11 and file management gateway (FMG) 12.FMG 12 comprises application server 13, data transformation engine (DTE) 14 and interfund transfer agreement (FTP) gateway 15.Application server 13 uses known Internet protocol to provide front-end interface by telecommunications link 17 to user terminal 16.FTP gateway 15 provides the back end communication with FMS11.DTE 14 conversions are from the data of user or FMS reception, and processing is arrived for example FMS or user's data communication through system.DTE uses the information as subscription list, tracked information and associated component, and they are stored in the database 18 that is connected to DTE.FTP gateway 15 also is connected to database 18.

Use in management and supervision account's context at this used term fund administration system and fund supervisory systems, that is, be different from management cash and the investment of this cash on commodity.

In use, application server 13 output customer interfaces for example, use Active Server Page (ASP) in the known manner to remote terminal 16.The user of access system can send the transaction data file of the trading instruction that comprises a plurality of investors, and its further details will be elucidated later herein below.Transaction file can be by the user with a kind of submission the in the multiple form.Usually, reach the agreement of relevant form, and described form is stored in the database 18 as the part and the user of initialization or register flow path.This can change under the requirement of contribution entity every now and then.

FMG 12 receives the general transaction file by application server 13, and application server 13 passes to DTE 14 with it, and DTE 14 converts them to the FMS flat file format that is used for being undertaken by FTP gateway and FMS internal communication.On the contrary, the message that the response of FMS program is called in the conduct that receives from FMS is converted into the form that can present to the user, and is transferred to the user by application server 13.

Flow process Figure 20 that the functional block diagram display systems of Fig. 2 connected system assembly is handled.In broad terms, with the user, as the wage clerical staff, the wage file 21 of establishment, in step 200 as New Transaction data file 23 from user terminal uploads to FMG 12.Working document is normally created as the output of employer/paying centre wage or HR management software, and these softwares may comprise any known wage or HR software package.Original transaction data file 23 is handled according to the Storage Mapping rule that is stored in the database 18 by FMG 12.The copy of the source document of gateway 12 storing initials input is used for reference in the future and audit objective.File is converted to standard format STD and is sent to FMS 11 by FMG 12, and wherein recording instruction in trading instruction registration form 24 is carried out two step matching treatment to instruction afterwards.First step is automatic checking procedure 210, wherein makes investor account 25 with FMS 11 by system and checks trial from the instruction of transaction file.Second step 220 is manual handle, wherein submits to the user of contribution wage file to select to mate the investor account of unmatched those records after handling automatically.The user comprises with ASP by the client interface 25A on the remote terminal and lists contribution and FMS record 25B and 25C to help manually coupling and to show that the state of matching treatment progress status shows that 25D carries out such processing.

In case solved all records that do not match, the user confirms file 230, then by carry out the trading instruction of coupling to individual investor account 25 interfund transfer 240 transaction from the clearing account 26 of FMS.System also considers payment step 250, and wherein the user can propose the bank account 27 of contribution entity, from wherein providing fund to pay to satisfy contribution to clearing account 26 by suitable e-commerce engine 28.

Handle in order to begin this, visit system through the session that swap server begins to enliven the user of contribution entity.Application server provides to user interface.By interface, the user is submitted to application server to transaction file in the known manner, and application server is transferred to FMG 12 with this document.Usually, original transaction file can comprise the contribution data of sign contribution entity, that is, and and employer or paying centre and user, and a plurality of trading instructions.Investor and one or more contribution details in this investor account are all specified in each trading instruction.Typical instruction field comprises:

● investor's details:

-symbolization of accounts

-pay sheet numbering

-surname

-name

-the date of birth

● the contribution details:

-pension guarantees (SG) contribution

-employer adds contribution

-wage sacrifice (SS) contribution

The voluntary contribution of-investor

-spouse contribution

File management gateway 12 receives the source document of the input that is sent by the user, stores it to be used for reference in the future and audit objective.18 storages of FMG database and other guide are specified the plan mapping ruler of the file layout of contribution entity expectation together.When the contribution entity is registered system, reach an agreement with regard to file layout at contribution entity and system, and described form is stored in the database 18.

Basic hypothesis is that certain combination of investor's details of providing in transaction file can be used to set up unique account identifier, to use when match trading instruction and the investor account.

The source document of input is at first handled by file management gateway 12, with according to user login name sign contribution entity, determines that then whether this document is the form of the predetermined expectation of contribution entity.Further test determines whether this contribution entity has any other pending file to carry out record in system, that is, and and the file of full confirmation or refusal not as yet.The failure of any of these test all will cause refusing transaction file, and provide error messages to the user of contribution entity.

If begin to have accepted source document, the mapping ruler of retrieving files form from database then, and be applied to this document, be used for the internal communication of system with the flat file format that this document is converted to standard.

Preferably original transaction data file uses the engagement and connector means file transmitting function to upload to file management gateway 12 by the user.Yet, system also comprise to the user provide online list with direct input trading instruction to system interface.

In case transaction file has received and be converted to the internal format of standard, just can check file data and the system data that is stored among the FMS 11.The purpose of collation process is the trading instruction and the existing FMS investor account of each input of coupling, with this instruction storage in the pending file that payment is checked, and submit to contribution to confirm numbering (CCN) to the contribution entity.Therefore, when this document is still waiting when pending, the contribution entity does not receive and accepts the affirmation that transaction data is used to handle fully.

This is handled also data check is carried out in trading instruction.When instruction comprises in the transaction processing recognition data mistake, will this record of refusal and make mistakes and wrong type to which instruction of user notification.The contribution entity can be corrected this mistake in off-line ground (promptly outside active session) then, and will instruct the part as the new data file to resubmit.First stage in the collation process is to derive from each instruction of transaction file to obtain being used as the match keywords of FMS account query instrument.Match keywords is derived from two or more record fields and is obtained.Basic hypothesis is the data that trading instruction comprises enough provides unique member's sign.The rule that obtains match keywords of deriving is set up during for the first time to system registry at the contribution entity, and usually specific to this paying centre/employer.The part of location registration process is an analyzing samples employer pension transaction file, and to the suitable account identifier rule of this employer (paying centre) exploitation.Investor account among the account identifier unique identification FMS, and can for, for example, the combination of following data element: symbolization of accounts (A), pay sheet numbering (P), paying centre ID (C), surname (S), name (F), date of birth (D).

The single letter code of each field is used for the field of match keywords rule definition for maximum ten characters of the suitable data element combination of expression.So match keywords rule

SDP

Show from surname: the date of birth: the pay sheet numbering is derived and is obtained match keywords.

In illustrated embodiments, employer's wage system has the capacity of storage employee FMS symbolization of accounts, therefore symbolization of accounts can be comprised as the part of transaction file and in the match keywords middle use of deriving.If this is impossible, then to system registry the time, analyze employer's file system, to determine optimal match keywords rule.Following described in the instructions, can make amendment to the match keywords rule at any time.

Refer now to Fig. 3 A, having showed derives obtains the processing of match keywords.From raw data file, extract sample trading instruction or contribution record 32.Presumptive instruction form 34 comprises instruction identifier file 34A to 34C, and they comprise investor's details, and contribution file 34D to 34G, and they comprise fund contribution details ($258, $40, $0 and $0).Presumptive instruction form 34 is converted to FMS stereotyped command form 36 by the file system gateway.From for example obtaining paying centre account identifier rule the DCM database, and use it for the match keywords 38 of deriving.In an example shown, the match keywords rule can be " SD ", and can produce match keywords or the account identifier 39 of deriving.Use the account identifier search FMS account that derives then, whether exist to determine the account 39A that mates the account identifier of deriving.Should be understood that the contribution details often changes easily, can not be as creating the match keywords purpose.

All instructions of extracting from transaction file are repeated this processing.Be stored in to the command assignment that can mate the account among the FMS " coupling " state and with it and be used for back payment as described below in pending file and check.Provide " not matching " state to unmatched instruction.Provide and be equivalent to " mistake " state of ignoring state to comprising the instruction that FMS is searched for indeterminable error in data, and must resubmit by the contribution entity.

User report command status to the contribution entity.Preferably, mechanical check handle occur in wherein provide the active session of transaction file by the user during, so that this user can obtain the approximate indication immediately whether data file comprises any data that can not check, particularly can not be by any instruction of system handles, so that do not stay the impression that all instructions in the file all will obtain handling to the user.Provide report with the online interaction form to the user, as shown in Figure 4.Screen interface layout 40 comprises three major parts.Above part 41 quantity 42 that still needs the unmatched instruction that solves is described in detail in detail.Center section 43 describes the quantity of the instruction of finishing in detail, comprises the quantity 45 of the quantity 44 of the instruction of coupling, the instruction ignored and comprises the instruction number 46 of error in data.Part 47 below the screen layout 40 comprises payment details, the available fund 49 of dealing with total charge 48, determining by the clearing account of poll FMS that comprises that the contribution field of the instruction by coupling calculates, and deal with difference 495 as what the difference between amount payable and the available fund was calculated.

At first, after automatically matching feature is finished, all instructions will show at the place in three places, described three places promptly, " not matching ", " coupling " or " error in data ".The digital summation in these three places equals total number of files.Instruction with error in data can not be got rid of them by user search and from transaction file.

In case mechanical check is finished dealing with and reported to the user, user's target is exactly from " will solve " part 41 moving recordings classification to middle " finishing " part 43 that do not match.Do not accept transaction file, all from " not matching " classification, remove up to all records.In this way, the user distributes fund can not obscure to investor account's instruction.Do not provide contribution to confirm numbering (CCN) in this stage,, accept the affirmation that entity does not obtain the transaction file instruction yet, therefore do not bear the responsibility of distributing contribution to pay investor account even so that this active session has stopped to the user.Manually collation process can be carried out in a few subsystem access sessions by the user, therefore allows the user to check unmatched data in the system of contribution entity.

In the above-described embodiments, the instruction of coupling is imported in " coupling " part 44 of finishing part 43 of screen interface 40 automatically.(not shown) in another embodiment, superincumbent part is showed the instruction of automatic coupling to the user, and requires the user to confirm coupling automatically before those instructions being moved to " coupling " part 44 of finishing part 43.

The user of contribution entity can select unmatched instruction to come matching instruction and existing account, establishment new account to mate unmatched instruction, or ignore instruction.If the user is mated unmatched instruction, then its finishes part as matching present centre, and the counting of coupling increases by one and the counting that do not match reduces one.Similarly, if the user selects to ignore unmatched instruction, then these instructions appear at and ignore classification, and suitably upgrade " ignoring " and " not matching " counting.To illustrate in greater detail below, unmatched instruction manually be mated, ignored or create the interface of new account.

In Fig. 3 B, showing derives obtains the processing of match keywords, and initial mispairing and manual coupling have wherein taken place.Sample trading instruction or contribution record 32A are identical with one of front, except surname is changed to DeMoon.The match keywords 38A that uses SD match keywords rule to produce produces match keywords or the account identifier of deriving " DeMoon24101972 ", shown in Figure 39 B.Correspondingly, the mistake of existence and account 39A coupling, wherein account's match keywords 39 remains DeJong24101972.Manually coupling this account and match keywords 39B, and this causes initial matching key word 39 to be covered by the match keywords at 39C, and it is equal to match keywords 39B.As a result, comprise any file of the record with match keywords 39B to what submit to later, in the future and the FMS account 39A with match keywords 39C of modification mating automatically.

If other data among the FMS account 39A change, this will be to not influence of matching treatment so.For example, if the surname details among this account changes, then match keywords still keeps identical, and because identical match keywords 39B and 39C, contribution record 32A will mate automatically with account 39A.

When unmatched instruction count is kept to zero, then the final steps request user of matching treatment confirms the coupling that all are made between contribution record and FMS account.During confirming step, the user can check the contribution instruction of all couplings, comprises the instruction of automatic coupling and the instruction of ignoring.What implied in contribution is handled is to cancel profit as the ability that does not match, any instruction of having made /FMS mates.In case made whole affirmations, then submitted affirmation contribution numbering to the user after, the user learns can be by the trading instruction of system handles coupling, thereby can stop this active session safely.

Provide " affirmation " state to the transaction file of confirming, with the collation process of paying, this processing does not need to carry out in active session fully.The payment collation process is responsible for accepting the contribution payment, is checked them with the transaction file of affirmation, and being checked trading instruction is delivered to transaction processing among the FMS.

In preferred embodiment, as shown in Figure 5, the payment collation process is used the concept nature clearing account of setting up 26 in FMS 11, and this account mirror image also is connected to the physical application account who is kept in the financial institution 27.Can use by independent " account " in the single application account of employer or paying centre ID sign and divide application account.This allows single application account to be used for all registered users of system.To having the big employer of a plurality of paying centres, employer has a clearing account usually in each paying centre.

The contribution entity can use known payment processes 52 to provide fund to clearing account, as BPay, DirectDebit or Direct Credit since they to be electronic processing therefore first-selected they, or also can use more traditional processing, deposit as check.

In the time of plan, the payment total charge of the transaction file that the payment collation process is accepted confirmation and all contributions of checking the instruction of mating in the file.Check the relevant clearing account among the FMS then, guaranteeing that the paying centre has enough clearing funds and satisfies payment, and if only if during this need satisfaction, transaction file just terminates.Transaction file transfers to the FMS transaction processing, then finishes dealing with, and the single amount of money of FMS transaction processing by appointment in will instructing is assigned to designated account and carries out trading instruction.

The file of check confirming every day leaves in the clearing account to determine whether enough funds, and the file of confirming as 28 days, changes into disarmed state after one period, and must be retransmitted by the contribution entity and send and handle.The system prompt contribution entity of being set up, as, arrive the user by the email message that sends automatic generation, to provide to the transaction file fund of confirming, wherein file waited the pending a period of time that reaches, as 10 days and 20 days.

The unallocated always fund that reaches a period of time as 28 days, can turn back to the account of appointed bank of employer or paying centre.

To the foregoing description, system does not need the contribution entity to have enough clearing funds in corresponding clearing account when confirming the contribution file.In a further embodiment, system can specify the fund of finishing the contribution payment can use when carrying out active session, so that can confirm all details that contribution is handled in active session.In such embodiments, interface can be provided in and points out the user that the payment system of payment information is provided when confirming the contribution file.

In a further embodiment, payment can be made as the part that file is submitted to and affirmation is handled.In this embodiment, interface will comprise to user prompt input account information or original affirmation historical information to this contribution entity stores.This embodiment can use the e-commerce engine of any one existing help online transaction.In case the user has confirmed account details, e-commerce engine can be before submit to confirm receiving numbering be cleared account fund from specifying contribution entity account to transfer accounts to system.

Refer now to Fig. 6, the sample screen layout of the interface that provides to the user when the user creates active session for the first time has been provided.Screen 60 provides the transaction file storehouse 61 of the transaction file of being submitted to by the contribution entity.The file by file ID #62, submission date 63, submission time 64, state 65 and required action 66 signs is listed in this storehouse.As shown in Figure 6, top file is to submit to recently, it have " by " state, that is, confirm but wait for fund.The user can select action link to come the viewing files details.

Second sample contribution storehouse 70 showed in Fig. 7.In this example, top file 71 is to have received and carried out automatic matching treatment and therefore " verification ", shown in mode field 75, but wait acknowledge and unmatched instruction mated presenting a paper shown in action field 76 still.The user can continue to confirm this document by selecting the action field chain to fetch." verification " file occurs will preventing the further upload file of contribution entity in system, is identified or refuses up to " verification " file.This helps prevent identical instruction set to be performed twice.

In Fig. 8, showed the screen layout 80 that transaction file is uploaded in help.Screen 80 comprises navigation button 81, when choosing it, allows user browser document system in the known manner on user interface.The user uses submit button 82 to submit the file of choosing to.

Fig. 9 is illustrated in the sample screen layout of using in the record collation process 90.This screen shows after the error in data of initial reception transaction file and verification this document.The instruction that comprises error in data is showed in square frame 91.By selecting " OK " icon 92, the instruction that the user can confirm to comprise error in data does not constitute the part of transaction file.Square frame 40 describes the result of above-mentioned automatic matching treatment in detail and shows as the part of this screen.

In order to continue to confirm transaction file, all unmatched instructions must be mated or ignore to the user.By selecting " matching " link 93 on the screen 90, take the user to as shown in figure 10 screen 100.Square frame 40 continues to show, but new square frame 101 is showed all unmatched instructions.Each instruction is by order number and depend on that match keywords constitutes investor/employee's details of deriving and obtaining from instruction, as pay sheet numbering, name, date of birth or the like the sign because any mistake in these details all can cause instructing and fund administration system in the account do not match.To any special instruction 102 that matches, provide ignore instruction 103, matching instruction 104 or create the option of investor/employee's new account 105 to the user, these processing will be described in greater detail below.

If the user selects matching instruction, the screen 110 of Figure 11 then appears.The instruction that will mate 111 that screen describe in detail to be selected also provides research tool interface 112, the user can the inputted search item to wherein.When the user selects " search " button 113, the search beginning.Search is carried out all existing investment person accounts relevant with the contribution entity.Show on the screen 120 of Search Results in the square frame 121 of Figure 12.The investor account 122 of location lists all correlative details, as name, date of birth, symbolization of accounts or the like, determines to support the user whether the account mates with present unmatched instruction.By selecting to make coupling corresponding to " coupling " prompting 123 of this account.Can in search box 124, import further search terms.If select the account to come matching instruction, then correspondingly updating file as a result table 40 and system return screen 100, confirm the remaining instruction that do not match to support the user.Can check the instruction of having mated by the screen 130 in Figure 13.As broad as long between the instruction of mating automatically by system or manually mating by the contribution entity, and screen 130 correspondingly shows the instruction of all couplings.The frame 131 of coupling shows that one comprises the row 132 of instruction and the adjacent row 133 that comprise corresponding coupling account.The user can be by the icon of selecting to be correlated with 134 that the do not match instruction of selecting not match, and this will make the counting that do not match of frame 40 increase by one.

Beginning, because do not have the account of identical match key word in system, instruction will not match.When user's manual creation during coupling, system can compare account's field and instruction field, and if exist and do not match, as, wherein the birthday inequality, then system can be initiatively to the additional affirmation of user prompt record coupling.

After initial account is provided with, employee record's details of preserving by employer's wage system and preserve by FMS those may be inconsistent.For example, the employee can change the spelling of its surname in employer's wage system, but can not do like this in the FMS system.In another example, the individual who marries may continue their pre-marital surname of use in the environment of their work recently, is their new wedding surname and change all accounts of finances.Correspondingly, preferably the employee record is asynchronous between two systems.Yet, use the details of revising when obtaining match keywords deriving, mispairing can take place.In order to prevent that mispairing from repeating in the file of back is submitted to, use from the derive new match keywords that obtains of the trading instruction of file and upgrade the account's of manual coupling match keywords.This guarantees to make automatically coupling in the future, and that the record details need not in the register system of employer and FMS is identical, because the just match keywords of revising.Data integrity in the therefore corresponding register system obtains keeping.Upgrade match keywords and can not take place, know the final transaction file of having confirmed, because at this time of day, any existing coupling just can not match.

If in screen 100 (Figure 10) " ignoring " icon selected in unmatched record, then file logging moves to the tabulation of ignoring record, as shown the square frame 141 of screen 140 among Figure 14.Correspondingly the updating file results box 40.The user can be by selecting " cancelling " prompting 144 " cancelling " to ignoring ignoring of record 143, and this returns the selected record of ignoring in the tabulation that do not match.After confirming, system does not attempt that handling controls oneself ignores the contribution data of record.

To the new investor,, when trading instruction is provided, will can not find coupling as the new employee of contribution entity.The user can ask this employee is set up new account by select " newly-built " icon of this record from screen 100 (Figure 10).System will use the investor's identification data that is provided with online list by the contribution entity to begin to create new account in FMS.In case submitted online list to, then establishment comprises all required fields in the FMS system of accounts, as the account of investor's sign, symbolization of accounts and match keywords field.Unmatched then instruction and new account coupling.When this document is finally confirmed, will write new account from the match keywords of transaction instruction, mate with the instruction that allows the back to relate to the new investor.

In case all unmatched instructions all by mating, ignore or creating new account and check, then can finally confirm transaction file, and user interface forward screen shown in Figure 15 150 to.The user still can check instruction all couplings or that ignore, if but do not need further action, then the user as PIN (PIN), and selects " affirmation " button 152 to confirm the contribution file by import security code in frame 151.

If confirmed PIN, then interface forwards the screen 160 of Figure 16 a to, it to the online user notify contribution to confirm numbering (CCN) 162 and satisfy the coupling contribution in transaction file, described in detail deal with difference 162.Direct Debit is provided payment options, and wherein the user can import the account details of which fund to carry out debit from, comprises BSB, symbolization of accounts, bank and subbranch, as shown in 163.BPay and Direct Credit option have been showed respectively 164 and 165 in addition.

The surcharge value that the user will pay in the clearing account alternatively is input in the frame 166, deals with on the difference 162 minimum.This generally includes the amount of money in the record of ignoring, and this solves in session next time usually.Select the Next button 167 to proceed payment then.Refer now to Figure 16 B, point out the user in frame 168, to provide PIN then, to confirm subscriber authorisation.Select " submission " icon 169 to continue payment then.In the final step of Figure 16 C, confirm the reception of Payment Request, and provide transaction Ref. No. 1695 to the user.

In an example shown, shown payment details still can show that also other means of payment and this depend on by the selected in history payment options of contribution entity at Direct Debit instrument.Above-mentioned example shows that further the user has the situation of the mandate of paying.In addition, on behalf of the contribution entity, the user can not make the mandate of payment, in this situation, presents screen 170 (Figure 17) to the user, and it is paid in 28 day time limit the personnel of 171 guides user request mandates.

Under many circumstances, owing to changed the essence of the raw data of submitting to, the contribution entity as the paying centre, is wished the mode of the match keywords that changing derives obtains each contributor of unique identification, for example changes into surname and pay sheet numbering from surname and DOB.Match keywords changes processing if do not carry out in batches, then all has mispairing in all records of first file of submitting to.The paying centre at first provides match keywords file in batches with the form shown in following.

Field name	Form	Must fill out
Field name	Form	Must fill out	Surname	????A30	????Y
Name	????A45	????Y	Surname	????A30	????Y
Name	????A45	????Y	Date of birth	????A15	????Y
Unique pay sheet numbering	????A15	????Y	Date of birth	????A15	????Y
Unique pay sheet numbering	????A15	????Y	The FMS symbolization of accounts	????A15	????Y
New surname	????A30	????Y	The FMS symbolization of accounts	????A15	????Y
New surname	????A30	????Y	New name	????A45	????Y
The new date of birth	????A15	????Y	New name	????A45	????Y
The new date of birth	????A15	????Y	New unique pay sheet numbering	????A15

The contribution entity saves as tab-delimited file with this document, guarantees to finish all required fields, and does not have comma in the numeric type field.All dates all are converted to the YYYYMMDD form, and guarantee that all row all have correct form and position.By the website tab-delimited file is uploaded to the interfund transfer protocol gateway.When receiving new file, handle and in file management system, realize changing.Select employer, and input employer title, numbering or plan numbering, and also from the paying centre as selecting the screenshotss of Figure 18 A shown type to upgrade.Then identifier is changed into the new identifier combination that to use.The transformation data sets of input association when file is the FTP form.Processing below when clicking " continuation ", carrying out.With the match keywords rule overwriting is new regulation, and to the new match keywords of each account creation in the data of new file, shown in the match keywords conversion screen of Figure 18 B.Use old match keywords location account, and be that coupling purpose is in the future replaced old match keywords with new match keywords.

Trading instruction in the transaction file is not limited to the financial payment made to investor account, but can expand to all types of valuable commodity and all types of transaction, include but are not limited to distribution of pension contribution, insurance payment, insurance rebate, the long-pending point of loyal remuneration or the like.Similarly, the contribution data are not limited to the pension contribution, but comprise all contributions, comprise the positive and negative amount of money of the valuable commodity that can distribute to the account.The reader who is familiar with technology should be understood that term " account " not only is used to represent accounts of finance as used herein, and is meant and is kept in the system database and can be used to store the record of the data relevant with particular entity with tracking.Use is from the proprietary suitable mandate of account, and the described system of preferred embodiment can be used for controlling simultaneously from a plurality of to be deducted from the account.

The present invention is particularly suitable for wherein instructing the environment with repetition essence, as above-mentioned wage embodiment, and it is wherein identical in essence between the consecutive data set that mates on a period of time, the result is coupling generation automatically in most of the cases, and match keywords is the transaction creation to a series of repetitions, rather than disposable transaction in groups, wherein the data set of data set that will mate and front obviously changes.Another example is online from supplier by the client and the product similar scope of regular subscription.Periodically, as every month, the retailer can order the goods supplied from supplier, and at ordered product with quantitatively have only slight variation.

In order to improve the goods subscription process, the client can create the standard form that comprises customer ID and identify the bulleted list that will order.In the time of will producing the order file, the client can access templates and the required entries purpose quantity is provided at every turn.Customer interface by provider system is uploaded to provider system with the order file then.

Provider system comprises the current inventory level of unique identification project and those projects and the database of any extraneous information, and extraneous information is as supply time limit, price or the like.System will further comprise the match keywords data set that can be used for the product that Query Database asks with the order that is identified at reception.

If desired, be supplier's internal file standard then, and single order instruction is write the instruction daily record the order file conversion that receives.Use the suitable match keywords that is stored in the system regular collection of deriving, each order instruction in the file is derived obtains match keywords, and match keywords also will write the instruction daily record.The single instruction of the match keywords that using then derives obtains in the supplier database mechanical check order file.With item identifier relevant in the supplier database,, write the instruction daily record as unit number with match keywords.Produce the report of handling any inconsistent order instruction at least, and provide to the client by customer interface.

To inconsistent order, provide the item of manual search supplier database to the client, or specify the option of from the order file, ignoring this order with search matched.In case all orders all or coupling or ignore client's file that just can confirm an order.

Form ordering system is also considered the order payment that is similar to above-mentioned investor's contribution embodiment.Calculate the total cost of the order that mates in the order file, and the client selects a kind of pay invoice of coming from any amount of known way, as Direct Credit, Direct credit or the like.Supplier can finish the order instruction of coupling according to their convention then.

It should be noted that in this example, can not cover the match keywords of supplier's match keywords data centralization by the coupling of client's establishment.This is because manually the step of coupling is that the client drives, and does not resemble the example of above-mentioned pension account, and commodity are not to be connected with the client inevitably.That is what, client was defined as mating not necessarily all is suitable for all clients.

For example, a reason that produces inconsistent order is that product has been substituted.When supplier begins to supply new product, then this product is created new match keywords.In addition, supplier may wish to guide the client who seeks old product to turn to new product.A solution is to allow product is used a plurality of match keywords, so that there are the many-one mapping relations.Therefore when the client orders replaced product, the old match keywords of order instruction will be mated automatically with substitute products.The client needn't guarantee that their order template and supplier's product tabulation fit like a glove like this.

Other replace other situations of products customer selecting, in this case, if preferably can be relevant with this product specific to client's match keywords, then can support to mate automatically the order from this client's future.In order to consider this situation, provider system can be stored the complete match keywords database that comprises specific to the regular and default match keywords regular collection of each client's match keywords.

The match keywords rule will be shone upon one or more fields of order instruction to match keywords.For example, the match keywords rule is matching product ID and match keywords simply, as:

Product A → match keywords #A

Product B → match keywords #B

Similarly, client's match keywords regular collection comprises the rule of mapping order instruction field to match keywords, as:

Product X → match keywords #aa

Product Y → match keywords #bb

Client's match keywords regular collection is stored in the match keywords data centralization of using the Customer ID location.

When receiving the order file, the match keywords field of instruction in the daily record at first filled by the match keywords rule set that this client is distributed in search.To each order instruction, if having dependency rule in client's match keywords database, the match keywords that then writes the instruction daily record is the match keywords that obtains according to this rule search.Otherwise, retrieve the default match keywords of this product.

Using of default match keywords allows the required database size of storage match keywords to be minimum.

When the client make and confirm an order instruction and supplier database in product between manual coupling the time, write new match keywords rule and arrive client's match keywords data centralization.

An example of the environment that this embodiment is suitable for is a spare part of ordering motor vehicle or the like.Similarly environment especially comprises the instruction from investor to stock trader, stock that such command identification will be concluded the business or the like.Following Table A sign other application of the present invention:

Use	Operation instruction
Use	Operation instruction	Represent following people to carry out the tax payment :-employee (income tax)-investor's (withholding income tax)	Upload the real-time payment error correction of taxpayer's details and payment total value file
Medical insurance payment to the employee	Upload the real-time insurance money of payment of private insurance gold and payment total value file/payment error correction
Medical insurance payment to the employee		Insurance payment to the employee	Upload the real-time insurance money of payment of private insurance gold and payment total value file/payment error correction
Licence fee :-software license-royalty right payment	Upload the real-time payment error correction of payment and payment total value file	Insurance payment to the employee
Licence fee :-software license-royalty right payment		The order of the following commodity of batch processing :-goods-stationery-spare part-building materials	Upload the real-time payment error correction of payment and payment total value file to the part of nonrecognition
Online retailing shop	Upload required goods and buy total

	The real-time error correcting of value file available items
		Transaction processing	Any type of transaction processing wherein wants the matched data collection to keep core homogeneity

Table A

The present invention such as shown herely in preferred embodiment, provide significant advantage because it allow the user directly with hard core control system real-time, interactive so that can solve any conflict in real time, and the responsibility which side bears these conflicts of solution is not obscured.

Preferable framework and document structure management are described now, particularly to file management gateway (FMG) and data and contribution match keywords (DCM) gateway.

FMG is responsible for receiving pension member registration, maintenance and contribution request, makes up to be sent to the message flow of FMS and to return then to confirm the sender.FMG is configured to receive the input file of the general super message format that the output as contribution entity wage system produces.Especially, FMG is configured to the message of treatment S uperEC form, the universal information agreement of SuperEC form for developing in the industry and realize at Australian pension.System uses the internal standard based on the SuperEC standard in inside.

SuperEC

SuperEC has defined following three kinds of common message format:

1. registration and contribution

2. accumulated

3. confirm

The scene that depends on transaction, every kind of message format all is divided into two or three message formats, and the message format of registration, contribution and affirmation is as follows:

1. registration and contribution

A.SUPEMP (employer's registration and maintenance)

B.SUPMEM (member's registration and maintenance)

C.SUPCONT (member's contribution)

2. confirm

A.ACK (positive acknowledgment)

B.NACK (Negative Acknowledgement)

The DCM gateway uses by the message format of the SuperEC standard appointment basis as the inside story form.SuperEC has also defined the message flow of pension transaction.

The flat file message format that FMS uses is supported all SuperEC fields.If the SuperEC message of full set arrives from the employee, then FMG did not filter untapped field before this document being converted to flat file and being passed to FMS.FMS only selects the field of its use and ignores empty or untapped field.

The flat file that FMS accepts comprises the file that TAB with label identifier and CR separate.Record is separated by CR, and field is separated by TAB.Each row front of record comprises the label of identification record type.This supports higher dirigibility in the flat file structure.

Use Microsoft Biztalk from the file layout that receives to the mapping of FMS flat file format ^TMUse.Biztalk at the separation plane file ^TMIn the framework, only specifying a kind of separator type, and this separator type application comprises field and subrecord in these all nodes of noting to record.In order to allow record to separate by TAB, with identical hierarchical structure,, create the framework of FMS flat file, except the record that comprises subrecord does not comprise field with the identical level of subrecord as SuperEC by carriage return separation and record field.This realizes by creating the container subrecord that is made of the field that should belong to master record.

The screenshotss that provide among Figure 19 have showed how to create the subrecord InsideInterchangeHeader 190 that comprises all fields under the InterchangeHeader 191, rather than are included in the intrarecord field of InterchangeHeader.This guarantees that InterchangeHeader only comprises the record node of being separated by carriage return.

For at Biztalk ^TMSuccessfully realize this effect, set up the mapper connection between the field in parent record rather than the record.The screenshotss of Figure 20 show how source SuperMember record 200 is connected to target SuperMember record 201.If not like this, mapper will connect source SuperMember record and target InsideSuperMember record 202 defaultly, and this can destroy the hierarchical structure of source document.

The message flow framework of DCM (Data Control module) gateway is described in more detail below.

The major function of DCM gateway is:

● with the super message of associating of general super message format reception member registration, maintenance and contribution, this form is specific to each wage system.This comprises the message of SuperEC compatibility.

● the verification message grammer

● conversion/mapping message is inner SuperEC XML form.

● carry out the preparation function verification.

● conversion/mapping message is the FMS flat file format.

● from FMS confirmation of receipt message.

● conversion/mapping message is general affirmation form.This comprises the message of SuperEC compatibility.

Refer now to Figure 21, the processing that receives and send message from the external world is undertaken by interactive server 53.From handling by FTP gateway 15 through FTP with the flat file of going to FMS 11.

It is the data transformation engine of DCM 14 to form that FMS 11 returns SuperEC ACK message.If have the employer/paying centre of this exchange is the SuperEC compatibility, and then DCM sends it back XMLSuperEC ACK message simply and gives them.Otherwise DCM will change and confirm that flat file is the form of contribution entity requirement.In addition, DCM 14 will be stored as CSV and XML file to the copy of ACK message in host server.Will be with enough information updating trace data storehouses, so that front end applications can use it to find relevant ACK file with particular exchange.

The front end page is available to the agency of employer/paying centre, so that they can check the state of their exchange.If will provide them to them wishes then the option that can download the CSV/XML file from host server.

Notice that this processing is applicable to all pensions transaction, and no matter employer/paying centre be the SuperEC compatibility or be ready to receive ACK message with themselves proprietary format.

Figure 22 to 25 shows all these in the 14 inner processing that take place of DCM gateway, and illustrates in greater detail these processing with reference now to these accompanying drawings.Yet it should be noted that the external message form that design support described below arrives with CSV or XML form, though also with the compatibility of other message formats.

The step 1-message sink stage

The processing of message sink is showed in Figure 22.Though preferably receive the message 230 of SuperEC XML compatibility, system's support is with the message of non-SuperEC CSV form 231 inputs.Paying centre (contribution) entity is uploaded the contribution file by front end 232, and also it is placed into Biztalk the most at last to handle file ^TMIn the special catalogue of reception server 233.In order to make realization more efficient, use a plurality of inbox directory 234-237.Each catalogue is specifically designed to and only receives one type message format from a paying centre.The file that front end is found out special paying centre with the query subscription list database is submitted the position to.

Step 2-is mapped as inner SuperEC form

Refer now to Figure 23, in case file has arrived their catalogues separately, messenger service will be selected those files by corresponding file receiver function 244 to 247 (RF identifies receiver function).Each catalogue has a file receiver function.Each receiver function and a passage (being represented by C) 248 to 251 bindings, promptly this is man-to-man relation.The special message format that receives a type of each passage, and to be configured to the input message maps be general inside SuperEC message format.These message have two types: inside SuperEC-MEM 252 SuperEC and the inside SuperEC-CONT 253 that is used for contribution that are used for the member.These inside story forms can be different from the SuperEC form, as long as fill them with extra XML record.Each mapping definition all is unique to each paying centre.During mapping is handled, the paying centre ID of this document is inserted in the file destination.This paying centre ID is determined by system during for the first time to system registry employer/paying centre.

Handle the passage of super contribution file 235 and 237 and to the port binding of fn_dcm_SUPCONT XLANG 254, this will begin to handle the XLANG of super contribution message.Similarly, handle super member file 234 and 236 passages and to the port binding of fn_dcm_SUPMEM XLANG 255, this will begin to handle the XLANG of super member's message.

The step 3-preparatory stage

Stage describes fully with reference to Figure 25 aligning.Receive from above-mentioned port message the time will start function XLANG (fn_dcm_SUPCONT/MEM XLANG) 256 and 257.These XLANG are responsible for checking that the paying centre entity that whether allows to upload this file uses this message.Do like this by using DCMGeneral.GetPCStatus com object 258 query subscription list databases 259.If do not allow transaction, then this message is passed to dcm_SUPCONT_SUSPEND passage 260 immediately, and the latter is dumped to message to be the file in the dcm_SUPCONT_SUSPEND catalogue 261.Then can resubmit these files if desired then by they are copied in the standard message format inbox.

If desired, XLANG also will produce the IID (using the DCMIID.GenIID object) 262 of the document.From Biztalk ^TMFilename to the final output of FTP gateway produces in the back, as shown in 263.This comprises paying centre ID and file sequence number, and the UNC of target file server.Change this UNC and promptly change clauses and subclauses in the DCMSubscriptionList.tblDCMInfo1 SQL table.Then with filename as field input file self.

Tracking.PutDCMEvents object 264 is used for DCM incident inputting, tracing database.To reception, the time-out of message with successfully send a message to next step and define tracking.XLANG is configured to send successful message in the MSMQ of static state.Yet the title of this formation determines dynamically that by the DCMGeneral.GetOutputQueue object this will inquire about it in the subscription list database.This reason behind is to allow to reconfigure need not to change XLANG at two different machine run preparations and output stage.

Step 4-output and FMS response phase

With reference now to Figure 26, output and response phase are described.Function XLANG, fn_dcm_SUPMEM and fn_dcm_SUPCONT_XLANG are submitted to message in dcm_SEC2FMS_SUPMEM and

dcm_SEC2FMS_SUPCONT MSMQ formation

265 and 266 the most separately.Dcm_EC2FMS_SUPMEM formation and 267 bindings of MSMQ receiver function, the latter will submit to message in dcm_SEC2FMS_SUPMEM passage 268.It is FMS SuperMember flat file format 269 that this passage will shine upon inner SuperEC message format.

Dcm_SEC2FMS_SUPCONT formation

266 and 270 bindings of MSMQ receiver function, the latter will submit to message in dcm_SEC2FMS_SUPCONT passage 271.It is FMS SuperContribution flat file format 272 that this passage will shine upon inner SuperEC message format.Result's FMS flat file is sent to

port

273 and 274, and they will be by in the

local directory

275 and 276 of network output file to the FTP gateway server.Two catalogues are arranged, and one is to be used for member's 275, and another is to be used for 276 of contribution.These ports are OPEN target types, and this will select transmission information from the field in the document self.

Select these files by the FTP engine then, this will be by FTP file transfer to FMS.

The DCM assembly

The DCM framework logically can be divided into several assemblies:

1. non-Biztalk ^TMDatabase.Based on the MS sql server, this is used to use Biztalk by DCM ^TMThe additional functionality that does not provide.

2.DLL。Be used to expand Biztalk ^TMFunction.

3. marshalling device.Based on MS Biztalk ^TMServer is used for the convection current compartment.

4.FTP gateway.Be used for transfer files between DCM and FMS.

These assemblies will describe separately below.

Database design

The DCM gateway uses two databases, is mainly used in tracking, log and memory system data, as message pathway rule or the like.These are:

1. subscription list

2. follow the trail of

Logically but not physically be divided into two databases, that is, they are realized in a lot of tables of individual data storehouse rather than two independent database usually, though can use a plurality of databases.

(a) subscription list

Table in the subscription list database comprises the information of employer/paying centre, registers these information to carry out super transaction with this system.The most administration details of this database storing are as contact details, address, Email, devolution or the like.

File from DCM14 must arrive FMS 11 by FTP gateway 15.This processing is the responsibility of FTP gateway.As shown in figure 26, FTP gateway self is made of MS ftp server 15A and two application, uses the transmission of file from DCM to FMS that 15B is used for the managing subscribing list database for one, and Another application 15C is used for reverse direction.These application can comprise the FTP client component, can be used for and inner ftp server and FMS communication.In preferred embodiment, the FTP client component 15B of use is made by Xceed software.

FTP GW DCM → HOST: step is showed and is comprised in the processing of (main frame) transfer files in Figure 27 from DCM to FMS:

1. poll is from the flat file of a local directory:

A. directory listing-FIFO (time sequencing) selects the filename of two ancient deeds.

B. check filename in the 18A of trace data storehouse, if exist, then therefore current another instance processes used just thus of this file selects second name, lays equal stress on to recheck and investigates and prosecutes reason.

C. add filename to the trace data storehouse.

D. derive and obtain new name → be increased to trace data storehouse.

2. be initialised to the ftp session of main frame 11.

3. transmission initialization command.

4. send data file to FMS (as, Putdatafilename fmsdatasetname) with suitable FMS dataset name.

5. transmit fully when database file, send and have NULLCHECK file that suitable FMS inspection file data set name claims to FMS (that is Put dummycheckfilenamefmscheckfiledatasetname).

6. the data file on the mobile FTP gateway is to archive directory.This must be mobile, and (non-duplicating) operated and must be carried out on the Physical Extents identical with source directory.This will guarantee maximum efficient, because only need the revised file link, and move will cause copy data and the original file of deletion to another Physical Extents.

7. upgrade trace data storehouse 18A, successfully transmit this document with indication.

FMS is with poll check file rather than data file.Owing to only send the inspection file when its data file is transmitted fully, FMS can not attempt handling the data file of having transmitted half, and such file is caused by the mistake in the transmission.Check filename back semi-inclusive its Data Filename back half.

Below with reference to Figure 28 explanation processing from FMS (main frame) 11 transfer files to DCM 14:

Confirm that data file is to ftp server 15A 1.FMS will transmit SuperEC.

2.FMS will be to each data file transfer check file that successfully transmits.

3. main frame → DCM handles the inspection file of 15C poll from FMS.

A. directory listing-FIFO (time sequencing) selects the filename of two inspection files the oldest.

C. add and check that filename is to the trace data storehouse.

D. obtain Data Filename from checking that filename is derived.

The search data file and by the mapping network drive it is transferred to Biztalk ^TMFile system 14A.

5. in case transmission is finished, data on the then mobile FTP gateway 15 and inspection file are to archive directory.

This must be mobile, and (non-duplicating) operated and must be carried out on the Physical Extents identical with source directory.This will guarantee maximum efficient, because only need the revised file link, and move will cause copy data and the original file of deletion to another Physical Extents.

6. upgrade trace data storehouse 18A and successfully transmit this document with indication.

Design to scalability

Several methods that can consider to be used to improve DCM gateway scalability are arranged:

1. separate and the sql server of trooping.This realizes optimizing and high availability simultaneously.By separating Biztalk ^TMThe duration data storehouse is to another server, main Biztalk ^TMThe pattern of the intensive processing of storer and CPU is got used in the load meeting of server.This permission system is to Biztalk ^TMServer uses relatively cheap machine and concentrates resource to be used to make up the SQL with hyperdisk array and troop.The sql server of trooping is guaranteed redundancy.Specific to the database of DCM,, also should be positioned at and main Biztalk as following the trail of and subscription list ^TMThe server that server separates.

2. load balancing Biztalk ^TMServer.Biztalk ^TMServer can use WLBS or hardware load balancing to carry out load balancing.Unlike WLBS, the load balance process in the hardware load balancing occurs in outside the server load balancing group.This removes the load balance process load to server automatically, and should preceding carry out in hardware herein, and this will be more efficient.Usually the product that for this reason uses is Cisco LocalDirector.

3. specialized Biztalk ^TMThe role of server.Can pass through specialized Biztalk ^TMThe role of server further optimizes performance.In the most basic configuration, this means to make one or one group of Biztalk ^TMServer is specifically designed to reception, and another group is specifically designed to processing and sends.

4. use local MSMQ to handle burst flow.Formation allows message to accumulate during burst flow, thus losing of preventing to ask.This is useful, needn't handle all requests that arrived because use, but once only handles a part.Notice that though under the situation of make an immediate response in expectation (in real time), this solution is inapplicable, DCM is loosely-coupled system, is fit to the use formation.

5. separating ASP uses and Biztalk ^TMReceiver function.Though Biztalk ^TMServer also is the IIS server, but ASP use should not live with above.Biztalk ^TMServer should be limited to and only move Biztalk ^TMMessage and marshalling service.

6. use AppCentre to carry out the COM+ load balancing.This is similar to the MTS server is carried out load balancing, and AppCentre helps supervision and management to troop, and provides the assembly load balancing based on performance.

Figure 29 shows the preferred architecture of DCM.Biztalk ^TMServer 14.1 and 14.2 is in the load balancing configuration, and SQL and ftp server 278.1 and 278.2 and 15.1 and 15.2 are in trooping.The non-Biztalk of boarding on sql server ^TMDatabase (that is, subscription list and tracking and write daily record) 279 and Biztalk ^TMSystem database.So Biztalk ^TMThe hard disk dense process of server will be alleviated.To ftp server, can use the SDDS server.To Biztalk ^TMThe load balancing of server can be carried out by MS WLBS or by Cisoco LocalDirector.

In case now the explanation flat file is by FTP processing in the FMS when FMS transmits.Receive the FMS flat file from FMG, and to its allocate file Ref. No..Extract the record in the flat file and they are input to the trading instruction daily record individually, transaction log is the table that is stored in the database of FMS.The every record of input of going at log sheet from this document.Figure 30 shows the clauses and subclauses in the transaction log 311, has wherein filled file references 312 and data field 313 (showing together).Transaction log also comprises match keywords field 314, FMS symbolization of accounts field 315 and matching status field 316.At first, as shown in figure 31, remove match keywords, account and mode field.

Director data is carried out the verification inspection, and if instruction comprise any unsolved error in data, then error condition is write the mode field of this instruction.

Using then derives based on the above-mentioned processing of match keywords rule obtains the match keywords of each instruction, and the match keywords " AA " that obtains of will deriving writes match keywords field 314, as shown in figure 31.Use identical match keywords rule to derive and obtain the match keywords of the every other instruction in the respective file.Use these match keywords inquiries FMS system of accounts then.When finding account 332, FMS account's symbolization of accounts 333 is write account's field 315 in the transaction log 311, and matching status is write corresponding mode field 316, shown in figure 32 with identical match key word " AA ".

In case these processing are carried out in all instructions in the file, then FMS produces by transaction log and confirms file, and record, the unmatched record of report coupling in the above described manner and comprise the state and the symbolization of accounts of the record of error in data.Produce the affirmation report of FMS flat file format and it is passed to FMS, it is converted into the form that is used for showing on user interface therein.By the mode field in the transaction log, all journal entries with suitable transaction file Ref. No. calculated the quantity coupling that shows in the interface shown in Figure 4, unmatched and error in data record.Similarly, amount payable is calculated as the polymerization of the contribution field of the transaction log of special deal file references numbering.

Be similar to mechanical check and handle, wherein the contribution entity manually selects FMS account to come record in the match trading daily record, and symbolization of accounts is write the respective account field of the record of charging to daily record, and with matching status write state field.Simultaneously, original unmatched match keywords among the deletion FMS account, and will write FMS account's match keywords field with the identical new match keywords of match keywords of record.

The contribution entity can be selected ignore instruction.When the contribution entity is selected this option by above-mentioned interface, will ignore the transaction log that state writes this record.

When the contribution entity selection does not match the record that has mated, correspondingly deletion symbolization of accounts and matching status from the account of the transaction log of this record and mode field.

Figure 33 shows processing, and wherein the contribution file logging is mated with FMS account mistakenly, and changes coupling correctly afterwards into.At first, has the account 342 that record 341 coupling of match keywords " AA " has symbolization of accounts " 101 " and match keywords " AA ".The contribution entity can select manual matched record 341 to another account 343 with match keywords " BB " and symbolization of accounts " 576 ", shown in 344, at that time, symbolization of accounts " 576 " covers the symbolization of accounts " 101 " in the transaction log, shown in 345 among Figure 34.In this stage, there are not data to write the FMS system of accounts, because this step occurs in transaction file when obtaining confirming.In another scene, contribution entity can select not match record and from transaction log, ignore this record.In this situation, matching status is revised as ignores state.Additionally can from account's field of record, delete symbolization of accounts, though this is not most important.

In case all that register in transaction log write down all or mate or ignore, then the contribution entity can be confirmed this transaction log.The step of confirming guarantees that the contribution entity knows that definitely the instruction of which submission has been checked with the FMS system of accounts and so can access execution.

For can mechanical check in the future instruction, when the contribution entity is confirmed transaction file, the match keywords field of the FMS system update FMS system of accounts.To the record of each coupling in the transaction log, system checks match keywords with the match keywords field of the account in the FMS system of accounts.When having conflict, the match keywords field " BB " of the system of accounts is covered by the record match keywords " AA " at 346 places among Figure 35.Therefore will derive with in the future all of FMS account's mechanical check of appointment and obtain the instruction of identical match keywords.

Writing new match keywords in the FMS system of accounts time, FMS account's (or relevant with this employer/paying centre at least part) to remainder carries out search, to determine whether this match keywords is present in other places in the system, as FMS account 101 situation.Any account with match keywords of equal value all deletes their match keywords field.This step guarantees that any one match keywords all will only be mapped to an account in the FMS system of accounts.The end-state of the FMS system of accounts shows that in Figure 36 wherein the match keywords field of symbolization of accounts " 576 " is stored " AA " now, and symbolization of accounts " 101 " has empty match keywords field 347.

Only the record that mates in the instruction daily record is taken place because upgrade the step of the match keywords field of the FMS system of accounts, when not matching record and account, do not need from account's field of record, to delete symbolization of accounts.

In a single day confirm state to the file allocation of confirming, and made, just can handle it to this document payment.In order to finish transaction, the single contribution amount of money of the record that mates in the transaction log is assigned in the FMS account's who identifies in account's field of respective record the contribution field.

It should be noted that and to be considered as complete file by the raw data file that the contribution entity is submitted to, and do not make and revising or change to any data field of raw data file or from derive any internal file of obtaining of raw data file.Unique field that writes is that those are relevant with match keywords during handling.Reason is that the raw data field is derived from the wage file of contribution entity usually and obtained.For audit objective, need guarantee by the data field one of host maintenance those fields of contribution entity of making peace.Therefore, preferably force the data that the contribution entity resubmits needs correction in the file of back, rather than allow the contribution entity in hosted environment, the data field in the instruction to be made a change.

Should be understood that every other combination in the two or more independent characteristics described or that obviously can from text or accompanying drawing, know of the present invention includes of this announcement and definition.All these are different constitutes each other aspects of the present invention.

Above embodiments of the invention are illustrated, and concerning the person skilled in the art, obviously can make modification and not depart from scope of the present invention it.

Claims

1. coupling is from the computer-based method of the log data set of the instruction set submitting entity to and receive and receiving entity, described log data set comprises a plurality of records, and relevant match keywords data set comprises a plurality of match keywords, wherein each match keywords all identifies relevant record, and described method comprises step:

Use is searched for described match keywords data set from the instruction that the receives match keywords that obtains of deriving, and with identification record in described log data set, thereby mates the record of described instruction and described sign automatically;

To the instruction of at least one non-automatic coupling, the special record that makes described submission entity can select described record data to concentrate, thus manually mate the record of described instruction and described selection; And

Use is upgraded the match keywords data set from the instruction of the manual coupling match keywords that obtains of deriving, to help in the back the instruction that coupling automatically receives and the record of selection.

2. the method for claim 1, it is characterized in that the match keywords of the record of the manual coupling that obtains with deriving is upgraded the match keywords data set makes the back provide the instruction of identical match key word in essence to concentrate the record relevant with them to mate automatically with record data.

3. method as claimed in claim 1 or 2, it is characterized in that, described being made by the contribution entity supports the manually step support of coupling can be used for the instruction of coupling automatically, the coupling that those mate automatically so that the contribution entity can cover or not match, thus allow the manual coupling of back to take place.

4. as any one the described method in the above-mentioned claim, it is characterized in that, comprise being independent of other record renewal match keywords data sets that record data are concentrated, so that record data concentrate any data field except that the match keywords field not change in essence.

5. as any one the described method in the above-mentioned claim, it is characterized in that, comprise that being independent of the match keywords data set upgrades any other record that record data are concentrated, so that the renewal of log data set does not influence instruction and described record that the back is mated reception automatically.

6. as any one the described method in the above-mentioned claim, it is characterized in that, the field store of the corresponding record of match keywords conduct that its neutralization record is relevant, so that the match keywords data set comprises the match keywords field of these data set records, be stored in by copy in the described match keywords field of record of described automatic coupling and upgrade the match keywords data set the described match keywords that obtains of deriving.

7. as any one the described method in the above-mentioned claim, it is characterized in that, comprise and use the step of the predetermined match keywords rule relevant, obtain match keywords by predetermined data elements fields in the described principle combinations instruction to special instruction collection establishment match keywords with the special instruction collection.

8. method as claimed in claim 7, it is characterized in that, handle a plurality of instruction set, each instruction set all has relevant match keywords rule, the data elements fields that will make up in the described regular designated order, described method comprise that the match keywords rule of using this instruction set is derived and obtain the match keywords of each instruction in the instruction set.

9. method as claimed in claim 8, it is characterized in that, when introducing or revising the match keywords rule of special instruction collection, the match keywords rule is written as the new regulation of corresponding match keywords data set, and produces one group of new match keywords and constitute new match keywords data set.

10. as any one the described method in the above-mentioned claim, it is characterized in that, comprise by writing the step that the match keywords data set is created the match keywords data centralization from the instruction that the receives match keywords that obtains of deriving to the small part match keywords.

11. as any one described method in the above-mentioned claim, it is characterized in that, comprise produce and at user interface to submitting to entity to present the command status details, comprise coupling and unmatched list of instructions, to support to submit to the remote manual coupling of entity sign on.

12. method as claimed in claim 11, it is characterized in that, comprise being supported in during the manual matching treatment all records are moved on to from " not matching " classification and finish classification, the described classification of finishing comprises coupling and ignores classification, and prevent that instruction set is accepted and be used for further processing, up to all records from not matching " remove the classification.

13. any one the described method as in the above-mentioned claim is characterized in that, comprises the error in data in the sign instruction set and remove the step that there is the instruction of error in data in those automatically from the instruction that will mate.

14. the method for claim 1, it is characterized in that, described match keywords data set further comprises a plurality of match keywords correlation rules, in the described match keywords correlation rule each all defines the relation between the match keywords of deriving the match keywords that obtains and being associated with record from instruction, and wherein the correlation rule by the renewal between the described match keywords of storing the described record of deriving the match keywords that obtains and being associated with described coupling upgrades the match keywords data set.

15. as any one described method in the above-mentioned claim, it is characterized in that, comprise that the described submission entity of prompting provides search criteria, automatically the described data set of search to be determining the record of the criterion that one or more couplings are provided by described submission entity, and points out described submission entity to select a record from described definite record.

16. as any one described method in the above-mentioned claim, it is characterized in that, wherein during the instruction and the record of described submission entity selection coupling, described method further comprises from described match keywords data centralization deletes association between the data set record outside the record of described the derive match keywords that obtains and selection.

17. as any one described method in the above-mentioned claim, it is characterized in that, submit described instruction set to the format character of special submission entity, described method comprises according to instruction set being converted to form with log data set compatibility before obtaining match keywords by a group mapping law of the feature formal definition of submitting entity to deriving.

18. method as claimed in claim 17 is characterized in that, can change described mapping ruler according to the format change of submitting to entity to make.

19. any one the described method as in the above-mentioned claim is characterized in that the form of described instruction set is to make the payment instruction of many payments, described log data set is to a group account of wherein regularly making payment.

20. method as claimed in claim 19 is characterized in that, comprises that the account according to coupling calculates the payment of dealing with difference and supporting to make described difference in real time based on the polymerization of available fund.

21. coupling is from first trading instruction data set of submitting entity to and receiving with in the method for second data set of receiving entity, described trading instruction data set comprises a plurality of trading instructions, described second data set comprises a plurality of records and relevant match keywords data set, and described method comprises step:

Derive from the trading instruction of described correspondence and to obtain a plurality of match keywords;

Use the described match keywords that obtains of deriving to search for described second data set automatically,, thereby mate the instruction and the described record of described selection with record in described second data centralised identity correspondence;

When the instruction that receives was not had the record of Automatic Logos, the record of supporting the described data centralization of described submission entity selection was with the described instruction of manual coupling; And

To manually carrying out trading instructions with those records that mate automatically.

22. method as claimed in claim 21, it is characterized in that, use is upgraded the match keywords data set from the derive match keywords that obtains of the instruction of manual coupling, provides the instruction of identical in essence match keywords to concentrate the record relevant with them to mate automatically with record data to support the back.

23. comprise the computer-readable media of program code, it is characterized in that described program code is used for controlling at least one programmable processor enforcement of rights and requires 1 to any one method of claim 22.

24. coupling is from the system of the log data set of the instruction set submitting entity to and receive and receiving entity, described log data set comprises a plurality of records, and described system comprises:

The match keywords data set that comprises a plurality of match keywords, wherein each match keywords relative recording of identification record data centralization all;

The match keywords deriving method of deriving and obtaining match keywords from instruction;

Use the described match keywords that obtains of deriving to search for described data set,, thereby mate the search engine of the record of described instruction and described sign automatically with identification record in described log data set;

Support described submission entity selection instruction and the system of selection that it and the record of selecting are manually mated; And

Use is helped the update method of the record that the automatic matching instruction in back and record data concentrate from the derive match keywords that obtains of the instruction of manual coupling.

25. system as claimed in claim 24 is characterized in that, described system of selection comprises to be supported to cover or those couplings of mating automatically that do not match, thereby allows the method for the manual coupling generation of back.

26. as claim 24 or 25 described systems, it is characterized in that described update method comprises that the match keywords renewal match keywords data set of the record of the manual coupling that obtains with deriving makes the back provide the instruction of identical match key word in essence to concentrate the record relevant with them method of coupling automatically with record data

27. system as claimed in claim 26, it is characterized in that, described update method comprises that being independent of other concentrated records of record data upgrades match keywords data sets, so that the method that record data concentrate any data field except that the match keywords field not change in essence, and be independent of any other record that match keywords data set renewal record data are concentrated, so that not influencing the back, the renewal of log data set do not mate the instruction of reception and the method for described record automatically.

28. as the described system of claim 24 to 27, it is characterized in that, the field store that comprises the corresponding record of match keywords conduct that will be relevant with record, so that the match keywords data set comprises the match keywords field of these data set records, be stored in the storer that upgrades the match keywords data set in the described match keywords field of record of described automatic coupling by copy with the described match keywords that obtains of deriving.

29. as the described system of claim 24 to 28, it is characterized in that, comprise the disposal route of handling a plurality of instruction set, and be used to store the storage means of each instruction set and relevant match keywords rule, the data elements fields of described match keywords rule to making up in this instruction set designated order.

30. system as claimed in claim 29, it is characterized in that, comprise being used to be supported in when the special instruction collection introduced or revise the match keywords rule match keywords rule wiring method that the match keywords rule is written as to the new regulation of corresponding match keywords data set, and be used to produce the match keywords production method that one group of new match keywords constitutes new match keywords data set.

31. as any one the described system in the claim 24 to 30, it is characterized in that, comprise by writing the method that the match keywords data set is created the match keywords data centralization from the instruction that the receives match keywords that obtains of deriving to the small part match keywords.

32. as any one the described system in the claim 24 to 31, it is characterized in that, described system of selection comprises generation and presents the command status details at user interface to the submission entity, comprise coupling and unmatched list of instructions, with the method for the remote manual coupling of supporting to submit to the entity sign on.

33. system as claimed in claim 32, it is characterized in that, described system of selection comprises being supported in during the manual matching treatment all records are moved on to from " not matching " classification finishes the class method for distinguishing, the described classification of finishing comprises coupling and ignores classification, and prevent that instruction set is accepted and be used for further processing, up to all records from not matching " method that removes the classification.

34. any one the described system as in the claim 24 to 33 is characterized in that, comprises the error in data in the sign instruction set and remove the method that there is the instruction of error in data in those automatically from the instruction that will mate.

35. as any one the described system in the claim 24 to 34, it is characterized in that, described search engine comprises that the described submission entity of prompting provides the method for search criteria, searches for the method for described data set with the record of determining the criterion that one or more couplings are provided by described submission entity automatically, and the described submission entity of prompting is selected the method for a record from described definite record.

36. any one the described system as in the claim 24 to 35 is characterized in that, comprises the method for the association between the data set record of support outside the record of described the derive match keywords that obtains and selection of described match keywords data centralization deletion.

37. as any one the described system in the claim 24 to 36, it is characterized in that, comprise that the instruction set that will have a special submission physical format feature according to the group mapping law by the feature formal definition of submitting entity to is converted to the data transformation engine with the form of log data set compatibility.

38. system as claimed in claim 37 is characterized in that, comprises the method that can change described mapping ruler according to the format change of submitting to entity to make.

39. any one the described system as in the claim 24 to 38 is characterized in that, the form of described instruction set is to make the payment instruction of many payments, and described log data set is to a group account of wherein regularly making payment.

40. any one the described system as in the claim 24 to 39 is characterized in that, comprise that the account according to coupling calculates the method for dealing with difference in real time based on the polymerization of available fund, and the method for the payment of described difference is made in support.

41. the system of the instruction set that coupling receives from long-range submission entity and the log data set of receiving entity, described log data set comprises a plurality of records, and described system comprises:

Store described log data set and the method that comprises the record match keywords data set of a plurality of match keywords, wherein each match keywords identifies all concentrated relative recordings of record data;

Derive from instruction and to obtain instructing the match keywords deriving method of match keywords;

Use the described match keywords that obtains of deriving to search for described match keywords data set,, and mate the search engine of the record of described instruction and described sign automatically with identification record in described match keywords log data set;

To submitting to entity output to support described submission entity selection instruction and with the manual server method of the interactive user interface of coupling of itself and the record selected, described interactive user interface comprises the command status details; And

42. the system of the instruction set that coupling receives from long-range submission entity and the log data set of receiving entity, described log data set comprises a plurality of records, and described system comprises:

Manage the record management system of described data set, described record management system comprises the record storage method of storage described record and the relevant record match keywords data set that comprises a plurality of match keywords, wherein each match keywords relative recording of identification record data centralization all;

Use the described match keywords that obtains of deriving to search for described match keywords data set,, and mate the search engine of the record of described instruction and described sign automatically with identification record in described match keywords log data set; And

To submitting to entity output to support described submission entity selection instruction and with the manual server method of the interactive user interface of coupling of itself and the record selected, described interactive user interface comprises the command status details.

43. system as claimed in claim 42, it is characterized in that it is the interfund transfer system, the form of instruction set is the interfund transfer instruction, and record management system comprises fund administration system, and described system comprises and is used for managing with the interfund transfer protocol gateway of interfund transfer to fund administration system.

44. interfund transfer as claimed in claim 43 system is characterized in that, comprises the data transformation engine of the data stream between long-range submission entity of conversion and the fund administration system, by it, long-range submission entity can the instruction of executed in real time interfund transfer.

45. any one the described system as in the claim 24 to 38 is characterized in that its form is a commercial articles ordering system, wherein the relation between instruction set and the log data set can be one to one, one-to-many and/or many-to-one relationship.