|
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 |
|
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 |
|
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_taxzone.pl
|
2,75 KB |
|
cp_greeting_migration.pl
|
6,19 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_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 |
|
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 |
|
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 |
|
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 |
|
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_type_enum.sql
|
1,59 KB |
|
parts_add_chart_foreign_keys.sql
|
390 Bytes |
|
parts_add_unit_foreign_key.sql
|
241 Bytes |
|
parts_ean.sql
|
131 Bytes |
|
parts_has_sernumber.sql
|
215 Bytes |
|
parts_translation_foreign_keys.sql
|
876 Bytes |
|
payment_terms_automatic_calculation.sql
|
360 Bytes |
|
payment_terms_for_invoices.sql
|
920 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_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 |
|
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 |
|
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_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,52 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 |