use T202223


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


DELETE FROM COMPANY_DETAIL WHERE CompCode='12TS001'