Difference between revisions of "Accounting export template CielXimport"
m (Blanked the page) |
m (Text replacement - "[[Accounting_export_template_list|" to "[[Accounting-export-template-list|") |
||
(7 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
+ | =Introduction= | ||
+ | This page described the [[Accounting-export-template-list|accounting export template]] Ximport for Ciel software. | ||
+ | =Output file description= | ||
+ | |||
+ | * Encoding charset: cp850 | ||
+ | * Fields: | ||
+ | {| class="wikitable" | ||
+ | !Name!!Length (in character)!!OpenFlyers filling | ||
+ | |- | ||
+ | |Flow number||5||Filled with prepended zeros to match length | ||
+ | |- | ||
+ | |Accounting journal||2||Export code | ||
+ | |- | ||
+ | |Accounting date||8||Format is YYYYMMDD | ||
+ | |- | ||
+ | |Due date||8||8 spaces | ||
+ | |- | ||
+ | |Voucher number||12||12 spaces | ||
+ | |- | ||
+ | |Account||11||Export account. Filled with appended spaces to match length | ||
+ | |- | ||
+ | |Description||25||Filled with appended spaces to match length | ||
+ | |- | ||
+ | |Amount||13||Number with 2 digits after the decimal separator and filled with prepended zeros to match length | ||
+ | |- | ||
+ | |Debit/credit||1||C for credit, D for debit | ||
+ | |- | ||
+ | |Reconciliation number||12||12 spaces | ||
+ | |- | ||
+ | |Analytic/Budget code||6||6 spaces | ||
+ | |- | ||
+ | |Name of the account||34||Filled with appended spaces to match length | ||
+ | |- | ||
+ | |Euro||1||ignored | ||
+ | |} | ||
+ | |||
+ | =Example of output file= | ||
+ | |||
+ | <pre> 67VT20140101 411000 Pilote CHRISTIAN CHRISTIA0000000099.00D | ||
+ | 67VT20140101 706BVOI Solo FBVOI 0000000099.00C | ||
+ | 69VT20140101 411000 Pilote l‚onore LONORE 0000000051.00D | ||
+ | 69VT20140101 706BVOI Solo FBVOI 0000000051.00C | ||
+ | 71VT20140101 411000 Pilote Nadine NADINE 0000000051.00D | ||
+ | 71VT20140101 706BVOI Solo FBVOI 0000000051.00C | ||
+ | 73VT20140102 411000 Pilote l‚onore LONORE 0000000408.00D | ||
+ | 73VT20140102 706BVOI Solo FBVOI 0000000408.00C | ||
+ | 75VT20140103 411000 Pilote Christophe LARATTE0000000099.00D | ||
+ | 75VT20140103 706BVOI Solo FBVOI 0000000099.00C | ||
+ | 77VT20140103 411000 Pilote Marie-France MARIE0000000124.00D | ||
+ | 77VT20140103 706BVOI Solo FBVOI 0000000124.00C | ||
+ | 79VT20140105 411000 Pilote Erwan ERWAN 0000000099.00D | ||
+ | 79VT20140105 706BVOI Solo FBVOI 0000000099.00C | ||
+ | 343VT20140101 411000 Pilote Susie SUSIE 0000000159.00D | ||
+ | 343VT20140101 706GNNB Solo FGNNB 0000000159.00C | ||
+ | 459VT20140101 411000 Pilote Thomas THOMAS 0000000138.00D | ||
+ | 459VT20140101 706GIKI Solo FGIKI 0000000138.00C | ||
+ | 461VT20140101 411000 Pilote firstTest4 lastTes0000000110.00D | ||
+ | 461VT20140101 706GIKI Solo FGIKI 0000000110.00C | ||
+ | 463VT20140101 411000 Pilote Thomas THOMAS 0000000069.00D | ||
+ | 463VT20140101 706GIKI Solo FGIKI 0000000069.00C | ||
+ | 465VT20140101 411000 Pilote Richard RICHARD 0000000207.00D | ||
+ | 465VT20140101 706GIKI Solo FGIKI 0000000207.00C | ||
+ | 467VT20140102 411000 Pilote Briac BRIAC 0000000345.00D | ||
+ | 467VT20140102 706GIKI Solo FGIKI 0000000345.00C | ||
+ | 469VT20140103 411000 Pilote firstTest5 lastTes0000000138.00D | ||
+ | 469VT20140103 706GIKI Solo FGIKI 0000000138.00C | ||
+ | 471VT20140103 411000 Pilote firstTest6 lastTes0000000138.00D | ||
+ | 471VT20140103 706GIKI Solo FGIKI 0000000138.00C | ||
+ | 473VT20140105 411000 Pilote tom TOM 0000000110.00D | ||
+ | 473VT20140105 706GIKI Solo FGIKI 0000000110.00C | ||
+ | </pre> |
Latest revision as of 11:13, 18 July 2016
Introduction
This page described the accounting export template Ximport for Ciel software.
Output file description
- Encoding charset: cp850
- Fields:
Name | Length (in character) | OpenFlyers filling |
---|---|---|
Flow number | 5 | Filled with prepended zeros to match length |
Accounting journal | 2 | Export code |
Accounting date | 8 | Format is YYYYMMDD |
Due date | 8 | 8 spaces |
Voucher number | 12 | 12 spaces |
Account | 11 | Export account. Filled with appended spaces to match length |
Description | 25 | Filled with appended spaces to match length |
Amount | 13 | Number with 2 digits after the decimal separator and filled with prepended zeros to match length |
Debit/credit | 1 | C for credit, D for debit |
Reconciliation number | 12 | 12 spaces |
Analytic/Budget code | 6 | 6 spaces |
Name of the account | 34 | Filled with appended spaces to match length |
Euro | 1 | ignored |
Example of output file
67VT20140101 411000 Pilote CHRISTIAN CHRISTIA0000000099.00D 67VT20140101 706BVOI Solo FBVOI 0000000099.00C 69VT20140101 411000 Pilote l‚onore LONORE 0000000051.00D 69VT20140101 706BVOI Solo FBVOI 0000000051.00C 71VT20140101 411000 Pilote Nadine NADINE 0000000051.00D 71VT20140101 706BVOI Solo FBVOI 0000000051.00C 73VT20140102 411000 Pilote l‚onore LONORE 0000000408.00D 73VT20140102 706BVOI Solo FBVOI 0000000408.00C 75VT20140103 411000 Pilote Christophe LARATTE0000000099.00D 75VT20140103 706BVOI Solo FBVOI 0000000099.00C 77VT20140103 411000 Pilote Marie-France MARIE0000000124.00D 77VT20140103 706BVOI Solo FBVOI 0000000124.00C 79VT20140105 411000 Pilote Erwan ERWAN 0000000099.00D 79VT20140105 706BVOI Solo FBVOI 0000000099.00C 343VT20140101 411000 Pilote Susie SUSIE 0000000159.00D 343VT20140101 706GNNB Solo FGNNB 0000000159.00C 459VT20140101 411000 Pilote Thomas THOMAS 0000000138.00D 459VT20140101 706GIKI Solo FGIKI 0000000138.00C 461VT20140101 411000 Pilote firstTest4 lastTes0000000110.00D 461VT20140101 706GIKI Solo FGIKI 0000000110.00C 463VT20140101 411000 Pilote Thomas THOMAS 0000000069.00D 463VT20140101 706GIKI Solo FGIKI 0000000069.00C 465VT20140101 411000 Pilote Richard RICHARD 0000000207.00D 465VT20140101 706GIKI Solo FGIKI 0000000207.00C 467VT20140102 411000 Pilote Briac BRIAC 0000000345.00D 467VT20140102 706GIKI Solo FGIKI 0000000345.00C 469VT20140103 411000 Pilote firstTest5 lastTes0000000138.00D 469VT20140103 706GIKI Solo FGIKI 0000000138.00C 471VT20140103 411000 Pilote firstTest6 lastTes0000000138.00D 471VT20140103 706GIKI Solo FGIKI 0000000138.00C 473VT20140105 411000 Pilote tom TOM 0000000110.00D 473VT20140105 706GIKI Solo FGIKI 0000000110.00C