JP2002092514A - Content reference database for transaction contract such as lease for vendor and content reference database for transaction contact such as lease for vendor - Google Patents

Abstract

PROBLEM TO BE SOLVED: To allow a vendor to efficiently and immediately obtain the contract content information related to a transaction such as lease, thereby reducing a lease company's load for inquiry response, and further to perform a business action incorporated with the lease company. SOLUTION: The contract content information related to one transaction contract of lease or the like is stored as one storage unit 106 every article, and an optional piece of information containing the information for the vendor to which the article is supplied is set as each data item of the storage unit 106. To the retrieval request of the vendor-side terminal connected through a communication circuit, the storage unit containing the article information related to the vendor is set as the range to be outputted.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION The present invention relates to a method in which a vendor (refers to a property supplier in a leasing or installment sales transaction, and all other parts are used in the same sense in the present application) immediately refers to, for example, information on a lease contract. Technology that can be done.

[0002]

2. Description of the Related Art Transactions for leasing and installment sales (hereinafter simply referred to as "lease transactions," etc., in the present application, all other parts are used in the same sense) are basically the same. Hereinafter, it is simply referred to as "lease company", and in this application, all other parts are used in the same meaning.) For the property, the leasing company and the user (refer to the customer who is the user of the property, all the same in this application) ), The property is delivered to the user.

[0003] In such leasing transactions, vendors are required to deliver their products to more users.
The business activity is to be performed, and the user who has already delivered his / her own product under a contract such as a lease will perform the business activity while providing information such as a property upgrade.

[0004] However, in such a vendor's business activities, contract content information on lease contracts such as lease start date (acceptance date), lease / installment period, lease end date (expiration date) is very important. However, such information is basically known only to companies such as leasing companies and users, while information on the vendor side is more limited information for maintenance and management (based on the serial number of the property in question). Information and limited information such as the delivery location). Therefore, the sales staff of the vendor individually listens to the leasing company or the user, or the user who leases the contract from the leasing company for a predetermined period of time. Or collectively collect data.

On the other hand, as a leasing company, if a user wishes to deliver a new property as a result of a vendor's business activities, if the information can be quickly known,
New lease contracts can be presented and other leasing companies can be pioneered, but the vendor's business activity information can only be understood by contacting the vendor. Contract expiration information for leases and other transactions held in the company is also output periodically (for example, a list of contracts that are in the first half year of contract expiration every month is distributed in the company). Not surprisingly, it is not linked to the start of the vendor's business activities.

[0006]

On the vendor side, it is very inefficient to collect information because it is only possible to obtain contract content information on lease transactions that are very important in business activities. Only the information is available, so the ability of the sales person
Looking at the vendor company as a whole, it was information on bug eating. In addition, even if the inquiries to the leasing company about the contract content information relating to the leasing transaction contract for the predetermined user, it is necessary to wait for the processing of the leasing company, and there is also a problem that the contract content information cannot be obtained immediately.

In addition, in the case of a leasing company, a database file must be created and provided to the vendor using spreadsheet software or database software each time the vendor inquires about the contract contents of the leasing transaction. Must
The labor burden, whether individual or collective, was extremely time and cost intensive.

[0008] Further, the leasing company cannot know the vendor's business activity information unless contacted by the vendor, and based on the contract contents information on the leasing transaction held by the company, the contract is based on the contract contents information. When conducting business activities such as renewal, the information is output periodically. For example, in the case of a property (for example, PC) whose cycle is extremely shorter than the lease period, the vendor's business In some cases, activities were preceded and they could not be involved in contracts such as leasing.

The present invention has been made in view of the above-described problems of the prior art, and enables a vendor to efficiently and immediately obtain contract content information on transactions such as lease.
Accordingly, the present invention aims to provide an innovative database and system that can reduce the burden of inquiring and answering of a leasing company or the like, and further enable joint business activities between a vendor and a leasing company.

[0010]

For this purpose, the present application first provides a vendor lease contract reference database, which stores contract content information on one lease transaction contract for each property. Any information, including at least the vendor information that supplied the property, is set as each data item of the storage unit, and the vendor terminal connected via a communication line. In response to the search request, a storage unit including property information related to the vendor is set as an output target range.

Here, the contract content information relating to the lease transaction contract refers to the main contract contents (so-called main items, for example, contract user name, contract user address, vendor name, property name, etc.) signed in the lease transaction contract. , Property quantity, delivery place, inspection date, lease period, lease fee, etc.), and any other related information (eg, ID number assigned for data management) etc. Is also good. In addition, the fact that the contract content information on such a lease transaction contract is stored as one storage unit for each property is that one lease transaction contract includes a plurality of properties supplied from different vendors. Generally, it is included (for example, in the case of a PC-related device set collective contract, the PC body is an A vendor, the display is a B vendor,
If the printer is supplied from the C vendor and the scanner is supplied from the D vendor respectively), if the transaction contract is output as a batch, detailed information cannot be output efficiently, and even more, the vendor who has requested the search must be In order to output information of other unrelated vendors, one storage unit is set for each property (for example, in the case of the parentheses, the PC main unit, the display, A record of contract content information is created and stored for each printer and scanner).

The property information related to the vendor includes, as an output target range, property information supplied by the vendor connected via a communication line and property information supplied by a vendor related to the vendor. The typical cases that are related include the case where each vendor is the same company, the case of a parent company and a subsidiary company (an example of the former is the Tokyo sales office of Company A). The vendor is related to the company's Osaka sales office.) Of course, whether or not they are related is determined arbitrarily (for example, the desire of the vendor), and there is no need to set a particularly related range (in that case, only the property information of the vendor is used). In this way, the storage unit including the property information of the related vendor is also set as the output target range, for example, when planning or expanding business promotion for the entire company, when managing the company as a whole, or The company can respond to a wide range of vendor requirements, such as when the parent company manages information on subsidiaries.

With such a database, the person in charge of each vendor can easily search for contract content information on his / her property via his / her own terminal via a communication line and output a response. Sales activities can be immediately performed based on the output response. In addition, since the relevant information of the vendor is also output as an output target, the business management department of the vendor can also grasp the overall contract status of the relevant vendor (for example, all departments of the whole company), and Planning for sales promotion etc. can be performed. On the other hand, there is no need to contact the leasing company for inquiries about the contract details, so that the burden on the leasing company is significantly reduced.

By the way, since the contract content information to be stored in the database is usually managed by a company such as a leasing company, it is generally considered that the database is generally managed by a center of the company such as a leasing company. . In such a case, since the database includes a log file (historical file) that records search history information of a searcher, a company such as a leasing company may refer to the history information of the log file to obtain a predetermined log file. Will find out what contract content information the vendor has searched for and when. That is, the leasing company can sequentially manage what kind of search request is made by a predetermined vendor, and the business activity of the vendor can be predicted. As a result, it is possible to communicate with the vendor and jointly carry out business activities such as renewal of a lease contract.

In consideration of such advantages, in the present application, the database is provided in a company center such as a lease which can be connected from a vendor terminal via a communication line. The content reference system is provided as the invention of claim 2.

[0016]

DESCRIPTION OF THE PREFERRED EMBODIMENTS An example of a specific embodiment according to the present invention will be described with reference to the drawings.

FIG. 1 is a schematic diagram showing the entire system.
1 is the center, 2 is the vendor terminal, 3 is the Internet, 10
Indicates a Web server, and 11 indicates a database server.

In this embodiment, the center 1 has a configuration managed and operated by a predetermined leasing company, and includes a Web server 10 and a database server 11 as shown in the figure. Web
The server 10 is a server that distributes information of a search Web page described later, and exchanges information with the vendor terminal 2 and the database server 11.

The database server 11 is a means for performing a response output process in response to a search request from the vendor terminal 2 via the Web server 10, and includes a database (100 shown in FIG. 2) storing information and a database management. And a control system (not shown).

As shown in FIG. 2, the database 100
It has a plurality of files in a table format. Here, a contract content information table 101, an asset information table 104, a vendor ID reference table 105, and a user master table 108
, A log (historical) table 103 is set. The contract content information table 101 stores contract content information relating to all transactions such as leasing.

The asset information table 104 divides the contract content information stored in the contract content information table 101 into respective properties (omitted when properties other than the main property are omitted in the contract content information). The information is divided by adding the property that has been added), and each record is formed as one record 106.
That is, “Asset No”, which is an ID unique to each property, is set as a data item of the record 106, and the “Asset N”
The data item "o" is set as the primary key of the record 106 by being combined with the item "contract No." As another data item of the record 106, "property name"
“Vendor number” and the like are selected and set as data items of the contract content information. Here, the vendor number is an internal office serial number that the leasing company conveniently assigns to manage the vendor within the company.

The vendor ID reference table 105 includes data items such as “vendor number”, “vendor name”, and “controlling company ID”. The user master table 108 includes “user I
One record is formed from data items such as "D", "user name", and "supervising company ID". In these items, “user ID” is replaced by “vendor number” and “user name”
Corresponds to the “vendor name”. In particular, “user ID” is a data item used as recognition information when each vendor logs in. The “supervising company ID” is a supervising name ID of a related vendor.

The “supervising company ID” of the user master table 108 is associated with that of the vendor ID reference table 105, and the “vendor number” of the vendor ID reference table 105 is associated with that of the asset information table 104. By these means, if the user logs in at least with the "user ID" (assuming that the passwords match, of course), the user master table 108 and the vendor I
In comparison with the data items of the D reference table 105, a record 106 of a vendor number having a matching “controlling company ID” in the asset information table 104 can be searched (search control is performed by the database management control system).

The log table 103 records search history information of each vendor who has made a search request to the database 100.

The database management control system is constructed from a database management system (DBMS) and control devices.
When there is a search request via the server 10, control is performed to cause the asset information table 104 to perform a search response output operation. When a search request is made by directly accessing the database server 11, control is performed not only on the asset information table 104 but also on the contract content information table 101 and the log table 103 to process the search response output operation.
In this embodiment, means for directly accessing the database server 11 is provided only on the leasing company center 1 side.

Next, an example of retrieval from a vendor in the above system will be described. Note that, in the following description, the screen display is on a display provided in the vendor terminal 2, and each terminal 2 has a browser capable of displaying information received from the Web server 10 on the display. It is assumed that

When the vendor terminal 2 accesses the Web server 10 of the center 1 via the Internet 3, the top page of the Web site of the leasing company opens and a user ID and password input screen is displayed (not shown). ). When the user ID and password are entered and it is confirmed that they match, a service selection menu screen including the present search service is displayed (not shown).

When this search service is selected, a search screen such as "search for contract transaction list" as shown in FIG. 3 is displayed. At this time, the processing of the database server 11 searches the data in the asset information table 104 of the database 100 based on the input of the user ID, and the processing first includes the user master table 108 and the vendor ID reference table. According to 105, information on the controlling company ID corresponding to the input user ID is retrieved from the record 106 in the asset information table 104, that is, the controlling company ID
Are extracted as the output target range. Based on such a processing result, the screen of FIG.
The name of the vendor that is performing the search is displayed as “Sales Co., Ltd. First Sales Department” and the controlling company I
A record that matches D (here, Co., Ltd.)
The number of contract numbers out of 106 will be displayed as "There are x contracts." This screen also serves as a search condition input screen, and the user names “customer name”, “contract number”, “contract date”, “acceptance date”, and the like are search conditions.

When the search conditions are entered, a search result screen such as "customer name list" as shown in FIG. 4 is displayed (if there is only one user (customer), the screen immediately shifts to the screen shown in FIG. 5). Do). At this time, the processing of the database server 11 is performed on the record 10 extracted as the output target range.
From 6, the record 106 that matches the search condition is extracted as the final output target. Based on such processing results, the number of contract Nos in the extracted records 106 is displayed as “the search result was ×” on the screen of FIG. at the same time,
"Customer name""Address""DL charge place" for each contract
"Number" is displayed as information, and each user (customer name)
Command buttons ("details" in the figure) for outputting a list of contract information for each item are also displayed.

When the command button is clicked, FIG.
An output screen such as "Contract List" is displayed. As shown in the figure, the contract information on the selected user (customer name) is displayed for each contract number as “contract number” and “contract date”.
"Inspection date", "Expiration date", "Remaining frequency", "Release frequency", "Location of our company (the relevant leasing company)" are output as data items. These output items are, among the data items of the record 106 extracted as the final output target described above, those data items that are collectively displayed for each common contract number (for this reason, they are displayed in units of the records 106). Not). At the same time, a text link ("property" in the figure) for individually outputting property information (asset information) for each contract number is also displayed.

When the text link is clicked, FIG.
Is displayed as shown in FIG. As shown in the figure, for each property in each contract, the "number of properties", "property price", "recovery amount each time", "property installation location" are output as data items, and "contract number" is a common data item for each property. "Customer name""Contractdate""Inspectiondate"
The “expiration date”, “remaining number”, and “release number” are output.
Among these output items, of the data items of the record 106 extracted as the final output target described above, common items are collectively displayed as contract information in the upper row, and property-specific data items are displayed in the lower row in a table format. It is what is displayed.

As is apparent from this search example, the person in charge of each vendor can easily and immediately obtain contract content information on his / her user from his / her terminal 2. In particular, finally, the screen shown in FIG.
As information for each property, the contract content information can be known in detail. Moreover, since information is stored in units of properties, even if properties of other companies are included in the same contract, information on properties of other companies is not searched,
Vendors no longer have to worry about leaking their property information. Furthermore, since the maximum output range for search is the company unit associated with the company name, not only the person in charge of each vendor, but also the sales manager of that company tries to get all the information of the company Even in this case, all information can be obtained without any problem.

On the other hand, also as a leasing company, since each vendor can obtain contract content information by using this search system, there is no need to make inquiries by telephone or the like as in the past, and the labor required for answering inquiries is required. Is alleviated.
Moreover, in this system, the leasing company center 1 directly accesses the database server 11 and
It is possible to search the history information in 103, and to understand what kind of contract contents information each person in charge of the vendor wants to know now, that is, what kind of sales activities are going to be done Can be done. For this reason, if necessary, it is possible to contact the vendor in charge and jointly carry out business activities for a transaction contract such as a lease.

[0034]

As described above in detail, according to the invention of the present application, each vendor can efficiently and promptly obtain contract content information relating to a transaction such as a lease, and can perform a quick sales activity. It will be. Also, the output target includes the property information related to the vendor,
The information can be more widely used within the relevant vendors. However, since information that is not related to the vendor to be searched is not output, there is no possibility that the contract content information leaks to the vendor that is completely unrelated.

In a company such as a leasing company, each vendor obtains its own contract information from the database, so that the inquiry is not sent directly by telephone or the like, and the labor required for the conventional inquiry response is eliminated. The burden is eliminated. Accordingly, it is possible to concentrate energy on one's own business activities, thereby promoting sales activities.

Furthermore, if the database is provided in the leasing company center, the leasing company can obtain the search information accessed by each vendor, so that the leasing company can predict the business activities of the vendor. It will be able to do so and, if necessary, contact the vendor to jointly conduct sales activities on the property.

[Brief description of the drawings]

FIG. 1 is a schematic diagram showing an entire system according to an embodiment.

FIG. 2 is an explanatory diagram showing a data storage state in a database.

FIG. 3 is an example of an output screen of a vendor terminal, and is an explanatory diagram of an output screen immediately after a vendor ID number has been input;

FIG. 4 is an example of an output screen of a vendor terminal, and is an explanatory diagram of an output screen immediately after a search condition is input.

5 is an example of an output screen of a vendor terminal, and is an explanatory diagram of an output screen displaying contract list information of a company selected on the screen of FIG. 4;

6 is an example of an output screen of a vendor terminal, and is an explanatory diagram of an output screen displaying property information of a contract selected on the screen of FIG. 5;

[Explanation of symbols]

 1 Center 2 Vendor terminal 3 Internet 10 Web server 11 Database server 100 Database 101 Contract information table 103 Log table 104 Asset information table 105 Vendor ID reference table 106,107 records

Claims (2)

[Claims] 1. An arbitrary contract content information relating to one lease contract, etc., as a storage unit for one property for each property, and including at least vendor information of the contract content information among the contract content information. The information is set as each data item of the storage unit, and in response to a search request for a vendor-side terminal connected via a communication line, the storage unit including property information related to the vendor is set as an output target range. Reference database of transaction contract details for vendor leases. 2. An arbitrary contract content information relating to one lease contract, etc., as a storage unit for one property for each property, and at least one of the contract content information including information on a vendor supplying the property. Information is set as each data item of the storage unit, and in response to a search request of a vendor terminal connected via a communication line, a database in which a storage unit including property information related to the vendor is set as an output target range. And a transaction reference system for vendor contracts, such as a lease, which is provided at a company center, such as a lease connectable from a vendor terminal via a communication line.