Company retrieval system and company retrieval program

Abstract

To provide a company retrieval system and a company retrieval program that enable a user of banking institutions, etc., to search for a customer target company and make decisions for credit, etc., based on the actual status of the searched company.SOLUTION: A company retrieval system 1 according to the present invention comprises a company retrieval unit 12 that searches for a company matching search criteria entered on a search screen for searching a company displayed on a display 6 of a terminal 2, a real estate retrieval unit 13 that searches for real estate owned by the company retrieved by the company retrieval unit 12 and its representative, and a display 10 that displays the search results of the real estate retrieval unit 13 and the search results of the company retrieval unit 12 on the display 6.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a company search system and a company search program that can search for companies that match search criteria and search for real estate owned by the searched companies. [Background technology]

[0002] When financial institutions investigate companies that could become clients for financial services, they have traditionally analyzed the creditworthiness of a corporation based on its financial information and owned real estate, as described in the background art of Patent Document 1. In particular, while financial information figures are prone to change depending on accounting methods, the value of owned real estate is stable based on market data and roadside land values, and therefore has been given importance in credit decisions. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Publication No. 2023-101969 Summary of the Invention [Problem to be solved by the invention]

[0004] However, in cases where a potential customer of financial services is a proprietorship, the real estate may be owned in the personal name of the representative rather than in the name of the corporation. If a financial institution fails to realize that a client company has a large number of real estate properties in personal names and focuses only on the real estate properties in the name of the corporation, it may make a mistake in extending credit lines or propose inappropriate services.

[0005] The present invention has been made in consideration of the above circumstances, and aims to provide a company search system and a company search program that enable users such as financial institutions to search for companies that are potential customers and to make decisions on credit etc. based on the actual status of the searched companies. [Means for solving the problem]

[0006] In order to solve the above problem, the company search system of the present invention is characterized by comprising a company search means that searches for companies that match the search criteria when search criteria are entered on a search screen for searching for companies displayed on the display of a user terminal, a real estate search means that searches for companies searched for by the company search means and real estate owned by their representatives, and a result display means that displays the search results of the company search means and the search results of the real estate search means on the display.

[0007] The company search system of the present invention may include an area identification means for identifying an area on the map displayed on the display by operation of the user terminal, and the company search means may search for companies that meet the search criteria from among companies located in the area identified by the area identification means.

[0008] In the company search system according to the present invention, the result display means may display on the display the number of real estate properties owned by the companies and their representatives found by the company search means individually or in total.

[0009] The company search system of the present invention may further include an appraisal value calculation means for calculating the appraisal value of real estate searched by the real estate search means, and the result display means may display the appraisal value calculated by the appraisal value calculation means on the display, or may include a rent calculation means for calculating an estimated rent for real estate searched by the real estate search means, and the result display means may display the estimated rent calculated by the rent calculation means on the display.

[0010] In addition, the company search program of the present invention is characterized in that it causes a computer to function as a company search means that searches for companies that match the search conditions when search conditions are entered on a search screen for searching for companies displayed on the display of a user terminal, a real estate search means that searches for companies searched for by the company search means and real estate owned by their representatives, and a result display means that displays the search results of the company search means and the real estate search means on the display.

[0011] The company search program of the present invention causes a computer to function as an area identification means that identifies an area on a map displayed on the display through operation of the user terminal, and the company search means may search for companies that meet the search conditions from among companies located in the area identified by the area identification means.

[0012] According to the company search program of the present invention, the result display means may display on the display the number of real estate properties owned by the companies and their representatives searched for by the company search means individually or in total.

[0013] The company search program of the present invention may further cause a computer to function as an appraisal value calculation means for calculating the appraisal value of real estate searched by the real estate search means, and the result display means may cause the computer to function as a rent calculation means for calculating the estimated rent of real estate searched by the real estate search means, and the result display means may cause the computer to function as a rent calculation means for calculating the estimated rent of real estate searched by the real estate search means, and the result display means may cause the computer to function as a rent calculation means for calculating the estimated rent calculated by the rent calculation means on the display. [Effects of the Invention]

[0014] According to the present invention, users such as financial institutions can search for companies that are potential customers and can make credit decisions based on the actual status of the companies they search for. [Brief explanation of the drawings]

[0015] [Figure 1]1 is a block diagram showing a hardware configuration of a company search system according to an embodiment of the present invention, and a functional unit that functions when a company search program is executed. [Figure 2] 1 is a flowchart showing the processing of a company search system. [Figure 3] FIG. 10 is an explanatory diagram showing a login screen of a service site provided by the company search system. [Figure 4] FIG. 10 is an explanatory diagram showing a map screen of a service site. [Figure 5] FIG. 10 is an explanatory diagram showing a real estate information screen for real estate located at a point specified on the map on the map screen. [Figure 6] FIG. 10 is an explanatory diagram showing a pull-down menu displayed when the "TOOLS" button is selected on the map screen. [Figure 7] FIG. 10 is an explanatory diagram showing an "Area Investigation" screen displayed within a map screen. [Figure 8] FIG. 10 is an explanatory diagram showing a "Search by Company" screen displayed within a map screen. [Figure 9] FIG. 10 is an explanatory diagram showing a search result list and pins representing the locations of companies included in the search result list. [Figure 10] FIG. 10 is an explanatory diagram showing a company information screen for a company selected from the search result list. DETAILED DESCRIPTION OF THE INVENTION

[0016] An embodiment of the present invention will be described with reference to the drawings.

[0017] As shown in FIG. 1, a company search system 1 according to this embodiment includes a server 3 with which a terminal 2 used by a user can communicate, and a database 4 connected to or built into the server 3.

[0018] The terminal 2 is a computer such as a personal computer, tablet, or smartphone, and includes an operation unit 5 that accepts user operations, and a display 6.

[0019] The server 3 is composed of a computer such as a personal computer, and is equipped with a CPU 7 (Central Processing Unit), memory 8 consisting of a ROM (Read Only Memory), RAM (Random Access Memory), etc., and a recording unit 9 consisting of a HDD (Hard Disk Drive), SDD (Solid State Drive), etc.

[0020] The memory 8 stores programs necessary for startup and is used as a work area during processing by the CPU 7, and the recording unit 9 has installed therein a program (company search program) that causes the server 3 and database 4 to function as the company search system 1. By executing this program, the CPU 7 functions as the display unit 10, area identification unit 11, company search unit 12, real estate search unit 13, assessed value calculation unit 14, and rent calculation unit 15, causing the server 3 and database 4 to function as the company search system 1 and enabling the terminal 2 to access a service site provided by the server 3 (a service site where companies can be searched for).

[0021] Database 4 is composed of a computer such as a personal computer or a recording device such as a hard disk drive, and includes a company database 16 in which company information is recorded, and a real estate database 17 in which real estate information is recorded. Company database 16 records company registration information (for example, trade name, addresses of head office and branch offices, date of incorporation, purpose, amount of capital, name and address of representative) obtained from company / corporation registration certificates and certified copies of registers, as well as non-registration information of companies such as sales, profits, representative's date of birth, and contact details obtained from other sources as data such as CSV, and also records the company registration certificates and certified copies of registers as image data such as PDF.

[0022] In the real estate database 17, real estate registration information obtained from real estate registration certificates and certified copies of the registry (for example, real estate number, location, land number, land use, land area, house number, structure, floor area, cause and date (date of registration), owner's address and name, matters related to ownership, matters related to rights other than ownership (including mortgage establishment, cause of mortgage establishment and amount of claim, mortgagee, etc.), matters related to joint guarantees) is recorded as data in CSV format, etc., and the registration certificates and certified copies of the registry are recorded as image data in PDF format, etc.

[0023] In addition, the real estate database 17 records roadside land prices, standard land prices, announced land prices, market prices (actual prices), market rents (average rent per tsubo for each type of building and land, etc.) as basic information used to calculate the assessed value or rent of real estate.

[0024] As will be described later, the display unit 10 displays a login screen on the display 6 of the terminal 2 that accesses the service site, and also displays various screens after login.

[0025] When a pin 22 (described later) is positioned at a certain point on the map displayed on the display 6 by operating the operation unit 5, and the point is designated, the area specification unit 11 specifies the real estate located at the point and a predetermined area such as a city, ward, town, or village that includes the point. In this case, the area specification unit 11 specifies a town or village as the predetermined area.

[0026] The company search unit 12 accesses the company database 16 and searches for companies that match the search criteria when the company's sales or profits or the representative's age is entered as a search criterion on a search screen for searching for companies ("Search by Company" screen 28 described below) displayed on the display 6 of the terminal 5. For example, if the search criterion for the representative's age is 70 years or older and the search criterion is entered on June 1, 2024, the company search unit 12 searches for companies whose representative's date of birth is before June 1, 1954.

[0027] The real estate search unit 13 accesses the real estate database 17 and searches for information about the real estate identified by the area identification unit 11 (the real estate located at the point where the pin 22 is located).

[0028] Furthermore, the real estate search unit 13 accesses the real estate database 17 to search for real estate owned by the company searched for by the company search unit 12 and the representative of that company. That is, the real estate search unit 13 extracts from the real estate database 17 real estate whose trade name and address of the company searched for by the company search unit 12 and the name and address of the representative of that company match the name and address of the owner in the registration information.

[0029] The assessed value calculation unit 14 accesses the real estate database 17 to calculate the assessed value of the real estate identified by the area identification unit 11 or the real estate searched for by the real estate search unit 13. This calculation is performed simply by multiplying the land value by the area of ​​the real estate, but it may also be performed by any other method using the information stored in the real estate database 17.

[0030] The rent calculation unit 15 accesses the real estate database 17 to calculate the estimated rent of the real estate identified by the area identification unit 11 or the real estate searched for by the real estate search unit 13. Here, this calculation is performed simply by multiplying the market rent (average price per tsubo) by the area of ​​the real estate, but it may also be performed by any other method using the information stored in the real estate database 17.

[0031] Figure 2 shows the processing of the company search system 1. In the company search system 1, when a user accesses the login screen 20 of the service site shown in Figure 3 using the terminal 2 and logs in by entering their ID and password (step 1 (shown as "S.1" in Figure 2, and the same applies below)), the server 3 (display unit 10) displays a map screen 21 including a map on the display 6, as shown in Figure 4 (step 2).

[0032] When a user designates an arbitrary point on the map using pin 22 on map screen 21 by operating operation unit 5, server 3 (display unit 10, area identification unit 11, real estate search unit 13) accesses real estate database 17 to obtain information such as the address and lot number of the real estate located at the point of pin 22, and displays real estate information screen 23 showing the obtained information within map screen 21 (superimposed on map screen 21), as shown in Fig. 5. At this time, server 3 (display unit 10, area identification unit 11, real estate search unit 13, assessed value calculation unit 15, rent calculation unit 16) may obtain information such as land value from real estate database 17, calculate the assessed value of the real estate located at the point of pin 22 (or the estimated rent if the rent can be estimated), and display the assessed value, etc. on real estate information screen 23, thereby enabling the user to know the real estate located at the point of pin 22 from the perspective of stock (or cash flow).

[0033] On the map screen 21, when the user selects the "TOOLS" button 24 in the upper right corner of the screen by operating the operation unit 5 as shown in Figure 6, and then selects the "Area Survey" button 25 from the pull-down menu that appears to specify an area (step 3), the server 3 (display unit 10, area identification unit 11) identifies the area that includes the location of the pin 22 as "Nihonbashi Muromachi, Chuo-ku" (step 4), and displays the "Area Survey" screen 26 on the map screen 21 as shown in Figure 7 (step 5).

[0034] When the user selects the "Search by Company" button 27 on the "Area Investigation" screen 26 by operating the operation unit 5 (step 6), the server 3 (display unit 10, company search unit 12) displays the "Search by Company" screen 28 on the map screen 21 (step 7), as shown in Figure 8. The "Search by Company" screen 28 displays the area identified in step 4, such as "Nihonbashi Muromachi, Chuo-ku, Tokyo," as well as toggle buttons 29a-29c and sliders 30a-30c for specifying whether to use the representative's age ("President's Age" in Figure 8), sales, and profit as search criteria, and, if so, the range of sales and profits. If so, the screen also displays a "GO" button 31 for confirming the search criteria. (Note that in Figure 8, "President's Age" is set to "70 years old or older," "Sales" is set to "1 billion yen to 10 billion yen," and "Profit" is set to "-1 billion yen to 0 yen," enabling a search for small and medium-sized enterprises likely to have succession issues.)

[0035] On the "Search by Company" screen 28, the user operates the operation unit 5 to set search conditions using the toggle buttons 29a to 29c and sliders 30a to 30c, and then clicks the "GO" button 31 to enter the search conditions (step 8).The server 3 (company search unit 12) then accesses the company database 16 to search for companies in the area identified in step 4 that match the search conditions entered in step 8 (step 9).

[0036] Next, the server 3 (display unit 10, real estate search unit 13) accesses the real estate database 17 to search for the companies found in step 9 and the real estate owned by their representatives (step 10), and generates a list (search result list) for the companies found in step 9, including the company name, address, name and age of the representative, sales, profit, and the number of real estate owned by the company and the representative (the total number of land parcels, buildings, and units) (step 11).As shown in Figure 9, the display 6 displays a "Company List" screen 32 including the list created in step 11 (step 12), and displays the locations of the companies included in the "Company List" screen 32 on a map with pins 33 (step 13).

[0037] When the user selects a company from the "Company List" screen 32 by operating the operation unit 5 or by clicking the pin 33 or the like (step 14), the server 3 (display unit 10, assessed value calculation unit 14, rent calculation unit 15) accesses the company database 16 to acquire various information such as the date of establishment, telephone number, business field, sales, capital, and the name and address of the representative of the company selected in step 14 (step 15), and also accesses the real estate database 17 to acquire the land value and average price per tsubo for the real estate owned by the company and the representative. After obtaining the information, the appraised value and the expected rental income (projected rental income) if the property is rented are calculated (step 16), and a company information screen 34 showing detailed information about the company (company name, company address, date of establishment, telephone number, industry (business field), sales, capital, number of employees, representative, representative address, number of land parcels held by the company (number of properties owned by the company), its total asset value (appraised value) and projected rental income, as well as number of land parcels held by the president (number of properties owned by the representative), its total asset value and projected rental income) is displayed at the position of the pin 33 corresponding to the company, as shown in Figure 10 (step 17).

[0038] The company search system 1 of this embodiment is equipped with a company search unit 12 that searches for companies that match the search criteria when search criteria are entered on a search screen for searching for companies displayed on the display 6 of the terminal 2, a real estate search unit 13 that searches for companies searched for by the company search unit 12 and real estate owned by their representatives, and a display unit 10 that displays the search results of the company search unit 12 and the real estate search unit 13 on the display 6, so that users of financial institutions, etc. can search for companies that are potential customers using the company search unit 12 and see the search results displayed on the display 6 by the display unit 10.

[0039] Furthermore, the real estate search unit 13 searches not only for the companies searched by the company search unit 12 but also for real estate owned by the representatives of those companies, so that even if the company searched for by the user owns real estate in the personal name of the representative rather than in the name of a corporation, it is possible to make a judgment on credit etc. according to the actual situation of the company.

[0040] The company search system 1 is equipped with an area identification unit 11 that identifies an area on a map displayed on a display 6 by operating the operation unit 5 of the terminal 2, and the company search unit 12 searches for companies that match the search criteria from among the companies located in the area identified by the area identification unit 11. Therefore, when the user wants to search for companies focusing on a certain area (for example, if the user is a branch of a financial institution and wants to narrow down the search for customers to companies located in the area under the jurisdiction of that branch), the user can conveniently specify the area from the map.

[0041] Furthermore, the company search system 1 is equipped with an appraisal value calculation unit 14 that calculates the appraised value of real estate searched by the real estate search unit 13, and the display unit 10 displays the appraised value calculated by the appraisal value calculation unit 14 on the display 6, so that the user can learn about the company's real estate from the perspective of stock, and the company search system 1 is equipped with a rent calculation unit 15 that calculates the estimated rent of the real estate searched by the real estate search unit 13, and the display unit 10 displays the estimated rent calculated by the rent calculation unit 15 on the display 6, so that the user can also learn about the company's real estate from the perspective of cash flow.

[0042] Although the embodiments of the present invention have been described above as examples, the embodiments of the present invention are not limited to those described above, and may be modified as appropriate within the scope of the invention.

[0043] For example, in the above embodiment, the search criteria for searching for a company by the company search unit 12 were described as the company's sales or profits or the age of the representative, but the search criteria are not limited to these and may be any criteria.

[0044] Furthermore, in the calculations by the assessed value calculation unit 14 and the rent calculation unit 15, data other than land value and market rent may be used, and road access and other conditions may be taken into account. Regarding the number of properties owned by the company and its representative, the display unit 10 may display the properties individually to make the details easier to understand, rather than displaying the total as in the above embodiment to make the overall picture of the owned properties easier to understand.

[0045] Furthermore, the server 3 may appropriately display on the display 6 a button or the like for obtaining registration information for obtaining registration information (including a certificate of registered matters) about a company or real estate, and when the user selects the button or the like by clicking or the like, the server 3 may access the company database 16, the real estate database 17, or a registration information providing service operated by the General Incorporated Foundation Civil Law Association, etc., to obtain the registration information, and display the obtained registration information on the display 6. In this case, the server 3 may obtain the registration information about the company or real estate individually, or may obtain the registration information about all companies included in the "Company List" screen 32 all at once, or may obtain the registration information about a certain company and all real estate owned by its representative all at once. [Explanation of symbols]

[0046] 1. Company search system 2. Terminal (user terminal) 3 Server (computer) 4 Database 5 Control section 6. Display 10 Display section (result display means) 11 Area identification unit (area identification means) 12 Company Search Section (Company Search Method) 13 Real Estate Search Section (Real Estate Search Method) 14 Valuation calculation unit (valuation calculation means) 15 Rent Calculation Section (Rent Calculation Method)

Claims

1. a company search means for searching for companies that match search criteria when search criteria are input on a search screen for searching for companies displayed on a display of a user terminal; a real estate search means for searching for real estate owned by the companies searched for by the company search means and their representatives; A company search system comprising a result display means for displaying the search results of the company search means and the search results of the real estate search means on the display.

2. an area specifying means for specifying an area on the map displayed on the display by operating the user terminal; 2. The company search system according to claim 1, wherein the company search means searches for a company that matches the search conditions from among companies located in the area specified by the area specification means.

3. 3. The company search system according to claim 1, wherein the result display means displays on the display the number of real estate properties owned by the companies and their representatives found by the company search means individually or in total.

4. a valuation calculation means for calculating the valuation of real estate searched by the real estate search means, 3. The company search system according to claim 1, wherein the result display means displays the valuation amount calculated by the valuation amount calculation means on the display.

5. a valuation calculation means for calculating the valuation of real estate searched by the real estate search means, 4. The company search system according to claim 3, wherein the result display means displays the valuation calculated by the valuation calculation means on the display.

6. a rent calculation means for calculating an estimated rent for the real estate searched by the real estate search means; 3. The company search system according to claim 1, wherein the result display means displays the estimated rent calculated by the rent calculation means on the display.

7. a rent calculation means for calculating an estimated rent for the real estate searched by the real estate search means; 4. The company search system according to claim 3, wherein the result display means displays the estimated rent calculated by the rent calculation means on the display.

8. Computer, a company search means for searching for companies that match search criteria when search criteria are entered on a search screen for searching for companies displayed on a display of a user terminal; a real estate search means for searching for real estate owned by the companies searched for by the company search means and their representatives; and a result display means for displaying the search results of the company search means and the search results of the real estate search means on the display; A company search program that acts as a

9. Computer, an area specifying means for specifying an area on the map displayed on the display by operating the user terminal; It functions as 9. The company search program according to claim 8, wherein the company search means searches for a company that matches the search conditions from among companies in the area specified by the area specification means.

10. 10. The company search program according to claim 8, wherein the result display means displays on the display the number of real estate properties owned by the companies and their representatives found by the company search means individually or in total.

11. Computer, an appraisal value calculation means for calculating the appraisal value of the real estate searched by the real estate search means; It functions as 10. The company search program according to claim 8, wherein the result display means displays the valuation calculated by the valuation calculation means on the display.

12. Computer, an appraisal value calculation means for calculating the appraisal value of the real estate searched by the real estate search means; It functions as 11. The company search program according to claim 10, wherein the result display means displays the valuation calculated by the valuation calculation means on the display.

13. Computer, a rent calculation means for calculating an estimated rent for the real estate searched by the real estate search means; It functions as 10. The company search program according to claim 8, wherein the result display means displays the estimated rent calculated by the rent calculation means on the display.

14. Computer, a rent calculation means for calculating an estimated rent for the real estate searched by the real estate search means; It functions as 11. The company search program according to claim 10, wherein the result display means displays the estimated rent calculated by the rent calculation means on the display.

Images