X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FPurchaseInvoice.pm;h=bee7eb2ae9087ac3bc086efc6237b9492136e863;hb=87e65e6c1cc64bfb2d73b6914ed2ef136861dd42;hp=eb18f7058ca93f1213e0defbc982feb1997da84c;hpb=4a6f0b74c08f02cd04adfe2429eb9965e770c2ba;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/PurchaseInvoice.pm b/SL/DB/MetaSetup/PurchaseInvoice.pm index eb18f7058..bee7eb2ae 100644 --- a/SL/DB/MetaSetup/PurchaseInvoice.pm +++ b/SL/DB/MetaSetup/PurchaseInvoice.pm @@ -28,7 +28,7 @@ __PACKAGE__->meta->setup( 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 +43,7 @@ __PACKAGE__->meta->setup( globalproject_id => { type => 'integer' }, transaction_description => { type => 'text' }, storno_id => { type => 'integer' }, + direct_debit => { type => 'boolean', default => 'false' }, ], primary_key_columns => [ 'id' ], @@ -50,11 +51,36 @@ __PACKAGE__->meta->setup( allow_inline_column_values => 1, foreign_keys => [ + contact => { + class => 'SL::DB::Contact', + key_columns => { cp_id => 'cp_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' },