Database apparatus and extended parts table generating apparatus
OwnerSatoshi Matsuurainventor
Life of this patent
Estimating the term…
Abstract
An extended parts table 13 contains information specifying relevant lower level parts or “descendants” for each “parent” part and for each of the relevant lower level parts. The prime cost of a product is calculated based on the extended parts table 13, an item master table containing the purchase unit cost of parts D, E, F and a processing cost master table containing the processing cost of the parts D, E, F. As this eliminates the need for a hierarchical process of calculating the prime cost of a parent part, the processing speed is improved, no complicated application need be developed, and the table need not be updated during run time.
Claims9
A database apparatus for calculating the prime cost of a product manufactured by a plurality of parts ranging, from the highest to the lowest level, over a plurality of hierarchical levels, said apparatus comprising:
- an extended parts table containing all combinations of pairs of parts selected from said plurality of parts, each pair of parts having an upper-lower level relationship;
- an item master table containing information on a price of each of said plurality of parts;
- and
- a cost account calculating section for calculating the prime cost of said product based on said extended parts table and said item master table.
A database apparatus for calculating the prime cost of a product manufactured by a plurality of parts ranging, from the highest to the lowest level, over a plurality of hierarchical levels, said apparatus comprising:
- an extended parts table containing all combinations of pairs of parts selected from said plurality of parts, each pair of parts having an upper-lower level relationship and also containing information on the price and the quantity of lower level parts of said pairs of parts;
- and
- a cost account calculating section for calculating the prime cost of said product based on said extended parts table.
An extended parts table generating apparatus for generating, regarding a product manufactured by a plurality of parts ranging, from the highest to the lowest level, over a plurality of hierarchical levels, based on an item master table containing information on a price for each of said parts and based on an immediate parts table containing information for specifying immediate lower level parts of each of said parts, an extended parts table containing all combinations of pairs of said plurality of parts, each pair of parts having an upper-lower level relationship.
Dependencies are inferred from the claim text.