update 0p4_item_transaction tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_assembly_items tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_customer_group_pricing_detail tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_disassembly_items tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_good_issue_note_items tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.art_no where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_good_issue_note_non_trade_vendor_detail tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_good_issue_note_trade_vendor_detail tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_goods_receipt_note_detail tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_goods_received_note_detail tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_inventory_adjustment_detail tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.part_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_inventory_stock_take_detail tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_item_transfer_detail tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_misc_issue_detail tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_misc_receipt_detail tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_stock_exchange_in tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_stock_exchange_out tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_cash_invoice_items tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);


update 0p4_cash_invoice_items tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_consignment_delivery_order_items tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_invoice_items tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_costing_detail tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);


update 0p4_credit_note_items tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_debit_note_items tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_delivery_order_items tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);


update 0p4_miscellaneous_invoice_items tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_proposal_items tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_purchase_order_items tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_quotation_detail tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_sale_order_detail tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_temporary_devlivery_order_items tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_vendor_credit_note_detail tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_vendor_debit_note_detail tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);


update 0p4_refund_detail tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);

update 0p4_eorder_items tran
inner join 0p4_item i on i.item_id=tran.item_id
set tran.item_code=i.item_code,tran.art_no=i.art_no 
where i.item_id in (7877,7878,7879,7876,7873,7874,7883,7875,8156,8157,8158,7847,8375,8373,8374,8376,8378,8377,8379,8152,8151,8143,8149,8150,8147,8148,8145,8144,8146,7463,7464,7465,7466,7467,7468,8681,7046,7009,7045,7095,7047,8435,8434,7093,7096,7010,8426,8427,7902,7904,7903,7905,7906,7907,7908,7913,7900,7901,8398);