Difference between revisions of "ExportQuadratus.json"
(Created page with "<javascript>{ "outputFormat":{ "contentType":"text\/csv", "charset":"ISO-8859-15", "filePrefix":"exportQuadratus_", "fileExtension":"txt", "converter":"ISO"...") |
|||
Line 22: | Line 22: | ||
"name":"paper", | "name":"paper", | ||
"format":{ | "format":{ | ||
− | "name":" | + | "name":"accountJournal", |
+ | "defaultJournal":"OD", | ||
+ | "parameter":[{ | ||
+ | "51":"BQ", | ||
+ | "53":"CA", | ||
+ | "7":"VT" | ||
+ | }] | ||
} | } | ||
}, | }, | ||
Line 29: | Line 35: | ||
}, | }, | ||
{ | { | ||
− | "name":" | + | "name":"converted_account_date", |
"format":{ | "format":{ | ||
"name":"formatDate", | "name":"formatDate", |
Latest revision as of 13:09, 28 January 2020
{ "outputFormat":{ "contentType":"text\/csv", "charset":"ISO-8859-15", "filePrefix":"exportQuadratus_", "fileExtension":"txt", "converter":"ISO" }, "field":[ { "text":"M" }, { "name":"export_account", "format":{ "name":"formatText", "rightPadding":" ", "size":8 } }, { "name":"paper", "format":{ "name":"accountJournal", "defaultJournal":"OD", "parameter":[{ "51":"BQ", "53":"CA", "7":"VT" }] } }, { "text":"000" }, { "name":"converted_account_date", "format":{ "name":"formatDate", "parameter":[ "DDMMYY" ] } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":1 } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":20 } }, { "text":"D+", "if":{ "leftPart":"debit", "operator":">", "rightPart":"0" } }, { "name":"debit", "format":{ "name":"formatNumber", "multiplier": 100, "parameter":[ "%012.0f" ] }, "if":{ "leftPart":"debit", "operator":">", "rightPart":"0" } }, { "text":"C+", "if":{ "leftPart":"debit", "operator":"==", "rightPart":"0" } }, { "name":"credit", "format":{ "name":"formatNumber", "multiplier": 100, "parameter":[ "%012.0f" ] }, "if":{ "leftPart":"debit", "operator":"==", "rightPart":"0" } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":8 } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":6 } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":2 } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":3 } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":5 } }, { "name":"customer_bill_id", "format":{ "name":"formatText", "rightPadding":" ", "size":10 } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":10 } }, { "name":"flow_id", "format":{ "name":"formatNumber", "parameter":[ "%08.0f" ] } }, { "text":"EUR" }, { "name":"paper", "format":{ "name":"accountPaper" } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":1 } }, { "text":"O1D", "if":{ "leftPart":"account_category", "operator":"==", "rightPart":"6" } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":3 }, "if":{ "leftPart":"account_category", "operator":"!=", "rightPart":"6" } }, { "name":"account_entry_comments", "format":{ "name":"formatText", "removeNewLine":true, "rightPadding":" ", "size":30 } }, { "text":"AF", "if":{ "leftPart":"account_category", "operator":"==", "rightPart":"6" } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":2 }, "if":{ "leftPart":"account_category", "operator":"!=", "rightPart":"6" } }, { "name":"account_entry_description", "format":{ "name":"formatText", "removeNewLine":true, "rightPadding":" ", "size":10 } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":10 } }, { "text":"+" }, { "name":"debit", "format":{ "name":"formatNumber", "multiplier":100, "parameter":[ "%012.0f" ] }, "if":{ "leftPart":"debit", "operator":">", "rightPart":"0" } }, { "name":"credit", "format":{ "name":"formatNumber", "multiplier":100, "parameter":[ "%012.0f" ] }, "if":{ "leftPart":"debit", "operator":"==", "rightPart":"0" } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":12 } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":10 } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":28 } } ], "separator":"", "endLine":"\r\n" }