Taurus Software

Manage Metrix ManageECO

4/23/2012

File NameChange DateCase NumberDescriptionAffected Field
DATA.xls2/29/201222524Add sample data file for mgc_vendor_compliance_issuesvendorcomplianceissues_data.csv
DATA.xls3/19/201222781Add sample data file for mgm_active_bohistory_dtmgm_active_bohistory_dt_data.csv
MACROS.xls2/28/201222669Add new macros: cntln, oneln, dts. Used in mgc_po_receipts 
MACROS.xls3/8/201222722Add new macros to help with customization. For sku table: mm_sku_class, mm_sku_category, mm_sku_subcategory, mm_sku_department, mm_sku_countryoforign, mm_sku_importeditemcd,mm_sku_privatelabelcd, mm_sku_newproductcd, mm_sku_dropshipind, mm_sku_coreproductind, mm_sku_includeininvind, mm_sku_includeinmerind, mm_sku_includeinmktind, mm_sku_includeinfinind 
MACROS.xls3/8/201222722Add new macros to help with customization. For offer table: mm_ofr_brand, mm_ofr_channel, mm_ofr_spotlighting, mm_ofr_marketinggoal,mm_ofr_event, mm_ofr_appliesto, mm_ofr_messagetobuy 
MACROS.xls3/22/201222810Add new macros for controlling approximate backorder table: mm_cbo and mm_cbo_cutoffdate 
MACROS.xls4/13/201222959Add new macros for additional items in mgc_skuMM_SKU_COLORATTRIBUTE, MM_SKU_SIZEATTRIBUTE, MM_SKU_OTHERATTRIBUTE, MM_SKU_BUYER, MM_SKU_MERCHANDISER
MGA.xls2/10/201222504Modified selection criteria to exclude source_cd = $nullmga_rtn_by_day_by_source, mga_rtn_by_day_offer_sku, mga_rtn_by_fp_by_sku, mga_rtn_by_fp_offer_sku, mga_rtn_by_source
MGC.xls2/14/201222583Correct mappings options in mgc_backorder_history tablemgc_back_order_history
MGC.xls2/14/201222531Change the number of days from 3 to 5 to be considered a backordermgc_back_order_history
MGC.xls2/14/201221864Correct index defintions on mgc_back_order_history tablemgc_back_order_history
MGC.xls2/15/201222586Add new table for keeping track of order header records per order numbermgc_order_cnt
MGC.xls2/15/201222586Add selection criteria for mgc_order_header to select only order number whose order header count = 1mgc_order_header
MGC.xls2/16/201220006Add new table to MM for po receiptsmgc_po_receipts
MGC.xls2/16/201220019Add new table to MM for return to vendor informationmgc_rtv
MGC.xls2/16/201220012Add new table to MM for vendor master informationmgc_vendor
MGC.xls2/16/201222540Changed purch_ord_ln_nr to decimal fieldmgc_po_receipts
MGC.xls2/16/201220463Remove time from receipt_dtmgc_po_receipts
MGC.xls2/16/201220575Change expression for purch_ord_ln_nr by change second lookup to min to avoid duplicate rowsmgc_po_receipts
MGC.xls2/16/201220235Change cost_amt to unit_cost amt in mgc_po_receiptsmgc_po_receipts
MGC.xls2/16/201220468Add vendor_nbr field into mgc_po_receiptsmgc_po_receipts
MGC.xls2/16/201220086Remove vendor_ prefix from name and address fieldsmgc_vendor
MGC.xls2/16/201220085Add extended_cost_amt field into mgc_po_receiptsmgc_po_receipts
MGC.xls2/28/201222669Modify purch_ord_ln_nr to use new macros: oneln, cntln, dtsmgc_po_receipts
MGC.xls2/28/201222668Modify expression to handle blank vend_cdmgc_po_receipts, mgc_vendor, mgc_vendor_sku, mgc_rtv, mgc_po_lines
MGC.xls2/28/201221305Change data type of purch_ord_ln_nr to decimal and change expression to yield decimal fieldmgc_po_lines
MGC.xls2/28/201221183Open_qty expression changed to only be populated if status = 'OP', 'RO', 'PR' and tot_to_be_rec_qty > 0mgc_po_lines
MGC.xls2/28/201220279Change mgc_vendor_compliance_issues to be at vendor level onlymgc_vendor_compliance_issues
MGC.xls2/29/201222239Change inventory_receive_dt to allow nullsmgc_inv_by_month
MGC.xls2/29/201220860Build hybrid approach for backorder history which allows those clients who have implemented bo_history in Ecomedate to use that data along with historical data load for records not in bo_historymgc_back_order_history, mgc_back_order_history_2
MGC.xls3/8/201222722Modify expression for product hierarchy, core attributes, and include in module indicators to use macrosmgc_sku
MGC.xls3/8/201222722Modified expression for brand, channel, and standard offer attributes to use macrosmgc_offers
MGC.xls3/22/201222810Add new table to hold approximated back order history datamgc_circa_back_order_history
MGC.xls3/22/201220860Modified mgc_back_order_history mapping to source from mgc_circa_back_order_historymgc_back_order_history
MGC.xls3/28/201222860Added folder name to mappingmgc_po_receipts, mgc_rtv
MGC.xls4/13/201222958Changed mappings to source brand from mgc_offers tablemgc_sources, mgc_order_header
MGC.xls4/13/201222960Use macros for buyer, merchandiser, color_attribute, size_attribute, other_attributemgc_sku
MGF.xls4/13/201222958Changed mappings to source brand from mgc_offersmgf_demand_line_facts, mgf_return_facts, mgf_shipped_line_facts
MGM.xls3/27/201222833Changed source column to reference correct data files for mgm_eco…tablesmgm_eco_xref_item_status, mgm_eco_xref_item_type, mgm_eco_xref_line_status, mgm_eco_xref_mediatype_grp, mgm_eco_xref_offer_channel, mgm_eco_xref_order_status, mgm_eco_xref_po_status, mgm_eco_xref_product_type