CN101251809A - Implementing method of data interface - Google Patents
Implementing method of data interface Download PDFInfo
- Publication number
- CN101251809A CN101251809A CNA2008100144587A CN200810014458A CN101251809A CN 101251809 A CN101251809 A CN 101251809A CN A2008100144587 A CNA2008100144587 A CN A2008100144587A CN 200810014458 A CN200810014458 A CN 200810014458A CN 101251809 A CN101251809 A CN 101251809A
- Authority
- CN
- China
- Prior art keywords
- data
- definition
- voucher
- template
- formula
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention relates to a method for realizing a data interface; through the interface, the data of an operation system is read to other defined application systems; if the readin data needs to generate a voucher, a financial system is generated according to a voucher template defined by a user; the interface is suitable for wage, fixed assets, data liquidation in a securities industry, capital data, expenses, emolument, etc. The invention has the advantages that: the data needed to be read by the user is read to a database needed by the user, or certain data is processed to the voucher needed by a user financial system; the method for realizing the data interface powerfully supports the increase of client operation in all walks of life, well guarantees the safe and reliable running of the system and reduces the development cost of a software corporation.
Description
Technical field
The present invention relates to Computer Applied Technology, specifically a kind of implementation method of data-interface.
Background technology
Along with all trades and professions are constantly opened up new business, in order to catch up with the acute increasingly market of competition order, this just requires industry software also will do in time corresponding the adjustment, but often all be passive, through constantly exploring for many years and summing up, accumulated a large amount of experiences, developed the data interface method of the various new business of a cover adaptation, as long as required data of reading in are read in interface definition, just data can be read in the appointing system database, being generated to if desired also needs to define type of service in the financial system, data structure information, require flexible definition voucher template formula according to financial accounting again, the data that just collection can be come generate the needed voucher of financial system, and do not need to change any code, and reduce because of business demand changes the risk of bringing, that has accomplished data does not land processing, also reduce the risk that factor brings according to typing again, the more effective cost of development that reduces software company.
Summary of the invention
The implementation method of a kind of data-interface of the present invention realizes in the following manner, comprises the data-interface definition; The type of service definition; According to financial accounting requirements definition voucher template and template parameter is set; Data are read in; Generate the voucher that finance require by the template formula definition; Concrete steps are as follows:
1) data-interface definition defines external data base or external file, comprises connected mode and source list structure, purpose list structure and their corresponding relation of EXCEL file, FOXFRO tables of data, TXT file;
2) link information definition, definition external data base link information comprises the definition database link information, if the external data table is to read in from another database, then need add link information on this function;
3) tables of data definition, definition external data table and internal data list structure comprise definition source data list structure and purpose list data structure;
4) tables of data contextual definition, definition external data table and internal data table concern to also have the relation of reference source table and purpose table definition, and promptly certain is listed as certain row of corresponding purpose table in the table of source;
5) also comprise the voucher interface definition, comprise following content:
(1) type of service definition, definition multiple business type makes things convenient for the user to expand;
(2) Data Source defines, and defines the Data Source and the structure of every kind of type of service, is used to generate voucher and gathers raw data;
(3) voucher template definition is pressed every kind of professional formula that generates voucher of voucher template model definition;
(4) voucher template parameter definition, whether the voucher entry that definition generates merges, and whether voucher embodies The Scarlet Letter, the sort criteria that voucher is recorded separately;
(6) voucher generates, and according to the definition of type of service, data source, image data generates professional needed voucher by the voucher template.
Gather the voucher desired data, show that these data are to take from certain real table, still by the data source after the arrangement process, create final required tables of data information according to attributes such as definition data structure type, length.
The voucher template defines the figure selection formula of each attribute from data source in the voucher by the financial accounting requirement, every kind of corresponding a plurality of voucher templates of type of service; Formula definition is with field value in the data source or use constant, and perhaps both are used in combination; Do not support various functions in the formula, such as summation, character string comprises, the CASE statement, the SQL statement that the type of database that uses according to the user becomes this database to support Formula Parsing; In the voucher template, go back definition of data and filter condition for validity, be put into certain subject such as the data that will meet certain condition, all support dictionary to help in formula and the condition, in the initialize data structure, want help in these row, just preset corresponding dictionary table structure.
Parameter by the setting of voucher template generates various types of vouchers, is saved in the financial system through the voucher legitimate verification.
Excellent effect of the present invention is: the data that the user is required to read are read in the needed database of user, or some data processing become the needed voucher of user's financial system, when providing powerful support for the growth of every profession and trade client traffic, the better safe and reliable operation of safeguards system reduces the cost of development of software company.
Description of drawings:
Fig. 1 represents the process flow diagram of external system reading;
Fig. 2 represents to generate the required process flow diagram of voucher.
Embodiment
Method of the present invention is extensively supported large databases such as MSS SQL, SYBASE, ORACLE, with reference to accompanying drawing method of the present invention be the following specifically describes.
The function that the present invention realizes is divided following several parts:
Data-interface definition: the guide that the user can use this function to provide, the link information of definition external data source (supporting external data base, EXCEL file, FOXFRO file, TXT file), relation between definition external source list structure, purpose list structure and two tables, can use formula between the relation, such as in the external table being " S " represent certain information, in the internal table be " 1 "; Perhaps externally show to read in the purpose table by certain conversion on the basis of data, these situations can be defined as formula.
Type of service and data structure definition: the user can use the newly-increased type of service of this functional definition, the corresponding again a kind of data source of each type of service, data source information comprises, tables of data title, type of database, database linkage information, obtain data source storing process or component Name, each data source comprises one group of data structure, mainly be definition train value, row type, row length, whether major key, have or not help information, write-back literary name name section.
Data are read in: according to user-defined data-interface information, by various database engines, external data is read in the destination data storehouse, according to the contextual definition of interior appearance source data is organized into the data of purpose system needs again.
The voucher template definition: the voucher template definition was divided into for two steps, the firstth, the Template Information of definition voucher head, as: the explanation of voucher template, type of credentials, annex number formula, voucher date formula, data source alternative condition, write-back column information, the single formula of acquiescence system.The write-back column information is for after business datum generates voucher, and the credential information that generates is written in the traffic table, is convenient to from business datum joint investigation like this to credential information, or from voucher joint investigation to the business datum that generates this voucher; Can there be partial data not need to generate voucher in the data that the data source alternative condition is provided by operation system, can in this condition, filters out, just filter one month payroll records such as the wage data.Second step was that the definition voucher is recorded separately Template Information, comprise: the managing detailed catalogue on the vouchers such as summary, subject, book keeping operation direction, the amount of money, all be defined as the formula form, it can be constant, can be that variable is the data structural field value, also can be by these formula of forming, also support many functions such as summation, average, substring in the formula.
Voucher template parameter definition: mainly be to be provided with, be meant when generating voucher whether summary, subject, the entry that the book keeping operation direction is identical merge at different templates; The entry amount of money negative occurs and whether changes the book keeping operation direction; Whether entry information is by the summary ordering; Whether document information generates voucher one by one.
Voucher generates: according to above definition, calls the voucher interface, formula resolved, generate the desired voucher of financial system, can seek survival into a backstage sheet form as required, or derive the text form, or in the credentials table of the financial system that writes direct.
Embodiment
A more common interface satisfies the demand of different business systems by this interface, supports different operation system and financial system, has good extendability.
The inventive method comprises five parts, first, data-interface definition; The second, type of service definition; Three, according to financial accounting requirements definition voucher template and template parameter is set; Four, data are read in; Five, generate the voucher that finance require by the template formula definition.
The data-interface definition, connected mode and source list structure, purpose list structure and their corresponding relation of definition external data base or external file (comprising EXCEL file, FOXFRO tables of data, TXT file etc.);
Type of service and data structure definition, because every profession and trade field business demand is constantly weeded out the old and bring forth the new, must cause the variation of operational data structure and data content, so when new business produces, need the user to come at own Added Business situation, progressively finish presetting of type of service and operational data structure by guide provided by the invention, the data structure here is different from the list structure in the data-interface defined function, this structure is just at the list structure that is used to generate voucher, if the data of reading in do not need to generate voucher, that can define.
Data are read in, and according to the data-interface of business, by different database engines, the data source that needs are read is read in the system of customer requirements.
According to financial accounting requirements definition voucher template and template parameter, after pressing preset information reading of data source, according to the formula that defines in the voucher template, write obtained numerical value as voucher form that financial system requires, lead into text as required or directly write in the financial system table.
The present invention has successfully applied to financial industry, resembles insurance, security etc., makes system datas such as wage, clearance, asset management, emolument accomplish that console mode handles, and has reached to meet with the nothing of financial system to be connected.
Claims (3)
1, a kind of implementation method of data-interface is characterized in that, comprises the data-interface definition; The type of service definition; According to financial accounting requirements definition voucher template and template parameter is set; Data are read in; Generate the voucher that finance require by the template formula definition; Concrete steps are as follows:
1) data-interface definition defines external data base or external file, comprises connected mode and source list structure, purpose list structure and their corresponding relation of EXCEL file, FOXFRO tables of data, TXT file;
2) link information definition, definition external data base link information comprises the definition database link information, if the external data table is to read in from another database, then need add link information on this function;
3) tables of data definition, definition external data table and internal data list structure comprise definition source data list structure and purpose list data structure;
4) tables of data contextual definition, definition external data table and internal data table concern to also have the relation of reference source table and purpose table definition, and promptly certain is listed as certain row of corresponding purpose table in the table of source;
5) also comprise the voucher interface definition, comprise following content:
(1) type of service definition, definition multiple business type makes things convenient for the user to expand;
(2) Data Source defines, and defines the Data Source and the structure of every kind of type of service, is used to generate voucher and gathers raw data;
(3) voucher template definition is pressed every kind of professional formula that generates voucher of voucher template model definition;
(4) voucher template parameter definition, whether the voucher entry that definition generates merges, and whether voucher embodies The Scarlet Letter, the sort criteria that voucher is recorded separately;
(5) voucher generates, and according to the definition of type of service, data source, image data generates professional needed voucher by the voucher template;
(6) gather the voucher desired data, create final required tables of data information according to attributes such as definition data structure type, length.
2, implementation method according to claim 1 is characterized in that, the voucher template defines the figure selection formula of each attribute from data source in the voucher by the financial accounting requirement, every kind of corresponding a plurality of voucher templates of type of service; Formula definition is with field value in the data source or use constant, and perhaps both are used in combination; Do not support various functions in the formula, such as summation, character string comprises, the CASE statement, the SQL statement that the type of database that uses according to the user becomes this database to support Formula Parsing; In the voucher template, go back definition of data and filter condition for validity, be put into certain subject such as the data that will meet certain condition, all support dictionary to help in formula and the condition, in the initialize data structure, want help in these row, just preset corresponding dictionary table structure.
3, implementation method according to claim 1, it is characterized in that, according to financial accounting requirements definition voucher template and template parameter, after pressing preset information reading of data source, according to the formula that defines in the voucher template, write obtained numerical value as voucher form that financial system requires, lead into text as required or directly write in the financial system table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2008100144587A CN101251809B (en) | 2008-03-11 | 2008-03-11 | Implementing method of data interface |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2008100144587A CN101251809B (en) | 2008-03-11 | 2008-03-11 | Implementing method of data interface |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101251809A true CN101251809A (en) | 2008-08-27 |
| CN101251809B CN101251809B (en) | 2011-03-16 |
Family
ID=39955209
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2008100144587A Expired - Fee Related CN101251809B (en) | 2008-03-11 | 2008-03-11 | Implementing method of data interface |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101251809B (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101458851B (en) * | 2008-12-23 | 2010-06-23 | 浪潮齐鲁软件产业有限公司 | Customizing method for wide invoice simulation template in tax control system |
| CN102456025A (en) * | 2010-10-27 | 2012-05-16 | 镇江华扬信息科技有限公司 | Tool for converting data in financial systems |
| CN106155681A (en) * | 2016-06-28 | 2016-11-23 | 成都诺铱科技有限公司 | Voucher resource edit method |
| CN106952154A (en) * | 2017-03-30 | 2017-07-14 | 国网河南禹州市供电公司 | A kind of automatic accreditation method |
| CN107273494A (en) * | 2017-06-15 | 2017-10-20 | 浪潮软件集团有限公司 | Data acquisition method and device |
| CN107870979A (en) * | 2017-09-30 | 2018-04-03 | 平安科技（深圳）有限公司 | Electronic installation, extract tables of data data method and storage medium |
| CN107918910A (en) * | 2017-09-28 | 2018-04-17 | 平安普惠企业管理有限公司 | Financial affairs receipt generation method, device, equipment and computer-readable recording medium |
| CN109034988A (en) * | 2018-07-26 | 2018-12-18 | 北京京东金融科技控股有限公司 | A kind of accounting entry generation method and device |
| CN110955413A (en) * | 2019-11-28 | 2020-04-03 | 国网河北省电力有限公司沧州供电分公司 | Financial data processing system |
| CN111429105A (en) * | 2020-04-07 | 2020-07-17 | 上海甄汇信息科技有限公司 | Financial middle engine system and method |
-
2008
- 2008-03-11 CN CN2008100144587A patent/CN101251809B/en not_active Expired - Fee Related
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101458851B (en) * | 2008-12-23 | 2010-06-23 | 浪潮齐鲁软件产业有限公司 | Customizing method for wide invoice simulation template in tax control system |
| CN102456025A (en) * | 2010-10-27 | 2012-05-16 | 镇江华扬信息科技有限公司 | Tool for converting data in financial systems |
| CN106155681A (en) * | 2016-06-28 | 2016-11-23 | 成都诺铱科技有限公司 | Voucher resource edit method |
| CN106952154A (en) * | 2017-03-30 | 2017-07-14 | 国网河南禹州市供电公司 | A kind of automatic accreditation method |
| CN107273494A (en) * | 2017-06-15 | 2017-10-20 | 浪潮软件集团有限公司 | Data acquisition method and device |
| CN107918910A (en) * | 2017-09-28 | 2018-04-17 | 平安普惠企业管理有限公司 | Financial affairs receipt generation method, device, equipment and computer-readable recording medium |
| CN107870979A (en) * | 2017-09-30 | 2018-04-03 | 平安科技（深圳）有限公司 | Electronic installation, extract tables of data data method and storage medium |
| CN109034988A (en) * | 2018-07-26 | 2018-12-18 | 北京京东金融科技控股有限公司 | A kind of accounting entry generation method and device |
| CN109034988B (en) * | 2018-07-26 | 2021-01-26 | 北京京东金融科技控股有限公司 | Accounting entry generation method and device |
| CN110955413A (en) * | 2019-11-28 | 2020-04-03 | 国网河北省电力有限公司沧州供电分公司 | Financial data processing system |
| CN111429105A (en) * | 2020-04-07 | 2020-07-17 | 上海甄汇信息科技有限公司 | Financial middle engine system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101251809B (en) | 2011-03-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101251809B (en) | Implementing method of data interface | |
| US20200334412A1 (en) | Data storage medium having a computer program executable to generate a detail document | |
| Lim | Impact of information technology on accounting systems | |
| US6397195B1 (en) | System for managing accounting information in a multi-dimensional database | |
| US7580916B2 (en) | Adjustments to relational chart of accounts | |
| JP2011513870A (en) | Method and system for group data management and classification | |
| US20030033225A1 (en) | Multi-dimensional accounting engine | |
| CN106157130A (en) | Business administration application system and software for budget to people | |
| CN103903092A (en) | Enterprise wage management system | |
| EP0857334A1 (en) | Corporate disclosure and repository system | |
| Hedstrom | Descriptive practices for electronic records: deciding what is essential and imagining what is possible | |
| Zealand | Data integration manual | |
| CN202433952U (en) | General network reporting system | |
| WO2006098951A2 (en) | Accounting method and system | |
| US7519570B2 (en) | Localization of generic electronic registration system | |
| CN107608950A (en) | A kind of method for generating electronic report forms | |
| Gatling et al. | Enterprise information management with SAP | |
| CN114265842A (en) | Audit data processing method, device, equipment and storage medium based on ERP system | |
| US20060190397A1 (en) | Utilizing supporting dimensions to further define transaction entities in a computerized financial/accounting system | |
| Rutherford | A content analysis of collection development policies in American art museum libraries | |
| RU2656982C1 (en) | Method of information retrieval of linguistic models of expression of business relations in documents of archival fund | |
| Ryan et al. | A Statistical Business Register spine as a new approach to support data integration and firm-level data linking: An ABS perspective | |
| Ospanova et al. | Building a model of the integrity of information resources within an enterprise management system | |
| Kharade et al. | Selection of small index to reduce the number of pages for improving efficiency | |
| Yu | Research on the Construction and Application of Computer Financial Analysis System in Enterprises |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20110316 Termination date: 20150311 |
|
| EXPY | Termination of patent right or utility model |