X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/3eb3d1b144adb92e62de08e67dc6ff3d39bf7483..eebe8e90991eacadb6fbd20a648c152017a620c7:/SL/DB/MetaSetup/DeliveryOrder.pm diff --git a/SL/DB/MetaSetup/DeliveryOrder.pm b/SL/DB/MetaSetup/DeliveryOrder.pm index 92d45ae14..c4ee93083 100644 --- a/SL/DB/MetaSetup/DeliveryOrder.pm +++ b/SL/DB/MetaSetup/DeliveryOrder.pm @@ -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' }, @@ -34,7 +35,7 @@ __PACKAGE__->meta->columns( shipto_id => { type => 'integer' }, shipvia => { type => 'text' }, taxincluded => { type => 'boolean' }, - taxzone_id => { type => 'integer' }, + taxzone_id => { type => 'integer', not_null => 1 }, terms => { type => 'integer' }, transaction_description => { type => 'text' }, transdate => { type => 'date', default => 'now()' }, @@ -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' }, @@ -91,6 +97,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' },