X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDB%2FMetaSetup%2FDefault.pm;h=5f3f6f320aa46782ec82ff6ebbe8b7d7ed441cca;hb=7230b956646b33a6a2da270df50d1e8edf5e4dd2;hp=c0f6a44111cd62b7971b4d5c5312dedb08c54b9c;hpb=bcc18db1e4de520a6d6d1ce0378516b2c390ee81;p=kivitendo-erp.git diff --git a/SL/DB/MetaSetup/Default.pm b/SL/DB/MetaSetup/Default.pm index c0f6a4411..5f3f6f320 100644 --- a/SL/DB/MetaSetup/Default.pm +++ b/SL/DB/MetaSetup/Default.pm @@ -10,7 +10,11 @@ __PACKAGE__->meta->table('defaults'); __PACKAGE__->meta->columns( accounting_method => { type => 'text' }, - address => { type => 'text' }, + address_city => { type => 'text' }, + address_country => { type => 'text' }, + address_street1 => { type => 'text' }, + address_street2 => { type => 'text' }, + address_zipcode => { type => 'text' }, allow_new_purchase_delivery_order => { type => 'boolean', default => 'true', not_null => 1 }, allow_new_purchase_invoice => { type => 'boolean', default => 'true', not_null => 1 }, allow_sales_invoice_from_sales_order => { type => 'boolean', default => 'true', not_null => 1 }, @@ -30,12 +34,16 @@ __PACKAGE__->meta->columns( bin_id => { type => 'integer' }, bin_id_ignore_onhand => { type => 'integer' }, businessnumber => { type => 'text' }, + carry_over_account_chart_id => { type => 'integer' }, closedto => { type => 'date' }, cnnumber => { type => 'text' }, co_ustid => { type => 'text' }, coa => { type => 'text' }, company => { type => 'text' }, + contact_departments_use_textfield => { type => 'boolean' }, + contact_titles_use_textfield => { type => 'boolean' }, create_part_if_not_found => { type => 'boolean', default => 'false' }, + create_zugferd_invoices => { type => 'integer' }, 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 }, @@ -100,6 +108,7 @@ __PACKAGE__->meta->columns( itime => { type => 'timestamp', default => 'now()' }, language_id => { type => 'integer' }, letternumber => { type => 'integer' }, + loss_carried_forward_chart_id => { type => 'integer' }, max_future_booking_interval => { type => 'integer', default => 360 }, mtime => { type => 'timestamp' }, normalize_part_descriptions => { type => 'boolean', default => 'true' }, @@ -114,9 +123,11 @@ __PACKAGE__->meta->columns( pdonumber => { type => 'text' }, ponumber => { type => 'text' }, precision => { type => 'numeric', default => '0.01', not_null => 1, precision => 15, scale => 5 }, + profit_carried_forward_chart_id => { type => 'integer' }, profit_determination => { type => 'text' }, project_status_id => { type => 'integer' }, project_type_id => { type => 'integer' }, + purchase_delivery_order_check_stocked => { type => 'boolean', default => 'false' }, purchase_delivery_order_show_delete => { type => 'boolean', default => 'true' }, purchase_order_show_delete => { type => 'boolean', default => 'true' }, quick_search_modules => { type => 'array' }, @@ -128,9 +139,11 @@ __PACKAGE__->meta->columns( rmanumber => { type => 'text' }, rndgain_accno_id => { type => 'integer' }, rndloss_accno_id => { type => 'integer' }, + sales_delivery_order_check_stocked => { type => 'boolean', default => 'false' }, sales_delivery_order_show_delete => { type => 'boolean', default => 'true' }, sales_order_show_delete => { type => 'boolean', default => 'true' }, sales_purchase_order_ship_missing_column => { type => 'boolean', default => 'false' }, + sales_serial_eq_charge => { type => 'boolean', default => 'false', not_null => 1 }, sdonumber => { type => 'text' }, sepa_creditor_id => { type => 'text' }, sepa_reference_add_vc_vc_id => { type => 'boolean', default => 'false' }, @@ -159,6 +172,7 @@ __PACKAGE__->meta->columns( 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' }, + vc_greetings_use_textfield => { type => 'boolean' }, vendornumber => { type => 'text' }, version => { type => 'varchar', length => 8 }, vertreter => { type => 'boolean', default => 'false' }, @@ -167,6 +181,7 @@ __PACKAGE__->meta->columns( webdav => { type => 'boolean', default => 'false' }, webdav_documents => { type => 'boolean', default => 'false' }, weightunit => { type => 'varchar', length => 5 }, + workflow_po_ap_chart_id => { type => 'integer' }, ); __PACKAGE__->meta->primary_key_columns([ 'id' ]); @@ -194,11 +209,26 @@ __PACKAGE__->meta->foreign_keys( key_columns => { bin_id_ignore_onhand => 'id' }, }, + carry_over_account_chart => { + class => 'SL::DB::Chart', + key_columns => { carry_over_account_chart_id => 'id' }, + }, + currency => { class => 'SL::DB::Currency', key_columns => { currency_id => 'id' }, }, + loss_carried_forward_chart => { + class => 'SL::DB::Chart', + key_columns => { loss_carried_forward_chart_id => 'id' }, + }, + + profit_carried_forward_chart => { + class => 'SL::DB::Chart', + key_columns => { profit_carried_forward_chart_id => 'id' }, + }, + project_status => { class => 'SL::DB::ProjectStatus', key_columns => { project_status_id => 'id' },