Topic overview

This documentation describes the procedures for using the Import data application in relation to bank data. This procedure contains general instructions and you will also be informed about possible prerequisites and effects.

The description of the Import data application, which also includes field and button descriptions, can be found in the Import data documentation.

Definition of terms

Banks

A bank is a private or public commercial enterprise that conducts money transactions and offers money and credit-related services. Today, the term is often used generally for any financial institution. A distinction is made between public financial institutions (e.g. regional banks or savings banks), private financial institutions (e.g. private banks) and financial institutions in the legal form of a cooperative (e.g. Volksbanks) according to their legal form.

Banks can be uniquely identified by internationally standardized codes, the so-called Bank Identifier Codes (BIC). Any number of branches can be assigned to a bank, which can also be uniquely identified using BICs.

Bank Identifier Code (BIC)

The Bank Identifier Code (BIC) is an internationally standardized code for banks that can be used to uniquely identify any financial or credit institution worldwide. It is used to uniquely identify all banks participating directly or indirectly in SWIFT (international electronic payment transactions) and is used, among other things, for cross-border payments in the European Union. The BIC is also known colloquially as the SWIFT code.

The BIC or SWIFT code has a length of 8 or 11 alphanumeric digits and normally consists of a 4-digit alphabetic code for the bank, the 2-digit ISO country code of the bank, a 2-digit alphanumeric code to indicate the location and a 3-digit alphanumeric designation of the branch. The structure:

BBBBCCLLbbb

BBBB 4-digit bank code, freely selectable by the financial institution

CC 2-digit country code

LL 2-digit coding of the city

bbb 3-digit identification of the branch (optional, default: XXX, can be omitted)

SWIFT

SWIFT is the abbreviation for Society for Worldwide Interbank Financial Tele-communication. It is an international cooperative of financial institutions that maintains a telecommunications network (SWIFT network) for the exchange of messages between these banks. The SWIFT network is used for the exchange of messages with which, among other things, international, cross-border payments are processed electronically.

General information

Read below for general information on bank data. You will learn how the data objects to be imported are composed.

Procedures

Read the procedures for importing bank data below:

• Importing data
• Attributes required for the import
• Importing new bank data
• Overview: Identification and mandatory fields

Importing data

1. open the Import data application
2. display the or a filter for the business object com.cisag.app.financials.obj.Bank.

• The filter for importing the data is displayed.

3. the selected attributes of the filter are already marked. If necessary, you can still adjust the attributes.
4. press the Import data button in the standard toolbar.

• The Import data dialog box opens.

5. you can make settings for the import file in this dialog box. A detailed description of the fields can be found in the Import data documentation in the section of the same name.
6. you can carry out the import by pressing the In background or Immediately button.

Attributes required for the import

Enter at least the following attributes per business entity:

• Identification attributes (business key)
• Mandatory fields

The business entity cannot be assigned without the identification attributes. If a mandatory field is missing, post-processing is always started. The mandatory fields and identification attributes of the individual business objects are compiled in the section Overview: Identification and mandatory fields.

There are also relationships to other business objects that do not belong directly to the Bank business entity (relationships via foreign keys, indicated by italics in the filter). In order to resolve these relationships, the identification attributes of these business objects must be selected in the filter. Data referenced via foreign keys cannot be imported together. They must already exist in the system. If attributes other than their identification attributes are specified via the foreign key relationship, these are ignored.

If the primary key of a business object consists entirely or partially of foreign keys, the business object to which this foreign key refers must be resolved in the import file using its identification attributes.

For example, a bank contains the attribute country. This attribute refers to the country of the bank, which in turn is specified by an identification (string).

Importing new bank data

All identification and mandatory attributes must be specified in the import file. Read the documentation on the Import data application to find out how separate import files are linked.

Example of importing new bank data with an import file:

bankId Country name mainBank.bankId mainBank.country .

1 DE OneBank …

2 DE OneBranch 1 DE …

The bank identified with mainBank.bankId and mainBank.country must already exist. If the bank head office and the bank branches are in the same import file, then the bank head office must be located before the bank branch.

Overview: Identification and mandatory fields

This section summarizes the identification and mandatory attributes.

For a branch, the attributes mainBank.bankId and main-Bank.country must also be specified.