-
Notifications
You must be signed in to change notification settings - Fork 5
/
esr_filemaker.xslt
80 lines (78 loc) · 4.35 KB
/
esr_filemaker.xslt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:camt="urn:iso:std:iso:20022:tech:xsd:camt.054.001.04" exclude-result-prefixes="camt">
<xsl:template match="/">
<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
<DATABASE DATEFORMAT="yyyy-mm-dd" NAME="camt.054-ESR-ASR" />
<METADATA>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Teilnehmernummer" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Referenznummer" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Transaktionsart" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Transaktionswaehrung" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Transaktionsbetrag" TYPE="NUMBER"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Verarbeitungsdatum" TYPE="DATE"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Gutschriftdatum" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Rejectcode" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Taxen Transaktionwaehrung" TYPE="NUMBER"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Taxen Transaktionbetrag" TYPE="NUMBER"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Name Debitor" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Buchungswaehrung" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Buchungbetrag" TYPE="NUMBER"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Taxen Buchungwaehrung" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Taxen Buchungbetrag" TYPE="NUMBER"/>
</METADATA>
<RESULTSET>
<xsl:for-each select="camt:Document/camt:BkToCstmrDbtCdtNtfctn/camt:Ntfctn/camt:Ntry">
<xsl:for-each select="camt:NtryDtls/camt:TxDtls">
<ROW>
<COL name="Teilnehmernummer">
<DATA><xsl:value-of select="normalize-space(../../camt:NtryRef)"/></DATA>
</COL>
<COL name="Referenznummer">
<DATA><xsl:value-of select="normalize-space(camt:RmtInf/camt:Strd/camt:CdtrRefInf/camt:Ref)"/></DATA>
</COL>
<COL name="Transaktionsart">
<DATA><xsl:value-of select="normalize-space(camt:CdtDbtInd)"/></DATA>
</COL>
<COL name="Transaktionswaehrung">
<DATA><xsl:value-of select="normalize-space(camt:Amt/@Ccy)"/></DATA>
</COL>
<COL name="Transaktionsbetrag">
<DATA><xsl:value-of select="normalize-space(camt:Amt)"/></DATA>
</COL>
<COL name="Verarbeitungsdatum">
<DATA><xsl:value-of select="normalize-space(../../camt:BookgDt/camt:Dt)"/></DATA>
</COL>
<COL name="Gutschriftdatum">
<DATA><xsl:value-of select="normalize-space(../../camt:ValDt/camt:Dt)"/></DATA>
</COL>
<COL name="Rejectcode">
<DATA><xsl:value-of select="normalize-space(camt:RmtInf/camt:Strd/camt:AddtlRmtInf)"/></DATA>
</COL>
<COL name="Taxen Transaktionswaehrung">
<DATA><xsl:value-of select="normalize-space(camt:Chrgs/camt:Rcrd/camt:Amt/@Ccy)"/></DATA>
</COL>
<COL name="Taxen Transaktionsbetrag">
<DATA><xsl:value-of select="normalize-space(camt:Chrgs/camt:Rcrd/camt:Amt)"/></DATA>
</COL>
<COL name="Name Debitor">
<DATA><xsl:value-of select="normalize-space(camt:RltdPties/camt:Dbtr/camt:Nm)"/></DATA>
</COL>
<COL name="Buchungswaehrung">
<DATA><xsl:value-of select="normalize-space(../../camt:Amt/@Ccy)"/></DATA>
</COL>
<COL name="Buchungstotal">
<DATA><xsl:value-of select="normalize-space(../../camt:Amt)"/></DATA>
</COL>
<COL name="Taxen Buchungswaehrung">
<DATA><xsl:value-of select="normalize-space(../../camt:Chrgs/camt:TtlChrgsAndTaxAmt/@Ccy)"/></DATA>
</COL>
<COL name="Taxen Buchungsbetrag">
<DATA><xsl:value-of select="normalize-space(../../camt:Chrgs/camt:TtlChrgsAndTaxAmt)"/></DATA>
</COL>
</ROW>
</xsl:for-each>
</xsl:for-each>
</RESULTSET>
</FMPXMLRESULT>
</xsl:template>
</xsl:stylesheet>