JPH11265325A - Data transmitting and receiving system, data transmitting terminal, data receiving terminal, data transmitting and receiving method, and medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To make it possible to exclude overlapped work in overseas associated companies and a domestic accounting division in the case of executing an international connection system. SOLUTION: The system is provided with data transmitting terminal equipments 100a to 100d in respective associated companies existing in respective places of the People's Republic of China, a server 200a to be a 1st provider, an interconnection network (Internet) 300 for sending an electric(E) mail to which receiving time information is added by the server 200a, a server device 400 existing in Japan, a mail box 410a for storing E mails from the associated companies in China, and a data receiving terminal equipment 500a for receiving E mails stored in the mail box 410a from the server 400 through a telephone line and restoring and working data such as monthly reports transmitted from respective overseas associated companies.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] The present invention relates to a data transmission / reception system, a data transmission terminal device, a data reception terminal device,
The present invention relates to a data transmission / reception method and a medium.

[0002]

2. Description of the Related Art Conventionally, a system using the following system has been known as an international consolidated business performance report business of a company having a plurality of affiliates in Japan and overseas.

[0003] First, each overseas affiliated company:
A monthly report and a financial report (confirmed report) as a monthly report, as well as reports on business performance forecasts and business plans, etc., are sent to a predetermined overseas headquarters in Japan by facsimile transmission using a telephone line. In this case, the overseas affiliated companies are generally divided into a plurality of groups according to their locations, and one overseas headquarters is generally supervised for each group. For example, for affiliates in China, the Chinese headquarters in Japan controls them. And these affiliates
The various reports described above are prepared in each format, and the fax is transmitted to the Chinese headquarters as described above.

[0004] In the following, taking as an example the business at the Chinese headquarters, ordinary data aggregation software (for example, Lotu
Using s1-2-3), data is input to a predetermined position on the worksheet while viewing numerical data and the like described in reports from affiliated companies in China. This is an operation for converting the contents of the report by fax from each affiliated company in China into electronic data that can be handled on a computer, and further unifying it into a predetermined format used for reporting to the accounting department of the head office. The same work will be performed at other overseas headquarters.

At the overseas headquarters, based on the contents of various reports from overseas companies, a transmission file is created from data of various reports in a uniform format created as described above.
The data is transmitted to the host computer at the head office by PC communication.

In the accounting department of the head office, monthly reports and the like of overseas companies transmitted from overseas headquarters by personal computer communication are converted into yen conversion and used as data of the international consolidation system. The data converted into yen is fed back to each overseas headquarters.

[0007] Each overseas headquarters uses the data that has been fed back and checks whether or not there is an error in the content of the initial report to the head office. If the initial report is found to be correct as a result of the check, in order to further process these data, prepare report materials such as overseas sales / manufacturing company performance reports in another format and submit these report materials to the head office .

[0008] The overseas affiliate company reports the same contents as the report to the overseas headquarters to the parent company in Japan in the same manner.

[0009]

However, in such a conventional method for realizing the international connection system described above, since reports from overseas companies are transmitted by facsimile, when the received data cannot be read, However, there has been a problem that the efficiency of work has been reduced as a whole, for example, it is necessary to request retransmission to the site, and at the site receiving the retransmission request, it is necessary to fax again.

In addition, since reports from overseas companies are based on facsimile, it is necessary for the overseas headquarters to re-enter the data while viewing the data on the documents, which requires time and effort and requires an overall view. Therefore, there was a problem that these operations were duplicated.

The present invention has been made in consideration of such a conventional problem, and has a data transmission / reception system, a data transmission terminal device, a data reception terminal device, and a data transmission / reception terminal device capable of further improving work efficiency as compared with the related art. It is intended to provide a receiving method and a medium.

[0012]

According to the first aspect of the present invention, there is provided an input means for inputting data at a predetermined position of a first frame used for data input, and all or a part of the input data is encrypted. Encryption means for encrypting, transmission file creation means for creating a transmission file of the encrypted data,
A data transmission terminal device having first transmission means for transmitting the transmission file as e-mail, reception means for receiving the transmission file transmitted from the first transmission means, and a second transmission means for transmitting the received transmission file. A relay device having two transmission means, a network in which the transmission file from the second transmission means is transmitted, and a network in which the pre / post relationship of data transmission time and the pre / post relationship of data reception time do not always match; A server device having a mailbox provided thereon, and a transmission file transmitted from the second transmission means to the mailbox via the network, including a plurality of transmission files including the transmission file in the mailbox. Extracted from email based on time information and file name of the transmission file Extraction means that, a decoding means for decoding the encrypted data of the extracted transmission file,
A data receiving terminal device having an arrangement means for arranging the decrypted data at a predetermined position of a second frame corresponding to the first frame based on a common rule, wherein the time information comprises: The transmission file creation time in the transmission file creation means, or the transmission time of the transmission file in the first transmission means, or the reception time of the transmission file in the reception means, or the second
This is information indicating the transmission time of the transmission file in the transmission means, and is a data transmission / reception system attached to the transmission file.

According to the present invention, data is input to a predetermined position of a first frame used for data input, all or a part of the input data is encrypted, and A transmission file is created, the transmission file is transmitted as an e-mail to a predetermined relay unit, and the transmission file is not always matched by the relay unit with respect to the data transmission time and the data reception time. Sent to a mailbox of a server provided on the network, a transmission file transmitted to the mailbox via the network, from among a plurality of e-mails including the transmission file in the mailbox, The encrypted data of the extracted transmission file is extracted based on time information and the file name of the transmission file. The decrypted and the decrypted data, to a predetermined position of the second frame corresponding to the first frame,
A data transmission / reception method arranged based on a common rule, wherein the time information is a time when the transmission file is created, or a time when the transmission file is sent to the relay unit, or the transmission time. A data transmission / reception method, which is information indicating the time at which a file is received by the relay unit or the time at which the transmission file is sent out by the relay unit, and is attached to the transmission file.

[0014]

Embodiments of the present invention will be described below with reference to the drawings.

(First Embodiment) FIG. 1 is a block diagram showing the overall configuration of a data transmission / reception system according to an embodiment of the present invention.
The configuration of the data transmission / reception system of the present embodiment will be described.

In the present embodiment, as an example of an overseas affiliated company, a plurality of affiliated companies located in China are provided with monthly earnings reports and financial statements (confirmed reports) as well as performance forecasts and business plans. This report focuses on sending reports to overseas headquarters in Japan (China Headquarters, Accounting Section) using the Internet.

As shown in FIG. 1, a data transmitting terminal 1
Reference numerals 00a to 100d denote terminal devices of affiliated companies located in various places in China, and are means for transmitting data such as the financial results flash report of the affiliated company as e-mail.

The server 200a of the first provider is:
This is a mail server including a receiving unit 210 and a sending unit 220. That is, the accepting unit 210 is a unit that receives an e-mail from the data transmission terminal devices 100a to 100b via a telephone line, and attaches information of the accepted time to a data file. This is a means for sending an e-mail marked with a symbol to the Internet 300. The server 200b of the second provider is
The configuration is basically the same as that of the server 200a of the first provider except that it is a server of another provider that receives e-mails from the data transmission terminal devices 100c to 100d. Here, the second transmitting means of the present invention corresponds to the transmitting means 220.

In the case where the same company has a plurality of data transmission terminal devices, the plurality of terminal devices are configured to always transmit data to the server of the same provider. This will be further described later.

On the other hand, the server 400 is a server device located in Japan, and stores a plurality of mailboxes 410 for storing e-mails from overseas companies including China in each region.
a, 410b, etc. Mailbox 4
10a is a means for storing e-mails from Chinese affiliates, and mailbox 410b is a means for storing e-mails from European affiliates. Each of the data receiving terminal devices 500a and 500b
From the telephone line 410, the mailboxes 410a, 4
This is a means for receiving the e-mails stored in 10b and restoring and processing data such as monthly reports transmitted from each overseas affiliated company. Data receiving terminal device 500a
Is a means for accessing the mailbox 410a, and the data receiving terminal device 500b is a means for accessing the mailbox 410b.

Next, the data transmission terminal device 100a,
And the internal configuration of the data receiving terminal device 500a,
This will be described in more detail with reference to FIGS. The other data transmission terminal devices 100b to 100d and data reception terminal device 500b have the same configuration as that shown in FIG.

First, the internal configuration of the data transmission terminal device 100a will be described.

As shown in FIG. 2A, display / input means 1
Numeral 01 denotes a means for displaying a management overview menu screen for inputting initial data, receiving initial data input, and receiving data input to the displayed worksheet 310 (see FIG. 3). When receiving data input to the worksheet 310, the display / input unit 101 first displays an image of the worksheet 310 used for data input on a display (not shown), and the operator displays the image. This is a means for inputting data by using a keyboard (not shown) or the like at a predetermined position on the worksheet 310 while watching. The display / input unit 101 is a unit that displays input data at a corresponding position on the worksheet 310 on the display. The worksheet 310 is, for example, Exc
el worksheet, data transmission terminal device 100
a in advance.

The transmission data creation means 102 is means for creating transmission data by associating the data input by the display / input means 101 with the position information of the data on the worksheet 310. The transmission data is
It is described in CSV format, and includes initial data input on the management overview menu screen. The initial data includes a business office code used as a transmission file name, a name of an input person, a date of a monthly report to be input, and the like.

The encryption means 103 includes a part of the initial data (for example, the date of the monthly report) and the worksheet 3 in the transmission data created by the transmission data creation means 102.
This is a means for encrypting the input data to 10. By the encryption unit 103, the transmission data is converted to CSV
Format to ASC format. The encryption in the present embodiment uses an international version of PGP.

The transmission file creation means 104 outputs encrypted data which is output from the encryption means 103 and data which has not been subjected to encryption such as a business office code which is output from the transmission data creation means 102. This is a means for creating an e-mail transmission file for.

The transmission means 105 transmits the transmission file created by the transmission file creation means 104 to the server 200a of the first provider by using mail software.
This is a means for transmitting using a telephone line. Transmission means 1
Reference numeral 05 denotes a means for giving a file transmission time to the transmission file by using the mail software.
Here, the first transmission unit of the present invention corresponds to the transmission unit 105. If the same provider has a plurality of access points (not shown), the data may be transmitted to the access point closest to each office.
The data is sent to the provider's server via the access point.

Next, the internal configuration of the data receiving terminal device 500a will be described with reference to FIG.

As shown in FIG. 2B, the receiving means 501
Is a means for acquiring the e-mail stored in the mailbox 410a (see FIG. 1) for the Chinese headquarters provided in the server 400.

The extracting means 502 searches for a file to be processed from the plurality of acquired transmission files,
It is a means to extract. The decryption unit 503 is a unit that decrypts the extracted transmission file.

The arranging means 504 converts the decrypted data into a predetermined worksheet 71 based on a certain rule.
0 (see FIG. 7) for each company, and display on a display (not shown). The predetermined worksheet 710 corresponds to the worksheet 310 used on the data transmission terminal device 100a side. The worksheet 710 is an Excel worksheet and is held in the data receiving terminal device 500a in advance. Note that the second frame of the present invention corresponds to the worksheet 710.

The data processing means 505 is provided for the worksheet 7
This is means for processing the data developed on 10 according to various purposes.

In the above configuration, the operation of the present embodiment will be described next, and an embodiment of the data transmission / reception method of the present invention will be described at the same time. In the following description, in the first half (1), the operation of the data input terminal device in China will be described, and in the second half (2), the data receiving terminal device in Japan will send the data via the server of the local provider. The receiving operation will be mainly described.

(1) Here, with reference to FIGS. 3 to 5, description will be made focusing on the case where an operator of a Chinese affiliate transmits data of a monthly report (flash report) for April 1998.

FIG. 3 is a diagram showing a worksheet 310 used for a monthly report (flash report). FIG. 4 shows an example of the C to be encrypted created by the transmission data creating unit 102.
It is a figure showing data of SV format. FIG. 5 is a diagram showing an example of data encrypted by the encryption unit 103. Note that the encrypted data shown in FIG.
Although it does not always match the one actually encrypted by the GP international version, for the sake of explanation, the description will be continued assuming that the contents of FIG. 4 are encrypted.

The operator operates the data transmission terminal 100
In a, start up the software for data entry and display
A management overview menu screen (not shown) is displayed on the display of the input unit 101. The operator inputs the following data as initial data using the display / input means 101 according to the instruction while watching the display screen.

That is, first, in order to select Chinese from among three languages, Japanese, Chinese, and English, a display button indicating the selection is clicked. next,
Enter the company code, the operator's name, and the name in the seal box. The company code is assumed to be 29064. Also, as the year and month of the monthly report to be entered, 199
Select 8 years and April in the list box on the screen. Finally, by clicking the input button on the screen, the display on the display is changed to the data input worksheet 31.
The display screen changes to 0 (see FIG. 3). Here, the items of this worksheet 310 are displayed in Chinese. That is, each item is displayed in the language selected when inputting the initial data. FIG. 3 shows a worksheet 310 in Japanese display for convenience of explanation. Also, FIG.
As an input result of the initial data, a company code column 301
29064, and the year / month column 302, April 1998
Monthly is displayed, and the situation where data input to each item described below is completed is shown.

Next, the operator operates the worksheet 3
Breaking news column 303, planning column 304, previous year column 3 within 10 frames
05, Data is sequentially input to the previous month confirmation column 306 and the general condition column 307. Here, the places to be input on the worksheet 310 are uncolored, so that they can be distinguished at a glance from the colored areas applied to the places that need not be input. In the general condition column 307, comments such as a general production condition and a general sales condition are input in Chinese. After the input of these data is completed, the operator clicks the transmission data creation button image 308 shown in FIG.

When the transmission data creation button image 308 is clicked, the transmission data creation means 102 to the transmission file creation means 104 perform the following series of operations.

That is, the transmission data creating means 102 associates the input data on the worksheet 310 with the position information and transmits the transmission data (FIG. 4) as follows.
See). Here, FIG. 4 is a conceptual diagram illustrating transmission data to be encrypted.

That is, the bulletin column 303 of the worksheet 310
, From the top row in FIG. 3 downward, 130, 80, 10,... -30,-,
−, 80, and 10 are displayed in this order. The transmission data creation unit 102 sets the top row 303a of the
, The data input to the bottom row 303b are arranged in that order as shown in FIG. That is, as shown in FIG.
In front of the data group 401, year and month data of the year and month column 302 (indicated by reference numeral 410 in FIG. 4) and a column identifier indicating that it is the flash report column 303 (FIG.
In this example, 1 is arranged as the reference numeral 411). Similarly, data is arranged in other columns, that is, data input to the plan column 304 to the general condition column 307. Note that the column identifier 411 is the plan column 304 and the previous year column 30
5, in the order of the previous month's confirmation column 306 and the general condition column 307,
3, 4, and 5. Last data group 4 shown in FIG.
05 is the Chinese kanji string data here. The transmission data creation unit 102 sends the data array shown in FIG. 4 to the encryption unit 103, and the input data (here, 29064) to the company code column 301 that becomes the transmission file name
Is sent to the transmission file creation means 104 without encryption.
As described above, the transmission data creating unit 102 creates only the fixed input data as the transmission data, not the data of the entire worksheet, because the data amount of the transmission file is minimized and the transmission time is shortened. It is for planning.
It should be noted that the transmission data does not include the data of the frame itself of the worksheet 310 and the display data of the item names.

The encryption means 103 encrypts the data string sent from the transmission data creation means 102 by the above-mentioned known encryption method (see FIG. 5). FIG.
It is an example of encryption by GP international version. As shown in the figure, according to the PGP international version, numbers, kanji strings, and the like as shown in FIG. 4 are converted into strings of alphabets, numbers, and certain symbols. The reason why certain input data is encrypted is that it is necessary to secure the security of transmission data when transmitting data relating to business secrets on the Internet.

The transmission file creation means 104 displays the transmission file name and the file storage location on the display of the display / input means 101. After confirming the contents, the operator clicks an OK button image (not shown) on the display if there is no problem. When the OK button image is clicked, the transmission file creation unit 104 creates a transmission file from the encrypted data and other input data not to be encrypted using mail software. Also, this transmission file has a transmission file name of 29064cs1. asc is added. here,
The first five characters of the file name are the company code and cs1
Indicates a bulletin. Incidentally, in the case of a certainty report, it is cs2. The last identifier asc indicates that the data includes encrypted data.

Next, the transmission means 105 activates electronic mail transmission software, and instructs the display / input means 101 on the URL (ht) of the server to which the transmission file is to be transferred.
tp: // www. panasonic. co. jp /
GANDAM / china / mail. htm) and an e-mail address for China headquarters (china@pub.me)
i. co. jp). Thereafter, a file selection screen is displayed, and the operator selects a file name to be transmitted and determines the transmission file. When the transmission file is determined, the file transmission time is set for the transmission file (April 17, 1998).
Time information indicating Sunday, Wednesday, 18:28:31) is added (see reference numeral 602 in FIG. 6), and file transmission to the server 200a of the first provider is started.

(2) The above is the data transmission terminal device 100
It is an operation explanation in a. Next, an operation from transmission to the server 200a of the first provider to processing by the data reception terminal device 500a in Japan will be described with reference to FIGS. 1, 2, and 7. FIG.

That is, as shown in FIG. 1, the transmission file transmitted from the data transmission terminal device 100a is received by the receiving means 210, and its reception time (1998)
(Wednesday, April 17, 18:56:47) is appended to the transmission file. The transmission file with the reception time information is divided into a plurality of packets by the transmission unit 220 and transmitted to the Internet 300.

Here, the reception time information attached to the provider server will be further described.

A transmission file of a monthly report having a different creation time may be resent from a Chinese affiliated company. Such retransmission data is usually a modified version of the previously created transmission file in many cases. Therefore, the data receiving terminal device 500a needs to process the latest data transmission file. However, since the plurality of transmission files are all transmitted from the same business establishment, the file names are all the same, and it is not possible to judge which one is the latest from the file name alone. Thus, even if the time when the transmission file arrived at the Chinese headquarters mailbox 410a is attached to each file, and the arrival time information is used to discriminate the new and old transmission files having the same file name, as described above, the transmission file is transmitted over the Internet. Since the packet is transmitted above, the following problem occurs.

In other words, in the case of packet transmission, the relationship between the transmission time of the transmission file on the Internet and that of the transmission time of the transmission file to the destination mailbox 410a may be reversed. In other words, the transmission route on the Internet of each transmission file is different, and a file transmitted earlier may arrive at a mailbox of the same destination later than a file transmitted later.

Therefore, in order to determine which of the transmission files having the same file name is the latest, it is preferable to use time information given before the file is transmitted to the Internet. In the present embodiment, the transmission time of the transmission file in the transmission unit 105 of the data transmission terminal device 100a is used. Incidentally, even if the absolute time of the internal clock of the data transmission terminal device 100a is incorrect,
If you follow the principle that the same company uses the same sending terminal device, the relationship of the sending file will be preserved,
No problem.

On the other hand, various electronic mails arrive at the China headquarters mailbox 410a in Japan via the Internet 300, and are sequentially accumulated.

The operator of the accounting section of the headquarters of China obtains all the electronic mails stored in the mailbox 410a for the headquarters of China by the receiving means 501 of the data receiving terminal device 500a shown in FIG.

Specifically, the operation of receiving the e-mail by the receiving means 501 is performed as follows using software such as Netscape as a mailer. That is, the receiving unit 501 requests the mail box 410a to transfer all the stored e-mails, and stores the transmission files of all the e-mails transferred to the mailer's inbox holder.

FIG. 6 is a view in which the contents of a transmission file for one mail stored in the holder are partially omitted.
Here, FIG. 6 will be described.

That is, the transmission file in FIG. 6 corresponds to the data of the monthly report described in FIG. In the figure, in the row denoted by reference numeral 601, as described above, the time when the e-mail is transferred to the inbox by the receiving means 501 of the data receiving terminal device 500 a is set to 19.
It is shown at 14:03:06 on Thursday, April 18, 1998. The line denoted by reference numeral 602 indicates that the transmission time of this transmission file in the data transmission terminal device 100a is 18:28:31 on Wednesday, April 17, the same year. In the line with reference numeral 603, the file name of this e-mail is 29064cs
1. asc. Further, reference numeral 60
The line marked with 4 is attached with the encrypted data described in FIG.

The rows denoted by reference numerals 601a to 601c indicate the reception time at each server that has received this transmission file between the data transmitting terminal device 100a and the data receiving terminal device 500a. That is, reference numeral 601
In a, the reception time of this e-mail in the server 200a of the first provider in China is shown to be 18:30:12 on Wednesday, April 17, the same year.
Reference numeral 601b indicates that the reception time of an e-mail sent from the server 200a to the Internet 300 by another server (not shown) is 18:34:50 on Wednesday of the same day. . Reference numeral 601c indicates that the reception time of the same electronic mail that has passed through the another server and received by the server 400 is 18:37:26 on Wednesday of the same day. Here, the number of passing servers is only one as shown in 601b. However, as the number of passing servers increases, the recording of the reception time information further increases.

The e-mail transferred to the inbox includes, in addition to a monthly report to be processed in the present embodiment as shown in FIG. Many are included.

Therefore, next, the extracting means 502
From the e-mails transferred to the inbox, only files necessary for subsequent processing are extracted.

The extracting means 502 first extracts a file having a file name of a transmission file whose extension is a three-digit alphabet is asc, and selects only an encrypted portion from the file. At the time of the extraction, the last three digits of the file name are cs1 or cs2.
, And the file whose last three digits of the alphabet is neither cs1 nor cs2 is determined to be out of the target and is not extracted. In FIG. 6, since the last three digits are cs1, it is determined that the content of the transmission file is a flash report. Further, when there are a plurality of e-mails having the same file name, the transmission time information of the file attached to the e-mails (reference numeral 602 in FIG. 6)
(Corresponding to the file attached with.), And only the transmission file with the latest time is extracted.

In this manner, only the latest reports from all the affiliated companies can be accurately extracted.

Next, the decrypting means 503 decrypts the encrypted portion 604 of the transmission file extracted from the plurality of transmission files shown in FIG. 6, for example, to change the data format. Return to the CSV format state as shown in FIG.

Further, the arrangement means 504 operates as follows.
The data decoded as described above is stored in a predetermined worksheet 71.
Fit within the zero frame.

That is, since the arrangement means 504 knows that the content of the transmission file is a preliminary report as described above,
From a plurality of types of worksheet data stored in advance, call the worksheet data corresponding to the flash report, display the frame on the display, and arrange the decrypted data in the frame according to a predetermined rule. (See FIG. 7). Here, the predetermined rule is to arrange the data group 401, the preceding date data 410, and the column identifier 411 shown in FIG. 4 in order from the left of the first row as shown in FIG. is there.

FIG. 7 is a diagram showing a state in which the decrypted data is arranged in the frame of the worksheet 710. 7, the leftmost column 701 of the worksheet 710 is shown.
Indicates a row number, and the uppermost row 702 indicates an alphabet indicating a column.

As described above, the worksheet 71 shown in FIG.
Based on the column identifiers displayed in column C of column 0, the correspondence between columns D and subsequent columns and each item of the worksheet 310 shown in FIG. 3 is completely established.
The report contents created in 00a can be accurately reproduced.

When a series of operations from the decoding process to the arrangement process described above are completed for reports from all the companies, the results are recorded on a recording unit (not shown) for each month. still,
Here, the case of the preliminary report of the monthly report has been described. However, the same processing as described above is performed for the report of the final report and the report of the performance forecast.

It should be noted that an e-mail having the same file name as that of the transmission file for which the data has been placed in the worksheet 710 is already stored in the mailbox. Will be described.

In this case, the basic operation of data receiving terminal device 500a is as described above, except for the following. That is, the extracting unit 502 compares the reception time information attached to the transmission file of the newly added e-mail in the inbox with the reception time information of the already processed transmission file with the same file name. If the former reception time is earlier, the subsequent processing is not performed. or,
Conversely, when the former reception time is later, the former data is subjected to the decoding processing and the arrangement processing in the same manner as described above, and the older data already developed on the worksheet 710 is replaced with the new data. It is updated with the data of the transmission file.

The contents of the monthly report (see FIG. 7) developed on the worksheet 710 in this way are transmitted to the host computer of the headquarters accounting headquarters as data of the international connection system. The transmission in this case is a LAN dedicated to the company
Is used.

The data processing means 505 uses the data developed on the worksheet 710 to calculate the management overview of each company and its aggregation, monthly processing (confirmed / planned / previous year), monthly and item-by-item totals, and the like. Then, the processed data is stored in the recording means. Also, based on the exchange rate (end of month / monthly average / period average) obtained from the company-wide exchange system, an overseas sales / manufacturing company performance report is prepared in yen conversion and sent to the headquarters accounting headquarters via LAN. On the other hand, in the data receiving terminal device 500b of the accounting section of the European headquarters, the same processing as described above is performed for reports from the European affiliates.

As described above, according to the present embodiment,
From the perspective of the entire company, duplication of work can be reduced as in the past, and security of important data can be ensured while improving operational efficiency.

By the way, a medium such as a magnetic recording medium or an optical recording medium in which a program for causing a computer to execute the functions of all or a part of each means of the above-described embodiment is prepared and used. Then, the same operation as described above may be executed. In this case, the same effect as described above is exerted.

In the above embodiment, the case where the collected data is reported to the head office is described. However, the present invention is not limited to this. For example, a server storing processing data of the accounting section of each overseas headquarters is connected to the LAN. By constructing the intranet, the following data can be further utilized. That is, for example, by storing the latest various data stored in the storage means of the accounting section of the China headquarters on a WWW server connected to the LAN, the parent company can view the browsing software such as a WWW browser. Using
You can easily refer to the reports of affiliated companies in China, and it is easy to import and process them. This allows
As in the past, the report of the affiliated company in China to the parent company is no longer required by a different route from the report to the head office, making it possible to unify the reporting work of each local company and work at the parent company Is also improved as described above.

The first frame of the present invention corresponds to the worksheet 310 in the above embodiment, and the case where this worksheet is stored in the data transmission terminal device in advance has been described. The present invention is not limited to this. For example, the worksheet 310 may be accessed by using an encryption-compatible Internet browsing software to access an encrypted homepage established by the headquarters' accounting headquarters.
A configuration in which data is downloaded to the data transmission terminal device may be used. In this case, the worksheet can be updated more quickly and reliably, and security can be ensured.

In the above embodiment, the case where data is encrypted to ensure security has been described. However, the present invention is not limited to this. For example, a configuration in which encryption and decryption are not performed may be employed. In this case, the data transmission terminal device:
For example, input means for inputting a predetermined position of a first frame used for data input, transmission file creation means for creating a transmission file including all or a part of the input data, and transmission of the transmission file And a transmitting unit that performs the transmission. The data receiving terminal device is, for example,
There is provided an arrangement means for arranging the transmitted transmission file data at a predetermined position of the second frame corresponding to the first frame based on a common rule.

In the above embodiment, the time information of the present invention is the transmission time of the transmission file in the transmission means of the data transmission terminal device. However, the present invention is not limited to this. The file reception time may be used. In this case, even if the absolute time of the internal clock of the Chinese provider's server is incorrect, if the same company follows the principle of contracting with the same provider,
As far as sending files from the same company are concerned,
Since the relationship can be reliably determined, no problem occurs.
Further, in this case, as described in the above embodiment, it is possible to adopt a configuration in which the same company does not necessarily have to use the same transmission terminal device. That is,
If the same company has multiple data transmission terminal devices, any of the data transmission terminal devices can be used as long as the multiple terminal devices always transmit data to the server of the same provider by the above contract. good. or,
In addition to the above, the time information may be, for example, the creation time of the transmission file in the transmission file creation means of the data transmission terminal device, or the transmission time of the transmission file in the transmission means of a local provider such as a Chinese provider. There may be.

Further, in the above-described embodiment, a case has been described in which the transmission time of the transmission file in the data transmission terminal device is used, and the same company always uses the same transmission terminal device in the same company. However, by observing not only this principle but also the following principle, for example,
Any data transmission terminal device may be used. That is, the principle in this case is that, when a plurality of data transmission terminal devices are provided in the same company, all the internal clocks of the devices are set to be the same. Otherwise, in the case of a transmission file having the same file name, an accurate leading-back relationship may not be maintained.

[0078]

As is apparent from the above description, the present invention has an advantage that the work efficiency can be further improved as compared with the prior art.

[Brief description of the drawings]

FIG. 1 is a configuration diagram showing an overall configuration of a data transmission / reception system according to an embodiment of the present invention;

FIG. 2A is a diagram illustrating an internal configuration of a data transmission terminal device according to the present embodiment. FIG. 2B is a diagram illustrating an internal configuration of a data reception terminal device according to the present embodiment.

FIG. 3 is an explanatory diagram of a worksheet used in the data receiving terminal device according to the embodiment;

FIG. 4 is a diagram showing data to be encrypted created by a transmission data creating unit according to the embodiment;

FIG. 5 is a diagram illustrating an example of data encrypted by the encryption unit according to the embodiment;

FIG. 6 is a diagram in which the contents of a transmission file for one mail stored in a holder according to the present embodiment are partially omitted.

FIG. 7 is a diagram showing a state in which decrypted data is arranged in a frame of a worksheet used in the data receiving terminal device according to the present embodiment;

[Explanation of symbols]

 100a-d Data transmission terminal device 200a Server of first provider 200b Server of second provider 300 Internet 400 Server 410a-b Mailbox 500a-b Data reception terminal device

────────────────────────────────────────────────── ───

[Procedure amendment]

[Submission date] June 3, 1999

[Procedure amendment 1]

[Document name to be amended] Statement

[Correction target item name] Claims

[Correction method] Change

[Correction contents]

[Claims]

[Procedure amendment 2]

[Document name to be amended] Statement

[Correction target item name] 0012

[Correction method] Change

[Correction contents]

[0012]

According to the present invention, there is provided an input means for inputting data at a predetermined position of a first frame used for data input, and encrypting all or part of the input data. Encryption means for encrypting, transmission file creation means for creating a transmission file of the encrypted data, and a first file for transmitting the transmission file as e-mail.
A relay device having a data transmission terminal device having a transmission unit, a reception unit for receiving a transmission file transmitted from the first transmission unit, and a second transmission unit transmitting the received transmission file; A network in which the transmission file from the second transmission means is transmitted, the sequence of data transmission times and the sequence of data reception times do not always match, and a server provided on the network and having a mailbox A transmission file transmitted from the second transmission means to the mailbox via the network from a plurality of e-mails including the transmission file in the mailbox; Extracting means for extracting based on the file name of the file; Data having decoding means for decoding encoded data, and arranging means for arranging the decoded data at a predetermined position in a second frame corresponding to the first frame based on a common rule A reception terminal device, wherein the time information is a creation time of the transmission file in the transmission file creation unit, or a transmission time of the transmission file in the first transmission unit, or a transmission time of the transmission file in the reception unit. Information indicating a reception time or a transmission time of the transmission file in the second transmission means, which is attached to the transmission file ;
In the sending file sent to the mailbox,
When there are a plurality of transmission files having the same file name,
By comparing the time information of each of these transmission files, the latest
This is a data transmission / reception system for extracting a transmission file .

[Procedure amendment 3]

[Document name to be amended] Statement

[Correction target item name] 0013

[Correction method] Change

[Correction contents]

The present invention solves the above-mentioned problems. According to the present invention, data is input to a predetermined position of a first frame used for data input, all or part of the input data is encrypted, and Create a transmission file, send the transmission file as e-mail to predetermined relay means,
The relay means transmits the transmission file to a mailbox of a server provided on a network in which the sequence of data transmission time does not always match the sequence of data reception time, and the network stores the network in the mailbox. A transmission file transmitted through the transmission file is extracted from a plurality of e-mails including the transmission file in the mailbox based on time information and a file name of the transmission file. A data transmission / reception method for decrypting the encrypted data and arranging the decrypted data at a predetermined position in a second frame corresponding to the first frame based on a common rule, The time information indicates the time at which the transmission file was created, or the time at which the transmission file was sent to the relay unit. , Or the time accepted by the transmission file the relay unit, or information indicating the time sent out by the transmission file the relay unit state, and are not subjected to the transmission file, said
In the sending file sent to the mailbox,
When there are a plurality of transmission files having the same file name,
By comparing the time information of each of these transmission files, the latest
This is a data transmission / reception method for extracting a transmission file .

Claims (10)

[Claims] 1. An input means for inputting a predetermined position of a first frame used for data input, an encryption means for encrypting all or a part of the input data, and the encrypted data A data transmission terminal device having transmission file creation means for creating the transmission file of the above, a first transmission means for transmitting the transmission file as e-mail, and a reception means for receiving the transmission file sent from the first transmission means And a relay device having a second transmission unit for transmitting the received transmission file; and a transmission sequence of the transmission file from the second transmission unit. A network that does not always have the same order, a server device having a mailbox provided on the network, Means for transmitting the transmission file transmitted to the mailbox via the network from the plurality of e-mails including the transmission file in the mailbox based on time information and the file name of the transmission file. Extracting means for extracting, decrypting means for decrypting the encrypted data of the extracted transmission file, and storing the decrypted data at a predetermined position in a second frame corresponding to the first frame. And a data receiving terminal device having an arrangement unit for arranging the transmission file based on the rule of the above. A transmission time, or a reception time of the transmission file in the reception unit, or the transmission time in the second transmission unit. Shin file is information indicating a transmission time of data transmission and reception system, characterized in that are attached to the transmission file. 2. The data transmission / reception system according to claim 1, wherein the transmission file transmitted from the relay device to the network is divided into a plurality of packets and transmitted. 3. When there are a plurality of transmission files having the same file name among transmission files transmitted to the mailbox, the time information of each transmission file is compared, and the latest transmission file is determined. 2. The data transmission / reception system according to claim 1, wherein the data is extracted. 4. The data transmission / reception system according to claim 1, wherein both the first frame and the second frame are worksheets for counting data. 5. The method according to claim 1, wherein the first frame is downloaded to the data transmission terminal device by accessing an encrypted homepage using encryption-compatible Internet browsing software. The data transmission / reception system according to claim 1, wherein: 6. An input means for inputting a predetermined position of a first frame used for data input, an encryption means for encrypting all or a part of the input data, and the encrypted data A data transmission terminal device comprising: a transmission file creation unit that creates the transmission file of the above; and a first transmission unit that transmits the transmission file as an e-mail, wherein a relay device is transmitted from the first transmission unit. Receiving means for receiving an incoming transmission file, and second transmitting means for transmitting the received transmission file, to a network in which the pre / post relationship between the data transmission time and the reception time of the data does not always match. The second
The transmission file from the transmission means is transmitted, a server device having a mailbox is provided on the network, and a data receiving terminal device transmits the data from the second transmission means to the mailbox via the network. Extracting means for extracting the transmitted transmission file from a plurality of e-mails including the transmission file in the mailbox based on time information and the file name of the transmission file; Decryption means for decrypting the encrypted data, and arranging means for arranging the decrypted data at a predetermined position in a second frame corresponding to the first frame based on a common rule. The time information may be a creation time of the transmission file in the transmission file creation means or a time in the first transmission means. The transmission time of the transmission file, or the reception time of the transmission file in the reception unit, or the information indicating the transmission time of the transmission file in the second transmission unit, it is attached to the transmission file Characteristic data transmission terminal device. 7. An input means for inputting a predetermined position of a first frame used for data input, an encryption means for encrypting all or a part of the input data, and the encrypted data Receiving means for receiving a transmission file transmitted from the first transmission means of the data transmission terminal device having transmission file generation means for generating the transmission file, and first transmission means for transmitting the transmission file as e-mail. From the second transmission means of the relay device having the second transmission means for transmitting the received transmission file, via a network in which the pre / post relation of the data transmission time and the pre / post relation of the data reception time do not always match. The transmission file sent to the mailbox of the server device provided on the network is stored in the mailbox. Extracting means for extracting, from a plurality of e-mails including the transmission file, based on time information and the file name of the transmission file; decryption means for decrypting the encrypted data of the extracted transmission file; An arrangement means for arranging the decrypted data at a predetermined position of a second frame corresponding to the first frame based on a common rule, the data receiving terminal device comprising: The transmission file creation time in the transmission file creation means, the transmission time of the transmission file in the first transmission means, or the reception time of the transmission file in the reception means, or the second transmission means Indicating the transmission time of the transmission file in the data reception terminal, and attached to the transmission file. 8. Inputting data at a predetermined position of a first frame used for data input, encrypting all or part of the input data, creating a transmission file of the encrypted data, A server provided on a network in which the transmission file is transmitted as e-mail to a predetermined relay unit, and the transmission file is transmitted from the relay unit to a network in which the pre / post relationship between the data transmission time and the reception time of the data does not always match. The transmission file transmitted to the mailbox via the network is transmitted from the plurality of e-mails including the transmission file in the mailbox to the time information and the transmission file. Extract based on the file name, decrypt the encrypted data of the extracted transmission file, and The second of the phased data, corresponding to the first frame
A data transmission / reception method that is arranged at a predetermined position in a frame based on a common rule, wherein the time information is a time when the transmission file is created, or the transmission file is transmitted to the relay unit. Information indicating the time at which the transmission file was received by the relay unit, or the time at which the transmission file was sent out by the relay unit, which is attached to the transmission file. A data transmission / reception method characterized by the above-mentioned. 9. A medium recording a program for causing a computer to execute the functions of all or a part of each of the means according to claim 1. Description: 10. A medium on which a program for causing a computer to execute the functions of all or some of the steps according to claim 8 is recorded.