--- ABS-10114
-------------------------   PACKINGNOTE   ------------------------------
--- Drop both duplicate constraints for Origin column

ALTER TABLE PACKINGNOTE DROP CONSTRAINT PNLORIGIN_VALID;

ALTER TABLE PACKINGNOTE DROP CONSTRAINT PNORIGIN_VALID;

ALTER TABLE PACKINGNOTE ADD CONSTRAINT PNORIGIN_VALID1_1 CHECK (ORIGIN BETWEEN 0 AND 14);

COMMENT ON COLUMN PACKINGNOTE.ORIGIN IS '0 = Generated based on Order
1 = Manually added
2 = Generated based on Outscan
3 = Quantity Correction Ticket
4 = Stock Delivery Note
5 = Special Order
6 = Bulk Note
7 = Bin Note
8 = Transfer Weights
9 = Import from DW
10 = Mounting Order
11 = Sales Order
12 = Credit Note
13 = Residential Delivery Note
14 = Customer Packing Note';


