X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FDefault.pm;h=c0f6a44111cd62b7971b4d5c5312dedb08c54b9c;hb=c301c2b3be223fe384bea2d899c6a08de54c21de;hp=aa222567f8908a3e8b09ac0acb9b9484637329e0;hpb=10edf79aa387edb350ccd8562d6f5bf37734004d;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm index aa222567f..c0f6a4411 100644 --- a/SL/DB/MetaSetup/Default.pm +++ b/SL/DB/MetaSetup/Default.pm @@ -45,21 +45,27 @@ __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 => '' }, - doc_max_filesize => { type => 'integer', default => 1000000 }, + doc_files_rootpath => { type => 'text', default => './documents' }, + doc_max_filesize => { type => 'integer', default => 10000000 }, doc_storage => { type => 'boolean', default => 'false' }, doc_storage_for_attachments => { type => 'text', default => 'Filesystem' }, doc_storage_for_documents => { type => 'text', default => 'Filesystem' }, doc_storage_for_images => { type => 'text', default => 'Filesystem' }, + doc_storage_for_shopimages => { type => 'text', default => 'Filesystem' }, doc_webdav => { type => 'boolean', default => 'false' }, 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' }, @@ -73,6 +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_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' }, @@ -83,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 }, @@ -97,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' }, @@ -124,13 +134,23 @@ __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 }, + shipped_qty_require_stock_out => { type => 'boolean', default => 'false', not_null => 1 }, show_bestbefore => { type => 'boolean', default => 'false' }, show_longdescription_select_item => { type => 'boolean', default => 'false' }, show_weight => { type => 'boolean', default => 'false', not_null => 1 }, 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' }, @@ -194,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' },