Difference between revisions of "Accounting export template CielXimport"
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\/plain", | |
− | + | "charset":"cp850", | |
− | + | "filePrefix":"xImport_", | |
− | + | "fileExtension":"txt", | |
− | + | "converter":"ISO2ASCII" | |
− | + | }, | |
− | + | "field":[ | |
− | + | { | |
− | + | "name":"flow_id", | |
− | + | "format":{ | |
− | + | "name":"formatNumber", | |
− | + | "parameter":[ | |
− | + | "%5.0f" | |
− | + | ] | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "name":"paper", | |
− | + | "format":{ | |
− | + | "name":"accountPaper" | |
− | + | } | |
− | + | }, | |
− | + | { | |
− | + | "name":"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_description", | |
− | + | "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_comments", | ||
+ | "format":{ | ||
+ | "name":"formatText", | ||
+ | "rightPadding":" ", | ||
+ | "size":34, | ||
+ | "removeNewLine":true | ||
+ | } | ||
+ | } | ||
+ | ], | ||
+ | "separator":"", | ||
+ | "endLine":"\r\n" | ||
+ | }</javascript> |
Revision as of 12:37, 2 May 2014
{ "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":"accountPaper" } }, { "name":"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_description", "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_comments", "format":{ "name":"formatText", "rightPadding":" ", "size":34, "removeNewLine":true } } ], "separator":"", "endLine":"\r\n" }