JP2019153242A - Expiration date calculation device, expiration date calculation method, and expiration date calculation program - Google Patents

Abstract

To provide an expiration date calculation device, an expiration date calculation method, and an expiration date calculation program capable of automatically setting an expiration date when a product has a member with an expiration date as a component when the manufacture of the product is completed.SOLUTION: An expiration date calculation device according to the present embodiment includes: an item master which registers at least a product and its expiration months in association with each other; a production formation master that registers, in association with each other, the product and a semi-product, a first member without an expiration date, and/or a second member with an expiration data all forming the product; and expiration date calculation means for, when the product includes the second member as the component as a result of reference to the item master and the production formation master upon completion of the manufacture of the product, comparing an expiration date of the product with an expiration date of a chemical contained in the component of the product and automatically setting the shorter expiration date as the expiration date of the product.SELECTED DRAWING: Figure 1

Description

  The present invention relates to an expiration date calculation device, an expiration date calculation method, and an expiration date calculation program.

  Conventionally, there is, for example, Patent Document 1 as a system for managing the expiration date of a medicine. In Patent Document 1, [0005] states that “a preparation control method for preparing a preparation mixture for use in at least one pharmaceutical preparation apparatus having a plurality of related raw material solutions and a mixture receiver. Determining whether the plurality of raw material solutions conform to a predetermined configuration; if the raw material solution is not assumed; providing an alert to an operator to avoid blending; and the raw material solution A step of determining a respective expiration date, a step of warning and / or avoiding the use of any of the raw material solutions if any of the raw material solutions has expired, and the input of a mixture based on the input of the mixture Adding at least a portion of at least one of the solutions to the mixture receiver to form the blended mixture. "

JP-T-2007-515213

  However, Patent Document 1 does not describe anything regarding the expiration date of a product having a chemical solution as a component when the manufacture of the product is completed.

  The present invention has been made in view of the above, and when a product has been manufactured, if the product has a member with a valid term as a component, the valid date of the product is automatically set. It is an object of the present invention to provide an expiration date calculation device, an expiration date calculation method, and an expiration date calculation program.

  In order to solve the above-described problems and achieve the object, the present invention provides at least an item master for registering a product in association with its expiration date, a product, a semi-product, and an expiration date constituting the product. A product configuration master that registers and registers a first member that is not associated with a second member and / or a second member that has an expiration date, and refers to the item master and the product configuration master when the manufacture of the product is completed When the product includes the second member as a component, the expiration date of the product is compared with the expiration date of the chemical contained in the component of the product, And an expiration date calculating means for automatically setting the expiration date.

  Further, according to the present embodiment, when the first member and / or the second member arrives, the inventory data including the number of inventory and the expiration date is created, and the product is completed. When the product includes inventory data creating means for creating inventory data, and the product expiration date calculating unit includes the second member as a constituent element, the product expiration date of the stock data of the drug solution and the product It is preferable that the shorter expiration date is set as the expiration date of the inventory data of the product by comparing the manufacturing completion date of the product + the number of months of validity of the product in the item master.

  In addition, according to the present embodiment, the item master further registers the semi-finished product and its expiration month in association with each other, and the product configuration master further configures the semi-finished product and the semi-finished product. The first member and / or the second member are registered in association with each other, and the expiration date calculating means includes the second member as a component when the expiration date of the product is automatically set. If there is a product, it is desirable to compare it with the expiry date of the semi-finished product.

  According to the present embodiment, it is desirable that the second member is a chemical solution.

  In order to solve the above-described problems and achieve the object, the present invention is an expiration date calculation method executed by an information processing apparatus including a control unit and a storage unit, and the storage unit includes at least a product. An item master that associates and registers the expiration date and the product, a product, a semi-finished product, a first member that does not have an expiration date, and / or a second member that has an expiration date. A product configuration master that is registered in association with the product, and is executed by the control unit, and when the manufacture of the product is completed, the product is referred to the second member with reference to the item master and the product configuration master. Is included in the component, the expiration date of the product is compared with the expiration date of the chemical contained in the component of the product, and a short expiration date is automatically set as the expiration date of the product. Calculation step And wherein the Mukoto.

  In order to solve the above-described problems and achieve the object, the present invention is an expiration date calculation program for causing an information processing apparatus including a control unit and a storage unit to execute, wherein the storage unit includes at least An item master for registering a product in association with its expiration month, a product, a semi-finished product, a first member without an expiration date, and / or a second member with an expiration date constituting the product A product configuration master for registering the product in association with each other, and when manufacturing of the product is completed, referring to the item master and the product configuration master, if the product includes a chemical solution as a component, An expiration date for causing the control unit to execute an expiration date calculating step for automatically setting a short expiration date as the expiration date of the product by comparing the expiration date and the expiration date of the chemical contained in the component of the product. Is a calculation program.

  According to the present invention, when the manufacture of a product is completed, if the product has a member with an expiration date as a component, the expiration date of the product can be automatically set.

FIG. 1 is a block diagram illustrating an example of a configuration of an expiration date calculation apparatus. FIG. 2 is a diagram for explaining an example of the entire processing procedure of the expiration date calculating apparatus according to the present embodiment. FIG. 3 is a diagram for explaining an example of the expiration date calculation process. FIG. 4 is a diagram illustrating an example of data of the item master. FIG. 5 is a diagram illustrating a data example of a product configuration master and a configuration image of a product hierarchy. FIG. 6 is a diagram illustrating a data example of inventory data. FIG. 7 is a diagram for explaining calculation of the expiration date of a product when the product configuration is “one layer”. FIG. 8 is a diagram for explaining the calculation of the expiration date of a product when the product configuration is “two levels”.

  Hereinafter, embodiments of an expiration date calculation device, an expiration date calculation method, and an expiration date calculation program according to the present invention will be described in detail based on the drawings. In addition, this invention is not limited by this embodiment.

[1. Overview]
Conventionally, when setting the expiration date of a product, the product expiration date was manually entered with reference to the component usage list when the manufacture of the product was completed, leading to an input error. More specifically, since the expiry date of the chemical solution that constitutes the product may be shorter than the expiry date of the product, refer to the component usage list that describes the expiry date, Since the operator has manually entered the expiration date of this, the operation is troublesome and an input error by the operator has occurred. Moreover, the yield of chemicals with a short expiration date was poor.

  In the present embodiment, the expiration date of a product having a chemical solution at the time of completion of product manufacture is automatically set as the expiration date of the product when the expiration date of the chemical solution is short. Moreover, there is an effect of preventing a decrease in the yield of a chemical solution with a short expiration date by preferentially using a chemical solution with a short expiration date for a product.

  For example, if the expiration date of the product is 24 months from the date of completion of manufacture, if the product is manufactured on the date of completion of manufacture “2017/08/31”, the expiration date of the product is “2019/08/31”. If the element has a chemical solution, and the expiration date of the chemical solution is “2019/02/28”, the expiration date of the product is automatically set to “2019/02/28”. In this way, by automatically calculating and setting the expiration date of the product, work efficiency is improved and input errors are prevented.

  Hereinafter, a specific configuration and operation will be described. In the following description, the first member having no expiration date is simply referred to as “member”, and the case of “chemical solution” is described as the second member having an expiration date. In the present invention, the second member having an expiration date is not limited to the “chemical solution”, but can be applied to other members having an expiration date. The “product” is, for example, a pharmaceutical product, but the present invention is not limited to this.

[2. Constitution]
The configuration of the expiration date calculating device 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the expiration date calculation device 100.

  The expiration date calculating device 100 is a commercially available desktop personal computer. The expiration date calculation device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable personal computer such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer. It may be a type information processing apparatus.

  As shown in FIG. 1, the expiration date calculating apparatus 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 expiration date calculating device 100 is connected to be communicable via an arbitrary communication path.

  The communication interface unit 104 communicatively connects the expiration date calculating device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the expiration date calculating 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 stored in the storage unit 106 to be described later may be stored in the server 200.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker (including a home television), a speaker, and a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with the mouse can be used. In the following description, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112. “Output” includes displaying on the monitor of the output device 114 and printing with the printer of the output device 114. In addition, when the user operates the information displayed on the monitor 114 with the input device 112 or the like, the operation may be referred to as “user operation via UI”.

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

  The storage unit 106 stores an item master 106a, a product configuration master 106b, and an inventory data file 106c.

  The item master 106a is a master for defining the number of months for which each item (product, semi-finished product, member, and / or chemical) is valid. The item master 106a includes an item code for identifying an item (product, semi-finished product, member, and / or chemical), a name of the item (product, semi-finished product, member, and / or chemical), and an item (product, semi-finished product). , Member, and / or drug solution) (in which the expiration date “0” indicates that there is no expiration date) and a drug category indicating whether the drug is a drug solution (for example, “0” is a drug solution) Other than the above, “1” can be constituted by a table or the like registered in association with the data of the drug solution (see FIG. 4).

  The product configuration master 106b is a master for registering components of products and / or semi-products (semi-products, members, and / or chemicals). The product configuration master 106b stores an item code for identifying a product and / or a semi-finished product, a semi-finished product, a member, and / or a chemical solution used when the product and / or the semi-finished product is manufactured. It can be configured by a table or the like in which item codes for identification and data on the number of uses thereof are registered in association with each other (see FIG. 5).

  The inventory data file 106c is for storing inventory data of products, semi-finished products, parts, and / or chemicals. The inventory data includes the part number code for identifying the item (product, semi-finished product, part, and / or chemical), the name of the item (product, semi-finished product, part, and / or chemical), the manufactured lot, the expiration date, And inventory quantity data may be included (see FIG. 6).

  The control unit 102 is a CPU or the like that comprehensively controls the expiration date calculating apparatus 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, and necessary data, and performs various information processing based on these stored programs. Execute. The control unit 102 includes an inventory data creation unit 102a, an expiration date calculation unit 102b, and a master maintenance unit 102c in terms of functional concept.

  The inventory data creation unit 102a performs receiving input when a member and / or chemical solution is received or a product and / or semi-finished product is completed, and responds to an operator's operation on an input screen displayed on the monitor 114. Inventory data is created and stored in the inventory data file 106c. The inventory data creation unit 102a displays the target inventory data stored in the inventory data file 106b on the monitor 114 in accordance with the operation of the operator. Thus, the operator can check the expiration date of the inventory data of the target item.

  The expiration date calculation unit 102b refers to the item master 106a and the product configuration master 106b when the manufacture of the product is completed. When the product includes a chemical solution as a component, the expiration date of the product and the product The expiration date of the chemical solution contained in the component is compared, and the shorter expiration date is automatically set as the expiration date of the product.

  In this case, when the product includes a chemical solution as a component, the expiration date calculation unit 102b determines the expiration date of the stock data of the chemical solution and the product completion date of the product + the number of months of validity of the product in the item master 106a. And the shorter expiration date may be automatically set as the expiration date of the inventory data of the product.

  When the expiration date of the product is automatically set, the expiration date calculation unit 102b may also compare the expiration date of the semi-finished product when there is a semi-finished product containing a chemical solution as a component.

  The master maintenance unit 102c displays a master maintenance screen on the monitor 114 according to the operation of the operator, and inputs data to the item master 106a and the product configuration master 106b according to the operation of the operator on the master maintenance screen.・ Edit such as addition, change, update.

[3. Specific example of processing]
With reference to FIGS. 1-8, the specific example of the process of the expiration date calculation apparatus 100 which concerns on this Embodiment is demonstrated. FIG. 2 is a diagram for explaining an example of the entire processing procedure of the expiration date calculating apparatus 100 according to the present embodiment. FIG. 3 is a diagram for explaining an example of the expiration date calculation process. With reference to FIG.2 and FIG.3, an example of the whole process sequence of the expiration date calculation apparatus 100 which concerns on this Embodiment is demonstrated.

  In FIG. 2, first, the master maintenance unit 102c registers data in the item master 106a and the product configuration master 106b in accordance with the operation of the operator on the master maintenance screen (step S1).

  The inventory data creation unit 102a performs acceptance input when purchasing parts and chemicals, creates inventory data of the purchased parts and chemicals according to the input operation of the operator on the input screen, and creates the inventory data file 106c. (Step S2). The operator may perform an input operation by looking at a purchase slip in which the expiration date of the chemical is written.

  The stock data creation unit 102a performs acceptance input when a product or semi-finished product is completed, creates stock data of the product or semi-finished product according to an input operation of the operator on the input screen, and creates a stock data file 106c. (Step S3). Moreover, the expiration date calculation part 102b performs the expiration date calculation process shown in FIG. 3, when a product or a semi-finished product is completed.

  In FIG. 3, first, the expiration date calculation unit 102b refers to the product configuration master 106b to determine whether or not the target product or the component of the semi-finished product has a chemical (step S11). In the case of a product, a semi-finished product is included as a component, and a case where the semi-finished product includes a chemical solution as a component is also determined. When there is no chemical solution in the component (“No” in step S11), the expiration date of the product or semi-finished product is directly adopted as the expiration date of the product or semi-finished product (step S12).

  When there is a chemical solution in the component (“Yes” in step S11), the expiration date of the product or semi-finished product is compared with the expiration date of the inventory data of the chemical solution (step S13). Specifically, the expiration date of the product is calculated by the product completion date + the number of months of expiration of the corresponding product in the item master 106a. Similarly, the expiry date of the semi-finished product is calculated by the date of completion of the semi-finished product + the number of months of expiry date of the corresponding semi-finished product in the item master 106a. Then, the shorter expiration date is adopted as the expiration date of the product or semi-finished product (step S14).

  With reference to FIGS. 4 to 7, specific data examples of the processing of the expiration date calculating apparatus 100 according to the present embodiment will be described. FIG. 4 is a diagram illustrating an example of data in the item master 106a. FIG. 5 is a diagram illustrating a data example of the product configuration master 106b and a configuration image of the hierarchy thereof. FIG. 6 is a diagram illustrating a data example of inventory data. FIG. 7 is a diagram for explaining calculation of the expiration date of a product when the product configuration is “one layer”. FIG. 8 is a diagram for explaining the calculation of the expiration date of a product when the product configuration is “two levels”.

  In the example of the item master 106a shown in FIG. 4, for the item code “0001”, the name “product A”, the expiration date “36”, the drug solution category “0”, and for the product code “0002” the name “ “Product B”, expiration date “36”, chemical category “0” is registered, and for the item code “0003”, the name “product C”, expiration date “36”, chemical category “0” is registered. Yes.

  In the example of the item master 106a shown in FIG. 4, for the product code “1000001”, the name “member A”, the expiration month “0”, the chemical classification “0”, and the product code “1000002” For the name “member B”, the expiry month “0”, the chemical category “0”, and the product code “1000003”, the name “member C”, the expiry month “0”, the medicinal solution category “0” As for the product code “200001”, the name “semi-finished product 1”, the expiration date “36”, and the chemical classification “1” are registered.

  In the example of the product configuration master 106b shown in FIG. 5A, the configuration of the product B with the product number code “00002” (name “product B” corresponding to the product number code “00002” of the item master 106a) is The number of use of the product code “1000001” is “2”, the number of use of the product code “1000002” is “1”, the number of use of the product code “1000003” is “1”, and the number of use of the product code “3000001” is “1”. ing. As shown in FIG. 5B, the configuration of the product B is a “one-level” configuration, and includes the first-layer member A, member B, member C, and the chemical solution 1.

  In the example of the product configuration master 106b shown in FIG. 5A, the product A with the product code “0001” (the name corresponding to the product code “00001” in the product master 106a is “product A”) is the product code “ The number of used “1000001” is “2”, the number of used product code “1000002” is “1”, the number of used product code “200001” is “1”, the number of used product code “3000001” is “1”, and the product code is “3000003”. The number of uses is “1”. In addition, the semi-finished product 1 with the product number code “2000001” (the name corresponding to the product number code “200001” in the item master 106a is “semi-finished product 1”) is the number of uses “1” of the product number code “1000003” and the product number code “3000002”. The number of use of “1” is “1”.

  As shown in FIG. 5C, the configuration of the product A is a “two-level” configuration. The first level of the product A is a member A, a member B, a semi-finished product 1, a drug solution 1, and a drug 3. It is comprised, and the 2nd hierarchy is comprised with the member C and the chemical | medical solution 2 which are the components of the semi-finished product 1. FIG.

(1) As described above, when the stock data creation unit 102a purchases a member or a chemical solution, the stock data creation unit 102a performs acceptance input, creates stock data, and stores the stock data in the stock data file 106c. FIG. 6 shows an example of inventory data for which acceptance input has been performed. In the example of the inventory data shown in FIG. 6, the product number code “1000001”, the name “member A”, the stock quantity “1,000”, the product number code “1000002”, the name “member B”, and the stock quantity “2,000”. Product number code “1000003”, name “member C”, stock quantity “3,000”, product number code “3000001”, name “chemical solution 1”, expiration date “2017/02/28”, stock quantity “1,” 000 ”, product number code“ 3000002 ”, name“ chemical solution 2 ”, expiration date“ 2016/12/31 ”, inventory number“ 2,000 ”, product number code“ 3000003 ”, name“ chemical solution 3 ”, expiration date“ 2017/01/28 "and the inventory quantity is" 3,000 ".

  Next, the case where the configuration of the completed product is the hierarchy “1” and the case of the hierarchy “2” will be described separately.

(2) When the configuration of the completed product is the hierarchy “1” When the product B is completed, acceptance input is performed to create inventory data. As shown in FIG. 7A, the product B has a one-layer configuration, and since the product B uses the chemical solution 1, the expiration date of the product A is compared with the expiration date of the chemical solution 1. .

  In FIG. 7B, when the production completion date of the product B is “2014/03/31”, the product master B is referred to and the product B has an expiration date of “36 months”. In the normal case, the expiration date of B is “2017/03/31”.

  Referring to the stock data of the chemical solution 1, since the expiration date of the chemical solution 1 is 2017/02/28, the expiration date of the chemical solution 1 is shorter, so the expiration date of the product B is “2017/02/28”. Become. When the expiration date of the product B is first, the expiration date of the product B is “2017/03/31” which is the expiration date of the product B. Further, when the chemical solution is not included in the configuration, “2017/03/31” is the expiration date of the product B.

  FIG. 7C shows an example of the inventory data of the product B, and “2017/02/28” is adopted as the expiration date of the inventory data of the product B.

(3) When the configuration of the completed product is the hierarchy “2” First, when the semi-finished product 1 is completed, the acceptance input is performed and the inventory data of the semi-finished product 1 is created. Since the semifinished product 1 uses the chemical solution 2 as shown in FIG. 7A, the expiration dates of the semifinished product 1 and the chemical solution 2 in the inventory data are compared. Specifically, when the production completion date of the semi-finished product 1 is “2014/03/31”, the expiration date of the semi-finished product 1 is “36 months” with reference to the item master 106a. The expiration date of the semi-finished product 1 is 2017/03/31 in a normal case.

  Referring to the stock data of the chemical solution 2, since the expiration date of the chemical solution 2 is “2016/12/31”, the expiration date of the chemical solution 2 is shorter, so the expiration date of the semi-finished product 1 is “2016/12/31”. 31 ". FIG. 8B shows an example of the inventory data of the semi-finished product 1, and “2016/12/31” is adopted as the expiration date of the inventory data of the semi-finished product 1.

  When product A is completed, acceptance input is performed to create inventory data for product A. As shown in FIG. 8C, the product A has a two-layer structure, and includes the semi-finished product 1 (chemical solution 2), the chemical solution 1, and the chemical solution 3. Therefore, the expiration date of the product A and the semi-finished product 1 The expiration dates of the stock data of the chemical solution 1 and the chemical solution 2 are compared. Specifically, as shown in FIG. 8D, when the production completion date of the product A is “2014/03/31”, the expiration date of the product A is determined by referring to the item master 106a. Since it is “36 months”, the expiration date of the product A is “2017/03/31” in a normal case.

  Referring to the inventory data, the expiration date “2016/12/31” of the semi-finished product 1, the expiration date “2017/02/28” of the chemical solution 1, and the expiration date “2017/01/31” of the chemical solution 2 The expiration date of A is the expiration date “2016/12/31” of the semi-finished product 1 with the shortest expiration date.

  FIG. 8E shows an example of the inventory data of the product A, and “2016/12/31” is adopted as the expiration date of the inventory data of the product A.

  As described above, according to the present embodiment, at least the product master 106a for registering the product in association with its expiration date, the product, the semi-finished product, the member, and / or the product constituting the product. If the product includes a chemical solution as a component by referring to the item master 106a and the product configuration master 106b when the manufacture of the product is completed with reference to the product configuration master 106b for registering the chemical solution in association with each other, An expiration date calculation unit 102b that compares the expiration date with the expiration date of the chemical contained in the component of the product and automatically sets the shorter expiration date as the expiration date of the product. When the manufacturing of the product is completed, if the product has a chemical as a component, the expiration date of the product can be set automatically, which can improve work efficiency and prevent input errors. To become. Moreover, it becomes possible by using a chemical | medical solution with a short expiration date preferentially for a product to prevent the fall of the yield of a chemical | medical solution with a short expiration date.

  In addition, according to the present embodiment, when the member and / or the chemical solution is received, the inventory data including the inventory quantity and the expiration date is created, and the inventory data is created when the production of the product is completed. When the product includes a chemical solution as a component, the expiration date calculation unit 102b includes the expiration date of the stock data of the chemical solution, the production completion date of the product + the item master 106a Compared with the validity period of a product, the shorter expiration date is set as the expiration date of the inventory data of the product, so it is possible to automatically set the expiration date of the product inventory data. .

  Further, according to the present embodiment, the item master 106a further registers and registers the semi-finished product and its expiration month, and the product configuration master 106b further configures the semi-finished product and the semi-finished product. When the first member and / or the second member are registered in association with each other and the expiration date calculation unit 102b automatically sets the expiration date of the product, the semi-finished product including the second member as a component is In some cases, since the comparison is made with the expiration date of the semi-finished product, the expiration date of the product can be automatically set even when the product configuration image has two layers.

[4. Other Embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments 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 performed manually, or all of the processes described as being performed manually are all performed. Alternatively, a part can be automatically performed by a known method.

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

  In addition, regarding the expiration date calculating apparatus 100, each illustrated component is functionally conceptual and does not necessarily need to be physically configured as illustrated.

  For example, all or some of the processing functions provided in the expiration date calculating apparatus 100, particularly the processing functions performed by the control unit 102, are realized by a CPU and a program interpreted and executed by the CPU. It may also be realized as hardware by wired logic. The program is recorded on a non-transitory computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the processing described in the present embodiment, and an expiration date is calculated as necessary. It is mechanically read by the device 100. In other words, in a storage unit such as a ROM or a HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

  Further, this computer program may be stored in an application program server connected to the expiration date calculation device 100 via an arbitrary network, and may be downloaded in whole or in part as necessary. It is.

  In addition, a 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 “recording medium” refers to a memory card, USB (Universal Serial Bus) memory, SD (Secure Digital) card, flexible disk, magneto-optical disk, ROM, EPROM (Erasable Programmable Read Only Memory), EEPROM (registration). Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Digital, Trademark) Any “portable physical media It is intended to include.

  The “program” is a data processing method described in an arbitrary language or description method, and may be in any form such as source code or binary code. Note that the “program” is not necessarily limited to a single configuration, and functions are achieved in cooperation with a separate configuration such as a plurality of modules and libraries or a separate program represented by the OS. Including things. In addition, a well-known structure and procedure can be used about the specific structure and reading procedure for reading a recording medium in each apparatus shown to embodiment, the installation procedure after reading, etc.

  Various databases and the like stored in the storage unit 106 are storage devices such as a memory device such as a RAM and a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. Programs, tables, databases, web page files, and the like.

  The expiration date calculating apparatus 100 may be configured as an information processing apparatus such as a known personal computer or workstation, or may be configured as the information processing apparatus connected to an arbitrary peripheral device. The expiration date calculation apparatus 100 may be realized by installing software (including a program or data) that realizes the processing described in this embodiment in the apparatus.

  Furthermore, the specific form of distribution / integration of the devices is not limited to that shown in the figure, and all or a part of them may be functionally or physically in arbitrary units according to various additions or according to functional loads. It can be configured to be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and may be selectively implemented.

100 Expiration date calculation device
102 Control unit
102a Inventory data creation part
102b Expiration date calculation unit
102c Master maintenance department
104 Communication interface
106 Storage unit
106a Material master
106b Product configuration master
106c Inventory data file
108 Input / output interface
112 Input device
114 Output device 200 Server 300 Network

Claims (6)

A material master that registers and associates at least the product with its expiration month,
A product configuration master that registers and associates a product with a semi-finished product, a first member without an expiration date, and / or a second member with an expiration date that constitutes the product;
When the manufacture of a product is completed, referring to the item master and the product configuration master, if the product includes the second member as a component, the expiration date of the product and the component of the product An expiration date calculating means for automatically setting the shorter expiration date as the expiration date of the product by comparing the expiration date of the contained chemical solution,
An expiration date calculating device comprising: Inventory data including inventory quantity and expiration date when the first member and / or the second member is received, and inventory data when the product is completed With creation means,
When the product includes the second member as a component, the expiration date calculation means calculates the expiration date of the inventory data of the second member, the date of completion of manufacture of the product + the product master of the item master The expiration date calculation device according to claim 1, wherein the expiration date is compared with the expiration date and the shorter expiration date is set as the expiration date of the inventory data of the product. The item master further registers the semi-finished product and its expiration month in association with each other,
The product configuration master further registers a semi-finished product in association with the first member and / or the second member constituting the semi-finished product,
The expiration date calculating means, when automatically setting the expiration date of the product, compares with the expiration date of the semi-finished product when there is a semi-finished product including the second member as a component. The expiration date calculation apparatus according to claim 1 or 2.   The expiration date calculating apparatus according to claim 1, wherein the second member is a chemical solution. An expiration date calculation method executed by an information processing apparatus including a control unit and a storage unit,
The storage unit
A material master that registers and associates at least the product with its expiration month,
A product configuration master that registers and associates a product with a semi-finished product, a first member without an expiration date, and / or a second member with an expiration date that constitutes the product;
With
Executed by the control unit,
When the manufacture of a product is completed, referring to the item master and the product configuration master, if the product includes the second member as a component, the expiration date of the product and the component of the product An expiration date calculation method comprising an expiration date calculation step of automatically setting a shorter expiration date as an expiration date of the product by comparing the expiration dates of the contained chemical solutions. An expiration date calculation program for causing an information processing apparatus including a control unit and a storage unit to execute,
The storage unit
A material master that registers and associates at least the product with its expiration month,
A product configuration master that registers and associates a product with a semi-finished product, a first member without an expiration date, and / or a second member with an expiration date that constitutes the product;
With
When the manufacture of a product is completed, referring to the item master and the product configuration master, if the product contains a chemical solution as a component, the expiration date of the product and the chemical solution contained in the component of the product An expiration date calculation program for causing the control unit to execute an expiration date calculation step of automatically setting a shorter expiration date as an expiration date of the product by comparing the expiration dates.

Images