-- ABS-14381

----------------- EMAILSETTING -------------------
COMMENT ON COLUMN EMAILSETTING.DOCUMENTTYPE
  IS '1 = Invoice
2 = Statement
3 = Purchase order
4 = E-service password reminder
5 = Work order via web
6 = Invoice job checklist
7 = Customer
8 = Log Message
9 = Delivery Note / Consignment Note
10 = Stock Count / Order
11 = Wash List
12 = POD (Proof of delivery)
13 = On site soil scan list
14 = Shipment List
15 = Commission Report
16 = Wearer Web Login Credentials
17 = Recalculation Norm Stock Levels
18 = Recalculation Standard Deliveries
19 = Incidental Inventory
20 = Container Usage Report
';
 
ALTER TABLE EMAILSETTING
  DROP CONSTRAINT DOCUMENTTYPEEMAILSETT_VALID;
  
ALTER TABLE EMAILSETTING
  ADD CONSTRAINT DOCUMENTTYPEEMAILSETT_VALID
  CHECK (DOCUMENTTYPE BETWEEN 1 AND 20);