Taurus Software

Maps for SXEnterprise

6/10/2014

File NameChange DateCase NumberDescriptionAffected Field
A_00_Macros.xls3/21/201425854Add macro to provide selection criteria for viewsINCLUDECPY
A_00_Macros.xls5/29/201426195Add macro to convert values to negative, depending on Return Flag, Trans Type, and Line StatusNEG
A_01_SXVIEWS.xls3/21/201425854Add selection criteria to all view for selection by company01_v_apsv, 01_v_arsc, 01_v_arss, 01_v_icsd, 01_v_icsp, 01_v_icsw, 01_v_oeeh, 01_v_oeel, 01_v_poeh, 01_v_poel, 01_v_sasc, 01_v_sasta, 01_v_sastn, 01_v_sasoo, 01_v_smsn, 01_v_icss
A_01_SXVIEWS.xls6/2/201426227Add new views to provide non-stock inventory data01_v_icenh, 01_v_icenl
A_04_SETUP.xls2/14/201425722Change selection criteria on SX_DIVISION to choose SASTN entries with CODEIDEN = "V"04b_sx_division
A_04_SETUP.xls4/29/201426036Changed expression for WAREHOUSE_CD to upshift data04a_sx_system_admin
A_04_SETUP.xls4/30/201426053Changed expression for SHIP_VIA_LGCY_CD to upshift data04e_sx_warehouse_master
A_05_ITEM.xls4/22/201426009Modifiy expression for product_number to upshift data05a_sx_product_master, 05b_sx_special_price_costing
A_05_ITEM.xls5/27/201426107Modify expression for description to put just descrip_1 if descrip_2 yields $null05a_sx_product_master
A_07_ORDER.xls4/14/201425957Change expression for product_number to upshift data09b_sx_order_lines
A_07_ORDER.xls4/29/201426036Change expression for warehouse codes to upshift data09a_sx_order_header
A_07_ORDER.xls5/29/201426195Change expression on amount/quantity fields to use NEG() macro to convert to negative where necessary09b_sx_order_lines
A_08_PO.xls4/22/201426009Change expression for product_number to upshift data08c_sx_po_lines
A_08_PO.xls4/29/201426036Changed expression for ptx_warehouse_cd to upshift data.08a_sx_vendor_master
A_08_PO.xls4/29/201426036Changed expression for warehouse_cd to upshift data.08c_sx_po_lines
A_09_INV.xls4/3/201425941Add checkchar to expression for whse_prod_status_lgcy_cd09a_sx_warehouse_products
A_09_INV.xls4/3/201425939Change expression to upshift price_type_lgcy_cd09a_sx_warehouse_products
A_09_INV.xls4/22/201426009Change expression to upshift product_number09a_sx_warehouse_products
A_09_INV.xls6/2/201426227Add new source tables (icenl, icenh) to products09b_sx_nonstock_header, 09c_sx_nonstock_lines