Projekt

Allgemein

Profil

Statistiken
| Zweig: | Markierung: | Revision:
Name Größe
COA_Account_Settings001.sql 437 Bytes
COA_Account_Settings002.sql 305 Bytes
PgCommaAggregateFunction.sql 681 Bytes
README 109 Bytes
SKR04-3804-addition.pl 4,17 KB
USTVA_abstraction.pl 7,45 KB
USTVA_at.pl 48,7 KB
acc_trans_booleans_not_null.sql 665 Bytes
acc_trans_constraints.pl 4,98 KB
acc_trans_id_uniqueness.pl 1,4 KB
acc_trans_without_oid.sql 1,8 KB
accounts_tax_office_bad_homburg.sql 473 Bytes
add_ar_paid_defaults.sql 229 Bytes
add_chart_link_to_acc_trans.sql 635 Bytes
add_customer_mandator_id.sql 706 Bytes
add_depositor_for_customer_vendor.sql 446 Bytes
add_fk_to_gl.sql 450 Bytes
add_fkey_tax_id_to_acc_trans.sql 248 Bytes
add_makemodel_prices.sql 444 Bytes
add_more_constraints_fibu_projekt_xplace.pl 1,96 KB
add_parts_price_history.sql 1,38 KB
add_parts_price_history2.sql 815 Bytes
add_tax_id_to_acc_trans.sql 1,13 KB
add_test_mode_to_csv_import_report.sql 327 Bytes
add_warehouse_client_config_default.sql 599 Bytes
add_warehouse_client_config_default2.sql 361 Bytes
add_warehouse_defaults.sql 452 Bytes
add_warehouse_for_assembly.sql 313 Bytes
ap_add_direct_debit.sql 263 Bytes
ap_ar_orddate_quodate.sql 317 Bytes
ap_deliverydate.sql 159 Bytes
ap_storno.sql 279 Bytes
ar_add_direct_debit.sql 263 Bytes
ar_add_donumber.sql 334 Bytes
ar_add_invnumber_for_credit_note.sql 384 Bytes
ar_ap_fix_notes_as_html_for_non_invoices.pl 1,33 KB
ar_ap_foreign_keys.sql 2,5 KB
ar_ap_gl_delete_triggers_deletion_from_acc_trans.sql 792 Bytes
ar_ap_storno_id.sql 705 Bytes
ar_storno.sql 278 Bytes
assembly_parts_foreign_key.sql 295 Bytes
assembly_parts_foreign_key2.sql 299 Bytes
assembly_position.sql 188 Bytes
assortment.sql 850 Bytes
assortment_charge.sql 230 Bytes
auth_enable_ct_all_edit.pl 1,26 KB
auth_enable_edit_prices.pl 1,17 KB
auth_enable_sales_all_edit.pl 1,26 KB
auto_delete_reconciliation_links_on_acc_trans_deletion.pl 927 Bytes
auto_delete_sepa_export_items_on_ap_ar_deletion.pl 785 Bytes
automatic_reconciliation.sql 584 Bytes
background_job_change_create_periodic_invoices_to_daily.pl 601 Bytes
background_jobs_3.pl 346 Bytes
background_jobs_clean_auth_sessions.pl 403 Bytes
bank_accounts.sql 680 Bytes
bank_accounts_add_name.sql 175 Bytes
bank_accounts_unique_chart_constraint.sql 248 Bytes
bank_transactions.sql 717 Bytes
bank_transactions_type.sql 272 Bytes
bank_transactions_type2.sql 299 Bytes
bankaccounts_reconciliation.sql 297 Bytes
bankaccounts_sortkey_and_obsolete.sql 545 Bytes
buchungsgruppen_forein_keys.sql 292 Bytes
buchungsgruppen_sortkey.sql 617 Bytes
cb_ob_transaction.sql 345 Bytes
change_makemodel_vendor_id.sql 427 Bytes
change_taxzone_id_0.pl 2,27 KB
chart_category_to_sgn.sql 409 Bytes
chart_names.sql 584 Bytes
chart_names2.sql 536 Bytes
chart_pos_er.sql 246 Bytes
chart_taxkey_id_from_taxkeys.sql 264 Bytes
chart_type_skonto.sql 1,25 KB
charts_without_taxkey.pl 1,23 KB
check_bin_belongs_to_wh_trigger.sql 1,09 KB
cleanup_after_customer_vendor_deletion.sql 748 Bytes
clients.pl 713 Bytes
column_type_text_instead_of_varchar.sql 1,36 KB
column_type_text_instead_of_varchar2.sql 677 Bytes
column_type_text_instead_of_varchar3.sql 243 Bytes
contacts_add_cp_position.pl 367 Bytes
contacts_add_street_and_zipcode_and_city.pl 532 Bytes
contacts_convert_cp_birthday_to_date.pl 1,99 KB
convert_curr_to_text.sql 3,55 KB
convert_drafts_to_record_templates.pl 9,65 KB
convert_taxzone.pl 2,75 KB
cp_greeting_migration.pl 6,19 KB
create_part_if_not_found.sql 275 Bytes
create_record_template_tables.sql 3,12 KB
csv_import_profiles.sql 692 Bytes
csv_import_profiles_2.sql 169 Bytes
csv_import_report_cache.sql 1,09 KB
csv_import_reports_add_numheaders.sql 351 Bytes
csv_mt940_add_profile.sql 2 KB
currencies.pl 9,33 KB
custom_variable_configs_column_type_text.pl 2,72 KB
custom_variable_partsgroups.sql 796 Bytes
custom_variables.sql 1,43 KB
custom_variables_delete_via_trigger.pl 620 Bytes
custom_variables_delete_via_trigger_2.pl 557 Bytes
custom_variables_delete_via_trigger_requirement_specs.sql 895 Bytes
custom_variables_indices.sql 278 Bytes
custom_variables_indices_2.sql 233 Bytes
custom_variables_parts_services_assemblies.sql 329 Bytes
custom_variables_sub_module_not_null.sql 350 Bytes
custom_variables_valid.sql 460 Bytes
custom_variables_validity_index.sql 340 Bytes
customer_add_constraints.sql 724 Bytes
customer_add_taxincluded_checked.sql 227 Bytes
customer_add_taxincluded_checked_2.sql 266 Bytes
customer_klass_rename_to_pricegroup_id_and_foreign_key.sql 340 Bytes
customer_long_entries.sql 379 Bytes
customer_vendor_add_currency.sql 226 Bytes
customer_vendor_phone_no_limits.sql 270 Bytes
customer_vendor_shipto_add_gln.sql 303 Bytes
customer_vendor_taxzone_id.sql 525 Bytes
customer_vendor_ustid_length.sql 585 Bytes
default_bin_parts.pl 5,03 KB
defaults_add_delivery_plan_config.sql 342 Bytes
defaults_add_features.sql 530 Bytes
defaults_add_finanzamt_data.sql 521 Bytes
defaults_add_language_id.sql 176 Bytes
defaults_add_max_future_booking_date.sql 244 Bytes
defaults_add_precision.sql 226 Bytes
defaults_add_quick_search_modules.sql 286 Bytes
defaults_add_rnd_accno_ids.sql 504 Bytes
defaults_balance_startdate.sql 281 Bytes
defaults_bcc_to_login.sql 185 Bytes
defaults_customer_hourly_rate.sql 235 Bytes
defaults_datev_check.pl 1,55 KB
defaults_drop_delivery_plan_calculate_transferred_do.sql 309 Bytes
defaults_drop_delivery_plan_config.sql 314 Bytes
defaults_enable_email_journal.sql 225 Bytes
defaults_feature.pl 1,69 KB
defaults_feature2.pl 592 Bytes
defaults_global_bcc.sql 170 Bytes
defaults_only_customer_projects_in_sales.sql 466 Bytes
defaults_order_warn_duplicate_parts.sql 260 Bytes
defaults_posting_config.pl 1,11 KB
defaults_posting_records_config.sql 522 Bytes
defaults_reqdate_interval.pl 458 Bytes
defaults_require_transaction_description.sql 465 Bytes
defaults_sales_process_limitations.sql 1,27 KB
defaults_sales_purchase_order_show_ship_missing_column.sql 475 Bytes
defaults_show_bestbefore.pl 926 Bytes
defaults_show_delete_on_orders.sql 532 Bytes
defaults_show_longdescription_select_item.sql 272 Bytes
defaults_show_mark_as_paid_config.sql 454 Bytes
defaults_signature.sql 914 Bytes
defaults_transport_cost_reminder.pl 506 Bytes
defaults_transport_cost_reminder_id.sql 354 Bytes
del_exchangerate.sql 408 Bytes
delete_close_follow_ups_when_order_is_deleted_closed.sql 3,57 KB
delete_close_follow_ups_when_order_is_deleted_closed_fkey_deletion.pl 499 Bytes
delete_cust_vend_tax.sql 451 Bytes
delete_customertax_vendortax_partstax.sql 181 Bytes
delete_cvars_on_trans_deletion.sql 5,57 KB
delete_cvars_on_trans_deletion_fix1.sql 1,12 KB
delete_cvars_on_trans_deletion_fix2.sql 725 Bytes
delete_from_generic_translations_on_language_deletion.pl 790 Bytes
delete_invalidated_custom_variables_for_parts.sql 477 Bytes
delete_translations_on_delivery_term_delete.sql 942 Bytes
delete_translations_on_payment_term_delete.sql 944 Bytes
delete_translations_on_tax_delete.sql 825 Bytes
delivery_order_items_add_pricegroup_id.sql 207 Bytes
delivery_orders.sql 3,94 KB
delivery_orders_fields_for_invoices.sql 458 Bytes
delivery_terms.sql 1,59 KB
department_drop_role.sql 367 Bytes
drafts.sql 431 Bytes
drop_audittrail.sql 194 Bytes
drop_datevexport.sql 418 Bytes
drop_dpt_trans.sql 611 Bytes
drop_gifi.sql 374 Bytes
drop_gifi_2.sql 184 Bytes
drop_rma.sql 157 Bytes
drop_sic_code.sql 349 Bytes
drop_yearend.sql 189 Bytes
dunning_config_interest_rate.sql 202 Bytes
dunning_dunning_id.sql 883 Bytes
dunning_invoices_for_fees.sql 707 Bytes
dunning_invoices_per_dunning_level.sql 602 Bytes
email_journal.sql 1,6 KB
email_journal_attachments_add_fileid.sql 228 Bytes
emmvee_background_jobs.sql 678 Bytes
emmvee_background_jobs_2.pl 362 Bytes
employee_deleted.sql 158 Bytes
employee_drop_columns.sql 833 Bytes
employee_no_limits.sql 1,32 KB
erzeugnisnummern.pl 2,89 KB
eur_bwa_category_views.sql 1,75 KB
filemanagement_feature.sql 974 Bytes
files.sql 1,57 KB
finanzamt_update_fa_bufa_nr_hamburg.pl 753 Bytes
first_aggregator.sql 378 Bytes
fix_acc_trans_ap_taxkey_bug.pl 3,39 KB
fix_datepaid.sql 864 Bytes
fix_datepaid_for_sepa_transfers.sql 516 Bytes
fix_taxdescription.sql 3,72 KB
follow_ups.sql 1,99 KB
generic_translations.sql 470 Bytes
gewichte.sql 264 Bytes
gl_add_employee_foreign_key.sql 209 Bytes
gl_storno.sql 1,33 KB
globalprojectnumber_ap_ar_oe.pl 886 Bytes
history_erp.sql 646 Bytes
history_erp_snumbers.sql 171 Bytes
invalid_entries_in_custom_variables_validity.sql 249 Bytes
invalid_taxkeys.sql 452 Bytes
invalid_taxkeys_2.sql 455 Bytes
inventory_fix_shippingdate_assemblies.sql 452 Bytes
inventory_shippingdate_not_null.sql 355 Bytes
invoice_add_donumber.sql 141 Bytes
invoice_positions.pl 1,11 KB
invoices_amount_paid_not_null.sql 1,11 KB
language_output_formatting.sql 321 Bytes
lastschrift.sql 316 Bytes
letter.sql 811 Bytes
letter_cleanup.sql 1,19 KB
letter_country_page.sql 197 Bytes
letter_cp_id.sql 212 Bytes
letter_date_type.sql 314 Bytes
letter_draft.sql 904 Bytes
letter_employee_salesman.sql 248 Bytes
letter_notes_internal.sql 160 Bytes
letter_reference.sql 130 Bytes
letter_vendorletter.sql 402 Bytes
license_invoice_drop.sql 365 Bytes
makemodel_add_vendor_foreign_key.sql 209 Bytes
marge_initial.sql 707 Bytes
oe_ar_ap_delivery_orders_edit_notes_as_html.pl 1,17 KB
oe_customer_vendor_fkeys.sql 400 Bytes
oe_delivered.sql 307 Bytes
oe_delivery_orders_foreign_keys.sql 2,52 KB
oe_do_delete_via_trigger.pl 5,52 KB
oe_employee_id_foreignkey.sql 295 Bytes
oe_is_salesman.sql 373 Bytes
orderitems_delivery_order_items_invoice_foreign_keys.sql 1,53 KB
orderitems_delivery_order_items_positions.pl 1,45 KB
part_classification_report_separate.sql 265 Bytes
part_classifications.sql 1,06 KB
part_type_enum.sql 1,59 KB
parts_add_unit_foreign_key.sql 241 Bytes
parts_ean.sql 131 Bytes
parts_has_sernumber.sql 215 Bytes
parts_remove_unneeded_fields.sql 409 Bytes
parts_translation_foreign_keys.sql 876 Bytes
partsgroup_sortkey_obsolete.sql 454 Bytes
payment_terms_automatic_calculation.sql 360 Bytes
payment_terms_for_invoices.sql 920 Bytes
payment_terms_obsolete.sql 216 Bytes
payment_terms_sortkey.sql 369 Bytes
payment_terms_translation.sql 378 Bytes
payment_terms_translation2.sql 412 Bytes
periodic_invoices.sql 1,44 KB
periodic_invoices_background_job.pl 395 Bytes
periodic_invoices_direct_debit_flag.sql 365 Bytes
periodic_invoices_first_billing_date.sql 246 Bytes
periodic_invoices_order_value_periodicity.sql 963 Bytes
periodic_invoices_order_value_periodicity2.sql 606 Bytes
periodic_invoices_send_email.sql 989 Bytes
price_factors.sql 1,37 KB
price_rules.sql 1,19 KB
price_rules_cascade_delete.sql 332 Bytes
price_rules_discount.sql 268 Bytes
price_source_client_config.sql 209 Bytes
pricegroup_sortkey_obsolete.sql 454 Bytes
prices_delete_cascade.sql 411 Bytes
prices_unique.sql 474 Bytes
project_bob_attributes.sql 3,89 KB
project_bob_attributes_fix_project_status_table_name.sql 272 Bytes
project_bob_attributes_itime_default_fix.sql 622 Bytes
project_customer_type_valid.sql 432 Bytes
project_defaults.sql 489 Bytes
project_flag_active.sql 256 Bytes
project_mtime_trigger.sql 242 Bytes
project_status_default_entries.sql 769 Bytes
project_types.sql 1,1 KB
re_add_sepa_export_items_foreign_keys.sql 633 Bytes
receivable_payable_default_accounts.sql 375 Bytes
record_links.sql 620 Bytes
record_links_orderitems_delete_triggers.sql 1,6 KB
record_links_post_delete_triggers.sql 2,94 KB
record_links_post_delete_triggers2.sql 1,25 KB
recorditem_active_dicount_source.sql 438 Bytes
recorditem_active_price_source.sql 737 Bytes
release_2_4_1.sql 395 Bytes
release_2_4_2.sql 528 Bytes
release_2_4_3.sql 608 Bytes
release_2_6_0.sql 507 Bytes
release_2_6_1.sql 538 Bytes
release_2_6_2.sql 461 Bytes
release_2_6_3.sql 280 Bytes
release_2_7_0.sql 689 Bytes
release_3.1.0.sql 1,42 KB
release_3_0_0.sql 739 Bytes
release_3_2_0.sql 1,51 KB
release_3_3_0.sql 811 Bytes
release_3_4_0.sql 685 Bytes
release_3_4_1.sql 432 Bytes
remove_alternate_from_parts.sql 185 Bytes
remove_index.sql 927 Bytes
remove_obsolete_trigger.sql 229 Bytes
remove_redundant_customer_vendor_delete_triggers.sql 423 Bytes
remove_redundant_cvar_delete_triggers.sql 1,35 KB
remove_role_from_employee.sql 158 Bytes
remove_terms_add_payment_id.sql 811 Bytes
rename_buchungsgruppe_16_19_to_19.sql 229 Bytes
rename_buchungsgruppen_accounts_16_19_percent.sql 674 Bytes
requirement_spec_delete_trigger_fix.sql 6,69 KB
requirement_spec_delete_trigger_fix2.sql 3,77 KB
requirement_spec_edit_html.pl 852 Bytes
requirement_spec_items_item_type_index.sql 245 Bytes
requirement_spec_items_price_factor.sql 331 Bytes
requirement_spec_items_update_trigger_fix.sql 2,43 KB
requirement_spec_items_update_trigger_fix2.sql 4,78 KB
requirement_spec_parts.sql 715 Bytes
requirement_spec_parts_foreign_key_cascade.sql 428 Bytes
requirement_spec_pictures.sql 1,59 KB
requirement_spec_predefined_texts_for_sections.sql 864 Bytes
requirement_spec_type_for_template_fix.sql 334 Bytes
requirement_spec_types_number_formats.sql 1,11 KB
requirement_spec_types_template_file_name.sql 301 Bytes
requirement_specs.sql 16,9 KB
requirement_specs_orders.sql 1,68 KB
requirement_specs_print_templates.pl 512 Bytes
requirement_specs_section_templates.sql 591 Bytes
rm_whitespaces.pl 642 Bytes
rundungsfehler_korrigieren_BUG1328.pl 1,95 KB
sales_quotation_order_probability_expected_billing_date.sql 440 Bytes
schema_normalization_1.sql 1,43 KB
schema_normalization_2.sql 1,41 KB
schema_normalization_3.sql 242 Bytes
self_test_background_job.pl 334 Bytes
sepa.sql 1,13 KB
sepa_contained_in_message_ids.sql 393 Bytes
sepa_export_items.sql 245 Bytes
sepa_in.sql 501 Bytes
sepa_items_payment_type.sql 453 Bytes
sepa_reference_add_vc_vc_id.sql 282 Bytes
shipto_add_cp_gender.sql 190 Bytes
skr03_04_bwa_zuordnung_konten_4250_4610.sql 736 Bytes
skr04_fix_category_3151_3160_3170.sql 286 Bytes
status_history.sql 529 Bytes
steuerfilterung.pl 5,28 KB
tax_constraints.pl 7,52 KB
tax_description_without_percentage.sql 2,71 KB
tax_description_without_percentage_skr04.sql 2,68 KB
tax_id_if_taxkey_is_0.sql 211 Bytes
tax_primary_key_taxkeys_foreign_keys.sql 362 Bytes
tax_report_table_name.sql 209 Bytes
tax_skonto_automatic.sql 1,74 KB
tax_zones_obsolete.sql 184 Bytes
taxzone_default_id.sql 243 Bytes
taxzone_id_in_oe_delivery_orders.sql 1,35 KB
taxzone_sortkey.pl 884 Bytes
taxzones.sql 660 Bytes
todo_user_config.sql 586 Bytes
transaction_description.sql 339 Bytes
transaction_description_not_null.sql 523 Bytes
transfer_out_sales_invoice.sql 365 Bytes
transfer_type_assembled.sql 309 Bytes
transfer_type_shipped.sql 272 Bytes
trigger_assembly_update_lastcost.sql 2,01 KB
trigram_indices.sql 3,54 KB
umstellung_eur.pl 2,13 KB
unit_foreign_key_for_line_items.sql 411 Bytes
units_id.sql 195 Bytes
units_no_type_distinction.sql 179 Bytes
units_sortkey.sql 327 Bytes
units_translations_and_singular_plural_distinction.sql 628 Bytes
update_date_paid.sql 637 Bytes
use_html_in_letter.pl 359 Bytes
user_preferences.sql 354 Bytes
ustva_2010.sql 985 Bytes
ustva_2010_fixes.sql 209 Bytes
ustva_setup_2007.sql 940 Bytes
ustva_setup_2007_update_chart_taxkeys_tax.sql 9,16 KB
ustva_setup_2007_update_chart_taxkeys_tax_add_missing_tax_accounts.sql 769 Bytes
ustva_setup_2007_update_chart_taxkeys_tax_skr04.sql 5,45 KB
vendor_add_constraints.sql 715 Bytes
vendor_long_entries.sql 372 Bytes
warehouse.pl 6,57 KB
warehouse2.sql 246 Bytes
warehouse3.sql 305 Bytes
warehouse_add_bestbefore.sql 233 Bytes
warehouse_add_delivery_order_items_stock_id.sql 1,01 KB
warehouse_alter_chargenumber.sql 320 Bytes

Aktuellste Revisionen

# Datum Autor Kommentar
ae37b24e 07.04.2017 11:00 Kivitendo Admin

Kategorien für EÜR/GuV und BWA in Datenbank speichern

Vorbereitung für Kontennachweis in EÜR/BWA, wo die Kategorienamen im
Template nicht hartkodiert sein sollen.

Die Berichte sollen komplett überarbeitet werden, daher werden die
Kategorienamen temporär in einer View gespeichert, nicht in einer...

731ba6d6 23.03.2017 13:39 Moritz Bunkus

überflüssiges SQL-Upgrade-Script »parts_add_chart_foreign_keys.sql« entfernt

Im dem Script werden drei Fremdschlüssel für Spalten angelegt, die im
nachfolgenden Script »parts_remove_unneeded_fields.sql« gleich gedroppt
werden. Damit ist das Script überflüssig und sogar schädlich, falls...

be71a860 04.03.2017 11:10 Jan Büren

trigram Indizes mit may_fail versehen und UPGRADE entsprechend angepasst

5296eca4 28.02.2017 13:00 Moritz Bunkus

Versehentlich entfernte Fremdschlüssel auf sepa_export_items wieder hinzugefügt

Das DB-Upgrade-Script
»auto_delete_sepa_export_items_on_ap_ar_deletion.pl« hat via
»SL::DBUpgrade2::Base::drop_constraints« alle Constraints auf
»sepa_export_items« entfernt, dann aber nur zwei davon (mit anderen...

cbf8ed02 22.02.2017 11:33 Martin Helmling martin.helm...

Dateimanagement: Robustere Mandantenkonfigurierung

Es wurde das BAckend "None" eingeführt, falls kein Backend enabled ist.
Fehlermeldung nun in deutsch falls kein Backend vorhanden.

Die Hochladbare Dateigröße ist nun in der Mandantenkonfig in Megabytes (default 10Mb)

4699b274 10.02.2017 10:28 Moritz Bunkus

Belegvorlagen: employee_id bei Umwandlung aus Drafts beibehalten

edfac813 01.02.2017 08:52 Martin Helmling

BCC an aktuellen Benutzer

Falls in der Mandantenkonfiguration diese Option eingeschaltet wird,
bekommt de raktuelle Benutzer zu jeder versendeten Email eine blinde Kopie

a40f0c2f 01.02.2017 08:52 Martin Helmling martin.helm...

Dateimanagement: Alle Anhänge per E-Mail versendbar machen

Es können an eine E-Mail alle Anhänge eines Dokumentes,
sowie die Anhänge am Kunden/Liefranten sowie die Anhänge an Artikeln
mitgesendet werden.

Falls ein Dokument bereits existiert muss es nicht noch neu erzeugt werden....

2bb452ee 01.02.2017 08:48 Martin Helmling mh@waldpark...

Dateimanagement: Basiserweiterung

In diesem Commit sind die Anpassungen in der Mandantenkonfiguration
sowie die notwendigen Klassen und Controller.

Über eine Zwischenschicht wird das tatsächliche Backend (Dateien,WebDAV,ext.DMS,Datenbank etc) verborgen.

96def4ca 31.01.2017 16:40 Kivitendo Admin

Inventory: shippingdate darf nicht leer sein

Nachtrag zu Commit 8fd886849e68f

Revisionen anzeigen

Auch abrufbar als: Atom