CN116069407A - Method and system for analyzing SWIFT message and automatically mapping SWIFT message to business transaction column - Google Patents

Abstract

The invention provides a method and a system for analyzing SWIFT messages and automatically mapping the SWIFT messages to business transaction columns, comprising the following steps: step 1: maintaining a message rule configuration table, and establishing a mapping relation between an external message field and business transaction column information and a matching and processing rule; step 2: monitoring a registered message, and notifying a background message processing service to analyze the message when receiving a trigger event from a trigger; step 3: analyzing the message through background service, reading related information according to analysis results to judge the type of the message, reading related configuration rules of the message in a message rule configuration table, and converting an external message file into a standard structured data file; step 4: and selecting the business to be processed from the to-be-processed folder, and automatically reading the structured data storage file by the system to analyze and process. The invention realizes the automatic conversion from the external message to the internal transaction information, improves the efficiency and reduces the error rate.

Description

Method and system for parsing SWIFT messages and automatically mapping to business transaction fields

technical field

The present invention relates to the field of communication technology, in particular to a method and system for parsing SWIFT messages and automatically mapping them to business transaction fields, especially a method and system for analyzing and mapping SWIFT messages to business transactions based on rule configuration in an international settlement system method of the field.

Background technique

There are many types of SWIFT messages, and the rules for each type of message are complex. On the one hand, the market lacks a mature processing mechanism for analyzing message content and mapping it to system business transaction fields. On the other hand, with the needs of global digital transformation, message standards It is changing rapidly every year, which brings huge challenges to the software adaptation and transformation of the banking system. The following problems exist in the prior art: 1) The lack of mapping rules or the low degree of parameterization lead to a low degree of automation of business processing, poor user experience, and low efficiency; 2) The mapping rules are hard-coded and inflexible. When the mapping with the transaction business field is wrong, the problem can only be solved by modifying the software code, which is costly and ineffective; 3) When the external environment such as message standards or customer needs changes, it is difficult to shield the impact of external changes on the internal system; More development workload reduces the response speed.

The publication number is CN113673978B, a transaction method, system, computer equipment and storage medium based on the SWIFT system, wherein the method includes: generating a transfer message in Extensible Markup Language XML format by integrating business information, and using SWIFT NET from The bank system obtains the account statement message; converts the end-of-day statement message and the day-time statement message into XML-formatted day-end statement files and day-time statement files through data processing, and stores them in the first folder; regularly scans the first Folder, obtain day-end bill files and daytime bill files, respectively analyze and translate to obtain the value of each field, store it in the corresponding file information database table, and update the balance table and detailed table of the overseas treasury system. But this patent document is different from the technical scheme of the present application.

Contents of the invention

Aiming at the defects in the prior art, the object of the present invention is to provide a method and system for parsing SWIFT messages and automatically mapping them to business transaction fields.

According to a method for parsing a SWIFT message provided by the present invention and automatically mapping to a business transaction column, the method includes the following steps:

Step 1: Maintain the message rule configuration table, and establish a mapping relationship between external message fields and business transaction field information for matching and processing rules;

Step 2: Register for message monitoring, when an incoming report is received, an event is triggered, and the background message processing service is notified to analyze the message;

Step 3: Analyze the message through the background service, read the relevant information to determine the message type according to the analysis result, read the relevant configuration rules of this type of message in the message rule configuration table, and load the relevant information related to this message from the database. specific business information, convert external message files into standard structured data files, and generate to-do tasks and put them in the task queue;

Step 4: Select the business to be processed from the to-do folder, the system automatically reads the structured data storage file for analysis and processing, completes the automatic assignment and display of the fields on the business transaction interface, verifies the information in the transaction field, and completes the business processing.

Preferably, in the step 1, the maintenance content includes information source and form, information type, transaction code, information label, information sub-label, target field, field type, field conversion method, copy flag and overwrite flag.

Preferably, in the step 3, the relevant information read according to the analysis result includes: message type, receiving bank, sending bank, currency, amount and reference number.

Preferably, in the step 3, the specific business information related to this message is loaded from the database, and the external message content information, configuration rule information and existing business record information are integrated to complete the value domain coverage processing and column rule processing And code value conversion processing, converting the external message file into a standard structured data file.

The present invention also provides a system for parsing SWIFT messages and automatically mapping to business transaction fields, including the following modules:

Module M1: maintain the message rule configuration table, and establish a mapping relationship between external message fields and business transaction field information for matching and processing rules;

Module M2: Register message monitoring, trigger an event when an incoming report is received, and notify the background message processing service to analyze the message;

Module M3: Analyze the message through the background service, read the relevant information according to the analysis result to judge the message type, read the relevant configuration rules of this type of message in the message rule configuration table, and load the relevant information related to this message from the database. specific business information, convert external message files into standard structured data files, and generate to-do tasks and put them in the task queue;

Module M4: Select the business to be processed from the to-do folder, the system automatically reads the structured data storage file for analysis and processing, completes the automatic assignment and display of the fields on the business transaction interface, verifies the information in the transaction field, and completes the business processing.

Preferably, in the module M1, the maintenance content includes information source and form, information type, transaction code, information label, information sub-label, target field, field type, field conversion method, copy flag and overwrite flag.

Preferably, in the module M3, the relevant information read according to the analysis result includes: message type, receiving bank, sending bank, currency, amount and reference number.

Preferably, in the module M3, the specific business information related to this message is loaded from the database, and the external message content information, configuration rule information and existing business record information are integrated to complete the value domain coverage processing and column rule processing And code value conversion processing, converting the external message file into a standard structured data file.

The present invention also provides a computer-readable storage medium storing a computer program. When the computer program is executed by a processor, it implements the parsing of the SWIFT message described in any one of claims 1 to 4 and automatic mapping to the business transaction column. The steps of the bit method.

The present invention also provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and operable on the processor, when the computer program is executed by the processor, it implements claims 1 to 4 Steps in any one of the methods for parsing SWIFT messages and automatically mapping them to business transaction fields.

Compared with the prior art, the present invention has the following beneficial effects:

1. The present invention realizes automatic conversion from external messages to internal transaction information, improves efficiency and reduces error rate;

2. The present invention can not only shield the impact of changes in external message rules, but also adjust the configuration rules online through configuration transactions without requiring or less modification of business transaction codes, realizing configurable and low-code software, and further supporting other Data formats such as XML message multiplexing related configuration rules have the characteristics of rule reusability, scalability, and insertability;

3. When the background service receives an incoming report, the present invention automatically parses and maps the incoming report content to the corresponding field of the business transaction according to the configured rules, realizes customizable rules, reusable rules, and expandable rules, reducing manual intervention by tellers volume and improve user experience;

4. The present invention provides a set of flexible message content-to-transaction field full-parameter mapping configuration method, which can maintain the mapping rules from message analysis to transaction field online and take effect, and can shield the problems caused by changes in external message rules. Impact, no need to redevelop the program, realize low-code, reusable, configurable, and improve user experience.

Description of drawings

Other characteristics, objects and advantages of the present invention will become more apparent by reading the detailed description of non-limiting embodiments made with reference to the following drawings:

Fig. 1 is a flow chart of the steps of the method for parsing SWIFT messages and automatically mapping them to business transaction fields in the present invention.

Detailed ways

The present invention will be described in detail below in conjunction with specific embodiments. The following examples will help those skilled in the art to further understand the present invention, but do not limit the present invention in any form. It should be noted that those skilled in the art can make several changes and improvements without departing from the concept of the present invention. These all belong to the protection scope of the present invention.

Example 1:

As shown in Figure 1, this embodiment provides a method for parsing a SWIFT message and automatically mapping it to a business transaction column, including the following steps:

Step 1: Maintain the message rule configuration table, and establish a mapping relationship between the external message field and the business transaction field information for matching and processing rules; the maintenance content includes information source and form, information type, transaction code, information label, and information sub-label , target field, field type, field conversion method, copy flag, and overwrite flag.

Step 2: Register for message monitoring, when an incoming report is received, an event is triggered, and the background message processing service is notified to analyze the message;

Step 3: Analyze the message through the background service, read the relevant information to determine the message type according to the analysis result, read the relevant configuration rules of this type of message in the message rule configuration table, and load the relevant information related to this message from the database. specific business information, convert the external message file into a standard structured data file, and generate to-do tasks and put them in the task queue; the relevant information read according to the analysis results includes: message type, receiving line, sending line , currency, amount, and reference number; load specific business information related to this message from the database, integrate external message content information, configuration rule information, and existing business record information, and complete value range coverage processing and field rule processing And code value conversion processing, converting the external message file into a standard structured data file.

Step 4: Select the business to be processed from the to-do folder, the system automatically reads the structured data storage file for analysis and processing, completes the automatic assignment and display of the fields on the business transaction interface, verifies the information in the transaction field, and completes the business processing.

In step 1, through message standards, message types, and business transaction configuration dimensions, establish the corresponding relationship between different message types of different standard messages and configurable data modules between business transactions in this system, and swift and XML can be configured and other message standards; by configuring the message TAG in the source message, it is further divided into message TAG sub-tags, and then associated with the path of the module and specific fields, so as to realize the source message TAG value field to the target system business transaction column Bit mapping configuration relationship; through whether to cover, analysis method, and analysis method parameters, the TAG value field of the message passes the agreed processing rules, realizes the value field analysis and processing in a configurable manner, and converts it into a target value and maps it to the business transaction column bit, Table 1 shows the data structure of the message rule configuration table.

Table 1 Message rule configuration table

In step 3, the message parsing method is to realize the format conversion of the message session (TAG) by parameterizing the content such as the basic format of the message and the session;

3.1) Formatting type configuration:

<xxx>=<Sign><nnn>;

<xxx> is the format name; <nnn> is the format length of 3 digits; <Sign> is '-', the maximum length is nnn characters, if it is '+', it means the length must be nnn characters;

For example:

DAT＝+006 DAT type must be 6 characters;

LDT＝+008 DAT type must be 8 characters;

AMT＝-018 AMT type can reach 18 characters;

3.2) Matching format of message field (TAG):

FLD <tag> = <Format>;

<tag> is the session in the message; <Format> is composed of format names and supports one or more formats;

When <tag> contains multiple word fields, one or more formatting types can be specified;

For example:

FLD32A=DAT AMT means that 32A includes DAT, AMT sub-fields, and the format DAT and AMT corresponding to the composition format;

FLD32B=AMT indicates that 32B contains the AMT sub-field;

3.3) According to the parameter configuration of 3.1) and 3.2), the SWIFT message is parsed in TAG order:

For example, the 32A format of the SWIFT message is as follows:

:32A:221017USD3322

The above message session 32A can be converted to the value date, currency and amount fields through the parameter settings of 1) and 2), so that they can be adapted to the transaction fields one by one.

In step 4, the whole process from receiving the message to assigning and displaying the value of the transaction field is as follows, taking SWIFT700 as an example:

4.1) Receive SWIFT MT700 message

...... (omitted)

:27:1/1

:40A:IRREVOCABLE

:20:110LC22000180

:31C:221114

:40E:UCP LATEST VERSION

...... (omitted)

:32A:USD3332,

...... (omitted)

4.2) Table 2 is the configuration table for reading message rules, showing the parameter configuration of reading message rule configuration table:

Table 2 Read message rule configuration table

4.3) Target system transaction field assignment and display

Taking MT700 message sessions 32B and 40A as an example, by reading the parameters of the message configuration table, the two fields of AMT and CUR corresponding to 32B can be mapped to the amount and Currency field, map the 40A field to the LCRTYP field (letter of credit type) under the AA module BBB path in LET001 (export L/C opening transaction), check the correctness through the code table, and set the code value corresponding to IRREVOCABLE to I Save; by extracting all message conversion and analysis to a single layer for processing, business transactions only need to focus on their own business logic;

After the message is processed, it forms a structured data file:

...... (omitted)

LET001.AA.BBB.AMT=3332

LET001.AA.BBB.CUR＝USD

LET001.AA.CCC.LCRTYP=I (code value IRREVOCABLE mapping I value)

...... (omitted)

When business personnel handle business transactions, the system can directly load structured files, and directly assign values to designated interface fields according to field paths and value fields, reducing the logic of data interaction and conversion.

This embodiment also provides a system for parsing SWIFT messages and automatically mapping to business transaction fields, the system for parsing SWIFT messages and automatically mapping to business transaction fields can perform the parsing of SWIFT messages and automatic mapping The process steps of the method to the business transaction field are realized, that is, those skilled in the art can understand the method of analyzing the SWIFT message and automatically mapping to the business transaction field as the analysis of the SWIFT message and automatically mapping to the business transaction A preferred embodiment of the system of fields.

This embodiment also provides a computer-readable storage medium storing a computer program. When the computer program is executed by a processor, the steps of the above-mentioned method for parsing a SWIFT message and automatically mapping it to a business transaction field are implemented.

This embodiment also provides an electronic device, including a memory, a processor, and a computer program stored on the memory and operable on the processor. When the computer program is executed by the processor, the above-mentioned parsing of SWIFT messages and automatic mapping to business Steps for the method of the transaction field.

Example 2:

This embodiment provides a system for parsing SWIFT messages and automatically mapping to business transaction fields, including the following modules:

Module M1: Maintain the message rule configuration table, and establish a mapping relationship between external message fields and business transaction field information for matching and processing rules; maintenance content includes information sources and forms, information types, transaction codes, information labels, and information sub-labels , target field, field type, field conversion method, copy flag, and overwrite flag.

Module M2: Register message monitoring, trigger an event when an incoming report is received, and notify the background message processing service to analyze the message;

Module M3: Analyze the message through the background service, read the relevant information according to the analysis result to judge the message type, read the relevant configuration rules of this type of message in the message rule configuration table, and load the relevant information related to this message from the database. specific business information, convert the external message file into a standard structured data file, and generate to-do tasks and put them in the task queue; the relevant information read according to the analysis results includes: message type, receiving line, sending line , currency, amount, and reference number; load specific business information related to this message from the database, integrate external message content information, configuration rule information, and existing business record information, and complete value range coverage processing and field rule processing And code value conversion processing, converting the external message file into a standard structured data file.

Module M4: Select the business to be processed from the to-do folder, the system automatically reads the structured data storage file for analysis and processing, completes the automatic assignment and display of the fields on the business transaction interface, verifies the information in the transaction field, and completes the business processing.

Example 3:

Those skilled in the art may understand this embodiment as a more specific description of Embodiment 1 and Embodiment 2.

This embodiment provides a set of methods based on rule configuration to parse SWIFT messages and automatically map them to business transaction fields. When the background service receives an incoming report, it automatically parses and maps the content of the incoming report to the corresponding field of the business transaction according to the configured rules. , realize customizable rules, reusable rules, and extensible rules, reduce the workload of manual intervention by tellers, and improve user experience.

The method provided in this embodiment for parsing and mapping message content to business transaction fields according to configuration rules includes:

Step 1: Maintain the message rule configuration table, and establish a mapping relationship between the external message field and the business transaction field information and processing rules. The maintenance content includes information source and form, information type, transaction code, information tag (TAG), Information sub-tab, target field, field type, field conversion method, copy flag, overwrite flag, etc.;

Step 2: Register for message monitoring, when an incoming report is received, an event is triggered, and the background message processing service is notified to analyze the message;

Step 3: The background service analyzes the message, reads the message type, receiving bank, sending bank, currency, amount, reference number and other information to judge the message type according to the analysis result, and then reads the message rule configuration table Relevant configuration rules for this type of message, and at the same time load specific business information related to this message from the database, integrate external message content, configuration rules, existing business records and other information, and complete value range coverage, field rule processing, A series of processing such as code value conversion, and finally convert the external message file into a standard structured data file (interface display file), and generate to-do tasks and put them in the task queue;

Step 4: The business personnel select the business to be processed from the to-do folder, the system automatically reads the structured data storage file for analysis and processing, and completes the automatic assignment and display of the fields on the business transaction interface; the business personnel verify the correctness of the information in the transaction field, etc. Business handling.

The present invention realizes the automatic conversion from external messages to internal transaction information by providing a set of rule-based configuration analysis methods for analyzing SWIFT messages and automatically mapping them to business transaction fields, improving efficiency and reducing error rates; both external message rules can be shielded At the same time, the configuration rules can be adjusted online through the configuration transaction, and the business transaction code does not need to be modified or less, so that the software can be configurable and low-code, and can further support other data formats such as XML message multiplexing related configuration rules , has the characteristics of rule reusability, scalability, and pluggability.

Those skilled in the art know that, in addition to realizing the system provided by the present invention and its various devices, modules, and units in a purely computer-readable program code mode, the system provided by the present invention and its various devices can be completely programmed by logically programming the method steps. , modules, and units implement the same functions in the form of logic gates, switches, ASICs, programmable logic controllers, and embedded microcontrollers. Therefore, the system and its various devices, modules, and units provided by the present invention can be regarded as a hardware component, and the devices, modules, and units included in it for realizing various functions can also be regarded as hardware components. The structure; the devices, modules, and units for realizing various functions can also be regarded as not only the software modules for realizing the method, but also the structures in the hardware components.

Specific embodiments of the present invention have been described above. It should be understood that the present invention is not limited to the specific embodiments described above, and those skilled in the art may make various changes or modifications within the scope of the claims, which do not affect the essence of the present invention. In the case of no conflict, the embodiments of the present application and the features in the embodiments can be combined with each other arbitrarily.

Claims (10)

1.A method for parsing a SWIFT message and automatically mapping the same to a business transaction field, comprising the steps of:

step 1: maintaining a message rule configuration table, and establishing a mapping relation between an external message field and business transaction column information and a matching and processing rule;

step 2: monitoring a registered message, and notifying a background message processing service to analyze the message when receiving a trigger event from a trigger;

step 3: analyzing the message through background service, reading related information according to an analysis result to judge the type of the message, reading related configuration rules of the message in a message rule configuration table, loading specific business information related to the message from a database, converting an external message file into a standard structured data file, generating a task to be handled and putting the task to be handled into a task queue;

step 4: and selecting the business to be processed from the to-be-processed folder, automatically reading the structured data storage file by the system to analyze and process, completing the automatic assignment and display of the business transaction interface field, verifying the information of the transaction field, and completing the business transaction.

2. The method for parsing a SWIFT message and automatically mapping the same to a business transaction field according to claim 1, wherein in step 1, the maintenance contents include information source and form, information category, transaction code, information tag, information sub-tag, target field, field type, field conversion method, copy flag and overlay flag.

3. The method for parsing a SWIFT message and automatically mapping the SWIFT message to a business transaction field according to claim 1, wherein in the step 3, the relevant information read according to the parsing result includes: message type, receipt line, transmission line, currency, amount and reference number.

4. The method for parsing a SWIFT message and automatically mapping the same to a transaction field according to claim 1, wherein in step 3, specific service information related to the message is loaded from a database, and external message content information, configuration rule information and existing service record information are integrated, so as to complete value range coverage processing, field rule processing and code value conversion processing, and convert an external message file into a standard structured data file.

5. A system for parsing a SWIFT message and automatically mapping to a business transaction field, comprising the following modules:

module M1: maintaining a message rule configuration table, and establishing a mapping relation between an external message field and business transaction column information and a matching and processing rule;

module M2: monitoring a registered message, and notifying a background message processing service to analyze the message when receiving a trigger event from a trigger;

module M3: analyzing the message through background service, reading related information according to an analysis result to judge the type of the message, reading related configuration rules of the message in a message rule configuration table, loading specific business information related to the message from a database, converting an external message file into a standard structured data file, generating a task to be handled and putting the task to be handled into a task queue;

module M4: and selecting the business to be processed from the to-be-processed folder, automatically reading the structured data storage file by the system to analyze and process, completing the automatic assignment and display of the business transaction interface field, verifying the information of the transaction field, and completing the business transaction.

6. The system for parsing a SWIFT message and automatically mapping it to a business transaction field according to claim 5, wherein the maintenance content in the module M1 includes information source and form, information category, transaction code, information tag, information sub-tag, target field, field type, field conversion method, copy flag and overlay flag.

7. The system for parsing a SWIFT message and automatically mapping the same to a business transaction field according to claim 5, wherein the module M3 reads relevant information according to the parsing result, including: message type, receipt line, transmission line, currency, amount and reference number.

8. The system for parsing a SWIFT message and automatically mapping the same to a transaction field according to claim 5, wherein the module M3 loads specific service information related to the message from a database, integrates external message content information, configuration rule information and existing service record information, and performs value coverage processing, field rule processing and code value conversion processing to convert an external message file into a standard structured data file.

9. A computer readable storage medium storing a computer program, wherein the computer program when executed by a processor implements the steps of the method of parsing a SWIFT message and automatically mapping to a business transaction field as claimed in any one of claims 1 to 4.

10. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the computer program when executed by the processor implements the steps of the method of parsing a SWIFT message and automatically mapping to a business transaction field as claimed in any one of claims 1 to 4.

Images