X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FDefault.pm;h=c0f6a44111cd62b7971b4d5c5312dedb08c54b9c;hb=c301c2b3be223fe384bea2d899c6a08de54c21de;hp=ea81e3504414706fe0e98028f6e21bd52e47b9e0;hpb=d3ae6850565e55743af3b9aadfb12f308a30ac94;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm index ea81e3504..c0f6a4411 100644 --- a/SL/DB/MetaSetup/Default.pm +++ b/SL/DB/MetaSetup/Default.pm @@ -45,8 +45,9 @@ __PACKAGE__->meta->columns( datev_check_on_gl_transaction => { type => 'boolean', default => 'true' }, datev_check_on_purchase_invoice => { type => 'boolean', default => 'true' }, datev_check_on_sales_invoice => { type => 'boolean', default => 'true' }, + datev_export_format => { type => 'enum', check_in => [ 'cp1252', 'cp1252-translit', 'utf-8' ], db_type => 'datev_export_format_enum', default => 'cp1252-translit' }, + delivery_date_interval => { type => 'integer', default => '0' }, disabled_price_sources => { type => 'array' }, - doc_database => { type => 'boolean', default => 'false' }, doc_delete_printfiles => { type => 'boolean', default => 'false' }, doc_files => { type => 'boolean', default => 'false' }, doc_files_rootpath => { type => 'text', default => './documents' }, @@ -60,7 +61,11 @@ __PACKAGE__->meta->columns( dunning_ar => { type => 'integer' }, dunning_ar_amount_fee => { type => 'integer' }, dunning_ar_amount_interest => { type => 'integer' }, + dunning_creator => { type => 'enum', check_in => [ 'current_employee', 'invoice_employee' ], db_type => 'dunning_creator', default => 'current_employee' }, duns => { type => 'text' }, + email_attachment_part_files_checked => { type => 'boolean', default => 'true' }, + email_attachment_record_files_checked => { type => 'boolean', default => 'true' }, + email_attachment_vc_files_checked => { type => 'boolean', default => 'true' }, email_journal => { type => 'integer', default => 2 }, expense_accno_id => { type => 'integer' }, fa_bufa_nr => { type => 'text' }, @@ -74,7 +79,8 @@ __PACKAGE__->meta->columns( feature_datev => { type => 'boolean', default => 'true', not_null => 1 }, feature_erfolgsrechnung => { type => 'boolean', default => 'false', not_null => 1 }, feature_eurechnung => { type => 'boolean', default => 'true', not_null => 1 }, - feature_experimental => { type => 'boolean', default => 'true', not_null => 1 }, + feature_experimental_assortment => { type => 'boolean', default => 'true', not_null => 1 }, + feature_experimental_order => { type => 'boolean', default => 'true', not_null => 1 }, feature_ustva => { type => 'boolean', default => 'true', not_null => 1 }, fxgain_accno_id => { type => 'integer' }, fxloss_accno_id => { type => 'integer' }, @@ -85,6 +91,7 @@ __PACKAGE__->meta->columns( inventory_accno_id => { type => 'integer' }, inventory_system => { type => 'text' }, invnumber => { type => 'text' }, + invoice_mail_settings => { type => 'enum', check_in => [ 'cp', 'invoice_mail', 'invoice_mail_cc_cp' ], db_type => 'invoice_mail_settings', default => 'cp' }, ir_changeable => { type => 'integer', default => 2, not_null => 1 }, ir_show_mark_as_paid => { type => 'boolean', default => 'true' }, is_changeable => { type => 'integer', default => 2, not_null => 1 }, @@ -99,6 +106,7 @@ __PACKAGE__->meta->columns( normalize_vc_names => { type => 'boolean', default => 'true' }, order_always_project => { type => 'boolean', default => 'false' }, order_warn_duplicate_parts => { type => 'boolean', default => 'true' }, + order_warn_no_deliverydate => { type => 'boolean', default => 'true' }, parts_image_css => { type => 'text', default => 'border:0;float:left;max-width:250px;margin-top:20px:margin-right:10px;margin-left:10px;' }, parts_listing_image => { type => 'boolean', default => 'true' }, parts_show_image => { type => 'boolean', default => 'true' }, @@ -126,6 +134,9 @@ __PACKAGE__->meta->columns( sdonumber => { type => 'text' }, sepa_creditor_id => { type => 'text' }, sepa_reference_add_vc_vc_id => { type => 'boolean', default => 'false' }, + sepa_set_duedate_as_default_exec_date => { type => 'boolean', default => 'false' }, + sepa_set_skonto_date_as_default_exec_date => { type => 'boolean', default => 'false' }, + sepa_set_skonto_date_buffer_in_days => { type => 'integer', default => '0' }, servicenumber => { type => 'text' }, shipped_qty_fill_up => { type => 'boolean', default => 'true', not_null => 1 }, shipped_qty_item_identity_fields => { type => 'array', default => '{parts_id}', not_null => 1 }, @@ -136,6 +147,10 @@ __PACKAGE__->meta->columns( signature => { type => 'text' }, sonumber => { type => 'text' }, sqnumber => { type => 'text' }, + stocktaking_bin_id => { type => 'integer' }, + stocktaking_cutoff_date => { type => 'date' }, + stocktaking_qty_threshold => { type => 'numeric', default => '0', precision => 25, scale => 5 }, + stocktaking_warehouse_id => { type => 'integer' }, taxnumber => { type => 'text' }, templates => { type => 'text' }, transfer_default => { type => 'boolean', default => 'true' }, @@ -199,6 +214,16 @@ __PACKAGE__->meta->foreign_keys( key_columns => { requirement_spec_section_order_part_id => 'id' }, }, + stocktaking_bin => { + class => 'SL::DB::Bin', + key_columns => { stocktaking_bin_id => 'id' }, + }, + + stocktaking_warehouse => { + class => 'SL::DB::Warehouse', + key_columns => { stocktaking_warehouse_id => 'id' }, + }, + warehouse => { class => 'SL::DB::Warehouse', key_columns => { warehouse_id => 'id' },