JP2015197699A - Affiliated store provision data output system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To output affiliated store provision data by a predetermined unit desired by an affiliated store.SOLUTION: A method includes: a step of, from a client computer, receiving the output condition of affiliated store provision data including a second affiliated store identification number and a first and/or second condition for tabulating settlement detail data for every first and/or second hierarchy of an affiliated store; a step of acquiring the first affiliated store identification number from an affiliated store data storage part on the basis of the second affiliated store identification number included in the output condition; a step of acquiring settlement detail data records from a settlement detail data storage part on the basis of a first affiliated store identification number; and a step of generating affiliated store provision data by tabulating the settlement detail data records on the basis of the first and/or second condition.

Description

  The present invention relates to a member store provided data output system and a member store provided data output method.

  It has been a long time since the spread of credit cards, and in recent years, the use of credit cards for small payments is increasing. Credit card payment is performed at a retail store (hereinafter “member store”) where a credit card user (hereinafter “member”) has shopped. Each member store can handle a member's credit card by signing a member store contract with the credit card company. The credit card payment system is as follows. 1) The credit card company pays the purchase price on behalf of the member to the member store where the member did the shopping. 2) The credit card company will withdraw money from the member's bank account. 3) The credit card company pays the purchase price to each member store at a predetermined timing (for example, once a month) in a lump. 4) Each member store pays a credit card company with a commission corresponding to the sales.

  Each member store registers the member store number with the credit card company. The hierarchy of member store organizations for registering member store numbers varies depending on the member store. In particular, member stores having large member store organizations (for example, member stores having franchise stores nationwide) are classified by franchise stores under their control. It is often registered or registered by individual store such as “Shinjuku store”.

  By the way, when a credit card payment is made, the POS (point of sale) system installed in the member store stores the card payment details data from each member store into a credit card company system (hereinafter referred to as “credit card company system”). ). By this mechanism, the credit card company system can have card payment details data for all credit card payments made by the members. This card settlement detail data is created for each member store number registered with the credit card company.

  As described above, each credit card company pays the purchase price (hereinafter “billing amount”) to each merchant, and each merchant pays a fee. It is necessary to grasp the fee.

Sumitomo Mitsui Card Co., Ltd., “Member Sales Web Statement Service”, [online], Mitsui Sumitomo Card Co., Ltd. website, [Searched on December 24, 2013], Internet (URL: https: //www.smbc- card.com/kamei/netservice/meisai.jsp) JCB Co., Ltd., “Transfer information WEB inquiry service 2 Download sales details (CSV file)”, [online] JCB Co., Ltd., [December 24, 2013 search], Internet (URL: http) : //www.jcb.co.jp/merchant/kamei/pop/csv.html)

  In consideration of the above requirements, the credit card company will charge each member store at the specified timing for all card payment details up to the time of payment, and the total amount charged (hereinafter referred to as “total charges”). Amount ") and data including fees calculated according to the total billed amount (hereinafter referred to as" Member Store Provided Data ") are provided on paper or electronic media (hereinafter referred to as" Member Store Offer ") Data output service ") (see Non-Patent Document 1 and Non-Patent Document 2). For example, as shown in FIG. 3, member store-provided data including all card settlement details, total billing amount, fee, etc. is provided once a month for each registered member store number. FIGS. 3 (a) and 3 (b) show the details of the card payments for one month for “XXya Shinjuku” and “XXya Akasaka”, which are pub franchise stores, respectively. FIG. 3C shows the card payment details for one month of “XX Camera Hachioji Store” that conducts home appliance sales business.

  FIG. 4 shows an example of the configuration of a member store organization to which member store provision data is provided. As shown in Fig. 4 (a), "XX Holdings Co., Ltd." operates a restaurant service business that has franchise stores throughout the country. The store “XX Food” and the Italian food chain store “XX Pasta”, each of “XX Restaurant”, “XX Food”, and “XX Pasta” It has multiple stores such as “Store”. FIG. 4B shows a member store organization of “XX Camera” that conducts home appliance sales business, and has a plurality of stores such as “Hachioji store”.

  Returning to FIG. 3, as shown in FIGS. 3 (a) and 3 (b), “OO shop” registers the member store number for each store such as “Shinjuku store” and “Akasaka store” The merchant-provided data is provided for each merchant number. As shown in FIG. 3C, “XX Camera” registers member store numbers for each store such as “Hachioji Store”, and member store providing data is provided for each member store number.

  When outputting merchant-provided data to an electronic medium, the person in charge of each merchant logs in to the input / output interface provided by the credit card company system and inputs information such as the month to be output. Monthly merchant-provided data can be output in CSV format. When logging in, it is necessary to use a login ID defined for each member store number.

  In such a situation, for example, a person in charge of “XX Holdings Co., Ltd.” has a desire to refer to the card settlement details and the total billed amount of all franchise stores under the umbrella. In the current merchant-provided data output service, the card settlement details data is created for each registered merchant number, so the billing amount is also totaled for each merchant number. Since the login ID is also defined for each member store number, the person in charge of “XX Holdings Co., Ltd.” logs in for each store using the login ID defined for each store in the franchise stores that belong to the store. It is necessary to output merchant-provided data. That is, it is necessary to repeat the number of times of the franchise stores under the umbrella, login and data output, and the burden on the person in charge becomes enormous.

  The present invention has been made in view of such a problem. Even when the card settlement details data is created for each registered member store number, the member store provided data is stored in a predetermined unit desired by the member store. An object is to provide a member store provided data output system and a member store provided data output method capable of outputting.

  In order to solve the above problems, a member store provided data output method according to the present invention is a method for generating member store provided data including a total bill amount to be paid to a member store of a credit card company. A method performed by a computing device connected to a client computer, the computing device comprising: a first merchant identification number for a first tier of the merchant; and a second of the merchant A merchant data storage unit that stores merchant data associated with a second merchant identification number for the hierarchy, and a payment statement for credit card settlement by a credit card member created for each first merchant identification number A payment statement data storage unit storing data, and the method receives the addition from the client computer. Receiving the output condition of the store-provided data, wherein the output condition is a first for summing up the settlement details data according to the second member store identification number and the first hierarchy of the member store; And / or a second condition for aggregating the settlement statement data by the second hierarchy of the member store, and the second member store identification included in the received output condition Acquiring the first member store identification number from the member store data storage unit based on the number, and the payment details data from the payment detail data storage unit based on the acquired first member store identification number Obtaining the record, and summing up the acquired settlement detail data records based on the first condition and / or the second condition included in the received output condition, Characterized by comprising the steps of: generating a serial merchant providing data.

  According to the member store providing data output system and the member store providing data output method according to the present invention, each member store can output member store providing data in a unit desired to be referred to. A person in charge of a company having a franchise chain store can efficiently refer to the card payment details of all stores.

It is a figure which shows the example of the network structure of the member store provision data output system which concerns on one Embodiment of this invention. It is a block diagram which shows the example of a detailed structure of the member store provision data output system which concerns on one Embodiment of this invention. It is a figure which shows the example of the member store provision data which exist conventionally. It is a figure which shows the member store organization of each member store hierarchically. It is a flowchart which shows a series of processes which the member store provision data output system which concerns on one Embodiment of this invention performs. It is a figure which shows the example of the member store data storage part 600 which concerns on one Embodiment of this invention. It is a figure which shows the example of the input-output interface 700 which concerns on one Embodiment of this invention. It is a figure showing an example of member store offer data concerning one embodiment of the present invention. It is a figure which shows the example of the management data storage part 900 which concerns on one Embodiment of this invention.

  Hereinafter, a member store provided data output system according to an embodiment of the present invention will be described in detail with reference to the accompanying drawings.

  FIG. 1 is a diagram showing an example of a network configuration of a member store-provided data output system according to an embodiment of the present invention.

  The member store-provided data output server 101 is a computing device that outputs member store-provided data, and includes a main function of the member store-provided data output system according to the present invention. The member store-provided data output server 101 is configured to communicate with 103a, 103b,..., 103n (hereinafter “client computer 103”) via a network 102 such as the Internet. The member store-provided data output server 101 may be implemented alone or in a credit card company system that has existed conventionally.

  The client computer 103 is a terminal used by a person in charge at each member store (hereinafter referred to as “user”), and inputs predetermined conditions from the input / output interface displayed on the client computer 103, and according to the conditions. The merchant-provided data is displayed on the input / output interface.

  The member store-provided data output server 101 described above may be configured by one or a plurality of computing devices. The client computer 103 described above may be an information terminal device such as a personal computer, a workstation, or a PDA having a communication function. A computing device and an information terminal device are computing devices including a central processing unit (CPU), a memory, a storage device, and the like, and are centralized by a CPU processing a computer program stored in the memory or the storage device. It is controlled, and the processing according to the present invention can be executed and its function can be realized. Note that the above-described system configuration is for illustration, and does not limit the system configuration capable of executing the present invention.

  Next, the configuration of the member store-provided data output system described above will be described in detail with reference to the block diagram of FIG. The member store-provided data output server 101 includes a control unit 201, a main storage unit 203, an auxiliary storage unit 204, an input unit 205, an output unit 206, a network I / F 207, and a database 208. Connected through.

  The control unit 201 is also called a central processing unit (CPU), performs control of each of the above-described constituent elements and data calculation, and reads various programs stored in the auxiliary storage unit 204 to the main storage unit 203 and executes them. To do.

  The main storage unit 203 is also referred to as a main memory, and stores input data received by the member store-provided data output server 101, computer-executable instructions, data after arithmetic processing by the instructions, and the like.

  The auxiliary storage unit 204 is a storage device represented by a hard disk (HDD) or the like, and is used when storing data and programs for a long period of time. Since the main storage unit 203 has a relatively smaller storage capacity than the auxiliary storage unit 204, it is used for temporary data storage, arithmetic processing, and the like, whereas the auxiliary storage unit 204 is used for long-term storage of necessary data. Used for general memory and preservation. That is, when the control unit 201 executes a program to perform data calculation, the necessary data or program is read from the auxiliary storage unit 204 to the main storage unit 203, and the calculation result data is stored and stored for a long time. In this case, the control unit 201 writes the calculation result data in the auxiliary storage unit 204.

  The input unit 205 receives input of predetermined conditions from the client computer 103 via the network I / F 207.

  The output unit 206 receives input of predetermined conditions from the client computer 103 and executes processing such as summation of card payment details, and then outputs member store provided data to the auxiliary storage unit 204. The member store-provided data is transmitted to the client computer 103 via the network I / F in response to a download request from the client computer 103.

  The database 208 includes data tables such as a card payment statement data storage unit and a member store data storage unit 600 described later.

  Next, a series of processing executed by the member store-provided data output system according to the embodiment of the present invention will be described using the flowchart of FIG.

  The user belongs to the affiliated store organization “XX Holdings Inc.” shown in FIG. 4 and the deadlines for all of the affiliated store organizations “XX store”, “XX food” and “XX pasta” The card payment details up to and including the total invoiced amount for each store (for example, “Xoya Shinjuku”) is output for each store that is a member store organization under its umbrella. Is required.

  First, the user logs in to the input / output interface displayed on the client computer 103 (S501). The login is performed by inputting a member store number (or a user number assigned to each member store) assigned to the member store organization “XX Holdings Co., Ltd.”. The entered member store number is transmitted to the member store providing data output server 101.

  The input unit 205 of the member store providing data output server 101 receives the transmitted member store number via the network I / F 207 (S502). Then, the control unit 201 of the member store-provided data output server 101 acquires all member store data records in which the member store number and the parent member store number match from the member store data storage unit 600 using the member store number as a key. (S503).

  As shown in FIG. 6, the member store data storage unit 600 is a database table that stores member store information, and includes a “member store number”, a “member store name”, and an upper member store organization for identifying each member store. The “parent member store number” and “parent member store name” are provided. This data storage unit realizes the hierarchical structure of the member store organization shown in FIG. 4 by associating the member store number and the parent member store number. For example, the member store organizations “XX store”, “XX food” and “XX pasta” are each affiliated with the member store organization “XX Holdings Co., Ltd.”. The value of the member store number indicating the member store organization “XX Holdings Co., Ltd.” is set. In S503, the member store number “10000000” serving as a key matches the member store number or the parent member store number. 1, 2, 6 and 10 records are acquired.

  Next, the control unit 201 of the member store provided data output server 101 transmits member store data including the acquired member store data record to the client computer 103 via the network I / F 207 (S504).

  The client computer 103 receives the transmitted member store data and displays the member store data on the input / output interface 700 (S505). The input / output interface 700 is an interface for the user to specify the predetermined condition and output the member store provided data, and will be described with reference to FIG.

  The deadline date selection menu 701 is a selection menu for designating a deadline date on which the card payment details are to be output. Sort criteria designation check boxes 702 to 705 are check boxes for classifying card settlement details and selecting a category for summing up billing amounts. For example, when each brand is selected in the sort criteria designation check box 702 and each store is selected in the sort criteria designation check box 703, the member store provided data is output by brand and by store. In other words, in the present embodiment, the data provided by the franchise stores is classified by franchise stores (by brand) such as the franchise organizations “XX shop”, “XX food”, and “XX pasta”, and for each of those stores. Is output. The arrangement order designation selection menu 706 is a selection menu for designating the display order of the card payment details included in the member store-provided data output by specifying the conditions. The affiliated store display 707 displays the member store data received in S505. In other words, in the affiliated store display 707, all member store data having the same parent member store number is displayed in S503, and in this embodiment, the member store numbers “10000010”, “10000020”, and “10000030” are displayed. Is done. The member store all designation check box 708 is a check box for designating to output member store provision data to all member store organizations under the member store displayed in the affiliated store display 707. The member store individual designation check box 709 is used to output member store provided data to a member store organization that is individually selected from among the member store organizations displayed in the member store display 707 under the affiliated store. In this case, individual member store organizations can be selected in the member store selection menu 710. Note that the above-described check boxes are merely exemplary, and may include check boxes for selecting other condition designations.

  The user designates an output condition as shown in FIG. 7 in each check box and selection menu of the input / output interface 700 described above, and presses an execution button 711. In response to pressing of the execution button 711, the client computer 103 indicates each of the above-described output conditions (for example, an indication indicating the category selected by the sort criterion specification check boxes 702 to 705) data (output condition specification data) Is transmitted to the member store-provided data output server 101 (S506).

  The input unit 205 of the member store provided data output server 101 receives the output condition designation data transmitted in S506 via the network I / F 207 (S507). Then, the control unit 201 of the member store provided data output server 101 adds the member from the member store data storage unit 600 based on the classification selected in the sort criterion specification check boxes 702 to 705 included in the received output condition specification data. All member store data records having the same store number and parent member store number are acquired (S508). In this embodiment, since the classification for each brand and each store is designated, and the all member store designation check box 708 is checked, the member store organization “under XX Holdings Co., Ltd.” “ A member store data record is acquired for each store under the member stores of XX Store, XX Food, and XX Pasta. That is, the member store number and the parent member store number match using the member store numbers “10000000”, “10000010”, “10000020”, and “10000030” included in the member store data acquired in S503 as the keys. . 1 to No. Get 13 records.

  Next, based on the member store number included in the member store data record acquired in S508, the control unit 201 uses the card payment details data storage unit (the card payment details data storage unit is not shown, but the card payment details shown in FIG. 3). Based on the output condition designation data, the target card settlement detail data record is acquired from the output condition designation data, and the charge amount included in each record is totaled (S509). In the present embodiment, as shown in FIG. 3, the card payment details data stored in the card payment details data storage unit is created for each store such as “XX ya Shinjuku store”. Get the data. When the card payment details data for one store and the sum of the billing amount are completed, the same processing is performed for the next store having the same parent member store number, and the processing for all stores is completed. The process of S509 is repeated until After obtaining the card settlement details data record for the last store and summing up the billing amount, the same processing is performed at the next member store (XX Food) having the same parent member store number. The processing of S509 is repeated until the processing for the member store having the member store number is completed. Here, in this step, records are acquired in the order specified in the arrangement order specification selection menu 706 in S506. That is, in the present embodiment, card settlement detail data records are acquired in order of brand, order of store, order of use date, and order of payment category.

  In S509, when the acquisition of all the card settlement details data and the summation of the billed amount are completed, the member store-provided data output server including the card settlement detail data record for each brand and the store and the summed billed amount is provided. 101, the client computer 103 can download the data provided by the member store. An example of member store provision data created in this embodiment is shown in FIG.

  As shown in FIG. 8, for the users of the member store organization “XX Holdings, Inc.”, “XX shop”, “XX food”, and “XX pasta” which are the affiliated store organizations below it are displayed. For each of these, the total bill amount for each store, which is a member store organization further below, is output.

  In such a state, the control unit 201 of the member store-provided data output server 101 inserts a record into the management data storage unit 900. The management data storage unit 900 will be described with reference to FIG.

  The management data storage unit 900 is a database table that stores information for managing whether or not the created member store provision data has been downloaded, and provides a “data identification number” that identifies the created member store provision data. “Member store number” of the target member store organization, “Notification date” that is the date and time when the email or indication described later is transmitted, “Notification availability” indicating whether the transmission was successful, and the date and time when the data was downloaded It has a certain “download date and time”.

  Next, the control unit 201 transmits an e-mail indicating that the above-described member store-provided data can be downloaded to the client computer 103 (S511). In many cases, all card payment details of member stores are enormous, and it takes a lot of time to collect the billed amount. In consideration of such circumstances, as described above, at the timing when the creation of member store-provided data is completed, it is possible to notify the client computer 103 that the data has been completed by sending an email to the client computer 103. it can. Instead of sending the above-mentioned e-mail, an indication that the member store-provided data can be downloaded is sent to the client computer 103, and the indication is displayed on the input / output interface 700. Also good.

  When the client computer 103 receives the e-mail or indication (hereinafter referred to as “e-mail”) transmitted in S510 (S512), the control unit 201 of the member store-provided data output server 101 sets items in the management data storage unit 900. “Notification date / time” is updated to the date / time when the e-mail or the like is transmitted, and the item “notification availability” is updated to “1: success”. On the other hand, if an error notification is returned as a result of the transmission of the e-mail or the like, the item “notification availability” is updated to “2: failure” (S513). In this way, by managing the transmission date and time of e-mail etc., for example, if e-mail etc. could not be sent, it is possible to grasp such fact and send e-mail etc. again Become. It should be noted that the above-described determination as to whether or not the transmission of e-mail or the like has succeeded is made by returning an acknowledgment (ACK) message to the member store-provided data output server 101 in response to the client computer 103 receiving the e-mail or the like. May be performed.

  When the user receives the e-mail or the like, the created member store-provided data can be downloaded via the input / output interface 700. When the user downloads data (S514), the control unit 201 of the member store-provided data output server 101 sets the item “download date / time” in the management data storage unit 900 to the date and time of download (the member store-provided data output server 101 joins). The date and time when the store-provided data is transmitted is updated (S515). In the transmission of e-mail and the like described above, there may be a case where e-mail or the like is not normally transmitted to the client computer 103 even if an error notification is not returned. Even in such a case, by managing the download date and time, it is possible to grasp whether or not the member store-provided data has been normally downloaded to each member store. In addition, by updating the download date and time, it becomes possible to identify member store provided data that has passed a certain period from the download date and time, for example, by having a function of automatically deleting member store provided data that has passed a certain period of time, The storage capacity of the auxiliary storage unit 204 of the member store provided data output server 101 can be managed.

  As for the process for creating the member store provided data described above, the member store provided data output request from the client computer 103 is added to the queue, and the request is extracted and executed based on a predetermined rule (or the predetermined rule). The member store-provided data output request is added to the queue based on the above), and the so-called delayed processing may be performed. For example, when the affiliated store provided data output system according to the present invention is implemented in a conventional credit card company system, online processing other than the affiliated store provided data output request also occurs simultaneously. Processing may be performed with priorities according to the response requirements of the other processing included.

  In addition, it is possible to specify various tabulation patterns in the sort criteria specification check boxes 702 to 705, and the billing amount may be totaled under the conditions specified in the check boxes, and further included in the card settlement details data. It is also possible to output only necessary items from the stored data (for example, output only the total billed amount). An example of merchant-provided data output by changing the condition designation is shown below.

  Table 1 below shows that “by brand” is checked in the sorting criteria designation check box 702 of the input / output interface 700, “by store” is checked in the sorting criteria designation check box 703, and in the sorting criteria designation check box 704. In the example of the merchant-provided data that is output by checking the “by payment category” and checking the “by use date” in the sort criteria specification check box 705 and specifying the condition to output only the total billed amount. is there.

  In Table 2 below, “By Brand” is checked in the sorting criteria designation check box 702 of the input / output interface 700, and “By Payment Category” is checked in the sorting criteria designation check box 703, and the total invoiced amount and total It is an example of member store offer data outputted by specifying a condition to output only a fee.

  As described above, the description of the member store-provided data output system according to the present invention has been described in detail, but specific data structures such as the member store data storage unit 600 and the management data storage unit 900 described in the embodiment are illustrated. However, the present invention may be modified without departing from the scope of claims.

102 Network 202 System bus 701 Deadline selection menu 701
702 Sort criteria designation check box 703 Sort criteria designation check box 704 Sort criteria designation check box 705 Sort criteria designation check box 706 Sort order designation selection menu 707 Affiliated member store display 708 Member store all designation check box 709 Member store individual designation check box 710 Member store selection menu 711 execute button

Claims (8)

A method performed by a computing device connected to a client computer for generating merchant-provided data including a total bill amount to be paid to a merchant of a credit card company, comprising:
The computing device is
A member store data storage unit that stores member store data in which a first member store identification number for the first layer of the member store and a second member store identification number for the second layer of the member store are associated; ,
A payment details data storage unit that stores payment details data for credit card payments by credit card members created for each first member store identification number;
The method
Receiving an output condition of the member store-provided data from the client computer, wherein the output condition includes the second member store identification number and the settlement detail data according to the first hierarchy of the member store; A first condition for aggregating and / or a second condition for aggregating the settlement statement data by a second tier of the member store;
Obtaining the first member store identification number from the member store data storage unit based on the second member store identification number included in the received output condition;
Acquiring a payment statement data record from the payment statement data storage unit based on the acquired first member store identification number;
And a step of generating the member store-provided data by aggregating the acquired settlement detail data records based on the first condition and / or the second condition included in the received output condition. A method characterized by that.   The method according to claim 1, further comprising the step of notifying the client computer that the member store providing data has been generated in response to the member store providing data being generated. The computing device further includes a management data storage unit for managing the member store provided data,
The method
Updating the notification date and time stored in the management data storage unit to the date and time when it is notified that the member store provision data has been generated;
Transmitting the generated member store-provided data to the client computer;
The method according to claim 2, further comprising: updating a download date and time stored in the management data storage unit to a date and time when the member store provided data is transmitted.   Adding the received output condition to a queue based on a predetermined rule, or retrieving the stored output condition based on a predetermined rule from a queue storing the received output condition; The method according to claim 1, further comprising a method. A computer system connected to a client computer for generating merchant-provided data including a total bill amount to be paid to a merchant of a credit card company,
A member store data storage unit that stores member store data in which a first member store identification number for the first layer of the member store and a second member store identification number for the second layer of the member store are associated; ,
A payment details data storage unit that stores payment details data for credit card payments by credit card members, created for each first member store identification number;
A receiving unit for receiving an output condition of the member store-provided data from the client computer, wherein the output condition includes the second member store identification number and the settlement details according to the first hierarchy of the member store; A receiving unit comprising: a first condition for aggregating data; and / or a second condition for aggregating the settlement statement data by the second tier of the member store;
Based on the second member store identification number included in the received output condition, a member store data acquisition unit that acquires the first member store identification number from the member store data storage unit;
A payment statement data acquisition unit for acquiring a payment statement data record from the payment statement data storage unit based on the acquired first member store identification number;
Member store-provided data generation for generating the member store-provided data by aggregating the acquired settlement detail data records based on the first condition and / or the second condition included in the received output condition And
A data generation notifying unit for notifying that the member store providing data is generated to the client computer in response to the member store providing data generating unit generating the member store providing data. Computer system.   The program for making a computer perform the method as described in any one of Claims 1 thru | or 4.   A computer-readable storage medium storing the program according to claim 6.   A computing device comprising a processor and a memory, wherein the memory stores a program for causing the processor to execute the method according to any one of claims 1 to 4.

Images