System Architecture for integration between bank software and organization accounting software

1.1 Introduction:

Every organization do their financial transaction through financial institution .They have accounts for collect bills/fees/distributor payments .Once financial institution receive any amount of money at these account’s they entered some information’s in their software .Each organization get the statement and manually posted to their accounting system. This kind of job indicates work redundancy. Also bank has multiple channel to deposit or withdraw money such as branch banking, Internet banking,mobile banking ATM etc.

This article will help software engineer to create integration system between bank system and organization accounting system.

1.2 Document Key word:

Organization accounting system: OAS

Bank system: FIS

DB: Database

MW: Middle Ware

VPN: Virtual Private Network

1.3 Scope:

The following scopes are currently available for this system.

-Bank will collect bill’s/Fees/Invoice.

-Send bill/fee/Invoice amount to organization database just in time.

For better understand and easy document writing I have assumed a organization named ORG and Bank named FI.

1.4 Overall Description

1.4.1 System Environment

                                    Fig1.1: System Environment

1.4.2 Steps for setup the integration system:

Step1:

            FI and organization MW(Middle Ware) server’s will be connect through VPN(Virtual Private Network) connection.

Step 2: Each MW server will connect with MW database.

Step 3: ORG will develop 3 web service method’s.

            a.Find

            b.PaymentConfirmation

            c.Reverse

Step 4: FI Need to access ORG web service.

Step 5: FI Need to develop a web service named SyncValidData which will post data to their MW DB to Main DB.

Or

 FI need to develop a DB Trigger named SyncValidData which will post data to MW DB to Main DB.

Step 6: ORG need to develop a web service named SyncValidData which will post data to MW DB to Main DB.

Or

ORG need to develop a DB Trigger named SyncValidData which will post data to MW DB to Main DB.

Step 7: ORG accounting system must insert process bill to its MW DB

1.5 Needed information

1.5.1 For FI:

1. Bill No

2. Bill Name

3. Total Amount

4. Vat

5.Status(Initiate/delivered/Reversed)

1.5.2 For ORG:

1. Transaction No

2. Transaction Date

3. 5.Status(delivered/Reversed)

1.6 Reference:

1. Web service

2. DB Trigger

3. VPN(Virtual Private Network)


My Others:
Web: http://techhunter047.com
Other Blog: http://ghorhishab.blogspot.com
Software: http://techhunter047.com/ghorhishab