JP2013008128A - Business ordering support system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide means (business flow) of exchanging information on timely business with ordering data entered in spread sheet format that a person in charge such as a wholesaler, a commissionaire, and a retailer easily recognizes, and converting the ordering data into a CSV format or XML format that a computer easily recognizes.SOLUTION: A business ordering support system 30 for perishables which has an EDI data generation part is connected to the Internet 20. A retailer terminal 50 transmits an ordering ledger to the business ordering support system 30 for perishables. The business ordering support system 30 for perishables converts data into the XML format after allotting the ordering ledger to ordering information by order destinations, and transmits the converted data to a wholesaler terminal 10.

Description

  The present invention requires an ordering support system between a terminal used by a wholesaler (terminal for a wholesaler) and a terminal used by a retailer (a terminal for retailer), in particular, timely ordering information exchange such as fresh food. About what to do.

  Since 2007, “distribution BMS (Business Message Standard)”, which is an EDI (Electronic Data Interchange) standard specification for the distribution industry, has been formulated and released in stages under the government. The introduction of distribution BMS has advantages such as reducing paper slips and improving efficiency by standardizing operations. Some IT companies have already released EDI systems that comply with this, and EDI communication by distribution BMS is beginning to be realized gradually, mainly by major general merchandise stores (GMS).

  As prior arts related to the distribution BMS as described above, JP 2003-178222 A (Patent Document 1), JP 2007-94772 A (Patent Document 2), JP 11-272742 A (Patent Document). 3) and JP-A-2004-126822 (Patent Document 4).

JP 2003-178222 A JP 2007-94772 A JP 11-272742 A JP 2004-126822 A

  However, in the retail industry, the spread of distribution BMS is delayed more than expected. One reason is that it is difficult to make EDI of ordering information for fresh products, and information is still being exchanged by analog means such as telephone and FAX.

  Ordering of fresh products is difficult to digitize due to the fact that there are cases where the contents of the order and the goods actually received are different, and in the related system of the above-mentioned patent document, timely transfer of ordering information and There is nothing corresponding to EDI data.

  In addition, if a person in charge such as a wholesaler, a middleman, or a retailer involved in a perishable product ordering work with incomplete computer-related knowledge exchanges order data in a format such as XML format, the ordering may take time. is there.

  On the other hand, more than 93 million slips (as of 2008) are exchanged between retailers and wholesalers related to fresh produce. This accounts for more than 40% of all the slips used in the supermarket, and is the business that is most expected to benefit from EDI. For this reason, there is a need for a mechanism that digitizes ordering information exchanged in fresh work and links it to the EDI system.

  The purpose of the present invention is to exchange information in a timely manner using order data written in a spreadsheet format that is easy to recognize for persons in charge such as wholesalers, middlemen, and retailers who participate in distribution BMS. An object of the present invention is to provide means (business flow) for converting order data into CSV format and XML format that are easy for a computer to recognize.

  The above and other objects and novel features of the present invention will be apparent from the description of this specification and the accompanying drawings.

  Of the inventions disclosed in the present application, the outline of typical ones will be briefly described as follows.

  A business ordering support system according to a typical embodiment of the present invention includes an external interface that communicates with the outside, and retrieves an order ledger submission destination from a retailer terminal received from the external interface, and submits the destination The ordering information based on the ordering ledger is sorted every time, the ordering information sorted for each submission destination is converted into the ordering ledger for the wholesaler terminal, the ordering ledger for the wholesaler terminal is converted into EDI data, and the submission destination It is transmitted every time.

  Another business order support system according to a representative embodiment of the present invention includes an external interface that communicates with the outside, a transmission / reception unit that transmits and receives data using the external interface, a control unit, a conversion unit, A business order support system including an EDI data generation unit, wherein a transmission / reception unit receives an order book from a retailer terminal received from an external interface, and a control unit searches for a submission destination of the order book, The conversion unit is instructed to sort the ordering information in the ordering ledger for each submission destination, and to convert the sorted ordering information into the ordering ledger to the wholesaler terminal, and the control unit wholesales to the EDI data generation unit Instructing the generation of EDI data from an order ledger to a vendor terminal is characterized.

  Another business ordering support system according to a typical embodiment of the present invention includes an external interface that communicates with the outside, and searches for and submits the order book submission destination from the wholesaler terminal received from the external interface. Order information based on the order book is sorted for each destination, the order information sorted for each destination is converted into an order book for a retailer terminal, and transmitted to each destination.

  Another business order support system according to a representative embodiment of the present invention includes an external interface that communicates with the outside, a transmission / reception unit that transmits and receives data using the external interface, a control unit, a conversion unit, The transmission / reception unit receives the order book from the wholesaler's terminal received from the external interface, the control unit searches the order book submission destination, and orders the order ledger for each submission destination to the conversion unit. It is characterized by instructing the distribution of information and the conversion of the sorted order information into an order book for a retailer terminal.

  According to the business order support system of the present invention, paperless by converting the order ledger to data, improving the efficiency of aggregation work using the conversion function, and the benefits of using the EDI system by generating EDI data compliant with the distribution BMS You can enjoy it.

1 is an overall view of an operating environment of a perishable business ordering support system according to the present invention. FIG. 10 is a flowchart from the purchase order ledger received from the wholesaler's terminal in the perishable business ordering support system until the perishable business ordering support system converts it and transmits it to the retailer's terminal. This is a flow from the conversion of the order ledger received from the retailer terminal by the perishable business ordering support system and transmission of EDI data compliant with the distribution BMS to the wholesaler terminal. It is a figure showing an example of the table stored in a recording part. It is a figure showing an example of the order ledger transmitted from the terminal for wholesalers. It is a figure showing an example of the order ledger transmitted from the terminal for retailers. It is a flowchart showing the procedure which produces | generates EDI data by the EDI data production | generation part in step S2005.

  In the following embodiment, when it is necessary for the sake of convenience, the description will be divided into a plurality of sections or embodiments. However, unless otherwise specified, it is not irrelevant to one another, and one is related to some or all of the other, details, supplementary explanations, and the like. Also, in the following embodiments, when referring to the number of elements (including the number, numerical value, quantity, range, etc.), especially when clearly indicated and when clearly limited to a specific number in principle, etc. Except for the specific number, the number may be more than or less than the specified number.

  Further, in the following embodiments, it is needless to say that the constituent elements are not necessarily essential unless particularly specified and apparently essential in principle.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings.

  FIG. 1 is an overall view of the operating environment of a fresh food business order support system 30 according to the present invention.

  This perishable business ordering support system includes a wholesaler terminal 10, the Internet 20, a perishable business ordering support system 30, an EDI processing device 40, and a retailer terminal 50.

  The wholesaler terminal 10 is an operation terminal such as a personal computer used by a wholesaler for business purposes.

  The Internet 20 is a network that interconnects computers using Internet protocol technology.

  The perishables business ordering support system 30 is a system for converting ordering ledger data transmitted from the wholesaler terminal 10 and transmitting it to the retailer terminal 50. The fresh food business order support system 30 includes a transmission / reception unit A, a recording unit B, a conversion unit C, an EDI data generation unit D, and a control unit E.

  The EDI processing device 40 is a device for communicating and exchanging the EDI data generated by the business order support system 30 such as fresh food between companies.

  The retailer terminal 50 is an operation terminal such as a personal computer for the retailer to use for business.

  A plurality of wholesaler terminals 10 and retailer terminals 50 may exist. All the components in FIG. 1 naturally have an external interface for communication. Further, if necessary, input means such as a keyboard may be prepared.

  Next, the operation of this system will be described.

  First, the flow of a purchase order from the wholesaler terminal 10 to the retailer terminal 50 will be described.

  FIG. 2 is a flowchart from the purchase order ledger received from the wholesaler terminal 10 in the perishables business ordering support system 30 until the perishables business ordering support system 30 converts it and transmits it to the retailer terminal 50.

  First, the transmitting / receiving unit A receives the order book transmitted from the wholesaler terminal 10, and notifies the control unit E of the fact by interruption or the like (step S1001).

  Next, the control unit E searches the recording unit B for the submission destination of the order ledger linked to the order ledger submission source (step S1002).

  When the submitting source is confirmed, the control unit E instructs the converting unit C to distribute the ordering information based on the ordering ledger for each submitting destination (step S1003).

  When the distribution in step S1003 is completed, the control unit E transmits to the conversion unit C the ordering information distributed for each submission destination to the conversion unit C, and instructs the conversion unit C to convert the ordering information to the retailer terminal 50. (Step S1004).

  When the conversion in step S1004 is completed, the control unit E instructs the transmitting / receiving unit A to transmit the converted order book for the retailer terminal 50 to the corresponding retailer terminal 50 ( Step S1005). In response to this instruction, the transmission / reception unit A transmits an order book for the retailer terminal 50 to the retailer terminal 50.

  Next, the flow of a purchase order from the retailer terminal 50 to the wholesaler terminal 10 will be described.

  FIG. 3 is a flow from converting the order ledger received from the retailer terminal 50 by the perishables business order support system 30 to transmitting EDI data compliant with the distribution BMS to the wholesaler terminal 10.

  First, the transmitting / receiving unit A receives the order ledger from the retailer terminal 50, and notifies the control unit E of the fact by interruption or the like (step S2001).

  Next, the control unit E searches the recording unit B for the submission destination of the order book associated with the retailer terminal 50 that is the transmission source of the order book (step S2002).

  If the submitting source is confirmed, the control unit E instructs the converting unit C to distribute the ordering information based on the ordering ledger for each submitting destination (step S2003).

  When the distribution in step S2003 is completed, the control unit E instructs the conversion unit C to convert the order information distributed for each submission destination into an order book for the wholesaler terminal 10 (step S2004).

  When the conversion in step S2004 is completed, the control unit E generates EDI data (XML format) compliant with the distribution BMS from the order information distributed to each of the converted submission destinations in the EDI data generation unit D ( Step S2005).

  Then, the control unit E instructs the transmission / reception unit A to transmit the EDI data compliant with the distribution BMS generated in step S2005 to the target wholesaler terminal 10 (step S2006). In response to this instruction, the transmission / reception unit A transmits EDI data compliant with the distribution BMS to the wholesaler terminal 10.

  Next, the table stored in the recording unit B referred to in steps S1002 and S2002 will be described.

  FIG. 4 is a diagram illustrating an example of a table stored in the recording unit B.

  In this figure, the order ID and the company code and department code of the order entry ledger, the linked company code and department code are defined for each record.

  The order ID is an order ID given to the received order book.

  There may be a plurality of submission destinations in one order. Accordingly, there is one record for each submission destination, and a duplicate order ID may be given to a plurality of records.

  The submitting company code is an ID for identifying the company that is uniquely assigned to the terminal of the ordering ledger (the wholesaler terminal 10 and the retailer terminal 50). The submitting department store code is an ID for identifying a department store when the company related to the submitting company code has a plurality of department stores.

  The linked submission destination company code is a linked submission destination company code derived from the order ID, the submission source company code, and the submission source department code. Similarly, the submission destination department code is the department code of the submission destination linked from the order ID, the submission source company code, and the submission source department code.

  Next, the order ledger transmitted from the wholesaler terminal 10 received in step S1001 will be described.

  FIG. 5 is a diagram illustrating an example of an order ledger transmitted from the wholesaler terminal 10. The order ledger transmitted from the wholesaler terminal 10 is described in a predetermined format.

  As can be seen from this figure, this order ledger is basically divided into a header part and a table part.

  The header part includes the orderer name, order date, delivery date, and creation date. These are information belonging to the act of “ordering” and are information common to all “ordered products”.

  On the other hand, the table portion represents information in which one record belongs to the ordered item for each ordered item. In one record, item number, product name / standard, product classification, cost per rose, order unit name, indefinite classification, product weight, weight unit, country name, prefecture, place of origin, standard product code .

  Next, the order ledger transmitted from the retailer terminal 50 in step S2001 will be described.

  FIG. 6 is a diagram illustrating an example of an order ledger transmitted from the retailer terminal 50.

  The order ledger in this figure is also divided into a header portion representing information related to “ordering” and a table portion representing information belonging to “ordered goods”.

  The header part includes an order date, a delivery date, and a total order amount.

  The table part can include one or more records. One record includes inquiry ID, supplier name, product name / standard, product classification, unit price, order quantity, order unit name, cost amount, subtotal, indefinite classification, product weight, weight unit, country name, prefecture, and origin Area, standard product code.

  FIG. 7 is a flowchart showing a procedure for generating EDI data by the EDI data generation unit D in step S2005.

  First, the EDI data generation unit D records the order ledger for the wholesaler terminal 10 converted in step S2004 in the recording unit B or the like (step S3001).

  Next, the EDI data generation unit D writes the converted information of the order book for the wholesaler terminal 10 in the work field in the order of the distribution BMS data (step S3002).

  Next, the EDI data generation unit D delimits the written file with “,” and writes it in a CSV file (step S3003).

  Finally, it is converted into the CSV file and XML file converted in step S3003 (step S3004).

  As described above, it is possible to make paperless by converting the order ledger into data, to improve the efficiency of aggregation work using the conversion function, and to enjoy the benefits of using the EDI system by generating EDI data compliant with the distribution BMS.

  As mentioned above, the invention made by the present inventor has been specifically described based on the embodiments. However, the present invention is not limited to the above-described embodiments, and various modifications can be made without departing from the scope of the invention. Needless to say.

  According to the present invention, the visibility of the order ledger to the person in charge of the ordering party (wholesale, retail) can be improved, and the EDI system software based on the distribution BMS data generated based on the perishables related ordering ledger and SaaS can be achieved.

10 ... terminal for wholesalers, 20 ... internet,
30 ... Fresh food business ordering support system, 40 ... EDI processing equipment,
50 ... Retailer terminal,
A ... Transmission / reception unit, B ... Recording unit, C ... Conversion unit, D ... EDI data generation unit, E ... Control unit.

Claims (4)

A business ordering support system including an external interface for communicating with the outside,
Search the submission destination of the order book from the retailer terminal received from the external interface, sort the order information based on the order book for each submission destination, and send the order information sorted for each submission destination to the wholesaler terminal A business order support system, wherein the order ledger for the wholesaler terminal is converted into EDI data and transmitted to each submission destination. A business ordering support system including an external interface that communicates with the outside, a transmission / reception unit that transmits and receives data using the external interface, a control unit, a conversion unit, and an EDI data generation unit,
The transceiver receives the order book from the retailer terminal received from the external interface;
The control unit searches for the submission destination of the order ledger, sorts the ordering information of the ordering ledger for each submission destination with respect to the conversion unit, and from the sorted ordering information to the ordering ledger to the wholesaler terminal Direct conversion,
The business order support system, wherein the control unit instructs the EDI data generation unit to generate EDI data from an order book for a wholesaler terminal. A business ordering support system including an external interface for communicating with the outside,
Search the submission destination of the order ledger from the wholesaler terminal received from the external interface, sort the ordering information based on the order ledger for each submission destination, and place the ordering information sorted for each submission destination into the retailer terminal A business order support system, wherein the system is converted into an order ledger and transmitted for each submission destination. A business ordering support system including an external interface that communicates with the outside, a transmission / reception unit that transmits and receives data using the external interface, a control unit, and a conversion unit,
The transceiver receives the order book from the wholesaler terminal received from the external interface;
The control unit searches the submission destination of the order ledger, sorts the ordering information of the order ledger for each submission destination with respect to the conversion unit, and from the sorted ordering information to the ordering ledger to the retailer terminal A business order support system characterized by instructing conversion.

Images