JP5416730B2 - Member billing management system, member billing management method, and member billing management program - Google Patents

Description

  The present invention relates to a membership billing management system, a membership billing management method, and a membership billing management program. Specifically, in consideration of the scale of a user company, an appropriate service according to the service actually used and its contents The present invention relates to a technology that enables billing management.

  As a user billing mechanism for the public cloud, a fixed billing process is mainly employed according to the number of users in use. In addition, as a billing mechanism related to a telephone charge, a pay-as-you-go billing process in which billing is performed based on the amount of network traffic or call time is also common.

  Such billing management technology includes, for example, billing processing according to the product actually generated by the application program, instead of billing processing for the usage count and usage time of the application program or a specific function therein. When the result is obtained using the application program, the result is obtained by providing a billing result that can be satisfied by the user using the application program by performing a discount according to the date and time. An application / program billing system (see Patent Document 1) including a billing management server that calculates a billing amount according to an object and charges the billing amount at a discount rate according to the date and time when the deliverable is obtained is proposed Has been.

JP 2002-116835 A

  On the other hand, in the service form in which the warehouse management work is made into a cloud, there is a problem when performing conventional billing management. A user who uses the service tends to have a larger storage capacity and sales scale as the company has a larger equipment capacity (a warehouse volume (size)). Naturally, there is a big difference in payment capability between large companies with large equipment capacity and small and medium-sized enterprises. In addition, as a cloud service user for warehouse management work, a large company having a large facility capacity and a small micro-enterprise have different usage functions and the number of forms to be output.

  Under these circumstances, if the conventional billing management mechanism is also applied to large enterprises and small and medium enterprises, a billing result (fair billing) that can be satisfied by each user may not be obtained.

  Accordingly, an object of the present invention is to provide a technology that enables appropriate billing management according to the service actually used and its contents in consideration of the scale of a user company that performs warehouse management work.

The member billing management system of the present invention that solves the above problems is a computer system that performs billing management for users in a cloud service that allows a user terminal to use an application for warehouse management work, and a communication unit that communicates with an external device; , A member management table storing the facility capacity related to the warehouse of each user and the contract contents corresponding to the degree of use of the application, and the basic information storing basic fee information determined according to the combination of the facility capacity of the warehouse and the contract contents Stores a charge table and a pay-per-use table that stores information on the pay-as-you-go charges determined according to the number of items printed on the form output by the user and the upper and lower pay- per-use information determined according to the facility capacity of the warehouse a storage unit which, from the membership management table, the contract content and the equipment capacity of a given user Data is extracted, the basic charge of the user is specified in the basic charge table using the extracted user capacity and contract details as keys, and the value of the basic charge is associated with the user and stored in the storage unit And the number of details printed on the form output to a predetermined output device in response to an instruction from each user terminal, and the value of the number of form output records obtained by the count corresponds to the corresponding user in the storage unit a process of storing attach the arrival detection of a predetermined time by the clock function provided as a computer, to not in accordance with the instruction received from the input unit or a user terminal, base rate and form output a predetermined user stored in the storage unit a process of reading the value of the record count, if the read form output number of records is less than a predetermined prescribed lower limit value, the member management Te According to the information of the equipment capacity of the relevant user in Bull said corresponding lower rates values in commodity charge table determines a pay-as-you-go, when the read form output number of records is predetermined or greater than a predetermined upper limit value, the member When the upper limit charge value in the pay-as-you-go table according to the information on the equipment capacity of the corresponding user in the management table is determined as the pay-per-use charge, and the number of read form output records is between the predetermined lower limit value and the predetermined upper limit value , Adding the lower limit fee value to the product of the number of record output records and a predetermined coefficient to determine a metered fee, and adding the read basic fee and the determined metered fee for each user, And a calculation unit that executes a process for calculating the charge amount.

The member billing management method of the present invention relates to a communication unit that communicates with an external device and a warehouse for each user in order to perform billing management for a user in a cloud service in which a user terminal uses an application for warehouse management work. A member management table storing the facility capacity and contract contents according to the degree of use of the application; a basic charge table storing information on basic charges determined according to the combination of the facility capacity of the warehouse and the contract contents; and A storage unit for storing a pay-for-use fee determined according to the number of items printed on the output form and a pay-per-use table storing information on the upper limit charge and the lower limit charge of the pay-per-use charge determined according to the facility capacity of the warehouse, and calculation computer and a part is, the from the member management table, the contract content and the equipment capacity of a given user data The basic charge of the corresponding user is specified in the basic charge table using the extracted equipment capacity and contract contents as a key, and the value of the basic charge is associated with the corresponding user and stored in the storage unit. Counts the number of details printed on a form output to a predetermined output device in accordance with processing and instructions from each user terminal, and associates the value of the number of form output records obtained by the count with the corresponding user in the storage unit The basic charge and form output record of the predetermined user stored in the storage unit in response to the detection of the arrival of the predetermined time by the clock function provided as a computer and the instruction received from the input unit or the user terminal a process of reading the value of the count, if the read form output number of records is less than a predetermined prescribed lower limit value, the member management table According to the definitive relevant information of the user equipment capabilities, said corresponding lower rates values in commodity charge table determines a pay-as-you-go, when the read form output number of records is predetermined or greater than a predetermined upper limit value, the member management According to the information on the equipment capacity of the corresponding user in the table, the corresponding upper limit charge value in the pay-per- use charge table is determined as a pay-per-use charge, and when the number of read form output records is between a predetermined lower limit value and a predetermined upper limit value, By adding the lower limit charge value to the product of the number of corresponding form output records and a predetermined coefficient to determine the metered fee, and adding the read basic fee and the determined metered fee for each user, And processing for calculating a charge amount.

The member billing management program of the present invention relates to a communication unit that communicates with an external device and a warehouse for each user in order to perform billing management for a user in a cloud service that allows a user terminal to use an application for warehouse management work. A member management table storing the facility capacity and contract contents according to the degree of use of the application; a basic charge table storing information on basic charges determined according to the combination of the facility capacity of the warehouse and the contract contents; and A storage unit for storing a pay-for-use fee determined according to the number of items printed on the output form and a pay-per-use table storing information on the upper limit charge and the lower limit charge of the pay-per-use charge determined according to the facility capacity of the warehouse, and calculation a computer with a part, the contract content from the member management table, and the installed capacity of a given user Data is extracted, the basic charge of the user is specified in the basic charge table using the extracted user capacity and contract details as keys, and the value of the basic charge is associated with the user and stored in the storage unit And the number of details printed on the form output to a predetermined output device in response to an instruction from each user terminal, and the value of the number of form output records obtained by the count corresponds to the corresponding user in the storage unit a process of storing attach the arrival detection of a predetermined time by the clock function provided as a computer, to not in accordance with the instruction received from the input unit or a user terminal, base rate and form output a predetermined user stored in the storage unit a process of reading the value of the record count, if the read form output number of records is less than a predetermined prescribed lower limit value, the member management Te According to the information of the equipment capacity of the relevant user in Bull said corresponding lower rates values in commodity charge table determines a pay-as-you-go, when the read form output number of records is predetermined or greater than a predetermined upper limit value, the member When the upper limit charge value in the pay-as-you-go table according to the information on the equipment capacity of the corresponding user in the management table is determined as the pay-per-use charge, and the number of read form output records is between the predetermined lower limit value and the predetermined upper limit value , Adding the lower limit fee value to the product of the number of record output records and a predetermined coefficient to determine a metered fee, and adding the read basic fee and the determined metered fee for each user, And a process of calculating a billing amount for the above.

  According to the present invention, it is possible to perform appropriate billing management according to the service actually used and its contents in consideration of the scale of a user company that performs warehouse management work.

It is a figure which shows the example of a network structure containing the member charge management system of this embodiment. It is a figure which shows the hardware structural example of DB server. It is a figure which shows the hardware structural example of a WEB / AP server. It is a figure which shows the hardware structural example of a member charge management server. It is a figure which shows the example of a data structure of the member management master table of this embodiment. It is a figure which shows the example of a data structure of the equipment rank master table of this embodiment. It is a figure which shows the example of a data structure of the basic charge master table of this embodiment. It is a figure which shows the example of a data structure of the stamp data table of this embodiment. It is a figure which shows the example of a data structure of the output instruction | indication data table of this embodiment. It is a figure which shows the example of a data structure of the mail FAX transmission data table of this embodiment. It is a figure which shows the example of a data structure of the mail form count data table of this embodiment. It is a figure which shows the example of a data structure of the mail form count total data table of this embodiment. It is a figure which shows the example of a data structure of the usage-amount master table of this embodiment. It is a figure which shows the example of a data structure of the charge performance data table of this embodiment. It is a flowchart which shows the process procedure example 1 of the member charge management method of this embodiment. It is a flowchart which shows the process procedure example 2 of the member charge management method of this embodiment. It is a flowchart which shows process sequence example 3 of the member charge management method of this embodiment. It is a flowchart which shows process sequence example 4 of the member charge management method of this embodiment. It is a flowchart which shows process sequence example 5 of the member charge management method of this embodiment. It is a flowchart which shows process sequence example 6 of the member charge management method of this embodiment. It is a flowchart which shows the process example 7 of the member charge management method of this embodiment. It is a flowchart which shows process sequence example 8 of the member charge management method of this embodiment. It is a flowchart which shows process sequence example 9 of the member charge management method of this embodiment. It is a figure which shows the example of an output with the peripheral device (printer) in this embodiment. It is a figure which shows the example of an output screen in this embodiment.

--- System configuration ---
Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a network configuration diagram including a member billing management system 100 of the present embodiment. A member billing management system 100 (hereinafter, system 100) shown in FIG. 1 is a computer system that performs billing management for a user in a cloud service in which a user terminal 13 uses an application for warehouse management work. In consideration of the scale of the user company to be performed, this is a computer system that enables appropriate charge management according to the service actually used and its contents.

  The member billing management system 100 includes a DB server 10, a WEB / AP server 11, and a member billing management server 12. Of course, it may be composed of a single server device. Such servers are connected to a user terminal 13 and a peripheral device 14 such as a printer via a network 15 such as the Internet. The user terminal 13 is a computer terminal for a user to access a WEB / AP server 11 that provides a cloud service and use an application for warehouse management work. The peripheral device 14 is a device that executes printing of various output data such as bills generated by the member billing management server 12.

  As illustrated in FIG. 2, the DB server 10 constituting the system 100 has a member management master table 211 (member management table), an equipment rank master table 212, and a basic charge master table 213 in its storage unit 201. (Basic fee table), stamp data table 214, output instruction data table 215, mail FAX transmission data table 216, form count data table 217, form count tabulation data table 218, pay-amount master table 219 (pay-a-charge table), billing A record data table 220 is stored. Each of these tables will be described later.

  The DB server 10 outputs information, a control unit 200 configured with a CPU, a storage unit 201 configured with a non-volatile storage device such as a hard disk drive, an input unit 202 serving as an interface for receiving external input, and the like. A display unit 203 and a network interface unit 204 as a communication unit are provided. These units are connected to each other by a bus (BUS).

  FIG. 3 is a diagram illustrating a hardware configuration example of the WEB / AP server 11. As with the DB server 10, the WEB / AP server 11 that constitutes the system 100 together with the DB server 10 includes a control unit 300, a storage unit 301, an input unit 302, a display unit 303, and a network interface unit 304. It comprises. Each part is connected by BUS. The storage unit 301 stores a program 310 for implementing a stamp instruction function 311, an output instruction function 312, a mail FAX transmission function 313, a form count function 314, and a form count totaling function 315. Yes. The program 310 is loaded into a memory (not shown) by the control unit 300 and executed.

  FIG. 4 is a diagram illustrating a hardware configuration example of the member billing management server 12. As with the DB server 10, the member billing management server 12 that constitutes the system 100 together with the DB server 10 and the WEB / AP server 11 includes a control unit 400, a storage unit 401, an input unit 402, and a display unit. 403 and a network interface unit 404. Each part is connected by BUS. The display unit 403 is connected to a peripheral device (printer) 14 via a print interface unit 405. The storage unit 401 stores a program 410 for implementing a basic charge calculation function 411, a pay-per-use charge calculation function 412, a monthly charge calculation function 413, a member management master registration function 414, and an invoice output function 415. The program 410 is loaded into a memory (not shown) by the controller 400 and executed.

  In addition, the function with which the member charge management system 100 of this embodiment is provided is demonstrated anew. As described above, the functions described below can be said to be functions that are implemented, for example, by executing programs provided in the servers 10 to 12 constituting the member billing management system 100, for example.

  The system 100 counts the number of details printed on a form output to a predetermined peripheral device (output device) 14 in response to an instruction from each user terminal 13, and uses the value of the number of form output records obtained by the count as a member. The management master table 211 has a function of storing in association with the corresponding user.

  In addition, the system 100 is stored in the member management master table 211 according to, for example, detection of arrival of a predetermined time by a clock function normally provided as a computer, or an instruction received from the input unit 202 or the user terminal 13. It has a function of reading the basic charge and the number of form output records for a predetermined user.

  Further, when the number of read form output records is equal to or less than a predetermined lower limit value, the system 100 determines a predetermined lower limit charge value as a metered charge, and the read number of form output records is a predetermined predetermined value. If it is equal to or greater than the upper limit value, the predetermined upper limit charge value is determined as a pay-as-you-go charge, and if the number of read form output records is between the predetermined lower limit value and the predetermined upper limit value, the number of corresponding form output records is multiplied by a predetermined coefficient. A function of determining a metered fee by adding the lower limit fee value to the value;

  In addition, the system 100 has a function of adding the read basic charge and the determined usage charge for each user to calculate the charge amount of the corresponding user.

  The system 100 counts the number of faxes or e-mails sent in response to an instruction from each user terminal 13, and the value of the number of faxes or e-mails sent by the count is stored in the member management master table 211. It has a function of storing in association with the corresponding user.

  In addition, the system 100 detects the arrival of a predetermined time by a clock function provided as a computer or the predetermined user stored in the member management master table 211 in response to an instruction received from the input unit 202 or the user terminal 13. It has a function of reading the basic charge, the number of form output records, and the value of the number of transmissions.

  In addition, the system 100 has a function of determining a usage fee by further adding a multiplication value of the number of transmissions and a predetermined coefficient when determining a usage fee based on the number of form output records.

  The system 100 may store a bill format in the storage unit 201. In this case, the system 100 calculates a billing amount by adding the basic fee obtained for the predetermined user and the metered fee, and sets the value of the billing amount in the billing amount column in the bill format, Information stored for the user in the member management master table 211 is set in the corresponding column in the invoice format to generate invoice data, and the invoice data is generated from a predetermined output device (peripheral device 14) to a predetermined It has a function of outputting to the user terminal 13 of the user.

  In addition, the storage unit of the system 100 may store a list of basic charges according to the facility capacity of the warehouse and the usage level of the application. In this case, the system 100 receives input from the input unit 202 or the user terminal 13 regarding the identification information of the company regarding the user, the facility capacity of the warehouse, and the usage level of the application. It has a function of collating the degree of use of the application with the list, determining a basic charge for a predetermined user, and storing it in association with the corresponding user in the member management master table 211.

--- Data structure example ---
Next, an example of the data structure in the table used by the system 100 of this embodiment will be described. FIG. 5 is a diagram illustrating a data configuration example of the member management master table 211 included in the DB server 10. The member management master table 211 is a master table that stores information about member companies that use the cloud service, and is a table that is created in advance by an administrator or the like and stored in the storage unit 201 of the DB server 10.

  As shown in FIG. 5, the member management master table 211 uses a company code (hereinafter, “code” is written as “CD”) 501 as a key, a business department CD 502, a member company name 503, and an equipment capacity 屯 504. And a set of records in which the equipment rank 505 and the function rank 506 are associated with each other. Here, the company CD 501 stores a CD assigned to the member company. The business department CD 502 stores a CD assigned to the business department of the member company. Member companies are identified using the company CD 501 and the business department CD 502 as keys. The member company name 503 stores the company name of the company associated with the record. The equipment capacity 504 stores the equipment capacity の of the company associated with the record. The equipment rank 505 stores the equipment rank specified on the condition that the company CD501 of the corresponding company, the business department CD502, and the equipment capacity 504. The function rank 506 stores the function rank of the company associated with the record (the function rank that can be used by the warehouse management application in accordance with the contents of the cloud service contract).

  FIG. 6 is a diagram illustrating a data configuration example of the equipment rank master table 212 included in the DB server 10. The equipment rank master table 212 is a master table for storing information on equipment capacity of the warehouse possessed by each member and equipment rank corresponding thereto. This table is prepared in advance by an administrator or the like and stored in the storage unit 201 of the DB server 10. As shown in FIG. 6, the equipment rank master table 212 is a record in which company CD601, business department CD602, equipment rank 603, equipment capacity 屯 _minimum 604, and equipment capacity 屯 _maximum 605 are associated with each other. It is an aggregate.

  Here, a management CD that uniquely identifies a member company is stored in the company CD 601 and the business department CD 602. The equipment rank 603 indicates “A” when the equipment capacity 屯 is less than 5,000 tons, “B” when the equipment capacity is less than 5,000 tons and less than 10,000 tons, and “B” when the equipment capacity is more than 10,000 to less than 15,000 tons. "C" is 15,000 tons and less than 20,000 tons, "D" is 20,000 to less than 30,000 tons, "E" is 30,000 to less than 40,000 tons, "F" “G” if it is 40,000 to 50,000 tons, “H” if it is 50,000 to 60,000 tons, “I” if it is 60,000 to 70,000 tons, and “I” if it is 60,000 to 70,000 tons. "J" for less than 10,000 tons, "K" for more than 80,000 tons and less than 90,000 tons, "L" for more than 90,000 tons and less than 100,000 tons, "M" for more than 100,000 tons Each rank value is set. In the equipment capacity 屯 _minimum 604 and the equipment capacity 屯 _maximum 605, the minimum value and the maximum value of the range of the equipment capacity 屯 corresponding to the equipment rank 603 are stored, respectively.

  FIG. 7 is a diagram illustrating a data configuration example of the basic charge master table 213 included in the DB server 10. The basic charge master table 213 is a master table that stores basic charge information. As shown in FIG. 7, the basic charge master table 213 stores a company CD 701 for identifying member companies, a business department CD 702, an equipment rank 703, a function rank 704, and a basic charge 705 in association with each other. Here, a management CD that uniquely identifies a member company is stored in the company CD 701 and the business department CD 702. The function rank 704 stores the rank of the use function corresponding to the contract content of the cloud service. For example, storage (basic) 1 function and selection 6 function (bonding management, storage (expansion), billing management, WEB information provision, EDI, management information (DWH)) are functions related to warehouse management provided by the cloud service. In the case where the member exists, if the function used by the member is only the storage (basic) one function, the function rank 704 is “Lite”. When the function used by the member is storage (basic) 1 function + selection 3 function, the function rank 704 is “Middle”. When the function used by the member is storage (basic) 1 function + selected all functions, the function rank 704 is “Full”. In the basic fee 705, a basic fee determined by the equipment rank 703 and the function rank 704 is set.

  FIG. 8 is a diagram illustrating a data configuration example of the stamp data table 214 included in the DB server 10. The stamp data table 214 is a data table that stores stamp information output from the system 100 to the peripheral device 14 or the like according to an instruction from the user terminal 13. The information stored in the stamp data table 214 is updated when the program 310 is executed by the control unit 300 of the WEB / AP server 11. As shown in FIG. 8, the stamp data table 214 includes a company CD 801, a business department CD 802, a form ID 803, a creation number 804, a form name 805, a file type 806, a page number 807, and a record number 808. , The number of copies 809 and the output destination printer name 810, respectively. Here, a management CD that uniquely identifies a member company is stored in the company CD 801 and the business department CD 802. The form ID 803 stores a form ID determined for each form. The creation number 804 stores a creation number issued when the stamp information is created. The form name 805 stores the name of the form associated with the form ID 803. The file type 806 stores the file format of the stamp information. “PDF” in the case of the PDF format, “CSV” in the case of the CSV format, and “print” in the case of output from the printer on paper. Stored. The page number 807 stores the number of PDF files and paper pages. When the file type 806 is “CSV”, “***” is stored. The record number 808 stores the record number of the stamp information. The number of copies 809 is stored when the file type 806 is “print”. The output destination printer name 810 stores the name of the output destination printer (peripheral device 14) when the file type 806 is “print”.

  FIG. 9 is a diagram illustrating a data configuration example of the output instruction data table 215 included in the DB server 10. The output instruction data table 215 is a table that stores output instruction information created when an output instruction is issued for a record in the stamp data table 214. Information stored in the output instruction data table 215 is updated when the control unit 200 executes the program 210. As shown in FIG. 9, the output instruction data table 215 includes an output instruction CD 901, an output instruction category 902, a company CD 903, a business department CD 904, a form ID 905, a creation number 906, a mail FAX ID 907, and an output destination printer. This is a set of records in which the name 908 and the file name 909 are associated with each other. As the output instruction ID 901, a management ID for uniquely identifying the output instruction information is automatically issued and stored. The output instruction section 902 stores the output instruction section of the stamp information, and “PDF output instruction” when output in PDF format, “CSV output instruction” when output in CSV format, and printer output on paper. In the case of “print instruction”, “print instruction” is stored. The company CD 903 and the business department CD 904 store a management CD that uniquely identifies a member company. The form ID 905 stores the form ID of the output stamp information. The mail FAX ID 906 stores an ID that is automatically assigned when the output stamp information is sent by mail or FAX. The output destination printer name 907 stores the name of the output destination printer when the output instruction category 902 is “print instruction”. The file name 908 stores the file name to be output when the output instruction category 902 is “PDF output instruction” or “CSV output instruction”.

  FIG. 10 is a diagram illustrating a data configuration example of the mail FAX transmission data table 216 included in the DB server 10. The mail FAX transmission data table 216 is a table for storing transmission information created when mail or FAX transmission is performed from the system 100 in response to an instruction from the user terminal 13. Information stored in the mail FAX transmission data table 216 is updated when the program 310 is executed by the control unit 300 of the WEB / AP server 11. As shown in FIG. 10, the mail FAX transmission data table 216 includes a mail ID 1001, a company CD 1002, a business department CD 1003, a form ID 1004, a mail / fax transmission category 1005, a TO mail address 1006, and a FROM mail address 1007. The CC mail address 1008, the BCC mail address 1009, the FAX number 1010, the attached file name 1011 and the number of transmitted pages 1012 are associated with each other. The mail ID 1001 stores the mail ID 906 numbered when the output is instructed. The company CD 1002 and the business department CD 1003 store management CDs that uniquely identify member companies. The form ID 1004 stores the form ID of the transmitted form. The mail / fax transmission section 1005 stores the transmission section, and stores “mail” when the mail is transmitted, and “FAX” when the fax is transmitted. The TO mail address 1006 stores the TO mail address of the transmission destination. The FROM mail address 1007 stores a transmission source mail address. The CC mail address 1008 stores the CC mail address of the transmission destination. The BCC mail address 1009 stores the destination BCC mail address. The FAX number 1010 stores a transmission destination FAX number. The attached file name 1011 stores a file name to be attached in the case of mail transmission, and stores the name of a PDF file to be transmitted by FAX in the case of FAX transmission. The number of transmission pages 1012 stores the number of transmission pages when a PDF file is transmitted by e-mail or when FAX transmission is performed.

  FIG. 11 is a diagram illustrating a data configuration example of the form count data table 217 included in the DB server 10. The form count data table 217 is a table that summarizes the output information of the form, and is a table in which information grouped by the output instruction ID 901, the company CD 903, the business department CD 904, and the form ID 905 of the output instruction data table 215 is registered. . Information stored in the form count data table 217 is updated when the program 310 is executed by the control unit 300 of the WEB / AP server 11. As shown in FIG. 11, the form count data table 217 includes a company CD 1101, a business department CD 1102, a form ID 1103, a start date and time 1104, an end date and time 1105, a stamp instruction category 1106, and a CSV output instruction category 1107. A PDF output instruction section 1108, a FAX output instruction section 1109, a mail CSV output instruction section 1110, a mail PDF output instruction section 1111, an output number 1112 and an output record 1113 are stored in association with each other.

  The company CD 1101 and the business department CD 1102 store a management CD that uniquely identifies a member company. The form ID 1103 stores the form ID of the output form. The start date and time 1104 and the end date and time 1105 store the date and time when the form counting function program is started and the date and time when the form count function program is ended, respectively. In the stamp instruction category 1106, “1” is stored when the stamp is output, and “0” is stored when the stamp is not output. The CSV output instruction section 1107 stores “1” when CSV output is performed and “0” when no CSV output is performed. In the PDF output instruction section 1108, “1” is stored when the PDF is output, and “0” is stored when the PDF is not output. The FAX output instruction section 1109 stores “1” when FAX transmission is performed, and “0” when it is not transmitted. The mail CSV output instruction category 1110 stores “1” when the CSV file is transmitted by mail, and “0” when the CSV file is not transmitted. The mail PDF output instruction category 1111 stores “1” when the PDF file is transmitted by mail and “0” when the PDF file is not transmitted. The number of output sheets 1112 stores the number of output sheets, and no numerical value is stored in the case of CSV output. The output record 1113 stores the number of output records.

  FIG. 12 is a diagram illustrating a data configuration example of the form count tabulation data table 218 included in the DB server 10. The form count total data table 218 is a table that summarizes the information of the form count data table 217 for each member company, the number of output records, the number of mail transmissions, and the number of FAX transmissions. Information stored in the form count summary data table 218 is updated when the program 310 is executed by the control unit 300 of the WEB / AP server 11. As shown in FIG. 12, the form count totaling data table 218 stores a company CD 1201, a business department CD 1202, a form output record number 1203, a mail transmission count 1204, and a FAX transmission number 1205 in association with each other. The company CD 1201 and the business department CD 1202 store management CDs that uniquely identify member companies. The form output record count 1203 stores the sum of the output records 1113 when the form count data table 217 is searched for the company CD and the business department CD. The mail transmission count 1204 indicates that the number of records in which the mail CSV output instruction category 1109 is “1” or the mail CSV output instruction category 1110 is “1” when the form count data table 217 is searched by the company CD and the business department CD. Is output. The FAX transmission number 1205 stores the sum of the output number 1112 when the FAX output instruction category 1109 is “1” when the form count data table 217 is searched by the company CD and the business department CD.

  FIG. 13 is a diagram illustrating a data configuration example of a metered rate master table 219 included in the DB server 10. The metered fee master table 219 is a master table that stores metered fee information. As shown in FIG. 13, the pay-per-use master table 219 includes a company CD 1301, a business department CD 1302, an equipment rank 1303, a lower limit charge 1304, an upper limit charge 1305, a determination record number 1_1306, a determination record number 2_1307, The number of determination records 3_1308, the coefficient 1309, the FAX unit price 1310, and the mail unit price 1311 are stored in association with each other. Here, a management CD for uniquely identifying a member company is stored in the company CD 1301 and the business department CD 1302. The equipment rank 1303 stores the equipment rank. The lower limit charge 1304 and the upper limit charge 1305 are information necessary for calculating a pay-per-use charge based on the number of output records, and an amount determined for each equipment rank is set. The judgment record number 1_1306 is one of the judgment values of the metered fee based on the number of output records, and stores the minimum number of records, for example, “50,000”. The minimum number of records can be determined based on, for example, the minimum value of the number of record output records per month according to the equipment capacity of approximately 100 warehouse companies. The judgment record number 2_1307 is one of the judgment values of the metered fee based on the number of output records, and stores the maximum number of records, for example, “1,000,000”. The maximum number of records can also be determined based on the maximum number of forms output records per month for about 100 companies in the warehouse industry (the maximum number of records per month is about 85% of the 100 companies). It can be determined with reference to a value of 1 million or less).

  The judgment record number 3_1308 is one of the judgment values of the pay-per-use fee based on the number of output records, and stores the maximum number of records that require individual estimation, for example, “2,000,000”. With regard to the maximum number of records that require an individual estimate, it can be determined by referring to the number of record output records per month for each of the 100 warehousing companies. For example, in about 5% of the 100 companies, the number of records per month can be determined with reference to a value of 2 million or more. For example, “0.07” is stored in the coefficient 1309 in consideration of the balance with the basic charge 705.

  The FAX unit price 1310 is a unit price per sheet used for calculation of a pay-per-use fee based on the number of FAX output sheets. For example, “25” is stored. The mail unit price 1311 is a unit price per time used for calculation of a pay-per-use charge based on the number of mail transmissions. For example, “5” is stored.

  FIG. 14 is a diagram illustrating a data configuration example of the billing result data table 220 included in the DB server 10. The billing record data table 220 is a data table that stores billing record information. Information stored in the billing result data table 220 is updated when the program 410 is executed by the control unit 400 of the member billing management server 12. As shown in FIG. 14, the billing result data table 220 includes a company CD 1401, a business department CD 1402, a member company name 1403, a billing date 1404, a function rank 1405, an equipment rank 1406, a basic charge 1407, Number of form output records 1408, number of fax transmissions 1409, number of email transmissions 1410, form output fee 1411, fax transmission fee 1412, email transmission fee 1413, metered fee (total) 1414, billed amount (excluding tax) ) 1415, billed amount (tax amount) 1416, and billed amount (total) 1417 are stored in association with each other. Here, the company CD 1401 stores a CD assigned to the member company.

  The business department CD 1402 stores a CD assigned to the business department of the member company. Member companies are identified using the company CD 1401 and the business department CD 1402 as keys. The member company name 1403 stores the company name of the company associated with the record. The billing date 1404 stores the billing date. The function rank 1405 stores the function ranks of the company CD and the business department CD. The equipment rank 1406 stores the equipment ranks of the company CD and the business department CD. The basic charge 1407 stores the basic charge calculated by the basic charge function. The form output record number 1408 stores the number of output records calculated by the form output count totaling function. The FAX transmission number 1409 stores the FAX transmission number 1409 calculated by the form output count totaling function. The mail transmission count 1410 stores the mail transmission count calculated by the form output count totaling function. The form output fee 1411 stores the form output fee calculated by the form output count totaling function. The FAX transmission fee 1412 stores the FAX transmission fee calculated by the form output count totaling function. The mail transmission fee 1413 stores the mail transmission fee calculated by the form output count totaling function. The metered fee (total) 1414 stores the metered fee (total) calculated by the monthly fee calculation function. The billing amount (tax excluded) 1415 stores the billing amount (tax excluded) calculated by the monthly fee calculation function. The billing amount (tax amount) 1416 stores the billing amount (tax amount) calculated by the monthly fee calculation function. The billing amount (total amount) 1417 stores the billing amount (total amount) calculated by the monthly fee calculation function. The determination record number flag 1418 stores “0” when the number of form output records 1408 is less than 2 million. If the form output record count flag 1408 is 2 million or more, “1” is stored.

--- Example of processing procedure 1 ---
Hereinafter, an actual procedure of the member billing management method in the present embodiment will be described with reference to the drawings. Various operations corresponding to the member billing management method described below are realized by programs that the servers 10 to 12 constituting the system 100 read into the memory or the like and execute. And this program is comprised from the code | cord | chord for performing the various operation | movement demonstrated below.

  FIG. 15 is a flowchart showing a processing procedure example 1 of the member billing management method in the present embodiment, and is a flowchart showing processing of the basic fee calculation function 411 provided in the member billing management server 12. In this flowchart, the basic fee calculation function 411 extracts equipment rank and function rank data from the member management master table 211 using a predetermined company CD and business department CD as keys (step S101).

  The basic charge calculation function 411 extracts a basic charge from the basic charge master table 213 using the company CD, the business department CD, and the equipment rank and function rank extracted in step S101 as keys (step S102). .

  The basic charge calculation function 411 writes the basic charge extracted in step S102 in the billing result data table 220 in association with the company CD and business department CD, equipment rank and function rank (step S103). .

  In executing the above flow, as shown in FIG. 25, the member billing management server 12 displays a member company information registration screen on the display unit 403 or the user terminal 13, and the input unit 402 or the user terminal 13 It is also possible to accept input of own information by the member company via.

--- Processing procedure example 2 ---
FIG. 16 is a flowchart showing a processing procedure example 2 of the member billing management method in the present embodiment, and is a flowchart showing processing of the stamp instruction function 311 provided in the WEB / AP server 11. The stamp instruction function 311 in this flowchart detects that a stamp instruction has been issued from the user terminal 13 via the cloud service provided by the system 100 (step S201), and creates the stamp information and the created stamp. Writing of the book information to the stamp data table 214 is executed (step S202).

--- Processing procedure example 3 ---
FIG. 17 is a flowchart showing a processing procedure example 3 of the member billing management method in the present embodiment, and is a flowchart showing a process of the output instruction function 312 provided in the WEB / AP server 11. The output instruction function 313 in this flowchart receives, for example, an output instruction regarding the record of the stamp data table 214 from the user terminal 13 (step S301), generates output instruction information, and the generated information is output to the output instruction data table 215. (Step S302). Further, the output instruction function 313 writes the automatically-assigned mail FAX ID in the output instruction data table 215 when performing mail or FAX transmission according to the output instruction (step S303: Y) (step S304). On the other hand, when mail or FAX transmission is not performed in response to the output instruction (step S303: N), the process ends.

--- Processing procedure example 4 ---
FIG. 18 is a flowchart showing a processing procedure example 4 of the member billing management method in the present embodiment, and is a flowchart showing processing of the mail FAX transmission function 313 provided in the WEB / AP server 11. If the mail FAX ID 906 in the output instruction data table 215 has a value (step S401: Y), the mail FAX transmission function 313 in this flowchart executes a mail or FAX transmission process (step S402), and sends the transmission information to the mail FAX. Write to the transmission data table 216. On the other hand, when there is no value in the mail FAX ID 906 of the output instruction data table 215 (step S401: N), the mail FAX transmission function 313 ends the process.

--- Processing procedure example 5 ---
FIG. 19 is a flowchart showing a processing procedure example 5 of the member billing management method in the present embodiment, and is a flowchart showing the processing of the form counting function 314 provided in the WEB / AP server 11. The form count function 314 in this flowchart is, for example, a predetermined (eg, the head of the list or the instruction from the user terminal 13) output instruction ID, company CD, business department CD, in the output instruction data table 215. Using the form ID as a key, information related to form output, mail, and fax transmission is extracted, and the extracted information is written into the form count data table 217 (step S501).

  When the output instruction data table 215 has a mail FAXID (step S502: Y), the form count function 314 searches the mail FAX transmission data table 216 using the mail FAXID as a key, and extracts the extracted information as form count data. Write to the table 217 (step S503). On the other hand, if the output instruction data table 215 does not have a mail FAX ID (step S502: N), the form count function 314 ends the process.

--- Example of processing procedure 6 ---
FIG. 20 is a flowchart showing a processing procedure example 6 of the member billing management method in the present embodiment, and is a flowchart showing the processing of the form count totaling function 315 provided in the WEB / AP server 11. The form count totaling function 315 in this flowchart extracts a corresponding record from the form count data table 217 by using a predetermined company CD, business department CD, start date / time, and end date / time as keys. (Step S601), an output record is acquired (Step S602).

  Further, the form count totaling function 315 writes the sum of the values of the output records acquired in step S602 in the form count total data table 218 (step S603). Further, the form count totaling function 315 obtains a record in which the mail CSV output instruction category is “1” or the mail PDF output instruction category is “1” in the form count data table 217 (step S604), and the number of the corresponding records is obtained. The number of mail transmissions in the form count summary data table 218 is written (step S605).

  Further, the form count totaling function 315 acquires a record whose FAX output instruction classification is “1” in the form count data table 217 (step S606), and the total number of output sheets of the corresponding record is obtained as a form count total data table 218. Is written in the FAX transmission number (step S607).

--- Processing procedure example 7 ----
FIG. 21 is a flowchart showing a processing procedure example 7 of the member billing management method in the present embodiment, and is a flowchart showing processing of the metered fee calculation function 412 provided in the member billing management server 12. The metered rate calculation function 412 in this flowchart uses, for example, a predetermined company CD and a business department CD such as those specified by the user terminal 13 as a key, the number of form output records in the form count total data table 218, the number of FAX transmissions, Each value of the number of times of mail transmission is written in the corresponding column of the billing result data table 220 (step S701).

  The pay-as-you-go calculation function 412 extracts the equipment rank value of the member management master table 211 for the member company (step S702). Also, the pay-per-use calculation function 412 obtains the value of the lower limit charge from the pay-per-use master table 219 when the number of form output records in the member company obtained in step S701 is less than 50,000 (step S703: Y). Acquired and written in the form output fee column of the billing result data table 220 (step S704).

  On the other hand, when the number of form output records obtained in step S701 is not less than 50,000 and less than 1 million (step S705: Y), the pay-as-you-go calculation function 412 uses the pay-as-you-go master table 219 and the lower limit charge and coefficient. Each value is acquired (step S706). The pay-as-you-go calculation function 412 obtains a product of the number of form output records obtained in step S701 and the value of the coefficient obtained in step S706, and obtains the sum of the product and the lower limit charge. It is written in the form output fee of the billing result data table 220 (step S707).

  On the other hand, when the number of form output records is 1 million or more and less than 2 million (step S708: Y), the pay-per-use charge calculation function 412 acquires the value of the upper limit charge for the member company from the pay-per-use master table 219, It is written in the form output fee of the billing result data table 220 (step S709).

  Further, when the number of form output records is 2 million or more (step S708: N), the pay-as-you-go calculation function 412 acquires the value of the upper limit charge from the pay-as-you-go master table 219 and outputs the form in the billing result data table 220. Write in the price. The metered fee calculation function 412 writes “1” in the determination record number flag of the billing record data table 220 (step S710). The pay-as-you-go calculation function 412 writes the number of form output records in the billing result data table 220 (step S711).

  The metered fee calculation function 412 acquires the value of the FAX unit price from the metered rate master table 219 (step S712), multiplies the FAX unit price by the number of FAX transmissions (obtained in step S701 above), and transmits the FAX. The charge is calculated, and the number of FAX transmissions and the FAX transmission charge in the billing result data table 220 are written in each column (step S713). The metered fee calculation function 412 obtains the value of the email unit price from the metered rate master table 219 (step S714), multiplies the email unit price by the number of email transmissions (obtained in step S701 above), and sends the email. The charge is calculated, and the number of mail transmissions and the mail transmission charge in the billing result data table 220 are written in each column (step S713).

--- Processing procedure example 8 ----
FIG. 22 is a flowchart showing a processing procedure example 8 of the member billing management method in the present embodiment, and is a flowchart showing a process of the monthly fee calculation function 413 provided in the member billing management server 12. The monthly fee calculation function 413 in this flowchart adds up each value of the form output fee, the FAX transmission fee, and the email transmission fee of the billing result data table 220 with respect to the predetermined member company, and the total value is a metered fee (total ) Field (step S801).

  Further, the monthly fee calculation function 413 writes the sum of the basic fee (specified in the basic fee master table 213) relating to the predetermined member company and the pay-as-you-go fee (total) in the billing amount (excluding tax) field ( Step S802). Further, the monthly fee calculation function 413 calculates the tax amount and the total amount from the value of the invoiced amount (excluding tax), and writes it in the invoiced amount (tax amount) and the invoiced amount (total amount), respectively (step S803).

--- Processing procedure example 9 ---
FIG. 23 is a flowchart showing a processing procedure example 9 of the member billing management method in the present embodiment, and is a flowchart showing a process of the bill output function 415 provided in the member billing management server 12. The bill output function 415 in this flowchart acquires billing information regarding a predetermined member company from the billing record data table 220 (step S901), and sets the acquired information in a predetermined bill layout (see FIG. 24). (Step S902) and output to the peripheral device 14 such as a printer (Step S903).

  FIG. 24 is a diagram showing a layout example of an invoice printed from the peripheral device (printer) 14 of the member billing management server 12. Each item is associated with an item in the billing result data table 220.

  Although the best mode for carrying out the present invention has been specifically described above, the present invention is not limited to this, and various modifications can be made without departing from the scope of the invention.

  According to this embodiment, it is possible to perform appropriate billing management according to the service actually used and its contents in consideration of the scale of the user company that performs warehouse management work.

At least the following will be clarified by the description of the present specification. That is, in the member billing management system, the calculation unit counts the number of faxes or e-mails transmitted in response to an instruction from each user terminal, and obtains the value of the number of faxes or e-mails transmitted by the count, Stored in the storage unit in response to a process of storing in association with the corresponding user in the storage unit, detection of arrival of a predetermined time by a clock function provided as a computer, or an instruction received from the input unit or the user terminal In the process of reading the basic charge of the predetermined user, the number of form output records, and the number of transmission records, and when determining the pay-per-use fee based on the number of form output records, the multiplication value of the number of transmissions and a predetermined coefficient is further added. Then, the process for determining the metered fee may be executed.

  In the member billing management system, the storage unit stores a bill format, and the calculation unit calculates a billing amount by adding the basic fee obtained for the predetermined user and the metered fee. The bill amount value is set in the bill amount column in the bill format, and the information stored for the user in the member management table is set in the corresponding column in the bill format to generate bill data. The bill data may be output to a predetermined output device or a user terminal of a predetermined user.

Further, in the member billing management system, the storage unit stores a list of basic charges according to the facility capacity of the warehouse and the usage level of the application, and the calculation unit is connected to the user from the input unit or the user terminal. The company's identification information, warehouse equipment capacity, and application usage level are input, and the warehouse equipment capacity and application usage level for the given user received here are checked against the above list, and the basic charge for the given user is calculated. It may be determined and stored in the storage unit in association with the corresponding user.

10 DB server 11 WEB / AP server 12 Member billing management server 13 User terminal 14 Peripheral device (printer, etc.)
100 Member billing management system 200, 300, 400 Control unit (calculation unit)
201, 301, 401 Storage unit 202, 302, 402 Input unit 203, 303, 403 Display unit 204, 304, 404 Network interface unit (communication unit)
211 Member management master table (member management table)
212 Equipment rank master table 213 Basic charge master table 214 Print data table 215 Output instruction data table 216 Mail FAX transmission data table 217 Form count data table 218 Form count total data table 219 Pay-per-use master table 220 Billing result data table 405 Print interface Part

Claims (6)

In a cloud service that allows a user terminal to use an application for warehouse management work, it is a computer system that performs billing management for users,
A communication unit that communicates with an external device;
Membership management table that stores the facility capacity related to each user's warehouse and the contract contents according to the degree of use of the application, and the basic charge that stores information on basic charges determined according to the combination of the facility capacity of the warehouse and the contract contents Stores a table and a metered rate table that stores information on the metered fee determined according to the number of items printed on the form output by the user and the information on the upper limit fee and the lower limit fee determined according to the facility capacity of the warehouse A storage unit;
From the member management table, the facility capacity of the predetermined user and the contract content data are extracted, and the basic fee of the user is specified in the basic fee table using the extracted facility capacity and contract content of the user as a key. , A process of associating the value of the basic charge with the corresponding user and storing it in the storage unit,
Count the number of details printed on a form output to a predetermined output device in response to an instruction from each user terminal, and store the value of the number of form output records obtained by the count in association with the corresponding user in the storage unit Processing,
Detection of arrival of a predetermined time by a clock function provided as a computer, or processing for reading the value of a basic charge and the number of form output records of a predetermined user stored in the storage unit in response to an instruction received from an input unit or a user terminal When,
When the number of read form output records is equal to or less than a predetermined lower limit value, the lower limit charge value in the pay- per-use table is determined as a pay-per-use charge according to the information on the facility capacity of the corresponding user in the member management table. When the number of read form output records is equal to or greater than a predetermined upper limit value, the corresponding upper limit charge value in the pay- per-use charge table is determined as a pay-per-use charge according to the information on the facility capacity of the corresponding user in the member management table. When the number of read form output records is between a predetermined lower limit value and a predetermined upper limit value, a process for determining a metered charge by adding the lower limit charge value to the product of the corresponding form output record number and a predetermined coefficient; ,
A calculation unit that performs a process of calculating the charge amount of the corresponding user by adding the read basic charge and the determined charge for each user,
A membership billing management system comprising: The computing unit is
A process of counting the number of faxes or e-mails transmitted in response to an instruction from each user terminal, and storing the value of the number of faxes or e-mails obtained by the count in association with the corresponding user in the storage unit; ,
Detection of arrival of a predetermined time by a clock function provided as a computer, or a basic charge of a predetermined user , the number of form output records, and the number of transmissions stored in the storage unit according to an instruction received from an input unit or a user terminal Processing to read the value of
When determining a metered fee based on the number of form output records, a process of determining a metered fee by further adding a multiplication value of the number of transmissions and a predetermined coefficient is executed.
The member billing management system according to claim 1. The storage unit
Remembers the invoice format,
The computing unit is
The basic charge obtained for the predetermined user and the metered charge are added together to calculate the charge amount, the charge amount value is set in the charge amount column in the invoice format, and the member management table stores the relevant user. Information is set in a corresponding column in the invoice format to generate invoice data, and the invoice data is output to a predetermined output device or a user terminal of a predetermined user.
The member billing management system according to claim 1 or 2, characterized in that The storage unit
We store a list of basic charges according to the capacity of the warehouse and the degree of application usage,
The computing unit is
From the input unit or user terminal, the company identification information about the user, the facility capacity of the warehouse, and the usage level of the application are received, and the facility capacity of the warehouse and the usage level of the application regarding the given user received here are collated with the above list. And determining a basic charge related to the predetermined user and storing the basic charge in association with the corresponding user in the storage unit,
The member billing management system according to any one of claims 1 to 3. In the cloud service that allows the user terminal to use an application for warehouse management work, according to the communication unit that communicates with the external device, the facility capacity of each user in relation to the warehouse, and the usage level of the application in order to perform billing management for the user Membership management table memorized about contract details, basic fee table memorized basic fee information determined according to the combination of warehouse capacity and contract details, and according to the number of items printed on user-output forms A storage unit for storing a pay-per-use fee and a pay-per-use table storing each information of the upper limit charge and the lower limit charge of the pay-per-use charge determined according to the facility capacity of the warehouse, and a computer having a calculation unit,
From the member management table, the facility capacity of the predetermined user and the contract content data are extracted, and the basic fee of the user is specified in the basic fee table using the extracted facility capacity and contract content of the user as a key. , A process of associating the value of the basic charge with the corresponding user and storing it in the storage unit,
Count the number of details printed on a form output to a predetermined output device in response to an instruction from each user terminal, and store the value of the number of form output records obtained by the count in association with the corresponding user in the storage unit Processing,
Detection of arrival of a predetermined time by a clock function provided as a computer, or processing for reading the value of a basic charge and the number of form output records of a predetermined user stored in the storage unit in response to an instruction received from an input unit or a user terminal When,
When the number of read form output records is equal to or less than a predetermined lower limit value, the lower limit charge value in the pay- per-use table is determined as a pay-per-use charge according to the information on the facility capacity of the corresponding user in the member management table. When the number of read form output records is equal to or greater than a predetermined upper limit value, the corresponding upper limit charge value in the pay- per-use charge table is determined as a pay-per-use charge according to the information on the facility capacity of the corresponding user in the member management table. When the number of read form output records is between a predetermined lower limit value and a predetermined upper limit value, a process for determining a metered charge by adding the lower limit charge value to the product of the corresponding form output record number and a predetermined coefficient; ,
A process of adding the read basic charge and the determined usage charge for each user to calculate the charge amount of the user;
A member billing management method characterized in that: In the cloud service that allows the user terminal to use an application for warehouse management work, according to the communication unit that communicates with the external device, the facility capacity of each user in relation to the warehouse, and the usage level of the application in order to perform billing management for the user Membership management table memorized about contract details, basic fee table memorized basic fee information determined according to the combination of warehouse capacity and contract details, and according to the number of items printed on user-output forms A storage unit that stores a metered rate table and a metered rate table that stores information on each of the upper limit fee and the lower limit fee of the metered rate determined according to the facility capacity of the warehouse, and a computer having a calculation unit,
From the member management table, the facility capacity of the predetermined user and the contract content data are extracted, and the basic fee of the user is specified in the basic fee table using the extracted facility capacity and contract content of the user as a key. , A process of associating the value of the basic charge with the corresponding user and storing it in the storage unit,
Count the number of details printed on a form output to a predetermined output device in response to an instruction from each user terminal, and store the value of the number of form output records obtained by the count in association with the corresponding user in the storage unit Processing,
Detection of arrival of a predetermined time by a clock function provided as a computer, or processing for reading the value of a basic charge and the number of form output records of a predetermined user stored in the storage unit in response to an instruction received from an input unit or a user terminal When,
When the number of read form output records is equal to or less than a predetermined lower limit value, the lower limit charge value in the pay- per-use table is determined as a pay-per-use charge according to the information on the facility capacity of the corresponding user in the member management table. When the number of read form output records is equal to or greater than a predetermined upper limit value, the corresponding upper limit charge value in the pay- per-use charge table is determined as a pay-per-use charge according to the information on the facility capacity of the corresponding user in the member management table When the number of read form output records is between a predetermined lower limit value and a predetermined upper limit value, a process for determining a metered charge by adding the lower limit charge value to the product of the corresponding form output record number and a predetermined coefficient; ,
A process of adding the read basic charge and the determined usage charge for each user to calculate the charge amount of the user;
Membership billing management program characterized in that

Images