summaryrefslogtreecommitdiff
path: root/Master/texmf-dist/tex/latex/bankstatement/csv-camt.def
diff options
context:
space:
mode:
authorKarl Berry <karl@freefriends.org>2015-01-07 22:55:03 +0000
committerKarl Berry <karl@freefriends.org>2015-01-07 22:55:03 +0000
commite9fbb4ed6dce2e5d9b76bb70d72d9c575da9d5a6 (patch)
treebd52313d230eb3c72ab28765cc32fea00901a0ff /Master/texmf-dist/tex/latex/bankstatement/csv-camt.def
parente94db7b41f3d43082ad3849926c4b1f6dcf730fb (diff)
bankstatement (7jan15)
git-svn-id: svn://tug.org/texlive/trunk@35985 c570f23f-e606-0410-a88d-b1316a301751
Diffstat (limited to 'Master/texmf-dist/tex/latex/bankstatement/csv-camt.def')
-rw-r--r--Master/texmf-dist/tex/latex/bankstatement/csv-camt.def36
1 files changed, 36 insertions, 0 deletions
diff --git a/Master/texmf-dist/tex/latex/bankstatement/csv-camt.def b/Master/texmf-dist/tex/latex/bankstatement/csv-camt.def
new file mode 100644
index 00000000000..801569bcf85
--- /dev/null
+++ b/Master/texmf-dist/tex/latex/bankstatement/csv-camt.def
@@ -0,0 +1,36 @@
+%
+% definitions for the csv-mt940 format
+%
+% define the order of keys in your csv file
+% simply use arbitrary keys for unused fields
+\renewcommand*\STM@JK@dbkeys{Account,PostingDate,ValueDate,Type,Reference,CreditorIdentifier,MandateReference,EndToEndReference,AAA,BBB,CCC,Recipient,IBAN,BIC,Amount,Currency,Info}%
+% define usage of key values inside the used longtable
+% dates & mixed information & amount
+\renewcommand*\STM@JK@DTLforeach%
+{%
+ \DTLforeach{\STM@JK@dbname}%
+ {\postingdate=PostingDate,\valuedate=ValueDate,\type=Type,\reference=Reference,\credid=CreditorIdentifier,\mref=MandateReference,\eref=EndToEndReference,\recipient=Recipient,\iban=IBAN,\bic=BIC,\amount=Amount,\currency=Currency}%
+ {%
+ \parbox[t]{\widthof{ DD.MM.YYYY }}{\hspace{\STM@JK@parspace}\postingdate\\(\valuedate)} &%
+ \parbox[t]{\STM@JK@referencewidth}{\raggedright%
+ \DTLifstringeq{\type}{}{}{\type\\}%
+ \DTLifstringeq{\bic}{}{-}{\bic{}}\DTLifstringeq{\iban}{}{}{ / \iban}\\%
+ \DTLifstringeq{\recipient}{}{}{\recipient\\}%
+ \DTLifstringeq{\credid}{}{}{CRED: \credid\\}%
+ \DTLifstringeq{\mref}{}{}{MREF: \mref\\}%
+ \DTLifstringeq{\eref}{}{}{EREF: \eref\\}%
+ \reference} &%
+ \DTLifStartsWith{\amount}{-}{\textcolor{\STM@JK@negativecolor}{\amount}}{\amount}%
+ \DTLiflastrow{%
+ \ifthenelse{\equal{\STM@JK@closingbalance}{none}}%
+ {}%
+ {\\\midrule\\ & \STM@JK@closingbalancenamename & \DTLifStartsWith{\STM@JK@closingbalance}{-}{\textcolor{\STM@JK@negativecolor}{\STM@JK@closingbalance}}{\STM@JK@closingbalance}}%
+ \\\bottomrule%
+ }%
+ {\\ & & \\}%
+ }%
+}%
+% set separator of csv file
+\DTLsetseparator{;}%
+% does the csv file (not) have a header row? ;-)
+\renewcommand*\STM@JK@noheader{false}% \ No newline at end of file