Taurus Software
Ecomedate Release 3/6/2007
| File Name | Change Date | Case Number | Description | Affected Field |
| 01_SETUP\Setup Queue 20061110\SETUP Queue 20061110.xls | 11/7/2006 | 9002 | Modified column name from desc to wh_desc | 01i_warehouse_mast |
| 01_SETUP\Setup Queue 20061110\SETUP Queue 20061110.xls | 11/10/2006 | 9065 | Changed table name for meta data | 01b_style_header |
| 01_SETUP\Setup Queue 20061110\SETUP Queue 20061110.xls | 11/13/2006 | 9076 | Removed meta data columns | 01d_vend_ord_tel_fax |
| 04_CUST\Customer Queue 20061115\Customer Queue 20061115.xls | 11/13/2006 | 9077 | Changed meta data business table name | 04i_credit_approval |
| 04_CUST\Customer Queue 20061115\Customer Queue 20061115.xls | 11/15/2006 | 9100 | Corrected mapping to reference home phone fields | 04d_cust_tel_night_phone |
| 05_CSTX\CSTX Queue 20061129\CSTX Queue 20061129.xls | 11/7/2006 | 9905 | Correction selection criteria for _oth mapping | 05a_cust_oth |
| 05_CSTX\CSTX Queue 20061129\CSTX Queue 20061129.xls | 11/16/2006 | 8764 | Add third-party dataset to Ecomedate | 05b_third_party |
| 05_CSTX\CSTX Queue 20061129\CSTX Queue 20061129.xls | 11/29/2006 | 8884 | Modified selection criteria to use macros | 05a_cust_fop, 05a_cust_payer, 05a_cust_dm, 05a_cust_site, 05a_cust_offer, 05a_cust_email, 05a_cust_email_u, 05a_cust_ship_to, 05a_cust_site, 05a_cust_payer, 05a_cust_oth, 05a_cust_dg, 05a_cust_mem, 05a_cust_lgcy, 05a_cust_serial_nr, 05a_cust_web |
| 06_ORD\Order Queue 20070201\Order Queue 20070201.xls | 11/9/2006 | 6831 | Add meta data columns to mappings | 06a_or_601_order_header, 06a_or_700_order_header, 06a_order_header, 06b_order_sub_head, 06b_sales_ord_lines, 06c_customization, 06c_customization_source, 06d_cust_ord_xref, 06d_dbcr_doc_xref, 06d_sales_ord_acct_inst, 06d_sales_ord_cc_inst, 06d_sales_ord_p |
| 06_ORD\Order Queue 20070201\Order Queue 20070201.xls | 1/5/2007 | 9306 | add breakout columns for BIG_DATA and BIG_DATA2 for use as keys | 06e_process_oth |
| 06_ORD\Order Queue 20070201\Order Queue 20070201.xls | 1/30/2007 | 9492 | change mapping for SALES_ORD_LN_NR; add EDP_NO_ID to key | 06e_process_po_create |
| 06_ORD\Order Queue 20070201\Order Queue 20070201.xls | 2/1/2007 | 9637 | Embedded cr/lf in sales_ord_mail_dt | 06a_order_header |
| 07_ORDS\ORDS Queue 20070108\ORDS Queue 20070108.xls | 11/10/2006 | 6831 | Add meta data columns | 07a_sales_oh_additions, 07b_sales_ord_comm, 07b_sales_ord_comm_s_to, 07b_sales_ord_comm_sment, 07c_service_track, 07c_service_trk_alt_cust, 07c_service_trk_ord, 07c_service_trk_res, 07d_gift_cards, 07d_gift_certs, 07d_gifts_coups, 07e_ar_comments |
| 08_OA\OA Queue 20070130\OA Queue 20070130.xls | 11/17/2006 | 6831 | Add meta data columns to mapping | all order action mappings |
| 08_OA\OA Queue 20070130\OA Queue 20070130.xls | 1/5/2007 | 9382 | Correct fop_type_lgcy_cd column mapping in _cc table | 08a_oa_dbcr_oacc, 08a_oa_ord_cc, 08a_oa_ord_smt_cc, 08a_oa_ord_sto_cc, 08a_or_601_oa_dbcr_oacc, 08a_or_601_oa_ord_cc, 08a_or_601_oa_ord_smt_cc, 08a_or_601_ord_sto_cc, 08a_or_700_oa_ord_cc, 08a_or_700_oa_ord_smt_cc, 08a_or_700_oa_ord_sto_cc |
| 08_OA\OA Queue 20070130\OA Queue 20070130.xls | 1/30/2007 | 9504 | Add keynum field to mapping | 08a_or_801_oa_cust_oth, 08a_or_801_oa_dbcr_oarc, 08a_or_801_oa_dbcr_oth, 08a_or_801_oa_ord_oth, 08a_or_801_cust_inqry, 08a_or_801_cust_oawo, 08a_or_801_cust_oth, |
| 08_OA\OA Queue 20070130\OA Queue 20070130.xls | 1/30/2007 | 9504 | Add keynum field to mapping | 08a_or_801_ord_bocan, 08a_or_801_oa_ord_cc, 08a_or_801_oa_ord_cpn, 08a_or_801_oa_ord_ctg, 08a_or_801_oa_ord_gftcrt, 08a_or_801_oa_ord_oarels, 08a_or_801_oa_ord_oarels, 08a_or_801_oa_ord_oawo, 08a_or_801_oa_ord_omcscr, 08a_or_801_oa_ord_omrels, 08a_or_801_ |
| 08_OA\OA Queue 20070130\OA Queue 20070130.xls | 1/30/2007 | 9504 | Add keynum field to mapping | 08a_or_801_oa_ord_redeem, 08a_or_801_oa_ord_smc, 08a_or_801_oa_ord_ord_smt_cc, 08a_or_801_oa_ord_smt_cpn, 08a_or_801_oa_ord_smg_ctg, 08a_or_801_oa_ord_smt_orc, 08a_or_801_oa_ord_sto_cc, 08a_or_801_oa_ord_sto_ctg, 08a_or_801_oa_ord_sto_smc, 08a_or_801_oa_o |
| 08_OA\OA Queue 20070130\OA Queue 20070130.xls | 2/2/2007 | 9663 | Change selection criteria to macros | all order action mappings |
| 09_ORDO\ORDO 20070202\ORDO Queue 20070201.xls | 11/16/2006 | 9090 | change criteria to include open and closed RAs; add OPEN_RA_IND field and populate with Y/N to indicate if the RA is open | 09d_return_auth |
| 09_ORDO\ORDO 20070202\ORDO Queue 20070201.xls | 11/17/2006 | 6831 | Add meta data to mappings | 09A_BACK_ORDER, 09b_pick_lot_header, 09c_or_601_pick_lot_detail, 09c_pick_lot_det_ds, 09c_pick_lot_det_wh, 09c_pick_lot_detail, 09d_exchg_returns, 09d_or_601_returns, 09d_proc_return, 09d_return_auth, 09d_returns, 09e_ma_601_manifest_entries, 09e_ma_700_m |
| 09_ORDO\ORDO 20070202\ORDO Queue 20070201.xls | 2/1/2007 | 9641 | Changed pkg_cd to calc_pkg_cd macrod | 09e_manifest_entries, 09e_mani_call_tag |
| 10_PO\PO Queue 20070112\PO Queue 20070112.xls | 11/17/2006 | 6831 | Add meta data columns to mapping | all po mappings |
| 11_INV\INV Queue 20070226\INV Queue 20070226.xls | 11/17/2006 | 6831 | Add meta data columns to mapping | 11e_inv_count_data, 11d_added4_rtv_comm, 11d_added4_rf_inv, 11d_added4_inv_dtls, 11d_added4_galv_clss, 11d_added4_dunning, 11c_cycle_data, 11b_inv_details_por, 11b_inv_details, 11a_it_601_inv_trans_outbound, 11a_it_601_inv_trans_inbound, 11a_it_601_invent |
| 12_FIN\FIN 20070221\Financial Order Object 20070221.xls | 11/17/2006 | 6831 | Add meta data columns to mapping | 12a_ft_ship_to_amt, 12a_ft_ship_to, 12a_ft_ship_amt, 12a_ft_ship, 12a_ft_sales_ord_amt, 12a_ft_sales_ord, 12a_ft_inv_trans_amt, 12a_ft_inv_trans, 12a_ft_doc_amt, 12a_ft_doc, 12a_ft_cust_amt, 12a_ft_cust |
| 12_FIN\FIN 20070221\Financial Order Object 20070221.xls | 12/20/2006 | 9297 | Exclude level 9999 from selection criteria because these are not shipments | 12a_ft_ship, 12a_ft_ship_amt |
| 12_FIN\FIN 20070221\Financial Order Object 20070221.xls | 1/8/2007 | 9401 | Switched selection criteria to macro. Selection criteria was too long | 12a_ft_ship, 12a_ft_ship_amt |
| 12_FIN\FIN 20070221\Financial Order Object 20070221.xls | 1/17/2007 | 9437 | Change selection criteria to exclude "46" records | 12a_ft_ship_to_amt, 12a_ft_ship_to, 12a_ft_sales_ord_amt, 12a_ft_sales_ord |
| 12_FIN\FIN 20070221\Financial Order Object 20070221.xls | 2/21/2007 | 9742 | Include in selection transactions 31-38, 44 and str(full-order-no,9,4) = "9999" | 12a_ft_inv_trans, 12a_ft_inv_trans_amt |
| 13_SUM\SUM Queue 20070301\SUM 20070301.xls | 1/11/2007 | 7091 | Add macs-snapshot to Ecomedate | sv_macitm_macs_snapshot |