X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/fc893a6d57c085228f56e272f6b144c3d6ea5393..a89af9c2a38f19bc2834a2e09a286ff36c9ef3d7:/SL/DB/MetaSetup/Part.pm diff --git a/SL/DB/MetaSetup/Part.pm b/SL/DB/MetaSetup/Part.pm index c54a8cfc7..7e9eedcfa 100644 --- a/SL/DB/MetaSetup/Part.pm +++ b/SL/DB/MetaSetup/Part.pm @@ -9,7 +9,6 @@ use parent qw(SL::DB::Object); __PACKAGE__->meta->table('parts'); __PACKAGE__->meta->columns( - assembly => { type => 'boolean', default => 'false' }, bin_id => { type => 'integer' }, bom => { type => 'boolean', default => 'false' }, buchungsgruppen_id => { type => 'integer' }, @@ -34,6 +33,7 @@ __PACKAGE__->meta->columns( notes => { type => 'text' }, obsolete => { type => 'boolean', default => 'false' }, onhand => { type => 'numeric', default => '0', precision => 25, 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' }, payment_id => { type => 'integer' }, @@ -66,17 +66,17 @@ __PACKAGE__->meta->foreign_keys( key_columns => { buchungsgruppen_id => 'id' }, }, - expense_accno => { + expense_account => { class => 'SL::DB::Chart', key_columns => { expense_accno_id => 'id' }, }, - income_accno => { + income_account => { class => 'SL::DB::Chart', key_columns => { income_accno_id => 'id' }, }, - inventory_accno => { + inventory_account => { class => 'SL::DB::Chart', key_columns => { inventory_accno_id => 'id' }, },