CN110544162A - Financial data processing method and device, computer equipment and storage medium - Google Patents
Financial data processing method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN110544162A CN110544162A CN201910838438.XA CN201910838438A CN110544162A CN 110544162 A CN110544162 A CN 110544162A CN 201910838438 A CN201910838438 A CN 201910838438A CN 110544162 A CN110544162 A CN 110544162A
- Authority
- CN
- China
- Prior art keywords
- financial system
- document
- order
- financial
- converted
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Computing Systems (AREA)
- Computer Security & Cryptography (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
the application relates to a financial data processing method, a financial data processing device, computer equipment and a storage medium. The method comprises the following steps: monitoring a service system database of each associated service system; when the order data in the business system database is monitored to change, actively pulling order real-time data from the business system database; carrying out format conversion on the order real-time data to obtain a converted financial system document; comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment; and synchronizing the financial system document increment to a financial system database for storage. By adopting the method, the development cost and the waste of human resources can be reduced.
Description
Technical Field
the present application relates to the field of computer technologies, and in particular, to a financial data processing method and apparatus, a computer device, and a storage medium.
background
with the development of computer technology, the intelligent degree of the enterprise financial system is higher and higher. Based on the rapid development requirements of various businesses, an enterprise develops a plurality of business systems, each business system is embedded with a corresponding financial system, and the financial systems are responsible for order data management of the corresponding matched business systems and management of related business system information, namely, each new business system needs to develop a set of corresponding financial systems. However, the data processing flow of the financial system is basically similar, and the repeated development of the financial system causes some waste of development cost and human resources.
Disclosure of Invention
In view of the above, it is necessary to provide a financial data processing method, apparatus, computer device and storage medium capable of reducing development cost and human resource waste.
a method of financial data processing, the method comprising:
Monitoring a service system database of each associated service system;
When the order data in the business system database are monitored to change, actively pulling order real-time data from the business system database;
carrying out format conversion on the order real-time data to obtain a converted financial system document;
Comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment;
Synchronizing the financial system document increment to the financial system database storage.
in one embodiment, the converting the format of the order real-time data to obtain a converted financial system document includes: splitting the order real-time data into orders of corresponding quantity according to the minimum consumable granularity to obtain order details of each split order; and converting the order details of each split order into financial system documents based on a preset financial data template.
in one embodiment, the minimum consumable granularity includes a coupon number or night granularity: splitting the order real-time data into orders of corresponding quantity according to the minimum consumable granularity to obtain order details of each split order, wherein the order details comprise: and splitting the order real-time data into orders of corresponding quantity according to the ticket number or the night granularity to obtain order details of each split order.
In one embodiment, the converting the format of the order real-time data to obtain a converted financial system document includes: obtaining a refund compensation record in the order real-time data; generating an order detail for each refund compensation record; and converting the order details of the refund compensation record into a financial system document based on a preset financial data template.
in one embodiment, the comparing the converted financial system document with the financial system documents stored in the financial system to determine the financial system document increment includes: and comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment according to the newly added and converted financial system document when the newly added and converted financial system document is newly added.
In one embodiment, the comparing the converted financial system document with the financial system documents stored in the financial system to determine the financial system document increment includes: and comparing the converted financial system document with the financial system document stored in the financial system, calculating the variation when the amount of money or the product quantity in the converted financial system document of the same document is changed, and generating the financial system document increment according to the variation.
In one embodiment, the comparing the converted financial system document with the financial system documents stored in the financial system to determine the financial system document increment includes: and comparing the converted financial system document with financial system documents stored in the financial system, and generating two financial system document increments of positive and negative money when the date in the converted financial system document of the same document changes.
A financial data processing apparatus, the apparatus comprising:
The data synchronization module is used for monitoring the service system database of each associated service system; the business system database is used for actively pulling order real-time data from the business system database when monitoring that the order data in the business system database changes;
The data conversion module is used for carrying out format conversion on the order real-time data to obtain a converted financial system document;
the increment determining module is used for comparing the converted financial system document with the financial system document stored in the financial system and determining the financial system document increment;
And the increment storage module is used for synchronizing the financial system bill increment to the financial system database for storage.
A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program:
Monitoring a service system database of each associated service system;
when the order data in the business system database are monitored to change, actively pulling order real-time data from the business system database;
Carrying out format conversion on the order real-time data to obtain a converted financial system document;
Comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment;
Synchronizing the financial system document increment to the financial system database storage.
A computer-readable storage medium, on which a computer program is stored which, when executed by a processor, carries out the steps of:
Monitoring a service system database of each associated service system;
when the order data in the business system database are monitored to change, actively pulling order real-time data from the business system database;
Carrying out format conversion on the order real-time data to obtain a converted financial system document;
Comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment;
Synchronizing the financial system document increment to the financial system database storage.
According to the financial data processing method, the financial data processing device, the computer equipment and the storage medium, the order real-time data of each business system is converted into the standard data of the financial system, namely the financial system bill, by actively pulling the changed order real-time data in the business system database, the corresponding financial system does not need to be repeatedly developed for each business system, the unified flow management of the financial system on the order data of each business system is realized, the operation is convenient, and therefore the development cost and the waste of human resources can be reduced.
drawings
FIG. 1A is a diagram illustrating an exemplary implementation of a method for financial data processing;
FIG. 1B is a diagram illustrating an exemplary implementation of a financial data processing method;
FIG. 2 is a schematic flow chart diagram illustrating a method for financial data processing according to one embodiment;
FIG. 3 is a timing diagram of a method of financial data processing in one embodiment;
FIG. 4 is a schematic diagram illustrating an embodiment of a process for converting real-time data format of an order to obtain a financial system document;
FIG. 5 is a schematic flow chart illustrating conversion of refund compensation records into financial system documents in accordance with one embodiment;
FIG. 6 is a schematic diagram illustrating an embodiment of a process for determining financial system document increments based on newly added and converted financial system documents;
FIG. 7 is a schematic diagram illustrating an embodiment of a process for determining financial system document increments based on the amount of change in the amount of money or product quantity of the same document;
FIG. 8 is a schematic flow chart illustrating the determination of financial system document increments based on resale of the same document order, in accordance with an embodiment;
FIG. 9 is a block diagram of a financial data processing apparatus;
FIG. 10 is a block diagram of another financial data processing apparatus;
FIG. 11 is a diagram of the internal structure of a computer device in one embodiment;
Fig. 12 is an internal structural view of a computer device in another embodiment.
Detailed Description
in order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
the financial data processing method provided by the application can be applied to the application environment shown in FIG. 1A. As shown in FIG. 1A, the application environment involves a device 102, a device 108, a financial system database 104, a business system database 106, and a network 110, wherein the financial system is installed on the device 102, the business system is installed on the device 108, and the financial system on the device 102 and the business system on the device 108 can communicate via the network 110. The financial systems on the devices 102 and the financial systems database 104 may be in direct communication with each other or may be in communication via the network 110. The business systems on the devices 108 may communicate directly with the business system database 106 or may communicate over the network 110.
In some embodiments, as shown in FIG. 1B, the financial system database 104 may also be located integral to the device 102, i.e., the financial system and financial system database are located on the same device 102. Similarly, in some embodiments, the service system database 106 may also be integrated with the device 108, i.e., the service system and the service system database are located on the same device 108.
specifically, the device 102 monitors the business system database 106 of the associated device 108, and when it is monitored that the order data in the business system database 106 changes, actively pulls the order real-time data from the business system database 106, performs format conversion on the pulled order real-time data to obtain a converted financial system document, compares the converted financial system document with the financial system documents stored in the financial system, determines a financial system document increment, and synchronizes the financial system document increment to the financial system database 104 for storage. The device 102 and the device 108 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, and may also be implemented as an independent server or a server cluster composed of a plurality of servers. Financial system database 104 and business system database 106 may be separate databases or may be on device 102 and device 108, respectively. The network 110 may be implemented as a local area network.
In one embodiment, as shown in fig. 2 and 3, a financial data processing method is provided, which is described by way of example as the method applied to the device 102 in fig. 1, and comprises the following steps:
Step 202, the service system database of each associated service system is monitored.
Specifically, a financial system on a device monitors a business system database of associated business systems on other devices within a certain area via a network (e.g., a local area network). For example, the financial system may check for changes in update times of the order data in the business system database, and then monitor the business system database for changes in the order data.
The financial system and the business system can be application software on terminal equipment developed by an enterprise, and can provide related application display pages for a user to browse and view. The application software may be a browser or other application that can display the content of a page. The application software may be a browser or other application that can display the content of a page. Controls, such as operation buttons, for generating functional operation instructions may be displayed in the page. Tabs of different contents can be displayed on application interfaces of the financial system and the business system, such as a financial system database on the financial system and a business system database on the business system. The financial system database and the business system database are used for storing data, such as orders, commissions, refunds and the like, and can be located on the database management system of the equipment, and users can add, inquire, update, delete and the like to the data in the database management system.
and step 204, actively pulling order real-time data from the business system database when the order data in the business system database is monitored to change.
specifically, when order data in the business system database changes, the financial system monitors the change of the order data and then obtains the order real-time data through the business system interface. The order data in the business system database comprises order related data such as sales, real income, base price, commission, order table, refund table, compensation table and the like. The order real-time data represents the order data of the business system after the change.
in one embodiment, the financial system monitors the order data in the business system database by monitoring a timestamp field corresponding to the order data, and if the timestamp field is updated, the order data is determined to be changed. Specifically, the financial system can set a preset interval duration for a timestamp field of a business system database to monitor, when order data of the business system changes, the business system database can automatically update the timestamp field of the changed order data, the financial system compares the last monitoring time with the current monitoring time, and if a timestamp between the last monitoring time and the current monitoring time exists, the timestamp field is considered to be updated. When the timestamp field of the business system database is updated, the financial system monitors the changed timestamp field, so that the order data corresponding to the timestamp field is judged to be changed.
The preset interval duration can be preset by a user, a server or a terminal, and if the preset interval duration is reached, the financial system reads a timestamp field of the preset interval duration, wherein the timestamp field comprises a starting timestamp field and an ending timestamp field. The preset interval duration is set, for example, 30 seconds. The contents of the timestamp field include the specific year, month, date, hour, minute, second, such as 2019, 7, month, 1, day, 20, 39, minute, 5 seconds.
In this embodiment, financial system is through the timestamp field of monitoring service system database to judge whether order data changes, can acquire the order data that changes fast, become the control of timestamp field with loaded down with trivial details order data monitoring, improved the efficiency of financial system actual monitoring.
in another embodiment, when the financial system actively pulls order real-time data and the order synchronous interface of the business system returns no data, order synchronous error early warning information is sent. Specifically, the financial system can send out order synchronization error early warning information through other application programs or alarm programs carried by the system, and the order synchronization error early warning information is displayed on an application interface of the financial system for a user to check.
in this embodiment, when the financial system cannot acquire real-time order data, sending out early warning information of order synchronization errors helps a user to actively find out problems occurring in the system, timely solve the problem of order data synchronization, and avoid the influence on the accuracy of financial data processing due to the order data synchronization errors.
and step 206, carrying out format conversion on the order real-time data to obtain the converted financial system document.
the financial system carries out format conversion on the order real-time data actively pulled from the business system interface, and converts the order data of the business system into standard data of the financial system, wherein the standard data of the financial system is the financial system bill. Specifically, the financial system converts the order data of each service system obtained synchronously into a format required by the financial system through a series of data converters carried by the system, and each pair of service systems needs to realize a data synchronization-conversion process.
Among other things, financial system documents are used to represent the credence of financial transactions, i.e., debts, between external corporations or individuals and businesses, including accounts receivable, accounts payable, bills of collection, and bills of payment. The receivable bill is the creditor certificate of the enterprise, namely the money certificate owed to the enterprise by the current user. The payable is the debt voucher of the enterprise, namely the money voucher owed by the enterprise to the current household. The receipt is the receipt voucher of the enterprise, i.e. the voucher of the enterprise receiving the money of the current user. The payment bill is the payment certificate of the enterprise, namely the certificate of the enterprise paying to the coming and going users. The visiting users, i.e. the external groups or individuals with which the business is transacted, include customers, suppliers, and promoters.
Specifically, in an embodiment, the financial system splits the obtained real-time data of the order according to the minimum consumption granularity of the order, obtains a split order detail after splitting the order into the corresponding number of orders, and converts the split order detail into the financial system document according to a preset financial data template to obtain the converted financial system document.
In the embodiment, the order real-time data is split and then converted into the financial system document, so that the accuracy of financial data processing can be ensured, and the problem that the converted financial system document is inaccurate is avoided.
and 208, comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment.
The converted financial system bill corresponds to the changed business system order data, namely order real-time data, and the financial system bill stored in the financial system corresponds to the business system order data before the change. And comparing the converted financial system document with the financial system document stored in the financial system, calculating a difference value between the converted financial system document and the financial system document, and taking the difference value as a financial system document increment. The financial system document increment comprises newly added and converted financial system documents, the change fund amount of the same financial system document, the change date record of the same financial system document and the like.
And step 210, synchronizing the financial system bill increment to a financial system database for storage.
The order data of the financial system is stored and displayed in a financial system database in an incremental mode, and the financial system synchronizes financial system document increments to the financial system database for storage.
According to the financial data processing method, the financial data processing device, the computer equipment and the storage medium, the order real-time data of each business system is converted into the standard data of the financial system, namely the financial system bill, by actively pulling the changed order real-time data in the business system database, the corresponding financial system does not need to be repeatedly developed for each business system, the unified flow management of the financial system on the order data of each business system is realized, the operation is convenient, and therefore the development cost and the waste of human resources can be reduced. And the converted financial system document is compared with the financial system document stored in the financial system, the financial system document increment is determined, and only the financial system document increment is synchronized to the financial system database for storage, so that the data synchronization efficiency is improved.
in one embodiment, as shown in fig. 4, the format conversion of the real-time order data to obtain the converted financial system document includes the following steps:
step 402, splitting the order real-time data into orders of corresponding quantity according to the minimum consumable granularity to obtain order details of each split order.
The minimum consumable granularity comprises a coupon number and night granularity, the coupon number is a consumption certificate after a consumer purchases a product, the consumer can obtain the coupon number in a mobile phone short message mode through a network and consume and use the product by borrowing the coupon number, and the coupon number can also be obtained through a server, the coupon number certificate is printed by self, and the consumption and use of the product are carried out through the coupon number certificate; the night is the number of days the consumer consumes after purchasing the product, one day is at a night granularity.
Specifically, the financial system divides the order real-time data into orders of corresponding quantity according to the ticket number or night granularity, and obtains order details of each divided order. For example, the minimum consumption granularity in the order real-time data is a coupon number, a coupon number is generated every time a consumer consumes, and the financial system obtains an order detail; when a product contains multiple night granularities, such as when a product is consumed for multiple days or consumed across months, the consumer consumes the same product for one day, and the financial system obtains an order detail. The product can be a guest room product, a body-building sports product and the like.
In one embodiment, a secondary reservation sheet of compensation is required, with one order detail generated for each coupon number of the secondary reservation sheet. The secondary reservation bill needing to be compensated means that for part of products, a consumer needs to reserve in advance to pay a part of fees, and the rest fees of the products are compensated before or after consumption, namely the consumer needs to pay a compensation fee, and the financial system generates an order detail for each ticket number in the splitting process of the secondary reservation bill needing to be compensated.
and step 404, converting the order details of each split order into financial system documents based on a preset financial data template.
and the financial system converts the details of each order obtained after the order is detached into the format of the financial system document according to a preset financial data template. Wherein the preset financial data template can be preset by a user, a server or a terminal.
specifically, when the order details comprise at least one of a purchase order, a supplier compensation order, a commission record and a purchase commission charge, the financial system converts the order into a payable order in the financial system document according to a preset financial data template; when the order details include at least one of a customer refund order, a supplier withdrawal order, and a commission withdrawal order, the financial system converts to a payment order in the financial system document according to a preset financial data template; when the order details comprise at least one of a sales order and a sales commission, the financial system converts the order into an order to be received in the financial system document according to a preset financial data template; when the order detail comprises a collection flow, the financial system converts the order into a collection list in the financial system document according to a preset financial data template.
In the embodiment, the financial system splits the order real-time data according to the ticket number or night granularity, can clearly and unambiguously split the complex order, and converts the complex order into the financial system document according to the split result, so that the problem of inaccurate financial document is avoided.
In one embodiment, as shown in fig. 5, the format conversion of the real-time order data to obtain the converted financial system document includes the following steps:
step 502, obtaining refund compensation records in order real-time data, and generating an order detail for each refund compensation record.
step 504, converting the order details of the refund compensation record into financial system documents based on a preset financial data template.
The refund compensation record refers to that when a consumer is not satisfied with the service or the product, if the received product is damaged, the enterprise needs to compensate the consumer with a compensation fee. Refund compensation is a partial refund, i.e., not a full refund. Specifically, the financial system generates a red order detail according to each refund compensation record in the order real-time data, and converts the order detail generated according to each refund compensation record into a financial system bill based on a preset financial data template.
In this embodiment, each refund compensation record is generated into an order detail according to the refund compensation record, so that individual data management of the refund compensation records can be realized, and financial data conversion can be realized better.
In one embodiment, as shown in fig. 6, comparing the converted financial system document with the financial system documents stored in the financial system to determine the financial system document increment includes: and comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment according to the newly added and converted financial system document when the newly added and converted financial system document is newly added.
The financial system compares the converted financial system document with the previously stored financial system document, and when the converted financial system document is found not to be the originally stored financial system document of the financial system and is a newly added converted financial system document, the financial system determines the amount data of the newly added converted financial system document as the financial system document increment. For example, when a new coupon number is added, the financial system generates a financial system document increment with positive amount, and the financial system document increment is amount data corresponding to the newly added and converted financial system document. And when the converted financial system document is found to be the originally stored financial system document of the financial system and the corresponding note number of the document is invalidated, the financial system generates a financial system document increment with negative money.
In the embodiment, the converted financial system document is compared with the financial system document stored in the financial system, the financial system document increment is determined according to the amount data of the newly added and converted financial system document, and the newly added order data of the business system is recorded in the form of the financial system document increment, so that the unified management of the financial system is realized conveniently.
in one embodiment, as shown in fig. 7, comparing the converted financial system document with the financial system documents stored in the financial system to determine the financial system document increment includes: and comparing the converted financial system document with the financial system document stored in the financial system, calculating the variation when the amount of money or the product quantity in the converted financial system document of the same document is changed, and generating the financial system document increment according to the variation.
Specifically, when the converted financial system document of the same document is compared with the stored financial system document and the amount of money is changed, the financial system calculates the amount data variable of the converted financial system document and the stored financial system document, the amount data variable can be subtracted by the converted financial system document amount data, and a corresponding financial system document increment is generated according to the amount variable. For example, the financial system bill amount data is 100 yuan for the first synchronization, the converted financial system bill amount data is 150 yuan for the second synchronization, the variation is 50 yuan, and the financial system generates a 50 yuan financial system bill increment.
And when the converted financial system document of the same document is compared with the stored financial system document and the product quantity is changed, the financial system calculates the product quantity variable quantity of the financial system document and the stored financial system document, so that corresponding amount data is calculated according to the product quantity variable quantity, and a corresponding financial system document increment is generated according to the amount data. For example, if the number of originally purchased products is 3, 1 part of the products is returned, and the unit price of 1 part of the products is 200 yuan, the amount data corresponding to 1 part of the returned products is 200 yuan, and the financial system generates a financial system bill increment of-200 yuan. Similarly, if the number of copies is 1, a 200-element increment of the financial system document is generated.
in this embodiment, the change of the amount or the product quantity is determined according to the change of the financial system document converted from the same document compared with the stored financial system document, so as to determine the amount data variation corresponding to the change, and the financial system document increment is generated according to the amount data variation.
In one embodiment, as shown in fig. 8, comparing the converted financial system document with the financial system documents stored in the financial system to determine the financial system document increment includes: and comparing the converted financial system document with financial system documents stored in the financial system, and generating two financial system document increments of positive and negative money when the date in the converted financial system document of the same document is changed.
Specifically, dates of the financial system documents converted from the same document are compared with dates of stored financial system documents, when the dates are found to be changed, when the order is subjected to time change, for example, first synchronization is carried out, the order use date is 2018-10-01, the amount of money is 100 yuan, the order is synchronized for the second time, the order use date is 2018-10-01, the amount of money is 100 yuan, two financial system document increments with positive and negative amounts are generated, for example, the amount of money synchronized for the first time is-100 yuan, and the amount of money synchronized for the second time is 100 yuan.
In the embodiment, the financial system bill increment is determined through the order renewal, so that a user can find the change of order data, the data processing flow of the financial system can be simplified, order records do not need to be added, and the order data change is directly determined according to the financial system bill increment.
It should be understood that although the various steps in the flow charts of fig. 2-8 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least some of the steps in fig. 2-8 may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performance of the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternating with other steps or at least some of the sub-steps or stages of other steps.
in one embodiment, as shown in FIG. 9, there is provided a financial data processing apparatus 900 comprising: a data synchronization module 902, a data conversion module 904, an increment determination module 906, and an increment storage module 908, wherein:
a data synchronization module 902, configured to monitor a service system database of each associated service system; and the method is used for actively pulling order real-time data from the business system database when the order data in the business system database is monitored to change.
And the data conversion module 904 is configured to perform format conversion on the order real-time data to obtain a converted financial system document.
And the increment determining module 906 is used for comparing the converted financial system document with the financial system document stored in the financial system to determine the financial system document increment.
an incremental store module 908 for incrementally synchronizing the financial system documents to the financial system database store.
in one embodiment, as shown in fig. 10, the data conversion module 904 further comprises: the order splitting module 910 is configured to split the order real-time data into orders of a corresponding number according to the minimum consumable granularity, so as to obtain order details of each split order; and converting the order details of each split order into financial system documents based on a preset financial data template.
In one embodiment, the order splitting module 910 further includes: the minimum consumable granularity includes a coupon number or an overnight granularity; splitting the order real-time data into orders of corresponding quantity according to the minimum consumable granularity to obtain order details of each split order, wherein the order details comprise: and splitting the order real-time data into orders of corresponding quantity according to the ticket number or the night granularity to obtain order details of each split order.
In one embodiment, the data conversion module 904 further comprises: obtaining refund compensation records in order real-time data; generating an order detail for each refund compensation record; and converting the order details of the refund compensation record into a financial system document based on a preset financial data template.
in one embodiment, the increment determination module 906 further includes: and comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment according to the newly added and converted financial system document when the newly added and converted financial system document is newly added.
In one embodiment, the increment determination module 906 further includes: and comparing the converted financial system document with the financial system document stored in the financial system, calculating the variation when the amount of money or the product quantity in the converted financial system document of the same document is changed, and generating the financial system document increment according to the variation.
In one embodiment, the increment determination module 906 further includes: and comparing the converted financial system document with financial system documents stored in the financial system, and generating two financial system document increments of positive and negative money when the date in the converted financial system document of the same document is changed.
for the specific limitations of the financial data processing means, reference may be made to the above limitations of the financial data processing method, which are not described in detail herein. The various modules in the financial data processing apparatus described above may be implemented in whole or in part by software, hardware, and combinations thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as shown in fig. 11. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer device is used for storing business data and financial data. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a financial data processing method.
In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as shown in fig. 12. The computer device includes a processor, a memory, a network interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a financial data processing method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.
It will be appreciated by those skilled in the art that the configurations shown in fig. 11 and 12 are block diagrams of only some of the configurations relevant to the present disclosure, and do not constitute a limitation on the computing devices to which the present disclosure may be applied, and that a particular computing device may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program:
monitoring a service system database of each associated service system;
When the order data in the business system database is monitored to change, actively pulling order real-time data from the business system database;
Carrying out format conversion on the order real-time data to obtain a converted financial system document;
Comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment;
And synchronizing the financial system document increment to a financial system database for storage.
In one embodiment, the processor, when executing the computer program, further performs the steps of: carrying out format conversion on the order real-time data to obtain a converted financial system document, and the method comprises the following steps: splitting the order real-time data into orders of corresponding quantity according to the minimum consumable granularity to obtain order details of each split order; and converting the order details of each split order into financial system documents based on a preset financial data template.
In one embodiment, the processor, when executing the computer program, further performs the steps of: the minimum consumable granularity includes a coupon number or an overnight granularity; splitting the order real-time data into orders of corresponding quantity according to the minimum consumable granularity to obtain order details of each split order, wherein the order details comprise: and splitting the order real-time data into orders of corresponding quantity according to the ticket number or the night granularity to obtain order details of each split order.
In one embodiment, the processor, when executing the computer program, further performs the steps of: carrying out format conversion on the order real-time data to obtain a converted financial system document, and the method comprises the following steps: obtaining refund compensation records in order real-time data; generating an order detail for each refund compensation record; and converting the order details of the refund compensation record into a financial system document based on a preset financial data template.
in one embodiment, the processor, when executing the computer program, further performs the steps of: comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment, comprising: and comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment according to the newly added and converted financial system document when the newly added and converted financial system document is newly added.
In one embodiment, the processor, when executing the computer program, further performs the steps of: comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment, comprising: and comparing the converted financial system document with the financial system document stored in the financial system, calculating the variation when the amount of money or the product quantity in the converted financial system document of the same document is changed, and generating the financial system document increment according to the variation.
In one embodiment, the processor, when executing the computer program, further performs the steps of: comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment, comprising: and comparing the converted financial system document with financial system documents stored in the financial system, and generating two financial system document increments of positive and negative money when the date in the converted financial system document of the same document is changed.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of:
Monitoring a service system database of each associated service system;
When the order data in the business system database is monitored to change, actively pulling order real-time data from the business system database;
carrying out format conversion on the order real-time data to obtain a converted financial system document;
Comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment;
and synchronizing the financial system document increment to a financial system database for storage.
In one embodiment, the computer program when executed by the processor further performs the steps of: carrying out format conversion on the order real-time data to obtain a converted financial system document, and the method comprises the following steps: splitting the order real-time data into orders of corresponding quantity according to the minimum consumable granularity to obtain order details of each split order; and converting the order details of each split order into financial system documents based on a preset financial data template.
in one embodiment, the computer program when executed by the processor further performs the steps of: the minimum consumable granularity includes a coupon number or an overnight granularity; splitting the order real-time data into orders of corresponding quantity according to the minimum consumable granularity to obtain order details of each split order, wherein the order details comprise: and splitting the order real-time data into orders of corresponding quantity according to the ticket number or the night granularity to obtain order details of each split order.
In one embodiment, the computer program when executed by the processor further performs the steps of: carrying out format conversion on the order real-time data to obtain a converted financial system document, and the method comprises the following steps: obtaining refund compensation records in order real-time data; generating an order detail for each refund compensation record; and converting the order details of the refund compensation record into a financial system document based on a preset financial data template.
in one embodiment, the computer program when executed by the processor further performs the steps of: comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment, comprising: and comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment according to the newly added and converted financial system document when the newly added and converted financial system document is newly added.
In one embodiment, the computer program when executed by the processor further performs the steps of: comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment, comprising: and comparing the converted financial system document with the financial system document stored in the financial system, calculating the variation when the amount of money or the product quantity in the converted financial system document of the same document is changed, and generating the financial system document increment according to the variation.
in one embodiment, the computer program when executed by the processor further performs the steps of: comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment, comprising: and comparing the converted financial system document with financial system documents stored in the financial system, and generating two financial system document increments of positive and negative money when the date in the converted financial system document of the same document is changed.
it will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
the technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A method of financial data processing, the method comprising:
Monitoring a service system database of each associated service system;
When the order data in the business system database are monitored to change, actively pulling order real-time data from the business system database;
carrying out format conversion on the order real-time data to obtain a converted financial system document;
comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment;
Synchronizing the financial system document increment to the financial system database storage.
2. The method of claim 1, wherein converting the format of the real-time order data to obtain a converted financial system document comprises:
splitting the order real-time data into orders of corresponding quantity according to the minimum consumable granularity to obtain order details of each split order;
And converting the order details of each split order into financial system documents based on a preset financial data template.
3. the method of claim 2, wherein the minimum consumable granularity comprises a coupon number or night granularity:
Splitting the order real-time data into orders of corresponding quantity according to the minimum consumable granularity to obtain order details of each split order, wherein the order details comprise: and splitting the order real-time data into orders of corresponding quantity according to the ticket number or the night granularity to obtain order details of each split order.
4. the method of claim 1, wherein converting the format of the real-time order data to obtain a converted financial system document comprises:
Obtaining a refund compensation record in the order real-time data;
generating an order detail for each refund compensation record;
And converting the order details of the refund compensation record into a financial system document based on a preset financial data template.
5. The method of claim 1, wherein comparing the converted financial system document to financial system documents stored by the financial system to determine the financial system document increment comprises:
And comparing the converted financial system document with the financial system document stored in the financial system, and determining the financial system document increment according to the newly added and converted financial system document when the newly added and converted financial system document is newly added.
6. The method of claim 1, wherein comparing the converted financial system document to financial system documents stored by the financial system to determine the financial system document increment comprises:
And comparing the converted financial system document with the financial system document stored in the financial system, calculating the variation when the amount of money or the product quantity in the converted financial system document of the same document is changed, and generating the financial system document increment according to the variation.
7. The method of claim 1, wherein comparing the converted financial system document to financial system documents stored by the financial system to determine the financial system document increment comprises:
And comparing the converted financial system document with financial system documents stored in the financial system, and generating two financial system document increments of positive and negative money when the date in the converted financial system document of the same document changes.
8. A financial data processing apparatus, characterised in that the apparatus comprises:
The data synchronization module is used for monitoring the service system database of each associated service system; the business system database is used for actively pulling order real-time data from the business system database when monitoring that the order data in the business system database changes;
The data conversion module is used for carrying out format conversion on the order real-time data to obtain a converted financial system document;
the increment determining module is used for comparing the converted financial system document with the financial system document stored in the financial system and determining the financial system document increment;
And the increment storage module is used for synchronizing the financial system bill increment to the financial system database for storage.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method of any of claims 1 to 7 are implemented when the computer program is executed by the processor.
10. a computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910838438.XA CN110544162A (en) | 2019-09-05 | 2019-09-05 | Financial data processing method and device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910838438.XA CN110544162A (en) | 2019-09-05 | 2019-09-05 | Financial data processing method and device, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110544162A true CN110544162A (en) | 2019-12-06 |
Family
ID=68712599
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910838438.XA Pending CN110544162A (en) | 2019-09-05 | 2019-09-05 | Financial data processing method and device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110544162A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111274299A (en) * | 2020-01-19 | 2020-06-12 | 北京三快在线科技有限公司 | Data processing method, device, system and storage medium |
| CN112232755A (en) * | 2020-09-16 | 2021-01-15 | 金蝶软件（中国）有限公司 | Receipt processing method and device, computer equipment and storage medium |
| CN113157787A (en) * | 2021-04-06 | 2021-07-23 | 中信百信银行股份有限公司 | Accounting processing method and device, electronic equipment and readable storage medium |
| CN113793205A (en) * | 2021-09-18 | 2021-12-14 | 上海中通吉网络技术有限公司 | Financial data construction method and system based on business data |
| CN114638543A (en) * | 2022-04-12 | 2022-06-17 | 中国工商银行股份有限公司 | Document auditing method and device, computer equipment and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108241934A (en) * | 2016-12-23 | 2018-07-03 | 北京京东尚科信息技术有限公司 | Data query method and apparatus |
| CN109558441A (en) * | 2018-10-25 | 2019-04-02 | 平安科技（深圳）有限公司 | Financial index automatic monitoring method, device, computer equipment and storage medium |
-
2019
- 2019-09-05 CN CN201910838438.XA patent/CN110544162A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108241934A (en) * | 2016-12-23 | 2018-07-03 | 北京京东尚科信息技术有限公司 | Data query method and apparatus |
| CN109558441A (en) * | 2018-10-25 | 2019-04-02 | 平安科技（深圳）有限公司 | Financial index automatic monitoring method, device, computer equipment and storage medium |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111274299A (en) * | 2020-01-19 | 2020-06-12 | 北京三快在线科技有限公司 | Data processing method, device, system and storage medium |
| CN112232755A (en) * | 2020-09-16 | 2021-01-15 | 金蝶软件（中国）有限公司 | Receipt processing method and device, computer equipment and storage medium |
| CN113157787A (en) * | 2021-04-06 | 2021-07-23 | 中信百信银行股份有限公司 | Accounting processing method and device, electronic equipment and readable storage medium |
| CN113793205A (en) * | 2021-09-18 | 2021-12-14 | 上海中通吉网络技术有限公司 | Financial data construction method and system based on business data |
| CN114638543A (en) * | 2022-04-12 | 2022-06-17 | 中国工商银行股份有限公司 | Document auditing method and device, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110544162A (en) | Financial data processing method and device, computer equipment and storage medium | |
| US7729930B1 (en) | Systems and methods for insurance coverage | |
| CN110599276B (en) | Bill reimbursement method, device and equipment and computer storage medium | |
| US8738476B2 (en) | Architectural design for selling standardized services application software | |
| JP7377832B2 (en) | Program, information processing device and method | |
| US11966972B2 (en) | Generating graphical user interfaces comprising dynamic credit value user interface elements determined from a credit value model | |
| CN110472895B (en) | Financial system wind control method and device, computer equipment and storage medium | |
| JP6568547B2 (en) | Information processing apparatus, information processing method, and program | |
| CN113362025B (en) | Data accounting system, method, computer-readable storage medium, and electronic device | |
| WO2022247964A1 (en) | Receipt processing method and apparatus, electronic device, and storage medium | |
| CN114187061B (en) | System and method for dynamic scheduling of data processing | |
| Demoč et al. | Proposal for optimization of information system | |
| JP6190935B1 (en) | Transaction proposal system, transaction proposal method, and transaction proposal program | |
| CN117350869A (en) | Financial document generation method, apparatus, electronic device and computer readable storage medium | |
| JP6976626B1 (en) | Programs, systems and methods | |
| CN114742547A (en) | Internet online collection control method, device, medium and electronic equipment | |
| KR20220119919A (en) | Server for providing simple tax payment service, system, and computer program | |
| CN111861594A (en) | Invoice processing method, invoice processing device, storage medium and processor | |
| JP7514411B1 (en) | PROGRAM, INFORMATION PROCESSING APPARATUS AND METHOD | |
| JP7466743B1 (en) | PROGRAM, INFORMATION PROCESSING APPARATUS AND METHOD | |
| JP2020091819A (en) | Transaction method for electric power derived from renewable energy, and transaction system | |
| CN113971007B (en) | Information processing method, device, electronic equipment and medium | |
| JP7566102B1 (en) | PROGRAM, INFORMATION PROCESSING APPARATUS AND METHOD | |
| JP7373830B2 (en) | Business expense reimbursement support system, business support device, reimbursement support device, and program | |
| JP2023159633A (en) | Service ticket providing device, service ticket providing method, program, and recording 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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20191206 |
|
| RJ01 | Rejection of invention patent application after publication |