JP3955689B2 - Transmission relay device - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention is a data transmission between a store system built in a store and a headquarters system built in a headquarters that manages the store, and a headquarters system and a business partner such as a wholesaler, a wholesaler, a manufacturer, etc. The present invention relates to a transmission relay device that relays data transmission to and from a customer system.
[0002]
[Prior art]
For example, in a retail enterprise with chain stores, a store system called a POS (Point Of Sales) system is built at each chain store and sold at the store using the store computer that forms the core of this store system. In addition to collecting various data related to each product, a host computer is installed at the headquarters that manages each chain store and is connected to the store computer of each chain store via a network. The data collected by the store computer of each chain store is collected by the host system of the headquarters via the network, and information processing such as analysis and processing is performed to support the headquarters in charge of operations necessary for store operation. Such a store management system is used.
[0003]
Recently, in order to distribute the information processing that has been performed comprehensively by the host computer so far, multiple computers are installed at the headquarters for the type of business required for store operation, and each computer is connected to a communication line. To establish a headquarters system by connecting to the communication system of the headquarters system, for example, by providing a transmission relay device that relays data transmission between the headquarters system and the store system of each chain store. Has received a data sent from the store computer of each chain store, a store management system has been developed that automatically selects and distributes the computer of the headquarters system that utilizes the data.
[0004]
By the way, the data collected by the headquarters from each chain store includes the sales results of each product unit (sales points and amount during normal sales, number and amount of sales during special sales, latest sales date, number of discounts) Single item settlement data indicating the sales amount of each item, and department settlement data indicating the sales results of each unit into which each product is classified.
In addition, operations necessary for store operations at the headquarters include business management operations such as managing the cash holdings of the entire corporate entity from the single item settlement data and the department settlement data, and managing losses due to part-time sales and out of stock. , Store management business that manages the appropriateness of the product lineup and the appropriateness of discounts from the individual item settlement data and department settlement data, and manages the best-selling and deadly products from the single item settlement data And product management services that manage product turnover.
[0005]
Therefore, when the head office system is constructed by connecting the information processing computer for business management operations, the information processing computer for store management operations, and the information processing computer for product management operations through a communication line, the transmission relay device The received data is distributed to each computer when individual product settlement data is received from, and the received data is distributed to information processing computers for business management operations and information processing computers for store management operations when department settlement data is received. Thus, the distribution destination of the data is controlled so as not to be distributed to the information processing computer for the product management work.
[0006]
On the other hand, the store system built in each chain store usually has a single product master file preset with single product information such as single product code, single product name, unit price of each product sold in its own store, etc. in the store computer etc. Based on the information of the single product master file, single product sales registration of each product is performed. In addition, the single product master file of each chain store is centrally managed by the headquarters, and if there is a change in assortment, unit price, etc., a single product is transferred from the head office system to the store system of each chain store via a transmission relay device. Send maintenance data for each master file. Therefore, each store system that has received the maintenance data updates the single product master file by reflecting the maintenance data in its own single product master file.
[0007]
By the way, there are several types of store systems depending on the function and ability of the store system according to the size and form of the store, and the structure of the single item master file differs depending on the type. For this reason, when different types are mixed in a plurality of store systems managed by one headquarter system, in the transmission relay device, the maintenance data of the single item master file received from the headquarter system is a single item of the store system that is the transmission destination. It was converted to data that matched the configuration of the master file and then sent to the corresponding store system.
[0008]
Recently, a computer system (hereinafter referred to as a supplier system) has been established for each business partner in order to streamline the ordering and receiving operations for merchandise between the head office and business partners such as wholesalers, wholesalers, and manufacturers. At the same time, each customer system and the head office system are connected by ISDN (Integrated Services Digital Network) or the like, and ordering data is exchanged by online transmission.
[0009]
Even in this case, there are several types of supplier systems that have different functions and capabilities according to the size and form of the supplier, and the configuration of the ordering data differs depending on the type. For this reason, when different types are mixed in a plurality of customer systems managed by one headquarters system, the ordering data received from the headquarters system can be processed by the client system that is the destination in the transmission relay device. It was sent to the relevant customer system after being converted into correct data.
[0010]
[Problems to be solved by the invention]
However, in a transmission relay device that relays data transmission between a conventional head office system and each store system, the information processing computer of the head office system to which data received from the store system is distributed is fixed by a program. It was decided and operated. In addition, since the data sent from the store system covers many items, the transmission relay device converts the data so as to eliminate unnecessary items according to the information processing computer of the transmission destination and distributes it. The data conversion processing in this case was also fixed by the program.
[0011]
For this reason, if the organization of the information processing computer that utilizes data collected from the store system changes due to a change in the headquarters system or the contents of data conversion change, it is necessary to modify the program and easily deal with it It was difficult. Further, since the contents of the data conversion process are determined in one way by the program, even if an item required for one information processing computer is unnecessary for another information processing computer, it is unnecessary for the latter information processing computer. The item could not be removed. In addition, since the transmission relay device receives data from the store system and transmits it to the corresponding information processing computer as soon as it is converted, the data from the store system is transmitted when the load on the information processing computer is heavy. In some cases, the processing efficiency of the computer is reduced.
[0012]
On the other hand, the data transmitted from the head office system to each of a plurality of store systems of different types are also transmitted after being converted into a form suitable for the type of the destination store system by a preset program, as described above. Therefore, if the contents of data conversion differ due to changes in the store system, etc., there is a problem that the program needs to be corrected and cannot be easily dealt with. Further, data conversion from one data to a plurality of different store systems has not been performed at the same time.
[0013]
Similarly, in the transmission relay device that relays data transmission between the headquarters system and each supplier system, the ordering system data to be sent to the supplier system is the type of the destination supplier system by a preset program. Since the data was transmitted after being converted into a form adapted to the above, if the contents of the data conversion differ due to changes in the supplier system, etc., there was a problem that correction of the program was necessary and could not be easily handled. Further, data conversion from one data to a plurality of different customer systems has not been performed at the same time.
[0014]
The present invention has been made based on such circumstances, and a first object of the present invention is a form in which data collected from a store system can be processed by an information processing computer of a headquarter system utilizing the data. Easy to use without changing the program even if the organization of the information processing computer that uses the data collected from the store system changes or the content of the data conversion changes due to the change of the headquarters system It is an object of the present invention to provide a transmission relay device that can cope with the above.
In addition to the first purpose, the second purpose is that when one type of data collected from the store system is utilized in a plurality of information processing computers, the data is simultaneously processed by each information processing. It is an object of the present invention to provide a transmission relay device that can perform relay transmission after converting data into only necessary items in a computer.
In addition to the first object, the third object is that the information processing computer needs to convert data converted into a form that can be processed by the information processing computer collected and used from the store system. It is an object of the present invention to provide a transmission relay device that can perform relay transmission at any time.
[0015]
The fourth object is that data received from the headquarters system is converted to a form that can be processed by the store system that uses the data and then relayed and transmitted. Therefore, it is an object of the present invention to provide a transmission relay device that can easily cope with changes in the conversion contents without changing the program.
In addition to the fourth object, the fifth object is to convert one data received from the headquarters system into a form that can be processed by a plurality of different store systems at the same time and relay it. An object of the present invention is to provide a transmission relay device that can be used.
[0016]
In addition, the sixth object is that the data received from the headquarters system is converted to a form that can be processed by the business partner system that uses the data and then relayed and transmitted. Therefore, an object of the present invention is to provide a transmission relay apparatus that can easily cope with changes in data conversion contents without changing the program.
In addition to the sixth object described above, the seventh object is to convert one data received from the headquarters system into a form that can be processed by a plurality of different customer systems at the same time and relay the transmission. It is an object of the present invention to provide a transmission relay device capable of performing the above.
[0017]
[Means for Solving the Problems]
The invention according to claim 1 of the present application is a store system that stores and manages various data relating to each product that is built in a store and sold in the store, and information processing that is built in the headquarters that manages the store and that is necessary for store operations. In a transmission relay device that relays data transmission with a headquarters system provided with a computer for Corresponding to store identification information for identifying each store, a store information storage unit that sets and stores system type information that identifies the type of store system built in the store, and for each system type information of the store system Of data transmitted from the store system to the head office system Set and store types, and for each type of data Table storage unit for setting and storing identification information of an information processing computer that performs information processing using the data and a data conversion parameter for converting the data into a form that can be processed by the information processing computer When When receiving data transmitted from the store system to the headquarters system, From the transmission source determination unit that searches the store information storage unit to acquire the system type information of the data transmission source store system, the system type information acquired by the transmission source determination unit, and the type of received data Search the table storage The system type information and Type of data received When Get information processing computer identification information and data conversion parameters set according to Transmission destination conversion information acquisition means and data conversion parameters acquired by the transmission destination conversion information acquisition means. Received data Change After changing Acquired by the destination conversion information acquisition means Send to the computer for information processing identified by the identification information Data transmission means It is a thing.
Preferably, in this case, as in the invention of claim 2 of the present application, the table storage unit is configured such that the identification information of the information processing computer and the data conversion parameter for each type of data transmitted from the store system to the head office system Can be stored in a plurality of sets. And Destination conversion information acquisition means As a result of searching the table storage unit according to the above, when the identification information and data conversion parameters of a plurality of sets of information processing computers are acquired , Received Each set of received data Acquired After conversion with data conversion parameters Acquired Each information processing computer identified by the identification information is transmitted.
The invention according to claim 3 of the present application is ,shop By type of data transmitted from the pavement system to the headquarters system Use that data for information processing Identification information of information processing computer and For converting data into a form that can be processed by the information processing computer Set and store the transmission time to the information processing computer together with the data conversion parameter Provide table storage . And when the data transmitted from the store system to the head office system is received, the identification information, the transmission time, and the data conversion parameters of the information processing computer set corresponding to the type of data received by searching the table storage unit After the received data is converted with the data conversion parameter, it is transmitted to the information processing computer identified by the identification information when the acquired transmission time is reached.
[0020]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, embodiments of the present invention will be described with reference to the drawings.
First, the data corresponding to the transmission relay apparatus according to claims 1 to 3, wherein the data collected from the store system is converted into a form that can be processed by an information processing computer of the head office system utilizing the data, and then relayed and transmitted. The embodiment will be described with reference to FIGS.
[0021]
In FIG. 1, reference numeral 10 denotes a headquarters system constructed at a headquarters of a retail business entity having a plurality of chain stores. This headquarters system is an information processing computer that performs information processing for various operations necessary for store operations. Store management operations that manage the optimization of product lineups and the optimization of discounts for each store Information processing computer (store management computer) 11 and management information processing computer (business management computer) that manages the cash holdings of the entire corporate body and manages losses due to part-time sales and out of stock 12 and an information processing computer (product management computer) 13 for managing merchandise, which manages popular products, dying products, and manages the turnover rate of the products. Are connected by a LAN line 14. Further, a transmission relay computer 15 as a transmission relay device that relays data transmission between the head office system 10 and the store systems A and B constructed in each chain store is connected to the LAN line 14. .
[0022]
One store system A is connected to the router 16 of the LAN line 14 via a communication network 17 and collects single item settlement data, department settlement data, etc. collected by a store computer (not shown) that forms the center of the store system. This is a type in which data relating to each product sold in the store is transmitted to the head office system 10 by the FTP (File Transfer Protocol) method. On the other hand, the other store system B is connected to a DSU (Digital Service Unit) 18 installed in the headquarters via the ISDN 19, and the same data collected by the store computer is also transferred to the headquarters by the digital communication method. It is of a type that is transmitted to the system 10. Incidentally, at each chain store, one of the store systems A and B is selected and constructed in advance depending on the store size and location conditions.
[0023]
FIG. 2 is a block diagram showing a functional configuration of the transmission relay computer 15. As shown in the figure, the transmission relay computer 15 includes a first data receiving unit 21 that receives data transmitted from one store system A and generated on the LAN line 14 via the router 16, and the other store system B. And a second data receiving unit 22 for receiving the data transmitted and input to the DSU 18. As shown in FIG. 3, the format of data transmitted from both store systems A and B is the actual data d1, the data type code d2 specifying the type of the actual data d1, and the transmission. A transmission source store ID code d3 for specifying the original store is added.
[0024]
The transmission relay computer 15 is a store system A, which is a system built in the transmission source store based on the transmission source store ID code d3 of the data received by the first or second data reception unit 21 or 22. The data received by the first or second data receiving unit 21 or 22 to which information processing computer 11, 12 or 13 via the LAN line 14. A transmission destination determination unit 24 that determines whether to transmit the data, and the store system of the data transmission source store determined by the transmission source determination unit 23 for the data received by the first or second data reception unit 21 or 22; Data processing parameters determined by the data transmission destination information processing computer determined by the transmission destination determination unit 24 can be processed by the information processing computer. The data conversion unit 25 that converts the data into the form, and the data converted by the data conversion unit 25, when the time counted by the clock unit 26 matches the transmission time of the data, the transmission destination And a data transmission unit 27 for transmission to the information processing computers 11, 12, and 13.
[0025]
Further, the transmission relay computer 15 includes a store information table 40 referred to in the processing operation of the transmission source determination unit 23, a job management table 50 referred to in the processing operation of the transmission destination determination unit 24, and the data conversion unit 25. A table storage unit 28 for setting and storing the parameter table 60 to be referred to in the processing operation, and a table maintenance unit 29 for performing maintenance of each table 40, 50, 60 stored in the table storage unit 28.
[0026]
As shown in FIG. 4, the store information table 40 specifies the types of store systems A and B built in the store corresponding to the store ID code as store identification information assigned to each chain store. The system type information (in this embodiment, the type information of the store system A is “XW0” and the type information of the store system B is “M / S”) is set and stored.
[0027]
As shown in FIG. 5, the job management table 50 stores the types of data transmitted from the store systems A and B to the head office system for each system type “XW0” and “M / S” of each store system A and B (see FIG. 5). In this embodiment, both of the store systems A and B transmit two types of single item settlement data indicating the sales result of each product for each item and department payment data indicating the sales result of each unit for classifying each product. In addition, transmission specifying one or more information processing computers 11, 12, and 13 serving as the transmission destination of the data is set as the type of data transmitted from each store system. Destination computer ID code (in this embodiment, the ID code of the store management computer 11 is “COM1”, and the ID code of the business management computer 12 is “ And OM2 ", has been set and stored the to the ID code of product management for the computer as" COM3 "). Further, corresponding to the destination computer ID code, the time hh (hour): mm (minute) at which data is transmitted to the information processing computers 11, 12, 13 specified by the ID code, and the destination computer It is set and stored together with the link parameter code P which is the address of the parameter table 60 in which the conversion parameter when data is transmitted to the information processing computers 11, 12, 13 specified as the ID code is set. ing.
[0028]
The parameter table 60 converts data transmitted from the store systems A and B to the information processing computers 11, 12, and 13 of the head office system 10 into a form that can be processed by the information processing computer that is the transmission destination. The necessary number of parameters are set and stored, and a unique parameter code P is assigned to each conversion parameter.
[0029]
Therefore, in the transmission relay computer 15 having such a configuration, the table maintenance unit 29 is made to function in advance, and data suitable for the current operation is set in the store information table 40, job management table 50, and parameter table 60, respectively. deep.
For example, a store system B is constructed at a chain store with a store ID code [01] and a chain store with a store ID code [03], and a store system A is constructed at a chain store with a store ID code [02]. Then, data is set in the store information table 40 as shown in FIG.
[0030]
Further, there are three destinations for single item settlement data transmitted from each of the store systems A and B: a store management computer 11, a management management computer 12, and a product management computer 13, and the department settlement data is transmitted to a store. If there are two computers, the management computer 11 and the business management computer 12, data is set in the job management table 50 as shown in FIG.
In this case, in the parameter table 60, as shown in FIG. 6, the single item settlement data from the store system B is converted into a form that can be processed by the store management computer 11 corresponding to the parameter code P [001]. A conversion parameter is set, a conversion parameter for converting the single item settlement data from the store system B into a form that can be processed by the business management computer 12 corresponding to the parameter code P [002] is set, and the parameter code P [ [003] corresponding to the parameter code P [004], a conversion parameter for converting the single item settlement data from the store system B into a form that can be processed by the product management computer 13 is set. Conversion parameters for converting the department settlement data into a form that can be processed by the store management computer 11 Set the data, setting the conversion parameters for converting into a form that can be processed department adjustment data from the store system B with management computer 12 in response to the parameter code P [005]. Further, a conversion parameter for converting the single item settlement data from the store system A into a form that can be processed by the store management computer 11 is set corresponding to the parameter code P [101], and corresponds to the parameter code P [102]. Then, a conversion parameter for converting the single item settlement data from the store system A into a form that can be processed by the management computer 12 is set, and the single item settlement data from the store system A corresponding to the parameter code P [103]. Is set to a form that can be processed by the product management computer 13, and the department settlement data from the store system A can be processed by the store management computer 11 corresponding to the parameter code P [104]. Set conversion parameters for conversion to form, and correspond to parameter code P [105] Setting the conversion parameters for converting into a form that can be processed department adjustment data from the store system A with management computer 12.
[0031]
For example, now, the format of single item settlement data transmitted from the store system A (system type [XW0]) includes items “single item code”, “link department”, “name”, “normal unit price”, “normal sales amount”, "Normal sales points", "Special sales 1 unit price", "Special sales 1 sales amount", "Special sales 1 sales point", "Special sales 2 unit price", "Special sales 2 sales amount", "Special sales 2 sales points", "Discount 1" “Store Number”, “Discount 1 Amount”, “Discount 1 Number”, “Discount 2 Number”, “Discount 2 Amount”, “Discount 2 Number”, “Latest Sales Date” Format of single item settlement data transmitted from B (system type [M / S]), item “single item code”, “link department”, “name”, “regular unit price”, “special unit price”, “regular sales amount” ”,“ Normal sales points ”,“ Special sales amount ”,“ Special sales points ” , It is assumed that consists of a "latest sales date", "value No. 引番", "value discount amount", "value circumventive number".
[0032]
In this case, in the store management computer 11, “single item code”, “name”, “regular unit price”, “special unit price”, “regular sale point”, “special sale point”, “latest item” of the individual item settlement data. When each item of “sales date” and “number of discounts” is utilized, parameters for converting single item settlement data 70B from the store system B into processing data 70 of the store management computer 11 as indicated by 71 in FIG. Is set corresponding to the parameter code P [001], and the parameter for converting the single item settlement data 70A from the store system A into the processing data 70 of the store management computer 11 as shown in 72 in FIG. Set in correspondence with code P [101].
[0033]
In the management computer 12, “single item code”, “name”, “link department”, “normal unit price”, “special unit price”, “sales amount”, “sale point”, “ If each item of “discount amount” is utilized, a parameter for converting the single item settlement data 70B from the store system B into the processing data 80 of the management computer 12 as indicated by 81 in FIG. 002] and a parameter for converting the single item settlement data 70A from the store system A into the processing data 80 of the business management computer 12 as indicated by 82 in the figure is the parameter code P [102]. Set according to.
[0034]
Further, in the product management computer 13, “single item code”, “name”, “normal unit price”, “normal sales amount”, “normal sales point”, “sale unit price”, “special unit sales amount” in the individual item settlement data. ”And“ special sales points ”, the parameters for converting the single item settlement data 70B from the store system B into the processing data 90 of the merchandise management computer 13 are shown in FIG. A parameter set to correspond to the code P [003] and a parameter for converting the single item settlement data 70A from the store system A into the processing data 90 of the product management computer 13 as indicated by 92 in FIG. Set in accordance with [103].
[0035]
In this way, the transmission relay computer 15 is program-controlled so as to operate according to the procedure shown in the flowchart of FIG. 10 with data suitable for the current operation set in each table 40, 50, 60. ing.
That is, it waits to receive data from the store system A or the store system B as ST (step) 1. Here, when data from the store system A or the store system B is received by the operation of the first or second data receiving unit 21 or 22, the transmission source determination unit 23 operates as ST2, and the transmission source store of the received data The store information table 40 is searched with the ID code d3, and the store system type information set corresponding to the transmission source store ID code d3 is acquired.
[0036]
Next, the transmission destination determination unit 24 operates as ST3, searches the job management table 50 using the store system type information acquired in the process of ST2 and the data type d2 of the received data, and the system type information and data type. ID codes of one or a plurality of destination information processing computers set corresponding to the transmission time and the corresponding transmission time and link parameter code P are acquired.
[0037]
Next, when the data conversion unit 25 operates as ST4 and the conversion parameter corresponding to the link parameter code P acquired by the operation of the transmission destination determination unit 24 is read from the parameter table 60, the actual data d1 of the reception data is obtained. Conversion is performed based on the conversion parameter. At this time, when a plurality of link parameter codes P have been acquired by the operation of the transmission destination determination unit 24, conversion parameters corresponding to the link parameter codes P are sequentially read from the parameter table 60, and converted into conversion parameters each time. Based on this, the actual data d1 is converted.
[0038]
Next, the data transmission unit 27 operates as ST5, and first, the transmission time acquired by the operation of the transmission destination determination unit 24 is checked. For the data for which the transmission time is set corresponding to the ID code of the destination information processing computer, the data converted by the operation of the data conversion unit 25 is temporarily stored in the memory, and the clock unit 26 measures the time. When the transmitted time coincides with the transmission time, it is transmitted to the information processing computer designated by the corresponding ID code, and the current data reception process is terminated.
On the other hand, for data whose transmission time is not set (= 0) corresponding to the ID code of the destination information processing computer, the ID code immediately corresponding to the data converted by the operation of the data converter 25 is used. Is transmitted to the information processing computer specified in step (3), and the current data reception process is terminated.
[0039]
As described above, in the transmission relay computer 15 according to the present embodiment, the information processing computer that performs information processing using the data for each type of data transmitted from the various store systems A and B to the head office system 10. And a table storage unit 28 for setting and storing data conversion parameters for converting the data into a form that can be processed by the information processing computer. When the data transmitted from the store systems A and B to the head office system 10 is received, the table information is retrieved from the table storage unit 28, and the information processing computer identification information and data conversion set according to the received data type And the received data is converted by the data conversion parameter, and then transmitted to the information processing computer identified by the identification information.
[0040]
Therefore, even when the organization of the information processing computer that utilizes the data collected from the store systems A and B changes due to the change of the head office system 10 or the contents of the data conversion change, the table maintenance unit 29 is operated to store the table. The setting data of the unit 28 may be changed to data suitable for the current operation, and no program change is required, so that it can be easily dealt with in a short time. Further, since no program change is required, the cost required for program development can be reduced.
[0041]
Further, in the present embodiment, in the table storage unit 28, the identification information (ID code) of the information processing computer and the data conversion parameter for various data transmitted from the store systems A and B to the headquarter system 10 respectively. And a plurality of sets can be stored. When the table storage unit 28 is searched by receiving the data transmitted from the store systems A and B to the head office system 10, the identification information and the data conversion parameters of a plurality of sets of information processing computers are acquired. The received data is converted for each set by the data conversion parameter and then transmitted to each information processing computer identified by the identification information.
[0042]
Therefore, one type of received data can be converted into transmission data to a plurality of different information processing computers at the same time, and transmission data to each information processing computer can be converted only to data of items required by the information processing computer. Since unnecessary item data can be reliably excluded, the processing efficiency of the information processing computer can be improved.
[0043]
Further, in the present embodiment, the table storage unit 28 includes the information processing computer identification information (ID code) and the data conversion parameters for each type of data transmitted from the store systems A and B to the headquarter system 10. The transmission time to the information processing computer is set and stored. When the data transmitted from the store systems A and B to the head office system 10 is received, the identification information and the transmission time of the information processing computer set corresponding to the type of the data retrieved by searching the table storage unit 28, After acquiring the data conversion parameter and converting the received data with the data conversion parameter, the data is transmitted to the information processing computer identified by the identification information at the acquired transmission time.
Therefore, since the time for transmitting data to each information processing computer 11, 12, 13 can be set, the data from the store systems A, B is transmitted in a time zone when the load on the information processing computers 11, 12, 13 is low. be able to. Further, the transmission time can be easily changed without changing the program.
[0044]
In the first embodiment, the transmission relay device (transmission relay computer 15) that relays data transmitted from the store systems A and B to the head office system 10 has been described. Even if the data transmitted from the computer to each of the store systems A and B needs to be converted depending on the type of store system, conversion parameters corresponding to the type of transmission data and the identification information of the destination store system are set. The present invention can be similarly applied by providing a table storage unit to be set.
Then, the second embodiment corresponding to the transmission relay device according to claims 4 to 5 in which the data received from the head office system is converted to a form that can be processed by a store system that uses the data and then relayed and transmitted. Will be described with reference to FIGS. 1, 4, and 11 to 16. FIG. In the second embodiment, as in the first embodiment, the transmission relay computer 15 of the store management system shown in FIG. 1 functions as the transmission relay device of the present invention. The description will be made assuming that data (single item maintenance data, etc.) is transmitted from the product management computer 13 to the store systems A and B among the information processing computers 11 to 13 of the system 10.
[0045]
FIG. 11 is a block diagram showing a functional configuration of the transmission relay computer 15 according to the second embodiment. The transmission relay computer 15 includes a data receiving unit 30 that receives data transmitted from the product management computer 13 according to FTP via the LAN line 14. As shown in FIG. 12, the format of data transmitted from the product management computer 13 includes actual data e1, a data type code e2 that identifies the type of the actual data e1, and a transmission that identifies the destination store. A destination store ID code e3 is added, and a destination store ID code e3 can set a plurality of store ID codes, and a plurality of stores can be designated as destinations at the same time.
[0046]
Further, the transmission relay computer 15 determines whether the type of the store system built in the destination store based on the destination store ID code e3 of the data received by the data receiving unit 30 is the type of the store system A. A data conversion parameter for converting the data received by the data receiving unit 30 and the data receiving unit 30 into a form that can be processed by the store system built in the destination store. The parameter acquisition unit 32 to be acquired, the data conversion unit 33 that converts the data received by the data reception unit 30 by the data conversion parameter acquired by the parameter acquisition unit 32, and the data converted by the data conversion unit 33 And a data transmission unit 34 for transmission to the destination store systems A and B. Note that the data transmission unit 34 transmits the converted data via the LAN line 14 via the router 16 when the store system built in the destination store is the store system A, and in the case of the store system B. Is transmitted via the DSU 18.
[0047]
The transmission relay computer 15 includes a store information table 41 referred to in the processing operation of the transmission destination determination unit 31, a job management table 51 referred to in the processing operation of the parameter acquisition unit 32, and the data conversion unit 33. A table storage unit 35 for setting and storing the parameter table 61 to be referred to in the processing operation, and a table maintenance unit 36 for maintaining each of the tables 41, 51, 61 stored in the table storage unit 35.
[0048]
The store information table 41 is the same as the store information table 40 of the first embodiment. As shown in FIG. 4, the store information table 41 corresponds to a store ID code as store identification information assigned to each chain store. System type information for identifying the types of store systems A and B built in the store (also in this embodiment, the type information of the store system A is “XW0” and the type information of the store system B is “M / S”. Is set and stored.
[0049]
As shown in FIG. 13, the job management table 51 is a data type transmitted to the store systems A and B from the product management computer 13 (in this embodiment, formed in the store computers of the store systems A and B). System type information of the store systems A and B to which the data is transmitted and the system type information according to the maintenance data of the single master file, the maintenance data of the special sale master file, the maintenance data of the store master file, etc. The link parameter code P, which is the address of the parameter table 61 in which the data conversion parameter for the store system identified by is set, is stored.
[0050]
The parameter table 61 has as many parameters as necessary to convert the data transmitted from the product management computer 13 to the store systems A and B into a form that can be processed by the store systems A and B as the transmission destinations. A parameter code P is assigned to each conversion parameter. The parameter table 61 can be integrated with the parameter table 60 of the first embodiment.
[0051]
Therefore, in the transmission relay computer 15 having such a configuration, the table maintenance unit 36 is made to function in advance, and data suitable for the current operation is set in the store information table 41, job management table 51, and parameter table 61, respectively. deep.
For example, the store system B is constructed at the chain store with the store ID code [01] and the chain store with the store ID code [03], and the store system A is constructed at the chain store with the store ID code [02]. Then, data is set in the store information table 41 as shown in FIG.
[0052]
Further, assuming that single item maintenance data, special maintenance data and store maintenance data transmitted from the product management computer 13 are transmitted to the store systems A and B, respectively, data is set in the job management table 51 as shown in FIG. Keep it.
In this case, as shown in FIG. 14, in the parameter table 61, conversion parameters for converting the single item maintenance data into a form that can be processed by the store system B corresponding to the parameter code P [901] are set. A conversion parameter for converting the single item maintenance data into a form that can be processed by the store system A is set corresponding to the code P [902], and the special maintenance data is set in the store system B corresponding to the parameter code P [903]. A conversion parameter for converting to a form that can be processed is set, a conversion parameter for converting the special maintenance data into a form that can be processed by the store system A is set corresponding to the parameter code P [904], and the parameter code Corresponding to P [905], store system B processes store data Set the conversion parameters for converting into a form that can be, setting the conversion parameters for converting into a form that can be processed store maintenance data store system A corresponding to the parameter code P [906].
[0053]
For example, now, the format of single item maintenance data transmitted from the product management computer 13 includes items “data type (addition, correction, deletion, cancellation)”, “single item code”, “link department”, “single item name kanji”, It consists of “single product name kana”, “manufacturer name”, “manufacturer code”, “desired price”, “standard unit price”, “original unit price”, “status”, “registration date”, and “lower limit selling price”.
[0054]
In this case, the store system B receives the single item maintenance data including the items “single item code”, “link department”, “name”, “unit price”, “status”, and “control” and receives its own single item master file. 15, the parameter for converting the single item maintenance data 100 from the headquarter system 10 into the single item maintenance data 100B for the store system B corresponds to the parameter code P [901] as indicated by 101 in FIG. And set.
[0055]
Similarly, the store system A includes items “data type”, “registration date”, “single item code”, “link section”, “single item name kanji”, “single item name kana”, “normal unit price”, “manufacturer name”. 15, assuming that the single product maintenance file consisting of “manufacturer code”, “desired price”, “status”, “minimum selling price”, and “original unit price” is received and the self master file is maintained. As shown at 102, a parameter for converting the single item maintenance data 100 from the head office system 10 into the single item maintenance data 100A for the store system A is set corresponding to the parameter code P [902].
[0056]
In this way, the transmission relay computer 15 is program-controlled so as to operate according to the procedure shown in the flowchart of FIG. 16 with data suitable for the current operation set in each table 41, 51, 61. ing.
That is, it waits for reception of transmission data to the store systems A and B as ST1. Here, when the corresponding data transmitted from the product management computer 13 via the LAN line 14 is received by the operation of the data receiving unit 30, all the destination store ID codes e3 are extracted from the received data as ST2.
[0057]
Next, the transmission destination determination unit 31 operates as ST3, searches the store information table 41 with one store ID code among all the extracted transmission destination store ID codes e3, and sets corresponding to the store ID code. The acquired store system type information is acquired. Next, the parameter acquisition unit 32 operates as ST4, searches the job management table 51 with the store system type information acquired in the process of ST3 and the data type e2 of the received data, and determines the system type information and data type. The link parameter code P set corresponding to is acquired. Next, when the data conversion unit 33 operates as ST5 and the conversion parameter corresponding to the link parameter code P acquired by the operation of the parameter acquisition unit 32 is read from the parameter table 61, the actual data e1 of the received data is Convert based on conversion parameters. Next, the data transmission unit 34 operates as ST6, and the data converted by the operation of the data conversion unit 33 is transmitted to the store system of the store designated by the corresponding store ID code via the LAN line 14 or DSU 18. .
[0058]
Thereafter, as ST7, it is determined whether or not there is an unprocessed store ID code among the destination store ID codes extracted in ST2. When there is an unprocessed store ID code, the transmission destination determination unit 31, the parameter acquisition unit 32, the data conversion unit 33, and the data transmission unit 34 are operated in sequence, and the unprocessed store ID code is processed with respect to the unprocessed store ID code. The process execution of ST3, 4, 5, and 6 is repeated.
In this way, if the processes of ST3, 4, 5, and 6 are executed for all the destination store ID codes extracted in ST2, the current data reception process is terminated.
[0059]
As described above, in the present embodiment, store information that sets and stores system type information that identifies the type of store system built in the store corresponding to store identification information (store ID code) that identifies each store. A store information table 41 is provided as a storage unit, and data transmitted from the headquarter system 10 to the store systems A and B according to the system type information of the store systems A and B is converted into a format that can be processed by the store systems A and B. A job management table 51 and a parameter table 61 are provided as conversion parameter storage units for setting and storing data conversion parameters. And when the transmission data which makes a store a transmission destination are received from the headquarters system 10, the store information table 41 is searched, the system type information of the store system built in the data transmission destination store is acquired, and then the job management table 51 and The parameter table 61 is searched to obtain the data conversion parameters set corresponding to the type of transmission data and the system type information, and after the transmission data is converted with the data conversion parameters, the data destination store It is sent to the store system.
[0060]
Therefore, even if the contents of data conversion differ due to changes in the store systems A and B, etc., the table maintenance unit 36 may be operated to change the setting data in the table storage unit 35 to data suitable for the current operation. Since there is no need to change the program, it is possible to easily cope with the problem in a short time as in the first embodiment, and to reduce the cost required for program development.
[0061]
Further, in the present embodiment, when a plurality of stores are designated as transmission destinations of transmission data received from the headquarters system 10, the store information table 41 is searched and the store constructed in the data transmission destination store The system type information of the system is acquired, then the job management table 51 and the parameter table 61 are searched to acquire the type of transmission data and the data conversion parameters set corresponding to the system type information, and the transmission data After the conversion with the data conversion parameters, the process of transmitting to the store system of the data transmission destination store (ST3, 4, 5, 6 in FIG. 16) is repeated for the number of each store designated as the transmission destination. Yes.
Accordingly, since data transmitted from the head office system 10 in a unified format can be converted into a form that can be processed by a plurality of different store systems at the same time and relayed, the store system A, The trouble of creating and sending data for each B can be eliminated.
[0062]
The transmission relay apparatus according to any one of claims 6 to 7, wherein the data received from the head office system is converted into a form that can be processed by an information processing computer of a plurality of customer systems utilizing the data, and then relayed and transmitted. A corresponding third embodiment will be described with reference to FIGS.
[0063]
In FIG. 17, reference numeral 110 denotes a headquarters system constructed at a headquarters of a retail business entity having a plurality of chain stores. As in the first and second embodiments, this headquarter system includes a store management computer 11, a business management computer 12, and a product management computer 13, and these information processing computers 11 to 13 are provided. Connected via a LAN line 14. Further, data transmission between the head office system 10 and store systems A and B respectively constructed in each chain store, and supplier systems A and B constructed in business partners such as wholesalers, wholesalers, manufacturers, etc. A transmission relay computer 111 as a transmission relay device that relays data transmission between the two is connected to the LAN line 14.
[0064]
The head office system 110 creates an order slip or the like in the product management computer 13 on the basis of data relating to the product order generated from the store systems A and B, and transmits the slip file data to the transmission relay computer 111. It distributes to each customer system A and B online via FTP.
Incidentally, each of the customer systems A and B is connected to the headquarter system 110 via the ISDN 19 in the same manner as the store system B. Further, the customer system A and the customer system B are different types having different data item configurations necessary for business operations such as orders.
[0065]
FIG. 18 is a block diagram showing a functional configuration of the transmission relay computer 111 according to the third embodiment. The transmission relay computer 111 includes a data receiving unit 181 that receives the slip file data transmitted from the merchandise management computer 13 according to FTP via the LAN line 14. As shown in FIG. 19, the format of data transmitted from the merchandise management computer 13 is the actual data f1 consisting of a slip header record and a slip detail record, and a data type code f2 for specifying the type of the actual data f1. A destination ID code f3 for specifying a destination business partner is added, and the destination ID code f3 can set a plurality of business partner ID codes, and simultaneously designate a plurality of business partners as destinations. It can be done.
[0066]
The transmission relay computer 111 determines whether the destination customer system is the customer system A type or the customer system B type based on the data destination ID code f3 received by the data receiver 181. A destination determination unit 182 for determining the data, a parameter acquisition unit 183 for acquiring a parameter for data conversion for converting the data received by the data reception unit 181 into a form that can be processed by the destination customer system, A data conversion unit 184 that converts the data received by the data receiving unit 181 using the data conversion parameters acquired by the parameter acquisition unit 183, and the destination customer system A, B And a data transmission unit 185 that transmits the data.
[0067]
The transmission relay computer 111 includes a supplier information table 42 referred to in the processing operation of the transmission destination determination unit 182, a job management table 52 referred to in the processing operation of the parameter acquisition unit 183, and the data conversion unit. A table storage unit 186 for setting and storing the parameter table 62 to be referred to in the processing operation of 184, and a table maintenance unit 187 for performing maintenance of each table 42, 52, 62 stored in the table storage unit 186 are provided. .
[0068]
As shown in FIG. 20, the store information table 42 corresponds to the supplier ID code as the supplier identification information assigned to each supplier, and includes the supplier systems A and B constructed for the supplier. The system type information for specifying the type (in this embodiment, the type information of the supplier system A is “AAA” and the type information of the supplier system B is “BBB”) is set and stored.
[0069]
As shown in FIG. 21, the job management table 52 indicates the type of slip file data transmitted from the product management computer 13 to each of the customer systems A and B (in this embodiment, an order slip for ordering products). System type information of customer systems A and B that are the transmission destination of the data and data conversion parameters for the customer system identified by this system type information are set separately for each file and cancellation slip file for canceling orders) The link parameter code P which is the address of the parameter table 62 is set and stored. The job management table 52 can be integrated with the job management table 51 of the second embodiment.
[0070]
The parameter table 62 requires parameters for converting data transmitted from the product management computer 13 to each of the customer systems A and B into a form that can be processed by the customer systems A and B that are the destinations. Each conversion parameter is assigned a unique parameter code P. The parameter table 62 can be integrated with the parameter tables 60 and 61 of the first and second embodiments.
[0071]
Therefore, in the transmission relay computer 110 having such a configuration, the table maintenance unit 187 is made to function in advance, and data suitable for the current operation is set in the supplier information table 42, the job management table 52, and the parameter table 62, respectively. Keep it.
For example, the supplier system A is established at the supplier (eg, manufacturer) with the supplier ID code [01], and the supplier system B is established at the supplier (eg, wholesaler) with the supplier ID code [02]. If so, data is set in the supplier information table 42 as shown in FIG.
[0072]
Further, assuming that the order slip file data and the cancel slip file data transmitted from the product management computer 13 are transmitted to the customer systems A and B, respectively, data is set in the job management table 52 as shown in FIG. Keep it.
In this case, in the parameter table 62, as shown in FIG. 22, a conversion parameter for converting the order slip file data into a form that can be processed by the customer system A is set corresponding to the parameter code P [501]. In response to the parameter code P [502], a conversion parameter for converting the order slip file data into a form that can be processed by the customer system B is set, and the cancellation slip file data corresponding to the parameter code P [503]. Is set to a format that can be processed by the customer system A, and the cancel slip file data is converted to a format that can be processed by the customer system B in correspondence with the parameter code P [504]. Set conversion parameters.
[0073]
For example, the header record format of the order slip file data transmitted from the merchandise management computer 13 is now composed of the items indicated by the reference numeral 230 in FIG. 23A, and the detailed record format is the reference numeral in FIG. The configuration of each item indicated by H.231 In this case, if the customer system A is the data of each item indicated by the reference numeral 232 in the figure (a) as the header record of the order slip file data, it can be processed, and the detail record is indicated by the reference numeral 233 in the figure (b). If it is possible to process the data of each item shown, parameters for converting the header record and the detail record of the order slip file data as indicated by reference numerals 234 and 235 of FIGS. It is set corresponding to the parameter code P [501].
[0074]
Similarly, if the customer system B is the data of each item indicated by the reference numeral 236 in the figure (a) as the header record of the order slip file data, it can be processed, and the detailed record is indicated by the reference numeral 237 in the figure (b). If the data of each item can be processed, parameters for converting the header record and detail record of the order slip file data as indicated by reference numerals 238 and 239 in FIGS. Set in correspondence with code P [502].
[0075]
In this way, the transmission relay computer 110 is program-controlled so as to operate according to the procedure shown in the flowchart of FIG. 24 in the state where the data suitable for the current operation is set in each table 42, 52, 62. ing.
That is, it waits for reception of transmission data to the customer systems A and B as ST1. Here, when data transmitted from the product management computer 13 via the LAN line 14 is received by the operation of the data receiving unit 181, all the business partner ID codes f 3 of the transmission destination are extracted from the received data as ST 2.
[0076]
Next, the transmission destination determination unit 182 operates as ST3, searches the supplier information table 42 with one supplier ID code among all the extracted supplier ID codes f3, and corresponds to the supplier ID code. Acquires the supplier system type information set. Next, the parameter acquisition unit 183 operates as ST4, searches the job management table 52 with the customer system type information acquired in the process of ST3 and the data type f2 of the received data, and the system type information and data type The link parameter code P set corresponding to is acquired. Next, when the data conversion unit 184 operates as ST5 and the conversion parameter corresponding to the link parameter code P acquired by the operation of the parameter acquisition unit 183 is read from the parameter table 62, the actual data f1 of the received data is Convert based on conversion parameters. Next, the data transmission unit 185 operates as ST6, and the data converted by the operation of the data conversion unit 184 is transmitted from the DSU 18 to the customer system specified by the corresponding customer ID code via the ISDN 19 To do.
[0077]
Thereafter, as ST7, it is determined whether or not there is an unprocessed supplier ID code among the supplier ID codes of the transmission destination extracted in ST2. If there is an unprocessed business partner ID code, the transmission destination determination unit 182, the parameter acquisition unit 183, the data conversion unit 184, and the data transmission unit 185 are operated in sequence, and the unprocessed business partner ID code. The process execution of ST3, 4, 5, 6 is repeated.
In this way, if the processes of ST3, 4, 5, and 6 are executed for all the business partner ID codes extracted in ST2, the current data reception process is terminated.
[0078]
As described above, in the present embodiment, the system type information for identifying the type of the supplier system built in the supplier corresponding to the supplier identification information (the supplier ID code) for identifying each supplier is provided. A supplier information table 42 is provided as a supplier information storage unit for setting and storing, and data transmitted from the headquarter system 110 to the supplier systems A and B according to the system type information of the supplier systems A and B is sent to the supplier system A. , B, a job management table 52 and a parameter table 62 are provided as conversion parameter storage units for setting and storing data conversion parameters for conversion into a form that can be processed by B. And when the transmission data which makes a business partner a transmission destination is received from the headquarters system 110, the system information of the business partner system constructed | assembled in the business partner of the data transmission destination by searching the business partner information table 42 is acquired, and then After searching the job management table 52 and the parameter table 62 to obtain the data conversion parameters set corresponding to the type of transmission data and the system type information, and converting the transmission data with the data conversion parameters, The data is sent to the business partner system.
[0079]
Therefore, even if the contents of data conversion differ due to changes in the supplier systems A and B, etc., the table maintenance unit 187 may be operated to change the setting data in the table storage unit 186 to data suitable for the current operation. Since no program change is required, as in the first and second embodiments, it is possible to easily deal with the problem in a short time and to reduce the cost required for program development.
[0080]
In the present embodiment, when a plurality of business partners are designated as transmission destinations of transmission data received from the headquarters system 110, the business partner information table 42 is searched and the data transmission destination business partners are designated. Acquire system type information of the constructed customer system, and then search the job management table 52 and parameter table 62 to acquire the data conversion parameters set corresponding to the type of transmission data and the system type information. Then, after the transmission data is converted with the data conversion parameter, the process of transmitting to the data transmission destination supplier system (ST3, 4, 5, 6 in FIG. 24) is performed for each supplier specified as the transmission destination. It repeats the number.
Therefore, data transmitted from the headquarter system 110 in a unified format can be converted into a form that can be processed by a plurality of different customer systems at the same time, and relayed and transmitted. Similarly, the headquarters system 110 can eliminate the need to create and send data for each supplier system A and B.
[0081]
In the third embodiment, the relay transmission function of data transmitted from the product management computer 13 of the head office system 110 to the customer system has been described. However, the present invention transmits data from the store system to the customer system. The same can be applied to the data to be processed.
[0082]
【The invention's effect】
As described above in detail, according to the first aspect of the present invention, the data collected from the store system is converted into a form that can be processed by the information processing computer of the head office system that utilizes the data, and then relayed and transmitted. A transmission relay device that can easily cope with changes in the organization of information processing computers that use data collected from store systems or changes in data conversion due to changes in the headquarters system without changing the program it can.
Further, according to the invention described in claim 2, the same effect as that of the invention described in claim 1 is obtained, and one type of data collected from the store system is utilized in a plurality of information processing computers. Even in this case, the data can be relayed after being converted into data of only necessary items in each information processing computer at the same time. Therefore, data with unnecessary items attached thereto is not transmitted to the information processing computer, and the processing efficiency of the information processing computer can be improved.
In addition, according to the invention described in claim 3 of the present application, the data converted into a form that can be processed by an information processing computer collected and utilized from the store system as well as having the same effect as that of the invention described in claim 1 of the present application Can be relayed when the information processing computer is needed. Therefore, the data from the store system can be transmitted in a time zone where the load on the information processing computer is low, and the change of the transmission time can be easily handled without changing the program.
[0083]
Ma Book Change the program even if the data conversion content changes due to changes in the store system, etc., when the data received from the department system is converted to a form that can be processed by the store system that uses the data and then relayed It is possible to provide a transmission relay apparatus that can easily cope with the above.
Ma Book It is possible to convert one data received from a department system into a form that can be processed by a plurality of different store systems at the same time and relay it. Therefore, the information processing computer of the head office system only needs to create and transmit one type of data in a unified format for a plurality of store systems, so that the processing efficiency of the information processing computer can be improved. Can play.
[0084]
Ma Book Even if the data conversion content changes due to changes in the supplier system, etc., the data received from the department system is converted to a form that can be processed by the supplier system that uses the data, and relayed and transmitted. It is possible to provide a transmission relay device that can be easily handled without any change.
Ma Book It is possible to convert one data received from the department system into a form that can be processed by a plurality of different customer systems at the same time and relay and transmit the data. Accordingly, the information processing computer of the headquarters system only needs to create and transmit one type of data in a unified format for a plurality of customer systems, so that the processing efficiency of the information processing computer can be improved. Can be played.
[Brief description of the drawings]
FIG. 1 is a block diagram of a store management system according to first and second embodiments of the present invention.
FIG. 2 is a functional block diagram of a transmission relay computer according to the first embodiment.
FIG. 3 is a view showing a format of data transmitted from the store system to the head office system in the store management system according to the embodiment.
4 is a diagram showing a configuration of a store information table in FIG. 2. FIG.
FIG. 5 is a diagram showing a configuration of a job management information table in FIG. 2;
6 is a diagram showing a configuration of a parameter table in FIG. 2. FIG.
7 is a diagram for explaining an example of conversion parameters set in the parameter table of FIG. 6;
FIG. 8 is a diagram for explaining an example of conversion parameters set in the parameter table of FIG. 6;
FIG. 9 is a diagram for explaining an example of conversion parameters set in the parameter table of FIG. 6;
FIG. 10 is a flowchart showing the operation of the transmission relay computer in the embodiment;
FIG. 11 is a functional block diagram of a transmission relay computer according to the second embodiment.
FIG. 12 is a view showing a format of data transmitted from the head office system to the store system in the store management system according to the embodiment;
13 is a diagram showing a configuration of a job management information table in FIG.
14 is a diagram showing a configuration of a parameter table in FIG.
15 is a diagram for explaining an example of conversion parameters set in the parameter table of FIG. 14;
FIG. 16 is a flowchart showing the operation of the transmission relay computer in the embodiment;
FIG. 17 is a block diagram of a store management system according to a third embodiment of the present invention.
FIG. 18 is a functional block diagram of a transmission relay computer according to the embodiment;
FIG. 19 is a diagram showing a format of data transmitted from the headquarter system to the customer system in the store management system in the embodiment.
20 is a diagram showing a configuration of a supplier information table in FIG.
FIG. 21 is a diagram showing a configuration of a job management information table in FIG.
22 is a diagram showing the configuration of a parameter table in FIG.
FIG. 23 is a view for explaining an example of conversion parameters set in the parameter table of FIG. 18;
FIG. 24 is a flowchart showing the operation of the transmission relay computer in the embodiment;
[Explanation of symbols]
10, 110 ... headquarters system
11 ... Computer for information processing in store management
12 ... Computer for information processing in business management
13 ... Computer for information processing in product management
14 ... LAN line
15 ... Transmission relay computer (transmission relay device)
28, 35, 186 ... Table storage unit
29, 36, 187 ... Table maintenance section
40, 41 ... Store information table
42 ... Supplier information table
50, 51, 52 ... job management table
60, 61, 62 ... parameter table

Claims (3)

A store system that stores and manages various data related to each product that is built in a store and sold in the store, and a headquarter system that is built in the headquarters that manages the store and that has an information processing computer for each operation required for store operation In a transmission relay device that relays data transmission between
A store information storage unit that sets and stores system type information that identifies the type of store system built in the store corresponding to the store identification information that identifies each store;
The information processing computer that sets and stores the type of data transmitted from the store system to the headquarters system for each system type information of the store system, and performs information processing using the data for each type of data a table storage unit that sets stores a data conversion parameter for converting the data into a form that can be processed by the identification information and the information processing computer,
When receiving data transmitted from the store system to the headquarters system, transmission source determination means for searching the store information storage unit and acquiring system type information of a data transmission source store system;
From the type of the data received and acquired system type information by the transmission source determining unit searches the table storage unit, for the information processing that is set corresponding to the type of the data received with the system type information Destination conversion information acquisition means for acquiring computer identification information and data conversion parameters ;
After converts the received data in the data conversion parameters acquired by the destination conversion information acquiring unit, the data transmitting means for transmitting to the information processing computer identified by the identification information obtained by the destination conversion information acquisition means When,
Transmission relay apparatus, characterized by comprising a. The table storage unit can store a plurality of sets of identification information and data conversion parameters for information processing computers for various data transmitted from the store system to the headquarters system, and the transmission destination conversion information acquisition means As a result of searching the table storage unit as described above, if the identification information and data conversion parameters of a plurality of sets of information processing computers are acquired, the data transmission means acquires the received data for each set. 2. The transmission relay apparatus according to claim 1, wherein the transmission relay apparatus transmits the information to each information processing computer identified by the identification information acquired after conversion with a parameter for use. A store system that stores and manages various data related to each product that is built in the store and sold in the store, and a headquarter system that is built in the headquarters that manages the store and that has an information processing computer for each operation required for store operation, In a transmission relay device that relays data transmission between
The identification information of the information processing computer that performs information processing using the data for each type of data transmitted from the store system to the head office system, the transmission time to the information processing computer, and the information processing computer A table storage unit for setting and storing data conversion parameters for converting the data into a form that can be processed is provided. When data transmitted from the store system to the head office system is received, the table storage unit is searched. Obtaining the identification information of the information processing computer, the transmission time, and the data conversion parameter set corresponding to the type of the received data, and converting the received data with the data conversion parameter, Sending to the information processing computer identified by the identification information at the transmission time Transmission relay device according to symptoms.

Images