Re Extract Basic Info

Information in this document is subject to change without notice.

No part of this document may be reproduced or transmitted in any form or by any means,
for any purpose, without the express written permission of TEMENOS HEADQUARTERS SA.

© 2016 Temenos Headquarters SA - all rights reserved.

RE.EXTRACT.BASIC.INFO

Table of Contents
Table of Contents ......................................................................................................................................... 2
Document History ......................................................................................................................................... 3
Introduction................................................................................................................................................ 4
Overview ................................................................................................................................................... 4
How to Use ................................................................................................................................................ 4
Conclusion............................................................................................................................................... 10

2 Banking Framework PACS

RE.EXTRACT.BASIC.INFO

Document History

Author Version Date

Sutheesh Kumar 1.0 4 Oct 2014

Srivathsan R 1.1 20 Jan 2016

Manju Soundararajan 1.2 24 Aug 2016

Gomathi G 1.3 30 May 2018

Julian Titus K 2.0 30 May 2018

Gomathi G 2.1 05 Jun 2018

Julian Titus K 3.0 05 Jun 2018

Gomathi G 3.1 08 Oct 2018

Julian Titus K 4.0 08 Oct 2018

Gomathi G 4.1 17 Oct.2018

Julian Titus K 5.0 17 Oct 2018

Comments:

User guide to execute RE.EXTRACT.BASIC.INFO utility

3 Banking Framework PACS

RE.EXTRACT.BASIC.INFO

Introduction
This utility can be used to extract the information required for General Ledger reconciliation and Report
related analysis.

Overview
This utility is helpful to extract the information from below T24 tables
 EB.SYSTEM.SUMMARY & EB.JOURNAL.SUMMARY
 RE.CRF.REPORT_NAME (RE.CRF Flat file)
 STMT.ENTRY
 RE.CONSOL.SPEC.ENTRY
 CATEG.ENTRY
 POS.MVMT.HIST
 CONSOLIDATE.ASST.LIAB(CAL)
 CONSOLIDATE.PRFT.LOSS(CPL)
 POSITION
 ACCOUNT
 EB.CONTRACT.BALANCES
 RE.STAT.LINE.BAL
 RE.STAT.LINE.CONT
Points to note:
1. Execution of this utility should be from the problematic company
2. The utility can be run in parallel sessions by different users and with various options when
multiple extracts are required

How to Use
Step 1
The routine RE.EXTRACT.BASIC.INFO should be FTP to a local BP directly (eg: PACS.BP) for
compilation as below

TAFC
>CREATE-FILE PACS.BP TYPE=UD
>BASIC –I../T24_BP PACS.BP RE.EXTRACT.BASIC.INFO
>CATALOG PACS.BP RE.EXTRACT.BASIC.INFO

TAFJ
The source code should be FTP to BASIC sources directory for compilation as below
>tCompile RE.EXTRACT.BASIC.INFO

4 Banking Framework PACS

RE.EXTRACT.BASIC.INFO

Step 2

A record should be created in PGM.FILE

Figure 1 – PGM.FILE

Step 3

Execute the utility from T24 application prompt

Figure 2 – Executing

5 Banking Framework PACS

RE.EXTRACT.BASIC.INFO

Step 4

Relevant option can be chosen from the Menu

Figure 3 – Menu

Step 5

Submenu for the entry files selection. If Option 5 was chosen, the below submenu will be
displayed

Corresponding date or savedlist data has to be feed in for the extraction.

Figure 4 – Sub Menu

Options

1. Extraction of entries based on BOOKING.DATE alone

2. Extraction of entries based on VALUE.DATE alone
3. Extraction of entries based on CONSOL.KEY
4. Extraction of entries based on OUR.REFERENCE

6 Banking Framework PACS

RE.EXTRACT.BASIC.INFO

5. Extraction of entries based on the entry IDs in &SAVEDLISTS&

6. Extraction of entries in value dated system
7. Extraction of entries based on PL.CATEGORY
8. Exit

For Option 3, the below submenu will be displayed

Corresponding date, account number or savedlist data has to be feed in for the extraction.

Figure 5 – Sub Menu

Options

1. Extraction of entries based on BOOKING.DATE alone

2. Extraction of entries based on VALUE.DATE alone
3. Extraction of entries based on CONSOL.KEY
4. Extraction of entries based on OUR.REFERENCE
5. Extraction of entries based on the entry IDs in &SAVEDLISTS&
6. Extraction of entries in value dated system
7. Extraction of entries based on ACCOUNT.NUMBER
8. Exit

For option 4, the below submenu will be displayed

Figure 6 – Date Input

7 Banking Framework PACS

RE.EXTRACT.BASIC.INFO

Options
1. Extraction of entries based on BOOKING.DATE alone
2. Extraction of entries based on VALUE.DATE alone
3. Extraction of entries based on CONSOL.KEY
4. Extraction of entries based on OUR.REFERENCE
5. Extraction of entries based on the entry IDs in &SAVEDLISTS&
6. Extraction of entries in value dated system
7. Extraction of AC.BALANCE.TYPE listings
8. Exit

To extract the information for the Entry ID’s already available in the saved list, the option 5 should be
selected.
-->CT &SAVEDLISTS& PROB.ENTRIES
PROB.ENTRIES
172812958459053.010001
172812958459053.010002
Figure 6 – Save list data

Figure 7 – Save list Input

To extract the information based on account number, the option 7 should be selected

8 Banking Framework PACS

RE.EXTRACT.BASIC.INFO

Figure 7 – Account number Input

Points to note
1. The Account extraction is based on the &SAVEDLISTS& file input.
2. To extract these records, the savedlists should be created with the required CONSOL.KEYS.

Submenu for the EB.CONTRACT.BALANCES selection. If Option 10 was chosen, the below
submenu will be displayed

Figure 8 – ECB Option

To extract the information based on consol key, the option 2 should be selected

Figure 9 – Consol Key Input

Points to note
1. If extraction is based on the &SAVEDLISTS& file input, then the savedlists should be created with
the required CONSOL.KEYS.

To extract the AC.BALANCE.TYPE listings, the option 7 should be selected.

9 Banking Framework PACS

RE.EXTRACT.BASIC.INFO

Step 6

Once extraction complete, the file name will be displayed. Please FTP the file from PACS.BP and send to
Temenos through the RTC ticket.

Conclusion
The utility will only extract the records from the corresponding T24 tables, no update or processing will be
done to the data

10 Banking Framework PACS