X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FInvoiceItem.pm;h=7cd853ec23e243941bdf7a6a955078b9a806a970;hb=1f592a0f4f88893b5c2cb29b2d10e2d07b444ac0;hp=1d73b7357bc3726630fba188be4cfce1176f6c54;hpb=bb7e2e85d50544c6b72eb40d57f513eeacf578d5;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/InvoiceItem.pm b/SL/DB/MetaSetup/InvoiceItem.pm index 1d73b7357..7cd853ec2 100644 --- a/SL/DB/MetaSetup/InvoiceItem.pm +++ b/SL/DB/MetaSetup/InvoiceItem.pm @@ -9,31 +9,31 @@ use base qw(SL::DB::Object); __PACKAGE__->meta->table('invoice'); __PACKAGE__->meta->columns( - allocated => { type => 'float', precision => 4 }, + allocated => { type => 'float', scale => 4 }, assemblyitem => { type => 'boolean', default => 'false' }, - base_qty => { type => 'float', precision => 4 }, + base_qty => { type => 'float', scale => 4 }, cusordnumber => { type => 'text' }, deliverydate => { type => 'date' }, description => { type => 'text' }, - discount => { type => 'float', precision => 4 }, - fxsellprice => { type => 'numeric', precision => 5, scale => 15 }, + discount => { type => 'float', scale => 4 }, donumber => { type => 'text' }, + fxsellprice => { type => 'numeric', precision => 15, scale => 5 }, id => { type => 'integer', not_null => 1, sequence => 'invoiceid' }, itime => { type => 'timestamp', default => 'now()' }, - lastcost => { type => 'numeric', precision => 5, scale => 15 }, + lastcost => { type => 'numeric', precision => 15, scale => 5 }, longdescription => { type => 'text' }, - marge_percent => { type => 'numeric', precision => 5, scale => 15 }, - marge_price_factor => { type => 'numeric', default => 1, precision => 5, scale => 15 }, - marge_total => { type => 'numeric', precision => 5, scale => 15 }, + marge_percent => { type => 'numeric', precision => 15, scale => 5 }, + marge_price_factor => { type => 'numeric', default => 1, precision => 15, scale => 5 }, + marge_total => { type => 'numeric', precision => 15, scale => 5 }, mtime => { type => 'timestamp' }, ordnumber => { type => 'text' }, parts_id => { type => 'integer' }, - price_factor => { type => 'numeric', default => 1, precision => 5, scale => 15 }, + price_factor => { type => 'numeric', default => 1, precision => 15, scale => 5 }, price_factor_id => { type => 'integer' }, pricegroup_id => { type => 'integer' }, project_id => { type => 'integer' }, - qty => { type => 'float', precision => 4 }, - sellprice => { type => 'numeric', precision => 5, scale => 15 }, + qty => { type => 'float', scale => 4 }, + sellprice => { type => 'numeric', precision => 15, scale => 5 }, serialnumber => { type => 'text' }, subtotal => { type => 'boolean', default => 'false' }, trans_id => { type => 'integer' },