Taurus Software

Ecomedate Release 11/28/2006

File NameChange DateCase NumberDescriptionAffected Field
01_SETUP\Setup Queue 20061110\SETUP Queue 20061110.xls11/7/20069002Modified column name from desc to wh_desc01i_warehouse_mast
01_SETUP\Setup Queue 20061110\SETUP Queue 20061110.xls11/10/20069065Changed table name for meta data01b_style_header
01_SETUP\Setup Queue 20061110\SETUP Queue 20061110.xls11/13/20069076Removed meta data columns01d_vend_ord_tel_fax
03_OFFER\offer queue 20061026\Offers Queue 20061026.xls10/23/20068880 change FOP_TYP_LGCY_CD to "OA" for open account orders03b_SOURCES_FOP_TOT3
04_CUST\Customer Queue 20061115\Customer Queue 20061115.xls11/13/20069077Changed meta data business table name04i_credit_approval
04_CUST\Customer Queue 20061115\Customer Queue 20061115.xls11/15/20069100Corrected mapping to reference home phone fields04d_cust_tel_night_phone
05_CSTX\CSTX Queue 20061116\CSTX Queue 20061116.xls11/7/20069905Correction selection criteria for _oth mapping05a_cust_oth
05_CSTX\CSTX Queue 20061116\CSTX Queue 20061116.xls11/16/20068764Add third-party dataset to Ecomedate05b_third_party
06_ORD\Order Queue 20061109\Order Queue 20061109.xls11/9/20066831Add meta data columns to mappings06a_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
07_ORDS\ORDS Queue 20061110\ORDS Queue 20061110.xls11/10/20066831Add meta data columns07a_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
09_ORDO\ORDO 20061116\ORDO Queue 20061116.xls11/16/20069090change criteria to include open and closed RAs; add OPEN_RA_IND field and populate with Y/N to indicate if the RA is open09d_return_auth
12_FIN\FIN 20061030\Financial Order Object 20061030.xls10/16/20068801Correct selection criteria Add the following to the selection criteria in inventory: STR(FINANCIAL-ORDER_R.BIG-STATUS, 3, 2) <> "46" AND & STR(FINANCIAL-ORDER_R.BIG-STATUS, 3, 2) <> "47" AND STR(FINANCIAL-ORDER_R.BIG-STATUS, 3, 2) <> "48" and include in ship and ship_amt12a_ft_inv_trans, 12a_ft_inv_trans_amt, 12a_ft_ship, 12a_ft_ship_amt
12_FIN\FIN 20061030\Financial Order Object 20061030.xls10/20/20068871Remove all b_ fields from all ft_ tables12a_ft_cust, 12a_ft_cust_amt, 12a_ft_sales_ord, 12a_ft_sales_ord_amt, 12a_ft_inv_trans, 12a_ft_inv_trans_amt, 12a_ft_ship, 12a_ship_amt, 12a_ship_to, 12a_ship_to_amt, 12a_ft_doc, 12a_ft_doc_amt
12_FIN\FIN 20061030\Financial Order Object 20061030.xls10/20/20068872Add DOC_TYPE_LGCY_CD to FT_DOC_AMT12a_ft_doc_amt
12_FIN\FIN 20061030\Financial Order Object 20061030.xls10/26/20068896Add transaction codes 81,82,83 to mappings12a_ft_inv_trans, 12a_ft_inv_trans_amt
12_FIN\FIN 20061030\Financial Order Object 20061030.xls10/26/20068896Exclude transaction codes 81,82,83 from table12a_ft_ship, 12a_ft_ship_amt