X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/e09f2da35e02b34569254b5d1550aa5dd287761f..639066d179464ead41625a9a901b165ce9a5eb06:/SL/DB/MetaSetup/Default.pm diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm index f762f3470..b6a3af539 100644 --- a/SL/DB/MetaSetup/Default.pm +++ b/SL/DB/MetaSetup/Default.pm @@ -24,7 +24,9 @@ __PACKAGE__->meta->columns( ar_show_mark_as_paid => { type => 'boolean', default => 'true' }, articlenumber => { type => 'text' }, 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' }, @@ -33,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,12 +46,36 @@ __PACKAGE__->meta->columns( datev_check_on_purchase_invoice => { type => 'boolean', default => 'true' }, datev_check_on_sales_invoice => { type => 'boolean', default => 'true' }, 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' }, + 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' }, duns => { type => 'text' }, email_journal => { type => 'integer', default => 2 }, expense_accno_id => { type => 'integer' }, + fa_bufa_nr => { type => 'text' }, + fa_dauerfrist => { type => 'text' }, + fa_steuerberater_city => { type => 'text' }, + fa_steuerberater_name => { type => 'text' }, + fa_steuerberater_street => { type => 'text' }, + fa_steuerberater_tel => { type => 'text' }, + fa_voranmeld => { type => 'text' }, + feature_balance => { type => 'boolean', default => 'true', not_null => 1 }, + 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_ustva => { type => 'boolean', default => 'true', not_null => 1 }, fxgain_accno_id => { type => 'integer' }, fxloss_accno_id => { type => 'integer' }, gl_changeable => { type => 'integer', default => 2, not_null => 1 }, @@ -84,6 +111,7 @@ __PACKAGE__->meta->columns( project_type_id => { type => 'integer' }, purchase_delivery_order_show_delete => { type => 'boolean', default => 'true' }, purchase_order_show_delete => { type => 'boolean', default => 'true' }, + quick_search_modules => { type => 'array' }, reqdate_interval => { type => 'integer', default => '0' }, require_transaction_description_ps => { type => 'boolean', default => 'false', not_null => 1 }, requirement_spec_section_order_part_id => { type => 'integer' }, @@ -97,19 +125,27 @@ __PACKAGE__->meta->columns( sales_purchase_order_ship_missing_column => { type => 'boolean', default => 'false' }, sdonumber => { type => 'text' }, sepa_creditor_id => { type => 'text' }, + sepa_reference_add_vc_vc_id => { type => 'boolean', default => 'false' }, 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_warehouse_id => { type => 'integer' }, taxnumber => { type => 'text' }, templates => { type => 'text' }, transfer_default => { type => 'boolean', default => 'true' }, transfer_default_ignore_onhand => { type => 'boolean', default => 'false' }, transfer_default_services => { type => 'boolean', default => 'true' }, transfer_default_use_master_default_bin => { type => 'boolean', default => 'false' }, + transfer_default_warehouse_for_assembly => { type => 'boolean', default => 'false' }, transport_cost_reminder_article_number_id => { type => 'integer' }, vendornumber => { type => 'text' }, version => { type => 'varchar', length => 8 }, @@ -135,6 +171,7 @@ __PACKAGE__->meta->foreign_keys( class => 'SL::DB::Chart', key_columns => { ar_chart_id => 'id' }, }, + bin => { class => 'SL::DB::Bin', key_columns => { bin_id => 'id' }, @@ -165,6 +202,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' },