Index of /gentos-prod/database/migrations
Parent Directory
0001_01_01_000000_create_users_table.php
0001_01_01_000001_create_cache_table.php
0001_01_01_000002_create_jobs_table.php
0001_01_99_100000_create_xmasters_table.php
0001_01_99_100000_create_xslips_table.php
0001_01_99_100001_create_xmaster_details_table.php
0001_01_99_100001_create_xslip_details_table.php
2025_01_18_000001_create_sp_generate_backorder_report.php
2025_01_18_000001_create_sp_generate_backorder_report.sql
2025_01_20_120001_add_custom_fields_to_audits_table.php
2025_01_20_120002_add_custom_fields_to_activity_log_table.php
2025_01_20_120003_create_export_jobs_table.php
2025_01_25_160000_optimize_edi_tables_for_reports.php
2025_01_28_000001_create_csv_imports_table.php
2025_01_28_000002_create_csv_import_templates_table.php
2025_01_28_000003_create_csv_import_logs_table.php
2025_01_28_100001_create_edi_raw_data_table.php
2025_01_28_100002_create_edi_order_headers_table.php
2025_01_28_100003_create_edi_order_details_table.php
2025_01_31_100001_add_shipment_arrival_fields_to_edi_order_details_table.php
2025_02_01_100001_create_edi_shipment_notifications_table.php
2025_02_01_100003_add_shipment_qty_to_edi_order_details_table.php
2025_02_01_100004_modify_order_type_in_edi_order_headers_table.php
2025_02_01_100005_modify_ordering_person_name_length.php
2025_02_01_100006_rename_order_quantity_to_order_qty.php
2025_02_01_100007_rename_notes_to_note_in_edi_order_details.php
2025_02_01_120001_create_edi_delivery_notices_table.php
2025_02_01_120002_create_edi_delivery_notice_headers_table.php
2025_02_01_120003_create_edi_delivery_notice_details_table.php
2025_02_01_120004_create_edi_delivery_notice_packages_table.php
2025_02_01_120005_drop_old_edi_shipment_tables.php
2025_02_01_120006_create_edi_order_lot_allocations_table.php
2025_08_04_000458_modify_processing_status_to_int_in_edi_raw_data_table.php
2025_08_04_001844_modify_status_to_int_in_edi_order_headers_table.php
2025_08_04_002512_modify_status_fields_to_int_in_edi_order_details_table.php
2025_08_05_100001_add_indexes_to_login_histories_table.php
2025_08_08_104617_add_updated_at_to_csv_import_logs_table.php
2025_08_08_140245_add_business_data_fields_to_csv_import_logs_table.php
2025_08_10_100001_add_account_lock_fields_to_users_table.php
2025_08_10_100002_add_account_lock_settings_to_company_settings_table.php
2025_08_10_120001_add_password_change_required_to_users_table.php
2025_08_10_120002_add_index_to_password_change_required_on_users_table.php
2025_08_11_120001_add_two_factor_enabled_to_users_table.php
2025_08_11_120002_create_two_factor_codes_table.php
2025_08_11_120003_create_trusted_devices_table.php
2025_08_11_120004_add_standard_columns_to_two_factor_codes_table.php
2025_08_11_120005_add_standard_columns_to_trusted_devices_table.php
2025_08_15_143800_update_postal_code_fields_length.php
2025_08_19_000001_add_missing_fields_to_edi_tables.php
2025_08_19_103541_create_audits_table.php
2025_08_19_104122_create_activity_log_table.php
2025_08_19_104123_add_event_column_to_activity_log_table.php
2025_08_19_104124_add_batch_uuid_column_to_activity_log_table.php
2025_08_20_140644_add_display_name_to_audit_tables.php
2025_08_22_230955_add_indexes_to_sales_budget_targets_table.php
2025_08_26_150740_fix_collation_for_product_code_columns.php
2025_08_26_151306_fix_edi_tables_collation_to_general_ci.php
2025_08_29_111436_add_created_at_index_to_activity_log_table.php
2025_08_29_193532_add_cancellation_columns_to_set_transfer_headers_table.php
2025_09_11_152554_2025_09_11_add_purchase_headers_fields_to_payment_status.php
2025_09_16_105500_add_effective_date_to_purchase_exchange_rate_histories_table.php
2025_09_17_143957_create_user_shortcuts_table.php
2025_09_17_150808_add_tax_rate_id_to_purchase_order_details.php
2025_09_24_153957_add_reserve_deadline_date_to_order_headers.php
2025_10_03_180529_add_vessel_name_to_receipt_headers.php
2025_10_08_140622_add_shipping_warehouse_id_to_edi_order_headers_table.php
2025_10_08_145827_add_sales_rep_id_to_customers.php
2025_10_18_000000_create_inventory_lot_logs_table.php
2025_10_18_000001_create_inventory_lot_log_details_table.php
2025_10_22_000001_add_record_counts_to_edi_raw_data_table.php
2025_10_24_010323_add_data_hash_to_edi_raw_data.php
2025_10_24_212448_add_notified_at_to_discrepancies.php
2025_11_06_000000_add_status_to_sales_lot_outs_table.php
2025_11_11_120156_create_fb_import_tables.php
2025_11_11_125557_add_department_id_to_order_details_table.php
2025_11_11_125559_add_department_id_to_sales_details_table.php
2025_11_12_194926_modify_bank_code_length_in_fb_import_batches_table.php
2025_11_12_204721_add_missing_columns_to_fb_import_tables.php
2025_11_14_083410_add_should_register_to_fb_import_details_table.php
2025_11_21_090938_add_default_cost_price_jpy_to_product_suppliers.php
2025_11_26_143815_add_purchase_status_to_receipt_headers.php
2025_11_28_100000_add_transfer_group_id_to_inventory_transfer_logs_table.php
2025_11_29_100000_add_adjustment_group_id_to_adjustment_logs_table.php
2025_12_04_091014_modify_order_number_in_order_headers.php
2025_12_09_183937_add_avg_cost_to_products.php
2025_12_11_113139_modify_tracking_number_to_sales_headers.php
2025_12_15_000001_add_backorder_report_indexes.php
2025_12_15_000001_add_backorder_report_indexes.sql
2025_12_15_000002_update_sp_generate_backorder_report.php
2025_12_15_000002_update_sp_generate_backorder_report.sql
2025_12_15_142558_add_index_to_shipment_date_on_order_headers.php
2025_12_15_162030_modify_purchase_headers_to_purchase_headers.php
2025_12_15_195833_add_index_to_shipment_date_on_shipment_headers.php
2025_12_16_112754_add_index_to_shipment_actual_date_on_sales_headers.php
2025_12_17_181030_add_index_to_sales_id_on_sales_sales_details.php
2025_12_17_190428_add_category_abbr_to_categories.php
2025_12_18_145840_add_index_to_arrival_date_on_sales_headers.php
2025_12_25_124603_add_billing_confirmed_status_to_sales_details.php
2025_12_25_183036_add_index_to_billing_ym_on_sales_sales_details.php
2026_01_01_000001_create_sales_rep_change_schedules_table.php
2026_01_01_000002_create_sales_rep_change_schedule_exclusions_table.php
2026_01_06_100001_add_yodobashi_edi_delivery_code_to_customer_deliveries_table.php
2026_01_06_100001_modify_document_name_code_in_edi_order_headers_table.php
2026_01_07_200919_add_exclude_from_stock_value_to_warehouses_table.php
2026_01_09_000001_create_shipment_instruction_groups_table.php
2026_01_09_000002_add_instruction_group_id_to_shipment_headers_table.php
2026_01_16_173612_add_category_code_to_categories.php
2026_01_17_000001_add_cod_fields_to_carriers_table.php
2026_01_18_000001_add_check_digit_type_to_carriers_table.php
2026_01_19_000001_create_approver_groups_table.php
2026_01_19_000002_create_approver_group_users_table.php
2026_01_19_000003_add_group_columns_to_approval_template_steps_table.php
2026_01_20_000001_add_group_columns_to_approval_steps_table.php
2026_01_20_163132_add_exclude_requester_to_approval_steps_table.php
2026_01_21_100001_modify_purchase_order_number_length_in_purchase_order_headers.php
2026_01_21_200001_add_disbursement_type_to_payment_disbursements_table.php
2026_01_21_200002_create_payment_disbursement_matchings_table.php
2026_01_27_000001_add_business_type_code_to_business_types_table.php
2026_01_28_100000_add_physical_warehouse_columns_to_warehouses_table.php
2026_01_30_181334_add_index_to_product_id_priority_on_product_suppliers.php
2026_01_31_100000_add_is_defective_warehouse_to_warehouses_table.php
2026_01_31_100001_add_quantities_to_inventory_stocktaking_details_table.php
2026_02_02_130702_update_sp_generate_backorder_report.php
2026_02_02_130702_update_sp_generate_backorder_report.sql
2026_02_02_195133_update_sp_generate_backorder_report.php
2026_02_02_195133_update_sp_generate_backorder_report.sql
2026_02_03_160035_update_sp_generate_backorder_report_carryover.php
2026_02_03_160035_update_sp_generate_backorder_report_carryover.sql
2026_02_04_100000_update_sp_generate_backorder_report_orderby.php
2026_02_04_110000_update_sp_generate_backorder_report_display_columns.php
2026_02_04_150000_update_sp_generate_backorder_report_pattern4.php
2026_02_04_220000_update_sp_generate_backorder_report_case_c1.php
2026_02_07_100001_add_index_to_order_date_on_order_headers.php
2026_02_08_000001_add_indexes_for_report_performance.php
2026_02_08_000002_create_proc_customer_price_list.php
2026_02_08_000003_update_proc_customer_price_list_add_params.php
2026_02_08_000004_update_report_customer_price_list_to_use_proc.php
2026_02_09_000001_update_proc_and_conditions_add_like_params.php
2026_02_09_000002_update_proc_exclude_inactive_products.php
2026_02_09_000003_update_proc_and_columns_add_abbr_character_successor.php
2026_02_09_000004_update_proc_price_source_japanese.php
2026_02_09_000005_update_col_def_header_name_product_id.php
2026_02_10_163259_create_monthly_accounts_payables_table.php
2026_02_12_000001_add_error_details_to_edi_raw_data_table.php
2026_02_14_000001_create_shipping_label_groups_table.php
2026_02_14_000002_add_shipping_label_group_id_to_sales_headers_table.php
2026_02_23_100001_add_accessory_cost_price_to_purchase_details_table.php
2026_02_23_100002_create_v_accessory_cost_summary_view.php
2026_03_02_000001_create_product_size_notifications_table.php
2026_03_06_000001_update_proc_customer_price_list_rank_display.php
2026_03_06_100001_create_v_sales_product_metrics_view.php
2026_03_07_100000_update_sp_generate_backorder_report_allocation_filter.php
2026_03_07_100001_add_index_to_product_id_on_sales_details.php
2026_03_07_110000_update_sp_generate_backorder_report_pattern3_available_qty.php
2026_03_07_120000_update_sp_generate_backorder_report_pattern3_available_qty_fix.php
2026_03_07_130000_update_sp_generate_backorder_report_shipment_qty_fix.php
2026_03_07_140000_update_sp_generate_backorder_report_carryover_window_fix.php
2026_03_07_140001_update_proc_generate_backorder_report_by_product.php
2026_03_07_140002_update_report_col_defs_expected_shipment_qty.php
2026_03_07_150000_update_sp_generate_backorder_report_carryover_null_fix.php
2026_03_07_150001_add_report_select_expected_shipment_qty.php
2026_03_09_100001_recreate_v_sales_product_metrics_view.php
2026_03_09_200001_add_is_end_of_sale_and_successor_product_name_to_products.php
2026_03_09_200001_create_v_product_sales_ranking_view.php
2026_03_12_000001_add_columns_to_inventory_lot_log_details_table.php
2026_03_15_000001_add_batch_id_to_payment_receipt_headers_table.php
2026_03_17_000001_update_proc_add_has_qty_price.php
2026_03_17_175139_add_reference_number_to_purchase_headers.php
2026_03_19_100001_fix_v_sales_actual_result_table_category_sort_order.php
2026_03_19_200001_fix_gross_profit_discount_calculation.php
2026_03_19_300001_fix_cost_price_null_in_gross_profit_views.php
2026_03_19_400001_add_category_lv2_sort_order_and_product_character_to_report38.php
2026_03_20_000001_fix_sales_budget_actual_report_views.php
2026_03_20_100001_fix_sales_budget_actual_sign_and_cost.php
2026_03_20_200001_fix_sales_budget_actual_return_sign.php
2026_03_20_300001_fix_cost_amount_exclude_discount_lines.php
2026_03_20_400001_fix_inventory_list_backorder_and_amount_calculation.php
2026_03_21_100001_update_report39_supplier_product_column_order_and_sort.php
2026_03_22_100001_fix_v_sales_product_metrics_category_id.php
2026_03_24_100001_add_gross_profit_margin_to_report21.php
2026_03_25_000001_update_proc_customer_price_list_add_customer_code.php
2026_03_25_000002_update_proc_customer_price_list_remove_is_active_add_end_of_sale.php
2026_03_25_100001_fix_proc_customer_ledger_carry_amount.php
2026_03_25_200001_fix_proc_product_ledger_unit_price.php
2026_03_26_100000_update_sp_generate_backorder_report_status_filter.php
2026_03_27_183616_add_last_transaction_date_to_sales_details.php
2026_03_28_100001_add_category_lv2_name_to_v_product_sales_ranking.php
2026_03_29_100001_add_product_character_sort_to_proc_customer_price_list.php
2026_03_29_100001_add_quantity_to_report123_parts_search.php
2026_03_29_200001_fix_v_inventory_lists_group_by_product.php
2026_03_30_100001_add_sales_details_id_to_monitor_list_views.php
2026_03_30_100002_add_sales_id_to_monitor_list_views.php
2026_03_31_100000_add_delivery_name_to_backorder_reports.php
2026_03_31_110000_update_sp_backorder_report_ec_delivery_name.php
2026_04_01_100000_add_default_col_width_to_reports_table.php
2026_04_04_100001_fix_v_inventory_lists_amount_calculation.php
2026_04_04_200001_fix_credit_check_list_credit_balance_calculation.php
2026_04_06_100001_fix_v_sales_actual_result_data_pure_sales_calculation.php
2026_04_06_100002_fix_backorder_report_same_date_arrival_qty.php
2026_04_06_100003_fix_backorder_report_same_date_allocation_subquery.php
2026_04_07_100001_fix_v_product_inventory_list_edi_allocation_duplication.php
2026_04_07_100002_fix_v_product_inventory_list_pivot_edi_allocation_duplication.php
2026_04_07_100003_fix_v_product_inventory_list_by_product_edi_allocation_duplication.php
2026_04_07_100004_fix_v_allocation_management_edi_allocation_duplication.php
2026_04_07_200001_fix_report21_proc_include_null_category_lv2.php
2026_04_07_200002_update_sp_backorder_report_receipt_headers_date.php
2026_04_07_200003_fix_backorder_report_priority_allocation_null.php
2026_04_08_100001_add_proc_to_reports_22_23_with_date_search.php
2026_04_08_100002_fix_reports_22_23_proc_gross_profit_margin_precision.php
2026_04_08_100003_fix_reports_21_22_23_proc_date_comparison.php
2026_04_08_100004_add_proc_to_report_37_with_date_search.php
2026_04_08_100005_add_proc_to_report_38_with_date_search.php
2026_04_08_100006_add_proc_to_report_39_with_date_search.php
2026_04_08_100007_add_proc_to_report_40_with_date_search.php
2026_04_08_100008_add_proc_to_report_41_with_date_search.php
2026_04_08_100009_add_proc_to_report_42_with_date_search.php
2026_04_08_100010_add_proc_to_report_43_with_date_search.php
2026_04_08_100011_add_proc_to_report_44_with_date_search.php
2026_04_08_100012_add_proc_to_report_45_with_date_search.php
2026_04_08_100013_add_proc_to_report_46_with_date_search.php
2026_04_08_100014_add_proc_to_report_47_with_date_search.php
2026_04_08_100015_add_proc_to_report_48_with_date_search.php
2026_04_08_100016_add_proc_to_report_49_with_date_search.php
2026_04_08_100017_add_proc_to_report_50_with_date_search.php
2026_04_08_100018_add_proc_to_reports_51_52_with_date_search.php
2026_04_08_100019_add_proc_to_reports_53_54_with_date_search.php
2026_04_08_100020_add_proc_to_reports_55_56_with_date_search.php
2026_04_08_100021_add_proc_to_reports_57_58_59_60_with_date_search.php
2026_04_08_100022_add_proc_to_report_61_with_date_search.php
2026_04_09_100000_fix_backorder_report_order_number_source.php
2026_04_09_100001_add_report_sort_order_to_categories.php
2026_04_09_100002_fix_report40_proc_add_category_lv2_sort_order.php
2026_04_09_100003_fix_reports_41_42_45_50_proc_add_category_lv2_sort_order.php
2026_04_09_100004_fix_reports_51_52_proc_add_category_lv2_sort_order.php
2026_04_09_100005_fix_reports_57_58_59_60_proc_add_category_lv2_sort_order.php
2026_04_09_100006_fix_reports_38_39_proc_category_lv2_report_sort_order.php
2026_04_09_100007_fix_reports_21_23_proc_category_lv2_report_sort_order.php
2026_04_09_200001_add_v_resolved_sales_rep_and_unique_index.php
2026_04_09_200002_fix_reports_22_23_proc_sales_rep_resolution.php
2026_04_09_200003_fix_reports_42_44_45_46_50_proc_sales_rep_resolution.php
2026_04_09_200004_fix_reports_57_58_59_60_proc_sales_rep_resolution.php
2026_04_09_200005_fix_report_69_proc_sales_rep_resolution.php
2026_04_10_100001_fix_views_06_09_29_sales_rep_resolution.php
2026_04_10_100002_fix_reports_45_57_proc_dept_resolution.php
2026_04_10_100003_fix_reports_40_41_43_47_51_56_proc_dept_resolution.php
2026_04_10_200001_fix_v_resolved_sales_rep_helmet_actual_check.php
2026_04_11_120000_add_purchase_order_detail_id_to_sp_generate_backorder_report.php
2026_04_11_120000_add_purchase_order_detail_id_to_sp_generate_backorder_report.sql
2026_04_12_120000_fix_sp_backorder_report_line_no_sort.php
2026_04_12_120000_fix_sp_backorder_report_line_no_sort.sql
2026_04_12_140000_fix_sp_backorder_report_order_pre_allocated_null.php
2026_04_12_140000_fix_sp_backorder_report_order_pre_allocated_null.sql
2026_04_13_092242_add_eta_to_receipt_headers.php
2026_04_16_100001_fix_proc_customer_ledger_rec_name_filter.php
2026_04_17_100000_fix_sp_backorder_carryover_cross_join.php
2026_04_17_100000_fix_sp_backorder_carryover_cross_join.sql
2026_04_19_100001_fix_rate_formulas_in_procs_51_to_56.php
2026_04_21_100000_add_allocation_policy_and_reserve_deadline_date_to_v_allocation_management.php
2026_04_23_100000_add_detail_note_to_inventory_transfer_logs_table.php
2026_04_24_100000_add_v_resolved_order_sales_rep_and_unique_index.php
2026_04_24_100001_fix_sp_backorder_sales_rep_resolution.php
2026_04_24_100001_fix_sp_backorder_sales_rep_resolution.sql
2026_04_25_100001_add_category_name_lv2_to_proc_report48.php
2026_04_27_100001_fix_proc_51_52_re_add_category_lv2_sort_order.php
2026_04_27_100002_add_unique_index_to_customer_category_sales_reps.php
2026_05_04_100001_exclude_unchin_sonota_from_sp_backorder.php
2026_05_04_100001_exclude_unchin_sonota_from_sp_backorder.sql
2026_05_05_100001_create_proc_net_profit_data.php
2026_05_05_100002_create_proc_net_profit_by_group.php
2026_05_05_100003_create_proc_net_profit_best30.php
2026_05_07_100000_add_sum_pure_sales_qty_to_report_50_proc.php
2026_05_07_100001_modify_proc_net_profit_best30_for_group_ranking.php
2026_05_08_100001_add_proc_to_report_62_with_date_search.php
2026_05_13_100001_create_fn_to_full_width.php
2026_05_13_100002_update_proc_customer_price_list_normalize.php
2026_05_15_120000_add_proc_to_report_195_daily_report_lv2.php
2026_05_19_100001_redesign_proc_customer_price_list_perf.php
2026_05_19_120000_fix_proc_report_195_preserve_all_data.php
2026_05_20_100001_add_purchase_row_id_to_sp_backorder_select.php
2026_05_20_100001_add_purchase_row_id_to_sp_backorder_select.sql
2026_05_27_100001_create_report_output_groups_table.php
2026_05_28_100001_add_net_term_days_and_visit_address_to_customers_table.php
2026_05_29_100001_create_fn_to_kana_search.php
2026_05_29_100002_update_proc_customer_price_list_kana_search.php
2026_06_04_100001_create_customer_product_policy_prices_table.php
2026_06_04_100001_create_product_comments_table.php
2026_06_05_140000_fix_backorder_report_arrival_suppression_by_detail.php
2026_06_06_100000_add_avgcost_base_to_purchase_details_table.php
2026_06_06_100001_update_proc_customer_price_list_add_sales_prohibited.php
2026_06_08_100001_fix_report40_proc_zero_fill_categories.php
2026_06_09_100000_add_requested_delivery_date_to_edi_order_details_table.php
2026_06_09_110000_add_inventory_lookup_indexes_for_edi_order_shipment.php
2026_06_10_000001_add_business_type_id_to_products_table.php
2026_06_11_100000_add_proc_to_report_after_parts_order_request.php
2026_06_15_100000_add_index_to_shipment_id_on_sales_headers.php
2026_06_15_110000_add_department_id_to_sales_category_sales_reps_table.php
2026_06_15_120000_backfill_department_id_on_sales_category_sales_reps_table.php
2026_06_15_130000_fix_reports_40_41_43_45_47_57_proc_dept_hierarchy.php
2026_06_15_140000_fix_reports_51_to_56_proc_dept_hierarchy.php
2026_06_15_150000_fix_v_sales_product_metrics_resolved_department.php
2026_06_16_100000_case2_repick_sales_rep_for_credit_memo_backfill.php
2026_06_16_110000_fix_sato_missing_led_scsr.php
2026_06_16_120000_fix_oldera_null_dept_scsr.php
2026_06_16_130000_fix_reports_22_23_195_proc_dept_by_month.php
2026_06_18_140000_add_inventory_list_view_indexes_for_report90.php
2026_06_22_100000_add_indexes_for_customer_ledger_report.php
2026_07_07_100000_sp_backorder_arrival_date_null_absorb.php
2026_07_07_100000_sp_backorder_arrival_date_null_absorb.sql
2026_07_10_100000_add_bank_account_holder_name_normalized_to_customers.php
2026_07_13_100000_fix_kakuta_scsr_sales_rep_to_ishihara.php
2026_07_13_110000_create_nextengine_tokens_table.php
2026_07_13_120000_add_app_key_to_nextengine_tokens_table.php
2026_07_25_100000_create_replenishment_targets_table.php
2026_08_10_100000_create_customer_price_rank_schedules_table.php
2026_08_11_100000_create_edi_trusco_branches_table.php
2026_08_11_100001_create_edi_trusco_branch_category_sales_reps_table.php
2026_08_11_100002_create_edi_trusco_branch_sales_rep_schedules_table.php
2026_08_12_100000_backfill_priority_on_product_suppliers_table.php
2026_08_12_110000_create_product_price_change_schedules_table.php
2026_08_25_100000_change_nextengine_tokens_unique_key.php
2026_08_31_100000_fix_sp_backorder_sort_allocation_pattern.php
2026_08_31_100000_fix_sp_backorder_sort_allocation_pattern.sql
2026_09_03_100000_create_fb_import_receipt_types_table.php
2026_09_08_100000_fix_sp_backorder_sort_remove_allocation_policy.php
2026_09_08_100000_fix_sp_backorder_sort_remove_allocation_policy.sql