JPH07230500A - Component table registration retrieval system - Google Patents

Abstract

PURPOSE:To provide the component table register and retrieval system which easily retrieves combinations of slave substrates and collective substrates by taking the component number of a collective mount, where components are mounted on a collective substrate, into a component table. CONSTITUTION:With respect to component table data consisting of plural final assembled product F data, plural collective substrate Z data, plural slave substrate P data, plural collective mount Y data where component are mounted on plural collective substrates respectively, and plural single mount A1 and A2 data where components are mounted in plural slave substrates respectively, a single mount data and collective mount data combination file, and a single mount data and slave substrate data combination file, a slave substrate data and collective substrate data combination file are recorded in a recording medium for the purpose of obtaining a three-dimensional component table instead of a tree type component table, and retrieval is performed.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a parts table registration / retrieval system, and more particularly to a parts table registration / retrieval system capable of registering and retrieving data of a collective board as one part of a parts table.

[0002]

2. Description of the Related Art Conventionally, some printed boards of different kinds or the same kind are apparently made into a single board, and a necessary portion is divided into parts for use (hereinafter referred to as an aggregate board). It was created for the purpose of reducing the unit price of the board and reducing the number of setup steps in the mounting process. Therefore, each department from design, materials, manufacturing to service,
In the case of a collective substrate of a heterogeneous set, the information "which substrate is combined with which substrate", and in the case of a collective substrate of the same type set, "how many are combined" is indispensable.

In describing the conventional example and the present invention, reference numerals of parts are defined as follows. F, F1, F2: Final assembly product (mainly showing the management unit of the parts list) A1, A2, A3, A4: Single mount (an assembly part in which various electric parts are mounted on the sub-board, for each category of parts) Numbered.). A, A0: Partial assembly parts made by assembling the mounts A1, A2, etc. P1, P2, P3: Substrate (single mount A1, A2,
Substrate necessary for making A3, such as tuner substrate, audio substrate, video substrate, etc. ). Z, Z1, Z2: Aggregate substrate (substrate in which the sub-substrates P1, P2, P3 are made into one plate). Y1, Y2: Collective mount (a component in which a component is mounted on a collective substrate). If you divide this into single mounts A1 and A
It will be 2 mag.

When manufacturing the above-mentioned aggregate board, a parts table is prepared. In the case of a tree type parts table shown in FIG. The method of registering the collective substrate Z1 as a child component of the mounts A1, A2, A3 has been adopted. For example, A1: P1, Z1 (1/3) A2: P2, Z1 (1/3) A3: P3, Z1 (1/3) are registered in combination.

The registration of the parts table is performed by the registration person using the parts table registration / retrieval system as shown in FIG. The system includes the registration / modification terminal 1, the search terminal 3, and the CPU.
4, the main storage device 5 and the like are generally provided.

Then, the collective substrate Z1 includes the sub-boards P1, P2, and P1 of the single mounts A1, A2, and A3.
Since it is common to P3, each single mount A1, A
2 and A3, the number of members of the collective substrate Z1 is
It is registered as a reciprocal of 1/3 as the reciprocal of the types P2 and P3, and as shown in FIG. 7, the collective mount Y1 formed by mounting the electrical components on the collective board Z1 is adopted in the registration method. The current situation is not.

When the component data is registered by the registration method based on the tree type component table, the following problems occur. (1) Since the collective substrate Z1 and each of the subsidiary substrates P1, P2, P3 have no parent-child relationship in a hierarchical manner, even if the subsidiary substrate P1 is searched, for example, the collective substrate Z1 and the subsidiary substrates P1, P2, P3 are Can not easily know the combination of.

(2) Even if the same single mount is used, the same part number of the collective substrate cannot be used for another model. For example, when the same sub-board is made into a collective board in a different combination, the collective board numbers are naturally different. However, if it is mounted on a collective board and then divided, the single mount should be the same regardless of which collective board it is made from.

However, if a parts table is created according to the rule that "if one child part is different, the parent part number must be changed."
Its parent single mount must have a different part number. In this case, since the numbers of the collective boards are different, the numbers of the parent parts are changed.

That is, as shown in FIG. 6, A1 and A
Despite 1'is exactly the same single mount, there are single mounts A1 and A2 on the collective board Z1.
If the single mounts A1 ′ and A3 are provided, the number of the collective board is different from Z1 and Z2 according to the above rule, and the parent component number is also changed to A1 and A1 ′, which causes inconvenience. As a result, the types of single mounts increase, which causes problems such as an increase in service inventory and management items.

(3) When ordering parts, the EDP system automatically calculates the order quantity by multiplying the number of parts in the parts list by the number of units produced. However, since the number of members of the collective board Z1 to be actually ordered is a fraction, for example, in the tree type parts table shown in FIG. I can't calculate.

For example, when producing 100 models using a set of three boards, the number of boards to be ordered is 100. However, in the calculation block, it becomes as follows, and the order is excessive. In other words, the number of products produced is 1/3 × 100 ≈ 34 1/3 × 100 ≈ 34 1/3 × 100 ≈ 34, and the total is 102, which is automatically the order quantity of 102 and an excess of 2 is ordered. . In order to prevent this, the materials department has made a huge amount of man-hours to check, and the merit of automatic calculation has not been fully utilized.

(4) Collective mount (Y1, Y2 ...)
Production control cannot be done in units. Assigning a code to each article is the basis of production management (article identification). However, conventionally, a code is not given to the collective mount mounted on the collective substrate, and each manufacturer sets a unique code at each manufacturing site, which is an obstacle to unified management.

[0014]

SUMMARY OF THE INVENTION In view of the above problems, the present invention provides a parts table registration / retrieval system using a parts table capable of easily searching for a combination and not causing an excessive order quantity. .

[0015]

According to the present invention, a plurality of final assembly product data, a plurality of collective board data, a plurality of child board data, and a plurality of sets in which a component is mounted on each of the plurality of collective boards. In the parts table registration / retrieval system for searching a parts table from a recording medium storing parts table data composed of mount data and a plurality of single mount data in which parts are mounted on each of the plurality of subsidiary boards, A file consisting of a combination of each one of the final assembly product data of the final assembly product data, each one of the plurality of single mount data and each of the plurality of collective mount data of the plurality of collective mounts, and the plurality of files. Combination of each single mount data of single mount data and each one collective mount data of said plurality of collective mount data File, a file consisting of a combination of each single mount data of the plurality of single mount data and each one of the plurality of subsidiary board data, and one of each of the plurality of collective board data. A file consisting of a combination of aggregate board data and each one of the plurality of child board data,
A file comprising a combination of each one of the collective mount data of the collective mount data and each one of the collective board data of the collective board data is recorded in the recording medium, and the part number of the collective mount is a part. Take in the table and register and search the combination of the child board and the collective board.

[0016]

EXAMPLE The relationship between the collective board and the collective mount in which electrical components are mounted on the collective board is shown in FIG. 7 as described above. That is, one aggregate substrate Z
1 has child boards P1 and P2, and these child boards P1 and P2
By mounting the electrical components on 2, the collective mount Y1
The single mounts A1 and A2 are formed on the bases.

The present invention is based on the conventional parts table shown in FIG. 1B, instead of the method of registering the collective board Z1 as a child part for each single mount A1, A2, A3, etc. As shown in (A) of (3), a method of dividing each parent-child relationship (hierarchy) into five individual files and registering component data as a three-dimensional component table is adopted.

In FIG. 1A, each file is divided as follows. File F-A1-Y1 (Final assembly product F-Single mount A1-
Collective mount Y1) F-A2-Y1 (Final assembly product F-Single mount A2-
Assembly mount Y1)

File A1-Y1 (single mount A1-collective mount Y1) A2-Y1 (single mount A2-collective mount Y1)

File A1-P1 (single mount A1-child board P1) A2-P2 (single mount A2-child board P2)

File Z1-P1 (collective board Z1-child board P1) Z1-P2 (collective board Z1-child board P2) File Y1-Z1 (collective mount Y1-collective board Z1)

If the registration method using the combination file as described above is adopted, the conventional registration method using the parts table in which the collective board Z1 is registered as a child part of the single mounts A1 and A2 can be avoided, and the hierarchical structure of the parts table is clear. By registering this, it is possible to realize a parts table registration search system that is easy to search.

Next, a concrete registration mechanism based on the three-dimensional parts table will be described. FIG. 2 shows two aggregate substrates Z1,
In Z2, a collective mount Y composed of single mounts A1 and A2 in which components are mounted on sub-boards P1 and P2 on Z1.
1 shows a conceptual diagram of a collective mount Y2 composed of single mounts A3 and A4 in which components are mounted on the subsidiary boards P3 and P4 on the collective board Z2. Then, the registration work is performed for each "lump" by inputting a screen from the registration terminal 1 using the registration search system shown in FIG.

By the screen input, the registration / retrieval system divides this into five files, and records them on the magnetic disk 2 while checking whether or not existing data exists and whether or not the rules are met. The specific contents of the component combination in the file divided into the five are as follows.

File F-A1-Y1 (Final assembly product F-Single mount A1-
Collective mount Y1) F-A2-Y1 (Final assembly product F-Single mount A2-
Assembly mount Y1) F-A3-Y2 (Final assembly product F-Single mount A3-
Collective mount Y2) F-A4-Y2 (Final assembly product F-Single mount A4-
Collective mount Y2)

File A1-Y1 (single mount A1-collective mount Y1) A2-Y1 (single mount A2-collective mount Y1) A3-Y2 (single mount A3-collective mount Y2) A4-Y2 (single mount A4-collective mount) Y2)

File A1-P1 (single mount A1-child board P1) A2-P2 (single mount A2-child board P2) A3-P3 (single mount A3-child board P3) A4-P4 (single mount A4-child board P4)

File Z1-P1 (collective board Z1-child board P1) Z1-P2 (collective board Z1-child board P2) Z2-P3 (collective board Z2-child board P3) Z2-P4 (collective board Z2-child board) P4)

File Y1-Z1 (collective mount Y1-collective board Z1) Y2-Z2 (collective mount Y2-collective board Z2)

In this way, the collective substrates Z1 and Z2 and the child substrates P1 and P of the individual mounts A1, A2, A3, and A4, respectively.
2, P3 and P4 have a hierarchical structure, and the collective mount Y1,
Y2 is recorded on the magnetic disk 2 as a "collective" file using the registration search system.

On the other hand, a searcher who searches for a part to be searched based on the parts table file recorded on the magnetic disk 2 inputs the part number to be searched from the search terminal 3 of the registration search system. Here, the part number refers to the collective board Z, the daughter board P, the collective mount Y, the single mount A1, etc. as a part, and is a number assigned to each part. In FIG. 3, P1, A1, F
For convenience, 1 and the like will be described as part numbers. When the part number is input to the registration search system, the system can read related data from each of the files to assemble the three-dimensional parts table.

FIG. 3 shows a case where the child board P1 is input as a search target. When the child board P1 is input, first, (P1-A1) is read from the file and (P1-Z1) is read from the file. As a result, the sub-board P
It can be found that the single mount of 1 is A1 and the collective substrate is Z1.

Next, following this, the single mount A1 is searched, (A1-Y1) is read from the file, and it is understood that the collective mount of the single mount A1 is Y1. Furthermore, the collective mount Y1 is searched,
(A1-Y1-F1) is read from the file and (Y1-A2) is read from the file, and then A2 is the search target and (A2-Y1-F1) is read from the file. Thus, only by inputting the child board P1 as a search target, the related data is automatically read out one after another from each of the files.

On the other hand, (P1-Z1) is read from the file, Z1 is subsequently searched, and (Z1-Y1) from the file and (Z1-P1 from the file.
2) is read. Accordingly, it is possible to search that the collective mount of Z1 is Y1 and at the same time, the sub-board P2 belongs to Z1. Further, P2 is searched, (P2-A2) is read from the file, and it is searched that the single mount of P2 is A2.

Based on such a reverse search result, the three-dimensional parts table shown in the lower side of FIG. 3 can be developed as the three-dimensional parts table. Assembling the parts list in the hierarchical structure,
In the hierarchical structure of the final assembled product F1, the single mounts A1 and A2, the child boards P1 and P2, the collective mount Y1, and the collective board Z1, for example, the final assembled products F1 and F1 are two parent parts (upper hierarchy) of the single mount A1. The connection of the collective mount Y1 can be expressed. The three-dimensional parts table shown in FIG. 4 is a further expanded parts table, but it goes without saying that it is also possible to express the connection of the two parent parts A0 and Y1 of the single mount A1. On the other hand, in the conventional tree type parts table shown in FIG. 1B, it is obvious that the connection is impossible.

By the way, it is possible to carry out registration and retrieval as well as data change using the parts table registration retrieval system. The data is changed by inputting the number of the part to be changed, a symbol indicating the change content, and the new part number after the change from the screen using the changing terminal 1. When changing this data, it is preferable to change the part number itself or the end of the part. The change of the part number is decoded by the parts table registration / retrieval system, the data to be changed is selected from each of the files, and the updating process is performed.
At this time, it is preferable that a list of files to be added, deletion, or change of data to be made according to the contents of change is compiled and incorporated in the system.

[0037]

EFFECTS OF THE INVENTION (1) By incorporating the part number of the collective mount into the parts table, the combination of the daughter board and the collective board can be easily searched. (2) A code representing a collective mount can be introduced, and a basis for production management on a collective basis can be created. (3) It is possible to divert an assembly board of a different combination of other models with the same part number, and it is possible to reduce management items, reduce service inventory, and shorten lead time until service parts are supplied. (4) By building a parts table database according to the present invention,
Checking the order quantity can be omitted and various problems at the site can be solved. Therefore, when the problems at the site are solved, it becomes a driving force for promoting the substrate assembling, and the original purpose of the substrate assembling is to reduce the number of manufacturing steps and improve the production efficiency.

[Brief description of drawings]

FIG. 1 is an explanatory diagram of a parts table according to the present invention and the related art.

FIG. 2 is an explanatory diagram of parts list registration according to the present invention.

FIG. 3 is an explanatory diagram of component search and component table creation according to the present invention.

FIG. 4 is an example of a three-dimensional parts table created by the present invention.

FIG. 5 is a block diagram of a general parts table registration / retrieval system.

FIG. 6 is an explanatory diagram of a conventional problem relating to a final assembled product, a collective substrate, and a collective mount.

FIG. 7 is an explanatory diagram of a collective substrate and a collective mount.

[Explanation of symbols]

 F Final assembly product Z1, Z2 Assembly board A1, A2 Single mount P1, P2 Sub-board Y1 Assembly mount

Claims (3)

[Claims] 1. A plurality of final assembly product data, a plurality of collective board data, a plurality of child board data, a plurality of collective mount data in which a component is mounted on each of the plurality of collective boards, and the plurality of daughters. In the parts table registration / retrieval system that searches the parts table data from a recording medium that records parts table data composed of a plurality of single parts mount data in which each part is mounted on each board, the single mount data and the collective mount data And a combination file of the single mount data and the child board data, and a combination file of the child board data and the collective board data are recorded in the recording medium. . 2. A plurality of final assembly product data, a plurality of collective board data, a plurality of child board data, a plurality of collective mount data in which a component is mounted on each of the plurality of collective boards, and the plurality of daughters. In a parts table registration / retrieval system that searches a parts table from a recording medium that records parts table data composed of a plurality of single mount data in which parts are mounted on each board, each of the plurality of final assembly product data A file composed of a combination of final assembly product data, each single mount data of each of the plurality of single mount data, and one set mount data of each of the plurality of collective mounts, and one single unit of each of the plurality of single mount data A file consisting of a combination of mount data and one aggregate mount data of each of the plurality of aggregate mount data; A file composed of a combination of each single mount data of a plurality of single mount data and a single slave board data of the plurality of slave board data, each one collective board data of the plurality of collective board data and the plurality of And a file consisting of a combination of each child board data of each of the child board data of (1) and a set of each one of the collective mount data of the collective mount data and each one of the collective board data of the collective board data. A parts table registration and retrieval system recorded on the recording medium. 3. The component mount registration search system according to claim 2, wherein the single mount data, the child board data,
Retrieving the collective board data, single mount, child board,
3. The parts table registration / retrieval system according to claim 2, wherein the parts table having a hierarchical structure in a lower order in the order of the assembled board is obtained by searching the recording medium.