DOC

Requests export formats in Telehansa 6

By Danielle Knight,2014-04-14 16:20
5 views 0
Requests export formats in Telehansa 6

1 (3)

    TELEHANSA IMPORT/EXPORT FORMAT

1. FORMAT DESCRIPTION

    Import and export file consists of rows, sorted in columnns. Every row contain separate field of data.

    Row is written as follows:

    :No:Description:Data

    No field number

    Description fields description. If left empty must contain at least one space

    Data field value

For example:

     :1:Account:LV47HABA000130F004165

     :2: :USD

Several payments can be included in one import file, however in one file can be included only payments

    of domestic and foreign types. Mass payment beneficiary list must be prepared in separate file.

2. REPORT EXPORT FORMATS

    2.1. Statement export file (**RS) No. Description Max length Comments 0 Document type 4 Always ‘**RS’ 1 Operation type 3

    Possible operation type values

    Value Description Credit/Debit

    transaction (C/D)

    OB Opening balance C/D

    CB Closing balance C/D

    K2 Turnover C/D

    T2 Fees amount D

    PRV Internal transfer C/D

    MK Domestic currency payment C/D

    IEM Cash lodgement C

    IZM Cash withdrawal D

    INB Incoming transfer C

    IZP Outgoing transfer D

    CTX Payment card transactions C/D

    SOD Standing order D

    EXC Currency exchange C/D

    CQA Cashing of a cheque C

    KOM Comission for cash withdrawal/ Comission for a D

    transfer/ Cheques commission

    DKA Deposit or escrow account opening C/D

    DPL Deposit breach or deal settlement C/D

    AUT End of deposit C

    AIA Accrued interest payment into account C

    AZA Loan repayment D

    SEC Securities operations C/D

    TBP T-bill purchase D

    TBC T-bill comission D

    7DN Amount booking C/D

    IKS Cash delivery C/D 2 Bank reference 16 If operation type is OB/CB/K2/T2 the

    date format is YYMMDD 3 Bank code/Account 47

    4 Correspondent name 70

    5 Document number 10

    6 Payment details 140

    7 Credit/Debit operation type 1 C or D

2 (3)

    8 Amount 15

    9 Currency 3

    10 Account No. 21

    11 Beneficiary’s / Payer’s register No. 13

2.2. Currency rates

    No. Description Max length Comments 0 Document type 4 Always ‘**RR’ 1 Date 11 Date formatdepends on system

    settings

    2 Currency 3

    3 Bank buys Cash 9 Decimals separated with ’.’ (dot) 4 Bank sells Cash 9 Decimals separated with ’.’ (dot) 5 Bank buys Not-Cash 9 Decimals separated with ’.’ (dot) 6 Bank sells Not-Cash 9 Decimals separated with ’.’ (dot)

3. PAYMENT IMPORT/EXPORT FORMATS

    Captions:

    used only in domestic payments (**M3) DP

    FP used only in international payments (**M4)

    M - mandatory; this is a required field;

    O - optional; the field is not required, if the field value is empty the field is not inserted in a

    file

    Definition of import format types: Type Comments

    A ASCII field, national symbols are encoded with Windows 1257; N Numeric field ASCII encoded decimal number. Field must be left-aligned.

    Decimals must be separated with ’.’ (dot). Decimal symbols after dot must be 2

    (also in case of round numbers).

Payment file format:

    No Description M/O Type Max Comments

    length

    0 Payment type M A 4 **M3 domestic payment,

    **M4 foreign payment, 1 Document number O A 10/

    (SM)8

    2 Amount M N 15 Decimals must be separated with ’.’

    (dot)

    3 Currency M A 3

    4 Details M A 140

    5 Not used

    6 Originator account number M A 21

    7 Beneficiary’s account M A 34

    number

    8 Beneficiary’s name M A 70

9 Beneficiary’s address (FP) O A 70

    10 Beneficiary’s bank code M A 11

    (SWIFT code)

    11 Beneficiary’s bank name O A 100

    12 Value date O N 8 Defines, when the payment is

    processed in bank.

    Date format: YYYYMMDD 13 Intermediary bank name O A 140

    (FP)

3 (3)

    14 Account of Beneficiary’s O A 34

    bank with Correspondent

    bank (FP)

    15 Correspondent bank code O A 11

    (SWIFT code) (FP)

    16 Bank info O A 50

    17 Payments type (FP) M A 1 N normal,

    U urgent,

    X express

    18 Charges (FP) M A 3 OUR (originator) or BEN

    (beneficiary)

    19 Not used

    20 Country code O A 2 For residents only, 2 characters, i.e.

    LV, EE

    21 Balance code O N 3

    27 Document date O N 8 Date format: YYYYMMDD 28 Debit currency (FP) A 3 M

    29 Register number (DP) O A 15

    30 Not used

    31 Bank reference O A 16 Only for data export

4. MASS PAYMENT IMPORT/EXPORT FORMATS

    4.1. Mass payment beneficiary list import: Captions:

    M - mandatory; this is a required field;

    O - optional; the field is not required, if the field value is empty the field is not inserted in a

    file

Definition of import format types:

    Type Comments

    A ASCII field, national symbols are encoded with Windows 1257;

    N Numeric field ASCII encoded decimal number. Field must be left-aligned.

    Decimals must be separated with ’.’ (dot). Decimal symbols after dot must be 2

    (also in case of round numbers).

    Mass payment beneficiary list file format:

    Description M/O Type Max length Comments Beneficiary’s name M A 30

    Beneficiary’s reg. number O A 12

    Beneficiary’s amount M N 15 Decimals must be separated with ’.’

    (dot)

    Beneficiary’s account M A 21

    Beneficiary’s bank SWIFT M A 12

    code

File format composed of rows, where records are separated with TAB button, however rows separator is

    ENTER button on the keyboard.

Number of rows in the file is equivalent to the number of beneficiaries. Row composed of 5 records.

    Maximal number of rows 9’999.

Example:

    Jānis Bērziņš 123456-12345 250.12 LV36HABA0551001234567 HABALV22

    Līga Ozola 123456-13654 300 LV67HABA0551000123456 HABALV22

Report this document

For any questions or suggestions please email
cust-service@docsford.com