X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FPart.pm;h=556ff8e30336198e115e97bcef782fb69e6e1e69;hb=b8ee6b6ed46e55095b955ee1800b8a4b8d8ccc3f;hp=b5e25772c42648e86932396d7189f1b1b7ca06cb;hpb=3eb3d1b144adb92e62de08e67dc6ff3d39bf7483;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Part.pm b/SL/DB/MetaSetup/Part.pm index b5e25772c..556ff8e30 100644 --- a/SL/DB/MetaSetup/Part.pm +++ b/SL/DB/MetaSetup/Part.pm @@ -19,35 +19,35 @@ __PACKAGE__->meta->columns( ean => { type => 'text' }, expense_accno_id => { type => 'integer' }, formel => { type => 'text' }, - gv => { type => 'numeric', precision => 5, scale => 15 }, + gv => { type => 'numeric', precision => 15, scale => 5 }, has_sernumber => { type => 'boolean', default => 'false' }, id => { type => 'integer', not_null => 1, sequence => 'id' }, image => { type => 'text' }, income_accno_id => { type => 'integer' }, inventory_accno_id => { type => 'integer' }, itime => { type => 'timestamp', default => 'now()' }, - lastcost => { type => 'numeric', precision => 5, scale => 15 }, - listprice => { type => 'numeric', precision => 5, scale => 15 }, + lastcost => { type => 'numeric', precision => 15, scale => 5 }, + listprice => { type => 'numeric', precision => 15, scale => 5 }, makemodel => { type => 'boolean', default => 'false' }, microfiche => { type => 'text' }, mtime => { type => 'timestamp' }, not_discountable => { type => 'boolean', default => 'false' }, notes => { type => 'text' }, obsolete => { type => 'boolean', default => 'false' }, - onhand => { type => 'numeric', default => '0', precision => 5, scale => 25 }, + onhand => { type => 'numeric', default => '0', precision => 25, scale => 5 }, partnumber => { type => 'text', not_null => 1 }, partsgroup_id => { type => 'integer' }, payment_id => { type => 'integer' }, price_factor_id => { type => 'integer' }, priceupdate => { type => 'date', default => 'now' }, - rop => { type => 'float', precision => 4 }, - sellprice => { type => 'numeric', precision => 5, scale => 15 }, + rop => { type => 'float', scale => 4 }, + sellprice => { type => 'numeric', precision => 15, scale => 5 }, shop => { type => 'boolean', default => 'false' }, stockable => { type => 'boolean', default => 'false' }, unit => { type => 'varchar', length => 20, not_null => 1 }, ve => { type => 'integer' }, warehouse_id => { type => 'integer' }, - weight => { type => 'float', precision => 4 }, + weight => { type => 'float', scale => 4 }, ); __PACKAGE__->meta->primary_key_columns([ 'id' ]);