User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Maintaining Countries
Transaction DBICTY
This transaction is used to maintain countries.
Country tables contain all information on a country relevant for the application. The country code is identical with the ISO 3166 code and consists of two characters.
The following transactions can be started from here by clicking the icons in the list below for:
printing country (countries).
creating Country List
showing Version Log of the modifications to the country (countries).
The description of the country has to be stored in at least the system language. However, we would recommend storing the descriptions in all available languages because these descriptions are used when addresses are printed out. If the correspondence is compiled in French, for example, French spellings of the relevant countries are used.
The option of storing country currencies supports the defaulting behavior of accounts. It is also possible to allocate a country to a specific region via “Maintaining Regions”, such as the European Union (EU).
Countries are used with parties, for conditions and in contract data.
Domestic and International Address Formats
The sequence of the individual address information in addresses differs from country to country. For example, in Germany the zip code comes before the location, whereas in the US area it comes after the location. In order to be able to realize such different output formats, the usage of these formats can be defined via the address formats.
The modification of address fields (recipient) for outgoing letter correspondence depends on whether the receiver is located inland or abroad. Thus, the design of an address block can be defined for each country, if the receiver is located in the same country or abroad
For this purpose the comboboxes “Domestic Address Format” and “International Address Format” are used. A sample of the selected address type is displayed in the text fields below, respectively. When the correspondence is sent to a domestic address, the address format selected under “Domestic Address Format” will be used. When the correspondence is sent to an address abroad, the address format selected under “International Address Format” will be used.
Examples:
- The bank using the application is located in Germany and the customer (recipient of the letter) is located in the USA. For this purpose, the international address format is used.
- The bank using the application and the customer (recipient of the letter) are both located in Germany. In this case, the domestic address format is used.
A basic principle:
- If the recipient address of the customer is located in the same country as the address of the bank using the application, the domestic address format is used.
- If the recipient address of the customer is NOT located in the same country as the address of the bank using the application, the international address format is used.
Depending on which address type has been selected, an address will be processed on dispatch, respectively. The address format types are defined within the application (in subrule “SetFmtXXXAdrBlk”).
Example: Address Type C
<NAM1>
<NAM2>
<NAM3>
<PTCNAM>
<DPT>
<STR1>
<STR2>
<LOCTXT>
<LOCZIP>
<LOCCTY>
The first three NAM lines hold the name of the company or organization. The PTCNAM line is a placeholder for the contact person. The line DPT contains the name of the department followed by two lines containing the street name and number (STR1 and STR2).
LOCTXT, LOCZIP and LOCCTY are placeholders for location, zip code (postal code), and country of the destination.
Creating Infotexts and Stoptexts
Infotexts and Stoptexts can be created for the selected country on the “Info and Stoptext” panel. The corresponding displaycodes and stoplevels are selected via the comboboxes next to the text fields.
Transaction Panels
Country
Datafields
| Datafield | Description |
|---|---|
| Country Code | cf Appendix A, Table CTY field COD |
| Currency | cf Appendix A, Table CTY field CUR |
| Region | cf Appendix A, Table CTY field REG |
| country key | cf Appendix A, Table CTY field AWVNBR |
| IBAN Country Code Position | cf Appendix A, Table CTY field IBANCCPOS |
| IBAN Country Code Length | cf Appendix A, Table CTY field IBANCCLEN |
| IBAN Check Digits Position | cf Appendix A, Table CTY field IBANCHKDIGPOS |
| IBAN Check Digits Length | cf Appendix A, Table CTY field IBANCHKDIGLEN |
| Bank Identifier Position | cf Appendix A, Table CTY field IBANBANKIDPOS |
| Bank Identifier Length | cf Appendix A, Table CTY field IBANBANKIDLEN |
| Branch Identifier Position | cf Appendix A, Table CTY field IBANBRANCHIDPOS |
| Branch Identifier Length | cf Appendix A, Table CTY field IBANBRANCHIDLEN |
| IBAN National ID Length | cf Appendix A, Table CTY field IBANNATIDLEN |
| IBAN Account Number position | cf Appendix A, Table CTY field IBANACCNBPOS |
| Account Number Length | cf Appendix A, Table CTY field IBANACCNBLEN |
| IBAN Total Length | cf Appendix A, Table CTY field IBANTOTLEN |
| IBAN used in SEPA scheme | cf Appendix A, Table CTY field SEPA |
| Optional Commence Date | cf Appendix A, Table CTY field IBANOPTCOMDAT |
| Mandatory Commence Date | cf Appendix A, Table CTY field IBANMANCOMDAT |
| ISO13616 | cf Appendix A, Table CTY field ISOFLG |
| ANF Record Key | cf Appendix A, Table CTY field ANFRECKEY |
| Domestic Address Format | cf Appendix A, Table CTY field FMTDOMADRTYP |
| International Address Format | cf Appendix A, Table CTY field FMTINTADRTYP |
Info and Stoptext
Datafields
