X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FOrderItem.pm;h=e83b65bda7d61aba4e91a4d506e8d75c27a6337c;hb=53593baa211863fbf66540cf1bcc36c8fb37257f;hp=53ded975ea45710176b62889b0071a38eacd3e2e;hpb=3954d14b8a2d394b95bb8ecf8b0ed92c030fbd1d;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/OrderItem.pm b/SL/DB/MetaSetup/OrderItem.pm index 53ded975e..e83b65bda 100644 --- a/SL/DB/MetaSetup/OrderItem.pm +++ b/SL/DB/MetaSetup/OrderItem.pm @@ -4,17 +4,17 @@ package SL::DB::OrderItem; use strict; -use base qw(SL::DB::Object); +use parent qw(SL::DB::Object); __PACKAGE__->meta->table('orderitems'); __PACKAGE__->meta->columns( active_discount_source => { type => 'text', default => '', not_null => 1 }, active_price_source => { type => 'text', default => '', not_null => 1 }, - base_qty => { type => 'float', scale => 4 }, + base_qty => { type => 'float', precision => 4, scale => 4 }, cusordnumber => { type => 'text' }, description => { type => 'text' }, - discount => { type => 'float', scale => 4 }, + discount => { type => 'float', precision => 4, scale => 4 }, id => { type => 'integer', not_null => 1, sequence => 'orderitemsid' }, itime => { type => 'timestamp', default => 'now()' }, lastcost => { type => 'numeric', precision => 15, scale => 5 }, @@ -23,6 +23,7 @@ __PACKAGE__->meta->columns( marge_price_factor => { type => 'numeric', default => 1, precision => 15, scale => 5 }, marge_total => { type => 'numeric', precision => 15, scale => 5 }, mtime => { type => 'timestamp' }, + optional => { type => 'boolean', default => 'false' }, ordnumber => { type => 'text' }, parts_id => { type => 'integer' }, position => { type => 'integer', not_null => 1 }, @@ -30,11 +31,11 @@ __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 }, reqdate => { type => 'date' }, sellprice => { type => 'numeric', precision => 15, scale => 5 }, serialnumber => { type => 'text' }, - ship => { type => 'float', scale => 4 }, + ship => { type => 'float', precision => 4, scale => 4 }, subtotal => { type => 'boolean', default => 'false' }, trans_id => { type => 'integer' }, transdate => { type => 'text' },