--ABS-63701/ABS-78516

---------------- CUSTOMER ----------------
ALTER TRIGGER AFTER_UPDATE_CUSTOMER DISABLE;
UPDATE CUSTOMER C
SET C.CONSIGNMENTNOTELEVEL = 0
WHERE C.CONSIGNMENTNOTELEVEL NOT IN (0,1,2,3,4);
COMMIT;
ALTER TRIGGER AFTER_UPDATE_CUSTOMER ENABLE;

ALTER TABLE CUSTOMER ADD CONSTRAINT CONSIGNMENTNOTELEVEL_VALID1 CHECK (CONSIGNMENTNOTELEVEL IN (0,1,2,3,4));

COMMENT ON COLUMN CUSTOMER.CONSIGNMENTNOTELEVEL
IS '0 = No Consignment Note
1 = Consignment Note on Customer level
2 = Consignment Note on Department level
3 = Consignment Note on DeliveryPoint level
4 = Consignment Note on Customer reference level';
