--ABSN-1984

--changes on WEIGHINGTRANSACTION table
ALTER TABLE WEIGHINGTRANSACTION DROP CONSTRAINT CHK_WEIGHINGTRANSACTION_EXCHCARTUNDEL;

ALTER TABLE WEIGHINGTRANSACTION ADD CONSTRAINT CHK_WEIGHINGTRANSACTION_EXCHCARTUNDEL CHECK (EXCHANGECARTUNDELIVERABLE IN (0, 1, 2, 3, 4, 5, 6, 7, 8,9));

COMMENT ON COLUMN WEIGHINGTRANSACTION.EXCHANGECARTUNDELIVERABLE IS
	'Possible values:
	0 = Deliverable / Not applicable
	1 = Substitute exchange cart
	2 = Delivery stop
	3 = Consumption point not active
	4 = Department not active
	5 = Customer not active
	6 = No delivery note found
	7 = Product without weighing category
	8 = Product without theoretical weight
	9 = Consumption point mismatch
	Only relevant when weighing transaction type = 4';


