Taurus Software
Maps for CWSerenade
9/4/2013
| File Name | Change Date | Case Number | Description | Affected Field |
| CUST Queue.xls | 7/23/2013 | 24891 | Add new source columns (dnsync, dncusn, dnsupseml) | 05a_cs_soldto_customer |
| CUST Queue.xls | 7/26/2013 | 24932 | Change expression for PHONE_TYPE_LGCY_CD to use checkchar | 05b_cw_soldto_customer_phone |
| CUST Queue.xls | 7/26/2013 | 24934 | Change expression for PHONE_TYPE_LGCY_CD to use checkchar | 05f_cw_shipto_customer_phone |
| CUST Queue.xls | 7/26/2013 | 24933 | Change MATCH_CODE expression to use checkchar | 05c_cw_billto_customer |
| CUST Queue.xls | 8/16/2013 | 25080 | Add mapping option to exclude training companies | 05a_cw_soldto_customer, 05b_cw_soldto_customer_phone, 05c_cw_billto_customer, 05d_cw_soldto_customer_email, 05e_cw_shipto_customer, 05f_cw_shipto_customer_phone |
| FIN Queue.xls | 8/9/2013 | 25041 | Add new source table: glintd | 11A_CW_GL_DETAIL |
| INV Queue.xls | 7/17/2013 | 24862 | Change original string columns to CHAR type | 07i_item_location |
| INV Queue.xls | 7/22/2013 | 24894 | Add new target table CW_4_LOCATION to support changes made in version 4 of CWSerenade | 07d_cw_4_location |
| INV Queue.xls | 7/23/2013 | 24897 | Add new source column a4gldt to mapping | 07f_inv_trans_history |
| INV Queue.xls | 7/26/2013 | 24936 | Change expression to use checkchar for CURRENCY_LGCY_CD and VENDOR_TYPE_CD | 07a_vendor |
| INV Queue.xls | 7/26/2013 | 24919 | Add new column sku_kf. Adjust indexes to use new column. | 07b_vendor_item |
| INV Queue.xls | 7/27/2013 | 24937 | Change expression for CITY to use checkchar. | 07c_cw_warehouse |
| INV Queue.xls | 7/27/2013 | 24938 | Change expressions for LOCATION_CD and HANG_FLAT_CD to use CHECKCHAR | 07d_cw_location |
| INV Queue.xls | 7/27/2013 | 24919 | Add new column sku_kf. Adjust indexes to use new column. | 07e_cw_fifo_cost, 07f_inv_trans_history, 07g_inv_trans_cost_detail, 07h_cw_item_warehouse, 07i_item_location |
| INV Queue.xls | 7/29/2013 | 24964 | Change field sequence in metadata to account for SKU_KF | 07b_vendor_item |
| INV Queue.xls | 7/29/2013 | 24965 | Change TARGET ATTRIBUTE for SKU_KF to NOT NULL | 07b_vendor_item |
| INV Queue.xls | 7/29/2013 | 24966 | Change field sequence in metadata to account for SKU_KF | 07e_cw_fifo_cost |
| INV Queue.xls | 7/29/2013 | 24967 | Change field sequence in metadata to account for SKU_KF | 07f_inv_trans_history |
| INV Queue.xls | 7/29/2013 | 24968 | Change field sequence in metadata to account for SKU_KF | 07g_inv_trans_cost_detail |
| INV Queue.xls | 7/29/2013 | 24969 | Change field sequence in metadata to account for SKU_KF | 07h_cw_item_warehouse |
| INV Queue.xls | 7/29/2013 | 24970 | Change field sequence in metadata to account for SKU_KF | 07i_item_location |
| INV Queue.xls | 8/16/2013 | 25080 | Add mapping option to exclude training companies | 07a_cw_vendor, 07b_vendor_item, 07c_cw_location, 07d_cw_location, 07e_cw_fifo_cost, 07f_inv_trans_history, 07g_inv_trans_cost_detail, 07h_cw_item_warehouse, 07i_item_warehouse |
| Item Queue.xls | 7/17/2013 | 24862 | Change string original columns to CHAR type | 02d_cw_set_detail, 02e_cw_kit_detail, 02f_cw_variable_set_detail, 02g_cw_item_attribute_value, 02h_cw_item_attribute_assign |
| Item Queue.xls | 7/18/2013 | 24867 | Add new mapping to support version 4 changes to insku | 02c_cw_4_sku |
| Item Queue.xls | 7/23/2013 | 24881 | Add new columns to cw_item mapping for new source columns (infolink, imagelink) | 02a_cw_item |
| Item Queue.xls | 7/23/2013 | 24882 | Add new columns to cw_sku mapping for new source columns (infolink, imagelink) | 02c_cw_sku |
| Item Queue.xls | 7/26/2013 | 24923 | Change following columns to use checkchar: KIT_TYPE_LGCY_CD, ITEM_2ND_LANG_DESC, ITEM_STATUS_LGCY_CD | 02a_cw_item |
| Item Queue.xls | 7/26/2013 | 24919 | Change index ix_cw_sku to use new _kf for joins and changed it from unique to regular index. Add new column sku_kf. | 02c_sku, 02d_cw_set_detail, 02e_cw_kit_detail, 02f_cw_variable_set_detail, 02h_cw_item_attribute_assign |
| Item Queue.xls | 7/26/2013 | 24924 | Change expression for Change expression for COMPATIBILITY_LGCY_CD to use checkchar | 02c_sku |
| Item Queue.xls | 7/26/2013 | 24925 | Change KIT_COMP_SKU expression to use checkchar | 02e_cw_kit_detail |
| Item Queue.xls | 7/26/2013 | 24926 | Change expression for VARIABLE_SET_COMP_SKU to use checkchar | 02f_cw_variable_set_detail |
| Item Queue.xls | 7/26/2013 | 24927 | Change index cw_item_attribute_value to be non-unique. Adjust columns accordingly. | 02g_cw_item_attribute_value |
| Item Queue.xls | 7/29/2013 | 24941 | Change sequence of fields in metadata to account for SKU_KF | 02c_cw_sku |
| Item Queue.xls | 7/29/2013 | 24942 | Change sequence of fields in metadata to account for SKU_KF | 02d_cw_set_detail |
| Item Queue.xls | 7/29/2013 | 24943 | Add SET_COMP_SKU_KF field | 02d_cw_set_detail |
| Item Queue.xls | 7/29/2013 | 24944 | Add KIT_COMP_SKU_KF field | 02e_cw_kit_detail |
| Item Queue.xls | 7/29/2013 | 24946 | Change sequence of fields in metadata to account for SKU_KF | 02e_cw_kit_detail |
| Item Queue.xls | 7/29/2013 | 24945 | Add VARIABLE_SET_COMP_SKU_KF field | 02f_cw_variable_set_detail |
| Item Queue.xls | 7/29/2013 | 24947 | Change sequence of fields in metadata to account for SKU_KF | 02f_cw_variable_set_detail |
| Item Queue.xls | 7/29/2013 | 24948 | Change sequence of fields in metadata to account for SKU_KF | 02h_cw_item_attribute_assign |
| Item Queue.xls | 7/31/2013 | 24994 | Change business name of SKU_KF | 02c_cw_4_sku |
| Item Queue.xls | 8/16/2013 | 25080 | Add mapping option to exclude training companies | 02a_cw_item, 02b_cw_item_attribute, 02c_cw_sku, 02d_cw_set_detail, 02e_cw_kit_detail, 02f_cw_variable_set_detail, 02g_cw_item_attribute_value, 02h_cw_item_attribute_assign |
| Macros.xls | 8/16/2013 | 25080 | Add new macros to exclude training companies | EXCLUDECOMPA, EXCLUDECOMPN |
| MetaData.xls | 7/29/2013 | 24973 | Update table joins data - change all references to SKU to use SKU_KF | metadata_table_joins.csv |
| MetaData.xls | 7/30/2013 | 24984 | Change all VARCHAR2 data types to VARCHAR | TMD_COLUMNS.csv |
| MetaData.xls | 7/30/2013 | 24985 | Change TARGET TYPE to ODBC; change all VARCHAR2 data types to VARCHAR | TMD_TABLES.csv |
| MetaData.xls | 7/30/2013 | 24986 | Change all VARCHAR2 data types to VARCHAR | TMD_TABLE_JOINS.csv |
| MetaData.xls | 7/30/2013 | 24982 | Add table join data for CWV_NEXT_PO_DATA | metadata_table_joins.csv |
| MetaData.xls | 7/30/2013 | 24983 | Add table join data for new CW_4_ versions of tables | metadata_table_joins.csv |
| Offer Queue.xls | 7/26/2013 | 24929 | Change DROP_CD to use checkchar in expression | 03b_cw_source |
| Offer Queue.xls | 7/26/2013 | 24930 | Change IX_CW_OFFER_ITEM_PRICE not to be unique. | 03c_cw_offer_item_price |
| Offer Queue.xls | 7/26/2013 | 24931 | Change ASBLST and ASBHSY to CHAR type. | 03d_cw_item_offer |
| Offer Queue.xls | 7/31/2013 | 24997 | Change column business name for TAX_AMT to "Tax Amount" | 03c_cw_offer_item_price |
| Offer Queue.xls | 8/16/2013 | 25080 | Add mapping option to exclude training companies | 03a_cw_offer, 03b_cw_source, 03c_cw_offer_item_price, 03d_cw_item_offer, 03e_cw_ref_src_category_lgcy_cd |
| Order Queue.xls | 7/17/2013 | 24862 | Change string original columns to CHAR type | 04h_cw_order_payment_method, 04i_cw_ref_order_tx_history |
| Order Queue.xls | 7/22/2013 | 24877 | Change attribute of FPO_PAYMENT_CD to allow NULLS | 04h_cw_order_payment_method |
| Order Queue.xls | 7/22/2013 | 24878 | Add new target table: cw_4_order_header for changes made in version 4 for CWSerenade | 04a_cw_4_order_header |
| Order Queue.xls | 7/23/2013 | 24883 | Add source columns to mapping (j01usr, j01pgm, j01job, dmorgstr) | 04a_cw_order_header |
| Order Queue.xls | 7/23/2013 | 24883 | Add source columns to mapping (basic cust columns and jo3 columns) | 04b_cw_order_lines |
| Order Queue.xls | 7/23/2013 | 24886 | Add source columns to mapping (jo2usr, jo2pgm, jo2job, DOFTXO, DOFTXR, DOFTYN) | 04c_cw_order_shipto |
| Order Queue.xls | 7/23/2013 | 24887 | Add new target table: CW_4_ORDER_SHIPTO_ADDR to support changes made in version 4 of CWSerenade | 04d_cw_4_order_shipto_addr |
| Order Queue.xls | 7/23/2013 | 24888 | Add source column to mapping (jl3usr, jl3pgm, jl3job, pickwhs) | 04f_cw_invoice_lines |
| Order Queue.xls | 7/23/2013 | 24890 | Add new source columns to mapping (e3binn, jo4user, jo4pgm, j04job) | 04h_cw_order_payment_method |
| Order Queue.xls | 7/26/2013 | 24919 | Add new column sku_kf. Adjust indexes to use field | 04b_cw_order_lines |
| Order Queue.xls | 7/29/2013 | 24949 | Change sequence of fields in metadata to account for SKU_KF | 04b_cw_bo_history |
| Order Queue.xls | 7/29/2013 | 24950 | Change TARGET ATTRIBUTE for SKU_KF to "NOT NULL" | 04b_cw_bo_history |
| Order Queue.xls | 7/29/2013 | 24951 | Change sequence of fields in metadata to account for SKU_KF | 04b_cw_order_lines |
| Order Queue.xls | 7/29/2013 | 24958 | Change TARGET ATTRIBUTE for SKU_KF to "NOT NULL" | 04b_cw_order_lines |
| Order Queue.xls | 7/31/2013 | 24996 | Change column business name for BACKORDER_QTY to "Backorder Quantity" | 04b_cw_bo_history |
| Order Queue.xls | 7/31/2013 | 24998 | Change column business name for BACKORDER_QTY to "Backorder Quantity" | 04b_cw_order_lines |
| Order Queue.xls | 7/31/2013 | 24999 | Change column business name for LAST_MOD_JOB to "Last Modified Job" | 04h_cw_order_payment_method |
| Order Queue.xls | 8/16/2013 | 25080 | Add mapping option to exclude training companies | 04a_cw_order, 04b_cw_order_lines, 04c_cw_order_shipto, 04d_cw_order_shipto_addr, 04e_cw_invoice_header, 04f_cw_invoice_lines, 04g_cw_order_line_history, 04h_cw_order_payment_method, 04I_cw_order_tx_history, 04i_cw_order_rlse_history, 04i_cw_order_hold_his |
| ORDO Queue.xls | 7/17/2013 | 24862 | Change original string columns to CHAR type | 06d_cw_pick_ctrl_hdr, 06e_cw_pick_ctrl_dtl |
| ORDO Queue.xls | 7/23/2013 | 24892 | Add new source columns (jf1user, jf1job, jf1pgm) | 06d_cw_pick_ctrl_hdr |
| ORDO Queue.xls | 7/23/2013 | 24893 | Add new source columns (jf2user, jf2job, jf2pgm) | 06e_cw_pick_ctrl_dtl |
| ORDO Queue.xls | 7/26/2013 | 24919 | Add new column sku_kf. | 06b_cw_return_lines, 06c_cw_return_exchg, 06e_cw_pick_ctrl_dtl |
| ORDO Queue.xls | 7/26/2013 | 24935 | Change string original columns to use CHAR data type. Change expression for GEN_TYPE_LGCY_CD to use CHECKCHAR | 06d_cw_pick_ctrl_hdr |
| ORDO Queue.xls | 7/29/2013 | 24953 | Change field sequence in metadata to account for SKU_KF | 06b_cw_return_lines |
| ORDO Queue.xls | 7/29/2013 | 24957 | Change TARGET ATTRIBUTE for SKU_KF to NOT NULL | 06b_cw_return_lines |
| ORDO Queue.xls | 7/29/2013 | 24954 | Change field sequence in metadata to account for SKU_KF | 06c_cw_return_exchg |
| ORDO Queue.xls | 7/29/2013 | 24959 | Change TARGET ATTRIBUTE for SKU_KF to NOT NULL | 06c_cw_return_exchg |
| ORDO Queue.xls | 7/29/2013 | 24955 | Change field sequence in metadata to account for SKU_KF | 06e_cw_pick_ctrl_dtl |
| ORDO Queue.xls | 7/29/2013 | 24960 | Change TARGET ATTRIBUTE for SKU_KF to NOT NULL | 06e_cw_pick_ctrl_dtl |
| ORDO Queue.xls | 7/31/2013 | 25001 | Change column business name for PO_BOX_IND to "PO Box Flag" | 06d_cw_pick_ctrl_hdr |
| ORDO Queue.xls | 8/8/2013 | 25040 | Add new source table: mstkct | 06f_cw_tickler_cat_lgcy_cd |
| ORDO Queue.xls | 8/8/2013 | 25040 | Add new source table: mstkrs | 06g_cw_tkl_resolution_lgcy_cd |
| ORDO Queue.xls | 8/8/2013 | 25040 | Add new source table: mstkug | 06h_cw_tickler_group_lgcy_cd |
| ORDO Queue.xls | 8/8/2013 | 25040 | Add new source table: mstklr | 06k_cw_tickler |
| ORDO Queue.xls | 8/9/2013 | 25040 | Add new source table: mstkev | 06i_cw_event_lgcy_cd |
| ORDO Queue.xls | 8/9/2013 | 25040 | Add new source table: mstker | 06j_cw_tickler_event_rules |
| ORDO Queue.xls | 8/9/2013 | 25040 | Add new source table: mstkno | 06l_cw_tickler_note |
| ORDO Queue.xls | 8/9/2013 | 25040 | Add new source table: mstkhs | 06m_cw_tickler_history |
| ORDO Queue.xls | 8/16/2013 | 25080 | Add mapping option to exclude training companies | 06a_cw_return_hdr, 06b_cw_return_lines, 06c_cw_return_exchg, 06d_pick_ctrl_hdr, 06e_pick_ctrl_dtl |
| PO Queue.xls | 7/17/2013 | 24862 | Change original string columns to CHAR type | 08G_PO_LAYERING |
| PO Queue.xls | 7/27/2013 | 24939 | Change expression for USER_LGCY_CD to use CHECKCHAR | 08a_po_header |
| PO Queue.xls | 7/27/2013 | 24919 | Add new column sku_kf. Adjust indexes | 08b_po_detail, 08g_po_layering |
| PO Queue.xls | 7/29/2013 | 24971 | Change field sequence in metadata to account for SKU_KF | 08b_po_detail |
| PO Queue.xls | 7/29/2013 | 24972 | Change field sequence in metadata to account for SKU_KF | 08g_po_layering |
| PO Queue.xls | 8/16/2013 | 25080 | Add mapping option to exclude training companies | 08a_po_header, 08b_po_detail, 08c_po_detail_ds, 08d_po_receipt_hdr, 08e_po_receipt, 08f_po_receipt_loc, 08g_po_layering |
| SETUP Queue.xls | 7/17/2013 | 24862 | Change original source columns to CHAR type | 01f_cw_ref_order_type_lgcy_cd, 01m_cw_ref_long_sku_dept_lgcy_cd, 01n_cw_ref_ship_via_lgcy_cd, 01o_cw_ref_order_hold_lgcy_cd, 01p_cw_ref_pay_type_lgcy_cd, 01q_cw_system_controls, 01r_cw_ref_location_class_lgcy_cd, 01s_cw_ref_buyer_lgcy_cd |
| SETUP Queue.xls | 7/17/2013 | 24865 | Change SHIP_TYPE_LGCY_CD and BILLING_LGCY_CD to allow nulls | 01n_cw_ref_ship_via_lgcy_cd |
| SETUP Queue.xls | 7/26/2013 | 24922 | Change index from unique to regular index (ix_cw_division). Add checkchar to division_cd | 01k_cw_division |
| SETUP Queue.xls | 8/9/2013 | 25048 | Add new source table: mscnty | 01u_cw_ref_country_lgcy_cd |
| SETUP Queue.xls | 8/16/2013 | 25080 | Add mapping option to exclude training companies | 01a_cw_ref_cancel_reason_lgcy_cd, 01b_cw_ref_customer_class_lgcy_cd, 01c_cw_ref_exchg_reason_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_item_trans_lgcy_cd |
| SETUP Queue.xls | 8/16/2013 | 25080 | Add mapping option to exclude training companies | 01t_cw_ref_buyer_lgcy_cd, 01u_cw_ref_country_lgcy_cd |
| SETUP Queue.xls | 8/20/2013 | 25091 | Add new source table: mscomp | 01v_cw_company |
| Static Queue.xls | 8/9/2013 | 24168 | Add reference data to support tickler tables | 09z_cw_ref_note_type_lgcy_cd, 09AA_CW_REF_COMPARISON_TYPE_LGCY_CD, 09AB_CW_REF_PICK_CAT_LGCY_CD, 09AC_CW_REF_EMAILERR_LGCY_CD, 09AD_CW_REF_INTERACT_LGCY_CD, 09AE_CW_REF_TKLHST_STAT_LGCY_CD |
| Utilities.xls | 8/9/2013 | 25041 | Add new queue to utlities | fin_q_script.wh, fin_q_start.bat, fin_q_stop.bat, purgeallqueues.bat, purgecwsmapsfin.wh, purgequeuefin.bat, fin_refreshcounts.txt, recon_allqueues.bat, recon_fin.bat, fin_reportsconts.txt |
| VIEWS.xls | 7/27/2013 | 24940 | Source SKU column from SKU_KF | 10A_CWVA_OPENPOS_COITEMSKU, 10A_CWVA_OPENPOS_COITEMSKUTDTPOSEQ, 10B_CWV_OPEN_LAYERING, 10F_CWV_COITEMSKUOPENPOSDATA, 10G_CWV_NEXT_PO_DATA |
| VIEWS.xls | 7/29/2013 | 24974 | Add new view for version 4 cw_4_sku table to base name (cw_sku) | 10H_CW_4_SKU |
| VIEWS.xls | 7/29/2013 | 24877 | Add new view for version 4 cw_4_order_shipto_addr table to base name (cw_order_shipto_addr) | 10H_CW_4_ORDER_SHIPTO_ADDR |
| VIEWS.xls | 7/29/2013 | 24878 | Add new view for version 4 cw_4_order_header table to base name (cw_order_header) | 10H_CW_4_ORDER_HEADER |
| VIEWS.xls | 7/29/2013 | 24894 | Add new view for version 4 cw_4_location table to base name (cw_location) | 10H_CW_4_LOCATION |
| VIEWS.xls | 7/30/2013 | 24987 | Remove all metadata | 10F_CWV_COITEMSKUOPENPOSDATA |