-- ABS-99428 / ABS-106428
--- WORKORDERLINEEMBLEM ---
ALTER TABLE WORKORDERLINEEMBLEM ADD (STYLECODE NUMBER DEFAULT 0 NOT NULL
					CONSTRAINT CHK_WOLINEEMB_STYLECODE CHECK (STYLECODE IN (0,1,2,3)),
				     CUSTOMERSUPPLIED VARCHAR2(1) DEFAULT 'N' NOT NULL
					CONSTRAINT CHK_WOLINEEMB_CUSTSUPPLIED CHECK (CUSTOMERSUPPLIED IN ('Y','N')));

COMMENT ON COLUMN WORKORDERLINEEMBLEM.STYLECODE IS '0 = Not applicable
1 = Emblem
2 = Direct embroidery
3 = Screen print
Only used for product emblems that have not come from a template';
COMMENT ON COLUMN WORKORDERLINEEMBLEM.CUSTOMERSUPPLIED IS 'Only used for product emblems that have not come from a template';