Difference between revisions of "ExportCiel RImport.json"
Line 2: | Line 2: | ||
"outputFormat":{ | "outputFormat":{ | ||
"contentType":"text\/plain", | "contentType":"text\/plain", | ||
− | "charset":" | + | "charset":"cp850", |
− | "filePrefix":" | + | "filePrefix":"xImport_", |
"fileExtension":"txt", | "fileExtension":"txt", | ||
− | "converter":" | + | "converter":"ISO2ASCII" |
}, | }, | ||
"field":[ | "field":[ | ||
Line 13: | Line 13: | ||
"name":"formatNumber", | "name":"formatNumber", | ||
"parameter":[ | "parameter":[ | ||
− | "% | + | "%5.0f" |
] | ] | ||
} | } | ||
Line 34: | Line 34: | ||
"name":"formatDate", | "name":"formatDate", | ||
"parameter":[ | "parameter":[ | ||
− | " | + | "YYYYMMDD" |
] | ] | ||
} | } | ||
+ | }, | ||
+ | { | ||
+ | "text":"", | ||
+ | "format":{ | ||
+ | "name":"formatText", | ||
+ | "rightPadding":" ", | ||
+ | "size":8 | ||
+ | } | ||
+ | }, | ||
+ | { | ||
+ | "text":"", | ||
+ | "format":{ | ||
+ | "name":"formatText", | ||
+ | "rightPadding":" ", | ||
+ | "size":12 | ||
+ | } | ||
}, | }, | ||
{ | { | ||
Line 43: | Line 59: | ||
"name":"formatText", | "name":"formatText", | ||
"rightPadding":" ", | "rightPadding":" ", | ||
− | "size": | + | "size":11 |
} | } | ||
}, | }, | ||
{ | { | ||
− | "name":" | + | "name":"account_entry_comments", |
"format":{ | "format":{ | ||
"name":"formatText", | "name":"formatText", | ||
"rightPadding":" ", | "rightPadding":" ", | ||
− | "size": | + | "size":25 |
} | } | ||
}, | }, | ||
Line 59: | Line 75: | ||
"name":"formatNumber", | "name":"formatNumber", | ||
"parameter":[ | "parameter":[ | ||
− | "% | + | "%013.2f" |
] | ] | ||
}, | }, | ||
Line 81: | Line 97: | ||
"name":"formatNumber", | "name":"formatNumber", | ||
"parameter":[ | "parameter":[ | ||
− | "% | + | "%013.2f" |
] | ] | ||
}, | }, | ||
Line 99: | Line 115: | ||
}, | }, | ||
{ | { | ||
− | + | "text":"", | |
+ | "format":{ | ||
+ | "name":"formatText", | ||
+ | "rightPadding":" ", | ||
+ | "size":12 | ||
+ | } | ||
}, | }, | ||
{ | { | ||
− | "name":" | + | "text":"", |
+ | "format":{ | ||
+ | "name":"formatText", | ||
+ | "rightPadding":" ", | ||
+ | "size":6 | ||
+ | } | ||
+ | }, | ||
+ | { | ||
+ | "name":"account_entry_description", | ||
"format":{ | "format":{ | ||
"name":"formatText", | "name":"formatText", | ||
"rightPadding":" ", | "rightPadding":" ", | ||
− | "size": | + | "size":34, |
"removeNewLine":true | "removeNewLine":true | ||
} | } | ||
} | } | ||
], | ], | ||
− | "separator":" | + | "separator":"", |
"endLine":"\r\n" | "endLine":"\r\n" | ||
}</javascript> | }</javascript> |
Revision as of 13:07, 28 January 2020
{ "outputFormat":{ "contentType":"text\/plain", "charset":"cp850", "filePrefix":"xImport_", "fileExtension":"txt", "converter":"ISO2ASCII" }, "field":[ { "name":"flow_id", "format":{ "name":"formatNumber", "parameter":[ "%5.0f" ] } }, { "name":"paper", "format":{ "name":"accountJournal", "defaultJournal":"OD", "parameter":[{ "51":"BQ", "53":"CA", "7":"VT" }] } }, { "name":"converted_account_date", "format":{ "name":"formatDate", "parameter":[ "YYYYMMDD" ] } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":8 } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":12 } }, { "name":"export_account", "format":{ "name":"formatText", "rightPadding":" ", "size":11 } }, { "name":"account_entry_comments", "format":{ "name":"formatText", "rightPadding":" ", "size":25 } }, { "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" } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":12 } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":6 } }, { "name":"account_entry_description", "format":{ "name":"formatText", "rightPadding":" ", "size":34, "removeNewLine":true } } ], "separator":"", "endLine":"\r\n" }