TAMS_MS_DB

Checkout Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
[MSDB-436] merge branch to trunk completed, no errors.
  1. … 1135 more files in changeset.
[MSDB-436] Modified Files Verified, Conflicts Resolved for Merge from v.6.094 (MSDB_2022_MS01) into trunk
    • -49
    • +23
    /trunk/procedures/sp_create_ib_order.sql
    • -0
    • +143
    /trunk/procedures/sp_cancel_on_order.sql
    • -53
    • +18
    /trunk/procedures/sp_create_f_order.sql
    • -52
    • +18
    /trunk/procedures/sp_create_n_order.sql
[MSDB-435] create new branch for MS Database project
[TNSS-3555] - Change v_po_id varchar(8,0) to varchar(14)
[TNSS-4454] Multi-Store Performance Tuning
[TNSS-4072] Added sp_cancel_on_order to MS DB in order to reduce On Factory Order Quantities at Branch Stores.
[MSDB-434]-Creating Branch from v.6.093 version of trunk
    • -0
    • +97
    /branches/MSDB_2022_MS01/tables/cust_dly_act.sql
  1. … 1134 more files in changeset.
[MSDB-433] Delete branch. merge completed and verified
    • -57
    • +0
    /branches/2021_MS01/tables/jif_sls.sql
  1. … 1134 more files in changeset.
[MSDB-433] Merge branch 2021_MS01 (v.6.093) to trunk for multistore DataBase
    • -3
    • +0
    /trunk/procedures/sp_add_mif_super.sql
    • -91
    • +446
    /trunk/procedures/sp_at2_customer.sql
    • -486
    • +0
    /trunk/procedures/sp_add_customer3.sql
    • -90
    • +0
    /trunk/procedures/sp_add_cust_stat.sql
    • -113
    • +0
    /trunk/procedures/sp_asgn_prcprofile.sql
    • -37
    • +172
    /trunk/procedures/sp_at2_cust_ar.sql
    • -0
    • +19
    /trunk/procedures/sp_drop_trigger.sql
  1. … 13 more files in changeset.
[MSDB-432]create tag for MSDB project. tag is v.6.093
[TNSS-3900] Add script updates and database create script.
    • -2781
    • +2358
    /branches/2021_MS01/IDS11/rdb.sql
    • -8
    • +30
    /branches/2021_MS01/IDS11/scripts/instms1b.sh
    • -1
    • +4
    /branches/2021_MS01/IDS11/pl_standard.sql
[TNSS-3681] The script to update the MS DB from v.6.092 to v.6.093
[TNSS-3393] Modified procedures/tables to allow invoice_email and statement_email to be transferred from TAMS to MS to branch TAMS stores.
    • -1
    • +9
    /branches/2021_MS01/tables/customer.sql
[TNSS-3393] Modified procedures to allow invoice_email and statement_email to be transferred from TAMS to MS to branch TAMS stores.
    • -0
    • +19
    /branches/2021_MS01/procedures/sp_drop_trigger.sql
    • -91
    • +446
    /branches/2021_MS01/procedures/sp_at2_customer.sql
[MSDB-425] Modified SQL to fix performance hit when D_E table gets large.
[MSDB-424] Make sure all stores show in Stock Check (F11) even if Part DNE for that store
[MSDB-419] create new branch for msdb build
    • -0
    • +57
    /branches/2021_MS01/tables/jif_sls.sql
  1. … 1139 more files in changeset.
[MSDB-398] Branch merged to trunk. merge has been verified. delete branch.
    • -24
    • +0
    /branches/MSDB_2020_MS03/tables/pl_admrole.sql
    • -56
    • +0
    /branches/MSDB_2020_MS03/tables/ord_sel_st.sql
    • -30
    • +0
    /branches/MSDB_2020_MS03/tables/pl_admin.sql
    • -41
    • +0
    /branches/MSDB_2020_MS03/tables/pl_obj_attr.sql
    • -53
    • +0
    /branches/MSDB_2020_MS03/views/vw_inventory.sql
  1. … 1139 more files in changeset.
[MSDB-410] Modified Files Verified, Conflicts Resolved for Merge from v.6.092 (MSDB_2020_MS03) into trunk
    • -471
    • +0
    /trunk/procedures/sp_add_jif.sql
    • -1
    • +15
    /trunk/procedures/sp_at2_mif_super.sql
    • -7
    • +4
    /trunk/procedures/sp_transfer_sales.sql
    • -14
    • +41
    /trunk/procedures/sp_add_inv_part.sql
    • -841
    • +0
    /trunk/procedures/sp_add_inv_part2.sql
    • -20262
    • +18491
    /trunk/IDS11/rdb.sql
    • -7
    • +18
    /trunk/procedures/sp_tu_18_1185.sql
    • -5
    • +1
    /trunk/procedures/sp_up_part_prices.sql
    • -699
    • +726
    /trunk/procedures/sp_create_ib_order.sql
    • -3
    • +4
    /trunk/procedures/sp_add_ord_session.sql
  1. … 8 more files in changeset.
[MSDB-409] create new tag for MSDB project from branch MSDB_2020_MS03
[MSDB-408] Script, DB Schema and table changes.
    • -63
    • +48
    /branches/MSDB_2020_MS03/IDS11/pl_standard.sql
    • -1
    • +11
    /branches/MSDB_2020_MS03/tables/store.sql
    • -20262
    • +18491
    /branches/MSDB_2020_MS03/IDS11/rdb.sql
    • -1
    • +2
    /branches/MSDB_2020_MS03/tables/ord_sel_grp.sql
[MSDB-408] Check in changes in for 2020_MS03.
    • -0
    • +19
    /branches/MSDB_2020_MS03/procedures/sp_drop_procedure.sql
[MSDB-398]-Creating Branch from v.6.091 version of trunk
    • -0
    • +24
    /branches/MSDB_2020_MS03/tables/pl_admrole.sql
    • -0
    • +55
    /branches/MSDB_2020_MS03/tables/ord_sel_st.sql
    • -0
    • +30
    /branches/MSDB_2020_MS03/tables/pl_admin.sql
    • -0
    • +41
    /branches/MSDB_2020_MS03/tables/pl_obj_attr.sql
    • -0
    • +53
    /branches/MSDB_2020_MS03/views/vw_inventory.sql
    • -0
    • +34
    /branches/MSDB_2020_MS03/tables/misc_chg.sql
  1. … 1141 more files in changeset.
[MSDB-381] merge branch to tag, confirmed merge completed.
    • -5493
    • +0
    /branches/MSDB_2020_MS02/IDS11/pl_standard.sql
    • -137369
    • +0
    /branches/MSDB_2020_MS02/IDS11/rdb.sql
    • -24
    • +0
    /branches/MSDB_2020_MS02/tables/pl_admrole.sql
    • -55
    • +0
    /branches/MSDB_2020_MS02/tables/ord_sel_st.sql
    • -30
    • +0
    /branches/MSDB_2020_MS02/tables/pl_admin.sql
  1. … 1141 more files in changeset.
[MSDB-396] Modified Files Verified, Conflicts Resolved for Merge from v.6.091 (MSDB_2020_MS02) into trunk
    • -13
    • +41
    /trunk/procedures/sp_create_ns_order.sql
    • -30
    • +47
    /trunk/procedures/sp_sync_inventory.sql
    • -8316
    • +8538
    /trunk/IDS11/rdb.sql
    • -161
    • +141
    /trunk/procedures/sp_poitem_datastor.sql
    • -15
    • +180
    /trunk/procedures/sp_valid_warehouse.sql
    • -2
    • +24
    /trunk/procedures/sp_create_f_order.sql
[MSDB-395] created new tag for multi store build
[MSDB-394] Update Database Install Scripts and Schemas
    • -1
    • +1
    /branches/MSDB_2020_MS02/IDS11/pl_standard.sql
    • -8316
    • +8538
    /branches/MSDB_2020_MS02/IDS11/rdb.sql
[MSDB-381]-Creating Branch from v.6.090 version of trunk
    • -0
    • +24
    /branches/MSDB_2020_MS02/tables/pl_admrole.sql
    • -0
    • +55
    /branches/MSDB_2020_MS02/tables/ord_sel_st.sql
    • -0
    • +30
    /branches/MSDB_2020_MS02/tables/pl_admin.sql
    • -0
    • +41
    /branches/MSDB_2020_MS02/tables/pl_obj_attr.sql
    • -0
    • +53
    /branches/MSDB_2020_MS02/views/vw_inventory.sql
    • -0
    • +34
    /branches/MSDB_2020_MS02/tables/misc_chg.sql
  1. … 1141 more files in changeset.
[MSDB-373] Branch merged to trunk. merge has been verified. delete branch.
    • -136
    • +0
    /branches/MSDB_2020_MS01/tables/mif_super.sql
    • -110
    • +0
    /branches/MSDB_2020_MS01/tables/jif_dept.sql
    • -233
    • +0
    /branches/MSDB_2020_MS01/tables/jif_trans.sql
    • -314
    • +0
    /branches/MSDB_2020_MS01/tables/prod_line.sql
    • -756
    • +0
    /branches/MSDB_2020_MS01/tables/jif.sql
    • -24
    • +0
    /branches/MSDB_2020_MS01/tables/pl_admrole.sql
    • -548
    • +0
    /branches/MSDB_2020_MS01/tables/supplier.sql
    • -30
    • +0
    /branches/MSDB_2020_MS01/tables/pl_admin.sql
  1. … 1141 more files in changeset.
[MSDB-378] Modified Files Verified, Conflicts Resolved for Merge from v.6.090 (MSDB_2020_MS01) into trunk
  1. … 178 more files in changeset.