X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/53593baa211863fbf66540cf1bcc36c8fb37257f..d8be5cc409de5b3bc34439599b1481201a5a1c2e:/SL/DB/MetaSetup/Part.pm diff --git a/SL/DB/MetaSetup/Part.pm b/SL/DB/MetaSetup/Part.pm index ef6ed69f5..eacff8fd2 100644 --- a/SL/DB/MetaSetup/Part.pm +++ b/SL/DB/MetaSetup/Part.pm @@ -29,8 +29,10 @@ __PACKAGE__->meta->columns( mtime => { type => 'timestamp' }, not_discountable => { type => 'boolean', default => 'false' }, notes => { type => 'text' }, - obsolete => { type => 'boolean', default => 'false' }, + obsolete => { type => 'boolean', default => 'false', not_null => 1 }, onhand => { type => 'numeric', default => '0', precision => 25, scale => 5 }, + order_locked => { type => 'boolean', default => 'false' }, + order_qty => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 }, part_type => { type => 'enum', check_in => [ 'part', 'service', 'assembly', 'assortment' ], db_type => 'part_type_enum', not_null => 1 }, partnumber => { type => 'text', not_null => 1 }, partsgroup_id => { type => 'integer' }, @@ -41,6 +43,7 @@ __PACKAGE__->meta->columns( sellprice => { type => 'numeric', precision => 15, scale => 5 }, shop => { type => 'boolean', default => 'false' }, stockable => { type => 'boolean', default => 'false' }, + tariff_code => { type => 'text' }, unit => { type => 'varchar', length => 20, not_null => 1 }, ve => { type => 'integer' }, warehouse_id => { type => 'integer' },