GeneXus Solution Partner Platinum
IBM Business Partner
Microsoft Certified Partner
Oracle Certified ABOVE Tested
Centro de Ensayo de Software (CES)
Cámara Uruguaya de Tecnologías de la Información
Architecture
Technological Architecture
Applications Architecture
Functional Architecture
Modular Integration Architecture
Data Architecture
Operating Architecture
Technological Architecture

The Bantotal system runs on the following architectures:

Java or .Net, using a Web Browser interface (Microsoft Internet Explorer or Mozilla Firefox)

And in the following platforms:

IBM i-Series
Windows Server / SQL Server
UNIX systems with data base managers DB2 or Oracle  

The Bantotal system also maintains some earlier installations on the modality:

AS/400 centralized (text interface)
AS/400 client/server (interface Windows Foundation Classes)
Windows 2000 Advanced Server/SQL Server 2000 (interface Windows Foundation Classes)
Windows Datacenter/SQL Server 2000 (interface Windows Foundation Classes)
Client/Server ODBC running Visual FoxPro code in the clients.

Top
Applications Architecture
Bantotal is an application logically structured in layers, component oriented that exploits the re-usability of the same. In particular, the construction of a sub system is made through the interaction of components such as the construction of a “Lego”. The following figure represents graphically the construction of a loans system.
Generic resources

The generic resources are modules shared by all the sub systems. Among them, there are the main functions of the system such as:

Accounting
Security administration
Prices
Clients data base

Those generic resources provide the functions for data registration and their processing. As an example, the accounting system allows a user to define the chart of accounts and the accounting templates for each transaction. It also provides the registration program that starting upon an accounting entry makes debits and credits on the accounts, and generic outputs such as balance sheet, general ledger and inventories.


Generic processes

The generic processes are programs, interactive queries, reports, batch programs that provide the handling of data for several sub systems included in Bantotal such as:

Queries on contracts
Dues reports
Interest accrual

Based on the design principles, the same data structures are used to save the information of operations of different nature. For that reason, the same programs are also used to recover the information. In that way the same program to query a deposit contract is used to query the information on a loan. The same concept is used with programs providing functions no related to a particular product. For example, interest accrual on term transactions is a unique program. It only has to identify financial from non-financial operations, without taking into account if it is an asset or a liability operation.


Specific processes and functions

The specific processes and functions are programs, interactive queries, reports, batch programs, providing support for certain contracts or operations such as:

Classification of credit risk on the basis of standards from the regulatory authorities
Calculation and registration of allowance for possible losses
Calculation and registration of suspense interest

Those specific functions in particular are related to the loan system and are not used by the deposit system.

Instances of the transactional meta-model

To obtain a fully functional support for certain banking operation, the events of a business process can be parameterized as instances, i. e. different transactions, of the transactional meta-model provided by the system. A business analyst selects the right parameters and defines different transactions that are necessary to administer a banking product or service. As an example, in the loan system it is possible define transactions for:

Registration of a loan request
Approval or denial of request
Opening a credit line
Construction of guarantees
Disbursement of loans
Collection of loans (full or installments)
Refinancing of loans
Restructuring of loans
Top
Functional Architecture
All modules share the same processing structure, hence the functional covering of the modules, except for those particular characteristics of each product or service, are the same.


Client service

Any module can access to the Client Integral Position to know those products and services that the client uses, balances and conditions (special prices), limits (granted, used, available) and guarantees. In addition, the financial products have included simulation features for new and existing operations. At this level, there can be defined products or product packages (“combos”) that make up the financial products offering of the financial institution. For a particular product, there have to be pre-parameterized a group of definitions such as:

Currency
Minimum and maximum terms
Minimum and maximum amounts
Interest accrual method (advanced-due, simple-composed, over capital-discount)
Basis of calculation (360/365, 365/360, etc.)
Interest rate
Rate type/reference (LIBOR, Prime, etc.)
Payment method (French, free, etc.)
Collaterals (Insurance, etc.)
Commissions and taxes
Other (Checkbooks, cards, overdraft agreements, etc.)

 
Process of work

The flow of operations work can be parameterized end-to-end using GXflow, a process design tool integrated in Bantotal. GXflow works with object states. Changes in states are the output of one process and the input of another one. The jobs that perform the activities within a process receive their assignments through an in-box that filters by state. The in-box has associated the transactions that can be launched.


Transaction

Each step in a process can have associated one or more transactions to be performed. The transactions make a call to Bantotal´s bank transactional monitor that in turn launches de transaction underlying definition. During the process, the system can send the information obtained at flow level and request additional data. A monetary transaction performed delivers the corresponding accounting in real time, with control of the accounting entry in all currencies involved. If there is an exception, the same system launches the authorization process (An example is an overdraft waiver). Rationality of transactions performance is the same for interactive/real-time or batch processes.


Documentation and messages

Transactions can also perform documentations and messaging services such as:

Prints of validations (Example: cashier transaction)
Tickets (Example: POS tickets)
High quality documentation (Example: contracts)

The system provides tools for parameterize and design printing templates, including texts, system fields, with dates and amounts in English or Spanish. Bantotal has its exclusive template editor for validations and tickets, and use the word processor Microsoft Word to edit templates for high quality printing documents.

The messaging services features support:

Parameterized definition of messages, with recommended text sensitive to language
Links between messages or message groups
Templates for SWIFT messages
Query on SWIFT sent
Input/output interface with SWIFT terminal
Capture of incoming MT 100/MT 103 and MT 700 messages to feed automatically transaction data


Accounting

Accounting is real-time updated by monetary transactions. Bantotal classifies automatically all the balances as needed to comply with standards from regulatory authorities. Besides, the accounting function implements all those processes related to each operation underlying elements such as:

Valuation and revaluation of foreign currencies
Valuation and revaluations of securities

It also provides support for generally accepted accounting principles such as:

Interest accrual
Interest suspense
Allowance for possible loan losses
Changes in balance sheet presentation

The chart of accounts and accounting entries associated with transactions are can be parameterized. There are also features to link the country’s mandatory chart of accounts with head office char of accounts. The system can also maintain balances valued at historical exchange rates to comply with FASB 52.

There are information outputs, on screen or printed, such as balance sheet, inventories, ledgers, journals and others.

Thanks to the system architecture (integrated accounting), there is no need of transit accounts. The transaction control is localized in the input, which means that there will not be differences due to non-compliance with the double entry method. Because the accounting entry is embedded in the transaction cycle, there are no differences between the product portfolio and its accounting.


Reporting to regulatory authorities

Bantotal makes easy the reporting to regulatory authorities. All products capture enough information to comply with the standards. All the features can be parameterized.

Top
Modular Integration Architecture
The system has been planned and designed to conceive a full integration among the different component features such as:
   
A unique data is necessary to satisfy client, accounting and product visions
A unique data structure allows save data from different class contracts (checking accounts, time deposits, loans, guarantees, etc.)
The interface is friendly and there is no need to enter different transactions or use transit accounts to complete an operation. Examples are:
 
To enter a loan and disbursing the loan on a demand deposit account
To receive a time deposit and withdraw the funds from a savings account
Top
Data Architecture
A relational database maintains all the system information. Due to the features of GeneXus and the design of Bantotal, the tables are normalized at the third normal form, and there are redundancies to improve the performance of certain processes (Example: through collection of data from the different system modules it creates a support file for reporting to regulatory authorities). When the database is modified, GeneXus builds up automatically data migration programs from old to new structures. Data integrity is held by:

Domain integrity (Examples: data type and validation lists)
Referential integrity (Example: cannot delete a client that has living contracts)
Transactional integrity (Example: the use of commit and rollback)

Database management features maintain journals and logs that allow the identification of the user, date and time when a transaction was performed.
Top
Operating Architecture
The system can function on a 7x24 basis, allows the parallel performance of interactive, and batch operations. The transactional integrity is assured through the features of commit and rollback. There is a unique journal provided by Bantotal and by the data base manager at the table’s level. Data, including accounting data, are updated on-line and in real time. There are some batch processes needed such as incoming clearance checks, interest accrual, allowance for credit losses calculation, and some others. The system supports date value and accounting date value, and reconstructs in automatic form the accounting balances from date value through process date value. The system allows to certain users to reverse transactions including accounting entries.

In batch processes, there is a control table that leads the performance, and that lets to define the sequence and timing or calendar of the execution. Those processes are designed for concurrent performance on several processors, and that allows a dramatically reduction of the critical path. That also depends on the nature of the process, such as groups of branches, modules, transactions. Batch processes are performed in automatic form thus requiring a minimum support to the operation.
Top