Difference between revisions of "Accounting export template Csv"

Jump to: navigation, search
m (Text replacement - "[[Accounting_export_template_list|" to "[[Accounting-export-template-list|")
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
<javascript>{
+
=Introduction=
−
  "outputFormat":{
+
This page described the generic [[Accounting-export-template-list|accounting export template]] CSV.
−
    "contentType":"text\/csv",
+
 
−
    "charset":"UTF-8",
+
=Output file description=
−
    "filePrefix":"accountancy_",
+
 
−
    "fileExtension":"csv",
+
* Encoding charset: UTF-8
−
    "converter":"Default"
+
* Field character separator: ;
−
  },
+
* Fields:  
−
  "field":[
+
{| class="wikitable"
−
    {
+
!Name!!Length (in character)!!Description
−
      "name":"flow_id",
+
|-
−
      "format":{
+
|Flow number||6||Filled with prepended zeros to match length
−
        "name":"formatNumber",
+
|-
−
        "parameter":[
+
|Export code||||
−
          "%06.0f"
+
|-
−
        ]
+
|Date||||Format is YYYYMMDD
−
      }
+
|-
−
    },
+
|Export account||||
−
    {
+
|-
−
      "name":"paper",
+
|Description||25||Filled with appended spaces to match length
−
      "format":{
+
|-
−
        "name":"accountPaper"
+
|Amount||8||Number with 2 digits after the decimal separator and filled with prepended zeros to match length
−
      }
+
|-
−
    },
+
|Character C or D||||C for credit, D for debit
−
    {
+
|-
−
      "name":"account_date",
+
|}
−
      "format":{
+
 
−
        "name":"formatDate",
+
=Example of output file=
−
        "parameter":[
+
 
−
          "YYYYMMDD"
+
<pre>000067;VT;20140101;411000;Pilote CHRISTIAN CHRISTIA;00099.00;D
−
        ]
+
000067;VT;20140101;706BVOI;Solo FBVOI              ;00099.00;C
−
      }
+
000069;VT;20140101;411000;Pilote Éléonore ÉLÉONORE ;00051.00;D
−
    },
+
000069;VT;20140101;706BVOI;Solo FBVOI              ;00051.00;C
−
    {
+
000071;VT;20140101;411000;Pilote Nadine NADINE     ;00051.00;D
−
      "name":"export_account"
+
000071;VT;20140101;706BVOI;Solo FBVOI              ;00051.00;C
−
    },
+
000073;VT;20140102;411000;Pilote Éléonore ÉLÉONORE ;00408.00;D
−
    {
+
000073;VT;20140102;706BVOI;Solo FBVOI              ;00408.00;C
−
      "name":"account_entry_description",
+
000075;VT;20140103;411000;Pilote Christophe LARATTE;00099.00;D
−
      "format":{
+
000075;VT;20140103;706BVOI;Solo FBVOI              ;00099.00;C
−
        "name":"formatText",
+
000077;VT;20140103;411000;Pilote Marie-France MARIE;00124.00;D
−
        "rightPadding":" ",
+
000077;VT;20140103;706BVOI;Solo FBVOI              ;00124.00;C
−
        "size":25
+
000079;VT;20140105;411000;Pilote Erwan ERWAN       ;00099.00;D
−
      }
+
000079;VT;20140105;706BVOI;Solo FBVOI              ;00099.00;C
−
     },
+
000343;VT;20140101;411000;Pilote Susie SUSIE       ;00159.00;D
−
    {
+
000343;VT;20140101;706GNNB;Solo FGNNB              ;00159.00;C
−
      "name":"debit",
+
000459;VT;20140101;411000;Pilote Thomas THOMAS     ;00138.00;D
−
      "format":{
+
000459;VT;20140101;706GIKI;Solo FGIKI              ;00138.00;C
−
        "name":"formatNumber",
+
000461;VT;20140101;411000;Pilote firstTest4 lastTes;00110.00;D
−
        "parameter":[
+
000461;VT;20140101;706GIKI;Solo FGIKI              ;00110.00;C
−
          "%08.2f"
+
000463;VT;20140101;411000;Pilote Thomas THOMAS     ;00069.00;D
−
        ]
+
000463;VT;20140101;706GIKI;Solo FGIKI              ;00069.00;C
−
       },
+
000465;VT;20140101;411000;Pilote Richard RICHARD  ;00207.00;D
−
      "if":{
+
000465;VT;20140101;706GIKI;Solo FGIKI              ;00207.00;C
−
        "leftPart":"debit",
+
000467;VT;20140102;411000;Pilote Briac BRIAC       ;00345.00;D
−
        "operator":">",
+
000467;VT;20140102;706GIKI;Solo FGIKI              ;00345.00;C
−
        "rightPart":"0"
+
000469;VT;20140103;411000;Pilote firstTest5 lastTes;00138.00;D
−
       }
+
000469;VT;20140103;706GIKI;Solo FGIKI              ;00138.00;C
−
    },
+
000471;VT;20140103;411000;Pilote firstTest6 lastTes;00138.00;D
−
     {
+
000471;VT;20140103;706GIKI;Solo FGIKI              ;00138.00;C
−
      "text":"D",
+
000473;VT;20140105;411000;Pilote tom TOM          ;00110.00;D
−
      "if":{
+
000473;VT;20140105;706GIKI;Solo FGIKI              ;00110.00;C
−
        "leftPart":"debit",
+
</pre>
−
        "operator":">",
+
−
        "rightPart":"0"
+
−
      }
+
−
     },
+
−
    {
+
−
      "name":"credit",
+
−
      "format":{
+
−
        "name":"formatNumber",
+
−
        "parameter":[
+
−
          "%08.2f"
+
−
        ]
+
−
       },
+
−
      "if":{
+
−
        "leftPart":"debit",
+
−
        "operator":"==",
+
−
        "rightPart":"0"
+
−
      }
+
−
    },
+
−
    {
+
−
      "text":"C",
+
−
      "if":{
+
−
        "leftPart":"debit",
+
−
        "operator":"==",
+
−
        "rightPart":"0"
+
−
      }
+
−
    }
+
−
  ],
+
−
  "separator":";",
+
−
  "endLine":"\n"
+
−
}</javascript>
+

Latest revision as of 11:13, 18 July 2016

Introduction

This page described the generic accounting export template CSV.

Output file description

  • Encoding charset: UTF-8
  • Field character separator: ;
  • Fields:
Name Length (in character) Description
Flow number 6 Filled with prepended zeros to match length
Export code
Date Format is YYYYMMDD
Export account
Description 25 Filled with appended spaces to match length
Amount 8 Number with 2 digits after the decimal separator and filled with prepended zeros to match length
Character C or D C for credit, D for debit

Example of output file

000067;VT;20140101;411000;Pilote CHRISTIAN CHRISTIA;00099.00;D
000067;VT;20140101;706BVOI;Solo FBVOI               ;00099.00;C
000069;VT;20140101;411000;Pilote Éléonore ÉLÉONORE ;00051.00;D
000069;VT;20140101;706BVOI;Solo FBVOI               ;00051.00;C
000071;VT;20140101;411000;Pilote Nadine NADINE     ;00051.00;D
000071;VT;20140101;706BVOI;Solo FBVOI               ;00051.00;C
000073;VT;20140102;411000;Pilote Éléonore ÉLÉONORE ;00408.00;D
000073;VT;20140102;706BVOI;Solo FBVOI               ;00408.00;C
000075;VT;20140103;411000;Pilote Christophe LARATTE;00099.00;D
000075;VT;20140103;706BVOI;Solo FBVOI               ;00099.00;C
000077;VT;20140103;411000;Pilote Marie-France MARIE;00124.00;D
000077;VT;20140103;706BVOI;Solo FBVOI               ;00124.00;C
000079;VT;20140105;411000;Pilote Erwan ERWAN       ;00099.00;D
000079;VT;20140105;706BVOI;Solo FBVOI               ;00099.00;C
000343;VT;20140101;411000;Pilote Susie SUSIE       ;00159.00;D
000343;VT;20140101;706GNNB;Solo FGNNB               ;00159.00;C
000459;VT;20140101;411000;Pilote Thomas THOMAS     ;00138.00;D
000459;VT;20140101;706GIKI;Solo FGIKI               ;00138.00;C
000461;VT;20140101;411000;Pilote firstTest4 lastTes;00110.00;D
000461;VT;20140101;706GIKI;Solo FGIKI               ;00110.00;C
000463;VT;20140101;411000;Pilote Thomas THOMAS     ;00069.00;D
000463;VT;20140101;706GIKI;Solo FGIKI               ;00069.00;C
000465;VT;20140101;411000;Pilote Richard RICHARD   ;00207.00;D
000465;VT;20140101;706GIKI;Solo FGIKI               ;00207.00;C
000467;VT;20140102;411000;Pilote Briac BRIAC       ;00345.00;D
000467;VT;20140102;706GIKI;Solo FGIKI               ;00345.00;C
000469;VT;20140103;411000;Pilote firstTest5 lastTes;00138.00;D
000469;VT;20140103;706GIKI;Solo FGIKI               ;00138.00;C
000471;VT;20140103;411000;Pilote firstTest6 lastTes;00138.00;D
000471;VT;20140103;706GIKI;Solo FGIKI               ;00138.00;C
000473;VT;20140105;411000;Pilote tom TOM           ;00110.00;D
000473;VT;20140105;706GIKI;Solo FGIKI               ;00110.00;C