3 Setting Up Localizations for Germany

This chapter contains the following topics:

3.1 Setting Up UDCs for Germany

Setting up German-specific UDCs enables you to use German-specific functionality. You also set up some base software UDCs with German-specific values.

3.1.1 Setting Up UDCs for Bank Accounts for Germany

Before you set up bank accounts in Germany, set up these UDCs.

3.1.1.1 Special Handling Code - A/P Payment (00/HC)

You must set up a value of W (services or capital movements) in this UDC to process foreign payments for Germany.

3.1.1.2 LZB Country Code (74/LA)

You must set up UDC 74/LA with valid Bundesbank Landerschlussel Codes (German Federal Bank Country Codes) and descriptions. The Description 02 field should be set up with abbreviated country descriptions, and the Special Handling Code field should contain the three-digit bank code. The Bundesbank provides you with these country codes. For example, you might set up these values:

Codes Description 01 Description 02 Special Handling
AD Andorra Andorr 043
AE United Arab Emirates (UAE) A Emir 647
AF Afghanistan Afghan 660
AG Antigua and Barbuda Antigu 459
AI Anguilla Anguil 446

The system uses the value in the Description 02 field and the Special Handling Code field in multiple fields in the Z1 output file. You must obtain valid bank values from the Bundesbank (German Federal Bank).

3.1.1.3 Cost Settlement Code (74/28)

Set up cost settlement codes to indicate the party who is responsible for the transaction fee. For example, you might set up these values:

  • 00: Trans/3rd party fees to principal.

  • 01: All fees debited to principal.

  • 02: All fees debited to recipient.

3.1.1.4 Label for Payment (74/29)

Set up labels for payment types to indicate the payment method used by the bank. For example, you might set up these values:

  • 00: Standard transmission (for example, letter, normal SWIFT message)

  • 10: Telex payment or urgent SWIFT message

  • 20: Check drawing, any form of dispatch

  • 21: Check drawing, sent by registered mail

  • 22: Check drawing, sent by special delivery

  • 23: Check drawing, sent by registered mail or special delivery

  • 30: Check drawn on principal, any form of dispatch

  • 31: Check drawn on principal, sent by registered mail

  • 32: Check drawn on principal, sent by special delivery

  • 33: Check drawn on principal, sent by registered mail or special delivery

  • 34–49: Reserved for intercompany purposes

  • 50–99: In-house

3.1.2 Setting Up the Replaced Character (04/RC) UDC

The Replaced Character (04/RC) UDC table lets you specify acceptable characters that the system uses to replace unacceptable characters in a text file.

When you set the Character Replacement processing option in the German Bank File Format and Statement Diskette program (R03B575DD) or the Create A/P Bank Diskette - Germany program (R04572G5) to use UDC 04/RC, the system scans the text file for the characters that are specified in the Description 01 field in the 04/RC UDC table. It then replaces those characters with the alternate characters that you specify in the Description 02 field. Thus, the system deletes the unacceptable characters from the text file and replaces them with acceptable characters. For example, if your bank does not recognize letters with umlauts, you can replace them with the two-letter equivalent, such as ae for ä, oe for ö, and so on.

Note:

The system replaces a single character with multiple characters only for the German programs German Bank File Format and Statement Diskette, and Create A/P Bank Diskette - Germany. When you use the Replaced Character UDC for other programs, the system replaces the character that is identified in the Description 01 field with only the first character in the Description 02 field.

You can specify that the system replace a single character with one alternate character or with multiple alternate characters. When you specify multiple alternate characters, the length of the string that is being altered does not change; if the original string is three characters, the modified string is three characters. The system drops certain characters from the string if inserting all of the alternate characters will result in the modified string exceeding the allowed length of the string.

These examples illustrate how the system replaces a single character with multiple characters:

3.1.2.1 Example 1: Replacing A with FG

Original string is ABC.

Modified string is FGB.

To retain field length of three, the system drops the C from the string.

3.1.2.2 Example 2: Replacing A with FG

Original string is ABC_ _ _ (where _ is blank).

Modified string is FGBC_ _.

To retain the field length of six, the system drops the last blank from the string.

3.1.2.3 Example 3: Replacing B with FGHI

String is ABC.

Result is AFG.

To retain the field length of three, the system replaces only the first two letters.

3.2 Setting Up Bank Information in Germany

This section provides overviews of German bank information setup and German UDC bank setup and discusses how to set up additional German bank information.

3.2.1 Understanding German Bank Information Setup

Foreign payment formats require more detailed information than is provided in the Bank Transit Master table (F0030).

You should set up this detailed information for your suppliers, both foreign and domestic. This information is stored in the Germany-Bank Transit Number Master - Addtl Information table (F74030G).

You can designate multiple bank accounts for a single supplier when the supplier is associated with a unique payment handling code.

Note:

At this point, if either a Swift Code or a Routing Transit Code is not provided, a warning message is issued on an inquiry, add, or change. Users must ensure that the Swift Code or Routing Transit Code is provided before the payment process is completed. If the information is not provided, then the file is filled with zeros.

3.2.2 Prerequisite

Verify that UDCs for bank accounts are set up.

See Setting Up UDCs for Bank Accounts for Germany.

3.2.3 Form Used to Set Up German Bank Information

Form Name FormID Navigation Usage
German Bank Account / Additional Information W74030GB German Localization (G74D), German Bank Account

On the Work With German Bank Account Cross Reference form, click Add.

Set up additional bank account information for Germany.

3.2.4 Setting Up Additional German Bank Account Information

Access the German Bank Account / Additional Information form.

Many of the fields on this form are the same as those on the Revise Bank Information form.

See "Setting Up GL Bank Account Information" in the JD Edwards EnterpriseOne Applications Financial Management Fundamentals Implemenation Guide.

These fields are specific to Germany:

SWIFT Code

The JD Edwards EnterpriseOne system does not provide the ability to enter a supplier's bank address and name in the German foreign payment file.

Instruction code 1, Instruction code 2, Instruction code 3, Instruction code 4

Enter a code from UDC table 74/27 that identifies the payment instructions for a German foreign payment.

Note:

You must set Instruction Code 3 or Instruction Code 4 to zero.
Cost Settlement Code

Enter a code from UDC table (74/28) that identifies the type of cost settlement the system uses for a German foreign payment. Values are:

00: Transfer or third-party fees debited to principal.

01: All fees debited to principal.

02: All fees debited to recipient.

Label for Payment

Enter a code from UDC table 74/29 that identifies the label for payment for a German foreign payment. Values are:

10: Telex payment.

20: Check drawing.

21: Check drawing, sent by registered mail.

22: Check drawing, sent by special delivery.

23C: Check drawing, sent by registered mail or special delivery.

30: Check drawn on principal, any form of dispatch.

31: Check drawn on principal, sent by registered mail.

32: Check drawn on principal, sent by special delivery.

33: Check drawn on principal, sent by registered mail or special delivery.

34-49: Reserved for intercompany purposes.

50-99: In house.

Code Number

Enter a code from UDC table 74/30 that identifies the code number for a German foreign payment according to the services index (annex to Foreign Trade and Payments Orders).

Transaction concerned

Enter a value that identifies the type of transaction for a German foreign payment. Values are:

2: Services, transfers or other expenditures.

4: Capital movements and capital gains.

This field is required if the payment handling code for the pay item is W.

Additional Instruction Code Information

Enter additional information for the instruction codes.

Instruction to Principal's Bank

Enter additional instructions for the Principal's bank.

Reporting Code

Enter a reporting code that indicates whether the paying bank is to report the contents of the T record to the Federal Bank.

Values are:

0: The paying bank reports the contents (default)

1: The paying bank does not report the contents.

Contact Name and Telephone Number

Enter a value that provides the ability to add the name and number of the person to contact at the principal company if the paying bank has questions about the payment order.

3.3 Setting Up Payment Formats for Germany

This section provides an overview of payment formats for Germany and discusses how to set up processing options for:

  • Create A/P Bank Tape - Germany (R04572G1).

  • Create A/P Bank Diskette - Germany (R04572G2).

  • Print Automatic Payments - Check - Germany (R04572G3).

  • Create A/P Bank Diskette - Germany (R04572G5).

3.3.1 Understanding Payment Formats for Germany

JD Edwards EnterpriseOne software supports these country-specific automatic payment formats for Germany:

Format Description
R04572G1 Bank tape format.
R04572G2 Diskette format.
R04572G3 Check format.
R04572G5 Z1 diskette format. This format supports IBAN; the output records contain the IBAN number and other related IBAN information if you set up IBAN information for your suppliers. The system uses IBAN information for the standard EU transfer type for foreign payments.

Note: The R04572G5 format calls the R04573G application, which creates a paper attachment to accompany the electronic submission (form Z1).


If you print German checks, you must specify the German translation program (X00500D). To specify, access the processing options for the Print Automatic Payments - Check - Germany program (R04572G3). Enter X00500D in the Translation processing option.

3.3.2 Setting Processing Options for Create A/P Bank Tape - Germany (R04572G1)

Processing options enable you to specify the default processing for programs and reports.

3.3.2.1 Transfer

City of Origin

Enter the city of origin.

3.3.2.2 Tape

Devise

Enter the devise name.

Tape Density

Enter the tape density.

Label Name

Enter the label name.

New Volume

Enter the new volume name.

New Owner ID

Enter the new owner ID.

Tape File Name

Enter the tape file name.

3.3.3 Setting Processing Options for Create A/P Bank Diskette - Germany (R04572G2)

Processing options enable you to specify the default processing for programs and reports.

3.3.3.1 Transfer

City of Origin

Enter the city of origin.

3.3.3.2 Tape

Devise

Enter the devise name.

Tape Density

Enter the tape density.

Label Name

Enter the label name.

Block Size

Enter the block size.

New Volume

Enter the new volume ID.

3.3.3.3 Tape (more)

New Owner ID

Enter the new owner ID.

File Name

Enter the file name.

3.3.3.4 Currency

Currency

Enter the currency code that is used in your system to identify the euro.

3.3.4 Setting Processing Options for Print Automatic Payments - Check - Germany (R04572G3)

Processing options enable you to specify the default processing for programs and reports.

3.3.4.1 Translation

1. Translation Program

Specify which translation program to use to translate the payment amount into words. The value that you enter must exist in the Check Translation (98/CT) UDC table. If you leave this processing option blank, the system uses the translation program associated with the payment currency.

3.3.4.2 Address

Address Format (FUTURE)

This processing option is not used.

3.3.4.3 Print

Form Type (FUTURE)

This processing option is not used.

3.3.5 Setting Processing Options for Create A/P Bank Diskette - Germany (R04572G5)

Processing options enable you to specify the default processing for programs and reports.

3.3.5.1 G5 Format

City of Origin

Enter the city of origin to be printed on the waybill (Begleitzettel).

Label Name

Enter the label name to be printed on the Begleitzettel as the volume number of the disk.

Q Record Information

Enter the Regional Bank Area Code, Company Code, and Industrial Classification Code. This information is printed in the Q record on the Z1 file to provide the respective Regional Federal Bank (LZB) with the proper regional information. You should obtain these codes from the Bundesbank (German Federal Bank).

Character Replacement

Enter 1 for the system to replace characters in the flat file as specified in the Replaced Character (04/RC) UDC table.

See Setting Up the Replaced Character (04/RC) UDC.

3.4 Setting Up Automatic Debit Formats for Germany

This section provides an overview of automatic debit formats for Germany and discusses how to set processing options for the German Bank File Format and Statement Diskette program (R03B575DD).

3.4.1 Understanding Automatic Debit Formats for Germany

You can specify the type of agreement that you have with customers regarding automatic debits. In Germany, businesses can enter into these automatic debit agreements:

  • Direct Debit Authority

    An agreement between the business (supplier) and the customer that allows the customer to dispute the automatic debit charge within six weeks.

  • Transfer Instruction

    An agreement between the business (supplier) and the bank. In this case, the customer does not have the right to protest the bank charges.

To specify the type of automatic debit agreement for the payment group, access the processing options for the German format program that you are using. Enter 1 in the processing option if you have a transfer instruction with the bank. Leave the processing option blank if you have Direct Debit Authority with customers. In both cases, the system writes the information to the correct field on the bank file for the bank to read.

The JD Edwards EnterpriseOne system provides these German automatic debit formats:

  • R03B575DD (German Bank File Format and Statement Diskette).

  • R03B575DD1 (German Bank Cover Sheet).

    Note:

    The German Bank File Format and Statement Diskette program calls the German Bank Cover Sheet program automatically.

The payment format programs generate a bank table that adheres to the German banking standards for automatic debits.

3.4.2 Setting Processing Options for German Bank File Format and Statement Diskette (R03B575DD)

Processing options enable you to specify the default processing for programs and reports.

3.4.2.1 Defaults

1. German Format

Specify whether the system creates Abbuchungen or Lastschriften records. Values are:

Blank: Create Abbuchungen records.

1: Create Lastschriften records.

2. Print Customer Statements

Specify whether the system prints customer statements for automatic debits. Values are:

Blank: Print customer statements only when the number of invoice detail lines exceeds the maximum number that is allowed by the format.

1: Print customer statements.

3. Tape Density

Specify the density of the tape.

4. Character Replacement

Specify whether the system replaces special characters according to the values that are set up in the Replaced Characters UDC (04/RC). Values are:

Blank: Character replacement is not enabled.

1: Character replacement is enabled. The system searches each alpha field for special characters in the order in which they are set up in the UDC. The system searches each alpha field separately.

3.4.2.2 Currency

1. Euro Currency Code

Specify the currency code for the euro. For example, EUR.