--ABSN-7926

--INVOICELINETYPE TABLE
ALTER TABLE INVOICELINETYPE ADD (ALLOWONMANUALINVOICE VARCHAR2(1) DEFAULT 'Y' NOT NULL CONSTRAINT CHK_INVOICELINETYPE_ALLOWONMANINV CHECK (ALLOWONMANUALINVOICE IN ('Y', 'N')));

UPDATE INVOICELINETYPE SET ALLOWONMANUALINVOICE = 'N' WHERE TYPE IN (13, 14, 17, 18, 29, 31, 33, 34);
COMMIT;