CN113128188A - Bank payroll generation method, device and medium - Google Patents
Bank payroll generation method, device and medium Download PDFInfo
- Publication number
- CN113128188A CN113128188A CN202110474410.XA CN202110474410A CN113128188A CN 113128188 A CN113128188 A CN 113128188A CN 202110474410 A CN202110474410 A CN 202110474410A CN 113128188 A CN113128188 A CN 113128188A
- Authority
- CN
- China
- Prior art keywords
- column
- bank
- filled
- payroll
- enterprise
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/183—Tabulation, i.e. one-dimensional positioning
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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/02—Banking, e.g. interest calculation or account maintenance
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- General Health & Medical Sciences (AREA)
- Finance (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Accounting & Taxation (AREA)
- Health & Medical Sciences (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
A bank payroll generation method is applied to a bank issuing platform and comprises the following steps: receiving an enterprise payroll table, identifying the column names of salary columns in the table, and acquiring the column names of columns to be filled and published to be filled; aiming at the publication to be filled, screening out salary columns with the same characters as the publication to be filled from the enterprise payroll table as first selected columns in a column name matching mode; acquiring the column names of the to-be-selected columns in the enterprise payroll table and the column names of the to-be-filled residual columns in the to-be-filled representative table; receiving selection operation input by an enterprise user for the to-be-filled residual column; selecting operation to generate an association relation table; and filling the contents in the first selected column into columns to be filled with the same column names respectively, and filling the contents in the second selected column into the associated remaining columns to be filled respectively according to the association relation table so as to generate a filled representative table comprising the bank representative information as a bank payroll table, thereby reducing the table making workload of enterprise users.
Description
Technical Field
The invention relates to the field of computer data processing, in particular to a bank payroll generation method, a bank payroll generation device and a bank payroll generation medium.
Background
The enterprise wages are generally sent by a bank, the existing service of sending the bank is to upload a bank wage table file through an internet bank channel or a counter channel of the bank enterprise, and the bank sends the enterprise wages by the bank according to the bank wage table file.
Whether the enterprise internet banking channel or the counter channel is adopted, when the enterprise user uploads the bank payroll file, the uploaded bank payroll file must meet the format required by the bank, and therefore the enterprise user needs to formulate the bank payroll file of the enterprise according to a fixed template of the bank internet banking. Under normal circumstances, the formats of enterprise payroll files and bank payroll files which are manufactured by enterprises and circulated in the enterprises are different, so that enterprise users need to manufacture the enterprise payroll files of the enterprises into the bank payroll files again according to the formats of the bank payroll, and the sheet making workload of enterprise staff is increased.
Disclosure of Invention
In view of the above, the present invention provides a method, an apparatus and a medium for generating a bank payroll.
The invention is realized by the following steps:
the embodiment of the invention provides a bank payroll generation method, which is used for a bank issuing platform and comprises the following steps:
receiving an enterprise payroll uploaded by an enterprise user;
identifying the column names of M columns of compensation in the enterprise payroll table;
acquiring column names of N columns of columns to be filled in a to-be-filled table in a bank issuing platform;
aiming at the to-be-filled publication, screening out a Q-column salary column with the same character as the to-be-filled publication from the enterprise payroll table as a Q-column first selected column in a column name matching mode;
acquiring the column names of M-Q columns to-be-selected columns which are not screened in an enterprise payroll table, and the column names of N-Q columns to-be-filled residual columns of a first selected column which is not screened and has the same column name in the to-be-filled representative table;
receiving selection operation input by an enterprise user for the N-Q column to-be-filled residual column; the selection operation is used for selecting the same to-be-selected column as a second selected column for at least one column of to-be-filled remaining columns;
generating an association relation table according to the selection operation; the incidence relation table represents the incidence relation between the column names of the columns to be filled with the rest and the column names of the second selected columns;
and filling the contents in the first selected column into columns to be filled with the same column names respectively, and filling the contents in the second selected column into the associated remaining columns to be filled respectively according to the association relation table so as to generate a filled-in surrogated table comprising bank surrogated information as a bank payroll table.
In some embodiments, the identifying the column names of the M columns of compensation in the enterprise payroll table comprises:
calculating the proportion of the numbers in the rows of the enterprise payroll table line by line from top to bottom;
determining a behavior characteristic digital line with a first digital proportion exceeding a preset value; and determining the content of the upper adjacent table of the ith table in the initial digital row as the column name of the compensation column of the ith column, wherein i is more than or equal to 1 and less than or equal to M.
In some embodiments, after generating the association relationship table according to the selection operation, the method further includes the following steps:
searching whether the first selected column and the second selected column have abnormal tables or not; the exception table comprises a null value table and a format error table;
if the abnormal form exists, the position of the abnormal form in the enterprise payroll is sent to the enterprise user;
receiving a first correction operation input by an enterprise user aiming at an abnormal form, wherein the first correction operation is used for correcting the abnormal form into a normal form;
and modifying the exception table according to the first correcting operation.
In some embodiments, after generating the association relationship table according to the selection operation, the method further includes the following steps:
acquiring a first total issuing amount and a first total issuing stroke number from the first selected column and the second selected column;
judging whether the first total issuing amount and the first total issuing stroke number are consistent with the received second total issuing amount and the second total issuing stroke number or not;
if the first total issuing amount is inconsistent with the second total issuing amount and/or the first total issuing stroke number is inconsistent with the second total issuing stroke number, sending first reminding information to the enterprise user;
and receiving a second correction operation of the enterprise user for the first reminding information, wherein the second correction operation is used for correcting the first total issuing amount and the second total issuing amount, and the first total issuing number and the second total issuing number to be consistent.
In some embodiments, after generating the association relationship table according to the selection operation, the method further includes the following steps: acquiring employee information from the first selected column and the second selected column; the employee information comprises the number of employees, the identity card numbers of the employees, the mobile phone numbers of the employees and the bank card numbers of the employees;
utilizing an enterprise employee information base of a bank issuing platform to judge whether employee information inconsistent with the enterprise employee information base exists or not;
if the inconsistent employee information exists, the inconsistent employee information is sent to the enterprise user;
receiving a third correction operation input by the enterprise user aiming at the inconsistent employee information; the third correction operation is used for correcting the enterprise employee information base according to the inconsistent employee information;
and updating the enterprise employee information base according to the third correction operation.
In some embodiments, after obtaining employee information from the first selected column and the second selected column,
further comprising the steps of:
judging whether the employee bank card is the bank card or the other bank card according to the employee bank card number;
if the bank card of the employee has the bank card, the contents in the first selected column and the second selected column of all the bank cards are filled into one to-be-filled substitution table to generate the bank substitution table, and the contents in the first selected column and the second selected column of all the bank cards are filled into the other to-be-filled substitution table to generate the bank substitution table.
In some embodiments, after obtaining the employee information from the first selected column and the second selected column, the method further includes the following steps:
judging whether a bank card with the real issued amount exceeding the transaction limit exists;
if yes, then verifying whether the excess other bank card exists in the bank card exceeding the transaction limit;
if the excess other bank card exists, splitting the real issued amount of the excess other bank card into F sub real issued amounts; the sub real sum is not more than the transaction limit corresponding to the excess other bank card;
splitting the row where the excess other row cards are located in the first selected middle column and the second selected middle column into F rows to obtain the split first selected middle column and the split second selected middle column; and the real issuing amount in the row F is the sub real issuing amount of the pen F.
In some embodiments, after obtaining the employee information from the first selected column and the second selected column, the method further includes the following steps:
sending the employee name, the employee mobile phone number, the employee identification number and the employee bank card number in the employee information to a bank card authentication platform for bank card authentication;
when generating the bank card payroll, acquiring the bank card authentication result from the bank card authentication platform in real time;
if the authentication result is that abnormal employee information exists, sending the abnormal employee information to the enterprise user;
receiving a fourth correction operation input by the enterprise user aiming at the inconsistent employee information; the fourth correction operation is used for correcting the employee information aiming at the abnormal employee information;
and correcting the employee information according to the fourth correction operation.
The embodiment of the invention also provides a bank payroll generating device, which comprises:
the first receiving module is used for receiving an enterprise payroll uploaded by an enterprise user;
the identification module is used for identifying the column names of M columns of compensation columns in the enterprise payroll table;
the first acquisition module is used for acquiring the column names of N columns of columns to be filled in the table to be filled;
the screening module is used for screening out a Q-column salary column which has the same character as the to-be-filled published list from the enterprise payroll table as a Q-column first selected column according to a column name matching mode aiming at the to-be-filled published list;
the second acquisition module is used for acquiring the column names of M-Q columns to-be-selected columns which are not screened in the enterprise payroll table and the column names of N-Q columns to-be-filled residual columns of the first selected columns which are not screened and have the same column names in the to-be-filled list;
the second receiving module is used for receiving the selection operation input by the enterprise user aiming at the N-Q column to-be-filled residual column; the selection operation is used for selecting the same to-be-selected column as a second selected column for at least one column of to-be-filled remaining columns;
the generating module is used for generating an association relation table according to the selection operation; the incidence relation table represents the incidence relation between the column names of the columns to be filled with the rest and the column names of the second selected columns;
and the filling module is used for respectively filling the contents in the first selected column into the columns to be filled with the same column names, and respectively filling the contents in the second selected column into the associated remaining columns to be filled according to the association relation table so as to generate a filled representative table comprising the bank representative information.
Embodiments of the present invention also provide a computer-readable storage medium having stored thereon a computer program, which, when executed by a processor, performs the steps of the bank payroll generation method.
The invention has the following beneficial effects: enterprise users can name each salary column according to the tabulation habit of an enterprise, after the bank issuing platform identifies the received salary columns in the enterprise payroll table, the salary columns in the enterprise payroll table are associated with the columns to be filled and issued which are required by pointing to the bank issuing platform, the users do not need to make the payroll table according to a template of the bank payroll table, the enterprise payroll table files of the enterprise can be directly uploaded to generate the required bank payroll table, the enterprise payroll table file uploading efficiency of enterprise finance or personnel can be greatly improved, and the complex workload generated by making the payroll table files is reduced.
Furthermore, the invention also carries out one or more of employee information verification, abnormal form verification, total amount of the generation and total stroke number verification in the uploaded enterprise payroll table, and displays the verification result to the enterprise user for the enterprise user to confirm and modify one by one, thereby avoiding the problems of failure of the distribution caused by mistaken distribution, mistaken distribution and information change, and greatly improving the success rate of the generation and the working efficiency of enterprise salary managers.
Furthermore, the invention also respectively generates the generation table of the bank and the generation tables of other banks, so that the bank can send the salary to the bank cards of other banks, the problem that financial staff need to make different bank salary tables aiming at different banks is solved, the financial staff does not need to go to the enterprise internet bank of different banks or to the operation network points of different banks to upload the enterprise salary tables, the tabulation workload of the financial staff is further reduced, and the uploading efficiency of enterprise salary table files is improved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present invention and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained according to the drawings without inventive efforts.
Fig. 1 is a flowchart of a method for generating a bank payroll according to an embodiment of the present invention;
FIG. 2 is a flowchart of a method for identifying column names of M columns of compensation in an enterprise payroll table according to an embodiment of the present invention;
FIG. 3 is a flowchart of a method for checking the exception table in the first selected column and the second selected column according to an embodiment of the present invention;
FIG. 4 is a flowchart of a method for checking the total amount and total strokes in the first selected column and the second selected column according to an embodiment of the present invention;
FIG. 5 is a flowchart of a method for verifying employee information according to an embodiment of the present invention;
fig. 6 is a flowchart of a method for splitting according to a bank to which a bank card belongs according to an embodiment of the present invention;
FIG. 7 is a flow chart of a method for verifying the transaction limits of his bank card according to an embodiment of the present invention;
fig. 8 is a flowchart of a bank card authentication method according to an embodiment of the present invention;
fig. 9 is a schematic structural diagram of a bank payroll generation apparatus according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. The components of embodiments of the present invention generally described and illustrated in the figures herein may be arranged and designed in a wide variety of different configurations.
Thus, the following detailed description of the embodiments of the present invention, presented in the figures, is not intended to limit the scope of the invention, as claimed, but is merely representative of selected embodiments of the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
In the description of the present invention, it should be noted that the terms "first", "second", and the like are used for distinguishing between the descriptions and are not to be construed as indicating or implying relative importance.
Some embodiments of the invention are described in detail below with reference to the accompanying drawings. The embodiments described below and the features of the embodiments can be combined with each other without conflict.
The enterprise worksheet made by enterprise user statistics of the enterprise wage detail contains a large amount of information, which usually comprises the information of conventional salary types such as name, telephone number, bank card number, identification card number, actual payment amount, five insurance one fee, special additional deduction, personal income tax and the like; the respective regulations of enterprises are different, therefore, enterprise payroll tables often also include various information of individual salary types, such as secret fees, deduction amounts, employee rewards, and the like.
Furthermore, according to the respective requirements of the enterprises, the information of the conventional salary types such as name, telephone number, bank card number, identification number, real amount, five insurance one fee, special additional deduction, personal income tax, etc. also usually has a plurality of naming modes, for example, the name may be named as employee, the telephone number may be named as contact, the bank card number may be named as account, etc.
The bank issuance table required by the bank issuance system for issuing wages is often different from the enterprise wage table made by enterprise users. Firstly, the bank issuing-substituting platform only needs to complete the amount issuing according to the actual issued amount, and various payroll details related to the actual issued amount are not needed, so that the number of items in the bank issuing-substituting table is far less than that of the enterprise payroll table. Second, the column names of the columns in the bank representative table header may not be the same as the column names of the same columns in the enterprise payroll table. If the enterprise payroll is directly uploaded to the bank issuing platform, the bank issuing platform needs to identify a large amount of irrelevant information, computing resources are wasted, and if the bank issuing platform is different from a certain list of names in the enterprise payroll, the identification of the bank issuing platform fails, and the payroll cannot be normally issued.
In order to normally and efficiently issue wages, in the prior art, a bank issuing platform only receives an enterprise wage table with the same file format as that of a bank issuing platform. Therefore, after the enterprise user counts the salary table of the enterprise, the enterprise user needs to make a bank issue again according to the file format requirement of the enterprise internet bank or counter bank issue, and the work load of the enterprise staff for making the table is increased.
In view of the above problems, the present inventors consider that the following bank payroll generation method can be adopted to solve the problem, and as shown in fig. 1, the bank payroll generation method includes the following steps:
s101, receiving an enterprise payroll uploaded by an enterprise user;
s102, identifying the column names of M columns of compensation columns in the enterprise payroll table;
s103, acquiring column names of N columns of columns to be filled in a to-be-filled table in a bank issuing platform;
s104, aiming at the to-be-filled publication, screening out a Q-column salary column with the same character as the to-be-filled publication from the enterprise payroll table as a Q-column first selected column in a column name matching mode;
s105, acquiring the column names of M-Q columns to-be-selected columns which are not screened in the enterprise payroll table, and the column names of N-Q columns to-be-filled residual columns of a first selected column which is the same as the screened column names in the to-be-filled representative table;
s106, receiving selection operation input by an enterprise user for the N-Q column to-be-filled residual column; the selection operation is used for selecting the same to-be-selected column as a second selected column for at least one column of to-be-filled remaining columns;
s107, generating an association relation table according to the selection operation; the incidence relation table represents the incidence relation between the column names of the columns to be filled with the rest and the column names of the second selected columns;
and S108, filling the contents in the first selected column into columns to be filled with the same column names respectively, and filling the contents in the second selected column into associated remaining columns to be filled respectively according to the association relation table so as to generate a filled representative table comprising bank representative information as a bank payroll table.
The enterprise payroll table in step S101 includes a header representing the type of compensation in the corresponding column, and the header has various forms, for example, a single header, multiple headers, and the like.
The following table i specifically shows the enterprise payroll table in step S101, and the table i is only used to specifically describe the technical solution of the present invention, and does not represent a real enterprise payroll table.
TABLE 1
In step S102, the list names of the salary columns represent the salary types of the columns, taking table one as an example, the list names identified in step S102 are the names, employee codes, contact ways, bank card numbers, identification card numbers, actual payment amounts, basic salaries, performance salaries, overtime salaries, bonus, allowance subsidies and salary sums respectively;
the table ii below specifically shows the table to be filled in step S103.
TABLE 2
The column names of the N columns to be filled read in step S103 are name, employee number, telephone number, bank card number, identification number, and actual amount.
The column names in the step S104 are matched, the column names in the enterprise payroll table are the name, employee code, contact, bank card number, identification number, actual payment amount, basic payroll, performance payroll, overtime payroll, bonus, allowance and payroll sum, and the column name, employee number, telephone number, bank card number, identification number and actual payment amount in the to-be-filled-in-place-and-send-out table are compared one by one, the column name, employee number, bank card number, identification number and actual payment amount in the to-be-filled-in-place-and-send-out table can find the payroll column with the same character, and the column corresponding to the name, employee number, bank card number, identification number and actual payment amount in the enterprise payroll table is the first selected column.
In step S105, the column names of the columns to be selected in the enterprise payroll table are the total of contact information, basic payroll, performance payroll, overtime payroll, bonus, allowance and payroll; the column names of the remaining columns to be filled are telephone numbers.
In step S106, receiving the operation that the enterprise user selects the contact way in the column to be selected as the column which is the same as the telephone number column in the remaining column to be filled;
in step S107, an association table of telephone numbers and contact addresses is generated.
In step S108, filling a first selected column (name, employee number, bank card number, identity card number and actual amount) in the enterprise wage table into columns with names, employee numbers, bank card numbers, identity card numbers and actual amount of columns to be filled and published respectively; and filling the column with the column name as the contact way in the enterprise payroll table into the column with the column name as the telephone number in the to-be-filled representative table so as to generate the enterprise payroll table.
Although the bank issuing-replacing platform requires that the enterprise payroll table must contain five information of name, actual issued amount, mobile phone number, bank card number and identification card number, the enterprise payroll table is not limited to be named according to the platform requirement. The user can name each salary column according to the tabulation habit of the enterprise, and after the bank issuing platform identifies the salary columns in the enterprise payroll table during uploading, the salary columns in the enterprise payroll table are associated with the to-be-filled issuing columns which point to the requirement of the bank issuing platform, so that file information can be normally identified and issuing can be completed on the premise of not changing the tabulation habit of the enterprise.
Therefore, the invention does not need the user to make the payroll according to the template of the bank payroll, can directly upload the enterprise payroll file of the enterprise and generate the required bank payroll, can greatly improve the uploading efficiency of the payroll file of the financial or personnel of the enterprise, and reduce the complex workload generated by making the payroll file.
Specifically, as shown in fig. 2, a specific implementation form of the step S102 of identifying the column names of M columns of compensation in the enterprise payroll table includes the following steps:
s1021, calculating the proportion of the numbers in the rows of the enterprise payroll line by line from top to bottom;
s1022, determining the behavior characteristic digital line with the first digital proportion exceeding a preset value;
s1023, determining the content of the upper adjacent table of the ith table in the initial number row as the column name of the ith compensation column, wherein i is more than or equal to 1 and less than or equal to M.
As can be seen from the table one, because the headers are divided into a single header and a plurality of headers, the column names of the salary columns in the enterprise payroll table are distributed in different rows, which cannot be realized simply by reading the contents of a certain column of tables in a certain row, the headers of the enterprise payroll table generally use characters to represent the types of salaries, and the detailed salary details of the enterprise payroll table have a large number of numbers, so that the headers and the detailed salary details can be distinguished by the ratio of the numbers in each row of tables in the enterprise payroll table. The ratio of numbers may be the ratio of the total bytes in each row occupied by the number.
Step S1022 determines the first digit row according to the difference between the digit ratios in the two adjacent rows of tables, specifically, in the two adjacent rows of tables, if the difference between the digit ratio in the downlink table and the digit ratio in the uplink table is greater than the set threshold, it is determined that the downlink table is the first digit row.
After generating the association table according to the selection operation and before generating the bank payroll table, as shown in fig. 3, the abnormal tables of the first selected column and the second selected column need to be checked, which specifically includes the following steps:
s201, searching whether an abnormal table exists in the first selected column and the second selected column; the exception table comprises a null value table and a format error table;
s202, if the abnormal form exists, sending the position of the abnormal form in the enterprise payroll to an enterprise user;
s203, receiving a first correcting operation input by an enterprise user aiming at the abnormal form, wherein the first correcting operation is used for correcting the abnormal form into a normal form;
and S204, modifying the exception table according to the first correction operation.
After the abnormal form is corrected, step S108 is performed to generate a filled-in substitute form as a bank payroll.
Otherwise, if there is no abnormal table, step S108 is performed to generate the filled-in surrogated table as the bank payroll table.
The abnormal form verification can verify the abnormal form to be filled in the to-be-filled surrogated table before the bank payroll table is generated, so that enterprise payroll generation failure caused by generation of an unqualified bank payroll table is prevented, and meanwhile, the position of the abnormal form is sent to a client to remind the client, and the client can conveniently perform first correction operation.
In step S201, whether the first selected column and the second selected column have an abnormal table is found by traversing all the first selected column and the second selected column.
Specifically, in the embodiment, when the format error table is searched, the content format in each column of the table is compared with the preset format in the column, and if the content format is inconsistent with the preset format in the column, the content format is determined to be the format error table. For example, the format of the contents for sending the wage should be numbers, and no Chinese characters or letters should appear, if the format of a certain table in the column is numbers, the table is determined to be a wrong-format table, and the position (the row and the column) of the table in the wage table of the enterprise is sent to the client to remind the enterprise user.
When needing to be noticed, whether the null value table and the format error table exist in the first selected column and the second selected column is checked, the checking can be carried out simultaneously or step by step, whether the null value table exists is searched firstly when the step is carried out, and if the null value table exists, the position of the null value table in the enterprise payroll table is sent to a client; then receiving a first correction operation input by an enterprise user aiming at the null value table, and modifying the null value table into a normal table according to the first correction operation; then searching whether a format error table exists, if so, sending the position of the format error table in the enterprise payroll table to the client; and then receiving a first correction operation input by the enterprise user aiming at the format error table, and modifying the format error table into a normal table according to the first correction operation. Or the order of the two tests may be reversed.
The first correcting operation has various modes, such as directly correcting the content of the abnormal form in the bank issuing platform, or correcting the content of the abnormal form in the enterprise payroll and uploading the enterprise payroll to the bank issuing platform again.
Preferably, the enterprise payroll is uploaded to the bank delivery platform again, and the situation that the enterprise payroll local to the enterprise user is forgotten to be modified is prevented.
After the association table is generated according to the selection operation and before the bank payroll table is generated, as shown in fig. 4, the total amount and the total number of strokes of the first selected column and the second selected column need to be checked, which specifically comprises the following steps:
s301, acquiring a first total issuing amount and a first total issuing stroke number from the first selected column and the second selected column;
s302, judging whether the first total issuing amount and the first total issuing stroke number are consistent with the received second total issuing amount and the second total issuing stroke number or not;
s303, if the first total amount of issuance is inconsistent with the second total amount of issuance and/or the first total number of issuance is inconsistent with the second total number of issuance, sending a first reminding message to the enterprise user;
s304, receiving a second correction operation of the enterprise user for the first reminding information, wherein the second correction operation is used for correcting the first total issuing amount and the second total issuing amount, and the first total issuing number and the second total issuing number to be consistent;
after S304, step S108 is performed to generate the filled-in surrogated table as the bank payroll table.
Otherwise, if the first total amount of issuance is consistent with the second total amount of issuance, and the first total number of issuance is consistent with the second total number of issuance, step S108 is performed to generate the filled-up issuance table as the bank payroll table.
The second correction operation has various modes, such as directly correcting the content of specific error amount or number in the bank issuing platform, or correcting the amount or number of the enterprise payroll, and uploading the enterprise payroll to the bank issuing platform again.
Preferably, the enterprise payroll is uploaded to the bank delivery platform again, and the situation that the enterprise payroll local to the enterprise user is forgotten to be modified is prevented.
In this embodiment, specifically, the first total issuing amount and the first total issuing stroke number are obtained from the first selected column and the second selected column. The method comprises the steps of obtaining a first generation total amount by calculating the sum of actual sending amounts in a first selected column and a second selected column, calculating the proportion of numbers in the first selected column and the second selected column or in each row of an enterprise wage table, determining a row with the proportion of the numbers exceeding a preset value as one stroke, and traversing the first selected column and the second selected column row by row to obtain the total stroke number.
Alternatively, the first total amount and the first total number of issues may be obtained from the received enterprise payroll table. The first generation total amount is obtained by calculating the sum of the actual total amount in the enterprise payroll table, the proportion of the number in each row in the enterprise payroll table is calculated, the row with the proportion of the number exceeding the preset value is one stroke, and the enterprise payroll table is traversed line by line to obtain the total stroke number.
And checking the total amount and the total number of the money in the first selected column and the second selected column before generating the bank payroll table, so as to prevent payroll issuing errors, and simultaneously sending first reminding information to the client to remind the client.
After the association relation table is generated according to the selection operation and before the bank payroll table is generated, as shown in fig. 5, the employee information needs to be checked, which specifically comprises the following steps:
s401, acquiring employee information from the first selected column and the second selected column; the employee information comprises the number of employees, the identity card numbers of the employees, the mobile phone numbers of the employees and the bank card numbers of the employees;
s402, judging whether staff information inconsistent with the enterprise staff information base exists or not by utilizing the enterprise staff information base of the bank issuing platform;
s403, if the inconsistent employee information exists, sending the inconsistent employee information to the enterprise user;
s404, receiving a third correction operation input by the enterprise user aiming at the inconsistent employee information; the third correction operation is used for correcting the enterprise employee information base according to the inconsistent employee information;
and S405, updating the enterprise employee information base according to the third correction operation.
After the employee information base of the enterprise is updated according to the third correction operation, step S108 is performed to generate a filled-in surrogated table as a bank payroll table.
If the enterprise user chooses not to update the employee information base of the enterprise, the filled-in surrogated list is directly generated as the bank payroll after step S403.
Specifically, the step S402 of determining whether employee information inconsistent with the employee information base of the enterprise exists by using the employee information base of the enterprise of the bank agent platform includes determining whether a new employee exists, determining whether a mobile phone number of each employee is consistent with the employee information base of the enterprise, and determining whether a bank card number of each employee is consistent with the employee information base of the enterprise;
if the new employee, the inconsistent employee mobile phone number or the inconsistent employee bank card number exists, the inconsistent employee information is sent to the client, so that the enterprise user can confirm whether the employee information is correct one by one, and if the employee information is incorrect, the employee information can be modified.
The enterprise user may determine to update the enterprise employee information base according to the inconsistent employee information sent to the client, and if it is determined to update the enterprise employee information base, proceed to steps S404 and S405.
The third correction operation may be to select all the newly added employee information, all the inconsistent employee mobile phone numbers, and all the inconsistent employee bank card numbers, and update the inconsistent employee information to the enterprise employee database in batch.
The bank issuing-instead platform verifies the employee information in the enterprise payroll uploaded at this time one by one through an enterprise employee information base, and verifies whether a new employee exists in the enterprise payroll file or whether key information such as an employee mobile phone number or a bank card number changes. Through the series of verification, the verification result is displayed to the enterprise users for the enterprise users to confirm one by one, so that the problems of salary failure and the like caused by mistaken distribution, mistaken distribution and information change are avoided, and the success rate of generation and the working efficiency of enterprise salary management personnel are greatly improved.
After acquiring the employee information from the first selected column and the second selected column, splitting the employee information according to the bank to which the bank card belongs, as shown in fig. 6, specifically including the following steps:
s501, judging whether the employee bank card is the bank card or the other bank card according to the employee bank card number;
s502, if the bank card of the employee has the bank card, filling the contents in the first selected column and the second selected column of all the bank cards into one to-be-filled representative table to generate the bank representative table, and filling the contents in the first selected column and the second selected column of all the bank cards into the other to-be-filled representative table to generate the bank representative table.
The representative table of the bank and the representative tables of other banks are all one kind of bank payroll table.
Table three is a present row representation table generated from the first selected column and the second selected column.
Table four is his row representative table generated from the first selected column and the second selected column.
TABLE 3
TABLE 4
Meanwhile, the enterprise payroll table is also split into the enterprise payroll table of the current bank and the enterprise payroll tables of other banks for reference of enterprise users.
And the fifth table is the enterprise payroll table of the current row generated by splitting the enterprise payroll table.
And the sixth table is the enterprise payroll of other rows generated by splitting the enterprise payroll.
TABLE 5
TABLE 6
The bank sends the payroll of the bank and the payroll of other bank according to the generation table of the bank and the generation table of other bank.
If no other bank card exists, step S108 is directly performed, in which the contents in the first selected column are respectively filled into columns to be filled with the same column name, and the contents in the second selected column are respectively filled into the associated remaining columns to be filled according to the association relation table, so as to generate a filled-in delivery table including the bank delivery information.
The bank issuing-substituting platform carries out card bin verification on employee bank card numbers in the uploaded enterprise pay table file, if the uploaded file contains the bank card and other bank cards, the bank cards are identified one by one, and the bank card file and the other bank card file are generated respectively, so that different in-bank payment channels can be conveniently sent during issuing.
After obtaining the employee information from the first selected column and the second selected column, the verification of the transaction limit of the other bank card is performed, as shown in fig. 7, which specifically includes the following steps:
s601, judging whether a bank card with real issued amount exceeding a transaction limit exists;
s602, if the bank card exceeds the transaction limit, verifying whether the excess bank card exists in the bank card;
s603, if the excess other bank card exists, splitting the real issuing amount of the excess other bank card into F sub real issuing amounts; the sub real sum is not more than the transaction limit corresponding to the excess other bank card;
s604, splitting the row where the excess other row cards in the first selected middle column and the second selected middle column are located into F rows to obtain the split first selected middle column and the split second selected middle column; and the real issuing amount in the row F is the sub real issuing amount of the pen F.
Meanwhile, in the row F, the contents of the other columns are the same as those of the first selected column and the second selected column except for other actual issued money.
And respectively filling the contents in the split first selected column into columns to be filled with the same column names, and respectively filling the contents in the split second selected column into associated remaining columns to be filled according to the association relation table so as to generate a filled representative table comprising bank representative information as a bank payroll table.
The BIN numbers of the bank cards represent different bank and bank card grades, and the transaction limit of the bank cards is determined by the bank and bank card grade of the bank cards. Therefore, specifically, in step S602, it is verified whether an excess other bank card exists in the bank card exceeding the transaction limit according to the bin data of the bank card; it should be noted that, in the ordinary course of performing the other-line identification and transaction limit verification, the card number in each payroll in the file is judged one by one according to thousands of bin data in the system, and then whether the card number exceeds the transaction limit is verified against the record of the other-line card, and this course often encounters the situation that the verification time of tens of thousands of details is too long.
Therefore, the method for verifying the transaction limit of other bank cards in the embodiment adjusts the verification strategy: and preferentially verifying whether the real amount in all payroll exceeds the transaction limit, and if so, verifying whether an excess other bank card exists according to the bin data.
Generally, the number of other bank cards exceeding the transaction limit is small, so that the time for verifying whether other bank cards exceed the limit by the bin data is greatly shortened, the verification method provided by the embodiment greatly improves the verification efficiency of the other bank cards and the transaction limit, and reduces the waiting time of enterprise users in the process of generating the enterprise payroll table.
And verifying whether the amount of the generation and issue recorded by the other bank card exceeds the transaction limit of the corresponding bank or the internal generation and issue channel, and if the amount of the generation and issue recorded by the other bank card exceeds the transaction limit, the transaction is possibly failed, so that the other bank card is divided into a plurality of transactions according to the transaction limit, and the transaction success rate of the other bank card is improved.
The bank issuing-instead platform can send reminding information for reminding a user of the existence of the excess bank card to the customer, and the user determines whether to split the excess amount. If the user inputs splitting operation to a bank issuing-substituting platform, splitting the real issuing amount of the excess other bank card into a plurality of sub-real issuing amounts; the sub real sum is not more than the transaction limit corresponding to the excess other bank card; otherwise, the splitting is not carried out. Preferably, after obtaining the employee information from the first selected column and the second selected column, the bank card authentication is further performed, as shown in fig. 8, where the bank card authentication includes the following steps:
s701, sending the employee name, the employee mobile phone number, the employee identity card number and the employee bank card number in the employee information to a bank card authentication platform to authenticate the bank card;
s702, when a bank card payroll table is generated, acquiring a bank card authentication result from a bank card authentication platform in real time;
s703, if the authentication result indicates that abnormal employee information exists, sending the abnormal employee information to the enterprise user;
s704, receiving a fourth correction operation input by the enterprise user aiming at the inconsistent employee information; the fourth correction operation is used for correcting the employee information aiming at the abnormal employee information;
and S705, correcting the employee information according to the fourth correction operation.
The bank card authentication is a verification service consisting of a bank card number plus (name plus identity card number plus bank reserved mobile phone number), and is used for verifying whether the employee information is correct or not and preventing the failure of wage issuing. The authentication mode of the bank card mainly comprises two-factor authentication of the bank card, three-factor authentication of the bank card and four-factor authentication of the bank card, and no matter what authentication mode is adopted, the bank card number is necessary, and the name, the identity card number and the bank reserved mobile phone number are different during authentication.
In this embodiment, the bank card authentication calculation amount is large, the time consumption is high, and after the employee information is acquired from the first selected column and the second selected column, the bank card authentication is performed in an asynchronous processing mode, that is, in the process of performing the method for checking the abnormal tables, the total amount and the total number of strokes in the first selected column and the second selected column, the method for checking the employee information, the method for performing the splitting according to the bank to which the bank card belongs, and the verification of the transaction limit of the bank card, the bank card authentication is performed at the same time, so that the serial waiting time of the enterprise user can be reduced.
In an embodiment, a bank payroll generating apparatus as shown in fig. 9 is further provided, which includes a first receiving module 801, configured to receive an enterprise payroll uploaded by an enterprise user;
an identifying module 802, for identifying the column names of M columns of compensation in the enterprise payroll table;
a first obtaining module 803, configured to obtain column names of N columns of columns to be filled in the table to be filled;
the screening module 804 is used for screening out a Q-column salary column which has the same character as the to-be-filled published list from the enterprise payroll table as a Q-column first selected column according to a column name matching mode aiming at the to-be-filled published list;
a second obtaining module 805, configured to obtain column names of M-Q columns to-be-selected columns that are not screened out in the enterprise payroll table, and column names of N-Q columns to-be-filled remaining columns of the first selected column that are not screened out in the to-be-filled list;
a second receiving module 806, configured to receive a selection operation input by an enterprise user for the N-Q columns to be filled with the remaining columns; the selection operation is used for selecting the same to-be-selected column as a second selected column for at least one column of to-be-filled remaining columns;
a generating module 807 for generating an association table according to the selection operation; the incidence relation table represents the incidence relation between the column names of the columns to be filled with the rest and the column names of the second selected columns;
the filling module 808 is configured to fill the content in the first selected column into to-be-filled columns with the same column name, and fill the content in the second selected column into the associated to-be-filled remaining columns according to the association relation table, so as to generate a filled representative table including the bank representative information.
The present embodiment also provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the bank payroll generation method as described.
Specifically, the storage medium can be a general-purpose storage medium such as a removable disk, a hard disk, or the like, and when a computer program on the storage medium is executed, the above-described dialogue sentence determination method can be executed, so that the accuracy of determining the first pair of dialogue sentences can be improved.
Finally, it should be noted that: the above examples are only specific embodiments of the present application, and are not intended to limit the technical solutions of the present application, and the scope of the present application is not limited thereto, although the present application is described in detail with reference to the foregoing examples, those skilled in the art should understand that: any person skilled in the art can modify or easily conceive the technical solutions described in the foregoing embodiments or equivalent substitutes for some technical features within the technical scope disclosed in the present application; such modifications, changes or substitutions do not depart from the spirit and scope of the present disclosure, which should be construed in light of the above teachings. Are intended to be covered by the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
Claims (10)
1. A bank payroll generation method is characterized in that the bank payroll generation method acts on a bank issuing platform and comprises the following steps:
receiving an enterprise payroll uploaded by an enterprise user;
identifying the column names of M columns of compensation in the enterprise payroll table;
acquiring column names of N columns of columns to be filled in a to-be-filled table in a bank issuing platform;
aiming at the to-be-filled publication, screening out a Q-column salary column with the same character as the to-be-filled publication from the enterprise payroll table as a Q-column first selected column in a column name matching mode;
acquiring the column names of M-Q columns to-be-selected columns which are not screened in an enterprise payroll table, and the column names of N-Q columns to-be-filled residual columns of a first selected column which is not screened and has the same column name in the to-be-filled representative table;
receiving selection operation input by an enterprise user for the N-Q column to-be-filled residual column; the selection operation is used for selecting the same to-be-selected column as a second selected column for at least one column of to-be-filled remaining columns;
generating an association relation table according to the selection operation; the incidence relation table represents the incidence relation between the column names of the columns to be filled with the rest and the column names of the second selected columns;
and filling the contents in the first selected column into columns to be filled with the same column names respectively, and filling the contents in the second selected column into the associated remaining columns to be filled respectively according to the association relation table so as to generate a filled-in surrogated table comprising bank surrogated information as a bank payroll table.
2. The method of generating a bank payroll as claimed in claim 1, wherein said step of identifying the column names of the M columns of payroll in said enterprise payroll comprises the steps of:
calculating the proportion of the numbers in the rows of the enterprise payroll table line by line from top to bottom;
determining a behavior characteristic digital line with a first digital proportion exceeding a preset value; and determining the content of the upper adjacent table of the ith table in the initial digital row as the column name of the compensation column of the ith column, wherein i is more than or equal to 1 and less than or equal to M.
3. The method of generating a bank payroll according to claim 1, wherein after generating the association table according to the selection operation, further comprising the steps of:
searching whether the first selected column and the second selected column have abnormal tables or not; the exception table comprises a null value table and a format error table;
if the abnormal form exists, the position of the abnormal form in the enterprise payroll is sent to the enterprise user;
receiving a first correction operation input by an enterprise user aiming at an abnormal form, wherein the first correction operation is used for correcting the abnormal form into a normal form;
and modifying the exception table according to the first correcting operation.
4. The method of generating a bank payroll according to claim 1, wherein after generating the association table according to the selection operation, further comprising the steps of:
acquiring a first total issuing amount and a first total issuing stroke number from the first selected column and the second selected column;
judging whether the first total issuing amount and the first total issuing stroke number are consistent with the received second total issuing amount and the second total issuing stroke number or not;
if the first total issuing amount is inconsistent with the second total issuing amount and/or the first total issuing stroke number is inconsistent with the second total issuing stroke number, sending and outputting first reminding information to the enterprise user;
and receiving a second correction operation of the enterprise user for the first reminding information, wherein the second correction operation is used for correcting the first total issuing amount and the second total issuing amount, and the first total issuing number and the second total issuing number to be consistent.
5. The method of generating a bank payroll according to claim 1, wherein after generating the association table according to the selection operation, further comprising the steps of: acquiring employee information from the first selected column and the second selected column; the employee information comprises the number of employees, the identity card numbers of the employees, the mobile phone numbers of the employees and the bank card numbers of the employees;
utilizing an enterprise employee information base of a bank issuing platform to judge whether employee information inconsistent with the enterprise employee information base exists or not;
if the inconsistent employee information exists, the inconsistent employee information is sent to the enterprise user;
receiving a third correction operation input by the enterprise user aiming at the inconsistent employee information; the third correction operation is used for correcting the enterprise employee information base according to the inconsistent employee information;
and updating the enterprise employee information base according to the third correction operation.
6. The method of generating a bank payroll according to claim 5, wherein after obtaining employee information from the first selected column and the second selected column, further comprising the steps of:
judging whether the employee bank card is the bank card or the other bank card according to the employee bank card number;
if the bank card of the employee has the bank card, the contents in the first selected column and the second selected column of all the bank cards are filled into one to-be-filled substitution table to generate the bank substitution table, and the contents in the first selected column and the second selected column of all the bank cards are filled into the other to-be-filled substitution table to generate the bank substitution table.
7. The bank payroll generation method according to claim 5,
after acquiring the employee information from the first selected column and the second selected column, the method further comprises the following steps:
judging whether a bank card with the real issued amount exceeding the transaction limit exists;
if yes, verifying whether an excess other bank card exists in the bank card exceeding the transaction limit;
if the excess other bank card exists, splitting the real issued amount of the excess other bank card into F sub real issued amounts; the sub real sum is not more than the transaction limit corresponding to the excess other bank card;
splitting the row where the excess other row cards are located in the first selected middle column and the second selected middle column into F rows to obtain the split first selected middle column and the split second selected middle column; and the real issuing amount in the row F is the sub real issuing amount of the pen F.
8. The method for generating a bank payroll according to claim 6 or 7, wherein when obtaining employee information from the first option column and the second option column, further comprising the steps of:
sending the employee name, the employee mobile phone number, the employee identification number and the employee bank card number in the employee information to a bank card authentication platform for bank card authentication;
when generating the bank card payroll, acquiring the bank card authentication result from the bank card authentication platform in real time;
if the authentication result is that abnormal employee information exists, sending the abnormal employee information to the enterprise user;
receiving a fourth correction operation input by the enterprise user aiming at the inconsistent employee information; the fourth correction operation is used for correcting the employee information aiming at the abnormal employee information;
and correcting the employee information according to the fourth correction operation.
9. A bank payroll generation apparatus, comprising:
the first receiving module is used for receiving an enterprise payroll uploaded by an enterprise user;
the identification module is used for identifying the column names of M columns of compensation columns in the enterprise payroll table;
the first acquisition module is used for acquiring the column names of N columns of columns to be filled in the table to be filled;
the screening module is used for screening out a Q-column salary column which has the same character as the to-be-filled published list from the enterprise payroll table as a Q-column first selected column according to a column name matching mode aiming at the to-be-filled published list;
the second acquisition module is used for acquiring the column names of M-Q columns to-be-selected columns which are not screened in the enterprise payroll table and the column names of N-Q columns to-be-filled residual columns of the first selected columns which are not screened and have the same column names in the to-be-filled list;
the second receiving module is used for receiving the selection operation input by the enterprise user aiming at the N-Q column to-be-filled residual column; the selection operation is used for selecting the same to-be-selected column as a second selected column for at least one column of to-be-filled remaining columns;
the generating module is used for generating an association relation table according to the selection operation; the incidence relation table represents the incidence relation between the column names of the columns to be filled with the rest and the column names of the second selected columns;
and the filling module is used for respectively filling the contents in the first selected column into the columns to be filled with the same column names, and respectively filling the contents in the second selected column into the associated remaining columns to be filled according to the association relation table so as to generate a filled representative table comprising the bank representative information.
10. A computer-readable storage medium, having stored thereon a computer program which, when executed by a processor, performs the steps of the bank payroll generation method according to any one of claims 1 to 8.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110474410.XA CN113128188A (en) | 2021-04-29 | 2021-04-29 | Bank payroll generation method, device and medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110474410.XA CN113128188A (en) | 2021-04-29 | 2021-04-29 | Bank payroll generation method, device and medium |
Publications (1)
Publication Number | Publication Date |
---|---|
CN113128188A true CN113128188A (en) | 2021-07-16 |
Family
ID=76780535
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202110474410.XA Pending CN113128188A (en) | 2021-04-29 | 2021-04-29 | Bank payroll generation method, device and medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN113128188A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN116167348A (en) * | 2023-04-20 | 2023-05-26 | 中瑞方胜人力资源科技(北京)有限公司 | Information processing method and device for generating payroll |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104978333A (en) * | 2014-04-08 | 2015-10-14 | 无锡兰霖网络科技有限公司 | Automatic matching method based on Excel statistical form and web technology |
CN205992243U (en) * | 2016-05-18 | 2017-03-01 | 杭州班博科技有限公司 | A kind of wage supervisory systems |
CN109359283A (en) * | 2018-09-26 | 2019-02-19 | 中国平安人寿保险股份有限公司 | Method of summary, terminal device and the medium of list data |
CN110222103A (en) * | 2019-04-19 | 2019-09-10 | 平安科技(深圳)有限公司 | Extract method and device, the computer equipment, storage medium of excel data |
CN111190860A (en) * | 2019-12-31 | 2020-05-22 | 中国银行股份有限公司 | Database configuration method and device |
CN112597927A (en) * | 2020-12-28 | 2021-04-02 | 电子科技大学 | Two-dimensional table identification method, device, equipment and system |
-
2021
- 2021-04-29 CN CN202110474410.XA patent/CN113128188A/en active Pending
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104978333A (en) * | 2014-04-08 | 2015-10-14 | 无锡兰霖网络科技有限公司 | Automatic matching method based on Excel statistical form and web technology |
CN205992243U (en) * | 2016-05-18 | 2017-03-01 | 杭州班博科技有限公司 | A kind of wage supervisory systems |
CN109359283A (en) * | 2018-09-26 | 2019-02-19 | 中国平安人寿保险股份有限公司 | Method of summary, terminal device and the medium of list data |
CN110222103A (en) * | 2019-04-19 | 2019-09-10 | 平安科技(深圳)有限公司 | Extract method and device, the computer equipment, storage medium of excel data |
CN111190860A (en) * | 2019-12-31 | 2020-05-22 | 中国银行股份有限公司 | Database configuration method and device |
CN112597927A (en) * | 2020-12-28 | 2021-04-02 | 电子科技大学 | Two-dimensional table identification method, device, equipment and system |
Non-Patent Citations (3)
Title |
---|
MUHAMMAD UMAIR HASSAN ET AL.: "An Overview of Schema Extraction and Matching Techniques", 《2018 2ND IEEE ADVANCED INFORMATION MANAGEMENT,COMMUNICATES,ELECTRONIC AND AUTOMATION CONTROL CONFERENCE(IMCEC 2018)》 * |
王克兰: "我国商业银行代发工资业务存在的问题及对策", 《中国商界》 * |
计承江 等: "《金融探索》", 31 January 2007, 中国金融出版社 * |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN116167348A (en) * | 2023-04-20 | 2023-05-26 | 中瑞方胜人力资源科技(北京)有限公司 | Information processing method and device for generating payroll |
CN116167348B (en) * | 2023-04-20 | 2023-08-04 | 中瑞方胜人力资源科技(北京)有限公司 | Information processing method and device for generating payroll |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US7840456B2 (en) | System and method for categorizing credit card transaction data | |
CN109344831A (en) | A kind of tables of data recognition methods, device and terminal device | |
CN106294125B (en) | Core banking system data processing method | |
US20060271450A1 (en) | Computer-based method for automatic remote coding of debtor credit databases with bankruptcy filing information | |
CN110909226A (en) | Financial document information processing method and device, electronic equipment and storage medium | |
US20050222944A1 (en) | System and method for managing the reimbursement of expenses using expense reports | |
CN103544074A (en) | Method and device for verifying service | |
CN110147365B (en) | Method, device, equipment and medium for checking business data and financial data | |
CN111127009A (en) | Wrong account positioning method and device applied to self-service equipment | |
US20090192810A1 (en) | Fraud detection system & method | |
CN113128188A (en) | Bank payroll generation method, device and medium | |
CN101706829A (en) | Data storage method and device | |
CN114140221A (en) | Fraud risk early warning method, device and equipment | |
CN109324963B (en) | Method for automatically testing profit result and terminal equipment | |
CN112559817A (en) | Report content checking method, system, computer equipment and storage medium | |
CN116702726A (en) | Tax management system, method, electronic device and storage medium | |
CN116342305A (en) | Travel expense reimbursement method, device, computer equipment and storage medium | |
CN113051257B (en) | Service data cleaning method and device | |
CN114626341A (en) | Document conversion method, device and storage medium | |
WO2021073264A1 (en) | Negotiable instrument information acquisition method and device, computer apparatus, and readable storage medium | |
KR101059582B1 (en) | Computer readable recording medium recording method and system for quality assurance of accounting and program quality assurance program | |
CN111026763A (en) | Data processing method, device, equipment and storage medium | |
CN117494702B (en) | Data pushing method and system combining RPA and AI | |
US20230418858A1 (en) | Methods, Systems, and Computer-Readable Media for Generating Labelled Datasets | |
US20220230153A1 (en) | Payment manager having data enrichment tool |
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 |