Share via

Reference No. Field, Gen. Journal Line Table

  • Article

When creating an ESR invoice, the reference number of the vendor invoice is entered in this field.

The format expected for the reference number depends on the ESR Type, which can be assigned every bank of the vendor.

Using the ESR type, the reference number can be checked for validity.

The 27, 16 or 15-digit reference number is recorded here for ESR and ESR+ documents.

27-digit reference numbers

The 27-digit reference numbers can be entered with any number of empty spaces. This is practical, because the long number combination on the deposit slip is often distributed in groups of five. After entry, the checksum is calculated and the spaces are removed.

Preceding zeros can be left out. They will be added by the program.

Here are a few examples of how the reference number 000000000000000000054245719 can be entered:

00 00000 00000 00000 00542 45719

000000000000000000054245719

542 45719

54245719

If the start position and length of the invoice number are entered in the vendor bank table, the invoice number is read from the reference number and entered as document number.

16-digit reference number

The same rules apply as for the 27-digit numbers.

Here is an example of a coding line:

0100000909345>3139471430009018+ 012000611>

15-digit reference number

These short reference numbers do not have their own checksum. For this ESR type (5/15), the checksum is calculated over the entire coding line. Therefore it refers to the reference number, amount and ESR member number. If you work with a document reader, the checksum is automatically transferred to the checksum field. Without a document reader, you have to enter the first two numbers of the coding line in this field.

Example: <050001000012000> 241170032660178+ 10304>

Tip

For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.

Parent Tables

Table Location
Gen. Journal Line Table General Ledger
Posting No. Series Field, Gen. Journal Line Table General Ledger
Posting No. Series Field, Gen. Journal Line Table General Ledger
Posting No. Series Field, Gen. Journal Line Table General Ledger
Gen. Journal Line Table General Ledger
Posting No. Series Field, Gen. Journal Line Table General Ledger