JP2011181024A - Csv file output device for cooperation between systems - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To flexibly cope with an item change output to a CSV data file, and to prevent a CSV file from being falsified. <P>SOLUTION: An automatic classification data item is divided into a preparation processing portion thereof, and CSV edition processing for a required item when output/form of the item/hash processing, and definition information for outputting the CSV file of a form required by an external accounting system is set in an automatic classification output form setting table. The CSV file output system copes with requests for the various kinds of external accounting systems, by changing the setting. A mechanism is provided to output a hash value of each item line data to the output CSV data file, when setting execution of hashing processing in the form setting table, and to detect the falsification. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to output setting and tampering prevention when sorting data is output as a CSV file from a business system used in a company to an external accounting system.

When business systems and accounting systems are separated, normal journal data is linked in a CSV (Comma Separated Values) format file to exchange data. The required CSV format usually differs depending on the accounting system used by the company. When linking, it is necessary to customize it for each accounting system.
There exists patent document 1 as a well-known technical document relevant to this invention. It will make it easier for the person in charge of the local government to visually confirm the exchange information of the disability support payment system for persons with disabilities.

JP 2009-093555 A

  The inventor of the present invention pays attention to the fact that it can be realized by defining a CSV file format setting table for automatic journal data to be output in advance as a mechanism for flexibly dealing with journal data items required by an external accounting system. did. In recent years, the reliability of corporate financial reports has been demanded from the viewpoint of internal control. No matter how much you try to guard at the input part of the business system, if the CSV data of the journal data is falsified, it will be recorded in the accounting system as it is, and there is a risk of erroneous financial reporting.

Therefore, it is necessary to ensure that the output journal data is not falsified. The inventor of the present invention has considered that the mechanism can be realized by setting the format setting table and the CSV output control process.
An object of the present invention is to flexibly cope with a format required by various external accounting systems, and to provide a mechanism that can be used as a subsequent heuristic control by preventing alteration of CSV data.

  Prepare a formatting table that defines hashing for automatic journal data CSV file items, formatting, and falsification prevention to be output, a processing part to create automatic journal data items, and required items and item formats for CSV output Divide the processing into CSV editing for hash processing, and set the required processing in the formatting table. Change the settings to meet the requirements of various external accounting systems. The present invention is a mechanism for setting output of an inter-system cooperation CSV file and preventing falsification.

  As a problem solving means, a journal table that the business system side has as a default and a format setting table that defines the journal output format are defined. In addition, a log table for the output CSV file is prepared to facilitate the corresponding process.

  According to the present invention, it is possible to cope with the CSV file format required by various accounting systems. In addition, it is possible to prevent falsification of the journal data CSV file.

It is a system configuration figure showing an embodiment of the present invention. It is an example of the data stored in the schema of an automatic journal data table, and this table. It is an example of the data stored in the schema of an output format setting table and this table. It is a processing control flow at the time of CSV file output of automatic journal data. It is an example of the data stored in the schema of an output control table and this table. The control flow at the time of automatic journal data (main part record) output is shown. It is an example of a CSV file. It is an example of the data stored in the schema of a log table and this table.

  Hereinafter, an embodiment of CSV file output setting for system cooperation and tampering prevention to which the present invention is applied will be described with reference to the drawings.

  FIG. 1 is a system configuration diagram showing an embodiment of the present invention. In this specification, “system” means an electronic information processing organization (computer system) that is realized by a computer reading several computer programs and integrally performs information processing operations. For example, the “business system” is specialized for each business in accordance with the business content, scale, field, etc., and is designed with priority on the profit of the business. In contrast, an “external accounting system” is a computer designed for the purpose of preparing financial statements that are transparent to the general public or to shareholders by outside corporate auditors who are certified public accountants. System. A “processing unit” such as a CSV data output processing unit, which will be described later, is realized by a part of a computer program constituting the “system”, and is realized by reading a necessary program by a computer constituting the “system”. Means. Further, the “processing unit” can also be regarded as an “apparatus”. This is because a state realized by executing the program is constituted by a CPU (central processing unit).

  As an example of a system configuration assumed by the present invention, a business system 01 for inputting / outputting various business data such as orders received, sales, and claims receivable generated when a company performs daily business activities, and the business system 01 input It is composed of an external accounting system 02 for finally outputting data as accounting data to data such as financial statements. The business system 01 includes physical database tables such as an automatic journal data table 10, an output format setting table 11, an output control table 12, and a log table 15. Furthermore, a CSV data output processing unit 13 that reads and writes data in the table and outputs the CSV data 14 for cooperation is included.

  The automatic journal data table 10 holds CSV output target data. The output format setting table 11 is a table that defines the format of data to be output and the items to be output to CSV among the items of the automatic journal data table 10. The output control table 12 holds setting data indicating whether a header / footer is output when CSV data is output, and whether an item name and a hash value are output after the footer is output. The CSV data output processing unit 13 reads the data from the above 10, 11 and 12 and performs processing. The CSV data output processing unit 13 includes a data editing processing unit 130, a data output processing unit 131, and a log output processing unit 132. The data editing processing unit 130 reads the data record from the automatic journal data table 10 and the output format setting table 11, and the format set in the output format setting table 11 for the data in the automatic journal data table 10 (the item to be output) , Processing according to zero padding, zero suppression, hashing, etc.). The data output processing unit 131 outputs the result of the processing 130 as the linkage CSV data 14. The log output processing unit 132 outputs the result log performed by the data editing processing unit 130 and the data output processing unit 131 to the log table 15. The external accounting system 02 takes in the CSV data 14 for cooperation described on the left, and processes its own system as accounting data.

  FIG. 2 shows an example of the schema of the automatic journal data table 10 and data stored in this table. The automatic journal data table 10 is a table for storing result data of business activities performed by a company every day as journal data handled by the external accounting system 02. As data items, journal number 20, line number 21, balance class 22, recording date 23, account 24, amount 25, consumption tax 26, description 27, time stamp 28, etc. keeping.

  FIG. 3 shows an example of the table schema of the output format setting table 11 and data stored in this table. The output format setting table 11 is a table for setting how to output the data stored in the automatic journal data table 10 to a CSV file. As data items, attribute information such as item order 20, output item 21, number of significant digits 22, number of decimal digits 23, output editing 24, hash classification 25, fixed value designation 26, and the like are held. The output order 20 defines the arrangement order of each data output to the CSV file. The output item 21 defines an item in the automatic journal data table 10 that is actually output. Thereby, it is possible to easily define the data items required by the external accounting system and the arrangement order of the items without depending on the structure of the automatic journal data table 10. The number of significant digits 22 defines the number of digits of data to be output, and the number of decimal digits 23 and output edit 24 are zero padding or zero suppression processing when there are not enough decimal digits or digits for numeric items. Define whether to do. The hash classification 25 defines whether to perform hash processing on the data of the automatic journal data item to be output. For example, it is defined that hash processing is performed on account item / amount information data that is important in accounting processing, and other flexible data items such as hash processing is not performed on relatively unimportant data items.

  FIG. 4 shows a processing control flow when the automatic journal data is output as a CSV file. First, at the time of CSV output, the control data on whether to output the header and footer is read into the output file, and determination 40 is performed to determine whether to output the header and footer. When header is output, predetermined header data is output 41. When the header is not output or after the header is output, the process 42 of the automatic journal data output 42 of the main body is performed. The details of the automatic journal data output process 42 will be described later. If the header has been output in the previous processing, the predetermined footer data is output after the completion of automatic journal data output 43. Also, an item name / hash value output determination 44 is performed to determine whether or not to output the item name and the hash value of each column after the footer. In the case of outputting, processing 45 is performed for outputting the item name and the hash value of each column to the back of the footer and to the Log table.

  FIG. 5 shows an example of a schema of an output control table that holds control data for outputting a header and a footer, and data stored in this table. No. 50 stores the data that uniquely identifies the record. The output target 51 stores data to be output in a CSV file other than the journal data, such as header / footer, item name, hash value, and the like. The output section 52 stores a control flag for controlling whether to output the output target 51 described on the left.

  FIG. 6 shows a control flow when automatic journal data is output. A record is read from the formatting table 11 60, and the data value of the corresponding column of the automatic journal data table 10 indicated by the output item 21 is read 61 in the output order 20 that has been read. At this time, the data format editing process 63 is performed as set in the format setting table 11. When the hash classification 25 of the format setting table 11 is set, a hashing process 63 using an appropriate hash function is performed on a series of data in the corresponding column.

  FIG. 7 shows an example of the CSV file output by the above processing. Record 70 indicates a header. A record 71 indicates a journal data record of the main body. The record 72 indicates a footer, but the number of records in the journal data body and the output time data 74 of the CSV file are also output to the footer at the same time. A record 73 indicates an item name of CSV data. A record 75 indicates the hash value of the entire column of each item.

  In this CSV file example, in the format setting table 11, items in the automatic journal data table 10 such as journal number, account item, amount, consumption tax, and time stamp in the last output order are set in the output order 001 to 004, respectively. An example is assumed. As in this example, for example, by changing the output order 003 amount in the format setting table and the consumption tax setting order in the output order 004, the order of the items in the output CSV file is also changed. In addition, for example, when the external accounting system is changed, the required items increase and the item number item is required, for example, a new item number is added to the output order 002 of the formatting table 11, for example, By shifting the output order of subsequent items, it is possible to respond to changes in the external accounting system. In this way, without changing the CSV data output processing logic, it is possible to easily cope with the CSV data file format change required by the external accounting system by simply adding, deleting, and updating records in the output format setting table. Various costs at the time of response can be suppressed.

  FIG. 8 shows an example of the schema of the log table that holds the hash value and the data stored in this table. Log number 80 uniquely defines the output log. The output item name 81 holds the item name 73 output by the CSV file, and the hash value 82 holds the hash value 75 output by the CSV file.

  By providing a log table as shown in Fig. 8 and holding the item name, hash value, etc. output to the CSV file, even if the CSV data is altered for some reason, CSV output is possible as a post control By checking the hash value of the time log table, it is possible to discover data changes.

  In the present invention, it is possible to flexibly support various automatic journal data CSV file formats required by an external accounting system. Prepare a formatting table and divide the processing into the processing part that creates automatic journal data items and the CSV editing of required items, item formats, and hash processing at the time of CSV output, and set the required processing in the formatting table. By simply changing the settings in the format setting table, various external accounting system requirements can be easily realized.

  Also, after CSV data is output, it works as a post-mortem control by hashing the output data and recording the output hash value in the log table to prevent the possibility of data being tampered with.

  Furthermore, the program of the hashing process part is modularized, and the external accounting system implements this module, so that the accounting system performs the same hashing process after taking accounting data, and the implementation results are recorded in a CSV file. By comparing with the hash value, it is possible to realize a mechanism that automatically checks for tampering.

  In addition to the inter-system cooperation between the in-house business system and the external accounting system, it can be used when it is necessary to output the data by CSV output and use it in cooperation between a plurality of systems.

01 Business System 02 External Accounting System 10 Automatic Journal Data Table 11 Output Format Setting Table 12 Output Control Table 13 CSV Data Output Processing Unit 14 CSV Data for Cooperation 15 Log Table

Claims (3)

A CSV file output device for inter-system cooperation provided in a business system in order to link a business system with an external accounting system,
An automatic journal data table for holding CSV output data;
An output format setting table that defines the format of target items and data to be output to CSV;
An output control table that holds setting data indicating whether a header / footer is output when CSV data is output, or whether an item name / hash value is output after the footer is output;
A data editing processing unit that reads a data record from the automatic journal data table and the output format setting table, and processes the data of the automatic journal data table according to the format set in the output format table;
A data output processing unit for outputting the processing result of the data editing processing unit as CSV data for cooperation;
A log output processing unit that outputs a result log performed by the data editing processing unit and the data output processing unit to a log table;
In order to flexibly support the CSV file format and items required by the external accounting system, the output format setting table is defined, and when the external system adds or changes items, the data in the output format setting table is updated. A CSV file output device for inter-system cooperation, characterized in that A CSV file output device for inter-system cooperation according to claim 1,
When the data output processing unit outputs a CSV file, it attaches a header / footer, leaves a trail of the item name and who did what, etc. after the footer, and hashes the trail to tamper the journal data A CSV file output device for intersystem cooperation, characterized by A CSV file output device for inter-system cooperation according to claim 2,
A CSV file output device for intersystem cooperation, wherein the trail data is left as a log, and as a subsequent heuristic control, the presence or absence of tampering is confirmed.

Images