The database layer is the lower most layer handling the database I/O.
The application layer holds the application logic. The OLE automation
layer provides a wrapper around the application objects for OLE
automation. The UI layer consists the screen details and user interaction.
The layered architecture helps in isolating the UI and the database from
the application logic.

Object Linking and Embedding (OLE)

E.X. offers application integration with other Microsoft Office product.
For instance, the reports generated in E.X. can be embedded directly
into Microsoft Word or Excel.


OLE automation support

Automation allows the user to program on E.X. The automation objects
have been provided to be called using VBA scripts for getting data from
E.X. or set data into E.X. Various functions of E.X. are provided as
automation objects. The properties and methods of these objects can
be set from outside E.X. Some of the important E.X. automation objects are:

1. Create accounts
2. Maintain accounts and balances
3. Maintain items and narrations
4. Enter vouchers through OLE controllers.


Invoice Designer

E.X is the only accounting software with the unique document designer
with which the user can decide on how the invoice looks with total
flexibility in the placement of details. The fields, columns, logos can be
dropped in the invoice layout from the field list and the properties of
the same can be set to match the requirement.

This feature has been developed using Graphic Front End (GFE) which
is a special state-of-the-art tool developed in-house at Tata Consultancy
Services.