CN116644030B

CN116644030B - Electronic filing data processing system and implementation method thereof

Info

Publication number: CN116644030B
Application number: CN202310926336.XA
Authority: CN
Inventors: 许艳涛
Original assignee: Beijing Huake Chengxin Technology Co ltd
Current assignee: Beijing Huake Chengxin Technology Co ltd
Priority date: 2023-07-26
Filing date: 2023-07-26
Publication date: 2023-10-20
Anticipated expiration: 2043-07-26
Also published as: CN116644030A

Abstract

The invention provides an electronic filing data processing system and an implementation method thereof, which belong to the technical field of financial data processing, wherein the system comprises an electronic filing service system and an electronic filing support system, and the electronic filing service system is used for carrying out configuration contents such as data processing rules, interface information, template configuration and the like, carrying out standardized processing on filing data and printing the filing data; the electronic filing service system is internally provided with a filing data module and a filing setting module, so that access to financial data of the service system can be realized, data standardization processing can be completed according to configured mapping rules, format file printing processing of the data is completed according to configured printing templates, the service system data is processed into filing data capable of being subjected to electronic filing, the filing data is processed into a data file according to the data printing templates and uploaded to a file server, and the electronic filing system is obtained. The invention supports the archiving of various data of accounting documents, business documents, invoice data and attachment data.

Description

Electronic filing data processing system and implementation method thereof

Technical Field

The invention belongs to the technical field of financial data processing, and particularly relates to an electronic filing data processing system and an implementation method thereof.

Background

With the development of data processing technology, accounting archive management data becomes a trend. Accounting archives management data in the financial data processing specification clearly define that the accounting archives formed by the internal units meet certain conditions and belong to the electronic accounting data of the archiving scope, and the accounting archives can be stored only in electronic form and form electronic archives. Currently, some industrial and mining enterprises already have comprehensive electronic accounting file management of reimbursement, business and accounting, and have implementation conditions of electronic files.

Based on the rapid development of the market, a variety of electronic accounting archive products are released in the market, and many financial systems are beginning to develop or expand electronic accounting archive functions. However, at present, the use experience of customers of electronic archive products is uneven, the coupling between electronic accounting archive modules developed by a plurality of financial systems and the financial systems of the electronic accounting archive modules is high, and the electronic accounting archive modules generally lack universality. In the prior art, there are two existing solutions for users who need to build electronic archives capabilities: according to the scheme I, if the customer uses the A financial system, the B electronic file system can be selected to build the electronic file capacity according to the needs; and in the second scheme, if the customer uses the A financial system, the C financial system with the electronic archive capability can be replaced, so that the C financial system has the electronic archive capability. In the above technical solutions, the first solution involves the problem of data docking specification between the system a and the system B, the problem of system intercommunication, and the work of modifying the used financial system, which cannot effectively guarantee the consistency and integrity of the data; scheme II relates to switching between new and old financial systems, carding of service specifications, unknown system usability and adaptability, and cost and management problems of switching service systems.

In view of the above problems with the prior art, no effective solution has been proposed.

Disclosure of Invention

Based on the problems existing in the prior art, the invention provides an electronic filing data processing system and an implementation method thereof, which aim to solve the problem of butting with an electronic file system when a financial system in the prior art builds electronic file capacity, and solve the problem of data intercommunication and different data specifications caused by different systems; the problems that the consistency and the integrity of the data cannot be effectively ensured due to various data types during data processing and file management confusion is easily caused due to low accuracy are further solved. The invention solves the problems existing in the prior art in different technical schemes, improves the processing efficiency and has extremely high service expansibility and compatibility.

According to a first aspect of the technical scheme of the invention, the invention provides an electronic filing data processing system, which comprises an electronic filing service system and an electronic filing support system, wherein the electronic filing service system is used for processing financial data and generating corresponding layout files and data; the electronic filing support system is used for supporting the operation of the electronic filing service system, and a filing data module and a filing setting module are arranged in the electronic filing service system; the electronic filing support system is used for bearing the standardized processing of the data based on the electronic filing service system according to the configuration of the electronic filing data processing system, generating accounting documents, business documents, invoice data and attachment information data of the electronic filing system based on the electronic filing service system to the source system data, generating corresponding data files according to the data file printing templates, and uploading the data files to the file server to obtain results of the electronic filing system.

Furthermore, the electronic filing service system is used for carrying out configuration contents such as data processing rules, interface information, template configuration and the like, standardized processing of filing data and printing of the filing data; the electronic filing service system is internally provided with a filing data module and a filing setting module, so that access to financial data of the service system can be realized, data standardization processing can be completed according to configured mapping rules, format file printing processing of the data is completed according to configured printing templates, the service system data is processed into filing data capable of being subjected to electronic filing, the filing data is processed into a data file according to the data printing templates and uploaded to a file server, and the electronic filing system is used for obtaining the data.

Further, the electronic filing data processing system acquires accounting vouchers, vouchers associated vouchers, business vouchers, invoice data and accessory information data according to a specified interface, the electronic filing data processing system completes standardized processing of financial data according to data structure definition and data structure mapping setting, layout file printing and data file printing of the data are completed according to printing template setting, and finally the financial filing data of the electronic filing system data structure are processed.

Further, an archive data module in the electronic archive service system is used for bearing business data in the client financial system acquired in the data processing process and archive data corresponding to the electronic archive system generated according to configuration; the archiving setting module is used for defining the corresponding business type carrying business data, the system information of the client financial system and the electronic file system, the data standardization rule definition of the client financial system and the electronic file system (two systems), the data printing template configuration, and completing the standardization processing and the printing processing of the data according to the configuration.

Preferably, the archiving data module comprises an accounting document unit, a document associated document unit, a business document unit, an invoice data unit, an accessory information data unit and an account book information archive unit; the accounting document unit provides accounting document data management and access or maintenance of corresponding data; the voucher associated bill unit provides voucher associated bill data management and access or maintenance of corresponding data; the business bill unit provides bill data management, issues structures of various types of bills based on data structure definition and data structure mapping, and provides access or maintenance of corresponding data based on the issued bill data; the invoice data unit provides invoice data management, issues the structures of various types of bills based on data structure definition and data structure mapping, and provides corresponding data access or is synchronized by invoice center data based on the issued invoice data; the accessory information data unit provides accessory data management and access of corresponding data; the account book information archive unit provides account book information data management and access or maintenance of corresponding data.

Preferably, the filing setting module is internally provided with a bill type setting unit, a printing setting unit, a service type definition unit, a data structure mapping unit, a three-party application setting unit, a service classification setting unit and a connection configuration unit, wherein the bill type setting unit is used for setting corresponding multi-type bill comparison relations under the bill service type and corresponding service system printing codes; the printing setting unit is used for setting a printing template corresponding to the service type data; the service type definition unit is used for defining the data service type of the service system to be archived under each service classification and the corresponding data service type of the electronic archive system; the data structure definition unit is used for defining a data table storage structure of data under each service type; the data structure mapping unit is used for defining a mapping rule from a business system data structure to be standardized to an electronic archive system data structure, editing source data through a formula editor, and corresponding to specific field information of target data; the three-party application setting unit is used for configuring service systems needing interaction and electronic file system information; the service classification setting unit is used for setting service data classification under the three-party application; the connection configuration unit is used for configuring the connection information of the service system and the electronic file system corresponding to the three-party application.

Further, a management platform system and a technical platform system are arranged in the electronic filing support system, wherein the management platform system is used for daily operation of the management platform, and a permission management module, a log management module, a task management module, a business management module and a parameter setting module are arranged in the management platform system.

Furthermore, the technical platform system is used for providing data storage and transmission functions, and an enterprise-level distributed application service unit, a distributed relational database RD6, a distributed message queue unit, a distributed memory unit, a platform DevOps, a computer and a storage platform unit are arranged in the technical platform system.

According to a second aspect of the present invention, there is provided an electronic archive data processing implementation method applied to the electronic archive data processing system, the implementation method including the following steps:

step W1, configuring three-party application settings: three-party application information of a source service system and a target electronic file system is required to be configured according to the archiving flow;

step W2, configuring service classification setting: according to the archiving data of the business system and the electronic archive system, configuring business classification information under the corresponding three-party application;

Step W3, configuring service type setting: defining and configuring service types according to service data types to be archived by a service system; and carrying out service type definition configuration according to the type of the archive data to be received by the electronic archive system.

Further, the method for realizing the electronic archive data processing in the electronic archive data processing system comprises the following steps: step W4, configuration data structure definition setting: according to the data content to be archived by the service system and the data content received by the electronic archive, configuring data structure information corresponding to each service type, including storage table names and field specific information;

step W5, configuring data structure mapping setting; according to the data content to be archived by the service system and the data content received by the electronic archive, carrying out data structure mapping setting on the data to be subjected to standardized processing;

step W6, configuring a printing template setting: setting a data template for data under a service type to be archived according to a specific archiving service scene, and setting a data configuration format file template for calling a service system interface to print a format file to be printed;

Step W7, configuration parameter management setting: whether to increment filing and filing beginning account period two parameters are set for electronic filing, whether to increment opening or closing is set according to actual filing business scenes, accounting years and months of beginning account period are set according to the beginning account period of the filing business data;

step W8, acquiring service system credential data: acquiring credential data through a service system interface and storing the credential data in an electronic archiving service system;

step W9, printing the credential data format file: printing the acquired credential data through a service system interface, and recording the corresponding file address to the credential data;

step W10, acquiring business system certificate associated document data: and acquiring the document data associated with the certificate through the service system interface according to the certificate data and storing the document data in the electronic filing data processing system.

In another preferred embodiment, the method for implementing electronic archive data processing applied to the electronic archive data processing system further includes the following steps:

step W11, acquiring business system attachment information data: acquiring accessory information data according to the document number in the acquired document data associated with the document, and storing the accessory information data in an electronic filing data processing system;

Step W12, acquiring bill data of a service system: according to the bill primary key information and the bill type in the acquired bill data associated with the certificates, specific data information of the bills is acquired in a classified mode and is stored in a data structure corresponding to the electronic filing data processing system;

step W13, printing the document data format file: according to the bill type in the acquired bill data, classifying and acquiring the printing codes maintained under the corresponding type in the bill type setting, calling a business system interface to print, and storing the file address of the corresponding bill;

step W14, standardized business system bill data: acquiring data structure mapping settings of corresponding types according to bill types according to invoice data and associated bill data in an electronic filing service system, carrying out standardized processing on the data to acquire invoice data of a data structure of the electronic filing system, and storing the invoice data into a data structure corresponding to an electronic filing data processing system;

step W15, standardized business system attachment information data: according to the acquired business system attachment information data and associated bill data, searching the data structure mapping setting of the corresponding attachment, carrying out standardized processing on the data to obtain attachment information data of the electronic file system data structure, and storing the attachment information data into the data structure corresponding to the electronic filing data processing system;

Step W16, writing back and recording to the certificate associated document: searching the corresponding account book in the data processing and the corresponding bill quantity and accessory quantity under the bill during accounting, and writing back to the bill data associated with the vouchers for storage;

step W17, standardized business system bill data: according to the obtained bill data, searching the data structure mapping setting under the corresponding service type for the printed bill classification type, carrying out standardized processing on the data according to the data structure mapping to obtain bill data of an electronic file system data structure, and storing the bill data into a data structure corresponding to an electronic filing data processing system;

step W18, generating a data file and uploading the data file to a file server: according to the account book, accounting document, bill, accessory information data are acquired during accounting, a data file printing template configured in the printing template setting under the corresponding service type is queried, and a corresponding data file is generated and uploaded to a file server.

According to a third aspect of the present invention, there is provided an electronic archive data processing implementation method, which is implemented based on an electronic archive service system, a client financial system, and an electronic archive system of an electronic archive data processing system, and the implementation method includes the following steps:

Step S1, initiating an archiving task, namely operating the archiving of the certificates and the attachments in an electronic file system, and initiating the archiving of the certificates and the archiving processing tasks of the bill attachments;

step S2, a data acquisition step, namely, receiving request parameters corresponding to an archiving processing task by the electronic archiving service system according to the step S1, wherein the request parameters comprise account book codes, tenant information and accounting time (such as accounting years, months and the like); calling a financial system interface to acquire corresponding financial data, wherein the financial data comprises accounting documents, document associated documents, document data and attachment information data, and printing layout files of the accounting documents and business documents;

step S3, a data standardization processing step, namely, carrying out data processing on data needing to be subjected to standardization processing according to the content of the data structure mapping setting to obtain and store data in a data format of the electronic file system, wherein the data comprises business documents, invoice data and attachment information data;

step S4, printing the data file on the accounting document data, the business document, the invoice data and the accessory information data which need to be archived based on the data file printing template maintained in the printing setting; the accounting document data comprises a document classification data file, a document main information file, a document entry file and an auxiliary accounting file, the business document comprises a document main information file, a document main table file and a document detail line file, the invoice data comprises a document main information file, a document main table file and a document detail line file, the accessory information data comprises an accessory data line file, the data files corresponding to the various data (accounting document data, business document, invoice data and accessory information data) are uploaded to a file server after being processed, address information of the data files is recorded, and a power supply archive system obtains a result.

Compared with the prior art, the electronic filing data processing system and the implementation method thereof have the beneficial effects that:

1. according to the invention, the accounting document, the document associated document, the business document, the invoice data and the accessory information data in the financial system are acquired through the electronic filing service system, and the data are subjected to standardized processing according to the data structure definition and the data structure mapping of the configuration, so that the data of the financial system can be effectively processed and converted into the electronic filing data, the authenticity, the integrity, the reliability and the availability of the data are ensured, and the problems of data loss, incomplete data and nonstandard data are avoided.

2. The invention can support the printing of format files for various filing data such as accounting certificates, business documents and the like, support the file generation in the process of filing the electronic files, and upload the files to the file server.

3. The system can rapidly and accurately complete standardized processing of data according to system configuration, can effectively improve the integrity and reliability of the data, meets the archiving requirement of an electronic file system, can record the source and target data in the archiving process, and is convenient for checking and checking the data.

4. The electronic archiving service system of the electronic archiving data processing system can flexibly set mapping rules and data structure definition so as to be suitable for clients in different industries; the electronic filing support system defines the data processing rule definition and the structure definition of the standard specification, and can support the application requirements of various financial systems and electronic filing systems. The electronic filing service system is used for processing the data of the electronic financial system and generating the format file of the data of the electronic filing system and the corresponding data, and the electronic filing support system is used for supporting the operation of the electronic filing data processing system.

Drawings

The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate the invention and together with the embodiments of the invention, serve to explain the invention. In the drawings:

FIG. 1 is a functional block diagram of an electronic archive data processing system in accordance with the present invention;

FIG. 2 is a block diagram of a workflow of an electronic archive data processing implementation method in accordance with the present invention;

FIG. 3 is a flow chart of an electronic archive acquisition result in accordance with the present invention;

fig. 4 is a flow chart of an electronic archive data processing process in accordance with the present invention.

Detailed Description

The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.

The invention provides an electronic archive data processing system and an implementation method thereof, which belong to the technical field of electronic archive data processing systems, wherein an electronic archive service system is used for processing financial data and generating corresponding format files and data; the electronic filing support system is used for supporting the operation of the electronic filing service system, and a filing data module and a filing setting module are arranged in the electronic filing service system; the electronic filing support system is used for bearing the standardized processing of the data based on the electronic filing service system according to the configuration of the electronic filing data processing system, generating accounting documents, business documents, invoice data and attachment information data of the electronic filing system based on the electronic filing service system to the source system data, generating corresponding data files according to the data file printing templates, and uploading the data files to the file server to obtain results of the electronic filing system. The invention can support the archiving of various data of accounting documents, business documents, invoice data and attachment data.

The electronic filing service system is used for carrying out configuration contents such as data processing rules, interface information, template configuration and the like, carrying out standardized processing on filing data and printing the filing data; the electronic filing service system is internally provided with a filing data module and a filing setting module, so that access to financial data of the service system can be realized, data standardization processing can be completed according to configured mapping rules, format file printing processing of the data is completed according to configured printing templates, the service system data is processed into filing data capable of being subjected to electronic filing, the filing data is processed into a data file according to the data printing templates and uploaded to a file server, and the electronic filing system is used for obtaining the data. The electronic filing data processing system is mainly based on the financial system and the electronic file system to realize filing, and generates the data result of the electronic file system by carrying out data processing on business data of the financial system, so that the electronic file system can quickly acquire data and finish storage of file data. The processing content of the data covers various data such as accounting documents, business documents, invoices and accessories, can perfectly cover the requirements of electronic filing business scenes, can help a financial system and an electronic file system to solve the system docking problem, provides a mode of self-defining data types and self-defining data structures, and can quickly and flexibly match the data processing requirements of various financial systems and electronic file systems.

The invention provides an electronic filing data processing system and an implementation method thereof, which belong to the technical field of electronic filing data processing, wherein the electronic filing data processing system comprises an electronic filing service system and an electronic filing support system, the electronic filing service system is used for acquiring financial data in a financial system, carrying out standardized processing and format file printing on the data to generate filing data meeting the filing of the electronic filing system, and the electronic filing support system is used for supporting the operation of the electronic filing data processing system; an archive data module and an archive setting module are arranged in the electronic archive data processing system; according to the invention, an electronic archiving service system is used for acquiring accounting vouchers, voucher associated receipts, business receipts, invoice data and accessory information data in a financial system, calling a financial system interface to print format files of the accounting vouchers and the business receipts, inquiring data structure mapping maintained under a corresponding data type according to the service type of the corresponding data, and carrying out standardized processing of the data to generate electronic archiving data; the electronic filing support system is used for bearing the data of the financial system acquired based on the electronic filing service system, carrying out standardization and printing processing, carrying out data file processing of corresponding data based on the filing data of the electronic filing system generated by the electronic filing service system, uploading the data file to the file server, and acquiring the data file by the electronic filing system.

Further, flexible data structure definition, data structure mapping setting, printing template setting and document type setting can be performed in the electronic filing service system of the electronic filing data processing system, so that the electronic filing support system is applicable to clients in different industries, and the data processing rule definition and the structure definition of the definition specification standard can support application requirements of various financial systems and electronic filing systems. The electronic filing service system is internally provided with: the archiving data module is used for accepting the service data acquired from the service system interface; the archive setting module is used for defining configuration content required in the electronic archive data processing process. The archive data module includes: an accounting document unit for receiving accounting document data in a financial system; a voucher associated document unit for receiving voucher associated document data in a financial system; a business document unit for receiving various business document data in the financial system; an invoice data unit for receiving various invoice data in the accounting system; an attachment information unit for receiving attachment information data in the financial system; and the account book information archive unit is used for receiving and maintaining the financial system account book information base archive.

Further, the electronic archive data processing system archive setting module is built in: the three-party application setting unit is used for defining three-party application information of the financial system and the electronic file system; the business classification setting unit is used for setting business classifications corresponding to financial system financial data and electronic file system file data; a service type setting unit for defining service types corresponding to various data; a data structure definition unit for defining a data structure of corresponding data under each service type; the data structure mapping unit is used for defining a mapping relation corresponding to data to be subjected to standardization processing; a connection configuration unit for defining system connection configuration information corresponding to the three-party application; the bill type setting unit is used for defining the bill type and the corresponding printing code under the service type corresponding to the financial system; and the printing setting unit is used for defining a printing template corresponding to the layout file and the data file.

The electronic archive data processing system of the present application and its method of operation are described in detail below with reference to FIGS. 1-4.

As shown in fig. 1, the present application provides an electronic filing data processing system, which includes an electronic filing service system and an electronic filing support system, wherein the electronic filing service system is used for processing financial data and generating corresponding format files and data; the electronic filing support system is used for supporting the operation of the electronic filing service system, and a filing data module and a filing setting module are arranged in the electronic filing service system; the electronic filing support system is used for bearing the standardized processing of the data based on the electronic filing service system according to the configuration of the electronic filing data processing system, generating accounting documents, business documents, invoice data and attachment information data of the electronic filing system based on the electronic filing service system to the source system data, generating corresponding data files according to the data file printing templates, and uploading the data files to the file server to obtain results of the electronic filing system.

Further, the electronic filing service system is used for acquiring and standardizing and printing financial system data to generate electronic filing system file data; the electronic archive support system is for supporting operation of the electronic archive data processing system. An archiving data module and an archiving setting module are arranged in the electronic archiving service system, the archiving data module is used for receiving financial system business data and standardized electronic archive system archive data generated after the standardization, and the archiving data module comprises an accounting document unit, a document unit associated with a document, a business document unit, an invoice data unit, an accessory information data unit and an account book information archive unit; the filing setting module is used for defining the data structures corresponding to the various data, the corresponding standardized mapping relation and the printing template, and finishing the standardization and printing of the data according to the set rules and the printing template.

Still further, the archive setting module is provided with:

the bill type setting unit is used for defining the bill type and the corresponding printing code under the service type corresponding to the financial system;

the printing setting unit is used for defining a printing template corresponding to the layout file and the data file;

The business type definition unit is used for defining business types corresponding to various data under each business classification of the financial system and the electronic file system;

a data structure definition unit for defining a data structure of corresponding data under each service type;

the data structure mapping unit is used for defining a mapping relation corresponding to data to be subjected to standardization processing;

the connection configuration unit is used for defining system connection configuration information corresponding to the three-party application, and comprises a financial system and an electronic file system, and is used for connecting the two systems of the electronic filing data processing system;

the three-party application setting unit is used for defining three-party application information of the financial system and the electronic file system;

and the business classification setting unit is used for setting business classifications corresponding to financial system financial data and electronic file system file data.

The accounting document unit is arranged in the filing data module and used for receiving accounting document data in the financial system; the voucher associated bill unit is used for receiving the voucher associated bill data in the financial system; the business bill unit is used for receiving various business bill data in the financial system; the invoice data unit is used for receiving various invoice data in the financial system; the accessory information unit is used for receiving accessory information data in the financial system; the account book information archive unit is used for accepting and maintaining the financial system account book information base archive.

Further, as shown in fig. 1, an electronic filing support system in the electronic filing data processing system is used for supporting the operation of the electronic filing data processing system, a management platform system and a technical platform system are arranged in the electronic filing support system, the management platform system is used for managing daily operation of a platform, and the technical platform system is used for providing data storage and transmission functions; the management platform system is internally provided with a permission management module, a log management module, a task management module, a business management module and a parameter setting module; the technical platform system is internally provided with an enterprise-level distributed application service unit, a distributed relational database RD6, a distributed message queue unit, a distributed memory unit, a platform DevOps and a computer and storage platform unit.

The functions of each functional module in the management platform system of the electronic filing support system are as follows:

1. and the permission management module is used for: the rights management module is a bottom layer core function of the electronic filing data processing system and mainly comprises functions of user management, role management, data rights management and the like; the authority management module realizes the authorization of inquiring the data range based on the user login authorization, the role access control authorization and the data authority through a flexible configuration mode. User management realizes control of user access system authority by defining user login codes and user passwords. Role management realizes role operation of function nodes and function node buttons by distributing the function nodes; and realizing user access authority control and operation button authority control by combining the user.

The data authority management presets the data authority level of the internal transaction data processing system, the data authority management comprises organization-level authority control, department-level authority control and user-level authority control, the data authority management is combined with user management and role management for use, and the data authority operation authority range of the user to the functional nodes can be strictly controlled.

2. And the log management module is used for: the log management module defines a log in log, an operation log, a service log, a task log, and an interface log. The system manager can check the cause of the error occurrence and leave trace of the operation through the log management module. Providing basis for the analysis of the application condition of the internal transaction data processing system.

The log management function node records the user log-in system time, log-out system time and whether the user is on line currently or not. The operation log management function node records various operation information records of the system, including records of operations such as data inquiry, data addition, data modification, data deactivation/activation, data deletion and the like, of a user. The service log management function node records service calling information, calling time and processing result information among the micro services of the platform. And the task log management function node records the system background timing task execution information. Including timing task execution results, execution time, etc. The interface log management function node records the calling record, the executing result and the executing message information of the external system integrated interface.

3. The task management module:

the task management module centrally manages all background automatic task information of the platform, and can set task basic information, task execution time and the like; the task management module can agree with automation applications such as data capture, data processing, program processing and the like, so that manual operation is reduced, and usability of the system and the like is enhanced. And the task execution log is combined to track, record and analyze the task execution condition. The task management module comprises task management and a task executor, and the task management can be defined by information such as tasks, operation modes, task parameters, execution strategies and the like. The task executor binds the tasks on the basis of task management and the like, sets the execution sequence and the execution time of the tasks, realizes the sequential execution of the multiple tasks, and can meet the requirement of complex background task processing scenes.

4. Business process module:

the business process module is a business approval process module, and the functions of the business approval process module comprise three modules of process category definition, approval process design, approval message center and the like. The corresponding approval process strategy can be flexibly set aiming at the functional node with approval requirements, and bill approval application is realized. The flow category definition defines the functional nodes to be approved, and the definition comprises information such as flow identification, approval path, withdrawal path, data interface and the like. The approval process design is used for designing a specific approval process for the process category. The approval message center centrally manages all approval messages in the running process of the approval process.

5. Parameter setting module:

the parameter setting module is a parameter setting management module and is used for defining some control parameter information in the process of system application operation and task execution; the method is used for solving different application requirements of different enterprises; controlling through parameter setting management; the method is convenient for a manager to carry out quick configuration application when carrying out system initialization configuration, and enhances the flexibility of the platform.

The technical platform system is internally provided with an enterprise-level distributed application service unit, a distributed relational database RD6, a distributed message queue unit, a distributed memory unit, a platform DevOps and a computer and storage platform unit; the function of each functional module in the technical platform system of the internal transaction support system is as follows.

The enterprise-level distributed application service EDAS (Enterprise Distributed Application Service) adopted by the invention is a Cloud native PaaS platform for application hosting and micro-service management, provides full stack solutions for application development, deployment, monitoring, operation and maintenance and the like, and simultaneously supports micro-service operation environments such as Spring Cloud, apache Dubbo and the like, so that a client application is assisted to easily Cloud. Preferably, a Spring Cloud platform is used.

Preferably, the distributed relational database RD6 used in the invention is a relational database, which is a MySQL database. The distributed message queue unit adopts a message queue middleware which is RabbitMQ; the internal transaction support system has high performance, high availability, scalability and final consistency architecture, and can solve the problems of application coupling, asynchronous message, flow cutting and the like. Furthermore, the distributed caching unit in the internal transaction supporting system adopts the distributed caching as Redis, so that the data which are frequently used and have small change in login authorization information, basic files and the like are stored, and the data can be rapidly used in the service occurrence process.

In particular, platform DevOps in the electronic archive support system facilitates communication, collaboration and integration between development (application/software engineering), technical operation and Quality Assurance (QA) departments, and adopts a gitlab+jenkins+bash script+docker mirror server+k8s or docker swarm to automatically pull mirror deployment. In the electronic archiving and supporting system, when a developer submits or merges codes, the Gitlab can check the operation of submitting the codes or merging the codes, inform Jenkins to execute compiled codes and package codes to a docker mirror image, submit the mirror image to a mirror image server, and a trigger of the mirror image server can inform k8s or docker swarm to update the mirror image and deploy an environment.

Further, the electronic filing support system adopts a computer and a storage platform unit, which realizes the storage and management of computer information data and saves the data in a computer platform; preferably, the storage platform used is seven Niu Yun, OSS of alicloud, minio, etc.

As shown in fig. 2, the present invention provides a method for implementing electronic archive data processing, which is implemented based on an electronic archive service system, a client financial system and an electronic archive system of an electronic archive data processing system, and the implementing method includes the following steps:

step S2, a data acquisition step, namely, according to the step S1, the electronic filing service system receives request parameters corresponding to filing processing tasks, including account book coding, tenant information, accounting years and months and the like, calling a financial system interface to acquire corresponding financial data, including accounting vouchers, vouchers associated vouchers, receipt data and attachment information data, and performing printing processing on layout files of the accounting vouchers and business vouchers;

and S4, printing a data file on the data to be archived based on a data file printing template maintained in the printing setting, wherein the accounting document data comprises a document classification data file, a document main information file, a document entry file and an auxiliary accounting file, the business document comprises a document main information file, a document main table file and a document detail line file, the invoice data comprises a document main information file, a document main table file and a document detail line file, the accessory information data comprises an accessory data line file, the data files corresponding to the various data are uploaded to a file server after being processed, the address information of the data files is recorded, and a result is acquired by the electronic archive system.

In particular, as shown in connection with FIG. 2, the system shown in FIG. 2 includes an electronic archive system, an electronic archive data processing system, and a customer finance system. FIG. 2 shows a method for implementing electronic archive data processing, and the steps of each flowchart are described in detail according to the flowchart shown in FIG. 2. The method comprises the following steps:

The implementation method of electronic archive data processing shown in fig. 2 is not an enlarged display in fig. 4, and includes the following steps:

step 1, initiating an archiving and collecting task in an electronic archive system and transmitting the archiving and collecting task to an electronic archiving data processing system; after receiving the request of the electronic archive archiving task, the electronic archive data processing system initiates a request for acquiring credential data; and sending the credential data request to the client financial system;

step 2, after the client financial system receives the request of the credential data, returning the credential data to the electronic filing data processing system; the electronic filing data processing system receives and stores the credential data and starts to print the credential data format file according to the specified format; the electronic filing data processing system initiates a request for acquiring a voucher-associated document to the client financial system based on the voucher data format file;

step 3, after receiving the request for acquiring the voucher-associated document, the client financial system extracts the voucher-associated document based on the specified rule and sends the voucher-associated document data back to the electronic filing data processing system; the electronic filing data processing system receives and stores the document data associated with the certificates; the method comprises the steps that the method starts sending to obtain accessory information data to a client financial system based on voucher-associated bill data, the client financial system receives an accessory information bill obtaining request, extracts the accessory information data based on the client financial data and returns the accessory information data to an electronic filing data processing system; the electronic filing data processing system receives and stores the accessory information data;

Step 4, the electronic filing data processing system initiates a document data acquisition request to the client financial system, the client financial system extracts document data based on the client financial data and returns the document data to the electronic filing data processing system, and the electronic filing data processing system receives and stores the document data; printing a document data format file according to a specified format, and then writing back a state to a document associated document in an electronic filing data processing system;

step 5, inquiring invoice data and corresponding mapping rules in the electronic filing data processing system, and standardizing the invoice data based on the corresponding mapping rules; further, inquiring the accessory information data and the corresponding mapping rules, and normalizing the accessory data based on the corresponding mapping rules; inquiring bill data and corresponding mapping rules on the basis of the standardized attachment data, and standardizing the bill data based on the corresponding mapping rules;

and 6, based on standardized invoice data, accessory data and receipt data, combining a data file template under inquiry archive data, generating a data file, uploading the data file to a file server, and recording an acquisition result and an acquisition state.

In one implementation of the electronic archive data processing method, as shown in fig. 2 and 3, archive task queries are performed at intervals, and electronic archive status records and archive status updates are performed based on the query results. The method specifically comprises the following steps:

Step Q1, initiating an archiving and inquiring result task in an electronic archive system, and sending the archiving and inquiring result task to the electronic archiving data processing system; after the electronic archive data processing receives the electronic archive inquiry task request, a system is started to collect record inquiry, and whether the electronic archive inquiry task is processed is judged; if the acquired results are inquired to be finished, the results are tidied, and the electronic filing data processing system returns the tidied inquiry task results to the electronic filing system; if the query is that the acquisition result is not completed (namely, the processing is failed), recording and sorting the reason of the query processing failure; if the reason record of the processing failure is not queried, marking as an unfinished state;

step Q2, the electronic filing data processing system returns the query task results of failure reasons, unfinished states or arrangement obtained in the step Q1 to the electronic filing system;

step Q3, the electronic archive system judges based on the query result returned in the step Q2, and stores and processes the data of the electronic archive processing completion; updating the status of the unfinished electronic archive data and displaying the reasons;

And Q4, carrying out archival task inquiry every a period of time, namely repeatedly executing the steps Q1-Q3.

In the method for implementing electronic archive data processing shown in fig. 1-4, the method is based on an electronic archive data processing system, and functional module units included in the electronic archive data processing system exist in the form of node modules, which are respectively associated with corresponding documents, and the functions of the functional module units are further described below:

1. the accounting document unit is accounting document data of a financial system, is automatically accessed through a financial system interface, and supports a user to conduct export and condition inquiry at the node;

2. the voucher associated bill unit is a financial system voucher associated bill and is automatically accessed through a financial system interface, so that a user is supported to conduct export or condition inquiry at the node;

3. the business bill unit comprises financial system bill data and standardized electronic archive bill data, comprises multiple types of business bill data, associates the bill data based on the certificates, and is automatically accessed by a financial system interface to support the export or condition inquiry of a user under the corresponding bill node;

4. the invoice data unit comprises financial system invoice data and standardized electronic archive invoice data, comprises multiple types of invoice data and associated bill data, and nodes in the unit are automatically accessed by a financial system interface or synchronized by invoice center data, so that a user is supported to export or query conditions under the corresponding invoice data nodes;

5. The accessory information data unit is used for associating business documents and comprises financial system accessory information data and standardized electronic file accessory information data, nodes in the unit are automatically accessed by a financial system interface, and a user is supported to export or query conditions under the corresponding accessory information nodes;

6. the system comprises an account book information archive unit, a node data processing unit and a node data processing unit, wherein the account book information archive unit is a financial system account book information basic archive, and the node data is automatically accessed by a financial system interface or newly added and maintained under the node to support user condition inquiry;

7. the three-party application setting unit is used for defining basic information of a client financial system and an electronic file system and supporting a user to view data and newly-added edit under the node;

8. the service classification setting unit is associated with the three-party application, and the node is used for defining codes and name information corresponding to each service classification under the corresponding three-party application and supporting the checking and the newly added editing at the node;

9. the service type definition unit is used for associating service classification settings, and the node is used for defining service type information corresponding to data under each service classification and supporting checking and newly added editing at the node;

10. the data structure definition unit is used for defining a data structure corresponding to each service type data, and comprises a storage table code, a table name, a field code, a field name, a field length and a field type, and supports the new addition and modification maintenance under the node;

11. The data structure mapping unit is used for defining the comparison relation between the source data service type and the target data service type to be standardized, configuring the mapping content from field information in source data to target data field information according to the respective data structure definition, completing the electronic archiving data processing standardization process according to the configuration, wherein the node comprises the source data field information, the formula editor setting and the archive type, and the node supports a user to check, edits the fields to be mapped and formulas to be used in a pop-up formula editor frame after clicking the mapping fields, saves and supports editing and modification;

12. the connection configuration unit is associated with the three-party application and is used for setting connection address information of the corresponding three-party application, wherein the connection address information comprises an access address, authorization information, an access key, a login user, a login password and the like;

13. the document type setting unit is used for maintaining each transaction type and corresponding printing code under the corresponding document type, and comprises a document type code, a document type name, a transaction type code, a transaction type name and a printing code, wherein the node supports the newly added maintenance data and condition inquiry of a user;

14. The printing setting unit is used for associating service type definition, the node is used for defining a printing template of data under the corresponding service type, and the printing setting unit comprises a template file uploading, a printing output file type and a printing type, and supports a user to newly add and maintain template information, view data and activate and deactivate the template.

In a preferred embodiment, the electronic archive data processing system must include or configure three-party applications, service classifications, service types, and data structure definitions, and if not configured, tenant permission issuing and file printing generation cannot be performed; the data structure mapping provides a standardized scheme of data, if the data is not configured, the system directly takes the accessed financial system source data for archiving, and the process of generating the electronic archive system archive data in a standardized way is not performed; the bill type is set into configuration business bill type and printing coding information, if the financial system needs to document filing, the content needs to be configured, and if the financial system does not need to document data processing, the system does not need to document data processing.

In a further embodiment, a method for implementing electronic archive data processing is provided, which includes the steps of:

Further, the method for processing the electronic archive data comprises the following steps:

step W4, configuration data structure definition setting: according to the data content to be archived by the service system and the data content received by the electronic archive, configuring data structure information corresponding to each service type, including storage table names and field specific information;

Furthermore, the method for processing the electronic archive data comprises the following steps:

In order to implement the electronic archive data processing system and the electronic archive data processing implementation method thereof, in the implementation method of electronic archive data processing of the invention, each functional module needs to be configured or set for the electronic archive data processing system of the invention, and the specific steps of each functional module are as follows:

F1. configuring three-party application settings: before electronic archive data processing, three-party application settings need to be preconfigured, and the three-party application definition file serving as the electronic archive data processing system contains codes and names of the three-party application definition files.

F2. And (3) configuring service classification setting: under the corresponding three-party application, the service classification setting is carried out according to the service classification under the actual service scene application, and the service classification coding and the name thereof are included.

F3. Configuration service type setting: under the established service classification, the service types needing to be archived are newly increased according to the actual application scene, and the method comprises the following configuration:

1) Accounting documents: defining the corresponding service type of the accounting document, including the corresponding code and name thereof, and being used for accepting the data of the filing accounting document;

2) Document associated document: defining a corresponding service type of the voucher associated document, including a corresponding code and a name thereof, and receiving the voucher associated document data; if the actual business does not document filing or the relation with the certificates is established in the document data of the financial system, the item is a selectable item;

3) Business document: defining the service types corresponding to all the receipts in the filing, such as payable bill, payment bill, reimbursement bill and the like, and carrying out definition release according to the service receipt type of the financial system, wherein the service types comprise corresponding codes and names and are used for receiving service receipt data;

4) Bill: defining the corresponding business types of various invoices in the archiving, such as value-added tax electronic common invoices, all-electric invoices, rated invoices and the like, and carrying out defined release according to the invoice types generated by actual business, wherein the invoice types comprise and correspond to code names for receiving invoice data;

5) Accessories: and defining the service type corresponding to the additional information related in the archiving, wherein the service type is used for accepting the accessory information data and comprises the corresponding code name.

F4-1. Configuration data structure definition setting: under the corresponding service type, establishing corresponding data structure definition information for defining the contents of specific structures, fields and the like of data, wherein the configuration comprises the following steps:

1) Library table coding and name: a specific database table name for defining and storing the service type;

2) Field coding: for defining specific service field codes in the database table;

3) Field name: the method is used for defining specific service field names in a database table, and is also used for menu node checking and template configuration matching of corresponding nodes and data;

4) Field type: specific types for defining corresponding fields, including characters, text, floating point, integer, etc.;

5) Field length: for defining the length of the corresponding field;

6) Remarks: remark information for adding corresponding fields, not necessarily filling items.

F4-2, configuring data structure mapping setting: in the invention, the data structure mapping setting provides a quick and easy-to-adjust data corresponding relation setting mode, a user can select a source data service type and a target data service type to set, field information in source data is mapped to fields of target data based on a defined data structure, and a formula editor is provided in the configuration data structure mapping setting to carry out diversified editing on the information and provide archive definition for translating data information. The configuration content of the configuration data structure map setting is as follows:

1) Configuring a main table:

source data: selecting a source service type to be standardized, namely a necessary entry, based on the service type definition;

target data: selecting a converted target service type, here a mandatory entry, based on the service type definition;

2) Configuration sub-table:

archive type: if the information is stored and the file translation is carried out, selecting the file type maintained in the file definition, and inputting the item unnecessarily;

the formula: the information is edited according to the formula editor, the specific field information in the source data can be selected, and the information can be edited or obtained through the formula, so that the information is not necessary to input terms.

F5. Configuring a print template setting: based on the service types defined by the source data and the target data, defining a printing template under the corresponding service types of the data needing to be archived, wherein the printing template comprises the following contents:

1) Template name: defining a specific name of the template information, so that the identification is facilitated;

2) Template category: the method is used for defining the file content category output by the template and supporting the same data to output different contents according to different category templates;

3) Status: the method is divided into starting and stopping, and can perform state operation on the template and adjust whether to output the type of files;

4) Output format: the method is used for defining the file format output by the corresponding template and supporting the output of pdf and txt formats;

5) Template file: the template file for printing is uploaded, and is uploaded and stored under corresponding template data after the template is set in the word document for the necessary transmission item.

F6. Configuration parameter management settings: the electronic filing needs to set two parameters of whether to increment filing and a filing beginning account period, whether to increment opening or closing is set according to an actual filing business scene, and accounting years and months of the beginning account period are set according to the initial account period of the filing business data.

F7. Configuration connection configuration: based on the three-party application set in the three-party application, the system connection information under the corresponding three-party application is configured, and the configuration content is as follows:

1) The access mode is as follows: the content is a method for determining the acquisition mode of data, and comprises an api interface, a database, importing or manually maintaining;

2) Platform type: the content is the type corresponding to the three-party application, namely the type of the financial system and the electronic file system;

3) Category: the content is to determine a system corresponding to the three-party application as a data acquisition party or a data receiving party, wherein the acquisition party is a source, and the receiving party is a target;

4) Address: the content is connection address information corresponding to the three-party application;

5) Authorization information: if the three-party application needs the authorization information, the corresponding authorization information such as an authorization key, a login account number, a login password, an encryption level and the like can be added according to the rule.

F8. The electronic file system initiates an acquisition task: the electronic file system initiates a collection task request to an electronic filing data processing system, wherein the collection task request comprises account book coding, tenant id, data type and accounting period, the electronic filing data processing system starts to enter a data processing step after receiving request information, and returns a unique serial number of a collection request to the electronic file system, records a three-party application, serial number, account book, request message and request time of the request to an interface for monitoring, and initializes a processing state to be unprocessed.

F9. And a data processing step: the method comprises F9.1 reverse data processing, namely acquiring whether incremental archiving parameter values are set in parameter management in an electronic archiving data processing system, if so, skipping the following process, and if not, entering the following process.

F9.1.1 delete historical attachment data:

1) Acquiring the account book and the accessory data during accounting in target data in an electronic filing data processing system, and deleting the data;

2) Acquiring records in the standardized log according to the data, summarizing a main key of source data, and deleting the standardized log;

3) Querying an account book in a cache and whether distributed lock control exists during accounting, if so, deleting the source data, and if not, deleting the part of source data.

F9.1.2 Deleting historical invoice data:

1) Acquiring the invoice data in the target data and the invoice data in the accounting period in the electronic filing data processing system, and deleting the invoice in the target data in a classified manner;

2) And inquiring the corresponding data standardization log according to the target data, and deleting the data standardization log.

F9.1.3 Deleting the historical document data:

1) Acquiring the bill book and bill data in the accounting period in the target data in the electronic filing data processing system, and deleting the bill in the target data in a classified manner;

2) Inquiring a corresponding data standardized log according to the target data, summarizing a primary key of source data, and deleting the standardized log;

3) Inquiring receipt data in the incoming source data according to the source data main key, summarizing format file addresses, deleting corresponding files in the file server, and deleting part of the receipt.

F9.1.4 delete history credential associated document data:

inquiring the account book and all the document data associated with the certificates during the accounting in the electronic filing data processing system, and deleting.

F9.1.5 delete history credential data:

1) Inquiring the account book and the voucher data in the accounting period in the electronic filing data processing system, summarizing format file addresses, and deleting file data of a file server;

2) And deleting the credential data.

F9.2 processing the data of the account book information files, namely, acquiring the account book information files and checking the checkout state, wherein the method comprises the following steps of:

f9.2.1 obtain an account book information archive:

before data acquisition is started, the acquisition of the account book information files is required, and a financial system interface is called or a new addition is performed on the account book information file unit, wherein the account book information file unit comprises account book codes and account book names.

F9.2.2 Acquiring the account book checkout state of a business system:

according to the account book coding and the account book which is checked out by the financial system under the accounting period, only the account book data which is checked out is filed, and if the account book data is not checked out, the process is terminated.

F9.3 archival data processing:

f9.3.1 acquiring business system accounting documents:

1) Inquiring connection configuration information corresponding to a three-party application to which the service type corresponding to the accounting document belongs;

2) Calling a financial system interface according to the account book, the accounting period and the connection configuration information to acquire accounting document data;

3) Processing the received accounting document data message;

4) Inquiring the data structure definition information corresponding to the accounting voucher service type, and storing the data into a corresponding data table.

F9.3.2 print accounting document layout file:

1) Acquiring credential data of unprinted format files according to the account book and accounting period, and sorting corresponding external system credential main keys;

2) Calling a printing interface of a financial system according to the certificate primary key and the printing code corresponding to the certificate to acquire information of the file;

3) Inquiring a file server address maintained in the object storage, uploading address information to a file server, and obtaining the address of a file;

4) And writing the file address back to the corresponding credential data.

F9.3.3 obtains a credential association document:

1) Inquiring connection configuration information corresponding to the three-party application to which the business type corresponding to the certificate-associated document belongs;

3) Processing the received accounting document data message;

F9.3.3 obtain document data:

1) Inquiring whether the receipt is data which is not obtained from the receipt-related receipt data in the account book and the accounting period, and classifying according to the receipt type;

2) Inquiring connection configuration information corresponding to a three-party application to which a business type corresponding to a bill belongs;

3) Sorting bill primary key information according to the classification, calling a financial system interface according to the connection configuration, and obtaining bill data;

4) Processing the received bill data message;

5) Inquiring data structure definition information under the service type corresponding to the bill type, and storing the data into a corresponding data table;

6) Repeating the steps 3) -5) until all types of bill data are acquired.

F9.3.4 receipt printing process:

1) Acquiring receipt data of unprinted format files according to the account book and accounting period, and sorting corresponding external system receipt main keys;

2) Acquiring a printing code maintained in the bill type setting according to the bill type code;

3) Calling a financial system printing interface according to the bill primary key and the corresponding printing code to acquire information of a file;

4) Inquiring a file server address maintained in the object storage, uploading address information to a file server, and obtaining the address of a file;

5) And writing the file address back to the corresponding bill data.

F9.3.5 bill standardization treatment:

1) Inquiring data in the voucher associated bill according to the account book and the accounting period, and sorting the bill numbers according to the bill types;

2) Inquiring various invoice data associated with the corresponding bill number under the bill type according to the type;

3) Inquiring corresponding data structure mapping setting according to the business type corresponding to the invoice type;

4) Performing standardized processing on invoice data according to mapping setting, including account book coding, accounting period, bill number, bill file address and main information contained in the bill, and generating target data;

5) Inquiring a table structure set in the corresponding data structure definition according to the target service type, and storing data into the table;

6) Repeating F9.3.5.3) -F9.3.5.5) until all types of bill data processing under the bill type is completed;

7) F9.3.5.2) -F9.3.5.6) are repeated until the invoice data processing corresponding to the documents under all the document types is completed.

F9.3.6 Accessory data acquisition:

1) Inquiring the account book, the document data associated with the certificates during the accounting period, and sorting all document numbers;

2) Inquiring connection configuration information corresponding to a three-party application to which the service type corresponding to the accessory belongs;

3) Calling a financial system interface according to the connection configuration to acquire accessory information data corresponding to the document numbers;

4) Processing the received attachment information data message;

5) Inquiring the data structure definition information under the service type corresponding to the accessory, and storing the data into a corresponding data table.

F9.3.7 Accessory data normalization:

1) Inquiring data in the certificate associated bill according to the account book and accounting period, and sorting the bill number;

2) Inquiring the associated accessory information data under the corresponding bill number;

3) Inquiring corresponding data structure mapping setting according to the service type corresponding to the accessory;

4) Carrying out standardized processing on the accessory information data according to the mapping setting, including account book coding, accounting period, bill number, accessory file address and other contained main information, and generating target data;

5) Inquiring a table structure set in the corresponding data structure definition according to the target service type, and storing data into the table.

F9.3.8 bill standardization processing:

1) Acquiring data structure mapping setting under a corresponding service type according to the bill type;

2) If the source service type is obtained successfully, inquiring data in a data table set by the data structure definition according to the source service type;

3) Obtaining information of corresponding fields in source data according to the queried data structure mapping setting, and editing according to a formula to obtain a result of the corresponding fields of target data, wherein the result comprises account book codes, service dates, total amount, format file addresses, uploading time, service receipt numbers, corresponding receipt numbers and receipt other information;

4) And storing the generated target data into a data table of the data structure definition setting corresponding to the target service type.

F9.3.9 archive data processing write back:

1) Inquiring the document data related to the vouchers according to the account book and accounting period, and classifying according to the document types;

2) Inquiring whether the acquired bill data and the printed data in the bill data are yes in the corresponding certificate association bill or not, and whether the acquired state is yes in the corresponding certificate association bill or not is updated;

3) And inquiring all the corresponding invoice quantity and accessory quantity in the corresponding bill main key, and writing back the invoice quantity and accessory quantity fields so as to facilitate checking data.

F10. A data file generation step:

f10.1 credential data file generation:

1) Inquiring a data file printing template maintained under the corresponding service type in the printing setting according to the service type corresponding to the accounting document;

2) Inquiring data table information maintained in the data structure definition according to the service type corresponding to the accounting document, and inquiring document data meeting the conditions according to the account book and accounting period;

3) Generating a data file corresponding to the template according to the template and the credential data;

4) Inquiring file server information maintained in the object storage, and uploading the generated data file to a file server;

5) And storing the acquisition address, the account book, the accounting period, the acquisition serial number and the file path information of the data file into a data file record table for the electronic file system to acquire a result.

F10.2 Document data file generation:

1) Inquiring a data file printing template maintained under the corresponding service type in the printing setting according to the target service type corresponding to various documents;

2) Classifying the bills, inquiring data table information maintained in the data structure definition according to the target service type corresponding to the bills, and inquiring bill data meeting the conditions according to the account book and accounting period;

3) Generating a data file corresponding to the template according to the template and the bill data, and recording file information;

4) Repeating F10.2.2) -F10.2.3) until printing of all document data files is completed;

5) Combining the data files output by the corresponding templates according to the types of the templates, inquiring file server information maintained in the object storage, and uploading the combined data files to a file server;

6) And storing the acquisition address, the account book, the accounting period, the acquisition serial number and the file path information of the data file into a data file record table for the electronic file system to acquire a result.

F10.3 Invoice data file generation:

1) Inquiring a data file printing template maintained under the corresponding service type in the printing setting according to the target service type corresponding to each invoice;

2) Classifying the invoice, inquiring data table information maintained in the data structure definition according to the target service type corresponding to the invoice, and inquiring invoice data meeting the conditions according to the account book and the accounting period;

3) Generating a data file corresponding to the template according to the template and invoice data, and recording file information;

4) Repeating F10.3.2) -F10.3.3) until all invoice data files are printed;

F10.4 Generating an attachment information data file:

1) Inquiring a data file printing template maintained under the corresponding service type in the printing setting according to the target service type corresponding to the accessory information;

2) Inquiring data table information maintained in the data structure definition according to a target service type corresponding to the accessory information, and inquiring accessory information data meeting the conditions according to the account book and the accounting period;

3) Generating a data file corresponding to the template according to the template and the attachment information data;

F10.5 Updating the processing state:

after the process of archiving data is completed, the processing state under the corresponding serial number in interface monitoring needs to be updated, including processing success, unprocessed and processing failure, and the reasons are recorded.

F11. A data result obtaining step:

the electronic file system initiates a request for acquiring the acquisition result, wherein the request comprises a serial number, and the electronic filing data processing system inquires a processing result in interface monitoring after receiving the serial number.

1) In the treatment: returning to the state in the processing of the electronic file system;

2) Failure of treatment: returning a specific failure reason of the electronic file system;

3) The treatment is successful: inquiring the data file information recorded in the data file record table, sorting the data file addresses corresponding to various data, and returning to the electronic file system for archiving data and storing.

In the electronic filing data processing system and the working method thereof, the interface information of the electronic filing data processing system is as follows:

interface J-1. Accounting document archival data processing:

public Boolean collVoucherFile(MakeFileConfig makeFileConfig)；

receiving parameters: the method comprises the steps of collecting serial numbers, account book codes, accounting periods, source data service types, template binding service types, template types and whether merging or not;

Returning data: storing successful and failed results;

description of the functions: receiving a processing request for archiving accounting documents, inquiring connection configuration, calling a financial system interface to obtain the documents, printing the document data, inquiring accounting documents meeting the conditions according to the account book and the accounting year and month, obtaining a data file template corresponding to the documents, printing the data and uploading the data to a file server.

Interface J-2. Business document, bill, attachment filing data processing:

Public Boolean collBillFile(List<MakeFileConfig> makeFileConfigList)；

returning data: storing successful and failed results;

description of the functions: receiving a processing request of filing business receipts, notes and accessories, inquiring connection configuration, calling a financial system interface to acquire business receipts and accessory data, printing the receipts data, inquiring receipts, notes and accessories meeting the conditions according to an account book and accounting years and months, acquiring a corresponding data file template, printing data and uploading the data to a file server.

Interface J-3. Data acquisition interface:

Map<String, Map<String, List<Map<String, Object>>>> pullData(@RequestBody PullConfig pullConfig)；

Receiving parameters: the method comprises the steps of obtaining a task number, a source data service type, a three-party application, connection configuration, obtaining parameters and tenant id;

returning data: the acquired data corresponding to the source service type;

description of the functions: and calling a data acquisition interface of the three-party application system according to the connection configuration, processing the received data message, and returning data of the corresponding service type after the processing is completed.

Interface J-4. File upload interface:

HawkFile putFileTenant(@RequestBody PutFileVO putFileVO, @RequestParam("tenantId") String tenantId) throws IOException;

receiving parameters: the method comprises a file uploading path, a file name, file information and a tenant id;

returning data: information such as an acquisition address and a file name of a file;

description of the functions: and acquiring file server information in the object storage according to the tenant id, and uploading the file to a file server.

Interface J-5 File deletion interface:

void removeFileBatch(@RequestBody List<String> fileName, @RequestParam("tenantId") String tenantId);

receiving parameters: the method comprises a file storage path and a tenant id;

description of the functions: and acquiring file server information in the object storage according to the tenant id, and deleting the file under the received file path from the file server.

Interface J-6. Data deletion invalidate interface:

Map<String, Object> deleteFileData(@RequestBody Map<String, Object> paramMap);

receiving parameters: including book codes, accounting years, accounting months;

returning data: the final result of the deletion, the failure cause;

Description of the functions: inquiring certificates, various receipts, various invoice data and attachment information data in the electronic filing data layer processing system according to account book codes, accounting years and accounting months, and deleting corresponding source data, target data and standardized data according to service types.

Interface J-7. Electronic archive credential acquisition interface:

public Map<String, Object> getAccountFile(@RequestBody Map<String, Object> paramMap)；

receiving parameters: including account book coding, accounting period, data category;

returning data: serial number collected at this time;

description of the functions: and acquiring and processing the voucher data in the financial system according to the account book coding and accounting period, printing according to the data file template data, generating a data file and storing the data file into a result record table.

Interface J-8. Electronic archive credential result acquisition interface:

public Map<String, Object> queryVouResult(@RequestBody Map<String, Object> paramMap) ；

receiving parameters: collecting serial numbers;

returning data: collecting the state, failure reason and data file result of the processing;

description of the functions: and returning to the state if the processing state is unprocessed, returning to the failure reason if the processing is failed, and inquiring the result in the data file record table under the corresponding serial number and returning if the processing is successful.

Interface J-9. Electronic archive credential archive completion notification interface:

public Map<String, Object> downLoadVouBack(@RequestBody Map<String, Object> paramMap) ；

receiving parameters: collecting serial numbers;

returning data: the result state of execution comprises a success state or a failure state and a reason;

description of the functions: and acquiring results in the data file record table under the corresponding serial number of the serial number query, sorting storage paths of the files, querying file server addresses maintained in object storage, and deleting data in the corresponding path data files and the result record table.

Interface J-10. Electronic archive document, bill, accessory acquisition interface:

public Map<String, Object> getBillFile(@RequestBody Map<String, Object> paramMap)；

returning data: serial number collected at this time;

description of the functions: and acquiring and standardizing bill data, accessory data and invoice data in the financial system according to the account book coding and accounting period, printing according to the data file template data, generating a data file and storing the data file in a result record table.

Interface J-11. Electronic archive document, bill, accessory result acquisition interface:

public Map<String, Object> queryBillResult(@RequestBody Map<String, Object> paramMap) ；

receiving parameters: collecting serial numbers;

Interface J-12. Electronic archive documents, notes, attachment archive completion notification interface:

public Map<String, Object> downLoadBillBack(@RequestBody Map<String, Object> paramMap)；

receiving parameters: collecting serial numbers;

In summary, the electronic archiving service system arranged in the electronic archiving data processing system can complete the butt joint of various financial systems and electronic archive systems, meets the data processing requirement, automatically performs standardized processing of data and format file printing after accessing financial system data, can be displayed on a corresponding interface according to the issued service type and is convenient to check.

Finally, it should be noted that: the foregoing description is only a preferred embodiment of the present invention, and the present invention is not limited thereto, but it is to be understood that modifications and equivalents of some of the technical features described in the foregoing embodiments may be made by those skilled in the art, although the present invention has been described in detail with reference to the foregoing embodiments. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for processing and realizing electronic archive data comprises the following steps:

step W1, configuring application settings: configuring application information of a source service system and a target electronic file system according to the archiving flow;

step W2, configuring service classification setting: configuring corresponding service classification information according to the archiving data of the service system and the electronic archive system;

step W3, configuring service type setting: defining and configuring service types according to service data types filed by a service system; carrying out service type definition configuration according to the type of the archive data to be received by the electronic archive system;

Step W4, configuration data structure definition setting: according to the data content filed by the service system and the data content received by the electronic file, configuring data structure information corresponding to each service type, wherein the data structure information comprises a storage table name, a storage table code, a table name, a field code, a field name, a field length and a field type;

step W5, configuring data structure mapping setting; according to the data content filed by the service system and the data content received by the electronic file, carrying out data structure mapping setting on the data needing to be subjected to standardized processing; setting a comparison relation between the standardized source data service type and the target data service type according to the data structure mapping, and defining mapping contents from field information in the configuration source data to target data field information according to the respective data structure;

step W6, configuring a printing template setting: according to a specific archiving service scene, setting a data template for data under a service type to be archived, and setting a data configuration format file template for calling data printed by a service system interface for data printed by a format file;

step W7, configuration parameter management setting: whether the electronic archiving setting is used for incremental archiving and the archiving starting accounting period is set, whether the actual archiving service scene setting is used for incremental opening or closing is set, and accounting years and months of the starting accounting period are set according to the initial accounting period of the archiving service data;

step W10, acquiring business system certificate associated document data: acquiring the document data associated with the document through a business system interface according to the document data and storing the document data to an electronic filing data processing system;

step W13, printing the document data format file: according to the bill type in the acquired bill data, classifying and acquiring the printing codes maintained under the corresponding type in the bill type setting, calling a business system interface to print, and storing the file address of the corresponding bill; the printing code comprises a receipt type code, a receipt type name, a transaction type code and a transaction type name;

2. The method for implementing electronic archive data processing according to claim 1, wherein the method for implementing electronic archive data processing is implemented according to an electronic archive data processing system, the electronic archive data processing system comprises an electronic archive service system and an electronic archive supporting system, and the electronic archive service system is used for processing financial data and generating corresponding format files and data; the electronic filing support system is used for supporting the operation of the electronic filing service system, and a filing data module and a filing setting module are arranged in the electronic filing service system; the electronic filing support system is used for bearing the standardized processing of the data based on the electronic filing service system according to the configuration of the electronic filing data processing system, generating accounting documents, business documents, invoice data and attachment information data of the electronic filing system based on the electronic filing service system to the source system data, generating corresponding data files according to the data file printing templates, and uploading the data files to the file server to obtain results of the electronic filing system.

3. The method for implementing electronic archive data processing according to claim 2, wherein the electronic archive service system is used for performing data processing rules, interface information, content configuration of template configuration, standardized processing of archive data and printing of archive data; the electronic filing service system is internally provided with a filing data module and a filing setting module, realizes access to financial data of the service system, completes data standardization processing according to a configured mapping rule, completes layout file printing processing of the data according to a configured printing template, processes the service system data into filing data capable of being subjected to electronic filing, processes the data file according to the data printing template, uploads the data file to the file server, and obtains the data through the electronic filing system.

4. A method for implementing electronic archive data processing according to claim 3, characterized in that the electronic archive data processing system obtains accounting documents, document associated documents, service documents, bill data and attachment information data according to a specified interface, and the electronic archive data processing system completes standardized processing of financial data according to data structure definition and data structure mapping setting, completes layout file printing and data file printing of data according to print template setting, and finally processes the financial archive data into the data structure of the electronic archive system.

5. The method for implementing electronic archive data processing according to claim 2, wherein an archive data module in the electronic archive service system is used for carrying service data in the client financial system acquired in the data processing process and archive data corresponding to the electronic archive system generated according to configuration; the archiving setting module is used for defining the corresponding business type carrying business data, the system information of the client financial system and the electronic file system, the data standardization rule definition of the client financial system and the electronic file system, the data printing template configuration, and completing the standardization processing and the printing processing of the data according to the configuration.

6. The method for processing electronic archive data according to claim 2, wherein the archive data module includes an accounting document unit, a document associated with document unit, a business document unit, an invoice data unit, an attachment information data unit, and an account book information archive unit; the accounting document unit provides accounting document data management and access or maintenance of corresponding data; the voucher associated bill unit provides voucher associated bill data management and access or maintenance of corresponding data; the business bill unit provides bill data management, issues structures of various types of bills based on data structure definition and data structure mapping, and provides access or maintenance of corresponding data based on the issued bill data; the invoice data unit provides invoice data management, issues the structures of various types of bills based on data structure definition and data structure mapping, and provides corresponding data access or is synchronized by invoice center data based on the issued invoice data; the accessory information data unit provides accessory data management and access of corresponding data; the account book information archive unit provides account book information data management and access or maintenance of corresponding data.

7. The method for realizing electronic archive data processing according to claim 6, wherein the archive setting module is internally provided with a bill type setting unit, a print setting unit, a service type defining unit, a data structure mapping unit, a three-party application setting unit, a service classification setting unit and a connection configuration unit, and the bill type setting unit is used for setting corresponding multi-type bill comparison relations under the bill service type and corresponding service system print codes; the printing setting unit is used for setting a printing template corresponding to the service type data; the service type definition unit is used for defining the data service type of the service system to be archived under each service classification and the corresponding data service type of the electronic archive system; the data structure definition unit is used for defining a data table storage structure of data under each service type; the data structure mapping unit is used for defining a mapping rule from a business system data structure to be standardized to an electronic archive system data structure, editing source data through a formula editor, and corresponding to specific field information of target data; the three-party application setting unit is used for configuring service systems needing interaction and electronic file system information; the service classification setting unit is used for setting service data classification under the three-party application; the connection configuration unit is used for configuring the connection information of the service system and the electronic file system corresponding to the three-party application.

8. The method for processing and implementing electronic archive data according to claim 6, wherein a management platform system and a technical platform system are arranged in the electronic archive supporting system, and the management platform system is used for daily operation of the management platform and is internally provided with a permission management module, a log management module, a task management module, a service management module and a parameter setting module.

9. The method of claim 8, wherein the technical platform system is used for providing data storage and transmission functions, and the technical platform system is provided with an enterprise-level distributed application service unit, a distributed relational database RD6, a distributed message queue unit, a distributed memory unit, a platform DevOps, and a computer and storage platform unit.