use T202223


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


DELETE FROM COMPANY_DETAIL WHERE CompCode='23TA001'