--Order 20010646

ALTER TABLE REASONCODE ADD (DEFAULTREASONFORLABELING VARCHAR2(1) DEFAULT 'N' NOT NULL
				CONSTRAINT YN_ValidationField25 
					CHECK (DEFAULTREASONFORLABELING IN ('Y','N'))
				);

COMMENT ON COLUMN REASONCODE.DEFAULTREASONFORLABELING IS 'Used to see if a reason code will be used 
as a default for registering items that are being subject to labeling.';

ALTER TABLE PRINTQUEUE ADD (REASONCODE_ID NUMBER NULL);

CREATE INDEX XIF11PRINTQUEUE ON PRINTQUEUE
(
	REASONCODE_ID ASC	
)
TABLESPACE INDX;

ALTER TABLE PRINTQUEUE 
ADD CONSTRAINT PRINTQUEUE_REASONCODE FOREIGN KEY (REASONCODE_ID)
	REFERENCES REASONCODE(REASONCODE_ID);