X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/6822ef0577c60a43d5daf6041936ac962d78bb0b..f228ac9bf50df653eeb8efffaaa485fb945f50cb:/SL/DB/MetaSetup/OrderItem.pm diff --git a/SL/DB/MetaSetup/OrderItem.pm b/SL/DB/MetaSetup/OrderItem.pm index 9de8b7e79..16478b149 100644 --- a/SL/DB/MetaSetup/OrderItem.pm +++ b/SL/DB/MetaSetup/OrderItem.pm @@ -11,10 +11,10 @@ __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 }, @@ -30,11 +30,11 @@ __PACKAGE__->meta->columns( price_factor_id => { type => 'integer' }, pricegroup_id => { type => 'integer' }, project_id => { type => 'integer' }, - qty => { type => 'float', scale => 4 }, + qty => { type => 'float', precision => 4, scale => 4 }, 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' },