JP2019101802A - Data display device, data display method, and data display program - Google Patents

Abstract

To provide a data display device, a data display method, and a data display program capable of displaying character string data and voucher image data related to a transaction corresponding to a designated journal slip.SOLUTION: In the present embodiment, (1) a trunk slip number associated with a journal slip number designated on a predetermined screen is acquired from a storage unit, (2) character string data relating to a transaction associated with the acquired trunk slip number is acquired from the storage unit, (3) a voucher key that is associated with the acquired trunk slip number is acquired from the storage unit, and further voucher image data relating to a transaction associated with the obtained voucher key is acquired from the storage unit, and (4) the acquired character string data and the acquired image data are displayed on the screen.SELECTED DRAWING: Figure 8

Description

  The present invention relates to a data display device, a data display method, and a data display program.

  Patent Document 1 discloses a mechanism by which a user can easily check whether an electronic file to be managed is registered (see, for example, paragraph 0007 of Patent Document 1).

JP, 2014-92807, A

  Thus, in the field of managing electronic files, for example, character string data (for example, supplier name, trading date, etc.) regarding transactions and image data of vouchers (for example, receipts) regarding transactions It may be linked to the document number and managed.

  However, for example, when linking the character string data and the image data from the expense reimbursement system to the financial accounting system, the slip number may change, or a plurality of slip numbers may be aggregated into one slip number. Sometimes.

  As a result, for example, when a certain journal entry slip is viewed from the financial accounting system, there is a problem that it becomes difficult to grasp which transaction the relevant journal entry slip relates to. In other words, there is a problem that it becomes difficult to grasp the character string data and the voucher image data related to the transaction corresponding to the designated journal entry.

  The present invention has been made in view of the above problems, and provides a data display device, a data display method, and a data display program capable of displaying character string data and voucher image data regarding a transaction corresponding to a designated journal entry. The purpose is to

  In order to solve the problems described above and to achieve the object, a data display device according to the present invention is a data display device including a control unit and a storage unit, and the storage unit includes journals of transactions in a financial accounting system. A journal entry slip number, which is a slip number for managing, and a core slip number, which is a slip number for managing the transaction in the backbone system, are linked and stored, and character string data and the backbone relating to the transaction are stored. The slip number and the slip number are linked and stored in the backbone system, and the image data of the voucher regarding the transaction, the voucher key corresponding to the image data, and the backbone slip number are linked and stored in the backbone system And the control unit acquires from the storage unit a basic slip number for acquiring the basic slip number associated with a journalizing slip number designated on a predetermined screen. A string, character string acquisition means for acquiring the character string data associated with the basic slip number acquired by the basic slip acquisition means from the storage part, and the basic slip acquisition means acquired from the storage part The character string acquired by the character string acquiring unit, the image acquiring unit acquiring the voucher key linked to the core slip number and further acquiring the image data linked to the acquired voucher key from the storage unit And display execution means for displaying data and the image data acquired by the image acquisition means on a screen.

  Further, in the data display device according to the present invention, the storage unit is a kind of a key slip number and is a kind of an expense slip number and a key slip number which are slip numbers in the expense settlement management of the transaction. A payment record including a payment slip number, which is a slip number in payment management of transaction, a payment slip number and a core slip number, which is a slip number that is an aggregation of the payment slip numbers A post-aggregation payment record including a string and a number, and a journal record including a post-aggregation payment slip number and a journalization slip number are further stored, and the control unit is configured to The post-aggregation payment slip number associated with the journal entry slip number included in the journal entry record is acquired, and the payment slip number associated with the acquired post-aggregate payment slip number is acquired from the post-aggregation payment record The expense slip number associated with the acquired payment slip number is acquired from the payment record, and the acquired expense slip number is associated with the journal slip number included in the journal record and stored in the storage unit. Further comprising storage means.

  Further, in the data display device according to the present invention, the backbone system identification information for identifying the backbone system is further added to the backbone slip number and the journalizing slip number stored in association in the storage unit. Is linked and stored in the storage unit with the backbone system identification information and the database identification information for identifying the database to which the backbone system specified by the backbone system identification information belongs. The key slip acquisition unit acquires, from the storage unit, the key slip number and the key system identification information associated with the journalizing slip number designated on the predetermined screen; and the control unit A database acquisition unit for acquiring database identification information associated with the backbone system identification information acquired by the backbone slip acquisition unit from the storage unit The character string acquiring unit may include the character associated with the backbone slip number acquired by the backbone slip acquiring unit from the backbone system belonging to the database specified by the database identification information acquired by the database acquisition unit. Column data is acquired, and the image acquisition unit acquires the core slip number and the string acquired by the trunk slip acquisition unit from the trunk system belonging to the database specified by the database identification information acquired by the database acquisition unit. The bond key may be acquired, and the image data to be associated with the acquired bond key may be acquired from the backbone system.

  Further, in the data display device according to the present invention, the display execution unit displays the character string data acquired by the character string acquisition unit on a first screen, and a predetermined area is selected on the first screen. And displaying the image data acquired by the image acquisition means on a second screen.

  The data display device according to the present invention is characterized in that the predetermined screen is a screen of a ledger.

  Further, the data display method according to the present invention is a data display method executed by an information processing apparatus including a control unit and a storage unit, and the storage unit is used to manage journalizing of transactions in a financial accounting system. A journal slip number, which is a slip number, and a key slip number, which is a slip number for managing the transaction in the key system, are linked and stored, and character string data about the transaction and the key slip number are the above The image data of the voucher related to the transaction, the voucher key corresponding to the image data, and the key slip number are stored in association with each other in the backbone system, and the control unit is stored. A basic slip acquisition procedure for acquiring from the storage unit the basic slip number associated with the journal entry number specified on the predetermined screen And a character string acquiring step of acquiring the character string data associated with the core slip number acquired in the core slip acquisition step from the storage portion; and the string acquisition step acquired in the core slip acquisition step from the storage portion An image acquisition step of acquiring the voucher key linked to the core slip number, and further acquiring the image data linked to the acquired voucher key from the storage unit; and the character string acquired in the character string acquisition step And display execution step of displaying data and the image data acquired in the image acquisition step on a screen.

  Further, a data display program according to the present invention is a data display program to be executed by an information processing apparatus having a control unit and a storage unit, and the storage unit performs journalizing management of transactions in a financial accounting system. And the basic slip number, which is the slip number for managing the transaction in the basic system, are stored in association with each other, and the character string data and the basic slip number relating to the transaction are stored. The image data of the voucher related to the transaction, the voucher key corresponding to the image data, and the key slip number are stored in association in the backbone system, and the control is stored. From the storage unit to be executed by the copy unit, the basic slip number associated with the journal entry number specified on the predetermined screen A core slip acquisition step to be obtained, a character string acquisition step for acquiring the character string data associated with the core slip number acquired in the core slip acquisition step from the storage unit, and the core slip acquisition step from the storage unit Acquiring the voucher key associated with the core slip number acquired in step b., And acquiring the image data associated with the acquired voucher key from the storage unit in the image acquisition step; And displaying the character string data and the image data acquired in the image acquisition step on a screen.

  According to the present invention, it is possible to display character string data and voucher image data regarding a transaction corresponding to a designated journal entry slip.

FIG. 1 is a block diagram showing an example of the configuration of a data display device. FIG. 2 is a diagram showing an example of a method of registering voucher image data regarding a transaction in a voucher database. FIG. 3 is a diagram showing an example of a method of creating character string data on a source slip number and a transaction by inputting a slip in the expense adjustment system, and an example of a method of attaching registered voucher image data. FIG. 4 is a diagram showing an example of a method of linking data from the expense adjustment system to the financial accounting system via the payment management system. FIG. 5 is a diagram showing an example of the ledger screen. FIG. 6 is a diagram showing an example of a method of tracing the expense slip number. FIG. 7 is a diagram showing an example of a method of tracing character string data and voucher image data regarding a transaction. FIG. 8 is a diagram showing an example of a detail inquiry screen and a voucher attachment screen. FIG. 9 is a view showing an example of a flowchart of voucher inquiry processing according to the present embodiment.

  Hereinafter, embodiments of a data display device, a data display method, and a data display program according to the present invention will be described in detail based on the drawings. The present invention is not limited by the present embodiment.

[1. Overview]
When data relating to a transaction is linked from the expense adjustment system to the financial accounting system, the slip number associated with the data may change, or a plurality of slips may be aggregated into one slip. In this case, in order to grasp which transaction the journal entry slip finally created corresponds to, it has been necessary to match the slip numbers in forms of a plurality of systems.

  Specifically, data on transactions may be aggregated and linked via a plurality of backbone systems (e.g., an expense adjustment system, a payment management system, etc.). However, the slip number (for example, "KEIHI 001") corresponding to the transaction changes each time the linkage (for example, when the expense settlement system cooperates with the payment management system, the slip number "KEIHI 001" is the slip number "SIHARAI 001" When the payment management system is linked to the financial accounting system, the slip number “SIHARAI 001” changes to the slip number “SIWAKE001”, or a plurality of slip numbers collectively change to one (for example, a slip) In the case where the number “SIHARAI 001” and the slip number “SIHARAI 002” merge into the slip number “SIHARAI 991”, a mechanism for capturing these changes has not existed conventionally. For this reason, for example, even if only the slip number “SIWAKE 001” is viewed on the financial accounting system, the data on the transaction can not be automatically confirmed.

  Therefore, up until now, the data on the transaction has been confirmed by manually tracing the slip numbers of the plurality of backbone systems, but in order to perform this confirmation, the plurality of backbone systems are activated. Since it is necessary to match the forms (match the slip numbers), it takes a lot of time and there is a demand for improvement.

  In addition, with the "revision of requirements for storing scanners in the Electronic Bookkeeping Act", which will be described in detail in the next paragraph, the need for storing scanners of data relating to the transaction increases, and as a result, the effort for matching slip numbers is improved. The desire to do something has become stronger.

  We will explain the background up to "Revision of the requirement for scanner storage in the Electronic Bookkeeping Act". First, in 1998, the "Electronic Bookkeeping Act" for national tax documents was enacted with the aim of reducing the cost of paper storage for companies. Furthermore, in 2005, the law "e-document law" was adopted, which permits the electronic preservation of documents and forms that are required to preserve originals in paper, but the requirements for scanner preservation are extremely strict. Recruitment did not progress. Subsequently, in response to rising institutional revisions and deregulation requirements from economic organizations, the “Revision of Scanner Preservation Requirements in the Electronic Bookkeeping Act” took place in 2016 and 2017. This revision has led to the abolition of the amount standard, the possibility to shoot a smartphone, and the abolition of electronic signatures, etc., and the interest in the system correspondence has increased in each company regardless of company size and industry, and the system needs for scanner storage are increasing. .

  As described above, by activating a plurality of backbone systems and collating a plurality of forms, it is very expensive to trace slip numbers and to grasp data on the transaction. Therefore, in the present embodiment, for example, the detailed contents and the voucher image data at the time when purchasing and expense repayment etc. exist in the core system from the accounting slip number of the financial accounting system, for example, by the person in charge of accounting. It enabled confirmation and reduced the burden of confirmation for accounting personnel etc. and improved work efficiency. In short, in this embodiment, for example, it is a function that can confirm the details and voucher at the time of occurrence of a transaction, including transactions other than the financial accounting system, from the journal entry slip number of the financial accounting system To realize the drill down function).

The effects of the present invention are, for example, as shown in the following (1) to (2).
(1) When linking from the expense settlement system or the like to another system, it is possible to check the details of the transaction from the journalizing slip by linking the slip numbers before and after the linkage. As a result, the work load of the person in charge of accounting was reduced.
(2) With the recent "relaxation of scanner storage requirements for electronic book storage", there is a growing need to manage electronic vouchers on the system, and the function of attaching electronic vouchers when a transaction occurs The implementation also made it possible to confirm the voucher. This makes it possible to respond to "relaxation of the requirement for scanner storage in electronic book storage".
The specific configuration and operation will be described below.

[2. Constitution]
An example of the configuration of the data display device 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the data display device 100. As shown in FIG.

  The data display device 100 is a commercially available desktop personal computer. The data display apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, and may be a portable personal computer such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smartphone, and a tablet personal computer. It may be an information processing apparatus.

  The data display device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the data display device 100 are communicably connected via any communication path.

  The communication interface unit 104 communicably connects the data display device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of communicably connecting the data display device 100 and the server 200, and is, for example, the Internet, a local area network (LAN), or the like. Note that data of various masters and the like described later may be stored in the server 200, for example.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. For the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. The input device 112 can be a keyboard, a mouse, a microphone, and a monitor that implements a pointing device function in cooperation with the mouse. Hereinafter, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

  The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving instructions to a central processing unit (CPU) in cooperation with an operating system (OS) to perform various processes. As the storage unit 106, for example, a memory device such as a random access memory (RAM) or a read only memory (ROM), a fixed disk device such as a hard disk, a flexible disk, an optical disk or the like can be used.

  The storage unit 106 includes, for example, voucher data 106a, expense adjustment data 106b, payment management data 106c, journal data 106d, slip number association table 106e, ledger data table 106f, description inquiry table 106g, and system information. And a table 106h. The voucher data 106a includes a voucher table 106a1 and a voucher image table 106a2. The expense adjustment data 106b includes an expense adjustment data table 106b1 and a related voucher table 106b2.

  Here, for example, with respect to a voucher related to a transaction, a slip number (for example, KEIHI 001) numbered in the expense adjustment system is a slip number on payment management of the transaction (for example, when linked to the payment management system) , SIHARAI 001). The payment management slip number is aggregated with another payment management slip number in a certain period unit to become a consolidated payment management slip number (for example, SIHARAI 991). The consolidated payment management slip number becomes the journal management slip number (for example, SIWAKE 001) when linked to the financial accounting system.

  In this embodiment, for example, a system other than a financial accounting system is defined as a basic system (in the example of the previous paragraph, an expense adjustment system and a payment management system), and a slip number for managing transactions in the basic system Is defined as the core document number. As the core slip number, for example, a type of core slip number and an expense slip number (in the example of the previous paragraph, KEIHI 001) which is a slip number in the expense reimbursement management of the transaction, and a type of core slip number A payment slip number (in the example of the previous paragraph, SIHARAI 001), which is a slip number in payment management of transactions, and a post-aggregate payment slip number (a type of core slip number, which is a slip number obtained by aggregating payment slip numbers) In the example of, SIHARAI 991), and the like.

  On the other hand, in the present embodiment, for example, the slip number for managing the journalizing of the transaction in the financial accounting system is defined as a journalizing slip number (SIWAKE 001 in the example of the previous paragraph).

  In the voucher table 106a1, as shown in FIG. 3, for example, a voucher key (abc 123) corresponding to the image data of the voucher regarding the transaction, an expense slip number (KEIHI 001), and character string data regarding the transaction (date of receipt of voucher: 2017/10/01, type of voucher: receipt, supplier name: ○ × Transportation Co., Ltd.) is stored in association with each other.

  In the voucher image table 106a2, as shown in FIG. 3, for example, a voucher key (abc 123) and image data (PDF data (stored in binary format)) of a voucher related to a transaction are stored in association with each other.

  In the expense adjustment data table 106b1, as shown in FIG. 3, for example, an expense slip number (KEIHI 001), which is a type of core slip number, and character string data related to the transaction (date of occurrence: 2017/10/01, transportation means: Taxi, amount of money: 10,800 yen, establishment: Tokyo, department: Sales department, description summary: 2017/10/01, taxi fare, Nippon Taro), it is linked in the expense settlement system which is a kind of backbone system Is stored.

  In the related voucher table 106b2, as shown in FIG. 3, for example, in an expense reimbursement system in which an expense slip number (KEIHI 001) which is a type of core slip number and a voucher key (abc 123) are a type of a backbone system. It is stored in association with it.

  Here, since the voucher image table 106a2 and the related voucher table 106b2 are linked via the voucher key (abc 123) as shown in FIG. 3, the storage unit 106 stores the image data (PDF data (PDF data (Stored in binary format), the voucher key (abc 123), and the expense slip number (KEIHI 001), which is a type of core slip number, linked and stored in the expense settlement system, which is a type of backbone system It can be said.

  Although not shown in the payment management data 106c, for example, payment slip number (SIHARAI 001), post-aggregation payment slip number (SIHARAI 991), character string data related to the transaction (occurrence date: 2017/10/01, transportation means: taxi means , Amount of money: 10,800 yen, establishment: Tokyo, department: sales department, item summary: 2017/10/01, taxi fare, Nippon Taro), and the string is stored.

  The journal data 106d, as shown in FIG. 4, for example, information created based on the journal entry number (SIWAKE 001) and the character string data related to the transaction (date of occurrence: 2017/10/01, establishment: Tokyo, Debit account items: travel expenses, transportation expenses, debit department: sales department, debit amount: 10,800 yen, credit account items: employee unpaid, credit department: management department, credit amount: 10,800 yen), and stored It is done.

  As shown in FIG. 4, for example, a payment record, a post-aggregation payment record, and a journal record are linked and stored in the slip number association table 106e. As shown in FIG. 4, the payment record includes, for example, an expense slip number (KEIHI 001), a backbone system identification information (25: expense settlement) for identifying an expense settlement system, and a payment slip number (SIHARAI 001). It includes the core system identification information (21: payment management) for identifying the payment management system in association with each other. For example, as shown in FIG. 4, the post-aggregation payment record includes a payment slip number (SIHARAI 001), a backbone system identification information (21: payment management) for identifying a payment management system, and a post-aggregate payment slip number ( SIHARAI 991) and core system identification information (21: payment management (aggregation)) for identifying a payment management system are linked and included. As shown in FIG. 4, the journal entry record has, for example, a post-aggregate payment slip number (SIHARAI 991), a backbone system identification information (21: payment management (aggregate)) for identifying the payment management system, and a journal slip number (SIWAKE 001) and financial accounting system identification information (10: financial accounting) for identifying a financial accounting system are linked and included.

  The ledger data table 106f is created from the journal data 106d. The ledger data table 106f, as shown in FIG. 6, is a journal entry number (SIWAKE 001) and information created based on the character string data related to the transaction (date of occurrence: 2017/10/01, account item: travel expenses and transportation expenses , Office: Tokyo, Department: Sales department, Counter account item: Employee unpaid, Amount: 10,800 yen) is linked and stored.

  The detail inquiry table 106g is created from the journal data 106d and the slip number association table 106e, as shown in the upper right of FIG. In the item inquiry table 106g, as shown in FIG. 6, for example, a journal slip number (SIWAKE 001), an expense slip number (KEIHI 001), and a backbone system identification information (25: expense reimbursement) for identifying the expense reimbursement system. And information created on the basis of the character string data about the transaction (occurrence date: 2017/10/01, account: travel expenses, travel expenses, establishments: Tokyo, department: sales department, counterpart account: employee unpaid, amount : 10,800 yen) and are stored in association with each other.

  The system information table 106h includes, as shown in FIG. 7, backbone system identification information (25: expense settlement) for identifying a backbone system, and a backbone system specified by the backbone system identification information. Database identification information (accounting system database) for identifying a database is linked and stored.

  The control unit 102 is a CPU or the like that controls the data display device 100 in an integrated manner. The control unit 102 has an internal memory for storing control programs such as the OS, programs defining various processing procedures, required data, etc., and performs various information processing based on the stored programs. Run.

  The control unit 102 is functionally and conceptually, for example, (1) a basic slip acquisition unit as a basic slip acquisition unit that acquires the basic slip number associated with the journal entry number specified on the predetermined screen from the storage unit 102a, (2) a character string acquisition unit 102b as character string acquisition unit for acquiring the character string data associated with the basic slip number acquired by the basic slip acquisition unit from the storage unit; Image acquisition means for acquiring from the storage unit the voucher key associated with the backbone slip number acquired by the backbone slip acquisition means, and further acquiring the image data associated with the acquired voucher key from the storage part (4) a display unit for displaying the character string data acquired by the character string acquiring unit and the image data acquired by the image acquiring unit on a screen The post-aggregation payment slip number associated with the journalizing slip number included in the journal entry record is acquired from the display execution unit 102d as means and (5) the journal entry record, and the acquired post-integration payment record The payment slip number associated with the post-aggregation payment slip number is acquired, and the expense slip number associated with the acquired payment slip number is acquired from the payment record, and included in the acquired expense slip number and the journal record. A storage unit 102e as a storage unit that stores the registered journal slip number in the storage unit, and (6) a linkage with the core system identification information acquired from the storage unit by the backbone slip acquisition unit And a database acquisition unit 102 f as a database acquisition unit that acquires database identification information. In addition, about the detail of the process which each part performs, below [3. Specific Example of Processing].

  The basic slip acquisition unit 102a acquires, from the storage unit 106, a basic slip number associated with the journalizing slip number designated on the predetermined screen. The core slip acquisition unit 102a may acquire, from the storage unit 106, a core slip number associated with a journal entry slip number designated on a predetermined screen and core system identification information.

  The character string acquisition unit 102b acquires, from the storage unit 106, character string data related to a transaction associated with the core slip number acquired by the core slip acquisition unit 102a. The character string acquisition unit 102b acquires character string data associated with the core slip number acquired by the core slip acquisition unit 102a from the core system belonging to the database specified by the database identification information acquired by the database acquisition unit 102f. It is also good.

  The image acquisition unit 102c acquires, from the storage unit 106, a voucher key associated with the core slip number acquired by the backbone slip acquisition unit 102a, and further, from the storage unit 106, a voucher related to a transaction associated with the acquired voucher key. Acquire image data. The image acquisition unit 102c acquires a voucher key that is associated with the backbone slip number acquired by the backbone slip acquisition unit 102a from the backbone system belonging to the database identified by the database identification information acquired by the database acquisition portion 102f, and further, The image data of the voucher regarding the transaction associated with the acquired voucher key may be acquired from the backbone system.

  The display execution unit 102 d displays, on the screen, the character string data on the transaction acquired by the character string acquisition unit 102 b and the image data of the voucher on the transaction acquired by the image acquisition unit 102 c. The display execution unit 102d displays the character string data on the transaction acquired by the character string acquisition unit 102b on the first screen, and when the predetermined area is selected on the first screen, the display execution unit 102d acquires the character string data The image data of the voucher regarding the transaction may be displayed on the second screen.

  The storage unit 102e acquires the post-aggregation payment slip number associated with the journal entry record number from the journal entry record, and the post-aggregate payment slip number associated with the acquired post-aggregate payment slip number from the post-aggregation payment record Acquire the acquired expense slip number and the expense slip number associated with the acquired payment slip number from the payment record, associate the acquired expense slip number with the journalizing slip number included in the journal record, and store in the storage unit 106 .

  The database acquisition unit 102 f acquires, from the storage unit 106, database identification information associated with the trunk system identification information acquired by the trunk slip acquisition unit 102 a.

[3. Specific example of processing]
Hereinafter, a specific example of the process according to the present embodiment will be described in detail. The processing according to the present embodiment can be roughly divided into three steps of voucher attachment processing, slip association processing, and voucher inquiry processing, so items will be described in this order in the following.

[3-1. Certificate attachment processing]
First, the voucher attachment process will be described in detail using FIGS. 2 and 3. In this item [3-1], an example will be described in which the expense settlement system is used to attach the voucher image data to the application slip.

(1) Registration to the voucher database First, as shown in FIG. 2A, when the employee receives a voucher such as a taxi receipt on the go, he / she photographs the voucher.

  Next, on the mobile screen such as a portable terminal shown in FIG. 2B, the image data of the photographed voucher is selected, and further, the receipt date (2017/10/01) and type (receipt of the photographed voucher) After inputting information such as a document, and selecting the “register” button, it is possible to upload the captured image data of the voucher and the input information to the voucher data 106 a.

  Specifically, the uploaded image data of the voucher and the input information are stored in the voucher data 106 a in the following configuration. That is, the voucher data 106a includes the voucher table 106a1 and the voucher image table 106a2 as shown in FIG. 2C. In the voucher table 106a1, as shown in FIG. 2C, for example, a voucher key (abc 123) corresponding to the image data of the voucher, a receipt date of the voucher (2017/10/01), and a type of voucher ( Receipts are stored in association with each other. The expense slip number in the voucher table 106a1 is set in (2) described below. As shown in FIG. 2C, for example, a voucher key (abc 123) and voucher image data (PDF data (stored in binary format)) are linked and stored in the voucher image table 106a2 There is.

(2) Attachment of Registered Vouchers Subsequently, after returning to the company, the employee activates the “Traffic Settlement” screen (shown in FIG. 3) of the expense settlement system, and the expense slip number corresponding to the image data of the voucher ( KEIHI 001) and string data on transactions (occurrence date: 2017/10/01, transportation: taxi, amount of money: 10,800 yen, establishment: Tokyo, department: sales department and abstract: 2017/10/01, taxi fare , Nippon Taro) etc. Furthermore, if the “Voucher button” is selected on the “Transportation expense payment screen” of FIG. 3, the image data of the voucher stored in the voucher data 106a is selected from the “Voucher attached screen” of FIG. , And the expense slip number (KEIHI 001) and the image data of the voucher can be associated (linked). At the time of this association, the expense slip number (KEIHI 001) is set in the voucher table 106a1. In addition, as shown on the left side of the screen, the expense slip number (KEIHI 001) and the character string data (reception date: 2017/10/01, amount of money: 10,800 yen) as shown on the left side of the screen. , Supplier Name: XX Transportation Co., Ltd., Product Name: Taxi fare, registered user: Nippon Taro) and detailed information on the attached image data of the attached voucher (File name: Receipt # 20171001 # Taro Nippon, version: 1, Certificate) Type: Receipt, Resolution: 300 dpi, Tone: 24 bits, Time stamp: 2017/10/01 23:00) etc. can be input.

  The expense slip number (KEIHI 001) entered on the “Training expenses settlement screen” described in the previous paragraph and the character string data related to the transaction (date of occurrence: 2017/10/01, transportation: taxi, amount of money: 10,800 yen, Based on the office: Tokyo, department: sales department and abstract: 2017/10/01, taxi fare, Nippon Taro), the expense adjustment data table 106b1 shown in FIG. 3 is created. Further, the related voucher table 106b2 shown in FIG. 3 is created based on the inputted expense slip number (KEIHI 001) and the voucher key corresponding to the image data of the selected voucher described in the previous paragraph. Then, the created expense adjustment data table 106b1 and the created related voucher table 106b2 are stored in the expense adjustment data 106b managed by the expense adjustment system.

(3) Summary As described above, in the expense reimbursement system, which is a type of backbone system, as shown in FIG. 3, the voucher table 106a1, the voucher image table 106a2, the expense reimbursement data table 106b1, and the related voucher table 106b2 are used. It can be linked and managed.

  As described above, as described in (1) and (2), according to the data display device 100 according to the present embodiment, it is possible to attach the image data of the digitized voucher to the slip of each core system system . The slips and the attached voucher image data are linked (linked) by the slip number and the voucher key, and it is determined which voucher is attached to which voucher. can do.

[3-2. Document association process]
Next, the slip association processing will be described in detail with reference to FIG.

(1) Linkage of data The expense adjustment data table 106b1 created in [3-1] is coordinated with the payment management system from the expense adjustment system, and becomes payment management data 106c. At the time of linkage, the expense slip number (KEIHI 001) included in the expense adjustment data table 106b1 becomes a payment slip number (SIHARAI 001), and further, the payment slip number corresponds to another payment slip number or one day or one. Aggregated monthly, it becomes the consolidated payment slip number (SIHARAI 991). Therefore, although not illustrated, the payment management data 106c managed by the payment management system is, for example, a transaction included in the payment slip number (SIHARAI 001), the post-aggregation payment slip number (SIHARAI 991), and the expense adjustment data table 106b1. String data about (date of occurrence: 2017/10/01, transportation: taxi, amount of money: 10,800 yen, establishment: Tokyo, department: sales department and abstract: 2017/10/01, taxi fare, Nippon Taro) And are linked and stored.

  The created payment management data 106c is linked from the payment management system to the financial accounting system, and becomes a journal data table 106d. At the time of linkage, the post-aggregate payment slip number (SIHARAI 991) included in the payment management data 106c is the journalization slip number (SIWAKE 001). Therefore, as shown in FIG. 4, the journal data table 106d is, for example, information created based on the journal entry number (SIWAKE 001) and the character string data related to the transaction included in the created payment management data 106c ( Occurrence date: 2017/10/01, establishment: Tokyo, debit account items: travel expenses, transportation expenses, debit department: sales department, debit amount: 10,800 yen, credit account items: employee unpaid, credit department: management department, credit The amount of money: 10,800 yen) is stored in a string.

(2) Linking of slip number As described above, when data is linked with the expense adjustment system → payment management system → financial accounting system, the slip number changes. Therefore, in order to check the contents of the data stored in the expense adjustment system retroactively from the journalizing slip number in the financial accounting system, it is necessary to associate the changing slip number. Therefore, in the present embodiment, by preparing the slip number association table 106e, tying of changing slip numbers is made possible.

As shown in FIG. 4, for example, (A) payment record, (B) post-aggregation payment record, and (C) journal record are linked and stored in the slip number association table 106e.
(A) As shown in FIG. 4, for example, the expense record number (KEIHI 001), the backbone system identification information (25: expense settlement) for identifying the expense settlement system, and the payment slip number (SIHARAI 001) ) And core system identification information (21: payment management) for identifying a payment management system. Therefore, it can be said that the payment record is a record for linking the expense slip number (KEIHI 001) and the payment slip number (SIHARAI 001).
(B) As shown in FIG. 4, the post-aggregation payment record includes, for example, a payment slip number (SIHARAI 001), a backbone system identification information (21: payment management) for identifying a payment management system, and a post-aggregation payment A slip number (SIHARAI 991) and core system identification information (21: payment management (aggregation)) for identifying a payment management system are linked and included. Therefore, it can be said that the post-aggregation payment record is a record for linking the payment slip number (SIHARAI 001) and the post-aggregation payment slip number (SIHARAI 991).
(C) The journal entry record has, as shown in FIG. 4, for example, a post-aggregation payment slip number (SIHARAI 991), and a backbone system identification information (21: payment management (aggregation)) for identifying a payment management system. A journal entry number (SIWAKE 001) and financial accounting system identification information (10: financial accounting) for identifying the financial accounting system are linked and included. Therefore, it can be said that the journal entry record is a record for linking the post-aggregate payment slip number (SIHARAI 991) and the journal entry slip number (SIWAKE 001).
As described above, the slip number relating table 106e can be traced back as follows: journal entry slip number → consolidated post payment slip number → payment slip number → expense slip number, and as a result, it is retroactive from the journal entry slip number in the expense adjustment system The contents of the data stored in can be confirmed.

(3) Summary As described above, when the data in the expense reimbursement system is linked to the financial accounting system through the payment management system, the slip number in each system is different. It has not been possible in the past to determine if it corresponds to a journal entry. However, as described in (1) and (2), the data display apparatus 100 according to the present embodiment prepares the slip number relating table 106e for associating (linking) the slip number of each system. Was able to put in place a mechanism to manage data.

[3-3. Certificate inquiry processing]
Finally, the voucher inquiry process will be described in detail with reference to FIGS. The voucher inquiry can be made from a predetermined screen. The predetermined screen is not particularly limited as long as the purpose of making a voucher inquiry can be achieved. For example, a screen may be used in which information on a desired voucher is input and a voucher search is performed, but in the present embodiment The following description will be made on the assumption that the predetermined screen is a screen of a ledger.

(1) Operation on the Ledger Screen When the business location, department, and accounts are entered on the ledger screen shown in FIG. 5, a ledger data table 106f is created from the journal data 106d. Each record included in the created ledger data table 106f is a record that matches the contents of the input business location, department, and account item, and is displayed on the “ledger screen” as shown in FIG. Ru. And if the "inquiry button" of the lower part of the screen concerned is chosen, processing of (2)-(4) shown below will be performed about each of the record of 3 lines shown in FIG. In the following (2) to (4), for convenience of description, only the process performed on the lowermost record of the three lines of records shown in FIG. 5 will be described in detail. .

(2) Mechanism for tracing slips of origins When the "inquiry button" is selected in the "ledger screen" shown in FIG. 5, the expense slip number etc. is acquired from the statement inquiry table 106g. Prior to this, the specification inquiry table 106g is created by the storage processing described below, and stored in the storage unit 106.

(Storage process)
First, the storage unit 102e acquires, from the journal entry record, a post-aggregation payment slip number associated with the journal entry slip number included in the journal entry record. Specifically, from the journal entry record (the record indicated by A) in the slip number relating table 106e shown in FIG. 6, the storage unit 102e collects post-aggregated payment slips that are associated with the journal entry slip number (SIWAKE001) included in the record. Get the number (SIHARAI 991).

  Next, the storage unit 102e acquires, from the post-aggregation payment record, a payment slip number associated with the acquired post-aggregation payment slip number. Specifically, the storage unit 102e is a payment slip that is associated with the acquired post-aggregate payment slip number (SIHARAI 991) from the post-aggregation payment record (record indicated by B) in the slip number relating table 106e shown in FIG. Get the number (SIHARAI 001).

  Next, the storage unit 102e acquires an expense slip number associated with the acquired payment slip number from the payment record. Specifically, from the payment record (record indicated by C) in the slip number relating table 106e shown in FIG. 6, the storage unit 102e stores the expense slip number (KEIHI 001) associated with the acquired payment slip number (SIHARAI 001). To get Furthermore, the storage unit 102e may also acquire the core system identification information (25: expense settlement) associated with the acquired expense slip number (KEIHI 001). Thus, by tracing the slip number relating table 106e for the slip number (SIWAKE001) of the journal included in the ledger data table 106f, the generation source of the journalizing slip "SIWAKE001" is the expense slip "KEIHI 001". It turns out.

  Finally, the storage unit 102e associates the acquired expense slip number with the journalizing slip number included in the journal entry record, and stores the result in the storage portion 106. Specifically, the storage unit 102e, as shown in the detail inquiry table 106g of FIG. 6, includes the acquired expense slip number (KEIHI 001) and the journal entry slip number (record indicated by A in FIG. 6) included in the journal entry record. The link with SIWAKE 001) is stored in the storage unit 106. The storage unit 102e may further associate the basic system identification information (25: expense reimbursement) acquired together with the above and store the same in the storage unit 106.

  The storage unit 102e further associates information (date of occurrence: 2017/10/01) with the journal entry slip number (SIWAKE 001) included in the journal entry record (record indicated by A in FIG. 6) from the ledger data table 106f shown in FIG. , Account items: travel expenses, transportation expenses, establishments: Tokyo, department: sales department, counterpart account: employee unpaid, amount of money: 10,800 yen), the acquired information and the journal entry number (SIWAKE001) and expense slip A record (that is, a record indicated by hatching in the detail inquiry table 106g of FIG. 6) including the number (KEIHI 001) and the backbone system identification information (25: expense settlement) may be stored in the storage unit 106.

  Thus, prior to acquisition of the expense slip number etc., the item inquiry table 106g is created based on the journal data 106d and the slip number association table 106e, and stored in the storage unit 106.

(Basic slip acquisition process)
The basic slip acquisition unit 102a acquires, from the storage unit 106, a basic slip number and a basic system identification information associated with the journal entry number specified on the predetermined screen.

  Specifically, as described in (1), the journal entry slip number designated on the “ledger screen” shown in FIG. 5 is SIWAKE 001. On the other hand, as described in (2) (storage processing), in the item inquiry table 106g shown in FIG. 6 stored in the storage unit 106, the expense slip number associated with the journal entry slip number (SIWAKE 001) and the backbone system The identification information is “KEIHI 001” and “25: expense reimbursement”, respectively. From the above, the basic slip acquisition unit 102a acquires “KEIHI 001” and “25: Expense Reimbursement” as the basic slip number and the system identification information, respectively.

  In this way, it is possible to specify the system as the generation source and the generated slip number from the journalizing slip number displayed in the ledger (step S1 in FIG. 9).

(3) Mechanism for acquiring transaction data of origin (database acquisition processing)
The database acquisition unit 102 f acquires, from the storage unit 106, database identification information associated with the trunk system identification information acquired by the trunk slip acquisition unit 102 a.

  Specifically, as described in (2) (basic slip acquisition processing), the basic system identification information acquired by the basic slip acquisition unit 102 a is “25: expense reimbursement”. On the other hand, as shown in the system information table 106h of FIG. 7, the database identification information associated with "25: expense reimbursement" is "accounting database". From the above, the database acquisition unit 102 f acquires “accounting system database” as database identification information.

  As described above, the database of the source system can be identified (step S2 in FIG. 9).

(String acquisition process)
The character string acquisition unit 102b acquires character string data related to a transaction associated with the core slip number acquired by the core slip acquisition unit 102a from the core system belonging to the database specified by the database identification information acquired by the database acquisition unit 102f. Do.

  Specifically, as described in (Database acquisition processing), the database specified by the database identification information acquired by the database acquisition unit 102 f is an “accounting database”. The backbone system belonging to the accounting database is a payment management system and an expense reimbursement system as shown in FIG. 7 (note that, as described in [2. Configuration] for the financial accounting system), the backbone system is not). In the expense adjustment system, the expense adjustment data table 106b1 is managed as described in (3-1) of [3-1]. As shown in FIG. 7, in the expense reimbursement data table 106b1, the character string data associated with the key slip number KEIHI 001 acquired by the key support slip acquisition unit 102a is “date of occurrence: 2017/10/01, transportation means: taxi , Amount of money: 10,800 yen, establishment: Tokyo, department: sales department and details abstract: 2017/10/01, taxi fare, Nippon Taro ". From the above, the character string acquisition unit 102b uses the character string data as "date of occurrence: 2017/10/01, transportation means: taxi, amount of money: 10,800 yen, establishment: Tokyo, department: sales department and description summary: 2017/10/01, taxi fare, get "Nippon Taro". Further, in the expense reimbursement system, as explained in (3) of [3-1], the voucher table 106a1 is also managed. As shown in FIG. 3, in the voucher table 106a1, the character string data associated with the key slip number KEIHI 001 acquired by the key slip acquisition unit 102a is “received date: 2017/10/01, type: receipt, transaction Former name: ○ ○ Transportation Co., Ltd. From the above, the character string acquisition unit 102b acquires “reception date: 2017/10/01, type: receipt, supplier name: ○ × Transportation Co., Ltd.” as character string data.

  In this manner, connection can be made to the database of the generation source system, and the transaction contents can be inquired using the slip number of the connection source (step S3 in FIG. 9).

(Image acquisition process)
The image acquisition unit 102c acquires a voucher key that is associated with the backbone slip number acquired by the backbone slip acquisition unit 102a from the backbone system belonging to the database identified by the database identification information acquired by the database acquisition portion 102f, and further, Image data of a voucher regarding a transaction associated with the obtained voucher key is obtained from the backbone system.

  Specifically, as described in (Database acquisition processing), the database specified by the database identification information acquired by the database acquisition unit 102 f is an “accounting database”. The backbone system belonging to the accounting database is a payment management system and an expense reimbursement system as shown in FIG. 7 (note that, as described in [2. Configuration] for the financial accounting system), the backbone system is not). In the expense adjustment system, the related voucher table 106b2 is managed as described in (3) of [3-1]. As shown in FIG. 7, in the related voucher table 106 b 2, the voucher key associated with the key slip number KEIHI 001 acquired by the key slip acquisition unit 102 a is “abc 123”. Furthermore, in the expense adjustment system, the voucher image table 106a2 is managed as described in (3-1) of [3-1]. As shown in FIG. 3, in the voucher image table 106 a 2, image data associated with the acquired voucher key “abc 123” is image data of a taxi receipt. As mentioned above, the image acquisition part 102c acquires the image data of the receipt of a taxi as image data.

  In this way, connection can be made to the database of the generation source system, and the voucher key can be inquired using the slip number of the connection source (step S3 in FIG. 9). In addition, when the voucher is not associated (when the voucher image data is not attached), the voucher key can not be acquired.

  In this item (3), an example of acquiring character string data related to a transaction and image data of a voucher related to a transaction from an accounting database has been described, but the database for data acquisition is not limited to the accounting database. As shown in FIG. 7, for example, a sales database or the like may be used.

(4) Display of character string data on transactions and image data of vouchers on transactions (display execution processing)
The display execution unit 102d displays the character string data on the transaction acquired by the character string acquisition unit 102b on the first screen, and when the predetermined area is selected on the first screen, the display execution unit 102d acquires the character string data The image data of the voucher regarding the transaction is displayed on the second screen.

  Specifically, as shown by the hatched records in the “details inquiry screen” of FIG. 8, the display execution unit 102d acquires the character string data “Trading date: 2017/10/10 acquired by the character string acquisition unit 102b. 01, amount of money: 10,800 yen, supplier: ○ × Transportation Co., Ltd., product name: taxi fee, abstract: 2017/10/01, taxi fee, Nippon Taro, document type: receipt ", the first screen ( Display on the screen of item inquiry).

  Here, in (3) (image acquisition processing), it is determined whether or not the voucher key can be acquired (step S4 in FIG. 9), but if the voucher key can be acquired (step S4 in FIG. 9) Yes), as shown in the hatched record of “Details inquiry screen” in FIG. 8, “○” mark is displayed in the column of vouchers (step S5 in FIG. 9), and when the voucher key can not be acquired (No in step S4 in FIG. 9), as shown in the second record from the top of the “details inquiry screen” in FIG. Step S6).

  Then, as shown in FIG. 8, when the predetermined area (the voucher button) is selected on the first screen (the screen for detailed inquiry), the display execution unit 102 d displays the “attachment screen of the voucher” of FIG. 8. As shown in FIG. 5, the image data of the taxi receipt acquired by the image acquisition unit 102c is displayed on the second screen (attachment screen of the voucher).

  Although not shown, the display execution unit 102d displays the character string data acquired by the character string acquisition unit 102b and the image data acquired by the image acquisition unit 102c on the same screen, not on separate screens. You may

(5) Summary As described above in (1) to (4), according to the data display device 100 according to the present embodiment, [3-1. Certificate attachment processing] and [3-2. The transaction data (character string data related to the transaction) generated in each basic system from the ledger (journal specification item) of the financial accounting system and the image data of the electronic voucher (the transaction related voucher) by satisfying the slip association processing]. Enabled to view). Since the ledger will be the entrance to the business flow in daily operations and audits, by implementing the reading function from the ledger, daily business efficiency can be improved.

[3-4. Summary]
As described above, according to the data display apparatus 100 according to the present embodiment, as described in [3-1] to [3-3], the character string data and the voucher image data related to the transaction corresponding to the designated journal entry. It can be displayed.

  Further, according to the data display apparatus 100 according to the present embodiment, for example, different slip numbers can be linked for each system at the time of cooperation from each backbone system. As a result, for example, it is possible to confirm transaction details and electronic vouchers when purchasing and expense repayment etc. occur from the financial accounting system. As a result, for example, it is possible to reduce the check load on the person in charge of accounting and to improve the work efficiency.

Also, in the field of financial accounting, there have conventionally been the following problems (1) to (2).
(1) There was no function to attach the computerized voucher and manage it in the system.
(2) It was not possible to view the transaction summary (the slip content) and the voucher (the computerized one) entered in each basic system from the journal entry details.
However, according to the data display device 100 according to the present embodiment, for example, it is possible to perform the following (3) to (4).
(3) An electronic voucher can be attached to a slip of each backbone system (refer to [3-1. Voucher attachment process]).
(4) The transaction summary and voucher of each backbone system can be confirmed from the ledger of the financial accounting system (refer to [3-2. Slip association processing] and [3-3. Voucher inquiry processing]).

[4. Other embodiments]
The present invention may be practiced in various different embodiments within the scope of the technical idea described in the claims in addition to the embodiments described above.

  For example, among the processes described in the embodiment, all or part of the process described as being automatically performed may be manually performed, or all the processes described as being manually performed. Alternatively, some of them can be performed automatically by known methods.

  In addition, information including processing procedures, control procedures, specific names, registered data of each processing, parameters such as search conditions, screen examples, and database configurations shown in the present specification and the drawings are described unless otherwise specified. Can be changed arbitrarily.

  Further, with regard to the data display device 100, each component shown in the drawings is functionally conceptual and does not necessarily have to be physically configured as shown.

  For example, with regard to the processing functions of the data display apparatus 100, in particular each processing function performed by the control unit, all or any part thereof may be realized by the CPU and a program interpreted and executed by the CPU. Well, it may be realized as wired logic hardware. The program is stored in a non-temporary computer-readable recording medium including programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment, and the data display apparatus as necessary. Mechanically read to 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). The computer program is executed by being loaded into the RAM, and cooperates with the CPU to configure the control unit.

  Also, the computer program may be stored in an application program server connected to the data display device 100 via any network, and it is possible to download all or a part of the computer program as needed. is there.

  Further, the program for executing the processing described in the present embodiment may be stored in a non-temporary computer readable recording medium, or may be configured as a program product. Here, the "recording medium" means a memory card, a universal serial bus (USB) memory, a secure digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an erasable programmable read only memory (EPROM), and an EEPROM (registration). Trademarks (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Blu-ray (registered trademark) Disc etc. Any "portable physical media It is intended to include.

  The “program” is a data processing method described in any language or description method, and may be in any format such as source code or binary code. Note that the “program” is not necessarily limited to one that is configured in a single way, and achieves its function in cooperation with a separate program represented by a plurality of modules or libraries or a separate program represented by the OS. Including things. In addition, as a specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, an installation procedure after reading, and the like, a known configuration and procedure can be used.

  The various databases and the like stored in the storage unit are storage devices such as RAM, memory devices such as ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, etc. Stores programs, tables, databases, files for web pages, etc.

  In addition, the data display device 100 may be configured as an information processing device such as a known personal computer or a work station, or may be configured as the information processing device to which any peripheral device is connected. Further, the data display device 100 may be realized by mounting software (including a program or data, etc.) that causes the device to realize the processing described in the present embodiment.

  Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them may be functionally or physically in any unit in accordance with various additions or according to functional load. It can be distributed and integrated. That is, the embodiments described above may be implemented in any combination, and the embodiments may be implemented selectively.

  The invention is useful in all industries and industries, but is particularly useful in the financial accounting industry.

100 Data Display Device 102 Control Unit
102a Basic slip acquisition unit
102b String acquisition unit
102c Image acquisition unit
102d display execution unit
102e storage unit
102 f Database acquisition unit 104 Communication interface unit 106 Storage unit
106a voucher data
106a1 voucher table
106a2 evidence image table
106b Expense Reimbursement Data
106b1 Expense adjustment data table
106b2 Related voucher table
106c Payment Management Data
106d Journal data
106e Document Number Association Table
106f Ledger data table
106g Line Item Inquiry Table
106h system information table 108 input / output interface unit 112 input device 114 output device 200 server 300 network

Claims (7)

A data display device comprising a control unit and a storage unit, the data display apparatus comprising:
The storage unit
A journal entry slip number, which is a slip number for performing transaction journal management in the financial accounting system, and a basic slip number, which is a slip number for performing the transaction management in the backbone system, are stored in association with each other,
The character string data on the transaction and the key slip number are linked and stored in the key system,
The image data of the voucher regarding the transaction, the voucher key corresponding to the image data, and the core slip number are stored in the core system in a linked manner,
The control unit
Basic slip acquisition means for acquiring the basic slip number associated with the journal entry slip number designated on the predetermined screen from the storage unit;
Character string acquisition means for acquiring the character string data associated with the basic slip number acquired by the basic slip acquisition means from the storage unit;
An image acquisition is performed to acquire the voucher key associated with the backbone slip number acquired by the backbone slip acquisition means from the storage unit, and further obtain the image data associated with the acquired voucher key from the storage unit. Means,
Display execution means for displaying on the screen the character string data acquired by the character string acquisition means and the image data acquired by the image acquisition means;
To provide
A data display device characterized by The storage unit
An expense slip number which is a kind of a core slip number and is a slip number in the expense settlement management of the transaction, and a payment slip number which is a kind of a core slip number and is a slip number in payment management of the transaction Payment records, and
An after-aggregation payment record including a payment document number, a type of core document number, and a post-aggregation payment document number which is a slip number obtained by aggregating the payment document numbers;
A journal record including linked post-aggregate payment document numbers and journal entry document numbers,
Is stored further,
The control unit
The post-aggregate payment slip number associated with the journal slip number included in the journal entry record is acquired from the journal entry record,
The payment slip number associated with the acquired post-aggregate payment slip number is acquired from the post-aggregation payment record,
The expense slip number associated with the acquired payment slip number is acquired from the payment record,
It further comprises storage means for correlating the acquired expense slip number with the journalizing slip number included in the journal record, and storing the stringing amount in the storage unit.
The data display device according to claim 1, characterized in that Core system identification information for identifying the core system is further linked to the core slip number and the journal entry number stored in the storage unit in a linked manner,
The storage unit
The backbone system identification information and database identification information for identifying the database to which the backbone system identified by the backbone system identification information belongs are linked and stored,
The basic slip acquisition means
The basic slip number and the basic system identification information associated with the journalizing slip number designated on the predetermined screen are acquired from the storage unit,
The control unit
The system further comprises database acquisition means for acquiring database identification information linked to the backbone system identification information acquired by the backbone slip acquisition means from the storage unit.
The character string acquisition unit
Acquiring the character string data associated with the core slip number acquired by the core slip acquisition means from the core system belonging to the database specified by the database identification information acquired by the database acquisition means;
The image acquisition means is
From the backbone system belonging to the database identified by the database identification information acquired by the database acquisition means, the voucher key linked to the backbone slip number acquired by the backbone slip acquisition means is acquired, and further, the backbone Acquiring the image data associated with the acquired voucher key from the system system;
The data display device according to claim 1 or 2, characterized in that The display execution means is
Displaying the character string data acquired by the character string acquiring unit on a first screen;
When the predetermined area is selected on the first screen, the image data acquired by the image acquiring unit is displayed on the second screen.
The data display device according to any one of claims 1 to 3, characterized in that The predetermined screen is a screen of a ledger,
The data display device according to any one of claims 1 to 4, characterized in that A data display method executed by an information processing apparatus including a control unit and a storage unit, the data display method comprising:
The storage unit
A journal entry slip number, which is a slip number for performing transaction journal management in the financial accounting system, and a basic slip number, which is a slip number for performing the transaction management in the backbone system, are stored in association with each other,
The character string data on the transaction and the key slip number are linked and stored in the key system,
The image data of the voucher regarding the transaction, the voucher key corresponding to the image data, and the core slip number are stored in the core system in a linked manner,
Executed by the controller
A basic slip acquisition step of acquiring from the storage unit the basic slip number which is linked with a journalizing slip number designated on a predetermined screen;
A character string acquisition step of acquiring, from the storage unit, the character string data associated with the core slip number acquired in the core slip acquisition step;
An image acquisition for acquiring from the storage unit the voucher key associated with the backbone slip number acquired at the backbone slip acquisition step, and further acquiring from the storage unit the image data associated with the acquired voucher key Step and
A display execution step of displaying on the screen the character string data acquired in the character string acquisition step and the image data acquired in the image acquisition step;
Including
Data display method characterized by A data display program for causing an information processing apparatus including a control unit and a storage unit to execute the program.
The storage unit
A journal entry slip number, which is a slip number for performing transaction journal management in the financial accounting system, and a basic slip number, which is a slip number for performing the transaction management in the backbone system, are stored in association with each other,
The character string data on the transaction and the key slip number are linked and stored in the key system,
The image data of the voucher regarding the transaction, the voucher key corresponding to the image data, and the core slip number are stored in the core system in a linked manner,
For the control unit to execute
A basic slip acquisition step of acquiring from the storage unit the basic slip number which is linked with a journalizing slip number designated on a predetermined screen;
A character string acquisition step of acquiring, from the storage unit, the character string data associated with the core slip number acquired in the core slip acquisition step;
An image acquisition for acquiring from the storage unit the voucher key associated with the backbone slip number acquired at the backbone slip acquisition step, and further acquiring from the storage unit the image data associated with the acquired voucher key Step and
A display execution step of displaying on the screen the character string data acquired in the character string acquisition step and the image data acquired in the image acquisition step;
Including
A data display program characterized by