TAMS_MS_DB

Checkout Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 15
Last Commit: 03 Aug 10
Commits this week: 0
Total Lines of Code (LoC): 317,111
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 27 Feb 2023
8:54 am

Mike Crystal

[MSDB-439] merge completed, no errors, deleting branch
Options
  1. /branches/MSDB_2022_MS02
    • -335
    • +0
    /branches/MSDB_2022_MS02/procedures/sp_calc_discount.sql
  3. /branches/MSDB_2022_MS02/procedures
  4. /branches/MSDB_2022_MS02/IDS11
    • -122
    • +0
    /branches/MSDB_2022_MS02/procedures/sp_tu_9_2111.sql
    • -93
    • +0
    /branches/MSDB_2022_MS02/procedures/sp_tu_12_817.sql
    • -123
    • +0
    /branches/MSDB_2022_MS02/procedures/sp_tu_9_2103.sql
    • -111
    • +0
    /branches/MSDB_2022_MS02/procedures/sp_tu_68.sql
    • -16
    • +0
    /branches/MSDB_2022_MS02/views/vw_cust_pmt_charge.sql
  10. /branches/MSDB_2022_MS02/views
    • -141
    • +0
    /branches/MSDB_2022_MS02/procedures/sp_ti_53.sql
    • -85
    • +0
    /branches/MSDB_2022_MS02/procedures/sp_tu_186_1329.sql
    • -80
    • +0
    /branches/MSDB_2022_MS02/procedures/sp_ti_659.sql
    • -570
    • +0
    /branches/MSDB_2022_MS02/procedures/sp_remove_1_store.sql
    • -116
    • +0
    /branches/MSDB_2022_MS02/procedures/sp_add_inv_del.sql
  16. … 1135 more files in changeset.
Thursday 23 Feb 2023
8:50 am

jenkins

[MSDB-440]-Creating Branch from v.6.095 version of trunk
Options
  1. /branches/MSDB_2023_MS01
    • -0
    • +145
    /branches/MSDB_2023_MS01/procedures/sp_add_ar_terms.sql
    • -0
    • +75
    /branches/MSDB_2023_MS01/procedures/sp_ti_51.sql
    • -0
    • +123
    /branches/MSDB_2023_MS01/procedures/sp_tu_9_2101.sql
  5. /branches/MSDB_2023_MS01/procedures
    • -0
    • +125
    /branches/MSDB_2023_MS01/procedures/sp_tu_660_1303.sql
    • -0
    • +93
    /branches/MSDB_2023_MS01/procedures/sp_tu_12_807.sql
    • -0
    • +290
    /branches/MSDB_2023_MS01/procedures/sp_rpt_slsper_mtd.sql
    • -0
    • +167
    /branches/MSDB_2023_MS01/procedures/sp_tu_12_815.sql
    • -0
    • +85
    /branches/MSDB_2023_MS01/procedures/sp_tu_186_1319.sql
    • -0
    • +117
    /branches/MSDB_2023_MS01/procedures/sp_tu_58.sql
    • -0
    • +119
    /branches/MSDB_2023_MS01/procedures/sp_add_jif_trans.sql
    • -0
    • +1
    /branches/MSDB_2023_MS01/IDSXX/scripts/Backup Failure Notification/backupdb
    • -0
    • +22
    /branches/MSDB_2023_MS01/views/vw_customer_sales.sql
    • -0
    • +109
    /branches/MSDB_2023_MS01/procedures/sp_td_88.sql
  16. … 1135 more files in changeset.
Monday 20 Feb 2023
8:54 am

jenkins

[MSDB-439] Modified Files Verified, Conflicts Resolved for Merge from v.6.095 (MSDB_2022_MS02) into trunk
Options
    • -17881
    • +18003
    /trunk/IDS11/rdb.sql
    • -6
    • +8
    /trunk/procedures/sp_create_n_order.sql
    • -1
    • +1
    /trunk/tables/ord_sel_grp.sql
    • -16
    • +0
    /trunk/tables/factory.sql
    • -3
    • +4
    /trunk/procedures/sp_ti_70.sql
    • -13
    • +14
    /trunk/procedures/sp_create_ib_order.sql
    • -101
    • +62
    /trunk/procedures/sp_sim_ord.sql
  8. /trunk
    • -3
    • +10
    /trunk/procedures/sp_tu_70.sql
    • -2
    • +3
    /trunk/procedures/sp_ti_67.sql
    • -4
    • +3
    /trunk/tables/price_profile_detl.sql
    • -0
    • +9046
    /trunk/UpgradeScripts/Upgrade_v.6.094_to_v.6.095.sql
    • -4
    • +3
    /trunk/tables/cust_custom_price.sql
    • -1
    • +1
    /trunk/IDS11/pl_standard.sql
    • -2
    • +2
    /trunk/tables/customer.sql
  16. … 7 more files in changeset.
Thursday 16 Feb 2023
8:02 am

Mike Crystal

[MSDB-438] create new tag for MS Database project
Options
  1. /tags/v.6.095
Wednesday 15 Feb 2023
1:37 pm

Randall VanHorn

[TNSS-5049] These are many of the files that I used to help build msrecovery.
Options
    • -2
    • +2
    /branches/MSDB_2022_MS02/tables/customer.sql
    • -1
    • +1
    /branches/MSDB_2022_MS02/IDS11/pl_standard.sql
    • -2578
    • +0
    /branches/MSDB_2022_MS02/UpgradeScripts/Upgrade_v.6.092_to_v.6.093.sql
    • -16
    • +0
    /branches/MSDB_2022_MS02/tables/factory.sql
    • -17881
    • +18003
    /branches/MSDB_2022_MS02/IDS11/rdb.sql
    • -4
    • +3
    /branches/MSDB_2022_MS02/tables/price_profile_detl.sql
    • -1
    • +1
    /branches/MSDB_2022_MS02/tables/ord_sel_grp.sql
    • -2
    • +2
    /branches/MSDB_2022_MS02/tables/customer_ar.sql
    • -0
    • +9046
    /branches/MSDB_2022_MS02/UpgradeScripts/Upgrade_v.6.094_to_v.6.095.sql
    • -4
    • +3
    /branches/MSDB_2022_MS02/tables/cust_custom_price.sql
Friday 03 Feb 2023
9:05 am

Curtis McGough

[TNSS-4884] Orders are excluding parts that contain NULL values
Options
    • -6
    • +8
    /branches/MSDB_2022_MS02/procedures/sp_create_n_order.sql
9:04 am

Curtis McGough

[TNSS-4884] Orders are excluding parts that contain NULL values
Options
    • -11
    • +12
    /branches/MSDB_2022_MS02/procedures/sp_create_ib_order.sql
9:04 am

Curtis McGough

[TNSS-4884] Orders are excluding parts that contain NULL values
Options
    • -4
    • +5
    /branches/MSDB_2022_MS02/procedures/sp_create_f_order.sql
9:03 am

Curtis McGough

[TNSS-4884] Orders are excluding parts that contain NULL values
Options
    • -7
    • +8
    /branches/MSDB_2022_MS02/procedures/sp_sim_ord.sql
Monday 16 Jan 2023
9:07 am

Randall VanHorn

[TNSS-4574] Increased size of emails from 50 to 100.
Options
    • -1
    • +2
    /branches/MSDB_2022_MS02/procedures/sp_tu_67.sql
    • -3
    • +4
    /branches/MSDB_2022_MS02/procedures/sp_ti_70.sql
    • -1
    • +2
    /branches/MSDB_2022_MS02/procedures/sp_at2_cust_ar.sql
    • -2
    • +2
    /branches/MSDB_2022_MS02/procedures/sp_create_ib_order.sql
    • -2
    • +3
    /branches/MSDB_2022_MS02/procedures/sp_ti_67.sql
    • -3
    • +10
    /branches/MSDB_2022_MS02/procedures/sp_tu_70.sql
    • -1
    • +2
    /branches/MSDB_2022_MS02/procedures/sp_at2_customer.sql
Wednesday 04 Jan 2023
9:07 am

Curtis McGough

[STEL-813] DB Review - Part history is Taking Too Long To Load / Average of 15-20 Minutes / Some Stores Over an Hour
Options
    • -2
    • +3
    /branches/MSDB_2022_MS02/procedures/sp_ord_sql_error.sql
    • -1
    • +2
    /branches/MSDB_2022_MS02/procedures/sp_sim_ord.sql
Tuesday 20 Dec 2022
10:37 am

Curtis McGough

[TNSS-4631] - Apply Factory Order Updates per TNSS-4454 to Factory Order Sentinel Report

[TNSS-4667] - Factory Order Sentinel Report fails when using Days Supply

Options
    • -100
    • +59
    /branches/MSDB_2022_MS02/procedures/sp_sim_ord.sql
Wednesday 30 Nov 2022
1:16 pm

svc_acct_apgit_scm

[MSDB-437]-Creating Branch from v.6.094 version of trunk
Options
  1. /branches/MSDB_2022_MS02
    • -0
    • +335
    /branches/MSDB_2022_MS02/procedures/sp_calc_discount.sql
  3. /branches/MSDB_2022_MS02/IDS11
    • -0
    • +122
    /branches/MSDB_2022_MS02/procedures/sp_tu_9_2111.sql
    • -0
    • +93
    /branches/MSDB_2022_MS02/procedures/sp_tu_12_817.sql
    • -0
    • +123
    /branches/MSDB_2022_MS02/procedures/sp_tu_9_2103.sql
    • -0
    • +111
    /branches/MSDB_2022_MS02/procedures/sp_tu_68.sql
    • -0
    • +16
    /branches/MSDB_2022_MS02/views/vw_cust_pmt_charge.sql
    • -0
    • +141
    /branches/MSDB_2022_MS02/procedures/sp_ti_53.sql
    • -0
    • +85
    /branches/MSDB_2022_MS02/procedures/sp_tu_186_1329.sql
    • -0
    • +80
    /branches/MSDB_2022_MS02/procedures/sp_ti_659.sql
    • -0
    • +570
    /branches/MSDB_2022_MS02/procedures/sp_remove_1_store.sql
    • -0
    • +116
    /branches/MSDB_2022_MS02/procedures/sp_add_inv_del.sql
    • -0
    • +95
    /branches/MSDB_2022_MS02/procedures/sp_tu_15_261.sql
    • -0
    • +97
    /branches/MSDB_2022_MS02/tables/cust_dly_act.sql
  16. … 1135 more files in changeset.
Monday 28 Nov 2022
3:32 pm

Mike Crystal

[MSDB-436] merge branch to trunk completed, no errors.
Options
  1. /branches/MSDB_2022_MS01
    • -335
    • +0
    /branches/MSDB_2022_MS01/procedures/sp_calc_discount.sql
  3. /branches/MSDB_2022_MS01/procedures
  4. /branches/MSDB_2022_MS01/IDS11
    • -122
    • +0
    /branches/MSDB_2022_MS01/procedures/sp_tu_9_2111.sql
    • -123
    • +0
    /branches/MSDB_2022_MS01/procedures/sp_tu_9_2103.sql
    • -93
    • +0
    /branches/MSDB_2022_MS01/procedures/sp_tu_12_817.sql
    • -141
    • +0
    /branches/MSDB_2022_MS01/procedures/sp_ti_53.sql
    • -16
    • +0
    /branches/MSDB_2022_MS01/views/vw_cust_pmt_charge.sql
  10. /branches/MSDB_2022_MS01/views
    • -80
    • +0
    /branches/MSDB_2022_MS01/procedures/sp_ti_659.sql
    • -85
    • +0
    /branches/MSDB_2022_MS01/procedures/sp_tu_186_1329.sql
    • -111
    • +0
    /branches/MSDB_2022_MS01/procedures/sp_tu_68.sql
    • -95
    • +0
    /branches/MSDB_2022_MS01/procedures/sp_tu_15_261.sql
    • -116
    • +0
    /branches/MSDB_2022_MS01/procedures/sp_add_inv_del.sql
  16. … 1135 more files in changeset.
3:28 pm

svc_acct_apgit_scm

[MSDB-436] Modified Files Verified, Conflicts Resolved for Merge from v.6.094 (MSDB_2022_MS01) into trunk
Options
    • -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
  5. /trunk
    • -1
    • +2
    /trunk/procedures/sp_mon_purge.sql
Monday 21 Nov 2022
12:54 pm

Mike Crystal

[MSDB-435] create new branch for MS Database project
Options
  1. /tags/v.6.094
Monday 31 Oct 2022
2:21 pm

Curtis McGough

[TNSS-3555] - Change v_po_id varchar(8,0) to varchar(14)
Options
    • -1
    • +2
    /branches/MSDB_2022_MS01/procedures/sp_mon_purge.sql
Wednesday 19 Oct 2022
3:20 pm

Curtis McGough

[TNSS-4454] Multi-Store Performance Tuning
Options
    • -53
    • +18
    /branches/MSDB_2022_MS01/procedures/sp_create_f_order.sql
    • -49
    • +23
    /branches/MSDB_2022_MS01/procedures/sp_create_ib_order.sql
    • -52
    • +18
    /branches/MSDB_2022_MS01/procedures/sp_create_n_order.sql
7:55 am

Randall VanHorn

[TNSS-4072] Added sp_cancel_on_order to MS DB in order to reduce On Factory Order Quantities at Branch Stores.
Options
    • -0
    • +143
    /branches/MSDB_2022_MS01/procedures/sp_cancel_on_order.sql
Tuesday 18 Oct 2022
8:31 am

svc_acct_apgit_scm

[MSDB-434]-Creating Branch from v.6.093 version of trunk
Options
  1. /branches/MSDB_2022_MS01
    • -0
    • +335
    /branches/MSDB_2022_MS01/procedures/sp_calc_discount.sql
  3. /branches/MSDB_2022_MS01/IDS11
    • -0
    • +122
    /branches/MSDB_2022_MS01/procedures/sp_tu_9_2111.sql
    • -0
    • +123
    /branches/MSDB_2022_MS01/procedures/sp_tu_9_2103.sql
    • -0
    • +93
    /branches/MSDB_2022_MS01/procedures/sp_tu_12_817.sql
    • -0
    • +141
    /branches/MSDB_2022_MS01/procedures/sp_ti_53.sql
    • -0
    • +16
    /branches/MSDB_2022_MS01/views/vw_cust_pmt_charge.sql
    • -0
    • +80
    /branches/MSDB_2022_MS01/procedures/sp_ti_659.sql
    • -0
    • +85
    /branches/MSDB_2022_MS01/procedures/sp_tu_186_1329.sql
    • -0
    • +111
    /branches/MSDB_2022_MS01/procedures/sp_tu_68.sql
    • -0
    • +95
    /branches/MSDB_2022_MS01/procedures/sp_tu_15_261.sql
    • -0
    • +116
    /branches/MSDB_2022_MS01/procedures/sp_add_inv_del.sql
    • -0
    • +48
    /branches/MSDB_2022_MS01/procedures/sp_dt2_jif_spcsale.sql
    • -0
    • +97
    /branches/MSDB_2022_MS01/tables/cust_dly_act.sql
  16. … 1134 more files in changeset.
8:14 am

Mike Crystal

[MSDB-433] Delete branch. merge completed and verified
Options
  1. /branches/2021_MS01
    • -534
    • +0
    /branches/2021_MS01/procedures/sp_add_jif2.sql
  3. /branches/2021_MS01/procedures
    • -57
    • +0
    /branches/2021_MS01/tables/jif_sls.sql
  5. /branches/2021_MS01/tables
    • -101
    • +0
    /branches/2021_MS01/procedures/sp_td_657.sql
    • -52
    • +0
    /branches/2021_MS01/procedures/sp_del_ord_sel_grp.sql
    • -138
    • +0
    /branches/2021_MS01/procedures/sp_at2_prc_pro_det.sql
    • -82
    • +0
    /branches/2021_MS01/procedures/sp_tu_21_1114.sql
    • -100
    • +0
    /branches/2021_MS01/procedures/sp_tu_85_1111.sql
    • -19
    • +0
    /branches/2021_MS01/views/vw_prod_line_sales.sql
  12. /branches/2021_MS01/views
    • -67
    • +0
    /branches/2021_MS01/procedures/sp_ti_564.sql
    • -108
    • +0
    /branches/2021_MS01/procedures/sp_add_valid2.sql
    • -126
    • +0
    /branches/2021_MS01/procedures/sp_m4_record_grp.sql
  16. … 1134 more files in changeset.
Friday 14 Oct 2022
1:08 pm

Mike Crystal

[MSDB-433] Merge branch 2021_MS01 (v.6.093) to trunk for multistore DataBase
Options
    • -3
    • +0
    /trunk/procedures/sp_add_mif_super.sql
  2. /trunk
    • -91
    • +446
    /trunk/procedures/sp_at2_customer.sql
    • -486
    • +0
    /trunk/procedures/sp_add_customer3.sql
    • -1
    • +1
    /trunk/IDS11/scripts/setup.sh
    • -90
    • +0
    /trunk/procedures/sp_add_cust_stat.sql
    • -1
    • +9
    /trunk/tables/customer.sql
    • -1
    • +4
    /trunk/IDS11/pl_standard.sql
    • -2
    • +3
    /trunk/procedures/sp_get_po_info6.sql
  10. /trunk/UpgradeScripts
    • -16
    • +14
    /trunk/procedures/sp_ti_26.sql
    • -3
    • +0
    /trunk/procedures/systdist.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
  16. … 13 more files in changeset.
Tuesday 11 Oct 2022
10:14 am

Mike Crystal

[MSDB-432]create tag for MSDB project. tag is v.6.093
Options
  1. /tags/v.6.093
Thursday 22 Sep 2022
9:51 am

Randall VanHorn

[TNSS-3900] Add script updates and database create script.
Options
    • -2781
    • +2358
    /branches/2021_MS01/IDS11/rdb.sql
    • -8
    • +30
    /branches/2021_MS01/IDS11/scripts/instms1b.sh
    • -1
    • +1
    /branches/2021_MS01/IDS11/scripts/setup.sh
    • -1
    • +1
    /branches/2021_MS01/IDS11/scripts/setup2.sh
    • -1
    • +4
    /branches/2021_MS01/IDS11/pl_standard.sql
Tuesday 07 Jun 2022
11:10 am

Randall VanHorn

[TNSS-3681] The script to update the MS DB from v.6.092 to v.6.093
Options
  1. /branches/2021_MS01/UpgradeScripts
    • -0
    • +2578
    /branches/2021_MS01/UpgradeScripts/Upgrade_v.6.092_to_v.6.093.sql
Thursday 28 Apr 2022
8:16 am

Randall VanHorn

[TNSS-3393] Modified procedures/tables to allow invoice_email and statement_email to be transferred from TAMS to MS to branch TAMS stores.
Options
    • -1
    • +9
    /branches/2021_MS01/tables/customer.sql
    • -5
    • +7
    /branches/2021_MS01/procedures/sp_tu_67.sql
    • -1
    • +1
    /branches/2021_MS01/procedures/sp_tu_70.sql
    • -1
    • +9
    /branches/2021_MS01/tables/customer_ar.sql
    • -2
    • +2
    /branches/2021_MS01/procedures/sp_at2_cust_ar.sql
    • -1
    • +1
    /branches/2021_MS01/procedures/sp_at2_customer.sql
Tuesday 26 Apr 2022
4:47 pm

Randall VanHorn

[TNSS-3393] Modified procedures to allow invoice_email and statement_email to be transferred from TAMS to MS to branch TAMS stores.
Options
    • -3
    • +0
    /branches/2021_MS01/procedures/systdist.sql
    • -148
    • +113
    /branches/2021_MS01/procedures/sp_tu_67.sql
    • -62
    • +0
    /branches/2021_MS01/procedures/sp_up_cust_profile.sql
    • -12
    • +20
    /branches/2021_MS01/procedures/sp_ti_67.sql
    • -0
    • +19
    /branches/2021_MS01/procedures/sp_drop_trigger.sql
    • -486
    • +0
    /branches/2021_MS01/procedures/sp_add_customer3.sql
    • -91
    • +446
    /branches/2021_MS01/procedures/sp_at2_customer.sql
    • -37
    • +172
    /branches/2021_MS01/procedures/sp_at2_cust_ar.sql
    • -122
    • +68
    /branches/2021_MS01/procedures/sp_ti_70.sql
    • -92
    • +0
    /branches/2021_MS01/procedures/sp_add_cust_ar.sql
    • -3
    • +0
    /branches/2021_MS01/procedures/sp_add_mif_super.sql
    • -3
    • +0
    /branches/2021_MS01/procedures/sp_td_60.sql
    • -16
    • +14
    /branches/2021_MS01/procedures/sp_ti_26.sql
    • -90
    • +0
    /branches/2021_MS01/procedures/sp_add_cust_stat.sql
    • -113
    • +0
    /branches/2021_MS01/procedures/sp_asgn_prcprofile.sql
    • -85
    • +44
    /branches/2021_MS01/procedures/sp_tu_70.sql
Thursday 31 Mar 2022
3:49 pm

Randall VanHorn

[MSDB-425] Modified SQL to fix performance hit when D_E table gets large.
Options
    • -3
    • +4
    /branches/2021_MS01/procedures/sp_get_de_recs.sql
Wednesday 30 Mar 2022
3:49 pm

Randall VanHorn

[MSDB-424] Make sure all stores show in Stock Check (F11) even if Part DNE for that store
Options
    • -2
    • +3
    /branches/2021_MS01/procedures/sp_get_po_info6.sql
Wednesday 04 Aug 2021
8:51 am

Mike Crystal

[MSDB-419] create new branch for msdb build
Options
  1. /branches/2021_MS01
    • -0
    • +534
    /branches/2021_MS01/procedures/sp_add_jif2.sql
    • -0
    • +57
    /branches/2021_MS01/tables/jif_sls.sql
    • -0
    • +101
    /branches/2021_MS01/procedures/sp_td_657.sql
    • -0
    • +52
    /branches/2021_MS01/procedures/sp_del_ord_sel_grp.sql
    • -0
    • +138
    /branches/2021_MS01/procedures/sp_at2_prc_pro_det.sql
    • -0
    • +82
    /branches/2021_MS01/procedures/sp_tu_21_1114.sql
    • -0
    • +100
    /branches/2021_MS01/procedures/sp_tu_85_1111.sql
    • -0
    • +19
    /branches/2021_MS01/views/vw_prod_line_sales.sql
    • -0
    • +67
    /branches/2021_MS01/procedures/sp_ti_564.sql
    • -0
    • +108
    /branches/2021_MS01/procedures/sp_add_valid2.sql
    • -0
    • +126
    /branches/2021_MS01/procedures/sp_m4_record_grp.sql
    • -0
    • +178
    /branches/2021_MS01/procedures/sp_ti_661.sql
    • -0
    • +96
    /branches/2021_MS01/procedures/sp_td_21.sql
    • -0
    • +24
    /branches/2021_MS01/procedures/ansinumprecradix.sql
  16. … 1139 more files in changeset.