--Order 20011082.70


ALTER TABLE WORKORDER
	ADD (WEBSALESNOTE NUMBER  DEFAULT 0 NOT NULL CONSTRAINT WebSalesNote_valid1 CHECK (WEBSALESNOTE IN (0, 1, 2)));



COMMENT ON COLUMN WORKORDER.WEBSALESNOTE IS 'Status field that indicates whether the current sales note has been imported from a legacy web application and in which application it is about to be paid.
Possible values:
0 = No
1 = Yes, invoice in ABSSolute
2 = Yes, paid in Web application
';


insert into process(process_id,description,active) values ('92','Import WMU Web Sales','Y');

insert into process(process_id,description,active) values ('93','Export WMU Web Sales','Y');
