WO2017166176A1

WO2017166176A1 - Central clearing and settlement system

Info

Publication number: WO2017166176A1
Application number: PCT/CN2016/078011
Authority: WO
Inventors: 李昕光
Original assignee: 李昕光
Priority date: 2016-03-31
Filing date: 2016-03-31
Publication date: 2017-10-05

Abstract

A central clearing and settlement system, related to the field of data processing. The central clearing and settlement system comprises: a transaction database (101) and a clearing database (102), where the transaction database (101) is used for storing transaction data sources, comprising acquiring data, and the clearing database (102) is used for storing clearing data and executing aggregation and clearing; the system also comprises: a reconciliation system (103) used for automatically generating a reconciliation file on the basis of data of the clearing database (102); and a settlement system (104) used for capital settlement. By means of the highly customized central clearing and settlement system, unified and standardized clearing and reconciliation files facilitate unified management, thus increasing clearing efficiency, and enhancing capability for handling exceptions.

Description

Central clearing and settlement system

Technical field

The present invention relates to the field of data processing, and in particular, to a central clearing and settlement system.

Background technique

The central clearing and settlement system is responsible for the electronic wallet card and the electronic cash card issued by the cooperative bank, and all the credit card transaction data on the operator POS terminal placed in the bus, subway, special merchant, and third party payment, etc. The clearing rules of the operating company and the third-party special merchants are carried out for clearing and settlement, and the central clearing and settlement system can be used to generate and print various reports and realize settlement of funds.

In the existing city card system, the clearing system undertakes important functions of data clearing and fund transfer. In the partial clearing system, multi-level platform processing is adopted: multiple system databases are set up in the primary platform for different services; in the secondary platform, the data of each application unit is cleared and settled; Businesses are collected by large merchants or industries, and funds are cleared and settled.

For consumption data, it is processed online in many clearing systems. POS collects and uploads each transaction data on the same day. The system accumulates all-day flow and sends it to the financial system for accounting. The financial department of the operator issues a statement and receives data from the partner merchant on the terminal to perform clearing and reconciliation.

In the process of implementing the present invention, the inventors have found that the prior art has at least the following problems:

For the business and industry, the processing is achieved through grading. For different merchants and industries, the business rules for liquidation are inconsistent, and the implementation is more complicated and less flexible. In the case of increasing industry and merchants, there will be an increase in workload and an increase in management costs.

For different merchants, there is no uniform specification and technical standard for the docking documents, and the reconciliation file does not support custom generation. At the same time, the processing of offline consumption data is not complete enough, relying on data online processing, there is no verification and verification mechanism for offline abnormal data, and there is no abnormal data clearing settlement mechanism.

Summary of the invention

In order to solve the current problem of large workload, the embodiment of the present invention provides a central clearing and settlement system. The technical solution is as follows:

According to a first aspect of the embodiments of the present invention, a central clearing and settlement system is provided, the system comprising: a transaction library and a clearing library;

Wherein, the transaction library is used to store transaction data sources, including receipt data;

The clearing library is used to save the clearing data and perform a summary clearing.

In a first possible implementation manner of the first aspect, the system further includes: a reconciliation system, configured to automatically generate a reconciliation file according to the data of the clearing library;

A settlement system for settlement of funds.

In a second possible implementation manner of the first aspect, the system adopts an ORACLE database, a Linux and Windows operating system, a TOMCAT architecture, and a JAVA/C development language; and uses IBM Pseries as a server hardware.

A second aspect of the embodiments of the present invention provides a central clearing settlement method, where the method includes:

Set the merchant's reserve, or recharge the credit line;

Setting a clearing rule and a rate of the merchant, and configuring the documents required for the merchant to reconcile;

At the predetermined time node, the online transaction data is transferred to the clearing library, and/or the offline transaction data uploaded in the file or the message mode and verified without abnormality is transferred to the clearing library;

The clearing library performs legality verification on the received data;

Perform a summary and clearing of the verified data, and perform card processing on the card at the same time;

The reconciliation system automatically generates a reconciliation file, and sends the reconciliation file to the merchant designated server through the transmission system;

Check the report data with the merchant or industry and settle the funds through the settlement system.

In a first possible implementation manner of the second aspect, the method further includes:

Transfer the offline transaction data of the abnormality after verification to the exception table;

Analyzing the cause of the abnormality, and when it is verified that the data is normal, transferring to the clearing library;

When the verification data fails, the data related impact is rolled back.

In a second possible implementation manner of the second aspect, the performing the summary clearing of the verified data includes: clearing out the transaction amount, commission, and procedure according to the clearing rules and rates of the merchant. The amount of the fee, and deducting the merchant's reserve and credit limit.

In a third possible implementation of the second aspect, the reconciliation system automatically generates a reconciliation file for automatic transmission to the merchant designated server by the transmission software.

In a fourth possible implementation manner of the second aspect, the configuring the merchant reconciliation required file, that is, customizing the daily generated reconciliation file required by the merchant.

In a fifth possible implementation manner of the second aspect, the method further includes: indexing related table data in the clearing library, and/or performing partition management on the table data, and/or The data in the clearing library is periodically timed to store the history table.

In a sixth possible implementation manner of the second aspect, the method further includes: transferring, at a predetermined time node, the online transaction data to the clearing library, specifically, according to the issuing amount of the operating party card and the existing office The number of merchants is such that the transaction database data is synchronized with the clearing library data, and the synchronization process includes transaction commit and transaction rollback.

The beneficial effects brought by the technical solutions provided by the embodiments of the present invention are:

Through a highly customized central clearing and settlement system, unified and standardized clearing and reconciliation documents facilitate unified management, improve clearing efficiency, and enhance the ability to handle abnormal situations.

DRAWINGS

In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings used in the description of the embodiments will be briefly described below. It is obvious that the drawings in the following description are only some embodiments of the present invention. Other drawings may also be obtained from those of ordinary skill in the art in light of the inventive work.

1 is a schematic structural view of an implementation environment involved in various embodiments of the present invention;

2 is a flowchart of a method for a central clearing settlement method according to an embodiment of the present invention;

3 is a schematic structural diagram of a central clearing and settlement system according to another embodiment of the present invention;

4 is a schematic structural diagram of a data processing module according to an embodiment of the present invention;

FIG. 5 is a schematic structural diagram of a server according to another embodiment of the present invention.

detailed description

The embodiments of the present invention will be further described in detail below with reference to the accompanying drawings.

Please refer to FIG. 1, which is a schematic structural diagram of an implementation environment involved in various embodiments of the present invention.

The system supports the clearing and clearing of massive data, realizes multi-rate and multi-rule clearing rule setting, and summarizes the data of each industry and each terminal at the end of the day, clears according to the rate, and clears according to the specified clearing rules. To achieve day-to-end reconciliation with various industries, and support error handling, financial processing, accounting auditing, to achieve industrial fund settlement on T-day or T+1 day, timely store and back up data, and implement fund collection.

The system supports different clearing rules according to the business needs of each merchant, adds merchant reserve, sets the merchant's top-up credit limit, and customizes the daily generated reconciliation files required by the merchant.

At a fixed time node every day, the system will automatically run batch processing in the database, transfer the transaction database data to the clearing library, and verify the validity of the data. Data that has not been validated enters the exception handling process. After verifying the passed data, the card account and the merchant account are credited, and then the summary processing is performed, and the handling fee of the merchant and the commission of the merchant are calculated, and a report is formed for storage.

After the liquidation is completed, the reconciliation file generation will be performed, and the reconciliation files required by the defined merchants will be generated and automatically transmitted through the transmission software.

For abnormal data, the business personnel verify according to the abnormal reason given by the system. If it is abnormal data, it enters the verification process; if it is determined to be normal data, it enters the verification process and performs liquidation again.

Please refer to FIG. 2, which shows a flowchart of a method for a central clearing settlement method provided by an embodiment of the present invention. This embodiment is exemplified by applying the central clearing settlement method to the implementation environment shown in FIG. 1. The method can include:

Step 201: Set a reserve of the merchant, or recharge the credit line;

Step 202: Set a clearing rule and a rate of the merchant, and configure a file required for the merchant to reconcile;

Step 2031: Transfer the online transaction data to the clearing library at a predetermined time node, and/or, in step 2032, transfer the offline transaction data uploaded in a file or message manner and verified without abnormality to the clearing branch. Library

Step 2033: Transfer the offline transaction data of the abnormality after verification to the exception table.

Step 2034, analyzing the cause of the abnormality, and when verifying that the data is normal, transferring to the clearing library;

In step 2035, when the verification data fails, the data related impact is rolled back.

Step 204: The clearing library performs legality verification on the received data.

Step 205, performing summary summarization on the verified data, and performing card processing on the card at the same time;

Specifically, the performing the summary clearing on the verified data includes: separately clearing the amount of the transaction amount, the commission, the handling fee according to the clearing rules and the rate of setting the merchant, and preparing for the merchant Gold and credit lines are deducted.

Step 206: The reconciliation system automatically generates a reconciliation file, and sends the reconciliation file to the merchant designated server through the transmission system;

Specifically, the reconciliation system automatically generates a reconciliation file, and automatically transmits the reconciliation file to the merchant designated server through the transmission software.

In summary, the present invention facilitates unified management by uniformly standardizing clearing and reconciliation files through a highly customized central clearing and settlement system, improving liquidation efficiency, and enhancing the ability to handle abnormal situations.

Step 207: Check the report data with the merchant or the industry, and perform fund settlement through the settlement system.

Specifically, the file required for the merchant reconciliation is configured, that is, the daily generated reconciliation file required by the merchant is customized.

Preferably, the method further comprises: indexing related table data in the clearing library, and/or performing partition management on the table data, and/or performing timing on data in the clearing library. The table takes over the storage.

Preferably, the method further includes: transferring the online transaction data to the clearing library at the predetermined time node, specifically comprising: making the transaction database data and the location according to the issued amount of the operating card and the existing number of the merchants The database data is synchronized for data synchronization, and the synchronization process includes transaction commit and transaction rollback.

Please refer to FIG. 3, which is a schematic structural diagram of a central clearing settlement system according to another embodiment of the present invention. This embodiment is exemplified by applying the central clearing settlement system to the implementation environment shown in FIG. 1. The method can include:

Transaction library 101, clearing library 102;

The transaction library 101 is configured to save a transaction data source, including the receipt data;

Specifically, the clearing library 102 is configured to save the clearing data and perform a summary clearing.

The system further includes: a reconciliation system 103, configured to automatically generate a reconciliation file according to the data of the clearing library 102;

The settlement system 104 is configured to perform fund settlement.

Among them, the system uses ORACLE database, Linux and windows operating system, TOMCAT architecture and JAVA/C development language; IBM Pseries is used as server hardware.

It should be noted that, in the central clearing and settlement system, the central clearing and settlement system provided by the above embodiment is only illustrated by the division of the above functional modules. In actual applications, the functions may be assigned different functions as needed. The module is completed, that is, the internal structure of the system is divided into different functional modules to complete all or part of the functions described above. In addition, the embodiments of the central clearing settlement system and the central clearing settlement method provided by the above embodiments are in the same concept, and the specific implementation process is described in detail in the method embodiments, and details are not described herein again.

Please refer to FIG. 4, which is a schematic structural diagram of a terminal according to an embodiment of the present invention. The electronic device can be used to implement the item transfer method provided in the above embodiments. Specifically:

The terminal 1000 may include an RF (Radio Frequency) circuit 1010, a memory 1020 including one or more computer readable storage media, an input unit 1030, a display unit 1040, a sensor 1050, an audio circuit 1060, a short-range communication module 1070, A processor 1080 having one or more processing cores, and a power supply 1090 and the like are included. It will be understood by those skilled in the art that the terminal structure shown in FIG. 10 does not constitute a limitation to the terminal, and may include more or less components than those illustrated, or combine some components, or different component arrangements. among them:

The RF circuit 1010 can be used for receiving and transmitting signals during and after receiving or transmitting information, in particular, receiving downlink information of the base station and then processing it by one or more processors 1080; in addition, transmitting data related to the uplink to the base station . Generally, the RF circuit 1010 includes, but is not limited to, an antenna, at least one amplifier, a tuner, one or more oscillators, a Subscriber Identity Module (SIM) card, a transceiver, a coupler, an LNA (Low Noise Amplifier). , duplexer, etc. In addition, RF circuit 1010 can also communicate with the network and other devices via wireless communication. Wireless communication can be used Any communication standard or protocol, including but not limited to GSM (Global System of Mobile communication), GPRS (General Packet Radio Service), CDMA (Code Division Multiple Access) WCDMA (Wideband Code Division Multiple Access), LTE (Long Term Evolution), e-mail, SMS (Short Messaging Service), and the like.

The memory 1020 can be used to store software programs and modules, and the processor 1080 executes various functional applications and data processing by running software programs and modules stored in the memory 1020. The memory 1020 may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application required for at least one function (such as a sound playing function, an image playing function, etc.), and the like; the storage data area may be stored according to The data created by the use of the terminal 1000 (such as audio data, phone book, etc.) and the like. Moreover, memory 1020 can include high speed random access memory, and can also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other volatile solid state storage device. Accordingly, memory 1020 can also include a memory controller to provide access to memory 1020 by processor 1080 and input unit 1030.

Input unit 1030 can be used to receive input numeric or character information, as well as to generate keyboard, mouse, joystick, optical or trackball signal inputs related to user settings and function controls. In particular, input unit 1030 can include touch-sensitive surface 1031 as well as other input devices 1032. Touch-sensitive surface 1031, also known as a touch display or touchpad, can collect touch operations on or near the user (such as a user using a finger, stylus, etc., on any touch-sensitive surface 1031 or The operation near the touch-sensitive surface 1031) and driving the corresponding connecting device according to a preset program. Alternatively, the touch-sensitive surface 1031 may include two parts of a touch detection device and a touch controller. Wherein, the touch detection device detects the touch orientation of the user, and detects a signal brought by the touch operation, and transmits the signal to the touch controller; the touch controller receives the touch information from the touch detection device, converts the touch information into contact coordinates, and sends the touch information. The processor 1080 is provided and can receive commands from the processor 1080 and execute them. In addition, the touch sensitive surface 1031 can be implemented in various types such as resistive, capacitive, infrared, and surface acoustic waves. In addition to the touch-sensitive surface 1031, the input unit 1030 can also include other input devices 1032. Specifically, other input devices 1032 may include, but are not limited to, one or more of a physical keyboard, function keys (such as volume control buttons, switch buttons, etc.), trackballs, mice, joysticks, and the like.

Display unit 1040 can be used to display information entered by the user or information provided to the user and various graphical user interfaces of terminal 1000, which can be constructed from graphics, text, icons, video, and any combination thereof. The display unit 1040 may include a display panel 1041. Alternatively, the display panel 1041 may be configured in the form of an LCD (Liquid Crystal Display), an OLED (Organic Light-Emitting Diode), or the like. Further, the touch-sensitive surface 1031 can cover the display panel 1041, and when the touch-sensitive surface 1031 detects a touch operation thereon or nearby, it is transmitted to the processor 1080 to determine the type of the touch event, and then the processor 1080 according to the touch event The type provides a corresponding visual output on display panel 1041. Although in FIG. 10, touch-sensitive surface 1031 and display panel 1041 are implemented as two separate components to implement input and input functions, in some embodiments, touch-sensitive surface 1031 can be integrated with display panel 1041 for input. And output function.

Terminal 1000 can also include at least one type of sensor 1050, such as a light sensor, motion sensor, and other sensors. Specifically, the light sensor may include an ambient light sensor and a proximity sensor, wherein the ambient light sensor may adjust the brightness of the display panel 1041 according to the brightness of the ambient light, and the proximity sensor may close the display panel 1041 when the terminal 1000 moves to the ear. / or backlight. As a kind of motion sensor, the gravity acceleration sensor can detect the magnitude of acceleration in all directions (usually three axes). When it is stationary, it can detect the magnitude and direction of gravity. It can be used to identify the gesture of the mobile phone (such as horizontal and vertical screen switching, related Game, magnetometer attitude calibration), vibration recognition related functions (such as pedometer, tapping), etc.; as for the terminal 1000 can also be configured with gyroscopes, barometers, hygrometers, thermometers, infrared sensors and other sensors, not here Let me repeat.

Audio circuit 1060, speaker 1061, and microphone 1062 can provide an audio interface between the user and terminal 1000. The audio circuit 1060 can transmit the converted electrical data of the received audio data to the speaker 1061, and convert it into a sound signal output by the speaker 1061; on the other hand, the microphone 1062 converts the collected sound signal into an electrical signal, by the audio circuit 1060. After receiving, it is converted into audio data, and then processed by the audio data output processor 180, transmitted to the terminal, for example, via the RF circuit 110, or outputted to the memory 120 for further processing. The audio circuit 160 may also include an earbud jack to provide communication of the peripheral earphones with the terminal 1000.

The short-range communication module 170 may include WiFi (wireless fidelity) technology and/or NFC technology and/or Bluetooth technology and/or infrared technology, and the terminal 1000 may help the user to send and receive emails and browse the webpage through the short-range communication module 170. And access to streaming media, etc., it provides users with no Broadband Internet access and close-range communication of the line, for example, for reading and writing of electronic cards in the embodiment of the present invention.

The processor 1080 is the control center of the terminal 1000, connecting various portions of the entire handset with various interfaces and lines, by running or executing software programs and/or modules stored in the memory 1020, and recalling data stored in the memory 1020, The various functions and processing data of the terminal 1000 are performed to perform overall monitoring of the mobile phone. Optionally, the processor 1080 may include one or more processing cores; preferably, the processor 1080 may integrate an application processor and a modem processor, where the application processor mainly processes an operating system, a user interface, an application, and the like. The modem processor primarily handles wireless communications. It will be appreciated that the above described modem processor may also not be integrated into the processor 1080.

The terminal 1000 also includes a power source 1090 (such as a battery) for powering various components. Preferably, the power source can be logically coupled to the processor 1080 through a power management system to manage functions such as charging, discharging, and power management through the power management system. The power supply 1090 may also include any one or more of a DC or AC power source, a recharging system, a power failure detection circuit, a power converter or inverter, a power status indicator, and the like.

Although not shown, the terminal 1000 may further include a camera, a Bluetooth module, and the like, and details are not described herein again. Specifically, in this embodiment, the display unit of the electronic device is a touch screen display, the electronic device further includes a memory, and one or more programs, wherein one or more programs are stored in the memory and configured to be one or one The above processor executes one or more programs that include an item transfer method as described above.

Please refer to FIG. 5, which is a schematic structural diagram of a server according to an embodiment of the present invention. One or more of the servers may constitute an order management system, a card management system, a convergence management system, or an item provider device in the embodiment of the present invention. The server 1100 includes a central processing unit (CPU) 1101, a system memory 1104 including a random access memory (RAM) 1102 and a read only memory (ROM) 1103, and a system bus 1105 that connects the system memory 1104 and the central processing unit 1101. The server 1100 also includes a basic input/output system (I/O system) 1106 that facilitates transfer of information between various devices within the computer, and mass storage for storing the operating system 1113, applications 1114, and other program modules 1115. Device 1107.

The basic input/output system 1106 includes a display 1108 for displaying information and for The user inputs information such as an input device 1109 such as a mouse or a keyboard. The display 1108 and the input device 1109 are both connected to the central processing unit 1101 via an input-output controller 1110 connected to the system bus 1105. The basic input/output system 1106 can also include an input output controller 1110 for receiving and processing input from a plurality of other devices, such as a keyboard, mouse, or electronic stylus. Similarly, the input and output controller 1110 also provides output to a display screen, printer, or other type of output device.

The mass storage device 1107 is connected to the central processing unit 1101 by a mass storage controller (not shown) connected to the system bus 1105. The mass storage device 1107 and its associated computer readable medium provide non-volatile storage for the server 1100. That is, the mass storage device 1107 can include a computer readable medium (not shown) such as a hard disk or a CD-ROM drive.

Without loss of generality, the computer readable medium can include computer storage media and communication media. Computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data. Computer storage media include RAM, ROM, EPROM, EEPROM, flash memory or other solid state storage technologies, CD-ROM, DVD or other optical storage, tape cartridges, magnetic tape, magnetic disk storage or other magnetic storage devices. Of course, those skilled in the art will appreciate that the computer storage medium is not limited to the above. The system memory 1104 and the mass storage device 1107 described above may be collectively referred to as a memory.

According to various embodiments of the present invention, the server 1100 may also be operated by a remote computer connected to the network through a network such as the Internet. That is, the server 1100 can be connected to the network 1112 through the network interface unit 1111 connected to the system bus 1105, or can also be connected to other types of networks or remote computer systems (not shown) using the network interface unit 1111. .

The memory further includes one or more programs, the one or more programs being stored in a memory, the one or more programs including instructions for performing the item transfer method provided by embodiments of the present invention.

The serial numbers of the embodiments of the present invention are merely for the description, and do not represent the advantages and disadvantages of the embodiments.

Those skilled in the art can understand that all or part of the steps of implementing the above embodiments can be The completion of the hardware may also be performed by a program to instruct related hardware. The program may be stored in a computer readable storage medium. The storage medium mentioned above may be a read only memory, a magnetic disk or an optical disk.

The above are only the preferred embodiments of the present invention, and are not intended to limit the present invention. Any modifications, equivalents, improvements, etc., which are within the spirit and scope of the present invention, should be included in the protection of the present invention. Within the scope.

Claims

A central clearing and settlement system, characterized in that the system comprises:

Trading library, clearing library; among them,

The transaction library is used to store transaction data sources, including receipt data;

The clearing library is used to save the clearing data and perform a summary clearing;

Among them, the system uses ORACLE database, Linux and windows operating system, TOMCAT architecture and JAVA/C development language; IBM Pseries is used as server hardware.
The system of claim 1 wherein the system further comprises:

a reconciliation system, configured to automatically generate a reconciliation file according to the data of the clearing library;

A settlement system for settlement of funds.