X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/2ea07c13e111b88478827bf621d41df3eec19dac..f217d072d76183bc07723dcc29503b732bd2022d:/SL/DB/MetaSetup/BankAccount.pm diff --git a/SL/DB/MetaSetup/BankAccount.pm b/SL/DB/MetaSetup/BankAccount.pm index b72a170b4..738b3f1da 100644 --- a/SL/DB/MetaSetup/BankAccount.pm +++ b/SL/DB/MetaSetup/BankAccount.pm @@ -11,6 +11,7 @@ __PACKAGE__->meta->table('bank_accounts'); __PACKAGE__->meta->columns( account_number => { type => 'varchar', length => 100 }, bank => { type => 'text' }, + bank_account_id => { type => 'varchar' }, bank_code => { type => 'varchar', length => 100 }, bic => { type => 'varchar', length => 100 }, chart_id => { type => 'integer', not_null => 1 }, @@ -18,9 +19,13 @@ __PACKAGE__->meta->columns( id => { type => 'integer', not_null => 1, sequence => 'id' }, name => { type => 'text' }, obsolete => { type => 'boolean', default => 'false', not_null => 1 }, + qr_iban => { type => 'text' }, reconciliation_starting_balance => { type => 'numeric', precision => 15, scale => 5 }, reconciliation_starting_date => { type => 'date' }, sortkey => { type => 'integer', not_null => 1 }, + use_for_qrbill => { type => 'boolean', default => 'false', not_null => 1 }, + use_for_zugferd => { type => 'boolean', default => 'false', not_null => 1 }, + use_with_bank_import => { type => 'boolean', default => 'true', not_null => 1 }, ); __PACKAGE__->meta->primary_key_columns([ 'id' ]);