--Delete custom Order tables from your order repository(Only if you have extended Order Repository)
delete from dcspp_schd_errmsg;
delete from dcspp_sched_error;
delete from dcspp_scherr_aux;
delete from dbcpp_sched_clone;
delete from dbcpp_sched_order;
delete from dcspp_manual_adj;
delete from dcspp_order_adj;
delete from dcspp_det_range;
delete from dcspp_det_price;
delete from dcspp_itmprice_det;
delete from dcspp_shipitem_tax;
delete from dcspp_ntaxshipitem;
delete from dcspp_taxshipitem;
delete from dcspp_shipitem_sub;
delete from dcspp_price_adjust;
delete from dcspp_amtinfo_adj;
delete from dcspp_ship_price;
delete from dcspp_tax_price;
delete from dcspp_item_price;
delete from dcspp_order_price;
delete from dcspp_amount_info;
delete from dcspp_payorder_rel;
delete from dcspp_payship_rel;
delete from dcspp_payitem_rel;
delete from dcspp_rel_range;
delete from dcspp_shipitem_rel;
delete from dcspp_cred_status;
delete from dcspp_debit_status;
delete from dcspp_auth_status;
delete from dcspp_sc_status;
delete from dcspp_gc_status;
delete from dcspp_cc_status;
delete from dcspp_pay_status;
delete from dcspp_bill_addr;
delete from dcspp_credit_card;
delete from dcspp_store_cred;
delete from dcspp_gift_cert;
delete from dcspp_item_ci;
delete from dcspp_subsku_item;
delete from dcspp_config_item;
delete from dcspp_pay_inst;
delete from dcspp_sg_hand_inst;
delete from dcspp_gift_inst;
delete from dcspp_hand_inst;
delete from dcspp_ship_addr;
delete from dcspp_ele_ship_grp;
delete from dcspp_hrd_ship_grp;
delete from dcspp_ship_inst;
delete from dcspp_order_rel;
delete from dcspp_order_item;
delete from dcspp_order_pg;
delete from dcspp_order_sg;
delete from dcspp_order_inst;
delete from dcspp_rel_orders;
delete from dcspp_relationship;
delete from dcspp_item;
delete from dcspp_pay_group;
delete from dcspp_ship_group;
delete from dcspp_order;
commit;
delete from dcspp_schd_errmsg;
delete from dcspp_sched_error;
delete from dcspp_scherr_aux;
delete from dbcpp_sched_clone;
delete from dbcpp_sched_order;
delete from dcspp_manual_adj;
delete from dcspp_order_adj;
delete from dcspp_det_range;
delete from dcspp_det_price;
delete from dcspp_itmprice_det;
delete from dcspp_shipitem_tax;
delete from dcspp_ntaxshipitem;
delete from dcspp_taxshipitem;
delete from dcspp_shipitem_sub;
delete from dcspp_price_adjust;
delete from dcspp_amtinfo_adj;
delete from dcspp_ship_price;
delete from dcspp_tax_price;
delete from dcspp_item_price;
delete from dcspp_order_price;
delete from dcspp_amount_info;
delete from dcspp_payorder_rel;
delete from dcspp_payship_rel;
delete from dcspp_payitem_rel;
delete from dcspp_rel_range;
delete from dcspp_shipitem_rel;
delete from dcspp_cred_status;
delete from dcspp_debit_status;
delete from dcspp_auth_status;
delete from dcspp_sc_status;
delete from dcspp_gc_status;
delete from dcspp_cc_status;
delete from dcspp_pay_status;
delete from dcspp_bill_addr;
delete from dcspp_credit_card;
delete from dcspp_store_cred;
delete from dcspp_gift_cert;
delete from dcspp_item_ci;
delete from dcspp_subsku_item;
delete from dcspp_config_item;
delete from dcspp_pay_inst;
delete from dcspp_sg_hand_inst;
delete from dcspp_gift_inst;
delete from dcspp_hand_inst;
delete from dcspp_ship_addr;
delete from dcspp_ele_ship_grp;
delete from dcspp_hrd_ship_grp;
delete from dcspp_ship_inst;
delete from dcspp_order_rel;
delete from dcspp_order_item;
delete from dcspp_order_pg;
delete from dcspp_order_sg;
delete from dcspp_order_inst;
delete from dcspp_rel_orders;
delete from dcspp_relationship;
delete from dcspp_item;
delete from dcspp_pay_group;
delete from dcspp_ship_group;
delete from dcspp_order;
commit;
0 comments:
Post a Comment