This chapter contains the following topics:
Section 3.2, "Setting Up Payment Formats for the Netherlands"
Section 3.3, "Setting Up the Work With Payment Groups Program (P04571) for the Netherlands"
Section 3.4, "Setting Up Automatic Debit Formats for the Netherlands"
Section 3.5, "Setting Up Bank Information in the Netherlands"
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
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
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.
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.
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.
Use these processing options to specify the default values for the bank tape.
Enter T to indicate tape. Enter X to indicate 8-inch tape. Enter P to indicate a PC file.
Enter the devise name.
Enter the tape density
Enter the file identification number.
Enter the block size.
Enter the volume serial number.
Enter the number of tapes in use.
Enter the owner ID.
Enter the file name.
Enter the label name.
Enter the sender information.
Enter the fixed description.
Enter the requested processing date.
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.
Enter the payment ID.
This processing option is not used.
Enter 1 to include the customer number from the supplier bank account in the F04572OW table.
Enter 1 to include the remark from the voucher in the F04572OW table. The invoice number is always included.
Enter 1 to include the paid amount for each voucher in the F04572OW table.
Enter 1 if the customer name and address are required.
Enter 1 to run in final mode.
Enter 1 if this is a duplicate run.
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.
Use these processing options to specify the default values for the bank tape.
Enter T to indicate tape. Enter X to indicate 8-inch tape. Enter P to indicate a PC file.
Enter the devise name.
Enter the tape density
Enter the file identification number.
Enter the block size.
Enter the volume serial number.
Enter the number of tapes in use.
Enter the owner ID.
Enter the file name.
Enter the label name.
Enter the requested processing date.
This processing option is not used.
Enter 1 to write ABNA to the Exchange Bank field. Enter 2 to write ABNT to the Exchange Bank field.
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 Bank Giro Centrale (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.
Specify which Clieop format the system uses when processing automatic debits. Values are:
Blank: Use Clieop02 format.
1: Use Clieop03 format.
Specify whether the file is a duplicate of the file that was previously supplied. Values are:
1: Original file.
2: Duplicate file.
Specify which Clieop format the system uses when processing automatic debits. Values are:
Blank: Use Clieop02 format.
1: Use Clieop03 format.
Specify the payment ID.
Specify the file serial number.
If this is the first tape that you are processing for the day, enter 01.
Specify the file fixed description.
Specify the processing date.
If you leave this processing option blank, the system will use the system date.
Specify the currency code in which the records are written.
Specify the test code. Values are:
P: Production
T: Test
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.
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.
Access the Dutch Bank Account Maintenance form.
Enter a code from UDC table 00/HC for the system to use to sequence the printing of payments.
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.
Enter the address number in the administration of the supplier.
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).
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.
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).
Enter a code that identifies the currency of a transaction.
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.
Enter the routing and transit number for a particular bank account. The combination of account number and transit number must be unique.
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.
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.
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.
Enter a code that is assigned to transit traders by the DNB (Netherlands Central Bank).
This is an optional entry in the F74030H table.
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.
Enter a description of the nature of the payment.
This is an optional entry in the F74030H table.
Enter a description of the nature of the payment.
This is an optional entry in the F74030H table.
Enter the address number of a foreign bank. This number provides a relationship between the F74030H table and the Address Book Master table (F0101).
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.
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.
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.
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.
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.
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.