This chapter discusses how to set up:
UDCs (user-defined codes).
Payment formats.
Processing options for the Work With Payment Groups program (P04571).
Automatic debit formats.
Bank accounts.
Setting up Netherlands-specific UDCs enables you to use Netherlands-specific functionality. You also set up some base software UDCs with Netherlands-specific values.
Before you set up bank accounts, set up these UDCs.
Set up article number codes to identify the goods bought and sold by the transit trader. This code is assigned by the DNB (Netherlands Central Bank) to transit traders. Examples of article numbers include:
00: Livestock
03: Fish
11: Drinks
21: Untanned hides
33: Crude oil
Set up a code for each bank account type in UDC table 74/BK. The bank account number is validated based on the bank account type. Set up these values:
B: Domestic Dutch bank
P: Domestic Postbank
X: Foreign bank
Set up codes in UDC table 74/CC to indicate whether a check that is issued by the bank should be crossed. Crossed checks cannot be cashed over the counter. Payment can only be made directly to the account of the payee. Values are:
Y: Cross the check.
N: Do not cross the check (default).
Set up check forwarding codes in UDC table 74/CV to indicate the location to which a check should be sent. Set up these values:
1: Principle's branch
2: Principle
3: Beneficiary
Domestic Costs Code (74/DC)
The codes in UDC table 74/DC specify whether the principle or the beneficiary is responsible for paying costs. The values are hard-coded and include:
Code |
Description |
1 |
Charged to Principle's NLG/EUR. |
2 |
Charged to Principle's FC Account. |
3 |
Charged to Beneficiary Details. |
Set up codes in UDC table 74/GP to indicate the payment category. The options are prescribed by the DNB (Netherlands Central Bank). Values are:
1: Goods
2: Transit trade
3: Services and capital
4: Transfer to your own account
5: Other registered items
Payment Instruction Code (74/I1)
Set up payment instruction codes in UDC table 74/11 to include in SWIFT messages to foreign banks. Values are:
0: Advise beneficiary by phone.
02: Advise beneficiary by telex.
03: Advise beneficiary bank by phone.
04: Advise beneficiary bank by telex.
05: Advise beneficiary bank by cable/SWIFT charges for us.
06: Advise beneficiary bank by cable/SWIFT without charges for us.
07: Hold disposal.
12: If beneficiary is unknown or deceased, please return amount.
13: This payment is irrevocable.
14: Intercompany transfer.
Costs Abroad (74/KC)
Set up codes in UDC table 74/KC to indicate how costs charged by the ABN AMRO Bank for processing payment orders are settled. This code is used in the foreign payment system.
Values are:
1: Charged to principle NLG/EUR.
2: Charged to principle FC account.
3: Charged to beneficiary details.
Costs NLG/Foreign Code (74/KG)
Set up codes to indicate how costs charged by foreign correspondent banks are settled. This code is used in the foreign payment system.
Values are:
1: Charged to principle NLG/EUR.
2: Charged to principle FC account.
3: Charged to beneficiary details.
Set up codes in UDC table 74/NO to indicate the method of payment.
Values are:
Normal (funds transfer)
Check
Urgent transfer
Set up processing codes in UDC table 74/SU to indicate whether the SWIFT message should be sent with standard or priority status when transferring funds. Set up these codes:
0: SWIFT standard
2: SWIFT priority
Set up codes in UDC table 74/TT to indicate transit types. This code is used to validate the supplier's bank transit number. You must specify the format of the transit number for each transit type in the Description 02 field using these characters:
N: Numeric; blank not allowed
Y: Numeric; blank allowed
X: Nonnumeric; blank not allowed
Z: Nonnumeric; blank allowed
B: Alphanumeric; blank allowed
The system uses the format that you specify to validate the bank transit number.
For example, entering NNNN in the Description 02 field indicates that transit numbers of the associated transit type consist of four numeric characters with blanks allowed in each position.
You should enter the format for domestic accounts in the Description 02 field for the blank UDC code.
Note. When a transit number has fewer characters than the specified format, the system adds trailing blanks to the transit number.
Do not change the SW (Swift address worldwide) code. The format in the Description 02 field of the SW code is hard-coded for validation of the Swift code.
This section provides an overview of payment formats for the Netherlands, lists a prerequisite, and discusses how to set up processing options for:
Create A/P Bank Tape - CLIEOP02/CLIEOP03 - Holland (R04572H1).
Create A/P Bank Tape - Foreign ABN AMRO - Holland (R04572H2).
JD Edwards EnterpriseOne software supports these country-specific automatic payment formats for the Netherlands:
Format |
Description |
ClieOp2 |
The ClieOp2 (Client opdracht indeling 2) is the standard format developed by the banks in the Netherlands. Both the BankGiro Centrale (BGC) and the Postbank accept this format. |
ClieOp3 |
The ClieOp3 (Client opdracht indeling 3) is the euro-compliant payment format. It contains all of the functionality of ClieOp2 and is upward-compatible. |
BTL91 |
ABN AMRO bank provides the BTL91 payment format for foreign payments. This format supports IBAN; the output records contain the IBAN number and other related IBAN information if you set up IBAN information for your bank and your supplier's bank. The format is also euro-compliant. |
Use these write programs to generate payment formats for the Netherlands:
Program |
Description |
R04572H1 |
Domestic formats ClieOp2 or ClieOp3. |
R04572H2 |
Foreign format ABN AMRO. |
You create two versions of the domestic payment format program (P04572H1): one for ClieOp2 and one for ClieOp3. To create a version for ClieOp2, leave the processing option on the ClieOp3 tab blank. To create a version for ClieOp3, enter 1 in the processing option on the ClieOp3 tab.
For each supplier for which you use the ABN AMRO BTL91 standard and want to print IBAN information, verify that the IBAN field (data item IBAN) is complete on the Set Up Bank Account Address form in the Bank Accounts by Address program (P0030A).
Processing options enable you to specify the default processing for programs and reports.
Tape
Use these processing options to specify the default values for the bank tape.
1. Medium |
Enter T to indicate tape. Enter X to indicate 8-inch tape. Enter P to indicate a PC file. |
2. Devise Name |
Enter the devise name. |
3. Tape Density |
Enter the tape density |
4. File identification number |
Enter the file identification number. |
5. Block Size |
Enter the block size. |
6. Volume serial number |
Enter the volume serial number. |
7. Number of tapes in use |
Enter the number of tapes in use. |
8. Owner ID |
Enter the owner ID> |
9. File Name |
Enter the file name. |
10. Label Name |
Enter the label name. |
11. Sender Information |
Enter the sender information. |
12. Fixed Description |
Enter the fixed description. |
13. Requested Processing Date |
Enter the requested processing date. |
14. Transaction Type |
Enter the transaction type. Values are: 0000: Non-net creditor payment into giro account. 0003: Non-net salary payment into giro account. 0005: Net credit payment into a giro account. Creditor payment into a bank account. 0008: Net salary payment into a giro account. Salary payment into a bank account. |
15. Payment ID |
Enter the payment ID. |
Process |
This processing option is not used. |
Process
Customer Number |
Enter 1 to include the customer number from the supplier bank account in the F04572OW table. |
Remark |
Enter 1 to include the remark from the voucher in the F04572OW table. The invoice number is always included. |
Paid Amount |
Enter 1 to include the paid amount for each voucher in the F04572OW table. |
Require Customer Name |
Enter 1 if the customer name and address are required. |
Mode |
Enter 1 to run in final mode. |
Duplicate |
Enter 1 if this is a duplicate run. |
Clieop03
Clieop03 Version |
Enter 1 to use the Clieop03 version. If you leave this processing option blank, the system uses Clieop02. |
Processing options enable you to specify the default processing for programs and reports.
Tape
Use these processing options to specify the default values for the bank tape.
1. Medium |
Enter T to indicate tape. Enter X to indicate 8-inch tape. Enter P to indicate a PC file. |
2. Devise Name |
Enter the devise name. |
3. Tape Density |
Enter the tape density |
4. File identification number |
Enter the file identification number. |
5. Block Size |
Enter the block size. |
6. Volume serial number |
Enter the volume serial number. |
7. Number of tapes in use |
Enter the number of tapes in use. |
8. Owner ID |
Enter the owner ID> |
9. File Name |
Enter the file name. |
10. Label Name |
Enter the label name. |
11. Desired Processing Date |
Enter the requested processing date. |
Process |
This processing option is not used. |
Process
Exchange Bank Field |
Enter 1 to write ABNA to the Exchange Bank field. Enter 2 to write ABNT to the Exchange Bank field. |
Funds |
This processing option is not used. |
This section discusses how to set the processing options for the Work With Payment Groups program (P04571) when running the program for payments in the Netherlands
Special considerations exist when you use the Work With Payment Groups program (P04571) in the Netherlands.
Before using the program, you should set the processing options as indicated:
On the Print tab, for the Print Program Version processing option, enter one of the following versions.
XJDE0001 for ClieOp2
XJDE0002 for ClieOp3 and BTL91
If you are using the BTL91 format for foreign payments, enter 2 in the Payment Control Group Output processing option on the Print tab to create one file for all control groups. Alternatively, the system creates one file for each bank account and currency.
This section provides an overview of automatic debits for the Netherlands and discusses how to set processing options for Automatic Debits Dutch Format (R03B575DH).
The automatic debits formats that are most commonly used in the Netherlands are ClieOp2 (Client opdracht indeling 2) and ClieOp3 (Client opdracht indeling 3). ClieOp2 is the standard format that was developed by the banks in the Netherlands. Both the BankGiroCentrale (BGC) and the Postbank accept this format. ClieOp3 is the euro-compliant automatic debiting format. It contains the ClieOp2 format and is upward-compatible.
The JD Edwards EnterpriseOne system provides Automatic Debits Dutch Formats ClieOp2 and ClieOp3 (R03B575DH) for automatic debits.
This program generates a bank table that adheres to the banking standards for automatic debits in the Netherlands.
You specify the debit format (ClieOp2 or ClieOp3) that you want to use on the File Info tab of the processing options for the Automatic Debits Dutch Formats ClieOp2 and ClieOp3 program (R03B575DH).
You must specify a file serial number for each automatic debit file that you create. In the Enter File Serial Number processing option on the File Info tab, type 01 for the first file that you create each day. If you create more than one file in a day, you must update this value. The value must be updated for every subsequent file that is created each day (that is, 01, 02, 03).
Processing options enable you to specify the default processing for programs and reports.
File Info
1. Clieop Format |
Specify which Clieop format the system uses when processing automatic debits. Values are: Blank: Use Clieop02 format. 1: Use Clieop03 format. |
2. Duplicate Code |
Specify whether the file is a duplicate of the file that was previously supplied. Values are: 1: Original file. 2: Duplicate file. |
3. Sender Identification |
Specify which Clieop format the system uses when processing automatic debits. Values are: Blank: Use Clieop02 format. 1: Use Clieop03 format. |
4. Payment ID |
Specify the payment ID. |
5. File Serial Number |
Specify the file serial number. If this is the first tape that you are processing for the day, enter 01. |
6. File Fixed Description |
Specify the file fixed description. |
Date
7. Processing Date |
Specify the processing date. If you leave this processing option blank, the system will use the system date. |
8. Currency Code |
Specify the currency code in which the records are written. |
9. Test Code |
Specify the test code. Values are: P: Production T: Test |
10. Type of Transaction |
Specify the type of transaction. If you leave this processing option blank, the system uses 1001 as the default. |
This section provides overviews of Dutch bank account setup, lists a prerequisite, and discusses how to set up Dutch bank account information.
See Also
You should set up additional bank account information for your suppliers, both foreign and domestic, after you set up bank accounts by address. This additional bank information is stored in the Dutch Payments Bank Information table (F74030H) and creates a link between the Dutch bank account number and the Bank Transit Master table (F0030).
You can designate multiple bank accounts for a single supplier when the supplier is associated with a unique payment handling code.
The system validates the Transit Number and the Swift Code that you enter in the Dutch Payments Bank Information program (P74030H). Validation of the Transit Number is based on the value in the Transit Type field.
You set up Dutch bank information on the Dutch Account Maintenance form. Alternatively, you can set up Dutch bank information by selecting Regional Info from the Form menu on the Setup Bank Accounts By Address form if you set your user profile to the Netherlands.
Form Name |
FormID |
Navigation |
Usage |
Work With Dutch Bank Account Summary |
W74030HA |
Dutch Localizations (G74N), Dutch Bank Account |
Review a list of bank accounts. |
Dutch Bank Account Maintenance |
W74030HB |
On the Work With Dutch Bank Account Summary form, click Add. |
Set up Dutch bank account information. |
Verify that the UDCs for bank accounts are set up.
See Setting Up UDCs for Bank Accounts in the Netherlands.
Access the Dutch Bank Account Maintenance form.
Payment Handling Code |
Enter a code from UDC table 00/HC for the system to use to sequence the printing of payments. |
Bank Account Number |
Enter the account number for a local Dutch bank or for Postbank. If the bank account number belongs to a local Dutch bank (Bank Type = B), enter the nine or 10-digit number that complies to the modulus-11 test. If the bank account number belongs to the Postbank (Bank Type = P), valid account numbers cannot be longer than seven digits. If the Bank Type is neither B nor P, then the account number must be at least one digit. |
Customer Number |
Enter the address number in the administration of the supplier. |
Bank Account Type |
Enter the type of bank. Values are: B: Domestic Dutch bank (must pass the modulus-11 check). P: Giro (< 10000000). X: Foreign bank (no validation occurs). |
Checking or Savings Account |
Enter a code from UDC table H00/CK that specifies the type of bank account. This code is used during bank tape processing for automatic payments. |
Domestic Costs Code |
Enter a code that indicates how costs charged by the ABN/AMRO Bank for processing payment orders (for example, transfer charges or check clearing charges) are settled. This value is used in the foreign payment system. Values are: Blank: No cost to be charged 1: Cost to be charged to the payor's NLG/Euro account. 2: Cost to be charged to the payor's foreign currency account. 3: Cost to be charged to the payee. The bank indicates which codes are allowed. This code is a required entry in the Dutch Payments Bank Information table (F74030H). |
Currency Code |
Enter a code that identifies the currency of a transaction. |
Transit Type |
Enter a code that indicates the transit type. If you leave the Transit Type field blank, the system does not validate the supplier's bank transit number in the Transit Number - Bank field. |
Transit Number - Bank |
Enter the routing and transit number for a particular bank account. The combination of account number and transit number must be unique. |
Normal or Check |
Enter a code that indicates the method of payment. This code is used in the foreign payment system. Values are: 0: Normal/funds transfer. 1: Check (at ABN/AMRO send to beneficiary). 2: Urgent transfer This code is a required entry in the F74030H table. |
Payment Category Code |
Enter the payment category code is used with foreign transfers. Values are: Blank: Not applicable 1: Goods. 2: Transit trade. 3: Services and capital. 4: Transfer to your own account. 5: Other registered items. This is an optional entry in the F74030H table. |
Article No. |
Enter a code (74/AN) that is assigned by the DNB (Netherlands Central Bank) to transit traders for the purpose of identifying the goods bought and sold by the traders. For example, you might use these codes: 00: Livestock 01: Meat and meat products 02: Dairy products and eggs 11: Drinks This is an optional entry in the F74030H table. |
Trader No. (trader number) |
Enter a code that is assigned to transit traders by the DNB (Netherlands Central Bank). This is an optional entry in the F74030H table. |
DNB Registration No. (DNB registration number) |
Enter a number assigned by DNB (Netherlands Central Bank) to the payor for the purpose of registration of a number of foreign payment categories. This is an optional entry in the F74030H table. |
Nature of Pmt Code 1 (nature of payment code 1) |
Enter a description of the nature of the payment. This is an optional entry in the F74030H table. |
Nature of Pmt Code 2 (nature of payment code 2) |
Enter a description of the nature of the payment. This is an optional entry in the F74030H table. |
Bank Address Number |
Enter the address number of a foreign bank. This number provides a relationship between the F74030H table and the Address Book Master table (F0101). |
Correspondent Costs Code |
Enter a code that indicates how the costs charged by foreign correspondent banks are settled. This value is used in the foreign payment system. Values are: 1: Costs to be charged to the payor's NLG/Euro account. 2: Costs to be charged to the payor's foreign currency account. 3: Costs to be charged to payee NOTE: The bank will indicate which codes are allowed. This code is an optional entry in the F74030H table. You must complete this field if the payment is made by transferring funds. If the payment is made by check, leave this field blank. |
Processing Code |
Enter a code that indicates whether a SWIFT message should have standard or priority status when transferring funds. Values are: 0: SWIFT standard 2: SWIFT priority This code is an optional entry in the F74030H table. |
SWIFT Code |
Enter an international banking identification code used to identify the origin and destination of electronic (or wire) financial transfers. The Society for Worldwide Interbank Financial Telecommunications (SWIFT) provides the code to user banks. Enter the SWIFT code of the beneficiary's bank. |
Payment Instruction code 1 |
Enter a code that specifies instructions for the receiving bank, which should be included in SWIFT messages for foreign banks. This code is an optional entry in the F74030H table. |
Check Crossing Code |
Enter a code that indicates whether the check issued by the bank should be crossed. Crossing of a check means that the receiver cannot cash the check. The check can only be transferred into the account of the beneficiary. Values are: N: Do not cross the check Y: Cross the check This code is an optional entry in the F74030H table. |
Check Forwarding Code |
Enter a code that indicates the location to which a check should be sent. Values are: 1: Principal's branch 2: Principal 3: Beneficiary This code is an optional entry in the F74030H table. |