CN1595412A - Cash managing system - Google Patents
Cash managing system Download PDFInfo
- Publication number
- CN1595412A CN1595412A CN 200410073779 CN200410073779A CN1595412A CN 1595412 A CN1595412 A CN 1595412A CN 200410073779 CN200410073779 CN 200410073779 CN 200410073779 A CN200410073779 A CN 200410073779A CN 1595412 A CN1595412 A CN 1595412A
- Authority
- CN
- China
- Prior art keywords
- information
- accounts
- mentioned
- goes out
- database
- 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)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Cash Registers Or Receiving Machines (AREA)
Abstract
Provided is a cash management system which is highly convenient for a user living in a country where predetermined language is not its native language. This CMS is provided with a Chinese sentence remittance external connection system 200, a mission-critical accounting system 300 which copes with only alphanumeric character data and a server 100. The Chinese sentence remittance external connection system 200 transmits alphanumeric character type money reception/payment information to the mission-critical accounting system 300, and transmits the money reception/payment information of Chinese characters to the server 100. The mission-critical accounting system 300 transmits the account information of alphanumeric characters to the server 100. The server 100 stores the account information of the alphanumeric characters in an alphanumeric character data DB101, and stores the money reception/payment information of Chinese characters in a Chinese character data DB102. The server 100 compounds the account information with the money reception/payment information by matching processing to generate display data, and transmits the display data to a customer terminal 500.
Description
Technical field
The present invention relates to cash management system, more specifically to technology with different language form deal with data.
Background technology
As the system of the fund that is used for management enterprise, for example such cash management system of being recorded and narrated of patent documentation 1 (TOHKEMY 2002-74231 communique) and patent documentation 2 (TOHKEMY 2002-133129 communique) is widely popularized.Recently, be accompanied by the globalization of business activity, can provide not only to rest on the management domestic funds, and the cash management system of outer management fund over strait (to call CMS in the following text).This CMS generally is the data that obtain relevant fund from the system of doing accounts.
In addition, in following patent documentation 1 (TOHKEMY 2002-74231 communique) and patent documentation 2 (TOHKEMY 2002-133129 communique), though cash management system is disclosed, is not had open technology with different language form deal with data.
Summary of the invention
The system that does accounts of Pu Jiing widely, great majority are all only supported English alphabet and numerical data.Thus, obtain data from this system of doing accounts and carry out the CMS that handles, also be confined to handle with English alphabet and numeral, the demonstration of accounts information etc. also is confined to English alphabet and numerical data.Therefore, for not with the user of English as the country of mother tongue, be very do not allow wield.
The objective of the invention is to solve such problem, provide for not with predetermined language cash management system easy to use as the user of the country of mother tongue.
Cash management system involved in the present invention, have connected system, support the 1st linguistic form and do not support the system that does accounts of the 2nd linguistic form at least and the server that is connected with client's terminal, it is characterized in that above-mentioned connected system has: input comprises the information of keeping accounts and/or the device of the information that goes out to keep accounts of the information of entering an item of expenditure in the accounts; And in the above-mentioned information of importing that goes out to keep accounts, will send to the above-mentioned system that does accounts according to the information of keeping accounts that goes out of the 1st linguistic form, will be according to the device that the information of keeping accounts sends to above-mentioned server that goes out of the 2nd linguistic form; The above-mentioned system of doing accounts has: from the device of above-mentioned connected system reception according to the information that goes out to keep accounts of the 1st linguistic form; According to the above-mentioned information that goes out to keep accounts, generate device according to the accounts information of the 1st linguistic form according to the 1st linguistic form; And the device that above-mentioned accounts information is sent to above-mentioned server; Above-mentioned server has: receive accounts information according to the 1st linguistic form from the above-mentioned system that does accounts, and store the device in the 1st database into; Receive the information that goes out to keep accounts from above-mentioned connected system, and store the device in the 2nd database into according to the 2nd linguistic form; According to above-mentioned coupling key information that accounts information comprised and the above-mentioned coupling key information that information comprised that goes out to keep accounts that is stored in the 2nd database that is stored in the 1st database, the device of retrieval and the corresponding information that goes out to keep accounts of account information; When with above-mentioned the 1st database in the accounts information stored is corresponding when going out the information of keeping accounts and being present in above-mentioned the 2nd database, synthetic account information and this information that goes out to keep accounts, and generate video data and/or download device with data file; And with the video data that generates and/or download the device that sends to above-mentioned client's terminal with data file.Because have such structure, do not need the system variation of doing accounts is become to support the 2nd linguistic form, just can provide the accounts information that to keep accounts information comprising of the 2nd linguistic form to the client.
Here, generate the video data of above-mentioned server and/or download the device of using data file, be easy to act as most with above-mentioned the 1st database in the corresponding information that goes out to keep accounts of accounts information of storing when not being present in above-mentioned the 2nd database, according to the accounts information that is stored in above-mentioned the 1st database, generate video data and/or download data file.By such structure, can provide accounts information to the client exactly.
In addition, above-mentioned server also has the site table that information that whether identifying information that makes the user and expression carry out the demonstration service of the 2nd linguistic form is associated, and according to this site table, judge whether carry out the demonstration service of the 2nd linguistic form, when the demonstration service of carrying out the 2nd linguistic form, generating video data and/or downloading when using data file, above-mentioned accounts information and the above-mentioned information of keeping accounts that goes out that is stored in the 2nd database that is stored in the 1st database is synthesized processing.By such structure, can realize optimal demonstration automatically to the user.
Cash management system server involved in the present invention, connecting the system that does accounts that supports the 1st linguistic form and do not support the 2nd linguistic form at least, terminal with the client, it is characterized in that comprising: receive accounts information from the above-mentioned system that does accounts, and store the device in the 1st database into according to the 1st linguistic form; Reception is according to the information that goes out to keep accounts of above-mentioned the 2nd linguistic form, and stores the device in the 2nd database into; According to above-mentioned coupling key information that accounts information comprised and the above-mentioned coupling key information that information comprised that goes out to keep accounts that is stored in the 2nd database that is stored in the 1st database, the device of retrieval and the corresponding information that goes out to keep accounts of account information; When with above-mentioned the 1st database in the accounts information stored is corresponding when going out the information of keeping accounts and being present in above-mentioned the 2nd database, synthetic account information and this information that goes out to keep accounts, and generate video data and/or download device with data file; And with the video data that generates and/or download the device that sends to above-mentioned client's terminal with data file.Because have such structure, do not need the system variation of doing accounts become is supported the 2nd linguistic form, just can provide accounts information to the client with the information that to keep accounts comprising of the 2nd linguistic form.
Here, generate above-mentioned video data and/or download the device of using data file, be easy to act as most with above-mentioned the 1st database in the corresponding information that goes out to keep accounts of accounts information of storing when not being present in above-mentioned the 2nd database, according to the accounts information that is stored in above-mentioned the 1st database, generate video data and/or download data file.By such structure, can provide accounts information to the client exactly.
Also has the site table that information that whether identifying information that makes the user and expression carry out the demonstration service of the 2nd linguistic form is associated, and according to this site table, judge whether carry out the demonstration service of the 2nd linguistic form, when the demonstration service of carrying out the 2nd linguistic form, generating video data and/or downloading when using data file, above-mentioned accounts information and the above-mentioned information of keeping accounts that goes out that is stored in the 2nd database that is stored in the 1st database is synthesized processing.By such structure, can realize optimal demonstration automatically to the user.
Fund management method involved in the present invention, use and support the 1st linguistic form and do not support the system of doing accounts of the 2nd linguistic form to carry out capital management at least, it is characterized in that comprising: connected system with in the information of being imported that goes out to keep accounts, send to the system of doing accounts according to the information of keeping accounts that goes out of the 1st linguistic form, will be according to the step that the information of keeping accounts sends to server that goes out of the 2nd linguistic form; The above-mentioned system that does accounts is from go out the keep accounts information of above-mentioned connected system reception according to the 1st linguistic form, and according to the above-mentioned information that goes out to keep accounts according to the 1st linguistic form, generation sends to the step of above-mentioned server according to the accounts information of the 1st linguistic form; Above-mentioned server receives accounts information according to the 1st linguistic form from the above-mentioned system that does accounts, and stores the step in the 1st database into; Above-mentioned server receives the information that goes out to keep accounts according to the 2nd linguistic form from above-mentioned connected system, and stores the step in the 2nd database into; Above-mentioned server is according to above-mentioned coupling key information that accounts information comprised and the above-mentioned coupling key information that information comprised that goes out to keep accounts that is stored in the 2nd database that is stored in the 1st database, the step of retrieval and the corresponding information that goes out to keep accounts of account information; Above-mentioned server, with above-mentioned the 1st database in the accounts information stored is corresponding when going out the information of keeping accounts and being present in above-mentioned the 2nd database, synthetic above-mentioned accounts information and the above-mentioned information that goes out to keep accounts generate video data and/or download step with data file; And above-mentioned server is with the video data that generates and/or download the step that sends to client's terminal with data file.By such method, do not need the system variation of doing accounts become is supported the 2nd linguistic form, just can provide accounts information to the client with the information that to keep accounts comprising of the 2nd linguistic form.
Other fund management methods involved in the present invention are characterised in that, comprising: from supporting the 1st linguistic form and do not support the system that does accounts of the 2nd linguistic form to receive the accounts information according to the 1st linguistic form at least, and store the step in the 1st database into; Reception is according to the information that goes out to keep accounts of above-mentioned the 2nd linguistic form, and stores the step in the 2nd database into; According to above-mentioned coupling key information that accounts information comprised and the above-mentioned coupling key information that information comprised that goes out to keep accounts that is stored in the 2nd database that is stored in the 1st database, retrieve the step of go out the keep accounts information corresponding with above-mentioned accounts information; When with above-mentioned the 1st database in the accounts information stored is corresponding when going out the information of keeping accounts and being present in above-mentioned the 2nd database, synthetic above-mentioned accounts information and the above-mentioned information that goes out to keep accounts, and generate video data and/or download step with data file; And with the video data that generates and/or download the step that sends to above-mentioned client's terminal with data file.
Here, preferably further have when with above-mentioned the 1st database in the corresponding information that goes out to keep accounts of accounts information of storing when not being present in above-mentioned the 2nd database, according to above-mentioned accounts information, generate video data and/or download step with data file.By such method, can provide accounts information to the client exactly.
Connected system involved in the present invention, connecting the system that does accounts that supports the 1st linguistic form and do not support the 2nd linguistic form at least, with the cash management service device that is connected with client's terminal, it is characterized in that, comprising: input comprises the information of keeping accounts and/or the device of the information that goes out to keep accounts of the information of entering an item of expenditure in the accounts; And in the information of being imported that goes out to keep accounts, will send to the above-mentioned system that does accounts according to the information of keeping accounts that goes out of the 1st linguistic form, will be according to the device that the information of keeping accounts sends to above-mentioned cash management service device that goes out of the 2nd linguistic form.
And, the information processing method that goes out to keep accounts involved in the present invention, be respectively to supporting the 1st linguistic form and not supporting the system that does accounts of the 2nd linguistic form at least, with the cash management service device that is connected with client's terminal, export out the method for the information of keeping accounts, it is characterized in that, comprising: in the information of being imported that goes out to keep accounts, will be according to the step that the information of keeping accounts sends to the above-mentioned system that does accounts that goes out of the 1st linguistic form; And will be according to the step that the information of keeping accounts sends to above-mentioned cash management service device that goes out of the 2nd linguistic form.
According to the present invention, can provide for not with predetermined language cash management system easy to use as the user of the country of mother tongue.
Description of drawings
Fig. 1 is the system construction drawing of expression CMS involved in the present invention.
Fig. 2 is the figure of change of the data of expression CMS involved in the present invention.
Fig. 3 is the process flow diagram of the matching treatment of expression CMS involved in the present invention.
Fig. 4 is the process flow diagram of the matching treatment of expression CMS involved in the present invention.
Fig. 5 be among the expression CMS involved in the present invention on client's terminal picture displayed show example.
Fig. 6 be among the expression CMS involved in the present invention on client's terminal picture displayed show example.
Fig. 7 is that picture displayed shows example on the terminal of client among the expression CMS involved in the present invention.
Fig. 8 is the figure that the detailed system of expression CMS involved in the present invention constitutes example.
Embodiment
At first use Fig. 1 that the structure of cash management system involved in the present invention (CMS) is described.This CMS is an enterprise-oriented overseas edition enterprise bank system.It promptly is the system that has realized overseas capital management simultaneously.This CMS is the main composition key element with CMS server 100, the outer welding system 200 of Chinese remittance, the system that does accounts 300.And the outer welding system 200 of Chinese remittance connect with external system 400 via communication networks such as internets, and CMS100 links together via the terminal 500 of communication networks such as internet with the client.
At first, external system 400 is the systems as the input source (source) of the information that goes out to keep accounts that comprises the data of representing with foreign languages such as Chinese, refers to for example enterprise bank system, the China Modern Payment System CNAPS (China NationalAdvanced Payment System) of the bank and other financial mechanism of China.In addition, CNAPS is with the function as a large sum of settlement system of carrying out RTGS clearing (the real-time settlement system of Real Time Gross Settlement interbank), with as carrying out the function of little settlement system of settlement on networks once-a-day, be equivalent to the day silver-colored network and system of complete silver-colored association of Japan.
The outer welding system 200 of Chinese remittance is obtained the information that goes out to keep accounts that comprises the data of representing with foreign languages such as Chinese from external system 400, to send to the system of doing accounts 300 with the information of keeping accounts that goes out that English alphabet and digital data form are represented, will comprise the connected system that the information of keeping accounts sends to CMS server 100 that of the data represented with Chinese forms.In addition, for the outer welding system 200 of Chinese remittance, except external system 400, can also be by manual and import data from the storage medium (CD-ROM, floppy disk etc.) of having stored the data that clearinghouse takes back.The outer welding system 200 of this Chinese remittance, specifically, by having the single of communication function or many computing machines constitute.
The system that does accounts 300 is the information that goes out to keep accounts that welding system 200 inputs are represented with English alphabet and digital data form outside the Chinese remittance, carries out the system of the processing of doing accounts.The packets of information that goes out to keep accounts is drawn together the information of keeping accounts and/or the information of entering an item of expenditure in the accounts.As such processing of doing accounts, for example have to go out remaining sum calculating that the information of keeping accounts carries out, interest calculating, service charge calculating, loan administration, exchange management etc. according to input.This 300 of system that do accounts supports specific linguistic form especially in the present invention, and does not support other linguistic form.300 of systems that does accounts that this example is related support English alphabet and digital data form, do not support to comprise other linguistic form of Chinese data form.Therefore, for this system 300 that does accounts,, also can't hold and handle these data exactly even imported the information of representing with Chinese forms that goes out to keep accounts.In this example, doing accounts that the system of system 300 constitutes is the information of representing with English alphabet and digital data form that goes out to keep accounts of only importing from the outer welding system 200 of Chinese remittance that these systems 300 that do accounts can support.This system 300 that does accounts is physically by having the single of communication function or many computing machines constitute.
CMS server 100 is made of single or multiple servers computing machine.This CMS server 100 is at the control device with CPU etc.; In the time of hardware configurations such as (Memory) such as the memory storage of ROM, RAM, hard disk etc., OS (Operation System) program and application storage are on hard disk.And the processing of being scheduled to is carried out in need launch on the RAM on the basis of these programs according to circumstances by CPU.CMS server 100 involved in the present invention has English alphabet and numerical data base (DB) 101 and Chinese data storehouse (DB) 102 especially.Control device carries out information (data) storage according to handling procedure for these databases 101,102, reads information (data) from these databases.
English alphabet and numerical data base (DB) the 101st stored go out to keep accounts information and the balance amount information (hereinafter referred to as the accounts information that comprises to keep accounts information and balance amount information) represented with English alphabet and digital data form imported via the system of doing accounts 300 from the outer welding system 200 of Chinese remittance at least.Example for this detailed data that goes out to keep accounts will describe in detail later.
The database of information that to keep accounts of the data of representing with Chinese forms that comprise therefrom that the outer welding system 200 of literary composition remittance imports is stored in Chinese data storehouse (DB) the 102nd at least.Example for these data will describe in detail later.
In CMS server 100, control device is carried out the matching treatment that is stored in the data in English alphabet and numerical data base 101 and the Chinese data storehouse 102 respectively, generation comprises the accounts information of Chinese data, video data, download is sent to client's terminal 500 with data file 103.
Then, use Fig. 2 that the transition example of the information handled in this CMS is described.In the left side of Fig. 2, expression has from the information 201 that goes out to keep accounts of external system 400 welding system 200 inputs outside the Chinese remittance.As shown in the figure, will import about name on account, number of the account, trade date, the input of bank side day, execution date, the information of differentiation, type of transaction, dealing money, bank's reference (Reference) numbering, client trading number, bank's reference information, client trading information, remarks, summary of keeping accounts of entering an item of expenditure in the accounts.In this example, the information about bank's reference information, client trading information, remarks, summary is the information of representing with Chinese forms.These information 201 that go out to keep accounts are handled by the outer welding system 200 of Chinese remittance, via the system of doing accounts 300, are stored in the English alphabet and numerical data DB101 of CMS server 100.At this moment,, add the Currency Type information that goes up, add by the system of doing accounts 300 and go up balance amount information by the outer welding system 200 of Chinese remittance for this information 201 that goes out to keep accounts.The case representation that is stored in the accounts information 202 among English alphabet and the numerical data DB101 is in Fig. 2 upper right side.Accounts information 202 has been removed bank's reference information, the client trading information of explaining with the Chinese expression form from the data 201 of input.In addition, in data 201, about the remarks of having imported Chinese information and the data of summary, though be present on the data 202 as data items, as Chinese information the time, real data is not preserved yet.
The information 201 of going out to keep accounts is processed by the outer welding system of Chinese remittance 200, and the case representation that is stored in the information 203 that goes out to keep accounts among the Chinese data DB102 of CMS server 100 is in Fig. 2 lower right side.The information 203 that goes out to keep accounts has been removed name on account, bank side's input day, execution date, Currency Type, client trading number from the information 201 that goes out to keep accounts of input.This information 203 that goes out to keep accounts has for example data file structure of csv form.This data file is on the basis of data division shown in Figure 2 and then have a Header Section that comprises start mark, data recording number of packages; The Footer Section that comprises end mark.
As mentioned above, the control device of CMS server 100 is carried out the matching treatment that these are stored in the accounts information 202 among English alphabet and the numerical data DB101 and are stored in the information 203 that goes out to keep accounts among the Chinese data DB102.In such matching treatment, as shown in Figure 2, use number of the account, trade date, differentiation, dealing money, the bank's Ref. No. execution of keeping accounts of entering an item of expenditure in the accounts.Being about to these data handles as the coupling key.Thus, the coupling key information form of the accounts information 202 and the information 203 that goes out to keep accounts is consistent, and figure place is also identical.
Processing when using Fig. 3 to inquire about accounts information to the client is arranged here, describes.When having the client to inquire about accounts information (S101), the control device of CMS server 100, at first according to client's the identifying informations such as user ID in the login, extract according to not shown site table this client's of storage site information in advance, and whether be that (S102) judged in the site that is suitable for the Chinese service the site of determining by this site information.
Is when being suitable for the site of Chinese service in this client's site, whether inquiry exists the information 203 (S103) that goes out to keep accounts that comprises the coupling key information consistent with the coupling key information that comprised of accounts information 202 among English alphabet and the numerical data DB101 in Chinese data DB102.
The result of inquiry be determine exist comprise the coupling key information consistent with the coupling key information that comprised of accounts information 202 among English alphabet and the numerical data DB101 go out to keep accounts during information 203, in the accounts information 202 synthetic information that go out to keep accounts that are stored in the Chinese data DB102 to reading from English alphabet and numerical data DB101, more specifically say so when carrying out overwrite, by adding display format information such as Show Color, font, demonstration place, generate video datas (S104) such as html data, XML data.
On the other hand, in the site of being determined by user ID is not the site (S102) that is suitable for the Chinese service, determine do not exist comprise the coupling key information consistent with the coupling key information that comprised of accounts information 202 among English alphabet and the numerical data DB101 go out to keep accounts during information 203 (S103), according to the accounts information 202 that is stored among English alphabet and the numerical data DB101, by adding display format information, generate video datas (S105) such as html data, XML data.
The control device of CMS server 100 sends to the video data (S104, S105) that generates client's terminal 500.Client's terminal 500 receives this video data, by display routines such as browsers, carries out picture and show on display.
Then, use the processing of Fig. 4 when having to describe from the requiring of client's download accounts information.When having (S201) from the requiring of client's download accounts information, the control device of CMS server 100, at first according to client's the user ID in the login, extract according to not shown site table this client's of storage site information in advance, and whether be that (S202) judged in the site that is suitable for the Chinese service the site of determining by this site information.
Is when being suitable for the site of Chinese service in this client's site, whether inquiry exists the information 203 (S203) that goes out to keep accounts that comprises the coupling key information consistent with the coupling key information that comprised of accounts information 202 among English alphabet and the numerical data DB101 in Chinese data DB102.
The result of inquiry be determine exist comprise the coupling key information consistent with the coupling key information that comprised of accounts information 202 among English alphabet and the numerical data DB101 go out to keep accounts during information 203, to the accounts information 202 synthetic information that go out to keep accounts that are stored in the Chinese data DB102 of reading from English alphabet and numerical data DB101, more specifically say so and carry out overwrite, generate the data file (S204) of downloading usefulness.
On the other hand, in the site of being determined by user ID is not the site (S202) that is suitable for the Chinese service, determine do not exist comprise the coupling key information consistent with the coupling key information that comprised of accounts information 202 among English alphabet and the numerical data DB101 go out to keep accounts during information 203 (S203), according to the accounts information 202 that is stored among English alphabet and the numerical data DB101, generate and download with data file (S205).
The control device of CMS server 100 sends to the download that generates client's terminal 500 with data file (S204, S205).Client's terminal 500 receives this download and uses data file, stores predetermined storage medium into.The client can be according to the data file of having downloaded, and carries out checking and the account management of own enterprise, conglomerate of receivables, payables.
Fig. 5, Fig. 6 and Fig. 7 represent that the picture of accounts information inquiry picture shows example.Fig. 5 is that page or leaf is represented in the guide look of account information inquiry picture.Each figure is with Chinese table aspect purpose page structure.Type number among each figure like this reaches the project data of Chinese according to this, is generated as display format information in advance, is stored in the memory storage on the CMS server 100, therefrom extracts the data corresponding with project as required, and enrolls.
In Fig. 5, be provided with the specific input field 701 to 708 that is used for as the information of complete list data presented.Represent that respectively 709 is names on account, the 710th, number of the account, the 711st, Currency Type, the 712nd, the scope of the trade date that shows.713 to 721 is guide look data, the 713rd, and trade date, the 714th, type of transaction (narration), the 715th, the dealing money when entering an item of expenditure in the accounts, the 716th, the dealing money when keeping accounts, the 717th, balance amount information, the 718th, bank's Ref. No., the 719th, client trading number, the 720th, remarks, the 721st are used for the linking button of the represented details of displayed map 6 and Fig. 7.
The detailed picture of page or leaf that shows when Fig. 6 is illustrated in the data that do not comprise Chinese forms in the data of Chinese data DB102 storage shows example.In the drawings, the 801st, trade date, the 802nd, name on account, the 803rd, number of the account, the 804th, Currency Type, the 805th, bank side's input day, the 806th, execution day (remittance day), the 807th, type of transaction, the 808th, the differentiation, the 809th that keeps accounts of entering an item of expenditure in the accounts, dealing money, the 810th, bank's Ref. No., the 811st, client trading number, the 812nd, remarks, the 813rd, summary (content).
The detailed picture of page or leaf that shows when Fig. 7 is illustrated in the data that comprise Chinese forms in the data of Chinese data DB102 storage shows example.The project 901 to 913 of video data is identical with Fig. 6.In this embodiment, bank's Ref. No. 910, client trading number 911, remarks 912, summary (content) the 913rd are with the information of Chinese statement.
Then, use Fig. 8 pair of concrete formation example to describe with CMS server 100 involved in the present invention.CMS server 100 is made of gateway server 10, database (DB) server 20, application (AP) server 30, web page server 40 as shown in Figure 8.
Gateway 10 has to be carried out MT940/MT942 respectively and handles with the information processing that goes out to keep accounts of process group 12, foreign language and delete the processing capacity of flow process 17 with process 14, the information processing that do not match with process 16, discarded record.Here, MT940/MT942 is that (the societyfor Worldwide Interbank Financial Telecommunications: settlement system between International Banks) the established data form is a kind of by SWIFT.Whether MT940/MT942 handles with process group 12, and input comprises the MT940/MT942 file 11 of accounts information, to the data form, exist corresponding account etc. to confirm, carry out the accounts information table 23 grade operation of data storage in the DB server 20.Whether foreign language goes out to keep accounts information processing with the process 14 input foreign languages message file 13 that goes out to keep accounts, to the data form, exist corresponding account etc. to confirm, carry out data storage to information table 24 operations such as grade that go out to keep accounts of the foreign language in the DB server 20.
The information processing that do not match is carried out the detecting operation of primary informations inconsistent (not matching) with the every preset times of process 16, and gets in touch with to the site.Carry out one-time detection in for example per 1 hour and handle, have non-existent information in MT940/MT942 file 11 though detect in foreign language is come in and gone out account message file 13; Though in MT940/MT942 file 11, there is non-existent information in foreign language is come in and gone out account message file 13; The information that does not have corresponding account; The incomplete information of form etc.
Discarded record deletion processing 17 is processing that relate to the data file that surpasses intended duration of deletion storage, for example deletes the processing of the data file of storing before the period of greater than two months, carries out 1 time in every month.
Master meter 22, accounts information table 23 (the account balance table and the detail list that goes out to keep accounts), the foreign language that database server 20 has inquiry usefulness such as site table 21, Currency Type master meter go out to keep accounts information table 24, record ignored delete procedure 25., user ID, site information, whether need the information of foreign language service etc. to produce association mutually here, be stored on the table 21 of site.With in the master meter 22, for example comprise Currency Type master meter etc. in inquiry.Accounts information table 23 (the account balance table and the detail list that goes out to keep accounts) is the information table that is equivalent to above-mentioned English alphabet and numerical data DB101.The foreign language information table 24 that goes out to keep accounts is the information tables that are equivalent to Chinese data DB102.Record ignored delete procedure 25 is carried out the processing same with discarded record deletion flow process 17.
Application server 30 has site attribute query/change function 31, accounts information inquiry/download function (no foreign language information) 32, accounts information inquiry/download function (foreign language information is arranged) 33.Site attribute query/change function 31 is carried out the inquiry of site attribute, the change of site attribute by bank comprehensive computing machine 600.Account attributes inquiry/download function 32,33 when inquiry from the accounts information of client's terminal 501,502, downloading request are arranged, generates the video data that comprises accounts information, downloads and use data file, sends to client's terminal 501,502.
Processing example to CMS server 100 shown in Figure 8 describes.The never illustrated external system of the Chinese outer welding system 200 of remittance obtains out the data that keep accounts, and the information of only representing with English alphabet and digital data form of keeping accounts that goes out is sent to the system of doing accounts 300.,, carry out MT940/MT942 by FTP (File Transfer Protocol) and transmit for gateway server 10 from the system of doing accounts 300 this information of representing with English alphabet and digital data form that goes out to keep accounts.
Gateway server 10 is carried out processing by 12 pairs of MT940/MT942 files 11 from the system's of doing accounts 300 outputs of MT940/MT942 process group.MT940/MT942 process group 12 is carried out the form affirmation of this MT940/MT942 file 11 etc., outputs to DB server 20.DB server 20 arrives accounts information table 23 with this data storage.After the data that store accounts information table 23 into are read by accounts information inquiry/download function (no foreign language information) 32, be prompted or be downloaded to not transmitting foreign language go out to keep accounts client's the terminal 501 of account inquiries of site of information.Promptly on this client's terminal 501, show that the picture as Fig. 6 shows the represented information that only comprises English alphabet and numerical data of example.In addition, when the inquiry of carrying out this balance amount information and download function, according to circumstances with reference to inquiry master meters 22 such as site table 21 and Currency Type master meters.
On the other hand, the never illustrated external system of the Chinese outer welding system 200 of remittance obtains out the data that keep accounts, and will comprise that the data that to keep accounts of foreign language data mode send gateway server 10.Welding system 200 is for gateway server 10 outside the Chinese remittance, and the data that will go out to keep accounts transmit by FTP (File Transfer Protocol).The foreign language that is received by gateway server 10 message file 13 that goes out to keep accounts is handled with process 14 by the foreign language information processing that goes out to keep accounts.Foreign language goes out to keep accounts information processing with process 14, carries out foreign language go out the to keep accounts form affirmation etc. of message file 13, outputs to DB server 20.DB server 20 with this data storage to the foreign language information table 24 that goes out to keep accounts.
Accounts information inquiry/download function (foreign language information is arranged) 33, having from sending foreign language when going out to keep accounts client's the inquiry of accounts information of terminal 502 of account inquiries of site of data, according to accounts information table 23 and the foreign language information table 24 that goes out to keep accounts, with reference to inquiries such as site table 21 and Currency Type master meter master meter 22, to storing the data and store foreign language go out the to keep accounts data that to keep accounts of information table 24 into and synthesize of to keep accounts of accounts information table 23 into, generate the demonstration page or leaf of accounts information, this balance amount information is sent on client's the terminal 502.When the downloading request that has from the accounts information of client's terminal 502, account information inquiry/download function (foreign language information is arranged) 33 sends the terminal 502 of synthetic balance amount information to the client similarly.
Site attribute query/change the function 31 of application server 31 according to bank comprehensive computing machine 600, is carried out the inquiry and the change of the site table 21 of DB server 20 and is handled.
As described above, CMS involved in the present invention, via the system that does accounts that only supports specific linguistic form, even the time to client's terminal notifying accounts information, from the information that goes out to keep accounts of input, will not support the information of the linguistic form of the system of doing accounts not send, then by this system of doing accounts, by synthesizing, can comprise the accounts information of the information of the linguistic form of supporting the system that does accounts to client's terminal notifying with the accounts information of importing from the system that does accounts.Thus, even because the system that does accounts does not support that other linguistic form is also passable, therefore can cut down the cost that the adjoint system change brings.
The main object of CMS involved in the present invention is that main office and group company are in Chinese enterprises group.Main office carries out detail inquiry and Commission remittance etc. by utilizing this CMS to the universal account of own company, the account of group company, can carry out total management to the fiscal fuction of this group.
Simultaneously, because CMS involved in the present invention is for main office and group company, data for remittance clientage etc. are not only used English alphabet and numeral, also can point out by enough Chinese, therefore can make client's checking and writing off of settlement bargain (mainly be buy money on credit, buy money on dredit) become easy.
In addition, in the middle of above-mentioned example, though as unsupported language is for the example of Chinese in the system of doing accounts, being not limited thereto also can be other language.
Claims (11)
1. a cash management system has connected system, supports the 1st linguistic form and does not support the system that does accounts of the 2nd linguistic form at least and the server that is connected with client's terminal, it is characterized in that:
Above-mentioned connected system has
Input comprises the information of keeping accounts and/or the device of the information that goes out to keep accounts of the information of entering an item of expenditure in the accounts; And
In the above-mentioned information of importing that goes out to keep accounts, will send to the above-mentioned system that does accounts according to the information of keeping accounts that goes out of the 1st linguistic form, will be according to the device that the information of keeping accounts sends to above-mentioned server that goes out of the 2nd linguistic form;
The above-mentioned system of doing accounts has
From the device of above-mentioned connected system reception according to the information that goes out to keep accounts of the 1st linguistic form;
According to the above-mentioned information that goes out to keep accounts, generate device according to the accounts information of the 1st linguistic form according to the 1st linguistic form; And
Above-mentioned accounts information is sent to the device of above-mentioned server;
Above-mentioned server has
Receive accounts information from the above-mentioned system that does accounts, and store the device in the 1st database into according to the 1st linguistic form;
Receive the information that goes out to keep accounts from above-mentioned connected system, and store the device in the 2nd database into according to the 2nd linguistic form;
According to above-mentioned coupling key information that accounts information comprised and the above-mentioned coupling key information that information comprised that goes out to keep accounts that is stored in the 2nd database that is stored in the 1st database, the device of retrieval and the corresponding information that goes out to keep accounts of account information;
When with above-mentioned the 1st database in the accounts information stored is corresponding when going out the information of keeping accounts and being present in above-mentioned the 2nd database, synthetic account information and this information that goes out to keep accounts, and generate video data and/or download device with data file; And
With the video data that generates and/or download the device that sends to above-mentioned client's terminal with data file.
2. cash management system according to claim 1 is characterized in that:
Generation video data in the above-mentioned server and/or the download device of data file, with above-mentioned the 1st database in the corresponding information that goes out to keep accounts of accounts information of storing when not being present in above-mentioned the 2nd database, according to the above-mentioned accounts information that is stored in the 1st database, generate video data and/or download data file.
3. cash management system according to claim 1 and 2 is characterized in that:
Above-mentioned server also has the site table that information that whether identifying information that makes the user and expression carry out the demonstration service of the 2nd linguistic form is associated, and according to this site table, judge whether carry out the demonstration service of the 2nd linguistic form, when the demonstration service of carrying out the 2nd linguistic form, generating video data and/or downloading when using data file, above-mentioned accounts information and the above-mentioned information of keeping accounts that goes out that is stored in the 2nd database that is stored in the 1st database is synthesized processing.
4. a cash management system server is connecting and is supporting the 1st linguistic form and do not support the system that does accounts of the 2nd linguistic form and client's terminal at least, it is characterized in that comprising:
Receive accounts information from the above-mentioned system that does accounts, and store the device in the 1st database into according to the 1st linguistic form;
Reception is according to the information that goes out to keep accounts of above-mentioned the 2nd linguistic form, and stores the device in the 2nd database into;
According to above-mentioned coupling key information that accounts information comprised and the above-mentioned coupling key information that information comprised that goes out to keep accounts that is stored in the 2nd database that is stored in the 1st database, the device of retrieval and the corresponding information that goes out to keep accounts of account information;
When with above-mentioned the 1st database in the accounts information stored is corresponding when going out the information of keeping accounts and being present in above-mentioned the 2nd database, synthetic account information and this information that goes out to keep accounts, and generate video data and/or download device with data file; And
With the video data that generates and/or download the device that sends to above-mentioned client's terminal with data file.
5. cash management system server according to claim 4 is characterized in that:
Generate video data and/or download the device of using data file, with above-mentioned the 1st database in the corresponding information that goes out to keep accounts of accounts information of storing when not being present in above-mentioned the 2nd database, according to the above-mentioned accounts information that is stored in the 1st database, generate video data and/or download data file.
6. according to claim 4 or 5 described cash management system servers, it is characterized in that:
Also has the site table that information that whether identifying information that makes the user and expression carry out the demonstration service of the 2nd linguistic form is associated, and according to this site table, judge whether carry out the demonstration service of the 2nd linguistic form, when the demonstration service of carrying out the 2nd linguistic form, generating video data and/or downloading when using data file, above-mentioned accounts information and the above-mentioned information of keeping accounts that goes out that is stored in the 2nd database that is stored in the 1st database is synthesized processing.
7. a fund management method is used and is supported the 1st linguistic form and do not support the system of doing accounts of the 2nd linguistic form to carry out capital management at least, it is characterized in that comprising:
Connected system with in the information of being imported that goes out to keep accounts, send to the system of doing accounts according to the information of keeping accounts that goes out of the 1st linguistic form, will be according to the step that the information of keeping accounts sends to server that goes out of the 2nd linguistic form;
The above-mentioned system that does accounts is from go out the keep accounts information of above-mentioned connected system reception according to the 1st linguistic form, and according to the above-mentioned information that goes out to keep accounts according to the 1st linguistic form, generation sends to the step of above-mentioned server according to the accounts information of the 1st linguistic form;
Above-mentioned server receives accounts information according to the 1st linguistic form from the above-mentioned system that does accounts, and stores the step in the 1st database into;
Above-mentioned server receives the information that goes out to keep accounts according to the 2nd linguistic form from above-mentioned connected system, and stores the step in the 2nd database into;
Above-mentioned server is according to above-mentioned coupling key information that accounts information comprised and the above-mentioned coupling key information that information comprised that goes out to keep accounts that is stored in the 2nd database that is stored in the 1st database, the step of retrieval and the corresponding information that goes out to keep accounts of account information;
Above-mentioned server, with above-mentioned the 1st database in the accounts information stored is corresponding when going out the information of keeping accounts and being present in above-mentioned the 2nd database, synthetic above-mentioned accounts information and the above-mentioned information that goes out to keep accounts generate video data and/or download step with data file; And
Above-mentioned server is with the video data that generates and/or download the step that sends to client's terminal with data file.
8. a fund management method is characterized in that, comprising:
From supporting the 1st linguistic form and do not support the system that does accounts of the 2nd linguistic form to receive accounts information at least, and store the step in the 1st database into according to the 1st linguistic form;
Reception is according to the information that goes out to keep accounts of above-mentioned the 2nd linguistic form, and stores the step in the 2nd database into;
According to above-mentioned coupling key information that accounts information comprised and the above-mentioned coupling key information that information comprised that goes out to keep accounts that is stored in the 2nd database that is stored in the 1st database, retrieve the step of go out the keep accounts information corresponding with above-mentioned accounts information;
When with above-mentioned the 1st database in the accounts information stored is corresponding when going out the information of keeping accounts and being present in above-mentioned the 2nd database, synthetic above-mentioned accounts information and the above-mentioned information that goes out to keep accounts, and generate video data and/or download step with data file; And
With the video data that generates and/or download the step that sends to above-mentioned client's terminal with data file.
9. according to claim 7 or 8 described fund management methods, it is characterized in that also having:
When with above-mentioned the 1st database in the corresponding information that goes out to keep accounts of accounts information of storing when not being present in above-mentioned the 2nd database, according to above-mentioned accounts information, generate video data and/or download step with data file.
10. a connected system is connecting the system that does accounts that supports the 1st linguistic form and do not support the 2nd linguistic form at least, and the cash management service device with being connected with client's terminal is characterized in that, comprising:
Input comprises the information of keeping accounts and/or the device of the information that goes out to keep accounts of the information of entering an item of expenditure in the accounts; And
In the information of being imported that goes out to keep accounts, will send to the above-mentioned system that does accounts according to the information of keeping accounts that goes out of the 1st linguistic form, will be according to the device that the information of keeping accounts sends to above-mentioned cash management service device that goes out of the 2nd linguistic form.
11. one kind respectively to supporting the 1st linguistic form and not supporting the system that does accounts of the 2nd linguistic form at least, with the cash management service device that is connected with client's terminal, exports out the method for the information of keeping accounts, and it is characterized in that, comprising:
In the information of being imported that goes out to keep accounts, will be according to the step that the information of keeping accounts sends to the above-mentioned system that does accounts that goes out of the 1st linguistic form; And
Will be according to the step that the information of keeping accounts sends to above-mentioned cash management service device that goes out of the 2nd linguistic form.
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| JP2003322279A JP3725886B2 (en) | 2003-09-12 | 2003-09-12 | Cash management system |
| JP322279/2003 | 2003-09-12 |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1595412A true CN1595412A (en) | 2005-03-16 |
Family
ID=34453681
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200410073779 Pending CN1595412A (en) | 2003-09-12 | 2004-09-10 | Cash managing system |
Country Status (3)
| Country | Link |
|---|---|
| JP (1) | JP3725886B2 (en) |
| CN (1) | CN1595412A (en) |
| TW (1) | TWI267033B (en) |
-
2003
- 2003-09-12 JP JP2003322279A patent/JP3725886B2/en not_active Expired - Lifetime
-
2004
- 2004-09-10 TW TW93127461A patent/TWI267033B/en active
- 2004-09-10 CN CN 200410073779 patent/CN1595412A/en active Pending
Also Published As
| Publication number | Publication date |
|---|---|
| JP3725886B2 (en) | 2005-12-14 |
| TWI267033B (en) | 2006-11-21 |
| TW200511077A (en) | 2005-03-16 |
| JP2005092371A (en) | 2005-04-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7805344B2 (en) | System providing methodology for consolidation of financial information | |
| US20200250763A1 (en) | Processing securities-related information | |
| US7751624B2 (en) | System and method for automating document search and report generation | |
| US20200334725A1 (en) | Computer implemented multi-currency invoice capture, trading, access and payment system | |
| JP4406565B2 (en) | Methods and software applications and systems for incorporating benchmarks into business software applications | |
| JP2011170490A (en) | SaaS GENERAL ACCOUNTING SYSTEM | |
| CN108765113A (en) | A kind of examination of invoice, reimbursement, management system | |
| US20050216479A1 (en) | Method, software application and system for incorporating benchmark data into a business software application | |
| US11675807B1 (en) | Database interface system | |
| JP2009098986A (en) | Electronic receivables mediating system | |
| US20050102313A1 (en) | System for locating data elements within originating data sources | |
| JP2001043280A (en) | Method and device for processing accounts and computer readable recording medium storing account processing program | |
| US20110055055A1 (en) | General ledger chart of accounts combination editing request response | |
| JP4459538B2 (en) | Reorganization fund management system, reorganization fund management system program, and recording medium recording the program | |
| CN111178993A (en) | Method and system for automatically calling invoice electronic file based on invoice container | |
| JP4373642B2 (en) | Supplier requirements system, supplier trend display control method, and program | |
| JP2009059147A (en) | Mediation server, mediation system and program for mediation system | |
| JP4024267B2 (en) | Supplier guidelines system | |
| CN1595412A (en) | Cash managing system | |
| CN108255616B (en) | Method for communication of wind data between C # and java system | |
| CN115809089B (en) | Method for developing based on document and test driver | |
| JP2014021879A (en) | Method of automatically generating response document draft, method of automatically generating a document file, method of preparing submitting document, and program for executing methods on computer | |
| US20060190405A1 (en) | Utilizing distribution types to assign attributes to distribution lines in an accounting system | |
| TWI375454B (en) | ||
| US20090234733A1 (en) | Property Management Platform and Method to Generate a tax form |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20050316 |