Welcome to the learning unit on Enquiries in T24 – An Introduction .

In this learning
unit you will learn about Enquiries in T24. You will also create simple enquiries that will
fetch data from T24.

T24 Enquiries 1
 At the end of this learning unit you will be able to

Explain what is an Enquiry in T24

Create Simple Enquiries in T24
Execute Enquiries in T24
Create Enquiries with Fixed & Dynamic Selection Criteria
Sort the output of an Enquiry
Set Favourites Selection criterion in Enquiry.
Create Drill down enquiries

T24 Enquiries 2
 Reports are a crucial aspect of any banks business for analysis and future business
predictions

ENQUIRY is a T24 application which allows you to create user defined reports that
fetch and display data as per the requirements of the user.

An enquiry is a query that is executed to fetch data from the database and display the
results in a user defined format

In technical terms, an enquiry is a ‘SELECT’ executed in order to fetch data from T24
and the results displayed in a user defined format

T24 Enquiries 3
 T24 is made up of different applications like CUSTOMER , ACCOUNT ,
FUNDS.TRANSFER etc. An application validates and stores the data that is input.

To view data from an application , you can do a LIST (L) of all the records. You can
also view a particular record, if you know the record ID using the SEE (S) function. The
LONG LIST (L L) function allows you to specify a selection criteria before the list of
records are displayed to you.

However you may use the ENQUIRY application to create reports in user defined
formats

T24 Enquiries 4
 ENQ is the command to launch an enquiry. It internally executes ENQUIRY.SELECT
which provides the user with a Selection Criterion Screen. Based on the selection
criterion specified dynamically by the user in the Selection Criterion Screen, the
enquiry fetches the desired records which match the condition (as shown in snapshot
2)

System defined enquiries start with a %, or have a “–”

Eg: %CUSTOMER, %ACCOUNT, %FUNDS.TRANSFER,
%LD.LOANS.AND.DEPOSITS, CURRENCY-LIST, CATEGORY-LIST
These enquiries should not be amended.

T24 Enquiries 5
T24 Enquiries 6
T24 Enquiries 7
 This task teaches you to create a simple enquiry. The requirement for the task
is as follows,

The enquiry is based on the CUSTOMER application . The fields to be part of

your enquiry are - @ID, MNEMONIC, SECTOR, NATIONALITY and
RESIDENCE .

Note: When discussing the use of fields in the ENQUIRY application, only
RELEVANT fields are discussed and displayed in the screenshots.

T24 Enquiries 8
 To create an enquiry in T24, create a record in the ENQUIRY application. The ID for
your enquiry can be any meaningful alphanumeric text. The only special character
allowed is ‘.’.

Before designing an enquiry, decide on the page layout. Does your report have a
header? How many lines can be displayed per page of the report? The first field
PAGE.SIZE allows you to do this. Specify the number of lines for the header and
number of lines for the body of the report separated by a comma. In this example four
lines are allocated for the header and twenty lines are allocated for the report.

Enquiries are created to query and fetch data from tables. Specify the table to be
queried ( which is the application name itself as there exists one table behind every
application which has the same name as the application name) in the field
FILE.NAME. In the example the enquiry is created for the CUSTOMER application.

T24 Enquiries 9
 Specify the Header Information as shown.

FIELD.NAME is an associated multi-value set used to display header lines. The text to
be displayed as column heading is specified in the OPERATION field. The value
specified in FIELD.NAME is not the one which is displayed.
Specify the first line of the header as “Temenos Training” . The text to be displayed as
header should be enclosed within quotes.

Use the COLUMN field, to specify the position of header text – column and row details.
The first value represents the column and the second value represents the row. The
two values are separated by a comma.

Use SECTION field to specify where the header has to be displayed. Choose
HEADER.

T24 Enquiries 10
 Each column in the report is an extracted field from the application (i.e., table). Each
column must have a header that represents what data is being displayed. This header
is mentioned in the field FIELD.NAME. The OPERATION field holds the actual name
of the field in the table. Data is fetched from this field from the table and populated in
the enquiry.
Tip: If you specify the actual field name from the STANDARD.SELECTION in the field
FIELD.NAME, this value is defaulted in the OPERATION field too. This saves you
some time during enquiry creation. If you desire a user-defined column heading, give
a different label in the field FIELD.NAME, but the OPERATION field will not be auto-
populated

Specify the order for the fields to appear in the enquiry in the COLUMN field. The first
field @ID is displayed in column one. If COLUMN is left blank, the column will not be
displayed as part of the report.

Note: Columns must always be specified in the correct order, meaning from left to
right. The ENQUIRY application cannot display the output correctly if the columns are
all mixed up.

FIELD.NAME is an associated multi value set. Multi-value the field FIELD.NAME to

specify the other fields.

Value for the LENGTH.MASK field is defaulted by T24. You can adjust the length and
justification of the field using the LENGTH.MASK field . Also the value in the field
SINGLE.MULTI is defaulted by T24 depending on the nature of the field. This field can
hold the value S or M.

T24 Enquiries 11
 Execute the enquiry to view the output. Use the command ENQ followed by the
enquiry (name) ID at the command prompt. ENQ is the abbreviation for
ENQUIRY.SELECT application.
The enquiry will display all the records against the 5 fields specified earlier, page by
page. That is, by default, any enquiry is T24 displays all records from the application
the enquiry is based on.
You may also specify conditions at runtime in an enquiry. Based on the values
supplied by the user, the enquiry will filter the records and only fetch those which
satisfy the condition Eg – Display only customers belonging to Sector 1001
2. When you execute the enquiry, a Dynamic Selection Criteria box appears. This
allows you to specify run time selection criteria based on all fields of the application the
enquiry is based on. You may specify one or more conditions in the selection criteria
box to filter out specific records from the database. The format of the criteria is
<Fieldname> <Logical Operand> <Value>. When you specify multiple conditions,
there is a logical AND between them. Then click on the Find button to execute your
enquiry. You will see that you can specify a selection criteria on any field of the
CUSTOMER application. The list of fields displayed here matches the list of fields in
the STANDARD.SELECTION record for the CUSTOMER application.
1.Another way of specifying the selection criteria at runtime is while executing the
enquiry itself. ENQ CUST.ADDRESS.ENQ SECTOR EQ 1001
Here the selection criteria is appended along with the execution request. You can use
the following command to use the last specified condition,
ENQ CUST.ADDRESS.ENQ LAST.
The keyword word “LAST” instructs the system to use the last selection criteria used.

T24 Enquiries 12
 Note: The Selection criteria is cached by T24 in the file F.ENQUIRY.SELECT.
3.The enquiry result may consist of more than one page of results depending upon the number
of records selected and the page size of the enquiry. You can use the Previous Page and the
Next Page buttons to navigate between the pages.

T24 Enquiries 12
 To display user defined headings

FIELD.LBL - Header for a field is specified in the field FIELD.LBL . Header for the @ID
field is specified in FIELD.LBL as ‘Customer Code’ and similarly for Mnemonic. If this
field is left blank, value in FIELD.NAME field will be defaulted.

Authorise your enquiry record and execute to view the results. Ensure that you specify
COLUMN value for all the fields.

T24 Enquiries 13
 This is the workshop section of the learning unit.

1. Create a report based on the ACCOUNT application in T24 which lists the
following fields

2. @ID (Account ID), MNEMONIC, CURRENCY, CATEGORY and

WORKING.BALANCE

3. Execute the Enquiry to generate the report of customers who belong to SECTOR
(One thousand and one) 1001

T24 Enquiries 14
 This task teaches you to specify fixed selections and dynamic selection
criteria in enquiries. Consider a scenario where a bank decides to provide an
offer for the US customers who belong to a particular SECTOR .The SECTOR
is specified at run time. How will you create an enquiry for the given
requirement?

1. Create a report based on the CUSTOMER application in T24.

2. The fields to be displayed are @ID (Customer ID), MNEMONIC,

SECTOR, NATIONALITY and RESIDENCE.

3. Display only those customer records whose nationality is US

4. The Value for the field SECTOR need to be obtained from the user at
run time. Make this as a mandatory input.

T24 Enquiries 15
 You need to design a report which only display information of customers whose
nationality is US. Since this requirement is fixed, specify it in FIXED.SELECTION
field. More than one fixed condition can be specified, if required by a logical AND
between the multiple conditions. The condition specified in fixed selection will be
executed first and always before dynamic selection. It first filters records with
nationality equal to US, and then applies the dynamic conditions specified at runtime
on these filtered records. User does not have privileges to modify this condition during
execution.

The format of FIXED.SELECTION is FIELD.NAME <space>operand <space> value.

The required condition for this example is ‘NATIONALITY EQ US', where
NATIONALITY is a field name and EQ is the operand. The fixed selections are always
executed first, before the dynamic run time selection criteria that is entered.

To make SECTOR as a mandatory dynamic selection criteria input, use the field
SELECTION.FLDS. To change the label of the field that is displayed in the dynamic
selection criteria, use SEL.LABEL. This multi-value set also allows you to impose
restrictions on the operand to be used in the dynamic selection criteria using the
SEL.FLD.OPER (Selection Field Operand). Multiple operands can be provided in this
field ,delimited by space. Set the field REQUIRED.SEL to Y to make the field
mandatory at runtime. The enquiry will not execute till a value is provided for
SECTOR in the dynamic selection criteria box.

You will notice that unlike the last task, when you use these set of fields, only the

T24 Enquiries 16
 application fields configured here are displayed during run-time in the dynamic selection
criteria box.

T24 Enquiries 16
 Usage of brackets to OR conditions in ENQUIRY. By default all the conditions that are
given in the selection box are AND conditions. To give an OR condition use the open
bracket facility in the enquiry

T24 Enquiries 17
 You may often need to specify multiple conditions in the enquiry that you create. How
do you link these conditions together? The multiple conditions can be grouped using
the relational operators , ‘AND’ or ‘OR’.

The dynamic conditions of your enquiry NATIONALITY is US or RESIDENCE is PA

How do you relate the two dynamic conditions? Therefore relate the two conditions
using the OR operator. This is specified in the field called REL.NEXT.FIELD. The
REL.NEXT.FIELD provides two options namely AND , OR. Dynamic Selection Fields
form a multi value set. By default all the dynamic selection conditions work with the
AND operator. However you may also use the OR operand to group the dynamic
selection conditions.
Specify the other required fields and authorise the enquiry record.
Output
1. When you launch the enquiry, it pops up a Selection Criteria box. This Selection
Criteria box forces the user to enter values for RESIDENCE and NATIONALITY at
run time. Enter the values for these fields and execute the enquiry to view the
output.
2. You can see the sample output of your enquiry. Customer 100329 is displayed in
output although nationality is not US because the residence is PA

T24 Enquiries 18
T24 Enquiries 19
 To sort records in the descending order of their MNEMONIC, USE the field
FIXED.SORT field in the ENQUIRY application

FIXED.SORT- This field is used to specify fixed sorts for enquiry. Specify the name of
the field that has to be sorted. By default the system sorts in ascending order. To sort
the records in descending order specify DSND along with the field name.

Authorise the enquiry and execute.

T24 Enquiries 20
 1. Amend the enquiry to ensure data that meets the following condition alone is
retrieved from the database.

2. Either the value for currency has to be supplied or the value for category has to be
supplied And

3. Account should be a valid customer account.

Hint : Internal accounts do not have a value in the field CUSTOMER

T24 Enquiries 21
 1. T24 provides built-in Enquiries. The naming convention for these Enquiries are
%Application name.
1.1 Some of the built-in Enquiries are %ACCOUNT,%CUSTOMER,
%FUNDS.TRANSFER etc.

2. When you execute the LONG LIST (L L) function on the command line , internally
the T24 system invokes the built-in Enquiry of T24.

3. However you can also modify these built-in Enquiries.

T24 Enquiries 22
 1. The application EB.SELECTION.FAVOURITES can be utilized by the user and
system administrators. This is to save specific enquiries based on selection criteria
as favourite enquiries.

2. Depending on the structure of the record ID these saved records can be system
wide (available to everyone) or available to specific users.

3. If a favourite for an enquiry is not required it can be disabled by setting the

ATTRIBUTES field in ENQUIRY as NO.ENQUIRY.FAVOURITES.
If this is set then the favourites do not appear when executing the enquiry.

T24 Enquiries 23
 The following is a USER specific EB.SELECTION.FAVOURITES record with the ID
defined in the format ENQUIRY*USER.ID, where ENQUIRY is a valid T24 enquiry.

Specify the required selection criteria and the Name for your favourite in this record. In
the above illustration (SECTOR 2001 GBP) and (SECTOR 3503 GBP) are the 2
named favourites.

T24 Enquiries 24
 The user can also create favourites when an ENQUIRY is launched.

Launch the CUST.ADDRESS.ENQ. Enter the desired Industry into the Industry drop
down.

Click on the ‘Add Favourite’ image. Enter a Label in the prompt (eg Health Care
Industry)

Click OK. The new favourite reflects on the screen.

T24 Enquiries 25
 A system wide favourite can be created with Record ID with an valid T24 Enquiry
Name without attaching a USER id to it. Eg. ACCT.BAL.TODAY.
Now what is the difference between a User specific favaourite and a system wide
favourite ?
The system wide favourite is available for all T24 users who launch that specific
enquiry whereas a User specific favourite appears only for that specific user and not
for others.

Above is a screen shot displaying a system wide favourite defined in the

EB.SELECTION.FAVOURITE application and the change it effects

In the above screenshot AUTHORISER tries to launch the ACCT.BAL.TODAY

enquiry. As you can see both the system wide as well as the user specific favourite is
made available for that user.

A user specific favourite can be deleted by clicking on the favourite image shown with
a (-) sign. An important information that we need to understand here is that a system
wide favourite cannot be deleted by a normal user.

T24 Enquiries 26
 1. Can you view the customer information of a particular customer from an enquiry
based on the ACCOUNT application?

The user should be given a link to drilldown to the customer information. This link
should be specified in the enquiry that is based on the ACCOUNT application.

2. In T24 you can navigate from one enquiry to another

3. The process of linking two or more enquiries is known as drilldowns

T24 Enquiries 27
 This task aims at teaching you drilldown enquiries.

Assume that you have created an Enquiry for the ACCOUNT application. From its
output is it possible to link to another enquiry based on the CUSTOMER application so
that you can also view customer details? Yes this can be done. This is what is known
as a drill down.

The enquiries to which you can link to must be defined in the parent enquiry record
itself. In this example the parent enquiry is based on the ACCOUNT application. From
this parent enquiry invoke the child enquiry that is based on the CUSTOMER
application .

The requirement of the task is as follows:

1. Create an Enquiry based on the ACCOUNT application with the following fields -
@ID , CUSTOMER.NO,CATEGORY,CURRENCY & WORKING.BALANCE.

2. Using this Enquiry invoke another Enquiry which is based on the CUSTOMER
application. The Enquiry based on the CUSTOMER application has the following fields
– CUSTOMER.NO,MNEMONIC, SHORT.NAME & NATIONALITY.

T24 Enquiries 28
 The parent Enquiry is based on the ACCOUNT application. Specify the field name &
field value for the fields - @ID,CUSTOMER.NO,CATEGORY,CURRENCY &
WORKING.BALANCE.

Note : The field name of the CUSTOMER field is CUST.NO

T24 Enquiries 29
 Next you will create the child enquiry which is for CUSTOMER application. Specify the
following fields – CUSTOMER.NO, MNEMONIC,SHORT.NAME & NATIONALITY.
Ensure that you specify the value for COLUMN field. Authorize the child Enquiry.

T24 Enquiries 30
 You have now created the parent enquiry and the child enquiry. Now you will learn
how to invoke the child enquiry from the parent enquiry. Amend the parent enquiry as
stated .To enable drilldown feature use the field ENQUIRY.NAME .

ENQUIRY.NAME – Specify the ID of the child Enquiry that has to be invoked.

SEL.CRIT – The specific customer record is chosen based on the customer id. The
customer id acts as a link between these two enquiries. The FIELD.NAME for
CUSTOMER.NO field is CUST.NO . The value of CUSTOMER.NO is passed from the
parent enquiry to the child enquiry. Specified value is CUSTOMER.NO EQ CUST.NO,
where CUSTOMER.NO is the field in child enquiry and CUST.NO is the field defined
in this parent enquiry. The value in these two fields are checked using the ‘EQ’
operand. When values in these two fields are equal the enquiry system launches the
customer report. This serves as the selection criteria for launching the child enquiry.

LABEL.FIELD- Here you will specify the field which is used to invoke the child enquiry.
The field CUST.NO is the field name for CUSTOMER.NO field. The value two(2) is
defaulted by T24. It denotes the column position of the field in this Enquiry.

NEXT.DESC – Specify the hyperlink to invoke the child Enquiry. Authorize the
Enquiry.

T24 Enquiries 31
 1. When you launch the parent enquiry, you will see the output looks different. The
account details are displayed in each row but at the end of every row there is a
hyperlink. Use the link to launch the child enquiry.

2. The child enquiry displays the specific customer as the value of the field CUST.NO
is passed from the parent enquiry to the child enquiry.

T24 Enquiries 32
 You can link enquiries using the drill down facility. Can you link an enquiry to a
version? For example, if a bank clerk is looking at an enquiry output based on the
CUSTOMER application, he must be able to click on a hyperlink that allows him to
create an ACCOUNT record for a particular customer. This is known as Context
Based Workflow in T24.You can also invoke versions from your enquiry. This section
teaches you how to create Context Based Workflows.

The requirement of the task is as follows:

1. Create an Enquiry based on the CUSTOMER application and display the following
fields @ID, and SHORT.NAME.

2. Create a version based on the ACCOUNT application and display the following
fields CUSTOMER, CATEGORY, MNEMONIC, CURRENCY & ACCOUNT.TITLE.

3. Using this Enquiry invoke a Version that creates an Account. The Customer Number
and Short Name must be defaulted into the version

T24 Enquiries 33
 You must first create the Version and Enquiry records that need to be part of the
workflow.

T24 Enquiries 34
 The task requires that values from the enquiry to be passed to the fields in the version.
The values for the fields ID and ACCOUNT.TITLE is passed to the version from the
enquiry. Therefore these fields will be populated automatically once you launch this
version.

AUTOM.FIELD.NO – In this field you specify the field name for which you want to
default the values.
AUT.NEW.CONTENT – The field AUT.NEW.CONTENT holds the value to be
defaulted. Here as you are passing the value from the enquiry, specify the content in
the following format APPLICATIONNAME>FIELDNAME.

T24 Enquiries 35
 Sub value the SEL.CRIT field and specify the value to populate the ACCOUNT.TITLE
field in the version. In the screen shot the specified value is
ACCOUNt.TITLE.1>ST.NAME where ST.NAME is the name of the SHORT.NAME
field.

LABEL.FIELD – The field in the enquiry whose value is passed to the version must be
mentioned in this field.
Note: The number in the screen shot next to the value CUSTOMER.NUMBER defaults
when the enquiry record is committed. It denotes the position of that field in the
enquiry.

The text that acts as a hyper link is specified in the field NXT.DESC.

Now authorize and execute your enquiry.

T24 Enquiries 36
 How do you make an Enquiry invoke an application or a version?

ENQUIRY.NAME – In this field you can specify an enquiry or an application name that
will be invoked next. You can specify the function followed by the application name. To
invoke an application in SEE mode you can append the function ‘S’ along with the
application. As you are going to invoke a version that will create customer accounts,
specify ACCOUNT,TRG.VERSION1 I F3. ACCOUNT,TRG.VERSION1 is the version
to be invoked. F3 is specified for auto-id generation.

SEL.CRIT - The customer ID should be automatically populated in the Account

record. You can pass the Customer ID by specifying the field name in the field
SEL.CRIT. The format is Application name>Field name. Field name should be defined
in this enquiry. In this field you will mention CUSTOMER > CUSTOMER.NUMBER ,
where CUSTOMER.NUMBER is the field name for @ID field in this Enquiry.

T24 Enquiries 37
 1. Launch the parent Enquiry, you can see a link ‘Open Account’ . When you click on
the hyper link the enquiry invokes the version in turn.

2. As soon as the version is invoked , it creates a new account for the customer. The
CUSTOMER.NO and SHORT.NAME for the customer is passed to the version
from the parent enquiry.

T24 Enquiries 38
 The given workshop tests your understanding on drilldown enquiries. The requirement
is stated below:

1. Create an Enquiry based on the ACCOUNT application and display the following
fields – CUSTOMER,MNEMONIC,CATEGORY & CURRENCY

2. Create an Enquiry based on the FUNDS.TRANSFER application which displays

the following fields – TRANSACTION.TYPE, DEBIT.ACCT.NO,
DEBIT.CURRENCY, DEBIT.AMOUNT, CREDIT.ACCT.NO, and
CREDIT.AURRENCY

3. The user should be able to view the FT details of a particular account from the
account enquiry

T24 Enquiries 39
 1. False
2. True
3. False
4. True
5. False

T24 Enquiries 40
 1. Enquiry allows users to retrieve data based on their needs.

2. Enquiries are created using ENQUIRY Application in T24.

3. ENQ is an abbreviation created for ENQUIRY.SELECT.

4. Ensure that you specify COLUMN values for all the fields in your enquiry.

T24 Enquiries 41
 You can now explain about Enquiries in T24. You can also create simple enquiries that
will fetch data from T24.

You will now be able to,

1. Explain what is an Enquiry in T24

2. Create Simple Enquiries in T24
3. Execute Enquiries in T24
4. Create Enquiries with Fixed Selection Criteria
5. Create Enquiries with Runtime Selection Criteria
6. Sort the output of an Enquiry and analyse the output
7. Add enquiries to Favourites
8. Create Drill down enquiries

T24 Enquiries 42
T24 Enquiries 43