CN101706936A - Domestic and foreign ledger-combining processing method and processing system - Google Patents

Abstract

The invention discloses a domestic and foreign ledger-combining processing method and processing system. The treatment method comprises the following steps: a file processor receives the ledger data files of domestic and foreign subsidiary banks; the file processor performs file processing operation to the ledger data files of domestic and foreign subsidiary banks to generate the account ledgers of domestic and foreign subsidiary banks; a domestic batch manager performs domestic batching operation to the account ledger of domestic subsidiary banks, after finishing the batching, a foreign batch manager performs foreign batching operation to the account ledger of foreign subsidiary banks; and a statement manager performs the statement operation to the batched account ledgers of domestic and foreign subsidiary banks. Accordingly, the invention also discloses a domestic and foreign ledger-combining processing system. The processing method and processing system of the invention can be used to realize the high timeliness and high precision for financial data transmission and processing and effectively reduce the working intensity.

Description

Local and overseas general ledgers merge disposal route and local and overseas general ledger merges disposal system

Technical field

The present invention relates to the finance data process field, more specifically, relate to a kind of local and overseas general ledger and merge disposal route and local and overseas general ledger merging disposal system.

Background technology

Along with development of economic globalization, each bank sets up branch offices one after another all over the world.For will be overseas the data of data and domestic branch offices of branch offices merge and handle, need that the data of branch offices are overseas sent back domestic disposal system and handle.And mainly report and submit with form and merge at present by manually carrying out data.This mode of manually carrying out information transmission and processing can not satisfy the requirement that modernized bank handles data, has following shortcoming:

The first, artificial data is reported and submitted with form speed slow, can not satisfy that full line data merges and the requirement of form aspect ageing;

The second, artificial data is reported and submitted with form and is made mistakes easily, can not satisfy the requirement of full line data merging and form aspect accuracy;

The 3rd, overseas the employee of branch offices will handle mass data every day, and along with the data of the required processing of increase of portfolio are increasing, the labour intensity of manual delivery and deal with data is excessive.

Summary of the invention

The object of the present invention is to provide a kind of local and overseas general ledger to merge disposal route and system, realize high-timeliness, the high-accuracy of finance data transmission and processing, and effectively reduce working strength.

On the one hand, the invention provides a kind of local and overseas general ledger and merge disposal route, it comprises:

File handler receives branch's general ledger data file and overseas branch's general ledger data file within the border;

File handler to described domestic branch general ledger data file and overseas branch's general ledger data file carry out document processing operation respectively to produce domestic branch set of books general ledger and set of books general ledger in lines overseas;

Domestic batch processing manager carries out domestic batch operation to described domestic branch set of books general ledger;

After described domestic branch set of books general ledger finished batch processing, overseas the batch processing manager carried out batch operation overseas to described branch overseas set of books general ledger;

Report Manager to through the domestic branch set of books general ledger of batch operation and overseas in lines the set of books general ledger carry out Report Operations.

On the other hand, the present invention also provides a kind of local and overseas general ledger to merge disposal system, comprising: file handler, domestic batch processing manager, overseas batch processing manager and Report Manager.

Described file handler is used to be achieved as follows function: receive domestic branch's general ledger data file and branch's general ledger data file overseas, to the domestic branch general ledger data file that received and overseas in lines the general ledger data file carry out document processing operation respectively to produce domestic branch set of books general ledger and set of books general ledger in lines overseas;

Described domestic batch processing manager is used for described domestic branch set of books general ledger is carried out domestic batch operation;

The described manager of batch processing overseas is used for after described domestic batch processing manager is finished batch processing described branch overseas set of books general ledger being carried out batch operation overseas;

Described Report Manager be used for to through the domestic branch set of books general ledger of described batch operation and overseas in lines the set of books general ledger carry out Report Operations.

Implement the present invention, report and submit and the labour statement, not only reduced labour intensity owing to report and submit robotization with form to substitute existing manual data with data, and ageing height, accuracy rate height, can satisfy the managerial demand that full line data merges and form is provided.

Description of drawings

Fig. 1 is the process flow diagram that a kind of local and overseas general ledgers of the present invention merge disposal route;

Fig. 2 is the structural representation that a kind of local and overseas general ledgers of the present invention merge disposal system;

Fig. 3 is the structural representation of a kind of file handler of the present invention;

Fig. 4 is the structural representation of a kind of domestic batch processing manager of the present invention;

Fig. 5 is the structural representation of a kind of manager of batch processing overseas of the present invention;

Fig. 6 is the structural representation of a kind of Report Manager of the present invention.

Embodiment

For making the purpose, technical solutions and advantages of the present invention clearer, present invention is described further below in conjunction with accompanying drawing.

With reference to figure 1, a kind of local and overseas general ledgers of the embodiment of the invention merge the method for handling and comprise:

S100, file handler receive branch's general ledger data file and overseas branch's general ledger data file within the border;

S200, file handler carries out document processing operation to produce domestic branch set of books general ledger to described domestic branch general ledger data file, and described branch overseas general ledger data file is carried out document processing operation to produce accordingly branch's set of books general ledger overseas.The number of described domestic branch set of books general ledger is one, and described branch overseas set of books general ledger is with overseas branch is corresponding one by one.

S300, domestic batch processing manager carries out domestic batch operation to described domestic branch set of books general ledger;

S400, described domestic branch set of books general ledger finished batch processing after, overseas the batch processing manager carries out batch operation overseas to described branch overseas set of books general ledger;

S500, Report Manager to through the domestic branch set of books general ledger of batch operation and overseas in lines the set of books general ledger carry out Report Operations.

In S100, the file designation rule that is received is: OBXXXX_GLMIS_INIT_YYYYMMDD_NNNXXX.dat.Wherein, OBXXXX is the English code name of system of branch overseas, XXXX is each branch's english abbreviation overseas, GLMIS (General Ledger Management InformationSystem, the general ledger management information system) expression need provide data file with the GLMIS form overseas in lines, and INIT is that ODS (Operational Data Store, manipulation type data storage) transmission expansion is used, on the YYYYYMMDD representative data account date, NNN represents column split coding overseas.For example, the file of Hong Kong branch OBHK_GLMIS_INIT_YYYYMMDD_711XXX.dat by name.

The information of every row adopts the GLMIS form in the file that is received, separate with " | " between field and the field, generally comprise mechanism's sign indicating number, adjust sign indicating number, Currency Type, initial balance due, initial credit balance, current period debit amount, the current period credit amount, ending debit balances, ending credit balances, for example: the sign indicating number char of mechanism (9) | adjust sign indicating number char (8) | number (20 takes place in initial debit, 2) | number (20 takes place in initial credit side, 2) | number (20 takes place in the current period debit, 2) | number (20 takes place in the current period credit side, 2) | number (20 takes place in end of term debit, 2) | number (20,2) takes place in end of term credit side

In S200, described document processing operation comprises:

File handler to domestic branch general ledger data file and overseas branch's general ledger data file resolve respectively, resolving information comprises mechanism's sign indicating number, adjust sign indicating number, Currency Type, initial balance due, initial credit balance, current period debit amount, the current period credit amount, ending debit balances, ending credit balances, described resolving information is inserted domestic branch temporary table and each branch's temporary table overseas respectively, and to described domestic branch temporary table with add domestic branch's set of books identifier and branch's set of books identifier overseas overseas in branch's temporary table respectively, be used for to domestic branch and each overseas in lines set of books identify.The set of books identifier is the unique Digital ID ID that distinguishes set of books, is respectively equipped with the field of corresponding set of books identifier in the corresponding tables of subsequent step, thereby plays the sign effect;

File handler respectively to described domestic branch temporary table and overseas the branch temporary table carry out the verification of balance of mechanism, Currency Type balance, remove described domestic branch temporary table and overseas the branch temporary table in unwanted data, for example remove the data that gather section's purpose data, gather mechanism, the described section's purpose data that gather are meant that adjusting code field in the GLMIS formatted data is to gather the recorded content of adjusting sign indicating number, and the described data that gather mechanism are meant that mechanism's sign indicating number is the recorded content that gathers mechanism's sign indicating number in the GLMIS formatted data;

File handler uses mechanism's mapping table and subject mapping table, become subject to make up (Chart of Account the data layout of Institution Code in described domestic branch temporary table and the branch's temporary table overseas and the Data Format Transform of adjusting sign indicating number respectively, COA) form, with described domestic branch and overseas the COA formatted data of branch insert domestic branch general ledger transformation result table and general ledger transformation result table in lines overseas respectively.The data layout of the data layout of Institution Code and accounting sign indicating number is the GLMIS form in the described temporary table, and the COA form comprises mechanism, responsibility center, natural subject, reference, bar line, product, intrabranch, source, nine sections of dead section.Can access the mechanism's section and the responsibility center section of the pairing COA form of Institution Code of GLMIS form by the corresponding relation in mechanism's mapping table, thereby the Data Format Transform of Institution Code is become the COA form; Can access natural subject section, reference field, bar line segment and the product section of the pairing COA form of accounting sign indicating number of GLMIS form by the corresponding relation in the subject mapping table, thereby the Data Format Transform that will adjust sign indicating number becomes the COA form.At domestic branch's general ledger transformation result table with there is the field of corresponding set of books identifier overseas in branch's general ledger transformation result table respectively, thus to domestic branch general ledger transformation result table and overseas in lines general ledger transformation result table identify;

File handler is removed described domestic branch temporary table and the data of branch in the temporary table overseas;

Data in the described domestic branch general ledger transformation result table of file handler after with data-switching are inserted in the domestic branch general ledger interface table, and the data in the described branch overseas general ledger transformation result table after the data-switching are inserted accordingly overseas in branch's general ledger interface table.At domestic branch's general ledger interface table with there is the field of corresponding set of books identifier overseas in branch's general ledger interface table respectively, thus to domestic branch general ledger interface table and overseas in lines general ledger interface table identify;

File handler is with the domestic branch of the data importing in described domestic branch general ledger interface table general ledger journal account, the Currency Type of respectively concluding the business in the described branch overseas general ledger interface table is converted to one's own department or unit Currency Type, and the branch's general ledger journal account overseas accordingly of the data importing in the general ledger interface table of branch overseas after will converting, described general ledger journal account comprises voucher head, the voucher that voucher is capable.At domestic branch's general ledger journal account with there is the field of corresponding set of books identifier overseas in branch's general ledger journal account respectively, thus to domestic branch general ledger journal account and overseas in lines the general ledger journal account identify;

File handler with described domestic branch general ledger journal account and described branch overseas general ledger journal account respectively voucher transfer items to produce domestic branch set of books general ledger and set of books general ledger in lines overseas, the current period debit amount, the current period credit amount that are about to the same day are accumulated in the subject balance table, thereby produce the set of books general ledger.At domestic branch's set of books general ledger with there is the field of corresponding set of books identifier overseas in branch's set of books general ledger respectively, thus to domestic branch set of books general ledger and overseas in lines the set of books general ledger identify.

In S300, described domestic batch operation comprises:

Domestic batch processing manager is with the set of books general ledger backup of described domestic branch;

Domestic batch processing manager will reach peripheral systems such as data warehouse through the domestic branch set of books general ledger of backup.

In S400, described batch operation overseas comprises:

Overseas the batch processing manager carries out revaluation to described branch overseas set of books general ledger, promptly according to the conversion of current time point exchange rate estimation section purpose again remaining sum;

Overseas the batch processing manager is Renminbi and dollar with the local standard coin conversion remaining sum conversion in the described branch overseas set of books general ledger, and adds conversion trim operation, and it is poor to prevent the conversion tail, causes the form injustice;

Overseas the batch processing manager is with the set of books general ledger backup of described branch overseas;

Overseas the batch processing manager reaches described branch overseas set of books general ledger peripheral system such as data warehouse and carries out other processing.

In addition, also can comprise before S400: the file processing manager reads the work calendar and detects the general ledger data file of branch overseas that this day has or not necessary reception, detect this day when not having the branch overseas general ledger data file that must receive, wait for after domestic batch operation is finished and directly described branch overseas set of books general ledger is carried out batch operation overseas; Detect this day when the branch overseas general ledger data file that must receive is arranged, wait for that domestic batch operation is finished and branch's set of books general ledger generates overseas after, described branch overseas set of books general ledger is carried out batch operation overseas.It is pointed out that because the exchange rate all can change every day even therefore there is not branch's general ledger data file overseas, the remaining sum of conversion Currency Type still can change through after the revaluation in the system, therefore also will carry out batch operation.

In S500, Report Manager reads through the domestic branch set of books general ledger of batch operation and the data of set of books general ledger in lines overseas, the initial balance due of the COA form in the subject balance table, initial credit balance, current period debit amount, current period credit amount field are gathered calculating, deposit the data that gathered in form table as a result.When showing, demonstration tool can be according to report query personnel's report parameter from parameter peek and showed that demonstration tool can adopt COGNOS the table as a result, and COGNOS is the form front-end presentation tool product of IBM (International Business Machines Corporation).

With reference to figure 2, a kind of local and overseas general ledgers of the embodiment of the invention merge disposal system, comprising:

File handler 200, described file handler is used to be achieved as follows function: receive branch's general ledger data file and overseas branch's general ledger data file within the border, the domestic branch general ledger data file that is received is carried out document processing operation to produce domestic branch set of books general ledger, the general ledger data file of branch overseas that is received is carried out document processing operation to produce accordingly branch's set of books general ledger overseas, the number of described domestic branch set of books general ledger is one, and described branch overseas set of books general ledger is with overseas branch is corresponding one by one;

Domesticbatch processing manager 300, described domestic batch processing manager are used for described domestic branch set of books general ledger is carried out domestic batch operation;

Overseas thebatch processing manager 400, and the described manager of batch processing overseas is used for after described domestic batch processing manager is finished batch processing described branch overseas set of books general ledger being carried out batch operation overseas;

Report Manager 500, described Report Manager be used for to through the domestic branch set of books general ledger of described batch operation and overseas in lines the set of books general ledger carry out Report Operations.

Wherein, as shown in Figure 3, described file handler comprises:

Receiver module 2100, described receiver module are used to receive domestic branch general ledger data file and branch's general ledger data file overseas;

Import module 2200, described importing module is respectively to domestic branch general ledger data file and branch's general ledger data file parsing overseas, obtain branch's general ledger data and overseas branch's general ledger data within the border, with described domestic branch general ledger data and overseas branch's general ledger data insert domestic branch temporary table respectively and overseas in lines in the temporary table, and to described domestic branch temporary table with add the set of books identifier of domestic branch and the set of books identifier of branch overseas overseas in branch's temporary table respectively, be used for to domestic branch and each overseas in lines set of books identify;

Pre-verification module 2300, described pre-verification module respectively to described domestic branch temporary table and overseas in lines the data in the temporary table carry out the verification of balance of mechanism, Currency Type balance, remove unwanted data;

Data conversion module 2400, described data conversion module uses mechanism's mapping table and subject mapping table, respectively the data layout of described domestic branch temporary table and the Institution Code of branch in the temporary table overseas and the Data Format Transform of adjusting sign indicating number are become the COA form, with described domestic branch and overseas in lines COA formatted data insert domestic branch general ledger transformation result table and general ledger transformation result table in lines overseas respectively.At domestic branch's general ledger transformation result table with there is the field of corresponding set of books identifier overseas in branch's general ledger transformation result table respectively, thus to domestic branch general ledger transformation result table and overseas in lines general ledger transformation result table identify;

Data scrubbing module 2500, described data scrubbing module are removed described domestic branch temporary table and the data of branch in the temporary table overseas;

Data in data in generalledger interface module 2600, the described general ledger interface module described domestic branch general ledger transformation result table after with data-switching and the described branch overseas general ledger transformation result table are inserted domestic branch general ledger interface table respectively and overseas in lines in the general ledger interface table.At domestic branch's general ledger interface table with there is the field of corresponding set of books identifier overseas in branch's general ledger interface table respectively, thus to domestic branch general ledger interface table and overseas in lines general ledger interface table identify;

The general ledger journalaccount imports module 2700, described general ledger journal account imports module with the domestic branch of the data importing in described domestic branch general ledger interface table general ledger journal account, the Currency Type of respectively concluding the business in the described branch overseas general ledger interface table is converted to one's own department or unit Currency Type, and the general ledger journal account in lines overseas accordingly of the data importing in the general ledger interface table of branch overseas after will convert.At domestic branch's general ledger journal account with there is the field of corresponding set of books identifier overseas in branch's general ledger journal account respectively, thus to domestic branch general ledger journal account and overseas in lines the general ledger journal account identify;

Thevoucher module 2800 of transferring items, described voucher transfer items module with described domestic branch general ledger journal account and described branch overseas general ledger journal account respectively voucher transfer items to produce domestic branch set of books general ledger and set of books general ledger in lines overseas, the current period debit amount, the current period credit amount that are about to the same day are accumulated in the subject balance table, thereby produce the set of books general ledger.At domestic branch's set of books general ledger with there is the field of corresponding set of books identifier overseas in branch's set of books general ledger respectively, thus to domestic branch set of books general ledger and overseas in lines the set of books general ledger identify.

As shown in Figure 4, domestic batch processing manager comprises:

Backup module 3100, described backup module is with the set of books general ledger backup of described domestic branch;

Delivery module 3200, described delivery module reaches peripheral systems such as data warehouse with the domestic branch set of books general ledger of described backup.

As shown in Figure 5, overseas the batch processing manager comprises:

Revaluation module 4100, described revaluation module is carried out revaluation to described branch overseas set of books general ledger, promptly according to the conversion of current time point exchange rate estimation section purpose again remaining sum;

Conversion module 4200 is converted to the regulation Currency Type with one's own department or unit Currency Type in the described branch overseas set of books general ledger data, is about to local standard coin remaining sum conversion and is Renminbi and dollar, and add conversion trim operation, and it is poor to prevent the conversion tail, causes the form injustice;

Backup module 4300, described backup module is with the set of books general ledger backup of described branch overseas;

Delivery module 4400, described delivery module reaches peripheral systems such as data warehouse with the set of books general ledger of branch overseas of described backup.

As shown in Figure 6, Report Manager comprises:

Readmodule 5100, described read module read through the domestic branch set of books general ledger of batch operation and the data of set of books general ledger in lines overseas;

Summarizingmodule 5200, described summarizing module gathers calculating to the initial balance due of the COA form in the subject balance table that is read, initial credit balance, current period debit amount, current period credit amount field;

Memory module 5300, described memory module deposits the data that gathered in form table as a result, and when showing, demonstration tool can be according to report query personnel's report parameter from parameter peek and showed that demonstration tool includes but not limited to COGNOS the table as a result.

Report and submit and the labour statement, not only reduced labour intensity owing to report and submit robotization with form to replace existing manual data with data, and ageing height, accuracy rate height, can satisfy the managerial demand that full line data merges and form is provided.

Through the above description of the embodiments, those skilled in the art can be well understood to the present invention and can realize by the mode of software combined with hardware platform, can certainly all implement by hardware.Based on such understanding, all or part of can the embodying that technical scheme of the present invention contributes to background technology with the form of software product, this computer software product can be stored in the storage medium, as ROM/RAM, magnetic disc, CD etc., comprise that some instructions are with so that a computer equipment (can be a personal computer, server, the perhaps network equipment etc.) carry out the described method of some part of each embodiment of the present invention or embodiment.

More than disclosed only be the specific embodiment of the present invention; only be used for the present invention is illustrated; can not limit the present invention's protection domain with this; those skilled in the art can carry out various modifications, variation or replacement under the prerequisite that does not break away from essence of the present invention; therefore; according to the various equivalent variations that the present invention did, still belong to the scope that the present invention is contained.

Claims (12)

1. local and overseas general ledgers merge disposal route, it is characterized in that described method comprises:

File handler receives branch's general ledger data file and overseas branch's general ledger data file within the border;

File handler to described domestic branch general ledger data file and overseas branch's general ledger data file carry out document processing operation respectively to produce domestic branch set of books general ledger and set of books general ledger in lines overseas;

Domestic batch processing manager carries out domestic batch operation to described domestic branch set of books general ledger;

After described domestic branch set of books general ledger finished batch processing, overseas the batch processing manager carried out batch operation overseas to described branch overseas set of books general ledger;

Report Manager to through the domestic branch set of books general ledger of batch operation and overseas in lines the set of books general ledger carry out Report Operations.

2. the method for claim 1 is characterized in that, the number of described domestic branch set of books general ledger is one, and described branch overseas set of books general ledger is with overseas branch is corresponding one by one.

3. the method for claim 1 is characterized in that, described document processing operation comprises:

File handler is respectively to domestic branch general ledger data file and branch's general ledger data file parsing overseas, obtain branch's general ledger data and overseas branch's general ledger data within the border, with described domestic branch general ledger data and overseas branch's general ledger data insert domestic branch temporary table respectively and overseas in branch's temporary table, and to described domestic branch temporary table with add within the border in lines set of books identifier and in lines set of books identifier overseas overseas in branch's temporary table respectively;

File handler respectively to described domestic branch temporary table and overseas branch's temporary table carry out the verification of balance of mechanism, Currency Type balance, remove described domestic branch temporary table and unwanted data in the temporary table in lines overseas;

File handler uses mechanism's mapping table and subject mapping table, respectively the data layout of Institution Code in described domestic branch temporary table and the branch's temporary table overseas and the Data Format Transform of adjusting sign indicating number are become subject combination COA form, with described domestic branch and overseas in lines COA formatted data insert domestic branch general ledger transformation result table and general ledger transformation result table in lines overseas respectively;

File handler is removed described domestic branch temporary table and the data of branch in the temporary table overseas;

Data in data in the described domestic branch general ledger transformation result table of file handler after with data-switching and the described branch overseas general ledger transformation result table are inserted domestic branch general ledger interface table respectively and overseas in lines in the general ledger interface table;

File handler is with the domestic branch of the data importing in described domestic branch general ledger interface table general ledger journal account, the Currency Type of respectively concluding the business in the described branch overseas general ledger interface table is converted to one's own department or unit Currency Type, and the general ledger journal account in lines overseas accordingly of the data importing in the general ledger interface table of branch overseas after will convert;

File handler with described domestic branch general ledger journal account and described branch overseas general ledger journal account respectively voucher transfer items to produce domestic branch set of books general ledger and set of books general ledger in lines overseas.

4. as claim 1 or 3 described methods, it is characterized in that described domestic batch operation comprises:

Domestic batch processing manager is with the set of books general ledger backup of described domestic branch;

Domestic batch processing manager will reach peripheral system through the domestic branch set of books general ledger of backup.

5. as claim 1 or 3 described methods, it is characterized in that described batch operation overseas comprises:

Overseas the batch processing manager carries out revaluation to described branch overseas set of books general ledger;

Overseas the batch processing manager will be converted to the regulation Currency Type through one's own department or unit Currency Type in the described branch overseas set of books general ledger of revaluation;

Overseas the batch processing manager will be through the set of books general ledger backup of branch overseas of Currency Type conversion;

Overseas the batch processing manager reaches peripheral system with the set of books general ledger of branch overseas of described backup.

6. as claim 1 or 3 described methods, it is characterized in that described Report Operations comprises:

Report Manager reads through the domestic branch set of books general ledger of batch operation and the data of set of books general ledger in lines overseas, and the data that read are gathered, and deposits the data that gathered in form table as a result.

7. local and overseas general ledgers merge disposal system, it is characterized in that described system comprises: file handler, domestic batch processing manager, overseas batch processing manager and Report Manager;

Described file handler is used to be achieved as follows function: receive domestic branch's general ledger data file and branch's general ledger data file overseas, to the domestic branch general ledger data file that received and overseas in lines the general ledger data file carry out document processing operation respectively to produce domestic branch set of books general ledger and set of books general ledger in lines overseas;

Described domestic batch processing manager is used for described domestic branch set of books general ledger is carried out domestic batch operation;

The described manager of batch processing overseas is used for after described domestic batch processing manager is finished batch processing described branch overseas set of books general ledger being carried out batch operation overseas;

Described Report Manager be used for to through the domestic branch set of books general ledger of described batch operation and overseas in lines the set of books general ledger carry out Report Operations.

8. system as claimed in claim 7 is characterized in that, the number of described domestic branch set of books general ledger is one, and described branch overseas set of books general ledger is with overseas branch is corresponding one by one.

9. system as claimed in claim 7 is characterized in that, described file handler comprises: import module, pre-verification module, data conversion module, data scrubbing module, general ledger interface module, general ledger journal account and import module and the voucher module of transferring items,

Described importing module is respectively to domestic branch general ledger data file and branch's general ledger data file parsing overseas, obtain branch's general ledger data and overseas branch's general ledger data within the border, with described domestic branch general ledger data and overseas branch's general ledger data insert domestic branch temporary table respectively and overseas in branch's temporary table, and to described domestic branch temporary table with add within the border in lines set of books identifier and in lines set of books identifier overseas overseas in branch's temporary table respectively;

Described pre-verification module respectively to described domestic branch temporary table and overseas branch's temporary table carry out the verification of balance of mechanism, Currency Type balance, remove described domestic branch temporary table and unwanted data in the temporary table in lines overseas;

Described data conversion module uses mechanism's mapping table and subject mapping table, the data layout of Institution Code in described domestic branch temporary table and the branch's temporary table overseas and the Data Format Transform of adjusting sign indicating number are become the COA form, with described through the domestic branch of conversion and overseas in lines COA formatted data insert domestic branch general ledger transformation result table and general ledger transformation result table in lines overseas respectively;

Described data scrubbing module is removed described domestic branch temporary table and the data of branch in the temporary table overseas;

Data in data in the described domestic branch general ledger transformation result table of described general ledger interface module after with data-switching and the described branch overseas general ledger transformation result table are inserted domestic branch general ledger interface table and general ledger interface table in lines overseas respectively;

Described general ledger journal account imports module with the domestic branch of the data importing in described domestic branch general ledger interface table general ledger journal account, the Currency Type of respectively concluding the business in the described branch overseas general ledger interface table is converted to one's own department or unit Currency Type, and the general ledger journal account in lines overseas accordingly of the data importing in the general ledger interface table of branch overseas after will convert;

Described voucher transfer items module with described domestic branch general ledger journal account and described branch overseas general ledger journal account respectively voucher transfer items to produce domestic branch set of books general ledger and set of books general ledger in lines overseas.

10. as claim 7 or 9 described systems, it is characterized in that described domestic batch processing manager comprises: backup module and delivery module,

Described backup module backs up domestic branch set of books general ledger;

Described delivery module reaches peripheral system with the domestic branch set of books general ledger of described backup.

11., it is characterized in that the described manager of batch processing overseas comprises as claim 7 or 9 described systems: revaluation module, conversion module, backup module and delivery module,

Described revaluation module is carried out revaluation to described branch overseas set of books general ledger;

Described conversion module will be converted to the regulation Currency Type through one's own department or unit Currency Type in the described branch overseas set of books general ledger of revaluation;

Described backup module will be through the set of books general ledger backup of branch overseas of Currency Type conversion;

Described delivery module reaches peripheral system with the set of books general ledger of branch overseas of described backup.

12., it is characterized in that described Report Manager comprises as claim 7 or 9 described systems: read module, summarizing module and memory module,

Described read module reads through the domestic branch set of books general ledger of batch operation and the data of set of books general ledger in lines overseas;

Described summarizing module gathers calculating to the data that read;

Described memory module deposits the data that gathered in form table as a result.

Images