Difference between revisions of "Accounting export template Ebp2012"
m (→Example of output file) |
|||
Line 1: | Line 1: | ||
+ | =Output file description= | ||
+ | |||
+ | * Encoding charset: ISO-8859-15 | ||
+ | * Field character separator: , | ||
+ | * Fields: | ||
+ | {| class="wikitable" | ||
+ | !Name!!Length (in character)!!Description | ||
+ | |- | ||
+ | |Flow number|||| | ||
+ | |- | ||
+ | |Date||||Format is DDMMYY | ||
+ | |- | ||
+ | |Export code|||| | ||
+ | |- | ||
+ | |Export account||||Character ''',''' is removed | ||
+ | |- | ||
+ | |||||Nothing | ||
+ | |- | ||
+ | |Flow number||3||Escaped with character '''"''' and '''OF''' added at the beginning | ||
+ | |- | ||
+ | |||15||15 spaces escaped with character '''"''' | ||
+ | |- | ||
+ | |Amount||13||Number 2 digits after the decimal separator | ||
+ | |- | ||
+ | |Character C or D||||C for credit, D for debit | ||
+ | |- | ||
+ | |Date||||Format is DDMMYYYY | ||
+ | |- | ||
+ | |||||Nothing | ||
+ | |- | ||
+ | |||||Nothing | ||
+ | |- | ||
+ | |} | ||
+ | |||
=Example of output file= | =Example of output file= | ||
− | |||
<pre>67,010114,VE,411000,,"Pilote CHRISTIAN CHRISTIAN ","OF067",99.00,D,, | <pre>67,010114,VE,411000,,"Pilote CHRISTIAN CHRISTIAN ","OF067",99.00,D,, | ||
67,010114,VE,706BVOI,,"Solo FBVOI ","OF067",99.00,C,, | 67,010114,VE,706BVOI,,"Solo FBVOI ","OF067",99.00,C,, |
Revision as of 09:38, 7 May 2014
Output file description
- Encoding charset: ISO-8859-15
- Field character separator: ,
- Fields:
Name | Length (in character) | Description |
---|---|---|
Flow number | ||
Date | Format is DDMMYY | |
Export code | ||
Export account | Character , is removed | |
Nothing | ||
Flow number | 3 | Escaped with character " and OF added at the beginning |
15 | 15 spaces escaped with character " | |
Amount | 13 | Number 2 digits after the decimal separator |
Character C or D | C for credit, D for debit | |
Date | Format is DDMMYYYY | |
Nothing | ||
Nothing |
Example of output file
67,010114,VE,411000,,"Pilote CHRISTIAN CHRISTIAN ","OF067",99.00,D,, 67,010114,VE,706BVOI,,"Solo FBVOI ","OF067",99.00,C,, 69,010114,VE,411000,,"Pilote Éléonore ÉLÉONORE ","OF069",51.00,D,, 69,010114,VE,706BVOI,,"Solo FBVOI ","OF069",51.00,C,, 71,010114,VE,411000,,"Pilote Nadine NADINE ","OF071",51.00,D,, 71,010114,VE,706BVOI,,"Solo FBVOI ","OF071",51.00,C,, 73,020114,VE,411000,,"Pilote Éléonore ÉLÉONORE ","OF073",408.00,D,, 73,020114,VE,706BVOI,,"Solo FBVOI ","OF073",408.00,C,, 75,030114,VE,411000,,"Pilote Christophe LARATTE ","OF075",99.00,D,, 75,030114,VE,706BVOI,,"Solo FBVOI ","OF075",99.00,C,, 77,030114,VE,411000,,"Pilote Marie-France MARIE-FRANCE ","OF077",124.00,D,, 77,030114,VE,706BVOI,,"Solo FBVOI ","OF077",124.00,C,, 79,050114,VE,411000,,"Pilote Erwan ERWAN ","OF079",99.00,D,, 79,050114,VE,706BVOI,,"Solo FBVOI ","OF079",99.00,C,, 343,010114,VE,411000,,"Pilote Susie SUSIE ","OF343",159.00,D,, 343,010114,VE,706GNNB,,"Solo FGNNB ","OF343",159.00,C,, 459,010114,VE,411000,,"Pilote Thomas THOMAS ","OF459",138.00,D,, 459,010114,VE,706GIKI,,"Solo FGIKI ","OF459",138.00,C,, 461,010114,VE,411000,,"Pilote firstTest4 lastTest4 ","OF461",110.00,D,, 461,010114,VE,706GIKI,,"Solo FGIKI ","OF461",110.00,C,, 463,010114,VE,411000,,"Pilote Thomas THOMAS ","OF463",69.00,D,, 463,010114,VE,706GIKI,,"Solo FGIKI ","OF463",69.00,C,, 465,010114,VE,411000,,"Pilote Richard RICHARD ","OF465",207.00,D,, 465,010114,VE,706GIKI,,"Solo FGIKI ","OF465",207.00,C,, 467,020114,VE,411000,,"Pilote Briac BRIAC ","OF467",345.00,D,, 467,020114,VE,706GIKI,,"Solo FGIKI ","OF467",345.00,C,, 469,030114,VE,411000,,"Pilote firstTest5 lastTest5 ","OF469",138.00,D,, 469,030114,VE,706GIKI,,"Solo FGIKI ","OF469",138.00,C,, 471,030114,VE,411000,,"Pilote firstTest6 lastTest6 ","OF471",138.00,D,, 471,030114,VE,706GIKI,,"Solo FGIKI ","OF471",138.00,C,, 473,050114,VE,411000,,"Pilote tom TOM ","OF473",110.00,D,, 473,050114,VE,706GIKI,,"Solo FGIKI ","OF473",110.00,C,,