Skip to content

Latest commit

 

History

History
536 lines (514 loc) · 9.87 KB

report_ocr.md

File metadata and controls

536 lines (514 loc) · 9.87 KB

OCR report

A report file is generated daily with all successful transactions from the day before. The format is based on NETS specification as found here: https://www.nets.eu/no-nb/PublishingImages/Lists/Accordion%20%20OCR%20giro/AllItems/OCR%20giro%20-%20System%20manual.pdf

The report file has lines with a fixed length of 80 characters.

The first two records are always a “Start record for Transmission” and a “Start record for Assignment”. The last two records are always a “End record for Assignment” and a “End record for Transmission”. For each transaction, 2 or 3 OCR transaction records are added, named “Amount item 1, 2, 3” in this specification.

"Start record for transmission"

# Field Value Comment
1 Format code NY Always
2 Service code 00 Always
3 Transmission type 00 Always
4 Record type 10 "Start transmission" type
5 Data transmitter 00008080 Nets' ID
6 Transmission number 1812171 7 characters date('dmy') + seq_id (seq_id = number from 1 to 9, usually 1 since we only generate one report per day)
7 Data recipient 00123456 Customer's id
8 Filler 49x '0' Filled with zeroes

"Start record for assignment"

# Field Value Comment
1 Format code NY Always
2 Service code 09 Always
3 Assignment type 00 Always
4 Record type 20 "Start assignment" type
5 Agreement id 001234567 Customer's agreement id 9 characters
6 Assignment number 0000001 Serial number accumulated per assignment in the transmission 7 characters
7 Assignment account 00012345678  Payee's (agreement's) account number.
11 characters
8 Filler 45x '0' Filled with zeroes

"Amount item 1"

# Field Value Comment
1 Format code NY Always
2 Service code 09 OCR giro service code
3 Transaction type 21 Configured pr service according to customer needs. The usual ones:
10 = Transaction from giro debited acct
19 = Purchase with KID
20 = Refund with free text (note this comes automatically on refunds, and can not be configured as default)
21 = Purchase with free text
4 Record type 30 Amount item 1 record type
5 Transaction number 0000001 Sequence number per transaction in the assignment
6 Date 181217 Date in DDMMYY format PSP processing date
7 Centre id 00 Not in use, fill with zeros
8 Day code 00 Not in use, fill with zeros
9 Partial settlement number 0 Not in use, fill with zeros
10 Serial number 00000 Not in use, fill with zeros
11 Sign 0 Not in use, fill with zeros
12 Amount 00000000000082300 Amount in LMU (i.e., øre for NOK) 17 characters
13 Customer Reference
(often KID)
 1216245017 25 characters, right-aligned and filled with blanks (spaces)
14 Filler 6x '0' Filled with zeroes

"Amount item 2"

# Field Value Comment
1 Format code NY Always
2 Service code 09 Always
3 Transaction type 21 Configured pr service according to customer needs. The usual ones:
10 = Transaction from giro debited acct
19 = Purchase with KID
20 = Refund with free text (note this comes automatically on refunds, and can not be configured as default)
21 = Purchase with free text
4 Record type 31 Amount item 2 record type
5 Transaction number 0000001 Same as for amount item 1 record
6 Form number 0000000000 Not in use, fill with zeros; 10 characters
7 Agreement-id / Archive reference 000000000 Not in use, fill with zeros; 9 characters
8 Filler 7x '0' Fill with zero; 7 chars
9 Bank date 181217 Date in DDMMYY format.
Note this will be the same as the date field in amount item 1 as Puzzel does not know the actual bank data
10 Debit account 11x '0' We do not know the payer's account. Fill with zero; 11 chars
11 Filler 22x '0' Fill with zero; 22 chars

"Amount item 3"

This record is only present if transaction type is either 20 (Refund with free text) or 21 (Purchase with free text).

# Field Value Comment
1 Format code NY Always
2 Service code 09 OCR giro always service code
3 Transaction type 21 20 = reversing with free text 21 = payment with free text
4 Record type 32 Amount item 3 record type
5 Transaction number 0000001 Same as for amount item 1 record
6 Free text message Fill with blanks; 40 chars
7 Filler 25x '0' Fill with zero; 25 chars

"End record for assignment"

# Field Value Comment
1 Format code NY Always
2 Service code 09 Always
3 Assignment type 00 Always
4 Record type 88 End assignment record type
5 Number of transactions 00000003 Total number of transactions in assignment; 8 chars
6 Number of records 00000011 Total number of records in the assignment, including start + end assignment records
7 Total amount 00000000000117300 Absolute sum of all the transactions in the assignment. Revesoins are not deducted. 17 chars
8 Date 181217 Date in DDMMYY format when the assignment was generated.
9 Earliest date 171217 Date in DDMMYY format. The earliest processing date for transactions in the assignment.
10 Latest date 191217 Date in DDMMYY format. The latest processing date for transactions in the assignment.
11 Filler 21x '0' Fill with zero; 21 chars

"End record for transmission"

# Field Value Comment
1 Format code NY Always
2 Service code 00 Always
3 Transmission type 00 Always
4 Record type 89 End transmission record type
5 Number of transactions 00000003 Total number of transactions in transmission; 8 chars
6 Number of records 00000011 Total number of records in transmission, including start + end assignment records and start + end transmission records.
7 Total amount 00000000000117300 Absolute sum of all the transactions in the transmission. Reversals are not deducted. 17 chars
8 Date 181217 Date in DDMMYY format when the assignment was generated.
9 Filler 33x '0' Fill with zero; 33 chars

Example of a file

NY000010000080801406171001234560000000000000000000000000000000000000000000000000
NY090020001234567000000101234567890000000000000000000000000000000000000000000000
NY09103000000011306170000000000000000000000331200                 12345678000000
NY091031000000100000000000000000000000000130617000000000000000000000000000000000
NY090088000000010000000400000000000331200140617130617130617000000000000000000000
NY000089000000010000000600000000000331200140617000000000000000000000000000000000