use T201718


UPDATE CUSTOMER_GROUP_MASTER SET CustFirmCode='12TR001' 
UPDATE CUSTOMER_MASTER SET CustFirmCode='12TR001'
UPDATE SUPPLIER_GROUP_MASTER SET SuppFirmCode='12TR001'
UPDATE SUPPLIER_MASTER SET SuppFirmCode='12TR001' 
UPDATE PURCHASE_DETAIL SET CompCode='12TR001', FirmCode='12TR001'
UPDATE PURCHASE_ADDLESS_DETAIL SET CompCode='12TR001'
UPDATE PURCHASE_TRANSPORT_DETAIL SET CompCode='12TR001'
UPDATE PURCHASE_IMAGES_DETAIL SET FirmCode='12TR001' 
UPDATE OPENING_PURCHASE_DETAIL SET CompCode='12TR001', FirmCode='12TR001' 
UPDATE OPENING_PURCHASE_ITEM_DETAIL SET CompCode='12TR001'
UPDATE OPENING_PURCHASE_ADDLESS_DETAIL SET CompCode='12TR001'
UPDATE OPENING_PURCHASE_TRANSPORT_DETAIL SET CompCode='12TR001'
UPDATE OPENING_PURCHASE_IMAGES_DETAIL SET FirmCode='12TR001' 
UPDATE ORDER_DETAIL  SET CompCode='12TR001'
UPDATE ORDER_ITEM_DETAIL  SET CompCode='12TR001'
UPDATE PURCHASE_ITEM_DETAIL  SET CompCode='12TR001'
UPDATE CHEQUE_RETURN_DETAIL SET CompCode='12TR001', FirmCode='12TR001' 
UPDATE CUSTOMER_SUPPLIER_REMARK SET CompCode='12TR001'
UPDATE RETURN_GOODS_DETAIL SET CompCode='12TR001',RtnFirmCode='12TR001' 
UPDATE RETURN_GOODS_ADDLESS_DETAIL SET CompCode='12TR001'
UPDATE RETURN_GOODS_ITEM_DETAIL SET CompCode='12TR001'
UPDATE RETURN_GOODS_IMAGES_DETAIL SET RtnFirmCode='12TR001' 
UPDATE RECEIVED_DETAIL SET RecFirmCode='12TR001',CompCode='12TR001' 
UPDATE RECEIVED_ADDLESS_DETAIL SET CompCode='12TR001'
UPDATE RECEIVED_PAYMENT_DETAIL SET CompCode='12TR001'
UPDATE RECEIVED_IMAGES_DETAIL SET RecFirmCode='12TR001' 
UPDATE BROKERAGE_DETAIL SET CompCode='12TR001'
UPDATE BROKERAGE_ADDLESS_DETAIL SET CompCode='12TR001'


DELETE FROM COMPANY_DETAIL WHERE COMPCODE <>'12TR001'