-- ABS-83318 / ABS-100007
---------CONSIGNMENTNOTE------------


ALTER TABLE CONSIGNMENTNOTE ADD (PDFARCHIVED VARCHAR2(1) DEFAULT 'N' NOT NULL
			CONSTRAINT CHK_CONSIGNNOTE_PDF CHECK (PDFARCHIVED IN ('Y','N')));

CREATE  INDEX XIE3CONSIGNMENTNOTE ON CONSIGNMENTNOTE (BUSINESSUNIT_ID ASC, PDFARCHIVED ASC);
