Revision cc872430
Von Moritz Bunkus vor mehr als 10 Jahren hinzugefügt
| SL/DB/MetaSetup/DeliveryOrder.pm | ||
|---|---|---|
| 35 | 35 |
shipto_id => { type => 'integer' },
|
| 36 | 36 |
shipvia => { type => 'text' },
|
| 37 | 37 |
taxincluded => { type => 'boolean' },
|
| 38 |
taxzone_id => { type => 'integer' },
|
|
| 38 |
taxzone_id => { type => 'integer', not_null => 1 },
|
|
| 39 | 39 |
terms => { type => 'integer' },
|
| 40 | 40 |
transaction_description => { type => 'text' },
|
| 41 | 41 |
transdate => { type => 'date', default => 'now()' },
|
| ... | ... | |
| 97 | 97 |
key_columns => { shipto_id => 'shipto_id' },
|
| 98 | 98 |
}, |
| 99 | 99 |
|
| 100 |
taxzone => {
|
|
| 101 |
class => 'SL::DB::TaxZone', |
|
| 102 |
key_columns => { taxzone_id => 'id' },
|
|
| 103 |
}, |
|
| 104 |
|
|
| 100 | 105 |
vendor => {
|
| 101 | 106 |
class => 'SL::DB::Vendor', |
| 102 | 107 |
key_columns => { vendor_id => 'id' },
|
Auch abrufbar als: Unified diff
Bearb. Buchungsgruppen: Spalte taxzone_id in oe/delivery_orders konvertieren
1. Werte 0 und NULL durch neue ID für »Inland« ersetzen (oe,
delivery_orders, ar, ap)
2. Spalte taxzone_id NOT NULL setzen (oe, delivery_orders, ar, ap)
3. Fremdschlüssel auf Tabelle tax_zones setzen (oe, delivery_orders)