Taurus Software

Ecomedate Release 8/16/2007

File NameChange DateCase NumberDescriptionAffected Field
01_SETUP\Setup Queue 20070807\SETUP Queue 20070807.xls7/3/200711081Value in src_cd referenced incorrect database was macord should be macitm. Changed to correct value.01j_ctl_mast, 01j_ref_maj_cat_lgcy_cd, 01j_ref_min_cat_lgcy_cd, 01j_ref_sub_maj_cat_lgcy_cd, 01j_ref_sub_min_cat_lgcy_cd
01_SETUP\Setup Queue 20070807\SETUP Queue 20070807.xls7/18/200711167Regenerated Warehouse_mast from source csv. Extraneous characters removed01i_warehouse_mast
01_SETUP\Setup Queue 20070807\SETUP Queue 20070807.xls7/27/200711220Selection criteria didn't return any rows of data. POS syntax was incorrect. Corrected01h_ref_ord_sub_sta_lgcy_cd
01_SETUP\Setup Queue 20070807\SETUP Queue 20070807.xls7/27/200711254Add new data fields AUTO_UPC_CD WEEKS_SUPPLY_CD ITMRPT_DEFAULT_CD which were new breakout fields added in version 9 of Ecometry. All fields are sourced from addl-data01d_it_700_vend_ord_from
01_SETUP\Setup Queue 20070807\SETUP Queue 20070807.xls7/27/200711253Added new data field AUTO_SHP_DRP_SHP_LGCY_CD which is sourced from addl-data01d_it_900_vend_ord_from
01_SETUP\Setup Queue 20070807\SETUP Queue 20070807.xls7/30/200711278Added new breakout columns for version 9. New fields added: NO_RETURN_LABEL_IND, DELIVERY_OPTION_LGCY_CD, SIGNATURE_OPTION_LGCY_CD and WEIGHT_TYPE_LGCY_CD. All sourced from SM-SHIPPER-INFO01e_ma_900_ship_methods
01_SETUP\Setup Queue 20070807\SETUP Queue 20070807.xls8/1/200711316Added new breakout columns for version 7. Missed in initial analysis. RETURN_WHS_CD, LABEL_ONLY_IND01i_ma_700_warehouse_mast
01_SETUP\Setup Queue 20070807\SETUP Queue 20070807.xls8/2/200711279Added new breakout columns for version 8. Missed in initial analysis. COMPL_TASK_CD, CREATE_MOVES_CD, SINGLES_STAGING_LOC_CD01i_ma_800_warehouse_mast
03_OFFER\offer queue 20070723\Offers Queue 20070723.xls7/17/200711218Add breakout columns to support new copylib entries for version 9: MARKET_LGCY_CD and INSTALL_TABLE_LGCY_CD sourced from additionaldata03a_it_900_offers
03_OFFER\offer queue 20070723\Offers Queue 20070723.xls7/23/200711202Add breakout columns which were added in version 8 but interadvertently left out of the mapping03a_it_800_offers, 03a_it_900_offers
03_OFFER\offer queue 20070723\Offers Queue 20070723.xls7/23/200711204Fields were inadvertently missed in original mappings. Fields are: standard_cost_amt, standard_overhead_amt, returns_pct03e_offers_items, 03e_it_601_offer_items
03_OFFER\offer queue 20070723\Offers Queue 20070723.xls7/23/200711204Fields were added in version 8 missing in original mapping. Fields are: active_cd, specials_cd03e_it_800_offer_items
03_OFFER\offer queue 20070723\Offers Queue 20070723.xls7/23/200711216Added new breakout column in version 9 of ecometry: INSTALL_TABLE_LGCY_CD03e_it_800_offer_items
04_CUST\Customer Queue 20070727\Customer Queue 20070727.xls7/27/200711257Added breakout column USPS_IND sourced from ADDL-DATA04c_customer_addl, 04c_or_700_customer_addl, 04c_or_900_customer_addl
04_CUST\Customer Queue 20070727\Customer Queue 20070727.xls7/27/200711264Add new mapping for version 7. Added SOC_SEC_CD sourced from ADDL-DATA04c_or_700_customer_addl
04_CUST\Customer Queue 20070727\Customer Queue 20070727.xls7/27/200711259Add new mapping for version 9. Added NO_SOLICIT_CD sourced from ADDL-DATA04c_or_900_customer_addl
06_ORD\Order Queue 20070807\Order Queue 20070807.xls7/18/200711166Expression incorrect for orig_prc_amt and inv_hard_alloc. Was IF(STR(OTHER-DATA[LINENBR1TO3],5,1) <> " ",FIELD(OTHER-DATA[LINENBR1TO3],5,"IMAGE J2") DIVF 100, $NULL) Should be FIELD(OTHER-DATA[LINENBR1TO3],5,"IMAGE J2") DIVF 100. For inv_hard_alloc was I06b_sales_ord_lines
06_ORD\Order Queue 20070807\Order Queue 20070807.xls7/19/200711285Added additional breakout columns included in version 9 for ORDERHEADER They are all sourced from FLAGS2. Fields are: REGISTER_CD, MARKET_LGCY_CD, UP_FRONT_OA_LGCY_CD and INSTALL_TABLE_LGCY_CD. Architecture of tracking installment billing code has chan06a_or_900_order_header
06_ORD\Order Queue 20070807\Order Queue 20070807.xls7/19/200711298Added additional breakout column included in version 9 for OPENAR. The new breakout field is called CREDIT_REDEEMED_IND and is sourced from ARTYPE.06f_or_900_open_ar
06_ORD\Order Queue 20070807\Order Queue 20070807.xls7/19/200711303Added additional breakout column included in version 9 for CLOSEDAR. The new breakout field is called CREDIT_REDEEMED_IND and is sourced from ARTYPE.06g_or_900_closed_ar
06_ORD\Order Queue 20070807\Order Queue 20070807.xls8/3/200711280Add new column for version 9: TRANS2_TYPE_LGCY_CD sourced from ACTION-SEARCH206i_or_900_transmittal
08_OA\OA Queue 20070807\OA Queue 20070807.xls8/3/200711282Add new breakout columns for version 8: NON_ECOM_CPN_IND, COUPON_DISCOUNT_AMT08a_or_800_oa_ord_smt_cpn, 08a_or_801_oa_ord_smt_cpn
09_ORDO\ORDO 20070730\ORDO Queue 20070730.xls7/19/200711189Add new breakout field SMARTLABEL09d_or_700_returns
09_ORDO\ORDO 20070730\ORDO Queue 20070730.xls7/19/200711311Add new breakout field SHIP_STAT_LGCY_CD which was added in version 9 of Ecometry09d_or_900_returns
09_ORDO\ORDO 20070730\ORDO Queue 20070730.xls7/19/200711312change PKG_CD and TRK_NR; TRK_NR is now consistently in positions 29 thru 50 of MISC-DATA-110; PKG_CD is now consistently in positions 17 thru 28 which changed in version 9 of Ecometry09e_ma_900_manifest_entries
10_PO\PO Queue 20070730\PO Queue 20070730.xls7/30/200711274Added new breakout columns to support version 9 of Ecometry. Columns added: ORIG_STAT_LGCY_CD, LOCKED_BY_USER_CD, TRANSFER_CD and RETAIL_PO_CD. All fields are sourced from ADDITIONALDATA.10a_it_900_po_header
10_PO\PO Queue 20070730\PO Queue 20070730.xls7/30/200711270Changed ADDL_COST_AMT from 4 decimals to 6; change ADDL_COST_PCT to recognize 6 places in source, but no change to target (changed expression to CHECKI4(ADDPRODUCTCOST, 6))10b_it_900_po_details
11_INV\INV Queue 20070807\INV Queue 20070807.xls8/3/200711284Add new breakout columns for version 8. New columns added were: STATUS2_LGCY_CD, ORIG_NONUSE_RSN_LGCY_CD both sourced from BIGDATA11d_it_800_added4_inv_dtls