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
Formats of files for import and export of data for Internetbanking service of PPF
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
Strana 2 (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
Formats of files for import and export of data for Internetbanking service of PPF
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
Strana 3 (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
Formats of files for import and export of data for Internetbanking service of PPF
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
Strana 4 (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
Formats of files for import and export of data for Internetbanking service of PPF
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
Strana 5 (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
Formats of files for import and export of data for Internetbanking service of PPF
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
Strana 6 (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
Formats of files for import and export of data for Internetbanking service of PPF
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
Formats of files for import and export of data for Internetbanking service of PPF
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
Formats of files for import and export of data for Internetbanking service of PPF
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
Formats of files for import and export of data for Internetbanking service of PPF
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
Formats of files for import and export of data for Internetbanking service of PPF
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
Formats of files for import and export of data for Internetbanking service of PPF
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
Formats of files for import and export of data for Internetbanking service of PPF
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
Formats of files for import and export of data for Internetbanking service of PPF
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
Formats of files for import and export of data for Internetbanking service of PPF
banka a. s.
Strana 15 (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