JP2002321826A - Device and method for managing product transportation - Google Patents

Abstract

PROBLEM TO BE SOLVED: To appropriately manage products committed to a transportation organization and transportation thereof. SOLUTION: Information of a transportation state and the like provided from the transportation organization and information on products to be transported are linked for making a database, desired retrieve conditions are inputted from computers placed at respective production bases, the transportation organization, and a sales base for retrieval (step S116) and for display of a list of results thereof (step S122). As a result, the products and products transportation can be appropriately managed, a sales plan can be made based on the retrieving result more appropriately, and inventory control can be performed more appropriately. If any problems occur in the products, a possible cause of the problem can be investigated from a history of production, transportation and the like.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a product transport management apparatus and a product transport management method, and more particularly, to a product transport management apparatus and a method for managing a product produced at a production base and transport of the product. .

[0002]

2. Description of the Related Art Conventionally, as this kind of transportation management device,
Proposals have been proposed for the transport to manage its own transport. In this device, for example, when the transport body is a ship, the date (On Boa) when the transported object is loaded on the ship
rd Date), the bill of lading number, the voyage position of the ship, the expected date of arrival, and the like, and these data are output as required.

[0003]

However, in such a transport management apparatus, it is often difficult for a receiving side (for example, a shipper) that receives the transport target to manage the transport target. For example, when the recipient of the goods to be transported prepares a sales plan for the product to be transported, it is necessary to know with certainty when to accept the product in order to make the sales plan more accurate. The vehicle must be queried for the expected arrival date of the goods to calculate the time. The expected arrival date is often changed due to a sudden change in the transportation environment (for example, weather), but the changed expected arrival date is often not notified unless the receiving party makes an inquiry. This makes it impossible to create an appropriate sales plan. Further, the product cannot be managed sufficiently.

[0004] It is an object of a product transport management apparatus and a product transport management method of the present invention to properly manage a product entrusted to a transportation agency. Another object of the present invention is to provide a product transport management device and a product transport management method that output a transport management status of a product in transit as necessary, thereby contributing to product sales planning and inventory management. One of

[0005]

Means for Solving the Problems and Their Functions / Effects The product transportation management device and the product transportation management method of the present invention employ the following means to at least partially achieve the above-mentioned object.

A product transport management device according to the present invention is a product transport management device for managing a product produced at a production site and the transport of the product, wherein product information on the product produced at the production site and the product information are provided. Receiving means for receiving shipping information relating to the shipment of the product and receiving transport information relating to the transport provided by a transporting means which transports the product shipped from the production site by a transporter, and the received product information, shipping information and transport Information storage means for generating the product transport management information based on the information and storing the product transport management information; and searching for the product transport management information stored in the information storage means based on the input predetermined condition. The gist of the present invention is to include a search unit and a result output unit that outputs a search result by the search unit.

In the product transport management apparatus of the present invention, the product transport management information is generated, stored, and input from the transport information on the transport of the product received and received from the transport organization, the product information, and the shipping information. Search the product transportation management information based on the specified conditions and output the result,
It can search and output appropriate information necessary for sales planning and inventory management. As a result, it is possible to more appropriately manage the products that are being transported and the transportation of the products.

[0008] In such a product transport management device of the present invention, the transport information may be information including a current position or an arrival schedule of the transporter. Further, in the product transport management device of the present invention, the transport information may be information including a transit point of the transporter. In this aspect of the product transport management device of the present invention, the transport information may be information including a scheduled arrival at a transit point of the transporter. In this way, by including the current position and the arrival schedule of the transporter, the transit point of the transporter and the arrival schedule thereof in the transport information, it is possible to more appropriately manage the transport of the product and the product.

Further, in the product transport management device of the present invention, the information receiving means is means for receiving a product name and a product number as a part of the product information, and the search means is one of the predetermined conditions. It may be a means for searching based on the product name or product number. In this case, since the search can be performed by the product name or the product number, the management can be performed for each product.

Further, in the product transport management device of the present invention, the information receiving means is a means for receiving a transporter name, a transport number, a transport unit, and a transport start date as a part of the shipping information, and the search means is As one of the predetermined conditions, the search means may be a means for searching based on any of a transporter name, a transport number, a transport unit, and a transport start date. In this way, the search can be performed based on the transporter, transport number, transport unit, transport start date, and the like. Note that the transport number includes a bill of lading number or the like when the transporter is a ship. In this aspect of the product transport management device of the present invention, the transport unit may be a unit for loading the transporter such as a container or a pallet.

In the product transport management device of the present invention, the transporter may be any one of a ship, an aircraft, and a vehicle.

[0012] In the product transport management device of the present invention, the product transport management device includes a search request receiving unit that receives a search request including the predetermined condition via a network, wherein the search unit receives the search request. At this time, it is a means for performing a search based on a predetermined condition included in the search request, and the result output means is a means for outputting a search result to a side that made the search request via a network. You can also. In this case, a search request can be made using a communication device such as a computer connected via a network, and the search result can be received.

In the product transport management device of the present invention, the information receiving means may be a means for receiving the product information, the shipping information, and the transport information via a network. In the product transport management device according to the aspect of the present invention, the information receiving unit may be a unit that receives product information and shipping information input by a production base terminal installed at the production base. Alternatively, it may be a means for receiving transportation information input by a transportation terminal installed in the transportation. In this case, it is possible to receive the product information and the shipping information input by the production base terminal installed at the production base, and to receive the transportation information input by the transportation terminal installed at the transportation facility.

[0014] The program for a product transport management device of the present invention includes a computer for storing the product transport management device of the present invention in any one of the above-described embodiments, that is, basically, a product produced at a production base and the product. A product transport management device that manages the transport of the product and receives the product information on the product produced at the production site and the shipping information on the shipment of the product, and transports the product shipped from the production site with a transporter. Information receiving means for receiving transport information related to transport provided by a transportation means, and information for generating product transport management information based on the received product information, shipping information, and transport information and storing the product transport management information. Storage means, search means for searching for the product transport management information stored in the information storage means based on the input predetermined condition, And result output means for outputting a search result that is summarized in that to function as a product transport control device comprising a.

According to the program for a product transport management device of the present invention, a computer is caused to function as the product transport management device of the present invention in any one of the above-described embodiments. For example, it is possible to obtain an effect of searching and outputting appropriate information necessary for a sales plan, inventory management, and the like, and an effect of more appropriately managing products being transported and transportation of the products.

The product transport management method of the present invention is a product transport management method for managing a product produced at a production site and the transport of the product, wherein (a) product information relating to the product produced at the production site. And shipping information on shipping of the product, and shipping information on shipping provided by a transportation means for transporting the product shipped from the production site by a transporter, and (b) the received product information and shipping information (C) receiving a search request, and (d) searching for the stored product transport management information based on the received search request, and (e) searching for the stored product transport management information based on the received search request. The gist is to output the result of the search.

According to the product transportation management method of the present invention,
Generates and stores product transport management information from the transport information, product information, and its shipping information relating to the transport of products received and received from the transportation agency, searches for product transport management information based on the search request, and returns the result. , It is possible to retrieve and output appropriate information necessary for sales planning, inventory management, and the like. As a result, it is possible to more appropriately manage the products that are being transported and the transportation of the products.

In the product transport management method according to the present invention, the step (a) includes, as a part of the transport information, a current position of the transporter, an arrival schedule, a transit point of the transporter and an arrival schedule of the transit point. May be a step of receiving any of the following. In this way, by including the current position and the arrival schedule of the transporter, the transit point of the transporter and the arrival schedule thereof in the transport information, it is possible to more appropriately manage the transport of the product and the product.

Further, in the product transportation management method of the present invention, the step (c) is a step of receiving the search request via a network, and the step (e) is a step of receiving the search request via the network. May be a step of outputting a result. In this case, a search request is made using a communication device such as a computer connected via a network,
You can receive search results.

Further, in the product transport management method of the present invention, the step (a) may be a step of receiving the product information, the shipping information and the transport information via a network. This way,
It is possible to receive product information and shipping information input by a production base terminal installed at a production base, and to receive transportation information input by a transportation terminal installed at a transportation facility.

[0021] The program for the product transport management method of the present invention stores the product transport management method of the present invention in any one of the above-described embodiments, that is, basically, a product produced at a production base and the product. (A) receiving product information on a product produced at the production site and shipping information on the shipment of the product, and transporting the product shipped from the production site. (B) generating and storing product transport management information based on the received product information, shipping information, and transport information; and (c) searching. Receiving the request, (d) searching the stored product transport management information based on the received search request, and (e) outputting the searched result. Steps and summarized in that to execute the respective steps.

According to the program for the product transport management method of the present invention, the computer executes each step in the product transport management method of the present invention in any one of the above aspects as each procedure. The effect of the method, for example, the effect of searching for and outputting appropriate information necessary for sales planning and inventory management, and the effect of better managing the transportation of products and products in transit, Can play.

[0023]

Next, embodiments of the present invention will be described with reference to examples. FIG. 1 is a configuration diagram schematically showing a configuration of a product transportation management system according to one embodiment of the present invention. As shown in the figure, the product transport management system according to the embodiment includes a computer for product transport management installed at a product transport management center or the like, and a terminal installed at each production site such as a production site 1 or a production site 2. Computer and
A computer as a terminal installed in each transportation means such as the transportation means 1 and the transportation means 2, and a sales base 1 and a sales base 2
The network is configured by computers installed at each sales base, warehouse, and the like. Hereinafter, in the embodiment, a case where a product produced at a production base is transported by a ship will be described as an example.

In the product transport management system of the embodiment, a process of preparing various data and a process of searching for the prepared data are performed. The core of the present invention lies in the prepared data search process. Before describing the search process, a brief description will be given of the prerequisite data adjustment process.

The adjustment processing of various data is performed by executing a product transportation management information processing routine illustrated in FIG. 2 by a computer for product management. This routine is executed every time a staff member of the product transportation management center performs a predetermined operation, for example, inputs a command for product transportation management, or every time a predetermined time elapses, or from a computer at a production base or a computer at a transportation agency, and from the computer at the transportation facility. It is executed every time when the output of the transportation information is detected. When the product transportation management information processing routine is executed, the computer for product transportation management firstly enters a process of inputting the product shipping information input from the computer at each production site and the transportation information input from the computer of each transportation organization. (Step S
100). As shown in Table 1 below, for example, the product shipping information input from the computer at each production site includes the production site name, shipping number, shipping date, product name, serial number, product quantity, and invoice number. The shipping information includes shipping destination, container number, pallet number, transportation means, ship name, flight number, bill of lading number, origin, scheduled departure date, origin departure actual date, destination, and onboard. The scheduled date, the actual onboard date, etc. Further, as the transportation information input from each transportation means, for example, as shown in Table 2, the transportation means, ship name, flight number,
Bill of Lading number, departure point, scheduled departure date, departure departure date, destination, expected destination arrival date, destination arrival actual date, final destination, final destination expected arrival date, final destination arrival result The date, the scheduled onboard date, the actual onboard date, the current position, and the like.

[0026]

[Table 1]

[Table 2]

When the product information, shipping information, and transport information are input in this way, product transport management information is prepared from the input information (step S102). This preparation is, in particular,
This is a process for integrating and organizing data by using transportation means, ship name, flight number, bill of lading number, etc. as keys.
In the case of the data in Table 2 or Table 2, data exemplified in Table 3 below is prepared as the product transport management information.

[0028]

[Table 3]

Then, the prepared product transport management information is stored as a database in a storage medium such as a hard disk (step S104), and this routine ends.

Next, a search process of the prepared data will be described with reference to an example in which the search process is performed using the computer at the sales base 1 as a terminal. FIG. 3 is a flowchart illustrating an example of a search processing routine executed by the computer at the sales base 1 and the computer for managing product transportation. The process on the left side of the broken line in the figure is executed by the computer of the sales base 1, and the process on the right side of the broken line is executed by the computer for product transportation management. In the search processing routine, first, the processing starts by inputting a search start command from the computer at the sales base 1 (step S11).
0). When this search start command is input, the computer at the sales base 1 outputs a search permission signal to the product transport management computer via the network. In response to this signal, the product transport management computer outputs a search permission signal to the computer at the sales base 1 via the network (step S112).

Upon inputting the search permission signal, the computer at the sales base 1 displays a search dialog on the monitor (step S114) and waits for input of search conditions. FIG. 4 shows an example of the search dialog. In the search dialog of this example, items are selected and input using a pull-down menu in five item columns arranged vertically on the left side, and a keyword as a search condition is entered in the input columns arranged vertically on the right side thereof. Each input item is searched as an AND condition. When the search condition is input and the search button is pressed (step S116), the input search condition and search command are output to the product transport management computer via the network.

Upon input of the search condition and the search command, the product transport management computer extracts data matching the search condition from the product transport management information stored in a database in a storage device such as a hard disk (step S118). ), And outputs the result to the computer at the sales base 1 (step S120). The search results are displayed in a list on the monitor of the computer at the sales base 1 (step S122). An example of a list of search results is shown in Table 4 below.

[0033]

[Table 4]

Next, it is determined whether the search has been completed based on the operation of the computer at the sales base 1 (step S124). That is, when the operator performs an operation for performing a new search, the process returns to the search dialog display process in step S114, and when the operator performs an operation for ending the search, the present routine ends.

According to the product transport management system of the embodiment described above, the product transport management information is generated from the transport information, product information, and its shipping information provided and input from the transportation agency, and is generated as a database and stored. It is possible to search for product transport management information that matches the conditions based on the search conditions input via the network, and display a list of the results. As a result, it is possible to retrieve and output appropriate information necessary for sales planning, inventory management, and the like. Further, when a problem occurs in a product, the cause of the problem can be used for investigation of production, transportation, and the like.

In the product transport management system of the embodiment, the search is performed from the computer of the sales base 1, but the computer of the other sales base, the computer for product transport management, the computer of each production base, and the computer of each transport organization are used. It is good also as what searches from. When searching from computers at other Idai bases, production bases, and transportation facilities,
The processing is the same as the processing of the embodiment, and when searching from a computer for product transportation management, the processing may be performed by a single computer without input / output via a network.

In the product transport management system of the embodiment, the product information and the shipping information are input from a computer as a terminal installed at each production site such as the production site 1 and the production site 2. Data on paper provided by facsimile or the like may be input from a computer for product transport management installed at the product transport management center. Also, in the product transport management system of the embodiment, the transport information is input from a computer as a terminal installed in each transport such as the transport 1 and the transport 2, but provided by each transport by facsimile or the like. The data on the paper may be input from a product transport management computer installed at the product transport management center. Furthermore, in the product transport management system of the embodiment, the computer as a terminal installed at each sales base such as the sales base 1 and the sales base 2 is connected to the computer for product transport management via a network.
Computers may not be installed at each sales base. In consideration of such modified examples, a product transport management system can be established with only a computer for product transport management as a minimum configuration.

In the product transport management system of the embodiment, a ship is used as a transport body, and the products transported by the ship and the transport of the products are managed. However, the transport body is not limited to the ship, but may be a car or a train. May be used.

In the embodiment, an embodiment of the present invention has been described as a product transport management system. However, a computer may function as a product transport management system according to the embodiment and its modifications. In this case, each process of the above-described product transport management system may be described in an appropriate program language for each step.

The embodiments of the present invention have been described with reference to the embodiments. However, the present invention is not limited to these embodiments, and various embodiments may be made without departing from the gist of the present invention. Of course, it can be carried out.

[Brief description of the drawings]

FIG. 1 is a configuration diagram schematically showing a configuration of a product transportation management system according to an embodiment of the present invention.

FIG. 2 is a flowchart illustrating an example of a product transport management information processing routine executed by a product transport management computer included in the product transport management system according to the embodiment;

FIG. 3 is a flowchart illustrating an example of a search processing routine executed by a computer at a sales base 1 and a computer for managing product transportation.

FIG. 4 is an explanatory diagram illustrating an example of a search dialog displayed on a monitor of a computer at a sales base 1.

Claims (18)

[Claims] 1. A product transportation management device for managing a product produced at a production base and transportation of the product, comprising: product information on a product produced at the production base and shipping information on shipping of the product. An information receiving means for receiving and receiving transport information related to transport provided by a transporter transporting the product shipped from the production site by a transporter, and transporting the product based on the received product information, shipping information, and transport information. Information storage means for generating management information and storing the product transport management information; search means for searching for the product transport management information stored in the information storage means based on the input predetermined condition; And a result output means for outputting a search result by the product transport management device. 2. The product transport management device according to claim 1, wherein the transport information is information including a current position or an arrival schedule of the transporter. 3. The product transport management device according to claim 1, wherein the transport information is information including a transit point of the transporter. 4. The product transport management device according to claim 3, wherein the transport information is information including a scheduled arrival at a transit point of the transporter. 5. The product transport management device according to claim 1, wherein the information receiving unit is a unit that receives a product name and a product number as a part of the product information. The means is a product transport management device which is a means for searching based on a product name or a product number as one of the predetermined conditions. 6. The product transport management device according to claim 1, wherein the information receiving unit includes a transporter name, a transport number, a transport unit, and a transport start date as a part of the shipping information. The product transport management device, wherein the search unit is a unit that performs a search based on one of the predetermined condition, a transporter name, a transport number, a transport unit, and a transport start date. 7. The product transport management device according to claim 6, wherein the transport unit is a unit for loading the transport body such as a container and a pallet. 8. The product transport management device according to claim 1, wherein the transporter is one of a ship, an aircraft, and a vehicle. 9. The product transport management device according to claim 1, further comprising: a search request receiving unit that receives a search request including the predetermined condition via a network, wherein the search unit includes: When the search request receiving means receives the search request, the search request is a means for performing a search based on a predetermined condition included in the search request. A product transportation management device that outputs the results. 10. The product transport management device according to claim 1, wherein the information receiving unit is a unit that receives the product information, the shipping information, and the transport information via a network. 11. The product transport management device according to claim 10, wherein said information receiving means is means for receiving product information and shipping information input from a production base terminal installed at said production base. 12. The product transport management device according to claim 10, wherein the information receiving unit is a unit that receives transport information input by a transport terminal installed in the transport. 13. The computer according to claim 1, wherein
A program that functions as the product transport management device according to any of the above. 14. A product transportation management method for managing products produced at a production site and transportation of the products, wherein (a) product information on the products produced at the production site and shipping related to the shipment of the products. Accepting information and accepting transport information related to transport provided by a transporting agency transporting the product shipped from the production site with a transporter,
(B) generating and storing product transport management information based on the received product information, shipping information, and transport information; (c) receiving a search request; and (d) storing the information based on the received search request. (E) a product transport management method for retrieving the retrieved product transport management information and outputting the retrieved result. 15. The step (a) is a step of accepting, as a part of the transportation information, any one of a current position, an arrival schedule, a transit point of the transport body, and an arrival schedule of the transit point. The product transportation management method according to claim 14. 16. The product transportation management method according to claim 14, wherein the step (c) is a step of receiving the search request via a network, and the step (e) is via a network. Outputting the result to the side that made the search request. 17. The product transport management method according to claim 14, wherein the step (a) is a step of receiving the product information, the shipping information, and the transport information via a network. 18. The computer according to claim 14, wherein
7. A program for executing each step in the product transportation management method according to any one of the above 7 as each procedure.