JP7499385B2 - Order planning data creation device, order planning data creation method, and order planning data creation program - Google Patents

Description

The present invention relates to an order schedule data creation device, an order schedule data creation method, and an order schedule data creation program.

Patent document 1 discloses an estimate support device, information processing device, and estimate support method that can help improve the accuracy of estimates for building construction costs while minimizing the burden on builders (see paragraph 0010 of patent document 1).

JP 2014-211710 A

In the field of quotation management, there are cases where an order is placed after a request for quotation is made to a supplier (order items that require a request for quotation), and cases where an agreement is concluded with a supplier through a basic contract and an order is placed directly without going through a quotation (order items that do not require a request for quotation).

Here, conventionally, a purchasing department or other staff member would manually determine whether or not a quotation request was required for each item of order (e.g., a screw) in the order schedule data, which resulted in poor work efficiency and the possibility of incorrect judgment.

The present invention has been made in consideration of the above problems, and aims to provide an order schedule data creation device, an order schedule data creation method, and an order schedule data creation program that can create order schedule data that includes, for each order item, the status of whether or not a quotation request is required.

In order to solve the above-mentioned problems and achieve the object, the order schedule data creation device of the present invention is an order schedule data creation device having a control unit and a memory unit, the memory unit stores order request data including order target identification data for identifying the order target, which is the object of an order, agreement target identification data for identifying the agreement target, which is an object with which an agreement has been concluded that an order may be placed without a request for quotation, agreement partner identification data for identifying the agreement partner, which is the supplier with which the agreement has been concluded, and an agreement unit price, which is the purchase unit price of the agreement target, the control unit determines whether or not the agreement target identification data that is the same as the order target identification data in the order request data exists in the agreement target setting master, and if it exists, The system is characterized by comprising an acquisition means for acquiring, from the agreement target setting master, agreement partner identification data and agreement unit price linked to the same agreement target identification data, and a creation means for creating, if present, a record including the agreement partner identification data and agreement unit price acquired by the acquisition means, the order target identification data in the order request data, and an agreement product status which is a status indicating that the order target identified by the order target identification data is the subject of the agreement, and, if not present, creating a record including the order target identification data in the order request data and a quotation request status which is a status indicating that the order target identified by the order target identification data is the subject of the quotation request, and creating order schedule data including the created record.

The order schedule data creation device according to the present invention is further characterized in that the control unit extracts the record including the quotation request status from the order schedule data, and displays the extracted record on the display unit as the subject of the quotation request.

The order schedule data creation device according to the present invention is further characterized in that the control unit further comprises an extraction means for extracting the record including the request for quotation status when a quotation response is received from a supplier in response to the request for quotation, an update means for updating the record extracted by the extraction means with the purchase price and supplier identification data included in the quotation response and updating the request for quotation status in the record extracted by the extraction means to a quotation response completed status which is a status indicating that the quotation response has been received, and a registration means for extracting the record including the quotation response completed status from the order schedule data and registering the combination of the order target identification data, purchase price, and supplier identification data in the extracted record in the agreement target setting master.

The order schedule data creation device according to the present invention is further characterized in that the control unit extracts the record including the agreed product status or the quotation response completed status from the order schedule data, and further includes a confirmation means for confirming an order based on the extracted record.

The ordering schedule data creation device according to the present invention is also characterized in that the ordering target identification data or the agreement target identification data is defined by a combination of part identification data for identifying parts required for the manufacture of large machinery and design drawing identification data for identifying design drawings for the parts.

The ordering schedule data creation device according to the present invention is also characterized in that the parts are mass-produced parts that are repeatedly ordered.

The method for creating order schedule data according to the present invention is a method for creating order schedule data executed by an information processing device having a control unit and a storage unit, in which the storage unit stores order request data including order target identification data for identifying an order target that is the object of an order, agreement target identification data for identifying an agreement target that is an object with which an agreement has been concluded that an order may be placed without making a quotation request, agreement partner identification data for identifying an agreement partner that is a supplier with which the agreement has been concluded, and an agreement unit price that is the purchase unit price of the agreement target, and the control unit executes a process for determining whether or not the agreement target setting master contains the same agreement target identification data as the order target identification data in the order request data, and if the agreement target identification data exists, the control unit executes a process for determining whether or not the agreement target setting master contains the same agreement target identification data as the order target identification data in the order request data, and, ... The method includes an acquisition step of acquiring, from the target setting master, agreement partner identification data and an agreement unit price linked to the same agreement target identification data; and, if present, creating a record including the agreement partner identification data and the agreement unit price acquired in the acquisition step, the order target identification data in the order request data, and an agreement product status which is a status indicating that the order target identified by the order target identification data is the target of the agreement; if not present, creating a record including the order target identification data in the order request data and a quotation request status which is a status indicating that the order target identified by the order target identification data is the subject of the quotation request, and creating order schedule data including the created record.

The order schedule data creation program according to the present invention is an order schedule data creation program to be executed by an information processing device having a control unit and a storage unit, and the storage unit stores order request data including order target identification data for identifying the order target, which is the object to be ordered, agreement target identification data for identifying the agreement target, which is the object with which an agreement has been concluded that an order may be placed without a quotation request, agreement partner identification data for identifying the agreement partner, which is the supplier with which the agreement has been concluded, and an agreement unit price, which is the purchase unit price of the agreement target. The program is executed by the control unit, and determines whether the agreement target setting master contains the same agreement target identification data as the order target identification data in the order request data, and if so, In this case, the method includes an acquisition step of acquiring from the agreement target setting master the agreement partner identification data and the agreement unit price linked to the same agreement target identification data, and, if the data exists, creating a record including the agreement partner identification data and the agreement unit price acquired in the acquisition step, the order target identification data in the order request data, and an agreement product status which is a status indicating that the order target identified by the order target identification data is the subject of the agreement, and, if the data does not exist, creating a record including the order target identification data in the order request data and a quotation request status which is a status indicating that the order target identified by the order target identification data is the subject of the quotation request, and creating order schedule data including the created record.

The present invention has the advantage of being able to create order schedule data that includes the status of whether a quotation request is required or not for each order item.

FIG. 1 is a block diagram showing an example of the configuration of an order schedule data creation device. FIG. 2 is a diagram illustrating an example of a business flow. FIG. 3 is a diagram showing an example of the order request data, the agreement product transaction master, and the order schedule data. FIG. 4 is a diagram showing an example of the agreement product transaction master in which a new agreement product is registered.

Below, an embodiment of an order schedule data creation device, an order schedule data creation method, and an order schedule data creation 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]
In manufacturers that handle large machinery and equipment, the design department creates a parts list each time, and the manufacturing department (production management department) places an order for the parts and materials required for production. The purchasing department then requests quotations from the supplier (manufacturer) based on the order request, and officially places an order after determining the price, but there are also parts that are ordered directly without going through a quotation by signing a basic contract.

Conventionally, the purchasing department would make the estimate and decide whether or not to place an order, and then process the order, which created problems in terms of business efficiency.

In this embodiment, for example, the availability of estimates and orders is automatically determined, thereby improving work efficiency and preventing errors, and thereby realizing appropriate order management. Note that in this embodiment, "drawing number" refers to the design drawing number, and since the supplier may differ for each design drawing number even when ordering the same material, a system is provided that allows the agreement unit price to be registered for each drawing number.

In other words, in this embodiment, in order to meet the demand for appropriate and efficient quotation and order management of purchased parts, for example, it is possible to perform status management of the order consideration situation (before quotation is requested and when a quotation has been responded to), thereby preventing erroneous input of quotation responses and erroneous orders, and further, it is possible to determine whether or not a contract exists through the contracted product transaction information, and automatically allocate whether or not a quotation can be made. The specific configuration and operation are explained below.

2. Configuration
An example of the configuration of an order schedule data creation 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 order schedule data creation device 100.

The order schedule data creation device 100 is a commercially available desktop personal computer. Note that the order schedule data creation 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 order schedule data creation device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input/output interface unit 108. Each unit included in the order schedule data creation 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 order schedule data creation 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 the communication line. Here, the network 300 has a function of connecting the order schedule data creation 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, order request data 106a, an agreement product transaction master 106b as an agreement target setting master, and order schedule data 106c.

As shown in FIG. 3, the order request data 106a includes, for example, order target identification data for identifying the order target, which is the subject of the order, the required date, the required quantity, and the like. The order target identification data may be any data that can identify the order target, but as shown in FIG. 3, for example, it is defined by a combination of part identification data (item name) for identifying parts required for the manufacture of large machinery and design drawing identification data (drawing number) for identifying the design drawing for the part. The part is, for example, a mass-produced part (screws, etc.) that is repeatedly ordered.

The agreement product transaction master 106b is a master for setting information on the agreement target, which is a target for which an agreement has been concluded that allows orders to be placed without a quotation request. As shown in FIG. 3, the agreement product transaction master 106b includes, for example, agreement target identification data for identifying the agreement target, agreement partner identification data (supplier) for identifying the agreement partner, which is the supplier with which the agreement has been concluded, and the agreement unit price, which is the purchase price of the agreement target. The agreement target identification data may be any data that can identify the agreement target, but as shown in FIG. 3, for example, it is defined by a combination of the part identification data (item name) and the blueprint identification data (drawing number).

As shown in FIG. 3, the order schedule data 106c includes, for example, the order target identification data (drawing number and item name), desired delivery date, required quantity, unit price, supplier identification data, and status. As the unit price, the agreed unit price in the agreed product transaction master 106b or the purchase unit price included in the quotation response from the supplier is stored. As the supplier identification data, the agreement partner identification data in the agreed product transaction master 106b or the supplier identification data included in the quotation response is stored. The status is an agreed product status (status of "agreement product" in FIG. 3) which is a status indicating that the order target identified by the order target identification data is the subject of the agreement, a quotation request status (status of "quotation request" in FIG. 3) which is a status indicating that the order target identified by the order target identification data is the subject of the quotation request, or a quotation response completed status (status of "quotation response completed" in FIG. 3) which is a status indicating that the quotation response has been received.

The control unit 102 is a CPU or the like that provides overall control of the order schedule data creation 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 operations based on these stored programs.

The control unit 102 has, in terms of its functional concept, for example, (1) an acquisition unit 102a as an acquisition means for determining whether or not the agreement target identification data that is the same as the order target identification data in the order request data exists in the agreement target setting master, and, if the data exists, acquiring the agreement partner identification data and the agreement unit price linked to the same agreement target identification data from the agreement target setting master, and (2) if the data exists, a record including the agreement partner identification data and the agreement unit price acquired by the acquisition means, the order target identification data in the order request data, and the agreement product status, which is a status indicating that the order target identified by the order target identification data is the subject of the agreement. a creating unit 102b as creating means for creating a record including the order target identification data in the order request data and, if the record does not exist, a quotation request status which is a status indicating that the order target identified by the order target identification data is the subject of the quotation request, and creating order schedule data including the created record; (3) a display unit 102c as display means for extracting the record including the quotation request status from the order schedule data and displaying the extracted record on a display unit as the subject of the quotation request; (4) an extraction unit 102d as extraction means for extracting the record including the quotation request status when a quotation response is received from a supplier in response to the quotation request; and (5) a display unit 102e as display means for displaying the record extracted by the extraction unit. The system includes an update unit 102e as an updating means for updating the purchase price and supplier identification data included in the quotation response and updating the quotation request status in the record extracted by the extraction means to a quotation response completed status, which is a status indicating that the quotation response has been received; (6) a registration unit 102f as a registration means for extracting the record including the quotation response completed status from the order schedule data and registering the combination of the order target identification data, purchase price, and supplier identification data in the extracted record in the agreement target setting master; and (7) a confirmation unit 102g as a confirmation means for extracting the record including the agreement product status or the quotation response completed status from the order schedule data and confirming the order based on the extracted record.

The acquisition unit 102a determines whether or not the same agreement object identification data (drawing number and item name) as the order object identification data (drawing number and item name) in the order request data 106a exists in the agreement item transaction master 106b, which includes the agreement object identification data (drawing number and item name), the agreement partner identification data (supplier), and the agreement unit price. If the same agreement object identification data (drawing number and item name) exists, the acquisition unit 102a acquires the agreement partner identification data (supplier) and the agreement unit price linked to the same agreement object identification data (drawing number and item name) from the agreement item transaction master 106b.

If the data exists, the creation unit 102b creates a record including the agreement partner identification data (supplier) and the agreed unit price acquired by the acquisition unit 102a, the order target identification data (drawing number and item name) in the order request data 106a, and the status of "agreement item". On the other hand, if the data does not exist, the creation unit 102b creates a record including the order target identification data (drawing number and item name) in the order request data 106a and the status of "quote request". The creation unit 102b then creates order schedule data 106c including the created record.

The display unit 102c extracts the records containing the status "request for quotation" from the order schedule data 106c, and displays the extracted records on the display unit as the subject of the request for quotation.

When a quotation response is received from a supplier in response to the quotation request, the extraction unit 102d extracts the record that includes the status "quotation request."

The update unit 102e updates the purchase price and supplier identification data (supplier) included in the quotation response in the record extracted by the extraction unit 102d, and updates the status of "quotation request" in the record extracted by the extraction unit 102d to the status of "quotation response completed."

The registration unit 102f extracts records containing the status "quote completed" from the order schedule data 106c, and registers the combination of order target identification data (drawing number and item name), purchase price, and supplier identification data (supplier) in the extracted records in the agreed product transaction master 106b.

The confirmation unit 102g extracts records containing the status of "agreed item" or "quote completed" from the order schedule data 106c, and confirms the order based on the extracted records.

3. Specific examples of processing
In this section, a specific example of the processing according to the present embodiment will be described. In this section, assuming a situation in which the order schedule data creation device 100 according to the present embodiment is used in a manufacturer that manufactures large machinery and equipment, the processing in the design department, the processing in the production management department, and the processing in the purchasing department will be described according to the flow in FIG. 2 and with reference to the specific example in FIG. 3.

[3-1. Processing in the Design Department]
First, in the design department, a parts list is prepared, which lists the parts required for manufacturing the large-scale machine, as shown in FIG.

[3-2. Processing in the Production Management Department]
Next, in the production management department, as shown in Fig. 2, order request data 106a is created based on the parts list created in the design department. Then, based on the created order request data 106a and a preset agreed product transaction master 106b (both see Fig. 3), order schedule data 106c is created as follows.

(1) Acquisition of Supplier and Agreed Unit Price Referring to the agreed product transaction master 106b in Fig. 3, there exists a combination that is the same as the combination of drawing number "Z001-1" and product name "Part A" in the order request data 106a in Fig. 3. In this case, the acquisition unit 102a acquires the supplier "Company A" and the agreed unit price "¥100" that are linked to the same combination from the agreed product transaction master 106b in Fig. 3, as shown by the bold frame.

In contrast, when referring to the agreed-upon product transaction master 106b in FIG. 3, there is no combination that is the same as the combination of drawing number "Z003-1" and product name "Part A" in the order request data 106a in FIG. 3. In this case, the supplier and the agreed-upon unit price are not obtained.

(2) Creation of Planned Order Data Next, if the item is found to "exist" in (1), the creation unit 102b creates a record A including the supplier "Company A" and the agreed-upon unit price "100 yen" acquired by the acquisition unit 102a, the drawing number "Z001-1" and the item name "Part A" (based on the drawing number "Z001-1" and the item name "Part A" in the order request data 106a), the desired delivery date of October 31st (based on the required date "October 31st" in the order request data 106a), the required quantity of 10 (based on the required quantity "10" in the order request data 106a), and the status "agreed item", as shown in record A of planned order data 106c (before quotation response) in FIG. 3.

On the other hand, if the item is "not available" in (1), the creation unit 102b creates record B including the drawing number "Z003-1" and the item name "Part A" (based on the drawing number "Z003-1" and the item name "Part A" in the order request data 106a), the desired delivery date of November 10th (based on the required date "November 10th" in the order request data 106a), the required quantity of 20 (based on the required quantity "20" in the order request data 106a), and the status "Estimate requested", as shown in record B of the order schedule data 106c (before quotation response) in FIG. 3.

Then, the creation unit 102b creates order schedule data 106c (before quotation response) that includes the created records A and B, as shown in FIG. 3.

[3-3. Purchasing department processing]
Next, based on the order schedule data 106c (before quotation response) created in [3-2] and the quotation response from the supplier, the purchasing department registers new agreed products as described in (3) below and confirms the order as described in (4) below.

(1) Input of order consideration (request for quotation)
First, in the "Order Consideration Input (Request for Estimate)" of FIG. 2, the display unit 102c displays on the screen records for which a request for estimate is required.

Specifically, the display unit 102c extracts record B, which is a record including the status of "request for quotation", from the order schedule data 106c (before quotation reply) in FIG. 3, and displays only the extracted record B on the screen. Note that when extracting, the operator may specify a desired delivery date, etc., as an extraction condition.

(2) Input of order consideration (receive quotation response)
Next, a request for quotation is created for record B displayed in (1) and a quotation is requested to the supplier. When the purchasing department receives the quotation reply from the supplier in “Order consideration input (receive quotation reply)” in FIG. 2, the extraction unit 102d extracts records to be updated for information contained in the quotation reply, and then the update unit 102e updates the extracted records.

Specifically, the extraction unit 102d extracts record B, which is a record including a status of "quote request", from the order planning data 106c (before the quotation response) in Fig. 3. In this way, by extracting a record including a status of "quote request" from the order planning data 106c (before the quotation response) at the time of the quotation response, it is possible to prevent, for example, erroneous input of the quotation response.

The update unit 102e then updates the purchase price (assumed to be 110 yen) and the supplier (assumed to be Company C) contained in the quotation reply in record B extracted by the extraction unit 102d, and further updates the status in record B from "request for quotation" to "quotation reply completed." The updated information is shown in a bold frame in record B of the order schedule data 106c (after quotation reply) in FIG. 3.

(3) Agreement Product Transaction Registration Next, in "agreement product transaction registration" in FIG. 2, the update unit 102f registers the information of record B updated in (2) in the agreement product transaction master 106b.

Specifically, the registration unit 102f extracts record B, which is a record including the status "quote completed" from the order schedule data 106c (after quotation response) in FIG. 3, and registers the drawing number "Z003-1", the product name "Part A", the supplier "Company C", and the purchase price "￥110" in the extracted record B in the agreed product transaction master 106b as new agreed product information. The updated agreed product transaction master 106b is shown in FIG. 4 (the part surrounded by a thick frame in FIG. 4 is the newly registered information). In this way, by registering new agreed product information in the agreed product transaction master 106b (registering the record with the status "quote completed" in the agreed product transaction master 106b), it becomes possible to determine whether or not a quotation can be made (for the agreed product) at the time of the next order request, and the maintenance work for the quotation availability determination information is made more efficient.

(4) Order Confirmation Finally, in the "order confirmation" step in FIG. 2, the confirmation unit 102g confirms the order for the record including the status of "agreed product" or "quote reply completed".

Specifically, the confirmation unit 102g extracts record A, which is a record including the status of "agreed item", and record B, which is a record including the status of "quote completed", from the order schedule data 106c (after quotation reply) in FIG. 3, and confirms the order for the extracted records A and B. As a result, purchase orders for records A and B are issued.

In this way, by making it possible to issue a purchase order with a record that includes the status of "agreed item" as a confirmed quotation, it becomes possible, for example, to automatically determine whether or not a quotation is acceptable and to prevent erroneous sending of a purchase order. Also, by making it possible to issue a purchase order with a record that now includes the status of "quote answered" as a result of receiving a quotation reply as a confirmed quotation, it becomes possible, for example, to prevent erroneous sending of a purchase order.

[4. Summary of the present embodiment]
As described above, the order schedule data creation device 100 according to this embodiment can create order schedule data including the status of whether a quotation request is required or not for each order target. This eliminates the need for a purchasing department staff member to manually determine whether a quotation request is required or not for each order target, thereby improving work efficiency and eliminating the possibility of misjudgment, for example.

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 parameters such as search conditions, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

In addition, with regard to the order schedule data creation 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 order schedule data creation 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 order schedule data creation device 100 as necessary. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working 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 order schedule data creation device 100 via any network, and it may be possible to download all or part of it 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 order schedule data creation 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 order schedule data creation 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 transactions are conducted through agreed unit prices with suppliers.

100 Order schedule data creation device 102 Control unit
102a Acquisition unit
102b Creation Department
102c Display unit
102d Extraction unit
102e Update section
102f Registration section
102g determination unit 104 communication interface unit 106 storage unit
106a Order request data
106b Agreement product transaction master
106c Order schedule data 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (8)

An order schedule data creation device including a control unit and a storage unit,
The storage unit includes:
Order request data including order target identification data for identifying an order target to be ordered;
An agreement target setting master including agreement target identification data for identifying an agreement target, which is a target with which an agreement has been concluded to the effect that an order may be placed without making a quotation request, agreement partner identification data for identifying an agreement partner, which is a supplier with which the agreement has been concluded, and an agreement unit price, which is the purchase unit price of the agreement target;
is stored,
The control unit is
A determination means for determining whether or not the agreement target identification data identical to the order target identification data in the order request data exists in the agreement target setting master;
a creating means for creating a record including the order target identification data in the order request data and a quotation request status which is a status indicating that the order target identified by the order target identification data is the subject of the quotation request, if the order target does not exist, and creating order schedule data including the created record;
To have
An order schedule data creation device comprising: The control unit is
a display means for extracting the record including the quotation request status from the order schedule data and displaying the extracted record as a target of the quotation request on a display unit;
2. The order schedule data creation device according to claim 1, The control unit is
an extraction means for extracting the record including the quotation request status when a quotation response is received from a supplier in response to the quotation request;
an updating means for updating the purchase unit price and the supplier identification data included in the quotation reply in the record extracted by the extracting means, and updating the quotation request status in the record extracted by the extracting means to a quotation reply completed status which is a status indicating that the quotation reply has been received;
a registration means for extracting the record including the quotation reply status from the order schedule data, and registering a combination of the order target identification data, the purchase unit price, and the supplier identification data in the extracted record in the agreement target setting master;
Further comprising:
3. The order schedule data creation device according to claim 1 or 2, The control unit is
a determination means for extracting the record including the quotation reply completion status from the order schedule data and determining an order based on the extracted record;
4. The order schedule data creation device according to claim 3, The order object identification data or the agreement object identification data is defined by a combination of part identification data for identifying parts necessary for manufacturing a large machinery and equipment and design drawing identification data for identifying design drawings for the parts;
5. The order schedule data creation device according to claim 1, wherein: The part is a mass-produced part that is repeatedly ordered;
6. The order schedule data creation device according to claim 5, An order schedule data creation method executed by an information processing device having a control unit and a storage unit,
The storage unit includes:
Order request data including order target identification data for identifying an order target to be ordered;
An agreement target setting master including agreement target identification data for identifying an agreement target, which is a target with which an agreement has been concluded to the effect that an order may be placed without making a quotation request, agreement partner identification data for identifying an agreement partner, which is a supplier with which the agreement has been concluded, and an agreement unit price, which is the purchase unit price of the agreement target;
is stored,
Executed by the control unit,
a determination step of determining whether the agreement target identification data that is the same as the order target identification data in the order request data exists in the agreement target setting master;
a creating step of creating a record including the order target identification data in the order request data and a quotation request status which is a status indicating that the order target identified by the order target identification data is the subject of the quotation request, and creating order schedule data including the created record, if the order target does not exist;
containing,
The method for creating order schedule data is characterized by the above. An order schedule data creation program to be executed by an information processing device having a control unit and a storage unit,
The storage unit includes:
Order request data including order target identification data for identifying an order target to be ordered;
An agreement target setting master including agreement target identification data for identifying an agreement target, which is a target with which an agreement has been concluded to the effect that an order may be placed without making a quotation request, agreement partner identification data for identifying an agreement partner, which is a supplier with which the agreement has been concluded, and an agreement unit price, which is the purchase unit price of the agreement target;
is stored,
To cause the control unit to execute
a determination step of determining whether the agreement target identification data that is the same as the order target identification data in the order request data exists in the agreement target setting master;
a creating step of creating a record including the order target identification data in the order request data and a quotation request status which is a status indicating that the order target identified by the order target identification data is the subject of the quotation request, and creating order schedule data including the created record, if the order target does not exist;
containing,
An order schedule data creation program comprising:

Images