JP5296435B2 - Transaction brokerage device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To solve the problem that much cost is required for supporting a physical distribution BMS (Business Message Standard) in an order reception system, while large investment is required for development when AS2 (Applicability Standard 2) or ebXML (electronic business Extensible Markup Language) are adopted. <P>SOLUTION: A transaction mediation device 100 is provided with: a storage device 10; an order data analysis part 20; an order registration part 30; an order reception collation part 40; a transaction data reading part 50; an order reception display control part 60; and an item control part 70. The storage device 10 stores an item management table 12; a distribution BMS correspondence table 14 and a transaction master table 16. The transaction mediation device 100 converts and stores order data 132 compatible with the distribution BMS. An order receiver accesses the transaction mediation device 100 through the Internet or the like, and acquires an order reception state. In this case, the transaction mediation device 100 refers to the item management table 12, and displays designated display items in the transaction data. <P>COPYRIGHT: (C)2010,JPO&amp;INPIT

Description

  The present invention relates to an apparatus that mediates transactions.

  In recent years, the introduction of the distribution business message standard (hereinafter referred to as distribution BMS) has been promoted by the foundation of the distribution system development center, with the aim of further increasing the efficiency and efficiency of the distribution industry. The distribution BMS is a general-purpose EDI (Electronic Data Interchange) format and is described in an XML (Extensible Markup Language) language. The XML language is a language that describes a document structure using marks called tags.

  It is assumed that data conforming to the format of the distribution BMS is transmitted using a communication protocol such as AS2 (Applicability Statement 2) or ebXML (electronic guidance XML).

Until now, contractors such as wholesalers and manufacturers have built their own order systems for distribution BMS.
JP 2001-216371 A JP 2001-229226 A

  However, even if the order receiving system is designed to support the distribution BMS, the cost is high, and if the specification is compatible with AS2 and ebXML, a large investment is required for the development.

  The present invention has been made in view of these problems, and an object thereof is to provide a transaction intermediary device that enables introduction of a distribution BMS at a low cost.

  One embodiment of the present invention relates to a transaction mediating apparatus. This transaction intermediary device is a device that mediates transactions between the orderer and the contractor, and includes a transaction master table that associates the orderer, the contractor, and the transaction data, and display items of transaction data for each orderer. It is a standard format for the item management table to be managed and the data exchanged between the orderer and the contractor, and the distribution business message from the ordering data according to the distribution business message standard described in the XML (Extensible Markup Language) language An order data analysis unit that extracts transaction data based on the standard format, an order registration unit that updates the transaction master table based on the extracted transaction data, and the contractor confirms the order status from the orderer with the transaction Transaction data corresponding to the contractor and the ordering party A transaction data reading unit to be read from the mail, and an order display unit to display a display item corresponding to the orderer with the transaction among the read transaction data with reference to the item management table.

Here, the “display item” includes the order date, transaction number, delivery date, original unit price, selling unit price, order quantity, and the like.
The “distribution business message standard” may be a standard format established in 2007 by the distribution system standardization project of the Ministry of Economy, Trade and Industry.

  According to this aspect, the contractor can confirm the order status without directly exchanging data according to the distribution BMS with the orderer. Therefore, the contractor can reduce the cost for introducing the distribution BMS. In addition, the order display unit refers to the item management table using the orderer as a key, and determines the items to be displayed. Therefore, display items can be controlled for each orderer.

  It should be noted that any combination of the above-described constituent elements, or those obtained by replacing the constituent elements and expressions of the present invention with each other between apparatuses, methods, systems, computer programs, recording media storing computer programs, and the like are also included in the present invention. It is effective as an embodiment of

  According to the transaction mediating apparatus according to the present invention, it is possible to reduce the cost when introducing the distribution BMS. Alternatively, it is possible to reduce the time required until the development period or operation of an order receiving system having specifications that support distribution BMS.

  The present invention will be described below based on preferred embodiments with reference to the drawings. The same or equivalent components, members, and processes shown in the drawings are denoted by the same reference numerals, and repeated descriptions are omitted as appropriate.

  The embodiment of the present invention provides a transaction intermediary device that receives and stores order data according to a distribution BMS, and displays the order status in the order specified by the orderer for the orderer who has accessed through the Internet or the like. provide.

  FIG. 1 is a block diagram illustrating functions and configurations of a transaction mediating apparatus 100 according to an embodiment and a terminal connected thereto. Each block shown here can be realized in hardware by an element such as a CPU of a computer or a mechanical device, and in software it is realized by a computer program or the like. Draw functional blocks. Therefore, those skilled in the art will understand that these functional blocks can be realized in various forms by a combination of hardware and software.

The transaction intermediary device 100 is connected to the contractor terminal 140 through the communication network 110 and is connected to the orderer terminal 130 through the communication network 120. The communication network 110 is the Internet, for example. The communication network 120 includes communication means such as a LAN (Local Area Network), a WAN (Wide Area Network), and the Internet.
The transaction intermediary device 100 includes a storage device 10, an order data acquisition unit 15, an order data analysis unit 20, an order registration unit 30, an order inquiry unit 40, a transaction data reading unit 50, and an order display control unit 60. And an item control unit 70.

  The storage device 10 stores an order database 11, an item management table 12, a distribution BMS correspondence table 14, and a transaction master table 16.

  The order data acquisition unit 15 receives order data 132 according to the distribution BMS from the orderer terminal 130 via the communication network 120. The received order data 132 is stored in the order database 11 as it is.

  The contractor logs in to the transaction mediating apparatus 100 through the communication network 110. Then, the order inquiry unit 40 displays an order inquiry screen 800 (detailed in FIG. 8) on the display 142 of the orderer terminal 140 through the communication network 110. The contractor uses the input device 144 of the contractor terminal 140 to input the orderer who wants to confirm the order status from there. Then, the order confirmation request is input to the transaction intermediary device 100 via the communication network 110 and then transmitted to the order data analysis unit 20, and the data of the orderer and the designated orderer are input to the order inquiry unit 40. Is done.

  The order data analysis unit 20 receives an order status confirmation request from the contractor and acquires the order data corresponding to the contractor from the order database 11. Then, with reference to the distribution BMS correspondence table 14, the order data described in the distribution BMS format is converted into items more easily understood to generate transaction data. Then, the transaction data is output to the order registration unit 30.

  The order registration unit 30 writes the contents of the transaction data received from the order data analysis unit 20 in the transaction master table 16.

  The order receiving inquiry unit 40 outputs the ordering party and the designated ordering party to the transaction data reading unit 50 and activates them, and outputs the designated ordering party to the order receiving display control unit 60.

  After the writing by the order registration unit 30 is completed, the transaction data reading unit 50 refers to the transaction master table 16 and first extracts transaction data corresponding to the contractor. Then, transaction data corresponding to the designated orderer is further extracted from the transaction data. The transaction data extracted in this way is output to the order display control unit 60.

  The order display control unit 60 refers to the item management table 12 and acquires items to be displayed and their order with respect to the designated orderer. Then, items to be displayed among the extracted transaction data are displayed on the display 142 of the contractor terminal 140 through the communication network 110 according to the order of display.

  The item control unit 70 updates the item management table 12 in response to a request from the administrator. The administrator rewrites the item management table 12 through the item control unit 70 so that the display items desired by the orderer and their order are realized.

  FIG. 2 is a data structure diagram of the order data 132. In the distribution BMS, for example, data of a buyer, that is, an orderer is described in an area sandwiched between tags <buyer> and </ buyer>. The data item indicated by this tag is determined in advance, and the orderer describes the order data according to the determined data item. Since the order database 11 stores the order data 132 as raw data, it has the same data structure as FIG.

  FIG. 3 is a data structure diagram of the distribution BMS correspondence table 14. The distribution BMS correspondence table 14 stores distribution BMS tags and corresponding items. Here, the corresponding item is an item that has been changed to an expression that is easier to understand than the data item defined in the distribution BMS. The corresponding item may be different for each orderer or each contractor. In this case, for example, when the business field to which the orderer belongs is different, it is convenient to use expressions suitable for each business field.

  FIG. 4 is a data structure diagram of the transaction master table 16. The transaction master table 16 includes a contractor, a contractor code, an orderer, an orderer code, an order date, a transaction number, a delivery date, a product code, a product name, an original unit price, and a selling price. And the order quantity are stored in association with each other. The transaction data stored in the transaction master table 16 may be deleted by a known method upon completion of the transaction, or may be separately saved as transaction history data by a known method.

  FIG. 5 is a data structure diagram of the item management table 12. The item management table 12 shows display items to be displayed and their order when displaying transaction data relating to the orderer. The display items are classified into essential display items and detailed display items. The mandatory display item indicates an item that is always displayed regardless of the orderer. The detailed display item indicates an item that can be set to display / hide for each orderer. In the present embodiment, the orderer, orderer code, order date, and transaction number are essential display items. The delivery date, the product code, the product name, the original unit price, the selling unit price, and the order quantity are detailed display items. In this case, by setting an item that is absolutely necessary for the transaction as an indispensable display item, it is possible to prevent the display of the item from being forgotten, and by making it possible to set the display / non-display of the detailed display item, It is possible to respond flexibly to requests.

  Further, in FIG. 5, a display order number is assigned to a display item to be displayed for each orderer. In other words, display items with display order numbers are displayed, and display items without display numbers are not displayed. On the order inquiry screen 800 (described in detail in FIG. 8), display items are displayed from the left in ascending order of the display order number. In this case, since the display order of the items can be controlled, it is possible to provide a display screen having a shape more in line with the orderer's intention. Further, the display order number is not necessarily a consecutive number. This is convenient when adding or deleting items. For example, in FIG. 5, if the item “Delivery address” is added for the former mart and it is displayed on the order inquiry screen 800 between the item “Delivery date” and the item “Product code”, the item “Delivery address” What is necessary is just to add to the management table 12 and attach | subject a display order number "6" to it.

  The operation of the transaction mediating apparatus 100 having the above configuration will be described. The transaction intermediary device 100 receives and stores order data according to the distribution BMS from the orderer. The contractor accesses the transaction mediation apparatus 100 through the Internet or the like, and requests display of the order status from the contractor who has a transaction. Then, the transaction intermediary device 100 obtains transaction data between the contractor and the orderer after converting the order data into more easily understandable transaction data, and the orderer requests the item requested by the orderer in the transaction data. To the contractor in the order of

Hereinafter, the flow of processing by the transaction mediating apparatus 100 will be described more specifically using the flowchart and the representative screen diagram. FIG. 6 is a flowchart showing a series of processing by the transaction mediating apparatus 100.
The contractor logs in to the transaction mediating apparatus 100 through the Internet or the like (S602). The transaction intermediary device 100 displays an order inquiry screen 800 for the contractor (S604). FIG. 7 is a representative screen diagram showing the order inquiry screen 800 displayed on the display 142 of the orderer terminal 140. In the contractor display area 802, the contractor who is currently logged into the transaction mediating apparatus 100 is displayed. In the orderer input area 804, the orderer who wants to confirm the order status from the orderer is input. In the search result display area 806, the search result of the order status is displayed. As described in the description of FIG. 5, items as defined in the item management table 12 are displayed in the search result display area 806 in the order as defined.

  The transaction intermediary device 100 accepts a request for confirming the order status from the contractor (S606). This is achieved when the orderer inputs a desired orderer in the orderer input area 804 on the order inquiry screen 800 and clicks a search button 808. Here, consider a case where the contractor “Otsu Foods” inputs the orderer “Ko Mart” as text in the orderer input area 804 and clicks the search button 808.

The transaction intermediary device 100 refers to the distribution BMS correspondence table 14, converts the distribution BMS tag into the corresponding item, thereby converting the order data corresponding to the logged-in contractor to transaction data (S608). Here, referring to the distribution BMS correspondence table 14 of FIG. 3, for example, in the order data, “2008-06-28” described in the area surrounded by the tag <orderDate> and the tag </ orderDate> The value of “day” is read as “2008/6/28”.
Next, the transaction data is written in the transaction master table 16 (S610). The second row 134 of the transaction master table 16 shown in FIG.

  The transaction intermediary device 100 reads transaction data related to the transaction between the contractor and the input orderer from the transaction master table 16 (S612). Referring to FIG. 4, the transaction data of the contractor “Otsu food” and the orderer “Komat” is stored in the first and second rows of the transaction master table 16. The transaction intermediary device 100 reads these two transaction data.

  The items to be displayed and their order corresponding to the input orderer are determined with reference to the item management table 12 (S614), and the items to be displayed in the transaction data are displayed in the search result display area in the order to be displayed. It is displayed on 806 (S616). Referring to the item management table 12 shown in FIG. 5, since the display order number is assigned in ascending order from the left to all of the display items with respect to the orderer “Extra mart”, the search result display area 806 in FIG. All items are displayed in order from the left.

  In order to further explain the display order number, consider a case where the contractor “Otsu Foods” designates the orderer “Kashiwa Store”. FIG. 8 is a representative screen diagram showing an order inquiry screen 900 when the orderer “丙 store” is designated. In the contractor display area 902, the contractor who is currently logged into the transaction mediating apparatus 100 is displayed. In the orderer input area 904, an orderer who wants to confirm the order status from the orderer is input. The search result display area 906 displays the search result of the order status. Here, it is assumed that the contractor “Otsu food” inputs the orderer “丙 store” in the orderer input area 904 as text and clicks the search button 908. Then, the transaction mediating apparatus 100 performs the same operation as that described above. In particular, the order display control unit 60 refers to the item management table 12 shown in FIG. 5, and the item “product code” and the item “unit price” are not assigned display order numbers in the row of the orderer “丙 store”. Make sure. For this reason, the order display control unit 60 does not display the item “product code” and the item “sale unit price”. Furthermore, since the display order number of the item “original unit price” is “17” and the display order number of the item “order quantity” is “14”, the item “order quantity” is displayed in the search result display area 906 in the item “original unit price”. "Is displayed on the left side.

  As described above, according to the transaction intermediary apparatus 100 according to the present embodiment, the contractor confirms the order status by accessing the transaction intermediary apparatus 100 via the communication network without directly receiving the order data according to the distribution BMS. be able to. Accordingly, it is not necessary to maintain a system having specifications that support distribution BMS on the contractor side, and the cost for introducing distribution BMS can be reduced. In addition, this facilitates the participation of small and medium-sized wholesalers and manufacturers who have been reluctant to participate in the distribution BMS due to the size of capital investment, thus facilitating information linkage between companies and the distribution industry as a whole. It is also beneficial for

  In general, the amount of data according to the distribution BMS tends to increase, so that it may take time to transmit data when the contractor has a poor connection environment to the Internet. However, according to the transaction mediating apparatus 100 according to the present embodiment, the contractor does not need to directly receive the data, so the order status can be confirmed more quickly. This contributes to lead time reduction.

  In general, in the field of distribution, items to be displayed in transaction data are different for each orderer. Therefore, conventionally, it has been necessary to develop a display screen of transaction data for each orderer. However, according to the transaction mediating apparatus 100 according to the present embodiment, the order display control unit 60 refers to the item management table 12 and displays the items as specified by the orderer on the order inquiry screen. Therefore, it is possible to save time and effort for developing a display screen for each orderer, thereby reducing costs and reducing the time required for developing and operating the order receiving system. Further, when changing the items to be displayed or their order, it is only necessary to rewrite the item management table 12 by the item control unit 70, so that the change can be dealt with quickly and flexibly.

  The configuration and operation of transaction mediating apparatus 100 according to the embodiment have been described above. These embodiments are exemplifications, and it is understood by those skilled in the art that various modifications can be made to combinations of the respective constituent elements and processes, and such modifications are also within the scope of the present invention. is there.

  In the embodiment, the case where the items are arranged from the left in the ascending order of the display order number in the search result display area 806 of the order inquiry screen 800 has been described. However, the present invention is not limited to this, and the items may be arranged in the order of the display order number. For example, the items may be arranged from the left in descending order of the display order number. The items may be arranged from top to bottom in the order of display order numbers. Thus, the search result can be flexibly displayed according to the preference of the orderer and the contractor.

  In the embodiment, the case where the contractor inputs only the orderer as the search key on the order inquiry screen 800 has been described. However, the present invention is not limited to this, and the search key may be the orderer and at least one other item. Good. For example, it may be configured to perform a search specifying an orderer and a delivery date. In this case, the search key can be set according to the business field in which the transaction mediating apparatus is used, which is convenient.

  In the embodiment, the case where the orderer is input in the orderer input area 804 by text has been described, but the present invention is not limited to this. The order inquiring unit 40 may be configured to request input in Roman characters to the orderer input area 804, for example. Further, as described above, it is possible to set a search key other than the orderer. In this case, in response to the search key, the order inquiry unit 40 specifies in advance input formats such as full-width, numbers, and dates, A configuration other than the specified format may not be accepted. In this case, input errors of the contractor can be reduced.

  In the embodiment, a case has been described in which all items are displayed in one row in order from the left in the search result display area 806. However, the present invention is not limited to this. For example, a two-column display may be used. Furthermore, the configuration may be such that when the items to be displayed are arranged in order from the left, the entire width becomes longer than the window width specified in advance, the display is switched to the two-column display. In this case, it is not necessary to scroll the order inquiry screen 800 horizontally, and the listability is improved.

  In the embodiment, the case of inquiring the order status based on the stored order data has been described. However, the present invention is not limited to this, and the order data is replaced with data sent from the orderer to the contractor, such as receipt data and payment data. May be. Further, a configuration may be further provided in which data to be sent from the contractor to the orderer, such as shipment data and billing data, is converted to data conforming to the distribution BMS by referring to the distribution BMS correspondence table 14 and transmitted to the orderer. . In this case, the transaction can be supported more comprehensively. Also, the orderer specifies the input format such as date format and number of digits for each screen such as the search screen and the delivery date input screen, and the contractor completes the input from the screen and executes the search and saves the data. The designated input format may be checked. In this case, the data format can be adapted to the orderer's preference for each orderer.

  Although the present invention has been described based on the embodiments, the embodiments merely show the principle and application of the present invention, and the embodiments are defined in the claims. Needless to say, many modifications and arrangements can be made without departing from the spirit of the present invention.

It is a block diagram which shows the function and structure of the transaction mediation apparatus which concerns on embodiment, and the terminal connected to it. It is a data structure figure of order data. It is a data structure figure of a distribution BMS correspondence table. It is a data structure figure of a transaction master table. It is a data structure figure of an item management table. It is a flowchart which shows a series of processes by the transaction mediation apparatus of FIG. It is a typical screen figure which shows an order inquiry screen. FIG. 8 is a representative screen diagram showing an order inquiry screen when the search conditions are different from those in FIG.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 10 Storage device, 11 Order database, 12 Item management table, 14 Distribution BMS correspondence table, 15 Order data acquisition part, 16 Transaction master table, 20 Order data analysis part, 30 Order registration part, 40 Order inquiry part, 50 Reading transaction data Part, 60 order display control part, 70 item control part, 100 transaction mediating apparatus, 110 communication network, 120 communication network, 130 orderer terminal, 140 orderer terminal, 800 order inquiry screen.

Claims (3)

A device that mediates transactions between an orderer and a contractor,
A transaction master table that associates the purchaser, contractor, and transaction data;
An item management table for managing display items of transaction data for each orderer;
This is a standard format for data exchanged between the orderer and the contractor, and it is based on the distribution business message standard described in the XML (Extensible Markup Language) language and deals with the format of the distribution business message standard. An order data analysis unit for extracting data;
An order registration unit that updates the transaction master table based on the extracted transaction data;
When the orderer confirms the order status from the ordering party with the transaction, the order inquiring unit accepts the designation of the orderer who wants to confirm the order status from the orderer's terminal through the communication network;
If specified is accepted by the order receiving inquiry unit, a transaction data reading unit for reading transaction data corresponding to the beauty onset Note's Oyo contractor associated with that specified by the transaction master table,
An order display unit that refers to the item management table and displays a display item corresponding to an orderer with a transaction in the read transaction data, on a display of the contractor's terminal through a communication network , and
Display items managed by the item management table include mandatory display items and detailed display items,
Mandatory display items indicate items that are always displayed regardless of the ordering party,
The detailed display item indicates an item that can be set to be displayed or hidden for each orderer . The item management table manages display items of transaction data for each orderer by display order number,
The order display unit refers to the item management table, and among the read transaction data, displays the display items to which display order numbers are assigned for orderers with transactions, in the display order number order. The transaction mediating apparatus according to claim 1. A computer program that mediates transactions between an orderer and a contractor,
The ability to generate a transaction master table associating the purchaser, contractor, and transaction data;
A function for generating an item management table for managing display items of transaction data for each orderer,
This is a standard format for data exchanged between the orderer and the contractor, and it is based on the distribution business message standard described in the XML (Extensible Markup Language) language and deals with the format of the distribution business message standard. The ability to extract data,
A function of updating the transaction master table based on the extracted transaction data;
When the contractor confirms the order status from the orderer with the transaction, the function of accepting the designation of the orderer who wants to confirm the order status from the contractor's terminal through the communication network,
When the specified it is accepted, and the function of reading the transaction data corresponding to the beauty onset Note's Hoyo contractor associated with the specified from the transaction master table,
With reference to the item management table, among the read transaction data, the display item corresponding to the orderer with the transaction is displayed on the display of the contractor's terminal through the communication network , and the computer realizes the function ,
Display items managed by the item management table include mandatory display items and detailed display items,
Mandatory display items indicate items that are always displayed regardless of the ordering party,
The detail display item indicates an item that can be set to be displayed or hidden for each orderer .

Images