X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FDB%2FMetaSetup%2FInvoiceItem.pm;h=8a67022fcbaeca360c9028becec081739a2dfbe9;hb=97a6f6d623a9810e1d324f44a5f8bcd12294f5d3;hp=2da0d7f18a8b35b20e74603257d6813c00f97aa9;hpb=2ea07c13e111b88478827bf621d41df3eec19dac;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/InvoiceItem.pm b/SL/DB/MetaSetup/InvoiceItem.pm index 2da0d7f18..8a67022fc 100644 --- a/SL/DB/MetaSetup/InvoiceItem.pm +++ b/SL/DB/MetaSetup/InvoiceItem.pm @@ -11,13 +11,13 @@ __PACKAGE__->meta->table('invoice'); __PACKAGE__->meta->columns( active_discount_source => { type => 'text', default => '', not_null => 1 }, active_price_source => { type => 'text', default => '', not_null => 1 }, - allocated => { type => 'float', scale => 4 }, + allocated => { type => 'float', precision => 4, scale => 4 }, assemblyitem => { type => 'boolean', default => 'false' }, - base_qty => { type => 'float', scale => 4 }, + base_qty => { type => 'float', precision => 4, scale => 4 }, cusordnumber => { type => 'text' }, deliverydate => { type => 'date' }, description => { type => 'text' }, - discount => { type => 'float', scale => 4 }, + discount => { type => 'float', precision => 4, scale => 4 }, donumber => { type => 'text' }, fxsellprice => { type => 'numeric', precision => 15, scale => 5 }, id => { type => 'integer', not_null => 1, sequence => 'invoiceid' }, @@ -35,7 +35,7 @@ __PACKAGE__->meta->columns( price_factor_id => { type => 'integer' }, pricegroup_id => { type => 'integer' }, project_id => { type => 'integer' }, - qty => { type => 'float', scale => 4 }, + qty => { type => 'numeric', precision => 25, scale => 5 }, sellprice => { type => 'numeric', precision => 15, scale => 5 }, serialnumber => { type => 'text' }, subtotal => { type => 'boolean', default => 'false' },