-- TD 20948 (80304 Adding Products Via Handheld Failed when Imported)

---------------- ROUTEASSISTANTTRANSACTION ------------------------
CREATE TABLE ROUTEASSISTANTTRANSACTION_TEMP AS (SELECT * FROM ROUTEASSISTANTTRANSACTION);

UPDATE ROUTEASSISTANTTRANSACTION R
SET R.PRICE=NULL;
COMMIT;

ALTER TABLE ROUTEASSISTANTTRANSACTION 
	MODIFY (PRICE NUMBER(15,6));
  
UPDATE ROUTEASSISTANTTRANSACTION R
SET R.PRICE=(SELECT RT.PRICE FROM ROUTEASSISTANTTRANSACTION_TEMP RT WHERE RT.ROUTEASSISTANTTRANSACTION_ID=R.ROUTEASSISTANTTRANSACTION_ID);
COMMIT;

DROP TABLE ROUTEASSISTANTTRANSACTION_TEMP;


