Accounting export template Sage

From OpenFlyers Documentation
Revision as of 16:04, 15 November 2017 by imported>Jcheng (→‎Output file description)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Introduction

This page described the accounting export template Sage.

Output file description

  • Encoding charset: ISO-8859-15
  • Field character separator: Tab
  • First line contains client structure name
  • Fields:
Name Length (in character) Description
Export code
1 space
Date Format is DDMMYY
2 spaces
Export account 13 Filled with appended spaces to match length
1 space
13 spaces
id 13 Filled with appended spaces to match length
Description 25 Filled with appended spaces to match length
1 space
6 spaces
Character C or D C for credit, D for debit
Amount 20 Number with 20 digits before the decimal separator and 2 digits after
Character N
Flow id 7 Filled with prepended zeros to match length
26 spaces

Example of output file

demo
VT 010114  411000                     67           Pilote CHRISTIAN CHRISTIA       D               99.00N0000067                          
VT 010114  706BVOI                    68           Solo FBVOI                      C               99.00N0000067                          
VT 010114  411000                     69           Pilote Éléonore ÉLÉONORE        D               51.00N0000069                          
VT 010114  706BVOI                    70           Solo FBVOI                      C               51.00N0000069                          
VT 010114  411000                     71           Pilote Nadine NADINE            D               51.00N0000071                          
VT 010114  706BVOI                    72           Solo FBVOI                      C               51.00N0000071                          
VT 020114  411000                     73           Pilote Éléonore ÉLÉONORE        D              408.00N0000073                          
VT 020114  706BVOI                    74           Solo FBVOI                      C              408.00N0000073                          
VT 030114  411000                     75           Pilote Christophe LARATTE       D               99.00N0000075                          
VT 030114  706BVOI                    76           Solo FBVOI                      C               99.00N0000075                          
VT 030114  411000                     77           Pilote Marie-France MARIE       D              124.00N0000077                          
VT 030114  706BVOI                    78           Solo FBVOI                      C              124.00N0000077                          
VT 050114  411000                     79           Pilote Erwan ERWAN              D               99.00N0000079                          
VT 050114  706BVOI                    80           Solo FBVOI                      C               99.00N0000079                          
VT 010114  411000                     343          Pilote Susie SUSIE              D              159.00N0000343                          
VT 010114  706GNNB                    344          Solo FGNNB                      C              159.00N0000343                          
VT 010114  411000                     459          Pilote Thomas THOMAS            D              138.00N0000459                          
VT 010114  706GIKI                    460          Solo FGIKI                      C              138.00N0000459                          
VT 010114  411000                     461          Pilote firstTest4 lastTes       D              110.00N0000461                          
VT 010114  706GIKI                    462          Solo FGIKI                      C              110.00N0000461                          
VT 010114  411000                     463          Pilote Thomas THOMAS            D               69.00N0000463                          
VT 010114  706GIKI                    464          Solo FGIKI                      C               69.00N0000463                          
VT 010114  411000                     465          Pilote Richard RICHARD          D              207.00N0000465                          
VT 010114  706GIKI                    466          Solo FGIKI                      C              207.00N0000465                          
VT 020114  411000                     467          Pilote Briac BRIAC              D              345.00N0000467                          
VT 020114  706GIKI                    468          Solo FGIKI                      C              345.00N0000467                          
VT 030114  411000                     469          Pilote firstTest5 lastTes       D              138.00N0000469                          
VT 030114  706GIKI                    470          Solo FGIKI                      C              138.00N0000469                          
VT 030114  411000                     471          Pilote firstTest6 lastTes       D              138.00N0000471                          
VT 030114  706GIKI                    472          Solo FGIKI                      C              138.00N0000471                          
VT 050114  411000                     473          Pilote tom TOM                  D              110.00N0000473                          
VT 050114  706GIKI                    474          Solo FGIKI                      C              110.00N0000473