CN118115300A

CN118115300A - Order record reconciliation method and device, electronic equipment and storage medium

Info

Publication number: CN118115300A
Application number: CN202410229192.7A
Authority: CN
Inventors: 林培晖
Original assignee: Beijing QIYI Century Science and Technology Co Ltd
Current assignee: Beijing QIYI Century Science and Technology Co Ltd
Priority date: 2024-02-29
Filing date: 2024-02-29
Publication date: 2024-05-31

Abstract

The embodiment of the application provides an order record reconciliation method, an order record reconciliation device, electronic equipment and a storage medium, wherein the method comprises the following steps: when a trigger instruction aiming at a reconciliation task to be processed is received, acquiring reconciliation information of a first subsystem and a second subsystem to be reconciled in a transaction system indicated by the reconciliation task to be processed; according to the first storage address and the second storage address, respectively acquiring each stored order record from the first subsystem and the second subsystem; for each order record, acquiring a field with a field type of a first field type in the order record as a main key field corresponding to the order record; and comparing the first order record with the second order record based on the main key field to obtain a comparison result. For any two subsystems in the transaction system, the electronic equipment can adopt the general comparison flow to compare, a new comparison program is not required to be developed, the universality of the account checking method is improved, and the program development workload is reduced.

Description

Order record reconciliation method and device, electronic equipment and storage medium

Technical Field

The present application relates to the field of order information processing technologies, and in particular, to an order record reconciliation method, an apparatus, an electronic device, and a storage medium.

Background

For the transaction system, the transaction system may include a plurality of subsystems such as a user ordering system, a payment center, an external cooperation system, a cloud ticket system, a gift buying system and the like, and a new subsystem may be further added later. For the same order, the corresponding order records may be stored in multiple subsystems, for example, when the user purchases a benefit, the user placing the order records of the order may include information such as order number, payment amount, and type of benefit. The payment center also stores an order record of the order, wherein the order record may include information such as an order number, a payment amount, and a payment method.

When abnormal conditions of losing order records in the subsystems or inconsistent order information of the same type of the same order recorded by each subsystem occur, normal operation of the service is affected, and great trouble is brought to users and service providers.

In order to find out the abnormal situation in time, the current practice is to design a special order record checking program for the two subsystems according to the characteristics of order records stored in the two subsystems. However, the reconciliation procedure is only suitable for comparing order records between the two subsystems, and can not compare order records of other subsystems, so that the generality is poor, and the program development workload is large.

Disclosure of Invention

The embodiment of the application aims to provide an order record checking method, an order record checking device, electronic equipment and a storage medium, so that the universality of the order record checking method is improved, and the workload of program development is reduced. The specific technical scheme is as follows:

In a first aspect, an embodiment of the present application provides an order record reconciliation method, where the method includes:

When a trigger instruction for a to-be-processed reconciliation task is received, acquiring reconciliation information of a first subsystem and a second subsystem to be reconciled in a transaction system indicated by the to-be-processed reconciliation task, wherein the reconciliation information at least comprises: a first storage address of an order record in the first subsystem, a second storage address of the order record in the second subsystem and a preset first field type, wherein the first field type is determined in advance based on field types of order identifications of the order records stored in all subsystems in the transaction system, and the first subsystem and the second subsystem are any two subsystems in the transaction system;

Acquiring each stored order record from the first subsystem according to the first storage address, and acquiring each stored order record from the second subsystem according to the second storage address;

For each order record, acquiring a field with the field type of the first field type in the order record as a main key field corresponding to the order record;

And comparing the first order record with the second order record based on the primary key field to obtain a comparison result, wherein the first order record is the order record obtained from the first subsystem, and the second order record is the order record obtained from the second subsystem.

Optionally, the reconciliation information further includes a second field type, where the second field type is determined in advance based on field types of other reconciliation to be performed except for the order identifier of the order record stored in each subsystem in the transaction system;

before the comparing the first order record with the second order record based on the primary key field to obtain a comparison result, the method further comprises:

for each order record, acquiring a field with the field type of the second field type in the order record as a comparison field corresponding to the order record;

Based on the primary key field, the first order record and the second order record are compared to obtain a comparison result, which comprises the following steps:

And comparing the first order record with the second order record based on the main key field and the comparison field to obtain a comparison result.

Optionally, the reconciliation information further includes a first data source interface of the first subsystem and a second data source interface of the second subsystem, where the first data source interface is used for characterizing an acquisition mode of an order record in the first subsystem, and the second data source interface is used for characterizing an acquisition mode of an order record in the second subsystem;

The step of obtaining the stored order records from the first subsystem according to the first storage address and obtaining the stored order records from the second subsystem according to the second storage address comprises the following steps:

And calling the first data source interface, acquiring each stored order record from the first subsystem according to the acquisition mode represented by the first data source interface and the first storage address, calling the second data source interface, and acquiring each stored order record from the second subsystem according to the acquisition mode represented by the second data source interface and the second storage address.

Optionally, the account checking information further includes an alignment mark;

and comparing the first order record with the second order record based on the main key field by the comparison mode indicated by the comparison mode identification to obtain a comparison result.

Optionally, when the comparison method identifier is the first identifier, the comparing method indicated by the comparison method identifier is based on the primary key field, and the comparing method includes:

For each first order record, judging whether a second order record with the same corresponding main key field as the main key field of the first order record exists, if not, determining the first order record as an abnormal order record;

Or alternatively, the first and second heat exchangers may be,

And under the condition that the comparison method identifier is a second identifier, comparing the first order record with the second order record based on the main key field by the comparison method indicated by the comparison method identifier to obtain a comparison result, wherein the comparison method comprises the following steps:

Judging whether a second order record with the same main key field as the main key field of the first order record exists or not according to each first order record, if not, determining the first order record as an abnormal order record, and if not, determining the second order record as an abnormal order record;

Or alternatively, the first and second heat exchangers may be,

The reconciliation information further includes a second field type, where the second field type is determined in advance based on field types of other to-be-reconciled order records stored in each subsystem in the transaction system, and when the comparison mode is the third identification, the comparison mode indicated by the comparison mode identification is based on the primary key field, and the comparing result is obtained by comparing the first order record with the second order record, and includes:

judging whether a second order record with the same corresponding main key field as the main key field of the first order record exists or not according to each first order record, if no second order record with the same corresponding main key field as the main key field of the first order record exists, determining the first order record as an abnormal order record, if a second order record with the same corresponding main key field as the main key field of the first order record exists, respectively acquiring fields with the field types of the second field types in the first order record and the first target order record as comparison fields corresponding to the first order record and the first target order record, judging whether the comparison fields in the first order record are consistent with the comparison fields in the first target order record, and if not, determining the first order record as the abnormal order record, wherein the first target order record is the second order record with the same corresponding main key field as the main key field of the first order record;

Or alternatively, the first and second heat exchangers may be,

The reconciliation information further includes a second field type, where the second field type is determined in advance based on field types of other reconciliation required except for the order identifier of the order records stored in each subsystem in the transaction system, and when the comparison method identifier is the fourth identifier, the comparison method indicated by the comparison method identifier is based on the main key field, and the comparing result is obtained by comparing the first order record with the second order record, and includes:

If a second order record with the same main key field as the main key field of the first order record exists, respectively acquiring fields with the field types of the second field types in the first order record and the first target order record as comparison fields corresponding to the first order record and the first target order record, judging whether the comparison fields in the first order record are consistent with the comparison fields in the first target order record, and if not, determining the first order record as an abnormal order record, wherein the first target order record is the second order record with the same main key field as the main key field of the first order record; and/or if a first order record with the same main key field as the main key field of the second order record exists, respectively acquiring fields with the field types of the second field types in the second order record and the second target order record as comparison fields corresponding to the second order record and the second target order record, judging whether the comparison fields in the second order record are consistent with the comparison fields in the second target order record, and if not, determining the second order record as an abnormal order record, wherein the second target order record is the first order record with the same main key field as the main key field of the second order record.

Optionally, the reconciliation information further includes a time period;

When a trigger instruction for a to-be-processed reconciliation task is received, acquiring reconciliation information of a first subsystem and a second subsystem to be reconciled in a transaction system indicated by the to-be-processed reconciliation task, including:

When the time difference between the current time point and the time point of executing the to-be-processed reconciliation task last time meets the time period, determining that a trigger instruction for the to-be-processed reconciliation task is received, and acquiring reconciliation information of a first subsystem and a second subsystem to be reconciled in a transaction system indicated by the to-be-processed reconciliation task; or alternatively, the first and second heat exchangers may be,

When an input trigger signal aiming at a to-be-processed reconciliation task is received, determining that a trigger instruction aiming at the to-be-processed reconciliation task is received, and acquiring reconciliation information of a first subsystem and a second subsystem to be reconciled in a transaction system indicated by the to-be-processed reconciliation task.

Optionally, the account checking information further includes manager information;

after the comparison is performed on the first order record and the second order record based on the primary key field to obtain a comparison result, the method further comprises:

and sending the comparison result to information receiving equipment of a manager according to the manager information so that the manager can process the comparison result.

Optionally, before the accounting information of the first subsystem and the second subsystem to be checked in the transaction system indicated by the task to be checked is obtained when the trigger instruction for the task to be checked is received, the method further includes:

Displaying a task configuration interface, wherein the task configuration interface at least comprises: a first field type setting component and a storage address setting component;

And creating each to-be-processed reconciliation task and reconciliation information corresponding to each to-be-processed reconciliation task based on setting operation of a setting component in the task configuration interface by a user, wherein the setting operation at least comprises a first field type setting operation sent by the user based on the first field type setting component and a storage address setting operation sent by the user based on the storage address setting component.

Optionally, the task configuration interface further includes a data source interface setting component, the reconciliation information further includes a first data source interface of the first subsystem and a second data source interface of the second subsystem, which are set by the data source interface setting component in advance, the first data source interface is used for characterizing an acquisition mode of an order record in the first subsystem, and the second data source interface is used for characterizing an acquisition mode of an order record in the second subsystem;

The creating each pending reconciliation task and the reconciliation information corresponding to each pending reconciliation task based on the setting operation of the setting component in the task configuration interface by the user includes:

Determining a subsystem in a transaction system indicated by a currently-to-be-created pending reconciliation task as a target subsystem based on a setting operation of a user on a setting component in the task configuration interface;

Judging whether the target subsystem exists in the subsystems in the transaction system indicated by the created to-be-processed reconciliation task;

And if the target to-be-processed reconciliation task exists, the data source interface of the target subsystem corresponding to the target to-be-processed reconciliation task is used as the data source interface of the target subsystem corresponding to the current to-be-created reconciliation task, wherein the target to-be-processed reconciliation task is the created to-be-processed reconciliation task of the target subsystem in the indicated subsystem in the transaction system.

Optionally, the task configuration interface further comprises at least one of the following setup components:

A second field type setting component, wherein when the task configuration interface further comprises the second field type setting component, the reconciliation information further comprises a second field type set by the second field type setting component in advance, the second field type is determined in advance based on other field types to be reconciled of order records stored in each subsystem in the transaction system, except for an order identifier;

The data source interface setting component is used for representing the acquisition mode of the order record in the first subsystem, and the reconciliation information also comprises a first data source interface of the first subsystem and a second data source interface of the second subsystem, which are preset based on the data source interface setting component, wherein the first data source interface is used for representing the acquisition mode of the order record in the first subsystem;

The account checking information also comprises an comparison mode identification which is preset based on the comparison mode setting component under the condition that the task configuration interface also comprises the comparison mode setting component;

A time period setting component, wherein when the task configuration interface further comprises the time period setting component, the reconciliation information further comprises a time period set by the time period setting component in advance;

And the manager setting component is used for setting the reconciliation information according to the preset manager information of the manager setting component when the task configuration interface further comprises the manager setting component.

In a second aspect, an embodiment of the present application provides an order record reconciliation device, including:

The system comprises a checking information acquisition module, a checking information processing module and a checking information processing module, wherein the checking information acquisition module is used for acquiring checking information of a first subsystem and a second subsystem to be checked in a transaction system indicated by a to-be-processed checking task when a trigger instruction for the to-be-processed checking task is received, and the checking information at least comprises: a first storage address of an order record in the first subsystem, a second storage address of the order record in the second subsystem and a preset first field type, wherein the first field type is determined in advance based on field types of order identifications of the order records stored in all subsystems in the transaction system, and the first subsystem and the second subsystem are any two subsystems in the transaction system;

the order record acquisition module is used for acquiring each stored order record from the first subsystem according to the first storage address and acquiring each stored order record from the second subsystem according to the second storage address;

The primary key field acquisition module is used for acquiring a field with a field type of the first field type in each order record as a primary key field corresponding to the order record;

and the order record comparison module is used for comparing a first order record with a second order record based on the primary key field to obtain a comparison result, wherein the first order record is an order record obtained from the first subsystem, and the second order record is an order record obtained from the second subsystem.

In a third aspect, an embodiment of the present application provides an electronic device, including a processor, a communication interface, a memory, and a communication bus, where the processor, the communication interface, and the memory complete communication with each other through the communication bus;

a memory for storing a computer program;

A processor configured to implement the method according to any one of the first aspect when executing a program stored in the memory.

In a fourth aspect, embodiments of the present application provide a computer readable storage medium having a computer program stored therein, which when executed by a processor implements the method of any of the first aspects.

In the scheme provided by the embodiment of the application, when receiving the trigger instruction for the to-be-processed reconciliation task, the electronic device can acquire the reconciliation information of the first subsystem and the second subsystem to be reconciled in the transaction system indicated by the to-be-processed reconciliation task, wherein the reconciliation information at least comprises: the method comprises the steps that a first storage address of an order record in a first subsystem, a second storage address of the order record in a second subsystem and a preset first field type are determined in advance based on field types of order identifications of the order records stored in all subsystems in a transaction system, and the first subsystem and the second subsystem are any two subsystems in the transaction system; acquiring each stored order record from the first subsystem according to the first storage address, and acquiring each stored order record from the second subsystem according to the second storage address; for each order record, acquiring a field with a field type of a first field type in the order record as a main key field corresponding to the order record; and comparing the first order record with the second order record based on the primary key field to obtain a comparison result, wherein the first order record is the order record obtained from the first subsystem, and the second order record is the order record obtained from the second subsystem. For any two subsystems in the transaction system, the electronic equipment can adopt a general comparison flow to compare, namely, according to a preset first field type and a preset storage address, order records in the two subsystems are obtained, a main key field used for representing order identification in the order records is determined, and then the order records in the two subsystems are compared based on the main key field. Even when the comparison task among other subsystems is newly added, only the corresponding first field type and storage address are required to be configured, a new comparison program is not required to be developed, the universality of an order record checking method is improved, and the program development workload is reduced.

Drawings

In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below.

FIG. 1 is a flow chart of an order record reconciliation method provided by an embodiment of the application;

FIG. 2 is a flow chart of a task creation style based on the embodiment shown in FIG. 1;

FIG. 3 is a specific flow chart of a task creation mode based on the embodiment shown in FIG. 2;

FIG. 4 is a flow chart of an alignment based on the embodiment shown in FIG. 2;

FIG. 5 is a flow chart of another alignment method based on the embodiment shown in FIG. 2;

FIG. 6 is a flow chart of yet another alignment method based on the embodiment shown in FIG. 2;

FIG. 7 is a flow chart of yet another alignment method based on the embodiment shown in FIG. 2;

FIG. 8 is a schematic diagram of a task configuration interface based on the embodiment shown in FIG. 2;

FIG. 9 is a schematic diagram of a task display interface based on the embodiment shown in FIG. 1;

Fig. 10 is a schematic structural diagram of an order record reconciliation device according to an embodiment of the application;

fig. 11 is a schematic structural diagram of an electronic device according to an embodiment of the present application.

Detailed Description

The technical solutions in the embodiments of the present application will be described below with reference to the accompanying drawings in the embodiments of the present application.

In order to improve the universality of the order record checking method and reduce the workload of program development, the embodiment of the application provides an order record checking method, an order record checking device, electronic equipment, a computer readable storage medium and a computer program product.

The order record checking method provided by the embodiment of the application can be applied to any electronic equipment, such as terminal equipment or a server, which needs to check the order records stored in each subsystem in a transaction system, and is not particularly limited herein, and is hereinafter referred to as electronic equipment for clarity of description.

As shown in fig. 1, a method for checking order records, the method comprising:

S101, when a trigger instruction for a to-be-processed reconciliation task is received, acquiring reconciliation information of a first subsystem and a second subsystem to be reconciled in a transaction system indicated by the to-be-processed reconciliation task.

Wherein, the reconciliation information comprises at least: the method comprises the steps of storing a first storage address of an order record in a first subsystem, a second storage address of the order record in a second subsystem and a preset first field type, wherein the first field type is determined in advance based on field types of order identifications of the order records stored in all subsystems in the transaction system, and the first subsystem and the second subsystem are any two subsystems in the transaction system.

S102, acquiring the stored order records from the first subsystem according to the first storage address, and acquiring the stored order records from the second subsystem according to the second storage address.

S103, for each order record, acquiring a field with the field type of the first field type in the order record as a main key field corresponding to the order record.

And S104, comparing the first order record with the second order record based on the primary key field to obtain a comparison result.

The first order record is an order record acquired from the first subsystem, and the second order record is an order record acquired from the second subsystem.

The electronic device may store each to-be-processed reconciliation task and reconciliation information corresponding to each to-be-processed reconciliation task in advance, where the reconciliation information corresponding to each to-be-processed reconciliation task may include each subsystem in the transaction system that needs to perform order record reconciliation, and reconciliation information between the subsystems.

For example, the reconciliation information corresponding to the pending reconciliation task a may include the subsystem 1 and the subsystem 2, the subsystem 2 and the subsystem 3, and the reconciliation information between the subsystem 1 and the subsystem 2, and the reconciliation information between the subsystem 2 and the subsystem 3, which are required to perform the order record reconciliation.

The electronic equipment can receive the triggering instruction aiming at the to-be-processed reconciliation task in a mode of self triggering or receiving an external signal, and when the triggering instruction aiming at any to-be-processed reconciliation task is received, the electronic equipment can determine a first subsystem and a second subsystem corresponding to the to-be-processed reconciliation task, and further can acquire a first storage address of an order record in the first subsystem, a second storage address of the order record in the second subsystem, a preset first field type and the like from pre-stored reconciliation information.

The first subsystem and the second subsystem are any two subsystems in the transaction system, and the first field type is determined in advance based on the field type of the order identification of the order record stored in each subsystem in the transaction system. For example, in the case of an order number as an order identification of an order record, when the field type of the order number of the order record stored in each subsystem is type a, the type a may be regarded as a first field type.

In one embodiment, when the to-be-processed reconciliation task includes only two subsystems that need to perform order record reconciliation, the electronic device may use any one of the two subsystems as the first subsystem and the other subsystem as the second subsystem.

For example, the pending reconciliation task a includes a subsystem 1 and a subsystem 2 that need to perform order record reconciliation, in which case the electronic device may use the subsystem 1 as a first subsystem and the subsystem 2 as a second subsystem, or may use the subsystem 2 as a first subsystem and the subsystem 1 as a second subsystem.

In another embodiment, when the pending reconciliation task includes a plurality of subsystems that need to perform order record reconciliation, the electronic device may use any two of the plurality of subsystems that need to perform order record reconciliation as the first subsystem and the second subsystem, respectively.

For example, the to-be-processed reconciliation task a includes a subsystem 1 and a subsystem 2, a subsystem 2 and a subsystem 3 that need to perform order record reconciliation, and the electronic device may determine two reconciliation tasks first, and then take the subsystem 1 as a first subsystem in the reconciliation task A1, take the subsystem 2 as a second subsystem, take the subsystem 2 as a first subsystem in the reconciliation task A2, and take the subsystem 1 as a second subsystem.

After the electronic device obtains the first storage address of the order record in the first subsystem and the second storage address of the order record in the second subsystem, the electronic device can obtain each stored order record from the first subsystem according to the first storage address, and obtain each stored order record from the second subsystem according to the second storage address.

For each obtained order record, the electronic device may traverse the field types of the fields in the order record, determine that the field type in the order record is the field of the first field type, and further use the field as the primary key field corresponding to the order record.

Because the primary key field in the order record can identify the order to which the order record belongs, through the primary key field of each order record in the two subsystems, whether the order record of the same order is stored in the two subsystems can be determined, so that whether the situation of losing the order record exists in the subsystems can be determined, the order records belonging to the same order in the two subsystems can be determined, and further, the two order records are compared, and whether the situation of inconsistent order information of the same type of the same order recorded in the two subsystems exists can be determined.

Therefore, after determining the primary key field corresponding to each order record, the electronic device can respectively compare each order record in the first subsystem with each order record in the second subsystem, i.e. compare the first order record with the second order record, so as to obtain a comparison result.

In the scheme provided by the embodiment of the application, for any two subsystems in the transaction system, the electronic equipment can adopt a general comparison flow to compare, namely, according to the preset first field type and the preset storage address, the order records in the two subsystems are obtained, the main key field used for representing the order mark in the order records is determined, and then the order records in the two subsystems are compared based on the main key field. Even when the comparison task among other subsystems is newly added, only the corresponding first field type and storage address are required to be configured, a new comparison program is not required to be developed, the universality of an order record checking method is improved, and the program development workload is reduced.

As shown in fig. 2, before obtaining the reconciliation information of the first subsystem and the second subsystem to be reconciled in the transaction system indicated by the reconciliation task to be processed when the trigger instruction for the reconciliation task to be processed is received, the method may further include:

s201, displaying a task configuration interface.

The to-be-processed account checking task and the account checking information corresponding to each to-be-processed account checking task stored in the electronic equipment can be sent by other equipment received by the electronic equipment, or can be created by a user on the electronic equipment.

In the case where the to-be-processed reconciliation tasks and the reconciliation information corresponding to each of the to-be-processed reconciliation tasks are created by the user on the electronic device, the electronic device needs to be capable of realizing the reconciliation task creation function.

In one embodiment, the electronic device may have a display screen or be connected to a display screen on which the electronic device may display a task configuration interface to the user upon receiving a creation request sent by the user.

For example, a creation button may be displayed on a display screen of the electronic device, and when the user clicks the creation button, the electronic device may determine that a creation request sent by the user is received, and may further display a task configuration interface to the user on the display screen.

Wherein, the task configuration interface may at least include: the system comprises a first field type setting component and a storage address setting component, wherein the first field type setting component is used for setting the field type of the order identification of the order records stored in each subsystem in the transaction system, and the storage address setting component is used for setting the storage address of the order records in the subsystems to be compared.

S202, creating each to-be-processed reconciliation task and reconciliation information corresponding to each to-be-processed reconciliation task based on setting operation of a user on a setting component in the task configuration interface.

After the electronic equipment displays the task configuration interface to the user, the setting operation of the user on each setting component in the task configuration interface can be detected in real time by detecting touch information, detecting external input information and the like. In the case that the task configuration interface includes at least a first field type setting component and a storage address setting component, the setting operation may include at least a first field type setting operation issued by the user based on the first field type setting component and a storage address setting operation issued by the user based on the storage address setting component.

In one embodiment, each input selection box may be included in the setting component, and the electronic device may determine the setting operation of the user on each setting component in the task configuration interface by detecting the input or selection operation of the user in the multiple input selection boxes, so as to determine the storage address and the first field type and other reconciliation information set by the user, thereby creating each pending reconciliation task and the reconciliation information corresponding to each pending reconciliation task.

For example, the first field type setting component may include an input selection box having a plurality of commonly used field types, in which a user may select one field type as the first field type, or in which a user may manually input one field type as the first field type.

Similarly, the storage address setting component may also include an input selection box, where the input selection box has names of a plurality of commonly used subsystems, the user may select a subsystem to be checked out in the input selection box, the electronic device may determine, according to a correspondence between a subsystem pre-stored by the user and a storage address, a storage address of an order record in the subsystem selected by the user, and the user may manually input the storage address in the input selection box as a storage address of the order record in the subsystem to be checked out.

After determining the storage address and the first field type of the order record in each subsystem to be checked, the electronic device may create a check task to be checked by adding a piece of data in the account_ checking _task_config table, and add the storage address and the first field type to the account_ checking _compare_field table as the check information corresponding to the check task to be checked, and in addition, the electronic device may set a status field corresponding to the corresponding data in the account_ checking _task_config table to 0 to prevent the check task to be checked from being directly executed.

In the scheme provided by the embodiment of the application, the electronic equipment can establish each to-be-processed reconciliation task and the reconciliation information corresponding to each to-be-processed reconciliation task based on the setting operation of the setting component in the task configuration interface by the user through the display task configuration interface, so that the comparison of the order records in each subsystem is realized, the universality of the order record reconciliation method is improved, the program development workload is reduced, and the requirements of the user on the comparison of the order records in different subsystems are met.

As an implementation manner of the embodiment of the present application, the reconciliation information may further include a second field type, where the second field type is determined in advance based on field types of other reconciliation to be performed except for the order identifier of the order record stored in each subsystem in the transaction system;

before the comparing the first order record with the second order record based on the primary key field to obtain the comparison result, the method may further include:

and aiming at each order record, acquiring a field with the field type of the second field type in the order record as a comparison field corresponding to the order record.

The comparing the first order record with the second order record based on the primary key field to obtain a comparison result may include:

When an order record of an order is stored for the same order, the emphasis recorded by the order record is different for different subsystems, which results in that the types of order information in the order records belonging to the same order in different subsystems are not identical.

For example, when a user purchases a benefit, the user ordering system may store an order record for the order, where the order record may include information such as an order number, a payment amount, and a type of benefit. The payment center also stores an order record of the order, wherein the order record may include information such as an order number, a payment amount, and a payment method.

If all the order information of the two order records are adopted for comparison to determine whether the two order records are consistent, a comparison error situation occurs, so that the reconciliation information can also comprise a second field type which is determined in advance based on the field types of other reconciliation required field types of the order records stored in each subsystem in the transaction system except the order identification.

For example, for the user ordering system and the payment center, the order records stored in the user ordering system and the payment center both have order information of a payment amount type except the order information of the order number type, so for a reconciliation task of reconciling the user ordering system and the payment center, a second field type in reconciliation information corresponding to the reconciliation task can be set as a field type of a field in which the payment amount is located in the order records.

In one embodiment, the electronic device may display a second field type setting component in the task configuration interface so that the user may determine the second field type based on other field types to be reconciled of the order records stored in the respective subsystems in the transaction system, except for the order identification, and set the second field type based on the second field type setting component.

When the electronic equipment creates each to-be-processed reconciliation task and the reconciliation information corresponding to each to-be-processed reconciliation task based on the setting operation of the setting component in the task configuration interface by the user, the reconciliation information also comprises the second field type set by the setting component based on the second field type, so that when the electronic equipment compares the order records belonging to the same order, the electronic equipment can determine which fields in the field types are adopted for comparison according to the second field type in the reconciliation information.

Correspondingly, under the condition that the reconciliation information further comprises the second field type, the electronic device can acquire the primary key field corresponding to each order record, traverse the field type of each field in the order record for each acquired order record, determine that the field type in the order record is the field of the second field type, and further use the field as the comparison field corresponding to the order record.

Correspondingly, when the electronic device compares the first order record with the second order record, the main key field and the comparison field can be adopted for comparison, specifically, the main key field can be firstly adopted for comparison to determine the order records belonging to the same order in different subsystems, and then the comparison is carried out according to the comparison field to determine whether the order records belonging to the same order in different subsystems are consistent.

In the scheme provided by the embodiment of the application, the account checking information can also comprise a second field type, and when the electronic equipment compares the order records belonging to the same order, the electronic equipment can determine which fields need to be adopted for comparison according to the second field type included in the account checking information, so that the accuracy of comparison is improved, and the situation of error of comparison results is avoided.

As an implementation manner of the embodiment of the present application, the reconciliation information may further include a first data source interface of the first subsystem and a second data source interface of the second subsystem, where the first data source interface is used for characterizing an acquisition manner of an order record in the first subsystem, and the second data source interface is used for characterizing an acquisition manner of an order record in the second subsystem;

The above-mentioned obtaining the stored order records from the first subsystem according to the first storage address, and obtaining the stored order records from the second subsystem according to the second storage address may include:

Because the subsystems in the transaction system are different, the transmission format, protocol, or rules of the order records between the electronic device and the subsystems may be different when the electronic device obtains the order records from the different subsystems, which results in the electronic device obtaining the order records from the different subsystems may be different.

Thus, to ensure that each order record stored in the subsystem can be successfully acquired, the reconciliation information may further include a first data source interface for characterizing the manner in which the order record in the first subsystem was acquired and a second data source interface for characterizing the manner in which the order record in the second subsystem was acquired.

In one embodiment, the electronic device may display the data source interface setting component in the task configuration interface so that the user may set the data source interfaces of different subsystems based on the manner in which the order records in the different subsystems are obtained. When the electronic device creates each to-be-processed reconciliation task and the reconciliation information corresponding to each to-be-processed reconciliation task based on the setting operation of the setting component in the task configuration interface by the user, the reconciliation information also comprises the data source interfaces of the subsystems set by the data source interface setting component.

Correspondingly, when the reconciliation information further comprises a data source interface setting component, the electronic device can call the data source interface of the subsystem when acquiring the order records in the subsystem, and acquire the stored order records from the subsystem according to the acquisition mode represented by the data source interface and the storage address of the order records in the subsystem.

In the scheme provided by the embodiment of the application, the reconciliation information can also comprise the first data source interface of the first subsystem and the second data source interface of the second subsystem, so that when the electronic equipment acquires the order records stored in the subsystems, the electronic equipment can determine which acquisition mode is required to acquire the order records of the first subsystem and the second subsystem according to the first data source interface and the second data source interface included in the reconciliation information, thereby ensuring the success rate of acquiring the order records and further ensuring the success rate of reconciliation of the order records.

As shown in fig. 3, the creating each to-be-processed reconciliation task and the reconciliation information corresponding to each to-be-processed reconciliation task based on the setting operation of the setting component in the task configuration interface by the user may include:

S301, determining a subsystem in the transaction system indicated by the pending reconciliation task to be created currently as a target subsystem based on the setting operation of the user on the setting component in the task configuration interface.

In the case that the task configuration interface further includes a data source interface setting component, in order to reduce repeated configuration of the user and improve use experience of the user, the electronic device may determine, based on a setting operation of the user on the setting component in the task configuration interface, a subsystem in the transaction system indicated by the to-be-created to-be-processed reconciliation task at present, as a target subsystem, that is, determine a subsystem to be compared by the user at present.

In one embodiment, when the setting operation of the setting component in the task configuration interface by the user directly includes the operation of the selected subsystem, the electronic device may directly use the selected subsystem as the subsystem in the transaction system indicated by the pending reconciliation task to be currently created, so as to determine the target subsystem.

In another embodiment, when the setting operation of the setting component in the task configuration interface by the user includes an operation of selecting relevant information of a subsystem, the electronic device may determine, according to a correspondence between the subsystem stored by the electronic device and the relevant information of the subsystem, a subsystem corresponding to the relevant information selected by the user, and further use the subsystem as a subsystem in a transaction system indicated by a to-be-created to-be-processed reconciliation task, so as to determine the target subsystem.

S302, judging whether the target subsystem exists in the subsystems in the transaction system indicated by the created pending reconciliation task.

After determining the target subsystems, the electronic device may traverse the subsystems in the transaction system indicated by the previously created pending reconciliation tasks, and further determine whether the target subsystems exist in the subsystems in the transaction system indicated by the created pending reconciliation tasks.

For example, the target subsystem determined by the electronic device is subsystem 1, the electronic device traverses the subsystem in the transaction system indicated by the previously created pending reconciliation task, determines that the subsystem in the transaction system indicated by the pending reconciliation task a is subsystem 1, subsystem 2 and subsystem 3, and the subsystem in the transaction system indicated by the pending reconciliation task B is subsystem 3, subsystem 6 and subsystem 7. The electronic device may then determine whether subsystem 1 is present in the subsystems in the transaction system indicated by the pending reconciliation task a and the pending reconciliation task B.

If the judgment result is negative, that is, the target subsystem does not exist in the subsystems in the transaction system indicated by the created pending reconciliation task, the electronic device can output prompt information to prompt the user to configure the data source interface of the target subsystem.

If the determination result is yes, that is, there is no target subsystem in the subsystems in the transaction system indicated by the created pending reconciliation task, the electronic device may directly inherit the data source interface of the target subsystem configured previously, that is, execute step S303.

S303, taking a data source interface of the target subsystem corresponding to the target to-be-processed reconciliation task as a data source interface of the target subsystem corresponding to the currently to-be-created to-be-processed reconciliation task.

When the electronic device determines that the created pending reconciliation task of the target subsystem exists in the subsystems in the indicated transaction system, that is, determines the target pending reconciliation task, the data source interface of the target subsystem configured when the target pending reconciliation task is created can be directly used as the data source interface of the target subsystem corresponding to the current pending reconciliation task to be created.

In the scheme provided by the embodiment of the application, when the target subsystem in the transaction system indicated by the pending reconciliation task to be created currently by the user exists in the subsystem in the transaction system indicated by the pending reconciliation task created previously, the electronic device can directly inherit the data source interface of the target subsystem configured previously without the need of the user to perform configuration again, thereby reducing repeated configuration operation of the user and improving the use experience of the user.

As an implementation manner of the embodiment of the present application, the reconciliation information may further include an alignment identifier;

Various comparison modes can be stored in the electronic equipment in advance so as to meet different requirements of a user for comparing the order records in the subsystem, and in this case, the account checking information can also comprise comparison mode identification so as to indicate what comparison mode should be adopted to compare the first order record with the second order record when the electronic equipment executes the account checking task to be processed corresponding to the account checking information.

In one embodiment, the electronic device may display the alignment setting component in the task configuration interface, so that the user may set the alignment identifier based on the alignment setting component according to different alignment requirements. And when the electronic equipment creates each to-be-processed reconciliation task and the reconciliation information corresponding to each to-be-processed reconciliation task based on the setting operation of the setting component in the task configuration interface by the user, the reconciliation information also comprises the comparison mode identifier set by the comparison mode setting component. .

Correspondingly, when the account comparison information further comprises the comparison method identification, the electronic device can determine the comparison mode indicated by the comparison method identification according to the corresponding relation between the pre-stored comparison method identification and the comparison method when comparing the first order record with the second order record, and further the electronic device can compare the first order record with the second order record based on the main key field and the comparison field through the comparison mode indicated by the comparison method identification, so that a comparison result is obtained.

Of course, in the case that the user does not set the comparison method identifier based on the comparison method setting component, the electronic device may adopt a default comparison method set in advance, and compare the first order record with the second order record based on the main key field and the comparison field, so as to obtain a comparison result.

In the scheme provided by the embodiment of the application, the account checking information can also comprise the comparison method identification, and the user can set different comparison method identifications according to different comparison requirements, so that when the electronic equipment performs comparison of the order records, the corresponding comparison method identification is adopted to perform comparison of the orders according to the comparison method identification included in the order records, thereby meeting different requirements of the user on comparison of the order records in the subsystem and improving the flexibility of order record comparison.

As an implementation manner of the embodiment of the present application, in the case where the comparison method identifier is the first identifier, as shown in fig. 4, the comparing method indicated by the comparison method identifier, based on the main key field and the comparison field, compares the first order record with the second order record to obtain a comparison result, may include:

When the comparison method identifier is the first identifier, the electronic device can determine that the comparison mode is one-way comparison according to the corresponding relation between the pre-stored comparison method identifier and the comparison method, and in this case, when the electronic device compares the first order records with the second order records, the electronic device can determine whether the second order records with the same main key field as the main key field of the first order records exist for each first order record.

S401, for each first order record, judging whether a second order record with the same corresponding main key field as the main key field of the first order record exists.

Because the electronic device has acquired the primary key field corresponding to each order record before comparing the first order record with the second order record, the electronic device may respectively compare whether the primary key field corresponding to each first order record with the primary key field corresponding to each second order record is the same to determine whether, for each first order record, there is a second order record with the corresponding primary key field being the same as the primary key field of the first order record.

For example, the first order record includes an order record a1 and an order record a2, the second order record includes an order record b1, an order record b2, and an order record b3, and the electronic device may determine, for the order record a1, whether the primary key fields of the order record b1, the order record b2, and the order record b3 are the same as the primary key field of the order record a1, and determine, for the order record a2, whether the primary key fields of the order record b1, the order record b2, and the order record b3 are the same as the primary key field of the order record a2, respectively.

If the judgment result is yes, namely, a second order record with the same main key field as the main key field of the first order record exists, the fact that the order records of the orders are recorded in the two subsystems is indicated, the problem of losing the order records does not exist, and at the moment, the first order record can be determined to be a normal order record.

If the determination result is no, that is, there is no second order record with the corresponding primary key field identical to the primary key field of the first order record, the electronic device may execute step S402.

S402, determining the first order record as an abnormal order record.

If the judgment result is no, that is, there is no second order record with the corresponding main key field identical to the main key field of the first order record, it is indicated that the order record of the first order record belongs to, there is no order record of the order stored in the second subsystem, and there is a problem of losing the order record, at this time, the first order record can be determined as an abnormal order record.

In one embodiment, for two subsystems to be reconciled in the transaction system indicated by the task to be reconciled, the electronic device may use either one of the two subsystems as the first subsystem and the other subsystem as the second subsystem.

In another embodiment, for two subsystems to be reconciled in the transaction system indicated by the reconciliation task to be processed, the task configuration interface displayed by the electronic device may further include a main system setting component, so that the electronic device may use the subsystem indicated by the user in the two subsystems as a first subsystem and use the other subsystem as a second subsystem according to the setting operation of the user based on the main system setting component.

In the case where the comparison method identifier is the second identifier, as shown in fig. 5, the comparing, according to the comparison method indicated by the comparison method identifier, based on the primary key field and the comparison field, the comparing the first order record with the second order record to obtain a comparison result may include:

When the comparison method identifier is the second identifier, the electronic device may determine that the comparison method is "two-way comparison" according to the corresponding relationship between the pre-stored comparison method identifier and the comparison method, in this case, when the electronic device compares the first order records with the second order records, it may determine, for each first order record, whether there is a second order record with a corresponding primary key field identical to the primary key field of the first order record, and for each second order record, whether there is a first order record with a corresponding primary key field identical to the primary key field of the second order record.

S402, determining the first order record as an abnormal order record.

The specific implementation of steps S401 to S402 is described in detail in the embodiment shown in fig. 4, and will not be described here again.

S501, for each second order record, judging whether a first order record with the same corresponding main key field as the main key field of the second order record exists.

Because the electronic device has acquired the primary key field corresponding to each order record before comparing the first order record with the second order record, the electronic device may respectively compare whether the primary key field corresponding to each first order record with the primary key field corresponding to each second order record is the same to determine whether, for each second order record, there is a first order record with the corresponding primary key field being the same as the primary key field of the second order record.

For example, the second order record includes an order record b1, an order record b2, and an order record b3, the first order record includes an order record a1 and an order record a2, and the electronic device may determine, for the order record b1, whether the primary key fields of the order record a1 and the order record a2 are the same as the primary key field of the order record b1, respectively; for the order record b2, judging whether the main key fields of the order record a1 and the order record a2 are the same as the main key field of the order record b2 or not respectively; and for the order record 3, judging whether the main key fields of the order record a1 and the order record a2 are the same as the main key field of the order record b3 or not respectively.

If the judgment result is yes, namely, a first order record with the same main key field as the main key field of the second order record exists, the fact that the order records of the orders are recorded in the two subsystems is indicated, the problem of losing the order records does not exist, and at the moment, the second order record can be determined to be a normal order record.

If the determination result is no, that is, there is no first order record with the corresponding primary key field identical to the primary key field of the second order record, the electronic device may execute step S502.

S502, determining the second order record as an abnormal order record;

If the judgment result is no, that is, there is no first order record with the same main key field as the main key field of the second order record, it is indicated that the order record of the second order record belongs to, the first subsystem does not store the order record of the order, and there is a problem of losing the order record, at this time, the second order record can be determined as an abnormal order record.

The reconciliation information may further include a second field type, where the second field type is determined in advance based on field types of other accounting required of the order records stored in each subsystem in the transaction system, and when the comparison mode identifier is a third identifier, as shown in fig. 6, the comparison mode indicated by the comparison mode identifier, based on the primary key field and the comparison field, compares the first order record with the second order record to obtain a comparison result, and may include:

when the comparison method identifier is the third identifier, the electronic device can determine that the comparison method is "one-way comparison+two-layer comparison" according to the corresponding relation between the pre-stored comparison method identifier and the comparison method, in this case, when the electronic device compares the first order records with the second order records, the electronic device can determine, for each first order record, whether there is a second order record with a corresponding primary key field identical to the primary key field of the first order record, and when it is determined that there is a second order record with a corresponding primary key field identical to the primary key field of the first order record, further comparison is performed based on the comparison field corresponding to the order record.

S402, determining the first order record as an abnormal order record.

The specific implementation of steps S401 to S402 in the embodiment shown in fig. 6 is similar to the specific implementation of steps S401 to S402 in the embodiment shown in fig. 4, and the difference between them is that, in the embodiment shown in fig. 4, when the determination result of step S401 is yes, the electronic device directly determines the first order record as the normal order record, but in the embodiment shown in fig. 6, when the determination result of step S401 is yes, the electronic device performs further comparison based on the comparison field corresponding to the order record, that is, executes step S403.

S403, respectively acquiring fields with the field types of the second field types in the first order record and the first target order record as comparison fields corresponding to the first order record and the first target order record.

For a first order record, after determining that there is a second order record with a corresponding primary key field that is the same as the primary key field of the first order record, the electronic device may use the second target order record as the first target order record.

And the electronic device may further obtain a field with a field type of the second field type in the first order record as a comparison field corresponding to the first order record, and may further obtain a field with a field type of the second field type in the first target order record as a comparison field corresponding to the first target order record.

S404, judging whether the comparison field in the first order record is consistent with the comparison field in the first target order record.

After determining the comparison field corresponding to the first order record and the first target order record, the electronic device can compare the first order record and the first target order record again based on the comparison field, namely judging whether the comparison field in the first order record is consistent with the comparison field in the first target order record.

If the judgment result is yes, that is, the comparison field in the first order record is consistent with the comparison field in the first target order record, it is indicated that the order information in the order records of the same order stored in different subsystems is consistent, and at the moment, the first order record can be determined to be a normal order record.

If the determination result is no, that is, the comparison field in the first order record is inconsistent with the comparison field in the first target order record, the electronic device may execute step S405.

S405, the first order record is determined as an abnormal order record.

If the judgment result is no, that is, the comparison field in the first order record is inconsistent with the comparison field in the first target order record, the fact that the order information of the same type of the order records stored by the first subsystem and the second subsystem is inconsistent for the same order is indicated, and at the moment, the first order record can be determined to be an abnormal order record.

The reconciliation information may further include a second field type, where the second field type is determined in advance based on field types of other accounting required of the order records stored in each subsystem in the transaction system, and when the comparison mode identifier is a fourth identifier, as shown in fig. 7, the comparing method indicated by the comparison mode identifier, based on the primary key field and the comparison field, compares the first order record with the second order record, to obtain a comparison result, may include:

When the comparison method identifier is the fourth identifier, the electronic device may determine that the comparison method is "bidirectional comparison+double-layer comparison" according to the correspondence between the pre-stored comparison method identifier and the comparison method, in this case, when comparing the first order record with the second order record, the electronic device may determine, for each first order record, whether there is a second order record with a corresponding primary key field identical to the primary key field of the first order record, and determine, for each second order record, whether there is a first order record with a corresponding primary key field identical to the primary key field of the second order record.

And when determining that a second order record with the corresponding main key field being the same as the main key field of the first order record exists and/or when determining that a first order record with the corresponding main key field being the same as the main key field of the second order record exists, the electronic device can further compare based on the comparison field corresponding to the order record.

S402, determining the first order record as an abnormal order record.

S405, the first order record is determined as an abnormal order record.

The specific implementation of steps S401 to S405 is described in detail in the embodiment shown in fig. 5, and will not be described here again.

S502, determining the second order record as an abnormal order record.

The specific implementation of steps S501-S502 in the embodiment shown in fig. 7 is similar to the specific implementation of steps S501-S502 in the embodiment shown in fig. 5, and the difference between them is that, in the embodiment shown in fig. 5, when the determination result of step S501 is yes, the electronic device directly determines the second order record as the normal order record, but in the embodiment shown in fig. 7, when the determination result of step S501 is yes, the electronic device performs further comparison based on the comparison field corresponding to the order record, that is, executes step S503.

S503, respectively obtaining fields with the field types of the second field types in the second order record and the second target order record as comparison fields corresponding to the second order record and the second target order record.

For a second order record, after determining that there is a first order record with a corresponding primary key field that is the same as the primary key field of the second order record, the electronic device may use the first target order record as the second target order record.

And the electronic device may further obtain a field with a field type of the second field type in the second order record as a comparison field corresponding to the second order record, and may further obtain a field with a field type of the second field type in the second target order record as a comparison field corresponding to the second target order record.

S504, judging whether the comparison field in the second order record is consistent with the comparison field in the second target order record.

After determining the comparison field corresponding to the second order record and the second target order record, the electronic device can compare the second order record and the second target order record again based on the comparison field, i.e. judging whether the comparison field in the second order record is consistent with the comparison field in the second target order record.

If the judgment result is yes, that is, the comparison field in the second order record is consistent with the comparison field in the second target order record, it is indicated that the order information in the order records of the same order stored in different subsystems is consistent, and at this time, the second order record can be determined to be a normal order record.

If the determination result is no, that is, the comparison field in the second order record is inconsistent with the comparison field in the second target order record, the electronic device may execute step S505.

S505, the second order record is determined as an abnormal order record.

If the judgment result is no, that is, the comparison field in the second order record is inconsistent with the comparison field in the second target order record, the fact that the order information of the same type of the order records stored by the first subsystem and the second subsystem is inconsistent for the same order is indicated, and at the moment, the second order record can be determined to be an abnormal order record.

It should be noted that fig. 7 only shows an embodiment in which steps S403-S405 and steps S503-S505 are performed, and in addition, the electronic device may also select to perform steps S403-S405 or steps S503-S505 according to the actual requirement of the user.

In the scheme provided by the embodiment of the application, the electronic equipment compares the first order record with the second order record in a one-way comparison mode, a two-way comparison mode, a one-way comparison mode, a two-layer comparison mode or a two-way comparison mode, so that different requirements of a user on comparison of order records in a subsystem are met, and the flexibility of order record comparison is improved.

As an implementation manner of the embodiment of the present application, the reconciliation information may further include a time period;

when the time difference between the current time point and the time point of executing the to-be-processed reconciliation task last time meets the time period, determining that a trigger instruction for the to-be-processed reconciliation task is received, and acquiring reconciliation information of a first subsystem and a second subsystem to be reconciled in a transaction system indicated by the to-be-processed reconciliation task.

In order to realize the periodic triggering of the execution of the reconciliation task, the reconciliation information may further include a time period, so that the electronic device may periodically execute the reconciliation information according to the execution time of each of the pending reconciliation tasks and the time period.

In one embodiment, the electronic device may display a time period setting component in the task configuration interface such that a user may set an execution period of the reconciliation task based on the time period setting component. When the electronic device creates each to-be-processed reconciliation task and the reconciliation information corresponding to each to-be-processed reconciliation task based on the setting operation of the setting component in the task configuration interface by the user, the reconciliation information also includes the time period set by the setting component based on the time period. .

Correspondingly, under the condition that the reconciliation information can further comprise a time period, the electronic device can judge whether the time difference between the current time point and the time point of executing the reconciliation task to be processed last time meets the time period or not in real time, if so, the triggering instruction for the reconciliation task to be processed is determined to be received, and further the reconciliation information of the first subsystem and the second subsystem to be reconciled in the transaction system indicated by the reconciliation task to be processed is obtained.

In one embodiment, the time period may be set to 24 hours, and accordingly, the electronic device may obtain, when obtaining each stored order record from the subsystem, only the order record generated between the current time point and the time point when the pending reconciliation task was last performed, so that the effect of reconciling the order record generated on the T-th day on the t+1 day may be achieved,

The electronic device may also trigger execution of the reconciliation task by receiving an externally input trigger signal, where in this case, when receiving the input trigger signal for the reconciliation task to be processed, the electronic device may determine that a trigger instruction for the reconciliation task to be processed is received, and may further obtain reconciliation information of the first subsystem and the second subsystem to be reconciled in the transaction system indicated by the reconciliation task to be processed.

In one embodiment, when the electronic device creates a to-be-processed reconciliation task by adding a piece of data in the account_ checking _task_configuration table, and sets a status field corresponding to corresponding data in the account_ checking _task_configuration table to 0 so as to prevent the to-be-processed reconciliation task from being directly executed, the electronic device may set a status field corresponding to data corresponding to the to-be-processed reconciliation task in the account_ checking _task_configuration table to 1 when determining that a trigger instruction for the to-be-processed reconciliation task is received, so as to trigger execution of the to-be-processed reconciliation task.

In the scheme provided by the embodiment of the application, the reconciliation information can also comprise a time period, and the electronic device can periodically trigger the execution of the reconciliation task according to the time period in the reconciliation information, so that timely reconciliation of the order records is realized, and abnormal conditions are found out in practice. In addition, the electronic equipment can trigger the execution of the reconciliation task according to the trigger signal input from the outside, so that the flexibility of triggering the reconciliation task is improved.

As an implementation manner of the embodiment of the present application, the reconciliation information may further include manager information;

After comparing the first order record with the second order record based on the primary key field to obtain a comparison result, the method may further include:

In order to enable the manager to process the comparison result of the order record in time, the account checking information can also comprise manager information so as to indicate the electronic equipment to send the comparison result to the information receiving equipment of the corresponding manager after the account checking task is executed.

In one embodiment, the electronic device may display a manager setting component in the task configuration interface so that a user may set the recipient of the comparison of the order records based on the manager setting component. When the electronic device creates each to-be-processed reconciliation task and the reconciliation information corresponding to each to-be-processed reconciliation task based on the setting operation of the setting component in the task configuration interface by the user, the reconciliation information also includes the manager information set based on the manager setting component.

Correspondingly, under the condition that the account checking information can also comprise the information of the manager, the electronic equipment can send the comparison result to the information receiving equipment such as a mobile phone and a computer of the manager according to the information of the manager after obtaining the comparison result, so that the manager can process the comparison result.

Of course, if the comparison failure occurs during the process of comparing the first order record with the second order record, prompt information of the comparison failure may also be sent to the manager, so that the manager can handle the abnormal situation.

The management personnel can be one or a plurality of management personnel, and when the electronic device sends the comparison result to the management personnel, the electronic device can send the complete comparison result, can only send the abnormal order record in the comparison result, and can also send the complete comparison result and the abnormal order record in the comparison result to different management personnel respectively, so that the management personnel are not particularly limited.

In the scheme provided by the embodiment of the application, the account checking information can also comprise manager information, and after the electronic equipment performs the account checking task to obtain the comparison result, the comparison result can be sent to the information receiving equipment of the corresponding manager according to the manager information included in the account checking information, so that the manager can process the comparison result in time.

As an implementation manner of the embodiment of the present application, the task configuration interface further includes at least one of the following setting components on the basis of including the first field type setting component and the storage address setting component:

The second field type setting component, correspondingly, in the case that the task configuration interface further comprises the second field type setting component, the reconciliation information may further comprise a second field type set in advance based on the second field type setting component;

The data source interface setting component, correspondingly, in the case that the task configuration interface further comprises the data source interface setting component, the reconciliation information can further comprise a first data source interface of the first subsystem and a second data source interface of the second subsystem which are set in advance based on the data source interface setting component;

the comparison mode setting component, correspondingly, in the case that the task configuration interface further comprises the comparison mode setting component, the reconciliation information can further comprise comparison mode identifiers set by the comparison mode setting component in advance;

the time period setting component, correspondingly, in the case that the task configuration interface further comprises the time period setting component, the reconciliation information can further comprise the time period set by the time period setting component in advance;

And the manager setting component correspondingly, and in the case that the task configuration interface further comprises the manager setting component, the reconciliation information can further comprise manager information set by the manager setting component in advance.

In the scheme provided by the embodiment of the application, the task configuration interface displayed by the electronic equipment comprises the first field type setting component and the storage address setting component and can also comprise other types of setting components, so that a user can set various parameters of the reconciliation task according to the task configuration interface displayed by the electronic equipment, thereby meeting the personalized order record reconciliation requirement of the user.

Taking fig. 8 and fig. 9 as an example, an embodiment of the present application is described below to further provide an order record reconciliation method.

The electronic device may display a task configuration interface as shown in fig. 8 to a user, where a "first field type" and an input selection frame on the right side thereof in the task configuration interface form a first field type setting component, a "storage address" and an input selection frame on the right side thereof form a storage address setting component, a "second field type" and an input selection frame on the right side thereof form a second field type setting component, a "data source interface" and an input selection frame on the right side thereof form a data source interface setting component, an "comparison mode" and an input selection frame on the right side thereof form a comparison mode setting component, a "time period" and an input selection frame on the right side thereof form a time period setting component, and a "manager" and an input selection frame on the right side thereof form a manager setting component.

The user can send setting operation to the electronic device aiming at each setting component in the task configuration interface by clicking options in the input selection boxes or manually inputting the options in the input selection boxes at each input selection box in the task configuration interface, and the electronic device can create a to-be-processed reconciliation task and reconciliation information corresponding to the to-be-processed reconciliation task based on the setting operation of the user. In this way, the electronic device may create a plurality of to-be-processed reconciliation tasks and reconciliation information corresponding to the plurality of to-be-processed reconciliation tasks.

The electronic device may create a plurality of to-be-processed reconciliation tasks and reconciliation information corresponding to the plurality of to-be-processed reconciliation tasks, and then may display the plurality of to-be-processed reconciliation tasks in the task display interface shown in fig. 9. The task display interface may include task IDs, task descriptions, management personnel, status, setting buttons, and execution buttons of each of the pending reconciliation tasks.

For example, as shown in fig. 9, a task of the to-be-processed reconciliation task whose task ID is "05" is described as "the payment center reconciles with the gifting system", the manager is "person a", and the state is "executing"; the task description of the to-be-processed reconciliation task with the task ID of '06' is 'cloud ticket system and user ordering system reconciliation', the manager is 'personnel A', and the state is 'executing'; the task of the pending reconciliation task with the task ID of "07" is described as "the payment center reconciles with the cloud ticket system", the manager is "person B", and the status is "in suspension".

The user can enter a task configuration interface of the to-be-processed reconciliation task by clicking a setting button so as to modify the reconciliation information of the to-be-processed reconciliation task, and the user can manually trigger the execution of the to-be-processed reconciliation task by clicking an execution button.

In addition, the task display interface can also comprise a search component and a newly added component, wherein the search component consists of a search box and a search button, a user can search a to-be-checked account checking task which the user wants to check through the search component, and the user can enter the task configuration interface through the newly added component to create a new to-be-checked account checking task.

After the electronic device triggers execution of the to-be-processed reconciliation task in a mode of periodically triggering or receiving a trigger signal input from the outside, the reconciliation information of the first subsystem and the second subsystem to be reconciled in the transaction system indicated by the to-be-processed reconciliation task can be obtained, and each stored order record is obtained from the first subsystem and the second subsystem respectively according to the first storage address and the second storage address included in the reconciliation information.

And the electronic equipment can acquire a field with a field type of a first field type included in reconciliation information in each order record as a main key field corresponding to the order record, and compare the first order record with the second order record based on the main key field to obtain a comparison result, so that the reconciliation of the order records is realized.

In the scheme provided by the embodiment of the application, for any two subsystems in the transaction system, the electronic equipment can adopt a general comparison flow to compare, namely, according to the preset first field type and the preset storage address, the order records in the two subsystems are obtained, the main key field used for representing the order mark in the order records is determined, and then the order records in the two subsystems are compared based on the main key field. Even when the comparison task among other subsystems is newly added, only the corresponding information is needed to be configured, a new comparison program is not needed to be developed, the universality of an order record checking method is improved, and the program development workload is reduced.

Corresponding to the order record reconciliation method, the embodiment of the application also provides an order record reconciliation device. The following describes an order record checking device provided by the embodiment of the application.

As shown in fig. 10, an order record reconciliation device may include:

The reconciliation information obtaining module 1010 is configured to obtain, when a trigger instruction for a to-be-processed reconciliation task is received, reconciliation information of a first subsystem and a second subsystem to be reconciled in a transaction system indicated by the to-be-processed reconciliation task, where the reconciliation information at least includes: a first storage address of an order record in the first subsystem, a second storage address of the order record in the second subsystem and a preset first field type, wherein the first field type is determined in advance based on field types of order identifications of the order records stored in all subsystems in the transaction system, and the first subsystem and the second subsystem are any two subsystems in the transaction system;

An order record obtaining module 1020, configured to obtain each stored order record from the first subsystem according to the first storage address, and obtain each stored order record from the second subsystem according to the second storage address;

The primary key field obtaining module 1030 is configured to obtain, for each order record, a field in the order record with a field type of the first field type, as a primary key field corresponding to the order record;

And the order record comparison module 1040 is configured to compare a first order record with a second order record based on the primary key field, so as to obtain a comparison result, where the first order record is an order record obtained from the first subsystem, and the second order record is an order record obtained from the second subsystem.

As an implementation manner of the embodiment of the present application, the reconciliation information may further include a second field type, where the second field type is determined in advance based on field types of other reconciliation to be performed, except for the order identifier, of the order records stored in each subsystem in the transaction system;

The apparatus may further include:

The comparison field acquisition module is used for acquiring a field with a field type of the second field type in each order record as a comparison field corresponding to the order record before comparing the first order record with the second order record based on the primary key field to obtain a comparison result;

The order record comparison module 1040 may be specifically configured to compare the first order record with the second order record based on the primary key field and the comparison field, to obtain a comparison result.

The order record obtaining module 1020 may be specifically configured to invoke the first data source interface, obtain each stored order record from the first subsystem according to the obtaining mode represented by the first data source interface and the first storage address, invoke the second data source interface, and obtain each stored order record from the second subsystem according to the obtaining mode represented by the second data source interface and the second storage address.

The order record comparison module 1040 may be specifically configured to compare the first order record with the second order record based on the primary key field by using the comparison mode indicated by the comparison method identifier, to obtain a comparison result.

As an implementation manner of the embodiment of the present application, when the comparison method is identified as the first identifier, the order record comparison module 1040 may be specifically configured to determine, for each first order record, whether there is a second order record with a corresponding primary key field that is the same as the primary key field of the first order record, and if there is no second order record with a corresponding primary key field that is the same as the primary key field of the first order record, determine the first order record as an abnormal order record;

Or alternatively, the first and second heat exchangers may be,

In the case that the comparison method identifier is the second identifier, the order record comparison module 1040 may be specifically configured to determine, for each first order record, whether a second order record having a corresponding primary key field that is the same as the primary key field of the first order record exists, if no second order record having a corresponding primary key field that is the same as the primary key field of the first order record exists, determine the first order record as an abnormal order record, and determine, for each second order record, whether a first order record having a corresponding primary key field that is the same as the primary key field of the second order record exists, if no first order record having a corresponding primary key field that is the same as the primary key field of the second order record exists, and determine the second order record as an abnormal order record;

Or alternatively, the first and second heat exchangers may be,

The reconciliation information further includes a second field type, where the second field type is determined in advance based on other field types of the order records stored in the subsystems in the transaction system, and when the comparison mode is identified as a third identifier, the order record comparison module 1040 may be specifically configured to determine, for each first order record, whether there is a second order record with a corresponding primary key field that is the same as a primary key field of the first order record, if there is no second order record with a corresponding primary key field that is the same as a primary key field of the first order record, determine the first order record as an abnormal order record, and if there is a second order record with a corresponding primary key field that is the same as a primary key field of the first order record, obtain fields with field types in the first order record and the first target order record as corresponding comparison fields of the first order record, determine whether there is a corresponding primary key record that is the same as a primary key record in the first order record, and if there is a corresponding primary key record that is the first order record that is the same as the first order record, and if there is a corresponding primary key record that is the first order record that is the abnormal;

Or alternatively, the first and second heat exchangers may be,

The reconciliation information further includes a second field type, where the second field type is determined in advance based on field types of other order records to be reconciled except for the order identifier stored in each subsystem in the transaction system, and in the case that the comparison mode identifier is the fourth identifier, the order record comparison module 1040 may be specifically configured to determine, for each first order record, whether there is a second order record with a corresponding primary key field identical to a primary key field of the first order record, if there is no second order record with a corresponding primary key field identical to a primary key field of the first order record, determine the first order record as an abnormal order record, determine, for each second order record, whether there is a first order record with a corresponding primary key field identical to a primary key field of the second order record, and if there is no first order record with a corresponding primary key field identical to a primary key field of the second order record, determine the second order record as an abnormal order record;

As an implementation of the embodiment of the present application, the reconciliation information further includes a time period;

The reconciliation information obtaining module 1010 may be specifically configured to determine that a trigger instruction for a to-be-processed reconciliation task is received when the time difference between a current time point and a time point at which the to-be-processed reconciliation task was executed last time satisfies the time period, and obtain reconciliation information of a first subsystem and a second subsystem to be reconciled in a transaction system indicated by the to-be-processed reconciliation task; or when receiving an input trigger signal aiming at a to-be-processed reconciliation task, determining that a trigger instruction aiming at the to-be-processed reconciliation task is received, and acquiring reconciliation information of a first subsystem and a second subsystem to be reconciled in a transaction system indicated by the to-be-processed reconciliation task.

The apparatus may further include:

and the comparison result sending module is used for comparing the first order record with the second order record based on the main key field to obtain a comparison result, and sending the comparison result to a manager according to the manager information so that the manager can process the comparison result.

As an implementation manner of the embodiment of the present application, the foregoing apparatus may further include:

the task configuration interface display module is used for displaying a task configuration interface before acquiring the reconciliation information of a first subsystem and a second subsystem to be reconciled in a transaction system indicated by a to-be-processed reconciliation task when a trigger instruction for the to-be-processed reconciliation task is received, wherein the task configuration interface at least comprises: a first field type setting component and a storage address setting component;

The creation module is used for creating each to-be-processed reconciliation task and the reconciliation information corresponding to each to-be-processed reconciliation task based on the setting operation of the setting component in the task configuration interface by the user, wherein the setting operation at least comprises the first field type setting operation sent by the user based on the first field type setting component and the storage address setting operation sent by the user based on the storage address setting component.

As an implementation manner of the embodiment of the present application, the task configuration interface further includes a data source interface setting component, the reconciliation information further includes a first data source interface of the first subsystem and a second data source interface of the second subsystem, which are set by the data source interface setting component in advance, where the first data source interface is used for characterizing an acquisition manner of an order record in the first subsystem, and the second data source interface is used for characterizing an acquisition manner of an order record in the second subsystem; the creation module may include:

The target subsystem determining unit is used for determining a subsystem in the transaction system indicated by the current to-be-created pending reconciliation task as a target subsystem based on the setting operation of the user on the setting component in the task configuration interface;

the judging unit is used for judging whether the target subsystem exists in the subsystems in the transaction system indicated by the created to-be-processed reconciliation task;

And the data source interface inheritance module is used for taking a data source interface of the target subsystem corresponding to the target to-be-processed reconciliation task as a data source interface of the target subsystem corresponding to the currently to-be-created to-be-processed reconciliation task when the judging result of the judging unit is yes, wherein the target to-be-processed reconciliation task is the created to-be-processed reconciliation task of the target subsystem in the indicated transaction system.

As an implementation of the embodiment of the present application, the task configuration interface may further include at least one of the following setting components:

The embodiment of the present application further provides an electronic device, as shown in fig. 11, including a processor 1101, a communication interface 1102, a memory 1103 and a communication bus 1104, where the processor 1101, the communication interface 1102 and the memory 1103 complete communication with each other through the communication bus 1104,

A memory 1103 for storing a computer program;

the processor 1101 is configured to implement the order record reconciliation method described in any of the embodiments above when executing the program stored in the memory 1103.

The communication bus mentioned by the above terminal may be a peripheral component interconnect standard (PERIPHERAL COMPONENT INTERCONNECT, abbreviated as PCI) bus or an extended industry standard architecture (Extended Industry Standard Architecture, abbreviated as EISA) bus, etc. The communication bus may be classified as an address bus, a data bus, a control bus, or the like. For ease of illustration, the figures are shown with only one bold line, but not with only one bus or one type of bus.

The communication interface is used for communication between the terminal and other devices.

The memory may include random access memory (Random Access Memory, RAM) or may include non-volatile memory (non-volatile memory), such as at least one disk memory. Optionally, the memory may also be at least one memory device located remotely from the aforementioned processor.

The processor may be a general-purpose processor, including a central processing unit (Central Processing Unit, abbreviated as CPU), a network processor (Network Processor, abbreviated as NP), etc.; but may also be a digital signal Processor (DIGITAL SIGNAL Processor, DSP), application Specific Integrated Circuit (ASIC), field-Programmable gate array (FPGA) or other Programmable logic device, discrete gate or transistor logic device, discrete hardware components.

In yet another embodiment of the present application, a computer readable storage medium is provided, in which a computer program is stored, the computer program implementing the order record reconciliation method of any of the above embodiments when executed by a processor.

In yet another embodiment of the present application, a computer program product containing instructions that, when run on a computer, cause the computer to perform the order record reconciliation method of any of the embodiments described above is also provided.

In the above embodiments, it may be implemented in whole or in part by software, hardware, firmware, or any combination thereof. When implemented in software, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. When loaded and executed on a computer, produces a flow or function in accordance with embodiments of the present application, in whole or in part. The computer may be a general purpose computer, a special purpose computer, a computer network, or other programmable apparatus. The computer instructions may be stored in or transmitted from one computer-readable storage medium to another, for example, by wired (e.g., coaxial cable, optical fiber, digital Subscriber Line (DSL)), or wireless (e.g., infrared, wireless, microwave, etc.). The computer readable storage medium may be any available medium that can be accessed by a computer or a data storage device such as a server, data center, etc. that contains an integration of one or more available media. The usable medium may be a magnetic medium (e.g., floppy disk, hard disk, tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., solid state disk Solid STATE DISK (SSD)), etc.

It is noted that relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.

In this specification, each embodiment is described in a related manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments. In particular, for apparatus, electronic devices, computer readable storage media and computer program product embodiments, the description is relatively simple as it is substantially similar to method embodiments, as relevant points are found in the partial description of method embodiments.

The foregoing description is only of the preferred embodiments of the present application and is not intended to limit the scope of the present application. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application are included in the protection scope of the present application.

Claims

1. An order record reconciliation method, the method comprising:

2. The method of claim 1, wherein the reconciliation information further comprises a second field type that is pre-determined based on other field types to be reconciled of the order records stored in the respective subsystems of the transaction system, except for an order identification;

3. The method of claim 1, wherein the reconciliation information further comprises a first data source interface of the first subsystem for characterizing a manner of acquisition of the order record in the first subsystem and a second data source interface of the second subsystem for characterizing a manner of acquisition of the order record in the second subsystem;

4. The method of claim 1, wherein the reconciliation information further comprises an alignment identifier;

5. The method according to claim 4, wherein, in the case that the comparison method identifier is the first identifier, the comparing, based on the primary key field, the first order record and the second order record to obtain a comparison result includes:

Or alternatively, the first and second heat exchangers may be,

The reconciliation information further includes a second field type, where the second field type is determined in advance based on field types of other reconciliation required except for the order identifier of the order records stored in each subsystem in the transaction system, and when the comparison method identifier is the third identifier, the comparison method indicated by the comparison method identifier is based on the main key field, and the comparing result is obtained by comparing the first order record with the second order record, and includes:

Or alternatively, the first and second heat exchangers may be,

6. The method of claim 1, wherein the reconciliation information further comprises a time period;

7. The method of claim 1, wherein the reconciliation information further comprises manager information;

8. The method according to any one of claims 1-7, wherein before obtaining reconciliation information of a first subsystem and a second subsystem to be reconciled in a transaction system indicated by a task to be reconciled upon receiving a trigger instruction for the task to be reconciled, the method further comprises:

9. The method of claim 8, wherein the task configuration interface further comprises a data source interface setting component, the reconciliation information further comprising a first data source interface of the first subsystem and a second data source interface of the second subsystem, the first data source interface being configured to characterize a manner of acquisition of order records in the first subsystem and the second data source interface being configured to characterize a manner of acquisition of order records in the second subsystem, the first data source interface being configured to pre-set based on the data source interface setting component;

10. The method of claim 8, wherein the task configuration interface further comprises at least one of the following setup components:

11. An order record reconciliation apparatus, the apparatus comprising:

12. The electronic equipment is characterized by comprising a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory are communicated with each other through the communication bus;

a memory for storing a computer program;

a processor for implementing the method of any of claims 1-10 when executing a program stored on a memory.

13. A computer readable storage medium, characterized in that the computer readable storage medium has stored therein a computer program which, when executed by a processor, implements the method of any of claims 1-10.