--Order 20011370.80

/*
----------------INVOICEHEADER--------------
ALTER TABLE INVOICEHEADER ADD
(	
	CREATIONSYSTEMUSER_ID NUMBER DEFAULT  0  NOT NULL ,
	CREATIONTIMESTAMP    DATE NULL ,
	FINALIZATIONSYSTEMUSER_ID NUMBER DEFAULT  0  NOT NULL ,
	FINALIZATIONTIMESTAMP DATE NULL 
);


UPDATE INVOICEHEADER IH SET IH.CREATIONTIMESTAMP = TO_DATE('01-01-2000','DD-MM-YYYY');
commit;


ALTER TABLE INVOICEHEADER MODIFY ( CREATIONTIMESTAMP NOT NULL);


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


UPDATE WEIGHINGTICKET WT SET WT.CREATIONTIMESTAMP = TO_DATE('01-01-2000','DD-MM-YYYY');
commit;


ALTER TABLE WEIGHINGTICKET MODIFY ( CREATIONTIMESTAMP NOT NULL);


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

*/