WO2020015184A1 - Account statement data management method and apparatus, and computer device and storage medium - Google Patents

Account statement data management method and apparatus, and computer device and storage medium Download PDF

Info

Publication number
WO2020015184A1
WO2020015184A1 PCT/CN2018/108031 CN2018108031W WO2020015184A1 WO 2020015184 A1 WO2020015184 A1 WO 2020015184A1 CN 2018108031 W CN2018108031 W CN 2018108031W WO 2020015184 A1 WO2020015184 A1 WO 2020015184A1
Authority
WO
WIPO (PCT)
Prior art keywords
flow
data
bank
template
pipeline
Prior art date
Application number
PCT/CN2018/108031
Other languages
French (fr)
Chinese (zh)
Inventor
宁之孟
刘建
魏尧东
金明
Original Assignee
平安科技(深圳)有限公司
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 平安科技(深圳)有限公司 filed Critical 平安科技(深圳)有限公司
Publication of WO2020015184A1 publication Critical patent/WO2020015184A1/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/186Templates
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/02Banking, e.g. interest calculation or account maintenance

Definitions

  • the present application relates to the field of computer technology, and in particular, to a method, an apparatus, a computer device, and a storage medium for managing flow data.
  • the main purpose of this application is to provide a method, device, computer equipment and storage medium for management of flow data, which is convenient for business reconciliation and data analysis and comparison of user's bank flow data.
  • this application provides a method for managing flow data, including the following steps:
  • a bank flow template corresponding to the marking information is selected as a target flow template in a database; the database stores a bank flow template corresponding to the marking information in a one-to-one manner;
  • the first flow information carries flow data and identification information
  • the identification information includes at least before the step of the bank name, including:
  • a bank flow template corresponding to the identification information is stored in the database.
  • the step of storing a bank flow template corresponding to the identification information in a database includes:
  • the step of storing a bank flow template corresponding to the identification information in a database includes:
  • the method further includes:
  • the user in the pipeline data is selected as the target pipeline data of the specified user, and the target pipeline data is loaded into the same data table.
  • the method further includes:
  • Configure the viewing authority of the data table and send the configured data table to a user terminal corresponding to the specified user.
  • the method further includes:
  • the consumption amount corresponding to the specified user in each bank is obtained, and the proportion of the consumption amount of the specified user in each bank is calculated.
  • This application also provides a device for managing flow data, including:
  • An obtaining unit configured to obtain first flow information from bank statistics, where the first flow information carries flow data and identification information, and the identification information includes at least a bank name;
  • a selection unit is configured to select a bank flow template corresponding to the mark information as a target flow template in a database according to the mark information; and the database stores a bank flow template corresponding to the mark information in a one-to-one manner. ;
  • the adding unit is configured to correspondingly add the pipeline data carried by the first pipeline information to the target pipeline template.
  • the present application further provides a computer device including a memory and a processor, where the computer-readable instructions are stored in the memory, and when the processor executes the computer-readable instructions, implements the steps of any one of the foregoing methods.
  • the present application further provides a computer non-volatile readable storage medium having computer readable instructions stored thereon, and the computer readable instructions, when executed by a processor, implement the steps of the method described in any one of the above.
  • the method, device, computer equipment, and storage medium for the management of flow data obtain first flow information that is counted by a bank.
  • the first flow information carries flow data and identification information, and the identification information includes at least a bank Name; according to the identification information, a bank flow template corresponding to the identification information is selected as a target flow template in the database; the database stores a bank flow template corresponding to the identification information one to one;
  • the flow data carried in the first flow information is correspondingly added to the target flow template; it is convenient for companies to reconcile and analyze and compare the user's bank flow data.
  • FIG. 1 is a schematic diagram of steps of a method for managing flow data in an embodiment of the present application
  • FIG. 2 is a schematic diagram of steps of a method for managing flow data in another embodiment of the present application.
  • FIG. 3 is a structural block diagram of an apparatus for managing flow data in an embodiment of the present application.
  • FIG. 4 is a structural block diagram of a flow data management device in another embodiment of the present application.
  • FIG. 5 is a schematic block diagram of a computer device according to an embodiment of the present application.
  • this application provides a method for managing flow data, including the following steps:
  • Step S1 Obtain first flow information from bank statistics, where the first flow information carries flow data and identification information, and the identification information includes at least a bank name;
  • step S2 according to the marking information, a bank flow template corresponding to the marking information is selected as a target flow template in the database; the database stores a bank flow template corresponding to the marking information one-to-one;
  • step S3 the pipeline data carried by the first pipeline information is correspondingly added to the target pipeline template.
  • the first flow information includes not only flow data but also identification information.
  • the above-mentioned flow data represents the flow of users, such as the amount of income, the amount of expenditure, and the time of expenditure.
  • the above identification information mainly includes the bank ID and user ID.
  • the bank ID is used to indicate specific bank types, such as Bank of China, China Construction Bank, and Ping An Bank.
  • the user ID is used to indicate the identity of the user, such as Huawei, Tencent, and Ping An Technology. , Individual user Zhang San, etc.
  • the marking information is used to mark the first flow information, and the first flow information is convenient to distinguish the first flow information. For example, according to the bank ID in the identification information, it is easy to distinguish which bank statistics the first stream information is, and the user ID and the bank ID are used to distinguish the bank which company is counted by which bank or Flowing information for individual users.
  • the above method is applied to a flow management platform.
  • the flow management platform (Caiku system) in this embodiment and each bank management system (bank official website) can be pre-configured with docking interfaces and configured to obtain corresponding flow.
  • the access right of the information facilitates the flow management platform to automatically obtain the above-mentioned first flow information of the bank statistics from each bank management system.
  • the above-mentioned first flow information can also be the form data downloaded manually from each bank management system by the user, and then uploaded to the flow management platform in this embodiment, and the flow management platform can obtain the above-mentioned bank statistics.
  • First-line information can also be the form data downloaded manually from each bank management system by the user, and then uploaded to the flow management platform in this embodiment, and the flow management platform can obtain the above-mentioned bank statistics.
  • the database stores a bank flow template corresponding to each of the identification information, that is, each bank flow template stored in the database corresponds to each type of label information; it can be understood that the above
  • the database stores a mapping table of bank flow templates corresponding to the above-mentioned marking information. According to the marking information, a bank flow template corresponding to the marking information can be selected from the mapping table, and then used as the target flow. template.
  • the above target flow template usually includes a title bar, such as an income bar, an expense bar, and a time node bar.
  • different bank ID templates correspond to different bank IDs; in other embodiments, different bank ID templates and different user IDs may correspond to different bank log templates.
  • the number of banks is relatively limited, and the corresponding bank flow templates are also limited for different bank IDs.
  • the number of users is large, and the number of bank flow templates corresponding to banks corresponding to different user IDs is also large.
  • the same bank flow template can be two parts, one of which is the basic template, which includes the same title bar (such as the income bar) in the flow order , Expenditure column, etc.); the other part is the difference template, which includes the title bar with differences in the slip; if you want to modify the above bank flow template, you usually only need to modify the part of the difference template.
  • the flow data of the first flow information is correspondingly added to the target flow template, for example, a specific income amount is added to the income column of the target flow template, and the specific expenditure is added. Amount figures are added to the revenue column of the target pipeline template above.
  • the flow information of different banks can match different bank flow templates, and the first flow information of all banks can be added and unified management, which is convenient for users to analyze data for different banks. Contrast and facilitate business reconciliation.
  • the content layout format of the selected target pipeline template is consistent with the original layout of the first pipeline information. Therefore, when the pipeline data of the first pipeline information is correspondingly added to the target pipeline template, the layout of the pipeline data in the first pipeline information may not be changed, but directly added to the target pipeline template according to the original layout. Saves calculations.
  • the above-mentioned first flow information obtained by the bank is obtained.
  • the first flow information carries flow data and identification information, and the identification information includes at least before step S1 of the bank name, including:
  • step S10 a bank flow template corresponding to the identification information is stored in a database.
  • a plurality of bank flow templates corresponding to the identification information need to be stored in a database in advance, so that the subsequent flow information carried in the first flow information is subsequently obtained after the first flow information counted by the bank is obtained.
  • the data is added to a bank flow template corresponding to the label information on a one-to-one basis.
  • step S10 of storing a bank flow template corresponding to the identification information in the database includes:
  • Step S101 Receive a bank flow template uploaded by a user, store the uploaded bank flow template in the database, and configure a mapping relationship between the bank flow template and the identification information.
  • a user can download a flow template from the websites of various banks and upload it to the flow management platform.
  • the flow management platform receives the bank flow template uploaded by the user and stores it
  • a mapping relationship between the bank flow template and the identification information is configured in the database, so that the corresponding bank flow template is matched according to the label information.
  • the above-mentioned flow template is an EXCEL form, which has a title bar, and below the title bar is a check box for inputting corresponding flow data.
  • step S10 of storing a bank flow template corresponding to the identification information in the database includes:
  • Step S102 obtaining a title bar field of a preset flow template through a preset script program, and generating a corresponding bank flow template based on the title bar field to store in the database, and configuring the bank flow template and the label Information mapping.
  • the flow template is downloaded from the website of each bank, and the title field of the flow template is obtained through a preset script program.
  • the title field is correspondingly written into a blank form according to the typesetting method of the flow template.
  • a flow form is generated to make the flow form consistent with the layout of the flow template, and the flow form is stored in the database as the bank flow template; at the same time, the mapping relationship between the bank flow template and the label information is configured. , Which is convenient to match the corresponding bank flow template according to the marked information.
  • step S3 of adding the flow data carried by the first flow information to the target flow template correspondingly the method further includes:
  • step S4 among all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data is selected as the target pipeline data of the specified user, and the target pipeline data is loaded into the same data table.
  • a user's flow slip is generated; as described in step S4 above, in the flow In the list, all the flow orders of the same specified user are selected according to the user's ID and loaded into the same data table, which is convenient for comparative analysis and calculation of consumption amount; for example, comparative analysis of the user's consumption amount in different banks , Determine which bank the user prefers, etc., and can also calculate the weighting ratio of all consumption amounts using different bank consumption. For example, user A uses 30% of the weight of Bank of China to consume, while Ping An Bank consumes 70% of the weight. Or you can also calculate the amount of consumption, income, etc. that a user spends through each bank in a certain month.
  • the method further includes:
  • step S501 from the flow data in the data table, the consumption amount corresponding to the specified user in each bank is obtained, and the proportion of the consumption amount of the specified user in each bank is calculated.
  • calculating the proportion of the consumption amount of the designated user in each bank is convenient for calculating the weighting proportion of the consumption amount of all users using different banks, and it is convenient to determine which bank the user prefers to use for consumption.
  • the method further includes:
  • step S50 the viewing authority of the data table is configured, and the configured data table is delivered to a user terminal corresponding to the designated user.
  • the above data table is also configured with corresponding viewing authority; for example, the above data table file is encrypted, and the user can view it by entering the password correctly, which can be set in advance in the flow management platform; the user Unable to open the file for viewing when the password was entered incorrectly.
  • the above-configured data form is sent to the user terminal of the designated user, so that the user can understand the amount of consumption in all banks and the financial management of the user.
  • the phone number that the user binds to the bank account can be obtained, and the text content in the data table is extracted to generate text information, and the text information is sent to the user's terminal through a short message. Or you can get the mailbox that the user binds to the bank account, and then send the above data form to the user by mail.
  • an embodiment of the present application further provides a device for managing flow data, including:
  • the obtaining unit 10 is configured to obtain first flow information from bank statistics, where the first flow information carries flow data and identification information, and the identification information includes at least a bank name;
  • a selection unit 20 is configured to select a bank flow template corresponding to the label information as a target flow template in the database according to the label information; the database stores bank flows corresponding to the label information one-to-one template;
  • the adding unit 30 is configured to correspondingly add the pipeline data carried by the first pipeline information to the target pipeline template.
  • the first flow information includes not only flow data but also identification information.
  • the above-mentioned flow data represents the flow of users, such as the amount of income, the amount of expenditure, and the time of expenditure.
  • the above identification information mainly includes the bank ID and user ID.
  • the bank ID is used to indicate specific bank types, such as Bank of China, China Construction Bank, and Ping An Bank.
  • the user ID is used to indicate the identity of the user, such as Huawei, Tencent, and Ping An Technology. , Individual user Zhang San, etc.
  • the marking information is used to mark the first flow information, and the first flow information is convenient to distinguish the first flow information. For example, according to the bank ID in the identification information, it is easy to distinguish which bank statistics the first stream information is, and the user ID and the bank ID are used to distinguish the bank which company is counted by which bank or Flowing information for individual users.
  • the above device is applied to a flow management platform.
  • the flow management platform (Caiku System) in this embodiment and each bank management system (bank official website) can be pre-configured with docking interfaces and configured with the acquisition authority to obtain corresponding flow information, which is convenient
  • the unit 10 automatically obtains the above-mentioned first flow information of the bank statistics from each bank management system.
  • the above-mentioned first flow information can also be the form data downloaded manually from each bank management system by the user, and then uploaded to the flow management platform in this embodiment, and the acquisition unit 10 of the flow management platform can obtain The above-mentioned first flow information of bank statistics.
  • the above database stores a bank flow template corresponding to each of the identification information, that is, each bank flow template stored in the database corresponds to each type of identification information; it can be understood that the above database stores one
  • the bank flow template mapping table corresponding to the label information in a one-to-one manner based on the label information, the selection unit 20 may select a bank flow template corresponding to the label information from the mapping table, and then use it as a target flow template.
  • the above target flow template usually includes a title bar, such as an income bar, an expense bar, and a time node bar.
  • different bank ID templates correspond to different bank IDs; in other embodiments, different bank ID templates and different user IDs may correspond to different bank log templates.
  • the number of banks is relatively limited, and the corresponding bank flow templates are also limited for different bank IDs.
  • the number of users is large, and the number of bank flow templates corresponding to banks corresponding to different user IDs is also large.
  • the same bank flow template can be two parts, one of which is the basic template, which includes the same title bar (such as the income bar) in the flow order , Expenditure column, etc.); the other part is the difference template, which includes the title bar with differences in the slip; if you want to modify the above bank flow template, you usually only need to modify the part of the difference template.
  • the adding unit 30 adds the flow data of the first flow information to the target flow template correspondingly. For example, a specific income amount is added to the income column of the target flow template, and a specific expenditure amount is added. Added to the revenue column of the target pipeline template above.
  • the flow information of different banks can match different bank flow templates, and the first flow information of all banks can be added and unified management, which is convenient for users to analyze data for different banks. Contrast and facilitate business reconciliation.
  • the content layout format of the target pipeline template selected by the selection unit 20 is consistent with the original layout of the first pipeline information. Therefore, when the adding unit 30 adds the flow data of the first flow information to the target flow template correspondingly, it can directly add the flow data in the first flow information to the target flow without changing the layout of the flow data in the first flow information. In the template, the calculation amount is saved.
  • the above-mentioned flow data management device further includes:
  • the storage unit 100 is configured to store a bank flow template corresponding to the identification information in a database.
  • the storage unit 100 needs to store a plurality of bank flow templates corresponding to the identification information in a database in advance, so that it is convenient to obtain the first flow information counted by the bank in the subsequent, and then store the first flow information
  • the flow data carried is added to a bank flow template that corresponds to the label information on a one-to-one basis.
  • the storage unit 100 includes:
  • the first storage subunit is configured to receive a bank flow template uploaded by a user, store the uploaded bank flow template in the database, and configure a mapping relationship between the bank flow template and the identification information.
  • a user can download a flow template from the websites of various banks and upload it to the flow management platform.
  • the first storage subunit receives the bank flow template uploaded by the user, and It is stored in the database, and the mapping relationship between the bank flow template and the marking information is configured, so that the corresponding bank flow template is matched according to the marking information.
  • the above-mentioned flow template is an EXCEL form, which has a title bar, and below the title bar is a check box for inputting corresponding flow data.
  • the storage unit 100 includes:
  • a second storage subunit configured to obtain a title bar field of a preset flow template through a preset script program, generate a corresponding bank flow template according to the title bar field, store the template in the database, and configure the bank flow A mapping relationship between a template and the identification information.
  • the flow template is downloaded from the website of each bank, and the second storage subunit obtains the title field of the flow template through a preset script program, and corresponds the title field to the typesetting method of the flow template.
  • the above-mentioned flow data management device further includes:
  • a loading unit 40 configured to select, from all the pipeline data stored in the target pipeline template of the database, a user in the pipeline data as the target pipeline data of a specified user, and load the target pipeline data to the same data Form.
  • the loading unit 40 selects the same designated user according to the user's ID All the flow orders of the company and load them in the same data table, which is convenient for comparative analysis and calculation of consumption amount; for example, compare and analyze the user's consumption amount in different banks, determine which bank the user prefers, etc. Calculate the weighting ratio of all consumption amounts using different bank consumption. For example, user A uses 30% of the weight of Bank of China to consume, while Ping An Bank consumes 70% of the weight. Or you can also calculate the amount of consumption, income, etc. that a user spends through each bank in a certain month.
  • the apparatus for managing flow data further includes:
  • the calculation unit is configured to obtain the consumption amount corresponding to the specified user in each bank from the running data in the data table, and calculate the proportion of the consumption amount of the specified user in each bank.
  • the calculation unit calculates the proportion of the consumption amount of the designated user in each bank, which is convenient for calculating the weighting proportion of consumption of different users by different banks, and it is convenient to judge which bank the user prefers to use for consumption.
  • the above-mentioned flow data management device further includes:
  • the issuing unit is configured to configure the viewing authority of the data table, and delivers the configured data table to a user terminal corresponding to the designated user.
  • the issuing unit is also configured with corresponding viewing authority for the above data table; for example, the above data table file is encrypted, and the user can enter the password to view the password, which can be set in advance in the flow management platform. ; The user cannot open the file to view when the user enters the wrong password.
  • the above-configured data form is sent to the user terminal of the designated user, so that the user can understand the amount of consumption in all banks and the financial management of the user.
  • the phone number that the user binds to the bank account can be obtained, and the text content in the data table is extracted to generate text information, and the text information is sent to the user's terminal through a short message. Or you can get the mailbox that the user binds to the bank account, and then send the above data form to the user by mail.
  • the management method and device for flow data are used to obtain first flow information of bank statistics.
  • the first flow information carries flow data and label information, and the label information is at least Including a bank name; selecting a bank flow template corresponding to the mark information as a target flow template in a database according to the mark information; and storing a bank flow template corresponding to the mark information in the database;
  • the flow data carried by the first flow information is correspondingly added to the target flow template; it is convenient for business reconciliation and data analysis and comparison of the user's bank flow data.
  • an embodiment of the present application further provides a computer device.
  • the computer device may be a server, and its internal structure may be as shown in FIG.
  • the computer device includes a processor, a memory, a network interface, and a database connected through a system bus.
  • the computer design processor is used to provide computing and control capabilities.
  • the memory of the computer device includes a non-volatile storage medium and an internal memory.
  • the non-volatile storage medium stores an operating system, computer-readable instructions, and a database.
  • the internal memory provides an environment for operating the operating system and computer-readable instructions in a non-volatile storage medium.
  • the database of the computer equipment is used to store data such as bank flow templates.
  • the network interface of the computer device is used to communicate with an external terminal through a network connection.
  • the computer-readable instructions are executed by a processor to implement a method for managing pipeline data.
  • the processor executes the steps of the method for managing pipeline data:
  • a bank flow template corresponding to the marking information is selected as a target flow template in a database; the database stores a bank flow template corresponding to the marking information in a one-to-one manner;
  • the processor obtains first flow information counted by a bank, where the first flow information carries flow data and identification information, and the identification information includes at least before the step of the bank name, including:
  • a bank flow template corresponding to the identification information is stored in the database.
  • the step of the processor storing a bank flow template corresponding to the identification information in a database includes:
  • the step of the processor storing a bank flow template corresponding to the identification information in a database includes:
  • the method includes:
  • the user in the pipeline data is selected as the target pipeline data of the specified user, and the target pipeline data is loaded into the same data table.
  • the processor selects, from all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data as the target pipeline data of the specified user, and loads the target pipeline data Following the steps in the same data sheet include:
  • Configure the viewing authority of the data table and send the configured data table to a user terminal corresponding to the specified user.
  • the processor selects, from all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data as the target pipeline data of the specified user, and loads the target pipeline data Following the steps in the same data sheet include:
  • the consumption amount corresponding to the specified user in each bank is obtained, and the proportion of the consumption amount of the specified user in each bank is calculated.
  • FIG. 5 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer equipment to which the solution of the present application is applied.
  • An embodiment of the present application further provides a computer non-volatile readable storage medium, which stores computer-readable instructions.
  • a method for managing pipelined data is specifically:
  • a bank flow template corresponding to the marking information is selected as a target flow template in a database; the database stores a bank flow template corresponding to the marking information in a one-to-one manner;
  • the processor obtains first flow information counted by a bank, where the first flow information carries flow data and identification information, and the identification information includes at least before the step of the bank name, including:
  • a bank flow template corresponding to the identification information is stored in the database.
  • the step of the processor storing a bank flow template corresponding to the identification information in a database includes:
  • the step of the processor storing a bank flow template corresponding to the identification information in a database includes:
  • the method includes:
  • the user in the pipeline data is selected as the target pipeline data of the specified user, and the target pipeline data is loaded into the same data table.
  • the processor selects, from all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data as the target pipeline data of the specified user, and loads the target pipeline data Following the steps in the same data sheet include:
  • Configure the viewing authority of the data table and send the configured data table to a user terminal corresponding to the specified user.
  • the processor selects, from all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data as the target pipeline data of the specified user, and loads the target pipeline data Following the steps in the same data sheet include:
  • the consumption amount corresponding to the specified user in each bank is obtained, and the proportion of the consumption amount of the specified user in each bank is calculated.
  • the method, device, computer equipment, and storage medium for the management of flow data are used to obtain the first flow information counted by the bank, where the first flow information carries the flow data and the label information.
  • the label information includes at least a bank name; according to the label information, a bank flow template corresponding to the label information is selected as a target flow template in the database; the database stores one by one with the label information A corresponding bank flow template; correspondingly adding the flow data carried by the first flow information to the target flow template; facilitating business reconciliation and data analysis and comparison of the user's bank flow data.
  • Non-volatile memory may include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory.
  • Volatile memory can include random access memory (RAM) or external cache memory.
  • RAM is available in various forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), dual-speed data rate SDRAM (SSRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), etc.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Finance (AREA)
  • General Engineering & Computer Science (AREA)
  • General Health & Medical Sciences (AREA)
  • Computational Linguistics (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Accounting & Taxation (AREA)
  • Economics (AREA)
  • General Business, Economics & Management (AREA)
  • Technology Law (AREA)
  • Strategic Management (AREA)
  • Marketing (AREA)
  • Development Economics (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

An account statement data management method and apparatus, and a computer device and a storage medium. The method comprises: acquiring first account statement information compiled by a bank, wherein the first account statement information carries account statement data and marking information; and adding the first account statement information to a bank account statement template corresponding to the marking information. Reconciliation in enterprises and analysis and comparison of bank account statement data of a user are thus facilitated.

Description

流水数据的管理方法、装置、计算机设备和存储介质Management method, device, computer equipment and storage medium for flow data
本申请要求于2018年7月19日提交中国专利局、申请号为2018107983914,发明名称为“流水数据的管理方法、装置、计算机设备和存储介质”的中国专利申请的优先权,其全部内容通过引用结合在本申请中。This application claims the priority of a Chinese patent application filed on July 19, 2018 with the Chinese Patent Office, application number 2018107983914, and the invention name "Management Method, Device, Computer Equipment, and Storage Medium for Flowing Data". Citations are incorporated in this application.
技术领域Technical field
本申请涉及计算机技术领域,特别涉及一种流水数据的管理方法、装置、计算机设备和存储介质。The present application relates to the field of computer technology, and in particular, to a method, an apparatus, a computer device, and a storage medium for managing flow data.
背景技术Background technique
通常对于不同的银行,其使用的银行流水模板也不相同,且针对不同的企业,银行所使用的银行流水模板也不相同。目前市面上没有统一管理不同银行流水模板的工具,不能支持多家银行的流水导入和配置,对于不同的用户的流水数据不便于使用不同的银行流水模板,不方便用户针对不同的银行进行数据分析对比和企业对账。Generally, different banks use different bank flow templates, and different banks use different bank flow templates. At present, there is no tool for unified management of different bank flow templates on the market, and it cannot support the flow import and configuration of multiple banks. It is not convenient to use different bank flow templates for the flow data of different users, and it is not convenient for users to analyze data for different banks. Contrast and corporate reconciliation.
技术问题technical problem
本申请的主要目的为提供一种流水数据的管理方法、装置、计算机设备和存储介质,便于企业对账以及对用户的银行流水数据进行数据分析对比。The main purpose of this application is to provide a method, device, computer equipment and storage medium for management of flow data, which is convenient for business reconciliation and data analysis and comparison of user's bank flow data.
技术解决方案Technical solutions
为实现上述目的,本申请提供了一种流水数据的管理方法,包括以下步骤:In order to achieve the above object, this application provides a method for managing flow data, including the following steps:
获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及对标示信息,所述标示信息至少包括银行名称;Acquiring first flow information from bank statistics, where the first flow information carries flow data and identification information, and the identification information includes at least a bank name;
根据所述标示信息,在数据库中选择出与所述标示信息相对应的银行流水模板作为目标流水模板;所述数据库中存储有与所述标示信息一一对应的银行流水模板;According to the marking information, a bank flow template corresponding to the marking information is selected as a target flow template in a database; the database stores a bank flow template corresponding to the marking information in a one-to-one manner;
将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中。Correspondingly add the pipeline data carried by the first pipeline information to the target pipeline template.
进一步地,所述获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及标示信息,所述标示信息至少包括银行名称的步骤之前,包括:Further, obtaining the first flow information from the bank statistics, the first flow information carries flow data and identification information, and the identification information includes at least before the step of the bank name, including:
在数据库中存储与所述标示信息一一对应的银行流水模板。A bank flow template corresponding to the identification information is stored in the database.
进一步地,所述在数据库中存储与所述标示信息一一对应的银行流水模板的步骤,包括:Further, the step of storing a bank flow template corresponding to the identification information in a database includes:
接收用户上传的银行流水模板,将所述上传的银行流水模板存储于所述数据库中,并配置所述银行流水模板与所述标示信息的映射关系。Receiving a bank flow template uploaded by a user, storing the uploaded bank flow template in the database, and configuring a mapping relationship between the bank flow template and the identification information.
进一步地,所述在数据库中存储与所述标示信息一一对应的银行流水模板的步骤,包括:Further, the step of storing a bank flow template corresponding to the identification information in a database includes:
通过预设的脚本程序获取预设流水模板的标题栏字段,并根据所述标题栏字段生成对应的银行流水模板存储于所述数据库中,以及配置所述银行流水模板与所述标示信息的映射关系。Obtain a title bar field of a preset flow template through a preset script program, and generate a corresponding bank flow template based on the title bar field to store in the database, and configure a mapping between the bank flow template and the identification information relationship.
进一步地,所述将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中的步骤之后,所述方法还包括:Further, after the step of correspondingly adding the flow data carried by the first flow information to the target flow template, the method further includes:
在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中。Among all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data is selected as the target pipeline data of the specified user, and the target pipeline data is loaded into the same data table.
进一步地,所述在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中的步骤之后,所述方法还包括:Further, in all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data is selected as the target pipeline data of the specified user, and the target pipeline data is loaded into the same data table After the steps in the method, the method further includes:
配置所述数据表格的查看权限,并将配置后的所述数据表格下发至所述指定用户所对应的用户终端。Configure the viewing authority of the data table, and send the configured data table to a user terminal corresponding to the specified user.
进一步地,所述在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中的步骤之后,所述方法还包括:Further, in all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data is selected as the target pipeline data of the specified user, and the target pipeline data is loaded into the same data table After the steps in the method, the method further includes:
从所述数据表格中的流水数据中,获取指定用户对应在各个银行的消费金额,并计算指定用户在各个银行的消费金额比例。From the flow data in the data table, the consumption amount corresponding to the specified user in each bank is obtained, and the proportion of the consumption amount of the specified user in each bank is calculated.
本申请还提供了一种流水数据的管理装置,包括:This application also provides a device for managing flow data, including:
获取单元,用于获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及标示信息,所述标示信息至少包括银行名称;An obtaining unit, configured to obtain first flow information from bank statistics, where the first flow information carries flow data and identification information, and the identification information includes at least a bank name;
选择单元,用于根据所述标示信息,在数据库中选择出与所述标示信息相对应的银行流水模板作为目标流水模板;所述数据库中存储有与所述标示信息一一对应的银行流水模板;A selection unit is configured to select a bank flow template corresponding to the mark information as a target flow template in a database according to the mark information; and the database stores a bank flow template corresponding to the mark information in a one-to-one manner. ;
添加单元,用于将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中。The adding unit is configured to correspondingly add the pipeline data carried by the first pipeline information to the target pipeline template.
本申请还提供一种计算机设备,包括存储器和处理器,所述存储器中存储有计算机可读指令,所述处理器执行所述计算机可读指令时实现上述任一项所述方法的步骤。The present application further provides a computer device including a memory and a processor, where the computer-readable instructions are stored in the memory, and when the processor executes the computer-readable instructions, implements the steps of any one of the foregoing methods.
本申请还提供一种计算机非易失性可读存储介质,其上存储有计算机可读指令,所述计算机可读指令被处理器执行时实现上述任一项所述的方法的步骤。The present application further provides a computer non-volatile readable storage medium having computer readable instructions stored thereon, and the computer readable instructions, when executed by a processor, implement the steps of the method described in any one of the above.
有益效果Beneficial effect
本申请中提供的流水数据的管理方法、装置、计算机设备和存储介质,获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及标示信息,所述标示信息至少包括银行名称;根据所述标示信息,在数据库中选择出与所述标示信息相对应的银行流水模板作为目标流水模板;所述数据库中存储有与所述标示信息一一对应的银行流水模板;将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中;便于企业对账以及对用户的银行流水数据进行数据分析对比。The method, device, computer equipment, and storage medium for the management of flow data provided in this application, obtain first flow information that is counted by a bank. The first flow information carries flow data and identification information, and the identification information includes at least a bank Name; according to the identification information, a bank flow template corresponding to the identification information is selected as a target flow template in the database; the database stores a bank flow template corresponding to the identification information one to one; The flow data carried in the first flow information is correspondingly added to the target flow template; it is convenient for companies to reconcile and analyze and compare the user's bank flow data.
附图说明BRIEF DESCRIPTION OF THE DRAWINGS
图1 是本申请一实施例中流水数据的管理方法步骤示意图;FIG. 1 is a schematic diagram of steps of a method for managing flow data in an embodiment of the present application; FIG.
图2 是本申请另一实施例中流水数据的管理方法步骤示意图;2 is a schematic diagram of steps of a method for managing flow data in another embodiment of the present application;
图3 是本申请一实施例中流水数据的管理装置结构框图;3 is a structural block diagram of an apparatus for managing flow data in an embodiment of the present application;
图4 是本申请另一实施例中流水数据的管理装置结构框图;4 is a structural block diagram of a flow data management device in another embodiment of the present application;
图5 是本申请一实施例的计算机设备的结构示意框图。FIG. 5 is a schematic block diagram of a computer device according to an embodiment of the present application.
本发明的最佳实施方式Best Mode of the Invention
参照图1,本申请提供了一种流水数据的管理方法,包括以下步骤:Referring to FIG. 1, this application provides a method for managing flow data, including the following steps:
步骤S1,获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及标示信息,所述标示信息至少包括银行名称;Step S1: Obtain first flow information from bank statistics, where the first flow information carries flow data and identification information, and the identification information includes at least a bank name;
步骤S2,根据所述标示信息,在数据库中选择出与所述标示信息相对应的银行流水模板作为目标流水模板;所述数据库中存储有与所述标示信息一一对应的银行流水模板;In step S2, according to the marking information, a bank flow template corresponding to the marking information is selected as a target flow template in the database; the database stores a bank flow template corresponding to the marking information one-to-one;
步骤S3,将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中。In step S3, the pipeline data carried by the first pipeline information is correspondingly added to the target pipeline template.
在本实施例中,上述第一流水信息中不仅仅包括有流水数据,还包括有标示信息。上述流水数据表示的是用户的流水,例如收入多少金额、支出多少金额,支出时间等多种数据。上述标示信息主要包括银行ID、用户ID,银行ID用于表示具体的银行类别,如中国银行、中国建设银行、平安银行等;用户ID则用于表示用户的身份,例如华为、腾讯、平安科技、个人用户张三等。上述标示信息用于标示上述第一流水信息,通过上述标示信息便于对第一流水信息进行区分。例如,根据标示信息中的银行ID,便于区分出上述第一流水信息是哪家银行统计的流水信息,根据用户ID以及银行ID便于区分出上述第一流水信息是哪家银行统计的哪个企业或者个人用户的流水信息等。In this embodiment, the first flow information includes not only flow data but also identification information. The above-mentioned flow data represents the flow of users, such as the amount of income, the amount of expenditure, and the time of expenditure. The above identification information mainly includes the bank ID and user ID. The bank ID is used to indicate specific bank types, such as Bank of China, China Construction Bank, and Ping An Bank. The user ID is used to indicate the identity of the user, such as Huawei, Tencent, and Ping An Technology. , Individual user Zhang San, etc. The marking information is used to mark the first flow information, and the first flow information is convenient to distinguish the first flow information. For example, according to the bank ID in the identification information, it is easy to distinguish which bank statistics the first stream information is, and the user ID and the bank ID are used to distinguish the bank which company is counted by which bank or Flowing information for individual users.
不同企业或者不同个人用户,其对应的流水信息不尽相同,因此,其对应的银行流水模板也具有差异性;例如,同一家银行针对华为、腾讯两家企业所使用的银行流水模板可以不同(可以是大体相同,但具有小的差异性),不同银行针对华为一家企业所使用的银行流水模板也不同。因此,结合银行ID、以及用户ID的不同,便可以对应不同的银行流水模板。Different companies or individual users have different corresponding flow information. Therefore, their corresponding bank flow templates are also different. For example, the same bank may use different flow templates for Huawei and Tencent ( It can be roughly the same, but with small differences), and different banks use different bank flow templates for a Huawei enterprise. Therefore, combining different bank IDs and user IDs can correspond to different bank flow templates.
上述方法应用于流水管理平台,如上述步骤S1所述,本实施例中的流水管理平台(财酷系统)与各个银行管理系统(银行官网)可以预先配置有对接接口,并配置有获取对应流水信息的获取权限,便于流水管理平台从各个银行管理系统上自动获取到银行统计的上述第一流水信息。可以理解的是,上述第一流水信息也可以是用户手动从各个银行管理系统上下载下来的表格数据,然后上传至本实施例中的流水管理平台,流水管理平台便可以获取到银行统计的上述第一流水信息。The above method is applied to a flow management platform. As described in step S1 above, the flow management platform (Caiku system) in this embodiment and each bank management system (bank official website) can be pre-configured with docking interfaces and configured to obtain corresponding flow. The access right of the information facilitates the flow management platform to automatically obtain the above-mentioned first flow information of the bank statistics from each bank management system. It can be understood that the above-mentioned first flow information can also be the form data downloaded manually from each bank management system by the user, and then uploaded to the flow management platform in this embodiment, and the flow management platform can obtain the above-mentioned bank statistics. First-line information.
如上述步骤S2所述,上述数据库中存储有与每个所述标示信息相对应的银行流水模板,即数据库中存储的每一个银行流水模板对应于每一种标示信息;可以理解的是,上述数据库中存储有一个与上述标示信息一一对应的银行流水模板映射表,根据上述标示信息,则可以从上述映射表中选择出与上述标示信息所对应的银行流水模板,然后将其作为目标流水模板。上述目标流水模板中通常包括一个标题栏,例如收入栏、支出栏、时间节点栏等。As described in step S2 above, the database stores a bank flow template corresponding to each of the identification information, that is, each bank flow template stored in the database corresponds to each type of label information; it can be understood that the above The database stores a mapping table of bank flow templates corresponding to the above-mentioned marking information. According to the marking information, a bank flow template corresponding to the marking information can be selected from the mapping table, and then used as the target flow. template. The above target flow template usually includes a title bar, such as an income bar, an expense bar, and a time node bar.
本实施例中,按照银行ID的不同,对应于不同的银行流水模板;其它实施例中,也可以是按照银行ID的不同以及用户的不同,对应于不同的银行流水模板。通常,银行的数量较为有限,不同银行ID,对应的银行流水模板也较为有限;而用户的数量较多,不同用户ID对应的银行所对应的银行流水模板数量也较多,但是,同一家银行针对不同ID的用户所使用的模板大致相同,只是具有一些小的差异,因此上述银行流水模板可以是两部分,其中一部分是基础模板,该基础模板包括流水单中相同的标题栏(例如收入栏、支出栏等);另一部分为差异模板,其包括的是流水单中具有差异性的标题栏;若要修改上述银行流水模板,通常只需要修改差异模板那一部分。In this embodiment, different bank ID templates correspond to different bank IDs; in other embodiments, different bank ID templates and different user IDs may correspond to different bank log templates. Generally, the number of banks is relatively limited, and the corresponding bank flow templates are also limited for different bank IDs. The number of users is large, and the number of bank flow templates corresponding to banks corresponding to different user IDs is also large. However, the same bank The templates used for users with different IDs are roughly the same, but with some small differences, so the above bank flow template can be two parts, one of which is the basic template, which includes the same title bar (such as the income bar) in the flow order , Expenditure column, etc.); the other part is the difference template, which includes the title bar with differences in the slip; if you want to modify the above bank flow template, you usually only need to modify the part of the difference template.
如上述步骤S3所述,将上述第一流水信息的流水数据对应添加至所述目标流水模板中,例如,将具体的收入金额数字添加至所述目标流水模板的收入栏中,将具体的支出金额数字添加至上述目标流水模板的收入栏中。在本实施例中的流水管理平台中,不同银行的流水信息可以匹配不同的银行流水模板,可以实现添加所有银行统计的第一流水信息,并进行统一管理,方便用户针对不同的银行进行数据分析对比,以及便于企业对账。As described in step S3 above, the flow data of the first flow information is correspondingly added to the target flow template, for example, a specific income amount is added to the income column of the target flow template, and the specific expenditure is added. Amount figures are added to the revenue column of the target pipeline template above. In the flow management platform in this embodiment, the flow information of different banks can match different bank flow templates, and the first flow information of all banks can be added and unified management, which is convenient for users to analyze data for different banks. Contrast and facilitate business reconciliation.
在本实施例中,当上述目标流水模板与上述标示信息对应时,上述选择出的目标流水模板的内容排版格式则与上述第一流水信息的原有排版一致。因此,将上述第一流水信息的流水数据对应添加至上述目标流水模板中时,则可以不改变第一流水信息中的流水数据的排版,而直接按原有排版添加至上述目标流水模板中,节省了计算量。In this embodiment, when the target pipeline template corresponds to the marking information, the content layout format of the selected target pipeline template is consistent with the original layout of the first pipeline information. Therefore, when the pipeline data of the first pipeline information is correspondingly added to the target pipeline template, the layout of the pipeline data in the first pipeline information may not be changed, but directly added to the target pipeline template according to the original layout. Saves calculations.
参照图2,在一实施例中,上述获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及标示信息,所述标示信息至少包括银行名称的步骤S1之前,包括:Referring to FIG. 2, in an embodiment, the above-mentioned first flow information obtained by the bank is obtained. The first flow information carries flow data and identification information, and the identification information includes at least before step S1 of the bank name, including:
步骤S10,在数据库中存储与所述标示信息一一对应的银行流水模板。In step S10, a bank flow template corresponding to the identification information is stored in a database.
在本实施例中,预先需要在数据库中存储有多个与所述标示信息一一对应的银行流水模板,便于后续获取到银行统计的第一流水信息之后,将第一流水信息中携带的流水数据添加至与所述标示信息一一对应的银行流水模板中。In this embodiment, a plurality of bank flow templates corresponding to the identification information need to be stored in a database in advance, so that the subsequent flow information carried in the first flow information is subsequently obtained after the first flow information counted by the bank is obtained. The data is added to a bank flow template corresponding to the label information on a one-to-one basis.
在一实施例中,上述在数据库中存储与所述标示信息一一对应的银行流水模板的步骤S10,包括:In an embodiment, the above-mentioned step S10 of storing a bank flow template corresponding to the identification information in the database includes:
步骤S101,接收用户上传的银行流水模板,将所述上传的银行流水模板存储于所述数据库中,并配置所述银行流水模板与所述标示信息的映射关系。Step S101: Receive a bank flow template uploaded by a user, store the uploaded bank flow template in the database, and configure a mapping relationship between the bank flow template and the identification information.
具体地,用户(可以是流水管理平台的管理员)可以从各个银行的网站上下载流水模板,并将其上传至流水管理平台,流水管理平台接收到用户上传的银行流水模板,并将其存储于所述数据库中,以及配置所述银行流水模板与所述标示信息的映射关系,便于根据标示信息匹配对应的银行流水模板。上述流水模板为一EXCEL表格,该表格具有标题栏,标题栏下方为输入对应流水数据的选框。Specifically, a user (may be an administrator of the flow management platform) can download a flow template from the websites of various banks and upload it to the flow management platform. The flow management platform receives the bank flow template uploaded by the user and stores it A mapping relationship between the bank flow template and the identification information is configured in the database, so that the corresponding bank flow template is matched according to the label information. The above-mentioned flow template is an EXCEL form, which has a title bar, and below the title bar is a check box for inputting corresponding flow data.
在另一实施例中,上述在数据库中存储与所述标示信息一一对应的银行流水模板的步骤S10,包括:In another embodiment, the above-mentioned step S10 of storing a bank flow template corresponding to the identification information in the database includes:
步骤S102,通过预设的脚本程序获取预设流水模板的标题栏字段,并根据所述标题栏字段生成对应的银行流水模板存储于所述数据库中,以及配置所述银行流水模板与所述标示信息的映射关系。Step S102, obtaining a title bar field of a preset flow template through a preset script program, and generating a corresponding bank flow template based on the title bar field to store in the database, and configuring the bank flow template and the label Information mapping.
在本实施例中,从各个银行的网站上下载流水模板,通过预设的脚本程序获取到流水模板的标题栏字段,并将上述标题栏字段按照上述流水模板的排版方式对应写入一个空白表格中,生成一个流水表格,使得该流水表格与上述流水模板的排版一致,该流水表格则作为上述银行流水模板存储于上述数据库中;同时,配置所述银行流水模板与所述标示信息的映射关系,便于根据标示信息匹配对应的银行流水模板。In this embodiment, the flow template is downloaded from the website of each bank, and the title field of the flow template is obtained through a preset script program. The title field is correspondingly written into a blank form according to the typesetting method of the flow template. In the process, a flow form is generated to make the flow form consistent with the layout of the flow template, and the flow form is stored in the database as the bank flow template; at the same time, the mapping relationship between the bank flow template and the label information is configured. , Which is convenient to match the corresponding bank flow template according to the marked information.
在一实施例中,上述将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中的步骤S3之后,所述方法还包括:In an embodiment, after step S3 of adding the flow data carried by the first flow information to the target flow template correspondingly, the method further includes:
步骤S4,在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中。In step S4, among all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data is selected as the target pipeline data of the specified user, and the target pipeline data is loaded into the same data table.
由于同一用户,其可能在多个银行具有账户,且在每个银行的流水数据不同。本实施例中,从银行获取到统计的第一流水信息,并将流水数据分别对应添加至所述目标流水模板中之后,生成用户的流水单;则如上述步骤S4所述的,在上述流水单中,根据用户的ID选择出同一指定用户的所有流水单,并将其加载在同一个数据表格中,便于进行对比分析、计算消费金额等;例如对比分析出该用户在不同银行的消费金额,判断用户偏好哪家银行等,同时还可以计算出所有消费金额中使用不同银行消费的权重比例。例如,用户甲使用中国银行消费的权重比例为30%,而使用平安银行消费的权重比例为70%等。或者还可以统计出用户某一个月份在通过各个银行的消费金额、收入金额等。Due to the same user, they may have accounts in multiple banks, and the flow data in each bank is different. In this embodiment, after obtaining the first statistical flow information from the bank and adding the flow data to the target flow template respectively, a user's flow slip is generated; as described in step S4 above, in the flow In the list, all the flow orders of the same specified user are selected according to the user's ID and loaded into the same data table, which is convenient for comparative analysis and calculation of consumption amount; for example, comparative analysis of the user's consumption amount in different banks , Determine which bank the user prefers, etc., and can also calculate the weighting ratio of all consumption amounts using different bank consumption. For example, user A uses 30% of the weight of Bank of China to consume, while Ping An Bank consumes 70% of the weight. Or you can also calculate the amount of consumption, income, etc. that a user spends through each bank in a certain month.
因此,在另一实施例中,上述在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中的步骤S4之后,所述方法还包括:Therefore, in another embodiment, among all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data is selected as the target pipeline data of the specified user, and the target pipeline data is After loading step S4 in the same data table, the method further includes:
步骤S501,从所述数据表格中的流水数据中,获取指定用户对应在各个银行的消费金额,并计算指定用户在各个银行的消费金额比例。In step S501, from the flow data in the data table, the consumption amount corresponding to the specified user in each bank is obtained, and the proportion of the consumption amount of the specified user in each bank is calculated.
本实施例中,计算指定用户在各个银行的消费金额比例,便于计算出所用户有消费金额中使用不同银行消费的权重比例,便于判断用户偏好使用哪家银行进行消费。In this embodiment, calculating the proportion of the consumption amount of the designated user in each bank is convenient for calculating the weighting proportion of the consumption amount of all users using different banks, and it is convenient to determine which bank the user prefers to use for consumption.
在一实施例中,上述在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中的步骤S4之后,所述方法还包括:In an embodiment, among all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data is selected as the target pipeline data of the specified user, and the target pipeline data is loaded to the same After step S4 in the data table, the method further includes:
步骤S50,配置所述数据表格的查看权限,并将配置后的所述数据表格下发至所述指定用户所对应的用户终端。In step S50, the viewing authority of the data table is configured, and the configured data table is delivered to a user terminal corresponding to the designated user.
本实施例中,对上述数据表格还配置有相应的查看权限;例如,对上述数据表格文件进行加密,用户正确输入密码才可以查看,该密码可以是预先在流水管理平台所设定的;用户输入密码错误时无法打开文件查看。将上述配置完的数据表格下发至指定用户的用户终端,便于用户了解自己在所有银行的消费金额,便于用户的财务管理。本实施例中,可以获取到用户与银行账户进行绑定的电话号码,并提取上述数据表格中的文本内容,生成文本信息,通过短消息的方式将上述文本信息发送至用户的终端。或者可以获取到用户与银行账户进行绑定的邮箱,然后,将上述数据表格通过邮件的形式发送给用户。In this embodiment, the above data table is also configured with corresponding viewing authority; for example, the above data table file is encrypted, and the user can view it by entering the password correctly, which can be set in advance in the flow management platform; the user Unable to open the file for viewing when the password was entered incorrectly. The above-configured data form is sent to the user terminal of the designated user, so that the user can understand the amount of consumption in all banks and the financial management of the user. In this embodiment, the phone number that the user binds to the bank account can be obtained, and the text content in the data table is extracted to generate text information, and the text information is sent to the user's terminal through a short message. Or you can get the mailbox that the user binds to the bank account, and then send the above data form to the user by mail.
参照图3,本申请一实施例中还提供了一种流水数据的管理装置,包括:Referring to FIG. 3, an embodiment of the present application further provides a device for managing flow data, including:
获取单元10,用于获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及标示信息,所述标示信息至少包括银行名称;The obtaining unit 10 is configured to obtain first flow information from bank statistics, where the first flow information carries flow data and identification information, and the identification information includes at least a bank name;
选择单元20,用于根据所述标示信息,在数据库中选择出与所述标示信息相对应的银行流水模板作为目标流水模板;所述数据库中存储有与所述标示信息一一对应的银行流水模板;A selection unit 20 is configured to select a bank flow template corresponding to the label information as a target flow template in the database according to the label information; the database stores bank flows corresponding to the label information one-to-one template;
添加单元30,用于将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中。The adding unit 30 is configured to correspondingly add the pipeline data carried by the first pipeline information to the target pipeline template.
在本实施例中,上述第一流水信息中不仅仅包括有流水数据,还包括有标示信息。上述流水数据表示的是用户的流水,例如收入多少金额、支出多少金额,支出时间等多种数据。上述标示信息主要包括银行ID、用户ID,银行ID用于表示具体的银行类别,如中国银行、中国建设银行、平安银行等;用户ID则用于表示用户的身份,例如华为、腾讯、平安科技、个人用户张三等。上述标示信息用于标示上述第一流水信息,通过上述标示信息便于对第一流水信息进行区分。例如,根据标示信息中的银行ID,便于区分出上述第一流水信息是哪家银行统计的流水信息,根据用户ID以及银行ID便于区分出上述第一流水信息是哪家银行统计的哪个企业或者个人用户的流水信息等。In this embodiment, the first flow information includes not only flow data but also identification information. The above-mentioned flow data represents the flow of users, such as the amount of income, the amount of expenditure, and the time of expenditure. The above identification information mainly includes the bank ID and user ID. The bank ID is used to indicate specific bank types, such as Bank of China, China Construction Bank, and Ping An Bank. The user ID is used to indicate the identity of the user, such as Huawei, Tencent, and Ping An Technology. , Individual user Zhang San, etc. The marking information is used to mark the first flow information, and the first flow information is convenient to distinguish the first flow information. For example, according to the bank ID in the identification information, it is easy to distinguish which bank statistics the first stream information is, and the user ID and the bank ID are used to distinguish the bank which company is counted by which bank or Flowing information for individual users.
不同企业或者不同个人用户,其对应的流水信息不尽相同,因此,其对应的银行流水模板也具有差异性;例如,同一家银行针对华为、腾讯两家企业所使用的银行流水模板可以不同(可以是大体相同,但具有小的差异性),不同银行针对华为一家企业所使用的银行流水模板也不同。因此,结合银行ID、以及用户ID的不同,便可以对应不同的银行流水模板。Different companies or individual users have different corresponding flow information. Therefore, their corresponding bank flow templates are also different. For example, the same bank may use different flow templates for Huawei and Tencent ( It can be roughly the same, but with small differences), and different banks use different bank flow templates for a Huawei enterprise. Therefore, combining different bank IDs and user IDs can correspond to different bank flow templates.
上述装置应用于流水管理平台,本实施例中的流水管理平台(财酷系统)与各个银行管理系统(银行官网)可以预先配置有对接接口,并配置有获取对应流水信息的获取权限,便于获取单元10从各个银行管理系统上自动获取到银行统计的上述第一流水信息。可以理解的是,上述第一流水信息也可以是用户手动从各个银行管理系统上下载下来的表格数据,然后上传至本实施例中的流水管理平台,流水管理平台的获取单元10便可以获取到银行统计的上述第一流水信息。The above device is applied to a flow management platform. The flow management platform (Caiku System) in this embodiment and each bank management system (bank official website) can be pre-configured with docking interfaces and configured with the acquisition authority to obtain corresponding flow information, which is convenient The unit 10 automatically obtains the above-mentioned first flow information of the bank statistics from each bank management system. It can be understood that the above-mentioned first flow information can also be the form data downloaded manually from each bank management system by the user, and then uploaded to the flow management platform in this embodiment, and the acquisition unit 10 of the flow management platform can obtain The above-mentioned first flow information of bank statistics.
上述数据库中存储有与每个所述标示信息相对应的银行流水模板,即数据库中存储的每一个银行流水模板对应于每一种标示信息;可以理解的是,上述数据库中存储有一个与上述标示信息一一对应的银行流水模板映射表,选择单元20根据上述标示信息,则可以从上述映射表中选择出与上述标示信息所对应的银行流水模板,然后将其作为目标流水模板。上述目标流水模板中通常包括一个标题栏,例如收入栏、支出栏、时间节点栏等。The above database stores a bank flow template corresponding to each of the identification information, that is, each bank flow template stored in the database corresponds to each type of identification information; it can be understood that the above database stores one The bank flow template mapping table corresponding to the label information in a one-to-one manner, based on the label information, the selection unit 20 may select a bank flow template corresponding to the label information from the mapping table, and then use it as a target flow template. The above target flow template usually includes a title bar, such as an income bar, an expense bar, and a time node bar.
本实施例中,按照银行ID的不同,对应于不同的银行流水模板;其它实施例中,也可以是按照银行ID的不同以及用户的不同,对应于不同的银行流水模板。通常,银行的数量较为有限,不同银行ID,对应的银行流水模板也较为有限;而用户的数量较多,不同用户ID对应的银行所对应的银行流水模板数量也较多,但是,同一家银行针对不同ID的用户所使用的模板大致相同,只是具有一些小的差异,因此上述银行流水模板可以是两部分,其中一部分是基础模板,该基础模板包括流水单中相同的标题栏(例如收入栏、支出栏等);另一部分为差异模板,其包括的是流水单中具有差异性的标题栏;若要修改上述银行流水模板,通常只需要修改差异模板那一部分。In this embodiment, different bank ID templates correspond to different bank IDs; in other embodiments, different bank ID templates and different user IDs may correspond to different bank log templates. Generally, the number of banks is relatively limited, and the corresponding bank flow templates are also limited for different bank IDs. The number of users is large, and the number of bank flow templates corresponding to banks corresponding to different user IDs is also large. However, the same bank The templates used for users with different IDs are roughly the same, but with some small differences, so the above bank flow template can be two parts, one of which is the basic template, which includes the same title bar (such as the income bar) in the flow order , Expenditure column, etc.); the other part is the difference template, which includes the title bar with differences in the slip; if you want to modify the above bank flow template, you usually only need to modify the part of the difference template.
最后,添加单元30将上述第一流水信息的流水数据对应添加至所述目标流水模板中,例如,将具体的收入金额数字添加至所述目标流水模板的收入栏中,将具体的支出金额数字添加至上述目标流水模板的收入栏中。在本实施例中的流水管理平台中,不同银行的流水信息可以匹配不同的银行流水模板,可以实现添加所有银行统计的第一流水信息,并进行统一管理,方便用户针对不同的银行进行数据分析对比,以及便于企业对账。Finally, the adding unit 30 adds the flow data of the first flow information to the target flow template correspondingly. For example, a specific income amount is added to the income column of the target flow template, and a specific expenditure amount is added. Added to the revenue column of the target pipeline template above. In the flow management platform in this embodiment, the flow information of different banks can match different bank flow templates, and the first flow information of all banks can be added and unified management, which is convenient for users to analyze data for different banks. Contrast and facilitate business reconciliation.
在本实施例中,当上述目标流水模板与上述标示信息对应时,上述选择单元20选择出的目标流水模板的内容排版格式则与上述第一流水信息的原有排版一致。因此,添加单元30将上述第一流水信息的流水数据对应添加至上述目标流水模板中时,则可以不改变第一流水信息中的流水数据的排版,而直接按原有排版添加至上述目标流水模板中,节省了计算量。In this embodiment, when the target pipeline template corresponds to the label information, the content layout format of the target pipeline template selected by the selection unit 20 is consistent with the original layout of the first pipeline information. Therefore, when the adding unit 30 adds the flow data of the first flow information to the target flow template correspondingly, it can directly add the flow data in the first flow information to the target flow without changing the layout of the flow data in the first flow information. In the template, the calculation amount is saved.
参照图4,在一实施例中,上述流水数据的管理装置还包括:Referring to FIG. 4, in an embodiment, the above-mentioned flow data management device further includes:
存储单元100,用于在数据库中存储与所述标示信息一一对应的银行流水模板。The storage unit 100 is configured to store a bank flow template corresponding to the identification information in a database.
在本实施例中,存储单元100预先需要在数据库中存储有多个与所述标示信息一一对应的银行流水模板,便于后续获取到银行统计的第一流水信息之后,将第一流水信息中携带的流水数据添加至与所述标示信息一一对应的银行流水模板中。In this embodiment, the storage unit 100 needs to store a plurality of bank flow templates corresponding to the identification information in a database in advance, so that it is convenient to obtain the first flow information counted by the bank in the subsequent, and then store the first flow information The flow data carried is added to a bank flow template that corresponds to the label information on a one-to-one basis.
在一实施例中,上述存储单元100包括:In an embodiment, the storage unit 100 includes:
第一存储子单元,用于接收用户上传的银行流水模板,将上传的银行流水模板存储于所述数据库中,并配置所述银行流水模板与所述标示信息的映射关系。The first storage subunit is configured to receive a bank flow template uploaded by a user, store the uploaded bank flow template in the database, and configure a mapping relationship between the bank flow template and the identification information.
具体地,用户(可以是流水管理平台的管理员)可以从各个银行的网站上下载流水模板,并将其上传至流水管理平台,第一存储子单元接收到用户上传的银行流水模板,并将其存储于所述数据库中,以及配置所述银行流水模板与所述标示信息的映射关系,便于根据标示信息匹配对应的银行流水模板。上述流水模板为一EXCEL表格,该表格具有标题栏,标题栏下方为输入对应流水数据的选框。Specifically, a user (may be an administrator of the flow management platform) can download a flow template from the websites of various banks and upload it to the flow management platform. The first storage subunit receives the bank flow template uploaded by the user, and It is stored in the database, and the mapping relationship between the bank flow template and the marking information is configured, so that the corresponding bank flow template is matched according to the marking information. The above-mentioned flow template is an EXCEL form, which has a title bar, and below the title bar is a check box for inputting corresponding flow data.
在另一实施例中,上述存储单元100包括:In another embodiment, the storage unit 100 includes:
第二存储子单元,用于通过预设的脚本程序获取预设流水模板的标题栏字段,并根据所述标题栏字段生成对应的银行流水模板存储于所述数据库中,以及配置所述银行流水模板与所述标示信息的映射关系。A second storage subunit, configured to obtain a title bar field of a preset flow template through a preset script program, generate a corresponding bank flow template according to the title bar field, store the template in the database, and configure the bank flow A mapping relationship between a template and the identification information.
在本实施例中,从各个银行的网站上下载流水模板,第二存储子单元通过预设的脚本程序获取到流水模板的标题栏字段,并将上述标题栏字段按照上述流水模板的排版方式对应写入一个空白表格中,生成一个流水表格,使得该流水表格与上述流水模板的排版一致,该流水表格则作为上述银行流水模板存储于上述数据库中;同时,配置所述银行流水模板与所述标示信息的映射关系,便于根据标示信息匹配对应的银行流水模板。In this embodiment, the flow template is downloaded from the website of each bank, and the second storage subunit obtains the title field of the flow template through a preset script program, and corresponds the title field to the typesetting method of the flow template. Write in a blank form to generate a flow form to make the flow form consistent with the layout of the flow template, and the flow form is stored in the database as the bank flow template; at the same time, configure the bank flow template and the The mapping relationship of the marking information is convenient for matching the corresponding bank flow template according to the marking information.
在一实施例中,上述流水数据的管理装置还包括:In an embodiment, the above-mentioned flow data management device further includes:
加载单元40,用于在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中。A loading unit 40, configured to select, from all the pipeline data stored in the target pipeline template of the database, a user in the pipeline data as the target pipeline data of a specified user, and load the target pipeline data to the same data Form.
由于同一用户,其可能在多个银行具有账户,且在每个银行的流水数据不同。本实施例中,从银行获取到统计的第一流水信息,并将流水数据分别对应添加至所述目标流水模板中之后,生成用户的流水单;加载单元40根据用户的ID选择出同一指定用户的所有流水单,并将其加载在同一个数据表格中,便于进行对比分析、计算消费金额等;例如对比分析出该用户在不同银行的消费金额,判断用户偏好哪家银行等,同时还可以计算出所有消费金额中使用不同银行消费的权重比例。例如,用户甲使用中国银行消费的权重比例为30%,而使用平安银行消费的权重比例为70%等。或者还可以统计出用户某一个月份在通过各个银行的消费金额、收入金额等。Due to the same user, they may have accounts in multiple banks, and the flow data in each bank is different. In this embodiment, after obtaining the first statistical flow information from the bank and adding the flow data to the target flow template respectively, a flow slip for the user is generated; the loading unit 40 selects the same designated user according to the user's ID All the flow orders of the company and load them in the same data table, which is convenient for comparative analysis and calculation of consumption amount; for example, compare and analyze the user's consumption amount in different banks, determine which bank the user prefers, etc. Calculate the weighting ratio of all consumption amounts using different bank consumption. For example, user A uses 30% of the weight of Bank of China to consume, while Ping An Bank consumes 70% of the weight. Or you can also calculate the amount of consumption, income, etc. that a user spends through each bank in a certain month.
因此,在一实施例中,上述流水数据的管理装置还包括:Therefore, in an embodiment, the apparatus for managing flow data further includes:
计算单元,用于从所述数据表格中的流水数据中,获取指定用户对应在各个银行的消费金额,并计算指定用户在各个银行的消费金额比例。The calculation unit is configured to obtain the consumption amount corresponding to the specified user in each bank from the running data in the data table, and calculate the proportion of the consumption amount of the specified user in each bank.
本实施例中,计算单元计算指定用户在各个银行的消费金额比例,便于计算出所用户有消费金额中使用不同银行消费的权重比例,便于判断用户偏好使用哪家银行进行消费。In this embodiment, the calculation unit calculates the proportion of the consumption amount of the designated user in each bank, which is convenient for calculating the weighting proportion of consumption of different users by different banks, and it is convenient to judge which bank the user prefers to use for consumption.
在一实施例中,上述流水数据的管理装置还包括:In an embodiment, the above-mentioned flow data management device further includes:
下发单元,用于配置所述数据表格的查看权限,并将配置后的所述数据表格下发至所述指定用户所对应的用户终端。The issuing unit is configured to configure the viewing authority of the data table, and delivers the configured data table to a user terminal corresponding to the designated user.
本实施例中,下发单元对上述数据表格还配置有相应的查看权限;例如,对上述数据表格文件进行加密,用户正确输入密码才可以查看,该密码可以是预先在流水管理平台所设定的;用户输入密码错误时无法打开文件查看。将上述配置完的数据表格下发至指定用户的用户终端,便于用户了解自己在所有银行的消费金额,便于用户的财务管理。本实施例中,可以获取到用户与银行账户进行绑定的电话号码,并提取上述数据表格中的文本内容,生成文本信息,通过短消息的方式将上述文本信息发送至用户的终端。或者可以获取到用户与银行账户进行绑定的邮箱,然后,将上述数据表格通过邮件的形式发送给用户。In this embodiment, the issuing unit is also configured with corresponding viewing authority for the above data table; for example, the above data table file is encrypted, and the user can enter the password to view the password, which can be set in advance in the flow management platform. ; The user cannot open the file to view when the user enters the wrong password. The above-configured data form is sent to the user terminal of the designated user, so that the user can understand the amount of consumption in all banks and the financial management of the user. In this embodiment, the phone number that the user binds to the bank account can be obtained, and the text content in the data table is extracted to generate text information, and the text information is sent to the user's terminal through a short message. Or you can get the mailbox that the user binds to the bank account, and then send the above data form to the user by mail.
综上所述,为本申请实施例中提供的流水数据的管理方法以及装置,获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及标示信息,所述标示信息至少包括银行名称;根据所述标示信息,在数据库中选择出与所述标示信息相对应的银行流水模板作为目标流水模板;所述数据库中存储有与所述标示信息一一对应的银行流水模板;将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中;便于企业对账以及对用户的银行流水数据进行数据分析对比。In summary, the management method and device for flow data provided in the embodiments of the present application are used to obtain first flow information of bank statistics. The first flow information carries flow data and label information, and the label information is at least Including a bank name; selecting a bank flow template corresponding to the mark information as a target flow template in a database according to the mark information; and storing a bank flow template corresponding to the mark information in the database; The flow data carried by the first flow information is correspondingly added to the target flow template; it is convenient for business reconciliation and data analysis and comparison of the user's bank flow data.
参照图5,本申请实施例中还提供一种计算机设备,该计算机设备可以是服务器,其内部结构可以如图5所示。该计算机设备包括通过系统总线连接的处理器、存储器、网络接口和数据库。其中,该计算机设计的处理器用于提供计算和控制能力。该计算机设备的存储器包括非易失性存储介质、内存储器。该非易失性存储介质存储有操作系统、计算机可读指令和数据库。该内存储器为非易失性存储介质中的操作系统和计算机可读指令的运行提供环境。该计算机设备的数据库用于存储银行流水模板等数据。该计算机设备的网络接口用于与外部的终端通过网络连接通信。该计算机可读指令被处理器执行时以实现一种流水数据的管理方法。Referring to FIG. 5, an embodiment of the present application further provides a computer device. The computer device may be a server, and its internal structure may be as shown in FIG. The computer device includes a processor, a memory, a network interface, and a database connected through a system bus. Among them, the computer design processor is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer-readable instructions, and a database. The internal memory provides an environment for operating the operating system and computer-readable instructions in a non-volatile storage medium. The database of the computer equipment is used to store data such as bank flow templates. The network interface of the computer device is used to communicate with an external terminal through a network connection. The computer-readable instructions are executed by a processor to implement a method for managing pipeline data.
上述处理器执行上述流水数据的管理方法的步骤:The processor executes the steps of the method for managing pipeline data:
获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及对标示信息,所述标示信息至少包括银行名称;Acquiring first flow information from bank statistics, where the first flow information carries flow data and identification information, and the identification information includes at least a bank name;
根据所述标示信息,在数据库中选择出与所述标示信息相对应的银行流水模板作为目标流水模板;所述数据库中存储有与所述标示信息一一对应的银行流水模板;According to the marking information, a bank flow template corresponding to the marking information is selected as a target flow template in a database; the database stores a bank flow template corresponding to the marking information in a one-to-one manner;
将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中。Correspondingly add the pipeline data carried by the first pipeline information to the target pipeline template.
在一实施例中,上述处理器获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及标示信息,所述标示信息至少包括银行名称的步骤之前,包括:In an embodiment, the processor obtains first flow information counted by a bank, where the first flow information carries flow data and identification information, and the identification information includes at least before the step of the bank name, including:
在数据库中存储与所述标示信息一一对应的银行流水模板。A bank flow template corresponding to the identification information is stored in the database.
在一实施例中,上述处理器在数据库中存储与所述标示信息一一对应的银行流水模板的步骤,包括:In one embodiment, the step of the processor storing a bank flow template corresponding to the identification information in a database includes:
接收用户上传的银行流水模板,将所述上传的银行流水模板存储于所述数据库中,并配置所述银行流水模板与所述标示信息的映射关系。Receiving a bank flow template uploaded by a user, storing the uploaded bank flow template in the database, and configuring a mapping relationship between the bank flow template and the identification information.
在一实施例中,上述处理器在数据库中存储与所述标示信息一一对应的银行流水模板的步骤,包括:In one embodiment, the step of the processor storing a bank flow template corresponding to the identification information in a database includes:
通过预设的脚本程序获取预设流水模板的标题栏字段,并根据所述标题栏字段生成对应的银行流水模板存储于所述数据库中,以及配置所述银行流水模板与所述标示信息的映射关系。Obtain a title bar field of a preset flow template through a preset script program, and generate a corresponding bank flow template based on the title bar field to store in the database, and configure a mapping between the bank flow template and the identification information relationship.
在一实施例中,上述处理器将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中的步骤之后,包括:In an embodiment, after the step of the processor correspondingly adding the pipeline data carried by the first pipeline information to the target pipeline template, the method includes:
在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中。Among all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data is selected as the target pipeline data of the specified user, and the target pipeline data is loaded into the same data table.
在一实施例中,上述处理器在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中的步骤之后,包括:In an embodiment, the processor selects, from all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data as the target pipeline data of the specified user, and loads the target pipeline data Following the steps in the same data sheet include:
配置所述数据表格的查看权限,并将配置后的所述数据表格下发至所述指定用户所对应的用户终端。Configure the viewing authority of the data table, and send the configured data table to a user terminal corresponding to the specified user.
在一实施例中,上述处理器在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中的步骤之后,包括:In an embodiment, the processor selects, from all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data as the target pipeline data of the specified user, and loads the target pipeline data Following the steps in the same data sheet include:
从所述数据表格中的流水数据中,获取指定用户对应在各个银行的消费金额,并计算指定用户在各个银行的消费金额比例。From the flow data in the data table, the consumption amount corresponding to the specified user in each bank is obtained, and the proportion of the consumption amount of the specified user in each bank is calculated.
本领域技术人员可以理解,图5中示出的结构,仅仅是与本申请方案相关的部分结构的框图,并不构成对本申请方案所应用于其上的计算机设备的限定。Those skilled in the art can understand that the structure shown in FIG. 5 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer equipment to which the solution of the present application is applied.
本申请一实施例还提供一种计算机非易失性可读存储介质,其上存储有计算机可读指令,计算机可读指令被处理器执行时实现一种流水数据的管理方法,具体为:An embodiment of the present application further provides a computer non-volatile readable storage medium, which stores computer-readable instructions. When the computer-readable instructions are executed by a processor, a method for managing pipelined data is specifically:
获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及对标示信息,所述标示信息至少包括银行名称;Acquiring first flow information from bank statistics, where the first flow information carries flow data and identification information, and the identification information includes at least a bank name;
根据所述标示信息,在数据库中选择出与所述标示信息相对应的银行流水模板作为目标流水模板;所述数据库中存储有与所述标示信息一一对应的银行流水模板;According to the marking information, a bank flow template corresponding to the marking information is selected as a target flow template in a database; the database stores a bank flow template corresponding to the marking information in a one-to-one manner;
将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中。Correspondingly add the pipeline data carried by the first pipeline information to the target pipeline template.
在一实施例中,上述处理器获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及标示信息,所述标示信息至少包括银行名称的步骤之前,包括:In an embodiment, the processor obtains first flow information counted by a bank, where the first flow information carries flow data and identification information, and the identification information includes at least before the step of the bank name, including:
在数据库中存储与所述标示信息一一对应的银行流水模板。A bank flow template corresponding to the identification information is stored in the database.
在一实施例中,上述处理器在数据库中存储与所述标示信息一一对应的银行流水模板的步骤,包括:In one embodiment, the step of the processor storing a bank flow template corresponding to the identification information in a database includes:
接收用户上传的银行流水模板,将所述上传的银行流水模板存储于所述数据库中,并配置所述银行流水模板与所述标示信息的映射关系。Receiving a bank flow template uploaded by a user, storing the uploaded bank flow template in the database, and configuring a mapping relationship between the bank flow template and the identification information.
在一实施例中,上述处理器在数据库中存储与所述标示信息一一对应的银行流水模板的步骤,包括:In one embodiment, the step of the processor storing a bank flow template corresponding to the identification information in a database includes:
通过预设的脚本程序获取预设流水模板的标题栏字段,并根据所述标题栏字段生成对应的银行流水模板存储于所述数据库中,以及配置所述银行流水模板与所述标示信息的映射关系。Obtain a title bar field of a preset flow template through a preset script program, and generate a corresponding bank flow template based on the title bar field to store in the database, and configure a mapping between the bank flow template and the identification information relationship.
在一实施例中,上述处理器将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中的步骤之后,包括:In an embodiment, after the step of the processor correspondingly adding the pipeline data carried by the first pipeline information to the target pipeline template, the method includes:
在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中。Among all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data is selected as the target pipeline data of the specified user, and the target pipeline data is loaded into the same data table.
在一实施例中,上述处理器在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中的步骤之后,包括:In an embodiment, the processor selects, from all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data as the target pipeline data of the specified user, and loads the target pipeline data Following the steps in the same data sheet include:
配置所述数据表格的查看权限,并将配置后的所述数据表格下发至所述指定用户所对应的用户终端。Configure the viewing authority of the data table, and send the configured data table to a user terminal corresponding to the specified user.
在一实施例中,上述处理器在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中的步骤之后,包括:In an embodiment, the processor selects, from all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data as the target pipeline data of the specified user, and loads the target pipeline data Following the steps in the same data sheet include:
从所述数据表格中的流水数据中,获取指定用户对应在各个银行的消费金额,并计算指定用户在各个银行的消费金额比例。From the flow data in the data table, the consumption amount corresponding to the specified user in each bank is obtained, and the proportion of the consumption amount of the specified user in each bank is calculated.
综上所述,为本申请实施例中提供的流水数据的管理方法、装置、计算机设备和存储介质,获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及标示信息,所述标示信息至少包括银行名称;根据所述标示信息,在数据库中选择出与所述标示信息相对应的银行流水模板作为目标流水模板;所述数据库中存储有与所述标示信息一一对应的银行流水模板;将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中;便于企业对账以及对用户的银行流水数据进行数据分析对比。In summary, the method, device, computer equipment, and storage medium for the management of flow data provided in the embodiments of the present application are used to obtain the first flow information counted by the bank, where the first flow information carries the flow data and the label information. The label information includes at least a bank name; according to the label information, a bank flow template corresponding to the label information is selected as a target flow template in the database; the database stores one by one with the label information A corresponding bank flow template; correspondingly adding the flow data carried by the first flow information to the target flow template; facilitating business reconciliation and data analysis and comparison of the user's bank flow data.
本领域普通技术人员可以理解实现上述实施例方法中的全部或部分流程,是可以通过计算机可读指令来指令相关的硬件来完成,所述的计算机可读指令可存储与一非易失性计算机可读取存储介质中,该计算机可读指令在执行时,可包括如上述各方法的实施例的流程。其中,本申请所提供的和实施例中所使用的对存储器、存储、数据库或其它介质的任何引用,均可包括非易失性和/或易失性存储器。非易失性存储器可以包括只读存储器(ROM)、可编程ROM(PROM)、电可编程ROM(EPROM)、电可擦除可编程ROM(EEPROM)或闪存。易失性存储器可包括随机存取存储器(RAM)或者外部高速缓冲存储器。作为说明而非局限,RAM通过多种形式可得,诸如静态RAM(SRAM)、动态RAM(DRAM)、同步DRAM(SDRAM)、双速据率SDRAM(SSRSDRAM)、增强型SDRAM(ESDRAM)、同步链路(Synchlink)DRAM(SLDRAM)、存储器总线(Rambus)直接RAM(RDRAM)、直接存储器总线动态RAM(DRDRAM)、以及存储器总线动态RAM(RDRAM)等。Those of ordinary skill in the art can understand that all or part of the processes in the method of the above embodiments can be implemented by computer-readable instructions to instruct related hardware. The computer-readable instructions can be stored with a non-volatile computer. In the readable storage medium, the computer-readable instructions, when executed, may include the processes of the embodiments of the methods described above. Wherein, any reference to the memory, storage, database, or other media provided in this application and used in the embodiments may include non-volatile and / or volatile memory. Non-volatile memory may include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory. Volatile memory can include random access memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in various forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), dual-speed data rate SDRAM (SSRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), etc.
需要说明的是,在本文中,术语“包括”、“包含”或者其任何其它变体意在涵盖非排他性的包含,从而使得包括一系列要素的过程、装置、物品或者方法不仅包括那些要素,而且还包括没有明确列出的其它要素,或者是还包括为这种过程、装置、物品或者方法所固有的要素。在没有更多限制的情况下,由语句“包括一个……”限定的要素,并不排除在包括该要素的过程、装置、物品或者方法中还存在另外的相同要素。It should be noted that, in this text, the terms "including", "including" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, device, article or method including a series of elements includes not only those elements, It also includes other elements not explicitly listed, or elements inherent to such a process, device, article, or method. Without more restrictions, an element limited by the sentence "including a ..." does not exclude that there are other identical elements in the process, device, article, or method that includes the element.
以上所述仅为本申请的优选实施例,并非因此限制本申请的专利范围,凡是利用本申请说明书及附图内容所作的等效结构或等效流程变换,或直接或间接运用在其它相关的技术领域,均同理包括在本申请的专利保护范围内。The above is only a preferred embodiment of the present application, and does not limit the patent scope of the present application. Any equivalent structure or equivalent process transformation made by using the description and drawings of the present application, or directly or indirectly used in other related The technical fields are equally included in the patent protection scope of this application.

Claims (20)

  1. 一种流水数据的管理方法,其特征在于,包括以下步骤:A method for managing flow data includes the following steps:
    获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及标示信息,所述标示信息至少包括银行名称;Acquiring first flow information from bank statistics, where the first flow information carries flow data and identification information, and the identification information includes at least a bank name;
    根据所述标示信息,在数据库中选择出与所述标示信息相对应的银行流水模板作为目标流水模板;所述数据库中存储有与所述标示信息一一对应的银行流水模板;According to the marking information, a bank flow template corresponding to the marking information is selected as a target flow template in a database; the database stores a bank flow template corresponding to the marking information in a one-to-one manner;
    将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中。Correspondingly add the pipeline data carried by the first pipeline information to the target pipeline template.
  2. 根据权利要求1所述的流水数据的管理方法,其特征在于,所述获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及标示信息,所述标示信息至少包括银行名称的步骤之前,包括:The method for managing flow data according to claim 1, wherein the first flow information obtained by the bank is obtained, and the first flow information carries flow data and identification information, and the identification information includes at least a bank Name the steps before, including:
    在数据库中存储与所述标示信息一一对应的银行流水模板。A bank flow template corresponding to the identification information is stored in the database.
  3. 根据权利要求2所述的流水数据的管理方法,其特征在于,所述在数据库中存储与所述标示信息一一对应的银行流水模板的步骤,包括:The method for managing flow data according to claim 2, wherein the step of storing a bank flow template corresponding to the identification information in a database comprises:
    接收用户上传的银行流水模板,将所述上传的银行流水模板存储于所述数据库中,并配置所述银行流水模板与所述标示信息的映射关系。Receiving a bank flow template uploaded by a user, storing the uploaded bank flow template in the database, and configuring a mapping relationship between the bank flow template and the identification information.
  4. 根据权利要求2所述的流水数据的管理方法,其特征在于,所述在数据库中存储与所述标示信息一一对应的银行流水模板的步骤,包括:The method for managing flow data according to claim 2, wherein the step of storing a bank flow template corresponding to the identification information in a database comprises:
    通过预设的脚本程序获取预设流水模板的标题栏字段,并根据所述标题栏字段生成对应的银行流水模板存储于所述数据库中,以及配置所述银行流水模板与所述标示信息的映射关系。Obtain a title bar field of a preset flow template through a preset script program, and generate a corresponding bank flow template based on the title bar field to store in the database, and configure a mapping between the bank flow template and the identification information relationship.
  5. 根据权利要求1所述的流水数据的管理方法,其特征在于,所述将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中的步骤之后,所述方法还包括:The method for managing flow data according to claim 1, wherein after the step of correspondingly adding the flow data carried by the first flow information to the target flow template, the method further comprises:
    在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中。Among all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data is selected as the target pipeline data of the specified user, and the target pipeline data is loaded into the same data table.
  6. 根据权利要求5所述的流水数据的管理方法,其特征在于,所述在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中的步骤之后,所述方法还包括:The method for managing flow data according to claim 5, wherein, among all the flow data stored in the target flow template of the database, the user in the flow data is selected as the target flow of the specified user. After the step of loading the target flow data into the same data table, the method further includes:
    配置所述数据表格的查看权限,并将配置后的所述数据表格下发至所述指定用户所对应的用户终端。Configure the viewing authority of the data table, and send the configured data table to a user terminal corresponding to the specified user.
  7. 根据权利要求5所述的流水数据的管理方法,其特征在于,所述在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中的步骤之后,所述方法还包括:The method for managing flow data according to claim 5, wherein, among all the flow data stored in the target flow template of the database, the user in the flow data is selected as the target flow of the specified user. After the step of loading the target flow data into the same data table, the method further includes:
    从所述数据表格中的流水数据中,获取指定用户对应在各个银行的消费金额,并计算指定用户在各个银行的消费金额比例。From the flow data in the data table, the consumption amount corresponding to the specified user in each bank is obtained, and the proportion of the consumption amount of the specified user in each bank is calculated.
  8. 一种流水数据的管理装置,其特征在于,包括:A management device for flow data, which includes:
    获取单元,用于获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及标示信息,所述标示信息至少包括银行名称;An obtaining unit, configured to obtain first flow information from bank statistics, where the first flow information carries flow data and identification information, and the identification information includes at least a bank name;
    选择单元,用于根据所述标示信息,在数据库中选择出与所述标示信息相对应的银行流水模板作为目标流水模板;所述数据库中存储有与所述标示信息一一对应的银行流水模板;A selection unit is configured to select a bank flow template corresponding to the mark information as a target flow template in a database according to the mark information; and the database stores a bank flow template corresponding to the mark information in a one-to-one manner. ;
    添加单元,用于将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中。The adding unit is configured to correspondingly add the pipeline data carried by the first pipeline information to the target pipeline template.
  9. 根据权利要求8所述的流水数据的管理装置,其特征在于,所述装置还包括:The apparatus for managing flow data according to claim 8, wherein the apparatus further comprises:
    存储单元,用于在数据库中存储与所述标示信息一一对应的银行流水模板Storage unit, configured to store a bank flow template corresponding to the identification information in a database
  10. 根据权利要求9所述的流水数据的管理装置,其特征在于,所述存储单元包括:The apparatus for managing flow data according to claim 9, wherein the storage unit comprises:
    第一存储子单元,用于接收用户上传的银行流水模板,将所述上传的银行流水模板存储于所述数据库中,并配置所述银行流水模板与所述标示信息的映射关系。The first storage subunit is configured to receive a bank flow template uploaded by a user, store the uploaded bank flow template in the database, and configure a mapping relationship between the bank flow template and the identification information.
  11. 根据权利要求9所述的流水数据的管理装置,其特征在于,所述存储单元包括:The apparatus for managing flow data according to claim 9, wherein the storage unit comprises:
    第二存储子单元,用于通过预设的脚本程序获取预设流水模板的标题栏字段,并根据所述标题栏字段生成对应的银行流水模板存储于所述数据库中,以及配置所述银行流水模板与所述标示信息的映射关系。A second storage subunit, configured to obtain a title bar field of a preset flow template through a preset script program, generate a corresponding bank flow template according to the title bar field, store the template in the database, and configure the bank flow A mapping relationship between a template and the identification information.
  12. 根据权利要求8所述的流水数据的管理装置,其特征在于,所述装置还包括:The apparatus for managing flow data according to claim 8, wherein the apparatus further comprises:
    加载单元,用于在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中。A loading unit, configured to select, from all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data as the target pipeline data of the specified user, and load the target pipeline data into the same data table in.
  13. 根据权利要求12所述的流水数据的管理装置,其特征在于,所述装置还包括:The apparatus for managing flow data according to claim 12, wherein the apparatus further comprises:
    下发单元,用于配置所述数据表格的查看权限,并将配置后的所述数据表格下发至所述指定用户所对应的用户终端。The issuing unit is configured to configure the viewing authority of the data table, and delivers the configured data table to a user terminal corresponding to the designated user.
  14. 根据权利要求12所述的流水数据的管理装置,其特征在于,所述装置还包括:The apparatus for managing flow data according to claim 12, wherein the apparatus further comprises:
    计算单元,用于从所述数据表格中的流水数据中,获取指定用户对应在各个银行的消费金额,并计算指定用户在各个银行的消费金额比例。The calculation unit is configured to obtain the consumption amount corresponding to the specified user in each bank from the running data in the data table, and calculate the proportion of the consumption amount of the specified user in each bank.
  15. 一种计算机设备,包括存储器和处理器,所述存储器中存储有计算机可读指令,其特征在于,所述处理器执行所述计算机可读指令时实现流水数据的管理方法的步骤:A computer device includes a memory and a processor, and the memory stores computer-readable instructions, wherein the processor implements steps of a method for managing pipelined data when the processor executes the computer-readable instructions:
    获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及标示信息,所述标示信息至少包括银行名称;Acquiring first flow information from bank statistics, where the first flow information carries flow data and identification information, and the identification information includes at least a bank name;
    根据所述标示信息,在数据库中选择出与所述标示信息相对应的银行流水模板作为目标流水模板;所述数据库中存储有与所述标示信息一一对应的银行流水模板;According to the marking information, a bank flow template corresponding to the marking information is selected as a target flow template in a database; the database stores a bank flow template corresponding to the marking information in a one-to-one manner;
    将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中。Correspondingly add the pipeline data carried by the first pipeline information to the target pipeline template.
  16. 根据权利要求15所述的计算机设备,其特征在于,所述处理器将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中的步骤之后,还包括:The computer device according to claim 15, wherein after the step of the processor adding the pipeline data carried by the first pipeline information to the target pipeline template correspondingly, further comprising:
    在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中。Among all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data is selected as the target pipeline data of the specified user, and the target pipeline data is loaded into the same data table.
  17. 根据权利要求16所述的计算机设备,其特征在于,所述处理器在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中的步骤之后,还包括:The computer device according to claim 16, wherein the processor selects, from all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data as the target pipeline data of the specified user. And after the step of loading the target flow data into the same data table, the method further includes:
    配置所述数据表格的查看权限,并将配置后的所述数据表格下发至所述指定用户所对应的用户终端。Configure the viewing authority of the data table, and send the configured data table to a user terminal corresponding to the specified user.
  18. 一种计算机非易失性可读存储介质,其上存储有计算机可读指令,其特征在于,所述计算机可读指令被处理器执行时实现流水数据的管理方法的步骤:A computer non-volatile readable storage medium having computer-readable instructions stored thereon, characterized in that, when the computer-readable instructions are executed by a processor, the steps of a method for managing flow data are implemented:
    获取银行统计的第一流水信息,所述第一流水信息中携带有流水数据以及标示信息,所述标示信息至少包括银行名称;Acquiring first flow information from bank statistics, where the first flow information carries flow data and identification information, and the identification information includes at least a bank name;
    根据所述标示信息,在数据库中选择出与所述标示信息相对应的银行流水模板作为目标流水模板;所述数据库中存储有与所述标示信息一一对应的银行流水模板;According to the marking information, a bank flow template corresponding to the marking information is selected as a target flow template in a database; the database stores a bank flow template corresponding to the marking information in a one-to-one manner;
    将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中。Correspondingly add the pipeline data carried by the first pipeline information to the target pipeline template.
  19. 根据权利要求18所述的计算机非易失性可读存储介质,其特征在于,所述处理器将所述第一流水信息携带的流水数据对应添加至所述目标流水模板中的步骤之后,还包括:The computer non-volatile readable storage medium according to claim 18, wherein after the processor adds the pipeline data carried by the first pipeline information to the target pipeline template correspondingly, after the step, include:
    在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中。Among all the pipeline data stored in the target pipeline template of the database, the user in the pipeline data is selected as the target pipeline data of the specified user, and the target pipeline data is loaded into the same data table.
  20. 根据权利要求19所述的计算机非易失性可读存储介质,其特征在于,所述处理器在所述数据库的目标流水模板中存储的所有流水数据中,选择出所述流水数据中的用户为指定用户的目标流水数据,并将所述目标流水数据加载至同一数据表格中的步骤之后,还包括:The computer non-volatile readable storage medium according to claim 19, wherein the processor selects a user in the pipeline data from all the pipeline data stored in the target pipeline template of the database. After the step of specifying the target pipeline data of the user and loading the target pipeline data into the same data table, the method further includes:
    配置所述数据表格的查看权限,并将配置后的所述数据表格下发至所述指定用户所对应的用户终端。Configure the viewing authority of the data table, and send the configured data table to a user terminal corresponding to the specified user.
PCT/CN2018/108031 2018-07-19 2018-09-27 Account statement data management method and apparatus, and computer device and storage medium WO2020015184A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201810798391.4 2018-07-19
CN201810798391.4A CN109255108B (en) 2018-07-19 2018-07-19 Method and device for managing running data, computer equipment and storage medium

Publications (1)

Publication Number Publication Date
WO2020015184A1 true WO2020015184A1 (en) 2020-01-23

Family

ID=65049000

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2018/108031 WO2020015184A1 (en) 2018-07-19 2018-09-27 Account statement data management method and apparatus, and computer device and storage medium

Country Status (2)

Country Link
CN (1) CN109255108B (en)
WO (1) WO2020015184A1 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112465618A (en) * 2020-12-22 2021-03-09 航天信息股份有限公司企业服务分公司 Universal importing method and system for bank statement

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102255786A (en) * 2010-05-20 2011-11-23 中国移动通信集团广西有限公司 Service message processing method and device
CN106815366A (en) * 2017-01-23 2017-06-09 北京思特奇信息技术股份有限公司 A kind of method and system of Mass production data
CN106897508A (en) * 2017-02-14 2017-06-27 北京数码大方科技股份有限公司 The generation method and device of drawing

Family Cites Families (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105631738A (en) * 2015-12-30 2016-06-01 中国建设银行股份有限公司 Standard inputting and storing system for accountant document template
CN106339932A (en) * 2016-08-24 2017-01-18 明算科技(北京)股份有限公司 Accounting document generating method and accounting document generating device
CN108074176A (en) * 2016-11-15 2018-05-25 平安科技(深圳)有限公司 One kind carries voucher generation method and device in advance
CN106779803B (en) * 2016-11-24 2021-01-15 久远谦长(北京)技术服务有限公司 Method for matching financial institution running water with operator data
CN107038553A (en) * 2016-12-29 2017-08-11 平安科技(深圳)有限公司 Data processing method and device
CN107679819B (en) * 2017-06-12 2020-05-26 平安科技(深圳)有限公司 Financial data processing method and device, computer equipment and storage medium
CN107918910A (en) * 2017-09-28 2018-04-17 平安普惠企业管理有限公司 Financial affairs receipt generation method, device, equipment and computer-readable recording medium
CN107944996A (en) * 2017-10-17 2018-04-20 九派天下支付有限公司 A kind of fund account checking method and system
CN107767066A (en) * 2017-10-31 2018-03-06 浪潮金融信息技术有限公司 Wisdom site user behavior analysis method and device, storage medium and terminal
CN107888672A (en) * 2017-11-02 2018-04-06 深圳市牛鼎丰科技有限公司 Billing data processing method, device, storage medium and computer equipment

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102255786A (en) * 2010-05-20 2011-11-23 中国移动通信集团广西有限公司 Service message processing method and device
CN106815366A (en) * 2017-01-23 2017-06-09 北京思特奇信息技术股份有限公司 A kind of method and system of Mass production data
CN106897508A (en) * 2017-02-14 2017-06-27 北京数码大方科技股份有限公司 The generation method and device of drawing

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112465618A (en) * 2020-12-22 2021-03-09 航天信息股份有限公司企业服务分公司 Universal importing method and system for bank statement

Also Published As

Publication number Publication date
CN109255108A (en) 2019-01-22
CN109255108B (en) 2022-06-17

Similar Documents

Publication Publication Date Title
US20210056259A1 (en) System and method for reliable extraction and mapping of data to and from customer forms
CN109558575B (en) Online form editing method, online form editing device, computer equipment and storage medium
CN110692070B (en) System and method for automated batch user registration across both content management systems and any software applications embedded therein
CN110287691A (en) Application program login method, device, equipment and storage medium
US20140351686A1 (en) Expert system for automation, data collection, validation and managed storage without programming and without deployment
WO2020015183A1 (en) Method and device for approving reimbursement, computer equipment and storage medium
TW201433994A (en) System and method of mail management
CN112488655A (en) Business process dynamic customization system and method based on multi-tenant mode
CN110147495A (en) Page response method, apparatus, equipment and medium based on Configuration Online
CN107392560A (en) A kind of Excel list datas issue acquisition method and system based on internet
CN108228618A (en) The method and apparatus of document verification of data
CN112288400A (en) Multi-system data interaction method and device, computer equipment and storage medium
US20090083048A1 (en) System and method for providing an application service
WO2020015184A1 (en) Account statement data management method and apparatus, and computer device and storage medium
US20140344129A1 (en) Centralized entitlements
WO2020073516A1 (en) Method and device for selecting supplier based on data analysis, and computer device
CN114266539A (en) File flow processing method, system, device and computer readable storage medium
US20230289738A1 (en) Digital mailroom application
US20070030515A1 (en) Electronic document having authentication function
US9275252B2 (en) Enhanced view compliance tool
Hole et al. Web Portals for Business Data Collection
CN108766513A (en) A kind of wisdom health medical treatment data structured processing system
US9070136B2 (en) Cloud-based skip tracing application
JP7041675B2 (en) Methods and systems for collecting digital documents from multiple suppliers
WO2021073264A1 (en) Negotiable instrument information acquisition method and device, computer apparatus, and readable storage medium

Legal Events

Date Code Title Description
NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 18926804

Country of ref document: EP

Kind code of ref document: A1