Revision e0d47e23
Von Udo Spallek vor etwa 18 Jahren hinzugefügt
| SL/CA.pm | ||
|---|---|---|
|
c.pos_eur,
|
||
|
c.valid_from,
|
||
|
c.datevautomatik,
|
||
|
( SELECT comma(taxkey_id)
|
||
|
FROM taxkeys tk
|
||
|
WHERE tk.chart_id = c.id
|
||
|
AND c.taxkey_id = tk.taxkey_id
|
||
|
ORDER BY c.id
|
||
|
) AS taxkey_id,
|
||
|
-- ( SELECT comma(taxkey_id)
|
||
|
-- FROM taxkeys tk
|
||
|
-- WHERE tk.chart_id = c.id
|
||
|
-- AND c.taxkey_id = tk.taxkey_id
|
||
|
-- ORDER BY c.id
|
||
|
-- ) AS taxkey_id,
|
||
|
|
||
|
( SELECT comma(taxkey)
|
||
|
FROM tax tx
|
||
|
WHERE tx.id in (
|
||
|
SELECT tk.tax_id from taxkeys tk
|
||
|
WHERE tk.chart_id = c.id
|
||
|
)
|
||
|
ORDER BY c.accno
|
||
|
) AS taxkey,
|
||
|
|
||
|
( SELECT comma(taxdescription)
|
||
|
FROM tax tx
|
||
|
WHERE tx.id in (
|
||
|
SELECT tk.tax_id from taxkeys tk
|
||
|
WHERE tk.chart_id = (
|
||
|
SELECT id from chart
|
||
|
WHERE chart.accno='0027' -- Beispielkonto aus dem SKR03
|
||
|
)
|
||
|
WHERE tk.chart_id = c.id
|
||
|
)
|
||
|
ORDER BY c.accno
|
||
|
) AS taxdescription,
|
||
|
|
||
|
( SELECT comma(taxnumber)
|
||
|
FROM tax tx
|
||
|
WHERE tx.id in (
|
||
|
SELECT tk.tax_id from taxkeys tk
|
||
|
WHERE tk.chart_id = c.id
|
||
|
)
|
||
|
ORDER BY c.accno
|
||
|
) AS taxaccount,
|
||
|
|
||
|
( SELECT comma(tk.pos_ustva)
|
||
|
FROM taxkeys tk
|
||
| bin/mozilla/am.pl | ||
|---|---|---|
|
$ca->{link} .= qq|[| . $link . qq|] |;
|
||
|
}
|
||
|
|
||
|
$ca->{startdate} =~ s/,/<br>/og;
|
||
|
$ca->{tk_ustva} =~ s/,/<br>/og;
|
||
|
|
||
|
$ca->{taxkey_id} =~ s/,/<br>/og;
|
||
|
$ca->{taxdescription} =~ s/,/<br>/og;
|
||
|
|
||
|
$ca->{startdate} =~ s/,/<br>/og;
|
||
|
$ca->{tk_ustva} =~ s/,/<br>/og;
|
||
|
$ca->{taxkey} =~ s/,/<br>/og;
|
||
|
$ca->{taxaccount} =~ s/,/<br>/og;
|
||
|
$ca->{taxdescription} =~ s/,/<br>/og;
|
||
|
$ca->{datevautomatik} = ($ca->{datevautomatik}) ? $locale->text('On'):q{};
|
||
|
|
||
|
$ca->{category} = ($ca->{category} eq 'A') ? $locale->text('Account Category A')
|
||
| locale/de/all | ||
|---|---|---|
|
'Fee' => 'Geb?hr',
|
||
|
'File locked!' => 'Datei gesperrt!',
|
||
|
'Folgekonto' => 'Folgekonto',
|
||
|
'Following Account' => 'Folgekonto',
|
||
|
'Following Account' => 'Folge-<br />konto',
|
||
|
'For each unit there\'s either no or exactly one base unit. If you chose a base unit then you also have to chose a factor. That way the new unit will be defined as a multiple of the base unit. The base unit must be the "smaller" one. A factor may not be less than 1. Therefore you may define "kg" with the base unit "g" and a factor of "1", but not the other way round.' => 'Einheiten haben entweder keine oder genau eine Basiseinheit, von der sie ein Vielfaches sind. Wenn Sie eine Basiseinheit auswählen, dann müssen Sie auch einen Faktor eingeben. Sie müssen Einheiten als ein Vielfaches einer kleineren Einheit eingeben. So ist die Definition von "kg" mit der Basiseinheit "g" und dem Faktor 1000 zulässig, die Definition von "g" mit der Basiseinheit "kg" und dem Faktor "0,001" hingegen nicht.',
|
||
|
'Foreign Exchange Gain' => 'Wechselkursertr?ge',
|
||
|
'Foreign Exchange Loss' => 'Wechselkursaufwendungen',
|
||
| ... | ... | |
|
'Tax number' => 'Steuernummer',
|
||
|
'Tax paid' => 'Vorsteuer',
|
||
|
'Taxable' => 'Steuerpflichtig',
|
||
|
'Taxaccount' => 'Steuer Konto',
|
||
|
'Taxation' => 'Versteuerungs Verfahren',
|
||
|
'Taxdescription' => 'Beschreibung',
|
||
|
'Taxdescription' => 'Steuerkonto<br />Beschreibung',
|
||
|
'Taxkey' => 'Steuerschl?ssel',
|
||
|
'Tel' => 'Tel',
|
||
|
'Tel.' => 'Telefon',
|
||
| templates/webpages/am/list_accounts_de.html | ||
|---|---|---|
|
|
||
|
<table border="0" cellpadding="3" cellspacing="3" width="100%">
|
||
|
<tr>
|
||
|
<th class="listtop" colspan="12"><TMPL_VAR title ESCAPE=HTML></th>
|
||
|
<th class="listtop" colspan="14"><TMPL_VAR title ESCAPE=HTML></th>
|
||
|
</tr>
|
||
|
<tr height=5></tr>
|
||
|
<tr class=listheading>
|
||
|
<tr height="5"></tr>
|
||
|
<tr class="listheading">
|
||
|
<th colspan="3"><b>Kontonummer</b></th>
|
||
|
<th colspan="8"><b>Beschreibung</b></a></th>
|
||
|
<th colspan="9"><b>Beschreibung</b></a></th>
|
||
|
<th rowspan="3">Haben</th>
|
||
|
<th rowspan="3">Soll</th>
|
||
|
</tr>
|
||
|
<tr class=listheading>
|
||
|
<tr class="listheading">
|
||
|
<th colspan="3"><b>Kontenart</b></th>
|
||
|
|
||
|
<th colspan="8">Verkn?pfungen</th>
|
||
|
<th colspan="9">Verkn?pfungen</th>
|
||
|
</tr>
|
||
|
<tr class=listheading>
|
||
|
<tr class="listheading">
|
||
|
<th>Steuerschl?ssel</th>
|
||
|
<th>Beschreibung</th>
|
||
|
<th>Steuer Konto</th>
|
||
|
<th>Steuerkonto<br />Beschreibung</th>
|
||
|
<th>G?ltig ab</th>
|
||
|
<th>tk_ustva</th>
|
||
|
<th>UStVA</th>
|
||
| ... | ... | |
|
<th>Bilanz</th>
|
||
|
<th>E/?R</th>
|
||
|
<th>Datev</th>
|
||
|
<th>Folge-<br />konto</th>
|
||
|
<th>G?ltig ab</th>
|
||
|
<th>Folgekonto</th>
|
||
|
</tr>
|
||
|
|
||
|
<TMPL_LOOP CA>
|
||
|
|
||
|
<TMPL_IF heading>
|
||
|
|
||
|
<tr class=listheading>
|
||
|
<td colspan="3" abbr="Kontonummer">
|
||
|
<tr class="listheading">
|
||
|
<td colspan="3">
|
||
|
<a href=<TMPL_VAR link_edit_account> >
|
||
|
<TMPL_VAR accno>
|
||
|
</a>
|
||
|
</td>
|
||
|
<td colspan="6">
|
||
|
<a href=<TMPL_VAR description> >
|
||
|
<td colspan="9">
|
||
|
<a href="<TMPL_VAR description>" >
|
||
|
<TMPL_VAR accno>
|
||
|
</a>
|
||
|
</td>
|
||
| ... | ... | |
|
|
||
|
|
||
|
<TMPL_IF __odd__>
|
||
|
<tr valign=top class=listrow1>
|
||
|
<tr valign="top" class="listrow1">
|
||
|
<TMPL_ELSE>
|
||
|
|
||
|
<tr valign=top class=listrow0>
|
||
|
<tr valign="top" class="listrow0">
|
||
|
</TMPL_IF>
|
||
|
|
||
|
<td colspan="3" abbr="Kontonummer"><b>
|
||
|
<td colspan="3"><b>
|
||
|
<a href="<TMPL_VAR link_edit_account>" ><TMPL_VAR accno></a>
|
||
|
</td>
|
||
|
<td colspan="8"><b><TMPL_VAR description ESCAPE=HTML> </b></td>
|
||
|
<td colspan="9"><b><TMPL_VAR description ESCAPE=HTML> </b></td>
|
||
|
<td rowspan="3" align=right><TMPL_VAR debit> </td>
|
||
|
<td rowspan="3" align=right><TMPL_VAR credit> </td>
|
||
|
|
||
|
</tr>
|
||
|
|
||
|
<TMPL_IF __odd__>
|
||
|
<tr valign=top class=listrow1>
|
||
|
<tr valign="top" class="listrow1">
|
||
|
<TMPL_ELSE>
|
||
|
<tr valign=top class=listrow0>
|
||
|
<tr valign="top" class="listrow0">
|
||
|
</TMPL_IF>
|
||
|
|
||
|
<td colspan="3"><b><TMPL_VAR category ESCAPE=HTML> </b></td>
|
||
|
<td colspan="8"><TMPL_VAR link> </td>
|
||
|
<td colspan="9"><TMPL_VAR link> </td>
|
||
|
</tr>
|
||
|
|
||
|
<TMPL_IF __odd__>
|
||
|
<tr valign=top class=listrow1>
|
||
|
<tr class="listrow1">
|
||
|
<TMPL_ELSE>
|
||
|
<tr valign=top class=listrow0>
|
||
|
<tr class="listrow0">
|
||
|
</TMPL_IF>
|
||
|
|
||
|
<td><TMPL_VAR taxkey_id > </td>
|
||
|
<td nowrap="nowrap"><TMPL_VAR taxdescription > </td>
|
||
|
<td><TMPL_VAR startdate > </td>
|
||
|
<td><TMPL_VAR tk_ustva > </td>
|
||
|
<td valign="top"><TMPL_VAR taxkey > </td>
|
||
|
<td valign="top"><TMPL_VAR taxaccount > </td>
|
||
|
<td valign="top"><TMPL_VAR taxdescription > </td>
|
||
|
<td valign="top"><TMPL_VAR startdate > </td>
|
||
|
<td valign="top"><TMPL_VAR tk_ustva > </td>
|
||
|
|
||
|
<td><TMPL_VAR pos_ustva ESCAPE=HTML> </td>
|
||
|
<td><TMPL_VAR pos_bwa ESCAPE=HTML> </td>
|
||
|
<td><TMPL_VAR pos_bilanz ESCAPE=HTML> </td>
|
||
|
<td><TMPL_VAR pos_eur ESCAPE=HTML> </td>
|
||
|
<td><TMPL_VAR datevautomatik ESCAPE=HTML> </td>
|
||
|
<td><TMPL_VAR valid_from ESCAPE=HTML> </td>
|
||
|
<td><TMPL_VAR new_account ESCAPE=HTML> </td>
|
||
|
<td valign="center"><TMPL_VAR pos_ustva ESCAPE=HTML> </td>
|
||
|
<td valign="center"><TMPL_VAR pos_bwa ESCAPE=HTML> </td>
|
||
|
<td valign="center"><TMPL_VAR pos_bilanz ESCAPE=HTML> </td>
|
||
|
<td valign="center"><TMPL_VAR pos_eur ESCAPE=HTML> </td>
|
||
|
<td valign="center"><TMPL_VAR datevautomatik ESCAPE=HTML> </td>
|
||
|
<td valign="center"><TMPL_VAR new_account ESCAPE=HTML> </td>
|
||
|
<td valign="center"><TMPL_VAR valid_from ESCAPE=HTML> </td>
|
||
|
|
||
|
</tr>
|
||
|
<tr>
|
||
|
<td colspan="14"> </td>
|
||
|
</tr>
|
||
|
</TMPL_IF>
|
||
|
|
||
|
|
||
|
</TMPL_LOOP>
|
||
|
|
||
|
<tr>
|
||
|
<td colspan=14><hr size=3 noshade></td>
|
||
|
<td colspan="14"><hr size="3" noshade="noshade"></td>
|
||
|
</tr>
|
||
|
</table>
|
||
|
|
||
| templates/webpages/am/list_accounts_master.html | ||
|---|---|---|
|
|
||
|
<table border="0" cellpadding="3" cellspacing="3" width="100%">
|
||
|
<tr>
|
||
|
<th class="listtop" colspan="12"><TMPL_VAR title ESCAPE=HTML></th>
|
||
|
<th class="listtop" colspan="14"><TMPL_VAR title ESCAPE=HTML></th>
|
||
|
</tr>
|
||
|
<tr height=5></tr>
|
||
|
<tr class=listheading>
|
||
|
<tr height="5"></tr>
|
||
|
<tr class="listheading">
|
||
|
<th colspan="3"><b><translate>Account Number</translate></b></th>
|
||
|
<th colspan="8"><b><translate>Description</translate></b></a></th>
|
||
|
<th colspan="9"><b><translate>Description</translate></b></a></th>
|
||
|
<th rowspan="3"><translate>Credit</translate></th>
|
||
|
<th rowspan="3"><translate>Debit</translate></th>
|
||
|
</tr>
|
||
|
<tr class=listheading>
|
||
|
<tr class="listheading">
|
||
|
<th colspan="3"><b><translate>category</translate></b></th>
|
||
|
|
||
|
<th colspan="8"><translate>Link</translate></th>
|
||
|
<th colspan="9"><translate>Link</translate></th>
|
||
|
</tr>
|
||
|
<tr class=listheading>
|
||
|
<tr class="listheading">
|
||
|
<th><translate>Taxkey</translate></th>
|
||
|
<th><translate>Taxaccount</translate></th>
|
||
|
<th><translate>Taxdescription</translate></th>
|
||
|
<th><translate>Startdate</translate></th>
|
||
|
<th><translate>tk_ustva</translate></th>
|
||
| ... | ... | |
|
<th><translate>pos_bilanz</translate></th>
|
||
|
<th><translate>pos_eur</translate></th>
|
||
|
<th><translate>Datev</translate></th>
|
||
|
<th><translate>valid_from</translate></th>
|
||
|
<th><translate>Following Account</translate></th>
|
||
|
<th><translate>valid_from</translate></th>
|
||
|
</tr>
|
||
|
|
||
|
<TMPL_LOOP CA>
|
||
|
|
||
|
<TMPL_IF heading>
|
||
|
|
||
|
<tr class=listheading>
|
||
|
<td colspan="3" abbr="<translate>Account Number</translate>">
|
||
|
<tr class="listheading">
|
||
|
<td colspan="3">
|
||
|
<a href=<TMPL_VAR link_edit_account> >
|
||
|
<TMPL_VAR accno>
|
||
|
</a>
|
||
|
</td>
|
||
|
<td colspan="6">
|
||
|
<a href=<TMPL_VAR description> >
|
||
|
<td colspan="9">
|
||
|
<a href="<TMPL_VAR description>" >
|
||
|
<TMPL_VAR accno>
|
||
|
</a>
|
||
|
</td>
|
||
| ... | ... | |
|
|
||
|
|
||
|
<TMPL_IF __odd__>
|
||
|
<tr valign=top class=listrow1>
|
||
|
<tr valign="top" class="listrow1">
|
||
|
<TMPL_ELSE>
|
||
|
|
||
|
<tr valign=top class=listrow0>
|
||
|
<tr valign="top" class="listrow0">
|
||
|
</TMPL_IF>
|
||
|
|
||
|
<td colspan="3" abbr="<translate>Account Number</translate>"><b>
|
||
|
<td colspan="3"><b>
|
||
|
<a href="<TMPL_VAR link_edit_account>" ><TMPL_VAR accno></a>
|
||
|
</td>
|
||
|
<td colspan="8"><b><TMPL_VAR description ESCAPE=HTML> </b></td>
|
||
|
<td colspan="9"><b><TMPL_VAR description ESCAPE=HTML> </b></td>
|
||
|
<td rowspan="3" align=right><TMPL_VAR debit> </td>
|
||
|
<td rowspan="3" align=right><TMPL_VAR credit> </td>
|
||
|
|
||
|
</tr>
|
||
|
|
||
|
<TMPL_IF __odd__>
|
||
|
<tr valign=top class=listrow1>
|
||
|
<tr valign="top" class="listrow1">
|
||
|
<TMPL_ELSE>
|
||
|
<tr valign=top class=listrow0>
|
||
|
<tr valign="top" class="listrow0">
|
||
|
</TMPL_IF>
|
||
|
|
||
|
<td colspan="3"><b><TMPL_VAR category ESCAPE=HTML> </b></td>
|
||
|
<td colspan="8"><TMPL_VAR link> </td>
|
||
|
<td colspan="9"><TMPL_VAR link> </td>
|
||
|
</tr>
|
||
|
|
||
|
<TMPL_IF __odd__>
|
||
|
<tr valign=top class=listrow1>
|
||
|
<tr class="listrow1">
|
||
|
<TMPL_ELSE>
|
||
|
<tr valign=top class=listrow0>
|
||
|
<tr class="listrow0">
|
||
|
</TMPL_IF>
|
||
|
|
||
|
<td><TMPL_VAR taxkey_id > </td>
|
||
|
<td nowrap="nowrap"><TMPL_VAR taxdescription > </td>
|
||
|
<td><TMPL_VAR startdate > </td>
|
||
|
<td><TMPL_VAR tk_ustva > </td>
|
||
|
<td valign="top"><TMPL_VAR taxkey > </td>
|
||
|
<td valign="top"><TMPL_VAR taxaccount > </td>
|
||
|
<td valign="top"><TMPL_VAR taxdescription > </td>
|
||
|
<td valign="top"><TMPL_VAR startdate > </td>
|
||
|
<td valign="top"><TMPL_VAR tk_ustva > </td>
|
||
|
|
||
|
<td><TMPL_VAR pos_ustva ESCAPE=HTML> </td>
|
||
|
<td><TMPL_VAR pos_bwa ESCAPE=HTML> </td>
|
||
|
<td><TMPL_VAR pos_bilanz ESCAPE=HTML> </td>
|
||
|
<td><TMPL_VAR pos_eur ESCAPE=HTML> </td>
|
||
|
<td><TMPL_VAR datevautomatik ESCAPE=HTML> </td>
|
||
|
<td><TMPL_VAR valid_from ESCAPE=HTML> </td>
|
||
|
<td><TMPL_VAR new_account ESCAPE=HTML> </td>
|
||
|
<td valign="center"><TMPL_VAR pos_ustva ESCAPE=HTML> </td>
|
||
|
<td valign="center"><TMPL_VAR pos_bwa ESCAPE=HTML> </td>
|
||
|
<td valign="center"><TMPL_VAR pos_bilanz ESCAPE=HTML> </td>
|
||
|
<td valign="center"><TMPL_VAR pos_eur ESCAPE=HTML> </td>
|
||
|
<td valign="center"><TMPL_VAR datevautomatik ESCAPE=HTML> </td>
|
||
|
<td valign="center"><TMPL_VAR new_account ESCAPE=HTML> </td>
|
||
|
<td valign="center"><TMPL_VAR valid_from ESCAPE=HTML> </td>
|
||
|
|
||
|
</tr>
|
||
|
<tr>
|
||
|
<td colspan="14"> </td>
|
||
|
</tr>
|
||
|
</TMPL_IF>
|
||
|
|
||
|
|
||
|
</TMPL_LOOP>
|
||
|
|
||
|
<tr>
|
||
|
<td colspan=14><hr size=3 noshade></td>
|
||
|
<td colspan="14"><hr size="3" noshade="noshade"></td>
|
||
|
</tr>
|
||
|
</table>
|
||
|
|
||
Auch abrufbar als: Unified diff
Ueberarbeitet r1807: System-> Kontenuebersicht-> Konten anzeigen.
Bitte testen.