X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/4f15333b8cc0ae1b0b4089adc2e516ba002b298b..b35bf9ab655a13a851c7fbe12a9dc94a590dc9ee:/SL/DB/MetaSetup/Order.pm diff --git a/SL/DB/MetaSetup/Order.pm b/SL/DB/MetaSetup/Order.pm index de072ec70..063ca0b0f 100644 --- a/SL/DB/MetaSetup/Order.pm +++ b/SL/DB/MetaSetup/Order.pm @@ -21,7 +21,6 @@ __PACKAGE__->meta->setup( taxincluded => { type => 'boolean' }, shippingpoint => { type => 'text' }, notes => { type => 'text' }, - curr => { type => 'character', length => 3 }, employee_id => { type => 'integer' }, closed => { type => 'boolean', default => 'false' }, quotation => { type => 'boolean', default => 'false' }, @@ -43,9 +42,10 @@ __PACKAGE__->meta->setup( delivered => { type => 'boolean', default => 'false' }, globalproject_id => { type => 'integer' }, salesman_id => { type => 'integer' }, - transaction_description => { type => 'text' }, marge_total => { type => 'numeric', precision => 5, scale => 15 }, marge_percent => { type => 'numeric', precision => 5, scale => 15 }, + transaction_description => { type => 'text' }, + currency_id => { type => 'integer', not_null => 1 }, ], primary_key_columns => [ 'id' ], @@ -58,6 +58,11 @@ __PACKAGE__->meta->setup( key_columns => { cp_id => 'cp_id' }, }, + currency => { + class => 'SL::DB::Currency', + key_columns => { currency_id => 'id' }, + }, + customer => { class => 'SL::DB::Customer', key_columns => { customer_id => 'id' }, @@ -83,11 +88,6 @@ __PACKAGE__->meta->setup( key_columns => { employee_id => 'id' }, }, - employee_obj => { - class => 'SL::DB::Employee', - key_columns => { employee_id => 'id' }, - }, - globalproject => { class => 'SL::DB::Project', key_columns => { globalproject_id => 'id' }, @@ -98,7 +98,7 @@ __PACKAGE__->meta->setup( key_columns => { language_id => 'id' }, }, - payment => { + payment_terms => { class => 'SL::DB::PaymentTerm', key_columns => { payment_id => 'id' }, },