--Order 20011370.80 (downgraded from Script_08.03.03.03.sql)


----------------INVOICEHEADER--------------
ALTER TABLE INVOICEHEADER ADD
(	
	CREATIONSYSTEMUSER_ID NUMBER DEFAULT  0  NOT NULL ,
	CREATIONTIMESTAMP    DATE default TO_DATE('01-01-2000','DD-MM-YYYY') NOT NULL ,
	FINALIZATIONSYSTEMUSER_ID NUMBER DEFAULT  0  NOT NULL ,
	FINALIZATIONTIMESTAMP DATE NULL 
);

ALTER TABLE INVOICEHEADER MODIFY ( CREATIONTIMESTAMP default NULL);


----------------WEIGHINGTICKET-------------
ALTER TABLE WEIGHINGTICKET ADD
(	
	CREATIONSYSTEMUSER_ID NUMBER DEFAULT  0  NOT NULL ,
	CREATIONTIMESTAMP    DATE default TO_DATE('01-01-2000','DD-MM-YYYY') NOT NULL ,
	PROCESSEDSYSTEMUSER_ID NUMBER DEFAULT  0  NOT NULL ,
	PROCESSEDTIMESTAMP   DATE NULL 
);



ALTER TABLE WEIGHINGTICKET MODIFY ( CREATIONTIMESTAMP default NULL);


----------------PACKINGNOTE----------------
ALTER TABLE PACKINGNOTE ADD
(	
	PROCESSEDTIMESTAMP   DATE NULL,
	PROCESSEDSYSTEMUSER_ID NUMBER DEFAULT  0  NOT NULL
);

