JP7153451B2 - Shipment decision work support device, shipment decision work support method, and shipment decision work support program - Google Patents

Description

The present invention relates to a shipping decision support device, a shipping decision support method, and a shipping decision support program.

In Patent Document 1, when the quality standard of the delivered raw material product is checked, the quality standard is within the allowable range, but the quality standard is significantly different from the raw material product that has been mainly used until then. When a raw material product is delivered to us, under the controlled production of those who use the raw material product, as a final product, a normal product based on the above-mentioned large differences in the quality standards of the raw material parts A quality control system is disclosed that enables production to be performed with as little difference in standards and quality as possible (see paragraph 0010 of Patent Document 1).

JP 2005-276180 A

In the field of managing the quality of products to be delivered in this way, for example, in recent years, as the number and types of products handled by manufacturers, etc. have increased, there are cases where the shipping conditions specified by the delivery destination or the company are not met. There was a problem that the wrong product might be shipped.

The present invention has been made in view of the above problems. By outputting a warning when a product does not meet the shipping conditions specified by the delivery destination or by the company, the operator can make accurate shipping decisions. It is an object of the present invention to provide a shipping decision work support device, a shipping decision work support method, and a shipping decision work support program capable of supporting such a situation.

In order to solve the above-described problems and achieve the object, a shipping decision work support device according to the present invention is a shipment decision work support device comprising a control unit, wherein the control unit identifies a delivery destination of the product. Based on shipping data including delivery destination identification data, product identification data for identifying products, and lot identification data for identifying product lots, product identification data, lot identification data, and products product identification data and lot identification in the shipping data by referring to inspection result management data including inspection item identification data for identifying inspection items and inspection result data relating to the results of inspections performed on the product; a first acquisition means for acquiring inspection result data in the inspection result management data linked with the same data; delivery destination identification data, product identification data, and inspection items based on the shipment data and the inspection result management data; By referring to the shipping condition management data including the identification data and the shipping condition data related to the shipping conditions specified by the delivery destination to be satisfied by the result of the inspection, the same delivery destination identification data and product identification data in the shipping data are linked. and a second acquiring means for acquiring shipping condition data in the shipping condition management data that is associated with the same product identification data and inspection item identification data in the inspection result management data; a first confirmation means for confirming whether the obtained inspection result data satisfies the shipping condition data obtained by the second obtaining means; and shipping condition data if the first confirmation means confirms that the data does not satisfy and a first output means for outputting warning data for a combination of delivery destinations and lots that do not satisfy

In the shipping decision work support device according to the present invention, in the shipping condition management data, exceptional data is set as the delivery destination identification data, and the shipping condition data is set as the shipping condition specified by the company. When the shipping condition data cannot be obtained by the second obtaining means, the control unit refers to the shipping condition management data based on the shipping data and the inspection result management data, and obtains the shipping condition data. a third acquisition means for acquiring shipping condition data in the shipping condition management data that is linked with the same product identification data in the data and with the same product identification data in the inspection result management data; a second confirmation means for confirming whether the inspection result data acquired by the first acquisition means satisfies the shipping condition data acquired by the third acquisition means; a second output means for outputting warning data different from the warning data output by the first output means for a combination of delivery destination and lot that does not satisfy the shipping condition data, characterized by

Further, in the shipping decision work support device according to the present invention, the inspection result data acquired by the first acquisition means is a numerical value, and the shipping condition data acquired by the second acquisition means or the third acquisition means is a lower limit. In the case of a value and an upper limit, the confirming means confirms whether the numerical value satisfies a condition that the numerical value is larger than the lower limit and smaller than the upper limit.

Further, in the shipping determination work support device according to the present invention, the control unit only outputs the combination of the delivery destination and the lot for which the warning data is not output by the first output means and the second output means. It is characterized by further comprising a test table output target control means for controlling to be output to the test table related to the product.

Further, a shipping decision work support method according to the present invention is a shipping decision work support method executed by an information processing apparatus having a control unit, wherein the control unit executes a shipping decision work support method for identifying a delivery destination of a product. Product identification data, lot identification data, and inspections performed on products based on shipping data including delivery destination identification data, product identification data for identifying products, and lot identification data for identifying product lots With reference to inspection result management data including inspection item identification data for identifying the items of and inspection result data related to the results of inspections performed on the product, the product identification data and lot identification data in the shipping data a first acquisition step of acquiring inspection result data in the inspection result management data linked to the same item; delivery destination identification data, product identification data, and inspection item identification data based on the shipping data and the inspection result management data; and shipping condition data related to the shipping conditions specified by the delivery destination to be satisfied by the results of the inspection, and linked with the same delivery destination identification data and product identification data in the shipping data, and , a second acquisition step of acquiring shipping condition data in the shipping condition management data that is associated with the same product identification data and inspection item identification data in the inspection result management data; a first confirmation step of confirming whether the inspection result data satisfies the shipping condition data acquired in the second obtaining step; and a first output step of outputting warning data for a combination of delivery destination and lot that is not specified.

Further, a shipping determination work support program according to the present invention is a shipping determination work support program to be executed by an information processing apparatus having a control unit, and identifies a product delivery destination for execution by the control unit. Based on shipping data including delivery destination identification data, product identification data for identifying products, and lot identification data for identifying product lots, product identification data, lot identification data, and products product identification data and lot identification in the shipping data by referring to inspection result management data including inspection item identification data for identifying inspection items and inspection result data relating to the results of inspections performed on the product; a first acquisition step of acquiring inspection result data in the inspection result management data linked with the same data; By referring to the shipping condition management data including the identification data and the shipping condition data related to the shipping conditions specified by the delivery destination to be satisfied by the result of the inspection, the same delivery destination identification data and product identification data in the shipping data are linked. and a second acquisition step of acquiring shipping condition data in the shipping condition management data that is linked to the same product identification data and inspection item identification data in the inspection result management data, and the first acquisition step a first confirmation step of confirming whether the obtained inspection result data satisfies the shipping condition data obtained in the second obtaining step; and a first output step of outputting warning data for combinations of delivery destinations and lots that do not satisfy

According to the present invention, by outputting a warning when a product does not meet the shipping conditions specified by the delivery destination or by the company, it is possible to assist the operator in making accurate shipping decisions.

FIG. 1 is a block diagram showing an example of the configuration of a shipment decision work support device. FIG. 2 is a diagram showing an example of items in each data and each master. FIG. 3 is a diagram showing an example of specific contents in each data and each master. FIG. 4 is a diagram showing an example of a screen for issuing a product test table. FIG. 5 is a diagram showing an example of the issued product test table. FIG. 6 is a diagram showing an example of a flowchart of processing for confirming whether or not shipment is possible according to the present embodiment.

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of a shipping decision support device, a shipping decision support method, and a shipping decision support program according to the present invention will be described below in detail with reference to the drawings. It should be noted that the present invention is not limited by this embodiment.

[1. Overview]
In the chemical industry, food processing industry, etc., products that do not meet the shipping conditions (quality standards) specified by the customer or company may be mistakenly shipped.

Therefore, in the present embodiment, for example, when a product to be shipped does not meet the quality standards set for each business partner, it is possible to call attention to the operator who is in charge of shipping decision work. made it possible. In particular,
(1) Set inspection items and thresholds for each business partner,
(2) At the time of issuing the test sheet attached at the time of shipment, by displaying the lots that do not meet the quality standards on the screen by color-coding, etc., it is possible to make shipping decisions easily. It has made it possible to prevent erroneous shipment of products that do not meet quality standards. In addition, the shipping lot has already been allocated to the shipping instructions. Specific configurations and operations will be described below.

[2. Constitution]
An example of the configuration of the shipment determination work support device 100 according to this embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of a shipment decision work support device 100. As shown in FIG.

The shipping decision work support device 100 is a commercially available desktop personal computer. Note that the shipping decision work support device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smart phone, a tablet personal computer, or the like. It may be a portable information processing device.

The shipping determination work support 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 shipment determination work support device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the shipping decision support apparatus 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 another device via a communication line. Here, the network 300 has a function of connecting the shipping determination work support apparatus 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). Data such as various masters described later 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 section 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that realizes a pointing device function in cooperation with a mouse. Note that, hereinafter, 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 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

The storage unit 106 includes, for example, shipping data 106a, quality result data 106b as inspection result management data, and reference value master 106c as shipping condition management data. Items included in each data and each master are as shown in FIG.

As shown in FIG. 3, the shipping data 106a includes, for example, a shipping number (shipping number) for identifying a shipping number, a shipping date, and delivery destination identification data (delivery destination CD and (delivery destination name), product identification data (product CD and product name) for identifying products, lot identification data (lot number) for identifying product lots, and the number of shipments.

As shown in FIG. 3, the quality result data 106b includes, for example, product identification data (product CD and product name), lot identification data (lot number), and inspection items for identifying inspection items performed on the product. It includes identification data (item number and item name) and inspection result data (result) related to the inspection results of the product. The inspection result data is, for example, numerical values of inspection results.

As shown in FIG. 3, the reference value master 106c includes, for example, delivery destination identification data (delivery destination CD and delivery destination name), product identification data (product CD and product name), inspection item identification data (item number and item name ) and shipping condition data (lower and upper limits) regarding the shipping conditions to be met by the results of inspections performed on the product.

The shipping condition data includes those related to the shipping conditions designated by the delivery destination (delivery destination shipping conditions data) and those related to the shipping conditions designated by the company (company shipping conditions data). For the delivery destination shipping condition data, normal data is set as the delivery destination identification data. For example, in the case of the reference value master 106c in FIG. 3, the combination of the delivery destination shipping condition data and the normal delivery destination identification data is "lower limit 28.0 and upper limit 30.0" and "delivery destination CD: 1007, delivery Destination name: Company A", the combination of "lower limit 6.0 and upper limit 9.0" and "delivery destination CD: 1007, delivery destination name: A company" in the record on the second row, and the combination of "lower limit 27.0 and an upper limit of 30.0" and a combination of "delivery destination CD: 1008, delivery destination name: Company B". On the other hand, for the company's shipping condition data, exceptional data is set as the delivery destination identification data. For example, in the case of the reference value master 106c in FIG. 3, the combination of the company's own shipping condition data and the exceptional delivery destination identification data is "lower limit 29.0 and upper limit 31.0" and "delivery destination CD: 9999" in the fourth row record. The combination of "lower limit 29.0 and upper limit 31.0" and "delivery destination CD: 9999" in the record on the 5th line and "lower limit 7.0 and upper limit 8.0" and "delivery destination CD: 9999" in the record on the 6th line Combination and.

The control unit 102 is a CPU or the like that comprehensively controls the shipment determination business support device 100 . The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

The control unit 102 functionally and conceptually includes, for example, (1) delivery destination identification data for identifying the delivery destination of the product, product identification data for identifying the product, and lot identification data for identifying the lot of the product; Based on the shipping data containing as a first acquisition means for acquiring inspection result data in the inspection result management data linked to the same product identification data and lot identification data in the shipping data by referring to the inspection result management data including (2) based on the shipping data and the inspection result management data, shipment related to delivery destination designation shipping conditions to be satisfied by delivery destination identification data, product identification data, inspection item identification data, and inspection results; By referring to the shipping condition management data including the condition data, the product identification data and the inspection item identification data in the inspection result management data are linked with the same delivery destination identification data and product identification data in the shipping data. and (3) the inspection result data acquired by the first acquisition means, (4) a first confirmation unit 102c as first confirmation means for confirming whether the shipping condition data acquired by the second acquisition means are satisfied; (5) a first output unit 102d as first output means for outputting warning data for a combination of delivery destinations and lots that do not satisfy the condition data; If not, the shipping condition management data is referred to based on the shipping data and the inspection result management data, and the product identification data in the shipment data is the same as the product identification data, and in the inspection result management data (6) the inspection acquired by the first acquisition means, a third acquisition unit 102e as a third acquisition means for acquiring the shipping condition data in the shipping condition management data, which is associated with the same product identification data as the product identification data of a second confirmation unit 102f as second confirmation means for confirming whether the result data satisfies the shipping condition data acquired by the third acquisition means; and (7) confirming that the second confirmation means does not meet of the delivery destination and lot that do not meet the shipping condition data. (8) the first output means and the second output; Test table output object control as test table output object control means for controlling so that only combinations of delivery destinations and lots for which the warning data is not output by the means are targeted for output to the test table related to the product. and a portion 102h. Details of the processing executed by each unit are described in [3. Specific example of processing].

[3. Specific example of processing]
Specific examples of processing according to the present embodiment will be described in detail below with reference to FIGS. 3 to 6. FIG. In this section, the confirmation of whether or not the products of Company A to Company C can be shipped will be explained, and finally, the control of the test table output target based on the confirmation result will be explained.

[3-1. Confirmation of availability for shipment of Company A's products]
In this section, we will explain in detail the decision to ship the anti-skid agent, which is a product of Company A. When "F10: Display" is selected on the test table issuing screen of FIG. 4, (1) to (4) will be described in detail below based on the first row record of the shipping data 106a shown in FIG. is executed, and warning data (indicated by diagonal hatching in FIG. 4) is output for the delivery destination "Company A" and the lot number "170907-1".

In this item [3-1], it is assumed that the shipping data 106a and the quality result data 106b are set as shown in FIG. Also, in this item [3-1], the reference value master 106c has normal data set in the delivery destination identification data, and shipping conditions data related to the specified delivery destination are set in the shipping conditions data. That is, it is assumed that the contents of the records in the first to third rows among the six rows of records in the reference value master 106c of FIG. 3 are set.

(1) First Acquisition Processing (Step S1 in FIG. 6)
The first acquisition unit 102a refers to the quality result data 106b, which includes the product CD, lot number, and item number, based on the shipping data 106a, which includes the delivery destination CD, the product CD, and the lot number. The inspection result data in the quality result data 106b associated with the same product CD and lot number is acquired.

Specifically, in the record on the first line of the shipping data 106a in FIG. 3 (record containing information on company A and anti-skid agent), the product CD is "150280" and the lot number is "170907-1". . On the other hand, in the quality result data 106b of FIG. 3, the records containing the product CD "150280" and the lot number "170907-1" are the records on the first and second lines. From the above, the first acquisition unit 102a obtains the result 30.9 (result for the item name “non-volatile”) included in the first row record and the result 7.5 (item result for the name "PH") (corresponding to "acquire standard value" in step S1 in FIG. 6).

As described in (1) above, the first acquiring unit 102a refers to the quality result data 106b with the "product code + lot number" of the shipping data 106a, and acquires the inspection item number and the standard value (inspection result). be able to.

(2) Second Acquisition Processing (Steps S2 and S3 in FIG. 6)
Based on the shipping data 106a and the quality result data 106b, the second acquisition unit 102b refers to the reference value master 106c including the delivery destination CD, product CD, item number, and shipping condition data, and determines the delivery data in the shipping data 106a. Acquire the shipping condition data in the reference value master 106c that is linked with the same destination CD and product CD and with the same product CD and item number in the quality result data 106b.

Specifically, in the first row record of the shipment data 106a in FIG. 3, the delivery destination CD is "1007" and the product CD is "150280". Also, in the first row record (record acquired by the first acquisition unit 102a) in the quality result data 106b of FIG. In the second row record (record acquired by the first acquisition unit 102a) in the quality result data 106b of No. 3, the product CD is "150280" and the item number is "10".

On the other hand, the records in the 1st to 3rd rows of the reference value master 106c in FIG. A record is a record of the 1st line. Also, in the reference value master 106c of FIG. 3, the record that includes the delivery destination CD "1007" and the product CD "150280" and also includes the product CD "150280" and the item number "10" is the record in the second line. be. From the above, the second acquisition unit 102b obtains the lower limit value of 28.0 and the upper limit value of 30.0 (the lower limit value and the upper limit value for the item name “non-volatile”) contained in the record on the first line as the shipping condition data, and the 6.0 and 9.0 (the lower limit and upper limit for the item name "PH") included in the record of . (corresponds to "No for no applicable data?").

As described in (2) above, the second acquisition unit 102b refers to the reference value master 106c with "delivery destination code + product code" of the shipping data 106a + "product code + inspection item number" of the quality result data 106b. to get the lower and upper bounds.

(3) First confirmation process (step S4 in FIG. 6)
The first confirmation unit 102c confirms whether the inspection result data acquired by the first acquisition unit 102a satisfies the shipping condition data acquired by the second acquisition unit 102b. That is, the first confirmation unit 102c satisfies the condition that the numerical value acquired by the first acquisition unit 102a is larger than the lower limit value acquired by the second acquisition unit 102b and smaller than the upper limit value acquired by the second acquisition unit 102b. Check if there is

Specifically, for the item name “nonvolatile”, the result 30.9 obtained by the first obtaining unit 102a is greater than the lower limit value 28.0 obtained by the second obtaining unit 102b and the upper limit value 30.0 obtained by the second obtaining unit 102b. does not satisfy the less than condition. On the other hand, for the item name "PH", the result 7.5 obtained by the first obtaining unit 102a satisfies the condition that the lower limit value 6.0 and less than 9.0 obtained by the second obtaining unit 102b. In this way, when there is even one item that does not satisfy the conditions while there are items that satisfy the conditions, the first confirmation unit 102c confirms that the inspection result data does not satisfy the shipping condition data (see the figure). (corresponds to No for "lower limit < standard value < upper limit?" in step S4 of 6).

As described in (3) above, the first confirmation unit 102c compares and confirms whether the inspection item number and standard value acquired in (1) satisfy the lower limit value and upper limit value acquired in (2). be able to.

(4) First output process (step S5 in FIG. 6)
When the first confirmation unit 102c confirms that the conditions are not satisfied, the first output unit 102d outputs warning data for the combination of delivery destination and lot that do not satisfy the shipping condition data.

Specifically, as described in (3), since the first confirmation unit 102c has confirmed that the conditions are not met, the first output unit 102d outputs the As shown in the rightmost column of the record, output warning data (indicated by diagonal hatching) for the combination of delivery destination "Company A" and lot number "170907-1" (Fig. 6). (corresponds to step S5, "error display based on customer's standards").

As described in (4) above, the first output unit 102d outputs an error (supplier standard error) when the condition of lower limit value<standard value<upper limit value is not satisfied.

As described in (1) to (4) above, the client-based error is displayed and the process ends (corresponding to "END" in FIG. 6).

[3-2. Confirmation of availability for shipment of Company B's products]
In this section, we will explain in detail the decision to ship the additive for car wax, which is a product of Company B. When "F10: Display" is selected on the test table issuance screen of FIG. 4, (1) to (4) will be described in detail below based on the record on the second line of the shipping data 106a shown in FIG. is executed, and warning data (indicated by dotted hatching in FIG. 4) is output for the delivery destination "Company B" and the lot number "170908-1".

In this item [3-2], it is assumed that the shipping data 106a and the quality result data 106b are set as shown in FIG. In addition, in this item [3-2], in the reference value master 106c, exceptional data is set in the delivery destination identification data and the shipping conditions specified by the company are set in the shipping condition data. That is, it is assumed that the contents of the records in the 4th to 6th rows among the 6 rows of records in the reference value master 106c of FIG. 3 are set.

(1) First Acquisition Processing (Step S1 in FIG. 6)
The first acquisition unit 102a acquires the result 28.0 included in the third row record in the quality result data 106b of FIG. (corresponds to "acquisition of standard value" which is step S1 of 6).

(2) Third Acquisition Processing (Steps S2, S3 and S6 in FIG. 6)
In the record on the second line of the shipment data 106a in FIG. 3, the delivery destination CD is "1008" and the product CD is "119626". Here, as described in (2) of [3-1], the second acquiring unit 102b uses the delivery destination CD and product CD in the shipping data 106a when referring to the reference value master 106c. However, the records on the 4th to 6th rows of the reference value master 106c in FIG. 3 do not include the combination of the delivery destination CD "1008" and the product CD "119626" in the shipping data 106a. Therefore, the second acquisition unit 102b cannot acquire the shipping condition data. In this case, the third acquisition unit 102e executes the following process (corresponding to "acquire lower limit and upper limit" in step S2 of FIG. 6 and "Yes to no applicable data?" in step S3 of FIG. 6). .

When the second acquisition unit 102b fails to acquire the shipping condition data, the third acquisition unit 102e refers to the reference value master 106c based on the shipment data 106a and the quality result data 106b, and obtains the Acquire the shipping condition data in the reference value master 106c that is associated with the same item as the product CD and with the same item as the product CD in the quality result data 106b.

Specifically, in the record on the second line of the shipment data 106a in FIG. 3, the product CD is "119626", and in the record on the third line of the quality result data 106b in FIG. Record), the product CD is "119626". On the other hand, in the 4th to 6th lines of the reference value master 106c in FIG. 3, the record including the product CD "119626" is the 4th line record. As described above, the third acquisition unit 102e acquires the lower limit value of 29.0 and the upper limit value of 31.0 included in the record of the fourth row as the shipping condition data (the "acquire lower limit and upper limit" in step S6 of FIG. 6). equivalent).

As described in (2) above, when the second obtaining unit 102b refers to the reference value master 106c and there is no corresponding data, the third obtaining unit 102e refers to the reference value master 106c only with the product code. (At the time of this reference, the delivery destination code in the reference value master 106c is set to "9999").

(3) Second confirmation process (step S7 in FIG. 6)
The second confirmation unit 102f confirms whether the inspection result data acquired by the first acquisition unit 102a satisfies the shipping condition data acquired by the third acquisition unit 102e. That is, the second confirmation unit 102f satisfies the condition that the numerical value acquired by the first acquisition unit 102a is larger than the lower limit value acquired by the third acquisition unit 102e and smaller than the upper limit value acquired by the third acquisition unit 102e. Check if there is

Specifically, the result 28.0 obtained by the first obtaining unit 102a does not satisfy the condition that it is larger than the lower limit value 29.0 obtained by the third obtaining unit 102e and smaller than the upper limit value 31.0 obtained by the third obtaining unit 102e. Therefore, the second confirmation unit 102f confirms that the inspection result data does not satisfy the shipping condition data (corresponding to No to "lower limit<standard value<upper limit?" in step S7 of FIG. 6).

(4) Second output process (step S8 in FIG. 6)
When the second confirmation unit 102f confirms that the second output unit 102g does not meet the requirements, the second output unit 102g targets the combination of the delivery destination and the lot that does not satisfy the shipping condition data, and outputs warning data from the first output unit 102d. outputs different warning data.

Specifically, as described in (3), since the second confirmation unit 102f has confirmed that the conditions are not satisfied, the second output unit 102g outputs the As shown in the rightmost column of the record, output warning data (indicated by dotted hatching) for the combination of delivery destination "Company B" and lot number "170908-1" (Fig. (corresponds to step S8, "error display according to company standards").

As described in (4) above, the second output unit 102g outputs an error (company general standard error) when the condition of lower limit value<standard value<upper limit value is not satisfied.

As described in (1) to (4) above, an error based on the company's standards is displayed and the process ends (corresponding to "END" in FIG. 6).

[3-3. Confirmation of availability for shipment of Company C's products]
In this section, we will explain in detail the decision to ship the anti-skid agent, which is a product of Company C. When "F10: Display" is selected on the test table issuing screen of FIG. 4, (1) to (3) will be described in detail below based on the third row record of the shipping data 106a shown in FIG. process is executed.

In this item [3-3], it is assumed that the shipping data 106a and the quality result data 106b are set as shown in FIG. In addition, in this item [3-3], in the reference value master 106c, exceptional data is set in the delivery destination identification data and the shipping conditions specified by the company are set in the shipping condition data. That is, it is assumed that the contents of the records in the 4th to 6th rows among the 6 rows of records in the reference value master 106c of FIG. 3 are set.

(1) First Acquisition Processing (Step S1 in FIG. 6)
The first acquisition unit 102a acquires the result 30.9 (item name “non-volatile ”) and the result 7.5 (result for the item name “PH”) included in the second row record (corresponding to step S1 in FIG. 6, “acquisition of standard value”).

(2) Third Acquisition Processing (Steps S2, S3 and S6 in FIG. 6)
The third acquisition unit 102e acquires the lower limit values 29.0 and 31.0 (item Obtain the lower limit value and upper limit value for the name "non-volatile") and the lower limit value 7.0 and upper limit value 8.0 (lower limit value and upper limit value for the item name "PH") contained in the record on the 6th line (step in FIG. 6 (corresponds to S2 "Obtain the lower limit and upper limit", Step S3 of FIG. 6 "Yes to no applicable data?", and Step S6 of FIG. 6 "Obtain the lower limit and upper limit").

(3) Second confirmation process (step S7 in FIG. 6)
The second confirmation unit 102f confirms that the result 30.9 acquired by the first acquisition unit 102a for the item name “non-volatile” is greater than the lower limit value 29.0 acquired by the third acquisition unit 102e and the upper limit acquired by the third acquisition unit 102e. Check if it satisfies the condition that the value is less than 31.0. The second confirmation unit 102f also confirms that the result 7.5 acquired by the first acquisition unit 102a for the item name "PH" is greater than the lower limit value 7.0 acquired by the third acquisition unit 102e and is acquired by the third acquisition unit 102e. It is confirmed that the condition that the upper limit value is less than 8.0 is satisfied (corresponding to Yes to "lower limit < standard value < upper limit?" in step S7 of Fig. 6).

(4) Second output process As described in (3), when the second confirmation unit 102f confirms that the second output unit 102g satisfies the requirements, the second output unit 102g performs the 3 As shown in the rightmost column of the row record, do not output warning data for the combination of delivery destination "Company C" and lot number "170907-1".

As described in (1) to (4) above, the process ends without displaying an error (corresponding to "END" in FIG. 6).

[3-4. Control of test table output target based on the result of shipment availability confirmation]
This item describes in detail the control of the product test table output target based on the results of confirming whether or not the products of Company A to Company C described in [3-1] to [3-3] can be shipped.

(Test table output target control process)
The test table output target control unit 102h selects only the combinations of delivery destinations and lots for which warning data is not output by the first output unit 102d and the second output unit 102g as targets for output to the test table related to the product. control so that

Specifically, as explained in [3-1], the combination of delivery destination "Company A" and lot number "170907-1" is the target of warning data output, and explained in [3-2] Thus, the combination of the delivery destination "Company B" and the lot number "170908-1" is also subject to warning data output. On the other hand, as explained in [3-3], the combination of the delivery destination "Company C" and the lot number "170907-1" is not subject to warning data output. In this case, the test table output target control unit 102h, as shown in the test table issuance screen of FIG. ) and the combination of delivery destination “Company B” and lot number “170908-1” (second row record with B), uncheck “Issue Classification”, while delivery destination “Company C” And for the combination of lot number "170907-1" (the record on the third line with C), the "Issue Classification" is left checked. In this state, when "F6: Issuance" is selected at the bottom of the screen in Fig. 4, as shown in Fig. 5, the product test table is displayed only for the combination of delivery destination "Company C" and lot number "170907-1". publish.

[3-5. summary]
As described above in [3-1] to [3-3], according to the shipping determination work support device 100 according to the present embodiment, if the product does not meet the shipping conditions specified by the delivery destination or the company By outputting a warning to , it is possible to assist the operator in making accurate shipping decisions.

In addition, as described in [3-4], according to the shipping determination work support device 100 according to the present embodiment, for example, for delivery destinations and lots that do not meet shipping conditions and are subject to warning, product testing Since it is possible to remove the product from the list to be issued, it is possible to prevent erroneous shipment of products that do not meet the shipping conditions.

[4. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above within the scope of the technical idea described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be manually performed, or all of the processes described as being manually performed Alternatively, some can be done automatically by known methods.

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

In addition, regarding the shipment decision work support device 100, each component shown in the figure is functionally conceptual, and does not necessarily need to be physically configured as shown in the figure.

For example, all or any part of the processing functions of the shipping decision support device 100, particularly the processing functions performed by the control unit, are realized by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment, and the shipping determination work may be performed as necessary. It is mechanically read by the support device 100 . That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

Also, this computer program may be stored in an application program server connected to the shipment decision support apparatus 100 via any network, and may be downloaded in whole or in part as necessary. It is possible.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered (trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Disc (registered trademark) such as Blu- shall include any "portable physical medium".

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single configuration, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, the installation procedure after reading, and the like.

The various databases stored in the storage unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks. It stores programs, tables, databases, files for web pages, and so on.

Further, the shipment decision work support 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. Further, the shipping decision work support device 100 may be realized by installing software (including programs, data, etc.) for realizing the processing described in the present embodiment.

Furthermore, the specific forms of distribution and integration of devices are not limited to those shown in the figures, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

The present invention is useful, for example, in the manufacturing industry, but is particularly useful in the chemical and food processing industries.

100 shipment decision work support device 102 control unit
102a first acquisition unit
102b second acquisition unit
102c first confirmation unit
102d first output unit
102e third acquisition unit
102f second confirmation unit
102g second output section
102h test table output target control unit 104 communication interface unit 106 storage unit
106a Shipping data
106b Quality result data
106c reference value master 108 input/output interface unit 112 input device 114 output device 200 server 300 network

Claims (5)

A shipping decision work support device comprising a control unit,
The control unit
Product identification data and lot identification based on shipping data including delivery destination identification data for identifying the product delivery destination, product identification data for identifying the product, and lot identification data for identifying the product lot In the shipping data, referring to inspection result management data including data, inspection item identification data for identifying items of inspection performed on the product, and inspection result data on the result of the inspection performed on the product. a first acquisition means for acquiring inspection result data in the inspection result management data associated with the same product identification data and lot identification data of
Shipping condition management including delivery destination identification data, product identification data, inspection item identification data, and shipping condition data related to shipping conditions specified by the delivery destination to be satisfied by the inspection result, based on the shipping data and the inspection result management data. By referring to the data, it is linked with the same delivery destination identification data and product identification data in the shipping data, and linked with the same product identification data and inspection item identification data in the inspection result management data, a second acquiring means for acquiring shipping condition data in the shipping condition management data;
When the inspection result data acquired by the first acquisition means is a numerical value, and the shipping condition data acquired by the second acquisition means is a lower limit value and an upper limit value, the numerical value acquired by the first acquisition means is , a first confirmation means for confirming whether the condition of being larger than the lower limit value acquired by the second acquisition means and smaller than the upper limit value acquired by the second acquisition means is satisfied;
a first output means for outputting warning data for a combination of delivery destinations and lots that do not satisfy the shipping condition data when the first confirmation means confirms that the conditions are not met;
to provide
A shipping decision business support device characterized by: In the shipping conditions management data, exceptional data is set in the delivery destination identification data, and shipping conditions data related to the shipping conditions specified by the company is set in the shipping conditions data,
The control unit
When the shipping condition data cannot be obtained by the second obtaining means, the shipping condition management data is referred to based on the shipping data and the inspection result management data, and the commodity identification data in the shipping data and the a third acquisition means for acquiring shipping condition data in the shipping condition management data that is linked to the same item and is linked to the same product identification data in the inspection result management data;
When the inspection result data acquired by the first acquisition means is a numerical value, and the shipping condition data acquired by the third acquisition means is a lower limit value and an upper limit value, the numerical value acquired by the first acquisition means is , a second confirmation means for confirming whether the condition of being larger than the lower limit value acquired by the third acquisition means and smaller than the upper limit value acquired by the third acquisition means is satisfied;
If it is confirmed by the second confirmation means that the conditions are not met, warning data different from the warning data output by the first output means is output for the combination of delivery destination and lot that do not satisfy the shipping condition data. a second output means;
further providing
2. The shipment decision work support device according to claim 1, characterized by: The control unit
Test table output for controlling so that only combinations of delivery destinations and lots for which the warning data are not output by the first output means and the second output means are targeted for output to the test table related to the product. further comprising an object control means;
3. The shipment decision business support device according to claim 2 , characterized by: A shipping decision work support method executed by an information processing device having a control unit,
executed by the control unit;
Product identification data and lot identification based on shipping data including delivery destination identification data for identifying the product delivery destination, product identification data for identifying the product, and lot identification data for identifying the product lot In the shipping data, referring to inspection result management data including data, inspection item identification data for identifying items of inspection performed on the product, and inspection result data on the result of the inspection performed on the product. a first acquisition step of acquiring inspection result data in the inspection result management data linked with the same product identification data and lot identification data of
Shipping condition management including delivery destination identification data, product identification data, inspection item identification data, and shipping condition data related to shipping conditions specified by the delivery destination to be satisfied by the inspection result, based on the shipping data and the inspection result management data. By referring to the data, it is linked with the same delivery destination identification data and product identification data in the shipping data, and linked with the same product identification data and inspection item identification data in the inspection result management data, a second acquisition step of acquiring shipping condition data in the shipping condition management data;
When the inspection result data acquired in the first acquisition step is a numerical value, and the shipping condition data acquired in the second acquisition step is a lower limit value and an upper limit value, the numerical value acquired in the first acquisition step is , a first confirmation step of confirming whether the condition of being larger than the lower limit value obtained in the second obtaining step and smaller than the upper limit value obtained in the second obtaining step is satisfied;
a first output step of outputting warning data for a combination of delivery destination and lot that does not satisfy the shipping condition data when it is confirmed that the first confirmation step does not meet the requirements;
including
A shipping decision work support method characterized by: A shipping decision work support program to be executed by an information processing device having a control unit,
for causing the control unit to execute
Product identification data and lot identification based on shipping data including delivery destination identification data for identifying the product delivery destination, product identification data for identifying the product, and lot identification data for identifying the product lot In the shipping data, referring to inspection result management data including data, inspection item identification data for identifying items of inspection performed on the product, and inspection result data on the result of the inspection performed on the product. a first acquisition step of acquiring inspection result data in the inspection result management data linked with the same product identification data and lot identification data of
Shipping condition management including delivery destination identification data, product identification data, inspection item identification data, and shipping condition data related to shipping conditions specified by the delivery destination to be satisfied by the inspection result, based on the shipping data and the inspection result management data. By referring to the data, it is linked with the same delivery destination identification data and product identification data in the shipping data, and linked with the same product identification data and inspection item identification data in the inspection result management data, a second acquisition step of acquiring shipping condition data in the shipping condition management data;
When the inspection result data acquired in the first acquisition step is a numerical value, and the shipping condition data acquired in the second acquisition step is a lower limit value and an upper limit value, the numerical value acquired in the first acquisition step is , a first confirmation step of confirming whether the condition of being larger than the lower limit value obtained in the second obtaining step and smaller than the upper limit value obtained in the second obtaining step is satisfied;
a first output step of outputting warning data for a combination of delivery destination and lot that does not satisfy the shipping condition data when it is confirmed that the first confirmation step does not meet the requirements;
including
A shipping decision business support program characterized by

Images