User Tools
Add this page to your book 
Remove this page from your book 
Manage book (
Help Table of Contents
Import of Addresses
Transaction IMPADR
This transaction is used to import address 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.
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.
In the Developer Documentation further information about the Standard Import Procedures and customization requirements can be found.
Import File Requirements
- Set Length: Fixed 1.579 characters without carriage return at the end of each set
- Field Size: All fields have to have the size specified in the column “Field Size”.
- Field Alignment: All fields are to left-aligned; missing characters have to be filled with space characters up to the specified field size
- Allowed Field Formats: Only alpha numeric formats (e.g. unpacked field contents)
- Character Set: ASCII
Field Mapping
| Field Size | Target Field(s) | Realization | Comment |
|---|---|---|---|
| 24 | PTY\EXTKEY ADRMAA\EXTKEY | Customer / Bank ID | |
| 10 | - | ||
| 12 | ADRMAA\BIC | SWIFT BIC | |
| 35 | PTY\NAM ADRMAA\NAM ADRMAA\NAM1 | Address Line 1 | |
| 35 | ADRMAA\NAM2 | Address Line 2 | |
| 35 | ADRMAA\NAM3 | Address Line 3 | |
| 35 | ADRMAA\STR1 | Address Line 4 | |
| 35 | ADRMAA\STR2 | Address Line 5 | |
| 35 | ADRMAA\LOC2 | Address Line 6 | |
| 25 | ADRMAA\LOCTXT | City | |
| 10 | ADRMAA\LOCZIP | Zip Code | |
| 20 | ADRMAA\LEI | LEI | |
| 1 | - | ||
| 1 | PTY\PTYTYP | B = Bank C = Customer | Address Type |
| 1 | - | ||
| 1 | - | ||
| 1 | - | ||
| 1 | PTY\ADRSTA | Empty = Regular Address T = Temporary Address | |
| 1 | - | ||
| 1 | ADRMAA\BICAUT | X = A empty = empty everything else = C | A = Authenticator available leer = Not connected C = Connected S = Score |
| 3 | ADRMAA\LOCCTY | Country code according to Codetable CTYTXT | |
| 1 | ADRMAA\UIL | 0 = DE 1 = EN 2 = FR 3 = SP | Language Code |
| 35 | SWIFT Address (1st line) | ||
| 35 | SWIFT Address (2nd line) | ||
| 35 | SWIFT Address (3rd line) | ||
| 35 | SWIFT Address (4th line) | ||
| 10 | Telex Number (short) | ||
| 1 | Does not equal 'empty' - Authenticator is available | ||
| 1 | - | ||
| 1 | Y = if not empty and not equal to '0' and not equal to 'N' | Use accounts of Headquarter | |
| 8 | TradeConnect Address | ||
| 1 | - | ||
| 45 | - | ||
| 243 | - | ||
| 10 | Reference to PTY of the organization | ||
| 8 | - | ||
| 8 | PTY\ACCUSR | Reference to user ID of the account user | |
| 24 | - | ||
| 16 | - | ||
| 20 | ADRMAA\FAX1 | Fax Number | |
| 8 | - | ||
| 7 | - | ||
| 50 | PTY\INFTXT | Infotext of the address. If available, the display flag in the application is set to 'Automatically display'. | |
| 50 | PTY\INFTXT | If available, the content will be added with a carriage return to the current content in PTY\INFTXT. | |
| 50 | PTY\INFTXT | If available, the content will be added with a carriage return to the current content in PTY\INFTXT. | |
| 3 | - | ||
| 10 | - | ||
| 20 | - | ||
| 15 | - | ||
| 36 | - | ||
| 16 | - | ||
| 15 | ADRMAA\TEL1 | Phone Number | |
| 8 | ADRMAA\BLZ | Local Bank Code (BLZ - Germany) | |
| 467 | - | ||
| 80 | ADRMAA\EML | ||
| 1 | PTM\AUTFLG | Y=Yes N= No | Authentication Flag for the email address of the ADRMAA |
| 1695 |
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 |
