JP3486161B2 - Part code management system - Google Patents

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a part code management system for assigning and managing a part code necessary for managing each part incorporated in each product to be manufactured in a manufacturing factory for manufacturing various products.

[0002]

2. Description of the Related Art For example, electric appliances and automobiles are composed of a huge number of parts. This manufacturing company that manufactures electric products and automobiles manufactures a huge number of parts to be incorporated into products such as electric products and automobiles that it manufactures, and also procures them from external parts manufacturers. Therefore, as a manufacturing company, parts codes are attached to parts developed and manufactured in-house, and production management and inventory management are performed. Parts manufacturers also attach parts to parts procured from external parts manufacturers. Instead of a component code, a component code having a format that matches the system of the own manufacturing plant is added, and the corresponding component is managed by this newly added component code.

The management of the parts codes of the parts developed in-house and the parts procured from the outside is carried out, for example, in a production management room (center) which manages the production of each product in this manufacturing factory. In this production control room, for all the parts that have been adopted in this manufacturing factory, the part code and
A component code list (file) in which various kinds of information such as specifications of the relevant components, product names, and dimensions are described is installed.

In the department in charge of developing each product, when it is decided to develop a new part or order a new part from a parts maker and incorporate the part into a product, the production control room (center) is informed. , Submit the part code application form for the relevant part, which describes various information such as the specification, name and size of the relevant part.

Upon receipt of the part code application form from the product development department, the production control room (center) has already registered the corresponding part in the aforementioned part code list based on the part code application from another product development department. Check whether it has been completed. Specifically, it is checked whether or not the parts having the same specifications and product names are already registered. If it is not registered, a new part code for the corresponding part is issued according to a predetermined rule, and the issued part code is returned to the requesting product development department.

If already registered, the part code of the registered part is returned to the requesting product development department (part code pre-assignment method).

The department in charge of product development writes the part code received from the production control room (center) in the specification of the developed product. Or, enter it in the purchase order for the relevant part.

[0008]

However, as described above, when adopting a new part in the product development department or the manufacturing department, the production control room (center) is requested to assign the part code of the corresponding part. There were still the following issues to be improved in the parts code pre-assignment method that was applied for.

That is, when the staff of the production control room (center) receives the part code application form from each product development department or manufacturing department, the specifications described in the part code application form are the same as the product name. Whether or not the product name is described is checked in order in the parts code list.

In this case, even if the parts are the same, the specifications and the format of the product name described in the part code application form by the person in charge of each product development department or manufacturing department may be slightly different. is there. Therefore, the staff of the production control room (center) are essentially the same as the specifications and product names stored in the parts code list, with the specifications and product names written in the parts code application form from the development departments and manufacturing departments. Only when it is judged that it is different,
It is necessary to assign and assign a new part code.

Since a person in charge of the production control room (center) makes a visual judgment to judge whether or not they are substantially the same, a great deal of labor and time are required. Therefore, the person in charge of each product development department or manufacturing department must wait for a long time from the application of the part code to the acquisition of the part code. As a result, there is a concern that product development and product manufacturing may not proceed smoothly.

In order to eliminate such an inconvenience, there is a case where a component code preceding giving method is adopted. In this part code pre-assignment method, the person in charge of each development department or manufacturing department submits a simple part code application form to the production control room (center) for the time being when a new part code for a new part is required. . A staff member of the production control room (center) unconditionally generates a new part code for the corresponding part and returns it to the request source. Therefore, the person in charge of each product development department or manufacturing department can immediately obtain the part code of the corresponding part, which does not hinder product development or product manufacturing.

However, in this part code precedent giving method, after the part code is determined, the specification, the product name and other information of the corresponding part are submitted to the production control room (center) and registered in the part code list. .

As a result, there is a concern that the same part may be inadvertently double-registered with different part codes. Furthermore, the person in charge of each product development department or manufacturing department may delay or forget to provide the information of the specification, product name, and other information of the relevant part to the production control room (center). In this case, the parts code list is left incomplete.

The present invention has been made in view of the above circumstances, and the part code is common to all parts having different attributes and is common to parts having substantially the same attributes as the unique primary code. An object of the present invention is to provide a parts code management system that can prevent the duplicate setting of the already set parts code and give the correct parts code to the new parts in a short time by configuring the following codes. To do.

[0016]

In order to solve the above problems, in the parts code management system of the present invention, the specifications
And a unique primary code across all parts that have different attributes including the product name, and a statement for the specifications and product names included in the attributes.
Specifications and product names that differ only in the arrangement of letters, and symbols other than letters
For each part code consisting of a secondary code that is common to parts that have substantially the same attributes including specifications and product names that differ only by the code, the part code master file that stores the attributes of the part and the attributes are specified. In response to a request for setting a new part code for a new part, the same judgment means for judging whether or not the same attribute as the inputted attribute is stored in the part code master file, and the same judgment means have the same attribute. When it is determined that it is not stored, whether or not the primary code assigning means for assigning a new primary code to the new component and the attribute substantially the same as the input attribute are stored in the component code master file When the substantially identical determination means and the substantially identical determination means determine that the substantially identical attributes are not stored, a new secondary code for the new part is added. When the new secondary code assigning means for assigning a code and the substantially identical determination means determine that substantially the same attributes are stored, the secondary code having substantially the same attributes is assigned to the new part as the secondary code. And a secondary code assigning means.

In the component code management system configured as described above, the component code assigned to each component is the same as the unique primary code across all components having different attributes. And a common secondary code. Then, in the component code master file, attributes such as specifications and product names of the relevant components are stored for each component code.

When a request for setting a new part code specifying an attribute is input, the part code master memory is searched for this attribute, and a unique primary code is added to a part for which the same attribute is not detected. The primary code can be used to start product development or product manufacturing using the relevant part.

On the other hand, the attribute of the component input by the setting request is compared and referred to each attribute stored in the component code master memory, and if substantially the same attribute exists, the secondary code of the relevant attribute is set to the current one. If the secondary code of the new component is not present and substantially the same attributes do not exist, a new secondary code is assigned to this new component.

Another aspect of the present invention is that the new secondary code assigning means in the component code management system of the above invention assigns the primary code assigned to the new component to the relevant new component as the new secondary code. ing.

In the component code management system thus configured, the secondary code of each component having substantially the same attribute is equal to the primary code of the component registered first. That is, in the component registered first, the primary code and the secondary code are equal, so the number of codes to be managed, which is the total of the primary code and the secondary code, decreases.

[0022]

[0023]

Another aspect of the present invention is, in the component code management system of the above invention, for each component specified by the secondary code, the current position (state) of the relevant component in the manufacturing process of the manufacturing plant in which the relevant component is used. ) Has a business master file to store.

In the component code management system thus constructed, since the business master file is provided, it is possible to accurately grasp the current position (state) of the component in the manufacturing process of the manufacturing factory.

Still another invention is the component code management system of the above invention, and further comprises business master file updating means for newly registering the secondary code newly set by the new secondary code assigning means in the business master file. .

In the component code management system configured as described above, the new component 2 is added to the work master file.
The following code is automatically set.

Still another invention is, in the parts code management system of the above invention, the secondary code newly set by the new secondary code assigning means and the current position (state) of the operated and input parts are a business master file. It is equipped with a business master file updating means for newly registering in.

In the component code management system configured in this way, the new component 2
The following code is automatically set, and the current position (state) of the corresponding part is also automatically set.

[0030]

BEST MODE FOR CARRYING OUT THE INVENTION An embodiment of the present invention will be described below with reference to the drawings. FIG. 1 is a block diagram showing a schematic configuration of a component code management system according to the embodiment. The part code management system of this embodiment is arranged in, for example, a production management room that carries out inventory management and production management of parts required in a product development department or a manufacturing department of an electric product or automobile manufacturing factory. . The component code management system of the embodiment is composed of, for example, a personal computer.

As shown in the figure, in the component code management system, an input operation unit 1 including a display unit 2 and a keyboard 3, a component code addition waiting buffer 4 formed in a storage device such as an HDD, Parts status buffer 5, A
A BC master file 6 and a business master file 7 are provided. Furthermore, in this parts code management system, a program
Component information input unit 8, identity determination unit 9, primary code assignment unit 10, and substantially identity determination unit 1 configured as a module
Primary and secondary code assigning unit 12 and new secondary code assigning unit 1
3. A business master file updating unit 14 is provided.

The part code of each part handled by this part code management system is constructed as shown in FIG. 2B, for example. That is, the component code 15 is composed of a primary ABC 16 as a primary code, a secondary ABC 17 as a secondary code, and an old (old component) code 18.

ABC (Access Basic Code) is a code composed of, for example, 17-digit alphanumeric characters so that it can be easily accessed by a computer. 1 as the primary code
The next ABC 16 is a code uniquely given to all the parts having different attributes consisting of "specification" and "product name" that characterize the part to which the part code 15 is given. On the other hand, the secondary ABC 17 as a secondary code is a code commonly given to each part having substantially the same attributes consisting of “specification” and “product name”. Further, the old (old component) code 18 is, for example, a code with a short number of digits that was adopted before the component code management system of this embodiment was introduced.

Therefore, in the part code 15 adopted in this part code management system, the primary ABC 16
The secondary ABC 17 is always included, but there is also a part code 15 that does not include the old (old part) code 18.

AB as a part code master file
In the C master file 6, as shown in FIG. 3, for each part code 15 including the above-described primary ABC 16, secondary ABC 17, and old (old part) code 18, the parts specified by the corresponding part code 15 are stored. Characterizing specifications 19 and product name 20
The attribute consisting of and and other information 21 are registered.

The specification 19 includes drawing standard, work and version number information. The product name 20 includes a specification product name and a packaging form. Further, the other information 21 includes a part code, a Japanese product name, an English product name, a management date, and the like.

As shown in FIG. 2A, the part code addition waiting buffer 4 temporarily stores information (parts information) of a new part to which the part code 15 input from the part information input unit 8 should be added. A plurality of input areas 4a to 4f are formed. Specifically, the primary ABC 16 is input to the input area 4a.
Is input, the secondary ABC 17 is input to the input area 4b, the old (old part) code 18 is input to the input area 4c, the specification 19 is input to the input area 4d, and the input area 4e is input.
The product name 20 is entered in and other information 2 is entered in the input area 4f.
1 is input.

As shown in FIG. 4, the work master file 7 stores the current position (state) of the relevant part and management information for each state for each part specified by the secondary ABC 17. The current position (state) is "purchase",
“Purchase → Inventory”, “In-house work → Inventory”, “In-house work”, etc. are set. As the management information for each state, items such as quality (Q), price (C), delivery date (D), work (A) in purchase management, inventory management, and in-house management are set. This business master file 7 is used when the production control room purchases each part in the manufacturing process and manages the inventory and in-house production.

The component status buffer 5 temporarily stores the above-mentioned current position (state) of the new component input from the input operation unit 1 and management information for each state.

The part information input section 8 in FIG. 1 includes a specification 19, a product name 20, other information 21, and a current position (state) included in a new part code setting request for a new part input from the input operation section 1. And are temporarily stored in the component code addition waiting buffer 4 and the component status buffer 5. In this case, at least the specification 1 is required for the setting request of the new part code.
9 and the product name 20 are included. Other information 21, the current position (state), and management information for each state are registered in the ABC master file 6 with the part code 15 of the corresponding part, and then the ABC It may be set in the area of the corresponding part code of the master file 6.

The same determination section 9 has an ABC master file shown in FIG. It is determined whether the data is stored in No. 6 or not.

When the same determination unit 9 determines that the same specification and product name are not stored, the primary code assigning unit 10 assigns the primary ABC 16 to the corresponding new component and waits for the component code. Write to the input area 4a of the primary ABC 15 of the buffer 4.

The substantially identical determination unit 11 first determines the primary ABC1.
ABC master file 6 with specifications 19 and product names 20 that are substantially the same as specifications 19 and product names 20 of the new parts to which 6 is added.
Is stored in. The specifications 19 and the product name 20 which are substantially the same in the specifications 19 and the product name 20 are
In this embodiment, the specifications and product names differ only in the arrangement of characters, and the specifications and product names differ only in the symbols and signs other than the characters.

A specific example will be described with reference to FIG. Figure 5
(A), (b), and (c) show specifications (standards) of the same part in different notations. In this example, "1
No space between "/ 12" and "P238",
There are three types: "-" symbol and space. These differences are individual differences in the input operation in the input operation unit 1 between the persons in charge. However, in the same determination unit 9, even such a difference is automatically determined to be another specification 19. Therefore, the substantially identical determination unit 11 determines that the specifications 19 having such a slight difference are substantially identical specifications.

In the embodiment system, the specification 19 and the product name 20 which are determined to be substantially the same are displayed on the display unit 2 of the input operation unit 1 so that the person in charge can confirm them.

When the secondary code assigning section 12 is determined to be substantially the same, the secondary code assigning section 12 is assigned to the part of the specification 19 and the product name 20 which are determined to be substantially the same in the ABC master file 6.
The next ABC 17 is the secondary A of the component code addition waiting buffer 4.
Write to the input area 4b of BC.

If the substantially same specifications 19 and product name 20 are not stored in the ABC master file 6, the new secondary code assigning section 13 assigns a new secondary ABC number to this new part. To do. In the system of this embodiment, the primary AB previously assigned to the relevant new part is added.
C is added as a new secondary ABC and written in the input area 4b of the secondary ABC of the component code addition waiting buffer 4. Therefore, in this case, the primary ABC16 and the secondary ABC17
Is equal to.

When the new secondary ABC 17 is added, the business master file updating unit 14 receives this new secondary ABC.
C17 is newly registered in the business master file 7 shown in FIG. Furthermore, this business master file update unit 14
Writes the current position (state) of the corresponding new component temporarily stored in the component state buffer 5 and the management information for each state into the corresponding position of the work master file 7.

The respective parts 8 to 14 of the component code management system configured as described above carry out the component code management processing for a new component in accordance with the flowcharts of FIGS. From the input operation unit 1 to at least the specification 19 and the product name 2 of the new part
When a new part code setting request that specifies new part information including 0 is input (S1), the part information input unit 8 is activated, and the specification 19 of this input part information, the product name 20, and other information 21 are input. Writing is performed in the corresponding input areas 4d, 4e, 4f of the component code addition waiting buffer 4 (S2).

When the old (component) code 18 is input independently, the old (component) of the component code addition buffer 4 is input.
Write in the input area 4c for the code 18. When the old (old part) code 18 and part information are input,
Write to both input areas 4c-4f.

Further, when the current position indicating the status (status) of the relevant part is input together with the new part information, the current position (status) indicating the input status (status).
Is written in the component status buffer 5 (S3).

When the old (old part) code 18 is stored in the input area 4c of the part code addition waiting buffer 4 (S4), each old (old part) of the ABC master file 6 is stored by this old (old part) code 18. ) The code 18 is searched (S5). If the same old (old component) code 18 already exists in the ABC master file 6 (S6), it is determined that the component code of this new component is already registered in the ABC master file 6.

Then, the primary ABC 16 and secondary AB of the same old (old component) code 18 in the ABC master file 6
Each input area 4a of the component code addition waiting buffer 4 by reading C17. Write to 4b (S7). This is the end of the component code setting procedure when the old (old component) code 18 exists, so the primary A of the component code addition waiting buffer 4
The component information (data) in the state where the BC 16 and the secondary ABC 17 are added is displayed and output to the display unit 2 of the input operation unit 1 (S8).

When the old (old part) code 18 does not exist in the input part information (S4), and when the same old (old part) code 18 does not exist in the ABC master file 6 even if it exists (S6) The same determination unit 9 is activated, and the specifications 19 and product names 20 of the input areas 4d and 4e of the component code addition waiting buffer 4 are searched sequentially for the specifications 19 and product names 20 in the ABC master file 6. Go (S
9).

When the same specification 19 and product name 20 are present in the ABC master file 6 (S10), it is judged that the part code of this new part is already registered in the ABC master file 6. Then, the same specification 19 and product name 20 in the ABC master file 6 and the primary ABC1
6, the secondary ABC 17 is read and written in the input areas 4a, 4b of the component code addition waiting buffer 4 (S11).

As described above, the part code setting procedure when the same specification 19 and product name 20 exist is completed, so that the primary ABC 16 and the secondary AB of the part code addition waiting buffer 4 are finished.
The component information (data) with C17 added is displayed and output to the display unit 2 of the input operation unit 1 (S5).

When the same specification 19 and product name 20 do not exist in the ABC master file 6 (S10), the primary code assigning section 10 is activated to issue a new primary ABC 16 (S12), The new primary ABC 16 is written in the input area 4a of the component code addition waiting buffer 4 (S1).
3).

After that, the substantially identical determination section 11 is activated,
It is checked whether or not the specification 19 and the product name 20 which are substantially the same as the specification 19 and the product name 20 written in the component code addition waiting buffer 4 exist in the ABC master file 6 (similarity check) (S14). If the ABC master file 6 stores substantially the same specifications 19 and product names 20, 2
The next code assigning unit 12 is activated to read the secondary ABC 17 in the component code 15 having substantially the same specification 19 and product name 20 in the ABC master file 6 and write it in the input area 4b of the component code addition waiting buffer 4. (S16).

If the ABC master file 6 does not store substantially the same specifications 19 and product names 20,
The new secondary code assignment unit 13 is activated, and the new secondary ABC
Issue number 17. In the system of this embodiment, the primary ABC set in S12 is set for this new part.
16 is adopted as the new secondary ABC 17 (S17). The newly created secondary ABC 17 is written in the input area 4b of the component code addition waiting buffer 4 (S18).

Then, in S19, the newly issued primary ABC 16 is newly placed in the component code addition waiting buffer 4.
If is set, all the data (primary ABC16, secondary ABC17, old (old component) code 18, specification 19, product name 20, other information 21) in the component code addition waiting buffer 4 is kept as is and the ABC master Write to a new area in file 6 (S20).

In the component code addition waiting buffer 4,
If the newly issued primary ABC 16 is set this time (S21), the business master file updating unit 14 is activated and a new secondary ABC 17 is added to the business master file 7 shown in FIG. Set (S21).

Then, the current position (status) temporarily stored in the component status buffer 5 is written in the area where the new secondary ABC 17 of the work master file 7 is additionally set (S22).

Next, 1 of the part code addition waiting buffer 4
The component information (data) in the state where the next ABC 16 and the secondary ABC 17 are added is displayed and output to the display unit 2 of the input operation unit 1 (S23).

In the component code management system having such a configuration, the component codes 15 assigned to all the components used in this manufacturing plant have specifications 19 and product names 20 as shown in FIG. 2B. It has a unique primary ABC 16 across all parts that have slightly different attributes, and a common 2 for parts that have substantially the same specifications 19 and product names 20.
It is composed of the following ABC17. In some cases, the old (old part) code 18 used before the part code management system is adopted is also incorporated. The component code master file 6 stores the attribute 19 including the specification 19 and the product name 20 of the relevant component and other information 21 for each component code.

Then, when a request for setting a new component code having attribute information consisting of the specification 19 and the product name 20 and component information consisting of other information 21 is input, the specification 19 and the product name 2
The component code master file 6 is searched with 0, and the similar primary specifications 19 and product names 20 are ignored for the time being, and a unique primary ABC 16 is given to a new component in which the same specifications 19 and product names 20 are not detected. .

Therefore, using the primary ABC 16, it is possible to start product development and product manufacturing using the relevant parts. In this case, the primary ABC 16 of the other parts already registered in the part code master file 6
No overlap with 6.

Next, for the time being, the specification 19 and the product name 20 of the new part to which the primary ABC 16 is added are compared and referenced in detail with the specification 19 and the product name 20 of the other parts stored in the part code master file 6. . Then, when there are substantially the same specifications 19 and product names 20, the secondary A of the corresponding attribute
The BC 17 is the secondary ABC 17 of the new part this time, and the new secondary ABC 17 is added only when the substantially same specification 19 and product name 20 do not exist.

As described above, the substantially same parts are given the different primary ABCs 16 and then the common secondary ABCs are provided.
Since 17 is added, component management can be performed for each substantially identical component later. Specifically, the secondary ABC 17 is adopted for the part coat set in the work master file 7 shown in FIG. 4 that manages the inventory and the state (current position) of each part, so that the same part is double-registered. Can be prevented, and parts management can be performed more efficiently.

Further, in the system of this embodiment, since the newly created secondary ABC 17 is automatically registered in the work master file 7, the work load on the person in charge can be greatly reduced.

In the system of this embodiment,
The old (old component) code 18 that existed before this component code management system was introduced is also the new component code 1.
Since it is designed to be taken in 5, the old (old part) code 1
It is not necessary to discard 8 and recreate a new component code 15, and it is possible to ensure continuity from the old (old component) code 18 to the new component code 15.

[0071]

As described above, in the parts code management system of the present invention, the attributes including the specification and the product name are matched.
Then, the characters are assigned to the specifications and product names included in the relevant attribute.
Specifications and product names that differ only in columns, and symbols or codes other than letters
Only the attributes that include specifications and product names differ from each other
However , the part code is composed of a unique primary code across all parts having different attributes and a secondary code common to parts having substantially the same attributes.

Therefore, the primary code can be added to the new part only by determining the presence or absence of the same attribute, so that the primary code can be added to the new part in a short time. Further, duplicate setting is prevented for the already set component code. After that, since the secondary code is set, it is possible to carry out more practical parts management.

Further, since the old (old part) code that existed before the introduction of this part code management system is also incorporated into the new part code, the old (old part) code is discarded and the new part code is written. It is not necessary to recreate it, and the continuity from the old (old part) code to the new part code can be secured.

[Brief description of drawings]

FIG. 1 is a block diagram showing a schematic configuration of a parts code management system according to an embodiment of the present invention.

FIG. 2 is a diagram showing a storage content of a component code addition waiting buffer incorporated in the component code management system of the embodiment and a configuration of a component code.

FIG. 3 is a diagram showing storage contents of an ABC master file incorporated in the component code management system of the embodiment.

FIG. 4 is a diagram showing stored contents of a business master file incorporated in the component code management system of the embodiment.

FIG. 5 is a diagram showing an example of specifications that are considered to be substantially the same.

FIG. 6 is a flowchart showing a component code management operation in the component code management system of the embodiment.

FIG. 7 is a flowchart showing a component code management operation in the component code management system of the same embodiment.

[Explanation of symbols]

1 ... Input operation unit 4 ... Part code addition waiting buffer 5: Parts status buffer 6 ... ABC master file 7 ... Business Master File 8 ... Parts information input section 9 ... Identity determination unit 10 ... Primary code assigning section 11 ... Substantially identical determination unit 12 ... Secondary code assigning section 13 ... New secondary code assigning section 14 ... Business Master File Update Department 15 ... Part code 16 ... Primary ABC 17 ... Secondary ABC 18 ... Old (old part) code 19 ... Specification 20 ... Product name 21 ... Other information

Front Page Continuation (56) References JP-A-9-11093 (JP, A) JP-A-5-94449 (JP, A) JP-A 2000-210844 (JP, A) (58) Fields investigated (Int. Cl. ⁷ , DB name) G05B 19/418 G06F 17/60 B23Q 41/08

Claims (5)

(57) [Claims] 1. A primary code unique to all parts having different attributes including specification and product name, and included in the attribute.
Specifications and products that differ only in the arrangement of characters for the specifications and product names
Specifications and product names that differ only by the name and the symbols and signs other than letters
2 that are common to parts that have substantially the same attributes including
For each part code consisting of the following code, a part code master file (6) that stores the attribute of the corresponding part, and the same as the input attribute in response to a new part code setting request for a new part with the specified attribute Of the same component is stored in the component code master file, and when the same determination unit determines that the same attribute is not stored, the same component is stored for the new component. A primary code assigning means (10) for assigning a new primary code, and a substantially identical determining means (11) for determining whether or not an attribute substantially the same as the input attribute is stored in the component code master file. ) And a new secondary code that assigns a new secondary code to the new component when the substantially identical determination means determines that the substantially identical attributes are not stored. And the substantially identical determination means determines that substantially the same attribute is stored, the secondary code having the substantially same attribute is added to the new component as a secondary code. A component code management system including a secondary code assigning means (12). 2. The new secondary code assigning means assigns the primary code assigned to the new component to the relevant new component as a new secondary code.
Part code management system described. 3. A business master file (7) for storing, for each part specified by the secondary code, the current position of the part in the manufacturing process of the manufacturing factory where the part is used.
The parts code management system according to claim 1 or 2, further comprising: 4. The method of claim 3, wherein further comprising a new secondary code set to newly registered in the business master file operations master file updating means (14) in the new second code supplying means Parts code management system. 5. A business master file updating means (14) for newly registering in the business master file the secondary code newly set by the new secondary code assigning means and the current position of the operation input part. part code management system <br/> claim 3, wherein a was.