CN114331653A - Processing method and device for to-and-fro ledger data - Google Patents
Processing method and device for to-and-fro ledger data Download PDFInfo
- Publication number
- CN114331653A CN114331653A CN202111632966.3A CN202111632966A CN114331653A CN 114331653 A CN114331653 A CN 114331653A CN 202111632966 A CN202111632966 A CN 202111632966A CN 114331653 A CN114331653 A CN 114331653A
- Authority
- CN
- China
- Prior art keywords
- data
- target
- standing book
- ledger
- fro
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a processing method and a device of forward and backward standing book data, wherein the method comprises the following steps: in response to the current standing book data generation instruction, screening out a target object and target standing book data related to the current standing book data generation instruction from a preset database; recording all target objects and target ledger data in a current management ledger table according to a preset recording rule to obtain first current ledger data; checking and correcting the first to-and-fro ledger data to obtain target to-and-fro ledger data; and determining abnormal data conditions in the target to-and-fro ledger data, and determining whether to send a prompt instruction according to the abnormal data conditions. The method has the advantages that the standing book data are recorded and checked in a process automation mode, data capture analysis is carried out on the target standing book data, a closed-loop management mechanism of the current standing book data is achieved, and the problems of long consumed time, low accuracy and low efficiency of the current processing mode of the current standing book data are solved.
Description
Technical Field
The invention relates to the technical field of ledger data management, in particular to a method and a device for processing commuter ledger data.
Background
For a long time, the processing mode of the current ledger data mainly comprises the steps of manually completing work such as account statement filling, audit early warning and the like, on one hand, the processing mode increases burden for basic level staff, on the other hand, the accuracy and the processing flow normalization of the current ledger data cannot be guaranteed, and further the situations that the processing of the current ledger data consumes more time, the accuracy is low and the efficiency is low are caused.
Disclosure of Invention
The invention provides a processing method and device of to-and-fro standing book data, which are used for solving the problems of long time consumption, low accuracy and low efficiency of the existing to-and-fro standing book data processing mode.
In a first aspect, the present invention provides a method for processing commuter ledger data, including:
in response to a current standing book data generation instruction, screening out a target object and target standing book data related to the current standing book data generation instruction from a preset database;
recording all the target objects and the target ledger data in a current management ledger table according to a preset recording rule to obtain first current ledger data;
checking and correcting the first to-and-fro ledger data to obtain target to-and-fro ledger data;
and determining abnormal data conditions in the target to-and-fro ledger data, and determining whether to send a prompt instruction according to the abnormal data conditions.
Optionally, in response to the current standing book data generation instruction, screening out a target object and a target standing book related to the current standing book data generation instruction from a preset database, including:
responding to the to-and-fro standing book data generation instruction, and identifying an operation time interval and the target object in the to-and-fro standing book data;
screening initial data related to the target object from the database;
and eliminating data irrelevant to the operation time interval in the initial data to obtain the target machine account.
Optionally, determining an abnormal data condition in the target commuter ledger data, and determining whether to issue a prompt instruction according to the abnormal data condition, includes:
s41, judging whether the target commuter ledger data has abnormal data condition; if yes, go to step S42; if not, go to step S43;
s42, determining the type of the abnormal data, and further judging whether the abnormal data generates an abnormal threshold value corresponding to the type, if so, sending the prompt instruction; if not, go to step S43; the categories of the anomaly data include: overdue account data, account posting data and associated transaction abnormal data;
and S43, defining that the target commuter ledger data is normal.
Optionally, determining an abnormal data condition in the target commuter ledger data, and determining whether to issue a prompt instruction according to the abnormal data condition, further includes:
and generating a log record based on the target transaction ledger data.
In a second aspect, the present invention further provides a device for processing commuter ledger data, including:
the response module is used for responding to the current standing book data generation instruction and screening out a target object and target standing book data related to the current standing book data generation instruction from a preset database;
the recording module is used for recording all the target objects and the target account data in a current management account table according to a preset recording rule to obtain first current account data;
the checking module is used for checking and correcting the first to-and-fro ledger data to obtain target to-and-fro ledger data;
and the judging module is used for determining the abnormal data condition in the target transaction ledger data and determining whether to send a prompt instruction according to the abnormal data condition.
Optionally, the response module includes:
the identification submodule is used for responding to the to-and-fro standing book data generation instruction and identifying an operation time interval and the target object in the to-and-fro standing book data;
the screening submodule is used for screening initial data related to the target object from the database;
and the eliminating submodule is used for eliminating data which is irrelevant to the operation time interval in the initial data to obtain the target machine account.
Optionally, the determining module includes:
the first judgment submodule is used for judging whether the abnormal data condition exists in the target current ledger data; if yes, executing a second judgment submodule; if not, executing the definition submodule;
the second judgment submodule is used for determining the type of the abnormal data and further judging whether the abnormal data output an abnormal threshold value corresponding to the type, and if so, sending the prompt instruction; if not, executing the definition submodule; the categories of the anomaly data include: overdue account data, account posting data and associated transaction abnormal data;
and the definition submodule is used for defining the normality of the target transaction ledger data.
Optionally, the method further comprises:
and the log generation module is used for generating log records based on the target transaction ledger data.
A third aspect of the application provides an electronic device comprising a processor and a memory;
the memory is used for storing program codes and transmitting the program codes to the processor;
the processor is configured to execute the power distribution network regional relay protection method according to the instruction in the program code.
A fourth aspect of the present application provides a computer-readable storage medium, which is configured to store program codes, where the program codes are configured to execute the power distribution network domain relay protection method according to the first aspect.
According to the technical scheme, the invention has the following advantages:
according to the method, a command is generated by responding to the current standing book data, and a target object and target standing book data which are related to the current standing book data generation command are screened out from a preset database; recording all the target objects and the target ledger data in a current management ledger table according to a preset recording rule to obtain first current ledger data; checking and correcting the first to-and-fro ledger data to obtain target to-and-fro ledger data; and determining abnormal data conditions in the target to-and-fro ledger data, and determining whether to send a prompt instruction according to the abnormal data conditions. The method comprises the steps of recording and checking the standing book data in a process automation mode to obtain target standing book data, then carrying out data capture analysis on the target standing book data to determine the specific situation of the target standing book data, realizing a closed-loop management mechanism for the previous standing book data, and overcoming the problems of long consumed time, low accuracy and low efficiency existing in the existing previous standing book data processing mode.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts;
fig. 1 is a flowchart illustrating steps of a first embodiment of a method for processing transactional ledger data according to the present invention;
FIG. 2 is a flowchart illustrating steps of a second embodiment of a method for processing transactional ledger data according to the present invention;
fig. 3 is a block diagram of an embodiment of a processing apparatus for processing forward ledger data according to the present invention.
Detailed Description
The embodiment of the invention provides a processing method and device of to-and-fro standing book data, which are used for solving the problems of long time consumption, low accuracy and low efficiency of the existing to-and-fro standing book data processing mode.
In order to make the objects, features and advantages of the present invention more obvious and understandable, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is obvious that the embodiments described below are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, fig. 1 is a flowchart illustrating a first step of a processing method of forward and backward standing book data according to a first embodiment of the present invention, which may specifically include the following steps:
step S101, in response to a current standing book data generation instruction, screening out a target object and target standing book data related to the current standing book data generation instruction from a preset database;
step S102, recording all the target objects and the target account data in a current management account table according to a preset recording rule to obtain first current account data;
step S103, checking and correcting the first to-and-fro ledger data to obtain target to-and-fro ledger data;
and step S104, determining abnormal data conditions in the target commuter ledger data, and determining whether to send a prompt instruction according to the abnormal data conditions.
In the embodiment of the invention, a target object and target standing book data related to a current standing book data generation instruction are screened out from a preset database by responding to the current standing book data generation instruction; recording all the target objects and the target ledger data in a current management ledger table according to a preset recording rule to obtain first current ledger data; checking and correcting the first to-and-fro ledger data to obtain target to-and-fro ledger data; and determining abnormal data conditions in the target to-and-fro ledger data, and determining whether to send a prompt instruction according to the abnormal data conditions. The method comprises the steps of recording and checking the standing book data in a process automation mode to obtain target standing book data, then carrying out data capture analysis on the target standing book data to determine the specific situation of the target standing book data, realizing a closed-loop management mechanism for the previous standing book data, and overcoming the problems of long consumed time, low accuracy and low efficiency existing in the existing previous standing book data processing mode.
Referring to fig. 2, a flowchart of a second step of a processing method of the present invention for the current ledger data specifically includes:
step S201, responding to a current standing book data generation instruction, and identifying an operation time interval and the target object in the current standing book data;
in the embodiment of the invention, after the user starts the to-and-fro account standing robot, the screen interface of the robot selects the operation time interval and the specific target object, such as a specific region or a specific enterprise, such as a civil enterprise or an enterprise in a merging range with the enterprise A, and the like, so as to generate the corresponding to-and-fro account standing data generation instruction.
In a specific implementation, the operation time interval and the subject (i.e., the target object) are manually selected, wherein the operation time interval is selected by month, and the target object is selected by the subject code, and the subject is not changed in general.
Step S202, screening out initial data related to the target object from the database;
in the embodiment of the present invention, the preset database may be imported by the system operation and maintenance personnel or the user before selecting the operation time interval and the specific target object.
Step S203, eliminating data irrelevant to the operation time interval in the initial data to obtain the target standing book;
step S204, recording all the target objects and the target account data in a current management account table according to a preset recording rule to obtain first current account data;
in the embodiment of the invention, different target ledgers are derived according to different subjects, and can be obtained according to a renaming format: "certificate entry query-a certain subject", a new folder is created every month. And continuously exporting the subject summary list, and renaming the exported subject summary list to be 'subject summary list-subject name'. And then, automatically recording the information in a certificate entry query table, a civil enterprise list and an internal unit list into a preset table set by a recording rule according to different to-and-fro account hanging and reimbursement rules to obtain first to-and-fro standing book data, and after all the information is recorded, updating the account age and responsibility unit information by the robot according to the recorded data.
Step S205, checking and correcting the first to-and-fro ledger data to obtain target to-and-fro ledger data;
in the embodiment of the present invention, after the recording of the first-pass ledger data is completed, the initial data from step S202 and the first-pass ledger data need to be checked through two processes of robot checking and manual checking. In addition, after the robot derives the first round trip ledger data, the robot needs to check whether the future balance of each round trip unit and organization is consistent with the ledger or not, with the round trip unit and organization in each involved target object as standards.
Step S206, determining abnormal data conditions in the target commuter ledger data, and determining whether to send a prompt instruction according to the abnormal data conditions;
in the embodiment of the invention, the corresponding position of the business account data is entered according to the subject name, and then the updated information of each worker, which is generally accountability, is recorded to the corresponding column number of the corresponding serial number.
In an optional embodiment, determining an abnormal data condition in the target commuter ledger data, and determining whether to issue a prompt instruction according to the abnormal data condition includes:
s2061, judging whether abnormal data exists in the target transaction ledger data or not; if yes, go to step S2062; if not, go to step S2063;
s2062, determining the type of the abnormal data, further judging whether the abnormal data generates an abnormal threshold value corresponding to the type, and if so, sending the prompt instruction; if not, go to step S2063; the categories of the anomaly data include: overdue account data, account posting data and associated transaction abnormal data;
s2063, defining that the target transaction ledger data is normal.
In the embodiment of the invention, the abnormal data in the target transaction ledger data may be one or more of overdue account data, account hanging data and associated transaction abnormal data, thresholds corresponding to different types of abnormal data are preset in the robot, and when the abnormal data exists in the target transaction ledger data and exceeds the type threshold corresponding to the abnormal data, the robot sends a prompt instruction to pay attention to the bank ball user or the staff.
And step S207, generating a log record based on the target transaction ledger data.
In the processing method of the to-and-fro standing book data provided by the embodiment of the invention, the target object and the target standing book data related to the to-and-fro standing book data generation instruction are screened out from the preset database by responding to the to-and-fro standing book data generation instruction; recording all the target objects and the target ledger data in a current management ledger table according to a preset recording rule to obtain first current ledger data; checking and correcting the first to-and-fro ledger data to obtain target to-and-fro ledger data; and determining abnormal data conditions in the target to-and-fro ledger data, and determining whether to send a prompt instruction according to the abnormal data conditions. The method comprises the steps of recording and checking the standing book data in a process automation mode to obtain target standing book data, then carrying out data capture analysis on the target standing book data to determine the specific situation of the target standing book data, realizing a closed-loop management mechanism for the previous standing book data, and overcoming the problems of long consumed time, low accuracy and low efficiency existing in the existing previous standing book data processing mode.
Referring to fig. 3, a block diagram of an embodiment of a device for processing the current ledger data is shown, which includes the following modules:
a response module 401, configured to, in response to the current standing book data generation instruction, screen out, from a preset database, a target object and target standing book data related to the current standing book data generation instruction;
a recording module 402, configured to record all the target objects and the target ledger data in a current management ledger table according to a preset recording rule, so as to obtain first current ledger data;
the checking module 403 is configured to check and correct the first to-and-fro ledger data to obtain target to-and-fro ledger data;
the determining module 404 is configured to determine an abnormal data condition in the target transaction ledger data, and determine whether to issue a prompt instruction according to the abnormal data condition.
In an alternative embodiment, the response module 401 includes:
the identification submodule is used for responding to the to-and-fro standing book data generation instruction and identifying an operation time interval and the target object in the to-and-fro standing book data;
the screening submodule is used for screening initial data related to the target object from the database;
and the eliminating submodule is used for eliminating data which is irrelevant to the operation time interval in the initial data to obtain the target machine account.
In an alternative embodiment, the determining module 404 includes:
the first judgment submodule is used for judging whether the abnormal data condition exists in the target current ledger data; if yes, executing a second judgment submodule; if not, executing the definition submodule;
the second judgment submodule is used for determining the type of the abnormal data and further judging whether the abnormal data output an abnormal threshold value corresponding to the type, and if so, sending the prompt instruction; if not, executing the definition submodule; the categories of the anomaly data include: overdue account data, account posting data and associated transaction abnormal data;
and the definition submodule is used for defining the normality of the target transaction ledger data.
In an optional embodiment, further comprising:
and the log generation module is used for generating log records based on the target transaction ledger data.
The application also provides an electronic device, which comprises a processor and a memory;
the memory is used for storing the program codes and transmitting the program codes to the processor;
the processor is used for executing the processing method of the current ledger data in the above method embodiment according to the instructions in the program code.
The application also provides a computer-readable storage medium for storing a program code for executing the processing method of the past ledger data in the above method embodiment.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for executing all or part of the steps of the method described in the embodiments of the present application through a computer device (which may be a personal computer, a server, or a network device). And the aforementioned storage medium includes: a U disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
The above embodiments are only used for illustrating the technical solutions of the present application, and not for limiting the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions in the embodiments of the present application.
Claims (10)
1. A processing method of the to-and-fro standing book data is characterized by comprising the following steps:
in response to a current standing book data generation instruction, screening out a target object and target standing book data related to the current standing book data generation instruction from a preset database;
recording all the target objects and the target ledger data in a current management ledger table according to a preset recording rule to obtain first current ledger data;
checking and correcting the first to-and-fro ledger data to obtain target to-and-fro ledger data;
and determining abnormal data conditions in the target to-and-fro ledger data, and determining whether to send a prompt instruction according to the abnormal data conditions.
2. The processing method of the current standing book data according to claim 1, wherein the step of screening out a target object and a target standing book related to the current standing book data generation instruction from a preset database in response to the current standing book data generation instruction comprises:
responding to the to-and-fro standing book data generation instruction, and identifying an operation time interval and the target object in the to-and-fro standing book data;
screening initial data related to the target object from the database;
and eliminating data irrelevant to the operation time interval in the initial data to obtain the target machine account.
3. The processing method of the to-and-fro standing book data of claim 1, wherein determining an abnormal data condition in the target to-and-fro standing book data, and determining whether to issue a prompt instruction according to the abnormal data condition comprises:
s41, judging whether the target commuter ledger data has abnormal data condition; if yes, go to step S42; if not, go to step S43;
s42, determining the type of the abnormal data, and further judging whether the abnormal data generates an abnormal threshold value corresponding to the type, if so, sending the prompt instruction; if not, go to step S43; the categories of the anomaly data include: overdue account data, account posting data and associated transaction abnormal data;
and S43, defining that the target commuter ledger data is normal.
4. The processing method of the to-and-fro standing book data of claim 1, wherein after determining an abnormal data condition in the target to-and-fro standing book data and determining whether to issue a prompt instruction according to the abnormal data condition, further comprising:
and generating a log record based on the target transaction ledger data.
5. A processing apparatus for processing to-and-fro ledger data, comprising:
the response module is used for responding to the current standing book data generation instruction and screening out a target object and target standing book data related to the current standing book data generation instruction from a preset database;
the recording module is used for recording all the target objects and the target account data in a current management account table according to a preset recording rule to obtain first current account data;
the checking module is used for checking and correcting the first to-and-fro ledger data to obtain target to-and-fro ledger data;
and the judging module is used for determining the abnormal data condition in the target transaction ledger data and determining whether to send a prompt instruction according to the abnormal data condition.
6. The processing apparatus of the current ledger data of claim 5, characterized in that the response module comprises:
the identification submodule is used for responding to the to-and-fro standing book data generation instruction and identifying an operation time interval and the target object in the to-and-fro standing book data;
the screening submodule is used for screening initial data related to the target object from the database;
and the eliminating submodule is used for eliminating data which is irrelevant to the operation time interval in the initial data to obtain the target machine account.
7. The processing apparatus of the current ledger data according to claim 5, characterized in that the judging module comprises:
the first judgment submodule is used for judging whether the abnormal data condition exists in the target current ledger data; if yes, executing a second judgment submodule; if not, executing the definition submodule;
the second judgment submodule is used for determining the type of the abnormal data and further judging whether the abnormal data output an abnormal threshold value corresponding to the type, and if so, sending the prompt instruction; if not, executing the definition submodule; the categories of the anomaly data include: overdue account data, account posting data and associated transaction abnormal data;
and the definition submodule is used for defining the normality of the target transaction ledger data.
8. The processing apparatus of the current ledger data according to claim 5, characterized by further comprising:
and the log generation module is used for generating log records based on the target transaction ledger data.
9. An electronic device comprising a processor and a memory, the memory storing computer readable instructions that, when executed by the processor, perform the method of any of claims 1-4.
10. A storage medium on which a computer program is stored, which computer program, when being executed by a processor, is adapted to carry out the method according to any one of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111632966.3A CN114331653A (en) | 2021-12-28 | 2021-12-28 | Processing method and device for to-and-fro ledger data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111632966.3A CN114331653A (en) | 2021-12-28 | 2021-12-28 | Processing method and device for to-and-fro ledger data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114331653A true CN114331653A (en) | 2022-04-12 |
Family
ID=81015616
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111632966.3A Pending CN114331653A (en) | 2021-12-28 | 2021-12-28 | Processing method and device for to-and-fro ledger data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114331653A (en) |
-
2021
- 2021-12-28 CN CN202111632966.3A patent/CN114331653A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109242261B (en) | Method for evaluating security risk based on big data and terminal equipment | |
| CA2992444C (en) | A system and method of managing data injection into an executing data processing system | |
| US20120116984A1 (en) | Automated evaluation of compliance data from heterogeneous it systems | |
| US20140006044A1 (en) | System and method for preparing healthcare service bundles | |
| CN108256810B (en) | Insurance business approval process processing method and device | |
| CN110472895B (en) | Financial system wind control method and device, computer equipment and storage medium | |
| CN114862270A (en) | Attendance data processing method and system | |
| US10282353B2 (en) | Proactive duplicate identification | |
| CN106056418A (en) | Invoice submission method, device and system | |
| CN108038667B (en) | Policy generation method, device and equipment | |
| CN111242779A (en) | Financial data characteristic selection and prediction method, device, equipment and storage medium | |
| CN114331653A (en) | Processing method and device for to-and-fro ledger data | |
| CN114202250A (en) | Enterprise evaluation system and method and electronic equipment | |
| CN115600972A (en) | Method, device, equipment and storage medium for verifying and selling of bad assets | |
| CN109828884B (en) | Hanging service data processing method, system, computer equipment and storage medium | |
| JP2019135602A (en) | Information management system and information management method | |
| CN111444217A (en) | Data processing method, device, server and storage medium | |
| JP2007041828A (en) | Sla achieved situation determining method | |
| CN110956552A (en) | Insurance problem processing method, device, equipment and storage medium | |
| JP2020095331A (en) | Unit price appropriateness check device, unit price appropriateness check method, and unit price appropriateness check program | |
| CN115545942A (en) | Method and system for managing and controlling investment information in engineering construction process | |
| CN110750558A (en) | Financial data management method, device, computer equipment and storage medium | |
| CN116433392A (en) | Reinsurance measuring and calculating method, device and equipment | |
| US20210133887A1 (en) | Efficiently aging and modifying policy records in a test system | |
| CN118096011A (en) | Inventory data updating method, updating device, equipment and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |