--ABS-98160/ ABS-98179

---PACKINGNOTELINE table---

ALTER TABLE PACKINGNOTELINE
  DROP CONSTRAINT PNLORIGIN_valid;
  
ALTER TABLE PACKINGNOTELINE
	ADD  CONSTRAINT PNLORIGIN_valid  CHECK (ORIGIN IN (0, 1, 2, 3, 4, 9, 10, 11, 12, 13, 15));

COMMENT ON COLUMN PACKINGNOTELINE.ORIGIN IS '0 = Generated based on Order
1 = Manually added
2 = Generated based on Outscan
3 = Quantity Correction Ticket
4 = Stock Delivery Note
9 = Import from DW
10 = Mounting Order
11 = Sales Order
12 = Credit Note
13 = Residential Delivery Note
15 = Charge To Product Process';