CN109816503A - Financial details data creation method, device, computer equipment and storage medium - Google Patents
Financial details data creation method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109816503A CN109816503A CN201910007433.2A CN201910007433A CN109816503A CN 109816503 A CN109816503 A CN 109816503A CN 201910007433 A CN201910007433 A CN 201910007433A CN 109816503 A CN109816503 A CN 109816503A
- Authority
- CN
- China
- Prior art keywords
- data
- business
- item
- detailed
- detailed business
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 30
- 238000012545 processing Methods 0.000 claims abstract description 12
- 230000004044 response Effects 0.000 claims abstract description 10
- 239000013598 vector Substances 0.000 claims description 38
- 238000004590 computer program Methods 0.000 claims description 27
- 238000000605 extraction Methods 0.000 claims description 8
- 238000002360 preparation method Methods 0.000 claims description 3
- 238000010586 diagram Methods 0.000 description 9
- 238000012790 confirmation Methods 0.000 description 7
- 238000004364 calculation method Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 239000000203 mixture Substances 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 238000012216 screening Methods 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 235000013399 edible fruits Nutrition 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 230000032258 transport Effects 0.000 description 1
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
This application involves technical field of data processing, are applied to financial industry, more particularly to a kind of financial details data creation method, device, computer equipment and storage medium.Method in one embodiment includes: to send detailed business data to make a report on instruction to the corresponding terminal of each business bar line, receive detailed business data, detailed business data is made a report on instruction by the corresponding terminal response detailed business data of each business bar line and is obtained, obtain financial details inquiry request, and parse financial details inquiry request, obtain query condition information, invocation target financial statement template, obtain the corresponding relationship between the attribute item of target financial report template and the data item of detailed business data, according to detailed business data, query condition information and corresponding relationship, obtain financial details data, in this way without artificially collecting arrangement detailed business data, data processing is carried out further according to demand, corresponding data are provided, it thus can effectively improve working efficiency.
Description
Technical field
This application involves computer data processing technology field, more particularly to a kind of financial details data creation method,
Device, computer equipment and storage medium.
Background technique
With the development of science and technology, computer digital animation is widely applied in financial field, and financial software is answered
It transports and gives birth to, financial software gives financial bringing great convenience property of related work.
However, traditional financial software does typing operation only for the income data after confirmation, need in advance to income number
According to confirmation by hand and processing is carried out, cause the working efficiency for generating income detail low.
Summary of the invention
Based on this, it is necessary in view of the above technical problems, provide a kind of financial details data that can be improved working efficiency
Generation method, device, computer equipment and storage medium.
A kind of financial details data creation method, which comprises
It sends detailed business data and makes a report on instruction to the corresponding terminal of each business bar line；
Detailed business data is received, the detailed business data is as described in the corresponding terminal response of each business bar line
Detailed business data is made a report on instruction and is obtained；
Financial details inquiry request is obtained, and parses the financial details inquiry request, obtains query condition information；
Invocation target financial statement template, obtain the target financial report template attribute item and the business detail number
According to data item between corresponding relationship；
According to the detailed business data, the query condition information and the corresponding relationship, financial details number is obtained
According to.
In one embodiment, described according to the detailed business data, the query condition information and the correspondence
Relationship obtains financial details data, comprising:
Extraction and the matched data of the query condition information, obtain business detail preparation from the detailed business data
Data；
According to the corresponding relationship, data item corresponding with the attribute item is obtained from the business detail preliminary date
Data content, by the data content correspondence be supplemented to the target financial report template, obtain financial details data.
In one embodiment, the query condition information includes object identity to be checked and time to be checked, it is described from
Extraction and the matched data of the query condition information, obtain business detail preliminary date in the detailed business data, comprising:
It is regular to obtain access corresponding with the object identity to be checked；
According to the time to be checked and access rule, is screened from the detailed business data, obtain industry
Business detail preliminary date.
In one embodiment, the detailed business data includes unit range major event, it is described according to it is described to be checked when
Between and the access it is regular, screened from the detailed business data, obtain business detail preliminary date, comprising:
When the corresponding unit of unit range major event is non-tabulating unit in the detailed business data, the business is judged
Whether the corresponding Criterion Attribute of unit range major event is parameter attribute in detailed data；
It is regular according to the time to be checked and the access when the Criterion Attribute is non-computational Criterion Attribute, from
It is screened in the detailed business data, obtains business detail preliminary date.
In one embodiment, the attribute item for obtaining the target financial report template and the detailed business data
Data item between corresponding relationship before, further includes:
Obtain the attribute item of the target financial report template；
It is searched in the detailed business data according to the attribute item, obtains the attribute item and the business is bright
Count the corresponding relationship between data item accurately.
In one embodiment, described to be searched in the detailed business data according to the attribute item, obtain institute
State the corresponding relationship in attribute item and the detailed business data between data item, comprising:
Data item in the attribute item and the detailed business data is converted into vector form, correspondence obtains attribute item
Vector and data item vector；
The cosine similarity for calculating the attribute item vector and the data item vector, according to the cosine similarity,
Obtain the corresponding relationship between the attribute item and the data item.
A kind of financial details data generating device, described device include:
Instruction sending module makes a report on instruction to the corresponding terminal of each business bar line for sending detailed business data；
Respond module is instructed, for receiving detailed business data, the detailed business data is by each business bar line
The corresponding terminal response detailed business data is made a report on instruction and is obtained；
Request processing module for obtaining financial details inquiry request, and parses the financial details inquiry request, obtains
Query condition information；
Relation acquisition module is used for invocation target financial statement template, obtains the attribute of the target financial report template
Corresponding relationship between item and the data item of the detailed business data；
Data generation module, for according to the detailed business data, the query condition information and the corresponding pass
System, obtains financial details data.
A kind of computer equipment, including memory and processor, the memory are stored with computer program, the processing
Device performs the steps of when executing the computer program
It sends detailed business data and makes a report on instruction to the corresponding terminal of each business bar line；
Detailed business data is received, the detailed business data is as described in the corresponding terminal response of each business bar line
Detailed business data is made a report on instruction and is obtained；
Financial details inquiry request is obtained, and parses the financial details inquiry request, obtains query condition information；
Invocation target financial statement template, obtain the target financial report template attribute item and the business detail number
According to data item between corresponding relationship；
According to the detailed business data, the query condition information and the corresponding relationship, financial details number is obtained
According to.
A kind of computer readable storage medium, is stored thereon with computer program, and the computer program is held by processor
It is performed the steps of when row
It sends detailed business data and makes a report on instruction to the corresponding terminal of each business bar line；
Detailed business data is received, the detailed business data is as described in the corresponding terminal response of each business bar line
Detailed business data is made a report on instruction and is obtained；
Financial details inquiry request is obtained, and parses the financial details inquiry request, obtains query condition information；
Invocation target financial statement template, obtain the target financial report template attribute item and the business detail number
According to data item between corresponding relationship；
According to the detailed business data, the query condition information and the corresponding relationship, financial details number is obtained
According to.
Above-mentioned financial details data creation method, device, computer equipment and storage medium, by sending business detail number
According to instruction is made a report on to the corresponding terminal of each business bar line, detailed business data is received, detailed business data is by each business item
The corresponding terminal response detailed business data of line is made a report on instruction and is obtained, and obtains financial details inquiry request, and parse financial details
Inquiry request, obtains query condition information, invocation target financial statement template, obtain the attribute item of target financial report template with
Corresponding relationship between the data item of detailed business data, according to detailed business data, query condition information and corresponding relationship,
Financial details data are obtained, in this way without artificially collecting arrangement detailed business data, data processing is carried out further according to demand, provides
Corresponding data, thus can effectively improve working efficiency.
Detailed description of the invention
Fig. 1 is the applied environment figure of financial details data creation method in one embodiment；
Fig. 2 is the flow diagram of financial details data creation method in one embodiment；
Fig. 3 is the flow diagram of financial details data generation step in one embodiment；
Fig. 4 is the flow diagram of business detail preliminary date generation step in one embodiment；
Fig. 5 is the flow diagram of corresponding relationship establishment step in one embodiment；
Fig. 6 is the timing diagram of financial details data creation method in one embodiment；
Fig. 7 is the structural block diagram of financial details data generating device in one embodiment；
Fig. 8 is the internal structure chart of computer equipment in one embodiment.
Specific embodiment
It is with reference to the accompanying drawings and embodiments, right in order to which the objects, technical solutions and advantages of the application are more clearly understood
The application is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the application, not
For limiting the application.
Financial details data creation method provided by the present application, can be applied in application environment as shown in Figure 1.Its
In, first terminal 102, second terminal 104 are communicated by network with server 106 respectively.Server sends business detail
Data make a report on instruction to the corresponding terminal of each business bar line, i.e. first terminal may include multiple terminals, receive first terminal
The detailed business data sent, detailed business data make a report on finger by the corresponding terminal response detailed business data of each business bar line
So that arriving.Server obtains the financial details inquiry request that second terminal is sent, and parses financial details inquiry request, is looked into
Conditional information is ask, invocation target financial statement template obtains the attribute item and detailed business data of target financial report template
Corresponding relationship between data item obtains financial details number according to detailed business data, query condition information and corresponding relationship
According to.Wherein, first terminal 102 and second terminal 104 can be, but not limited to be various personal computers, laptop, intelligence
Energy mobile phone peace plate computer, server 106 can use the server cluster of the either multiple servers compositions of independent server
To realize.
In one embodiment, it as shown in Fig. 2, providing a kind of financial details data creation method, applies in this way
It is illustrated for server in Fig. 1, comprising the following steps:
Step 202, it sends detailed business data and makes a report on instruction to the corresponding terminal of each business bar line.
Detailed business data makes a report on that instruction refers to and is used to indicate the instruction that finishing service detailed data makes a report on task, and business is bright
It counts evidence accurately and makes a report on the specific instruction that can be for notifying handler's submission detailed business data of each business bar line of instruction.
Business bar line refers to that department classifies, for example business bar line may include medium-sized and small enterprises business bar line, loan transaction bar line etc., each
Business bar line includes multiple related service handlers.
Step 204, detailed business data is received, detailed business data responds business by the corresponding terminal of each business bar line
Detailed data is made a report on instruction and is obtained.
Detailed business data refers to the income detailed data of each business bar line, can specifically include of that month real revenue,
This month mentions in advance, practical confirmation last month is taken in, abatement proposes income etc. last month in advance.The related service handler of each business bar line exists
It receives after detailed business data makes a report on instruction, instruction is made a report on according to detailed business data, is inputted in financial enterprise planning system
Corresponding detailed business data.
Step 206, financial details inquiry request is obtained, and parses financial details inquiry request, obtains query condition information.
Financial details inquiry request refers to that the request for obtaining financial details data, the carrying of financial details inquiry request are looked into
Conditional information is ask, query condition information can be time dimension, business line dimension etc..By taking certain Corporate Finance as an example, work as company
Management level related personnel it should be understood that income detail situation of each business bar line within a certain period, to carry out business decision
Or when department's planning, financial enterprise planning system can be logged in and carry out data query, input inquiry condition, such as inquiry business bar line
Income detail situation of the A in March, 2018 to June.
Step 208, invocation target financial statement template obtains the attribute item and business detail number of target financial report template
According to data item between corresponding relationship.
Target financial report template refer to specific data content be blank financial statement, can specifically include profit flow table,
Cash flow table etc..Attribute item refers to that the field for characterizing financial statement data information, the data item of detailed business data refer to
For characterizing the field of the data content of detailed business data.The attribute item of target financial report template and detailed business data
Corresponding relationship between data item refers to the corresponding relationship in financial statement template in field and detailed business data between field,
It can be one-to-one relationship, be also possible to logical operation relationship.Using business bore income as target financial report template
For attribute item, the data item of detailed business data include of that month real revenue, it is of that month do not make out an invoice income and it is of that month mention in advance, business
Income+this month of not making out an invoice in bore income=this month real revenue+this month mentions in advance.Using financial bore income as target financial report
For the attribute item of template, the data item of detailed business data is pre- including of that month real revenue, of that month income of not making out an invoice, this month
It mentions, practical confirmation income last month and abatement propose income, financial bore income=business bore income+practical confirmation last month last month in advance
Income-abatement proposes income last month in advance.
Step 210, according to detailed business data, query condition information and corresponding relationship, financial details data are obtained.
The related service handler of each business bar line uploads detailed business data, financial staff or phase according to instruction
Administrative staff's initiation financial details inquiry request is closed to be based on according to the query condition information carried in financial details inquiry request
Corresponding relationship obtains corresponding data from detailed business data, obtains financial details data.
Above-mentioned financial details data creation method makes a report on instruction to each business bar line pair by sending detailed business data
The terminal answered, receives detailed business data, and detailed business data responds business detail number by the corresponding terminal of each business bar line
It is obtained according to instruction is made a report on, obtains financial details inquiry request, and parse financial details inquiry request, obtain query condition information,
Invocation target financial statement template obtains between the attribute item of target financial report template and the data item of detailed business data
Corresponding relationship obtains financial details data, is not necessarily in this way according to detailed business data, query condition information and corresponding relationship
Arrangement detailed business data is artificially collected, data processing is carried out further according to demand, corresponding data is provided, thus can effectively be mentioned
High working efficiency.
In one embodiment, as shown in figure 3, being obtained according to detailed business data, query condition information and corresponding relationship
To financial details data, comprising: step 302, extraction and the matched data of query condition information, obtain from detailed business data
Business detail preliminary date；Step 304, it according to corresponding relationship, is obtained from business detail preliminary date corresponding with attribute item
Data content correspondence is supplemented to target financial report template, obtains financial details data by the data content of data item.Business is bright
Thin preliminary date refers to the detailed business data for meeting query condition information, using query time in March, 2018 to June as inquiry
For conditional information, business detail preliminary date is in March, 2018 to the detailed business data during June.Attribute item refers to
For characterizing the field of financial statement data information, the data item of detailed business data refers to for characterizing detailed business data
The field of data content.The corresponding relationship of attribute item and data item, for example, using business bore income as attribute item, it is of that month real
Income that border is taken in, this month does not make out an invoice and this month are mentioned in advance as data item, and the corresponding relationship of attribute item and data item is category
Property item be equal to the sum of each data item.It is equal to each number according to the corresponding relationship of attribute item and data item, such as according to attribute item
According to the sum of item, obtained from business detail preliminary date of that month real revenue, it is of that month do not make out an invoice income and it is of that month mention in advance it is corresponding
Data value, and data value is subjected to summation operation, using the result of summation operation as business bore in target financial report template
Corresponding data value is taken in, to obtain financial details data.
In one embodiment, query condition information includes object identity to be checked and time to be checked, from business detail
Extraction and the matched data of query condition information, obtain business detail preliminary date in data, comprising: obtain and object to be checked
Identify corresponding access rule；According to time to be checked and access rule, is screened from detailed business data, obtain business
Detail preliminary date.Object identity to be checked refers to that the mark for distinguishing different data object, such as query object specifically may be used
To be business bar line A or team X.Access rule refers to the acquiring way of the corresponding data value of different data object, specifically,
Data object includes medium-sized and small enterprises business line, loan transaction line etc..By taking medium-sized and small enterprises are engaged in line as an example, access rule is specific as follows:
Of that month real revenue is automatically generated by data of making out an invoice, and this month, which does not make out an invoice to take in, fills out 0 automatically, and of that month mention in advance is handled hilllock by service line and filled out
It writes, last month, practical confirmation income system filled out 0 automatically, writes off to mention last month taking in advance and be made a report on by checking hilllock financial staff.
In one embodiment, detailed business data includes unit range major event, as shown in figure 4, according to the time to be checked
With access rule, is screened from detailed business data, obtain business detail preliminary date, comprising: step 402, work as business
When the corresponding unit of unit range major event is non-tabulating unit in detailed data, unit range major event in detailed business data is judged
Whether corresponding Criterion Attribute is parameter attribute；Step 404, when Criterion Attribute be non-computational Criterion Attribute when, according to
Query time and access rule, are screened from detailed business data, obtain business detail preliminary date.Unit range major event
For the type of data object in differentiated service detailed data, unit range major event includes tabulating unit and non-tabulating unit, is converged
Total unit is used to identify the data object Jing Guo certain mathematical operation, and non-tabulating unit needs not move through any mathematics fortune for identifying
The data object of calculation.For example, single business bar line includes multiple business team, using each business bar line as cover sheet
Position, and the business team under each business bar line is then used as non-tabulating unit.Criterion Attribute is in identification service detailed data
The type of index, index include parameter and non-computational index, and non-computational index refers to specific index, and parameter is
Refer to the index that non-computational index is calculated by certain calculating, such as addition subtraction multiplication and division etc..Specifically, work as detailed business data
When middle unit range major event is business team, judge whether the corresponding Criterion Attribute of business team is calculating in detailed business data
Criterion Attribute, when Criterion Attribute is non-computational Criterion Attribute, according to time to be checked and access rule, from detailed business data
In screened, obtain business detail preliminary date.
In one embodiment, it obtains between the attribute item of target financial report template and the data item of detailed business data
Corresponding relationship before, further includes: obtain target financial report template attribute item；According to attribute item in detailed business data
It is searched, obtains the corresponding relationship in attribute item and detailed business data between data item.Attribute item refers to for characterizing wealth
Be engaged in report data information field, using profit flow table as target financial report template for, the attribute item of profit flow table includes business
Bore income, operating profit, net profit etc..Detailed business data is pre- including of that month real revenue, of that month income of not making out an invoice, this month
It mentions, practical confirmation last month is taken in, abatement proposes the data item such as income last month in advance.Specifically, attribute item is taken according to business bore to exist
Data item in detailed business data is searched, and the data item in business bore income attribute item and detailed business data is obtained
Between corresponding relationship.
In one embodiment, as shown in figure 5, being searched in detailed business data according to attribute item, attribute is obtained
Corresponding relationship in item and detailed business data between data item, comprising: step 502, by attribute item and detailed business data
Middle data item is converted to vector form, and correspondence obtains attribute item vector and data item vector；Step 504, computation attribute item to
The cosine similarity of amount and data item vector obtains the corresponding relationship between attribute item and data item according to cosine similarity.
Specifically, attribute item vector P can be expressed as { p1, p2, p3 ..., pm }, m be attribute item number, data item vector [0,
1] value in.Data item vector Q can be expressed as { q1, q2, q3 ..., qn }, and n is the number of data item, and data item vector exists
Value in [0,1], wherein n is greater than or equal to m.Take m=n, poor item is filled up with 0, so as to by attribute item vector P and data item to
It measures Q and carries out scalar product operation, if scalar product operation result is equal to 0, show that there is no corresponding symbolic animal of the birth year items in data item.Such as
Fruit scalar product operation result is not equal to 0, shows that there are corresponding attribute item, computation attribute item vector and data item in data item
The cosine similarity of vector, cosine similarity are to assess the similarity of the two by calculating the included angle cosine value of two vectors,
When cosine similarity be equal to 1 when, declared attribute item be fully present in data item.
It should be understood that although each step in the flow chart of Fig. 2-5 is successively shown according to the instruction of arrow,
These steps are not that the inevitable sequence according to arrow instruction successively executes.Unless expressly stating otherwise herein, these steps
Execution there is no stringent sequences to limit, these steps can execute in other order.Moreover, at least one in Fig. 2-5
Part steps may include that perhaps these sub-steps of multiple stages or stage are not necessarily in synchronization to multiple sub-steps
Completion is executed, but can be executed at different times, the execution sequence in these sub-steps or stage is also not necessarily successively
It carries out, but can be at least part of the sub-step or stage of other steps or other steps in turn or alternately
It executes.
In one embodiment, the timing diagram of financial details data creation method as shown in FIG. 6 provides in the timing diagram
Dynamic cooperative between first terminal, server and second terminal.Specifically, as shown, server transmission business is bright
It counts evidence accurately and makes a report on instruction to the corresponding first terminal of each business bar line.The corresponding first terminal of each business bar line responds business
Detailed data makes a report on instruction, obtains detailed business data and is sent to server.Second terminal sends financial details inquiry request
To server, server receives financial details inquiry request, and parses financial details inquiry request, obtains query condition information.
Server calls target financial report template obtains the attribute item of target financial report template and the data item of detailed business data
Between corresponding relationship financial details data are obtained according to detailed business data, query condition information and corresponding relationship, and
Financial details data are sent to second terminal.
In one embodiment, as shown in fig. 7, providing a kind of financial details data generating device, comprising: instruction is sent
Module 702, instruction respond module 704, request processing module 706, Relation acquisition module 708 and data generation module 710.Its
In, instruction sending module makes a report on instruction to the corresponding terminal of each business bar line for sending detailed business data.Instruction response
Module, for receiving detailed business data, detailed business data responds business detail number by the corresponding terminal of each business bar line
It is obtained according to instruction is made a report on.Request processing module for obtaining financial details inquiry request, and parses financial details inquiry request,
Obtain query condition information.Relation acquisition module is used for invocation target financial statement template, obtains target financial report template
Corresponding relationship between attribute item and the data item of detailed business data.Data generation module, for according to detailed business data,
Query condition information and corresponding relationship obtain financial details data.
In one embodiment, data generation module includes: data extracting unit, for extracting from detailed business data
With the matched data of query condition information, business detail preliminary date is obtained；Data supplementary units are used for according to corresponding relationship,
Data content correspondence is supplemented to mesh by the data content that data item corresponding with attribute item is obtained from business detail preliminary date
Financial statement template is marked, financial details data are obtained.
In one embodiment, data extracting unit includes: Rule unit, for obtaining and object identity to be checked
Corresponding access rule；Screening unit, for being sieved from detailed business data according to time to be checked and access rule
Choosing, obtains business detail preliminary date.
In one embodiment, screening unit includes index judging unit, for when unit range in detailed business data
When the corresponding unit of major event is non-tabulating unit, judge in detailed business data whether is the corresponding Criterion Attribute of unit range major event
For parameter attribute；Index processing unit, for when Criterion Attribute is non-computational Criterion Attribute, according to the time to be checked and
Access rule, is screened from detailed business data, obtains business detail preliminary date.
It in one embodiment, further include that attribute item obtains module before Relation acquisition module, for obtaining target financial
The attribute item of report template；Relationship establishes module, for being searched in detailed business data according to attribute item, obtains attribute
Corresponding relationship in item and detailed business data between data item.
In one embodiment, it includes vector transduced cell that relationship, which establishes module, is used for attribute item and business detail
Data item is converted to vector form in data, and correspondence obtains attribute item vector and data item vector；Vector calculation unit is used for
The cosine similarity of computation attribute item vector and data item vector, according to cosine similarity, obtain attribute item and data item it
Between corresponding relationship.
Specific restriction about financial details data generating device may refer to generate above for financial details data
The restriction of method, details are not described herein.Modules in above-mentioned financial details data generating device can be fully or partially through
Software, hardware and combinations thereof are realized.Above-mentioned each module can be embedded in the form of hardware or independently of the place in computer equipment
It manages in device, can also be stored in a software form in the memory in computer equipment, in order to which processor calls execution or more
The corresponding operation of modules.
In one embodiment, a kind of computer equipment is provided, which can be server, internal junction
Composition can be as shown in Figure 8.The computer equipment include by system bus connect processor, memory, network interface and
Database.Wherein, the processor of the computer equipment is for providing calculating and control ability.The memory packet of the computer equipment
Include non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system, computer program and data
Library.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.The calculating
The database of machine equipment is for storing the data such as financial statement template, detailed business data.The network interface of the computer equipment
For being communicated with external terminal by network connection.To realize a kind of financial details when the computer program is executed by processor
Data creation method.
It will be understood by those skilled in the art that structure shown in Fig. 8, only part relevant to application scheme is tied
The block diagram of structure does not constitute the restriction for the computer equipment being applied thereon to application scheme, specific computer equipment
It may include perhaps combining certain components or with different component layouts than more or fewer components as shown in the figure.
In one embodiment, a kind of computer equipment, including memory and processor are provided, which is stored with
Computer program, which performs the steps of when executing computer program sends detailed business data and makes a report on instruction to each
The corresponding terminal of a business bar line, receives detailed business data, and detailed business data is rung by the corresponding terminal of each business bar line
It answers detailed business data to make a report on instruction to obtain, obtains financial details inquiry request, and parse financial details inquiry request, looked into
Conditional information is ask, invocation target financial statement template obtains the attribute item and detailed business data of target financial report template
Corresponding relationship between data item obtains financial details number according to detailed business data, query condition information and corresponding relationship
According to.
In one embodiment, it is also performed the steps of from detailed business data when processor executes computer program
Extraction and the matched data of query condition information, obtain business detail preliminary date；According to corresponding relationship, from business detail preparation
Data content correspondence is supplemented to target financial report mould by the data content that data item corresponding with attribute item is obtained in data
Plate obtains financial details data.
In one embodiment, acquisition and object to be checked are also performed the steps of when processor executes computer program
Identify corresponding access rule；According to time to be checked and access rule, is screened from detailed business data, obtain business
Detail preliminary date.
In one embodiment, it also performs the steps of when processor executes computer program when in detailed business data
When the corresponding unit of unit range major event is non-tabulating unit, the corresponding index of unit range major event in detailed business data is judged
Whether attribute is parameter attribute；It is regular according to time to be checked and access when Criterion Attribute is non-computational Criterion Attribute,
It is screened from detailed business data, obtains business detail preliminary date.
In one embodiment, it is also performed the steps of when processor executes computer program and obtains target financial report
The attribute item of template；It is searched in detailed business data according to attribute item, obtains number in attribute item and detailed business data
According to the corresponding relationship between item.
In one embodiment, it also performs the steps of when processor executes computer program by attribute item and business
Data item is converted to vector form in detailed data, and correspondence obtains attribute item vector and data item vector；Computation attribute item to
The cosine similarity of amount and data item vector obtains the corresponding relationship between attribute item and data item according to cosine similarity.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated
Machine program performed the steps of when being executed by processor send detailed business data make a report on instruction it is corresponding to each business bar line
Terminal, receives detailed business data, and detailed business data is filled out by the corresponding terminal response detailed business data of each business bar line
Report instruction obtains, and obtains financial details inquiry request, and parse financial details inquiry request, obtains query condition information, calls
Target financial report template obtains corresponding between the attribute item and the data item of detailed business data of target financial report template
Relationship obtains financial details data according to detailed business data, query condition information and corresponding relationship.
In one embodiment, it also performs the steps of when computer program is executed by processor from detailed business data
Middle extraction and the matched data of query condition information, obtain business detail preliminary date；It is pre- from business detail according to corresponding relationship
Data content correspondence is supplemented to target financial report mould by the data content that data item corresponding with attribute item is obtained in standby data
Plate obtains financial details data.
In one embodiment, when computer program is executed by processor also perform the steps of acquisition with it is to be checked right
As identifying corresponding access rule；According to time to be checked and access rule, is screened from detailed business data, obtain industry
Business detail preliminary date.
In one embodiment, it is also performed the steps of when computer program is executed by processor and works as detailed business data
When the corresponding unit of middle unit range major event is non-tabulating unit, the corresponding finger of unit range major event in detailed business data is judged
Mark whether attribute is parameter attribute；When Criterion Attribute is non-computational Criterion Attribute, advised according to time to be checked and access
Then, it is screened from detailed business data, obtains business detail preliminary date.
In one embodiment, it is also performed the steps of when computer program is executed by processor and obtains target financial report
The attribute item of table template；It is searched, is obtained in attribute item and detailed business data in detailed business data according to attribute item
Corresponding relationship between data item.
In one embodiment, it is also performed the steps of when computer program is executed by processor by attribute item and industry
Data item is converted to vector form in business detailed data, and correspondence obtains attribute item vector and data item vector；Computation attribute item
The cosine similarity of vector and data item vector obtains the corresponding pass between attribute item and data item according to cosine similarity
System.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the computer program can be stored in a non-volatile computer
In read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein,
To any reference of memory, storage, database or other media used in each embodiment provided herein,
Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include
Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms,
Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing
Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM
(RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
Each technical characteristic of above embodiments can be combined arbitrarily, for simplicity of description, not to above-described embodiment
In each technical characteristic it is all possible combination be all described, as long as however, the combination of these technical characteristics be not present lance
Shield all should be considered as described in this specification.
The several embodiments of the application above described embodiment only expresses, the description thereof is more specific and detailed, but simultaneously
It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art
It says, without departing from the concept of this application, various modifications and improvements can be made, these belong to the protection of the application
Range.Therefore, the scope of protection shall be subject to the appended claims for the application patent.
Claims (10)
1. a kind of financial details data creation method, which comprises
It sends detailed business data and makes a report on instruction to the corresponding terminal of each business bar line；
Detailed business data is received, the detailed business data is by each business bar line corresponding terminal response business
Detailed data is made a report on instruction and is obtained；
Financial details inquiry request is obtained, and parses the financial details inquiry request, obtains query condition information；
Invocation target financial statement template, obtain the target financial report template attribute item and the detailed business data
Corresponding relationship between data item；
According to the detailed business data, the query condition information and the corresponding relationship, financial details data are obtained.
2. the method according to claim 1, wherein described according to the detailed business data, the inquiry item
Part information and the corresponding relationship, obtain financial details data, comprising:
Extraction and the matched data of the query condition information, obtain business detail preparation number from the detailed business data
According to；
According to the corresponding relationship, the number of data item corresponding with the attribute item is obtained from the business detail preliminary date
According to content, data content correspondence is supplemented to the target financial report template, obtains financial details data.
3. according to the method described in claim 2, it is characterized in that, the query condition information include object identity to be checked and
Time to be checked, the extraction from the detailed business data and the matched data of the query condition information, obtain business
Detail preliminary date, comprising:
It is regular to obtain access corresponding with the object identity to be checked；
According to the time to be checked and access rule, is screened from the detailed business data, it is bright to obtain business
Thin preliminary date.
4. according to the method described in claim 3, it is characterized in that, the detailed business data includes unit range major event, institute
It states according to the time to be checked and access rule, is screened from the detailed business data, obtain business detail
Preliminary date, comprising:
When the corresponding unit of unit range major event is non-tabulating unit in the detailed business data, the business detail is judged
Whether the corresponding Criterion Attribute of unit range major event is parameter attribute in data；
It is regular according to the time to be checked and the access when the Criterion Attribute is non-computational Criterion Attribute, from described
It is screened in detailed business data, obtains business detail preliminary date.
5. the method according to claim 1, wherein the attribute item for obtaining the target financial report template
Before corresponding relationship between the data item of the detailed business data, further includes:
Obtain the attribute item of the target financial report template；
It is searched in the detailed business data according to the attribute item, obtains the attribute item and the business detail number
According to the corresponding relationship between middle data item.
6. according to the method described in claim 5, it is characterized in that, it is described according to the attribute item in the detailed business data
In searched, obtain the corresponding relationship in the attribute item and the detailed business data between data item, comprising:
Data item in the attribute item and the detailed business data is converted into vector form, correspondence obtains attribute item vector
And data item vector；
The cosine similarity for calculating the attribute item vector and the data item vector is obtained according to the cosine similarity
Corresponding relationship between the attribute item and the data item.
7. a kind of financial details data generating device, which is characterized in that described device includes:
Instruction sending module makes a report on instruction to the corresponding terminal of each business bar line for sending detailed business data；
Respond module is instructed, for receiving detailed business data, the detailed business data is corresponding by each business bar line
Terminal respond the detailed business data and make a report on instruction and obtain；
Request processing module for obtaining financial details inquiry request, and parses the financial details inquiry request, is inquired
Conditional information；
Relation acquisition module is used for invocation target financial statement template, obtain the attribute item of the target financial report template with
Corresponding relationship between the data item of the detailed business data；
Data generation module, for obtaining according to the detailed business data, the query condition information and the corresponding relationship
To financial details data.
8. device according to claim 7, which is characterized in that the data generation module includes:
Data extracting unit is obtained for the extraction from the detailed business data and the matched data of the query condition information
To business detail preliminary date；
Data supplementary units, for being obtained and the attribute from the business detail preliminary date according to the corresponding relationship
Data content correspondence is supplemented to the target financial report template, obtains wealth by the data content of the corresponding data item of item
Business detailed data.
9. a kind of computer equipment, including memory and processor, the memory are stored with computer program, feature exists
In the step of processor realizes any one of claims 1 to 6 the method when executing the computer program.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The step of method described in any one of claims 1 to 6 is realized when being executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910007433.2A CN109816503A (en) | 2019-01-04 | 2019-01-04 | Financial details data creation method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910007433.2A CN109816503A (en) | 2019-01-04 | 2019-01-04 | Financial details data creation method, device, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109816503A true CN109816503A (en) | 2019-05-28 |
Family
ID=66603911
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910007433.2A Pending CN109816503A (en) | 2019-01-04 | 2019-01-04 | Financial details data creation method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109816503A (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110297837A (en) * | 2019-06-14 | 2019-10-01 | 阿里巴巴集团控股有限公司 | A kind of data-updating method and device, data query method and apparatus |
| CN110555082A (en) * | 2019-07-23 | 2019-12-10 | 平安科技（深圳）有限公司 | data processing method, data processing device, computer equipment and storage medium |
| CN110991992A (en) * | 2019-11-27 | 2020-04-10 | 贝壳技术有限公司 | Business process information processing method and device, storage medium and electronic equipment |
| CN111460298A (en) * | 2020-03-31 | 2020-07-28 | 深圳市酷开网络科技有限公司 | Service data processing method and device, computer equipment and storage medium |
| CN111625864A (en) * | 2020-05-28 | 2020-09-04 | 北京思特奇信息技术股份有限公司 | Telecommunication service data detail establishment method and system |
| CN112000660A (en) * | 2020-07-03 | 2020-11-27 | 苏宁云计算有限公司 | Multi-report data processing method and device, computer equipment and storage medium |
| CN112016287A (en) * | 2020-07-24 | 2020-12-01 | 浙江鸿程计算机系统有限公司 | Data management method, platform, storage medium and electronic device |
| CN112052653A (en) * | 2020-09-04 | 2020-12-08 | 国网福建省电力有限公司 | Filling method of statement remark information and financial robot |
| CN112131843A (en) * | 2020-09-02 | 2020-12-25 | 苏宁云计算有限公司 | Business report generation method and device, computer equipment and storage medium |
| CN112183035A (en) * | 2020-11-06 | 2021-01-05 | 上海恒生聚源数据服务有限公司 | Text labeling method, device and equipment and readable storage medium |
| CN112861496A (en) * | 2021-03-22 | 2021-05-28 | 平安商业保理有限公司 | Report generation display method and device, computer equipment and readable storage medium |
| CN113379221A (en) * | 2021-06-04 | 2021-09-10 | 远光软件股份有限公司 | Data conversion model construction method, financial data processing method and related equipment |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2303886A1 (en) * | 1997-09-19 | 1999-03-25 | William J. Clancey | Creating and editing electronic documents |
| KR100821701B1 (en) * | 2007-03-06 | 2008-04-14 | 주식회사 엑스너 | Consolidation financial statements processing system |
| CN103473342A (en) * | 2013-09-23 | 2013-12-25 | 北京久其软件股份有限公司 | Report data generating method and system |
| CN103714480A (en) * | 2013-12-30 | 2014-04-09 | 山东中创软件工程股份有限公司 | Self-defined financial statement generation system |
| CN104021450A (en) * | 2014-06-19 | 2014-09-03 | 北京工商大学 | Conglomerate statement management method and device |
| US20140310136A1 (en) * | 2013-04-11 | 2014-10-16 | Thomson Reuters (Markets) Llc | Machine Generated Financial Summary |
| CN106504079A (en) * | 2016-09-22 | 2017-03-15 | 江苏富山企业服务有限公司 | A kind of composite type financial management method and its management platform |
| CN106844320A (en) * | 2016-12-27 | 2017-06-13 | 税友软件集团股份有限公司 | A kind of financial statement integration method and equipment |
| CN107832371A (en) * | 2017-10-27 | 2018-03-23 | 安徽经邦软件技术有限公司 | A kind of Excel intelligent Matchings import system and method based on financial statement |
| US9934213B1 (en) * | 2015-04-28 | 2018-04-03 | Intuit Inc. | System and method for detecting and mapping data fields for forms in a financial management system |
| CN108198065A (en) * | 2018-03-20 | 2018-06-22 | 重庆市农业科学院 | Agriculture construction project financial statement manages system and method |
-
2019
- 2019-01-04 CN CN201910007433.2A patent/CN109816503A/en active Pending
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2303886A1 (en) * | 1997-09-19 | 1999-03-25 | William J. Clancey | Creating and editing electronic documents |
| KR100821701B1 (en) * | 2007-03-06 | 2008-04-14 | 주식회사 엑스너 | Consolidation financial statements processing system |
| US20140310136A1 (en) * | 2013-04-11 | 2014-10-16 | Thomson Reuters (Markets) Llc | Machine Generated Financial Summary |
| CN103473342A (en) * | 2013-09-23 | 2013-12-25 | 北京久其软件股份有限公司 | Report data generating method and system |
| CN103714480A (en) * | 2013-12-30 | 2014-04-09 | 山东中创软件工程股份有限公司 | Self-defined financial statement generation system |
| CN104021450A (en) * | 2014-06-19 | 2014-09-03 | 北京工商大学 | Conglomerate statement management method and device |
| US9934213B1 (en) * | 2015-04-28 | 2018-04-03 | Intuit Inc. | System and method for detecting and mapping data fields for forms in a financial management system |
| CN106504079A (en) * | 2016-09-22 | 2017-03-15 | 江苏富山企业服务有限公司 | A kind of composite type financial management method and its management platform |
| CN106844320A (en) * | 2016-12-27 | 2017-06-13 | 税友软件集团股份有限公司 | A kind of financial statement integration method and equipment |
| CN107832371A (en) * | 2017-10-27 | 2018-03-23 | 安徽经邦软件技术有限公司 | A kind of Excel intelligent Matchings import system and method based on financial statement |
| CN108198065A (en) * | 2018-03-20 | 2018-06-22 | 重庆市农业科学院 | Agriculture construction project financial statement manages system and method |
Non-Patent Citations (1)
| Title |
|---|
| 杨秀璋 等: "《Python 网络数据爬取及分析从入门到精通（分析篇）》", vol. 1, 北京航空航天大学出版社, pages: 181 - 184 * |
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110297837A (en) * | 2019-06-14 | 2019-10-01 | 阿里巴巴集团控股有限公司 | A kind of data-updating method and device, data query method and apparatus |
| CN110297837B (en) * | 2019-06-14 | 2023-03-21 | 阿里巴巴集团控股有限公司 | Data updating method and device and data query method and device |
| CN110555082A (en) * | 2019-07-23 | 2019-12-10 | 平安科技（深圳）有限公司 | data processing method, data processing device, computer equipment and storage medium |
| CN110555082B (en) * | 2019-07-23 | 2024-03-19 | 平安科技（深圳）有限公司 | Data processing method, device, computer equipment and storage medium |
| CN110991992A (en) * | 2019-11-27 | 2020-04-10 | 贝壳技术有限公司 | Business process information processing method and device, storage medium and electronic equipment |
| CN110991992B (en) * | 2019-11-27 | 2024-03-12 | 贝壳技术有限公司 | Processing method and device of business process information, storage medium and electronic equipment |
| CN111460298A (en) * | 2020-03-31 | 2020-07-28 | 深圳市酷开网络科技有限公司 | Service data processing method and device, computer equipment and storage medium |
| CN111625864A (en) * | 2020-05-28 | 2020-09-04 | 北京思特奇信息技术股份有限公司 | Telecommunication service data detail establishment method and system |
| CN112000660B (en) * | 2020-07-03 | 2022-11-15 | 苏宁云计算有限公司 | Multi-report data processing method and device, computer equipment and storage medium |
| CN112000660A (en) * | 2020-07-03 | 2020-11-27 | 苏宁云计算有限公司 | Multi-report data processing method and device, computer equipment and storage medium |
| CN112016287B (en) * | 2020-07-24 | 2024-01-26 | 浙江鸿程计算机系统有限公司 | Data management method, platform, storage medium and electronic equipment |
| CN112016287A (en) * | 2020-07-24 | 2020-12-01 | 浙江鸿程计算机系统有限公司 | Data management method, platform, storage medium and electronic device |
| CN112131843A (en) * | 2020-09-02 | 2020-12-25 | 苏宁云计算有限公司 | Business report generation method and device, computer equipment and storage medium |
| CN112052653A (en) * | 2020-09-04 | 2020-12-08 | 国网福建省电力有限公司 | Filling method of statement remark information and financial robot |
| CN112183035A (en) * | 2020-11-06 | 2021-01-05 | 上海恒生聚源数据服务有限公司 | Text labeling method, device and equipment and readable storage medium |
| CN112183035B (en) * | 2020-11-06 | 2023-11-21 | 上海恒生聚源数据服务有限公司 | Text labeling method, device, equipment and readable storage medium |
| CN112861496A (en) * | 2021-03-22 | 2021-05-28 | 平安商业保理有限公司 | Report generation display method and device, computer equipment and readable storage medium |
| CN113379221A (en) * | 2021-06-04 | 2021-09-10 | 远光软件股份有限公司 | Data conversion model construction method, financial data processing method and related equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109816503A (en) | Financial details data creation method, device, computer equipment and storage medium | |
| CN110399293B (en) | System test method, device, computer equipment and storage medium | |
| CN109636607A (en) | Business data processing method, device and computer equipment based on model deployment | |
| CN108876133A (en) | Risk assessment processing method, device, server and medium based on business information | |
| US20050080821A1 (en) | System and method for managing collections accounts | |
| CN109858737A (en) | Rating Model method of adjustment, device and computer equipment based on model deployment | |
| CN110363645A (en) | Asset data processing method, device, computer equipment and storage medium | |
| CN112395177A (en) | Interactive processing method, device and equipment of service data and storage medium | |
| CN110503544A (en) | Collage-credit data reports and submits method, apparatus, system, computer equipment and storage medium | |
| CN112053123A (en) | Automatic accounting processing method and device, electronic equipment and readable storage medium | |
| CN109992506A (en) | Scheduling tests method, apparatus, computer equipment and storage medium | |
| CN109583682A (en) | Recognition methods, device and the computer equipment of business finance fraud risk | |
| CN110413507A (en) | System detection method, device, computer equipment and storage medium | |
| CN110458633A (en) | Invoice data generation method, system and computer equipment based on block chain technology | |
| CN109460995A (en) | Financial accreditation method, apparatus, computer equipment and storage medium | |
| CN113570468A (en) | Enterprise payment wind control service platform | |
| CN110008119A (en) | Report test method, device, computer equipment and storage medium | |
| CN109542764A (en) | Webpage automated testing method, device, computer equipment and storage medium | |
| Rosa et al. | Internal auditor transformation strategy in the industrial revolution 4.0 era: Literature review | |
| CN111639916A (en) | Online auditing method, system and readable storage medium based on block chain technology and deep learning | |
| Tømmervåg et al. | Leveraging the competition: Robotic Process Automation (RPA) enabling competitive small and medium sized auditing firms | |
| CN114358903A (en) | RPA-based multi-system accounting checking method and device and computer equipment | |
| CN112419052B (en) | Transaction testing method, device, electronic equipment and readable storage medium | |
| CN109544206A (en) | Business opportunity processing method, device, computer equipment and storage medium | |
| CN115687599A (en) | Service data processing method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20190528 |