JP7488940B2 - WAREHOUSE ACQUISITION DEVICE, WAREHOUSE ACQUISITION METHOD, AND WAREHOUSE ACQUISITION PROGRAM - Google Patents

Description

The present invention relates to a warehouse acquisition device, a warehouse acquisition method, and a warehouse acquisition program.

Patent Document 1 relates to a shipping management system and a shipping management program, and in particular discloses a shipping management system that ships multiple products stored in multiple warehouses based on order information sent from an ordering terminal, and a program related to the system (see paragraph 0001 of Patent Document 1, etc.).

JP 2004-250165 A

In this way, in the field of managing the shipment and delivery of goods, it is important to ship goods from a warehouse as close as possible to the delivery destination in order to keep transportation costs as low as possible. However, this alone is not enough, and there are many cases where it is necessary to decide which warehouse to use for shipping, taking into account the type of goods.

For example, if the goods being delivered are pharmaceutical products and the warehouses closest to the delivery destination are the company's own warehouse A, which has a pharmacist, and a contractor's warehouse B, which does not have a pharmacist, it is appropriate to determine the company's own warehouse A as the shipping warehouse.

However, in order to make such a decision on which warehouse to ship from, taking into account both the delivery destination's location and the type of product, the person in charge needs to be highly skilled, and even for an experienced person, making such a decision requires a lot of time and effort.

The present invention has been made in consideration of the above problems, and aims to provide a warehouse acquisition device, a warehouse acquisition method, and a warehouse acquisition program that can acquire a warehouse by taking into account both the delivery destination location and the type of product.

In order to solve the above-mentioned problems and achieve the object, the warehouse acquisition device according to the present invention is a warehouse acquisition device including a control unit and a storage unit, and the storage unit stores a delivery destination master including delivery destination identification data for identifying a delivery destination of a product and location identification data for identifying the delivery destination, which are linked to each other, a product master including product identification data for identifying the product and a warehouse category that is a category that indicates the characteristics or role of a warehouse, which is linked to each other, and a location master including location identification data, which includes a plurality of warehouse identification data for identifying the warehouse by linking the location identification data, and the control unit includes a location acquisition means for acquiring location identification data linked to the specified delivery destination identification data from the delivery destination master, a warehouse category acquisition means for acquiring a warehouse category linked to the specified product identification data from the product master, and a warehouse acquisition means for acquiring warehouse identification data for the warehouse having the characteristics or role indicated by the warehouse category acquired by the warehouse category acquisition means from the location master, among the plurality of warehouse identification data linked to the location identification data acquired by the location acquisition means, from the location master.

In order to solve the above-mentioned problems and achieve the objective, the warehouse acquisition device of the present invention is characterized in that the warehouse classification is a company warehouse classification, which is a classification meaning that the warehouse is the company's own warehouse, or a contractor warehouse classification, which is a classification meaning that the warehouse is a contractor's warehouse.

In order to solve the above-mentioned problems and achieve the objective, the warehouse acquisition device of the present invention is characterized in that the location master includes a plurality of defective product warehouse identification data linked to the location identification data, which is warehouse identification data for identifying a defective product warehouse that is a warehouse that holds defective products among the products, and when it is specified that the products are to be returned from a customer, the warehouse acquisition means acquires from the location master, from the plurality of defective product warehouse identification data linked to the location identification data acquired by the location acquisition means, the defective product warehouse identification data for the defective product warehouse that stores the products that were to be stored in the warehouse having the characteristics or role indicated by the warehouse classification acquired by the warehouse classification acquisition means, but are defective.

The warehouse acquisition method according to the present invention is a warehouse acquisition method executed by an information processing device having a control unit and a storage unit, and the storage unit stores a delivery destination master including delivery destination identification data for identifying a delivery destination of a product and location identification data for identifying the delivery destination, which are linked together; a product master including product identification data for identifying the product and a warehouse category, which is a category indicating the characteristics or role of a warehouse, which are linked together; and a location master including location identification data, which includes a plurality of warehouse identification data for identifying the warehouse by linking them with the location identification data. The method includes a location acquisition step executed by the control unit, which acquires location identification data linked to the specified delivery destination identification data from the delivery destination master; a warehouse category acquisition step, which acquires a warehouse category linked to the specified product identification data from the product master; and a warehouse acquisition step, which acquires warehouse identification data for the warehouse having the characteristics or role indicated by the warehouse category acquired in the warehouse category acquisition step, from the location master, among the plurality of warehouse identification data linked to the location identification data acquired in the location acquisition step.

The warehouse acquisition program according to the present invention is a warehouse acquisition program to be executed by an information processing device having a control unit and a storage unit, and the storage unit stores a delivery destination master including delivery destination identification data for identifying a delivery destination of a product and location identification data for identifying the delivery destination, which are linked together; a product master including product identification data for identifying the product and a warehouse category, which is a category indicating the characteristics or role of a warehouse, which are linked together; and a location master including location identification data, which includes a plurality of warehouse identification data for identifying the warehouse by linking them with the location identification data. The warehouse acquisition program includes a location acquisition step for acquiring location identification data linked to the specified delivery destination identification data from the delivery destination master, a warehouse category acquisition step for acquiring a warehouse category linked to the specified product identification data from the product master, and a warehouse acquisition step for acquiring warehouse identification data for the warehouse having the characteristics or role indicated by the warehouse category acquired in the warehouse category acquisition step from the location master, which are to be executed by the control unit.

The present invention has the advantage of being able to acquire a warehouse by taking into account both the delivery destination's location and the type of product.

FIG. 1 is a block diagram showing an example of the configuration of a warehouse acquisition device. FIG. 2 is a diagram showing an example of items in the delivery destination master, the product master, and the location master. FIG. 3 is a diagram showing an example of a screen for inputting information required to acquire a warehouse. FIG. 4 is a diagram showing an example of specific data in the delivery destination master, the product master, and the location master. FIG. 5 is a diagram showing an example of the relationships between pharmaceutical companies, pharmaceutical wholesalers, medical institutions, and the like.

Below, an embodiment of a warehouse acquisition device, a warehouse acquisition method, and a warehouse acquisition program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the present embodiment.

[1. Overview]
Conventionally, because the shipping warehouse was determined on a business site basis, there was a problem that the operator would unknowingly suggest a warehouse far from the delivery destination, resulting in unnecessary transportation costs. In addition, there was also a problem that the operator would make an input error when changing to an appropriate warehouse. Therefore, in this embodiment, for example, the following is made possible. First, it is possible to determine the shipping warehouse from the delivery destination location and the type of product, and automatically suggest an appropriate shipping warehouse. In addition, it is possible to improve the efficiency of slip registration and prevent input errors by selecting an appropriate shipping warehouse without the input operator's judgment. And it is possible to suggest a warehouse that does not require transportation costs, regardless of the industry, to a company that manages multiple warehouses. Furthermore, it is possible to classify products by inventory warehouse classification (specifically, it is possible to classify products that require management by pharmacists in the medical industry, and products that require refrigeration and freezing management in the food industry, and to suggest warehouses by classifying them).

In other words, simply put, this embodiment responds to the demand to determine the delivery destination location and product type, ship from the appropriate warehouse, and eliminate the need to determine the warehouse, by managing the delivery destination location and the inventory warehouse for each product type at each location in master data, making it possible to automatically suggest a shipping warehouse. The specific configuration and operation are described below.

2. Configuration
An example of the configuration of the warehouse acquisition device 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of the warehouse acquisition device 100.

The warehouse acquisition device 100 is a commercially available desktop personal computer. Note that the warehouse acquisition device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

The warehouse acquisition device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit included in the warehouse acquisition device 100 is connected to each other so as to be able to communicate with each other via any communication path.

The communication interface unit 104 communicatively connects the warehouse acquisition device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the warehouse acquisition device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data such as various masters described below may be stored in the server 200, for example.

An input device 112 and an output device 114 are connected to the input/output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that works with a mouse to provide a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like.

The memory unit 106 includes, for example, a delivery destination master 106a, a product master 106b, and a location master 106c.

As shown in Figures 2 and 4, the delivery destination master 106a includes, for example, delivery destination identification data (delivery destination CD and delivery destination name) for identifying the delivery destination of the product, and location identification data (location CD) for identifying the location of the delivery destination, etc.

As shown in Figures 2 and 4, the product master 106b includes, for example, product identification data (product CD and product name) for identifying the product, and a warehouse classification (inventory warehouse classification) that is a classification indicating the characteristics or role of the warehouse, etc., which are linked together.

As shown in FIG. 4, the warehouse classification is, for example, a company warehouse classification ("0: company-managed products" and "2: center-managed products") which indicates that the warehouse is a company warehouse, or a contractor warehouse classification ("1: contractor-managed products") which indicates that the warehouse is a contractor warehouse. In the example of the product master 106b in FIG. 4, the inventory warehouse classification is set to "0: company-managed products" for company product A, which is a pharmaceutical product, because it needs to be shipped from a company warehouse where a pharmacist is present. In contrast, the inventory warehouse classification is set to "1: contractor-managed products" and "2: center-managed products" for contractor product B and center product C, which are not pharmaceutical products, because there is no problem with shipping from a contractor warehouse and center warehouse where a pharmacist is not present. In this way, by setting different inventory warehouse classifications according to the type of product, it is possible to automatically obtain an appropriate warehouse taking into account not only the delivery destination location but also the type of product, as will be described in detail in [3. Example of processing] below.

The inventory warehouse category may be any category that can be set according to the type of product, and is not limited to the categories that indicate where the warehouse is managed as described in the previous paragraph ("0: in-house managed products", "1: subcontractor managed products", and "2: center managed products"). For example, if the product is a pharmaceutical product, the inventory warehouse category may be a category that indicates whether or not there is a pharmacist in the warehouse, and if the product is a food product, it may be a category that indicates the storage function of the warehouse. The category that indicates whether or not there is a pharmacist is, for example, a category such as "pharmacist present" or "pharmacist absent". The category that indicates the storage function is, for example, a category such as "refrigerated category" or "frozen category".

As shown in Figures 2 and 4, the location master 106c includes, for example, the location identification data (location CD and address), and also includes multiple warehouse identification data (warehouse CD) for identifying the warehouse in association with the location identification data.

There are two types of warehouse identification data (warehouse CD): normal product warehouse identification data, which is the warehouse identification data for identifying a normal product warehouse that is a warehouse that holds normal products among the products, and defective product warehouse identification data, which is the warehouse identification data for identifying a defective product warehouse that is a warehouse that holds defective products among the products. In the example of the location master 106c in FIG. 4, the company's own warehouse CD, the outsourced warehouse CD, and the center warehouse CD correspond to the normal product warehouse identification data, while the company's own defective product warehouse CD, the outsourced defective product warehouse CD, and the center defective product warehouse CD correspond to the defective product warehouse identification data. The warehouse identified by the company's own defective product warehouse CD is a warehouse that stores defective products that were supposed to be stored in the warehouse identified by the company's own warehouse CD, the warehouse identified by the outsourced defective product warehouse CD is a warehouse that stores defective products that were supposed to be stored in the warehouse identified by the outsourced warehouse CD, and the warehouse identified by the center defective product warehouse CD is a warehouse that stores defective products that were supposed to be stored in the warehouse identified by the center warehouse CD.

The detailed process will be explained in [3. Specific example of process] below, but when entering a product, the warehouse can be obtained from the location master 106c and proposed taking into consideration the inventory warehouse classification in the product master 106b. That is, when the inventory warehouse classification in the product master 106b = "0: in-house managed product", the in-house warehouse CD in the location master 106c is obtained, when the inventory warehouse classification in the product master 106b = "1: outsourced managed product", the outsourced warehouse CD in the location master 106c is obtained, and when the inventory warehouse classification in the product master 106b = "2: center managed product", the center warehouse CD in the location master 106c is obtained. When a product is returned, the respective defective product warehouse CD is obtained.

The control unit 102 is a CPU or the like that performs overall control of the warehouse acquisition device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs.

The control unit 102, in terms of its functional concept, includes, for example, (1) a location acquisition unit 102a as a location acquisition means that acquires, from the delivery destination master, location identification data linked to the specified delivery destination identification data, (2) a warehouse classification acquisition unit 102b as a warehouse classification acquisition means that acquires, from the product master, a warehouse classification linked to the specified product identification data, and (3) a warehouse acquisition unit 102c as a warehouse acquisition means that acquires, from the location master, warehouse identification data for the warehouse having the characteristics or role indicated by the warehouse classification acquired by the warehouse classification acquisition means, from among multiple warehouse identification data linked to the location identification data acquired by the location acquisition means.

3. Specific examples of processing
In this section, a specific example of the process according to this embodiment will be described. In this section, in the case where three parties, such as a pharmaceutical company, a pharmaceutical wholesaler, and a medical institution, appear as shown in Fig. 5, first, the acquisition of a warehouse in the case where a product (pharmaceutical product) is shipped from the pharmaceutical wholesaler to the medical institution (arrow X in Fig. 5) will be described in detail, and then, the acquisition of a warehouse in the case where a product (pharmaceutical product) is returned from the medical institution to the pharmaceutical wholesaler (arrow Y in Fig. 5) will be briefly described. Also, as shown in Fig. 5, the warehouse acquisition device 100 according to the present invention is used, for example, by a pharmaceutical wholesaler.

(Prerequisites)
In addition, as a prerequisite for starting the processing in this item, on the screen for entering the information required to obtain a warehouse (see Figure 3), it is assumed that "warehouse order" is specified in advance as the document category, "001 (Tokyo Sales Office)" is specified as the business location CD, "2017/11/01" is specified as the order date, "J0001 (XX Co., Ltd.)" is specified as the customer CD, "N0001 (△△ Hospital)" is specified as the delivery destination CD as shown in MA1, and "00001 (our own product A)" is specified as the product CD as shown in MA2.

[3-1. Location acquisition process]
The location acquisition unit 102a acquires a location CD associated with a specified delivery destination CD from a delivery destination master 106a that includes delivery destination CDs and locations CDs.

Specifically, as shown in FIG. 4, the location acquisition unit 102a acquires "010010001" as the location CD associated with the delivery destination CD "N0001" specified in (preconditions).

[3-2. Warehouse classification acquisition process]
The warehouse category acquisition unit 102b acquires the inventory warehouse category associated with the specified product CD from the product master 106b that includes the product CD and the inventory warehouse category.

Specifically, as shown in FIG. 4, the warehouse category acquisition unit 102b acquires "0: In-house managed products" as the inventory warehouse category associated with the product CD "00001" specified in (Preconditions).

[3-3. Warehouse Acquisition Processing]
In this section, the warehouse acquisition process will be explained in detail, dividing it into cases of leaving (=shipping) from a normal product warehouse and entering (=returning) into a defective product warehouse.

(1) When issuing (=shipping) from a normal product warehouse, the warehouse acquisition unit 102c acquires, from the location master 106c which includes a location CD and which includes multiple warehouse CDs linked to the location CD, a warehouse CD for a warehouse which has the characteristics or role indicated by the inventory warehouse classification acquired by the warehouse classification acquisition unit 102b, from among the multiple warehouse CDs linked to the location CD acquired by the location acquisition unit 102a.

Specifically, the warehouse CDs linked to the location CD "010010001" acquired by the location acquisition unit 102a are six warehouse CDs, namely, the company warehouse CD "A10S", the contractor warehouse CD "B10S", the center warehouse CD "C10S", the company defective product warehouse CD "A10F", the contractor defective product warehouse CD "B10F" and the center defective product warehouse CD "C10F", as shown by the dotted lines in the location master 106c in FIG. 4. Of the six warehouse CDs, the warehouse CDs corresponding to the slip category "warehouse order" specified in (preconditions) are the company warehouse CD "A10S", the contractor warehouse CD "B10S" and the center warehouse CD "C10S". Furthermore, of the three warehouse CDs, the warehouse that has the characteristics or role indicated by the warehouse category "0: in-house managed products" acquired by the warehouse category acquisition unit 102b is the warehouse identified by the company warehouse CD "A10S". From the above, the warehouse acquisition unit 102c acquires the company's own warehouse CD "A10S" as the shipping warehouse when a product is shipped from the pharmaceutical wholesaler to a medical institution (△△ Hospital) (arrow X in Figure 5). The acquired company's own warehouse CD "A10S" is set in the MA3 section of the screen (see Figure 3).

As described above in section (1), the warehouse acquisition device 100 according to this embodiment can select from three warehouses, namely the company's own warehouse, which is closest to the delivery destination, the contractor's warehouse, and the center warehouse, as the shipping warehouse, taking into consideration that the product is a "pharmaceutical product," and that the company's own warehouse is the only one of the three warehouses that has a pharmacist.

(2) When the product is stored in a defective product warehouse (=returned), when a customer specifies that the product is to be returned, the warehouse acquisition unit 102c acquires, from the location master 106c which includes a location CD and which includes a plurality of warehouse CDs linked to the location CD, a defective product warehouse CD for a defective product warehouse which stores defective products that were to be stored in a warehouse having the characteristics or role indicated by the inventory warehouse classification acquired by the warehouse classification acquisition unit 102b, among the plurality of defective product warehouse CDs linked to the location CD acquired by the location acquisition unit 102a.

Specifically, let us change the premise in (Prerequisites) and assume that "returned order" is specified as the slip category. Of the six warehouses CDs shown in FIG. 4 surrounded by dotted lines, the warehouses CD corresponding to the specified slip category "returned order" are the three defective product warehouses CD, namely, the in-house defective product warehouse CD "A10F", the outsourced defective product warehouse CD "B10F", and the center defective product warehouse CD "C10F". Of the three defective product warehouses CD, the defective product warehouse that stores defective products that were supposed to be stored in the "in-house warehouse", which is a warehouse having the characteristics or role indicated by the warehouse category "0: in-house managed products" acquired by the warehouse category acquisition unit 102b, is the warehouse identified by the in-house defective product warehouse CD "A10F". From the above, the warehouse acquisition unit 102c acquires the in-house defective product warehouse CD "A10F" as the receiving warehouse when products (pharmaceutical products) are returned from medical institutions, etc. to pharmaceutical wholesalers (arrow Y in FIG. 5).

As described above in section (2), according to the warehouse acquisition device 100 of this embodiment, by setting up a defective product warehouse CD in addition to a normal product warehouse CD in the location master 106c, when a product is returned from a customer, the product is stored in the defective product warehouse instead of the normal product warehouse, so that the returned defective product is not subject to allocation during other shipping processes.

[4. Summary of the present embodiment]
In this way, the warehouse acquisition device 100 according to the present embodiment can acquire a warehouse taking into consideration both the delivery destination location and the type of product. Therefore, even a new employee who is not yet familiar with the work of shipping can accurately and easily grasp a warehouse taking into consideration both the delivery destination location and the type of product.

5. Other embodiments
The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using a known method.

In addition, the processing procedures, control procedures, specific names, registered data for each process, information including search conditions and other parameters, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

Furthermore, with regard to the warehouse acquisition device 100, each component shown in the figure is a functional concept, and does not necessarily have to be physically configured as shown in the figure.

For example, the processing functions of the warehouse acquisition device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium that contains programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the warehouse acquisition device 100 as needed. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) to work with the OS to give instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

This computer program may also be stored in an application program server connected to the warehouse acquisition device 100 via any network, and all or part of it may be downloaded as needed.

In addition, the program for executing the processing described in this embodiment may be stored on a non-transitory computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to a memory card, a USB (Universal Serial Bus) memory, a SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile This includes any "portable physical media" such as a DVD (registered trademark) or Blu-ray (registered trademark) Disc.

A "program" is a data processing method written in any language or description method, and may be in any format, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration consisting of multiple modules or libraries, and a program that works in conjunction with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

The various databases stored in the memory unit are storage devices such as RAM, ROM, etc., fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

The warehouse acquisition device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The warehouse acquisition device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively.

The present invention is useful, for example, in industries where inventory management is carried out using multiple warehouses.

100 Warehouse acquisition device 102 Control unit
102a Location Acquisition Department
102b Warehouse classification acquisition section
102c Warehouse acquisition unit 104 Communication interface unit 106 Storage unit
106a Delivery destination master
106b Product master
106c Location master 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (4)

A warehouse acquisition device including a control unit and a storage unit,
The storage unit includes:
A delivery destination master including delivery destination identification data for identifying a delivery destination of a product and location identification data for identifying the location of the delivery destination in association with each other;
A product master including product identification data for identifying the product and a warehouse classification which is a classification indicating a characteristic or role of a warehouse, in association with each other;
a location master including a plurality of normal product warehouse identification data for identifying a warehouse that holds normal products among the products and a plurality of defective product warehouse identification data for identifying a warehouse that holds defective products among the products, the location master being linked to the location identification data and the warehouse classification;
is stored,
The control unit is
A location acquisition means for acquiring location identification data associated with the delivery destination identification data designated on a screen for inputting information required to acquire a warehouse from the delivery destination master;
A warehouse classification acquisition means for acquiring a warehouse classification associated with the product identification data specified on the screen from the product master;
a warehouse acquisition means for acquiring, from the location master, location identification data acquired by the location acquisition means and normal product warehouse identification data linked to the warehouse category acquired by the warehouse category acquisition means, when it is specified on the screen that the product is to be shipped to a customer, and, on the other hand, for acquiring, from the location master, location identification data acquired by the location acquisition means and defective product warehouse identification data linked to the warehouse category acquired by the warehouse category acquisition means , when it is specified on the screen that the product is to be returned by a customer;
To have
A warehouse acquisition device comprising: The warehouse classification is a company warehouse classification which means that the warehouse is the company's own warehouse, or a contractor warehouse classification which means that the warehouse is a contractor's warehouse;
The warehouse acquisition device according to claim 1 . A warehouse acquisition method executed by an information processing device having a control unit and a storage unit,
The storage unit includes:
A delivery destination master including delivery destination identification data for identifying a delivery destination of a product and location identification data for identifying the location of the delivery destination in association with each other;
A product master including product identification data for identifying the product and a warehouse classification which is a classification indicating a characteristic or role of a warehouse, in association with each other;
a location master including a plurality of normal product warehouse identification data for identifying a warehouse that holds normal products among the products and a plurality of defective product warehouse identification data for identifying a warehouse that holds defective products among the products, the location master being linked to the location identification data and the warehouse classification;
is stored,
Executed by the control unit,
A location acquisition step of acquiring location identification data associated with the delivery destination identification data specified on a screen for inputting information required to acquire a warehouse from the delivery destination master;
A warehouse classification acquisition step of acquiring a warehouse classification associated with the product identification data specified on the screen from the product master;
a warehouse acquisition step of acquiring, from the location master, location identification data acquired in the location acquisition step and normal-product warehouse identification data linked to the warehouse category acquired in the warehouse category acquisition step, when it is specified on the screen that the product is to be shipped to a customer, and, on the other hand, acquiring, from the location master, location identification data acquired in the location acquisition step and defective-product warehouse identification data linked to the warehouse category acquired in the warehouse category acquisition step, when it is specified on the screen that the product is to be returned by the customer;
containing,
A warehouse acquisition method characterized by: A warehouse acquisition program to be executed by an information processing device having a control unit and a storage unit,
The storage unit includes:
A delivery destination master including delivery destination identification data for identifying a delivery destination of a product and location identification data for identifying the location of the delivery destination in association with each other;
A product master including product identification data for identifying the product and a warehouse classification which is a classification indicating a characteristic or role of a warehouse, in association with each other;
a location master including a plurality of normal product warehouse identification data for identifying a warehouse that holds normal products among the products and a plurality of defective product warehouse identification data for identifying a warehouse that holds defective products among the products, the location master being linked to the location identification data and the warehouse classification;
is stored,
To cause the control unit to execute
a location acquisition step of acquiring location identification data associated with the delivery destination identification data specified on a screen for inputting information required to acquire a warehouse from the delivery destination master;
A warehouse classification acquisition step of acquiring a warehouse classification associated with the product identification data specified on the screen from the product master;
a warehouse acquisition step of acquiring, from the location master, location identification data acquired in the location acquisition step and normal-product warehouse identification data linked to the warehouse category acquired in the warehouse category acquisition step, when it is specified on the screen that the product is to be shipped to a customer, and, on the other hand, acquiring, from the location master, location identification data acquired in the location acquisition step and defective-product warehouse identification data linked to the warehouse category acquired in the warehouse category acquisition step, when it is specified on the screen that the product is to be returned by the customer;
containing,
A warehouse acquisition program featuring.

Images