Accounting export template Ebp

Revision as of 12:38, 2 May 2014 by Jcheng (Talk | contribs)

Jump to: navigation, search
{
  "outputFormat":{
    "contentType":"text\/plain",
    "charset":"cp850",
    "filePrefix":"ecriture_",
    "fileExtension":"txt",
    "converter":"DOS"
  },
  "field":[
    {
      "name":"flow_id",
      "format":{
        "name":"formatNumber",
        "parameter":[
          "%5.0f"
        ]
      }
    },
    {
      "name":"account_date",
      "format":{
        "name":"formatDate",
        "parameter":[
          "DDMMYYYY"
        ]
      }
    },
    {
      "name":"paper",
      "format":{
        "name":"accountPaper"
      }
    },
    {
      "name":"export_account",
      "format":{
        "name":"formatText",
        "removeChar":",",
        "rightPadding":" ",
        "size":15
      }
    },
    {
      "text":""
    },
    {
      "name":"account_entry_description",
      "format":{
        "name":"formatText",
        "appendText":"\"",
        "prependText":"\"",
        "rightPadding":" ",
        "size":40
      }
    },
    {
      "text":"",
      "format":{
        "name":"formatText",
        "appendText":"\"",
        "prependText":"\"",
        "rightPadding":" ",
        "size":15
      }
    },
    {
      "name":"debit",
      "format":{
        "name":"formatNumber",
        "parameter":[
          "%013.2f"
        ]
      },
      "if":{
        "leftPart":"debit",
        "operator":">",
        "rightPart":"0"
      }
    },
    {
      "text":"D",
      "if":{
        "leftPart":"debit",
        "operator":">",
        "rightPart":"0"
      }
    },
    {
      "name":"credit",
      "format":{
        "name":"formatNumber",
        "parameter":[
          "%013.2f"
        ]
      },
      "if":{
        "leftPart":"debit",
        "operator":"==",
        "rightPart":"0"
      }
    },
    {
      "text":"C",
      "if":{
        "leftPart":"debit",
        "operator":"==",
        "rightPart":"0"
      }
    },
    {
      "name":"account_date",
      "format":{
        "name":"formatDate",
        "parameter":[
          "DDMMYYYY"
        ]
      }
    },
    {
      "text":""
    }
  ],
  "separator":",",
  "endLine":"\n"
}