Difference between revisions of "Accounting export template Ebp2012"

Jump to: navigation, search
m (Text replacement - "[[Accounting_export_template_list|" to "[[Accounting-export-template-list|")
(Output file description)
Line 33: Line 33:
|Currency (optional ISO Code)||||Ignored by OpenFlyers
|Currency (optional ISO Code)||||Ignored by OpenFlyers
=Journal VCC=
Les écritures sont mises dans les journals suivant.
=Example of output file=
=Example of output file=

Revision as of 13:51, 30 July 2019


This page described the accounting export template EBP 2012.

Output file description

  • Encoding charset: ISO-8859-15
  • Field character separator: ,
  • End line separator: CR
  • Fields:
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 " 15 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

Journal VCC

Les écritures sont mises dans les journals suivant.

  • "6":"AC"
  • "7":"VE"
  • "51":"BQ"
  • "53":"CA"

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