Accounting export template Fec

From OpenFlyers Documentation
Revision as of 11:16, 10 July 2019 by imported>Eberthomieu (→‎Example of output file)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Introduction

This page described the accounting export template EBP 2012.

Output file description

  • Encoding charset: UTF-8
  • Field character separator: |
  • End line separator: \n
  • Fields:
Name OpenFlyers filling
JournalCode OpenFlyers export code
JournalLib General journal
EcritureNum OpenFlyers flow ID
EcritureDate OpenFlyers account entry date
CompteNum First 3 numbers of the account
CompteLib OpenFLyers account label
CompAuxNum Empty
CompAuxLib Empty
PieceRef OpenFlyers bill id
PieceDate OpenFlyers account entry date
EcritureLib OpenFlyers account entry description
Debit OpenFlyers Debit
Credit OpenFlyers Credit
EcritureLet Empty
DateLet Empty
ValidDate OpenFlyers validation date
Montantdevise Empty
Idevise Empty

Example of output file

JournalCode|JournalLib|EcritureNum|EcritureDate|CompteNum|CompteLib|CompAuxNum|CompAuxLib|PieceRef|PieceDate|EcritureLib|Debit|Credit|EcritureLet|DateLet|ValidDate|Montantdevise|Idevise
VEN|Journal des ventes|9574|20190701|411|411claratte|||56|20190701|Heures de vol|200,00|0,00|||20190702||
VEN|Journal des ventes|9574|20190701|706|70611|||||Heures de vol|0,00|200,00|||20190702||