bankdata version 4.5 record description- ascii · type just consists of one record. hotline +45 33...

Bankdata version 4.5 Record description- ASCII

7 juni 2006

Total amount of pages: 31

Hotline +45 33 36 85 85 [email protected]

2

Table of contents General ............................................................................................................................................................................ 3

File design........................................................................................................................................................................ 3 Payment file................................................................................................................................................................ 3 Data file for export/receipt ......................................................................................................................................... 4

Record descriptions........................................................................................................................................................ 5 Descriptions of records with fixed length.................................................................................................................. 5 Description of records with variable length............................................................................................................... 6

Payment start (IB000000000000) ................................................................................................................................. 7

Transfer between own accounts (IB030201000002)................................................................................................... 8

Domestic Bank transfer/cheque (IB030202000005) ................................................................................................... 9 Information of Transfers (Index 1) ............................................................................................................................ 9 Recipient information and reference fields (Index 2).............................................................................................. 12 Details of payment (Index 3-4) ............................................................................................................................... 13

International payment (IB030204000003)................................................................................................................. 14 Payment information mv. (Index 1)......................................................................................................................... 14 Settlement information (Index 2)............................................................................................................................. 17

Salaries (IB030205000004) .......................................................................................................................................... 20 Employers information (index 0001)....................................................................................................................... 20 Employee information (index 0002)........................................................................................................................ 22

Inpayment form (IB030207000002) ........................................................................................................................... 23 Paymentsrecord (Index 1) ........................................................................................................................................ 23 Record of advice (Index 2 or 3) ............................................................................................................................... 26

Payment end (IB999999999999) ................................................................................................................................. 27

FI-advises ...................................................................................................................................................................... 28 Start record (ED000000000000).............................................................................................................................. 28 Record of the advises (ED010106000001).............................................................................................................. 29


3

OCM Bankdata 4.5s format General In this document SEB has described their own format for transactions, which can be exchanged between the cus-tomer and OCM

• In OCM the file is imported into OCM, and from here sent as single payments to the bank. or information is imported from SEB to OCM. From here you can export this information into your own ERP-system. Danish ASCII characters are valid.

The following payment types can be sent to SEB/imported into OCM

• Transfer between own accounts • Domestic Bank transfer/cheque • International payment/cheque • Salaries • Payment-slip

The following information can be obtainedfrom SEB/exported from OCM

Incoming payments with payment-slips

File design The files always start with a start record and ends with a final record. All the fields in a record start with an inverted comma and are separated by a comma. When exporting FI-advises from OCM, the users can choose to use a full stop as a punctuation mark.. Files imported to OCM must have record punctuation mark new line = <CR><LF>.

Payment file Payments can not be imported/exported in the same file as FI-advises. In the payment files all records has a fixed length of 896 bytes. All fields must be filled out, if no information exists it must be filled with spaces. E.g. a file with payments can look like this:

• Payment start • Transfer between own accounts • Domestic Bank transfer/cheque • International payment/cheque • Transfer between own accounts • Payment end

As you can see in the example above the different payment types does not have to be in order. If payments, consists of more than one record, these must follow each other. Or else, it is normal, that a payment type just consists of one record.


4

Data file for export/receipt FI-advises and payments can not be read in the same file. In the export files all records have a variable length. All fields with data must be filled out, the rest is represented by “”. Numeric fields are filled without any zeros in the beginning and text fields are filled without spaces in the end.

A file with FI-advises can look like this:

• FI-advises start • FI-advice • FI-advice • FI-advice • FI-advises end

A file with payments can look like this:

• Payment start • Payment • Payment • Payment • Payment end


5

Record descriptions

Description of record with a fixed length Example:

Field

Pos. Data name Format Filled out

Description

1 2 Trans-type X(14) Yes Payment type = “IB030202000004” 2 19 Index 9(4) Yes Index no. = “1” 3 26 Eksp-dato 9(8) Yes Execution day (YYYYMMDD) 4 37 Transbeløb 9(13)+ Yes Amount in øre or cent 5 54 Mønt X(3) Yes Currency 6 60 Fra-type 9(1) Yes Specifies the content of “Fra-konto”

“2” = Bank account

Field Specifies the fields’ position in the record layout.

Pos. Specifies the first position after the inverted comma, that is, the first position with an influential character

Data name Name of the field.

Format X(14) text field of 14 characters. The content in the field is placed to the left fol-lowed by spaces.

9(4) Numeric filed of 4 figures. The content is placed to the right with zeros in

front 9(13)+ Numeric field of 13 figures and a sign. The sign has a fixed place to the

right in the field (position 14). The value of the figures is placed to the right with zeros in front.

Numeric fields are written without a comma. That is e.g. 12,50 kr. Is writ-ten as “0000000001250+”.

Filled out Yes Mandatory. The field must have a content. It could also be a remark to the content after the description

No Optional. The field may be used. See below There is a remark to the content after the description.

e.g. special validations or dependencies to other fields Space can contain data.

Description Description of the content of the field. E.g. the format of a date (see field 3) or valid data in a type field (see field 6).

Example A record, shown, above will look like this: “IB030202000004”,”0001”,”20020105”,”0000000012345+”,”DKK”,”2” Notice: When a payment is read-out, the payment record looks like a above except field 1 (Trans-type) is changed from IB030202000004 to EB030202000004. The re-cord will look like this: “EB030202000004”,”0001”,”20020105”,”0000000012345+”,”DKK”,”2”


6

Description of record with variable length Example: Field Data name Format Filled

out Description

1 Trans-type X(14) Yes Payment type = “ED010103000002” 2 Record-løbenr 9(5) Yes Consecutive record number 3 Bogf-dato 9(8) Yes Booking date (YYYYMMDD) 4 Post-beløb 9(15) Yes The amount is written with 2 decimals. The field

contains a ”-” in the beginning, if the amount is negative.

5 Konto-type 9(1) Yes Specifies the content of ”Konto-no”, field 6 “2” = Bank account

6 Konto-no 9(15) Yes Account number

Field Specifies the fields’ position in the record layout.

Data name Specifies the name of the field.

Format X (14) text field of 14 characters. 9(4) Numeric field of 4 figures. 9(15) Numeric field of 15 figures. The field contains a ”-” in the beginning, if

the amount is negative. The decimal punctuation mark in OCM can be a comma or a full stop. That is, e.g. 12,50 kr. is written as “12,50” or “12.50”.

Filled out Yes Mandatory. The field must have a content. It could also be a remark to the

content after the description See below There is a remark to the content after the description.

E.g. special validations or other dependencies to other fields Space can contain data.

Description Description of the content of the field. E.g. the format of a date (see field 3) or valid data in a type field (see field 5).

Example The record, described above will look like this “ED010103000002”,”1”20020105”,”123,45”,”2”,”012340001234567”


7

Payment start (IB000000000000) Field Pos. Data name Format Filled out Description

1 2 Trans-type X(14) Yes Payment type = “IB000000000000” 2 19 Dan-dato 9(8) Yes Date of formation (YYYYMMDD) 3 30 Blanke X(90) Filled with = “ “ 4 123 Blanke X(255) Filled with = “ “ 5 381 Blanke X(255) Filled with = “ “ 6 639 Blanke X(255) Filled with = “ “ 7 895 Slut X(2) Yes <CR><LF>

Field no. Description

Field 2 The date of formation of the file with subsequent payments. The date must corre-spond with the date in the “payment end” - record.


8

Transfer between own accounts (IB030201000002)

Field


Description

1 2 Trans-type X(14) Yes Payment type = “IB030201000002” 2 19 Index 9(4) Yes Index no. = “1” 3 26 Eksp-dato 9(8) Yes Execution day (YYYYMMDD) 4 37 Trans-beløb 9(13)+ Yes Amount in øre or cent 5 54 Currency X(3) Yes Currency 6 60 Fra-type 9(1) Yes Specifies the content of “Fra-konto”

“2” = Bank account 7 64 Fra-konto 9(15) Yes Account number (sender) 8 82 Til-regnr 9(4) Yes Clearing number (recipient) 9 89 Til-konto-no 9(10) Yes Account number (recipient)

10 102 Eget-bilagsnr X(35) See be-low

Senders own identification of the payment

11 140 Blanke X(20) Filled with = “ “ 12 163 Blanke X(255) Filled with = “ “ 13 421 Blanke X(255) Filled with = “ “ 14 679 Reserveret X(215) 15 895 Slut X(2) Yes <CR><LF>


Field 3 Checks done when importing/ receiving:

1. Execution day, if not a business date, it is changed by the system to next business day. 2. Dates, not valid, are changed by the system to today’s date. 3. Dates, that is before today’s date is changed by the system to today’s date.

Field 4 The amounts must be positive and larger than 0. No comma must be sent. That is, the amount is

written in øre or cent.

Field 5 The currency can be either DKK or EUR.

Field 7 The field contains a bank account. Bank account: When the file is received OCM validates if the bank account can be found in the system. If not, the payment gets status error (fejl). The format of the bank account: The bank account fills up 15 characters and is composed of: 9(1) = 0 9(4) = Clearing number 9(10) = Account number Example: An amount shall be transferred to the bank account 1111 1234567. In the file the bank account number is written “011110001234567”.

Field 8-9 When receiving the payment OCM, validates if the account exists in the system. If not, the pay-ment receives status error (fejl).

Field 10 The field is used by the sender to link the payment in their ERP-system /the payment in OCM and the booking on ”Fra-konto”. E.g. for automatic reconciliation of paid invoices.


9

Domestic Bank transfer/cheque (IB030202000005)

A domestic transfer consists of up to 4 records identified by an index number 1-4. Index 1 is mandatory. When us-ing transfer type = 2 (field 8 in index 1), index 2-4 are optional. A domestic cheque can only be sent to a receiver in Denmark.

Transfer Information (Index 1) Fiel

d Pos. Data name Format Filled

out Description

1 2 Trans-type X(14) Yes Payment type = “IB030202000005” 2 19 Index 9(4) Yes Index no. = “1” 3 26 Eksp-dato 9(8) Yes Execution day (YYYYMMDD) 4 37 Transbeløb 9(13)+ Yes Amount in øre or cent 5 54 Mønt X(3) Yes Currency 6 60 Fra-type 9(1) Yes Specifies the content of “Fra-konto”

“2” = Bank account 7 64 Fra-konto 9(15) Yes Account number (sender) 8 82 Overførselstype 9(1) Yes Specifies how the transfer shall be exe-

cuted: “1” = Send cheque “2” = transfer to a bank account

9 86 Til-regnr 9(4) Yes Clearing number (recipient) 10 93 Til-konto-no 9(10) Yes Account number (recipient) 11 106 Adviseringstype 9(1) See be-

low Possibilities of advises: “0” = Details of Payment is stated on the

recipients bank statement “1” = An advice is sent to the recipient “2” = Cheque (The bank sends a cheque to

the recipient) 12 110 Posteringstekst X(35) See be-

low Entry text, that is written on the recipients account statement

13 148 Navn X(32) Yes Name of recipient 14 183 Adresse-1 X(32) Yes Address of recipient 15 218 Adresse-2 X(32) Address of recipient 16 253 Postnr 9(4) Yes postal number of recipient 17 260 Bynavn X(32) The city of recipient 18 295 Eget-bilagsnr X(35) See be-

low Senders own identification of the payment

19 333 Adviseringstekst-1 X(35) See be-low

Details of Payment to the recipient















27 637 Adviseringstekst-9 X(35) See be- Details of Payment to the recipient


10

Field


Description

low 28 675 Blanke X(1) Filled with = “ “ 29 679 Reserveret X(215) 30 895 Slut X(2) Yes <CR><LF>






Field 5 Currency can either be in DKK or EUR. If transfer type (field 8) is 1 = Send cheque, the currency must be DKK.

Field 7 The field contains a bank account . Bank account: When the file is received OCM validates if the bank account can be found in the system. If not, the payment gets status error (fejl). The format of the bank account: The bank account fills up 15 characters and are composed of: 9(1) = 0 9(4) = Clearing number 9(10) = Account number Example: An amount shall be transferred to the bank account 1111 1234567. In the file the bank account number is written “011110001234567”.

Field 8 Transferstype=”1” Send cheque Index 1 is mandatory. Index 3 is optional. Transferstype=”2” Transfer to a bank account Index 1 is mandatory. Index 2-4 is optional.

Field 9-10 Fields must be filled out, when using transfer type 2 “Transfer to a bank account”. The numbers are written to the right with zeros in front.


11

Field 11 Type of advice = “0” Details of Payment is stated on the recipients bank statement Type of advice 0 can only be used together with transfer type 2 “Transfer to a bank account”. If the type of advice is put to 0, at least one of the fields below is mandatory:

1. Field 12 “Posteringstekst” in index 1 2. Minimum one of the fields 19-27 (Adviseringstekst) in index 1 3. Minimum one of the fields 8-10 (referencefelt) in index 2 4. Minimum one of the fields 3-24 (adviseringstekster) in index 3 5. Minimum one of the fields 3-12 (adviseringstekster) in index 4

Type of advice = “1” An advice is sent to the recipient Type of advice 1 can only be used together with transfer type 2 “Transfer to a bank account”. If the type of advice is put to 1, at least one of the fields below is mandatory:

1. Field 12 “Posteringstekst” in index 1 2. Minimum one of the fields 19-27 (Adviseringstekst) in index 1 3. Minimum at least one of the fields 8-9 (referencefelt) in index 2 4. Minimum at least one of the fields 3-24 (adviseringstekster) in index 3 5. Minimum at least one of the fields 3-12 (adviseringstekster) in index 4

Type of advice = “2” Send cheque Type of advice 2 can only be used together with transfer type 1 “Send cheque”. If the type of advice is put to 2, the following fields are mandatory:

1. Field 14 (Address of recipient) Field 15 (Address of recipient) can be filled out.

2. Field 16 (postal number of recipient) 3. Field 17 (The city of recipient) 4. At least one of the fields 19-27 (Adviseringstekst) in index 1

or field 3 (Adviseringstekst) in index 3

Field 12 The field can only be used, when field 8 (transfer type) is put to 2 “Transfer to a bank account” and field 11 (Adviseringstype) is put to 0 “Details of Payment is stated on the recipients bank statement”. Only 20 characters of narrative to receiver can be entered.

Field 14-17

The fields can only be used when field 8 (transfer type) is put to 1 “Send cheque” and field 11 (Adviseringstype) is put to 2 “Send cheque”. Se also description to field 11. A domestic cheque can only be sent to a recipient in Denmark. When received in the bank the field ” postal number of recipient” is translated to a city. Therefor the field ” postal number of recipient ” decides which city the cheque will be sent to.


Field 19-27

See description to field 11.


12

Recipient information and reference fields (Index 2) This index can only be used together with transfer type 2 “Transfer to a bank account”. If using transfer type 1 “Send cheque” index 2 must not be used.

Field


Description

1 2 Trans-type X(14) Yes Payment type = “IB030202000005” 2 19 Index 9(4) Yes Index no. = “2” 3 26 Afsender 1 X(35) See be-

low Recipient information line 1

4 64 Afsender 2 X(35) See be-low

Recipient information line 2

5 102 Afsender 3 X(35) No Recipient information line 3 6 140 Afsender 4 X(35) No Recipient information line 4 7 178 Afsender 5 X(35) No Recipient information line 5 8 216 Kreditors identifika-

tion af debitor X(35) See be-

low Recipients identification of the sender

9 254 Reference til primært dokument

X(35) See be-low

Reference to primary document

10 292 Debitors identifika-tion af betalingen

X(35) See be-low


11 330 Blanke X(48) Filled with = “ “ 12 381 Blanke X(255) Filled with = “ “ 13 639 Blanke X(255) Filled with = “ “ 14 895 Slut X(2) Yes <CR><LF>


Field 3-7 If the fields are used, the first 2 lines are mandatory. Recipient information is optional. If the fields aren’t used name and address from “Fra-konto” will be sent to the recipient.

Field 8-10 If the fields are used the information is sent to the recipient. Information in field 10 is sent to the recipients EDB central to be used if necessary when searching for errors. See also description to field 11 in index 1 (Adviseringstype).


13

Details of payment (Index 3-4) When using transfer type 2 “transfer to a bank account” up to 41 lines with Details of payment can be sent. The first 9 lines must be written in index 1, and the rest is divided into index 3 and 4. Index 3 and 4 shall only be used, if necessary. When using transfer type 1 “Send cheque” up to 10 lines with Details of Payment can be sent. The first 9 must be found in index 1, the 10th. line must be in index 3.

Field


Description

1 2 Trans-type X(14) Yes Payment type = “IB030202000005” 2 19 Index 9(4) Yes Index no. = “3” or “4”

3- 24

fra 26

Adviseringstekst X(35) See be-low

Details of payment to the recipient

25 862 Blanke X(32) Filled with = “ “ 26 895 Slut X(2) Yes <CR><LF>


Field 2 Index specifies the amount of details of payments lines in the record. In index 3 the fields 3-24 are details of payment lines 10 to 31. In index 4 the fields 3-12 are details of payment lines 32 to 41. The bank does not process con-tent in fields 13-24.

Field 3-24 See description to field 11 in index 1 (Adviseringstype).


14

International payment (IB030204000003)

An international payment consists of 2 records index 1 and index 2. Index 1 contains information about the pay-ment. Index 2 contains information about the settlement.

Payment information etc. (Index 1). Fiel


out Description

1 2 Trans-type X(14) Yes Payment type = “IB030204000003” 2 19 Index 9(4) Yes Index “1” 3 26 Eksp-dato 9(8) Yes Execution day (YYYYMMDD) 4 37 Trans-beløb 9(13)+ Yes The amount is in foreign currency and

without a comma 5 54 Fra-type 9(1) Yes Specifies the content of “Fra-konto”

“2” = Bank account 6 58 Fra-konto 9(15) Yes Account number (sender) 7 76 Valutakode X(3) Yes Currency code, to be settled 8 82 Overførselsmønt X(3) No Filled out, if the payment shall be executed

in another currency than stated in field 7 9 88 Overførselstype 9(2) See be-

low Transfer type

10 93 Betal-tekst-1 X(35) See be-low

Description of payment (1. line)







14 245 Modtager X(35) Yes Name of recipient 15 283 Adresse-1 X(35) See be-

low Address of recipient (1. line)

16 321 Adresse-2 X(35) No Address of recipient (2. line) 17 359 Land X(35) Yes Address of recipient - country 18 397 Anmeldformålskode X(4) See be-

low N/A

19 404 Indf-år 9(6) See be-low

N/A

20 413 Hjemland X(2) See be-low

N/A

21 418 Andre-trans-1 X(75) No N/A 22 496 Andre-trans-2 X(75) No N/A 23 574 Andre-trans-3 X(75) No N/A 24 652 Blanke X(24) Filled with = “ “ 25 679 Reserveret X(215) 26 895 Slut X(2) Yes <CR><LF>


15





written in øre or cent. E.g. 100,50 EUR (100 Euro and 50 cent) is written as “0000000010050+”. For EU-Payments (field 9 = 97) the amount must not exceed 12.500 EUR. (From the 01 of July 2006 the limit is enhanced to 50.000 EUR)

Field 6 The field contains a bank account.. Which type of account the field contains is decided by field 6 “Fra-type”. Bank account: When the file is received OCM validates if the bank account can be found in the system. If not, the payment gets status error (fejl). The format of the bank account: The bank account fills up 15 characters and are composed of: 9(1) = 0 9(4) = Clearing number 9(10) = Account number Example: An amount shall be transferred to the bank account 1111 1234567. In the file the bank account number is written “011110001234567”.

Field 8 Cannot be used in OCM

Field 9 Specifies the type of payment. The possibilities appear in OCM. As a minimum the following codes can be used: Code Meaning 21 International cheque 22 SEB Intra group payment 23 Extern intra group payment 25 Normal payment 26 Express payment

97 EU -payment When using transfer type 21 “international cheque” field 4 in index 2 is mandatory. Fields 5-12 in index 2 must not be used. When using the other transfer types field 4 in index 2 must not be used. Fields 5-12 in index 2 are filled out according to the description in index 2. For EU-Payments the field value 97 is mandatory.

Field 10-13

One of the fields is mandatory, except for the EU-Payments.

Field 10-17

The characters from the swift-character set are valid. Press CTRL and click here to see the swift-tegnsættet.


16

Field 15-16

For EU-Payments these fields must not be used.

Field 18 N/A

Field 19 N/A

Field 20 N/A

Field 21-23

N/A


17

Settlement information (Index 2) Fiel


out Description

1 2 Trans-type X(14) Yes Payment type = “IB030204000003” 2 19 Index 9(4) Yes Index = “2” 3 26 Omk-DK 9(1) Yes Domestic (Danish) costs will be paid by:

“0” = Sender “1” = Recipient

4 30 Tilsendes 9(1) See be-low

Treatment of a cheque: “2” = Sent to the recipient

5 34 Swift-adr X(11) Yes Swift-address of the recipient 6 48 Banknavn X(35) See be-

low Name of the recipients bank

7 86 Bank-adresse1 X(35) See be-low

Address of the recipients bank

8 124 Bank-adresse2 X(35) No Address of the recipients bank 9 162 Bank-land X(35) No Country of the recipients bank.

10 200 Bankkode X(33) Yes Specification of an unambiguous branch code. Used for further identification of the Swift-address.

11 236 Udenlandsk-konto X(34) See be-low

Account number of the recipient

12 273 IBAN X(35) See be-low

IBAN-number of the recipient

13 311 Omk-udland 9(1) Yes Foreign costs will be paid by: “0” = sender “1” = Recipient

14 315 Gebyrkonto 9(15) No N/A 15 333 Bemærk-1 X(35) No N/A 16 371 Bemærk-2 X(35) No N/A 17 409 Bemærk-3 X(35) No N/A 18 447 Eget-bilagsnr X(35) See be-

low The senders own identification of the payment

19 485 Fra-konto1 9(15) No N/A 20 503 Beløb-1 9(13) No N/A 21 519 Kurstype-1 9(1) No N/A 22 523 Terminsnr-1 9(7) No N/A 23 533 Fra-konto2 9(15) No N/A 24 551 Beløb-2 9(13) No N/A 25 567 Kurstype-2 9(1) No N/A 26 571 Terminsnr-2 9(7) No N/A 27 581 Fra-konto3 9(15) No N/A 28 599 Beløb-3 9(13) No N/A 29 615 Kurstype-3 9(1) No N/A 30 619 Terminsnr-3 9(7) No N/A 31 629 Fra-konto4 9(15) No N/A 32 647 Beløb-4 9(13) No N/A 33 663 Kurstype-4 9(1) No N/A 34 667 Terminsnr-4 9(7) No N/A 35 677 Fra-konto5 9(15) No N/A 36 695 Beløb-5 9(13) No N/A 37 711 Kurstype-5 9(1) No N/A 38 715 Terminsnr-5 9(7) No N/A 39 725 Blanke X(169) Filled with = “ “ 40 895 Slut X(2) Yes <CR><LF>


18


Field 3 For EU-Payments, the field must contain the value 0.

Field 4 The field is mandatory if, field 9 (Transfer type) in index 1 has the value 21 “International cheque”. Fields 5-13 filled must not be used.

Field 5

For all types of payments, the field 5 (Swift address) is mandatory. The Swift address must be correct.

Field 5-9 Use only field 5 (Swift address)

Field 5-11 The characters from the swift-character set are valid. Press CTRL and click here to see the swift-tegnsættet..

Field 6-10 For EU-Payments these fields are not used.

Field 10 The field must be filled out with the following formats: Branch code-code (2 characters) Branch code-content (3-11 characters) Example: Branch code to England: SC123456 Branch code to Germany: BL12345678 The field must not be used when:

• Field 5 and field 12 are used • Field 5 contains a Swift address of 11 characters

Field 11 If EU-Payment the field must not be used.

Field 11-12

Just one of the fields must be used

Field 12 The field must contain valid IBAN no. Example of IBAN no: DE89370400440532013000 The first 2 characters contain a country code. The next 2 characters are controls numbers and the rest is the original account number. If EU-Payment this field is mandatory.

Field 13 If field 3 is filled with the value 1 the field 13 must be filled with the value 1. For EU-Payments, the field must contain the value 1.

Field 14-17

Must not be used


Field 19-38

Must not be used


19


20

Salaries (IB030205000004)

Employers information (index 0001) Fiel


out Description

1 2 Trans-type X(14) Yes Payment type = “IB030205000004” 2 19 Index 9(4) Yes Index = “1” (header) 3 26 Disp-dato 9(8) Yes Execution day (YYYYMMDD) 4 37 Beløb-afstemning 9(13)+ See be-

low Total amount written in øre

5 54 Fra-type 9(1) Yes Specifies the content of “Fra-konto” “2” = Bank account

6 58 Fra-konto 9(15) Yes Account number (sender) 7 76 Antal-modtagare 9(6) See be-

low Total amount of employees (recipients) in the file transfer

8 85 Medarbejder-no 9(10) No Identification of the employee. Must not be used in index 1 (header).

9 98 Medarbejder-reg-no 9(4) No Clearing number of the employee. Must not be used in index 1 (header).

10 105 Medarbejder-konto 9(10) No Account number of the employee. Must not be used in index 1 (header).

11 118 Medarbejder-beløb 9(13)+ No Amount of salary to the employee. Must not be used in index 1 (header).

12 135 Gruppe X(2) No The group of the employee. Must not be used in index 1 (header).

13 140 Navn X(26) No Name of the employee. Must not be used in index 1 (header).

14 169 Beskriv X(7) No Account description. Must not be used in index 1 (header).

15 179 Overførselstype 9(1) Yes “0” = Salaries “1” = Transfer

16 183 Posteringstekst X(35) No Entry text, that is written on the recipients account statement



18 259 Blanke X(159) Filled with = “ “ 19 421 Blanke X(255) Filled with = “ “ 20 679 Reserveret X(215) 21 895 Slut X(2) Yes <CR><LF>


Field 2 Index 0001 specifies that it is a header record.



Execution day + 1 business day equals credit value day on beneficiary’s account

Field 4 The amounts must be positive and larger than 0. No comma must be sent. That is, the amount is written in øre or cent.


21

Field 5 In the EDI-solution the field can only be filled out with 2 (bank account).” or else the salary im-port will be rejected.

Field 6 The field contains a bank account. Which type of account the field contains is decided by field 6 “Fra-type”. Bank account: When the file is received OCM validates if the bank account can be found in the system. If not, the payment gets status error (fejl). The format of the bank account: The bank account fills up 15 characters and are composed of: 9(1) = 0 9(4) = Clearing number 9(10) = Account number Example: An amount shall be transferred to the bank account 1111 1234567. In the file the bank account number is written “011110001234567”.

Field 7 Specifies the amount of salary recipients.

Field 17 The field is used by the sender to link the payment in their ERP-system /the payment in OCM and the booking on ”Fra-konto”. E.g. for automatic reconciliation of paid salaries.


22

Employee information (index 0002) Fiel


out Description

1 2 Trans-type X(14) Yes Payment type = “IB030205000004” 2 19 Index 9(4) Yes Index = “0002” (transfer) 3 26 Disp-dato 9(8) No Not used in index 0002 4 37 Beløb-afstemning 9(13)+ No Not used in index 0002 5 54 Fra-type 9(1) No Not used in index 0002 6 58 Fra-konto 9(15) No Not used in index 0002 7 76 Antal-modtagare 9(6) No Not used in index 0002 8 85 Medarbejder-no 9(10) Yes Identification of the employee. 9 98 Medarbejder-reg-nr 9(4) Yes Clearing number of the employee.

10 105 Medarbejder-konto 9(10) Yes Account number of the employee. 11 118 Medarbejder-beløb 9(13)+ See be-

low Amount of salary to the employee.

12 135 Gruppe X(2) Yes The group of the employee. 13 140 Navn X(26) Yes Name of the employee. 14 169 Beskriv X(7) Yes Account description. 15 179 Overførselstype 9(1) No “0” = Salaries

“1” = Transfer Not used in index 0002

16 183 Posteringstekst X(35) See be-low

Entry text that is written on the recipients account statement

17 221 Eget-bilagsnr X(35) No Not used in index 0002 18 259 Blanke X(159) Filled with = “ “ 19 421 Blanke X(255) Filled with = “ “ 20 679 Reserveret X(215) 21 895 Slut X(2) Yes <CR><LF>


Field 2 Index 0002 specifies that this is a transfer record.

Field 11 The amounts must be positive and larger than 0. No comma must be sent. That is, the amount is written in øre or cent.

Field 16 The field only read by the bank in employee information (index = “0002”) and only when field 15 (Transfer type) in index 0001 is set to 1 “Transfer”. The bank reads only the first 20 charac-ters.


23

Payment-slip (IB030207000002)

A payment-slip consists of up to 3 records known by index number 1-3. Index 1 is mandatory. If more than 6 lines with details of payment is necessary index 2 and if necessary index 3 can be used.

Paymentsrecord (Index 1) Fiel


out Description

1 2 Trans-type X(14) Yes Payment type = “IB030207000002” 2 19 Index 9(4) Yes Index no. = “1” 3 26 Eksp-dato 9(8) Yes Execution day (YYYYMMDD) 4 37 Trans-beløb 9(13)+ Yes The amount is specified with 2 decimals 5 54 Fra-type 9(1) Yes Specifies the content of “Fra-konto”

“2”= Bank account 6 58 Fra-konto 9(15) Yes Sender account number 7 76 Kortartskode X(2) See be-

low Code for the payment-slip type

8 81 Betalingsid X(19) See be-low

OCR reference (senders)

9 103 Modtagers giro regnr 9(4) See be-low

Clearing number of the recipients giro ac-count

10 110 Modtagers girono 9(10) See be-low

giro account number (recipient)

11 123 Modtagers kreditorno 9(8) See be-low

Creditor number (recipient)

12 134 Modtagernavn X(32) Yes Name of the recipient 13 169 Kreditorregister navn X(32) See be-

low Name of the recipient from creditor regis-ter



15 242 Afsender-navn X(35) See be-low

Senders information line 1

16 280 Afsender -adr1 X(35) See be-low








20 432 Advisering 1 X(35) See be-low

Details of payment to the recipient 1











26 660 Blanke X(16) Filled with = “ “ 27 679 Reserveret X(215) 28 895 Slut X(2) Yes <CR><LF>


24






Field 6 The field must contain a bank account. Bank account: When the file is received OCM validates if the bank account can be found in the system. If not, the payment gets status error (fejl). The format of the bank account: The bank account fills up 15 characters and are composed of: 9(1) = 0 9(4) = Clearing number 9(10) = Account number Example: An amount shall be transferred to the bank account 1111 1234567. In the file the bank account number is written “011110001234567”.

Field 7 The card type decides how the structure/content of the OCR reference will look like and if the bank will read the detail of payment lines. E.g. some card types does not allow the OCR refer-ence to be written – on the other hand you can write the detail of payment lines. If card type 01, 73 and 75 an advice is sent to the recipient. If card type 01 and 73 name and address information from the senders account is sent automati-cally as sender information. If a card type is used, and the system does not recognise it the transaction will be rejected with error. If the card type is not recognised by the system it can be due to:

• The card type is “physical” (not type 01,04,15,71,73 and 75). The payment-slip must be presented and paid in the bank or at the post office.

• Error in writing the card type code.

Field 8 The OCR reference is filled out dependent of the card type.: Card type 01 OCR reference must not used Card type 04 OCR reference must be 13 - 16 figures (modulus 10 control). Card type 15 OCR reference must be 13 - 16 figures (modulus 10 control) Card type 71 OCR reference must be max. 15 figures (modulus 10 control) Card type 73 OCR reference must not be used Card type 75 OCR reference must be max. 16 figures (modulus 10 control) If no card type is specified (written with 2 spaces) must The first figure in the OCR reference be 2, 4 or 8, + 17 figures + modulus control figure, in total the OCR reference will be 19 figures.

Field 9 The field is reserved to giro clearing number. The field is not used right now.

Field 10-11

Only one of the field must be filled out. Modulus control is performed on the content.


25

Field 13 The field is used in OCM when processing the payments. The field contains the name from the PBS register. This field must not be used when importing the file.

Field 14 The field is used by the sender to link the payment in their ERP-system /the payment in OCM and the booking on ”Fra-konto”. E.g. for automatic reconciliation of paid invoices

Field 15-19

Sender information can be stated for card type 01 and 73 (field 7). If no information is sent the name and address from “Fra-konto” will be sent to the recipient.

Field 20-25

Details of payment can be given for card type 01, 73 and 75 (field 7).


26

Record of advice (Index 2 or 3) If card type 01 is used up to 26 lines with details of payment can be sent, if card type 73 and 75 is used up to 41 lines with details of payments can be sent. Index 1 contains 1-6 details of payment lines. If additional information is needed, 2 and if necessary index 3 is used.

Field


Description

1 2 Trans-type X(14) Yes Payment type = “IB030207000002” 2 19 Index 9(4) Yes Index = “2” or “3”

3- 24

fra 26

Adviseringstekst X(35) See be-low


25 862 Blanke X(32) Filled with = “ “ 26 895 Slut X(2) Yes <CR><LF>


Field 2 Index specifies which lines with details of payment, which are written in the record.

Index “2” = Details of payment line 7 -28 Index “3” = Details of payment line 29 - 41

If a payment-slip with 26 lines with details of payment are used, the advice is constructed like what’s shown below:

Details of payment line 1-6 in index 1 Details of payment line 7-26 in index 2, Details of payment line 27-28 are filled out with spaces index 3 must not be used

If a payment-slip with 41 lines with details of payment are used the advice is constructed like what’s shown below:

Details of payment line 1-6 in index 1 Details of payment line 7-28 in index 2 Details of payment line 29-41 in index 3


27

Payment end (IB999999999999) Fiel


out Description

1 2 Trans-type X(14) Yes Payment type = “IB999999999999” 2 19 Dan-dato 9(8) Yes Date of formation (YYYYMMDD) 3 30 Antal trans 9(6) Yes Amount of payments 4 39 Beløb-total 9(13)+ Yes Nonsense total 5 56 Blanke X(64) Filled with = “ “ 6 123 Blanke X(255) Filled with = “ “ 7 381 Blanke X(255) Filled with = “ “ 8 639 Blanke X(255) Filled with = “ “ 9 895 Slut X(2) Yes <CR><LF>


Field 2 The date of formation of the file with payments furnished above. The date must correspond with the date in the “payment start” – record otherwise the file will be rejected

Field 3 Enumeration of payments of the type “IB=03XXXXXXXXX”with Index = “1”, that is positioned between the previous “Payment start” and this record. If the enumeration is not correct the file will be rejected.

Field 4 Enumeration of the field “Trans-beløb” in Payments of the type “IB=03XXXXXXXXX”, that is positioned between the previous “Payment start” and this record. The counting shall only be done of records with index = “1”. No comma must be sent. That is, the amount is written in øre or cent. Enumeration is done independent of the currency code. That is the amounts are added directly without any exchange and without sign check. The total is given as a positive number.


28

FI-advises Start record (ED000000000000)

Field

Data name Format Filled out

Description

1 Trans-type X(14) Yes Payment type = “ED000000000000” 2 Dan-dato 9(8) Yes Date of formation (YYYYMMDD) 3 Dan-klok 9(6) Yes Timestamp of formation (HHMMSS) 4 Slut Yes <CR><LF>


Field 2 Date of formation of the file with furnished FI-advises. The date must correspond with the date in “FI-advises (End record)”.

Field 3 Timestamp of formation of the file with furnished FI-advises. The timestamp must correspond with the timestamp in “FI-advises (end record)”.


29

Record of the advises (ED010106000001) Fiel

d Data name Format Filled

out Description

1 Trans-type X(14) Yes Payment type = “ED010106000001” 2 Løbenummer 9(5) Yes Consecutive record number 3 Kreditornummer 9(8) Yes Creditor number 4 Kortart 9(2) Yes Card type code for the FI-card 5 Betalingsident 9(16) Yes OCR reference 6 Indbetalingsdato 9(8) Yes Date of the payment (YYYYMMDD) 7 Beløb 9(15) Yes Booking amount from the advise 8 Mønt X(3) The field is reserved for future use 9 Arkivdato 9(8) Yes Archive date (YYYYMMDD)

10 Arkivrefnr 9(14) Yes archive clearing no + archive reference (4+10) 11 Bogføringsdato 9(8) Yes Booking date (YYYYMMDD) 12 Gebyr 9(15) Fee 13 Gebyrårsag X(2) Cause of the fee:

AA = Not OCR-readable BB = Modulus error in OCR reference AB = Not OCR-readable and modulus error CC = Correct

14 Gebyrkonto 9(15) Fee account 15 Afsender 1 X(35) Sender information 16 Afsender 2 X(35) Sender information 17 Afsender 3 X(35) Sender information 18 Afsender 4 X(35) Sender information 19 Afsender 5 X(35) Sender information 20 Posteringsmønt X(3) The field is reserved for future use 21 Meddelelsesline 1 X(35) Details of Payment

22- 60

Meddelelsesline 2-40 X(35) Details of Payment

61 Meddelelsesline 41 X(35) Details of Payment 62 Slut X(2) Yes <CR><LF>


Field 9-10 The archive information consists of a date and a reference. The archive information is solely used as reference information to the bank in connection with errors in the payment. The archive reference is not numeric (can e.g. contain letters).

Field 13 If it is exported from OCM and the fee cause code is correct, this field will be blank.


30

End record (ED999999999999)

Field

Data name Format Filled out

Description

1 Trans-type X(14) Yes Payment type = “ED999999999999” 2 Dan-dato 9(8) Yes Date of formation (YYYYMMDD) 3 Dan-klok 9(6) Yes Timestamp of formation (HHMMSS) 4 Antal-trans 9(5) Yes Amount of FI-advises 5 Beløb-total 9(15) Yes Total amount, the sum of the field “Beløb” 6 Slut X(2) Yes <CR><LF>


Field 2 Date of formation of the file with furnished FI-advises. The date must correspond with the date in “FI-advises (Start record)”.

Field 3 Timestamp of formation of the file with furnished FI-advises. The timestamp must correspond with the timestamp in “FI-advises (Start record)”.

Field 4 Enumeration of bookings of the type “ED010106000001”, that is positioned between the previ-ous “Record of advises start” and this record.

Field 5 Enumeration of “Postbeløb” in the record of the type “ED010106000001” without signs, that is positioned between the previous “Record of advises” and this record. The amount will be posi-tive (nonsense total).


31

bankdata version 4.5 record description- ascii · type just consists of one record. hotline +45 33...

Documents