JPH0554046A - Device for preparing parts table and purchase specification - Google Patents

Abstract

PURPOSE:To provide a device which easily prepares, a parts table for calculation of required quantities of individual electronic parts of an electronic apparatus or the like and purchase specifications attached to the parts table at the time of ordering of parts. CONSTITUTION:A final list 6 consisting of a list where parts names and quantities are enumerated, reference files 7 and 5 consisting of set groups of plural parts whose names are allowed to be entered together with parts registered in the final file 6, purchase specification files 8 and 10 of purchase specifications of parts which are allowed to be enter a storage part 1 where respective files are stored, a control part 2 which reads out the final file 6 from the storage part 1 at the time of preparing the parts table and reads out reference files 7 and 9 to successively totalize the quantity of each parts in the case of registration of names of reference files 7 and 9 in the list and reads out the final file 6 from the storage part 1 at the time of preparing purchase specifications and reads out purchase specification files 8 and 10 in the case of registration of purchase specification files 8 and 10 in the list, and an output part 3 which outputs information read out by the control part 2 and the totalization result are provided.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a parts list for calculating the required quantity of individual electronic parts such as capacitors in electronic equipment using a plurality of printed wiring boards as a unit, and the parts list when ordering parts. The present invention relates to a parts table and a purchase specification creation device capable of easily creating a purchase specification such as a custom-made part attached to the.

[0002]

2. Description of the Related Art In an electronic device or the like using a plurality of printed wiring boards, a method of calculating the number of necessary parts mounted on the boards and creating a parts table is to manually calculate each part. The quantity has been calculated, or the quantity of each part has been added up using a spreadsheet application software on an electronic computer, and a parts table has been created based on the result.

[0003] Parts are ordered by attaching purchase specifications such as custom-made parts to the parts list, but conventionally, the parts list and the purchase specifications were generally managed separately.

[0004]

However, calculation of the parts table by hand calculation frequently causes mistakes in calculation, and when the circuit is large and the total number of parts is several hundreds, the efficiency is low.

Further, even when a parts table is created using a spreadsheet application, it is easier than the above manual calculation, but the input and processing operation of the parts for each type is complicated, and still remains. The counting efficiency was not good.

Further, as described above, since the purchase specifications are managed separately from the parts list, it takes a very long time to search for the purchase specifications to be attached to the created parts list, which is inefficient. ..

The present invention has been made in view of the above problems, and an object of the present invention is to efficiently add up the necessary quantity of electronic parts required for electronic equipment by a simple operation to create a parts table, and An object of the present invention is to provide a parts table and purchase specification creation device that can simultaneously create a purchase specification attached to a parts list.

[0008]

In order to solve the above-mentioned problems, the parts table and purchase specification creation device of the present invention includes a final file consisting of a list in which at least parts names and quantities are listed, and in the final file. A reference file consisting of a set of a plurality of parts whose names are allowed to be described together with the parts registered in, a purchasing specification file in which the purchasing specifications of the parts are allowed to be described, and a storage unit for storing the above files, The last file is read from the storage unit when creating the parts table, and if the name of the reference file is registered in the list, this reference file is read, and the quantity is sequentially added up for each part and the purchase specifications are created. Sometimes the final file is read from the storage unit, and if the purchase specification file is registered in the list, this purchase specification file is And a control unit out look is configured to include an output section for outputting the read information and counting result by the control unit.

[0009]

According to the parts table and purchase specification creating apparatus of the present invention, a certain set of parts is created in advance as a reference file, and this reference file can be registered in the final file as needed. , The parts table can be created efficiently, and the tabulation can be easily done.

It is particularly effective when the reference file is set data of parts and assemblies required for manufacturing electronic equipment. In other words, the existing C
When a PU peripheral circuit is included, by registering only the set of parts included in this peripheral circuit as one reference file in the same row as other parts in the list in the final file, the so-called assembly unit It is possible to create a parts list in.

Further, if the information regarding the purchase specifications of the custom-made parts is created as a purchase specification file and this purchase specification file is also registered in the final file, if the created parts table contains the custom-made parts, the custom-ordered parts are created. Purchase specifications for parts can be created at the same time.

[0012]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the parts table and purchase specification creating apparatus of the present invention will be described below with reference to the drawings. FIG. 1 is a flow chart showing the procedure for creating a parts table in this embodiment, and FIG. 2 is a flow chart showing the procedure for creating a purchase specification in this embodiment.
3 is a schematic diagram showing the configuration of the parts table and purchase specification creation device, FIG. 4 is an explanatory diagram showing the list contents of the final file, FIG. 5 is an explanatory diagram showing the list contents of the first reference file, and FIG.
Is an explanatory view showing the list contents of the second reference file, FIG. 7 is an explanatory view showing a parts table created in this embodiment, and FIG.
9 is an explanatory diagram showing the contents of the purchase specification file, FIG. 9 is an explanatory diagram showing the contents of the second purchase specification file, and FIG. 10 is a conceptual diagram showing the relationship between the final file, the reference file, and the purchase specification file.

As shown in FIG. 3, the parts table and purchase specification creating apparatus of the present embodiment has a storage device 1 for registering each file and a control program of the present device, and writing / reading / calculation to / from the storage device 1. Control device 2 for processing, CRT
And an output device 3 including a printer, an input device 4 including auxiliary input means such as a keyboard or a mouse, and the like.
The storage device 1, the control device 2, the output device 3, and the input device 4 are connected by a bus 5.

The final file 6 stored in the storage device 1 has the name "A_1000.DB", for example, and stores the component information in the list format shown in FIG. That is, the column includes a "symbol" column in which a code indicating a component attribute and the like is described, and a "type name", a "quantity", and a "remark" column that indicate the type name of the component. Creation and update of such a final file are processed by a program separately prepared in the storage device 1.

In the figure, when the code "FIL" is written in the symbol column, this means that a reference file is registered, not a part. In this case, the reference file is registered. Is "U_0001.DB" (first reference file 7) described in the model name.

Further, in the figure, the symbol column has "#FI
When the code "LE" is described, it means that this is a custom-made part and the purchase specification file is registered. This purchase specification file is "EP-0001.P1" (first purchase specification file 8) described in the model name.

Therefore, in the final file 6, the gate IC "74LS244" used as a buffer, the tantalum capacitor "CP3-3UDDTH" and the carbon resistor "R4-7KJFDA" are provided one by one, and the first reference file 7 is also provided. This is a parts list that requires two groups of parts indicated by the contents of "U_0001.DB" and one power transformer of the custom-made parts indicated by "EP-0001.P1" which is the first purchase specification file 8. It means that.

The contents of the first reference file 7 "U_0001.DB" described in the final file 6 "A_1000.DB" are shown in FIG.
As shown in. As shown in the figure, the first reference file 7 "U_0001.DB" is also the final file 6 "" A_1000.D
B has the same file format as "B_B", and another reference file (second reference file 9) "U_000" is also included in the first reference file 7 "U_0001.DB" as shown in FIG.
2. DB ”can be registered.

The contents of the first purchase specification file 8 "EP-0001.P1" described in the final file 6 "A_1000.DB" are as shown in FIG. Detailed purchase specifications such as are described. The purchase specifications related to the unit price and delivery date of this power transformer are registered in the first purchase specification file 8 as the second purchase specification file 10 "TR-0001.P1", and the contents are shown in the figure. It is 9.

FIG. 10 shows the relationship among the final file 6, the first reference file 7, the second reference file 9, the first purchase specification file 8 and the second purchase specification file 10 in this embodiment. .. That is, as a first reference file 7 in the final file 6, "U_
"0001.DB" is registered, and further, "U_0002.DB" is registered as the second reference file 9 in the first reference file 7, which is a hierarchical structure. Similarly, “EP-0001.P1” is registered as the first purchase specification file 8 in the final file 6 for creating the purchase specification.
Second purchase specification file 10 in purchase specification file 8
"TR-0001.P1" is registered hierarchically. In the present embodiment, the second reference file 9 and the second purchase specification file 10 are shown, but if there are many parts groups and information to be registered, the third reference can be made in the second reference file 9 as necessary. The file, the third in the second purchase specification file 10
It is sufficient to sequentially register files in a hierarchical manner, such as registering a purchase specification file.

Next, a specific procedure for creating a parts table in the control device 2 using the final file 6, the first reference file 8 and the second reference file 9 will be described with reference to FIG. First, when a parts table preparation command is given from the input device 4 such as a keyboard (step 101), the control device 2 reads out and displays the final file 6 "A_1000.DB" from the storage device 1 (102). Then, it is searched whether or not the reference file is registered in the final file 6 (10
3). Here, if the reference file (“U_0001.DB” which is the first reference file 7 in this case) exists, (10
3), this reference file (first reference file 7 "U_000
1.DB ”) is read. Here, this first reference file 7
It is searched whether or not the second reference file 9 is further registered in "U_0001.DB". Since "U_0002.DB" is registered as the second reference file 9 here, the second reference file 9 "U_0002.DB" is further read. In this way, the loop of steps 103 to 104 is repeated, and when there is no reference file in the list, the loop is exited.

The final file ("A_1000.DB") read above and all the reference files ("U_0001.D")
Total the number of all parts from "B" and "U_0002.DB") (1
05). At this time, the number of parts is totaled for each same "model name". At this time, if a reference file is registered in the “model name”, all the parts of the reference file may be totaled, and then the quantity of all the parts may be multiplied by the number of reference files.

The above counting result is output by the output device 3 such as a CRT and a printer. FIG. 7 shows the output result.

Thus, in this embodiment, the final file 6
The parts around the CPU are registered as the first reference file 7 (“U_0001.DB”) in (“A_1000.DB”), and the digital parts are further registered in the second reference file 9 (“U_0002.D”).
By registering as "B"), the total can be easily calculated. Further, as described above, by registering the CPU peripheral parts as the first reference file 7 and the second reference file 9, if the circuit configuration uses the same type of CPU, it is created before. You can use these reference files as they are.

Next, using the final file 6, the first purchase specification file 8 and the second purchase specification file 10, the procedure for creating the purchase specification attached to the parts list output at the time of ordering the parts is described. It will be described with reference to FIG.

First, when the final file display command is given from the input device 4 to the control device 2 (step 201),
The final file 6 ("A_1000.DB") is read from the storage device 1 and displayed (202). Next, it is searched whether the purchase specification file is registered in the final file 6 (203). If a purchase specification file (here, the first purchase specification file 8 “EP-0001.P1”) exists (203), a purchase specification file display command is given from the input device 4 ( 204), this first
The purchase specification file 8 is read and displayed (20
5). The display content is output by the output device 3 (20
6). Furthermore, this first purchase specification file 8 "EP-000
It is searched whether or not the second purchase specification file 10 is registered in "1.P1" (203). In this embodiment, the second
Since "TR-0001.P1" is registered as the reference file 10, when a purchase specification file display command is given (204), the second purchase specification file 1 is further added.
0 "TR-0001.P1" is read and displayed (205), and the content is output (206). As mentioned above, Step 2
The loop of 03 to 206 is repeated, and when there is no purchase specification file, the process exits from the loop and the work of creating the purchase specification is completed.

As described above, in this embodiment, the final file 6
Register the 1st purchase specification file 8 (“EP-0001.P1”) that describes the purchase specifications of the custom-made parts in (“A_1000.DB”), and add the price of the above-mentioned custom-made parts to the 2nd purchase specification. By registering it as the document file 10 (“TR-0001.P1”), the purchase specification can be efficiently created.

Moreover, since the purchase specification attached to the parts table can be created at the same time when the parts table is created, the parts ordering work can be performed very efficiently.

[0029]

According to the parts table and purchase specification creating apparatus of the present invention, a set of certain parts is created in advance as a reference file, and this reference file is registered in the final file as necessary. By setting the parts list, the parts list can be efficiently created and the totals can be easily added.

This is particularly effective when the reference file is set data of parts and assemblies required for manufacturing electronic equipment. In other words, the existing C
When a PU peripheral circuit is included, by registering only the set of parts included in this peripheral circuit as one reference file in the same row as other parts in the list in the final file, the so-called assembly unit It is possible to create a parts list in.

Further, since information regarding purchase specifications of custom-made parts is created as a purchase specification file and this purchase specification file is also registered in the final file, if there is a custom-made part in the created parts list, the custom-made part Purchase specifications can be created at the same time, and the ordering work of parts can be performed more efficiently than in the case where a parts table and purchase specifications are created separately.

[Brief description of drawings]

FIG. 1 is a flow chart showing a procedure for creating a parts table in a parts table and purchase specification creation device according to an embodiment of the present invention.

FIG. 2 is a flow chart showing a procedure for creating a purchase specification in a parts table and purchase specification creating apparatus according to an embodiment of the present invention.

FIG. 3 is a schematic diagram showing the configuration of a parts list and purchase specification creation device showing an embodiment of the present invention.

FIG. 4 is an explanatory diagram showing the contents of a list of final files.

FIG. 5 is an explanatory diagram showing the contents of a list of first reference files.

FIG. 6 is an explanatory diagram showing a list content of a second reference file.

FIG. 7 is an explanatory diagram showing a parts table and a parts table created by the purchase specification creation device according to an embodiment of the present invention.

FIG. 8 is an explanatory diagram showing the contents of the first purchase specification file.

FIG. 9 is an explanatory diagram showing the contents of a second purchase specification file.

FIG. 10 is a conceptual diagram showing the relationship between the final file, reference file, and purchase specification file.

[Explanation of symbols]

 1 Storage Device 2 Control Device 3 Output Device 4 Input Device 5 Bus 6 Final File 7 1st Reference File 8 1st Purchase Specification File 9 2nd Reference File 10 2nd Purchase Specification File

Claims (1)

[Claims] 1. A final file consisting of a list in which at least part names and quantities are listed, and a reference file consisting of a set of a plurality of parts whose names can be described together with the parts registered in the final file. The purchase specification file in which the purchase specifications of parts are allowed, the storage unit that stores each of the above files, the final file is read from the above storage unit when creating a parts table, and the name of the reference file is registered in the list. If this is the case, this reference file is read out and the quantity is sequentially added up for each part. Also, when the purchase specifications are created, the final file is read out from the storage section,
When a purchase specification file is registered in the list, a parts table and purchase including a control unit that reads the purchase specification file and an output unit that outputs the information read by the control unit and the totalized result Specification creation device.