CN112685484A - Transaction account checking method and device, storage medium and electronic equipment - Google Patents

Transaction account checking method and device, storage medium and electronic equipment Download PDF

Info

Publication number
CN112685484A
CN112685484A CN202011554036.6A CN202011554036A CN112685484A CN 112685484 A CN112685484 A CN 112685484A CN 202011554036 A CN202011554036 A CN 202011554036A CN 112685484 A CN112685484 A CN 112685484A
Authority
CN
China
Prior art keywords
data
target
target data
module
database
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN202011554036.6A
Other languages
Chinese (zh)
Other versions
CN112685484B (en
Inventor
王英郦
杨明华
李嘉坤
孙宏兵
唐凌云
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Aisino Software Technology Co ltd
Original Assignee
Aisino Software Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Aisino Software Technology Co ltd filed Critical Aisino Software Technology Co ltd
Priority to CN202011554036.6A priority Critical patent/CN112685484B/en
Publication of CN112685484A publication Critical patent/CN112685484A/en
Application granted granted Critical
Publication of CN112685484B publication Critical patent/CN112685484B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30—Computing systems specially adapted for manufacturing

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The disclosure relates to a transaction reconciliation method, a transaction reconciliation device, a storage medium and electronic equipment, belonging to the technical field of information, wherein the method comprises the following steps: acquiring first data of an upstream data source and second data of a downstream data source according to a target downloading mode, wherein the target downloading mode is any one of a plurality of preset downloading modes; converting the first data and the second data into first target data and second target data according to a target data format, wherein the target data format is any one of a plurality of data formats configured in advance; taking a model of order number information in each piece of data, naming the primary key of the data in the first target data and the second target data according to the obtained model number, and storing the first target data and the second target data in a file system; extracting data with the same main key name in the file system to a Redis memory for comparison so as to determine difference data; and generating a reconciliation result according to the difference data.

Description

Transaction account checking method and device, storage medium and electronic equipment
Technical Field
The present disclosure relates to the field of information technologies, and in particular, to a transaction reconciliation method, an apparatus, a storage medium, and an electronic device.
Background
At present, along with the development of company's multiple service lines, the data volume increases, and each service line all has the reconciliation demand, and in the correlation technique, the reconciliation system is when the reconciliation demand changes frequently, data volume is big, because need redevelopment, test and issue, leads to the unable demand that exists of quick response of current system, from this, current system has a plurality of new reconciliation business of dealing with needs, and the response is slow, the development and the issue cycle is lengthy problem.
Disclosure of Invention
In order to solve the problems in the related art, the present disclosure provides a transaction reconciliation method, device, storage medium and electronic device.
In order to achieve the above object, a first aspect of the present disclosure provides a transaction reconciliation method, which includes:
acquiring first data of an upstream data source and second data of a downstream data source according to a target downloading mode, wherein the target downloading mode is any one of a plurality of preset downloading modes;
converting the first data and the second data into first target data and second target data according to a target data format, wherein the target data format is any one of a plurality of preconfigured data formats, and each piece of data in the target first data and the target second data comprises order number information and transaction amount information;
taking a model of order number information in each piece of data, naming a primary key of data in the first target data and the second target data according to the obtained model number, and storing the first target data and the second target data in a file system;
extracting data with the same main key name in the file system to a Redis memory for comparison so as to determine difference data;
and generating a reconciliation result according to the difference data.
Optionally, each of the first target data and the second target data further includes a transaction time, the method further includes:
storing the target first data and the target second data in a database;
the extracting data with the same primary key name in the file system to a Redis memory for comparison to determine the difference data further comprises:
marking difference states on the difference data, wherein the difference states comprise non-compliance, a long error and a short error;
under the condition that the difference state is a long-line error or a short-line error, whether matched target data exist in the database or not is inquired according to order number information of data extracted to the Redis memory at this time;
and under the condition that the matched target data exists in the database and the transaction time of the target data is in a fault-tolerant time range corresponding to the transaction time of the data extracted to the Redis memory at this time, deleting the difference state marked on the difference data.
Optionally, the storing the first target data and the second target data in a database includes:
taking a module of order number information in each piece of data, and determining a target database and a target data table in the target database from at least one preset database according to the obtained module number;
storing the piece of data into the target data table in the target database;
the step of inquiring whether matched target data exists in the database according to the order number information of the data extracted to the Redis memory data;
obtaining a target model number by taking a model of the order number information, and determining a target database and a target data table for inquiring according to the target model number;
and querying the target data table in the target database according to the order number information.
Optionally, each of the first data and the second data further includes an organization number as a unique identifier of an upstream organization, the modulo of the order number information in each piece of data is performed, and naming the primary key of the data in the first target data and the second target data according to the obtained modulo number includes:
and naming the primary key of the data in the first target data and the second target data according to the mechanism number and the model number.
Optionally, the generating a reconciliation result according to the difference data includes:
and generating a statement and a settlement file according to the difference data, a target statement template and a target settlement file template, wherein the target statement template is any one of a plurality of preconfigured statement templates, and the target settlement file template is any one of a plurality of preconfigured settlement file templates.
A second aspect of the present disclosure provides a transaction reconciliation apparatus, the apparatus comprising:
the system comprises a downloading module, a processing module and a processing module, wherein the downloading module is used for acquiring first data of an upstream data source and second data of a downstream data source according to a target downloading mode, and the target downloading mode is any one of a plurality of preset downloading modes;
the conversion module is used for converting the first data and the second data into first target data and second target data according to a target data format, wherein the target data format is any one of a plurality of preconfigured data formats, and each piece of data in the target first data and the target second data comprises order number information and transaction amount information;
the naming module is used for taking a model of order number information in each piece of data, naming the main keys of the data in the first target data and the second target data according to the obtained model numbers, and storing the first target data and the second target data in a file system;
the comparison module is used for extracting the data with the same main key name in the file system into a Redis memory for comparison so as to determine difference data;
and the generating module is used for generating a reconciliation result according to the difference data.
Optionally, each of the first target data and the second target data further includes a transaction time, and the apparatus further includes:
a storage module, configured to store the target first data and the target second data in a database;
the comparison module further comprises:
the marking module is used for marking the difference data with difference states, and the difference states comprise inconsistent money amount, long-money error and short-money error;
the query module is used for querying whether matched target data exist in the database according to the order number information of the data extracted to the Redis memory at this time under the condition that the difference state is a long-money error or a short-money error;
and the deleting module is used for deleting the difference state marked by the difference data under the condition that the matched target data exists in the database and the transaction time of the target data is within the fault-tolerant time range corresponding to the transaction time of the data extracted to the Redis memory at this time.
Optionally, the storage module comprises:
the module taking module is used for taking a module of order number information in each piece of data and determining a target database and a target data table in the target database from at least one preset database according to the obtained module number;
the storage submodule is used for storing the piece of data into the target data table in the target database;
the query module comprises;
the determining submodule is used for obtaining a target model number by taking a model of the order number information and determining a target database and a target data table for inquiring according to the target model number;
and the query submodule is used for querying the target data table in the target database according to the order number information.
A third aspect of the present disclosure provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the method of any one of the first aspects of the present disclosure.
A fourth aspect of the present disclosure provides an electronic device, comprising:
a memory having a computer program stored thereon;
a processor for executing the computer program in the memory to implement the steps of the method of any one of the first aspect of the present disclosure.
Through the technical scheme, the transaction reconciliation of various downloading modes and file formats can be supported, the development cost is reduced, the rapid deployment can be realized, the work of a plurality of service lines is supported, the stability is high, the reconciliation efficiency is greatly improved by using the cache distributed reconciliation through the mode of taking the mode and naming according to the mode number, a large amount of data can be supported, and the difference data can be rapidly found out to facilitate the further processing of operators.
Additional features and advantages of the disclosure will be set forth in the detailed description which follows.
Drawings
The accompanying drawings, which are included to provide a further understanding of the disclosure and are incorporated in and constitute a part of this specification, illustrate embodiments of the disclosure and together with the description serve to explain the disclosure without limiting the disclosure. In the drawings:
FIG. 1 is a flow diagram illustrating a transaction reconciliation method according to an exemplary embodiment.
FIG. 2 is another flow diagram illustrating a transaction reconciliation method according to an exemplary embodiment.
Fig. 3 is a block diagram illustrating a transaction reconciliation apparatus according to an exemplary embodiment.
FIG. 4 is a block diagram illustrating an electronic device in accordance with an example embodiment.
FIG. 5 is another block diagram illustrating an electronic device according to an example embodiment.
Detailed Description
The following detailed description of specific embodiments of the present disclosure is provided in connection with the accompanying drawings. It should be understood that the detailed description and specific examples, while indicating the present disclosure, are given by way of illustration and explanation only, not limitation.
Fig. 1 is a flowchart illustrating a transaction reconciliation method according to an exemplary embodiment, where an execution subject of the method may be a server or an electronic device such as a personal computer, and the disclosure is not limited thereto. As shown in fig. 1, the method comprises the steps of:
s101, acquiring first data of an upstream data source and second data of a downstream data source according to a target downloading mode, wherein the target downloading mode is any one of a plurality of preset downloading modes.
The upstream can be a bank or other financial institution for providing a channel for receiving and paying funds, and the downstream can be an e-commerce platform or a business operator of the payment receiving company. The downloading mode may include http, https, ftp, sftp, mysql, oracle, and the corresponding class may be matched according to different strategies according to the downloading mode, for example, the target downloading mode is configured as ftp, and then the ftp downloading class is found, and the file is downloaded according to the ftp parameters and the data is analyzed according to the template. And if the query is configured as the database mysql, downloading the class according to the corresponding mysql data source, and returning a field with a result required for account checking according to the database configuration information and the corresponding sql statement by the sql. In one embodiment, the business fields of the first data and the second data, such as transaction type, payment type, commission fee, merchant name, etc., may also be preconfigured, and
s102, converting the first data and the second data into first target data and second target data according to a target data format, wherein the target data format is any one of a plurality of pre-configured data formats, and each of the first target data and the second target data comprises order number information and transaction amount information.
For example, the data format may include xml, json, and csv, that is, for example, the format of the original data format of the acquired first data is xml, and the format of the json format is json, and the json format is configured as the target data format, the xml-formatted first data may be converted into json-formatted first target data by this step.
S103, taking a model of order number information in each piece of data, naming the primary keys of the data in the first target data and the second target data according to the obtained model numbers, and storing the first target data and the second target data in a file system.
Wherein the file system may be a persistent key-value store such as RocksDB. The order number is always integer numerical data, so the data can be stored in a split mode by a mode of taking a modulus, for example, if the order number a is 10077, the order number B is 10078, if the mode is 2, the module number obtained by taking the modulus of the order number a is 10077% 2 being 1, and the module number obtained by taking the modulus of the order number B is 10078% 2 being 0, the primary key name of the order number a in the file system is 1, and the primary key name of the order number B is 0. The selection of the modulus can be selected according to actual service requirements, for example, when the data volume is large, the data can be split into more data groups by increasing the numerical value of the modulus, so that further processing is facilitated.
And S104, extracting the data with the same primary key name in the file system to a Redis memory for comparison so as to determine the difference data.
And S105, generating a reconciliation result according to the difference data.
In the embodiment of the disclosure, transaction reconciliation of multiple downloading modes and file formats can be supported, development cost is reduced, rapid deployment can be realized, work of multiple service lines is supported, stability is high, by means of modulus taking and naming according to a modulus number, reconciliation efficiency is greatly improved by using cache distributed reconciliation, a large amount of data can be supported, and differential data can be rapidly found out to facilitate further processing of operators.
In some optional embodiments, each of the first target data and the second target data further comprises a transaction time, the method further comprising:
storing the target first data and the target second data in a database;
the extracting data with the same primary key name in the file system to a Redis memory for comparison to determine the difference data further comprises:
marking difference states on the difference data, wherein the difference states comprise non-compliance, a long error and a short error;
under the condition that the difference state is a long-line error or a short-line error, whether matched target data exist in the database or not is inquired according to order number information of data extracted to the Redis memory at this time;
and under the condition that the matched target data exists in the database and the transaction time of the target data is in a fault-tolerant time range corresponding to the transaction time of the data extracted to the Redis memory at this time, deleting the difference state marked on the difference data.
The database can be a MySQL relational database or a key-value database with the main key name as an order number, the fault-tolerant time range can be seven days before and two days after the accounting period of long-money data or short-money data, and in addition, after the difference state of the difference data is deleted, the data is not used as the difference data any more.
By adopting the scheme, the difference data can be obtained by comparing the two data with the same main key name, and the difference state of the difference data is marked, so that the difference data can be checked by related workers conveniently. And when the difference state is a long error or a short error, namely the first target data with the same primary key name in the file system has the data but the second target data does not have the data or the second target data has the data but the first target data does not have the data, inquiring the data stored in the database through the order number of the data to determine whether the data has a problem.
For example, since the data stored in the file system may be different from the data stored in the database, for example, only data of 1 month and 1 day exists in the file system, and the database stores the whole amount of data, when there is a long or short error in the data for reconciliation in the file system, for example, when a certain piece of data with an order number of 10077 at the upstream in the file system indicates that the transaction time receives 100 units in 1 month and 1 day, and there is no data with an order number of 10077 in the downstream data, the query database finds that there is data with an order number of 10077 which pays 100 units and has the same order number in 1 month and 5 days, and the difference state of the piece of data can be deleted.
In other optional embodiments, the storing the first target data and the second target data in a database comprises:
taking a module of order number information in each piece of data, and determining a target database and a target data table in the target database from at least one preset database according to the obtained module number;
storing the piece of data into the target data table in the target database;
the step of inquiring whether matched target data exists in the database according to the order number information of the data extracted to the Redis memory data;
obtaining a target model number by taking a model of the order number information, and determining a target database and a target data table for inquiring according to the target model number;
and querying the target data table in the target database according to the order number information.
Illustratively, for example, there are 2 databases, each of which has 2 data tables, the order number a is 10077, the order number B is 10078, and when the module number is 4, the module number of the order number a is 10077% 4 ═ 1, that is, the data corresponding to the order number a is stored in the database 0 data table 1, and the module number of the order number B is 10078% 4 ═ 2, that is, the data corresponding to the order number B is stored in the database 1 data table 0, further, if the module number of the order number C is 0, the corresponding data is stored in the database 0 data table 0, and if the module number of the order number D is 3, the corresponding data is stored in the database 1 table 1.
By adopting the scheme, a large amount of data can be stored in the database-based sub-tables in a mode of taking a modulus, and the database-based sub-tables are independently processed when comparison is carried out, so that the processing speed and accuracy when the data amount is large are improved.
Optionally, each of the first data and the second data further includes an organization number as a unique identifier of an upstream organization, the modulo of the order number information in each piece of data is performed, and naming the primary key of the data in the first target data and the second target data according to the obtained modulo number includes:
and naming the primary key of the data in the first target data and the second target data according to the mechanism number and the model number.
By adopting the scheme, the data of different mechanisms can be distinguished when a plurality of upstream mechanisms check accounts simultaneously, and only the data with the same model number of the mechanism needing to be processed is selected when the account is checked, so that the data confusion of the plurality of mechanisms when the account is checked can be avoided.
Optionally, the generating a reconciliation result according to the difference data includes:
and generating a statement and a settlement file according to the difference data, a target statement template and a target settlement file template, wherein the target statement template is any one of a plurality of preconfigured statement templates, and the target settlement file template is any one of a plurality of preconfigured settlement file templates.
Where the commission for the reconciliation document is calculated here. By adopting the scheme, the fields of the bill display column and the clearing document display column in the bill template can be configured according to actual business requirements, for example, the bill display column and the clearing document display column can comprise a merchant request sheet number, a transaction order number, transaction time, transaction types, payment types, merchant names and the like, the formats of the bill and the clearing document can be configured, including xml and csv, the pushing modes of the bill and the clearing document can be configured, including http, https, ftp and sftp, downstream statement data in various formats can be provided, and the data file can be cleared and can adapt to various business requirements.
Fig. 2 is another flow diagram illustrating a transaction reconciliation method according to an exemplary embodiment, as shown in fig. 2, comprising the steps of:
s201, acquiring first data of an upstream data source and second data of a downstream data source
S202, converting the first data and the second data into first target data and second target data according to the target data format.
S203, taking a module of the first target data and the second target data, and storing the module in a database according to the module number database and the module table.
And S204, taking a module of the first target data and the second target data, and naming and storing the first target data and the second target data in a file system according to the module number and the mechanism number.
S205, extracting the data with the same main key name in the file system to a Redis memory for comparison so as to determine the difference data.
And S206, judging whether the difference data is long data or short data or not according to one piece of difference data in the difference data.
If the difference data is the long data or the short data, step S207 and step S208 are executed.
And S207, determining a target database and a target data table to be inquired according to the order number information of the difference data.
S208, inquiring whether the target data table in the target database has matched target data.
S209, judging whether the target data table in the target database has matched target data or not and the transaction time is in the fault-tolerant time range.
In the case where there is matching target data and the transaction time is within the fault-tolerant time range, step S210 and step S211 are performed.
S210, deleting the difference state marked on the difference data.
And S211, generating a reconciliation result according to the difference data.
In addition, in the case that it is determined in step S206 that the difference data is not long data or short data, manual review may be performed to determine whether the difference data is real difference data, and step S211 is executed after the determination, and those skilled in the art should understand that step S211 is executed in any case, and the steps in other cases of S206 and S209 are not shown in the embodiment of the present disclosure, and do not represent that step S211 is not executed in some cases. In the embodiment of the disclosure, transaction reconciliation of multiple downloading modes and file formats can be supported, development cost is reduced, rapid deployment can be realized, work of multiple service lines is supported, stability is high, by means of modulus taking and naming according to a modulus number, reconciliation efficiency is greatly improved by using cache distributed reconciliation, a large amount of data can be supported, and differential data can be rapidly found out to facilitate further processing of operators.
Fig. 3 is a block diagram illustrating a transaction reconciliation apparatus 30 according to an exemplary embodiment, the apparatus 30, as shown in fig. 3, comprising:
the downloading module 31 is configured to obtain first data of an upstream data source and second data of a downstream data source according to a target downloading manner, where the target downloading manner is any one of multiple preset downloading manners;
the conversion module 2 is configured to convert the first data and the second data into first target data and second target data according to a target data format, where the target data format is any one of multiple preconfigured data formats, and each piece of data in the target first data and the target second data includes order number information and transaction amount information;
the naming module 33 is configured to modulo the order number information in each piece of data, name the primary key of the data in the first target data and the second target data according to the obtained modulo number, and store the first target data and the second target data in a file system;
a comparison module 34, configured to extract data with the same primary key name in the file system into a Redis memory for comparison, so as to determine difference data;
and the generating module 35 is configured to generate a reconciliation result according to the difference data.
Optionally, each of the first target data and the second target data further includes a transaction time, and the apparatus further includes:
a storage module, configured to store the target first data and the target second data in a database;
the comparison module 34 further includes:
the marking module is used for marking the difference data with difference states, and the difference states comprise inconsistent money amount, long-money error and short-money error;
the query module is used for querying whether matched target data exist in the database according to the order number information of the data extracted to the Redis memory at this time under the condition that the difference state is a long-money error or a short-money error;
and the deleting module is used for deleting the difference state marked by the difference data under the condition that the matched target data exists in the database and the transaction time of the target data is within the fault-tolerant time range corresponding to the transaction time of the data extracted to the Redis memory at this time.
Optionally, the storage module comprises:
the module taking module is used for taking a module of order number information in each piece of data and determining a target database and a target data table in the target database from at least one preset database according to the obtained module number;
the storage submodule is used for storing the piece of data into the target data table in the target database;
the query module comprises;
the determining submodule is used for obtaining a target model number by taking a model of the order number information and determining a target database and a target data table for inquiring according to the target model number;
and the query submodule is used for querying the target data table in the target database according to the order number information.
Optionally, each of the first data and the second data further includes an organization number as a unique identifier of an upstream organization, and the naming module 33 is further configured to:
and naming the primary key of the data in the first target data and the second target data according to the mechanism number and the model number.
Optionally, the generating module 35 is specifically configured to:
and generating a statement and a settlement file according to the difference data, a target statement template and a target settlement file template, wherein the target statement template is any one of a plurality of preconfigured statement templates, and the target settlement file template is any one of a plurality of preconfigured settlement file templates.
In the embodiment of the disclosure, transaction reconciliation of multiple downloading modes and file formats can be supported, development cost is reduced, rapid deployment can be realized, work of multiple service lines is supported, stability is high, by means of modulus taking and naming according to a modulus number, reconciliation efficiency is greatly improved by using cache distributed reconciliation, a large amount of data can be supported, and differential data can be rapidly found out to facilitate further processing of operators.
With regard to the apparatus in the above-described embodiment, the specific manner in which each module performs the operation has been described in detail in the embodiment related to the method, and will not be elaborated here.
Fig. 4 is a block diagram illustrating an electronic device 40 according to an example embodiment. As shown in fig. 4, the electronic device 40 may include: a processor 41 and a memory 42. The electronic device 40 may also include one or more of a multimedia component 43, an input/output (I/O) interface 44, and a communications component 45.
The processor 41 is configured to control the overall operation of the electronic device 40, so as to complete all or part of the steps of the transaction reconciliation method. The memory 42 is used to store various types of data to support operation at the electronic device 40, such data may include, for example, instructions for any application or method operating on the electronic device 40, as well as application-related data, such as contact data, downloaded upstream and downstream reconciliation data, difference data, generated statements, clearing files, and so forth. The Memory 42 may be implemented by any type of volatile or non-volatile Memory device or combination thereof, such as Static Random Access Memory (SRAM), Electrically Erasable Programmable Read-Only Memory (EEPROM), Erasable Programmable Read-Only Memory (EPROM), Programmable Read-Only Memory (PROM), Read-Only Memory (ROM), magnetic Memory, flash Memory, magnetic disk or optical disk. The multimedia components 43 may include a screen and an audio component. Wherein the screen may be, for example, a touch screen and the audio component is used for outputting and/or inputting audio signals. For example, the audio component may include a microphone for receiving external audio signals. The received audio signals may further be stored in the memory 42 or transmitted through the communication component 45. The audio assembly also includes at least one speaker for outputting audio signals. The I/O interface 44 provides an interface between the processor 41 and other interface modules, such as a keyboard, mouse, buttons, etc. These buttons may be virtual buttons or physical buttons. The communication component 45 is used for wired or wireless communication between the electronic device 40 and other devices. Wireless Communication, such as Wi-Fi, bluetooth, Near Field Communication (NFC), 2G, 3G, 4G, NB-IOT, eMTC, or other 5G, etc., or a combination of one or more of them, which is not limited herein. The corresponding communication component 45 may thus comprise: Wi-Fi module, Bluetooth module, NFC module, etc.
In an exemplary embodiment, the electronic Device 40 may be implemented by one or more Application Specific Integrated Circuits (ASICs), Digital Signal Processors (DSPs), Digital Signal Processing Devices (DSPDs), Programmable Logic Devices (PLDs), Field Programmable Gate Arrays (FPGAs), controllers, microcontrollers, microprocessors, or other electronic components for performing the transaction reconciliation method described above.
In another exemplary embodiment, a computer readable storage medium comprising program instructions which, when executed by a processor, implement the steps of the transaction reconciliation method described above is also provided. For example, the computer readable storage medium may be the memory 42 described above including program instructions executable by the processor 41 of the electronic device 40 to perform the transaction reconciliation method described above.
Fig. 5 is a block diagram illustrating an electronic device 50 according to an example embodiment. For example, the electronic device 50 may be provided as a server. Referring to fig. 5, the electronic device 50 comprises a processor 51, which may be one or more in number, and a memory 52 for storing computer programs executable by the processor 51. The computer program stored in memory 52 may include one or more modules that each correspond to a set of instructions. Further, the processor 51 may be configured to execute the computer program to perform the transaction reconciliation method described above.
Additionally, the electronic device 50 may also include a power component 53 and a communication component 54, the power component 53 may be configured to perform power management of the electronic device 50, and the communication component 54 may be configured to enable communication, e.g., wired or wireless communication, of the electronic device 50. The electronic device 50 may also include an input/output (I/O) interface 55. The electronic device 50 may operate based on an operating system, such as Windows Server, stored in the memory 52TM，Mac OS XTM，UnixTM，LinuxTMAnd so on.
In another exemplary embodiment, a computer readable storage medium comprising program instructions which, when executed by a processor, implement the steps of the transaction reconciliation method described above is also provided. For example, the computer readable storage medium may be the memory 52 described above including program instructions executable by the processor 51 of the electronic device 50 to perform the transaction reconciliation method described above.
In another exemplary embodiment, a computer program product is also provided, which comprises a computer program executable by a programmable apparatus, the computer program having code portions for performing the above-described transaction reconciliation method when executed by the programmable apparatus.
The preferred embodiments of the present disclosure are described in detail with reference to the accompanying drawings, however, the present disclosure is not limited to the specific details of the above embodiments, and various simple modifications may be made to the technical solution of the present disclosure within the technical idea of the present disclosure, and these simple modifications all belong to the protection scope of the present disclosure.
It should be noted that, in the foregoing embodiments, various features described in the above embodiments may be combined in any suitable manner, and in order to avoid unnecessary repetition, various combinations that are possible in the present disclosure are not described again.
In addition, any combination of various embodiments of the present disclosure may be made, and the same should be considered as the disclosure of the present disclosure, as long as it does not depart from the spirit of the present disclosure.

Claims (10)

1. A transaction reconciliation method, the method comprising:
acquiring first data of an upstream data source and second data of a downstream data source according to a target downloading mode, wherein the target downloading mode is any one of a plurality of preset downloading modes;
converting the first data and the second data into first target data and second target data according to a target data format, wherein the target data format is any one of a plurality of preconfigured data formats, and each piece of data in the target first data and the target second data comprises order number information and transaction amount information;
taking a model of order number information in each piece of data, naming a primary key of data in the first target data and the second target data according to the obtained model number, and storing the first target data and the second target data in a file system;
extracting data with the same main key name in the file system to a Redis memory for comparison so as to determine difference data;
and generating a reconciliation result according to the difference data.
2. The method of claim 1, wherein each of the first target data and the second target data further comprises a transaction time, the method further comprising:
storing the target first data and the target second data in a database;
the extracting data with the same primary key name in the file system to a Redis memory for comparison to determine the difference data further comprises:
marking difference states on the difference data, wherein the difference states comprise non-compliance, a long error and a short error;
under the condition that the difference state is a long-line error or a short-line error, whether matched target data exist in the database or not is inquired according to order number information of data extracted to the Redis memory at this time;
and under the condition that the matched target data exists in the database and the transaction time of the target data is in a fault-tolerant time range corresponding to the transaction time of the data extracted to the Redis memory at this time, deleting the difference state marked on the difference data.
3. The method of claim 2, wherein storing the first and second target data in a database comprises:
taking a module of order number information in each piece of data, and determining a target database and a target data table in the target database from at least one preset database according to the obtained module number;
storing the piece of data into the target data table in the target database;
the step of inquiring whether matched target data exists in the database according to the order number information of the data extracted to the Redis memory data;
obtaining a target model number by taking a model of the order number information, and determining a target database and a target data table for inquiring according to the target model number;
and querying the target data table in the target database according to the order number information.
4. The method according to any one of claims 1 to 3, wherein each of the first data and the second data further includes an organization number as a unique identifier of an upstream organization, the modulo of the order number information in each of the data, and the naming of the primary key of the data in the first target data and the second target data according to the obtained modulo number includes:
and naming the primary key of the data in the first target data and the second target data according to the mechanism number and the model number.
5. The method according to any one of claims 1-3, wherein generating a reconciliation result from the difference data comprises:
and generating a statement and a settlement file according to the difference data, a target statement template and a target settlement file template, wherein the target statement template is any one of a plurality of preconfigured statement templates, and the target settlement file template is any one of a plurality of preconfigured settlement file templates.
6. A transaction reconciliation apparatus, the apparatus comprising:
the system comprises a downloading module, a processing module and a processing module, wherein the downloading module is used for acquiring first data of an upstream data source and second data of a downstream data source according to a target downloading mode, and the target downloading mode is any one of a plurality of preset downloading modes;
the conversion module is used for converting the first data and the second data into first target data and second target data according to a target data format, wherein the target data format is any one of a plurality of preconfigured data formats, and each piece of data in the target first data and the target second data comprises order number information and transaction amount information;
the naming module is used for taking a model of order number information in each piece of data, naming the main keys of the data in the first target data and the second target data according to the obtained model numbers, and storing the first target data and the second target data in a file system;
the comparison module is used for extracting the data with the same main key name in the file system into a Redis memory for comparison so as to determine difference data;
and the generating module is used for generating a reconciliation result according to the difference data.
7. The apparatus of claim 6, wherein each of the first target data and the second target data further comprises a transaction time, the apparatus further comprising:
a storage module, configured to store the target first data and the target second data in a database;
the comparison module further comprises:
the marking module is used for marking the difference data with difference states, and the difference states comprise inconsistent money amount, long-money error and short-money error;
the query module is used for querying whether matched target data exist in the database according to the order number information of the data extracted to the Redis memory at this time under the condition that the difference state is a long-money error or a short-money error;
and the deleting module is used for deleting the difference state marked by the difference data under the condition that the matched target data exists in the database and the transaction time of the target data is within the fault-tolerant time range corresponding to the transaction time of the data extracted to the Redis memory at this time.
8. The apparatus of claim 7, wherein the storage module comprises:
the module taking module is used for taking a module of order number information in each piece of data and determining a target database and a target data table in the target database from at least one preset database according to the obtained module number;
the storage submodule is used for storing the piece of data into the target data table in the target database;
the query module comprises;
the determining submodule is used for obtaining a target model number by taking a model of the order number information and determining a target database and a target data table for inquiring according to the target model number;
and the query submodule is used for querying the target data table in the target database according to the order number information.
9. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 5.
10. An electronic device, comprising:
a memory having a computer program stored thereon;
a processor for executing the computer program in the memory to carry out the steps of the method of any one of claims 1 to 5.
CN202011554036.6A 2020-12-24 2020-12-24 Transaction checking method and device, storage medium and electronic equipment Active CN112685484B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011554036.6A CN112685484B (en) 2020-12-24 2020-12-24 Transaction checking method and device, storage medium and electronic equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011554036.6A CN112685484B (en) 2020-12-24 2020-12-24 Transaction checking method and device, storage medium and electronic equipment

Publications (2)

Publication Number Publication Date
CN112685484A true CN112685484A (en) 2021-04-20
CN112685484B CN112685484B (en) 2023-08-29

Family

ID=75452948

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011554036.6A Active CN112685484B (en) 2020-12-24 2020-12-24 Transaction checking method and device, storage medium and electronic equipment

Country Status (1)

Country Link
CN (1) CN112685484B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113626510A (en) * 2021-08-11 2021-11-09 中国银行股份有限公司 Transaction checking method, device, electronic equipment and storage medium

Citations (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7340421B1 (en) * 2000-12-22 2008-03-04 General Electric Company Account reconciliation methods and systems
US20120136789A1 (en) * 2008-03-24 2012-05-31 Propay Usa Inc. Secure payment system
US20140101025A1 (en) * 2012-10-10 2014-04-10 Mobibucks Corp. Accounts with multiple pre-authorization levels
CN105741168A (en) * 2014-12-09 2016-07-06 航天信息股份有限公司 Liquidation management system and method
US20170039553A1 (en) * 2015-08-04 2017-02-09 Accenture Global Services Limited Data reconciliation
US20170270493A1 (en) * 2016-03-21 2017-09-21 Mastercard International Incorporated Method and system for recording point to point transaction processing
US20170286929A1 (en) * 2016-03-30 2017-10-05 Mastercard International Incorporated Method and system for digital money management for a payment account
CN107729553A (en) * 2017-11-07 2018-02-23 北京京东金融科技控股有限公司 System data account checking method and device, storage medium, electronic equipment
US20190050400A1 (en) * 2017-08-11 2019-02-14 Wipro Limited Method and system for data conversion and data model optimization
CN110084690A (en) * 2019-03-18 2019-08-02 深圳壹账通智能科技有限公司 Data processing method, device, computer installation and storage medium
US20190385135A1 (en) * 2018-06-14 2019-12-19 Mastercard International Incorporated Transaction device, computer program and transaction method
CN110706105A (en) * 2019-09-19 2020-01-17 北京三快在线科技有限公司 Error marking method, error marking device, computer equipment and storage medium
CN111899011A (en) * 2020-07-29 2020-11-06 广州海鹚网络科技有限公司 Medical bill reconciliation system, computer equipment and storage medium

Patent Citations (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7340421B1 (en) * 2000-12-22 2008-03-04 General Electric Company Account reconciliation methods and systems
US20120136789A1 (en) * 2008-03-24 2012-05-31 Propay Usa Inc. Secure payment system
US20140101025A1 (en) * 2012-10-10 2014-04-10 Mobibucks Corp. Accounts with multiple pre-authorization levels
CN105741168A (en) * 2014-12-09 2016-07-06 航天信息股份有限公司 Liquidation management system and method
US20170039553A1 (en) * 2015-08-04 2017-02-09 Accenture Global Services Limited Data reconciliation
US20170270493A1 (en) * 2016-03-21 2017-09-21 Mastercard International Incorporated Method and system for recording point to point transaction processing
US20170286929A1 (en) * 2016-03-30 2017-10-05 Mastercard International Incorporated Method and system for digital money management for a payment account
US20190050400A1 (en) * 2017-08-11 2019-02-14 Wipro Limited Method and system for data conversion and data model optimization
CN107729553A (en) * 2017-11-07 2018-02-23 北京京东金融科技控股有限公司 System data account checking method and device, storage medium, electronic equipment
US20190385135A1 (en) * 2018-06-14 2019-12-19 Mastercard International Incorporated Transaction device, computer program and transaction method
CN110084690A (en) * 2019-03-18 2019-08-02 深圳壹账通智能科技有限公司 Data processing method, device, computer installation and storage medium
CN110706105A (en) * 2019-09-19 2020-01-17 北京三快在线科技有限公司 Error marking method, error marking device, computer equipment and storage medium
CN111899011A (en) * 2020-07-29 2020-11-06 广州海鹚网络科技有限公司 Medical bill reconciliation system, computer equipment and storage medium

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113626510A (en) * 2021-08-11 2021-11-09 中国银行股份有限公司 Transaction checking method, device, electronic equipment and storage medium
CN113626510B (en) * 2021-08-11 2024-02-13 中国银行股份有限公司 Transaction verification method, device, electronic equipment and storage medium

Also Published As

Publication number Publication date
CN112685484B (en) 2023-08-29

Similar Documents

Publication Publication Date Title
CN108346028B (en) Business approval processing method, device and system
CN110532536B (en) Rule configuration method and device
CN112204557A (en) System and method for automated decentralized multilateral transaction processing
CN109241068B (en) Method and device for comparing foreground and background data and terminal equipment
CN111061833A (en) Data processing method and device, electronic equipment and computer readable storage medium
CN109670943B (en) Settlement system, settlement method, computer equipment and storage medium
CN114064112A (en) Business process configuration method, device, equipment and storage medium
CN111553656A (en) Capital settlement method and device based on big data, electronic equipment and medium
CN110879808B (en) Information processing method and device
CN112434982A (en) Task processing method, device and system, storage medium and electronic equipment
CN112685484B (en) Transaction checking method and device, storage medium and electronic equipment
CN110033362B (en) Money drawing method, device and equipment
US9613072B2 (en) Cross platform data validation utility
CN112039975A (en) Method, device, equipment and storage medium for processing message field
US9483660B2 (en) Enterprise content management platform validator
CN115809228A (en) Data comparison method and device, storage medium and electronic equipment
CN110347657A (en) Data creation method, device, electronic equipment and storage medium
JP6588988B2 (en) Business program generation support system and business program generation support method
CN114416895A (en) Map data processing method and device, electronic equipment and storage medium
CN113190562A (en) Report generation method and device and electronic equipment
CN111445330A (en) Account checking method and device
CN116610591B (en) Method, device, system and medium for generating test data and call statement
CN112685437A (en) Configuration-based commission calculation method, device, equipment and storage medium
CN112907223A (en) Method and device for processing service information
CN109388785B (en) Text screening method and device

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant