CN118313939A - Order checking system based on dual-system bill flow - Google Patents
Order checking system based on dual-system bill flow Download PDFInfo
- Publication number
- CN118313939A CN118313939A CN202410422483.8A CN202410422483A CN118313939A CN 118313939 A CN118313939 A CN 118313939A CN 202410422483 A CN202410422483 A CN 202410422483A CN 118313939 A CN118313939 A CN 118313939A
- Authority
- CN
- China
- Prior art keywords
- data
- payment
- parking
- reconciliation
- excel form
- 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
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 claims abstract description 15
- 238000012545 processing Methods 0.000 claims abstract description 9
- 238000000034 method Methods 0.000 claims description 23
- 230000009977 dual effect Effects 0.000 claims description 11
- 238000012795 verification Methods 0.000 claims description 8
- 238000005516 engineering process Methods 0.000 claims description 4
- 238000004590 computer program Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Abstract
The application discloses an order reconciliation system based on double-system bill flow, which relates to the technical field of computers and comprises a parking end acquisition module, a public platform, a payment end acquisition module and a reconciliation module; the parking end acquisition module is used for: inquiring payment running water in a parking system and generating a table as parking data exce l; the payment end acquisition module is used for: inquiring payment running water in a payment system and generating a form as payment data exce l; the public platform is used for: pulling and storing the parking data and the payment data for the parking data exce l form and the payment data exce l form; the reconciliation module is used for: reading and processing the parking data and the payment data into multi-dimensional display data in a unified format; and comparing the parking data with the payment data according to dimensions one by one, storing the found difference in an error pool, and displaying the error pool to a user. According to the application, the situation that financial staff needs to switch different system query data is reduced, and the accounting data checking efficiency of the financial staff is improved.
Description
Technical Field
The application relates to the technical field of computers, in particular to an order reconciliation system based on double-system bill flow.
Background
When the finance checks account of the payment data of the system, the finance is checked by comparing the bill detail page of the parking system with the running water of the payment system, and when the bill is inquired, the account is checked by comparing the amounts inquired by the conditions of the condition screening, the payment mode, the business type, the transaction type, the payment channel provider, the payment store and the like, wherein the process is particularly troublesome, the inquiry of different conditions is repeated for a plurality of times, errors or leakage can be caused by little attention, and the account is checked by multi-system inquiry in the operation process. Financial staff checking time is wasted and frequent billing statement inquiries increase system server pressure when the volume of billing statement data is large.
Disclosure of Invention
The application aims to provide an order checking system based on double-system bill flow so as to solve the technical problems in the background.
In order to achieve the above purpose, the present application discloses the following technical solutions: an order checking system based on double-system bill flow comprises a parking end acquisition module, a public platform, a payment end acquisition module and a checking module;
The parking end acquisition module is configured to: inquiring payment running water in a parking system at regular time, generating a parking data excel form, and uploading the generated parking data excel form to the public platform;
The payment end acquisition module is configured to: inquiring payment running water in a payment system at regular time, generating a payment data excel form, and uploading the generated payment data excel form to the public platform;
The common platform is configured to: pulling and storing the parking data for the parking data excel form, and pulling and storing the payment data for the payment data excel form;
The reconciliation module is configured to: reading parking data and payment data stored on the public platform, and reading and processing the parking data and the payment data into multi-dimensional display data in a unified format; and comparing the multidimensional display data corresponding to the parking data with the multidimensional display data corresponding to the payment data one by one according to dimensions, storing the difference found by the data comparison in an error pool, and displaying the data in the error pool as a reconciliation result to a user.
Preferably, the dimension includes at least two of payment store, paymate information, transaction order number, order amount, transaction type, or payment means.
Preferably, the multidimensional display data is obtained by data sorting the parking data and the payment data according to data contents corresponding to different dimensions.
Preferably, when no difference is found in the data comparison process, the payment data and the parking data are saved as account details as a reconciliation result and presented to the user.
Preferably, the reconciliation module obtains the multidimensional display data through STR INGRED I STEMP L ATE technology.
Preferably, the working method of the order reconciliation system based on the double-system bill flow comprises the following steps:
inquiring payment flowing water in a parking system at fixed time, generating a parking data exce l form, and uploading the generated parking data exce l form to the public platform;
Periodically inquiring payment running water in a payment system and generating a form as payment data exce l, and uploading the generated form of payment data exce l to the public platform;
Pulling and storing the parking data for the parking data exce l form, and pulling and storing the payment data for the payment data exce l form;
Reading parking data and payment data stored on the public platform, and reading and processing the parking data and the payment data into multi-dimensional display data in a unified format; and comparing the multidimensional display data corresponding to the parking data with the multidimensional display data corresponding to the payment data one by one according to dimensions, storing the difference found by the data comparison in an error pool, and displaying the data in the error pool as a reconciliation result to a user.
Preferably, the working method of the order reconciliation system based on the dual-system bill flow further comprises the following steps:
And when the reconciliation result shows that the difference exists, the corresponding payment data and parking data auditing pass, otherwise, the corresponding payment data and parking data auditing do not pass.
Preferably, the working method of the order reconciliation system based on the dual-system bill flow further comprises the following steps:
And when the verification fails, inquiring the data in the error pool, repairing the data, and then re-comparing the data, and when the re-comparing the data corresponds to the failure of the verification, indicating that the verification of the corresponding payment data and parking data fails.
The beneficial effects are that: according to the order checking system based on the double-system bill flow, the financial checking system is utilized, so that the server pressure of the parking system is reduced, and the normal use of the original system is not affected. And when the data statistics is utilized, the statistics of different dimensions of the reconciliation data are compared through STR INGRED I STEMP L ATE, so that the statistics of different data required by the reconciliation is performed. The page account checking data is clear at a glance, so that the problem that financial staff needs to repeatedly inquire payment data in different dimensions to check account, waste time and energy is solved. The application gathers the data of the two systems for comparison and checking, so that the situation that the financial staff needs to switch different system inquiry data is also reduced, and the checking data efficiency of the financial staff is improved.
Drawings
In order to more clearly illustrate the embodiments of the application or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the application, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a block diagram of the operation of an order reconciliation system based on dual system billing pipelining provided by an embodiment of the application;
fig. 2 is a timing chart of reconciliation data flow according to an embodiment of the present application.
Detailed Description
The following description of the technical solutions in the embodiments of the present application will be clear and complete, and it is obvious that the described embodiments are only some embodiments of the present application, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
In this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
In a first aspect, this embodiment discloses a working method of an order reconciliation system based on dual-system billing pipeline as shown in fig. 1, the method comprising the steps of:
inquiring payment flowing water in a parking system at fixed time, generating a parking data exce l form, and uploading the generated parking data exce l form to the public platform;
Periodically inquiring payment running water in a payment system and generating a form as payment data exce l, and uploading the generated form of payment data exce l to the public platform;
Pulling and storing the parking data for the parking data exce l form, and pulling and storing the payment data for the payment data exce l form;
Reading parking data and payment data stored on the public platform, and reading and processing the parking data and the payment data into multi-dimensional display data in a unified format; and comparing the multidimensional display data corresponding to the parking data with the multidimensional display data corresponding to the payment data one by one according to dimensions, storing the difference found by the data comparison in an error pool, and displaying the data in the error pool as a reconciliation result to a user.
Correspondingly, the embodiment discloses an order reconciliation system based on double-system bill flow, which comprises a parking end acquisition module, a public platform, a payment end acquisition module and a reconciliation module.
Specifically, the parking end acquisition module is configured to: and inquiring payment flowing water in the parking system at regular time and generating a table of parking data exce l, and uploading the generated table of parking data exce l to the public platform.
Specifically, the payment end acquisition module is configured to: periodically querying a payment system for payment flowing water and generating a form as payment data exce l, and uploading the generated form of payment data exce l to the public platform.
Specifically, the common platform is configured to: and pulling and storing the parking data for the parking data exce l table, and pulling and storing the payment data for the payment data exce l table.
Specifically, the reconciliation module is configured to: reading parking data and payment data stored on the public platform, and reading and processing the parking data and the payment data into multi-dimensional display data in a unified format; and comparing the multidimensional display data corresponding to the parking data with the multidimensional display data corresponding to the payment data one by one according to dimensions, storing the difference found by the data comparison in an error pool, and displaying the data in the error pool as a reconciliation result to a user.
The dimension comprises at least two of payment store, payment platform information, transaction order number, order amount, transaction type or payment mode. The multidimensional display data are obtained by data sorting of the parking data and the payment data according to data contents corresponding to different dimensions. For example, the multi-dimensional presentation data is in the format of: payment store (data content) + (data content of) payment platform information) + (data content of) transaction order number) + (data content of) order amount) + (data content of) transaction type) + (data content of) payment mode.
As a preferred implementation of this embodiment, when no difference is found in the data comparison process, the payment data and the parking data are saved as billing details and presented to the user as a billing result.
In this embodiment, the accounting module obtains the multidimensional display data through STR INGRED I STEMP L ATE technology. Correspondingly, in the working method of the order reconciliation system based on the double-system bill flow, the multi-dimensional display data is acquired through STR INGRED I STEMP L ATE technology.
In the working method of the order reconciliation system based on the dual-system bill flow, when the reconciliation result is that there is no difference, the corresponding payment data and parking data are checked and passed, otherwise, the corresponding payment data and parking data are checked and passed. Further, when the auditing is not passed, the data in the error pool is queried and is subjected to data restoration, and then the data comparison is performed again, wherein the data restoration mode can adopt any one of the prior art. And when the data comparison performed again corresponds to that the verification fails, indicating that the verification of the corresponding payment data and parking data fails. Therefore, the problem that the account checking result is abnormal due to data loss in the data transmission or receiving process can be avoided, and the accuracy and reliability of the account checking result are further ensured.
In summary, in the order checking system based on the dual-system bill flow disclosed in the embodiment, data comparison statistics is performed based on the data of the parking system and the payment system, and the checking time of financial staff is obviously improved during financial checking. The core of the method is that data comparison and statistics processing are carried out on the data of two sides through the data of the two sides by using STR INGRED I STEMP L ATE, and then multidimensional data statistics is obtained, so that the daily account checking time cost is greatly improved, and the resource cost of a management system is also reduced. With this STR INGRED I STEMP L ATE comparison of data, there is efficient data comparison statistics. Compared with the traditional method, the checking efficiency of personnel is greatly improved. The system is prevented from carrying out data of the data quantity, the pressure caused by the data quantity is avoided from being compared with the pressure caused by the system, the performance pressure caused when the system is used by a user is avoided, and the good performance of the system used by the user is ensured.
In a possible embodiment, the data flow of the two-side system is specifically shown in the diagram, and will not be described herein.
In the embodiments provided by the present application, it is to be understood that the embodiments described herein may be implemented in hardware, software, firmware, middleware, code, or any suitable combination thereof. For a hardware implementation, the processor may be implemented in one or more of the following units: an Application Specific Integrated Circuit (ASIC), a Digital Signal Processor (DSP), a Digital Signal Processing Device (DSPD), a Programmable Logic Device (PLD), a Field Programmable Gate Array (FPGA), a processor, a controller, a microcontroller, a microprocessor, other electronic units designed to perform the functions described herein, or a combination thereof. For a software implementation, some or all of the flow of an embodiment may be accomplished by a computer program to instruct the associated hardware. When implemented, the above-described programs may be stored in or transmitted as one or more instructions or code on a computer-readable storage medium. Computer-readable storage media includes both computer storage media and communication media including any medium that facilitates transfer of a computer program from one place to another. A storage media may be any available media that can be accessed by a computer. The computer-readable storage media may include, but is not limited to, RAM, ROM, EEPROM, CD-ROM or other optical disk storage, magnetic disk storage media or other magnetic storage devices, or any other medium that can be used to carry or store desired program code in the form of instructions or data structures and that can be accessed by a computer.
Finally, it should be noted that: the foregoing description is only illustrative of the preferred embodiments of the present application, and although the present application has been described in detail with reference to the foregoing embodiments, it will be apparent to those skilled in the art that modifications may be made to the embodiments described, or equivalents may be substituted for elements thereof, and any modifications, equivalents, improvements or changes may be made without departing from the spirit and principles of the present application.
Claims (8)
1. The order checking system based on the double-system bill flow is characterized by comprising a parking end acquisition module, a public platform, a payment end acquisition module and a checking module;
The parking end acquisition module is configured to: inquiring payment running water in a parking system at regular time, generating a parking data excel form, and uploading the generated parking data excel form to the public platform;
The payment end acquisition module is configured to: inquiring payment running water in a payment system at regular time, generating a payment data excel form, and uploading the generated payment data excel form to the public platform;
The common platform is configured to: pulling and storing the parking data for the parking data excel form, and pulling and storing the payment data for the payment data excel form;
The reconciliation module is configured to: reading parking data and payment data stored on the public platform, and reading and processing the parking data and the payment data into multi-dimensional display data in a unified format; and comparing the multidimensional display data corresponding to the parking data with the multidimensional display data corresponding to the payment data one by one according to dimensions, storing the difference found by the data comparison in an error pool, and displaying the data in the error pool as a reconciliation result to a user.
2. The dual system bill line based order reconciliation system of claim 1, wherein the dimensions comprise at least two of payment store, paymate information, transaction order number, order amount, transaction type or payment means.
3. The dual system bill pipeline based order reconciliation system of claim 2, wherein the multi-dimensional presentation data is obtained by data ordering the parking data and the payment data according to data content corresponding to different dimensions.
4. The dual system bill pipelining-based order reconciliation system of claim 1, wherein the payment data and the parking data are saved as a bill statement as a reconciliation result and presented to a user when no discrepancy is found during the data comparison.
5. The dual system billing pipeline-based order reconciliation system of claim 1 wherein the reconciliation module performs multi-dimensional presentation data acquisition via STRINGREDISTEMPLATE technology.
6. The order reconciliation system based on dual system billing process of any one of claims 1-5 wherein the method of operation of the order reconciliation system based on dual system billing process comprises the steps of:
inquiring payment running water in a parking system at regular time, generating a parking data excel form, and uploading the generated parking data excel form to the public platform;
Inquiring payment running water in a payment system at regular time, generating a payment data excel form, and uploading the generated payment data excel form to the public platform;
Pulling and storing the parking data for the parking data excel form, and pulling and storing the payment data for the payment data excel form;
Reading parking data and payment data stored on the public platform, and reading and processing the parking data and the payment data into multi-dimensional display data in a unified format; and comparing the multidimensional display data corresponding to the parking data with the multidimensional display data corresponding to the payment data one by one according to dimensions, storing the difference found by the data comparison in an error pool, and displaying the data in the error pool as a reconciliation result to a user.
7. The dual system billing system of claim 6 wherein the dual system billing system based order billing system further comprises:
And when the reconciliation result shows that the difference exists, the corresponding payment data and parking data auditing pass, otherwise, the corresponding payment data and parking data auditing do not pass.
8. The dual system billing system of claim 7 wherein the dual system billing system based order billing system further comprises:
And when the verification fails, inquiring the data in the error pool, repairing the data, and then re-comparing the data, and when the re-comparing the data corresponds to the failure of the verification, indicating that the verification of the corresponding payment data and parking data fails.
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN118313939A true CN118313939A (en) | 2024-07-09 |
Family
ID=
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8174405B2 (en) | Message-bus-based advanced meter information system with applications for cleaning, estimating and validating meter data | |
| US20060020544A1 (en) | System and method for tracking emissions | |
| US10794729B2 (en) | System and method for message-bus-based advanced meter information system | |
| CN106294125B (en) | Core banking system data processing method | |
| CN101515289B (en) | Device for detecting conventional data file and method thereof | |
| CN109062872B (en) | Method for uniformly processing customs files with different formats | |
| CN109408043A (en) | A kind of program creating method and device | |
| CN108269182B (en) | Balance calculation method and calculation equipment based on fund collection | |
| CA2471022C (en) | Business transaction management | |
| US11913811B2 (en) | Enhanced meter management solution | |
| CN105630839A (en) | Webpage information acquisition method and device | |
| CN118313939A (en) | Order checking system based on dual-system bill flow | |
| CN111353763B (en) | Method, device, server and storage medium for processing data | |
| WO2014180401A1 (en) | Service model adaptation method and system | |
| CN112116469A (en) | Memory-based multi-exchange full-service clearing system and method | |
| CN113836145B (en) | Method, device, electronic equipment and computer readable storage medium for requesting data | |
| CN115114354A (en) | Distributed data storage and query system | |
| CN101427274A (en) | Detailed trade data report | |
| CN111639936B (en) | Transaction information acquisition method and device, electronic equipment and readable storage medium | |
| CN113434734A (en) | Method, device, equipment and storage medium for generating file and reading file | |
| Ferreira et al. | Smart meter data processing: a showcase for simple and efficient textual processing | |
| CN114239519A (en) | Credit investigation data processing method and device, electronic equipment and computer readable medium | |
| CN113277461B (en) | System and method for monitoring oiling quantity data of oiling machine | |
| CN113076340A (en) | Accounting data processing method and device, electronic equipment and storage medium | |
| CN112598414A (en) | Electric power marketing charging method and electric power marketing charging engine |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication |