Electra

Export Format of Account Statement Files

Account statements downloaded from the bank’s account management computer are stored in the client program's directory of account statements. The account statements of each day are saved in a separate file, where the filename extension is ".STM" or ".CAM". Account statement files are stored in the system in an encoded form. In order to be able to process the data of a given day with other software you have to export the statements from the system.

Select the Account management subsystem, click on the Statements, advices option in the subsystem menu, then select the Account Statements submenu option.

To export the file, select the Export function on the toolbar.

As a result of the export, a so-called external account statement file is created. This section describes the structure of this file.

External account statement files contain four kinds of records: header records, data records, footer records, and a file end record. The transactions (the statement) belonging to each account are contained by a header record, the data records following it, and a footer record closing the data belonging to the given account:

header record to account # 1
data records to account # 1 …
footer record to account # 1
header record to account # 2
data records to account # 2 …
footer record to account # 2
etc.
file end record

External account statement files are ordinary text files, in which the length of the diverse types of records are identical: the data section consists of 933 bytes, which is supplemented in the case of each record by the CR (Carriage Return, code: 13, hexadecimal: 0D) and LF (Line Feed, code: 10, hexadecimal: 0A) characters. Constant record length is thus 935 bytes.

The exact structure of the individual records is described in the following tables.

Header record

Field	Content	Pos.	Length	Description
1	Record type	1	2	“11” (constant in all header records)
2	Statement ID	3	8
3	Account No.	11	24
4	Currency of A/C	35	3
5	Name of account	38	20
6	Branch code	58	8
7	Branch name	66	20
8	Starting date of statement	86	8	YYYYMMDD
9	Closing date of statement	94	8	YYYYMMDD
10	Opening balance / starting date	102	19	sign, 2 decimals, no decimal point
11	Closing balance on closing date	121	19	sign, 2 decimals, no decimal point
12	Client name	140	50
13	Client’s address 1	190	50
14	Client’s address 2	240	50
15	Client’s address 3	290	50
16	Client’s address 4	340	50
17	Client’s address 5	390	50
18		440	494	Reserved
	CR/LF	934	2

Data record

Field	Content	Pos.	Length	Description
1	Record type	1	2	“12” (constant in all data records)
2	Transaction type	3	6	Bank dependent!
3	Bank’s transaction ID	9	15
4	Amount of order	24	16	sign, 2 decimals, no decimal point
5	Currency of order	40	3
6	Initiator’s bank 1	43	35
7	Initiator’s bank 2	78	35
8	Initiator’s bank 3	113	35
9	Initiator’s bank 4	148	35
10	Initiator’s name 1	183	35
11	Initiator’s name 2	218	35
12	Initiator’s name 3	253	35
13	Initiator’s name 4	288	35
14	Initiator’s account No.	323	34
15	Narrative 1	357	35
16	Narrative 2	392	35
17	Narrative 3	427	35
18	Narrative 4	462	35
19	Beneficiary’s bank 1	497	35
20	Beneficiary’s bank 2	532	35
21	Beneficiary’s bank 3	567	35
22	Beneficiary’s bank 4	602	35
23	Beneficiary’s name 1	637	35
24	Beneficiary’s name 2	672	35
25	Beneficiary’s name 3	707	35
26	Beneficiary’s name 4	742	35
27	Beneficiary’s account No.	777	34
28	Certificate No.	811	6
29	Deadline	817	8	Only in case of scheduled collection
30	Account No. to be credited	825	24
31	Currency of credit	849	3
32	Final credit amount	852	16	2 decimals, no decimal point
33	Value date of credit	868	8	YYYYMMDD
34	Account No. to be debited	876	24
35	Currency of debit	900	3
36	Final debit amount	903	16	2 decimals, no decimal point
37	Value date of debit	919	8	YYYYMMDD
38	Orderer's country code	927	2
39	Beneficiary's country code	929	2
40	Statistical code	931	3
	CR/LF	934	2

Footer record

Field	Content	Pos.	Length	Description
1	Record type	1	2	“13” (constant in all footer records)
2		3	931	Reserved
	CR/LF	934	2

File end record

Field	Content	Pos.	Length	Description
1	Record type	1	2	“14” (constant)
2		3	931	Reserved
	CR/LF	934	2