CN103729337A - Report conversion method and device - Google Patents

Report conversion method and device Download PDF

Info

Publication number
CN103729337A
CN103729337A CN201310740376.1A CN201310740376A CN103729337A CN 103729337 A CN103729337 A CN 103729337A CN 201310740376 A CN201310740376 A CN 201310740376A CN 103729337 A CN103729337 A CN 103729337A
Authority
CN
China
Prior art keywords
standard format
field
local
report
mapping table
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
Application number
CN201310740376.1A
Other languages
Chinese (zh)
Other versions
CN103729337B (en
Inventor
尹斌
杨良柏
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Kingdee Software China Co Ltd
Original Assignee
Kingdee Software China Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Kingdee Software China Co Ltd filed Critical Kingdee Software China Co Ltd
Priority to CN201310740376.1A priority Critical patent/CN103729337B/en
Publication of CN103729337A publication Critical patent/CN103729337A/en
Application granted granted Critical
Publication of CN103729337B publication Critical patent/CN103729337B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention provides a report conversion method. The method includes the first step of selecting a selected local report and a report in the standard format and extracting report heading information of the selected local report and report heading information of the report in the standard format, the second step of obtaining fields, selected from the report heading information, of the local report and fields, corresponding to the fields of the local report, of the report in the standard format, the third step of generating and storing a mapping table of the fields of the selected local report and the fields of the report in the standard format, and the fourth step of extracting data from the fields of the local report according to the mapping table and writing the data into the corresponding fields of the report in the standard format. In addition, the invention further provides a report conversion device. Through the report conversion method and device, operation convenience can be improved.

Description

Form conversion method and device
Technical field
The present invention relates to ERP technical field, particularly relate to a kind of form conversion method and device.
Background technology
In conventional art, between ERP system, be generally the system of mutual isomery, database and the list structure of storing data are all different, when need to be according to unified formatted output form, need the manual elder generation of staff to extract data from its ERP system, and then be filled up in the form of consolidation form.For example, ERP system is generating XBRL(Extensible Business Reporting Language according to its data, can expand business report language) during form, need keeper in ERP system, to extract data, then according to XBRL, report tableau format disposal data, so operating efficiency is lower.
Summary of the invention
Based on this, be necessary to provide a kind of form conversion method that can improve operating efficiency.
A form conversion method, comprising:
Obtain local form and the standard format form chosen, extract the report heading information of described local form and standard format form;
Obtain the field of the local form of choosing and the field of the standard format form corresponding with it in described report heading information;
The mapping table of the field of the field of the local form of choosing described in generation and described standard format form storage;
According to described mapping table, from the field of described local form, extract data, and write in the field of corresponding standard format form.
Therein in an embodiment, described in also comprise before obtaining the step of the local form chosen and standard format form:
Obtain local Report List and standard format Report List and show.
Therein in an embodiment, described in also comprise before obtaining the step of the local form chosen and standard format form:
Obtain the querying condition of input, according to described querying condition, described local Report List and/or standard format Report List are screened.
In an embodiment, described standard format form is the form that meets XBRL form therein.
Therein in an embodiment, the step of the field of local form of choosing described in described generation and the mapping table of the field of described standard format form also comprises:
Obtain the query statement/arithmetic statement of input and the field of the standard format form corresponding with it and add in mapping table, and the field that comprises the local form of choosing in described query statement/arithmetic statement.
In addition, be also necessary to provide a kind of form conversion equipment that can improve operating efficiency.
A form conversion equipment, comprising:
Report heading acquisition module, for obtaining local form and the standard format form of choosing, extracts the report heading information of described local form and standard format form;
Field acquisition module, for obtaining the field of the local form of choosing in described report heading information and the field of the standard format form corresponding with it;
Mapping table generation module, for the field of local form chosen described in generating and mapping table the storage of the field of described standard format form;
Data shift module, for extracting data according to described mapping table from the field of described local form, and writes in the field of corresponding standard format form.
In an embodiment, described device also comprises form display module therein, for obtaining local Report List and standard format Report List and showing.
In an embodiment, described form display module also, for obtaining the querying condition of input, screens described local Report List and/or standard format Report List according to described querying condition therein.
In an embodiment, described standard format form is the form that meets XBRL form therein.
Therein in an embodiment, described mapping table generation module is also for obtaining the query statement/arithmetic statement of input and the field of the standard format form corresponding with it and adding mapping table to, and the field that comprises the local form of choosing in described query statement/arithmetic statement.
In above-mentioned form conversion method and device, user can, by choosing in advance local form and standard format form, then select corresponding field to shine upon to generate mapping table in its report heading information.Follow-up when generating standard format form, can find in local form the corresponding automatic reading out data of field and write in the corresponding field of standard format form according to mapping table, thereby improve the convenience of operation.
Meanwhile, user can be by selecting field to generate corresponding mapping table in the ERP system of each isomery.When generating standard format form according to the ERP system of each isomery, can, according to corresponding mapping table reading out data, make the mode of changing form not rely on concrete ERP system, thereby improve extendability.
Accompanying drawing explanation
Fig. 1 is the process flow diagram of form conversion method in an embodiment;
Fig. 2 is the structural representation of form conversion equipment in an embodiment.
Embodiment
As shown in Figure 1, in one embodiment, a kind of form conversion method, the execution of the method depends on computer program, can run in the computer system based on Feng Luoyiman system, and this computer system can be the computer equipment with gateway function.
The method comprises:
Step S102, obtains local form and the standard format form chosen, extracts the report heading information of local form and standard format form.
Local form is the tables of data in the ERP system of each isomery, and standard format form is needs the form that generates.In the present embodiment, annotation formatting form is the form that meets XBRL form.XBRL is based on internet, cross-platform operation, the computerese that be specifically designed to financial report establishment, discloses and use, in the world accounting standard to be combined with computerese, for unstructured data, up-to-date recognised standard and technology that especially financial information exchanges.XBRL form is and meets the form that < < can expand the standard format of business report language (XBRL) technical manual > > and < < accounting standards for enterprises universal classification standard > >.
Report heading information is in local form and standard format form the field information of definition unit lattice attribute type separately, comprises row element information (be in form laterally the field in gauge outfit) and column element information (being the field in longitudinal gauge outfit in form).
In the present embodiment, also comprise before obtaining the step of the local form chosen and standard format form: obtain local Report List and standard format Report List and show.
Can be first using the local Report List in local ERP system with as the standard format form of standard format report definition sample, show respectively user, user is the several local forms of one of single choice or multiselect in local Report List and standard format Report List respectively.That is to say, owing to for example conventionally having a plurality of forms in XBRL form shfft in standard format form, user can choose one or more local forms in local ERP system, and then at XBRL Report List, chooses (for example in the finance table of standard format a kind of) XBRL form of one type accordingly.
Further, obtain the querying condition of input, according to querying condition, local Report List and/or standard format Report List are screened.
For example, user can be by querying conditions such as input Business Name, time (timing statistics of local form, such as finance table in 2013, in March, 2012 finance table), report form type.Because common local form quantity in local ERP system is more, therefore add querying condition to screen and can dwindle the scope that user chooses, thereby facilitate user to choose.
Step S104, obtains the field of the local form of choosing in report heading information and the field of the standard format form corresponding with it.
In the present embodiment, its form with cell can be shown obtain the field of the local form of choosing and the field of the standard format form corresponding with it in report heading information after.For example, in report heading information, there are row element information and column element information, in row element information, comprise the transversely arranged cell with each Related fields, in column element information, comprise with the clump of each Related fields to the cell of arranging.
User can choose by clicking cell the field of local form and standard format form.
Step S106, the field of local form that generation is chosen and the mapping table of the field of standard format form storage.
For example, if user has chosen a3 cell in local form A, in standard format form B, chosen b2 cell, the field of the local form A that a3 cell is corresponding i.e. field in the standard format form B corresponding with b2 cell forms mapping, and this mapping can be recorded in mapping table and store.
Step S108 extracts data according to mapping table from the field of local form, and writes in the field of corresponding standard format form.
If desired according to the local report generation standard format form of this ERP system, can first obtain the mapping table corresponding with this ERP system, find title and the field of the corresponding local form in mapping table of each field in standard format form, then in local form, the data under this field read and write in standard format form in corresponding field.
As above in example, if will generate standard format form B according to ERP system corresponding to local form A, can obtain corresponding mapping table, then according to mapping table, find the field a3 of local form A, read the data of storing under a3, then write in the b2 field of standard format form B.
The step of the field of local form that in the present embodiment, generation is chosen and the mapping table of the field of standard format form also comprises:
Obtain the query statement/arithmetic statement of input and the field of the standard format form corresponding with it and add in mapping table, and in query statement/arithmetic statement, comprising the field of the local form of choosing.
As above in example, user can choose a1 cell and a2 cell in local form A, in standard format form B, chosen b1 cell, and to define arithmetic statement be that a1 and a2 are added, the arithmetic statement that this a1 and a2 are added with standard format form B corresponding to b1 cell in field form mapping, this mapping can be recorded in mapping table and store.
Follow-uply when generating standard format form B, can read a1 and a2 in local form A, calculate it and write in the b1 field of standard format form B afterwards.
Again for example, user can input SQL(Structured Query Language, Structured Query Language (SQL)) statement, in this sql like language, can comprise a4, a5 and a6 cell and partial query condition in local form A, and then choose b3 cell, this SQL statement the field in the standard format form B corresponding with b3 cell form mapping, this mapping can be recorded in mapping table and store.
Follow-uply when generating standard format form B, can first according to mapping table, read this SQL statement, then in local form A, carry out this SQL statement relevant with a4, a5, a6, and the result that execution SQL statement is returned write in the b3 field of standard format form B.
In one embodiment, as shown in Figure 2, a kind of form conversion equipment, comprises report heading acquisition module 102, field acquisition module 104, mapping table generation module 106 and data shift module 108, wherein:
Report heading acquisition module 102, for obtaining local form and the standard format form of choosing, extracts the report heading information of local form and standard format form.
Field acquisition module 104, for obtaining the field of the local form of choosing in report heading information and the field of the standard format form corresponding with it.
Mapping table generation module 106, for generating mapping table the storage of the field of the local form of choosing and the field of standard format form.
Data shift module 108, for extracting data according to mapping table from the field of local form, and writes in the field of corresponding standard format form.
In one embodiment, form conversion equipment also comprises form display module 110, for obtaining local Report List and standard format Report List and showing.
In one embodiment, form display module 110 also, for obtaining the querying condition of input, screens local Report List and/or standard format Report List according to querying condition.
In one embodiment, standard format form is the form that meets XBRL form.
In one embodiment, mapping table generation module 106 is also for obtaining the query statement/arithmetic statement of input and the field of the standard format form corresponding with it and adding mapping table to, and in query statement/arithmetic statement, comprises the field of the local form of choosing.
In above-mentioned form conversion method and device, user can, by choosing in advance local form and standard format form, then select corresponding field to shine upon to generate mapping table in its report heading information.Follow-up when generating standard format form, can find in local form the corresponding automatic reading out data of field and write in the corresponding field of standard format form according to mapping table, thereby improve the convenience of operation.
Meanwhile, user can be by selecting field to generate corresponding mapping table in the ERP system of each isomery.When generating standard format form according to the ERP system of each isomery, can, according to corresponding mapping table reading out data, make the mode of changing form not rely on concrete ERP system, thereby improve extendability.
One of ordinary skill in the art will appreciate that all or part of flow process realizing in above-described embodiment method, to come the hardware that instruction is relevant to complete by computer program, described program can be stored in a computer read/write memory medium, this program, when carrying out, can comprise as the flow process of the embodiment of above-mentioned each side method.Wherein, described storage medium can be magnetic disc, CD, read-only store-memory body (Read-Only Memory, ROM) or random store-memory body (Random Access Memory, RAM) etc.
The above embodiment has only expressed several embodiment of the present invention, and it describes comparatively concrete and detailed, but can not therefore be interpreted as the restriction to the scope of the claims of the present invention.It should be pointed out that for the person of ordinary skill of the art, without departing from the inventive concept of the premise, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with claims.

Claims (10)

1. a form conversion method, comprising:
Obtain local form and the standard format form chosen, extract the report heading information of described local form and standard format form;
Obtain the field of the local form of choosing and the field of the standard format form corresponding with it in described report heading information;
The mapping table of the field of the field of the local form of choosing described in generation and described standard format form storage;
According to described mapping table, from the field of described local form, extract data, and write in the field of corresponding standard format form.
2. form conversion method according to claim 1, is characterized in that, described in also comprise before obtaining the step of the local form chosen and standard format form:
Obtain local Report List and standard format Report List and show.
3. form conversion method according to claim 2, is characterized in that, described in also comprise before obtaining the step of the local form chosen and standard format form:
Obtain the querying condition of input, according to described querying condition, described local Report List and/or standard format Report List are screened.
4. form conversion method according to claim 1, is characterized in that, described standard format form is the form that meets XBRL form.
5. form conversion method according to claim 1, is characterized in that, the step of the field of local form of choosing described in described generation and the mapping table of the field of described standard format form also comprises:
Obtain the query statement/arithmetic statement of input and the field of the standard format form corresponding with it and add in mapping table, and the field that comprises the local form of choosing in described query statement/arithmetic statement.
6. a form conversion equipment, is characterized in that, comprising:
Report heading acquisition module, for obtaining local form and the standard format form of choosing, extracts the report heading information of described local form and standard format form;
Field acquisition module, for obtaining the field of the local form of choosing in described report heading information and the field of the standard format form corresponding with it;
Mapping table generation module, for the field of local form chosen described in generating and mapping table the storage of the field of described standard format form;
Data shift module, for extracting data according to described mapping table from the field of described local form, and writes in the field of corresponding standard format form.
7. form conversion equipment according to claim 6, is characterized in that, described device also comprises form display module, for obtaining local Report List and standard format Report List and showing.
8. form conversion equipment according to claim 7, is characterized in that, described form display module also, for obtaining the querying condition of input, screens described local Report List and/or standard format Report List according to described querying condition.
9. form conversion equipment according to claim 6, is characterized in that, described standard format form is the form that meets XBRL form.
10. form conversion equipment according to claim 6, it is characterized in that, described mapping table generation module is also for obtaining the query statement/arithmetic statement of input and the field of the standard format form corresponding with it and adding mapping table to, and the field that comprises the local form of choosing in described query statement/arithmetic statement.
CN201310740376.1A 2013-12-27 2013-12-27 report conversion method and device Active CN103729337B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201310740376.1A CN103729337B (en) 2013-12-27 2013-12-27 report conversion method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201310740376.1A CN103729337B (en) 2013-12-27 2013-12-27 report conversion method and device

Publications (2)

Publication Number Publication Date
CN103729337A true CN103729337A (en) 2014-04-16
CN103729337B CN103729337B (en) 2018-01-12

Family

ID=50453416

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201310740376.1A Active CN103729337B (en) 2013-12-27 2013-12-27 report conversion method and device

Country Status (1)

Country Link
CN (1) CN103729337B (en)

Cited By (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104268244A (en) * 2014-09-28 2015-01-07 广州华多网络科技有限公司 Method and device for processing form
CN104408030A (en) * 2014-10-28 2015-03-11 用友软件股份有限公司 XBRL (eXtensible Business Reporting Language) instance generation method and XBRL instance generation device
CN104618490A (en) * 2015-02-09 2015-05-13 深圳市联新科技有限公司 Data sharing method and system of communication terminal in medical system
CN105320744A (en) * 2015-09-24 2016-02-10 四川长虹电器股份有限公司 Analytical method of link library with custom XBRL classification criterion
CN105335462A (en) * 2015-09-24 2016-02-17 四川长虹电器股份有限公司 Visual mapping method for data relation of XBRL application platform
CN108509485A (en) * 2018-02-07 2018-09-07 深圳壹账通智能科技有限公司 Preprocess method, device, computer equipment and the storage medium of data
CN109189769A (en) * 2018-08-14 2019-01-11 平安医疗健康管理股份有限公司 Data standardization processing method, device, computer equipment and storage medium
CN109284488A (en) * 2018-09-06 2019-01-29 郑州云海信息技术有限公司 Based on the method, apparatus and medium that modification front end table column data is locally stored
CN109299234A (en) * 2018-09-19 2019-02-01 北京明略软件系统有限公司 A kind of information query method, device and computer readable storage medium
CN109558440A (en) * 2018-10-18 2019-04-02 平安科技(深圳)有限公司 Batch data processing method, device, computer equipment and storage medium
CN109636350A (en) * 2018-12-17 2019-04-16 深圳壹账通智能科技有限公司 Document structure tree method, apparatus, computer equipment and storage medium
JP2019102034A (en) * 2017-12-08 2019-06-24 富士通株式会社 Determination program, determination apparatus and determination method
CN110991150A (en) * 2019-12-16 2020-04-10 中国铁塔股份有限公司 Data format conversion method and device and account reporting system
CN114417802A (en) * 2022-03-22 2022-04-29 创意信息技术股份有限公司 Intelligent report generation system

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101615177A (en) * 2009-07-21 2009-12-30 深圳市科陆电子科技股份有限公司 At structural self-defined report implementation method of server/browser and device
CN101652774A (en) * 2007-04-03 2010-02-17 微软公司 System for financial documentation conversion
CN101689259A (en) * 2007-06-08 2010-03-31 埃森哲环球服务有限公司 Migration of legacy applications
US8055997B2 (en) * 2006-06-26 2011-11-08 Lexmark International Technology, S.A. System and method for implementing dynamic forms

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8055997B2 (en) * 2006-06-26 2011-11-08 Lexmark International Technology, S.A. System and method for implementing dynamic forms
CN101652774A (en) * 2007-04-03 2010-02-17 微软公司 System for financial documentation conversion
CN101689259A (en) * 2007-06-08 2010-03-31 埃森哲环球服务有限公司 Migration of legacy applications
CN101615177A (en) * 2009-07-21 2009-12-30 深圳市科陆电子科技股份有限公司 At structural self-defined report implementation method of server/browser and device

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
上海市会计学会2008 年科研课题: ""网络财务报告(XBRL)研究"", 《会计信息化》 *

Cited By (23)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104268244A (en) * 2014-09-28 2015-01-07 广州华多网络科技有限公司 Method and device for processing form
CN104408030B (en) * 2014-10-28 2018-01-05 用友网络科技股份有限公司 XBRL examples generation method and XBRL example generating means
CN104408030A (en) * 2014-10-28 2015-03-11 用友软件股份有限公司 XBRL (eXtensible Business Reporting Language) instance generation method and XBRL instance generation device
CN104618490A (en) * 2015-02-09 2015-05-13 深圳市联新科技有限公司 Data sharing method and system of communication terminal in medical system
CN104618490B (en) * 2015-02-09 2018-06-19 深圳市联新移动医疗科技有限公司 The data sharing method and system of communicating terminal in medical system
CN105320744A (en) * 2015-09-24 2016-02-10 四川长虹电器股份有限公司 Analytical method of link library with custom XBRL classification criterion
CN105335462A (en) * 2015-09-24 2016-02-17 四川长虹电器股份有限公司 Visual mapping method for data relation of XBRL application platform
JP7064128B2 (en) 2017-12-08 2022-05-10 富士通株式会社 Judgment program, judgment device and judgment method
JP2019102034A (en) * 2017-12-08 2019-06-24 富士通株式会社 Determination program, determination apparatus and determination method
CN108509485A (en) * 2018-02-07 2018-09-07 深圳壹账通智能科技有限公司 Preprocess method, device, computer equipment and the storage medium of data
CN109189769A (en) * 2018-08-14 2019-01-11 平安医疗健康管理股份有限公司 Data standardization processing method, device, computer equipment and storage medium
WO2020034873A1 (en) * 2018-08-14 2020-02-20 平安医疗健康管理股份有限公司 Data standardization method and apparatus, computer device, and storage medium
CN109284488A (en) * 2018-09-06 2019-01-29 郑州云海信息技术有限公司 Based on the method, apparatus and medium that modification front end table column data is locally stored
CN109284488B (en) * 2018-09-06 2021-11-19 郑州云海信息技术有限公司 Method, device and medium for modifying front-end table column data based on local storage
CN109299234A (en) * 2018-09-19 2019-02-01 北京明略软件系统有限公司 A kind of information query method, device and computer readable storage medium
CN109299234B (en) * 2018-09-19 2022-03-15 北京明略软件系统有限公司 Information query method and device and computer readable storage medium
CN109558440A (en) * 2018-10-18 2019-04-02 平安科技(深圳)有限公司 Batch data processing method, device, computer equipment and storage medium
CN109558440B (en) * 2018-10-18 2023-12-15 平安科技(深圳)有限公司 Data batch processing method and device, computer equipment and storage medium
CN109636350A (en) * 2018-12-17 2019-04-16 深圳壹账通智能科技有限公司 Document structure tree method, apparatus, computer equipment and storage medium
CN110991150A (en) * 2019-12-16 2020-04-10 中国铁塔股份有限公司 Data format conversion method and device and account reporting system
CN110991150B (en) * 2019-12-16 2023-10-03 中国铁塔股份有限公司 Data format conversion method, device and account reporting system
CN114417802A (en) * 2022-03-22 2022-04-29 创意信息技术股份有限公司 Intelligent report generation system
CN114417802B (en) * 2022-03-22 2022-06-10 创意信息技术股份有限公司 Intelligent report generation system

Also Published As

Publication number Publication date
CN103729337B (en) 2018-01-12

Similar Documents

Publication Publication Date Title
CN103729337A (en) Report conversion method and device
EP2669815B1 (en) System and method of generating in-memory models from data warehouse models
US10354002B2 (en) Interaction relationship building and explorer for dashboard
US9251238B2 (en) Data warehouse queries using SPARQL
US20110153611A1 (en) Extracting data from a report document
EP2463790B1 (en) Manipulation of elements and their attributes in graphical user interfaces
US20080180458A1 (en) Apparatus and method for data charting with an extensible visualization library
US9069830B2 (en) Retrieving data objects
US10192330B2 (en) Rendering data visualizations in different analytical applications
CN106933845B (en) Method and device for realizing MDX query effect by using SQ L
KR20170098854A (en) Building reports
CN106547841A (en) A kind of data automatic switching method of Excel XML mappings
JP2013507712A (en) Excel-based analysis report creation system and method
CN102214243A (en) Version management system for x extensible business reporting language (XBRL) classification standard
CN103257987A (en) Rule-based distributed log service implementation method
US20140143270A1 (en) Generating dynamic drilldown reports
CN101388018A (en) Computer aided design document management method
US20070282804A1 (en) Apparatus and method for extracting database information from a report
US8782510B2 (en) Cell content scrolling
CN104679880A (en) Device and method for dynamically storing and displaying dynamic input items and business data thereof
US20130268855A1 (en) Examining an execution of a business process
US20130290829A1 (en) Partition based structured document transformation
US9218677B2 (en) Presenting data records based on binning and randomization
US10817486B2 (en) Containment of data structures with data objects in data modeling tools
US20140136293A1 (en) Relative trend analysis of scenarios

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant