imported>Jcheng: /* Output file description */

2017-03-20T12:18:22Z

Output file description

New page

=Introduction=
This page described the [[Accounting-export-template-list|accounting export template]] EBP 2010.

=Output file description=

* Encoding charset: ISO-8859-15
* Field character separator: ,
* End line separator: CR
* Fields:
{| class="wikitable"
!Name!!Length (in character)!!OpenFlyers filling
|-
|Line||||OpenFlyers flow number. Ignored by EBP
|-
|Accounting date DDMMYY or DDMMYYYY||||Date formatted DDMMYY
|-
|Accounting journal||4 max.||OpenFlyers export code
|-
|Account number||15 max.||OpenFlyers Export account. Characters '','' are removed
|-
|Automatic label||2||Ignored by OpenFlyers and ignored by EBP
|-
|Manual label quoted with character ''"''||40 max.||OpenFlyers account description
|-
|Voucher number quoted with character ''"''||3 max.||OpenFlyers flow number prefixed with ''OF'' and quoted with character ''"''
|-
|Amount||||Number 2 digits after the decimal separator. Point as decimal separator.
|-
|Debit/Credit||1||C for credit, D for debit
|-
|Due date DDMMYY or DDMMYYYY||||Ignored by OpenFlyers
|-
|Currency (optional ISO Code)||||Ignored by OpenFlyers
|}

=Example of output file=

<pre>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,,
</pre>

Accounting export template Ebp2010 - Revision history

imported>Jcheng: /* Output file description */