CN1458601A - Decision support system and method for income credit - Google Patents
Decision support system and method for income credit Download PDFInfo
- Publication number
- CN1458601A CN1458601A CN 02115247 CN02115247A CN1458601A CN 1458601 A CN1458601 A CN 1458601A CN 02115247 CN02115247 CN 02115247 CN 02115247 A CN02115247 A CN 02115247A CN 1458601 A CN1458601 A CN 1458601A
- Authority
- CN
- China
- Prior art keywords
- accounts receivable
- data
- user
- database
- accounts
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The present invention relates to decision support system and method for on-line analyzing and processing receivable accounts. The system includes one finance and accounting data base, one date base server and one web server, where the date base server includes one multidimensional receivable account data set and one receivable account data base, and the web server includes one receivable account inquiring and analyzing module. The historical and current receivable account data of the company stored in the finance and accounting data base are transmitted the receivable account data base and the multidimensional receivable account data set is established by utilizing the receivable account data base as data source and the on-line analyzing and processing system. The user accesses the multidimensional receivable account data set via calling the receivable account inquiring and analyzing module with browser to perform relevant inquiry and analysis.
Description
[invention field]
The present invention relates to a kind of accounts receivable decision support system and method, especially refer to a kind of by using the on-line analysis disposal system, make the user carry out on-line analysis, thereby the decision support system and the method for support are provided for managerial personnel's decision-making enterprise's history and current accounts receivable data.
[background of invention]
Correct decision-making is that company exists and important condition of development.No matter senior management staff's decision-making, still in low layer managerial personnel's decision-making, related management personnel need all that historical and current financial position have one clearly to understand to company.Can become one of key condition of decision-making correctness to company is historical and current Financial Information carries out easily and fast, inquiry timely and analysis.
Utilize the internet, the technology of relevant information being carried out remote inquiry, analysis and management is comparatively ripe.For example in the U.S. the 6th of bulletin on February 26th, 2002,350, No. 066, name is called " information stores, transmission and management system and method " (Systems and methods forstoring, delivering, and managing messages) patent has promptly disclosed a kind of information stores, transmission and management system and method.As shown in Figure 1, be the structural drawing of a kind of information stores, transmission and management system.Wherein, the government department 4 of telephone operator links together with phone 1, facsimile recorder 2 or the computer 3 of company, and company is delivered to relevant information by phone 1, facsimile recorder 2 or computer 3 government department 4 of telephone operator.Direct inner dialing main line in the government department 4 (Direct Inward Dialing Trunk) 5 is sent to information stores and transmission system (Message Storage and DeliverySystem with the information that receives; MSDS) 6, the central processing unit of MSDS 6 is checked the address information in the information that sends, and all information translation is become Hypertext Markup Language (Hyper-text Markup Language after affirmation; HTML) store database into.User 8 is connected with MSDS 6 via internet 7 by computer, just can inquire about the information that is stored in wherein after password check.
Though above-mentioned information stores, transmission and management system provide the technology of information stores, transmission and management, exist some deficiency in the utilization of reality.The deficiency that this system exists is: when company need transmit a new information or need to upgrade original information, all need by the passing on of telephone operator, and can not directly be connected with information stores and transmission system.Another deficiency is: though telephone operator can provide many direct inner dialing main lines for information transmission usefulness, the number that can provide is limited.Above-described deficiency has limited the transmission of the bulk information of company, thereby the user can not effectively be inquired about, and passes through passing on of telephone operator, has also increased the expense of company greatly.Therefore, at the deficiency of above-mentioned information stores, transmission and management system, the invention provides a kind of more efficiently company accounts receivable decision support system and method.
[summary of the invention]
Fundamental purpose of the present invention is to provide a kind of accounts receivable decision support system and method, realizes the transmission of company's accounts receivable data.
Another object of the present invention is to provide a kind of accounts receivable decision support system and method, make managerial personnel carry out easily and fast inquiry and analysis, thereby provide support for managerial personnel's decision-making the global accounts receivable data of company.
For reaching above-mentioned goal of the invention, the invention provides a kind of system that company's whole world accounts receivable is inquired about, making the user is the accounts receivable cube (Cube) of data source by internet access with the accounts receivable database, thereby reaches the purpose that the global accounts receivable data of company is inquired about.This system includes: a financial accounting database is used to store and management company's history and current global accounts receivable data and other financial accounting data; One database server, it includes an accounts receivable database and accounts receivable cube, the accounts receivable database is used to store from the next global accounts receivable data of financial accounting database transmissions, the accounts receivable cube, being used for storage is data source and treated multidimensional data with the accounts receivable database; One Web server, be used to user's inquiry that the service of Web interface is provided, comprising user's login authentication module, an authority management module, an accounts receivable query analysis module, a funds on account filling module, a counterbalanced accounts record queries module and a cash in banks unusual fluctuation enquiry module are arranged; User's login authentication module is carried out subscriber authentication when being used for that the user logined Web server; Authority management module is used for the regulation different user and accounts receivable is inquired about the authority that is had; Accounts receivable query analysis module, it is used such as querying methods such as inquiry mode, Query Result display modes to be used to stipulate that the user inquires about accounts receivable; Funds on account filling module is used for every accounts receivable is added necessary explanation and note; Counterbalanced accounts record queries module is used for the user data of bank's counterbalanced accounts record of company is inquired about; Cash in banks unusual fluctuation enquiry module is used for the user variation of company's cash in banks is inquired about.
The present invention also provides a kind of method that the global accounts receivable of company is inquired about and analyzed, the user can be by internet access accounts receivable cube, thereby reach the purpose that the global accounts receivable data of company is inquired about, this method comprises following step: (a) the financial accounting database is by data-switching service (Data Transformation Service; DTS) data that will be stored in wherein is transferred to the accounts receivable database; (b) the accounts receivable database receives the data from the financial accounting database, and according to the wherein original data of the data regular update that receives; (c) be data source with the accounts receivable database, utilize on-line analysis disposal system (OnlineAnalytical Process; OLAP) build to put and generate the accounts receivable cube; (d) user by the internet with security socket layer (Security Socket Layer; SSL) mode is visited Web server, and Web server is connected with the accounts receivable cube, realizes the inquiry to company's whole world accounts receivable.
Utilize system and method provided by the present invention, the related personnel is inquired about the accounts receivable data quickly and efficiently, eurypalynous querying method makes the related personnel can obtain to meet the information of decision-making needs in simple and clear mode from lot of data, thereby provides support for the decision-making of company.
[description of drawings]
Fig. 1 is the structural drawing of a kind of existing information stores, transmission and management system.
Fig. 2 is the basic block diagram of accounts receivable decision support system of the present invention and method.
Fig. 3 is each module structure drafting in the Web server of accounts receivable decision support system of the present invention and method.
Fig. 4 be accounts receivable decision support system of the present invention and method from the financial accounting database to accounts receivable data of database transfer process figure.
Fig. 5 is the selection inquiry mode interface figure of accounts receivable decision support system of the present invention and method.
Fig. 6 is the accounts receivable querying flow figure of accounts receivable decision support system of the present invention and method.
Fig. 7 is other financial accounting data check process flow diagram of accounts receivable decision support system of the present invention and method.
Fig. 8 is that the e-mail that exceeds the time limit of accounts receivable decision support system of the present invention and method distributes process flow diagram.
[embodiment]
As shown in Figure 2, be the basic block diagram of accounts receivable decision support system of the present invention and method.In accounts receivable decision support system of the present invention, mainly include a financial accounting database 10, a database server 20, a Web server 30.Wherein, financial accounting database 10 is used to store and manage the financial accounting data of reflection Comments on Companies'Financial Condition, and global accounts receivable data transmission that will be wherein is to database server 20, and data is deposited in the accounts receivable database 210; Database server 20 includes an accounts receivable cube 211 and an accounts receivable database 210; Accounts receivable cube 211 is to be data source and the cube that utilizes the on-line analysis disposal system to generate with the accounts receivable database, can be used for storing the usefulness of treated multidimensional data for user's 50 inquiries; Accounts receivable database 210 is used to store and manage the data that comes from financial accounting database 10, an one accounts receivable table 2100 and an accounts receivable temporary table 2110 are wherein arranged, accounts receivable table 2100 is the data sources that generate the accounts receivable cube, accounts receivable temporary table 2110 is used to receive the accounts receivable data that storage comes from financial accounting database 10, and accounts receivable temporary table 2110 is with the data of its data updating accounts receivable table 2100; Web server 30 is used to user's inquiry that the service of Web interface is provided.User 50 visits Web server 30 by internet 40 in the security socket layer mode, Web server 30 is connected with database server 20, thereby user 50 has access to accounts receivable cube 211 wherein, has realized the inquiry to the global accounts receivable of company.
As shown in Figure 3, be each module structure drafting in the Web server of accounts receivable decision support system of the present invention and method.Web server, be used to user's inquiry that the service of Web interface is provided, comprising user's login authentication module 310, an authority management module 311, an accounts receivable query analysis module 312, a funds on account filling module 313, a counterbalanced accounts record queries module 314 and a cash in banks unusual fluctuation enquiry module 315 are arranged.Wherein, user's login authentication module 310 is carried out user's authentication when being used for that the user logined Web server; Authority management module 311, be used for the regulation different user accounts receivable inquired about the authority that is had, according to dissimilar users search access right is divided into " customer administrator ", " accounts receivable financial and accountancy personnel " reach " ordinary person " three kinds of different authorities; Accounts receivable query analysis module 312, be used to stipulate that the user inquires about used inquiry mode and Query Result display mode to accounts receivable, inquiry mode includes " cause group cause place client ", " sales territory marketing unit client " and reaches different modes such as " clients cause group cause place ", and the Query Result display mode includes data display mode and chart display mode; Funds on account filling module 313 is used for every accounts receivable is added necessary explanation and note; Counterbalanced accounts record queries module 314 is used for the user data of bank's counterbalanced accounts record of company is inquired about; Cash in banks unusual fluctuation enquiry module 315 is used for the user variation of company's cash in banks is inquired about.
As shown in Figure 4, be accounts receivable decision support system of the present invention and method from the financial accounting database to accounts receivable data of database transfer process figure.After system comes into operation, financial accounting database 10 regularly will wherein upgrade and newly-increased data is upgraded by the data-switching service system and increase accounts receivable database 20 newly, its transmitting step includes: the accounts receivable data (step 410) in the deletion accounts receivable temporary table 2110, data Transformation Service system is sent to the renewal and the accession of financial accounting database 10 in the accounts receivable temporary table 2110 (step 420), the data (step 430) identical with accounts receivable temporary table 2110 in the deletion accounts receivable table 2100 is inserted into all data in the accounts receivable temporary table 2110 in the accounts receivable table 2100.Through after the above step, make the accounts receivable data be sent to the accounts receivable table 2100 of accounts receivable database 210 from financial accounting database 10, accounts receivable data in the accounts receivable table 2100 as data source for generating accounts receivable cube 211, the latter stores treated various dimensions data about accounts receivable, and these data are for the usefulness of user's 50 inquiries.
As shown in Figure 5, be the selection inquiry mode interface figure of accounts receivable decision support system of the present invention and method.Different inquiry modes can make the emphasis of the definite data that will inquire about of user, for example, some user needs emphasis inquiry " cause group " this classification, some user needs emphasis inquiry " marketing unit " this classification, like this, different inquiry modes is set just helps the user most important data is presented at center-stage, make the inquiry best results.Inquiry mode 60 includes " cause group cause place client ", " sales territory marketing unit client " and reaches modes such as " clients cause group cause place ".The user clicks the option keys 610 of inquiry mode front, and then clicks " determining " key 611 of below, and like this, the user just can inquire about and analyze company's accounts receivable data according to selected inquiry mode.
As shown in Figure 6, be the user inquiring flow process figure of accounts receivable decision support system of the present invention and method.In the process of inquiry, background data base and ERP system are separated, thereby play the effect of protection ERP system.User 50 utilizes client browser to be connected to internet 40 (step 610), visits Web server 30 (step 620) in the security socket layer mode; Web server 30 operation 310 couples of users' 50 of user's login authentication module wherein identity is verified (step 630); Determine after user's 50 identity that the user type that authority management module 311 is determined according to previous step gives the user 50 corresponding search access rights (step 640); Accounts receivable query analysis module 312 (steps 650) that are present in are wherein called in Web server 30 operations; Thereby Web server 30 is connected with database server 20 and has access to wherein accounts receivable cube 211 (step 660); Accounts receivable query analysis module 312 receives Query Result (step 670); The result of inquiry is presented on the Web server 30 (step 680), checks and analyzes for the user.
As shown in Figure 7, be other financial accounting data check process flow diagram of accounts receivable decision support system of the present invention and method.Managerial personnel except the accounts receivable data to company has the abundant understanding, also must inquire about other financial accounting data in the time of decision-making ground sometimes, further provide support for decision-making.User 50 utilizes client browser to be connected to internet 40 (step 710), visits Web server 30 (step 720) in the security socket layer mode again; When user's 50 visit Web servers 30, Web server 30 operation 310 couples of users' 50 of user's login authentication module wherein identity is verified (step 730); Determine after user's 50 identity that the user type that authority management module 311 is determined according to previous step gives the user 50 corresponding search access rights (step 740); Web server 30 directly is connected with financial accounting database 10, thereby user 50 has access to financial accounting database 10 (step 750), and the data of bank's counterbalanced accounts record of operation counterbalanced accounts record queries module 314 pairs of companies inquires about, and perhaps moves the variation of 315 pairs of company's cashes in banks of cash in banks unusual fluctuation enquiry module and inquires about (step 760).
As shown in Figure 8, be that the e-mail that exceeds the time limit of accounts receivable decision support system of the present invention and method distributes process flow diagram.Distribute the information that accounts receivable exceeded the time limit and worked to improve Comments on Companies'Financial Condition, for example be distributed to unit in debt and can supervise it to give back debt, be distributed to corporate operations personnel and can play the auxiliary effect of decision-making to the relevant personnel.The condition that the pre-set e-mail of exceeding the time limit of managerial personnel distributes, promptly when surpassing current date, just sends the date of expiry of accounts receivable the e-mail (step 810) that exceeds the time limit, system regularly checks (step 820) to the date of expiry of accounts receivable, and result and managerial personnel's predetermined conditions that inspection obtains are compared (step 830), if surpassing current date, the accounts receivable date of expiry will distribute program transmission e-mail according to pre-set e-mail to related personnel (step 840), if do not surpass, then do not carry out this program (step 850).
Claims (13)
1. accounts receivable decision support system, it utilizes on-line analysis to handle and realizes that this system includes a financial accounting database, a database server, a Web server to the inquiry of company's whole world accounts receivable data, it is characterized in that, wherein:
The financial accounting database is used to store and manage the relevant financial accounting data of reflection company financial accounting situation, and can regularly increase or upgrade data wherein newly;
Database server includes an accounts receivable cube and a database, wherein:
The accounts receivable cube can be used for storing treated multidimensional face data, and user's extraction data from database is analyzed;
Database, be used to store the global accounts receivable data that transmits from the financial accounting database, include an accounts receivable table and an accounts receivable temporary table, wherein, the accounts receivable table is used to store the accounts receivable data and as the data source of accounts receivable cube, the accounts receivable temporary table is used to receive the data that storage comes from the accounts receivable data of financial accounting database and upgrades the accounts receivable table with its material of money;
Web server is used to user's inquiry that the service of Web interface is provided.
2. accounts receivable decision support system as claimed in claim 1, it is characterized in that, Web server includes user's login authentication module, an authority management module, an accounts receivable query analysis module, a funds on account filling module, a counterbalanced accounts record queries module and a cash in banks unusual fluctuation enquiry module, wherein:
User's login authentication module is carried out user's authentication when being used for that the user logined Web server;
Authority management module is used for the authority that the regulation different user is inquired about accounts receivable;
Accounts receivable query analysis module is used for stipulating that the user inquires about employed method and receives the result who inquires about the accounts receivable data of database;
Funds on account filling module is used for every accounts receivable is added necessary explanation or note;
Counterbalanced accounts record queries module is used for the user data of bank's counterbalanced accounts record of company is inquired about;
Cash in banks unusual fluctuation enquiry module is used for the user variation of company's cash in banks is inquired about.
3. accounts receivable decision support system as claimed in claim 1 is characterized in that, the accounts receivable temporary table is with the data of wherein data updating accounts receivable table.
4. accounts receivable decision support system as claimed in claim 1 is characterized in that, wherein accounts receivable query analysis module can be used for setting inquiry mode and Query Result display mode.
5. accounts receivable decision support system as claimed in claim 1 is characterized in that, wherein search access right includes customer administrator, accounts receivable financial and accountancy personnel and three kinds of different authorities of ordinary person.
6. accounts receivable decision support system as claimed in claim 4, it is characterized in that wherein inquiry mode includes " cause group cause place client ", " sales territory marketing unit client " and reaches " client cause group cause place " three kinds of different inquiry modes.
7. accounts receivable decision support system as claimed in claim 4 is characterized in that, wherein the Query Result display mode includes data display mode and chart display mode.
8. method that the accounts receivable to company is inquired about and analyzed, it utilizes on-line analysis to handle and realizes that this method includes following steps to the inquiry of company's whole world accounts receivable data:
(a) the financial accounting database is transferred to database by the data that the data-switching service system will be stored in wherein;
(b) database receives the data from the financial accounting database, and according to the data of its Central Plains storage of this data regular update;
(c) be data source with the database and utilize the on-line analysis disposal system to build to put and generate the accounts receivable cube;
(d) user visits Web server by the internet in the security socket layer mode, and Web server is connected with database server, and then has access to the accounts receivable cube, and the global accounts receivable of company is inquired about.
9. the method that company's accounts receivable is inquired about and analyzed as claimed in claim 8, the user is in inquiring about accounts receivable, and background data base and company's ERP system are separated, thereby guarantee the safety of ERP system.
10. the method as the global accounts receivable of company being inquired about and analyzed as described in the claim 8 is characterized in that wherein data transmission step (a) comprises the steps:
(a1) data in the deletion accounts receivable temporary table;
(a2) renewal and the accession with the financial accounting database is sent in the accounts receivable temporary table;
(a3) data identical in the deletion accounts receivable table with the accounts receivable temporary table;
(a4) all data in the accounts receivable temporary table are inserted in the accounts receivable table, with the data in the data updating accounts receivable table in the accounts receivable temporary table.
11. the method as the global accounts receivable of company being inquired about and analyzed as described in the claim 8 is characterized in that wherein step (d) comprises following step:
(d1) user utilizes client browser to be connected to the internet;
(d2) user visits Web server in the security socket layer mode;
(d3) Web server is verified user's identity;
(d4) authority management module gives the user corresponding search access right according to user type;
(d5) the accounts receivable query analysis module that is present in is wherein called in the Web server operation;
(d6) have access to the accounts receivable cube by database server;
(d7) accounts receivable query analysis module receives Query Result;
(d8) Cha Xun result is presented on the Web server.
12. a method of inquiring about other financial accounting data in the financial accounting database plays important booster action to accounts receivable decision-making support method, it comprises the steps:
(a) user utilizes client browser to be connected to the internet;
(b) user visits Web server in the security socket layer mode;
(c) Web server is verified user's identity;
(d) authority management module gives the user corresponding search access right according to user type;
(e) have access to the financial accounting database;
(f) operation counterbalanced accounts record queries module is inquired about the data of bank's counterbalanced accounts record, perhaps moves cash in banks unusual fluctuation enquiry module the variation of cash in banks is inquired about.
13. the e-mail distributing method that exceeds the time limit about accounts receivable, it includes following steps:
(a) condition distributed of the pre-set e-mail of exceeding the time limit of managerial personnel;
(b) system makes regular check on the funds on account date of expiry of accounts receivable;
(c) date of expiry is compared with the condition that the system manager sets;
(d) if the date of expiry surpasses current date, then carry out e-mail system, distribute e-mail and give the related personnel; If the date of expiry does not surpass current date, then do not carry out this program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 02115247 CN1458601A (en) | 2002-05-15 | 2002-05-15 | Decision support system and method for income credit |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 02115247 CN1458601A (en) | 2002-05-15 | 2002-05-15 | Decision support system and method for income credit |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1458601A true CN1458601A (en) | 2003-11-26 |
Family
ID=29426483
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 02115247 Pending CN1458601A (en) | 2002-05-15 | 2002-05-15 | Decision support system and method for income credit |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1458601A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110019186A (en) * | 2017-09-07 | 2019-07-16 | 北京国双科技有限公司 | The method and device of data storage |
-
2002
- 2002-05-15 CN CN 02115247 patent/CN1458601A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110019186A (en) * | 2017-09-07 | 2019-07-16 | 北京国双科技有限公司 | The method and device of data storage |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7167839B1 (en) | Collection agency data access method | |
| US7054857B2 (en) | Use of extensible markup language in a system and method for influencing a position on a search result list generated by a computer network search engine | |
| US6886047B2 (en) | System and method for managing information retrievals for integrated digital and analog archives on a global basis | |
| US6856970B1 (en) | Electronic financial transaction system | |
| US6279033B1 (en) | System and method for asynchronous control of report generation using a network interface | |
| US8607138B2 (en) | System and method for OLAP report generation with spreadsheet report within the network user interface | |
| CA2487028C (en) | System and method for facilitating information collection, storage, and distribution | |
| US20030074342A1 (en) | Customer information management infrastructure and methods | |
| US20030144930A1 (en) | Methods and systems for managing tax audit information | |
| US20020198743A1 (en) | Network architecture and management system for conducting insurance activities on a network | |
| CN107103529A (en) | Bank Profile management system based on SOA frameworks | |
| US20060247960A1 (en) | System for managing customer productivity through central repository | |
| US20090150479A1 (en) | Web Feeds for Work List Publishing | |
| US7120632B2 (en) | Methods and systems for managing business information on a web site | |
| US20020128954A1 (en) | Electronic trade confirmation system and method | |
| US20020123898A1 (en) | System and method for managing business to business customer extranet | |
| KR100494975B1 (en) | Customer finance management method and system using screen scrapping | |
| CN100412858C (en) | Report generating system and method | |
| US7587350B1 (en) | Integrated investment management system with network datafeed | |
| CN1458601A (en) | Decision support system and method for income credit | |
| US20020165728A1 (en) | Device, method and computer program product for carrying out business processes | |
| US20040044679A1 (en) | System and method for remotely generating reports | |
| KR20060116735A (en) | Real time web asp package system and control method with small/medium enterprises and accounts office | |
| US20040111288A1 (en) | System and method for querying reports using a mobile computing device | |
| KR100401090B1 (en) | Method of managing contracts of employee in the internet |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |