TAMS_MS_DB

Checkout Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
[MSDB-445] merge completed, no errors, deleting branch
  1. … 1236 more files in changeset.
[MSDB-445] Modified Files Verified, Conflicts Resolved for Merge from v.6.097 (MSDB_2023_MS02) into trunk
    • -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
    • -3
    • +4
    /trunk/procedures/sp_create_n_order.sql
    • -3
    • +10
    /trunk/procedures/sp_create_ns_order.sql
    • -23
    • +32
    /trunk/procedures/sp_sim_ord.sql
  1. … 194 more files in changeset.
[MSDB-444] create new tag for tamsii ms database
[MSAPP-1657] Add Upgrade_v.6.096_to_v.6.097.sql

[MSAPP-1651] Create MS_Recovery file for DB v.6.096
    • -0
    • +0
    /branches/MSDB_2023_MS02/IDS11_scr/readme
  1. … 182 more files in changeset.
[TNSS-4151] Add dc_only to the Inventory (JIF) table.
    • -0
    • +2
    /branches/MSDB_2023_MS02/tables/jif.sql
[MSAPP-1568] Add Warehouse Overstock Calculation.
[MSAPP-1638] Prevent change to supplier when su_id = 1 and DC_Only = 'Y'
[MSAPP-1639] Add DC_Only flag for DCM
[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
[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

[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
[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
[MSAPP-1625] Added DC_ONLY = Y and SU_ID = 1 to act as SU_ID = 0
[MSDB-443]-Creating Branch from v.6.096 version of trunk
  1. … 1135 more files in changeset.
[MSDB-440] merge completed, no errors, deleting branch
  1. … 1135 more files in changeset.
[MSDB-442] Modified Files Verified, Conflicts Resolved for Merge from v.6.096 (MSDB_2023_MS01) into trunk
    • -0
    • +2
    /trunk/procedures/sp_create_f_order.sql
[MSDB-441] create new tag for tamsii ms database
[MSAPP-1628] Update additional files for v.6.096.
    • -1
    • +1
    /branches/MSDB_2023_MS01/IDS11/pl_standard.sql
[MSAPP-1628] Added DC_Only to Factory Order Creation routine.
[MSDB-439] merge completed, no errors, deleting branch
  1. … 1135 more files in changeset.
[MSDB-440]-Creating Branch from v.6.095 version of trunk
  1. … 1135 more files in changeset.
[MSDB-439] Modified Files Verified, Conflicts Resolved for Merge from v.6.095 (MSDB_2022_MS02) into trunk
    • -17881
    • +18003
    /trunk/IDS11/rdb.sql
    • -6
    • +8
    /trunk/procedures/sp_create_n_order.sql
    • -13
    • +14
    /trunk/procedures/sp_create_ib_order.sql
    • -101
    • +62
    /trunk/procedures/sp_sim_ord.sql
  1. … 7 more files in changeset.
[MSDB-438] create new tag for MS Database project
[TNSS-5049] These are many of the files that I used to help build msrecovery.
    • -1
    • +1
    /branches/MSDB_2022_MS02/IDS11/pl_standard.sql
    • -17881
    • +18003
    /branches/MSDB_2022_MS02/IDS11/rdb.sql
    • -1
    • +1
    /branches/MSDB_2022_MS02/tables/ord_sel_grp.sql
    • -2
    • +2
    /branches/MSDB_2022_MS02/tables/customer_ar.sql
[TNSS-4884] Orders are excluding parts that contain NULL values
[TNSS-4884] Orders are excluding parts that contain NULL values
[TNSS-4884] Orders are excluding parts that contain NULL values
[TNSS-4884] Orders are excluding parts that contain NULL values
[TNSS-4574] Increased size of emails from 50 to 100.