User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Table of Contents
Import of Accounts
Transaction IMPACT
This transaction is used to import account data into the database of the application.
The text file to be imported is selected via path and file name and will be imported by clicking the 
icon.
The log file for this transaction can be displayed by clicking the icon.
The log shows information about the updated and added records.
In the Developer Documentation further information about the Standard Import Procedures and customization requirements can be found.
Note: The subdirectory BATIN must be created in the DATA directory of the application. The converted import file has to be in that subdirectory. The structure of the import file depends on each individual environment and has to be clarified between the user and Surecomp DOS.
The file has to be available in ASCII format and has to have a .txt extension.
Import File Requirements
- Field seperator: The fields have to be seperated by tabulator
- Fieldsize: All fields must have not more than the in column “max. Size” specified length
- Fieldformat: The fields must have the in column “Datatype” specified format
- Character set: ASCII
Field Mapping
| Fieldname | Description | Datatype | max. Size | Comment |
|---|---|---|---|---|
| PRI | Priority for Defaulting | Text | 1 | |
| CUR | Currency | Text | 3 | see CURTXT |
| EXTKEY | Exteral Key | Text | 34 | |
| SERACC | Account Number Defined by Servicing Institute | Text | 34 | |
| SERPTY | Extkey of Servicing Party | Text | 8 | From that determination of SERPTYINR Content “OWN” fills with data of current ETY/ETG |
| HOLACC | Account Number of Control Account of Holder | Text | 34 | |
| HOLPTY | Extkey of Holder | Text | 8 | From that determination of HOLPTYINR Content “OWN” fills with data of current ETY/ETG |
| RMBFLG | Reimbursement Account Flag | Text | 1 | |
| DELFLG | Deleted Flag | Text | 1 | |
| DIRFLG | Available for | Text | 1 | |
| IBAN | International Bank Account Number | Text | 34 | |
| SPADAT | SEPA Mandate Authorisation Date | Date | 12 | in format dd/mm/jjjj |
| SPASRVID | SEPA Service Id | Text | 3 | |
| SPASTA | SEPA Status | Text | 4 | |
| SPAID | Sepa Mandate ID | Text | 35 | |
| SPAPRENOT | Pre-Notification advance | Numeric | 2 | |
| SPASNDPRENOT | Send Pre-Notification | Text | 4 | |
| NAM | Name | Text | 40 | if empty, filled from Type, Cur and Name of relevant party |
| EXTTYP | External Account Type | Text | 3 | |
| TYP | Account Type | Text | 3 | ACTTYP |
| INFTXT | Text | Stream | 60 | Infotext, will be stored with type 'display' |
If a file in DOKA 4 record format should be imported, the respective format has to be used.
Transaction Panels
Import
Datafields
| Datafield | Description |
|---|---|
| Encoding of Import File | Possible encodings are “CP437” MS-DOS US “CP850” MS-DOS Central Europe “UTF-8” UTF-8 |
