JPS6285377A - Summing-up system which follows department hierarchical structure - Google Patents
Summing-up system which follows department hierarchical structureInfo
- Publication number
- JPS6285377A JPS6285377A JP60226155A JP22615585A JPS6285377A JP S6285377 A JPS6285377 A JP S6285377A JP 60226155 A JP60226155 A JP 60226155A JP 22615585 A JP22615585 A JP 22615585A JP S6285377 A JPS6285377 A JP S6285377A
- Authority
- JP
- Japan
- Prior art keywords
- department
- hierarchical structure
- departmental
- departments
- summing
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 230000002776 aggregation Effects 0.000 claims description 16
- 238000004220 aggregation Methods 0.000 claims description 16
- 238000000034 method Methods 0.000 claims description 10
- 238000004458 analytical method Methods 0.000 claims description 7
- 238000004364 calculation method Methods 0.000 claims description 4
- 238000010586 diagram Methods 0.000 description 5
- 230000004931 aggregating effect Effects 0.000 description 2
- 241000894006 Bacteria Species 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 229910052751 metal Inorganic materials 0.000 description 1
- 239000002184 metal Substances 0.000 description 1
- 150000002739 metals Chemical class 0.000 description 1
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Description
【発明の詳細な説明】
〔産業上の利用分野〕
本発明は部門階層構造に従う集計方式に関し、特に部門
毎に発生ずる数値情報(金類等)と−上位部門へ集計す
る部門階層構造に従う集計方式に関する。[Detailed Description of the Invention] [Industrial Field of Application] The present invention relates to an aggregation method according to a departmental hierarchical structure, and in particular to a method for calculating numerical information (metals, etc.) generated in each department and - aggregating according to a departmental hierarchical structure that is aggregated to higher departments. Regarding the method.
(従来の技術〕
従来、この種の集計方式は、部門コード設計時に階層構
造を意識したコード設定を行い、例えば部門コードの上
1桁目、2桁目、3桁目等に意味を持たせ、それらの各
桁の数値が変わる毎に集計していく方式となっていた。(Conventional technology) Conventionally, this type of aggregation method involves setting codes with hierarchical structure in mind when designing department codes, and assigning meaning to, for example, the first, second, and third digits of the department code. , the system was such that the numbers were counted each time the numerical value of each digit changed.
しかし、部門に変更が生じた場合、たとえば部門の追加
、削除1合併および分割等の一般企業において頻繁に発
生する場合においては変更後の部門体系で期首からの集
計を再度行う方式がとられていた。However, in cases where changes occur in departments, such as the addition or deletion of departments (1) mergers and splits, which frequently occur in general companies, a method is adopted in which the aggregation is performed again from the beginning of the period using the changed department structure. Ta.
上述した従来の部門RZ N構造に従う集計方式は、集
計するプログラムにおけるアルコリズムが部門コードの
各桁の数値を意識して作られているので、部門の変更に
際しプログラムの再作成あるいは部門コードの大幅な変
更が必要となる欠点かあり、さらに、変更後の部門体系
で!!I]肖″からの集計を再度行う・g・要が発生す
る場合には、手作業で金額を16正しなければならない
という欠点があった。In the aggregation method according to the conventional department RZN structure described above, the algorithm in the aggregation program is created with the numerical value of each digit of the department code in mind. There are drawbacks that require major changes, and what's more, the department structure after the change! ! I] If there is a need to re-tally tally the sum, the disadvantage is that the amount must be corrected manually.
し問題点を解決するための手段、1
本発明の部門階層構造に従う集計方式は、部門毎に発生
する数値情報を部門階層に従って上位部門に集計してい
く部門階層構造に従う集計方式において、部門階層構造
を入力する階層構造入力部と、部門階層構造を表示する
階層構造表示部と、部門階層構造を保存する階層構造格
納部と、部門階層構造を解析する階N構造解析部と、階
層構造に従った集計if算を行う集計部と、部門毎に集
計された数値情報等を格納する部門情報格納部とを有し
ている。Means for Solving Problems, 1. In the aggregation method according to the departmental hierarchical structure of the present invention, in the aggregation method according to the departmental hierarchical structure in which numerical information generated for each department is aggregated to higher departments according to the departmental hierarchy, A hierarchical structure input section for inputting the structure, a hierarchical structure display section for displaying the departmental hierarchical structure, a hierarchical structure storage section for saving the departmental hierarchical structure, a floor N structure analysis section for analyzing the departmental hierarchical structure, and a hierarchical structure display section for displaying the departmental hierarchical structure. It has a totaling unit that performs a total if calculation and a department information storage unit that stores numerical information etc. totaled for each department.
(実施例〕 次に本発明の実施例について図面を参照して説明する。(Example〕 Next, embodiments of the present invention will be described with reference to the drawings.
第1(図は本発明の一実施例を示す。第1図において、
本実施例は部門階層構造を入力する階層構造入力部11
と、部門階層構造を表示する階層構造表示部]2と、部
門階N構造を保存する階層構造格納部13と、部門階層
構造を解析する階層構造解析部14と、階層構造に従っ
た集計計算を行う集計部と、部門毎に集計された数値情
報等を格納する部門情報格納部とを含む。First (The figure shows an embodiment of the present invention. In FIG. 1,
In this embodiment, the hierarchical structure input section 11 inputs the departmental hierarchical structure.
and a hierarchical structure display unit that displays the departmental hierarchical structure] 2, a hierarchical structure storage unit 13 that stores the departmental hierarchy structure, a hierarchical structure analysis unit 14 that analyzes the departmental hierarchical structure, and a total calculation according to the hierarchical structure. The department information storage section stores numerical information etc. that are totaled for each department.
階層構造入力部11は、部門の変更が頻繁に発生する事
象に対処するために、対話的に簡単に部門階層構造を登
録・変更ができるもので、階層構造表示部12は部門階
層構造を明快に表示する。The hierarchical structure input section 11 allows the department hierarchical structure to be easily registered and changed interactively in order to deal with the phenomenon where department changes occur frequently, and the hierarchical structure display section 12 allows the department hierarchical structure to be clearly displayed. to be displayed.
階層構造格納部13は、入力されたlv層構造を効率的
に保存する格納部であり、階層構造解析部14は、階層
構造の正当性を検査し、解析する解析部である。集計部
15は階層構造に従って下位部門から上位部門へ順次集
計計算を行う部分であり、部門情報格納部16は集計部
15で集計された金額等の数値情報を自部門発生高と下
位からの集計部とに分離して格納する格納部である。The hierarchical structure storage section 13 is a storage section that efficiently stores the input lv layer structure, and the hierarchical structure analysis section 14 is an analysis section that inspects and analyzes the validity of the hierarchical structure. The aggregation unit 15 is a part that performs aggregation calculations sequentially from lower divisions to upper divisions according to the hierarchical structure, and the department information storage unit 16 stores numerical information such as the amount totaled by the aggregation unit 15 into the own department's accrued amount and the aggregation from the lower level. This is a storage section that stores the data separately.
第2図は部門を変更する状態を示す。第2図において、
置体的に述べると、部門Xの下位部門として部門Y1と
部門Y2が存在し、部門の変更により部門Xの下位部門
として部門Zと部門Y2が、また部門Zの下bγ部門と
して部門Y1が存在するように変更された場合で、部門
Zが追加された場きである。FIG. 2 shows a state in which the department is changed. In Figure 2,
In terms of structure, department Y1 and department Y2 exist as subordinate departments of department X, and due to a change in department, department Z and department Y2 become subordinate departments of department This is the case when the department Z is added.
この]♀i′層構造を変更する場きは階層NJ造表示部
12の画面上に表示された部門階層N4造をす照しなが
ら階層構造入力部11によりカーソルを移動させ、指示
することにより追加、変更、削除が行える。たとえば、
部門Zの追加は部門Y2を移動させ、その間に部門Zを
追加することにより行う。To change the layer structure]♀i', move the cursor using the hierarchical structure input section 11 while pointing to the departmental hierarchy N4 structure displayed on the screen of the hierarchical structure NJ structure display section 12, and give an instruction. Can be added, changed, and deleted. for example,
Addition of department Z is performed by moving department Y2 and adding department Z during that time.
なお、初!!!l登録の場合は階層構造表示部12に空
白の構造が表示される。Also, for the first time! ! ! In the case of 1 registration, a blank structure is displayed in the hierarchical structure display section 12.
第3図は本実施例における階層84造表示部に表示され
る階層構造を示す9第3図において、この1借層構造は
部門ノ〜1のF位部門として部門Bl。FIG. 3 shows the hierarchical structure displayed on the display section of the hierarchy 84 in this embodiment.
B2.B3かあり、部門B1の下位部門として部門C1
,C2があり、部門B3の下位部門として部門DI、D
2がある。B2. There is also B3, and department C1 is a subdivision of department B1.
, C2, and departments DI, D as subordinate departments of department B3.
There are 2.
このように構成された部門構造はト(千層構造格納部1
3に格納され、更にl(J、7層横遣解析部14により
解析を行い、実行形式を再度階層構造格納部13に格納
する。この格納形式は第3図に示す状態ではi’AI
(Bl (C1,C2)、B2.B3(Di、C2>)
jのようになる。階層構造集計部15では階層構造格納
部13の実行形式を参照することにより数値情報を集計
し、部門情報格納部16に格納する6
第3図は部門別経費管理を例として、経費の発生高を集
計した例である。各部門毎に発生類と集計額(部門B1
の集計額一部門C1の集計額十部門C2の集計額〉を保
持することにより部門変更後の再集計が可能となる。特
に本実施例においては管理会計分野において、下位部門
で発生した経費等を上位部門へ集計する手段として、格
納されている部門階層構造を利用することができる。The departmental structure configured in this way is
3, and is further analyzed by l(J, 7-layer horizontal analysis unit 14, and the executable format is stored in the hierarchical structure storage unit 13 again. This storage format is i'AI in the state shown in FIG.
(Bl (C1, C2), B2.B3(Di, C2>)
It becomes like j. The hierarchical structure aggregation unit 15 aggregates numerical information by referring to the execution format of the hierarchical structure storage unit 13, and stores it in the department information storage unit 16. This is an example of aggregating. Accrual type and total amount for each department (department B1
By holding the total amount of one department C1, the total amount of ten departments C2, it is possible to re-tally the total after changing the department. Particularly in the present embodiment, in the field of management accounting, the stored departmental hierarchical structure can be used as a means of totaling expenses etc. generated in lower departments to higher departments.
以上説明したように本発明は、部門階層構造を部門コー
ドとは全く独立に定義しておくことにより、部門の変更
に柔軟に対処でき、また期首にさかのぼって再集計がで
きる効果がある。As explained above, the present invention has the advantage that by defining the department hierarchical structure completely independently of the department code, it is possible to flexibly deal with department changes, and it is also possible to perform re-aggregation retroactively to the beginning of the period.
第1図は本発明の一実施例を示す図、第2図は本実施例
における部門の変更を示す図、第3図は階層構造表示部
での具体例を示す図、第4図は部門情報格納部の部門別
経費管理を行う場合の情報例を示す図である。
11・・・階層構造入力部、12・・・階層構造表部、
13・・・階層構造格納部、14・・・階層構造解析部
、15・・・集計部、16・・・部門情報格納部。
$ I 菌
$2 面FIG. 1 is a diagram showing an embodiment of the present invention, FIG. 2 is a diagram showing changes in departments in this embodiment, FIG. 3 is a diagram showing a specific example in the hierarchical structure display section, and FIG. 4 is a diagram showing department changes. FIG. 7 is a diagram illustrating an example of information when performing departmental expense management in an information storage unit. 11... Hierarchical structure input section, 12... Hierarchical structure table section,
13... Hierarchical structure storage unit, 14... Hierarchical structure analysis unit, 15... Totalization unit, 16... Department information storage unit. $ I Bacteria $ 2 side
Claims (1)
に集計していく部門階層構造に従う集計方式において、
部門階層構造を入力する階層構造入力部と、前記部門階
層構造を表示する階層構造表示部と、前記部門階層構造
を保存する階層構造格納部と、前記部門階層構造を解析
する階層構造解析部と、階層構造に従った集計計算を行
う集計部と、部門毎に集計された数値情報等を格納する
部門情報格納部とを備えることを特徴とする部門階層構
造に従う集計方式。In an aggregation method that follows a departmental hierarchical structure, in which numerical information generated for each department is aggregated to higher departments according to the departmental hierarchy,
a hierarchical structure input section for inputting a departmental hierarchical structure; a hierarchical structure display section for displaying the departmental hierarchical structure; a hierarchical structure storage section for storing the departmental hierarchical structure; and a hierarchical structure analysis section for analyzing the departmental hierarchical structure. , an aggregation method according to a departmental hierarchical structure, comprising: an aggregation section that performs aggregation calculations according to the hierarchical structure; and a department information storage section that stores numerical information etc. aggregated for each department.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
JP60226155A JPS6285377A (en) | 1985-10-09 | 1985-10-09 | Summing-up system which follows department hierarchical structure |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
JP60226155A JPS6285377A (en) | 1985-10-09 | 1985-10-09 | Summing-up system which follows department hierarchical structure |
Publications (1)
Publication Number | Publication Date |
---|---|
JPS6285377A true JPS6285377A (en) | 1987-04-18 |
Family
ID=16840721
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
JP60226155A Pending JPS6285377A (en) | 1985-10-09 | 1985-10-09 | Summing-up system which follows department hierarchical structure |
Country Status (1)
Country | Link |
---|---|
JP (1) | JPS6285377A (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2000137748A (en) * | 1998-11-04 | 2000-05-16 | Akuatekku:Kk | Integration system management device |
JP2009181438A (en) * | 2008-01-31 | 2009-08-13 | Casio Comput Co Ltd | Data processor and program |
-
1985
- 1985-10-09 JP JP60226155A patent/JPS6285377A/en active Pending
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2000137748A (en) * | 1998-11-04 | 2000-05-16 | Akuatekku:Kk | Integration system management device |
JP2009181438A (en) * | 2008-01-31 | 2009-08-13 | Casio Comput Co Ltd | Data processor and program |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US5390296A (en) | Method and apparatus for calculation with display data | |
Stanback | Computerization and the transformation of employment: Government, hospitals, and universities | |
US8396739B2 (en) | Quotation system and method | |
Lynch | ADS: A technique in systems documentation | |
JPS6285377A (en) | Summing-up system which follows department hierarchical structure | |
JP2001043264A (en) | Job system | |
US20220269673A1 (en) | Updating of database data associated with spreadsheet structures | |
JP4245388B2 (en) | Accounting system, accounting program, and accounting method | |
JP3499823B2 (en) | Accounting system and method, and recording medium recording accounting program | |
JP2014219770A (en) | Management planning support system | |
JP2021093070A (en) | Device, method, and program for calculating estimated progress rate | |
JP3153631B2 (en) | Store design support device | |
JP5919333B2 (en) | Tax accounting processing apparatus, tax accounting processing method, and tax accounting processing program | |
Creighton et al. | Data processing for city planning | |
JP7525466B2 (en) | Import overhead management device, import overhead management method, and import overhead management program | |
JP2003203150A (en) | Administration analysis system | |
JPH04181372A (en) | Table sheet totalization system for data | |
JPH0619917A (en) | Nursing staff service management system | |
JP3927106B2 (en) | Integration processing system, integration processing device, and program | |
JP2006059263A (en) | Management system for fixed asset | |
JP3986097B2 (en) | Table device | |
JP2001101266A (en) | Cach flow calculation system | |
JP3858232B2 (en) | Pay scale output device | |
JP2024068999A (en) | Program for creating cash flow statement | |
JP2000268083A (en) | Insurance charge revenue record updating device, scheduled pension reception amount calculating device and prepaid insurface calculating device |