KR100983154B1 - Annual expenditure e-banking system interlocked with local finance management system and erp system of local government system and method for the same - Google Patents

Abstract

PURPOSE: A system for managing local finance of a local government and a system and a method of expenditure e-banking which connected an ERP(Enterprise Resource Planning) system are provided to enable a local government to process all the expending behaviors for satisfying a finance demand on online in real time, thereby simplifying administrations. CONSTITUTION: A local finance management system(110) generates expense instructions and capital allotment data. The local finance management system stores the expense instructions and the capital allotment data in an expense resolution DB. The local finance management system transmits the expense resolution DB to a financial data providing system(120). The financial materials providing system transmits the expense resolution database to a expenditure system(130).

Description

Expenditure e-banking system and method in connection with local financial management system and ERP system of local governments

Embodiments of the present invention relate to an expenditure e-Banking system and method in connection with the local financial management system and enterprise resource planning (ERP) system of the local government.

All expenses to meet the financial needs of the Seoul Metropolitan Government, Autonomous District (25), and subsidiary companies in Seoul issue accounting orders (pension rights), and visit the vault bank branch for daily expenses (general operating expenses, travel expenses, business promotion expenses, duties). The bank asks the appropriate person to pay the expenses such as performance expenses, special activity expenses, water supply expenses), social welfare expenses (basic pension age, livelihood benefits), and vault bank employees provide case-by-case and mass transfer processing services.

In particular, there are demands for processing large-scale transfers of 400,000 cases (living benefits) and 600,000 days (basic pension age) on the 20th of each month related to social welfare expenses.

These financial services can be handled through Internet banking without the need for accounting officials to visit financial institutions. Accidents, etc. Accident occurred on the 15 billion won over four years and eight months since 2005.

In addition, when allocating funds from accounting accounts by departments and departments to appropriation accounts by departments and government offices, real funds are allocated to manage the status of self-accounting funds, which prevents work efficiency and fraudulent expenditures. There was a request for construction (operation as limit management without moving actual funds when allocating funds).

An embodiment of the present invention is to simplify and cost administrative procedures such as issuing and storing payment orders by processing online all the expenditures (payment orders, fund allocation, etc.) in order to meet financial needs in local governments such as Seoul. We provide the expenditure e-Banking system and method in connection with local government's local financial management system and ERP system that can improve public service by reducing and promptly depositing money.

The problem to be solved by the present invention is not limited to the problem (s) mentioned above, and other object (s) not mentioned will be clearly understood by those skilled in the art from the following description.

The expenditure e-banking system linked with the local financial management system of the local government according to an embodiment of the present invention receives the payment resolution and the expense details from the head office and the establishment of the local government, approves the spending resolution, and the expenditure. A local financial management system for generating expenditure orders and fund allocation data and sending the data to a financial data providing system based on the expenditure resolution and the expenditure details when the resolution is approved; The financial data providing system for receiving the expenditure order and the fund allocation data from the local financial management system and transmitting the data to the appropriation system through a linked server; Receive the payment instruction and the fund allocation data from the linked server through the financial data providing system to query the payee, and if the payee's account is justified, send the pay order and the fund allocation data to the bank host system to receive the payee. An appropriation system for requesting a transfer of funds to an account; And receive the expenditure order and the fund allocation data from the appropriation system, process the transfer of funds to the beneficiary account, and transmit the fund transfer processing result to the appropriation system to manage the local finance through the financial data provision system. The bank host system for delivery to the system.

According to another embodiment of the present invention, the expenditure e-banking system linked with the ERP system of the local government receives the expenditure resolution and expenditure details from the subsidiary of the local government, approves the expenditure resolution, and the expenditure resolution is approved. An enterprise resource planning (ERP) system that generates an expenditure order based on the expense resolution document and the expense details; Receiving the expenditure order from the ERP system through interworking with the CMS (Cash Management Service) system of the affiliated agency and the Internet, inquiring the payee, and sending the expenditure order to the bank host system if the payee's account is justified. An appropriation system for requesting a transfer of funds to the payee account; And the bank host system receiving the expenditure order from the appropriation system, processing the transfer of funds to the payee account, and transmitting the fund transfer processing result to the appropriation system to be delivered to the ERP system through the CMS system. It includes.

The expenditure e-banking method in connection with the local financial management system of the local government according to an embodiment of the present invention, in the local financial management system, receives the spending resolution and expenditure details from the headquarters and offices of the local government, and the expenditure resolution Approving; Generating, at the local financial management system, an expenditure order and a fund allocation data based on the expenditure resolution and the expenditure details when the expenditure resolution is approved; In an appropriation system, receiving the expenditure order and the fund allocation data from the financial data providing system and retrieving a payee; In the appropriation system, if the payee's account is legitimate, sending the expenditure order and the fund allocation data to a bank host system requesting a transfer of funds to the payee account; Receiving, at the bank host system, the expenditure order and the fund allocation data from the appropriation system to process funds transfer to the payee account; And transmitting, at the bank host system, the result of the money transfer processing to the appropriation system to be delivered to the local financial management system through the financial data providing system.

According to another embodiment of the present invention, the expenditure e-banking method in connection with the ERP system of a local government, in the ERP system, receiving the spending resolution and expenditure details from an establishment of a subsidiary of a local government and approving the expenditure resolution. ; In the ERP system, generating an expenditure order based on the expenditure resolution and the expenditure details when the expenditure resolution is approved; In the appropriation system, receiving the expenditure order from the ERP system through the interworking with the CMS system of the affiliated agency and the Internet network to query the payee; In the appropriation system, if the payee's account is legitimate, requesting a transfer of funds to the payee account by sending the expenditure order to a bank host system; Receiving, at the bank host system, the expenditure order from the appropriation system and processing the transfer of funds to the payee account; And transmitting, at the bank host system, the result of the money transfer processing to the appropriation system to be delivered to the ERP system through the bank CMS system.

Specific details of other embodiments are included in the detailed description and the accompanying drawings.

Advantages and / or features of the present invention and methods for achieving them will become apparent with reference to the embodiments described below in detail in conjunction with the accompanying drawings. However, the present invention is not limited to the embodiments disclosed below, but may be implemented in various different forms, only the present embodiments to make the disclosure of the present invention complete, and common knowledge in the art to which the present invention pertains. It is provided to fully inform the person having the scope of the invention, which is defined only by the scope of the claims. Like reference numerals refer to like elements throughout.

According to an embodiment of the present invention, all payments (payment orders, fund allocation, etc.) to meet the financial needs in local governments such as Seoul Metropolitan City and its subsidiaries are processed in real time online, thereby issuing and storing payment orders, etc. Simplification of administrative procedures, cost reduction, and prompt and accurate deposit processing can improve public service.

1 is a block diagram illustrating an expenditure e-banking system in conjunction with a local financial management system and ERP system of a local government according to an embodiment of the present invention.
FIG. 2 is a view illustrating a work flow of the local financial management system of FIG. 1.
3 is a diagram illustrating a business flow of the financial data providing system of FIG. 1.
4 is a view illustrating a work flow of the appropriation system of FIG. 1.
FIG. 5 is a diagram illustrating a business flow of the bank host system of FIG. 1.
6 is a flowchart illustrating an expenditure e-banking method in conjunction with a local financial management system and an ERP system of a local government according to an embodiment of the present invention.
7 to 9 is a flow chart for the expenditure fund centralized management.

The expenditure e-banking system (hereinafter, referred to as the expenditure e-banking system) in connection with the local financial management system and the ERP system of the local government according to an embodiment of the present invention is financed by a local government such as Seoul Metropolitan Government. All expenditures (expenditure orders, allocating funds) to meet demand are handled online by connecting the local governments and banks to leased lines, and between local government agencies and the banks through the Internet, and issuing and storing expenditure orders. Simplification of the procedure and prompt and accurate deposit processing can improve public service.

To this end, the expenditure e-banking system according to an embodiment of the present invention processes the spending online in connection with a local government system, that is, a local financial management system and a financial data providing system, and a local government affiliated system, The spending activity may be processed online in connection with an Enterprise Resource Planning (ERP) system and a Cash Management Service (CMS) system.

In this case, the expenditure e-banking system according to an embodiment of the present invention may establish an online verification system for the expenditure order and a data security maintenance system when transmitting and receiving the expenditure order and the fund allocation data.

The main functions of the expenditure e-banking system according to an embodiment of the present invention as described in Table 1 below. In Table 1 below, the local governments will describe the city headquarters and ward offices and affiliated organizations in Seoul as an example.

book
fence
city
example
Of
phrase
blue Local financial management
system 1. Seoul Financial Management Office
2. Enter estimate activity details and upload files
3. Cause action details input and correction function
4. Enter and edit spending activity details
5. Data output function such as schedule
6. A system in which the finance officer approves the expenditure orders received from the Seoul Metropolitan Financial Accounting System.
7. Expenditure approval function
8. Data transmission function to financial data providing system Financial data provision system 1. Data transmission function to the expenditure system
2. Ability to view spending results
3. Data output function such as schedule
4. Inquiry function such as public account




silver
line Expenditure system 1. The system that processes payment after inquiry of payee for the expenditure order of the Seoul Metropolitan Government.
2. Recipient Inquiry about Spending Orders
3. Approval of the person responsible for the payment
4. Processing spending orders and fund allocations
5. Print out data such as schedules
6. Approve data to bank host system Bank host system 1. Core Banking
2. Processing deposits and counter accounts
3. Cash Payment Processing
4. Transaction Transfer Transactions
5. Process parent / child account fund allocation by expenditure account
6. Process real money payment through the parent account when processing the limit account mountain
Ha
group
tube ERP
system 1. Financial accounting business processing system
2. Enter and edit spending activity details
3. Expenditure approval function CMS
system 1. Data transmission function to the expenditure system
2. Ability to view spending results

According to the main functions as described above can be expected the following effects.

Complaint

-Increased satisfaction with fast and accurate deposit processing

2. Local Governments (Seoul Head Office / Ward Office)

-Establishment of appropriation administration system by computerization of appropriation

-Reduction of expenditure (payment) order of administrative department and printing of slips

-Efficient work by omitting handwriting seal and computerized automatic seal processing

-Improving civil service through real-time expenditure processing and data output

-Fund concentration and integrated management

-As we improve our business and departments so that they do not have 'real money'

 Actively contribute to the prevention of fraudulent expenditure as well as the high-intensity management of funds

3. Affiliated subsidiaries (Metro, SH construction, etc.)

-Establish expenditure administration system by expenditure computerization

-Efficient work by omitting handwriting seal and computerized automatic seal processing

-Improving civil service through real-time expenditure processing and data output

-In spite of transfer of funds through approval of internal control without visiting institutional banks,

Positive contribution

3. Bank

-Management of Seoul city expenditure portal through establishment and operation of the expenditure computerization system

-Prevents money transfer errors by real-time processing of expenditure and search results

-Increase productivity by automating manual processing

Hereinafter, with reference to the accompanying drawings will be described embodiments of the present invention;

1 is a block diagram illustrating an expenditure e-banking system according to an embodiment of the present invention. FIG. 2 is a diagram illustrating a business flow of the local financial management system of FIG. 1, and FIG. 3 is a diagram illustrating a business flow of the financial data providing system of FIG. 1. FIG. 4 is a diagram illustrating a business flow of the appropriation system of FIG. 1, and FIG. 5 is a diagram illustrating a business flow of the bank host system of FIG. 1.

Referring to Figure 1, the expenditure e-banking system 100 according to an embodiment of the present invention is a local financial management system 110, financial data providing system 120, expenditure system 130, and bank host system 140 ).

The local financial management system 110 is a system for processing the local financial management of the head office / ward office in Seoul, receiving the spending resolutions and details of expenses from the headquarters and establishments of local governments to approve the spending resolutions, and the expenses If the resolution is approved, an expenditure order and fund allocation data are generated based on the expenditure resolution and the expenditure details.

The local financial management system 110 transmits the generated expenditure order and the fund allocation data to the financial data providing system 120 in preparation for the processing of the cashier expenditure.

The business flow of the local financial management system 110 will be described in detail with reference to FIG. 2.

That is, first, the expenditure resolution and expenditure details are input from the main office and the establishment 210 and sent to the finance department and the expenditure source 220. Then, the finance department expenditure source 220 examines the expenditure resolution and checks the expenditure details.

Subsequently, when the expenditure resolution is approved through the review and confirmation, the local financial management system 110 sends the expenditure resolution database DB to the financial data providing system 120 and updates the expenditure resolution DB. . Here, the expenditure resolution DB may include the expenditure resolution, the expenditure details, the expenditure order, and the fund allocation data.

As such, the local financial management system 110 may transmit the expenditure confirmed expenditure order and the allocation confirmed fund allocation data to the financial data providing system 120. In addition, the local financial management system 110 provides a screen for the user to start the transmission so that the data can be transmitted from time to time.

In addition, the local financial management system 110 may output the revenue expenditure date table, the revenue expenditure monthly table, the revenue expenditure quarterly statement, and extract the amount of the allocation return based on the fund allocation data, the cashier 160 with the allocation return order. The amount of the allocation can be recovered.

In addition, the local financial management system 110 grants the user ID and password for each user, and grants the use rights of the screen related to the task of the user based on the ID and password, thereby limiting the use of the screen data Can be prevented from leaking.

The financial data providing system 120 serves to relay data to the appropriation system 130 of local governments and banks such as Seoul. The financial data providing system 120 may transmit the expenditure order and the fund allocation data to the appropriation system 130 through the linking server 125.

In this case, the financial data providing system 120 provides a screen for the user to start the transmission, thereby enabling the occasional transmission of the expenditure approved expenditure orders and allocation approved fund allocation data to the appropriation system 130.

That is, as shown in FIG. 3, the financial data providing system 120 receives the expenditure order and the fund allocation data from the local financial management system 110 and receives the expenditure system through the linked server 125. 130, and receives the cashier processing result from the appropriation system 130.

The financial data providing system 120 may perform security management for the user. That is, the financial data providing system 120 may perform user login, user authentication, user screen registration, password change, user permission setting by user, screen, and function.

In addition, the financial data providing system 120 may request for re-approval by modifying the account number, debtor's name, etc. in the case where the data cannot be processed in the cashier 160. In addition, the financial data providing system 120 may query the processing result of the spinner, and may query the current status and analysis of the spending resolution, fund allocation.

In addition, the financial data providing system 120, like the local financial management system 110, grants an ID and password for each user, and the use authority of the screen related to the task of the user based on the ID and password By restricting the use of the screen, it is possible to prevent the leakage of data.

The appropriation system 130 is an appropriation payment processing system that processes the payment instruction and the self-sufficiency allocation data sent from the financial data providing system 120 and transmits them to the bank host system 140 in a batch.

That is, the expenditure system 130 receives the expenditure order and the fund allocation data from the financial data providing system 120, as shown in FIG. 4, inquires a payee, and if the payee's account is justified, The payment instruction and the fund allocation data are sent to the bank host system 140 to request the transfer of funds to the payee account.

At this time, the bank staff 160, the bank employee checks the expenditure order and the fund allocation order data received by the appropriation system 130 to request the bank host system 140 to allocate funds, payee inquiry, funds transfer, account information The bank host system 140 may transmit the result of the money transfer process to the appropriation system 130 by determining whether the payee account is legitimate by checking the consistency of the payee account with reference to a database.

The appropriation system 130 may perform a user login, user authentication, password change, and the like, and may perform a payment order, a fund allocation inquiry, a payment order process, and a fund allocation process.

In addition, the expenditure system 130 may query the data processed by the bank host system 140, and may query the current status and analysis of the spending resolutions and fund allocation.

The bank host system 140 is a bank accounting system that processes the money transfer data sent from the appropriation system 130.

That is, as shown in FIG. 5, the bank host system 140 receives money transfer data such as the expenditure order and the fund allocation data from the expenditure system 130 to process the money transfer to the payee account. do. In addition, the bank host system 140 transmits the result of the transfer of funds to the appropriation system 130 to be delivered to the local financial management system 110 through the financial data providing system 120.

In this case, the bank host system 140 transfers funds to other banks 170 through the Financial Settlement Center 510 and transmits the result to the appropriation system 130 in the case of the other payment. The result of the transfer of funds to the other bank 170 is also transmitted to the local financial management system 110 through the financial data providing system 120.

As described above, the bank host system 140 processes the data transmitted from the appropriation system 130 in real time, and transmits the processing result to the appropriation system 130 to process the counterpart account. In addition, the bank host system 140 may perform real-time processing on the cash processing data transmitted from the appropriation system 130.

On the other hand, the expenditure e-banking system 100 according to an embodiment of the present invention, the local financial management system 110, the financial data provided in various failure situations including errors due to power outages, server down, network load increase Design and develop a connection between the system 120 and the appropriation system 130 to design and develop a database and application that ensures the handling of exceptions, commits, and rollbacks to present data transactions and results to users. High level of consistency can be pursued.

In addition, the expenditure e-banking system 100 according to an embodiment of the present invention is in the expenditure order and fund allocation data between the local financial management system 110, the financial data providing system 120 and the expenditure system 130. In order to guarantee the integrity of the data when transmitting and receiving the data, the data header part and the detail part may be separated and operated to encrypt the data for security.

In addition, the expenditure e-banking system 100 according to an embodiment of the present invention, the local financial management system 110, the financial data providing system 120 and to ensure the consistency of the expenditure order and the fund allocation data By scheduling the metabolism of data between the appropriation system 130 to be a daily work, it is possible to build a system to automatically classify the inconsistency and confirmation request.

In addition, the expenditure e-banking system 100 according to an embodiment of the present invention by using the load (stress) test tool to capture and analyze the point where the load is abnormal or congested by improving the design or code for the macro, micro You can control traffic optimally.

In addition, the expenditure e-banking system 100 according to an embodiment of the present invention can prevent the increase of load due to incorrect design and coding by the optimization of the program. That is, the expenditure e-banking system 100 according to an embodiment of the present invention may be caused by an incorrect modeling of a method or a class of a program, an analytical engineering preliminary check, or a micro error due to an analysis tool. The increase in load can be prevented.

In addition, the expenditure e-banking system 100 according to an embodiment of the present invention distributes network load by utilizing a load balancing function applied to a web application server (WAS) and a transaction processing (TP) monitor middleware. By this, the throughput of the whole system can be increased and the processing time can be shortened.

In addition, the expenditure e-banking system 100 according to an embodiment of the present invention may further include an ERP system 180.

The ERP system 180 is a system for processing the financial accounting of the affiliated organizations, and performs the function of inputting and modifying the expenditure activity details and the expenditure approval function as described above.

The ERP system 180 is connected to the appropriation system 130, the business process thereafter is the same as the local financial management system 110. However, the ERP system 180 connects to the appropriation system through interworking with the CMS system of the affiliated agency and the internet network and transmits the expenditure order, and does not process the fund allocation.

6 is a flowchart illustrating an expenditure e-banking method according to an embodiment of the present invention. Here, the expenditure e-banking method may be performed by the expenditure e-banking system of FIG.

1 and 6, in step 610, the local financial management system 110 receives a spending resolution and expenditure details from the main office and establishment 150 of the local government.

Next, at step 620, the local financial management system 110 approves the spending resolution. If the spending resolution is approved, in step 630, the local financial management system 110 generates an expenditure order and fund allocation data based on the spending resolution and the expenditure details.

At this time, the local financial management system 110 grants the user ID and password for each user, and grants the use rights of the screen related to the task of the user based on the ID and password, thereby limiting the use of the screen data Can be prevented from leaking.

Next, the financial data providing system 120 receives the expenditure order and the fund allocation data from the local financial management system 110 and delivers it to the appropriation system 130. That is, the financial data providing system 120 serves to relay the local financial management system 110 and the appropriation system 130.

The financial data providing system 120 assigns an ID and a password to each user, and grants the use authority of a screen related to the task of the user based on the ID and password, thereby restricting the use of the screen and leaking data. Can be prevented.

Next, in step 640, the appropriation system 130 receives the expenditure order and the fund allocation data from the financial data providing system 120 to query a payee.

Next, at step 650 the cashier 160 server checks the integrity of the payee account with reference to an account information database to determine whether the payee account is legitimate. The cashier 160 bank employee checks the expenditure order and the fund allocation order data received by the appropriation system 130 and requests the bank host system 140 to allocate funds, payee inquiry, and transfer funds. The bank host system 140 transmits the fund transfer processing result to the appropriation system 130.

As a result of the processing, if the payee account is justified (YES direction 650), in step 660, the appropriation system 130 transmits the expenditure order and the fund allocation data to the bank host system 140, and the Request funds to be transferred to the payee account and to the appropriation account.

On the other hand, if the payee account is not justified (“No” direction 650) as a result of the processing, the appropriation system 130 performs step 640. That is, the appropriation system 130 relooks the payee. In this case, the appropriation system 130 may output an error when the payee account is not justified for a predetermined number of times as a result of the payee inquiry.

Next, at step 670, the bank host system 140 receives the expenditure order and the fund allocation data from the appropriation system 130 to process the transfer of funds to the payee account.

Next, in step 680, the bank host system 140 transmits the result of the transfer of funds to the appropriation system 130 to the local financial management system 110 through the financial data providing system 120. To be delivered.

As such, the expenditure e-banking system and method according to an embodiment of the present invention, local governments, such as Seoul Metropolitan Government and its subsidiary, all expenditure (expenditure order, allocating funds) to meet the financial needs of local governments By connecting online to the banks through the leased line, the service can be improved by simplifying administrative procedures such as issuing and storing expenditure orders and prompt and accurate deposit processing.

On the other hand, the centralized integrated fund management system abolishes the existing fund allocation system, and manages / operates all funds, including project costs as well as institutional operating expenses, for the first time in the main office of the main office. This can be avoided by dividing appropriations by divisions and departments and maximizing the use of consolidated funds.

For example, if the centralized fund management system is applied to Seoul City, it is possible to centrally manage a total of 419 parent accounts and 2,389 child accounts, that is, 2,808 accounts into one parent account. / Account / by accounting). In other words, for the purpose of managing expenditure funds, it is possible to complete the mother-to-child account connection setting for a total of 2,808 accounts (excluding housing business special accounting and four non-executed wards) and to centrally manage one mother account for each city / gu / account. In addition, in order to prevent mixed funds, all self-accounts, such as departmental daily security accounts, can be opened / operated according to the nature of funds (by city, city, and accounting).

In addition, by implementing the above-mentioned funds centralized management system to perform the account unification, it is possible to organize the cancellation and long-term unused accounts (eg, 418) that have been neglected for many years. In addition, all department / office funds are collected and centrally managed by the central office, so that the balances of all books and all offices can be zeroed (zero account balance).

The expenditure e-banking system according to an embodiment of the present invention provides a function to query the real-time fund expenditure status of the parent account according to the integrated fund management system. In this case, the expenditure e-banking system may provide the inquiry function on the basis of the actual money expenditure of the mother account excluding the limit (fund allocation, daily security grant). In addition, the expenditure e-banking system provides a function for inquiring in real time the limits of the account.

Therefore, according to one embodiment of the present invention, a new government proposes a revolutionary new alternative through efficient fund management and management, such as minimizing borrowings by preventing one-won from falling asleep for one day to structured local governments. By ensuring that the balance of management accounts (department accounts) for each department is always zero (0 month), it is possible to lay the groundwork for efficient accounting such as the reduction of the processing stage (abolition of fund allocation stage) and the simplified settlement.

In addition, according to an embodiment of the present invention, by improving so that all establishments and departments do not hold the 'real money', it can actively contribute to the prevention of fraudulent expenditure as well as high-intensity management of funds, practitioners visit banks or wired It is possible to maximize work efficiency by improving the account balance / limit, etc. without being checked in the computer system.

7 to 9 are flow charts for centralized expenditure fund management, specifically, FIG. 7 is a flow chart for general expenditures and returns, and FIG. 8 is a flow chart for expenditures and returns for daily expenses, and FIG. This is a flow chart of payment for daily expenses and return of payments.

First, in the case of general expenditure and return, as shown in FIG. Subsequently, when the expenditure occurs, the limit assigned to the account of the office of the establishment account is subtracted from the account of the main office accounting account on the day of expenditure, and the funds of the account account of the establishment of accounting are spent on the debtor account (the day of the expenditure). When the funds are returned from the debtor account (the day of the return), the mother account for each main office account returns funds from the account for each business account and increases the limit of the account for each business account. Alternatively, the funds can be directly spent (the day of expenditure) and the return of the money (the day of return) between the parent account for each main office account and the debtor account, without going through the account for each establishment.

As shown in FIG. 8, in the case of the daily expense grant expenditure and the return of the grant, a limit is assigned to the self-account by the account of the establishment in the main account by the main office account. In addition, in the account for each business office account, a limit is assigned (granted) to the daily expense account, and the deducted limit is deducted (the day of return). Alternatively, a limit assignment (day of issue) and a limit deduction (day of issue of return) may be performed between the parent account for each main office account and the daily security account, without going through the account for each establishment.

In the case of daily expenses payment and payment return, as shown in FIG. 9, first, a limit is assigned to a subsidiary account of each establishment accounting in the main account of the main office account. In the account of each establishment, the limit is assigned to the daily security account. Subsequently, when the expenditure occurs, the limit of the daily security magnetic account is deducted from the parent account-specific account of the main office (the day of the expenditure), and the money is sent to the debtor account in the daily expense account. When funds are returned from the debtor's account to the daily security account (the day of return), the main account accounting account of the main office returns the funds from the daily security account and increases the limit of the daily security account (return day). Alternatively, a direct limit allocation (granting), fund expenditure (day of expenditure), limit deduction (day of expenditure), and funds between the parent account for each main office account, the daily expense account and the debtor account, and not through the account for each business office account. Return (the return day) and limit increase (the return day) can be performed.

Embodiments of the present invention include computer readable media including program instructions for performing various computer implemented operations. The computer readable medium may include program instructions, local data files, local data structures, or the like, alone or in combination. The media may be those specially designed and constructed for the purposes of the present invention, or they may be of the kind well-known and available to those having skill in the computer software arts. Examples of computer-readable recording media include magnetic media such as hard disks, floppy disks, and magnetic tape, optical recording media such as CD-ROMs, DVDs, magnetic-optical media such as floppy disks, and ROM, RAM, flash memory, and the like. Hardware devices specifically configured to store and execute the same program instructions are included. Examples of program instructions include not only machine code generated by a compiler, but also high-level language code that can be executed by a computer using an interpreter or the like.

While specific embodiments of the present invention have been described so far, various modifications are possible without departing from the scope of the present invention. Therefore, the scope of the present invention should not be limited to the described embodiments, but should be determined not only by the claims below, but also by the equivalents of the claims.

As described above, the present invention has been described by way of limited embodiments and drawings, but the present invention is not limited to the above-described embodiments, which can be variously modified and modified by those skilled in the art to which the present invention pertains. Modifications are possible. Accordingly, the spirit of the present invention should be understood only by the claims set forth below, and all equivalent or equivalent modifications thereof will belong to the scope of the present invention.

110: local financial management system
120: financial data provision system
130: appropriation system
140: bank host system
180: ERP system

Claims (12)

After the expenditure resolution and expenditure details are inputted from the headquarters and establishment of the local government to the finance and expenditure source, the expenditure resolution is reviewed by the finance and expenditure source and the expenditure details are confirmed. Approve the expenditure resolution, and if the expenditure resolution is approved, generate expenditure orders and fund allocation data based on the expenditure resolution and the expenditure details, and generate the expenditure orders and fund allocation data from the expenditure resolution and the expenditure data; A local financial management system that stores in the expenditure resolution database along with details and updates the expenditure resolution database and transmits the expenditure resolution database to a financial data providing system;
The financial data providing system for receiving from the local financial management system an expenditure resolution database including the expenditure order and the fund allocation data and transmitting to the expenditure system;
Receiving the expenditure resolution database from the financial data providing system, querying the payee using the expenditure order and the fund allocation data in the expenditure resolution database, and if the payee's account is justified, the expenditure order and the fund allocation The appropriation system sending data to a bank host system to request transfer of funds to the payee account; And
Receive the expenditure order and the fund allocation data from the appropriation system, process the transfer of funds to the payee account, send the fund transfer processing result to the appropriation system, and provide the financial data management system through the financial data provision system. The bank host system to be forwarded to
Including,
The local financial management system
Appropriate e-banking system in conjunction with the local financial management system of the local government, characterized in that the amount of money to be collected and the amount of money allocated to the allocation return to recover the amount of money.
The method of claim 1,
The local financial management system and the financial data providing system
Providing an ID and password for each user, and granting the use authority of the screen related to the task of the user based on the ID and password, by limiting the use of the screen to prevent the leakage of data Spending e-banking system in conjunction with a group system.
The method of claim 1,
Reliable handling of exceptions, commits, and rollbacks between the local financial management system, the financial data providing system, and the appropriation system in various failure situations including power failures, server downtime, and errors due to increased network load. Appropriate e-banking system linked with local government system, which is designed to connect the database and the application that guarantee the security, and to seek a high degree of consistency to present the data transaction situation and results to the user.
The method of claim 1,
In order to ensure the integrity of data when sending and receiving payment orders and fund allocations between the local financial management system, the financial data providing system, and the appropriation system, a data header part and a detail part are separated and operated. Expenditure e-banking system in conjunction with the municipal system, characterized in that for encryption of security.
The method of claim 1,
In order to ensure the consistency of the expenditure order and the fund allocation, the metabolism of the data between the local financial management system, the financial data providing system, and the appropriation system is scheduled for daily work, so that the inconsistency and the confirmation request are automatically classified. Expenditure e-banking system in conjunction with the local government system, characterized in that the system to build so that.
delete The method of claim 1,
The appropriation e-banking system incorporating a local government system, characterized in that it checks the integrity of the payee account with reference to an account information database and determines whether the payee account is legitimate, and transmits the determination result to the appropriation system.
After the expenditure resolution and expenditure details are input from the subsidiary of the local government to the finance and expenditure source, the expenditure resolution and the expenditure resolution are reviewed by the finance and expenditure source and the expenditure details are confirmed. Approve the resolution, and if the spending resolution is approved, generate an expenditure order based on the expenditure resolution and the expenditure details, and store the generated expenditure order along with the expenditure resolution and the expenditure details in the expenditure resolution database; An enterprise resource planning (ERP) system for updating the expenditure resolution database to transmit the expenditure resolution database to an appropriation system;
Receive an expenditure resolution database including the expenditure order from the ERP system, query the payee using the expenditure order in the expenditure resolution database, and send the expenditure order to a bank host system if the payee's account is justified The appropriation system to request transfer of funds to the payee account; And
The bank for receiving the expenditure order from the appropriation system, processing the transfer of funds to the payee account, and transmitting the fund transfer processing result to the appropriation system for delivery to the ERP system through the affiliated CMS system; Host system
Including,
The local financial management system
Appropriate e-banking system linked with the local government's ERP system, characterized by extracting the amount of the allocation return and assigning it to the allocation return.
In the appropriation e-banking method performed by the appropriation e-banking system including a local financial management system, a financial data providing system, an appropriation system, and a bank host system,
In the local financial management system, the expenditure resolution and expenditure details are inputted from the headquarters and offices of local governments and sent to the finance and expenditure sources. Approving the expenditure resolution through review and verification results;
Generating, at the local financial management system, an expenditure order and a fund allocation data based on the expenditure resolution and the expenditure details when the expenditure resolution is approved;
In the local financial management system, the generated expenditure order and the fund allocation data together with the expenditure resolution and the expenditure details are stored in the expenditure resolution database to update the expenditure resolution database, and the expenditure resolution database is provided with the financial data provision system. Transmitting to;
Receiving, at the financial data providing system, an expenditure resolution database including the expenditure order and the fund allocation data from the local financial management system and transmitting to the expenditure system;
Receiving, at the appropriation system, the expenditure resolution database from the financial data providing system and querying a payee using the expenditure order and the fund allocation data in the expenditure resolution database;
In the appropriation system, if the payee's account is legitimate, sending the expenditure order and the fund allocation data to a bank host system requesting a transfer of funds to the payee account;
Receiving, at the bank host system, the expenditure order and the fund allocation data from the appropriation system to process funds transfer to the payee account; And
Sending, at the bank host system, the result of the transfer of funds to the appropriation system to be delivered to the local financial management system through the financial data providing system;
Including,
The local financial management system
A method of expenditure e-banking incorporating a local financial management system of a local government, characterized by extracting the amount of the allocation return and assigning it to the allocation return.
10. The method of claim 9,
In each of the above systems, the network load is distributed by utilizing the load balancing function provided in the Web Application Server (WAS) and Transaction Processing (middleware) monitor middleware, thereby increasing the throughput of the entire system and reducing the processing time. Letting step
Appropriate e-banking method linked to the local government system, further comprising a.
10. The method of claim 9,
Granting an ID and a password for each user in the local financial management system and the financial data providing system; And
In the local financial management system and the financial data providing system, the use of the screen related to the task of the user based on the ID and the password is granted, thereby limiting the use of the screen to prevent leakage of data.
Appropriate e-banking method linked to the local government system, further comprising a.
In the appropriation e-banking method performed by the appropriation e-banking system including an ERP system, an appropriation system, and a bank host system,
In the ERP system, the expenditure resolution and expenditure details are inputted from the establishment of a subsidiary of a local government and sent to the finance and expenditure source. When the expenditure resolution is reviewed at the finance and expenditure source and the expenditure details are confirmed, the review and Approving the expenditure resolution based on a verification result;
In the ERP system, generating an expenditure order based on the expenditure resolution and the expenditure details when the expenditure resolution is approved;
In the ERP system, updating the expenditure resolution database by storing the generated expenditure order together with the expenditure resolution and the expenditure details in the expenditure resolution database, and transmitting the expenditure resolution database to the appropriation system;
Receiving, at the appropriation system, an expenditure resolution database comprising the expenditure order from the ERP system and querying a payee using the expenditure order in the expenditure resolution database;
In the appropriation system, if the payee's account is legitimate, requesting a transfer of funds to the payee account by sending the expenditure order to a bank host system;
Receiving, at the bank host system, the expenditure order from the appropriation system and processing the transfer of funds to the payee account; And
Transmitting, at the bank host system, the result of the money transfer processing to the appropriation system to be delivered to the ERP system through the CMS system of the affiliated agency;
Including,
The local financial management system
An appropriation e-banking method in connection with a local government's ERP system, characterized by extracting the amount of the allocation return and assigning it to the allocation return.

Images