Difference between revisions of "Accounting export template Quadratus"
m (Created page with "<xml><?xml version="1.0" encoding="ISO-8859-1"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="text" media-type="text/pl...") |
|||
Line 1: | Line 1: | ||
− | < | + | <javascript>{ |
− | + | "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":"accountPaper" | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "text":"000" | |
− | + | }, | |
− | + | { | |
− | + | "name":"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" | ||
+ | }</javascript> |
Revision as of 12:39, 2 May 2014
{ "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":"accountPaper" } }, { "text":"000" }, { "name":"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" }