摘要 |
<p>PURPOSE:To execute an expenditure distributing processing based on the expenditure distributing policy of a company by extracting the department information of a distribution object from the distributing policy information of an expenditure distributing policy table and the attribute information of an attribute data base according to offices and departments. CONSTITUTION:Based on attribute delimiting information to indicate the expenditure distributing policy defined in an expenditure distributing policy table 6, an expenditure distributing part table 7 obtained by adding an attribute partition to attribute data stored into an attribute data base 3 according to the offices and departments is prepared, the record data in the respective departments are extracted from a sales record data base 4, and an expenditure distributing rate table 8 is prepared. Next, the recorded amount of the expenditures is extracted from an expenditure data base 5, the department classification distribution rate of an expenditure distributing rate table 8 is multiplied, the distributed amount according to the department is obtained, an expenditure distribution amount table 9 is prepared, and it is outputted to an input/output device 1.</p> |