Accounting export template CielXimport
Jump to navigation
Jump to search
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