JP2001306776A - Method and device for linking data between different systems and information storage medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To easily and exactly perform the mutual exchange of data between plural systems. SOLUTION: The method comprises a process where a financial system on a data request side automatically stars salary journalizing output processing of a salary system as another system, a process for generating a salary journalizing data file linked with data of salary journalizing output processing and reporting the preparation of the salary data file to the financial system on the data request side and a process for enabling the financial system on the data request side to fetch the salary journalizing data file of linked data.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to an accounting system, and more particularly, to data linkage between systems related to the accounting system.

[0002]

2. Description of the Related Art Conventionally, a data interlocking function between different systems is an asynchronous operation in which interlocked data is written once as a data file by an operation on a data output side, and then data is received by an operation on a data receiving side. It was a typical thing.

[0003]

In the above-mentioned asynchronous linkage, the user operates the data output side system, creates a data file, and then receives data in order to perform data linkage between different systems. It was necessary to start the side system and perform the complicated operation of importing the already created data file without mistake. During such a series of operations, there is a possibility that an erroneous operation of erroneously locating the data file may occur.

[0004] It is an object of the present invention to facilitate the exchange of data between systems and to improve the efficiency of business processing.

[0005]

According to the present invention, there is provided a method of exchanging data among a plurality of different systems such as an accounting system, a payroll system, a depreciation system, etc., wherein the system on the data input side is connected to the data output side. Activating a data output program of the system, generating a data file of the data by the data output program, notifying the data input side system that the data file has been created, And a step of taking in.

According to another aspect of the present invention, in a method of exchanging data between a plurality of different systems, the data output side system generates a data file of the data and then receives the data from the data input side system. The method further comprises a step of activating the program and a step of informing the data input processing of the data input side system that the data receiving program has received the interlocked data.

In this way, data can be exchanged between the respective systems without complicated operation by the user. Therefore, data exchange between the systems can be performed without erroneous operation.

The present invention may be in the form of an apparatus for realizing the above method and an information storage medium storing a program for realizing the method by a computer.

[0009]

Embodiments of the present invention will be described below. FIG. 1 is a block diagram showing an example of a data interlocking configuration in a case where another system data is fetched by operation of a data requesting system, that is, by initiating data requesting.

FIG. 2 shows the operation of the data output side system.
That is, it is a block diagram showing an example of a data interlocking configuration in a case where the other system receives data led by the data output side.

In FIG. 1, a financial system 1 is a data requesting system and has a financial database 2.
The financial system 1 activates the payroll journal output process 4 or the depreciation journal output process 6 via the data linking unit 3 and acquires necessary journal data.

The payroll journal output process 4 is one of the processes constituting the payroll system 8, and extracts journal data requested from the financial system 1 from the payroll database 9 and outputs it to a file.

The depreciation journal output process 6 is one of the processes constituting the depreciation system 13, and the financial system 1
The journal data requested from the depreciation database 14
Extract and output to a file.

The data linking unit 3 transmits a request from the financial system 1 to the payroll journal output process 4 or the depreciation journal output process 6, and transmits the result information of the payroll journal output process 4 or the depreciation journal output process 6 to the financial system 1. Notice.

In FIG. 2, the pay system 8 has a pay database 9. The payroll system 8 extracts journals from the payroll database 9, outputs them as a file, activates the financial journal receiving process 11 via the data linking unit 10, and receives the journal data output by the payroll system 8 into the financial journal receiving process 11. Let

The depreciation system 13 has a depreciation database. The depreciation system 13 extracts journals from the depreciation database 14 and outputs them as a file.
The financial journal receiving process 11 is started via the data linking unit 10, and the journal data received by the depreciation system 13 is received by the financial journal receiving process 11.

The financial journal receiving process 11 is one of the processes constituting the financial system 1, and extracts journal data requested from the salary system 8 or the depreciation system 13 from the financial database 12 and outputs the extracted journal data to a file.

The data linking unit 10 transmits a request from the payroll system 8 or the depreciation system 13 to the financial journal output process 11, and transmits the result information of the financial journal output process 11 to the payroll system 8 or the depreciation system that made the request. 13
Notify.

1 and 2, a financial database 2
Reference numeral 12 includes subject master data, journal data, and balance data for each company. The salary databases 5.9 have subject master data, journal data, and balance data for each company. The depreciation database 714 has subject master data, journal data, and balance data for each company.

FIG. 3 shows the structures of the financial database and the payroll database used in the present invention.

Next, the operation of data linkage according to the present embodiment will be described. First, the operation of data interlocking when led by the data requesting side will be described.

FIG. 6 shows the flow of the data requester-initiated process related to FIG. When the journal of the payroll system is to be taken into the financial system 35, the operator specifies the company name, the start date, and the period on the payroll journal take-in designation screen 33. Upon completion of the designation process, the financial system generates parameter information 41 based on the information designated on the payroll journal entry designation screen 33.

In the parameter information 41, "salary journal output processing", which is the output processing to be started, is set in "application", and "company", "start date", "start date", and "end" are set. In "Date", the company name, the beginning date, and the period specified on the pay journal entry specification screen are set. In the “output destination”, a journal output destination folder is set in order to notify the folder for outputting the journal to the payroll journal output process.

The financial system 35 stores the parameter information 4
The data interlocking unit 36 is called with "1".

In the data linking unit 36, the parameter information 41
From "application" information of "salary journal output processing"
And obtains the name of the data output processing program to be actually started from the data output processing management table shown in FIG.
In this case, it is the program name of the payroll journal output process. The data linking unit 36 activates a program based on the program name of the payroll journal output process with the parameter information 41 passed from the financial system 35.

The payroll journal output process 37 obtains the company, the start date, the start date, and the end date from the parameter information 41 passed through the data linkage, and obtains the payroll database 24
The journal information matching the condition is extracted from the journal data 27 of the above and stored as a journal file in the folder indicated by the output destination in the parameter information 41. The payroll journal output process writes, as result information 42, what file was output to the "output destination" in addition to the information passed in the parameter information.

In the result information 42 of this embodiment, there are two “number of files” output by the payroll journal output process, and Key1 and Key2 are prepared according to the number of output files, and the value of Key1 is set as a value. , Kamoku, and Key2 are set to Shiwake as values. In Kamoku, the journal master is set as the file that outputs the subject, and in Subject.CSV Shiwake, journal.CSV is set as the file that outputs the journal data. “.CSV” indicates the extension of the file.

The payroll journal output process writes “success” as “Result” indicating whether or not the journal output was successful, as the result information 42. Journal output may fail for some reason. In that case, "Result"
If the cause of the failure can be identified, for example, the revision of the journal data in the financial database 12 is old, or the input of the data has not been detected, the failure may be written. Instead, the cause may be recorded. The payroll journal output process 37 notifies the data linkage process of the result information and ends the process.The data linkage unit 36 waits for the end of the payroll journal output process and terminates the process. After the confirmation, the result information of the payroll journal output process is notified to the financial system 35, and the process ends.

After confirming the end of the data linkage, the financial system 35 confirms the result information of the payroll journal output process 37.

The financial system 35 recognizes from the result information of the payroll journal output processing that Result is “success”. When it is detected that the number of files is two, since there are two files, it is confirmed whether or not there is a value for Key1 and Key2. Ke
Shiwake as value for y1, Kamoku and Key2 for value
Next, check the value for each key with Kamoku / Shiwake as keys. Check the journal.CSV as the file to which the master data is output to Kamoku, and the subject.CSV to Shioku as the file to which the journal data is output. The key of Kamoku / Shiwake shall be decided in advance between the financial system and the payroll system.

At this point, the financial system 35 has, for example, "
Recognize the subject .CSV as the file to which the subject master was output, and the journal .CSV as the file to which the journal data was output, with "D: \ Data" as the output destination.

When the financial system 35 confirms that the item .CSV exists in the item master in the financial database, it reads the journal .CSV and takes it in as journal data in the financial database 2.

With the above operation, the financial system 1 can take in the journal data from the payroll journal output process 4 and can utilize it as data of the financial system 1 thereafter.

Next, a description will be given of the data interlocking operation in the case of the data output side initiative. FIG. 7 shows a flow of the data output-side process related to FIG. If the payroll system 38 wants the financial system to take journals, payroll system 3
In the financial journal output designation screen 34, the company name, the beginning date, and the period are designated. The payroll system 38 writes the subject master data and the journal data as a file to the output destination “D: \ Data” with the specified company name, start date, and period.

The salary system 38 generates parameter information 43 based on the information specified on the financial journal output designation screen 34. In the parameter information 43, "financial journal receiving process", which is the receiving process to be started, is set in "application", and "company", "start date", "
For “Start date” and “End date”, set the company name, beginning and end date and period specified on the financial journal output designation screen, and output the “Output destination” item master and journal. It is an output destination folder.There are 2 "number of files" as parameter information of salary system. Key1 and Key2 are prepared according to the number of files, and Key1 is
Shiwake is set as a value for Kamoku and Key2.
In Kamoku, subject.CSV is set as the file that outputs the subject master, and in Shiwake, journal.CSV is set as the file that outputs the journal data. The pay system 38 calls the data interlocking unit 39 with these parameter information.

In the data linking unit 39, the parameter information 43
"Financial journal reception processing" is obtained from the "application", and the name of the data reception processing program actually started is obtained in the data reception processing management table shown in FIG. In this case, it is the program name of the financial journal receiving process. The data linking unit 39 activates a program based on the program name of the financial journal receiving process with the parameter information 43 passed from the salary system 38.

The financial journal receiving process 40 is performed by the data link unit 3
Recognize the company, start date, start date and end date from the parameter information passed from 9. It also detects that there are two files. Since there are two files, Ke
Check if there are values for y1 and Key2. Check Shiwake as a value for Key1, Kamoku as a value for Key2,
Next, using Kamoku / Shiwake as keys, check the values for each key. Check the journal.CSV as the file to which the master data is output to Kamoku, and the subject.CSV to Shioku as the file to which the journal data is output. Kamo
The key of ku / Shiwake shall be determined in advance between the financial system and the payroll system.

At this point, the financial journal receiving process 40 sets “D:
Recognize the subject .CSV as the file to which the subject master was output, and the journal .CSV as the file to which the journal data was output, with "\ Data" as the output destination.

When the financial journal receiving process 40 confirms that the item .CSV exists in the item master 17 in the financial database 15, the financial journal
Is taken in as the journal data 18.

After receiving the journal data, the financial journal receiving process 40 writes “success” as the result information 44 as the Result in the parameter information passed from the payroll system. The journal output may fail for some reason. In this case, “failure” is written as “Result”.

The financial journal receiving process 40 notifies the result information 44 to the data linkage process 39, and ends the process. The data linking unit 39 waits for the end of the financial journal receiving process 40, and after confirming the end, notifies the payroll system 38 of the result information 40 of the financial journal receiving process 40. The pay system 38 confirms that the Result of the result information is “success”, and ends a series of data linkage processing.

Although the description of the embodiment of the present invention has been made between the financial system and the payroll system, data can be linked in the same manner between the financial system and the depreciation system. Further, if processing is added to the data output processing management table and the data reception processing management table, other systems such as a breakdown system and a summary system not shown in FIGS. It is possible.

If parameter information is agreed upon between applications, it is possible to cope with the situation between applications. For example, in the case of the requester's initiative, the requester specifies the output destination as “D: \ Data” in the financial system, but the output side instead of the requester can specify the output destination in the result information. It is also possible to add new parameters between applications and exchange new information.

[0044]

According to the present invention, a system for exchanging mutually necessary data, such as an accounting system, a payroll system, a depreciation system, etc., can: (1) operate a data requesting system to execute a data output program of another system; Automatically generates a data file of the interlocked data, informs the data requesting system that the data file has been created, and enables the data requester to import the interlocked data so that the data can be transferred between systems. Can be linked. Thus, for example, after the payroll system outputs the determined journal, it is possible to request that the journal be imported to the financial system and have the financial system import the journal. (2) After the data output side generates the data file of the interlocked data, it automatically starts the data receiving program of the other system, and notifies the data request processing that the data receiving program has received the interlocked data. Data can be linked between systems. Thus, for example, the salary system requests the financial system to receive the journal information, acquires the journal information output by the financial system, and creates a form. (3) Data linkage is enabled by the linkage program specifying means without fixing the application for data linkage. According to the linked program specifying means, it is possible to cope with an upgrade of the program only by changing the information in the management table without changing the program.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an example of a data link configuration led by a data requesting side.

FIG. 2 is a block diagram illustrating an example of a data linkage configuration led by a data output side.

FIG. 3 is a diagram showing a configuration in a financial DB and a payroll DB in the block diagrams shown in FIGS. 1 and 2;

FIG. 4 is a journal entry designation screen when a journal is requested by the financial system to the payroll system as an example led by the data requesting side.

FIG. 5 shows a financial journal output designation screen when a request is made from the payroll system to the financial system as an example led by the data output side.

FIG. 6 is a diagram illustrating, as an example led by a data requesting side, an operation in a case where a request is made from a financial system to a pay system and journals are taken in;

FIG. 7 is a diagram illustrating, as an example led by the data output side, an operation when a pay system requests a financial system to take in journals;

FIG. 8 shows a data requester-initiated operation shown in FIG.
Data output processing management table for specifying a data output program.

FIG. 9 shows a data output side-led operation shown in FIG.
Data reception processing management table for specifying a data reception program.

FIG. 10 is a diagram showing parameters passed from a data requesting system to a data output process and result information from the data output process to the data requesting system in an operation led by the data requesting side.

FIG. 11 is a view showing parameters passed from the data output side system to the data reception processing and result information from the data reception processing to the data output side system in the operation led by the data output side.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Financial system 2 Financial database 3 Data linkage part 4 Payroll journal output processing 5 Payroll database 6 Depreciation journal output processing 7 Depreciation database

Claims (9)

[Claims] 1. A method for exchanging data between a plurality of different systems, wherein a system on a data input side activates a data output program of a system on a data output side;
A data linking method, comprising: generating a file; notifying a data input side system that a data file has been created; and capturing the data by the data input side. 2. A method for exchanging data between a plurality of different systems, wherein the data output system activates a data receiving program of the data input system after generating a data file of the data; Notifying the data input processing of the data input side system that the data receiving program has received the interlocked data. 3. The data interlocking method according to claim 1, further comprising the step of selecting a data output side system, wherein in the data output program starting step, the data output program of the selected data output side system is executed. A data linking method characterized by starting. 4. The data interlocking method according to claim 2, further comprising the step of selecting a data input side system, wherein in the data receiving program starting step, the data receiving program of the selected data input side system is executed. A data linking method characterized by starting. 5. A computer-readable information storage medium storing a program for realizing the data linking method according to claim 1 by a computer. 6. An apparatus for exchanging data between a plurality of different systems, comprising: a data input side system for inputting data; a data output side system for outputting data; and the data output side system includes: Data output means for generating a data file of predetermined data; data-linked activation means for activating the data output means in response to a request from a data input system; and completion of generation of the data file by the data output means And a data interlocking notification unit that notifies the data input side system in response to the notification, wherein the data input side system captures the data from the data file in response to the notification. Characteristic data interlocking device. 7. An apparatus for exchanging data between a plurality of different systems, a data input side system for inputting data, a data output side system for outputting data, and the data output side system includes: A data output unit that generates a data file of predetermined data; a data acquisition unit that is included in the data input side system and captures the data file generated by the data output unit; Responsively, the data linking activating means for activating the data fetching means, and when the data fetching means completes the fetching of the data file, notifies the input processing of the data input side system accordingly. A data link device comprising: a data link notifying unit. 8. The data interlocking device according to claim 6, further comprising a data output system selecting unit for selecting a data output side system, wherein said data interlocking activation unit is a data output unit of the selected data output side system. A data interlocking device characterized in that the device is activated. 9. The data interlocking device according to claim 7, further comprising data input system selecting means for selecting a data input side system, wherein said data interlocking activation means acquires data of the selected data input side system. A data linking device for activating a means.