Taurus Software
ECOMEDATE Release 8/25/2009
| File Name | Change Date | Case Number | Description | Affected Field |
| 01_SETUP\Setup Queue 20090825\SETUP Queue 20090825.xls | 11/18/2008 | 15196 | chg_dt references offer-discount | 01f_ph_types |
| 01_SETUP\Setup Queue 20090825\SETUP Queue 20090825.xls | 11/20/2008 | 15123 | corrected index | 01h_ref_restrict_ship_lgcy_cd |
| 01_SETUP\Setup Queue 20090825\SETUP Queue 20090825.xls | 3/5/2009 | 15873 | Add new breaktable for table type codes | 01h_table_type_lgcy_cd |
| 01_SETUP\Setup Queue 20090825\SETUP Queue 20090825.xls | 7/11/2009 | 16712 | Add reference data to support Manage including target market codes, list segments, and source type codes | 01h_ref_rep_mkt_lgcy_cd, 01h_ref_rep_list_lgcy_cd, 01h_ref_src_type_lgcy_cd |
| 01_SETUP\Setup Queue 20090825\SETUP Queue 20090825.xls | 7/11/2009 | 16713 | Make modifications to mappings to include new columns/breakout fields added in version 10 of Ecometry | 01e_ma_1000_ship_methods, 01g_it_1000_customize_dtl, 01i_ma_1000_warehouse_mast |
| 01_SETUP\Setup Queue 20090825\SETUP Queue 20090825.xls | 7/11/2009 | 16714 | Change meta data name for short_nm to reference the code that it is refering to. | 01h_ref_adj_reason_lgcy_cd, 01h_ref_auto_hold_lgcy_cd, 01h_ref_buyer_lgcy_cd, 01h_ref_canc_reas_lgcy_cd, 01h_ref_cs_cred_reas_lgcy_cd, 01h_ref_cust_action_lgcy_cd, 01h_ref_cust_sta_lgcy_cd, 01h_ref_cust_type_lgcy_cd, 01h_ref_discount_type_lgcy_cd, 01h_ref |
| 01_SETUP\Setup Queue 20090825\SETUP Queue 20090825.xls | 7/21/2009 | 16754 | Add folder names to all mappings in this queue | |
| 01_SETUP\Setup Queue 20090825\SETUP Queue 20090825.xls | 7/21/2009 | 15610 | Corrected key on sv_it_800_wh_locs from wh_loc_cd to slotid on open mapping | 01c_it_800_whse_locs |
| 01_SETUP\Setup Queue 20090825\SETUP Queue 20090825.xls | 8/24/2009 | 11787 | Add countries mapping to Ecomedate | 01l_countries |
| 02_ITEM\item queue 20090824\item Queue 20090824.xls | 3/5/2009 | 14490 | Fixed table description | 02b_item_pos_loc |
| 02_ITEM\item queue 20090824\item Queue 20090824.xls | 7/11/2009 | 16713 | Add new breakout columns/columns to mapping required for version 10 fields in Ecometry | 02a_1000_item_mast |
| 02_ITEM\item queue 20090824\item Queue 20090824.xls | 7/21/2009 | 16754 | Add folder names to all mappings in this queue | |
| 02_ITEM\item queue 20090824\item Queue 20090824.xls | 8/24/2009 | Added new table sv_macitm_itm_keywords which contains one row per keyword | 02f_itm_keywords | |
| 03_OFFER\offer queue 20090721\Offers Queue 20090721.xls | 3/5/2009 | 15871 | Add new source table to Ecomedate: feature-color | 03i_feature_color, 03i_featured_colors |
| 03_OFFER\offer queue 20090721\Offers Queue 20090721.xls | 3/5/2009 | 10248 | Correct expression for ent_dt to account for trailing spaces in time | 03e_offer_items, 03e_it_601_offer_items, 03e_it_800_offer_items, 03e_it_900_offer_items |
| 03_OFFER\offer queue 20090721\Offers Queue 20090721.xls | 7/11/2009 | 16713 | Added new breakout columns added in version 10 of Ecometry | 03a_it_1000_offers, 03e_it_1000_offer_items |
| 03_OFFER\offer queue 20090721\Offers Queue 20090721.xls | 7/11/2009 | 16715 | Add reference table meta data reference for new reference table added ref_src_type_lgcy_cd | 03b_sources |
| 03_OFFER\offer queue 20090721\Offers Queue 20090721.xls | 7/21/2009 | 16754 | Add folder names to mappings in this queue | |
| 04_CUST\Customer Queue 20090721\Customer Queue 20090721.xls | 7/21/2009 | 16754 | Add folder names to all mappings in this queue | |
| 05_CSTX\CSTX Queue 20090721\CSTX Queue 20090721.xls | 3/5/2009 | 9041 | Add source dataset added-data-2 to Ecomedate | |
| 05_CSTX\CSTX Queue 20090721\CSTX Queue 20090721.xls | 7/11/2009 | 16713 | Add new breakout columns or columns added in version 10 of Ecometry | 05a_or_1003_cust_fop |
| 05_CSTX\CSTX Queue 20090721\CSTX Queue 20090721.xls | 7/21/2009 | 16754 | Add folder names to all mappings in this queue | |
| 06_ORD\Order Queue 20090821\Order Queue 20090821.xls | 7/24/2008 | 14137 | Moved credit card installment billing records to _oth table. Data in Ecometry has unexpected binary data. Need macros >= 20080724 | 06e_process_order, 06e_or_801_process_order, 06e_process_oth, 06e_or_801_process_oth, 06e_process_cc, 06e_or_801_process_cc |
| 06_ORD\Order Queue 20090821\Order Queue 20090821.xls | 8/14/2008 | 14515 | Pass ACTION-SEARCH2 to macro - revised selection criteria to exclude installment billing Processing records | 06e_process_oth, 06e_or_801_process_oth, 06e_process_cc, 06e_or_801_process_cc, 06e_process_order, 06e_or_801_process_order |
| 06_ORD\Order Queue 20090821\Order Queue 20090821.xls | 3/5/2009 | 15874 | Corrected expression in cc_expire_dt to handle date which is in MMYY not YYMM as previously thought | 06j_standing_header, 06j_or_801_standing_header |
| 06_ORD\Order Queue 20090821\Order Queue 20090821.xls | 5/8/2009 | 16271 | Changed expression for pick_lot_cd to from IF(STR(FULL-ORDER-NO,11,2) > "00", IF (STR(PICK-LOT,1,1)="Y",PICK-LOT,$NULL), $NULL) to IF(STR(FULL-ORDER-NO,11,2) > "00", IF (STR(PICK-LOT,1,1)<>"Y",PICK-LOT,$NULL), $NULL) | 06b_sales_ord_lines |
| 06_ORD\Order Queue 20090821\Order Queue 20090821.xls | 5/11/2009 | 16262 | correct mapping of INSTALL_TABLE_LGCY_CD | 06a_or_900_order_header |
| 06_ORD\Order Queue 20090821\Order Queue 20090821.xls | 5/11/2009 | 15242 | Corrected expression for ship_conf_dt to capture the time at ship confirm | 06b_sales_ord_lines |
| 06_ORD\Order Queue 20090821\Order Queue 20090821.xls | 7/11/2009 | 16713 | Add new columns or breakout columns due to changes in version 10 of Ecometry | 06a_or_1000_order_header, 06i_or_1003_transmittal |
| 06_ORD\Order Queue 20090821\Order Queue 20090821.xls | 7/21/2009 | 16754 | Add folder names to add mappings in this queue | |
| 06_ORD\Order Queue 20090821\Order Queue 20090821.xls | 8/21/2009 | 16944 | Add columns eliminated in the b_ fix | 06e_or_801_process_ol_cc |
| 07_ORDS\ORDS Queue 20090824\ORDS Queue 20090824.xls | 7/21/2009 | 16754 | Add folder names to all mappings in this queue | |
| 07_ORDS\ORDS Queue 20090824\ORDS Queue 20090824.xls | 8/24/2009 | 16947 | correct mapping expressions for SRV_TRK_DT, SCH_FLW_UP_DT, SRV_TRK COMM; add index on CUST_EDP_ID | 07c_service_track, 07c_service_trk_res |
| 08_OA\OA Queue 20090825\OA Queue 20090825.xls | 7/21/2009 | 16754 | Add folders names to all mappings in this queue | |
| 08_OA\OA Queue 20090825\OA Queue 20090825.xls | 8/24/2009 | 16945 | Fixed expression for inq_dt to source from action-date instead of entry-date | 08a_oa_cust_inqry |
| 08_OA\OA Queue 20090825\OA Queue 20090825.xls | 8/25/2009 | 16967 | Remove keynum field from mapping | 08a_or_800_oa_ord_smt_cpn |
| 09_ORDO\ORDO 20090721\ORDO Queue 20090721.xls | 7/21/2009 | 16754 | Add folder names to all mappings in this queue | |
| 09_ORDO\ORDO 20090721\ORDO Queue 20090721.xls | 7/21/2009 | 16100 | Added original column CHECKED to mapping | 09c_or_800_pick_lot_details |
| 10_PO\PO Queue 20090721\PO Queue 20090721.xls | 7/21/2009 | 16754 | Add folder names to all mappings in this queue | |
| 11_INV\INV Queue 20090721\INV Queue 20090721.xls | 7/21/2009 | 16754 | Add folder names to all mappings in this queue | |
| 11_INV\INV Queue 20090721\INV Queue 20090721.xls | 7/21/2009 | 16238 | Added original column task-number back to the mapping | 11a_it_800_inv_trans |
| 12_FIN\FIN 20090721\Financial Order Object 20090721.xls | 4/20/2009 | 16154 | Add transaction code 75 to rules table to support new class of txs added in version 10 | |
| 12_FIN\FIN 20090721\Financial Order Object 20090721.xls | 7/21/2009 | 16754 | Add folder names to all mappings in this queue | |
| 13_SUM\SUM Queue 20090721\SUM 20090721.xls | 7/21/2009 | 16754 | Add folder names to all mappings in this queue |