X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FInvoice.pm;h=e80b110e4f1a44853c47c1f611605549eb5356fa;hb=b293ff8ad52fc76ba0c44783e3982418114d6b08;hp=9b10c938c6992b8d3880440a1350fffe7531917d;hpb=4dc48e117cfdb6e59c2d8b9d8087ef8a3bc245a4;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Invoice.pm b/SL/DB/MetaSetup/Invoice.pm index 9b10c938c..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' }, @@ -64,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' },