X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/f2b44f136e8193bbda860c377eeb04cd932b713b..a3b8cfa7b7546:/SL/DB/MetaSetup/Default.pm diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm index 496336480..95aeee2b0 100644 --- a/SL/DB/MetaSetup/Default.pm +++ b/SL/DB/MetaSetup/Default.pm @@ -26,6 +26,7 @@ __PACKAGE__->meta->columns( assemblynumber => { type => 'text' }, assortmentnumber => { type => 'text' }, balance_startdate_method => { type => 'text' }, + bcc_to_login => { type => 'boolean', default => 'false', not_null => 1 }, bin_id => { type => 'integer' }, bin_id_ignore_onhand => { type => 'integer' }, businessnumber => { type => 'text' }, @@ -34,6 +35,7 @@ __PACKAGE__->meta->columns( co_ustid => { type => 'text' }, coa => { type => 'text' }, company => { type => 'text' }, + create_part_if_not_found => { type => 'boolean', default => 'false' }, currency_id => { type => 'integer', not_null => 1 }, customer_hourly_rate => { type => 'numeric', precision => 8, scale => 2 }, customer_projects_only_in_sales => { type => 'boolean', default => 'false', not_null => 1 }, @@ -43,10 +45,22 @@ __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_delete_printfiles => { type => 'boolean', default => 'false' }, + doc_files => { type => 'boolean', default => 'false' }, + 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_journal => { type => 'integer', default => 2 }, expense_accno_id => { type => 'integer' }, @@ -61,6 +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_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 +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' }, @@ -112,13 +129,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' }, @@ -182,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' },