/*502295*/  


alter table PICKLISTLINEORIGIN
  drop constraint BASELINETYPE_VALID;


alter table PICKLISTLINEORIGIN
  add constraint BASELINETYPE_VALID
  check (BASELINETYPE IN (1, 2, 3, 4, 5, 6, 8, 9,10,90));

COMMENT ON COLUMN  PICKLISTLINEORIGIN.BASELINETYPE
  is '1 = Work Order
2 = Work Order For Pool
3 = Web Work Order
4 = Route Assistant
5 = Conversion
6 = Sales Note
8 = Stock Delivery Order (Internal PO)
9 = Direct Stock Delivery Order
10= Mounting Order
90 = PackingNote';

alter table PICKLISTLINEORIGINAS
  add constraint BASELINETYPEAS_VALID
  check (BASELINETYPE IN (1, 2, 3, 4, 5, 6, 8, 9,10,90));

COMMENT ON COLUMN  PICKLISTLINEORIGINAS.BASELINETYPE
  is '1 = Work Order
2 = Work Order For Pool
3 = Web Work Order
4 = Route Assistant
5 = Conversion
6 = Sales Note
8 = Stock Delivery Order (Internal PO)
9 = Direct Stock Delivery Order
10= Mounting Order
90 = PackingNote';