This chapter discusses how to set up:
User-defined codes (UDCs)
Bank information
Payment formats
Automatic debit formats
Setting up German-specific UDCs enables you to use German-specific functionality. You also set up some base software UDCs with German-specific values.
Before you set up bank accounts in Germany, set up these UDCs.
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.
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).
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.
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
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:
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.
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.
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.
See Also
Setting Processing Options for German Bank File Format and Statement Diskette (R03B575DD)
This section provides overviews of German bank information setup and German UDC bank setup and discusses how to set up additional German bank information.
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.
See Also
Verify that UDCs for bank accounts are set up.
See Setting Up UDCs for Bank Accounts for Germany.
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. |
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.
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. |
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).
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 Z4). |
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.
Processing options enable you to specify the default processing for programs and reports.
Transfer
City of Origin |
Enter the city of origin. |
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. |
Processing options enable you to specify the default processing for programs and reports.
Transfer
City of Origin |
Enter the city of origin. |
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. |
Tape (more)
New Owner ID |
Enter the new owner ID. |
File Name |
Enter the file name. |
Currency
Currency |
Enter the currency code that is used in your system to identify the euro. |
Processing options enable you to specify the default processing for programs and reports.
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. |
Address
Address Format (FUTURE) |
This processing option is not used. |
Form Type (FUTURE) |
This processing option is not used. |
Processing options enable you to specify the default processing for programs and reports.
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. |
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).
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.
Processing options enable you to specify the default processing for programs and reports.
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. |
Currency
1. Euro Currency Code |
Specify the currency code for the euro. For example, EUR. |