JP2009048594A - Global article data, article management program, and device operated by the program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide global article data which appropriately associates article codes of different forms. <P>SOLUTION: The global article data 110 include article codes 112 as identifiers of articles and attribute information 114 which indicates the attributes of the articles. The attribute information 114 has a plurality of attribute items A, B, ..., and attribute data set to at least one C of the attribute items are represented by a logical equation which includes attribute values. A plurality of local article data, which include local article codes 122 and attribute information 123, are each collected from databases of a plurality of production plants, respectively. Then, the global article data 110, which include the attribute information 114 corresponding to the attribute information 123 included in the collected local article data collected from among a plurality of global article data which are preliminarily stored, are correlated with the local article codes 122 included in the local article data. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to a technique for linking and managing a local item code as an item identifier defined in each manufacturing plant for each of a plurality of manufacturing factories.

  Conventionally, as a method for managing products, “item codes” such as product codes are used as identifiers.

  In general, manufacturers that operate in various countries around the world generally construct manufacturing plants in countries and regions where parts procurement costs and labor costs are low in order to reduce manufacturing costs, and manufacture products at those factories. Is. This is particularly noticeable in business fields such as digital home appliances that survive by frequently offering new products with superior functionality and high cost performance to other companies' products. In particular, when units made at multiple manufacturing plants around the world are made into products at multiple final assembly plants and sold to customers in each country, factories with functions such as product design and sales management in addition to production and parts procurement (here Is called `` IDM '' which means a factory that integrates functions required for manufacturing vertically) and a factory specialized in production and parts procurement (here called `` Foundry '' which means a factory specializing in manufacturing). It is common for products to be created through collaboration. In this case, after IDM grasps the global supply and demand situation, IDM allocates the planned production volume of all factories including Foundry, and each factory manufactures products by arranging parts from appropriate parts manufacturers based on that. To do. The finished product is sold to customers around the world through IDM. This general production operation is called the global supply chain here.

  In this global supply chain, IDM and Foundry each make their own daily production / shipment plans based on the planned production volume for each factory determined by IDM, while ordering parts and managing delivery times so that they can be met. Manufacture products. At this time, in order to facilitate the production management at the own factory, the product code unit and unit code unit numbered by "detailed meaning ()" such as the difference in the procurement source handled at the own factory and the difference in product performance, A bill of materials (BOM) that creates a hierarchical list of parts to be incorporated into a product or unit is created. The “item code” used in this BOM often has a fixed format for each manufacturing plant.

  As described above, when the item code format is different for each manufacturing factory, IDM increases the man-hours for inventory management of products and units over a plurality of factories and for identifying the bill of materials to be changed when the design is changed.

  Therefore, as a method for associating codes of different formats, there are methods described in Patent Documents 1 and 2 below.

  In Patent Document 1, a code of another format is left as it is, and a code of a new format is retained in the system as an internal code, and the code of another format is uniquely managed without showing this internal code to the system user. A method is disclosed.

  Further, Patent Document 2 discloses a method of associating codes of different formats by utilizing attribute information such as products indicated by codes, regardless of code conversion. Specifically, as attribute information related to the performance etc. of the product etc. indicated by the item code of a certain factory, a plurality of attribute items are provided, and for each attribute item, one numerical value indicating the degree etc. is set. Yes.

Japanese Patent Laid-Open No. 10-171866 JP 2007-26426 A

  However, in the method disclosed in Patent Document 1, since the number of item codes handled increases as the number of manufacturing factories increases, it is necessary to design an internal code format in anticipation of the increase, and this format design is troublesome. When the item code increases beyond the assumption at the time of design, the internal code number overflows, and there is a problem that unique code management becomes impossible.

  Further, in the method disclosed in Patent Document 2, since codes of different formats are associated with each other in attribute information, the method disclosed in Patent Document 1 such as an overflow of an internal code number accompanying an increase in manufacturing factories. However, it is difficult to establish a correspondence between the attribute information of the product etc. indicated by the code of one factory and the attribute information of the product etc. indicated by the code of the other factory. If the products cannot be associated, or the products indicated by the codes in different formats have substantially the same performance and are supposed to be the same type, they may be handled as different types of products. There is a problem that it often occurs.

  Therefore, the present invention provides a global item data, an item management program, and a device that operates according to this program, which can easily cope with an increase in the number of manufacturing factories and can appropriately associate codes of different formats. Objective.

In order to solve the above problems, in the present invention,
As global item data for the computer to manage the local item code as the item identifier specified in each manufacturing plant for each of the multiple manufacturing factories,
An item code as an item identifier, and attribute information indicating an attribute of the item,
The attribute information includes a plurality of attribute items, and attribute data related to the attribute item is set in each of the plurality of attribute items, and is set in at least one attribute item of the plurality of attribute items. Attribute data is represented by a logical expression that includes attribute values.
Use data.

  Then, using the attribute information included in the global item data, for each of a plurality of manufacturing factories, a local item code as an item identifier defined in each manufacturing plant is associated with the global item code.

  According to the present invention, using the attribute information included in the global item data, for each of a plurality of manufacturing factories, a local item code as an item identifier defined in each manufacturing plant is used as a global item code. Therefore, even if the number of manufacturing factories increases, it can be easily handled. Moreover, since a logical expression is used as part of the attribute information, the attribute value can be set in various forms as compared with the case where only one numeric value or character is set as the attribute value of one attribute item. The item code of another format can be appropriately associated.

  In general, global management operations for manufacturing factories deployed around the world include the following.

  1) Supply and demand / production management business that adjusts the sales volume and order volume in each country / region and the production capacity of each manufacturing plant.

  2) Design change management work to find and change the bill of materials at each manufacturing plant when changing product specifications and manufacturing methods.

  3) Material procurement business that arranges bulk purchase arrangements to procure parts with the same specifications at low cost.

  4) Inventory management business that compares and evaluates the product inventory stored at each manufacturing plant and manages it so that the product inventory of the entire company is secured where necessary.

  As described above, these management tasks are performed by a factory having the role of IDM. The IDM factory categorizes products with a globally common "meaning" for parts lists that have been designed and operated and managed according to its own rules for each Foundry manufacturing factory. Managing the bill of materials is extremely important.

  Therefore, in the following, as an embodiment of an item management system for managing a parts list (hereinafter referred to as a local parts list) for each of a plurality of Foundry manufacturing factories deployed globally by an IDM that performs global management work. The parts table management system will be described.

  As shown in FIG. 1, the parts table management system of the present embodiment includes local parts table management servers 40a and 40b provided for each Foundry manufacturing factory, these local parts table management servers 40a and 40b, and a communication network N. And a global parts table management server 10 connected via the.

  The global BOM management server 10 has a global BOM table 33 in which a global BOM is stored. Each local parts table management server 40a, 40b has parts table databases 41a, 41b in which local parts tables are stored.

  Here, before describing the configuration of the global BOM management server 10, the global BOM and the local BOM will be described. Here, a case where the final product in IDM is a personal computer will be described as an example.

  As shown in FIG. 2, the global parts table managed by the global parts table management server 10 associates a personal computer as a final product with its component parts. As parts constituting the personal computer, there are a mother board, a keyboard, a liquid crystal panel, and the like. In addition, as components of the mother board, there are a CPU, a board and the like.

  In this global parts list, “Personal computer” as the final product, “Motherboard” and “Liquid crystal panel” as the parts, and “CPU” as the parts of the motherboard are associated with the item names 101, A global product item code 102 as an identifier thereof and a number 103 indicating the number of stocks and the like. These item name 101, global product item code 102, and number 103 constitute global product item data 100.

  For example, in the case of the item name “liquid crystal panel”, the global product item code is “48201234” and the number is “250”.

  The global product item code 102 is associated with global factory shipment item data 110 relating to the item of the factory shipment form that is a child item of the product or part indicated by the global product item code 102. The global factory shipment item data 110 is a child item of the product or part indicated by the global product item code 102, and includes a global factory shipment item code 112 as an identifier for an item in factory shipment form, a number 113 of this item, And attribute information 114 indicating attributes of the item. The attribute information 114 has a plurality of attribute items A, B,..., And attribute data is set in each attribute item A, B,.

  The global factory shipment item code 112 is associated with the local item code 122 of the item corresponding to the global factory shipment item code among the items manufactured at the Foundry manufacturing factory. The local item code 122 is associated with the local item code 122. The number 123 of items of the code 122 is associated. The association between the global factory shipment item code 112 and the local item code 122 is performed by a process described later by the global parts table management server 10.

  For example, in the case of the item name “liquid crystal panel”, three global factory shipment item codes “48201234NN01”, “48201234NN02”, and “48201234NN03” are associated with the global product item code “48201234”. Of these three global factory shipment item codes 112, 112, 112, for example, the first global factory shipment item code “48201234NN01” includes the number of items “150” and the attribute information “1, 2, OR of this item” (1,2), 2,2, ... "are associated. In addition, this global factory shipment item code “48201234NN01” is associated with two local item codes “1001J” and “ZA213”, and each local item code is associated with the number of items “100” and “150”. Yes. Here, the names of the items indicated by the three global factory shipment item codes “48201234NN01”, “48201234NN02”, and “48201234NN03” are all “liquid crystal panels”, although the types are different. Further, the name of the item indicated by the two local item codes “1001J” and “ZA213” is also “liquid crystal panel”.

  Here, it should be noted that the global factory shipment item code “48201234NN01” is associated with two local item codes “1001J” and “ZA213” having different formats, and the global factory shipment item code “ 48201234NN01 ”is that a logical expression is used for a part C of the plurality of attribute items A, B,...

  In this embodiment, since the item attribute information 114 indicated by the global factory shipment item code 112 is used for associating the global factory shipment item code 112 with the local item code 122 in this way, local item codes having different formats are used. 122 can be associated. Further, since a logical expression is used for a part C of the plurality of attribute information A, B,... Of the attribute information 114, as compared with the case where only one numerical value or character is set as the attribute value of one attribute item. The attribute values can be set in various forms, and the item codes of different formats can be appropriately associated.

  In the global BOM shown in FIG. 2, the item name 101 is included as the configuration data of the global product item data 100, but this is only for easy understanding of the configuration of the BOM. Not data.

  For example, as shown in FIG. 5, a local parts list managed by a local parts list management server 40a of a foundry manufacturing factory associates a liquid crystal panel, which is a final product in this factory, with its constituent parts. . Components constituting the liquid crystal panel include glass, a film applied to the glass, a spacer disposed between the two glasses, a liquid crystal, and a driver circuit. In addition, the components of the driver circuit include a memory, a resistor, and the like.

  In this local parts list, “Liquid Crystal Panel” as the final product, “Glass” and “Driver Circuit” as the parts, and “Memory” as the parts of the driver circuit are associated with the item name 201. , A local item code 202 as an identifier thereof, a number 203 indicating the stock quantity of the item, and attribute information 204 of the item. These item name 201, global product code 202, number 203, and attribute information 204 constitute local item data 200.

  For example, if the item name 201 is “LCD panel”, the item code in this factory, that is, the local item code 202 is “1001J” “1002J”, the number is “100” “50”, and the attribute information is “1,2” , 1,2,2, ... "" 2,2,3,2,1, ... ". These local item codes “1001J” and “1002J” correspond to the global factory shipment item codes “48201234NN01” and “48201234NN02” of “LCD panel” in FIG. Attached. Here, the number 203 is the number of stocks of the item, but it may be the used quantity of the item. For example, when the item name 201 is “glass”, the number used in the manufacture of the liquid crystal panel is two, so “2” may be set as the number 203.

  Next, the configuration of the global parts table management server 10 will be described again using FIG.

  The global BOM management server 10 is a computer, and includes an output device 11 such as a display, an input device 12 such as a keyboard, an input / output interface 13 of these input / output devices 11 and 12, a communication interface 14, and a work memory 15. And a CPU 20 that executes various processes, and a storage device 30 such as a hard disk drive.

  Functionally, the CPU 20 functionally associates a global item code with a local item code, and generates a new global item data when there is no global item data associated with the local item code. A new data creation unit 23 to be created, an item data collection unit 23 that collects local item data from each local parts table management server 40a, 40b, and an input / output control unit 24 that controls input / output by the input / output devices 11 and 12. And a communication control unit 25 that performs communication control for communicating with the outside via the communication network N. The storage device 30 stores an item management program 31. The CPU 20 implements the functions of the above-described functional units 21 to 25 by executing the item management program 31. The storage device 30 further stores a global item master table 32, a global parts table table 33, a semantic attribute master table 34, and a semantic attribute logical set table 35, which will be described later.

  The aforementioned code association processing unit 21 mainly has a function of associating a global item code with a local item code as described above. In other words, it has an update and reference function for the global BOM table 33 that stores the global BOM. Since the bill of materials generally has a hierarchical structure having a parent-child relationship of items, the update function has a function of registering a bill of material by associating other items with child items as child items. The reference function has a function of expanding only an arbitrary hierarchy and a function of expanding all hierarchies in the hierarchical data structure. Further, it has a function of selecting items by paying attention to a part of the parts table such as a certain item code and attribute. Furthermore, it has a function of adding up the number of child items and reflecting it in the number of parent items when expanded along the hierarchy of the parts table. The functions described above are based on database operations generally called drill-down or drill-up.

  The above-described new data creation unit 23 mainly has a function of generating global item data (to be described later) by assigning a global item code in the global bill of materials, and storing this global item data in the global item master table 32. Further, a new attribute item is provided in the attribute information, and a new attribute value to be included in the existing attribute item is given a meaning, and data addition, data update, data of the semantic attribute master table 34 and the semantic attribute logical set table 35 are performed. It has a function to delete. That is, the new data creation unit 23 has a function of adding, updating, and deleting data from the global item master table 32, the semantic attribute master table 34, and the semantic attribute logical set table 5.

  The global item master table 32 stores a plurality of global product item data 100 and a plurality of global factory shipment item data 110. That is, the configuration data of the global item master table 32 is different from the data stored in the global parts table shown in FIG. 2 except that there is no local item code 122 and data of the number 123 of items of the local item code 122. In addition, a plurality of items are not associated with each other.

  In the semantic attribute master table 34, as shown in FIG. 3, each attribute of the attribute information 114 included in the corresponding global shipment item data 110 (FIG. 2) for each product item, that is, for each global product item code 102. The meanings 130a, 130b, 130c,... Of items A, B, and C, and the meanings 131a, 131b, 131c,. Specifically, for example, the attribute item A of the attribute information 114 of the “liquid crystal panel” whose global product item code 102 is “48201234” indicates “glass production line name”, and the attribute value set in this item A Of these, “1” indicates “ABC line”, “2” indicates “ABD line”, and “3” indicates “ABE line”.

  In the semantic attribute logical set table 34, as shown in FIG. 4, the meanings of logical expressions used in the attribute information 114 are shown. The semantic attribute logical set table 34 includes, for each product item, that is, for each global product item code 102, a clear number column 141 in which a clear number is entered, a logical set condition column 142 in which a logical set condition including a logical expression is entered, And a semantic column 143 in which the meaning of the logical set condition is entered. The expression format of the “meaning” entered in the meaning column 143 may be a simple word combination or a free sentence format as shown in FIG. The “meaning” entered in the meaning column 143 is the meaning of the logical set condition from the viewpoint of the global supply chain.

  For example, in the location where the global product item code 102 is “48201234” and the CLIE number column 141 contains “1”, the logical set condition column 142 contains “(A = 1) and (C = 1 or 2)”. In the meaning column 143, “G = 1” line (ABC line) and “C = 1” model (Company A 01) or “C = 2” model (A "Combination with signal processing driver of company 03)".

  Next, the operation of the global parts table management server 10 of this embodiment will be described with reference to the flowchart shown in FIG.

  The item data collection unit 23 of the global BOM management server 10 activates the communication control unit 25 periodically or upon receipt of an instruction from the operator through the operation of the input device 12, and each local BOM management server 40a, A communication path is established with 40b, and the top item data of the local parts table is collected from these local parts table databases 41a and 41b (S10). For example, in the case of the local parts table shown in FIG. 5, the local item data 200 of the “liquid crystal panel” which is the highest level is collected.

  Next, the code association processing unit 21 of the global BOM management server 10 extracts one of the collected local item data 200 (S11), and this local item data is stored in the global BOM table 33. It is determined whether or not it is possible to correspond to any of the global factory shipment item data of the child items of the corresponding global product item in the stored global parts list (S12). The determination of whether or not it corresponds is attribute information 214 included in the extracted local item data 200 and attribute information 114 included in the global factory shipment item data 110 of the child item of the corresponding global product item. Judgment by whether or not.

  Specifically, the local item data 200 extracted in step 11 is, for example, as shown in FIG. 5, the item name 201 is “liquid crystal panel”, the local item code 202 is “1001J”, and the attribute information 204 is “1,1”. 2, 1, 2, 2,..., A plurality of global factory shipment items associated with the “liquid crystal panel” of the global product item corresponding to the local item data 200 in the global parts table shown in FIG. Whether data 110, 110, or 110 is supported is determined. In this case, since the attribute information 204 of the local item is “1,2,1,2,2,...”, A plurality of global factory shipment item data 110, associated with the “liquid crystal panel” in the global parts list. 110 and 110, the global factory shipment item code 112 is “48201234NN01” and the attribute information 114 is “1,2, OR (1,2), 2,2,... Judge that there is.

  When it is determined that the extracted local item data 200 and any of the global factory shipment item data 110 in the global BOM are compatible (in the case of “YES” in S12), the code association processing unit 21 The data is associated (S21), and the local item code 122 and the number 203 included in the local item data 200 are stored in the global parts table table 33 (S22).

  Specifically, in step 12, as shown in FIG. 2, the local item data 200 having a local item code 202 of “1001J” and the global factory shipment item data 110 having a global factory shipment item code 112 of “48201234NN01” are obtained. If it is determined that it can be handled, the local item code “1001J” is associated with the global factory shipment item code “48201234NN01” in the global parts table stored in the global parts table 33. Further, the number “100” is associated with the local item code “1001J”. In addition, here, the total value “150” of the number of all local items associated with the global factory shipment item code “48201234NN01” is set as the number 113 of this global shipment item code “48201234NN01”. The total value “250” of all the global product items associated with the global product item “liquid crystal panel” which is the parent item of the code “48201234NN01” is set as the number 103 of this global product item.

  In step 12, it is determined that neither the extracted local item data 200 nor the global factory shipment item data of the child item of the corresponding global product item in the global BOM stored in the global BOM table 33 correspond. In this case, the code association processing unit 21 determines whether or not correspondence is possible if a new global factory shipment item is added as a child item of the corresponding global product item (S13). When it is determined that it is impossible to handle, that is, when it is determined that the product item is a completely new product item, the new data creation unit 22 assigns a new global product item code 101 (S14). Register in the global item master table 32 (S15).

  If it is determined in step 13 that a new global factory shipment item is added as a child item of the corresponding global product item, and if a new global item code 101 is registered in step 15, a new data creation unit 22 assigns a new global factory shipment item code 112 (S16), and registers this new global factory shipment item code 112 in the global item master table 32 (S17). Then, the local item data 200 extracted in step 11 determines whether or not the existing attribute item or attribute value can be handled (S18). It is registered in the semantic attribute master table 34 (S19). For example, when all attribute items are newly defined, only some attribute items are changed, or when there are not enough attribute items, Although attribute items exist, there are cases where it is necessary to define attribute values other than the attribute values defined in the corresponding attribute item. The new data creation unit 22 performs a new definition of the attribute item and a new definition of the attribute value in any case, and registers this in the semantic attribute master table 34.

  If it is determined in step 18 that the existing attribute definition is applicable, and if a new attribute definition is added in step 19, the code association processing unit 21 adds the attribute information to the new global factory shipment item code. Associate (S20). The code association processing unit 21 associates the local item code 202 of the local item data 200 extracted in step 11 with the new global factory shipment code 112 (S21), and is included in the local item data 200. The local item code 122 and the number 203 are stored in the global parts table table 33 (S22).

  Next, the code association processing unit 21 determines whether or not all the local item data collected in step 10 has been extracted (S23). If all the local item data has not been extracted yet, the process returns to step 11. If all the local item data have been extracted, the series of processing is terminated.

  As described above, in the present embodiment, as shown in FIGS. 2 and 6, the global factory shipment item code 112 and the local item code 122 (202) at the highest level in the local parts table stored in the local parts table databases 41a and 41b. ) Can be associated. Moreover, a plurality of local item codes 122 (202) having different formats can be associated with the global factory shipment item code 112. For example, in the example of FIG. 2 and FIG. 6, a local item code having a format having “100” in the upper digits, such as “1001J”, “1002J”, “1004J”, and “ZA213”, “ZA243”, “ It can be associated with a local item code in a format having “ZA” in the upper digit.

Thus, since item codes having different formats can be associated with each other, there are the following advantages (1) and (2).
(1) The number of items in stock indicated by local item codes with different formats can be integratedly managed. For example, by summing the stock quantities “100” and “50” of the local item codes “1001J” and “ZA213” associated with the global factory shipment item data “48201234NN01”, the global factory shipment item data “48201234NN01” The inventory number “150” can be obtained.
(2) With respect to items of a plurality of local item codes having different formats associated with global factory-shipped items, management such as addition / deletion of parts can be easily performed for a design change or the like.

  In other words, in this embodiment, it is considered that the user interprets the “meaning” of the item data collected from each manufacturing factory on the global supply chain and defines it as a semantic attribute so that it can be used at the actual manufacturing site. It is possible to define attributes with “detailed meaning”. Therefore, even when a user other than the registered user performs item data registration or parts table selection, an appropriate meaning can be designated and processed. And by managing the BOM without using the difference in the item code format using semantic attributes, operations such as inventory management and design change management using the BOM at multiple manufacturing bases deployed around the world. Can be accomplished.

  Furthermore, in the present embodiment, as described above, since a logical expression is used for a part of each attribute item A, B,... Of the attribute information 114 of the global factory shipment item data 110, the attribute of one attribute item is used. Compared to the case where only one numerical value or character is set as the value, the attribute value can be set in various forms, and the item code in another format can be associated appropriately.

It is a block diagram of the parts table management system in one Embodiment which concerns on this invention. It is explanatory drawing which shows the data structure of the global components table | surface in one Embodiment which concerns on this invention. It is explanatory drawing which shows the data structure of the semantic attribute master table in one Embodiment which concerns on this invention. It is explanatory drawing which shows the data structure of the semantic attribute logic set table in one Embodiment which concerns on this invention. It is explanatory drawing which shows the data structure of the local components table | surface database in one Embodiment which concerns on this invention. It is explanatory drawing which shows the relationship between the global product item in one Embodiment which concerns on this invention, a global factory shipment item, and a local item. It is a flowchart which shows operation | movement of the global parts list management server in one Embodiment which concerns on this invention.

Explanation of symbols

10: Global parts table management server, 21: Code association processing unit, 22: New data creation unit, 23: Item data collection unit, 24: Input / output control unit, 25: Communication control unit, 30: Storage device, 31: Item management program, 32: Global item master table, 33: Global parts table, 34: Semantic attribute master table, 35: Semantic attribute logical set table, 40a, 40b: Local parts table management server, 41a, 41b: Local parts table Database: 100: Global product item data, 101: Global product item name, 102: Global product item code, 103: Number, 110: Global factory shipment item data, 112: Global factory shipment item code, 113: Number, 114: Attribute Information, 122, 202: Local item code, 12 , 203: Number

Claims (8)

In the global item data for the computer to manage the local item code as the item identifier specified in each manufacturing plant for each of the plurality of manufacturing factories,
Including an item code as an item identifier and attribute information indicating an attribute of the item,
The attribute information includes a plurality of attribute items, and attribute data related to the attribute item is set in each of the plurality of attribute items, and is set in at least one attribute item of the plurality of attribute items. Attribute data is represented by a logical expression that contains attribute values,
The computer stores the global item data for each of a plurality of items,
A plurality of local item data collected and stored by the computer from each of a plurality of manufacturing plant databases, including a plurality of local item codes and attribute information indicating attributes of items indicated by the local item codes. The global item data including attribute information corresponding to the attribute information included in the collected local item data is associated with the local item code included in the local item data. Be
Global item data characterized by In the item management program of the computer that manages the local item code as the item identifier defined in each manufacturing plant for each of the plurality of manufacturing factories,
In the storage device of the computer,
Global item data including a global item code as an identifier of the item and attribute information indicating the attribute of the item is stored for each of a plurality of items, and the attribute information includes a plurality of attribute items. In each of the plurality of attribute items, attribute data related to the attribute item is set, and the attribute data set in at least one attribute item of the plurality of attribute items is represented by a logical expression including an attribute value. And
Item data collection for collecting a plurality of local item data including a local item code and attribute information indicating an attribute of an item indicated by the local item code from each of a plurality of manufacturing factory databases by means of the computer Steps,
From among a plurality of global item data stored in the storage device, select global item data including attribute information corresponding to attribute information included in the local item data collected in the item data collection step, An association step of associating a local item code included in the local item data with the selected global item data and storing it in the storage device;
Is executed by the computer. In the item management program of the computer that manages the local item code as the item identifier defined in each manufacturing plant for each of the plurality of manufacturing factories,
In the storage device of the computer,
Stores a global bill of materials for multiple parts that make up the product.
The global parts table includes a global product code as an identifier of the product and the part, a child item of the product or part indicated by the global product code, and global factory shipment item data of an item in a factory shipment form. Are related to each other,
The global factory shipment item data is a child item of the product or part indicated by the global product code, and indicates a global factory shipment item code as an identifier of the item in the factory shipment form and an attribute of the item in the factory shipment form. The attribute information includes a plurality of attribute items, each of the plurality of attribute items is set with attribute data related to the attribute item, and at least one attribute of the plurality of attribute items is set. The attribute data set in the item is represented by a logical expression including the attribute value.
Item data collection for collecting a plurality of local item data including a local item code and attribute information indicating an attribute of an item indicated by the local item code from each of a plurality of manufacturing factory databases by means of the computer Steps,
The attribute information included in the local item data collected in the item data collection step among the plurality of global factory shipment item data that are constituent elements of the global BOM stored in the storage device. Correlation step of selecting global factory shipment item data including corresponding attribute information, and storing the local item code included in the local item data in the storage device in association with the selected global factory shipment item data When,
Is executed by the computer. In the item management program according to claim 3,
Included in the local item data collected in the item data collection step from among the plurality of global factory shipment item data that are constituent elements of the global BOM stored in the storage device in the association step If global item data that includes attribute information corresponding to the attribute information that is specified cannot be selected, a new global factory shipment item code is assigned to the local item data, and new data that defines new attribute information Causing the computer to execute a creation step;
In the association step, a new global factory shipment item code is assigned to the local item data collected in the item data collection step in the new data creation step, and new attribute information is determined. The new global factory shipment item code is set in the global bill of materials, and new attribute information is set in association with the global shipment item code. The global factory shipment item code is included in the local item data. Map the local item code
An item management program characterized by that. In the item management program according to any one of claims 3 and 4,
The global factory shipment item data includes, in addition to the global factory shipment item code and the attribute information, a number indicating the stock quantity of the item indicated by the global factory shipment item code,
The local item data collected in the item data collection step includes, in addition to the local item code and the attribute information, a number indicating the number of items in stock indicated by the local item code,
In the association step, a value obtained by totaling the numbers of one or more local item codes associated with the factory shipment item data is set as the number of the factory shipment item data.
An item management program characterized by that. In the item management program according to any one of claims 3 to 5,
Each of the databases for each of the plurality of manufacturing factories stores a bill of materials for the manufacturing plant. The parts list defines a parent-child relationship of a plurality of items, and the local item data is stored for each item. Is set,
In the item data collection step, local item data relating to the highest level item in the parts table stored in the database is collected from each of the databases for each of the plurality of manufacturing factories.
An item management program characterized by that. In the item management device that manages the local item code as the identifier of the item defined in each manufacturing factory for each of the plurality of manufacturing factories,
Storage means for storing global item data including a global item code as an identifier of the item and attribute information indicating an attribute of the item for each of a plurality of items;
Item data collecting means for collecting a plurality of local item data including a local item code and attribute information indicating an attribute of the item indicated by the local item code from each of a plurality of manufacturing factory databases;
From among a plurality of global item data stored in the storage means, select global item data including attribute information corresponding to attribute information included in the local item data collected in the item data collection step, Association means for associating a local item code included in the local item data with the selected global item data and storing it in the storage means;
With
The attribute information includes a plurality of attribute items, and attribute data related to the attribute item is set in each of the plurality of attribute items, and is set in at least one attribute item of the plurality of attribute items. The attribute data is represented by a logical expression that includes the attribute value.
Item management device characterized by that. The item management device according to claim 7;
A local item management device having the database for each of a plurality of manufacturing factories and connected to the item management device via a communication network;
An item management system comprising:

Images