TAMS_MS_DB

Checkout Tools
More
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 25 Aug 2023
1:06 pm

Mike Crystal

[MSDB-448] create new tag for branch msdb-2022_ms03
Options
  1. /tags/v.6.098
Tuesday 11 Jul 2023
9:51 am

Randall VanHorn

[MSAPP-1657] Create MS_Recovery file for DB v.6.098
Options
    • -25038
    • +24661
    /branches/MSDB_2022_MS03/IDS11_scr/lib/schemas/rdb.sql
    • -1
    • +2
    /branches/MSDB_2022_MS03/IDS11_scr/lib/pl_standard.sql
    • -8425
    • +0
    /branches/MSDB_2022_MS03/UpgradeScripts/Upgrade_v.6.096_to_v.6.097.sql
    • -1
    • +1
    /branches/MSDB_2022_MS03/IDS11_scr/readme
    • -0
    • +1836
    /branches/MSDB_2022_MS03/UpgradeScripts/Upgrade_v.6.097_to_v.6.098.sql
Thursday 06 Jul 2023
10:32 am

Randall VanHorn

[MSAPP-1663] Prevent an order from being released if Factory contains DC_Only /Supplier 1.
Options
    • -3
    • +48
    /branches/MSDB_2022_MS03/procedures/sp_release_po.sql
    • -584
    • +0
    /branches/MSDB_2022_MS03/procedures/sp_tms030_sync2.sql
10:32 am

Randall VanHorn

[MSAPP-1669] Modify MS DB to follow INVOICE_EMAIL_IN_USE flag
Options
    • -3
    • +22
    /branches/MSDB_2022_MS03/procedures/sp_tu_67.sql
Friday 09 Jun 2023
2:07 pm

Curtis McGough

[MSAPP-1661] Reason Code = 5 - Prevent DC Only = 'Y' and Supplier = 1 from being added
Options
    • -0
    • +15
    /branches/MSDB_2022_MS03/procedures/sp_add_po_item.sql
Thursday 08 Jun 2023
3:09 pm

Curtis McGough

[MSAPP-1668] Adding updates for MSDB-264 (Modify Order in PerCar) that sp_create_f_order.sql has that sp_sim_ord.sql does NOT have.
Options
    • -11
    • +13
    /branches/MSDB_2022_MS03/procedures/sp_sim_ord.sql
Tuesday 23 May 2023
3:44 pm

Randall VanHorn

[MSAPP-1659] Do not error if factory record Does Not Exist (DNE)
Options
    • -1
    • +11
    /branches/MSDB_2022_MS03/procedures/sp_add_fact_prefix.sql
    • -1
    • +10
    /branches/MSDB_2022_MS03/procedures/sp_add_fact_part.sql
3:43 pm

Randall VanHorn

[MSAPP-1658] Modified code to Skip PROTabs.
Options
    • -1
    • +6
    /branches/MSDB_2022_MS03/procedures/sp_add_factory.sql
3:43 pm

Randall VanHorn

[MSAPP-1659] Created DE-type 91 to create X1 records.
Options
    • -36
    • +15
    /branches/MSDB_2022_MS03/procedures/sp_cancel_on_order.sql
3:42 pm

Randall VanHorn

[MSAPP-1567] Remove stores (oss_st_id_purch) that are ordered for in ord_sel_st table.
Options
    • -2
    • +6
    /branches/MSDB_2022_MS03/procedures/sp_remove_1_store.sql
Wednesday 17 May 2023
10:31 am

jenkins

[MSDB-446]-Creating Branch from v.6.097 version of trunk
Options
  1. /branches/MSDB_2022_MS03
    • -0
    • +0
    /branches/MSDB_2022_MS03/IDS11_scr/lib/sp.dir/usr/sp/Utils/tms033_sync
    • -0
    • +93
    /branches/MSDB_2022_MS03/procedures/sp_tu_12_817.sql
    • -0
    • +123
    /branches/MSDB_2022_MS03/procedures/sp_tu_9_2103.sql
    • -0
    • +85
    /branches/MSDB_2022_MS03/procedures/sp_tu_186_1329.sql
    • -0
    • +111
    /branches/MSDB_2022_MS03/procedures/sp_tu_68.sql
    • -0
    • +141
    /branches/MSDB_2022_MS03/procedures/sp_ti_53.sql
    • -0
    • +335
    /branches/MSDB_2022_MS03/procedures/sp_calc_discount.sql
    • -0
    • +16
    /branches/MSDB_2022_MS03/views/vw_cust_pmt_charge.sql
    • -0
    • +80
    /branches/MSDB_2022_MS03/procedures/sp_ti_659.sql
    • -0
    • +116
    /branches/MSDB_2022_MS03/procedures/sp_add_inv_del.sql
    • -0
    • +570
    /branches/MSDB_2022_MS03/procedures/sp_remove_1_store.sql
    • -0
    • +95
    /branches/MSDB_2022_MS03/procedures/sp_tu_15_261.sql
    • -0
    • +97
    /branches/MSDB_2022_MS03/tables/cust_dly_act.sql
    • -0
    • +21
    /branches/MSDB_2022_MS03/IDS11_scr/lib/sp.dir/usr/sp/tab_sync_93.sql
  16. … 1236 more files in changeset.
Monday 15 May 2023
1:05 pm

Mike Crystal

[MSDB-445] merge completed, no errors, deleting branch
Options
  1. /branches/MSDB_2023_MS02
    • -75
    • +0
    /branches/MSDB_2023_MS02/procedures/sp_ti_51.sql
  3. /branches/MSDB_2023_MS02/procedures
    • -123
    • +0
    /branches/MSDB_2023_MS02/procedures/sp_tu_9_2101.sql
    • -145
    • +0
    /branches/MSDB_2023_MS02/procedures/sp_add_ar_terms.sql
    • -125
    • +0
    /branches/MSDB_2023_MS02/procedures/sp_tu_660_1303.sql
    • -85
    • +0
    /branches/MSDB_2023_MS02/procedures/sp_tu_186_1327.sql
    • -93
    • +0
    /branches/MSDB_2023_MS02/procedures/sp_tu_12_807.sql
    • -117
    • +0
    /branches/MSDB_2023_MS02/procedures/sp_tu_58.sql
    • -290
    • +0
    /branches/MSDB_2023_MS02/procedures/sp_rpt_slsper_mtd.sql
    • -167
    • +0
    /branches/MSDB_2023_MS02/procedures/sp_tu_12_815.sql
    • -85
    • +0
    /branches/MSDB_2023_MS02/procedures/sp_tu_186_1319.sql
    • -22
    • +0
    /branches/MSDB_2023_MS02/views/vw_customer_sales.sql
  14. /branches/MSDB_2023_MS02/views
    • -119
    • +0
    /branches/MSDB_2023_MS02/procedures/sp_add_jif_trans.sql
  16. … 1236 more files in changeset.
12:20 pm

jenkins

[MSDB-445] Modified Files Verified, Conflicts Resolved for Merge from v.6.097 (MSDB_2023_MS02) into trunk
Options
    • -8
    • +27
    /trunk/procedures/sp_valid_warehouse.sql
    • -5
    • +14
    /trunk/procedures/sp_create_f_order.sql
    • -2
    • +3
    /trunk/procedures/sp_add_ord_session.sql
    • -0
    • +8425
    /trunk/UpgradeScripts/Upgrade_v.6.096_to_v.6.097.sql
  5. /trunk/IDSXX
  6. /trunk/IDS11_scr
    • -0
    • +2
    /trunk/tables/jif.sql
    • -3
    • +7
    /trunk/procedures/sp_add_jif2.sql
    • -3
    • +4
    /trunk/procedures/sp_create_n_order.sql
  10. /trunk/IDS11
  11. /trunk
    • -3
    • +10
    /trunk/procedures/sp_create_ns_order.sql
    • -23
    • +32
    /trunk/procedures/sp_sim_ord.sql
    • -3
    • +19
    /trunk/procedures/sp_tu_88.sql
    • -1750
    • +0
    /trunk/UpgradeScripts/Upgrade_v.6.095_to_v.6.096.sql
  16. … 194 more files in changeset.
Friday 12 May 2023
1:20 pm

Mike Crystal

[MSDB-444] create new tag for tamsii ms database
Options
  1. /tags/v.6.097
Monday 01 May 2023
8:54 am

Randall VanHorn

[MSAPP-1657] Add Upgrade_v.6.096_to_v.6.097.sql

Options
    • -1750
    • +0
    /branches/MSDB_2023_MS02/UpgradeScripts/Upgrade_v.6.095_to_v.6.096.sql
    • -0
    • +8425
    /branches/MSDB_2023_MS02/UpgradeScripts/Upgrade_v.6.096_to_v.6.097.sql
Friday 28 Apr 2023
3:04 pm

Randall VanHorn

[MSAPP-1651] Create MS_Recovery file for DB v.6.096
Options
    • -0
    • +17
    /branches/MSDB_2023_MS02/IDS11_scr/lib/cron.dir/usr/mssupport/chk_client.sql
  2. /branches/MSDB_2023_MS02/IDS11_scr/lib/cron.dir/usr/ms_update
    • -0
    • +5
    /branches/MSDB_2023_MS02/IDS11_scr/lib/sp.dir/usr/sp/del_dups.sql
    • -0
    • +22
    /branches/MSDB_2023_MS02/IDS11_scr/lib/sp.dir/usr/sp/Utils/tab_sync_93.sql
    • -0
    • +0
    /branches/MSDB_2023_MS02/IDS11_scr/lib/cron.dir/usr/local/bin/format_flash
    • -0
    • +6
    /branches/MSDB_2023_MS02/IDS11_scr/lib/sp.dir/usr/sp/de_view.sql
    • -0
    • +2
    /branches/MSDB_2023_MS02/IDS11_scr/lib/cron.dir/informix/cron/weekly_reboot.sh
    • -0
    • +162
    /branches/MSDB_2023_MS02/IDS11_scr/lib/sp.dir/usr/sp/Utils/fix_jif_ytd_sls.sql
    • -0
    • +0
    /branches/MSDB_2023_MS02/IDS11_scr/lib/sp.dir/usr/sp/admin/mstrans_chk
    • -0
    • +0
    /branches/MSDB_2023_MS02/IDS11_scr/lib/cron.dir/usr/local/bin/mount_flash
    • -0
    • +162
    /branches/MSDB_2023_MS02/IDS11_scr/lib/sp.dir/usr/sp/Utils/tmsundel2.sql
    • -0
    • +0
    /branches/MSDB_2023_MS02/IDS11_scr/lib/sp.dir/usr/sp/admin/tms010_restart
    • -0
    • +3
    /branches/MSDB_2023_MS02/IDS11_scr/lib/cron.dir/informix/cron/sp/purge_mif.sql
    • -0
    • +0
    /branches/MSDB_2023_MS02/IDS11_scr/readme
    • -0
    • +398
    /branches/MSDB_2023_MS02/IDS11_scr/lib/sp.dir/usr/sp/Utils/change_store_numbers.sql
  16. … 182 more files in changeset.
2:52 pm

Randall VanHorn

[TNSS-4151] Add dc_only to the Inventory (JIF) table.
Options
    • -0
    • +2
    /branches/MSDB_2023_MS02/tables/jif.sql
2:41 pm

Randall VanHorn

[MSAPP-1568] Add Warehouse Overstock Calculation.
Options
    • -2
    • +3
    /branches/MSDB_2023_MS02/procedures/sp_add_ord_session.sql
2:38 pm

Randall VanHorn

[MSAPP-1638] Prevent change to supplier when su_id = 1 and DC_Only = 'Y'
Options
    • -3
    • +19
    /branches/MSDB_2023_MS02/procedures/sp_tu_88.sql
2:37 pm

Randall VanHorn

[MSAPP-1639] Add DC_Only flag for DCM
Options
    • -3
    • +7
    /branches/MSDB_2023_MS02/procedures/sp_add_jif2.sql
Monday 24 Apr 2023
7:44 am

Curtis McGough

[MSAPP-1641] 1 - Added wh_ostock_calc to call sp_valid_warehouse 2 - Added call to sp_po_both_up to correct PO header totals after other procedural updates
Options
    • -3
    • +10
    /branches/MSDB_2023_MS02/procedures/sp_create_ns_order.sql
7:43 am

Curtis McGough

[MSAPP-1641] 1 - Added use_super_parts and wh_ostock_calc to call sp_valid_warehouse 2 - Added total_disc_13_5 to handle rounding discrepancy with sp_create_f_order

[MSAPP-1627] Added dc_only check that Randall added to sp_create_f_order

Options
    • -23
    • +32
    /branches/MSDB_2023_MS02/procedures/sp_sim_ord.sql
7:41 am

Curtis McGough

[MSAPP-1641] 1 - Added wh_ostock_calc to call sp_valid_warehouse 2 - Added call to sp_po_both_up to correct PO header totals after other procedural updates
Options
    • -5
    • +14
    /branches/MSDB_2023_MS02/procedures/sp_create_f_order.sql
7:40 am

Curtis McGough

[MSAPP-1641] 1 - Added wh_ostock_calc to external calling procdure 2 - Modified ORD and RPT sections to use Zero, One, Min, or Max and also included WIP to calculate available quantity 3a - Added use_super_parts to the external calling procedure 3b - Added the setting of the product line and part number to determine supersedes
Options
    • -8
    • +27
    /branches/MSDB_2023_MS02/procedures/sp_valid_warehouse.sql
Wednesday 19 Apr 2023
8:33 am

Curtis McGough

[MSAPP-1625] Added DC_ONLY = Y and SU_ID = 1 to act as SU_ID = 0
Options
    • -3
    • +4
    /branches/MSDB_2023_MS02/procedures/sp_create_n_order.sql
Monday 27 Mar 2023
10:20 am

jenkins

[MSDB-443]-Creating Branch from v.6.096 version of trunk
Options
  1. /branches/MSDB_2023_MS02
    • -0
    • +75
    /branches/MSDB_2023_MS02/procedures/sp_ti_51.sql
    • -0
    • +123
    /branches/MSDB_2023_MS02/procedures/sp_tu_9_2101.sql
  4. /branches/MSDB_2023_MS02/procedures
    • -0
    • +145
    /branches/MSDB_2023_MS02/procedures/sp_add_ar_terms.sql
    • -0
    • +125
    /branches/MSDB_2023_MS02/procedures/sp_tu_660_1303.sql
    • -0
    • +85
    /branches/MSDB_2023_MS02/procedures/sp_tu_186_1327.sql
    • -0
    • +93
    /branches/MSDB_2023_MS02/procedures/sp_tu_12_807.sql
    • -0
    • +117
    /branches/MSDB_2023_MS02/procedures/sp_tu_58.sql
    • -0
    • +290
    /branches/MSDB_2023_MS02/procedures/sp_rpt_slsper_mtd.sql
    • -0
    • +167
    /branches/MSDB_2023_MS02/procedures/sp_tu_12_815.sql
    • -0
    • +85
    /branches/MSDB_2023_MS02/procedures/sp_tu_186_1319.sql
    • -0
    • +22
    /branches/MSDB_2023_MS02/views/vw_customer_sales.sql
    • -0
    • +119
    /branches/MSDB_2023_MS02/procedures/sp_add_jif_trans.sql
    • -0
    • +1
    /branches/MSDB_2023_MS02/IDSXX/scripts/Backup Failure Notification/backupdb
  16. … 1135 more files in changeset.
Friday 24 Mar 2023
8:59 am

Mike Crystal

[MSDB-440] merge completed, no errors, deleting branch
Options
  1. /branches/MSDB_2023_MS01
    • -145
    • +0
    /branches/MSDB_2023_MS01/procedures/sp_add_ar_terms.sql
  3. /branches/MSDB_2023_MS01/procedures
    • -75
    • +0
    /branches/MSDB_2023_MS01/procedures/sp_ti_51.sql
    • -123
    • +0
    /branches/MSDB_2023_MS01/procedures/sp_tu_9_2101.sql
    • -125
    • +0
    /branches/MSDB_2023_MS01/procedures/sp_tu_660_1303.sql
    • -93
    • +0
    /branches/MSDB_2023_MS01/procedures/sp_tu_12_807.sql
    • -290
    • +0
    /branches/MSDB_2023_MS01/procedures/sp_rpt_slsper_mtd.sql
    • -167
    • +0
    /branches/MSDB_2023_MS01/procedures/sp_tu_12_815.sql
    • -85
    • +0
    /branches/MSDB_2023_MS01/procedures/sp_tu_186_1319.sql
    • -117
    • +0
    /branches/MSDB_2023_MS01/procedures/sp_tu_58.sql
    • -119
    • +0
    /branches/MSDB_2023_MS01/procedures/sp_add_jif_trans.sql
    • -1
    • +0
    /branches/MSDB_2023_MS01/IDSXX/scripts/Backup Failure Notification/backupdb
  14. /branches/MSDB_2023_MS01/IDSXX/scripts/Backup Failure Notification
  15. /branches/MSDB_2023_MS01/IDSXX/scripts
  16. … 1135 more files in changeset.
8:57 am

jenkins

[MSDB-442] Modified Files Verified, Conflicts Resolved for Merge from v.6.096 (MSDB_2023_MS01) into trunk
Options
  1. /trunk
    • -0
    • +2
    /trunk/procedures/sp_create_f_order.sql
    • -9046
    • +0
    /trunk/UpgradeScripts/Upgrade_v.6.094_to_v.6.095.sql
    • -0
    • +1750
    /trunk/UpgradeScripts/Upgrade_v.6.095_to_v.6.096.sql
    • -1
    • +1
    /trunk/IDS11/pl_standard.sql
Thursday 23 Mar 2023
12:16 pm

Mike Crystal

[MSDB-441] create new tag for tamsii ms database
Options
  1. /tags/v.6.096
Wednesday 22 Mar 2023
10:34 am

Randall VanHorn

[MSAPP-1628] Update additional files for v.6.096.
Options
    • -0
    • +1750
    /branches/MSDB_2023_MS01/UpgradeScripts/Upgrade_v.6.095_to_v.6.096.sql
    • -9046
    • +0
    /branches/MSDB_2023_MS01/UpgradeScripts/Upgrade_v.6.094_to_v.6.095.sql
    • -1
    • +1
    /branches/MSDB_2023_MS01/IDS11/pl_standard.sql