FORMATS OF FILES FOR IMPORT AND EXPORT OF DATA FOR INTERNETBANKING SERVICE OF PPF banka a. s

Formats of files for import and export of data for Internetbanking service of PPF

banka a. s.

FORMATS OF FILES FOR IMPORT AND EXPORT OF DATA FOR INTERNETBANKING SERVICE OF PPF banka a. s.

Content: Import of data – Batch ................................................................................................................................................................ 2

I. A.

CSV format ............................................................................................................................................................................ 2

B.

Gemini 4.1 format .................................................................................................................................................................. 2 Export of data – transaction history and unsettled transactions ............................................................................................. 3

II. A.

CSV format ............................................................................................................................................................................ 3

B.

XML format ........................................................................................................................................................................... 5

Strana 1 (celkem 15) PPF banka a. s., Praha 6, Evropská 2690/17, PSČ 160 41 Česká republika, IČ 47116129, DIČ CZ47116129 Společnost zapsaná v Obchodním rejstříku vedeném městským soudem v Praze, oddíl B, vložka 1834 Tel.: (+420) 224 175 888, fax: (+420) 224 175 980


I.

banka a. s.

Import of data – Batch

It is possible to use two formats of files for Batches (i.e. import of collective Payment orders): a) CSV format, or b) Gemini 4.1 format.

A.

CSV format

Specification of the format CSV: Text file, Format ASCII One line = one payment order The first line is the heading Separator "," ; if the array is empty, two separators follow one after another "," There are obligatory and optional arrays in the file Lines are separated by the symbol LF Structure of the file: Array

Data type

Obligatory/Optional

Description

DD.MM.YYYY 13,2N 50a

Obligatory Obligatory Optional

Credit Account Prefix Number

6n

Optional

Credit Account Number Credit Account Bank Code Number Recipient Account Name (free text) Constant Symbol Variable Symbol Specific Symbol Message for Recipient (free text)

10n

Obligatory

4n

Obligatory

20a

Optional

4n 10n 10n

Optional Optional Optional

Maturity date Amount Description of the payment Area code of the recipient’s account number Recipient’s account number Recipient’s bank code number Recipient’s name of an account Constant symbol Variable symbol Specific symbol

140a

Optional

Message for the recipient

Due Date Payment Amount Client Payment Description

Example: DueDate,PaymentAmount,ClientPaymentDescription,CreditAccountPrefixNumber,CreditAccountNumber,C reditAccountBankCodeNumber,RecipientAccountName,ConstantSymbol,VariableSymbol,SpecificSymbol,Me ssageForRecipient 11.05.2010,1.12,client desc,,19,0100,client name,308,0000780283,0000000000, message for the recipient 1

B.

Gemini 4.1 format

Specification of the format Gemini 4.1: Text file, Format ASCII Fixed length of positions of respective records One line = one payment order The lines are marked off by the symbol CR/LF Explanations: Digits: lz: decpt: opt:

numbers only zeros added from the left side are obligatory there can be a decimal point/comma in the record optional information, can remain vacant, or not to be filled in if at the end of the line



banka a. s.

Structure of the file: Position

Length

Format

1

6

digits, lz,

7

2

11

9 15 22 29 44 50 60 70

6 4 4 15 6 10 10 10

YYMMDD, opt digits, lz digits, lz Digits YYMMDD, opt digits, lz digits, lz digits, lz

80

6

digits, lz, opt

86 96 102 112 252 272 292 302 312 452

10 6 10 140 20 20 10 10 140 140

digits, lz, opt digits, lz digits, lz Opt Opt Opt digits, lz, opt digits, lz, opt Opt Opt

Description Serial number of the line Value „11“ or 01 – type of data – is ignored, completed according to the form IB Date of creating the file Area code of one’s own bank Area code of the recipient’s bank Amount in 1/100 CZK Maturity date Constant symbol Credit Variable symbol Credit Specific symbol Area code of one’s own account – will be added automatically Number of one’s own account – will be added automatically Area code of the recipient’s account Recipient’s account number Credit information Name of one’s own account Recipient’s name of an account Debit Variable symbol Debit Specific symbol Debit information Bank information – not used

Example: 000001110105116000 0100 00000000000093110051000000003080000780283000000000000000099999999990000190000000019me ssage for the recipient Recipient of a payment 00000000000000000000

II.

Export of data – transaction history and unsettled transactions

Export of Payment transactions is possible in two formats: c) CSV format, or d) XML format.

A.

CSV format

Specification of the format: Text file, Format ASCII One line = one record from transaction history The first line is the heading Separator "," ; if the array is empty two separators follow one after another "," The lines are separated by the symbol CRLF



banka a. s.

Structure of the file: Order

Contain of the array

Note

1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11 12 13 14 15 16 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35. 36. 37. 38. 39. 40. 41. 42. 43. 44. 45. 46. 47.

Reserved Bank name Bank code Variable symbol Description 1 Specific symbol Bank reference Period) Description 2 Pay title Payment currency Reference gemini Description 3 Charges currency Description 4 Balance Transaction type code Account text type ID Account name Amount Account number Clearing account number Posting date Client bank ID Account currency Partner account name Partner bank Transaction text type Transaction text type ID Account type ID Country code Partner account number Value date Cancel indicator Transaction direction Partner value date Export indicator Exchange rate Pay amount Account type code Client reference Account type text Constant symbol Charges Transaction type ID Number of an item Listing number

only 1 PPF banka a. s. Code number of PPF banka a. s. Description of a transaction Internal references of the bank Not used Description of a transaction Payment title if given Currency of the payment References of an order from the electronic channel Description of a transaction Description of a transaction Balance after a respective movement

Amount of a movement Number of one’s own account Number of one’s own account in the clearing format Posting Date (Accounting Date) Not used

Not used Not used only 1- Current account

Value date DR/CR indicator Value date of counterparty Not used Exchange rate of the transaction Amount of a payment in the currency of the payment

Transaction charges Number of an item within the posting date Not used



banka a. s.

Example: Reserved,Bank name,Bank code,Variable symbol,Description 1,Specific symbol,Bank reference ,Period,Description 2,Pay title,Payment currency,Reference gemini,Description 3,Charges currency,Description 4,Balance,Transaction type code,Account text type ID ,Account name,Amount,Account number,Clearing account number,Posting date,Client bank ID,Account currency,Partner account name,Partner bank,Transaction text type,Transaction text type ID,Account type ID,Country code,Partner account number,Value date,Cancel indicator,Trnasaction direction,Partner value vate,Export indicator,Exchange rate,Pay amount,Account type code,Client reference,Account type text,Constant symbol,Charges,Transaction type ID ,Item number,Listing number 0,PPF banka a.s.,6000,0000000000,,0000000000,20100505:0000003249:BO100505GE256837,,,,,302.1.55289.3,,CZK,, "5 042,16",DOM_OP11,,Name of an account.,"87,00",9999999999,000000 9999999999/6000,20100505,,CZK,,0100,,,1,CZ,123123,20100505,0,D,,,,,001,,,0000000000,"1,90",6,1, 0,PPF banka a.s.,6000,0000000000,,0000000000,20100430:0000010284:BO100430GE254601,,,,,301.7.55200.1,,CZK,, "7 715,79",DOM_OP11,,BÚ PPF A.S.,"1,23",9999999999,000000 9999999999/6000,20100430,,CZK,,0100,,,1,CZ,19,20100430,0,D,,,,,001,,,0000000000,"1,90",6,1,

B.

XML format

Specification of a format: Used data types: bool – Y or N date – YYYYMMDD or records with NULL value are not exported Structure of the file: Name of XML Element

Format

Description

Note

Official

Bool

StatemDebitTotal

double

StatemCreditTotal

double

StatemTransactionCount StatemDebitCount StatemCreditCount StatemClosed ItemNo

int int int bool Int

Amount

double

Direction

varchar(1)

PostingDate MovementTypeID MovementTypeCode PartnerAccNo PartnerAccBank PartnerAccName ValueDate PartnerValueDate PayAmount PayCcy

date int varchar(8) varchar(35) varchar(35) varchar(35) date date double varchar(3)

always N – one’s own withdrawal Total of exported debit turnovers (amounts) Total of exported credit turnovers (amounts) Count of exported transactions Count of exported debit turnovers Count of exported credit turnovers Information on closing the statement Not used Item number as transferred from the bank Not used Amount of the movement in the currency of the account Movement direction D - debit, C - credit, N – refused payment Posting date Type of the movement Movement code Account number of the counterparty Bank of the counterparty Account name of the counterparty Value date of the transaction Foreign exchange on a partner’s account Amount in the payment currency Payment currency



Name of XML Element

Format

ExcRate

Double

ChargesAmount ChargesCcy

double varchar(3)

Balance

double

CancelIndicator GeminiRef BankRef ClientRef MovementTypeText

bool varchar(32) varchar(50) varchar(50) varchar(255)

BankID

int

BankCode BankCountryID BankName

varchar(8) varchar(2) varchar(50)

AccNoID

varchar(34)

AccNoCC

varchar(34)

AccName AccCcy AccCcyText AccTypeID AccTypeCode AccTypeText

varchar(50) char(3) varchar(255) int varchar(8) varchar(255)

Period

int

StatemNo StatemDate StatemStartBalance StatemEndBalance

int date double double

StatemOpeningDate

date

StatemClosingDate

date

Statistics1 Statistics2 Statistics3 Statistics4 Description1 Description2 Description3 Description4 Description5 Description6 Description7

varchar(10) varchar(10) varchar(10) varchar(10) varchar(35) varchar(35) varchar(35) varchar(35) varchar(35) varchar(35) varchar(35)

banka a. s.

Description Exchange rate used to a conversion of payment currency in the currency of an account Bank charges Currency of bank charges Balance of an account after a realized movement (if known) Cancellation Indicator References of Gemini References of the Bank References of the client Description of the movement type Identification of the bank in the client’s database Gemini alpha code of the bank (Gemini) Abbreviation of the bank clearing Bank name Number of one’s own account in the form of a key Number of one’s own account in the clearing format One’s own account number One’s own account currency Description of one’s own account currency Type of one’s own account Code of one’s own account Description of one’s own account type Period of time for that the statement was issued Statement number Date of issue of the statement Opening balance of the statement (ledger) Closing balance of the statement Opening date of the period that the statement covers End date of the period that the statement covers Statistical data (usually Constant symbol) Statistical data (usually Variable symbol) Statistical data (usually Specific symbol) Statistical data (usually payment title) Transaction description Transaction description Transaction description Transaction description Transaction description Transaction description Transaction description

Note

Not used

Not used Not Not Not Not

used used used used

Not used Not used



banka a. s.

Name of XML Element

Format

Description

Description8

varchar(35)

Info01

varchar(60)

Transaction description Further optional information to the movement 1 .. 20

Info02 Info03 Info04 Info05 Info06 Info07 Info08 Info09 Info10 Info11 Info12 Info13 Info14 Info15 Info16 Info17 Info18 Info19 Info20 Extensions

varchar(60) varchar(60) varchar(60) varchar(60) varchar(60) varchar(60) varchar(60) varchar(60) varchar(60) varchar(60) varchar(60) varchar(60) varchar(60) varchar(60) varchar(60) varchar(60) varchar(60) varchar(60) varchar(60) varchar(255)

IncomingDocID

int

Note

Not used Not Not Not Not Not Not Not Not Not Not Not Not Not Not Not Not Not Not Not

Extended information to the movement Number of an incoming document in the client’s database Gemini

used used used used used used used used used used used used used used used used used used used

Not used

Example: <Movement ItemNo='1' Amount='10,00' Direction='D' PostingDate='20100618' MovementTypeID='6' MovementTypeCode='DOM_OP11'> <PartnerAccNo>9999999999 <PartnerAccBank>6000 <PartnerAccName> 20100618 <PartnerValueDate> Strana 7 (celkem 15) PPF banka a. s., Praha 6, Evropská 2690/17, PSČ 160 41 Česká republika, IČ 47116129, DIČ CZ47116129 Společnost zapsaná v Obchodním rejstříku vedeném městským soudem v Praze, oddíl B, vložka 1834 Tel.: (+420) 224 175 888, fax: (+420) 224 175 980


banka a. s.

<PayAmount> <PayCcy> <ExcRate> 20 062,72 0 301.7.55851.1 20100618:0000003271:BO100618GE320438 <MovementTypeText>Odchozí domácí platba 6000 CZ PPF banka a.s. 123123123 000000 0123123123/6000 BU Klient 1 CZK Koruna česká 1 001 Běžný účet <Statistics1>0000000000 <Statistics2>0000000000 <Statistics3>0000000000 <Statistics4> ahoj priemcce. řádek čárka ahoj priemcce. řádek čárka <Extensions>DOM-AVIZO: ahoj priemcce. řádek čárka <Movement ItemNo='2' Amount='11,00' Direction='D' PostingDate='20100618' MovementTypeID='1' MovementTypeCode='DOM'> <PartnerAccNo>10328018 <PartnerAccBank>5500 <PartnerAccName> 20100618 <PartnerValueDate> <PayAmount> <PayCcy> <ExcRate> 200,00 CZK 20 051,72 Strana 8 (celkem 15) PPF banka a. s., Praha 6, Evropská 2690/17, PSČ 160 41 Česká republika, IČ 47116129, DIČ CZ47116129 Společnost zapsaná v Obchodním rejstříku vedeném městským soudem v Praze, oddíl B, vložka 1834 Tel.: (+420) 224 175 888, fax: (+420) 224 175 980


banka a. s.

0 20100618:0000003272:BO100618MN320423 <MovementTypeText>Domácí platba 6000 CZ PPF banka a.s. 123123123 000000 0123123123/6000 BU Klient 1 CZK Koruna česká 1 001 Běžný účet <Statistics1>0000000000 <Statistics2>0000000000 <Statistics3>0000000000 <Statistics4> <Extensions> <Movement ItemNo='1' Amount='20,00' Direction='D' PostingDate='20100618' MovementTypeID='6' MovementTypeCode='DOM_OP11'> <PartnerAccNo>123123123 <PartnerAccBank>6000 <PartnerAccName> 20100618 <PartnerValueDate> <PayAmount> <PayCcy> <ExcRate> 2 035,30 0 301.7.55852.1 20100618:0000003274:BO100618GE320439 <MovementTypeText>Odchozí domácí platba 6000 Strana 9 (celkem 15) PPF banka a. s., Praha 6, Evropská 2690/17, PSČ 160 41 Česká republika, IČ 47116129, DIČ CZ47116129 Společnost zapsaná v Obchodním rejstříku vedeném městským soudem v Praze, oddíl B, vložka 1834 Tel.: (+420) 224 175 888, fax: (+420) 224 175 980


banka a. s.

CZ PPF banka a.s. 9999999999 000000 9999999999/6000 BU Klient 1 CZK Koruna česká 1 001 Běžný účet <Statistics1>0000000000 <Statistics2>0000000000 <Statistics3>0000000000 <Statistics4> <Extensions> <Movement ItemNo='3' Amount='20,00' Direction='C' PostingDate='20100618' MovementTypeID='7' MovementTypeCode='DOM_IN'> <PartnerAccNo>9999999999 <PartnerAccBank>6000 <PartnerAccName>BU Klient 1 20100618 <PartnerValueDate>20100618 <PayAmount> <PayCcy> <ExcRate> 20 071,72 0 301.7.55852.1 20100618:0000003273:BO100618GE320439 <MovementTypeText>Příchozí domácí platba 6000 CZ PPF banka a.s. 123123123 000000 0123123123/6000 BU Klient 1 CZK Strana 10 (celkem 15) PPF banka a. s., Praha 6, Evropská 2690/17, PSČ 160 41 Česká republika, IČ 47116129, DIČ CZ47116129 Společnost zapsaná v Obchodním rejstříku vedeném městským soudem v Praze, oddíl B, vložka 1834 Tel.: (+420) 224 175 888, fax: (+420) 224 175 980


banka a. s.

Koruna česká 1 001 Běžný účet <Statistics1>0000000000 <Statistics2>0000000000 <Statistics3>0000000000 <Statistics4> <Extensions> <Movement ItemNo='2' Amount='10,00' Direction='C' PostingDate='20100618' MovementTypeID='7' MovementTypeCode='DOM_IN'> <PartnerAccNo>123123123 <PartnerAccBank>6000 <PartnerAccName>BU Klient 1 20100618 <PartnerValueDate>20100618 <PayAmount> <PayCcy> <ExcRate> 2 045,30 0 301.7.55851.1 20100618:0000003275:BO100618GE320438 <MovementTypeText>Příchozí domácí platba 6000 CZ PPF banka a.s. 9999999999 000000 9999999999/6000 BU Klient 1 CZK Koruna česká 1 001 Běžný účet <Statistics1>0000000000 <Statistics2>0000000000 Strana 11 (celkem 15) PPF banka a. s., Praha 6, Evropská 2690/17, PSČ 160 41 Česká republika, IČ 47116129, DIČ CZ47116129 Společnost zapsaná v Obchodním rejstříku vedeném městským soudem v Praze, oddíl B, vložka 1834 Tel.: (+420) 224 175 888, fax: (+420) 224 175 980


banka a. s.

<Statistics3>0000000000 <Statistics4> zpráva pro příjemce zpráva pro příjemce <Extensions>DOM-AVIZO: zpráva pro příjemce <Movement ItemNo='1' Amount='39,11' Direction='D' PostingDate='20100617' MovementTypeID='102' MovementTypeCode='FOR_OP'> <PartnerAccNo>ES6600301133880003484271 <PartnerAccBank>ESPCESMMXXX <PartnerAccName>TEST 20100617 <PartnerValueDate> <PayAmount>1,50 <PayCcy>EUR <ExcRate>26.0760000 150,00 CZK 20 223,82 0 20100617:0000003279:BO100617MN320356 <MovementTypeText>Odchozí zahraniční platba 6000 CZ PPF banka a.s. 123123123 000000 0123123123/6000 BU Klient 1 CZK Koruna česká 1 001 Běžný účet <Statistics1> <Statistics2> <Statistics3> <Statistics4>320 SHA Strana 12 (celkem 15) PPF banka a. s., Praha 6, Evropská 2690/17, PSČ 160 41 Česká republika, IČ 47116129, DIČ CZ47116129 Společnost zapsaná v Obchodním rejstříku vedeném městským soudem v Praze, oddíl B, vložka 1834 Tel.: (+420) 224 175 888, fax: (+420) 224 175 980


banka a. s.

<Extensions>FT-CHARGEACC: 123123123 <Movement ItemNo='2' Amount='150,00' Direction='D' PostingDate='20100617' MovementTypeID='99' MovementTypeCode='JE_BATCH'> <PartnerAccNo> <PartnerAccBank> <PartnerAccName> 20100617 <PartnerValueDate> <PayAmount> <PayCcy> <ExcRate> 20 073,82 0 20100617:0000003280:002213 <MovementTypeText>Ostatní transakce 6000 CZ PPF banka a.s. 123123123 000000 0123123123/6000 BU Klient 1 CZK Koruna česká 1 001 Běžný účet <Statistics1> <Statistics2> <Statistics3> <Statistics4> BO100617MN320356 Odchozí ( 0.-) <Extensions> Strana 13 (celkem 15) PPF banka a. s., Praha 6, Evropská 2690/17, PSČ 160 41 Česká republika, IČ 47116129, DIČ CZ47116129 Společnost zapsaná v Obchodním rejstříku vedeném městským soudem v Praze, oddíl B, vložka 1834 Tel.: (+420) 224 175 888, fax: (+420) 224 175 980


banka a. s.

<Movement ItemNo='3' Amount='1,10' Direction='D' PostingDate='20100617' MovementTypeID='200' MovementTypeCode='STANDOR'> <PartnerAccNo>111952119 <PartnerAccBank>0300 <PartnerAccName>prijemce 20100617 <PartnerValueDate> <PayAmount> <PayCcy> <ExcRate> 4,00 CZK 20 072,72 0 20100617:0000003281:PS100617SO320339 <MovementTypeText>Trvalý příkaz domácí 6000 CZ PPF banka a.s. 123123123 000000 0123123123/6000 BU Klient 1 CZK Koruna česká 1 001 Běžný účet <Statistics1>0000000000 <Statistics2>0000000000 <Statistics3>0000000000 <Statistics4> <Extensions> <StatemDebitTotal>231,21 <StatemCreditTotal>30,00 <StatemTransactionCount>8 <StatemDebitCount>6 <StatemCreditCount>2 Strana 14 (celkem 15) PPF banka a. s., Praha 6, Evropská 2690/17, PSČ 160 41 Česká republika, IČ 47116129, DIČ CZ47116129 Společnost zapsaná v Obchodním rejstříku vedeném městským soudem v Praze, oddíl B, vložka 1834 Tel.: (+420) 224 175 888, fax: (+420) 224 175 980


banka a. s.


FORMATS OF FILES FOR IMPORT AND EXPORT OF DATA FOR INTERNETBANKING SERVICE OF PPF banka a. s

Recommend Documents