X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FDB%2FMetaSetup%2FDeliveryOrder.pm;h=d242fcd3cd7b6b32c3401b4be62b12608ad057f2;hb=f24cf1f5ab8428ced545a382d0f0179ae6f40a81;hp=92d45ae14860ea4ff6bd0aec81c8d90489d666c0;hpb=3eb3d1b144adb92e62de08e67dc6ff3d39bf7483;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/DeliveryOrder.pm b/SL/DB/MetaSetup/DeliveryOrder.pm index 92d45ae14..d242fcd3c 100644 --- a/SL/DB/MetaSetup/DeliveryOrder.pm +++ b/SL/DB/MetaSetup/DeliveryOrder.pm @@ -4,7 +4,7 @@ package SL::DB::DeliveryOrder; use strict; -use base qw(SL::DB::Object); +use parent qw(SL::DB::Object); __PACKAGE__->meta->table('delivery_orders'); @@ -15,6 +15,7 @@ __PACKAGE__->meta->columns( cusordnumber => { type => 'text' }, customer_id => { type => 'integer' }, delivered => { type => 'boolean', default => 'false' }, + delivery_term_id => { type => 'integer' }, department_id => { type => 'integer' }, donumber => { type => 'text', not_null => 1 }, employee_id => { type => 'integer' }, @@ -28,14 +29,14 @@ __PACKAGE__->meta->columns( notes => { type => 'text' }, ordnumber => { type => 'text' }, oreqnumber => { type => 'text' }, + payment_id => { type => 'integer' }, reqdate => { type => 'date' }, salesman_id => { type => 'integer' }, shippingpoint => { type => 'text' }, shipto_id => { type => 'integer' }, shipvia => { type => 'text' }, taxincluded => { type => 'boolean' }, - taxzone_id => { type => 'integer' }, - terms => { type => 'integer' }, + taxzone_id => { type => 'integer', not_null => 1 }, transaction_description => { type => 'text' }, transdate => { type => 'date', default => 'now()' }, vendor_id => { type => 'integer' }, @@ -61,6 +62,11 @@ __PACKAGE__->meta->foreign_keys( key_columns => { customer_id => 'id' }, }, + delivery_term => { + class => 'SL::DB::DeliveryTerm', + key_columns => { delivery_term_id => 'id' }, + }, + department => { class => 'SL::DB::Department', key_columns => { department_id => 'id' }, @@ -81,6 +87,11 @@ __PACKAGE__->meta->foreign_keys( key_columns => { language_id => 'id' }, }, + payment => { + class => 'SL::DB::PaymentTerm', + key_columns => { payment_id => 'id' }, + }, + salesman => { class => 'SL::DB::Employee', key_columns => { salesman_id => 'id' }, @@ -91,6 +102,11 @@ __PACKAGE__->meta->foreign_keys( key_columns => { shipto_id => 'shipto_id' }, }, + taxzone => { + class => 'SL::DB::TaxZone', + key_columns => { taxzone_id => 'id' }, + }, + vendor => { class => 'SL::DB::Vendor', key_columns => { vendor_id => 'id' },