Difference between revisions of "ExportCiel RImport.json"
Line 2: | Line 2: | ||
"outputFormat":{ | "outputFormat":{ | ||
"contentType":"text\/plain", | "contentType":"text\/plain", | ||
− | "charset":" | + | "charset":"ISO-8859-15", |
− | "filePrefix":" | + | "filePrefix":"Rimport_", |
"fileExtension":"txt", | "fileExtension":"txt", | ||
− | "converter":" | + | "converter":"ISO" |
}, | }, | ||
"field":[ | "field":[ | ||
Line 13: | Line 13: | ||
"name":"formatNumber", | "name":"formatNumber", | ||
"parameter":[ | "parameter":[ | ||
− | "% | + | "%06.0f" |
] | ] | ||
} | } | ||
Line 34: | Line 34: | ||
"name":"formatDate", | "name":"formatDate", | ||
"parameter":[ | "parameter":[ | ||
− | " | + | "DD\/MM\/YYYY" |
] | ] | ||
} | } | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
}, | }, | ||
{ | { | ||
Line 59: | Line 43: | ||
"name":"formatText", | "name":"formatText", | ||
"rightPadding":" ", | "rightPadding":" ", | ||
− | "size": | + | "size":13 |
} | } | ||
}, | }, | ||
{ | { | ||
− | "name":" | + | "name":"account_entry_description", |
"format":{ | "format":{ | ||
"name":"formatText", | "name":"formatText", | ||
"rightPadding":" ", | "rightPadding":" ", | ||
− | "size": | + | "size":35 |
} | } | ||
}, | }, | ||
Line 75: | Line 59: | ||
"name":"formatNumber", | "name":"formatNumber", | ||
"parameter":[ | "parameter":[ | ||
− | "% | + | "%0.2f" |
] | ] | ||
}, | }, | ||
Line 97: | Line 81: | ||
"name":"formatNumber", | "name":"formatNumber", | ||
"parameter":[ | "parameter":[ | ||
− | "% | + | "%0.2f" |
] | ] | ||
}, | }, | ||
Line 115: | Line 99: | ||
}, | }, | ||
{ | { | ||
− | + | "text":"B" | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
}, | }, | ||
{ | { | ||
− | + | "name":"account_entry_comments", | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | "name":" | + | |
"format":{ | "format":{ | ||
"name":"formatText", | "name":"formatText", | ||
"rightPadding":" ", | "rightPadding":" ", | ||
− | "size": | + | "size":50, |
"removeNewLine":true | "removeNewLine":true | ||
} | } | ||
} | } | ||
], | ], | ||
− | "separator":"", | + | "separator":"\t", |
"endLine":"\r\n" | "endLine":"\r\n" | ||
}</javascript> | }</javascript> |
Latest revision as of 13:08, 28 January 2020
{ "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":"accountJournal", "defaultJournal":"OD", "parameter":[{ "51":"BQ", "53":"CA", "7":"VT" }] } }, { "name":"converted_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" }