CN114897590A - Form checking method, apparatus, computer equipment and storage medium - Google Patents
Form checking method, apparatus, computer equipment and storage mediumDownload PDFInfo
- Publication number
- CN114897590A CN114897590ACN202110295312.XACN202110295312ACN114897590ACN 114897590 ACN114897590 ACN 114897590ACN 202110295312 ACN202110295312 ACN 202110295312ACN 114897590 ACN114897590 ACN 114897590A
- Authority
- CN
- China
- Prior art keywords
- list
- data
- matched
- matching
- piece
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION 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/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION 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/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/03—Credit; Loans; Processing thereof
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION 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/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/04—Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Development Economics (AREA)
- Mathematical Physics (AREA)
- Human Computer Interaction (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Translated fromChinese
Description
Translated fromChinese技术领域technical field
本申请涉及数据处理技术领域，特别是涉及一种表单核对方法、装置、计算机设备和存储介质。The present application relates to the technical field of data processing, and in particular, to a form checking method, apparatus, computer equipment and storage medium.
背景技术Background technique
在再保险风险交易过程中，保险公司与再保险公司有非常繁重的账单核对工作。目前的账单核对工作都依赖人工比对来完成，因此核对的效率低，并且准确率也不高。In the process of reinsurance risk transactions, insurance companies and reinsurance companies have a very heavy bill reconciliation work. The current bill reconciliation work relies on manual comparison to complete, so the reconciliation efficiency is low and the accuracy rate is not high.
发明内容SUMMARY OF THE INVENTION
基于此，有必要针对上述技术问题，提供一种能够提高表单核对效率以及准确率的表单核对方法、装置、计算机设备和存储介质。Based on this, it is necessary to provide a form verification method, apparatus, computer equipment and storage medium that can improve the form verification efficiency and accuracy in order to address the above technical problems.
第一方面，提供了一种表单核对方法，该方法包括：In a first aspect, a form checking method is provided, and the method includes:
依次获取第一清单中的一条待匹配数据，根据匹配规则将该待匹配数据与第二清单中的每一条数据进行逐一匹配，若匹配成功，则对该待匹配数据和第二清单中的匹配数据进行第一次标记；Acquire a piece of data to be matched in the first list in turn, and match the data to be matched with each piece of data in the second list one by one according to the matching rules. If the match is successful, match the data to be matched with the data in the second list Data is marked for the first time;
将该第二清单中账单号相同的至少一条数据进行汇总，得到汇总数据；根据匹配规则依次将该第一清单中的待匹配数据与该第二清单中的汇总数据进行匹配，若匹配成功，对该待匹配数据与第二清单中汇总数据的每一条数据进行第二次标记；Aggregate at least one piece of data with the same bill number in the second list to obtain aggregated data; sequentially match the data to be matched in the first list with the aggregated data in the second list according to the matching rules, if the matching is successful, Marking each piece of the data to be matched and the aggregated data in the second list for the second time;
将该第二清单中账单组号相同的至少一条汇总数据进行汇总，得到账单组数据；根据匹配规则将该第一清单中的每一条记录与第二清单中的账单组数据进行匹配，若匹配成功，对该待匹配数据与第二清单中账单组数据的每一条数据进行第三次标记，得到该第一清单和该第二清单的核对结果。Summarize at least one piece of summary data with the same billing group number in the second list to obtain billing group data; match each record in the first list with the billing group data in the second list according to the matching rule, if there is a match If successful, mark the data to be matched and each piece of billing group data in the second list for the third time, and obtain a check result of the first list and the second list.
在其中一个实施例中，该方法还包括：In one embodiment, the method further includes:
获取第一清单及第二清单，并在核对界面显示；Obtain the first list and the second list, and display them on the verification interface;
响应于对该核对界面上的核对控件的触发操作，显示参数选项框；In response to the triggering operation of the checking control on the checking interface, displaying a parameter option box;
通过该参数选项框获取输入的容差参数值以及反向参数值；Obtain the input tolerance parameter value and reverse parameter value through the parameter option box;
根据该容差参数值以及反向参数值得到该匹配规则。The matching rule is obtained according to the tolerance parameter value and the reverse parameter value.
在其中一个实施例中，根据匹配规则将该待匹配数据与第二清单中的每一条数据进行逐一匹配，包括：In one embodiment, the to-be-matched data is matched with each piece of data in the second list one by one according to a matching rule, including:
根据该第一清单的待匹配数据及该反向参数值进行计算，得到正确的待匹配数据；Calculate according to the data to be matched in the first list and the reverse parameter value to obtain correct data to be matched;
若该正确的待匹配数据与第二清单中的一条数据的绝对差值小于该容差参数值，则匹配成功。If the absolute difference between the correct data to be matched and a piece of data in the second list is less than the tolerance parameter value, the matching is successful.
在其中一个实施例中，获取第一清单及第二清单，并在核对界面显示包括：In one embodiment, acquiring the first list and the second list and displaying them on the verification interface includes:
获取第一用户提供的原始结算清单；Obtain the original settlement list provided by the first user;
对该原始结算清单进行预处理，得到第一清单；Preprocessing the original settlement list to obtain the first list;
在该核对界面显示该第一清单；displaying the first list on the checking interface;
获取查询条件，根据该查询条件从数据库中查询得到第二清单，并在核对界面显示该第二清单，其中该第二清单是指第二用户提供的未结算清单。Obtain query conditions, query the database to obtain a second list according to the query conditions, and display the second list on the checking interface, where the second list refers to an unsettled list provided by the second user.
在其中一个实施例中，获取查询条件，包括：In one embodiment, acquiring query conditions includes:
获取对该核对界面上的查询控件的触发操作，根据该查询触发操作显示查询条件字段，该查询条件字段包括账单状态、核销状态、日期区间、币种、或第一用户标识中至少一种，其中，该币种根据第一清单中的币种确定；Obtain the trigger operation of the query control on the verification interface, and display a query condition field according to the query trigger operation, where the query condition field includes at least one of billing status, write-off status, date interval, currency, or the first user ID , where the currency is determined according to the currency in the first list;
获取对该查询条件字段所赋的值，根据该查询条件字段的值得到查询条件。Obtain the value assigned to the query condition field, and obtain the query condition according to the value of the query condition field.
在其中一个实施例中，该方法还包括：In one embodiment, the method further includes:
根据该核对结果、第一清单数据量以及第二清单数据量进行计算，得到匹配度；Calculate according to the check result, the data volume of the first list and the data volume of the second list to obtain the matching degree;
若该匹配度小于预设匹配度，则重新显示该查询条件字段，获取对所述查询条件字段所赋的值，根据所述查询条件字段的值得到新的查询条件，进行核对，或者重新显示参数选项框，通过所述参数选项框获取输入的容差参数值以及反向参数值，重新确定匹配规则。If the matching degree is less than the preset matching degree, the query condition field is redisplayed, the value assigned to the query condition field is obtained, a new query condition is obtained according to the value of the query condition field, and the query condition is checked or displayed again. A parameter option box, through which the input tolerance parameter value and reverse parameter value are obtained, and the matching rule is re-determined.
在其中一个实施例中，该方法还包括：In one embodiment, the method further includes:
获取对该核对界面上的第一导出控件的触发操作，在该第一清单上加入核对结果ID，并生成第一核对文件；Obtain the trigger operation of the first export control on the verification interface, add the verification result ID to the first list, and generate a first verification file;
获取对该核对界面上的第二导出控件的触发操作，在该第二清单上加入核对结果ID，并生成第二核对文件。The trigger operation of the second export control on the verification interface is acquired, the verification result ID is added to the second list, and a second verification file is generated.
第二方面，提供了一种表单核对装置，该装置包括：In a second aspect, a form checking device is provided, the device comprising:
第一匹配模块，用于依次获取第一清单中的一条待匹配数据，根据匹配规则将该待匹配数据与第二清单中的每一条数据进行逐一匹配，若匹配成功，则对该待匹配数据和第二清单中的匹配数据进行第一次标记；The first matching module is used to sequentially obtain a piece of data to be matched in the first list, and match the data to be matched with each piece of data in the second list one by one according to the matching rule. If the matching is successful, then the data to be matched is matched Perform the first marking with the matching data in the second list;
第二匹配模块，用于将该第二清单中账单号相同的至少一条数据进行汇总，得到汇总数据；根据匹配规则依次将该第一清单中的待匹配数据与该第二清单中的汇总数据进行匹配，若匹配成功，对该待匹配数据与第二清单中汇总数据的每一条数据进行第二次标记；The second matching module is used for summarizing at least one piece of data in the second list with the same bill number to obtain summary data; the data to be matched in the first list and the summary data in the second list in turn according to matching rules Matching is carried out, if the matching is successful, the data to be matched and each piece of data in the aggregated data in the second list are marked for the second time;
第三匹配模块，用于将该第二清单中账单组号相同的至少一条汇总数据进行汇总，得到账单组数据；根据匹配规则将该第一清单中的每一条记录与第二清单中的账单组数据进行匹配，若匹配成功，对该待匹配数据与第二清单中账单组数据的每一条数据进行第三次标记，得到该第一清单和该第二清单的核对结果。The third matching module is used for summarizing at least one piece of summary data with the same bill group number in the second list to obtain bill group data; each record in the first list is matched with the bill in the second list according to the matching rule The group data is matched, and if the match is successful, the data to be matched and each piece of data in the bill group data in the second list are marked for the third time to obtain the check result of the first list and the second list.
第三方面，提供了一种计算机设备，包括存储器和处理器，该存储器存储有计算机程序，该处理器执行该计算机程序时实现以下步骤：In a third aspect, a computer device is provided, including a memory and a processor, the memory stores a computer program, and the processor implements the following steps when executing the computer program:
依次获取第一清单中的一条待匹配数据，根据匹配规则将该待匹配数据与第二清单中的每一条数据进行逐一匹配，若匹配成功，则对该待匹配数据和第二清单中的匹配数据进行第一次标记；Acquire a piece of data to be matched in the first list in turn, and match the data to be matched with each piece of data in the second list one by one according to the matching rules. If the match is successful, match the data to be matched with the data in the second list Data is marked for the first time;
将该第二清单中账单号相同的至少一条数据进行汇总，得到汇总数据；根据匹配规则依次将该第一清单中的待匹配数据与该第二清单中的汇总数据进行匹配，若匹配成功，对该待匹配数据与第二清单中汇总数据的每一条数据进行第二次标记；Aggregate at least one piece of data with the same bill number in the second list to obtain aggregated data; sequentially match the data to be matched in the first list with the aggregated data in the second list according to the matching rules, if the matching is successful, Marking each piece of the data to be matched and the aggregated data in the second list for the second time;
将该第二清单中账单组号相同的至少一条汇总数据进行汇总，得到账单组数据；根据匹配规则将该第一清单中的每一条记录与第二清单中的账单组数据进行匹配，若匹配成功，对该待匹配数据与第二清单中账单组数据的每一条数据进行第三次标记，得到该第一清单和该第二清单的核对结果。Summarize at least one piece of summary data with the same billing group number in the second list to obtain billing group data; match each record in the first list with the billing group data in the second list according to the matching rule, if there is a match If successful, mark the data to be matched and each piece of billing group data in the second list for the third time, and obtain a check result of the first list and the second list.
第四方面，提供了一种计算机可读存储介质，其上存储有计算机程序，该计算机程序被处理器执行时实现以下步骤：In a fourth aspect, a computer-readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, the following steps are implemented:
依次获取第一清单中的一条待匹配数据，根据匹配规则将该待匹配数据与第二清单中的每一条数据进行逐一匹配，若匹配成功，则对该待匹配数据和第二清单中的匹配数据进行第一次标记；Acquire a piece of data to be matched in the first list in turn, and match the data to be matched with each piece of data in the second list one by one according to the matching rules. If the match is successful, match the data to be matched with the data in the second list Data is marked for the first time;
将该第二清单中账单号相同的至少一条数据进行汇总，得到汇总数据；根据匹配规则依次将该第一清单中的待匹配数据与该第二清单中的汇总数据进行匹配，若匹配成功，对该待匹配数据与第二清单中汇总数据的每一条数据进行第二次标记；Aggregate at least one piece of data with the same bill number in the second list to obtain aggregated data; sequentially match the data to be matched in the first list with the aggregated data in the second list according to the matching rules, if the matching is successful, Marking each piece of the data to be matched and the aggregated data in the second list for the second time;
将该第二清单中账单组号相同的至少一条汇总数据进行汇总，得到账单组数据；根据匹配规则将该第一清单中的每一条记录与第二清单中的账单组数据进行匹配，若匹配成功，对该待匹配数据与第二清单中账单组数据的每一条数据进行第三次标记，得到该第一清单和该第二清单的核对结果。Summarize at least one piece of summary data with the same billing group number in the second list to obtain billing group data; match each record in the first list with the billing group data in the second list according to the matching rule, if there is a match If successful, mark the data to be matched and each piece of billing group data in the second list for the third time, and obtain a check result of the first list and the second list.
上述表单核对方法、装置、计算机设备和存储介质，通过依次获取第一清单中的一条待匹配数据，首先根据匹配规则将该待匹配数据与第二清单中的每一条数据进行逐一匹配；而后，将该第一清单中的待匹配数据与该第二清单中的汇总数据进行第二次匹配；接着，将该第一清单中的每一条记录与第二清单中的账单组数据进行第三次匹配；每次匹配成功都将匹配成功的数据进行标记。通过三次核对过程将第一清单中的待匹配数据与第二清单中的单条数据、汇总数据、账单组数据层层匹配，得到该第一清单和该第二清单的核对结果，该方法可以应对多种类型的账单，核对时间缩短，核对效率提升，且提高了核对结果的准确率。The above-mentioned form checking method, device, computer equipment and storage medium, by sequentially acquiring a piece of data to be matched in the first list, firstly match the data to be matched with each piece of data in the second list one by one according to matching rules; then, The data to be matched in the first list is matched with the aggregated data in the second list for the second time; then, each record in the first list is matched with the billing group data in the second list for the third time Match; each successful match will mark the data that matches successfully. The data to be matched in the first list is matched with the single data, summary data, and billing group data in the second list through three verification processes, and the verification results of the first list and the second list are obtained. This method can deal with For various types of bills, the verification time is shortened, the verification efficiency is improved, and the accuracy of the verification results is improved.
附图说明Description of drawings
图1为一个实施例中表单核对方法的应用环境图；Fig. 1 is the application environment diagram of the form checking method in one embodiment;
图2为一个实施例中表单核对方法的流程示意图；2 is a schematic flowchart of a form checking method in one embodiment;
图3为一个实施例中表单核对方法的界面示意图；3 is a schematic interface diagram of a form checking method in one embodiment;
图4为另一个实施例中表单核对方法的架构图；4 is a schematic diagram of a form checking method in another embodiment;
图5为另一个实施例中表单核对方法的整体流程示意图；5 is a schematic diagram of an overall flow of a form checking method in another embodiment;
图6为一个实施例中表单核对装置的结构框图；6 is a structural block diagram of a form checking apparatus in one embodiment;
图7为一个实施例中计算机设备的内部结构图。FIG. 7 is a diagram of the internal structure of a computer device in one embodiment.
具体实施方式Detailed ways
为了使本申请的目的、技术方案及优点更加清楚明白，以下结合附图及实施例，对本申请进行进一步详细说明。应当理解，此处描述的具体实施例仅仅用以解释本申请，并不用于限定本申请。In order to make the purpose, technical solutions and advantages of the present application more clearly understood, the present application will be described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application, but not to limit the present application.
本申请提供的表单核对方法，可以应用于如图1所示的应用环境中。其中，终端102通过网络与服务器104进行通信。终端102接收第一用户提供的原始结算清单，并通过核对人员在终端102上的核对界面输入的查询条件，通过网络将查询条件发送至服务器104，服务器104根据查询条件在数据库中进行查询，得到第二用户提供的未结算清单，并通过网络发送给终端102。其中，终端102可以但不限于是各种个人计算机、笔记本电脑、智能手机、平板电脑和便携式可穿戴设备，服务器104可以用独立的服务器或者是多个服务器组成的服务器集群来实现。本实施例以表单核对方法应用于再保险风险交易为列进行说明，本申请提供的表单核对方法也可以应用于其他交易过程中的表单核对，例如银行交易账单核对、学校账单核对等。The form checking method provided in this application can be applied to the application environment shown in FIG. 1 . The terminal 102 communicates with the
在一个实施例中，如图2所示，提供了一种表单核对方法，以该方法应用于图1中的终端为例进行说明，包括以下步骤：In one embodiment, as shown in FIG. 2 , a form checking method is provided, and the method is applied to the terminal in FIG. 1 as an example for description, including the following steps:
步骤202，依次获取第一清单中的一条待匹配数据，根据匹配规则将该待匹配数据与第二清单中的每一条数据进行逐一匹配，若匹配成功，则对该待匹配数据和第二清单中的匹配数据进行第一次标记。Step 202: Obtain a piece of data to be matched in the first list in turn, and match the data to be matched with each piece of data in the second list one by one according to the matching rule. If the match is successful, then match the data to be matched with the second list. The matching data in is marked for the first time.
其中，第一清单是由第一用户提供的结算清单。第一用户可以是公司或者个人，例如第一用户可以是不同类型的保险公司：再保险经纪公司或者再保险分出公司。再保险分出公司是指将其承担的保险业务，部分转移给其他保险公司的保险公司；再保险经纪公司主要是指那些“帮助保险公司安排再保险业务以及按照某些大宗保险业务本身的需要进行再保险业务的保险经纪人所在的公司”。第一清单可以是表格或者其他文本格式，本实施例在此不做限定，只要能清楚地表示清单信息即可。第一清单中每一列表示一个属性，每一行表示一条数据。第一清单的属性包括币种、金额等清单关键信息。The first list is a settlement list provided by the first user. The first user may be a company or an individual, for example the first user may be a different type of insurance company: a reinsurance brokerage company or a reinsurance ceding company. Reinsurance ceding companies refer to insurance companies that transfer part of the insurance business they undertake to other insurance companies; reinsurance brokerage companies mainly refer to those who "help insurance companies arrange reinsurance business and carry out reinsurance business according to the needs of certain bulk insurance business itself. the company of the insurance broker”. The first list may be in a table or other text format, which is not limited in this embodiment, as long as the list information can be clearly represented. Each column in the first list represents an attribute, and each row represents a piece of data. The attributes of the first list include key list information such as currency and amount.
第二清单是由第二用户提供的未结算清单。第二用户可以是公司或者个人，例如第二用户可以为再保险公司。再保险也称分保或“保险的保险”，指保险人将自己所承担的保险责任，部分地转嫁给其他保险人承保的业务。再保险业务中分出保险的一方为原保险人，接受再保险的一方为再保险人。再保险人与本来的被保险人无直接关系，只对原保险人负责。第二清单可以是表格或者其他文本格式，本实施例在此不做限定，只要能清楚地表示清单信息即可。第二清单中每一列表示一个属性，每一行表示一条数据。第二清单的属性包括币种、金额、第一用户标识、账单状态、核销状态、日期区间等关键信息。The second list is an open list provided by the second user. The second user may be a company or an individual, for example, the second user may be a reinsurance company. Reinsurance, also known as reinsurance or "insurance of insurance", refers to the insurer transferring part of the insurance liability undertaken by itself to the business underwritten by other insurers. In the reinsurance business, the party that cedes insurance is the original insurer, and the party that accepts reinsurance is the reinsurer. The reinsurer has no direct relationship with the original insured and is only responsible to the original insurer. The second list may be in a table or other text format, which is not limited in this embodiment, as long as the list information can be clearly represented. Each column in the second list represents an attribute, and each row represents a piece of data. The attributes of the second list include key information such as currency, amount, first user ID, bill status, write-off status, and date interval.
具体地，依次从第一清单中获取一条数据作为待匹配数据，将这条待匹配数据与第二清单中的每一条数据的币种和金额进行逐一匹配，根据匹配规则查看两者是否匹配。匹配规则是指预先设定的币种和金额的匹配条件，若待匹配数据与第二清单中的一条数据的币种和金额满足匹配规则，则匹配成功，然后将待匹配数据和第二清单中的匹配数据进行第一次标记。若第二清单中有多条数据与待匹配数据匹配，则按照第二清单中日期区间中日期递增的顺序对这多条匹配数据进行排序，选取日期最小的匹配数据和待匹配数据做第一次标记。第一次标记的方式可以为“第一清单行号##第二清单行号”，例如第一清单中的第一行数据的金额与币种与第二清单中第3行数据的金额和币种都相同，则第一次标记为“1##3”，并将标记作为这两条数据的核对结果的ID，可以在第一清单和第二清单新插入一列，将核对结果的ID写入对应的待匹配数据和匹配数据所在的行。Specifically, sequentially obtain a piece of data from the first list as the data to be matched, match the data to be matched with the currency and amount of each piece of data in the second list one by one, and check whether the two match according to the matching rules. The matching rule refers to the preset matching conditions of currency and amount. If the currency and amount of the data to be matched and a piece of data in the second list meet the matching rules, the matching is successful, and then the data to be matched and the second list are matched. The matching data in is marked for the first time. If there are multiple pieces of data in the second list that match the data to be matched, sort the multiple pieces of matching data in the order of increasing dates in the date interval in the second list, and select the matching data with the smallest date and the data to be matched as the first secondary mark. The way of marking the first time can be "first list line number##second list line number", for example, the amount and currency of the first line of data in the first list and the sum of the amount and currency of the third line of data in the second list If the currencies are the same, the first time mark is "1##3", and the mark is used as the ID of the check result of these two data. A new column can be inserted in the first list and the second list, and the ID of the check result Write the corresponding data to be matched and the row where the matched data is located.
步骤204，将该第二清单中账单号相同的至少一条数据进行汇总，得到汇总数据；根据匹配规则依次将该第一清单中的待匹配数据与该第二清单中的汇总数据进行匹配，若匹配成功，对该待匹配数据与第二清单中汇总数据的每一条数据进行第二次标记。Step 204: Aggregate at least one piece of data with the same bill number in the second list to obtain aggregated data; sequentially match the data to be matched in the first list with the aggregated data in the second list according to the matching rule, if If the matching is successful, the data to be matched and each piece of aggregated data in the second list are marked a second time.
其中，一个账单号可能会对应多笔金额，这多笔金额账单号相同，都是属于同一个账单的，将这多笔金额汇总之后就是账单的汇总数据。例如小A购买一个商品C分六期付款，最后汇总账单的时候，这六期的付款的账单号相同，都是对应的商品C的，最后账单核对的时候需要用汇总金额与售货方的账单进行核对。Among them, one bill number may correspond to multiple amounts. The bill numbers of these multiple amounts are the same and belong to the same bill. After summarizing the multiple amounts, the summary data of the bill is obtained. For example, small A buys a commodity C and pays in six installments. When the final bill is summarized, the bill numbers of the six payments are the same, and they are all corresponding to product C. When checking the final bill, the total amount and the seller's bill must be used. Check the bill.
具体地，将第二清单中账单号相同的多条数据的金额进行累加，得到汇总数据的汇总金额。从第一清单中依次获取一条未匹配数据作为待匹配数据，将待匹配数据依次与第二清单汇总数据的汇总金额进行匹配，若未匹配的数据与汇总数据中的汇总金额满足匹配规则，则匹配成功，然后将待匹配数据和第二清单中的汇总数据的每一条数据做第二次标记。第二次标记的方式与上述第一次标记的方式相同。例如，如果第一清单中第5行数据的金额是100，币种是CNY，第二清单中行号为10、20、30行的金额的账单号相同，这三行数据的金额累加结果是100CNY，则第二次标记的写法是“5##10_20_30”。Specifically, the amounts of the multiple pieces of data with the same bill number in the second list are accumulated to obtain the aggregated amount of the aggregated data. Obtain a piece of unmatched data from the first list as the data to be matched, and sequentially match the data to be matched with the aggregated amount of the aggregated data in the second list. If the unmatched data and the aggregated amount in the aggregated data satisfy the matching rule, then If the matching is successful, then mark each piece of data to be matched and the aggregated data in the second list for the second time. The second marking is done in the same way as the first marking above. For example, if the amount of data in line 5 in the first list is 100 and the currency is CNY, and the invoice numbers of the amounts in
步骤206，将该第二清单中账单组号相同的至少一条汇总数据进行汇总，得到账单组数据；根据匹配规则将该第一清单中的每一条记录与第二清单中的账单组数据进行匹配，若匹配成功，对该待匹配数据与第二清单中账单组数据的每一条数据进行第三次标记，得到该第一清单和该第二清单的核对结果。Step 206: Summarize at least one piece of summary data with the same billing group number in the second list to obtain billing group data; match each record in the first list with the billing group data in the second list according to the matching rule , if the matching is successful, mark the data to be matched and each piece of billing group data in the second list for the third time to obtain the check result of the first list and the second list.
具体地，一组账单可能包含多个汇总数据，则需要把账单组号相同的多个账单汇总数据的金额进行累加，得到账单组金额。例如，小A在10月有15笔消费，这15笔消费都使用花呗支付，每笔消费有唯一的账单号，这多个账单号对应的账单组号即“10月消费账单”组号相同，都是属于小A的10月消费账单，在11月进行花呗还款的时候，是将10月的15笔消费金额全部汇总得到账单组金额后进行还款。Specifically, a group of bills may contain multiple aggregated data, and the amounts of aggregated data of multiple bills with the same bill group number need to be accumulated to obtain the amount of the bill group. For example, Xiao A has 15 consumptions in October, and these 15 consumptions are all paid by Huabei. Each consumption has a unique bill number. The bill group number corresponding to these multiple bill numbers is the "October consumption bill" group number In the same way, they all belong to Xiao A's consumption bills in October. When Huabei repays in November, all the 15 consumption amounts in October are aggregated to obtain the amount of the bill group before repayment.
从第一清单中依次获取一条未匹配数据作为待匹配数据，将待匹配数据依次与第二清单账单组数据的金额进行匹配，若未匹配的数据与账单组数据的金额满足匹配规则，则匹配成功，然后将待匹配数据和第二清单中的账单组数据的每一条数据做第三次标记，并将第三次标记作为这两条数据的核对结果的ID。第三次标记的方式与上述第一次标记的方式相同，在此不再举例说明。最后将完整的第一清单数据及每条数据的核对结果ID作为第一清单核对结果，将完整的第二清单数据及每条数据的核对结果ID组成第二清单核对结果。Obtain a piece of unmatched data from the first list as the data to be matched, and match the data to be matched with the amount of the billing group data in the second list in sequence. If the unmatched data and the amount of the billing group data meet the matching rules, then match If successful, mark each piece of data to be matched and the billing group data in the second list for the third time, and use the third mark as the ID of the verification result of these two pieces of data. The way of marking the third time is the same as the way of marking the first time, and will not be illustrated here. Finally, the complete first list data and the check result ID of each piece of data are used as the first list check result, and the complete second list data and the check result ID of each piece of data form the second list check result.
上述表单核对方法中，通过依次获取第一清单中的一条待匹配数据，首先根据匹配规则将该待匹配数据与第二清单中的每一条数据进行逐一匹配；而后，将该第一清单中的待匹配数据与该第二清单中的汇总数据进行第二次匹配；接着，将该第一清单中的每一条记录与第二清单中的账单组数据进行第三次匹配；每次匹配成功都将匹配成功的数据进行标记。通过三次核对过程将第一清单中的待匹配数据与第二清单中的单条数据、汇总数据、账单组数据层层匹配，得到该第一清单和该第二清单的核对结果，该方法可以应对多种类型的账单，核对时间缩短，核对效率提升，且提高了核对结果的准确率。In the above form checking method, by sequentially acquiring a piece of data to be matched in the first list, the data to be matched is firstly matched with each piece of data in the second list according to the matching rule; then, the data in the first list is matched one by one. The data to be matched is matched with the aggregated data in the second list for the second time; then, each record in the first list is matched with the billing group data in the second list for the third time; Mark the data that matches successfully. The data to be matched in the first list is matched with the single data, summary data, and billing group data in the second list through three verification processes, and the verification results of the first list and the second list are obtained. This method can deal with For various types of bills, the verification time is shortened, the verification efficiency is improved, and the accuracy of the verification results is improved.
在一个实施例中，该方法还包括：In one embodiment, the method further includes:
获取第一清单及第二清单，并在核对界面显示；Obtain the first list and the second list, and display them on the verification interface;
响应于对该核对界面上的核对控件的触发操作，显示参数选项框；In response to the triggering operation of the checking control on the checking interface, displaying a parameter option box;
通过该参数选项框获取输入的容差参数值以及反向参数值；Obtain the input tolerance parameter value and reverse parameter value through the parameter option box;
根据该容差参数值以及反向参数值得到该匹配规则。The matching rule is obtained according to the tolerance parameter value and the reverse parameter value.
具体地，核对界面上显示第一清单、第二清单以及一些触发控件。当接收到核对人员在核对界面上核对控件的触发操作时，弹出参数选项框并在核对界面显示。参数选项框包括容差参数、反向参数两个字段等。容差参数为两位小数的数字格式，是指核对过程可以接受的误差，例如容差参数值为0.00则表示不允许有误差，容差参数值为0.01则表示允许的误差范围为[-0.01,0.01]。反向参数是指第一清单中数据的借贷方向，如果以第一用户视觉填写第一清单，则与第二清单中金额的借贷方向不同，就需要对第一清单中数据的金额乘以-1，例如小A借了小B100元，对于小A来说账户金额+100元，对于小B来说账户金额-100元。核对人员可以在参数选项框对容差参数、反向参数两个字段进行输入或者选择操作，终端通过参数选项框获取输入的容差参数值以及反向参数值，并根据容差参数值、反向参数值以及第一清单数据、第二清单数据计算得到匹配规则。Specifically, the check interface displays the first list, the second list and some trigger controls. When receiving the triggering operation of checking the control on the checking interface by the checking personnel, a parameter option box will pop up and be displayed on the checking interface. The parameter option box includes two fields such as tolerance parameter and reverse parameter. The tolerance parameter is a digital format with two decimals, which refers to the acceptable error in the verification process. For example, a tolerance parameter value of 0.00 means that no error is allowed, and a tolerance parameter value of 0.01 means that the allowable error range is [-0.01 , 0.01]. The reverse parameter refers to the loan direction of the data in the first list. If the first list is visually filled by the first user, the loan direction of the amount in the second list is different from the loan direction of the amount in the second list. The amount of the data in the first list needs to be multiplied by - 1. For example, Xiao A borrows
本实施例中，通过参数选项框获取容差参数值与反向参数值，可以根据核对需求调整容差参数值，根据借贷方向将第一清单中的数据与第二清单中的数据调整一致，提高了核对过程的灵活性与准确性。In this embodiment, the tolerance parameter value and the reverse parameter value are obtained through the parameter option box, the tolerance parameter value can be adjusted according to the checking requirements, and the data in the first list can be adjusted to be consistent with the data in the second list according to the lending direction, Increased flexibility and accuracy of the reconciliation process.
在一个实施例中，根据匹配规则将该待匹配数据与第二清单中的每一条数据进行逐一匹配，包括：In one embodiment, the data to be matched is matched with each piece of data in the second list one by one according to a matching rule, including:
根据该第一清单的待匹配数据及该反向参数值进行计算，得到正确的待匹配数据；Calculate according to the data to be matched in the first list and the reverse parameter value to obtain correct data to be matched;
若该正确的待匹配数据与第二清单中的一条数据的绝对差值小于该容差参数值，则匹配成功。If the absolute difference between the correct data to be matched and a piece of data in the second list is less than the tolerance parameter value, the matching is successful.
具体地，正确的待匹配数据是指借贷方向与第二清单中借贷方向一致的待匹配数据。首先检测第一清单中待匹配数据的借贷方向，若与第二清单中数据的借贷方向一致，则第一清单中的待匹配数据为正确的待匹配数据；若与第二清单中数据的借贷方向不一致，则将第一清单中的待匹配数据中的金额乘以(-1)得到正确的待匹配数据。匹配规则为第一清单中正确的待匹配数据的币种与第二清单中一条数据的币种相同，并且|第一清单中正确的待匹配数据金额-第二清单中一条数据的金额|<容差参数值。若第一清单中正确的待匹配数据与第二清单中一条数据的币种相同，并且两者金额的差值的绝对值小于容差参数值，则匹配成功。由于金额的散列分布情况比较好，只根据币种和金额就可以唯一确定匹配条件。若还想要更高的匹配度，还可以增加其他条件以提高匹配精度。Specifically, the correct data to be matched refers to the data to be matched whose loan direction is consistent with the loan direction in the second list. First, the loan direction of the data to be matched in the first list is detected. If it is consistent with the loan direction of the data in the second list, the data to be matched in the first list is the correct data to be matched; if it matches the loan direction of the data in the second list If the directions are inconsistent, multiply the amount in the data to be matched in the first list by (-1) to obtain the correct data to be matched. The matching rule is that the currency of the correct data to be matched in the first list is the same as the currency of a piece of data in the second list, and |the correct amount of the data to be matched in the first list - the amount of a piece of data in the second list|< Tolerance parameter value. If the correct data to be matched in the first list is of the same currency as a piece of data in the second list, and the absolute value of the difference between the two amounts is less than the tolerance parameter value, the matching is successful. Since the hash distribution of the amount is relatively good, the matching conditions can be uniquely determined only based on the currency and amount. If you want a higher matching degree, you can also add other conditions to improve the matching accuracy.
第二次匹配的过程与上述匹配过程一致，若第一清单中正确的待匹配数据与第二清单中的汇总数据金额的币种相同，并且两者金额的差值的绝对值小于容差参数值，则匹配成功。The second matching process is the same as the above matching process. If the correct data to be matched in the first list is in the same currency as the aggregated data amount in the second list, and the absolute value of the difference between the two amounts is less than the tolerance parameter value, the match is successful.
第三次匹配的过程与上述匹配过程一致，若第一清单中正确的待匹配数据与第二清单中的账单组数据金额的币种相同，并且两者金额的差值的绝对值小于容差参数值，则匹配成功。The third matching process is the same as the above matching process. If the correct data to be matched in the first list is in the same currency as the billing group data in the second list, and the absolute value of the difference between the two amounts is less than the tolerance parameter value, the match is successful.
本实施例中，通过反向参数值和容差参数值可以灵活地调整匹配规则，提高了核对过程的灵活性，同时通过三次核对过程，可以解决第二清单同时包含单笔数据、汇总数据以及账单组数据的情况，合并付款的账单也能汇总匹配成功，适用范围广，同时保证了核对结果的准确性。In this embodiment, the matching rules can be flexibly adjusted through the reverse parameter value and the tolerance parameter value, which improves the flexibility of the checking process. In the case of bill group data, the bills of combined payment can also be successfully aggregated and matched, which is applicable to a wide range and ensures the accuracy of the verification results.
在一个实施例中，获取第一清单及第二清单，并在核对界面显示包括：In one embodiment, acquiring the first list and the second list and displaying them on the verification interface includes:
获取第一用户提供的原始结算清单；Obtain the original settlement list provided by the first user;
对该原始结算清单进行预处理，得到第一清单；Preprocessing the original settlement list to obtain the first list;
在该核对界面显示该第一清单；displaying the first list on the checking interface;
获取查询条件，根据该查询条件从数据库中查询得到第二清单，并在核对界面显示该第二清单，其中该第二清单是指第二用户提供的未结算清单。Obtain query conditions, query the database to obtain a second list according to the query conditions, and display the second list on the checking interface, where the second list refers to an unsettled list provided by the second user.
具体地，当接收到第一用户提供的原始结算清单时，对原始结算清单进行预处理，得到格式规范的第一清单。例如通过邮件接收到第一用户提供的原始结算清单，提取原始结算清单中的币种和金额两列数据，将原始结算清单中币种为RMB的改为CNY，并去掉多余信息。例如将原始结算清单中的汇总信息去除、去掉第一用户的标识(logo、第一用户名称等信息)，加入第一清单属性信息：币种、金额、合同名称、合约分保/临时分保、账户类型、业务年度等类型，其中币种和金额为必须的属性，其他属性可以先不作处理，提高核对效率。Specifically, when the original settlement list provided by the first user is received, the original settlement list is preprocessed to obtain the first list with a format specification. For example, the original settlement list provided by the first user is received by mail, the data in the currency and amount columns in the original settlement list are extracted, the currency in the original settlement list is changed to CNY, and the redundant information is removed. For example, remove the summary information in the original settlement list, remove the first user's logo (logo, first user name and other information), and add the attribute information of the first list: currency, amount, contract name, contract reinsurance/temporary reinsurance , account type, business year and other types, of which currency and amount are required attributes, and other attributes can be left out first to improve verification efficiency.
在核对界面导入第一清单。例如可以将预处理好的第一清单直接拖拽核对界面，并且确认第一清单数据，如图3所示，如果导入正常则可以在核对界面的左半边界面显示第一清单，通过核对界面左边显示的第一清单的行数是否准确、是否有多余的空行、金额和精度导入是都准确、币种是否有歧义(如CNY、RMB)、是否存在不需要的信息误导入核对界面等，信息确认无误后，就可以获取查询条件以获取第二清单。Import the first list in the check interface. For example, you can drag the preprocessed first list directly to the verification interface, and confirm the first list data, as shown in Figure 3, if the import is normal, the first list can be displayed on the left half of the verification interface. Whether the number of lines in the displayed first list is accurate, whether there are extra blank lines, whether the import amount and precision are accurate, whether the currency is ambiguous (such as CNY, RMB), and whether there is any unnecessary information imported into the verification interface by mistake, etc. After the information is confirmed to be correct, the query conditions can be obtained to obtain the second list.
获取核对人员在核对界面上输入的查询条件并将查询条件上传到服务器。服务器数据库中存储第二用户的所有账单信息。服务器根据查询条件和服务器提供的查询服务从数据库中获取与第一清单数据对应的未结算清单，即第二清单，并将第二清单发送给终端，终端接收到第二清单后在核对界面的右半边界面显示第二清单。Obtain the query conditions entered by the checker on the check interface and upload the query conditions to the server. All billing information of the second user is stored in the server database. The server obtains the unsettled list corresponding to the first list data, that is, the second list, from the database according to the query conditions and the query service provided by the server, and sends the second list to the terminal. The right half of the interface displays the second list.
如图4所示，通过开发平台设计本申请所提供的表单核对方法以及SICS所提供的一系列服务。图4还展示了本申请所提供的表单核对方法所使用的一系列核心系统的服务(如SICS Query、Live Desktop、SICS API)、文档云及开发平台，SICS(即核心系统)系列服务为查询第二清单提供了保障，可以通过不同终端设备快速查询得到第二清单，还可以将核对过程生成的文件自动储存在文档云中，以便后续查看。As shown in FIG. 4 , the form checking method provided by this application and a series of services provided by SICS are designed through the development platform. Figure 4 also shows a series of core system services (such as SICS Query, Live Desktop, SICS API), document cloud and development platform used by the form checking method provided by this application. The SICS (ie core system) series of services are query The second list provides a guarantee that the second list can be obtained by quick query through different terminal devices, and the files generated during the verification process can be automatically stored in the document cloud for subsequent viewing.
本实施例中，通过对第一用户提供的原始结算清单的预处理，可以处理不同用户提供的不同格式的结算清单，增强了本申请所提供的表单核对方法的兼容性；服务器通过查询条件缩小查询范围，并使用SICS API提供的查询服务(即SICS Query)获取第二用户提供的未结算清单，查询效率高，同时可以灵活获取需要核对的未结算清单，提高了核对方法的灵活性。In this embodiment, by preprocessing the original settlement list provided by the first user, settlement lists in different formats provided by different users can be processed, which enhances the compatibility of the form checking method provided by this application; Query scope, and use the query service provided by SICS API (ie SICS Query) to obtain the unsettled list provided by the second user, the query efficiency is high, and at the same time, the unsettled list that needs to be checked can be flexibly obtained, which improves the flexibility of the checking method.
在一个实施例中，获取查询条件，包括：In one embodiment, acquiring query conditions includes:
获取对该核对界面上的查询控件的触发操作，根据该查询触发操作显示查询条件字段，该查询条件字段包括账单状态、核销状态、日期区间、币种、或第一用户标识中至少一种，其中，该币种根据第一清单中的币种确定；Obtain the trigger operation of the query control on the verification interface, and display a query condition field according to the query trigger operation, where the query condition field includes at least one of billing status, write-off status, date interval, currency, or the first user ID , where the currency is determined according to the currency in the first list;
获取对该查询条件字段所赋的值，根据该查询条件字段的值得到查询条件。Obtain the value assigned to the query condition field, and obtain the query condition according to the value of the query condition field.
具体地，当获取到核对人员对核对界面上查询控件的触发操作时，显示查询条件字段，查询条件字段包括账单状态、核销状态、日期区间、币种、或第一用户标识中至少一种。其中，第一用户标识可以根据第一清单中用户的ID或者名称来获取并输入，第一用户表示为必要的查询条件。币种不需要输入，币种字段值可以直接根据第一清单中币种信息自动获取并显示在币种字段上。其他字段信息可以由核对人员输入，然后终端获取对查询条件字段所赋的值，得到查询条件。例如为了获取到未结算清单，账单状态必须为close，核销状态为unsettle，日期区间为2020年10月-2020年11月，第一用户标识为1，得到的查询条件为标识为1的第一用户在2020年10月-2020年11月的未结算清单。Specifically, when the triggering operation of the checker on the query control on the check interface is obtained, a query condition field is displayed, and the query condition field includes at least one of billing status, write-off status, date interval, currency, or the first user ID . The first user identifier can be obtained and input according to the ID or name of the user in the first list, and the first user is represented as a necessary query condition. The currency does not need to be entered, and the currency field value can be automatically obtained and displayed on the currency field directly according to the currency information in the first list. Other field information can be input by the checking personnel, and then the terminal obtains the value assigned to the query condition field to obtain the query condition. For example, in order to obtain the unsettled list, the bill status must be close, the write-off status must be unsettled, the date interval is October 2020-November 2020, the first user ID is 1, and the query condition obtained is the first user with
本实施例中，通过获取输入的查询条件，可以根据核对需求调整查询范围，提高核对的灵活性，可以根据多个查询条件获得未结算清单，提高核对的精度。In this embodiment, by acquiring the input query conditions, the query scope can be adjusted according to the verification requirements, the flexibility of the verification can be improved, and the unsettled list can be obtained according to multiple query conditions, and the verification accuracy can be improved.
在一个实施例中，该方法还包括：In one embodiment, the method further includes:
根据该核对结果、第一清单数据量以及第二清单数据量进行计算，得到匹配度；Calculate according to the check result, the data volume of the first list and the data volume of the second list to obtain the matching degree;
若该匹配度小于预设匹配度，则重新显示该查询条件字段，获取对所述查询条件字段所赋的值，根据所述查询条件字段的值得到新的查询条件，进行核对，或者重新显示参数选项框，通过所述参数选项框获取输入的容差参数值以及反向参数值，重新确定匹配规则。If the matching degree is less than the preset matching degree, the query condition field is redisplayed, the value assigned to the query condition field is obtained, a new query condition is obtained according to the value of the query condition field, and the query condition is checked or displayed again. A parameter option box, through which the input tolerance parameter value and reverse parameter value are obtained, and the matching rule is re-determined.
具体地，匹配度包括第一清单匹配度和第二清单匹配度，匹配度的计算方式为匹配成功的数量/总数量。第一清单匹配度为第一清单匹配成功的数量除以第一清单总数据量，第二清单匹配度为第二清单匹配成功的数量除以第二清单总数据量。例如，第一清单导入1000行数据，匹配成功了987行，也就是说987行后面都生成了核对结果ID，则左侧匹配度为98.7％。此时如果第二清单数据是2000条，匹配上了987条，那么第二清单的匹配度就是49.35％。第一清单、第二清单的匹配度可以让用户更好的了解到清单数据的情况和匹配的情况。Specifically, the matching degree includes the matching degree of the first list and the matching degree of the second list, and the calculation method of the matching degree is the number of successful matches/total number. The first list matching degree is the number of successful first list matches divided by the total data volume of the first list, and the second list matching degree is the number of successful second list matching divided by the total data volume of the second list. For example, the first list imports 1000 rows of data, and 987 rows are successfully matched, that is to say, the check result ID is generated after the 987 rows, and the matching degree on the left side is 98.7%. At this time, if the second list data is 2000 and 987 are matched, then the matching degree of the second list is 49.35%. The matching degree of the first list and the second list can allow the user to better understand the situation of the list data and the matching situation.
可以根据第一清单匹配度、第二清单匹配度与预设的匹配度进行对比，若小于预设匹配度，则重新显示参数选项框或者查询条件字段，重新通过参数选项框获取输入的容差参数值以及反向参数值，重新确定匹配规则，然后重新进行核对；或者重新获取对查询条件字段所赋的值，根据查询条件字段的值得到新的查询条件，重新进行核对。重新进行核对时，上一次的核对结果将清空。The matching degree of the first list and the matching degree of the second list can be compared with the preset matching degree. If the matching degree is less than the preset matching degree, the parameter option box or the query condition field will be displayed again, and the input tolerance will be obtained through the parameter option box again. The parameter value and the reverse parameter value, re-determine the matching rule, and then re-check; or re-acquire the value assigned to the query condition field, obtain a new query condition according to the value of the query condition field, and re-check. When re-checking is performed, the previous check result will be cleared.
在一个实施例中，该方法还包括：In one embodiment, the method further includes:
获取对该核对界面上的第一导出控件的触发操作，在该第一清单上加入核对结果ID，并生成第一核对文件；Obtain the trigger operation of the first export control on the verification interface, add the verification result ID to the first list, and generate a first verification file;
获取对该核对界面上的第二导出控件的触发操作，在该第二清单上加入核对结果ID，并生成第二核对文件。The trigger operation of the second export control on the verification interface is acquired, the verification result ID is added to the second list, and a second verification file is generated.
具体地，当获取到核对人员对核对界面上第一导出控件的触发操作，则在第一清单上加入核对结果ID，生成第一核对文件，并将第一核对文件自动储存至文档云，不易丢失。可以将第一核对文件发送给第一用户，以便第一用户查看核对结果。Specifically, when the triggering operation of the checker to check the first export control on the check interface is obtained, the check result ID is added to the first list, the first check file is generated, and the first check file is automatically stored in the document cloud, which is not easy. lost. The first verification file may be sent to the first user, so that the first user can view the verification result.
当获取到核对人员对核对界面上第二导出控件的触发操作，则在第二清单上加入核对结果ID，生成第二核对文件，并将第一核对文件自动储存至文档云，不易丢失。第二核对文件用于第二用户留存及内部对账，以便应对后续将多次核对结果进行汇总，以便后续的核销工作。When the triggering operation of the checker on the second export control on the check interface is obtained, the check result ID is added to the second list, a second check file is generated, and the first check file is automatically stored in the document cloud, which is not easily lost. The second reconciliation file is used for the retention of the second user and the internal reconciliation, so as to summarize the results of subsequent reconciliations for subsequent write-off work.
还可以根据核对界面的创建控件创建核对对象。创建核对对象的时候可以根据币种创建多个核对对象，还可以将一次核对过程中的不同币种的核对对象转换为一个折中的币种创建一个核对对象。由于业务系统的分离，第二用户还包括不同的子用户，创建核对对象的时候每个子公司单独创建一个核对对象，例如中再集团包括中国财产再保险股份有限公司、中国人寿再保险股份有限公司等6家子公司，不同子公司之间的业务都是分离的，需要根据每个子公司创建一个核对对象。核对对象包括第一核对清单、第二清单、核对结果ID、核对时间及匹配度，还包括核对流程编号，可以作为核对系统与核心系统的连接键，以便后续的核销工作，并且做到核对过程可追踪。You can also create a check object according to the creation control of the check interface. When creating a reconciliation object, you can create multiple reconciliation objects according to the currency, and you can also convert the reconciliation objects of different currencies in a reconciliation process into a compromised currency to create a reconciliation object. Due to the separation of business systems, the second user also includes different sub-users. When creating a verification object, each subsidiary creates a separate verification object. For example, China Re Group includes China Property and Casualty Reinsurance Co., Ltd., China Life Reinsurance Co., Ltd., etc. 6 The business of different subsidiaries is separated, and a check object needs to be created according to each subsidiary. The verification objects include the first checklist, the second list, the ID of the verification result, the verification time and the degree of matching, and also the verification process number, which can be used as the connection key between the verification system and the core system, so as to facilitate the subsequent verification and verification. Process can be traced.
本实施例中，通过创建第一核对文件、第一核对文件以及核对对象，并核对文件、核对对象自动储存至文档云，能够做到核对过程的可追踪，方便后续的工作。In this embodiment, by creating a first check file, a first check file, and a check object, and automatically storing the check file and the check object in the document cloud, the checking process can be traced and subsequent work is facilitated.
为了易于理解本申请实施例提供的技术方案，下面结合图5，以完整的表单核对过程对本申请实施例提供的表单核对方法进行简要说明：In order to facilitate the understanding of the technical solutions provided by the embodiments of the present application, the form checking method provided by the embodiments of the present application is briefly described below with reference to FIG. 5 with a complete form checking process:
(1)获取第一用户提供的原始结算清单(即图5中的结算清单)。(1) Obtain the original settlement list provided by the first user (ie, the settlement list in FIG. 5 ).
(2)对所述原始结算清单进行预处理(即图5中清理结算清单)，得到第一清单；在所述核对界面显示所述第一清单(即图5中上传到系统)。(2) Preprocessing the original settlement list (ie, clearing the settlement list in FIG. 5 ) to obtain a first list; displaying the first list on the checking interface (ie, uploading to the system in FIG. 5 ).
(3)获取对所述核对界面上的查询控件的触发操作，根据所述查询触发操作显示查询条件字段，所述查询条件字段包括账单状态、核销状态、日期区间、币种、或第一用户标识中至少一种，其中，所述币种根据第一清单中的币种确定。获取对所述查询条件字段所赋的值，根据所述查询条件字段的值得到查询条件(即图5中查询未结算清单)。根据所述查询条件从数据库中查询得到第二清单，并在核对界面显示所述第二清单，其中所述第二清单是指第二用户提供的未结算清单。(3) Acquire a trigger operation for the query control on the verification interface, and display a query condition field according to the query trigger operation, where the query condition field includes bill status, write-off status, date interval, currency, or first At least one of user identifiers, wherein the currency is determined according to the currency in the first list. The value assigned to the query condition field is obtained, and the query condition is obtained according to the value of the query condition field (ie, the query unsettled list in FIG. 5 ). The second list is obtained by querying the database according to the query condition, and the second list is displayed on the checking interface, wherein the second list refers to the unsettled list provided by the second user.
(4)响应于对所述核对界面上的核对控件的触发操作，显示参数选项框；通过所述参数选项框获取输入的容差参数值以及反向参数值；根据所述容差参数值以及反向参数值得到所述匹配规则(即图5中的触发智能核对)。(4) In response to the triggering operation on the checking control on the checking interface, a parameter option box is displayed; the input tolerance parameter value and reverse parameter value are obtained through the parameter option box; according to the tolerance parameter value and The inverse parameter value obtains the matching rule (ie, the trigger smart check in FIG. 5 ).
(5)依次获取第一清单中的一条待匹配数据，根据匹配规则将所述待匹配数据与第二清单中的每一条数据进行逐一匹配(即图5中的逐账单匹配过程)，若匹配成功，则对所述待匹配数据和第二清单中的匹配数据进行第一次标记。(5) Acquire a piece of data to be matched in the first list in turn, and match the data to be matched with each piece of data in the second list one by one according to the matching rule (that is, the bill-by-bill matching process in FIG. 5 ). If successful, mark the data to be matched and the matched data in the second list for the first time.
(6)将所述第二清单中账单号相同的至少一条数据进行汇总，得到汇总数据；根据匹配规则依次将所述第一清单中的待匹配数据与所述第二清单中的汇总数据进行匹配(即图5中的Balance匹配过程)，若匹配成功，对所述待匹配数据与第二清单中汇总数据的每一条数据进行第二次标记。(6) Aggregate at least one piece of data with the same bill number in the second list to obtain aggregated data; sequentially perform matching between the to-be-matched data in the first list and the aggregated data in the second list according to matching rules Matching (ie, the Balance matching process in FIG. 5 ), if the matching is successful, the data to be matched and each piece of aggregated data in the second list are marked a second time.
(7)将所述第二清单中账单组号相同的至少一条汇总数据进行汇总，得到账单组数据；根据匹配规则将所述第一清单中的每一条记录与第二清单中的账单组数据进行匹配(即图5中的Claim组匹配过程)，若匹配成功，对所述待匹配数据与第二清单中账单组数据的每一条数据进行第三次标记，得到所述第一清单和所述第二清单的核对结果。(7) Summarize at least one piece of summary data with the same billing group number in the second list to obtain billing group data; compare each record in the first list with the billing group data in the second list according to the matching rule Carry out matching (that is, the claim group matching process in FIG. 5 ), if the matching is successful, mark the data to be matched and each piece of billing group data in the second list for the third time to obtain the first list and all the data. Check the results of the second checklist.
(8)根据所述核对结果、第一清单数据量以及第二清单数据量进行计算，得到匹配度(即生成匹配结果过程)；若所述匹配度小于预设匹配度，则重新显示所述查询条件字段，获取对所述查询条件字段所赋的值，根据所述查询条件字段的值得到新的查询条件，进行核对，或者重新显示参数选项框，通过所述参数选项框获取输入的容差参数值以及反向参数值，重新确定匹配规则。(8) Calculate according to the check result, the data volume of the first list and the data volume of the second list to obtain a matching degree (ie, the process of generating a matching result); if the matching degree is less than a preset matching degree, redisplay the matching degree Query the condition field, obtain the value assigned to the query condition field, obtain a new query condition according to the value of the query condition field, check it, or redisplay the parameter option box, and obtain the input content through the parameter option box. The difference parameter value and the reverse parameter value are used to re-determine the matching rule.
(9)获取对所述核对界面上的第一导出控件的触发操作，在所述第一清单上加入核对结果ID，并生成第一核对文件(即导出对方结果文件)；获取对所述核对界面上的第二导出控件的触发操作，在所述第二清单上加入核对结果ID，并生成第二核对文件(即导出我方结果文件)；还可以生成核对对象(即生成SBG对象，Settlement Balance Group对象)。(9) Obtain the triggering operation for the first export control on the check interface, add the check result ID to the first list, and generate a first check file (ie, export the counterparty result file); obtain the check result The trigger operation of the second export control on the interface, add the verification result ID on the second list, and generate a second verification file (that is, export our result file); also can generate a verification object (that is, generate an SBG object, Settlement Balance Group object).
应该理解的是，虽然图2、图5的流程图中的各个步骤按照箭头的指示依次显示，但是这些步骤并不是必然按照箭头指示的顺序依次执行。除非本文中有明确的说明，这些步骤的执行并没有严格的顺序限制，这些步骤可以以其它的顺序执行。而且，图2、图5中的至少一部分步骤可以包括多个步骤或者多个阶段，这些步骤或者阶段并不必然是在同一时刻执行完成，而是可以在不同的时刻执行，这些步骤或者阶段的执行顺序也不必然是依次进行，而是可以与其它步骤或者其它步骤中的步骤或者阶段的至少一部分轮流或者交替地执行。It should be understood that although the steps in the flowcharts of FIG. 2 and FIG. 5 are sequentially displayed according to the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless explicitly stated herein, the execution of these steps is not strictly limited to the order, and these steps may be performed in other orders. Moreover, at least a part of the steps in FIG. 2 and FIG. 5 may include multiple steps or multiple stages. These steps or stages are not necessarily executed and completed at the same time, but may be executed at different times. The order of execution is also not necessarily sequential, but may be performed alternately or alternately with other steps or at least a portion of the steps or stages within the other steps.
在一个实施例中，如图6所示，提供了一种表单核对装置，包括：第一匹配模块602、第二匹配模块604和第三匹配模块606，其中：In one embodiment, as shown in FIG. 6, a form checking apparatus is provided, including: a
第一匹配模块602，用于依次获取第一清单中的一条待匹配数据，根据匹配规则将该待匹配数据与第二清单中的每一条数据进行逐一匹配，若匹配成功，则对该待匹配数据和第二清单中的匹配数据进行第一次标记。The
第二匹配模块604，用于将该第二清单中账单号相同的至少一条数据进行汇总，得到汇总数据；根据匹配规则依次将该第一清单中的待匹配数据与该第二清单中的汇总数据进行匹配，若匹配成功，对该待匹配数据与第二清单中汇总数据的每一条数据进行第二次标记。The
第三匹配模块606，用于将该第二清单中账单组号相同的至少一条汇总数据进行汇总，得到账单组数据；根据匹配规则将该第一清单中的每一条记录与第二清单中的账单组数据进行匹配，若匹配成功，对该待匹配数据与第二清单中账单组数据的每一条数据进行第三次标记，得到该第一清单和该第二清单的核对结果。The
在一个实施例中，上述表单核对装置还包括：获取模块和显示模块。In one embodiment, the above-mentioned form checking apparatus further includes: an acquisition module and a display module.
获取模块用于获取第一清单及第二清单，并在核对界面显示；The obtaining module is used to obtain the first list and the second list, and display them on the verification interface;
显示模块用于响应于对该核对界面上的核对控件的触发操作，显示参数选项框；以及通过该参数选项框获取输入的容差参数值以及反向参数值；以及根据该容差参数值以及反向参数值得到该匹配规则。The display module is configured to display a parameter option box in response to a triggering operation of the check control on the check interface; and obtain the input tolerance parameter value and reverse parameter value through the parameter option box; and according to the tolerance parameter value and The reverse parameter value gets the matching rule.
在一个实施例中，第一匹配模块602还用于根据该第一清单的待匹配数据及该反向参数值进行计算，得到正确的待匹配数据；若该正确的待匹配数据与第二清单中的一条数据的绝对差值小于该容差参数值，则匹配成功。In one embodiment, the
在一个实施例中，获取模块包括第一获取单元和第二获取单元，第一获取单元用于获取第一用户提供的原始结算清单；还用于对该原始结算清单进行预处理，得到第一清单；In one embodiment, the obtaining module includes a first obtaining unit and a second obtaining unit, where the first obtaining unit is configured to obtain the original settlement list provided by the first user; and is further configured to preprocess the original settlement list to obtain the first list;
显示模块还用于在该核对界面显示该第一清单；The display module is further configured to display the first list on the verification interface;
第二获取单元用于获取查询条件，根据该查询条件从数据库中查询得到第二清单，并在核对界面显示该第二清单，其中该第二清单是指第二用户提供的未结算清单。The second obtaining unit is configured to obtain query conditions, obtain a second list from the database according to the query conditions, and display the second list on the checking interface, wherein the second list refers to the unsettled list provided by the second user.
在一个实施例中，第二获取单元用于获取对该核对界面上的查询控件的触发操作，根据该查询触发操作显示查询条件字段，该查询条件字段包括账单状态、核销状态、日期区间、币种、或第一用户标识中至少一种，其中，该币种根据第一清单中的币种确定；In one embodiment, the second obtaining unit is configured to obtain a trigger operation of the query control on the verification interface, and display a query condition field according to the query trigger operation, where the query condition field includes bill status, write-off status, date interval, At least one of the currency or the first user identifier, wherein the currency is determined according to the currency in the first list;
以及获取对该查询条件字段所赋的值，根据该查询条件字段的值得到查询条件。and obtain the value assigned to the query condition field, and obtain the query condition according to the value of the query condition field.
在一个实施例中，第三匹配模块606还用于根据该核对结果、第一清单数据量以及第二清单数据量进行计算，得到匹配度；In one embodiment, the
若该匹配度小于预设匹配度，显示模块还用于重新显示该查询条件字段，第二获取单元还用于获取对所述查询条件字段所赋的值，根据所述查询条件字段的值得到新的查询条件，进行核对，或者显示模块还用于重新显示参数选项框，通过所述参数选项框获取输入的容差参数值以及反向参数值，重新确定匹配规则。If the matching degree is less than the preset matching degree, the display module is further configured to redisplay the query condition field, and the second obtaining unit is further configured to obtain the value assigned to the query condition field, which is obtained according to the value of the query condition field The new query condition is checked, or the display module is also used to redisplay the parameter option box, and the input tolerance parameter value and reverse parameter value are obtained through the parameter option box, and the matching rule is re-determined.
在一个实施例中，第一获取单元还用于获取对该核对界面上的第一导出控件的触发操作，在该第一清单上加入核对结果ID，并生成第一核对文件；In one embodiment, the first obtaining unit is further configured to obtain a trigger operation of the first export control on the check interface, add a check result ID to the first list, and generate a first check file;
第二获取单元还用于获取对该核对界面上的第二导出控件的触发操作，在该第二清单上加入核对结果ID，并生成第二核对文件。The second acquiring unit is further configured to acquire the triggering operation of the second export control on the verification interface, add the verification result ID to the second list, and generate a second verification file.
关于表单核对装置的具体限定可以参见上文中对于表单核对方法的限定，在此不再赘述。上述表单核对装置中的各个模块可全部或部分通过软件、硬件及其组合来实现。上述各模块可以硬件形式内嵌于或独立于计算机设备中的处理器中，也可以以软件形式存储于计算机设备中的存储器中，以便于处理器调用执行以上各个模块对应的操作。For specific limitations on the form checking device, reference may be made to the above limitations on the form checking method, which will not be repeated here. Each module in the above-mentioned form checking apparatus may be implemented in whole or in part by software, hardware and combinations thereof. The above modules can be embedded in or independent of the processor in the computer device in the form of hardware, or stored in the memory in the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.
在一个实施例中，提供了一种计算机设备，该计算机设备可以是终端，其内部结构图可以如图7所示。该计算机设备包括通过系统总线连接的处理器、存储器、通信接口、显示屏和输入装置。其中，该计算机设备的处理器用于提供计算和控制能力。该计算机设备的存储器包括非易失性存储介质、内存储器。该非易失性存储介质存储有操作系统和计算机程序。该内存储器为非易失性存储介质中的操作系统和计算机程序的运行提供环境。该计算机设备的通信接口用于与外部的终端进行有线或无线方式的通信，无线方式可通过WIFI、运营商网络、NFC(近场通信)或其他技术实现。该计算机程序被处理器执行时以实现一种表单核对方法。该计算机设备的显示屏可以是液晶显示屏或者电子墨水显示屏，该计算机设备的输入装置可以是显示屏上覆盖的触摸层，也可以是计算机设备外壳上设置的按键、轨迹球或触控板，还可以是外接的键盘、触控板或鼠标等。In one embodiment, a computer device is provided, and the computer device may be a terminal, and its internal structure diagram may be as shown in FIG. 7 . The computer equipment includes a processor, memory, a communication interface, a display screen, and an input device connected by a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium, an internal memory. The nonvolatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the execution of the operating system and computer programs in the non-volatile storage medium. The communication interface of the computer device is used for wired or wireless communication with an external terminal, and the wireless communication can be realized by WIFI, operator network, NFC (Near Field Communication) or other technologies. The computer program, when executed by a processor, implements a form checking method. The display screen of the computer equipment may be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment may be a touch layer covered on the display screen, or a button, a trackball or a touchpad set on the shell of the computer equipment , or an external keyboard, trackpad, or mouse.
本领域技术人员可以理解，图7中示出的结构，仅仅是与本申请方案相关的部分结构的框图，并不构成对本申请方案所应用于其上的计算机设备的限定，具体的计算机设备可以包括比图中所示更多或更少的部件，或者组合某些部件，或者具有不同的部件布置。Those skilled in the art can understand that the structure shown in FIG. 7 is only a block diagram of a partial 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. Include more or fewer components than shown in the figures, or combine certain components, or have a different arrangement of components.
在一个实施例中，还提供了一种计算机设备，包括存储器和处理器，存储器中存储有计算机程序，该处理器执行计算机程序时实现上述各方法实施例中的步骤。In one embodiment, a computer device is also provided, including a memory and a processor, where a computer program is stored in the memory, and the processor implements the steps in the foregoing method embodiments when the processor executes the computer program.
在一个实施例中，提供了一种计算机可读存储介质，其上存储有计算机程序，该计算机程序被处理器执行时实现上述各方法实施例中的步骤。In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, implements the steps in the foregoing method embodiments.
本领域普通技术人员可以理解实现上述实施例方法中的全部或部分流程，是可以通过计算机程序来指令相关的硬件来完成，所述的计算机程序可存储于一非易失性计算机可读取存储介质中，该计算机程序在执行时，可包括如上述各方法的实施例的流程。其中，本申请所提供的各实施例中所使用的对存储器、存储、数据库或其它介质的任何引用，均可包括非易失性和易失性存储器中的至少一种。非易失性存储器可包括只读存储器(Read-Only Memory，ROM)、磁带、软盘、闪存或光存储器等。易失性存储器可包括随机存取存储器(Random Access Memory，RAM)或外部高速缓冲存储器。作为说明而非局限，RAM可以是多种形式，比如静态随机存取存储器(Static Random Access Memory，SRAM)或动态随机存取存储器(Dynamic Random Access Memory，DRAM)等。Those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be implemented by instructing relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage In the medium, when the computer program is executed, it may include the processes of the above-mentioned method embodiments. Wherein, any reference to memory, storage, database or other media used in the various embodiments provided in this application may include at least one of non-volatile and volatile memory. The non-volatile memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash memory or optical memory, and the like. Volatile memory may include random access memory (RAM) or external cache memory. By way of illustration and not limitation, the RAM may be in various forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM).
以上实施例的各技术特征可以进行任意的组合，为使描述简洁，未对上述实施例中的各个技术特征所有可能的组合都进行描述，然而，只要这些技术特征的组合不存在矛盾，都应当认为是本说明书记载的范围。The technical features of the above embodiments can be combined arbitrarily. In order to make the description simple, all possible combinations of the technical features in the above embodiments are not described. However, as long as there is no contradiction in the combination of these technical features It is considered to be the range described in this specification.
以上所述实施例仅表达了本申请的几种实施方式，其描述较为具体和详细，但并不能因此而理解为对发明专利范围的限制。应当指出的是，对于本领域的普通技术人员来说，在不脱离本申请构思的前提下，还可以做出若干变形和改进，这些都属于本申请的保护范围。因此，本申请专利的保护范围应以所附权利要求为准。The above-mentioned embodiments only represent several embodiments of the present application, and the descriptions thereof are specific and detailed, but should not be construed as a limitation on the scope of the invention patent. It should be pointed out that for those skilled in the art, without departing from the concept of the present application, several modifications and improvements can be made, which all belong to the protection scope of the present application. Therefore, the scope of protection of the patent of the present application shall be subject to the appended claims.
Claims (10)
Translated fromChinesePriority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110295312.XACN114897590B (en) | 2021-03-19 | 2021-03-19 | Form verification method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110295312.XACN114897590B (en) | 2021-03-19 | 2021-03-19 | Form verification method, device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114897590Atrue CN114897590A (en) | 2022-08-12 |
| CN114897590B CN114897590B (en) | 2025-01-24 |
Family
ID=82714042
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110295312.XAActiveCN114897590B (en) | 2021-03-19 | 2021-03-19 | Form verification method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114897590B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116012185A (en)* | 2023-03-24 | 2023-04-25 | 北京沐融信息科技股份有限公司 | Method, device, electronic equipment and computer readable storage medium for checking account |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106327317A (en)* | 2015-06-16 | 2017-01-11 | 阿里巴巴集团控股有限公司 | Data verification method and device used for computer system |
| CN108416580A (en)* | 2018-03-09 | 2018-08-17 | 万帮充电设备有限公司 | Account checking method, account checking apparatus and electronic equipment |
| CN109636300A (en)* | 2018-10-16 | 2019-04-16 | 深圳壹账通智能科技有限公司 | Detection method, device, terminal and the computer readable storage medium of bill |
| CN110706105A (en)* | 2019-09-19 | 2020-01-17 | 北京三快在线科技有限公司 | Error marking method, error marking device, computer equipment and storage medium |
- 2021
- 2021-03-19CNCN202110295312.XApatent/CN114897590B/enactiveActive
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106327317A (en)* | 2015-06-16 | 2017-01-11 | 阿里巴巴集团控股有限公司 | Data verification method and device used for computer system |
| CN108416580A (en)* | 2018-03-09 | 2018-08-17 | 万帮充电设备有限公司 | Account checking method, account checking apparatus and electronic equipment |
| CN109636300A (en)* | 2018-10-16 | 2019-04-16 | 深圳壹账通智能科技有限公司 | Detection method, device, terminal and the computer readable storage medium of bill |
| CN110706105A (en)* | 2019-09-19 | 2020-01-17 | 北京三快在线科技有限公司 | Error marking method, error marking device, computer equipment and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 李秀萍: "W公司关联交易对账管理的流程优化研究", 《中国优秀硕士学位论文全文数据库 经济与管理科学辑》, no. 1, 15 January 2020 (2020-01-15), pages 152 - 1969* |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116012185A (en)* | 2023-03-24 | 2023-04-25 | 北京沐融信息科技股份有限公司 | Method, device, electronic equipment and computer readable storage medium for checking account |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114897590B (en) | 2025-01-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11068978B1 (en) | Decentralized systems and methods for managing loans and securities | |
| US20220027988A1 (en) | Methods and apparatus for mortgage loan securitization based upon mortgage servicing stored on blockchain | |
| CN110458562B (en) | Bill reimbursement method, device and equipment and computer storage medium | |
| US10885580B2 (en) | EscrowTab mobile application system and method | |
| US7313540B1 (en) | Electronic communication system and method for facilitating financial transaction bidding and reporting processes | |
| US9213993B2 (en) | Investment, trading and accounting management system | |
| CA2924971A1 (en) | System and method for automatically providing a/r-based lines of credit to businesses | |
| US20140236860A1 (en) | system allowing banks to diversify their loan portfolios via exchanging loans | |
| KR20150110463A (en) | Systems and methods for providing computer-automated adjusting entries | |
| US9811863B1 (en) | Database management system | |
| CN114240611A (en) | Business data accuracy accounting method, device, computer equipment and storage medium | |
| US20130346285A1 (en) | Facilitating Financial Institution Compliance with Foreclosure Laws | |
| CN116342315A (en) | Method and device for clearing up to and from money, computer equipment and storage medium | |
| CN107615325A (en) | Banking system, method, and program for overseas credit management for company financing | |
| US20140143101A1 (en) | Systems, methods and computer program products that facilitate matching of debtor payments to collection authority accounts | |
| CN114897590A (en) | Form checking method, apparatus, computer equipment and storage medium | |
| CN114663206A (en) | Batch account-merging data processing method and device, computer equipment and storage medium | |
| CN107924534A (en) | Banking system, method and program for credit management for structured financing | |
| CN118195759A (en) | Resource flow direction analysis method, device, computer equipment and storage medium | |
| US20220398678A1 (en) | Automated system to facilitate real estate transactions | |
| CN107924535B (en) | Credit management system, method, and storage medium | |
| Chen et al. | The effect of the alternation in the ruling party on three-factor risks and returns in ETF: The case of presidential elections in Taiwan | |
| JP5758948B2 (en) | Electronic record receivable liquidation management system | |
| JP6103792B1 (en) | Accounts receivable evaluation system | |
| US20250173792A1 (en) | Data structure and display system for transforming, cleaning, storing, and displaying performance insights of data for life insurance from multiple issuers including methods thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |