ExportCsvDebitCreditWithCommaDecimal.json
Jump to navigation
Jump to search
{
"outputFormat":{
"contentType":"text\/csv",
"charset":"UTF-8",
"filePrefix":"accountancy_",
"fileExtension":"csv",
"converter":"Default"
},
"field":[
{
"name":"flow_id",
"format":{
"name":"formatNumber",
"parameter":[
"%06.0f"
]
}
},
{
"name":"paper",
"format":{
"name":"accountJournal",
"defaultJournal":"OD",
"parameter":[{
"51":"BQ",
"53":"CAI",
"7":"VT"
}]
}
},
{
"name":"converted_account_date",
"format":{
"name":"formatDate",
"parameter":[
"YYYYMMDD"
]
}
},
{
"name":"export_account"
},
{
"name":"account_entry_description",
"format":{
"name":"formatText",
"removeChar":[
"&",
">",
"<",
";"
]
}
},
{
"name":"debit",
"format":{
"name":"formatNumber",
"parameter":[
"%08.2f"
],
"separatorDecimal":","
},
"if":{
"leftPart":"debit",
"operator":">",
"rightPart":"0"
}
},
{
"text":"",
"if":{
"leftPart":"debit",
"operator":">",
"rightPart":"0"
}
},
{
"text":"",
"if":{
"leftPart":"debit",
"operator":"==",
"rightPart":"0"
}
},
{
"name":"credit",
"format":{
"name":"formatNumber",
"parameter":[
"%08.2f"
],
"separatorDecimal":","
},
"if":{
"leftPart":"debit",
"operator":"==",
"rightPart":"0"
}
}
],
"separator":";",
"endLine":"\n"
}