Taurus Software

Maps for CWSerenade

3/11/2014

File NameChange DateCase NumberDescriptionAffected Field
CUST Queue.xls1/15/201425599Change source table name to lowercase05a_cw_soldto_customer, 05c_cw_billto_customer, 05d_cw_soldto_customer_email, 05e_cw_shipto_customer, 05f_cw_shipto_customer_phone
INV Queue.xls11/14/201325405Change expression for item to use checkchar07e_cw_fifo_cost, 07i_item_location
INV Queue.xls1/8/201425186Add new field added (bscodt) in povend in CWSerenade release 4.0.13041107a_cw_4_vendor
INV Queue.xls1/8/201425602Add new fields added (BASLGR, BAVRNK, BABNTY, BAMXSK) to new mapping for version 4 for location07d_cw_4_location
INV Queue.xls1/15/201425601Change source table names to lowercase07b_vendor_item, 07c_cw_warehouse, 07d_cw_location, 07e_cw_fifo_cost, 07g_inv_trans_cost_detail, 07h_cw_item_warehouse
Item Queue.xls1/2/201425544Change column name from DEPARTMENT to LONG_SKU_DEPT_LGCY_CD.02a_cw_item
Item Queue.xls1/9/201425079Add new source table (itmupc) to product02i_cw_item_upc, 02i_cw_4_item_upc
Item Queue.xls1/10/201425078Add new source table (insxr) to product02j_cw_sku_xref
Item Queue.xls1/10/201425077Add new source table (skelwf) to product02k_cw_sku_element
Item Queue.xls1/13/201425577Change source table name to lowercase02b_cw_item_attribute, 02c_cw_sku, 02c_cw_4_sku
Offer Queue.xls1/15/201425598Change source table name to lowercase03a_cw_offer, 03b_cw_source, 03c_cw_offer_item_price
Offer Queue.xls2/18/201425618Add field with concatenated code and description 03e_cw_ref_src_category_lgcy_cd
Offer Queue.xls3/3/201425776Add indexes needed by Merchandise Performance Analysis in mapping03a_cw_offer
Order Queue.xls9/27/201325191Changed expression on the backorder_qty to exclude those with a warehouse = 004b_cw_order_lines
Order Queue.xls12/27/201325532Change the fetch to be only by ID. Change the index for company, order ,sequence to non-unque04h_cw_order_payment_method
Order Queue.xls1/7/201425535Add new source table : csinvp04i_cw_invoice_payment_method
Order Queue.xls1/7/201425535Add new source table: oeinad04j_cw_invoice_address
Order Queue.xls1/9/201425181Add new mapping to support new columns (doprev, doprmt) to oeorst04c_cw_4_order_shipto
Order Queue.xls1/10/201425192Change unique index from ID to co_cd, order_nbr, ship_to_nbr, seq_nbr, item, sku_kf, and backorder_dt04b_cw_bo_history
Order Queue.xls3/3/201425776Add indexes to support Merchandise Performance Analysis to mapping04e_cw_invoice_header
ORDO Queue.xls1/8/201425183Add new mapping to support version 4 changes to return lines. CWSerenade added column: gqrtni to table.06b_cw_4_return_lines
ORDO Queue.xls1/8/201425182Add new mapping to support version 4 changes pick control detail. CWSerenade added new column: dxobrn to table.06e_cw_4_pick_ctrl_dtl
ORDO Queue.xls3/3/201425776Add indexes needed by Merchandise Performance Analysis to mappings06a_cw_return_hdr
PO Queue.xls11/14/201325405Change expression for ITEM to include CHECKCHAR08g_cw_po_layering
PO Queue.xls12/4/201325487Change breakout fields to allow NULLS08c_cw_po_detail_ds
PO Queue.xls1/14/201425594Changed source table to be lowercase08c_cw_po_detail_ds
SETUP Queue.xls12/31/201325543Add new source table: inldvp01w_cw_ref_long_sku_div_lgcy_cd
SETUP Queue.xls1/2/201425547Change column DIVISION_CD to LONG_SKU_DIV_LGCY_CD01m_cw_ref_long_sku_dept_lgcy_cd
SETUP Queue.xls1/6/201425184Add new mapping for new CWSerenade change to msshpv. CWSerenade adds two new columns: eacarriercode, eacarrierclass.01n_cw_4_ref_ship_via_lgcy_cd
SETUP Queue.xls1/7/201425312Changed source table from exrtrs to oeexrs01c_cw_ref_exchg_reason_lgcy_cd
SETUP Queue.xls1/7/201425184Add new source table: rtndis01x_cw_ref_rtn_dispos_lgcy_cd
SETUP Queue.xls1/10/201425077Add new source table: inskeo01y_cw_ref_seo_lgcy_cd
SETUP Queue.xls1/10/201425077Add new source table: inskew01z_cw_ref_sew_lgcy_cd
SETUP Queue.xls1/10/201425077Add new source table: insket01aa_cw_ref_set_lgcy_cd
SETUP Queue.xls1/13/201425577Change source table name to lowercase01a_cw_ref_cancel_reason_lgcy_cd, 01b_cw_ref_customer_class_lgcy_cd, 01d_cw_ref_item_category_lgcy_cd, 01e_cw_ref_item_status_lgcy_cd, 01f_cw_ref_order_type_lgcy_cd, 01g_cw_ref_return_reason_lgcy_cd, 01h_cw_ref_item_trans_lgcy_cd, 01i_cw_ref_long_sku_clas
SETUP Queue.xls3/3/201425768Add mapping option to exclude training companies01v_cw_company
SETUP Queue.xls3/3/201425776Add indexes needed to support Merchandise Performance Analysis01t_cw_ref_buyer_lgcy_cd, 01i_cw_ref_long_sku_class_lgcy_cd, 01m_cw_ref_long_sku_dept_lgcy_cd
Static Queue.xls1/6/201424849Changed "Cancelled" to "Canceled" in reference data filesdrop_ship_po_status_cds.csv, line_status_cd.csv, order_shipto_status_cds.csv, order_status_cds.csv, po_status_cds.csv
Static Queue.xls1/6/201424245Add entry for O type code in reference data fileorder_shipto_status_cds
Static Queue.xls1/7/201425563Add credit card credit status data 09ah_cw_ref_cc_credit_stat_lgcy_cd
Static Queue.xls1/7/201425564Add pay option reference data 09ai_cw_ref_pay_option_lgcy_cd
Static Queue.xls1/9/201425571Add UPC type reference data09aj_cw_ref_upc_type_lgcy_cd
VIEWS.xls1/6/201425184Add new view for version 4 cw_4_ref_ship_via_lgcy_cd10H_CW_4_REF_SHIP_VIA_LGCY_CD
VIEWS.xls1/8/201425186Add new view for version 4 cw_4_vendor10H_CW_4_VENDOR
VIEWS.xls1/8/201425182Add new view for version 4 cw_4_pick_ctrl_dtl10H_CW_4_PICK_CTRL_DTL
VIEWS.xls1/8/201425183Add new view for version 4 cw_4_return_lines10H_CW_4_RETURN_LINES
VIEWS.xls1/9/201425181Add new view for version 4 cw_4_order_shipto 10H_CW_4_ORDER_SHIPTO
VIEWS.xls2/1/201425079Add new view for version 4 cw_4_item_upc10H_CW_4_ITEM_UPC