Difference between revisions of "Accounting export template Sage"
m (→Example of output file) |
(→Output file description) |
||
(4 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
+ | =Introduction= | ||
+ | This page described the [[Accounting-export-template-list|accounting export template]] Sage. | ||
+ | |||
+ | =Output file description= | ||
+ | |||
+ | * Encoding charset: ISO-8859-15 | ||
+ | * Field character separator: Tab | ||
+ | * First line contains client structure name | ||
+ | * Fields: | ||
+ | {| class="wikitable" | ||
+ | !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= | =Example of output file= | ||
− | |||
<pre>demo | <pre>demo | ||
VT 010114 411000 67 Pilote CHRISTIAN CHRISTIA D 99.00N0000067 | VT 010114 411000 67 Pilote CHRISTIAN CHRISTIA D 99.00N0000067 |
Latest revision as of 17:04, 15 November 2017
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