JP4304107B2 - Inventory management system and inventory management program - Google Patents

Description

  The present invention relates to an inventory management system for inventory management of a lot of articles in lot units and each article unit, and an inventory management program incorporated in the inventory management system.

For example, in various manufacturing factories including semiconductor manufacturing factories, inventory management of various items such as parts and products sequentially manufactured in the factories is an important task. In an inventory management system that specially implements such inventory management, generally, a large number of articles are inventory-managed in units of lots and units of articles. As a function required for such an inventory management system,
The latest stock status of lot units and the current status of each product unit at the present time. History of stock status from the past to the current time of each lot unit and each product unit. Examples include storing and retrieving event histories of various events.

  Therefore, in an inventory management system constituted by a kind of computer, for example, the above-described current inventory status, inventory status history, and event history are stored in a database configured in the HDD. Then, an operator (operator) inputs various events related to inventory management such as inventory acceptance, change, and condition change, and performs a change (update) operation on the current inventory state.

  When an event input operation and a change (update) operation on the current inventory status are performed by an operator (operator), a new history is automatically added to the inventory status history.

As a related technique, Patent Document 1 proposes a production system for manufacturing a semiconductor device.
JP 2000-12414 A

As described above, when a change (update) operation is performed on the current stock status, a new history is additionally registered in the stock status history in a relatively short time.
However, after an operator (operator) once performs an event input operation and a change (update) operation with respect to the current inventory status, the operator may find that the change (update) operation is incorrect. In such a case, the operator (operator) may perform an operation of changing the current stock state after the change to the stock state before the change.

  However, since this operation was performed twice consecutively when viewed by a third party later, whether the normal change was performed twice consecutively or a change (update) cancellation operation was performed I can't tell if

It is theoretically possible to return the current inventory status and history of inventory status to the state before the change only by an instruction to cancel the change by the operator (operator). Processing time was required.
Further, in the conventional inventory management system, a large storage capacity is necessary to store and hold the history of inventory status.

  The present invention has been made in view of such circumstances, and is stored and held in the event history as an event of change cancellation only by an instruction of change cancellation by an operator (operator), and the current inventory state and inventory in a short time. It is an object of the present invention to provide an inventory management system and an inventory management program that can return the state history to the state before the change, increase the speed, and reduce the necessary storage capacity.

  In order to solve the above problems, in the inventory management system of the present invention, a current lot information table storing the current inventory status of a lot composed of a plurality of articles, and the current inventory status of each article constituting the lot A plurality of current article information tables for storing information, an event history table for storing and holding event information related to inventory management in a time series, and a lot history indicating stock status at each update of the current lot information table in a time series A lot information history table for storing and holding, an article information history table for storing and holding an article history indicating stock status at the time of each update of the current article information table, a lot input from the outside, and In response to a change instruction related to inventory management for each item, additional change event information is registered in the event history table. Update processing means for updating the contents of the product information table and the current article information table, additionally registering the lot history in the lot information history table, and additionally registering the article history in the article information history table, and change cancellation input from the outside In response to the instruction, change cancellation event information is additionally registered in the event history table, and the previous lot history stored in the lot information history table and the previous article stored in the article information history table are stored. Change cancellation processing means for returning the contents of the current lot information table and the current article information table to the state before the change using the history is provided.

  Further, according to another invention, in the inventory management system of the invention described above, the change processing means writes an event history number for identifying event information to be additionally registered this time in the current lot information table and the current article information table, and is added this time. The event history number for identifying the event information to be registered and the previous event history number for identifying the event information that has been additionally registered last time are written in the lot history and article history to be additionally registered.

  Based on the event history number written in the current lot information table and the current article information table, the event history number written in the lot information history table and the article information history table, and the previous event history number, The previous lot history and the previous article history are specified.

  Furthermore, in another invention, in the inventory management system of the invention described above, the article is a wafer.

  Another invention includes a current lot information table that stores a current stock status of a lot configured with a plurality of articles, a plurality of current product information tables that stores a current stock status of each article constituting the lot, An event history table for storing and holding event information related to inventory management in time series, and a lot information history table for storing and holding lot history indicating inventory status at the time of each update of the current lot information table in time series This is an inventory management program incorporated in an inventory management system having an article information history table for storing and holding an article history indicating an inventory status at each update of the current article information table in a time series.

  Then, the inventory management program registers the changed event information in the event history table in response to a change instruction regarding the inventory management of the lot and each article input from the outside, and the current lot information table and the current lot information table In accordance with the change processing means for updating the contents of the article information table, additionally registering the lot history in the lot information history table, and additionally registering the article history in the article information history table, and the change cancellation instruction input from the outside, Use the previous lot history stored in the lot information history table and the previous article history stored in the article information history table to register the event information for change cancellation in the event history table. As a change cancellation processing means for returning the contents of the lot information table and the current article information table to the state before the change. Make.

  According to another invention, in the inventory management program of the invention described above, the change processing means writes an event history number for identifying event information to be additionally registered this time in the current lot information table and the current article information table, and is added this time. The event history number for identifying the event information to be registered and the previous event history number for identifying the event information that has been additionally registered last time are written in the lot history and article history to be additionally registered.

  Based on the event history number written in the current lot information table and the current article information table, the event history number written in the lot information history table and the article information history table, and the previous event history number, The previous lot history and the previous article history are specified.

  In the inventory management system and the inventory management program configured as described above, only the change cancellation instruction from the operator (operator) is left in the event history as a change cancellation event, and the current inventory status and inventory status are quickly displayed. The history can be returned to the state before the change, the speed can be increased, and the necessary storage capacity can be reduced.

Hereinafter, an embodiment of the present invention will be described with reference to the drawings.
FIG. 1 is a block diagram showing a schematic configuration of an inventory management system in which an inventory management program according to an embodiment of the present invention is incorporated. This inventory management system is composed of a kind of information processing apparatus such as a computer.

  The inventory management system of this embodiment performs inventory management of wafers as articles that are the basis of semiconductor chips in a semiconductor manufacturing factory. Specifically, one lot is composed of 25 wafers, and inventory management is performed in lot units and wafer units. Incidentally, 40 semiconductor chips can be manufactured with one wafer as a reference. Therefore, 1000 semiconductor chips can be manufactured in one lot.

  In FIG. 1, the inventory management system includes an input operation unit 1 such as a keyboard for an operator (operator) to input various instructions such as a search instruction, a change instruction, and a change cancellation instruction, and the type of processing corresponding to the instruction. The processing determination unit 2 for determination, the processing unit 3 formed on the application program, the display unit 4, the database 5 formed in the HDD, and the like are included.

  In the processing unit 3, an inventory information search processing unit 6, a history information search processing unit 7, a lot information change processing unit 8, a lot information wafer information change processing unit 9, a change cancellation processing unit 10, and the like are provided.

  In the database 5, a current data area 11 and a history data area 12 are roughly divided. In the current data area 11, a current lot information table 13 for storing the current stock status of a lot consisting of 25 wafers, and 25 current wafers for storing the current stock status of the wafers constituting this lot. An information table 14 is formed.

  In the current lot information table 13, as shown in FIG. 2, the lot ID, product name, manufacturing flow, inventory process, number of wafers, number of non-defective products out of the number of semiconductor chips that can be manufactured in this lot, etc. And an event history NO that specifies event information at the time when the inventory status is obtained are stored.

  As shown in FIG. 3, each current wafer information table 14 includes a lot ID, a slot number, a wafer ID for specifying the wafer, a product name, a manufacturing flow, and a non-defective product out of the number of semiconductor chips that can be manufactured on the wafer. An inventory status consisting of the number, the number of defective products, and the like, and an event history NO specifying event information at the time when the inventory status is obtained are stored.

  In the history data area 12, an event history table 16 for storing and holding event information 15 relating to inventory management in time series, and a lot history 17 indicating the inventory status at the time of each update of the current lot information table 13 are time-series. 25 wafer information history tables 20 for chronologically storing and holding a lot information history table 18 for storing and holding the wafer history 19 and a wafer history 19 indicating the inventory status at each update of each current wafer information table 14 And are formed.

  As shown in FIG. 4A, the event information 15 is mainly input by the operator (operator) via the input operation unit 1 such as “acceptance”, “chip number change”, “chip number change cancellation” related to inventory management. Indicates items related to specific instructions for changes and cancellations. Specifically, this event information 15 is composed of an event and a lot ID, and as shown in FIG. 4B, an event history NO that is sequentially updated is attached, and the event history table 16 is time-sequentially. Added and written.

  As shown in FIG. 7, the current lot information table 13 generates, for example, event information 15 of process change (PROC01 → PROC02) from the initial state of [A], and change of the number of chips of [C] ( The stored contents are updated (changed) each time the event information 15 is generated (number of chips 40 → 30) of the wafer of slot NO = 1, and the event information 15 is generated to cancel the change in the number of chips [D].

  Similarly, as shown in FIG. 7, each current wafer information table 14 generates, for example, [B] process change event information 15 generated from [A] initial state, and [C] chip number change event information. Whenever 15 occurrences, [D] chip number change cancellation event information 15 occurrences, etc., the stored contents are updated (changed). FIG. 7 shows only the current wafer information table 14 with the wafer ID = AAAAA-01 among the 25 current wafer information tables 14.

  In principle, every time new event information 15 is generated and this new event information 15 is additionally registered in the event history table 16, the contents of the current lot information table 13 and each current wafer information table 14 are updated. However, if the new event information 15 is the event information 15 of [B] process change (PROC01 → PROC02) as shown in FIG. Currently, the contents of the wafer information table 14 are not updated.

  As shown in FIG. 5, the lot history 17 includes inventory status including lot ID, product name, manufacturing flow, inventory process, number of wafers, number of non-defective products, number of defective products, etc., and event information at the time when this inventory status is obtained. The event history NO to be specified and the previous event history NO of the lot history 17 are added and written in the lot information history table 18 in time series as shown in FIG.

  As shown in FIG. 6, each wafer history 19 includes a stock status composed of a lot ID, a slot number, a wafer ID, a product name, a manufacturing flow, the number of non-defective products, the number of defective products, etc., and event information when the stock status is obtained. 9 and the previous event history NO of the wafer history 19 are added and written in the wafer information history table 20 in time series as shown in FIG.

  In principle, each of the 25 wafer histories 19 is generated as new wafer history 19 each time new event information 15 is generated and this new event information 15 is additionally registered in the event history table 16. , It is additionally registered in the wafer information history table 20 to which it belongs. However, if the new event information 15 does not change the contents of the current wafer information table 14 corresponding to itself, a new wafer history 19 is not generated, so a new wafer is added to the wafer information history table 20 to which the new event information 15 belongs. The history 19 is not registered.

  For example, as shown in FIG. 7 and FIG. 9, since the event information 15 of [B] process change (PROC01 → PROC02) is a process change in lot units, a new wafer history 19 does not occur. The new wafer history 19 is not registered in the wafer information history table 20.

  In addition, when the event information for changing the number of chips in [C] is an instruction to change the number of chips for only the wafer in slot NO = 1 from [40] to [30] as shown in FIGS. A new wafer history 19 is registered only in the wafer information history table 20 with the wafer ID = AAAA-01. There is no need to register a new wafer history 19 in the other wafer information history table 20.

  Similarly, the event information for canceling the change in the number of chips in [D] is an instruction canceling the instruction to change the number of chips for only the wafer in slot NO = 1 from [40] to [30], as shown in FIGS. In this case, a new wafer history 19 is registered only in the wafer information history table 20 with the wafer ID = AAAA-01. There is no need to register a new wafer history 19 in the other wafer information history table 20.

  Each processing unit 6, 7, 8, 9, 10 of the processing unit 3 of the inventory management system in which a plurality of tables 13, 14, 16, 18, 20 having such a configuration is formed in the database 5 is shown in FIG. The inventory management process is performed according to the flowchart of FIG.

  When an operator (operator) inputs an operation instruction via the input operation unit 1 in the initial state of [A] described above for each table 13, 14, 16, 18, and 20 in the database 5 (step S1), The process determination unit 2 determines the type of process to be executed.

  When the input operation instruction is stock search (S2), the stock information search processing unit 6 is activated, and the contents of the current lot information table 13 or the current wafer information table 14 of the lot or wafer designated by the operator (operator). Is read from the database 5 and displayed on the display unit 4 (S3).

  When the input operation instruction is history search (S4), the history information search processing unit 7 is activated, and each lot information history table 18 or wafer information history table 20 of the lot or wafer designated by the operator (operator) is displayed. The lot history 17, each wafer history 19, and each event information 15 of the event history table 16 are read from the database 5 and displayed on the display unit 4 (S5).

  When the input operation instruction is, for example, a lot change instruction indicated by [B] process change (S6), the lot information change processing unit 8 is activated to execute the lot information change process shown in FIG. 11 (S7). In FIG. 11, new event information 15 of “acceptance” for changing the specified lot ID is created, and the new event history NO is updated to the event history NO of the previous event information 15 with this new event information 15. Is added and registered in the event history table 16 as shown in FIG. 4 (Q1).

  Next, as shown in FIG. 7, the contents of the current lot information table 13 are changed to the contents instructed to operate (process PROC01 → PROC02). Then, the event history NO of the current lot information table 13 is updated to the event history NO of the event information 15 additionally registered in the current event history table 16 (Q2).

  Next, as shown in FIG. 8, the lot information 17 that has been additionally registered in the previous time in the lot information history table 18 is changed to the contents instructed to operate (process PROC01 → PROC02) as the new lot history 17, and the lot information It is additionally registered in the history table 18. In this case, the event history NO of the lot history 17 additionally registered last time is written in the new lot history 17 as the previous event history NO. Further, the event history NO of the new event information 15 this time is written in the new lot history 17 (Q3). And it returns to the flowchart of FIG.

  In S8 in FIG. 10, when the input operation instruction is, for example, a lot / wafer change instruction indicated by changing the number of chips [C], the lot information wafer information change processing unit 9 is activated and the lot information shown in FIG. Wafer information change processing is executed (S9). In FIG. 12, a new event information 15 for changing the specified number of chips is created, and a new event history NO obtained by updating the event history NO of the previous event information 15 is attached to the new event information 15. As shown in FIG. 4, the event history table 16 is additionally registered (R1).

  Next, as shown in FIG. 7, the contents of the current lot information table 13 are changed to values based on the contents instructed to operate (number of non-defective products 1000 → 990). Then, the event history NO in the current lot information table 13 is updated to the event history NO of the event information 15 additionally registered in the current event history table 16 (R2).

  Next, as shown in FIG. 8, a lot history 17 additionally registered last time in the lot information history table 18 is changed to a content instructed to operate (number of non-defective products 1000 → 990) as a new lot history 17. It is additionally registered in the information history table 18. In this case, the event history NO of the lot history 17 additionally registered last time is written in the new lot history 17 as the previous event history NO. Further, the event history NO of the new event information 15 this time is written in the lot history 17 (R3).

  As shown in FIG. 7, the contents of the current wafer information table 14 with the wafer ID = AAAAA-01 are changed to values based on the contents instructed to operate (number of non-defective products 40 → 10). Then, the event history NO of the corresponding current wafer information table 14 is updated to the event history NO of the event information 15 additionally registered in the current event history table 16 (R4). In this case, each current wafer information table 14 other than the current wafer information table 14 with the wafer ID = AAAAA-01 is not updated.

  Next, as shown in FIG. 9, the wafer history 19 additionally registered last time in the wafer information history table 20 with the wafer ID = AAAA-01 is changed to the content instructed to operate (number of non-defective products 40 → 30). Are additionally registered in the wafer information history table 20. In this case, the event history NO of the wafer history 19 additionally registered last time is written in the new wafer history 19 as the previous event history NO. Further, the event history NO of the new event information 15 this time is written in the wafer history 19 (R5). In this case, a new wafer history 19 is not additionally registered in each wafer information history table 20 other than the wafer information history table 20 of wafer ID = AAAAA-01. And it returns to the flowchart of FIG.

  In S10 in FIG. 10, when the input operation instruction is, for example, [D] chip number change cancellation instruction, the change cancellation processing unit 10 is activated to execute the change cancellation process shown in FIG. 13 (S11). In FIG. 13, the new event information 15 of change cancellation shown in FIG. 4 is created, and a new event history NO that updates the event history NO of the previous event information 15 is attached to the new event information 15. As shown in FIG. 4, the event history table 16 is additionally registered (P1).

  Next, the lot history 17 having the event history NO corresponding to the event history NO in the current lot information table 13 is read from the lot information history table 18 shown in FIG. 8 (P2). The previous lot history 17 having the event history NO corresponding to the previous event history NO written in the read lot history 17 is read from the lot information history table 18 shown in FIG. 8 (P3). Then, the contents of the current lot information table 13 are updated with the previous lot history 17. That is, at this time, the state before the change is restored in the current lot information table 13. A new event history NO additionally registered in the event history table 16 is written in the current lot information table 13 (P4).

  Next, the previous lot history 17 in which the state before the change is stored is additionally registered in the lot information history table 18 as a new lot history 17. In this case, the event history NO is the new event history NO additionally registered in the event history table 16, and the previous event history NO is the event history NO previously registered in the event history table 16 (P5).

  Next, the wafer history 19 having the event history NO corresponding to the event history NO in the current lot information table 13 before the change is searched from the wafer information history table 20 shown in FIG. 9 (P6). If not retrieved (P7), it is determined that there was no change to be canceled for each wafer, the change cancellation process is terminated, and the flow returns to the flowchart of FIG.

  When a wafer history 19 having an event history NO corresponding to the event history NO in the current lot information table 13 before the change is retrieved from the wafer information history table 20 (P7), the wafer history 19 that has been retrieved (read) is written. The previous wafer history 19 having the event history NO corresponding to the previous event history NO is read from the wafer information history table 20 shown in FIG. 9 (P8).

  Then, the contents of the current wafer information table 14 of the corresponding wafer ID are updated with the previous wafer history 19. That is, at this time, the state before the change is restored in the current wafer information table 14 of the corresponding wafer ID. The new event history NO additionally registered in the event history table 16 is written in the current wafer information table 14 of the corresponding wafer ID (P9).

  Next, the previous wafer history 19 in which the state before the change is stored is additionally registered in the wafer information history table 20 of the corresponding wafer ID as a new wafer history 19. In this case, the event history NO is the new event history NO additionally registered in the event history table 16, and the previous event history NO is the event history NO previously registered in the event history table 16 (P10). And it returns to the flowchart of FIG.

  In the inventory management system of the embodiment configured as described above, the database 5 includes a current lot information table 13 for storing the current inventory status, and a plurality of current wafer information tables for storing the current inventory status of each wafer. 14, an event history table 16, a lot information history table 18, and a wafer information history table 20 are formed.

  When various change instructions indicated by, for example, [B] and [C] described above are input from the input operation unit 1, event information 15 of the change instructions is sequentially stored and held in the event history table 16 in time series. In addition, the stored contents of the current lot information table 13 and each current wafer information table 14 are sequentially updated. Further, a new lot history 17 and a new wafer history 19 are additionally registered sequentially in the lot information history table 18 and the wafer information history table 20.

  In this case, since a new lot history 17 and a new wafer history 19 corresponding to lots and wafers not corresponding to the change instruction do not occur, the storage capacity of the lot information history table 18 and each wafer information history table 20 can be greatly reduced. .

  Further, in the lot history 17 and the wafer history 19 sequentially added and registered in the lot information history table 18 and the wafer information history table 20, an event for specifying the cause (change contents) of the lot history 17 and the wafer history 19 is specified. In addition to the history NO, a previous event history NO for specifying the previous lot history 17 and wafer history 19 in which the instruction content before the change is stored is stored.

  Therefore, when a change cancel instruction indicated by [D] described above is input from the input operation unit 1, for example, the previous lot history 17 and wafer history 19 storing the lot before change and the management state of each wafer can be easily obtained. Since the search can be performed, the processing time required to cancel the change can be shortened. As a result, the processing speed of the entire inventory management system can be increased.

  In addition, since the event information 15 “cancel change” is registered in the event history table 16, a third party other than the operator (operator) can easily grasp this “cancel change” later.

  In addition, this invention is not limited to embodiment mentioned above. In the system of the embodiment, the article to be inventory managed is a wafer, but is not limited to a wafer.

The block block diagram which shows schematic structure of the inventory management system in which the inventory management program concerning one Embodiment of this invention was integrated The figure which shows the memory content of the present lot information table formed in the database of the inventory management system of the embodiment The figure which shows the memory content of the present wafer information table formed in the database of the inventory management system of the embodiment The figure which shows the memory content of the event history table formed in the database of the inventory management system of the embodiment The figure which shows the memory content of the lot history formed in the database of the inventory management system of the embodiment The figure which shows the memory content of the wafer history formed in the database of the inventory management system of the embodiment The figure which shows the update contents of the present lot information table and the current wafer information table which were formed in the database of the inventory management system of the embodiment The figure which shows the memory content of the lot information history table formed in the database of the inventory management system of the embodiment The figure which shows the memory content of the wafer information history table formed in the database of the inventory management system of the embodiment A flowchart showing an inventory management operation of the inventory management system of the embodiment Flow chart showing the lot information change processing operation of the inventory management system of the embodiment Flow chart showing the lot information and wafer information change processing operation of the inventory management system of the embodiment Flow chart showing change cancellation processing operation of the inventory management system of the embodiment

Explanation of symbols

  DESCRIPTION OF SYMBOLS 1 ... Input operation part, 2 ... Process determination part, 3 ... Processing part, 4 ... Display part, 5 ... Database, 6 ... Inventory information search process part, 7 ... History information search process part, 8 ... Lot information change process part, DESCRIPTION OF SYMBOLS 9 ... Lot information wafer information change process part, 10 ... Change cancellation process part, 11 ... Current data area, 12 ... History data area, 13 ... Current lot information table, 14 ... Current wafer information table, 15 ... Event information, 16 ... Event history table, 17 ... lot history, 18 ... lot information history table, 19 ... wafer history, 20 ... wafer information history table

Claims (5)

A current lot information table for storing the current stock status of a lot composed of a plurality of articles;
A plurality of current article information tables for storing the current inventory status of each article constituting the lot;
Event history table for storing and holding event information related to inventory management in time series,
A lot information history table for storing and holding a lot history indicating stock status at the time of each update of the current lot information table;
An article information history table for storing and holding an article history indicating stock status at the time of each update of the current article information table;
In response to a change instruction relating to inventory management of a lot and each article inputted from the outside, change event information is additionally registered in the event history table, and the contents of the current lot information table and the current article information table are updated. Change processing means for additionally registering the history in the lot information history table, and additionally registering the article history in the article information history table;
In response to an externally input change cancellation instruction, change cancellation event information is additionally registered in the event history table, and the previous lot history stored in the lot information history table and the article information history table are stored. An inventory management system comprising: a change cancellation processing means for returning the contents of the current lot information table and the current item information table to a state before the change by using the previous item history stored and held. The change processing means writes an event history number for specifying event information to be additionally registered this time in the current lot information table and the current article information table, and an event history number for specifying event information to be additionally registered this time and the previous additional registration. Write the previous event history number that identifies the event information that has been added to the lot history and article history to be additionally registered,
The change cancellation processing means is based on the event history number written in the current lot information table and the current article information table, the event history number and the previous event history number written in the lot information history table and the article information history table. The inventory management system according to claim 1, wherein the previous lot history and the previous article history are specified.   The inventory management system according to claim 1, wherein the article is a wafer. A current lot information table for storing the current inventory status of a lot composed of a plurality of articles, a plurality of current article information tables for storing the current inventory status of each article constituting the lot, and event information related to inventory management Event history table for storing and holding time series, lot information history table for storing and holding lot history indicating stock status at the time of each update of the current lot information table, and the current article In an inventory management program incorporated in an inventory management system having an article information history table for storing and holding an article history indicating an inventory state at each update of the information table in time series,
Computer
In response to a change instruction relating to inventory management of a lot and each article inputted from the outside, change event information is additionally registered in the event history table, and the contents of the current lot information table and the current article information table are updated. Change processing means for additionally registering the history in the lot information history table, and additionally registering the article history in the article information history table;
In response to an externally input change cancellation instruction, change cancellation event information is additionally registered in the event history table, and the previous lot history stored in the lot information history table and the article information history table are stored. An inventory management program that functions as change cancellation processing means for returning the contents of the current lot information table and the current item information table to the state before change using the previous item history stored and held. The change processing means writes an event history number for specifying event information to be additionally registered this time in the current lot information table and the current article information table, and an event history number for specifying event information to be additionally registered this time and the previous additional registration. Write the previous event history number that identifies the event information that has been added to the lot history and article history to be additionally registered,
The change cancellation processing means is based on the event history number written in the current lot information table and the current article information table, the event history number and the previous event history number written in the lot information history table and the article information history table. The inventory management program according to claim 4, wherein the previous lot history and the previous article history are specified.

Images