use hosxp_pcu;
delete from stock_warehouse_adj_detail;
delete from stock_warehouse_adj_head;
delete from stock_request_list;
delete from stock_request;
delete from stock_subdraw_list;
delete from stock_subdraw;
delete from stock_cutpay_list;
delete from stock_cutpay;
delete from stock_card;
delete from stock_snapshot_detail;
delete from stock_snapshot_head;
delete from stock_adjust_detail;
delete from stock_adjust_head;
delete from stock_remain_summary;
delete from stock_manual_detail;
delete from stock_manual_head;
delete from stock_manual_item;
delete from stock_opitemrece_err;
delete from stock_opitemrece;
delete from stock_borrow_item;
delete from stock_borrow;
delete from stock_return_list;
delete from stock_return;
delete from stock_draw_list;
delete from stock_draw;
delete from stock_item_list;
delete from stock_deliver_detail;
delete from stock_deliver;
delete from stock_po_detail;
delete from stock_po;
delete from stock_bestow;
delete from stock_bestow_item;
delete from stock_bestow_list;
delete from stock_bestow_return;
delete from stock_bestow_return_item;
delete from stock_borrow_return;
delete from stock_borrow_return_item;
delete from stock_borrow_return_list;
delete from stock_budget_detail;
delete from stock_budget_list;
delete from stock_cutpay_item;
delete from stock_cary_forward;
delete from stock_cheque_list;
delete from stock_cutpay_item;
delete from stock_draw_item;
delete from stock_expire;
delete from stock_item_balance_history;
delete from stock_manual_item;
delete from stock_plan;
delete from stock_plan_list;
delete from stock_po_committee;
delete from stock_po_special;
delete from stock_po_special_committee;
delete from stock_po_special_detail;
delete from stock_request_committee;
delete from stock_return_item;
delete from stock_subcard;
delete from stock_substock_detail;
delete from stock_summary;
delete from stock_trancation_itemdata;
update  stock_item_unit   set rate_1_month=0,rate_3_month=0,rate_12_month=0,rate_1_month_lastyear=0,empty_in_day=0,
age_1_year=0,age_2_year=0,age_3_year=0,age_4_year=0,age_5_year=0,age_morethan_5_year=0,current_qty=0,po_wait_qty=0;
update  stock_item  set unit_cost=0;
update stock_item_unit   set last_active_date="";

update stock_item set unit_cost = " ";
