Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 18931692

Von Niclas Zimmermann vor fast 12 Jahren hinzugefügt

  • ID 18931692ebe56ef5a2afa471182d3845914979c2
  • Vorgänger 233c00b1
  • Nachfolger 32ddb71c

Constraints für tax und taxkeys

Dieser Commit fügt für die Tabellen tax und taxkeys folgende
Constraints hinzu:

Tabelle tax:

1.chart_id hat jetzt einen Fremdschlüssel auf chart.id.
2.rate darf nicht mehr NULL sein und hat DEFAULT-Wert 0.
3.taxkey darf nicht mehr NULL sein.
4.taxdescription darf nicht mehr NULL sein.

Tabelle taxkeys:

1.chart_id darf nicht mehr NULL sein, hat jetzt einen Fremdschlüssel
auf chart.id.
2.tax_id darf nicht mehr NULL sein.
3.taxkey_id darf nicht mehr NULL sein.
4.startdate darf nicht mehr NULL sein.
5.chart_id und startdate müssen eindeutig sein.

Unterschiede anzeigen:

locale/en/all
20 20
  '*) Since version 2.7 these parameters ares set in the client database and not in the lx-erp.conf / lx_office.conf file, details in chapter:' => '',
21 21
  '*/'                          => '',
22 22
  '---please select---'         => '',
23
  '. Automatically generated.'  => '',
23 24
  '...after loggin in'          => '',
24 25
  '...done'                     => '',
25 26
  '...on the TODO list'         => '',
27
  '0% tax with taxkey'          => '',
26 28
  '1. Quarter'                  => '',
27 29
  '2. Quarter'                  => '',
28 30
  '3. Quarter'                  => '',
......
1985 1987
  'There are #1 more open invoices from this vendor with other currencies.' => '',
1986 1988
  'There are #1 unfinished follow-ups of which #2 are due.' => '',
1987 1989
  'There are bookings to the account 3803 after 01.01.2007. If you didn\'t change this account manually to 19% the bookings are probably incorrect.' => '',
1990
  'There are entries in tax where taxkey is NULL.' => '',
1988 1991
  'There are four tax zones.'   => '',
1992
  'There are invalid taxnumbers in use.' => '',
1993
  'There are no entries in the background job history.' => '',
1989 1994
  'There are no items in stock.' => '',
1990 1995
  'There are no items on your TODO list at the moment.' => '',
1991 1996
  'There are still entries in the database for which no unit has been assigned.' => '',
1992 1997
  'There are still transfers not matching the qty of the delivery order. Stock operations can not be changed later. Do you really want to proceed?' => '',
1993 1998
  'There are usually three ways to install Perl modules.' => '',
1994 1999
  'There is already a taxkey 0 with tax rate not 0.' => '',
2000
  'There is an inconsistancy in your database.' => '',
1995 2001
  'There is at least one sales or purchase invoice for which kivitendo recorded an inventory transaction with taxkeys even though no tax was recorded.' => '',
1996 2002
  'There is at least one transaction for which the user has chosen a logically wrong taxkey.' => '',
1997 2003
  'There is not enough available of \'#1\' at warehouse \'#2\', bin \'#3\', #4, #5, for the transfer of #6.' => '',

Auch abrufbar als: Unified diff