i.date_time, i.department, i.category, i.item, i.quantity, i.unit_cost, i.invent_id, i.trans_type, i.ref_no, i.locatn_id, i.[message], i.exportd_on, isnull(mi.vpartno, it.vpartno) as vpartno, isnull(mi.descrip, it.descrip) as descrip, isnull(mi.barcode, it.barcode) as barcode, isnull(mi.upc, it.upc) as upc, isnull(mi.vendor_1, it.vendor_1) as vendor_1, isnull(mi.vendor_2, it.vendor_2) as vendor_2, it.monday_0 as price, it.gl_no, it.user_code, it.price_type, it.tax_rate, it.tax_rate_b, it.cust_tax, it.cust_tax_b, it.keycode, it.keydescrip, it.reorder_pt, it.target_qty, isnull(mi.descrip, '') as m_descrip, isnull(mi.stock_loc, '') as stock_loc, isnull(mi.store_id, 0) as store_id, isnull(mi.curr_cost, 0.0000) as curr_cost, isnull(mi.reorder_lv, 0) as reorder_lv, isnull(mi.target_lvl, 0) as target_lvl, isnull(mi.lead_time, 0) as lead_time, isnull(mi.min_ord_lv, 0) as min_ord_lv, isnull(mi.vend_disc1, 0) as vend_disc1, isnull(mi.vend_disc2, 0) as vend_disc2, isnull(mi.user_int1, 0) as user_int1, isnull(mi.user_code1, '') as user_code1, isnull(mi.user_code2, '') as user_code2, isnull(mi.user_num1, 0) as user_num1, mi.last_order, mi.last_sales, mi.start_sale, isnull(v.full_name, '') as full_name, isnull(v.e_mail, '') as e_mail, isnull(v.contact, '') as contact, isnull(v.[address], '') as [address], isnull(v.address2, '') as address2, isnull(v.city, '') as city, isnull(v.[state], '') as [state], isnull(v.zip, '') as zip, isnull(v.country, '') as country, isnull(v.area_code, '') as area_code, isnull(v.phone, '') as phone, isnull(v.tier, 0) as tier, isnull(v.number_1, 0) as number_1, isnull(v.number_2, 0) as number_2, isnull(v.number_3, 0) as number_3, isnull(v.number_4, 0) as number_4, isnull(v.number_5, 0) as number_5, isnull(v.text_1, '') as text_1, isnull(v.text_2, '') as text_2, isnull(v.text_3, '') as text_3, isnull(v.text_4, '') as text_4, isnull(v.text_5, '') as text_5, isnull(v.externalid, '') as externalid, cast(isnull(v.check_bx1, 0) as bit) as check_bx1, cast(isnull(v.check_bx2, 0) as bit) as check_bx2, cast(isnull(v.check_bx3, 0) as bit) as check_bx3, cast(isnull(v.check_bx4, 0) as bit) as check_bx4, cast(isnull(v.check_bx5, 0) as bit) as check_bx5, v.date_1, v.datetime_1, isnull(h.internl_po, 0) as internl_po, isnull(h.externl_po, '') as externl_po, isnull(h.sales_tax, 0.0000) as sales_tax, isnull(h.ship_hndl, 0.0000) as ship_hndl, isnull(h.misc_chrg, 0.0000) as misc_chrg, isnull(h.ship_via, '') as ship_via, isnull(h.[status], '') as [status], isnull(h.fob, '') as fob, isnull(h.terms, '') as terms, isnull(h.savercvloc, 0) as savercvloc, cast(isnull(h.nobackord, 0) as bit) as nobackord, h.date_expct, case when it.i_matrix = 1 then 'M' else case when it.inventory = 1 then 'I' else 'O' end end as invt_type, isnull(l.descrip , space(25)) as location