X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FDB%2FMetaSetup%2FPurchaseInvoice.pm;h=e484fb933954c0aab0dc5d9c42c4bed8392f81ee;hb=c6b2257945060625bcb86fa7e2efd27c737480ff;hp=eb18f7058ca93f1213e0defbc982feb1997da84c;hpb=7ea32650019b2611e03f83ccaa904a03d6a6b3d1;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/PurchaseInvoice.pm b/SL/DB/MetaSetup/PurchaseInvoice.pm index eb18f7058..e484fb933 100644 --- a/SL/DB/MetaSetup/PurchaseInvoice.pm +++ b/SL/DB/MetaSetup/PurchaseInvoice.pm @@ -23,12 +23,11 @@ __PACKAGE__->meta->setup( duedate => { type => 'date' }, invoice => { type => 'boolean', default => 'false' }, ordnumber => { type => 'text' }, - curr => { type => 'text' }, notes => { type => 'text' }, employee_id => { type => 'integer' }, quonumber => { type => 'text' }, intnotes => { type => 'text' }, - department_id => { type => 'integer', default => '0' }, + department_id => { type => 'integer' }, itime => { type => 'timestamp', default => 'now()' }, mtime => { type => 'timestamp' }, shipvia => { type => 'text' }, @@ -43,6 +42,9 @@ __PACKAGE__->meta->setup( globalproject_id => { type => 'integer' }, transaction_description => { type => 'text' }, storno_id => { type => 'integer' }, + direct_debit => { type => 'boolean', default => 'false' }, + deliverydate => { type => 'date' }, + currency_id => { type => 'integer', not_null => 1 }, ], primary_key_columns => [ 'id' ], @@ -50,11 +52,41 @@ __PACKAGE__->meta->setup( allow_inline_column_values => 1, foreign_keys => [ + contact => { + class => 'SL::DB::Contact', + key_columns => { cp_id => 'cp_id' }, + }, + + currency => { + class => 'SL::DB::Currency', + key_columns => { currency_id => 'id' }, + }, + + department => { + class => 'SL::DB::Department', + key_columns => { department_id => 'id' }, + }, + + employee => { + class => 'SL::DB::Employee', + key_columns => { employee_id => 'id' }, + }, + globalproject => { class => 'SL::DB::Project', key_columns => { globalproject_id => 'id' }, }, + language => { + class => 'SL::DB::Language', + key_columns => { language_id => 'id' }, + }, + + payment_terms => { + class => 'SL::DB::PaymentTerm', + key_columns => { payment_id => 'id' }, + }, + storno_obj => { class => 'SL::DB::PurchaseInvoice', key_columns => { storno_id => 'id' },