This chapter contains the following topics:
In addition to setting up the country-specific payment format from the base software, set up the CGI payment format. To set up and use CGI payment format:
Set up UDCs for CGI payments.
Set up and verify bank accounts for CGI payments.
See Section 2.3, "Setting Up and Verifying Bank Accounts for CGI Payments".
Generate the XML file for CGI payments.
Review and purge the XML file for CGI payments.
Before you generate CGI payment and credit files or CGI direct debits, set up these UDC tables:
Localization Country Code (00/LC)
Produce Bank FIle (04/PP)
The JD Edwards EnterpriseOne software provides hard-coded values for this UDC table. The Localization Country Code field in the User Profile Revision program (P0092) must be set to a country for which CGI payments are supported by the JD Edwards EnterpriseOne system before you can use the CGI payments process.
The Produce Bank File UDC table includes the print programs that the automatic payment process uses to process payments. You must add the value P744003 to this UDC table. P744003 is the code that the system uses for the print program for CGI payments.
The Replace Character In String (74/RS) UDC table enables you to specify acceptable characters that the system uses to replace unacceptable characters in the CGI Direct Debit XML file generated by the CGI Direct Debit Extractor report (R743008).
The Replace Character In String (70/RS) UDC table enables you to specify acceptable characters that the system uses to replace unacceptable characters in the CGI Credit Transfer XML file generated by the Payment Information Extractor program (R744003) for CGI.
The system scans the XML file for the characters that are specified in the Description 01 field in the 74/RS or 70/RS UDC table. It then replaces those characters with the alternative characters that you specify in the Description 02 field. Thus, the system deletes the unacceptable characters from the XML 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.
|
Important: The length of the text string does not change when you substitute multiple characters for one character. See the examples in the ”Understanding Unacceptable Characters" section of this document for specific information about character replacement.Blank is a valid value for the Description 02 field. If you enter a value in the Description 01 field and leave the Description 02 field blank, the system replaces the Description 01 value with a blank value in each character string that includes the Description 01 value. |
This table provides examples of values for the 74/RS UDC table:
| Codes | Description 01 | Description 01 |
|---|---|---|
| 01 | ç | c |
| 02 | ä | ae |
You must set up the BIC Country Code UDC table with the two-character country code that is used for BIC numbers. The system validates the BIC number that you enter on the CGI Account Setup form against the values that exist in the 74/SA UDC table. Examples of values are:
| Codes | Description 01 |
|---|---|
| AT | Austria |
| BE | Belgium |
| BG | Bulgaria |
JD Edwards EnterpriseOne software provides hard-coded values for this UDC table. You use these values to specify whether the mandate will have a unique collection (one-off type) or several collections (recurrent) and whether it is the first recurrent collection (First) or the last recurrent collection (Final). Values are:
| Codes | Description 01 |
|---|---|
| FNAL | Final Collection |
| FRST | First Collection |
| OOFF | One-off Collection |
| RCUR | Recurrent Collection |
You can set up values to identify different business lines or different services in this UDC table. You specify this value when you set up the creditor identification in the CGI Direct Debit program. This value is informational and is not needed to identify a mandate in a unique way. You can change it over time for business reasons. When the Creditor Business Code is not used, the value is set to ZZZ.
JD Edwards EnterpriseOne software provides hard-coded values for this UDC table. You use these values to specify the category that defines the purpose of the transaction. The system prints this value on the XML file. Examples of values are:
| Codes | Names of the Codes | Description |
|---|---|---|
| CASH | CashManagementTransfer | Transaction relates to cash transfer for general purpose. The process instructs and manages the cash flow in this case. |
| CCRD | CreditCardPayment | Transaction is for the payment of credit card. |
| CORT | TradeSettlementPayment | Transaction relates to settlement of a trade. It can be a foreign exchange deal or a securities transaction. |
JD Edwards EnterpriseOne software provides hard-coded values for this UDC table. You use these values to specify the purpose of the transaction. The system prints this value on the XML file. Examples of values are:
| Codes | Names of the Codes | Description |
|---|---|---|
| ACCT | AccountManagement | Transaction moves funds between two accounts of the same account holder at the same bank. |
| CASH | CashManagementTransfer | Transaction relates to cash transfer for general purpose. The process instructs and manages the cash flow in this case. |
| COLL | CollectionPayment | Transaction relates to collection of funds initiated via a credit transfer or direct debit. |
JD Edwards EnterpriseOne software provides hard-coded values from 1 to 5 for this UDC table that exists in the processing options. The number that you specify in the processing option retrieves the associated additional address book number of the creditor from the F0101 table. The system validates this number that you specify against the values that exist in the 74/UC UDC table.
To process CGI payments, you must set up the bank accounts for your company and suppliers. You can access company bank accounts by accessing the Bank Account Information program (P0030G). You access supplier bank accounts in the Bank Account Cross-Reference program (P0030A).
You must enter a valid IBAN in the account setup form of the Bank Account Information program or Bank Account Cross-Reference program. After you click the OK button in the form, the system validates the IBAN and displays an error message in case of incorrect entry or if the IBAN field is left blank.
You can enter or verify the BIC on the Revise Bank Information or Set Up Bank Accounts By Address form. You enter the BIC in the SWIFT Code field on the Revise Bank Information form or the Set Up Bank Accounts By Address form. You can leave the field blank.
The EPC (European Payments Council) uses ISO (International Standards Organization) standards for BIC numbers. The BIC number, also called the SWIFT (Society for Worldwide Interbank Financial Telecommunication) number, consists of four elements, in this order:
Four characters for the bank code.
Two characters for the country code.
Three characters for the branch code (optional).
When you enter the BIC number, the system validates that:
No special characters, such as /, &, or %, are entered.
The string of characters entered consists of 8 or 11 characters.
Positions 5 and 6 consist of the country code for the bank account, which must be set up in the 74/SA UDC table.
The system displays an error message if the BIC number that you enter fails the validation.
The Bank Account Information program (P0030G) works differently from the Bank Account Cross-Reference program (P0030A).
Select Bank Account Information (P0030G) from the Automatic Payment Setup (G04411). On the Work With G/L Bank Accounts form (W0030GA), select the existing bank account records for your company to review them.
Select Bank Account Cross-Reference (P0030A) from Automatic Payment Setup (G04411). On the Work With Bank Account By Address form (W0030AD), select existing bank account records for your suppliers to review them.
Click Cancel on the SEPA Account Setup form to view the Revise Bank Information (W0030GC). Review existing bank information for an account and Add the BIC in the Swift Code field, if necessary. Verify that the SEPA Account Setup form check box is unchecked to view the Revise Bank Information.
Click Add on the Work With Bank Accounts By Address form to navigate on the Set Up Bank Accounts By Address form (W0030AA). Add a new bank account record or to modify an existing bank account record. Add the BIC in the Swift Code field, if necessary.