Difference between revisions of "Accounting export template Sage"
m (Created page with "<xml><?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="text" media-type="text/plain" ...") |
|||
Line 1: | Line 1: | ||
− | < | + | <javascript>{ |
− | + | "outputFormat":{ | |
− | + | "contentType":"text\/plain", | |
− | + | "charset":"ISO-8859-15", | |
− | + | "filePrefix":"Import_", | |
− | + | "fileExtension":"pnm", | |
− | + | "converter":"ISOWithHeader" | |
− | + | }, | |
− | + | "field":[ | |
− | + | { | |
− | + | "name":"paper", | |
− | + | "format":{ | |
− | + | "name":"accountPaper" | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "text":"", | |
− | + | "format":{ | |
− | + | "name":"formatText", | |
− | + | "rightPadding":" ", | |
− | + | "size":1 | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "name":"account_date", | |
− | + | "format":{ | |
− | + | "name":"formatDate", | |
− | + | "parameter":[ | |
− | + | "DDMMYY" | |
− | + | ] | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "text":"", | |
− | + | "format":{ | |
− | + | "name":"formatText", | |
− | + | "rightPadding":" ", | |
− | + | "size":2 | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "name":"export_account", | |
− | + | "format":{ | |
− | + | "name":"formatText", | |
− | + | "rightPadding":" ", | |
− | + | "size":13 | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "text":"", | |
− | + | "format":{ | |
− | + | "name":"formatText", | |
− | + | "rightPadding":" ", | |
− | + | "size":1 | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "text":"", | |
− | + | "format":{ | |
− | + | "name":"formatText", | |
− | + | "rightPadding":" ", | |
− | + | "size":13 | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "name":"id", | |
− | + | "format":{ | |
− | + | "name":"formatNumber", | |
− | + | "parameter":[ | |
− | + | "%-13.0f" | |
− | + | ] | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "name":"account_entry_description", | |
− | + | "format":{ | |
− | + | "name":"formatText", | |
− | + | "rightPadding":" ", | |
− | + | "size":25 | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "text":"", | |
− | + | "format":{ | |
− | + | "name":"formatText", | |
− | + | "rightPadding":" ", | |
− | + | "size":1 | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "text":"", | |
− | + | "format":{ | |
− | + | "name":"formatText", | |
− | + | "rightPadding":" ", | |
− | + | "size":6 | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "text":"D", | |
+ | "if":{ | ||
+ | "leftPart":"debit", | ||
+ | "operator":">", | ||
+ | "rightPart":"0" | ||
+ | } | ||
+ | }, | ||
+ | { | ||
+ | "name":"debit", | ||
+ | "format":{ | ||
+ | "name":"formatNumber", | ||
+ | "parameter":[ | ||
+ | "%20.2f" | ||
+ | ] | ||
+ | }, | ||
+ | "if":{ | ||
+ | "leftPart":"debit", | ||
+ | "operator":">", | ||
+ | "rightPart":"0" | ||
+ | } | ||
+ | }, | ||
+ | { | ||
+ | "text":"C", | ||
+ | "if":{ | ||
+ | "leftPart":"debit", | ||
+ | "operator":"==", | ||
+ | "rightPart":"0" | ||
+ | } | ||
+ | }, | ||
+ | { | ||
+ | "name":"credit", | ||
+ | "format":{ | ||
+ | "name":"formatNumber", | ||
+ | "parameter":[ | ||
+ | "%20.2f" | ||
+ | ] | ||
+ | }, | ||
+ | "if":{ | ||
+ | "leftPart":"debit", | ||
+ | "operator":"==", | ||
+ | "rightPart":"0" | ||
+ | } | ||
+ | }, | ||
+ | { | ||
+ | "text":"N" | ||
+ | }, | ||
+ | { | ||
+ | "name":"flow_id", | ||
+ | "format":{ | ||
+ | "name":"formatNumber", | ||
+ | "parameter":[ | ||
+ | "%07.0f" | ||
+ | ] | ||
+ | } | ||
+ | }, | ||
+ | { | ||
+ | "text":"", | ||
+ | "format":{ | ||
+ | "name":"formatText", | ||
+ | "rightPadding":" ", | ||
+ | "size":26 | ||
+ | } | ||
+ | } | ||
+ | ], | ||
+ | "separator":"", | ||
+ | "endLine":"\r\n" | ||
+ | }</javascript> |
Revision as of 12:39, 2 May 2014
{ "outputFormat":{ "contentType":"text\/plain", "charset":"ISO-8859-15", "filePrefix":"Import_", "fileExtension":"pnm", "converter":"ISOWithHeader" }, "field":[ { "name":"paper", "format":{ "name":"accountPaper" } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":1 } }, { "name":"account_date", "format":{ "name":"formatDate", "parameter":[ "DDMMYY" ] } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":2 } }, { "name":"export_account", "format":{ "name":"formatText", "rightPadding":" ", "size":13 } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":1 } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":13 } }, { "name":"id", "format":{ "name":"formatNumber", "parameter":[ "%-13.0f" ] } }, { "name":"account_entry_description", "format":{ "name":"formatText", "rightPadding":" ", "size":25 } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":1 } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":6 } }, { "text":"D", "if":{ "leftPart":"debit", "operator":">", "rightPart":"0" } }, { "name":"debit", "format":{ "name":"formatNumber", "parameter":[ "%20.2f" ] }, "if":{ "leftPart":"debit", "operator":">", "rightPart":"0" } }, { "text":"C", "if":{ "leftPart":"debit", "operator":"==", "rightPart":"0" } }, { "name":"credit", "format":{ "name":"formatNumber", "parameter":[ "%20.2f" ] }, "if":{ "leftPart":"debit", "operator":"==", "rightPart":"0" } }, { "text":"N" }, { "name":"flow_id", "format":{ "name":"formatNumber", "parameter":[ "%07.0f" ] } }, { "text":"", "format":{ "name":"formatText", "rightPadding":" ", "size":26 } } ], "separator":"", "endLine":"\r\n" }