Difference between revisions of "Accounting export template CielRimport"
m |
|||
Line 1: | Line 1: | ||
− | < | + | <javascript>{ |
− | + | "outputFormat":{ | |
− | + | "contentType":"text\/plain", | |
− | + | "charset":"ISO-8859-15", | |
− | + | "filePrefix":"Rimport_", | |
− | + | "fileExtension":"txt", | |
− | + | "converter":"ISO" | |
− | + | }, | |
− | + | "field":[ | |
− | + | { | |
− | + | "name":"flow_id", | |
− | + | "format":{ | |
− | + | "name":"formatNumber", | |
− | + | "parameter":[ | |
− | + | "%06.0f" | |
− | + | ] | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "name":"paper", | |
− | + | "format":{ | |
− | + | "name":"accountPaper" | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "name":"account_date", | |
− | + | "format":{ | |
− | + | "name":"formatDate", | |
− | + | "parameter":[ | |
− | + | "DD\/MM\/YYYY" | |
− | + | ] | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "name":"export_account", | |
− | + | "format":{ | |
− | + | "name":"formatText", | |
− | + | "rightPadding":" ", | |
− | + | "size":13 | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "name":"account_entry_description", | |
− | + | "format":{ | |
− | + | "name":"formatText", | |
− | + | "rightPadding":" ", | |
− | + | "size":35 | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "name":"debit", | |
− | + | "format":{ | |
− | + | "name":"formatNumber", | |
− | + | "parameter":[ | |
− | + | "%0.2f" | |
− | + | ] | |
− | + | }, | |
− | + | "if":{ | |
− | + | "leftPart":"debit", | |
− | + | "operator":">", | |
− | + | "rightPart":"0" | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "text":"D", | |
− | + | "if":{ | |
− | + | "leftPart":"debit", | |
− | + | "operator":">", | |
− | + | "rightPart":"0" | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "name":"credit", | |
− | + | "format":{ | |
− | + | "name":"formatNumber", | |
− | + | "parameter":[ | |
− | + | "%0.2f" | |
− | + | ] | |
− | + | }, | |
− | + | "if":{ | |
− | + | "leftPart":"debit", | |
− | + | "operator":"==", | |
− | + | "rightPart":"0" | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "text":"C", | |
− | + | "if":{ | |
− | + | "leftPart":"debit", | |
− | + | "operator":"==", | |
− | + | "rightPart":"0" | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "text":"B" | |
− | + | }, | |
− | + | { | |
− | + | "name":"account_entry_comments", | |
− | + | "format":{ | |
− | + | "name":"formatText", | |
− | + | "rightPadding":" ", | |
− | + | "size":50, | |
− | + | "removeNewLine":true | |
− | + | } | |
− | + | } | |
− | + | ], | |
− | + | "separator":"\t", | |
− | + | "endLine":"\r\n" | |
− | + | }</javascript> |
Revision as of 12:36, 2 May 2014
{ "outputFormat":{ "contentType":"text\/plain", "charset":"ISO-8859-15", "filePrefix":"Rimport_", "fileExtension":"txt", "converter":"ISO" }, "field":[ { "name":"flow_id", "format":{ "name":"formatNumber", "parameter":[ "%06.0f" ] } }, { "name":"paper", "format":{ "name":"accountPaper" } }, { "name":"account_date", "format":{ "name":"formatDate", "parameter":[ "DD\/MM\/YYYY" ] } }, { "name":"export_account", "format":{ "name":"formatText", "rightPadding":" ", "size":13 } }, { "name":"account_entry_description", "format":{ "name":"formatText", "rightPadding":" ", "size":35 } }, { "name":"debit", "format":{ "name":"formatNumber", "parameter":[ "%0.2f" ] }, "if":{ "leftPart":"debit", "operator":">", "rightPart":"0" } }, { "text":"D", "if":{ "leftPart":"debit", "operator":">", "rightPart":"0" } }, { "name":"credit", "format":{ "name":"formatNumber", "parameter":[ "%0.2f" ] }, "if":{ "leftPart":"debit", "operator":"==", "rightPart":"0" } }, { "text":"C", "if":{ "leftPart":"debit", "operator":"==", "rightPart":"0" } }, { "text":"B" }, { "name":"account_entry_comments", "format":{ "name":"formatText", "rightPadding":" ", "size":50, "removeNewLine":true } } ], "separator":"\t", "endLine":"\r\n" }