X-Git-Url: http://wagnertech.de/git?p=kivitendo-erp.git;a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FInvoice.pm;fp=SL%2FDB%2FMetaSetup%2FInvoice.pm;h=e80b110e4f1a44853c47c1f611605549eb5356fa;hp=b88c2f57c087afe3a6562c95709d8ce42b4ff9bb;hb=53593baa211863fbf66540cf1bcc36c8fb37257f;hpb=deb4d2dbb676d7d6f69dfe7815d6e0cb09bd4a44 diff --git a/SL/DB/MetaSetup/Invoice.pm b/SL/DB/MetaSetup/Invoice.pm index b88c2f57c..e80b110e4 100644 --- a/SL/DB/MetaSetup/Invoice.pm +++ b/SL/DB/MetaSetup/Invoice.pm @@ -10,6 +10,7 @@ __PACKAGE__->meta->table('ar'); __PACKAGE__->meta->columns( amount => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 }, + billing_address_id => { type => 'integer' }, cp_id => { type => 'integer' }, currency_id => { type => 'integer', not_null => 1 }, cusordnumber => { type => 'text' }, @@ -43,6 +44,7 @@ __PACKAGE__->meta->columns( ordnumber => { type => 'text' }, paid => { type => 'numeric', default => '0', not_null => 1, precision => 15, scale => 5 }, payment_id => { type => 'integer' }, + qrbill_without_amount => { type => 'boolean', default => 'false' }, quodate => { type => 'date' }, quonumber => { type => 'text' }, salesman_id => { type => 'integer' }, @@ -51,6 +53,7 @@ __PACKAGE__->meta->columns( shipvia => { type => 'text' }, storno => { type => 'boolean', default => 'false' }, storno_id => { type => 'integer' }, + tax_point => { type => 'date' }, taxincluded => { type => 'boolean' }, taxzone_id => { type => 'integer', not_null => 1 }, transaction_description => { type => 'text' }, @@ -63,6 +66,11 @@ __PACKAGE__->meta->primary_key_columns([ 'id' ]); __PACKAGE__->meta->allow_inline_column_values(1); __PACKAGE__->meta->foreign_keys( + billing_address => { + class => 'SL::DB::AdditionalBillingAddress', + key_columns => { billing_address_id => 'id' }, + }, + contact => { class => 'SL::DB::Contact', key_columns => { cp_id => 'cp_id' },