Previous	Next		Contents	Index	Glossary	Library

For more information, please refer to Electronic Funds Transfer (EFT), Oracle Financials for European Region (EMEA) User’s Guide.

The following sections are added after the Prerequisites section:

Adding Country Numeric Codes and Short Names

Country codes and short names are used to generate the EFT payment file. Enter a numeric code and a short name for a new country that you enter. Enter country numeric codes for the JEDE_COUNTRY_NUMERIC_CODE lookup type and short names for the JEDE_COUNTRY_SHORT_NAME lookup type in the Lookups window.

To enter numeric codes for the JEDE_COUNTRY_NUMERIC_CODE lookup type:

1. Navigate to the Lookups window (Application Developer: Application > Validation > QuickCodes > Special).

2. Enter JEDE_COUNTRY_NUMERIC_CODE in the Type field. Oracle Applications only allows you to enter this lookup type in uppercase letters.

3. Choose Query > Run from the menu bar.

4. Enter a country, such as IRELAND, in the Code field. Oracle Applications only allows you to enter a country in uppercase letters.

5. Enter the same country in the meaning field. If you do not enter the same country that you entered in the Code field, the EFT file cannot extract the correct values for the numeric codes.

6. Enter the country’s three digit numeric code, such as 007, in the Description field.

7. Save your work.

To enter short names for the JEDE_COUNTRY_SHORT_NAME lookup type:

1. Navigate to the Lookups window (Application Developer: Application > Validation > QuickCodes > Special).

2. Enter JEDE_COUNTRY_SHORT_NAME in the Type field. Oracle Applications only allows you to enter this lookup type in uppercase letters.

3. Choose Query > Run from the menu bar.

4. Enter the same country that you entered for the JEDE_COUNTRY_NUMERIC_CODE lookup type in the Code field. Oracle Applications only allows you to enter a country in uppercase letters.

5. Enter the same country in the meaning field. If you do not enter the same country that you entered in the Code field, the EFT file cannot extract the correct values for the short names.

6. Enter the country’s short name, such as IRLAND, in uppercase letters in the Description field.

7. Save your work.

System Format EFT Information

Use the System Format flexfield window to set up additional EFT details for German payment formats.

To enter system format EFT information:

1. Navigate to the EFT System Information window (German Localizations: Localizations > System Formats).

2. In the Country Code field, query the country code DE for Germany.

3. Click in the globalization flexfield to navigate to the System Format flexfield window.

4. Enter information in the following fields:

In this field	Enter
LZB Area Number	The LZB area number
Company Number	The company number
Declaration Flag	Yes if you want to declare this payment to the government No if you do not want to declare this payment
Declaration Limit	The declaration limit

5. Save your work.

Supplier Site EFT Information

Use the Vendor Site EFT Information flexfield window to set up additional EFT details for each supplier site that will be paid using EFT.

To enter supplier site EFT information:

1. Navigate to the Suppliers window (Oracle Payables: Suppliers > Entry).

2. Query the supplier that you want.

3. Navigate to the Sites region.

4. Open a site. The Supplier Sites window appears for the site.

5. Choose View EFT Details from the Special menu. The Supplier Site EFT Information window appears.

6. Click in the globalization flexfield to navigate to the Vendor Site EFT Information flexfield window.

7. Enter information in the following fields:

In this field	Enter
Declaration Type	The declaration type: U - Imported Goods V - Transit Goods W - Services, Capital and Other
Reasons	The reasons for the payment
Bank Instruction	The bank instruction according to your supplier’s requirements
Bank Instruction Details	Details about the bank instruction
Charge Code	The charge code: 00 - Transfer Charges to Sender, Foreign Charges to Receiver 01 - All Charges to Sender 02 - All Charges to Receiver
Payment Method	The payment method
Explanation	An explanation for the payment method
Declaration Flag	Yes if you want to declare this payment to the government No if you do not want to declare this payment
Country	The country your supplier’s site is located in

8. Save your work.

Payment Schedule EFT Information

Use the Payment Schedules Information flexfield window to set up additional EFT details for German payment formats.

To enter invoice payment schedule EFT information:

1. Navigate to the Invoices window (Oracle Payables: Invoices > Entry > Invoices).

2. Enter or query an invoice.

3. Press the Scheduled Payments button. The Scheduled Payments window appears.

4. Choose View EFT Details from the Special menu. The Scheduled Payment EFT Information window appears.

5. Choose the payment format that you want from the Payment Preference pop-up menu.

6. Click in the globalization flexfield to navigate to the Payment Schedules Information flexfield window. The list of flexfield segments is different depending on the payment preference that you choose.

7. Enter information in the following fields:

Payment Preference: U

In this field	Enter
Declaration Flag	Yes if you want to declare this payment to the government No if you do not want to declare this payment
Country	The country your supplier’s site is located in

Payment Preference: V

In this field	Enter
Declaration Flag	Yes if you want to declare this payment to the government No if you do not want to declare this payment
Transit Goods	The transit goods
Goods No.	The goods number
Export Country	The export country
Purchase Cost	The purchase cost
Passing Trade	Yes if selling transit goods to foreigners No if not selling transit goods to foreigners
Goods Separated	Yes if selling transit goods to residents No if not selling transit goods to residents
Stored Inland	Yes if the supplier stores the goods in your country No if the supplier does not store the goods in your country
Stored Abroad	Yes if the supplier stores the goods abroad No if the supplier does not store the goods abroad
Export Goods	The export goods
Export No	The export number
Money Due Date	The money due date
Import Country	The import country
Selling Cost	The selling cost
Buyers Address	The buyer’s address

Payment Preference: W

In this field	Enter
Declaration Flag	Yes if you want to declare this payment to the government No if you do not want to declare this payment
Import Country	The import country
Record Type	The record type
Reason	The reason for the payment
Explanation	An explanation for the payment

8. Save your work.