X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/f559550ffb82e23f3712c11be4161d9c53a4b904..a3b8cfa7b7546:/SL/DB/MetaSetup/Default.pm diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm index f62f1d1fd..95aeee2b0 100644 --- a/SL/DB/MetaSetup/Default.pm +++ b/SL/DB/MetaSetup/Default.pm @@ -45,8 +45,8 @@ __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' }, 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' }, @@ -55,10 +55,12 @@ __PACKAGE__->meta->columns( 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_journal => { type => 'integer', default => 2 }, expense_accno_id => { type => 'integer' }, @@ -73,7 +75,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' }, @@ -98,6 +101,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' }, @@ -125,6 +129,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 }, @@ -135,6 +142,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' }, @@ -198,6 +209,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' },