JP3703294B2 - Proxy order processing apparatus and recording medium - Google Patents

Description

以上のようにして、▲３▼緊急代行指示データをもとに、発注バックアップ２２、商品マスタを参照して緊急代行発注データを自動作成することが可能となる。
【００３８】
図５は、本発明の発注データ例を示す。この発注データは、既述した加盟店の発注装置１が作成して発注処理装置２に送信する発注データの例であって、図示の下記の項目を設定したものである。
【００３９】
・地区本部コード：図４の（ｂ）の発注バックアップの地区本部を設定
・加盟店コード ：図４の（ｂ）の発注バックアップの加盟店コードを設定
・納品日 ：図示外の取引先マスタより納品日を求めて設定
・商品コード ：図４の（ｂ）の発注バックアップの商品コードを設定
・発注数 ：図４の（ｂ）の発注バックアップの数量を設定
・その他 ：
図６は、本発明の説明図（緊急代行発注）を示す。
【００４０】
図６の（ａ）は、▲３▼緊急代行指示データを示す。これは、既述した図４の（ａ）の▲３▼緊急代行指示データと同一であるので、説明を省略する。
図６の（ｂ）は、発注バックアップを示す。これは、既述した図４の（ｂ）の発注バックアップ２２と同一であるので説明を省略する。
【００４１】
図６の（ｃ）は、図６の（ｂ）から地区本部・加盟店コードで抽出したデータの例を示す。
図６の（ｄ）は、加盟店−分類の全体データの例を示す。これは、図６の（ｃ）から図６の（ａ）の地区本部、加盟店、分類コードに一致するデータを抽出したものである。
【００４２】
図６の（ｅ）は、加盟店−取引先の全体データの例を示す。これは、図６の（ｃ）から図６の（ａ）の地区本部、加盟店、取引先コードに一致するデータを抽出したものである。
【００４３】
図６の（ｆ）は、加盟店−分類−取引先の全体データの例を示す。これは、図６の（ｄ）と（ｅ）をマージしたものであり、斜線の部分のように重複したレコードが抽出される場合が存在するので、当該重複した斜線のレコードを削除する。
【００４４】
以上のように、▲３▼緊急代行指示データ中の作成週、地区本部コード、加盟店コードをキーにして発注バックアップ２２中から分類コードおよび取引先コードに対応するものをそれぞれ図６の（ｄ）と（ｅ）に示すように取り出し、これら両者をマージしたときに重複したレコードがあったときに一方を削除して重複しないようにし、発注データの未受信の加盟店の発注データを自動的に代行発注するようにしている。
【００４５】
【発明の効果】
以上説明したように、本発明によれば、加盟店からの発注データもとに発注結果データを生成して発注した加盟店はその発注数、未発注の加盟店には発注数０とし、加盟店マスタを参照して代行発注指示を行い、過去の発注データをもとに代行発注を行う構成を採用しているため、従来の手作業の軽減および入力ミスを無くして迅速化を図ると共に、未発注の加盟店の代行発注を実現できる。
【図面の簡単な説明】
【図１】本発明のシステム構成図である。
【図２】本発明の動作説明フローチャートである。
【図３】本発明の加盟店マスタの説明図である。
【図４】本発明の説明図である。
【図５】本発明の発注データ例である。
【図６】本発明の説明図（緊急代行発注）である。
【符号の説明】
１：発注装置（加盟店、ＰＯＳ）
２：発注処理装置
２１：発注処理手段
２２：発注バックアップ
２３：緊急代行発注処理手段
２４、３２：加盟店マスタ
３：発注監視装置（本部）
３１：発注状況監視手段
３３：緊急代行発注指示手段[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a proxy order processing apparatus and a recording medium for creating order data for products of a plurality of member stores and placing an order.
[0002]
[Prior art]
Conventionally, when the headquarters places an order from a merchant after receiving an order from each member store, the headquarters prepares the same ordering environment as each member store and inputs ordering data at the headquarters based on an order request from each member store. And placed an order with a business partner.
[0003]
In addition, the headquarters heard the type and quantity of products from each member store by telephone, created an order list for each business partner, and placed orders by calling the business partner.
[0004]
[Problems to be solved by the invention]
In the ordering method described above, there is a problem that a lot of manpower is required and an error such as an input error occurs. In addition, there is a problem that the order processing cannot be performed for a member store that does not have an order request.
[0005]
In order to solve these problems, the present invention generates the order result data based on the order data from the member stores and sets the number of orders for the member stores that have been ordered, and the number of orders for the unordered member stores is zero. The purpose is to perform proxy ordering processing with reference to the member store master, reduce manual work, eliminate input errors, speed up, and enable proxy orders from unordered member stores.
[0006]
[Means for Solving the Problems]
Means for solving the problem will be described with reference to FIG.
In FIG. 1, an ordering device 1 creates and transmits ordering data at a member store.
[0007]
The order processing device 2 performs order processing based on order data for each member store received from the order device 1, and includes an order backup 22 and a member store master 24.
[0008]
The order monitoring apparatus 3 monitors the order status.
Next, the operation will be described.
The order processing device 2 receives the ordering data of the product from each member store, and the past of the member store in the order backup 22 automatically or based on an instruction from the headquarters for the member store for which the order data has not been received. Order data is created based on product order data.
[0009]
At this time, automatic agency order classification and closure information were set for each affiliated store in the franchisee master, and for the affiliated stores for which ordering data was not received, there was an automatic agency order classification and the closure information was not closed. Sometimes, the order data is created based on the order data of the past products of the member stores in the order backup 22.
[0010]
Also, as the ordering data of the past merchandise of the member store in the order backup 22, the ordering data of the specified one of the creation week, the member store code, the classification code and the customer code is used to create the ordering data. ing.
[0011]
Also, the created order data is checked for duplication, and the duplicate order data is deleted.
Therefore, the ordering result data is generated based on the ordering data from the member store, and the number of orders for the member store that has been ordered is set as the number of orders for the member store that has not been ordered. By performing the processing, it is possible to reduce the manual work and speed up without making an input error, and it is possible to realize an agency order for an unordered member store.
[0012]
DETAILED DESCRIPTION OF THE INVENTION
Next, embodiments and operations of the present invention will be described in detail sequentially with reference to FIGS.
[0013]
FIG. 1 shows a system configuration diagram of the present invention.
In FIG. 1, an ordering apparatus 1 is a terminal such as a POS provided in a member store, and here, creates and transmits ordering data.
[0014]
The order processing device 2 performs order processing based on order data for each member store received from the ordering device 1, and includes an order processing means 21, an order backup 22, an emergency agency order processing means 23, And a member store master 24 provided as necessary.
[0015]
The order processing means 21 creates (2) order result data based on the order data transmitted and received from the ordering device 1 of each member store and transmits it to the order monitoring device (headquarters) 3 or not received. (2) The order result data of the affiliated stores are set to 0 (zero) and sent to the order monitoring apparatus (headquarters) 3.
[0016]
The order backup 22 stores past order data for each member store.
The emergency agency order processing means 23 refers to the order backup 22 and creates the order data on the basis of the past order data of the member store when the order data from the member store cannot be received. It is.
[0017]
The member store master 24 registers various information related to the member stores, and has the same contents as the member store master 32 of the headquarters or information for the member stores for which the order processing device 2 performs order processing.
[0018]
The order monitoring device 3 is a head office device (computer device) that monitors the order status of each member store that is ordered by the order processing device 2. Here, the order monitor device 31, member store master 32, And emergency proxy ordering instruction means 33 and the like.
[0019]
The order status monitoring means 31 is for monitoring the order status by the order processing device 2.
The member store master 32 registers various information of member stores, and has information as shown in FIG.
[0020]
The emergency agency ordering instruction means 33 refers to the affiliated store master 32 for the affiliated store that has not received the ordering data, and issues an emergency agency ordering instruction to the order processing device 2.
[0021]
Next, the operation of the configuration of FIG. 1 will be described in detail according to the order shown in the flowchart of FIG.
FIG. 2 shows a flowchart for explaining the operation of the present invention.
[0022]
In FIG. 2, S1 creates order result data. This creates (2) ordering result data based on (1) ordering data in FIG. 5 (described later) received by the ordering processing unit 2 in FIG. 1 from the ordering device 1 of each member store. At this time, order data of member stores that have not been received due to a line failure, etc., can be distinguished from the fact that the number of orders and the original selling price are set to 0 (2) by creating order result data. To do. These created {circle around (2)} order result data are transmitted to the order monitoring apparatus (headquarters) 3.
[0023]
In S2, order result data is displayed. This is because the order monitoring apparatus (headquarters) 3 that has received (2) order result data created and transmitted in S1 displays (2) order result data on the monitoring screen. At this time, the order result data with 0 of the order quantity and the original selling price is highlighted, and the fact that the order data has not been received from the member store is displayed in an easy-to-understand manner due to a line failure or the like.
[0024]
In S3, it is determined whether automatic ordering is specified. This is because (2) if the order result data quantity displayed on the screen or the original selling price is 0 (zero), the member store master 32 is referred to and the automatic agent order classification of the member store is present. Is set, and it is determined whether the date set in the closing information does not match the order date. In the case of YES, since it has been found in S3 that it is in the automatic proxy ordering category and does not match the store closing information, the process proceeds to S6 and an emergency proxy described later is instructed. On the other hand, in the case of NO in S3, it is determined that there is no automatic order designation, so the process proceeds to S4.
[0025]
In S4, the manager of the headquarters confirms the order status for each member store displayed on the screen.
In S5, it is determined whether there is a member store for which ordering data has not been transmitted. This is because (2) ordering result data for the number of orders and the original selling price of 0 (indicating that the ordering data has not been sent) is highlighted on the screen. Is determined to be transmitted. In the case of YES, it is determined that the order data has not been transmitted from the ordering device 1 of the member store to the ordering processing device 2 due to a line failure or the like, and the process proceeds to S6. On the other hand, if NO, the process proceeds to S7.
[0026]
S6 instructs an emergency substitution. In the case of S3 YES (in the case where it is an unsubmitted member store that is in the automatic agent ordering category of the member store master 32 and it is determined that the order date does not correspond to the closing information), the emergency agent is instructed. Or, in the case of YES of S4 and S5 (in the case of an untransmitted member store and the automatic store ordering category of the member store master 32 is set to “no”, but the administrator determines automatic transfer) Instruct the agent.
[0027]
In S7, the order processing apparatus 2 that has received the emergency proxy instruction in S6 determines whether or not there is past ordering data of the member store in the order backup 22. In the case of YES, emergency proxy ordering data is created in S8. If NO, the process ends.
[0028]
As described above, even when the ordering device 1 of the member store transmits (1) ordering data to the ordering processing device 2 via the line, when the ordering processing device 2 cannot receive it due to a line failure, the member store automatically. Refer to the master 32 (or the member store master 24), and when the automatic agency order classification is present and does not correspond to the store closing information, or the corresponding past in the order backup 22 in response to the automatic agency instruction of the manager of the headquarters It is possible to place an automatic proxy order based on the order data.
[0029]
FIG. 3 is an explanatory diagram of the member store master of the present invention.
FIG. 3A shows an example of a member store master (order processing apparatus). Here, (1) ordering data (not shown) received from the merchant ordering device 1 is sorted by the district headquarters / member store code / delivery date / classification code, etc., and then the district headquarters + member store code. (2) When it is found by collating with the member store master 24 using the key, it is set as order result data. On the other hand, there is a key in the member store master 24. The order number is determined as unreceived order data, and the order number and the original selling price of (2) order result data are set to 0 (zero) so that it can be identified that the order has not been received. Then, (2) order result data of all the member stores thus created is transmitted to the order monitoring apparatus 3 at the head office.
[0030]
FIG. 3B shows an example of a member store master (order monitoring apparatus). Here, (3) order result data is received from the order processing device 2, the member store master 32 is referred, the automatic agent order classification is present (for example, “5”), and the store information (closed day for each member store). If the order date does not correspond to (3), (3) emergency proxy instruction data is created and transmitted to the order processing device 2 for automatic proxy ordering. On the other hand, if there is no automatic agency order classification, or if the order date corresponds to the closing information (business holiday for each member store), it is determined that (3) emergency agency instruction data is not created.
[0031]
As described above, when the order data cannot be received due to a line failure between the ordering device 1 and the order processing device 2 of the member store, the ordering result of the member store that has not been received by referring to the member store master 24. The number of data orders and the original selling price are set to 0 (zero) to indicate that the data has not been received and sent to the headquarters. (3) Create emergency agency instruction data and notify the order processor 2 when there is an automatic agency order category with reference to the information and it does not correspond to the closing information, and the past order data in the order backup 22 It is possible to place an order by creating ordering data on behalf of the original.
[0032]
FIG. 4 is an explanatory diagram of the present invention.
FIG. 4A shows an example of (3) emergency proxy instruction data. This is because the order monitoring apparatus 3 refers to the member store master 32 and has an automatic proxy order classification (for example, “5”) and the order information does not correspond to the store closing information (business holiday for each member store). An example of (3) emergency proxy instruction data to be created is shown. Here, an example of (3) emergency proxy instruction data in which the creation week, the district headquarters, and the member store code are used as keys and the classification designation pattern, classification code, supplier code, etc. are set as shown in the figure is shown. The order monitoring device 3 transmits the emergency proxy instruction data (3) to the order processing device 2.
[0033]
FIG. 4B shows an example of the order backup 22. This is an accumulation of past ordering data, which is extracted based on (3) emergency agency instruction data key (creation week + district headquarters + member store code) in FIG. Order data (extracting the order data corresponding to the “creation week” that is part of the key, and changing the “creation week” that is part of the key to other information to match the information in the past. To retrieve the order data for). Here, for the week in which the key is created, the matching order data converted to the order date by calendar date conversion is extracted.
[0034]
FIG. 4C shows an example of a product master. This product master is a product registered. Here, as shown by the arrow in the figure, based on the district headquarter code and product code of the order backup 22 in FIG. Used to add When extracting by classification code, the classification key setting determines the key length to be compared based on the setting of the classification designation pattern. At this time, the classification key setting process takes out the record of the matching classification code converted into the corresponding classification code based on the classification designation pattern and classification code in (3) emergency substitution instruction data of FIG. I have to.
[0035]
FIG. 4D shows an example of emergency proxy ordering data. As indicated by the arrows in the figure, the information of (a), (b), and (c) in FIG. The order data of member stores is generated, and the following items shown in the figure are set.
[0036]
・ District headquarters: Set up the district headquarters for order backup in Fig. 4 (b) · Member stores: Set up the member store code for order backup in Fig. 4 (b) · Order date: Order backup in Fig. 4 (b) Set the order date of the item ・ Delivery date: Set the date of delivery from the unillustrated supplier master. ・ Set the supplier: Set the supplier code of the product master of FIG. 4C. ・ Classification code: (c of FIG. ) Set product master classification code ・ Product code: Set order backup product code in FIG. 4B ・ Quantity: Set order backup quantity in FIG. 4B ・ Others:
The calendar date conversion process described above designates (3) how many weeks ago the order backup 22 is to be used in the creation week of the emergency substitution instruction data. At the time of retrieval, the created week is converted to a calendar date, and compared with the order date of the order backup 22, the past order data that matches is extracted.
[0037]
In the classification key setting process, the relationship between the classification designation pattern and the classification code is as follows.

As described above, (3) emergency proxy ordering data can be automatically created with reference to the order backup 22 and the product master based on the emergency proxy instruction data.
[0038]
FIG. 5 shows an example of ordering data according to the present invention. This ordering data is an example of ordering data that is created by the ordering device 1 of the member store described above and transmitted to the ordering processing device 2, and the following items shown in the figure are set.
[0039]
・ District headquarters code: Set the district headquarters for order backup in Fig. 4 (b) ・ Member store code: Set the member store code for order backup in Fig. 4 (b) · Delivery date: From supplier master not shown Set for obtaining delivery date / Product code: Set product code for order backup in (b) of FIG. 4 -Order quantity: Set quantity of order backup in (b) of FIG. 4 / Other:
FIG. 6 is an explanatory diagram (emergency proxy ordering) of the present invention.
[0040]
(A) of FIG. 6 shows (3) emergency proxy instruction data. Since this is the same as (3) emergency proxy instruction data in FIG. 4A described above, description thereof will be omitted.
FIG. 6B shows order backup. Since this is the same as the order backup 22 shown in FIG.
[0041]
FIG. 6C shows an example of data extracted by the district headquarters / member store code from FIG. 6B.
FIG. 6D shows an example of the entire data of the member store-classification. This is data extracted from the district headquarters, the member stores, and the classification codes in FIG. 6C to FIG. 6A.
[0042]
FIG. 6E shows an example of the entire data of the member store and the business partner. This is data obtained by extracting data corresponding to the district headquarters, the member store, and the supplier code shown in FIG. 6C to FIG. 6A.
[0043]
(F) of FIG. 6 shows an example of the whole data of the member store-classification-business partner. This is a result of merging (d) and (e) of FIG. 6, and there are cases where duplicate records are extracted as shown by the hatched portion, and therefore the duplicate hatched records are deleted.
[0044]
As described above, (3) those corresponding to the classification code and the customer code from the order backup 22 using the creation week, the district headquarters code, and the member store code in the emergency agency instruction data as a key in FIG. ) And (e), and when these two are merged, if there is a duplicate record, one is deleted to avoid duplication, and the order data of the merchant that has not received the order data is automatically I am going to place an order with you.
[0045]
【The invention's effect】
As described above, according to the present invention, the ordering result data is generated based on the ordering data from the member store, and the number of the ordering member stores the ordering number, and the ordering number of the unordered member stores is zero. Since it has adopted a configuration in which substitute ordering instructions are given by referring to the store master and substitute ordering is performed based on past ordering data, the conventional manual work is reduced and input mistakes are made quicker. It is possible to implement an agency order for an unordered member store.
[Brief description of the drawings]
FIG. 1 is a system configuration diagram of the present invention.
FIG. 2 is a flowchart explaining the operation of the present invention.
FIG. 3 is an explanatory diagram of a member store master of the present invention.
FIG. 4 is an explanatory diagram of the present invention.
FIG. 5 is an example of ordering data according to the present invention.
FIG. 6 is an explanatory diagram (emergency proxy ordering) of the present invention.
[Explanation of symbols]
1: Ordering equipment (Members, POS)
2: Order processing device 21: Order processing means 22: Order backup 23: Emergency agency order processing means 24, 32: Member store master 3: Order monitoring device (headquarters)
31: Order status monitoring means 33: Emergency proxy order instruction means

Claims (5)

In an order processing device that creates order data for products from multiple member stores and places an order,
Receiving means for receiving the ordering data of the product transmitted from each member store;
At least merchant code from the order data of the merchant, order date, and ordering backup DB for storing information including commodity code, quantity,
A means for determining to place an order on behalf of a member store that does not have a member store code by collating with a member store master that has previously registered a member store code of the member store with at least the member store code as a key for the ordering data;
Ordering means for creating substitute ordering data for the member store from the ordering data of the merchant store's products stored in the order backup DB for the member store determined to be placed on behalf by the determination means An agency order processing device. In an order processing device that creates order data for products from multiple member stores and places an order,
Receiving means for receiving the ordering data of the product transmitted from each member store;
At least merchant code from the order data of the merchant, order date, and ordering backup DB for storing information including commodity code, quantity,
A data format that can be used to identify that a merchant with no merchant code has not been received by collating with the merchant master that has previously registered the merchant code of the merchant, using at least the merchant code as a key for the order data Transmitting means for transmitting to the order monitoring device;
An ordering means for generating proxy order data for the member store from the order data of the merchandise of the member store stored in the order backup DB when proxy order instruction data is received from the order monitoring device ; A featured agency order processing device. A member store in which the member store code of the member store is registered in advance by the ordering means based on the automatic agency classification and the suspension information set for each member store in the member store master, using the member store code as a key for the order data. When there is an automatic agency order classification for a member store that does not have a member store code after collation with the master , and the closed information is not closed, the relevant order from the product order data of the member store stored in the order backup DB 2. The agency order processing apparatus according to claim 1 , wherein agency order data of member stores is created. The ordering means extracts from the ordering data of the merchant's merchandise stored in the ordering backup DB using the designated week, district headquarters, merchant code, classification code, and supplier code as a key. proxy order processing device according to to claim 1, characterized in that a proxy order data of the merchant to claim 3. 5. The proxy order processing apparatus according to claim 4 , wherein the ordering unit performs a duplication check on the created ordering data and deletes the duplicated ordering data.

Images