JP6644369B1 - Information processing system, information processing method and information processing program - Google Patents

Abstract

A novel information processing system, an information processing method, and an information processing program are provided. In an information processing system, an instruction generating means capable of generating picking instruction data corresponding to a batch format indicating an article to be picked, a position of the article, and a quantity of the article, and an accessory attached to the article indicated by the picking instruction data Inspection means capable of executing inspection processing on the article by reading a code to be executed, and printing processing of a first printed matter including a delivery note on the article and a second printed matter including an invoice on the article based on a batch format. And other printing means. [Selection diagram] FIG.

Description

  The present invention relates to an information processing system, an information processing method, and an information processing program.

  2. Description of the Related Art In recent years, attempts have been made to improve the business of logistics in warehouses using a WMS (warehouse management) system. Improvement of the WMS system is achieved by individually improving element technologies including database management such as data input / output and algorithm design related to work instructions such as picking.

The following operations in warehouse logistics were performed manually, which limited efficiency.
(1) Reserve to allocate inventory to shipping instructions (2) Filtering to classify allocation data by courier company type or specific part number etc. (3) Form printing such as delivery note, invoice, convenience store payment paper, etc. (4) Form During the above-mentioned (1) to (4), the work at the site could not proceed.

  Patent Literature 1 discloses a picking schedule creation system that creates a schedule for picking an ordered article by a method selected from a plurality of picking schemes. Picking information on the picking method is freely rewritten for each shipping destination of the ordered article. A picking method of the stored shipping work management table is selected from a plurality of picking methods (order picking and total picking) and input, and a picking schedule is created according to the picking information input to the shipping work management table. Picking schedule creation systems have been reported.

JP 2007-39181 A

  However, in the current WMS system including the invention described in Patent Literature 1, even if the picking method can be selected, the picking efficiency can be improved, but even the efficiency of the printing operation of a form or the like related to the ordered article to be picked is reduced. It is hard to say that improvement will be easy.

  An object of the present invention is to solve a new information processing system, an information processing method, and an information processing program.

  In order to solve the above-mentioned problem, the present invention is an information processing system, and includes an instruction generation unit capable of generating picking instruction data corresponding to a batch format indicating an article to be picked, a position of the article, and a quantity of the article. Inspection means capable of reading a code attached to the article indicated by the picking instruction data and executing inspection processing on the article, a first printed matter including a delivery note on the article based on the batch format, and A printing unit capable of executing a printing process of a second printed matter including an invoice pertaining to the article prior to the inspection processing, wherein the batch format is an order related to one point of each of the one or more kinds of the articles. A first type indicating picking, a second type indicating total sowing picking of one or more types of the articles according to a predetermined number or more, and a pinch according to two or more types of the articles. A third type indicating total picking in a picking system, a fourth type indicating total picking in one or more types of the predetermined type of articles, and a third type indicating order picking of one type of the predetermined articles. 5 is an information processing system that is at least one of the five formats.

  In order to solve the above problem, the present invention is an information processing method, an instruction generating step capable of generating picking instruction data corresponding to a batch format indicating an article to be picked, a position of the article and a quantity of the article, and An inspection step capable of reading a code attached to the article indicated by the picking instruction data and executing an inspection process for the article, a first printed matter including a delivery note for the article based on the batch format, and And a printing step capable of executing a printing process of a second printed matter including an invoice pertaining to the article prior to the inspection processing. A first format indicating such order picking, a second format indicating total sowing picking of one or more types of said articles, A third format indicating total picking of a picking method according to at least one kind of the article, a fourth format indicating total picking of a picking method according to at least one kind of the article, and one kind of predetermined It is any of the fifth forms indicating order picking of the article.

  In order to solve the above-mentioned problem, the present invention is an information processing program, which is a computer-readable instruction that indicates a target article to be picked, a position of the article, and a quantity of the article and that can generate picking instruction data corresponding to a batch format. Generating means, inspection means capable of reading a code attached to the article indicated by the picking instruction data and executing inspection processing for the article, and a first printed matter including a delivery note for the article based on the batch format; And causing the printing process of the second printed matter including the invoice pertaining to the article to function as a printing unit that can be executed prior to the inspection processing, wherein the batch format is one point of one or more types of the articles. A first format indicating order picking according to the first type, a second format indicating total picking of a seeding method according to one or more types of the articles, A third format indicating total picking of a picking method according to at least one kind of the article, a fourth format indicating total picking of a picking method according to at least one kind of the article, and one kind of predetermined It is any of the fifth forms indicating order picking of the article.

  In a preferred aspect of the present invention, when the batch format indicates the first format, the printing unit does not perform the printing process of the first and second printed materials prior to the inspection process, and Execute after processing is completed.

  In a preferred aspect of the present invention, when the batch format indicates the second or third format, the printing unit does not perform the printing process on the second printed matter prior to the inspection process, Execute after the inspection process is completed.

  In a preferred aspect of the present invention, when the batch format indicates the fourth format, the printing unit does not execute the print processing of the first and second printed materials.

  In a preferred embodiment of the present invention, display means for performing display processing relating to a graphical user interface, and at least a part of a subroutine including first, second and third processing can be set via the graphical user interface. Means, wherein the first processing is a condition determination processing for determining transition to the second processing, and the second processing converts the first data into the second data. The third process is a data registration process for transmitting at least a part of the second data and / or storing the data in a database, and the condition determination process and the data shaping process. The data registration process corresponds to a group.

  In a preferred embodiment of the present invention, the setting means can select the group via the graphical user interface, and when the group is selected, the arguments of the first, second, and third processes and The processing content can be selected.

  In a preferred embodiment of the present invention, the setting means is capable of executing at least one of the subroutines, enabling, disabling, duplicating or deleting the subroutines via the graphical user interface.

  In a preferred aspect of the present invention, the setting means can simultaneously execute addition or deletion of each of the first, second, and third processes via the graphical user interface.

  In a preferred aspect of the present invention, the data shaping processing includes at least one of combining, extracting, deleting, replacing, and full-width conversion of character strings, inputting a fixed value, calculating a date, and calculating a numerical value. Based on one.

  In a preferred embodiment of the present invention, the first data indicates shipping instruction data including at least order number, order date and time, scheduled shipping date, designated delivery date and shipping information, and the database includes at least a product master, It has a supplier master, a carrier master, a warehouse master, and a location master.

According to the present invention, a new information processing system, an information processing method, and an information processing program can be realized.
Further, according to the present invention, it is possible to increase the efficiency of printing operations for slips and forms.
Further, according to the present invention, the picking instructions are classified based on various batch formats, so that the picking movement distance can be shortened, and the shipping efficiency can be improved.
Further, according to the present invention, by defining each of various batch formats, it is possible to promote the automation of the picking work in cooperation with a software robot or the like.

FIG. 1 is a hardware configuration diagram according to an embodiment of the present invention (hereinafter, simply referred to as an embodiment). It is a functional block diagram concerning one embodiment. It is a processing flowchart concerning one embodiment. FIG. 4 is an explanatory diagram of picking instruction data according to one embodiment. It is a processing flowchart concerning one embodiment. 6 is a graphical user interface for setting a subroutine according to one embodiment. 6 is a graphical user interface for setting a subroutine according to one embodiment. 6 is a graphical user interface for setting a subroutine according to one embodiment. 5 is a graphical user interface for setting a batch format and batch division rule information according to one embodiment. 5 is a graphical user interface for setting a batch format and batch division rule information according to one embodiment.

An embodiment will be described with reference to the drawings.
The present invention is not limited to one embodiment, and various configurations can be adopted.
In addition, a configuration, an operation, and the like according to an embodiment will be described. However, a method, a computer program, a recording medium, and the like having a similar configuration can also provide similar functions and effects.
Further, the program may be stored in a recording medium. By using this recording medium, for example, a program can be installed in a computer. Here, the recording medium storing the program may be a non-transitory recording medium such as a CD-ROM.
In one embodiment, for example, a method of transmitting an e-mail to a mail address, or various other methods such as SMS can be used for realizing the functions.

<Hardware configuration>
As shown in FIG. 1A, the information processing system includes a database 0 that can be mutually connected via a network, one or more terminals 1, one or more servers 2, and one or more handy terminals 3. And one or more local servers 4.
As shown in FIG. 1B, a hardware configuration according to an embodiment includes, for example, in a terminal 1, an arithmetic device 101, a main storage device 102, an auxiliary storage device 103, an input device 104, and a display device 105. , A communication device 106, and a bus interface. The server 2, the handy terminal 3, and the local server 4 have the same hardware configuration.
The functions of the server 2 according to an embodiment may be realized by a plurality of servers 2. The local server 4 includes a printing device in addition to the hardware configuration described above. The various types of hardware described above are appropriately used for realizing a function relating to each unit / step described below.

The arithmetic device 101 includes a processor core, for example, a CPU.
The main storage device 102 includes a volatile device such as a RAM.
The auxiliary storage device 103 includes a nonvolatile device such as an HDD, an SSD, or a flash memory, and stores an OS, a program, and the like.
The input device 104 is used for input processing, and the input method is not limited.
The display device 105 is used for display processing and includes a display and a graphic controller.
The communication device 106 is used for communication processing via a network, and the communication method is not limited.

The database 0 according to one embodiment may be constructed in an auxiliary storage device of the server 2 or may be constructed in an external server that can communicate with each other via a network.
The terminal 1 according to one embodiment is a terminal device installed in a warehouse or a remote place remote from the warehouse, and has a conventional configuration such as a smartphone or a laptop.
The server 2 according to one embodiment is used as a backbone server for an information processing system, and has a conventional configuration such as a workstation.
The handy terminal 3 according to one embodiment is a terminal device carried by a worker in a warehouse for mainly performing picking work suitably, and has a conventional configuration such as a smartphone.
The local server 4 according to one embodiment is a server installed in a warehouse for mainly performing a printing operation of a slip or the like, and has a conventional configuration such as a workstation.

《Function block》
<Database 0>
As shown in FIG. 2, the database 0 according to one embodiment includes a product master 1001, a customer master 1002, a delivery method master 1003, a payment method master 1004, a location master 1005, an error master 1006, shipping instruction data 1007, and shipping results. It has data 1008, picking instruction data 1009, design template 1010, delivery note data 1011, invoice data 1012, and subroutine 1013.

<Product Master 1001>
The product master 1001 according to one embodiment includes at least a part of the following information on the product included in the article.
-Product name information indicating the name (article name, product name) of the product-Amount information indicating the amount of money related to the product-Category information indicating any of the product, bundled items, work, and materials as the category of the product-Product Size information indicating the height / width / depth / weight / size coefficient according to the above. Image information indicating an image (still image or moving image) related to the product. Product identification number indicating an identification number corresponding to a code attached to the product / article. Information ・ Inventory code information indicating the inventory code related to the product ・ Inventory number information indicating the number of inventory related to the product ・ Inventory alert number information indicating the number of inventory alerts related to the product ・ Inventory category related to the product as either new or used SKU number information indicating the number of SKUs (minimum management units) related to the product. SKU number information indicating the number of pieces related to the product. Restricted days information ・ Priority information indicating shipping priority etc. for products ・ Lot management information indicating necessity of lot management for products ・ Consumption expiration management information indicating necessity of expiration date management for products ・ Delivery related to products Delivery note display information indicating the necessity of label display-Product remark information including one or more keywords as remarks related to the product

<Customer master 1002>
The customer master 1002 according to one embodiment includes at least a part of the following information on the customer including the orderer and the shipping destination.
-Customer code information indicating a customer code for identifying the customer-Customer name information indicating the name of the customer-Customer contact information indicating the address / telephone number / FAX number / mail address of the customer Information ・ Customer remark information including one or more keywords as remarks related to the customer

<Delivery method master 1003>
The delivery method master 1003 according to one embodiment includes the following information related to the delivery method.
-Delivery method name information indicating the name of the delivery method-Delivery method shipping information indicating the method of calculating the shipping cost related to the delivery method-Delivery method numbering information indicating the numbering method of the invoice related to the delivery method-Remarks related to the delivery method Shipping method remarks information including one or more keywords as

<Payment method master 1004>
The payment method master 1004 according to one embodiment includes the following information on the payment method.
・ Payment method name information indicating the name of the payment method ・ Payment method summary information indicating at least one of various methods including at least credit card / bank transfer / cash on delivery / convenience store / NP postpayment Payment method remark information including one or more keywords as such remarks

<Location Master 1005>
The location master 1005 according to one embodiment indicates the following information related to the storage destination.
-Location information indicating the location for identifying the storage location of the article-Location remark information including one or more keywords as remarks related to the storage location of the article [0032]
<Error master 1006>
The error master 1006 according to one embodiment includes error information associated with a caution error, a critical error, or the like.

<Shipping instruction data 1007>
The shipping instruction data 1007 according to one embodiment includes at least a part of the following information on the ordered article included in the article and the shipping instruction.
-Inventory code information indicating the inventory code of the ordered item-Product code information indicating the product code of the ordered item-Article location information indicating the storage location of the ordered item-Product detail information indicating the item details of the ordered item-Order received Order number information indicating the order number related to the goods ・ Sheet number information indicating the slip number related to the ordered goods ・ Tracking number information indicating the tracking number related to the ordered goods ・ Name / postal code / address / telephone of the destination related to the ordered goods Destination information indicating the number, etc.-Orderer information indicating the name / postal code / address / telephone number, etc. of the orderer pertaining to the ordered item-Order date information indicating the order date pertaining to the ordered item-Shipping date pertaining to the ordered item Shipment date information indicating the expected shipment date of the ordered item-Shipment date information indicating the number of shipments of the ordered item-Cancellation date indicating the cancellation date of the ordered item Information-Return registration date information indicating the return registration date of the ordered item-Hold (payment confirmation) / Hold (address is insufficient) / Hold (Remarks column) / Hold (postpayment data) / Waiting for shipment / Shipping status information indicating any of shipping preparation / shipment inspection completed / returned / canceled / shipped, etc. ・ Delivery status information indicating the delivery status of the ordered item ・ Specifies the correspondence with the external service of the ordered item Registration format information ・ Sender information indicating the sender of the ordered item ・ Payment method information indicating the settlement method of the ordered item ・ Paper information indicating the type of paper such as the delivery note or payment paper for the ordered item ・ Sheet order information Payment confirmation information indicating the presence or absence of such payment ・ Delivery method information indicating the delivery method of the ordered item ・ Delivery date information indicating the desired delivery date of the ordered item ・ Related to the ordered item Desired delivery time information indicating desired delivery time ・ Temperature classification information indicating temperature classification such as room temperature / refrigerated / frozen etc. pertaining to ordered goods ・ Gift information indicating whether or not ordered goods are gifts (designated gifts) Delivery information indicating the necessity of such gifts-Delivery note designation information indicating whether the delivery note pertaining to the ordered item is specified by the sender, for example-Delivery note output information indicating the presence or absence of delivery note output pertaining to the ordered item- Delivery note amount information indicating the presence or absence of the delivery note amount related to the ordered goods ・ Shipping instruction remark information including one or more keywords as notes related to shipping instructions ・ Batch division rule information indicating batch division rules related to shipping instructions

The product specification information according to one embodiment includes at least a part of the following information.
-Product total information indicating the total amount of products corresponding to the price, quantity, etc. of the ordered item-Shipping information indicating the shipping cost of the ordered item-Commission information indicating the fee of the ordered item-The orderer or shipping destination of the ordered item Point usage information indicating the amount of points used ・ Point remaining information indicating the remaining points of the orderer or shipping destination for the ordered item ・ Adjustment information indicating the adjustment amount for the ordered item ・ Total amount of money indicating the total amount for the ordered item Information-Consumption tax information indicating the consumption tax on the ordered item-Billing amount information indicating the amount charged on the ordered item-Customer number information indicating the customer number of the orderer on the ordered item-NP transaction of the orderer on the ordered item NP transaction identification information indicating identification information • NP member store identification information indicating the orderer's NP member store identification information for the ordered item • Indicates whether the orderer related to the ordered item has a DM subscription M-subscription information ・ Member rank information indicating the order rank of the orderer related to the ordered goods ・ Grant point information indicating the assigned points of the orderer related to the ordered goods ・ Order count information indicating the number of orders of the orderer related to the ordered goods ・ Orders received Regular order count information indicating the number of regular orders of the orderer related to the goods ・ Periodical status information indicating the regular status of the orderer related to the ordered goods ・ Next scheduled shipping date information indicating the next scheduled shipping date of the orderer related to the ordered goods ・Next payment method information indicating the orderer's next payment method for the ordered item-Regular delivery interval information indicating the orderer's regular delivery interval for the ordered item-Next time indicating the orderer's next delivery date for the ordered item Delivery date information-Birthday information indicating the orderer's birthday related to the ordered item-Gender information indicating the orderer's gender related to the ordered item-Invoice notes related to the ordered item Ri-like remarks information

<Shipping result data 1008>
The shipping result data 1008 according to one embodiment includes any of the above-described various types of information that can identify the ordered article subjected to the picking and inspection processing, location information, and shipping result information indicating the corresponding shipping result.

<Picking instruction data 1009>
The picking instruction data 1009 according to one embodiment includes a picking list according to the picking instruction. Each line of the picking list according to one embodiment indicates any of various types of information that can identify the article to be picked, the quantity of the article, and any of various pieces of information that can identify a position corresponding to the article. .

  The picking instruction data 1009 according to one embodiment corresponds to a batch format indicating any one of the first format, the second format, the third format, the fourth format, and the fifth format. The picking instruction data 1009 may be regarded as a set of a plurality of picking instruction data 1009. For example, the picking instruction data 1009 may include picking instruction data 1009 corresponding to the first format and picking instruction data 1009 corresponding to the second format. At this time, the picking instruction data 1009 includes each combination of the picking instruction data 1009 in the first to fourth formats.

  The picking instruction data 1009 according to one embodiment may be identified by a combination of predetermined numbers. The combination is, for example, a combination of a character string indicating the batch number, the number of orders, the total number of batches, the total number of orders, and the batch format. The combination is, for example, a combination of a batch number, the number of orders in a batch, the total number of orders, whether postpay is required, and a character string indicating a batch format.

<Batch format (first format)>
The first type according to one embodiment indicates order picking of one or more items of two or more types of articles, respectively. The one or more types of articles in the description in this specification refer to one or more types of articles that do not overlap product name information, product identification number information, and product code information. Further, “order picking” in the description of the present specification refers to a method of individually picking up articles corresponding to each row of the picking list, performing inspection processing, and shipping.

<Batch format (second format)>
The second type according to the embodiment indicates total sowing of a seed sowing method according to one or more types of articles or a combination of one or more articles. “Total picking” in the description of the present specification refers to a method in which at least a part of articles included in a picking list is collectively picked, inspected, and shipped. Further, the “seed sowing method” in the description of the present specification refers to a method of performing inspection processing and shipping the collectively picked articles for each shipping destination or each row of the picking list. Note that the predetermined number is not limited.

<Batch format (third format)>
A third type according to one embodiment indicates a total picking of a picking method according to two or more kinds of articles or a combination of two or more kinds of articles. The two or more types of articles in the description in this specification refer to one or more types of articles in which product name information, product identification number information, and product code information do not overlap. In addition, the “plucking method” in the description in this specification refers to a method of picking an article in a picking list for each shipping destination or each row of the picking list, performing inspection processing, and shipping.

<Batch format (fourth format)>
A fourth type according to one embodiment indicates a total picking of a picking method for one or more types of predetermined articles. The “predetermined article in the fourth format” according to an embodiment may be, for example, a flyer or DM in which the category information indicates “bundled item”, or the product name information may indicate a flyer, DM, or the like. Goods may be used. Further, the “predetermined article in the fourth format” may be an article whose merchandise remark information indicates a flyer / flyer / DM or the like.

<Batch format (fifth format)>
A fifth method according to one embodiment indicates order picking of one type of predetermined article. The “predetermined article in the fifth format” according to one embodiment may be an article in which the product remark information or the shipping instruction remark information indicates a predetermined phrase such as “BtoB”, and the orderer information and the destination information are An article according to the shipping instruction data 1007 which is a predetermined orderer and destination may be used.

  The picking instruction data 1009 according to one embodiment is generated by being subdivided based on a batch filter included in the batch division rule information. “Batch filter” includes a first batch filter, a second batch filter, a third batch filter, a fourth batch filter, a fifth batch filter, a sixth batch filter, a seventh batch filter, a seventh batch filter, And at least one of the eighth batch filter.

  The first batch filter according to the embodiment indicates “there are warehouse notes”. Specifically, the first batch filter is a batch filter that sets ordered items, in which various information including the name “remarks information” is input, as candidates for the items related to the picking list of the new picking instruction data 1009. Refers to the filter. At this time, the various kinds of information are, for example, "I want a doll with a name" or "I want a special inspection at the time of shipment", and the content is not limited.

  The second batch filter according to one embodiment indicates "postpaid company". More specifically, the second batch filter sets the ordered goods into one or more new picking instruction data 1009 based on “postpay” indicated by the settlement method information on the ordered goods and the type of the corresponding payment service provider. , A batch filter that is a candidate for an article related to each picking list. At this time, information indicating the provider is defined in advance in the payment method master 1004.

  The third batch filter according to one embodiment indicates “post-paid paper type”. The third batch filter specifically, based on the “paper type” indicated by the paper information on the ordered product, sets the ordered product as a candidate for the product according to each picking list of one or more new picking instruction data 1009. Refers to a batch filter. At this time, the paper type indicates, for example, "normal delivery note and postpaid normal paper", "postpaid integrated paper", "normal delivery paper and postpaid integrated paper", and the like.

  The fourth batch filter according to one embodiment refers to a “delivery method”. More specifically, the fourth batch filter categorizes the ordered product into one or more new picking instruction data 1009 based on the “delivery method” indicated by the delivery method information related to the ordered product. Refers to a batch filter. At this time, the information indicating the “delivery method” is defined in advance in the delivery method master 1003.

  The fifth batch filter according to one embodiment refers to “location”. The fifth batch filter specifically relates to the picked list of one or more new picking instruction data 1009 based on the “location (storage destination)” indicated by the item location information of the ordered item. Refers to a batch filter that is a candidate for an article. At this time, the information indicating “location” indicates a location type such as “pick location” or “stock location”, and such information is defined in the location master 1005 in advance.

  The sixth batch filter according to one embodiment indicates “commodity score”. The sixth batch filter, specifically, based on the “quantity” indicated by the product specification information on the ordered item, determines the ordered item as a candidate for an item associated with each picking list of one or more new picking instruction data 1009. Refers to a batch filter. At this time, the sixth batch filter may be configured such that ordered items having a small “quantity” are aggregated into one picking list, or the picking list is sorted based on a descending / ascending order of “quantity”. It may be.

  The seventh batch filter according to one embodiment indicates “the number of SKUs”. Specifically, the seventh batch filter may be configured such that, based on the SKU number information relating to the ordered goods, for example, the ordered goods with a small “SKU number” are preferentially aggregated into one picking list, or “SKU”. The picking list may be sorted based on the descending / ascending order of “number”.

  An eighth batch filter according to one embodiment refers to “zip code”. Specifically, the eighth batch filter may be configured such that, for example, on the basis of the destination information relating to the ordered item, the ordered item having a smaller “zip code” is preferentially aggregated into one picking list, The picking list may be sorted based on the descending / ascending order of the “number”.

  As shown in FIG. 5, the picking instruction data 1009 includes information indicating a location, a product number, a category, a code for inspection processing, a product name, and the number of shipments.

<Design template 1010>
The design template 1010 according to one embodiment includes a first design template relating to a first printed matter including a delivery note and a second design template relating to a second printed matter including an invoice.

<Delivery note data 1011>
The delivery note data 1011 according to one embodiment includes delivery note information generated based on at least a part of the first design template and at least a part of the shipping instruction data 1007.

<Invoice data 1012>
The invoice data 1012 according to one embodiment includes invoice information generated based on at least a part of at least the second design template and the shipping instruction data 1007.

<Subroutine 1013>
The subroutine 1013 according to one embodiment is a subprogram including a first process 1013A, a second process 1013B, and a third process 1013C. Note that a “subroutine (subprogram)” in the description of the present specification refers to a module included in a main routine (main program).

The first process 1013A according to one embodiment includes one or more condition determination processes for determining a transition to the second process 1013B. The argument of the condition determination process according to one embodiment is any of various information on the database 0. Further, the condition determination processing according to one embodiment is associated with a group. Hereinafter, (group) / [argument] / [processing content] related to the condition determination processing will be exemplified.
・ (Compare value) / [Order number] / [All match] ・ (Compare value) / [Order number] / [Partial match] ・ (Compare value) / [Order number] / [Start with] Yes ・ (Compare values) / [Order number] / [Suffix] ・ (Compare values) / [Order number] / [Not]
• (compare values) / [order number] / [more than] • (compare values) / [order number] / [less] • (compare values) / [order number] / [greater than]
・ (Compare values) / [Order number] / [Smaller]
・ (Compare values) / [Order number] / [Exists]
・ (Compare values) / [Order number] / [Not present]
・ (Compare values) / [Order number] / [Included]
Note that, of course, a value is set separately from [argument] in [processing content].
・ (Check part number) / Part number of [Order number] in product master / [Registered]
・ (Check part number) / Part number of [Order number] in product master / [No registration]
・ (Check address) / Postal code of [Order number] / [Check if address name is correct]
・ (Check address) / Postal code of [Order number] / [Whether or not it is a remote island]
・ (Check address) / Postal code of [Order number] / [Whether or not cash on delivery]
・ (Check address) / Postal code of [Order number] / [Whether time cannot be specified]
・ (Check order number) / Order number of [Order number] / [Duplicate?]
・ (Check bundled order) / [Whether there is an order that can be bundled]
Of course, in [argument], another variable related to the designated variable on the database 0 can be handled.

The second process 1013B according to one embodiment includes one or more data shaping processes for converting first data, which is information on the database 0 such as the shipping instruction data 1007, into second data. At this time, the data shaping processing is at least one of combining, extracting, deleting, replacing, and full-width conversion of character strings, inputting a fixed value, calculating a date, and calculating a numerical value. The argument of the data shaping process according to one embodiment is any of various information on the database 0. Further, the data shaping process according to one embodiment is associated with a group. Hereinafter, (group) / [argument] / [processing content] related to the data shaping process will be exemplified. Note that the first data itself is treated as an argument in the second processing 1013B unless otherwise specified.
・ (Input fixed value) / [Input character string]
・ (Input fixed value) / [Input numerical value]
・ (Enter fixed value) / [Enter date]
At this time, there are no restrictions on the input location or insertion destination of the fixed value.
・ [Delete control characters] / [Article name] / [Delete control characters before and after]
・ (Concatenate character strings) / [Inquiry number] in [Article name] / [Add as delimiter]
・ (Extract a character string) / [Article name] / [Extract predetermined characters]
・ (Cut a character string) / [Article name] / [Delete a predetermined number of characters from a predetermined position]
・ [Replace character string] / [Article name] / [Replace target character with replacement character]
・ Decompose the contents of (decompose character string) / [article name] / [decompose with delimiters and extract from predetermined position]
・ (Convert character string to full width) / [Orderer name] / [Convert alphanumeric characters from half width to full width]
・ (Convert character string to full-width) / [Orderer name] / [Convert katakana from half-width to full-width]
・ (Calculation of numerical values) / (Adjusted amount) / (Addition, subtraction, multiplication, division, surplus)
-[Calculate the date] / [Delivery specified date] / [Add or subtract predetermined days]
・ (Format date) / [Delivery designation date] / [Convert to specified format]
・ (Extract difference) / [Second data] / and [Extract difference from predetermined character string]
Note that the number of arguments of the second process 1013B according to the embodiment may be plural.

The third processing 1013C according to one embodiment includes transmitting at least a part of the second data to an external service or terminal 1 / server 2 / handy terminal 3 / local server 4 and / or to database 0. This includes one or more data registration processes for storing data. The argument of the data registration process according to one embodiment is any of various information on the database 0, and the registration destination (storage destination) of the data is, for example, related to the article included in the first data or the second data. Information. Further, the data registration process according to the embodiment is associated with a group. Hereinafter, (group) / [argument] / [processing content] related to the data shaping process will be exemplified.
・ (Register data) / [Registered amount] / [Register in delivery note information]
・ Change the contents of (Status change) / [Shipping status] to any of [Hold (Payment confirmation), Hold (Insufficient address), Hold (Remarks column), Hold (Postpaid data), Shipment wait, etc.]
・ (Allocation processing) / [Perform allocation processing, do not perform]
・ (Bundled processing) / [Perform or not perform bundled processing]
・ (Change payment method) / [Change payment method information]
・ (Change delivery method) / [Change delivery method information]
・ (Change sender) / [Change sender]
・ (Addition of goods) / [Items indicated by [second data] / [Addition of predetermined number]
・ (Product deletion) / [Items indicated by [second data] / [Add all or predetermined number]
・ (Send mail) / Contents of [second data] / [Send to orderer's e-mail address, destination e-mail address or administrator's e-mail address]
・ (Error output) / Contents of [second data] / [Register as caution or important error]

With such a configuration, the present invention can convert order data such as shipping instruction data 1007 and order transaction data such as order data, which are not standardized in various EC sites, into an arbitrary format and standardize it. I can do it.
For example, according to the present invention, data cleansing can be performed on the data in which control characters forming a blank are inserted for each type of information such as an article name and an address.
Further, for example, according to the present invention, it is possible to suppress the influence of the fluctuation of the notation of the calendar including the year and the Japanese calendar on the information indicating the date.
In addition, for example, according to the present invention, it is possible to improve the efficiency of the subsequent allocation processing based on the data standardized by the second processing 1013B.

<< Terminal 1 >>
The terminal 1 according to one embodiment includes an input unit 11 for inputting and processing various information handled in the information processing system (handled on the database 0), and the various information and a graphical user interface (hereinafter, simply referred to as a GUI). ), A receiving unit 13 for receiving the various information, a registration unit 14 for requesting storage of the various information in the auxiliary storage unit / database 0, and a subroutine 1013. Setting means 15 capable of setting at least a part thereof.

<Setting means 15>
The setting unit 15 according to an embodiment preferably performs each of the first processing 1013A, the second processing 1013B, and the third processing 1013C included in the subroutine 1013 via a GUI displayed by the display unit 12. At least a part can be set.
In addition, the setting unit 15 according to one embodiment can select a group for each of the first processing 1013A, the second processing 1013B, and the third processing 1013C via the GUI, and the group can be selected. By doing so, the respective arguments and processing contents (functions) of the first processing 1013A, the second processing 1013B, and the third processing 1013C can be selected, and at least one of the subroutine 1013 is enabled, disabled, and copied. Alternatively, deletion or execution can be performed, and addition or deletion of each of the first processing 1013A, the second processing 1013B, and the third processing 1013C can be performed.
In addition, the setting unit 15 according to an embodiment can set, via a GUI, each piece of information relating to a generation rule of the picking instruction data 1009, taking the batch division rule information as an example.
In one embodiment, the server 2, the handy terminal 3, or the local server 4 may have a configuration having the function of the setting unit 15.

The above-described GUI may be displayed only by the display unit 12 or may be displayed in cooperation with the display unit 22 described later. Details including a screen configuration related to the GUI will be described later.
Similarly, the above-mentioned GUI may be displayed only by the display unit 32 or 42 described later, or may be displayed by the display unit 32 or 42 and the display unit 22 in cooperation.

<< Server 2 >>
The server 2 according to one embodiment includes an input unit 21 for input processing of various information handled in the information processing system (handled on the database 0), and a display unit for displaying and processing the various information and the GUI. 22, a receiving unit 23 for receiving the various information, a registration unit 24 for requesting storage of the various information in the auxiliary storage unit / database 0, and a change / deletion of the various information on the database 0. It has a management unit 25 that performs data management including the instruction, and an instruction generation unit 26 that can generate the picking instruction data 1009.

<Management means 25>
The management unit 25 according to one embodiment converts the first data into the second data based on the subroutine 1013. The first data is, for example, shipping instruction data 1007 received by the receiving unit 23 from an external service or the like.
In addition, the management unit 25 according to one embodiment performs allocation processing such as updating the stock quantity information in the database 0 based on the shipping instruction data 1007.
In addition, the management unit 25 according to an embodiment may update the shipping result data 1008 based on the shipping instruction data 1007 relating to the ordered article whose shipping status is “shipped”.

<Instruction generation means 26>
The instruction generation unit 26 according to one embodiment can generate one or more picking instruction data 1009 based on the shipping instruction data 1007 and the batch division rule information.

  The batch division rule information according to one embodiment includes the number of batch divisions according to each of the first to fifth formats, and the threshold of the number of shipments and / or the number of types of shipment corresponding to each of the first to fifth formats. Show. Note that batch division according to one embodiment may be performed based on suggestions such as “Noshito” / “message card” / “letter” indicated by the shipping instruction data 1007.

The instruction generation unit 26 according to an embodiment, for example, when the number of shipments of ordered goods indicated by the product code information and the number of shipments according to the shipping instruction data 1007 is 1 or the number of types of shipment is 1, Picking instruction data 1009 corresponding to the first format is generated.
In addition, the instruction generation unit 26 according to an embodiment, for example, when the number of shipment types of ordered articles indicated by the product code information related to the shipment instruction data 1007 is 1 and the number of shipments is equal to or more than a predetermined number, Is generated, and picking instruction data 1009 corresponding to the format is generated.
In addition, as an example, when the product code information and the destination information of the shipping instruction data 1007 indicate the number of shipping types <the number of destinations, the instruction generating unit 26 according to the embodiment may select the picking instruction corresponding to the third format. The data 1009 is generated.
In addition, the instruction generation unit 26 according to an embodiment, for example, when the category information or the product remark information or the like corresponding to the product code information related to the shipping instruction data 1007 indicates “bundled item”, “flyer”, or the like, The picking instruction data 1009 corresponding to the fourth format is generated.
In addition, the instruction generation unit 26 according to an embodiment may use, for example, the case where the category information or the product remark information corresponding to the product code information related to the shipping instruction data 1007 indicates “BtoB” or the like, or the shipping instruction data 1007. When each of the orderer information and the destination information indicates a predetermined name or the like, picking instruction data 1009 corresponding to the fifth format is generated.

  Note that the instruction generation unit 26 according to one embodiment may generate a plurality of picking instruction data 1009 based on the shipping instruction data 1007. Specifically, the picking instruction data 1009 corresponding to the third format may be generated in addition to the picking instruction data 1009 corresponding to the first format.

  Specifically, picking instruction data 1009 corresponding to the first format is generated based on the one shipping instruction data 1007, and the remaining ordered items in the one shipping instruction data 1007 correspond to the second format. The picking instruction data 1009 may be generated, and the picking instruction data 1009 corresponding to the third format may be generated for the remaining ordered articles in the one shipping instruction data 1007.

  The instruction generation unit 26 according to an embodiment may generate a plurality of picking instruction data 1009 by giving priority to the first, second, third, and fourth formats.

  The instruction generation unit 26 according to an embodiment may generate the picking instruction data 1009 based on the subroutine 1013. At this time, it goes without saying that the argument and the like included in the subroutine 1013 include any of various kinds of information constituting the shipping instruction data 1007 and the picking instruction data 1009. In addition, the instruction generation unit 26 according to an embodiment may be capable of transmitting the picking instruction data 1009 to the handy terminal 3.

《Handy Terminal 3》
The handy terminal 3 according to one embodiment includes an input unit 31 for input processing of various information handled in the information processing system (handled on the database 0) and a display unit for displaying the various information and the aforementioned GUI. The display unit 32, a receiving unit 33 for receiving the various information, a registration unit 34 for requesting the storage of the various information in the auxiliary storage unit / database 0, and an article included in the picking instruction data 1009. Inspection means 35 for performing inspection processing.

<Inspection means 35>
The inspection means 35 according to one embodiment can read the code attached to the ordered article indicated by the picking instruction data 1009. The code is a one-dimensional code or a two-dimensional code, and its format is not limited. At this time, the handy terminal 3 preferably has a reading device including an image sensor and the like in addition to the hardware configuration described above.
The inspection means 35 according to one embodiment can execute the inspection processing by reading the code. The inspection process refers to a process in which the product identification information indicated by the code is compared with the product identification information on the product master 1001, and the shipping status corresponding to the ordered product is changed to “shipping inspected”.

《Local server 4》
The local server 4 according to an embodiment includes an input unit 41 for input processing of various information handled in the information processing system (handled on the database 0), and an input unit 41 for displaying and processing the various information and the aforementioned GUI. A display unit 42, a receiving unit 43 for receiving the various information, a registration unit 44 for requesting storage of the various information in the auxiliary storage unit / database 0, and a delivery note of the ordered product based on the batch format. And a printing unit 45 capable of executing print processing of a first printed matter including the invoice and a second printed matter including the invoice for the ordered article.

<Printing means 45>
As illustrated in FIG. 3, when the batch format indicated by the picking instruction data 1009 regarding the ordered article indicates the first format, the printing unit 45 according to the embodiment inspects the print processing of the first and second prints. It is executed after the inspection processing by the means 35 is completed.
Further, when the batch format indicates the second or third format, the printing unit 45 according to an embodiment performs the printing process of the first printed material before the inspection process is completed, and prints the second printed material. The processing is executed after the inspection processing is completed.
Further, when the batch format indicates the fourth format, the printing unit 45 according to one embodiment does not execute the print processing of the first and second printed materials.
In addition, when the batch format indicates the fifth format, the printing unit 45 according to the embodiment executes the printing process of the first and second printed materials before the inspection process is completed.
The printing process of the delivery note by the printing unit 45 is of course based on the delivery note data 1011. Also, it goes without saying that the printing process for the invoice is based on the invoice data 1012 as well. It is needless to say that whether or not the inspection processing has been completed can be determined based on whether or not the shipping status indicates “shipping inspected”. Note that “the batch format indicates a predetermined format” means that the batch format corresponds to a combination including the predetermined format.

  It is preferable that the printing unit 45 according to one embodiment performs the third printed matter including the “gift” / “message card” / “letter” of the ordered article after the completion of the corresponding inspection processing.

  The printing unit 45 according to one embodiment may perform a printing process based on the subroutine 1013. At this time, the arguments included in the subroutine 1013 include various kinds of information constituting the shipping instruction data 1007, the picking instruction data 1009, the delivery note data 1011 and the invoice data 1012, and the processing content of the subroutine 1013 includes the printing process. Of course.

"flowchart"
As shown in FIG. 5, an example of the flowchart according to the present invention can be understood as follows.
<Setting Step S1> The setting means 15 sets the subroutine 1013.
<Reception Step S2> The reception means 23 receives the shipping instruction data 1007.
<Conversion step S3> The management means 25 converts the shipping instruction data 1007 as the first data into the shipping instruction data 1007 as the second data based on the subroutine 1013.
<Allocation Step S4> The management means 25 performs an allocation process based on the shipping instruction data 1007.
<Instruction generation step S5> The instruction generation means 26 generates picking instruction data 1009 based on the shipping instruction data 1007, and transmits it to the handy terminal 3.
<Display step S6> The display means 32 displays the picking instruction data 1009.
<Inspection Step and Printing Step S7> The inspection means 35 and the printing means 45 execute the inspection processing and the printing processing based on the picking instruction data 1009, respectively.
<Step S8> The management unit 25 updates the shipping result data 1008 after the shipping status of the ordered article indicated by the picking instruction data 1009 becomes “shipped”.

《Graphical user interface》
As shown in FIGS. 6 to 8, the setting of the subroutine 1013 according to one embodiment is executed via a GUI. At this time, each display object related to the setting screen as a GUI according to one embodiment is not limited in its size, coloration, and the like, and can adopt various appearances.
In one embodiment, each of the setting screens is preferably subjected to an overlay display process.

  As shown in FIG. 6, the setting screen W1 shows a list of one or more subroutines 1013 (meaning RPA rules in the figure). Each subroutine 1013 shows the subroutine name (meaning the name of the RPA rule in the figure), its description, and its use state. The use state indicates valid or invalid, and the operation of the display object W101 and the check box can be switched as a turning point. The display object W102 functions as an intention input unit for setting details of each subroutine 1013. The display object W103 functions as an intention input unit for adding a new subroutine 1013.

As shown in FIG. 7, the display processing is performed using the intention input via the designation of the display object W102 or W103 as a turning point. The setting screen W2 includes the name / description of the subroutine 1013, the processing settings of the first processing 1013A, the second processing 1013B, and the third processing 1013C, and the format of the first data and / or the second data. And so on for input / output settings. The input / output setting is performed, for example, to set only the shipping instruction data 1007 in a predetermined format as the first data.
The display object W201 functions as an intention input unit for performing the process setting. The display object W202 functions as an intention input unit for deleting the first processing 1013A, the second processing 1013B, and the third processing 1013C. The display object W203 functions as an intention input unit for adding new first processing 1013A, second processing 1013B, and third processing 1013C.

As shown in FIG. 8, the setting screen W3 that is displayed using the intention input through the designation of the display object W201 or W203 as a turning point is a first processing 1013A, a second processing 1013B, and a third processing 1013C, respectively. (Group) / [argument] / [processing content].
The display object W301 functions as an input unit for specifying a group of the first process 1013A. The display object W302 functions as an input unit for specifying an argument of the first process 1013A. The display objects W303 and W304 function as an input unit for specifying the processing content of the first processing 1013A.
The display object W305 functions as an input unit for specifying a group of the second processing 1013B. The display objects W306, W307, and the like function as an input unit for specifying the processing content of the second processing 1013B. Note that a display object that functions as an input unit for designating an argument according to the second processing 1013B is, of course, appropriately displayed on the setting screen W3.
The display object W308 functions as an input unit for specifying a group of the third processing 1013C. The display object W309 functions as an input unit for specifying the processing content of the third processing 1013C. In addition, it goes without saying that a display object that functions as an input unit for specifying an argument related to the third processing 1013C can be appropriately displayed on the setting screen W3.
Each of the display objects W311, W312, and W313 functions as an intention input unit for adding each of the new first processing 1013A, second processing 1013B, and third processing 1013C. It is needless to say that a display object for deleting each of the first processing 1013A, the second processing 1013B, and the third processing 1013C can be appropriately displayed on the setting screen W3.

  As shown in FIGS. 9 and 10, the setting of the batch format and the batch division rule information according to the embodiment is executed via a GUI. At this time, each display object related to the setting screen as a GUI according to one embodiment is not limited in its size, coloration, and the like, and can adopt various appearances. In one embodiment, each of the setting screens is subjected to an overlay display process.

  As shown in FIG. 9, the setting screen W4 is used to set batch division rule information. The display object W401 functions as an intention input unit for performing one of validation, invalidation, and deletion for one or more batch division rule information specified via a check box. The display object W402 functions as an intention input unit for setting details of the corresponding batch division rule information. The display object W403 functions as an intention input unit for newly creating / adding batch division rule information. The setting screen W4 may be configured to show a creator, a change history, and the like related to each batch division rule information.

  As shown in FIG. 10, the setting screen W5 that is displayed when the designation of the display object W402 is a turning point is used to set details of the batch division rule information. The display object W501 functions as a form for inputting character string data such as “name” and “description” for identifying batch division rule information. The display object W502 is a combination of batch formats, a delimited number of shipments according to a predetermined batch format, necessity of application according to each of the first to fifth formats, and a shipment number when the second batch format is applied. Functions as a form for inputting settings such as (threshold). The display object W503 functions as a form for specifying the type of delivery note. The display object W504 functions as a form for designating whether or not to generate a picking list including ordered articles corresponding to the fifth format. The display object W505 functions as a form for specifying whether to activate the first batch filter. The display object W506 functions as a form for specifying whether or not to use post-paid bundling. The display object W507 functions as a form for specifying a batch filter.

  In the embodiment, the processing content for the purpose of improving the business of the warehouse physical distribution has been described as an example, but there is no particular limitation on the business type / field to which the present invention can be applied.

0 Database 1 Terminal 2 Server 3 Handy terminal 4 Local server 11, 21, 31, 41 Input means 12, 22, 32, 42 Display means 13, 23, 33, 43 Receiving means 14, 24, 34, 44 Registration means 25 Management Means 26 Instruction generation means 35 Inspection means 45 Printing means 1007 Shipping instruction data 1009 Picking instruction data W1, W2, W3 Setting screen

Claims (6)

An information processing system,
Instruction generating means capable of generating picking instruction data corresponding to a batch format indicating a picking target article, the position of the article and the quantity of the article,
Inspection means capable of reading a code attached to the article indicated by the picking instruction data and executing an inspection process for the article;
A first printed matter including a delivery note pertaining to the article based on the batch format, and a printing unit capable of executing a print processing of a second printed matter including an invoice pertaining to the article prior to the inspection processing; Have
The batch format is a first format indicating order picking for one point of each of one or more of the articles, a second format indicating total picking of a sowing method for a predetermined number or more of one of the items, A third format indicating the total picking of the picking method according to two or more types of the articles, a fourth format indicating the total picking of the picking type according to one or more predetermined products, and one predetermined type The information processing system according to any one of the fifth forms, which shows the order picking of the article. When the batch format indicates the first format, the printing unit does not execute the printing process relating to the first and second printed materials prior to the inspection process, and after the inspection process is completed. The information processing system according to claim 1. When the batch format indicates the second or third format, the printing unit does not execute the printing process related to the second printed matter prior to the inspection process, and after the inspection process is completed. The information processing system according to claim 1 or 2, which executes. 4. The information processing system according to claim 1, wherein when the batch format indicates the fourth format, the printing unit does not execute the printing process on the first and second printed materials. 5. An information processing method,
An instruction generation step capable of generating picking instruction data corresponding to a batch format indicating the article to be picked, the position of the article and the quantity of the article, and
An inspection step of reading a code attached to the article indicated by the picking instruction data and executing an inspection process for the article;
A first printed matter including a delivery note pertaining to the article based on the batch format, and a printing step capable of executing a print processing of a second printed matter including an invoice pertaining to the article prior to the inspection processing; Let the computer run
The batch format is a first format indicating order picking for one point of each of one or more of the articles, a second format indicating total picking of a sowing method for a predetermined number or more of one of the items, A third format indicating the total picking of the picking method according to two or more types of the articles, a fourth format indicating the total picking of the picking type according to one or more predetermined products, and one predetermined type The information processing method according to any one of the fifth forms, which shows the order picking of the article. An information processing program,
Computer
Instruction generating means capable of generating picking instruction data corresponding to a batch format indicating a picking target article, the position of the article and the quantity of the article,
Inspection means capable of reading a code attached to the article indicated by the picking instruction data and executing an inspection process for the article;
A first printed matter including a delivery note pertaining to the article based on the batch format, and a printing unit capable of executing a print processing of a second printed matter including an invoice pertaining to the article prior to the inspection processing; Let it work,
The batch format is a first format indicating order picking for one point of each of one or more of the articles, a second format indicating total picking of a sowing method for a predetermined number or more of one of the items, A third format indicating the total picking of the picking method according to two or more types of the articles, a fourth format indicating the total picking of the picking type according to one or more predetermined products, and one predetermined type The information processing program according to any one of the fifth formats, which shows the order picking of the article.