Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

XBRL intelligent report platform based statement consolidation data extraction method

A technology for reporting data and reporting, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of manual import, cumbersome, error-prone, etc., to reduce workload, simplify data, and be less prone to errors.

Active Publication Date: 2016-02-17
SICHUAN CHANGHONG ELECTRIC CO LTD
View PDF4 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] (1) When reporting the financial report, it is necessary to download the relevant report data from the consolidated report system, repetitive work
[0005] (2) It is necessary to sort out the reports and correspond to the items of the instance documents, which is cumbersome and error-prone
[0006] (3) It is necessary to manually import the XBRL platform. If the imported information is wrong, it has to be imported again
[0007] (4) It is processed manually and is only used to report very few financial reports. When a large number of financial reports are required, the workload of financial personnel will be extremely large

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0024] Each step and specific implementation of the method of the present invention will be further described exemplarily below.

[0025] First, each table appearing in the present invention will be described in detail.

[0026] 1. Report configuration table

[0027] The report configuration table is used to store all report headers and fixed dimensions defined by the consolidated report system. The specific fields include: report name, report alias, fixed dimension, whether there is a year dimension identifier, whether there is a period dimension identifier, whether it is a consolidated and individual report ID and row dimension name. The name of the report form saved by the report name, such as "Financial assets measured at fair value and whose changes are included in the current profit and loss (by type)", the alias of the report form saved by the report alias, because the report form is provided in the form of an Excel file , the name of the table sample is inconsistent ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to a financial statement generation technology and aims to solve the problems of high workload and high error rate in a process of obtaining existing financial statement consolidation data. The invention provides an XBRL intelligent report platform based statement consolidation data extraction method. The method comprises the following steps: firstly, obtaining fixed dimensions and row dimensions from a statement configuration table, a statement row configuration table and a statement column configuration table, generating and executing a dynamic SQL, automatically retrieving data available for a current statement from a statement consolidation fact table, and inserting the data into a fact middle table; secondly, performing Cartesian join on the statement row configuration table and the statement column configuration table through statement IDs, generating a dynamic SQL of extracted data, inserting the dynamic SQL into a row-column dynamic SQL temporary table, obtaining path and fact value information, and inserting the path and fact value information into a fact value table; and finally, performing circulation on each statement to obtain complete fact value table data identifiable for an XBRL platform, and storing the complete fact value table data in a statement value table. The method is suitable for extracting statement consolidation data of the XBRL intelligent report platform.

Description

technical field [0001] The invention relates to a financial statement generation technology, in particular to a method for extracting consolidated statement data based on an XBRL intelligent report platform. Background technique [0002] XBRL eXtensible Business Reporting Language is an Internet-based, cross-platform computer language that is specially used for the preparation, disclosure and use of financial reports. After an enterprise edits taxonomy standards and instance files, it needs a lot of manual operations to generate instance data files. [0003] With the increasing use of the XBRL platform, financial personnel also exposed some disadvantages when using the XBRL platform to manually import report data: [0004] (1) When reporting the financial report, it is necessary to download the relevant report data from the consolidated report system, which is repetitive work. [0005] (2) It is necessary to sort out the reports and correspond to the items of the instance ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/254G06F16/258
Inventor 李波赵金勇胡嘉居邦鲜利许岩龙
Owner SICHUAN CHANGHONG ELECTRIC CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com